public plugin_cfg()
{
new Query[5012];
new Len;
g_SqlTuple = SQL_MakeDbTuple(SQL_INFO[0],SQL_INFO[1],SQL_INFO[2],SQL_INFO[3]);
Len += formatex(Query[Len], charsmax(Query), "CREATE TABLE IF NOT EXISTS `GlobalOffensive` ")
Len += formatex(Query[Len], charsmax(Query)-Len, "(`Nev` varchar(32) NOT NULL,")
Len += formatex(Query[Len], charsmax(Query)-Len, "`Dollar` int(11) NOT NULL,")
Len += formatex(Query[Len], charsmax(Query)-Len, "`Szint` int(11) NOT NULL,")
Len += formatex(Query[Len], charsmax(Query)-Len, "`Oles` int(11) NOT NULL,")
Len += formatex(Query[Len], charsmax(Query)-Len, "`Kapcsolo` int(11) NOT NULL,")
Len += formatex(Query[Len], charsmax(Query)-Len, "`Nyelv` int(11) NOT NULL,")
for(new i;i < sizeof(skin_names); i++)
Len += formatex(Query[Len], charsmax(Query)-Len, "`Fegyver%d` int(11) NOT NULL,",i)
for(new i;i < sizeof(LadaNevek); i++)
Len += formatex(Query[Len], charsmax(Query)-Len, "`Lada%d` int(11) NOT NULL,",i)
for(new i;i < sizeof(KulcsNevek); i++)
Len += formatex(Query[Len], charsmax(Query)-Len, "`Kulcs%d` int(11) NOT NULL, `id` int(11) NOT NULL AUTO_INCREMENT PRIMARY KEY)",i)
SQL_ThreadQuery(g_SqlTuple, "createTableThread", Query);
}
public createTableThread(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
if(FailState == TQUERY_CONNECT_FAILED)
set_fail_state("[HIBA*] NEM TUDTAM CSATLAKOZNI AZ ADATBAZISHOZ.");
else if(FailState == TQUERY_QUERY_FAILED)
set_fail_state("Query Error");
if(Errcode)
log_amx("[HIBA*] HIBAT DOBTAM: %s",Error);
}
public Load(id)
{
new Query[2048], Data[1], Name[32];
get_user_name(id, Name, 31);
Data[0] = id;
formatex(Query, charsmax(Query), "SELECT * FROM `GlobalOffensive` WHERE Nev = ^"%s^";", Name);
SQL_ThreadQuery(g_SqlTuple, "QuerySelectData", Query, Data, 1);
return PLUGIN_HANDLED;
}
public QuerySelectData(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) {
log_amx("%s", Error);
return;
}
else {
new id = Data[0];
if(SQL_NumRows(Query) > 0) {
SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Dollar"), Dollar[id])
szint[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Szint"))
oles[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Oles"))
Kapcsolo[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Kapcsolo"))
Nyelv[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Nyelv"))
for(new i;i < sizeof(skin_names); i++) {
OsszesSkin[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Fegyver%d"),i)
}
for(new i;i < sizeof(LadaNevek); i++) {
Lada[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Lada%d"),i)
}
for(new i;i < sizeof(KulcsNevek); i++) {
Kulcs[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Kulcs%d"),i)
}
}
else
{
Save(id)
}
}
}
public Save(id) {
new Query[2048], Name[32];
get_user_name(id, Name, 31);
new Len;
Len += format(Query[Len], 2048, "INSERT INTO GlobalOffensive ")
Len += format(Query[Len], 2048-Len,"(Nev) VALUES('%s')", Name)
SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query);
}
public Update(id) {
new Query[2048], Name[32];
get_user_name(id, Name, 31);
new Len;
Len += formatex(Query[Len], charsmax(Query), "UPDATE `GlobalOffensive` ");
Len += formatex(Query[Len], charsmax(Query)-Len, "SET Dollar = ^"%i^",", Dollar[id])
Len += formatex(Query[Len], charsmax(Query)-Len, "Szint = ^"%i^",", szint[id])
Len += formatex(Query[Len], charsmax(Query)-Len, "Oles = ^"%i^",", oles[id])
Len += formatex(Query[Len], charsmax(Query)-Len, "Kapcsolo = ^"%i^",", Kapcsolo[id])
Len += formatex(Query[Len], charsmax(Query)-Len, "Nyelv = ^"%i^",", Nyelv[id])
for(new i;i < sizeof(skin_names); i++) {
Len += formatex(Query[Len], charsmax(Query)-Len, "Fegyver%d = ^"%i^",",i , OsszesSkin[i][id])
}
for(new i;i < sizeof(LadaNevek); i++) {
Len += formatex(Query[Len], charsmax(Query)-Len, "Lada%d = ^"%i^",", i, Lada[i][id])
}
for(new i;i < sizeof(KulcsNevek); i++) {
Len += formatex(Query[Len], charsmax(Query)-Len, "Kulcs%d = ^"%i^"", i, Kulcs[i][id])
}
Len += formatex(Query[Len], charsmax(Query)-Len, "WHERE Nev = ^"%s^";", Name)
SQL_ThreadQuery(g_SqlTuple, "QuerySetData", Query);
}
public QuerySetData(FailState, Handle:Query, Error[], Errcode, Data[], DataSize, Float:Queuetime) {
if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED) {
log_amx("%s", Error);
return;
}
}
public plugin_end()
{
SQL_FreeHandle(g_SqlTuple)
}
public client_putinserver(id) {
Dollar[id] = 0.0
szint[id] = 0
oles[id] = 0
Kapcsolo[id] = 1
Nyelv[id] = 1;
for(new i;i < sizeof(skin_names); i++) {
OsszesSkin[i][id] = 0
}
for(new i;i < sizeof(LadaNevek); i++) {
Lada[i][id] = 0
}
for(new i;i < sizeof(KulcsNevek); i++) {
Kulcs[i][id] = 0
}
if(!is_user_bot(id)) {
Load(id);
}
}
public client_disconnect(id) {
if(!is_user_bot(id)) {
Update(id);
}
}