public sql_tuple_create()
{
g_SqlTuple = SQL_MakeDbTuple(s_HOSZT, s_FELHASZNALO, s_JELSZO, s_ADATBAZIS)
sql_active_check()
sql_load_server()
}
public sql_table_create_thread(FailState,Handle:Query,Error[],Errcode,Data[],DataSize)
{
if(FailState == TQUERY_CONNECT_FAILED)
return set_fail_state("[ *HIBA* ] NEM LEHET KAPCSOLODNI AZ ADATBAZISHOZ!")
else if(FailState == TQUERY_QUERY_FAILED)
return set_fail_state("[ *HIBA* ] A LEKERDEZES MEGSZAKADT!")
if(Errcode)
return log_amx("[ *HIBA* ] PROBLEMA A LEKERDEZESNEL! ( %s )",Error)
return PLUGIN_CONTINUE
}
public sql_active_check()
{
new szQuery[2048]
new len = 0
len += format(szQuery[len], 2048, "UPDATE rwt_sql_register_new_s5 SET ")
len += format(szQuery[len], 2048-len,"Aktivitas = '0' ")
len += format(szQuery[len], 2048-len,"WHERE Aktivitas = '%d'", SERVER_ID)
SQL_ThreadQuery(g_SqlTuple,"sql_active_check_thread", szQuery)
}
public sql_active_check_thread(FailState,Handle:Query,Error[],Errcode,Data[],DataSize)
{
if(FailState == TQUERY_CONNECT_FAILED)
return set_fail_state("[ *HIBA* ] NEM LEHET KAPCSOLODNI AZ ADATBAZISHOZ!")
else if(FailState == TQUERY_QUERY_FAILED)
return set_fail_state("[ *HIBA* ] A LEKERDEZES MEGSZAKADT!")
if(Errcode)
return log_amx("[ *HIBA* ] PROBLEMA A LEKERDEZESNEL! ( %s )",Error)
return PLUGIN_CONTINUE
}
public sql_account_check(id)
{
new szQuery[2908]
new len = 0
new a[191]
format(a, 190, "%s", g_Felhasznalonev[id])
replace_all(a, 190, "\", "\\")
replace_all(a, 190, "'", "\'")
len += format(szQuery[len], 2908, "SELECT * FROM rwt_sql_register_new_s5 ")
len += format(szQuery[len], 2908-len,"WHERE Felhasznalonev = '%s'", a)
new szData[2];
szData[0] = id;
szData[1] = get_user_userid(id);
SQL_ThreadQuery(g_SqlTuple,"sql_account_check_thread", szQuery, szData, 2)
}
public sql_account_check_thread(FailState,Handle:Query,Error[],Errcode,szData[],DataSize)
{
if(FailState == TQUERY_CONNECT_FAILED)
{
set_fail_state("[ *HIBA* ] NEM LEHET KAPCSOLODNI AZ ADATBAZISHOZ!")
return
}
else if(FailState == TQUERY_QUERY_FAILED)
{
set_fail_state("[ *HIBA* ] A LEKERDEZES MEGSZAKADT!")
return
}
if(Errcode)
{
log_amx("[ *HIBA* ] PROBLEMA A LEKERDEZESNEL! ( %s )",Error)
return
}
new id = szData[0];
if (szData[1] != get_user_userid(id))
return;
new iRowsFound = SQL_NumRows(Query)
if(g_RegisztracioVagyBejelentkezes[id] == 1)
{
if(iRowsFound > 0)
{
client_printcolor(id, SREGMENU[31][Nyelv[id]])
g_Folyamatban[id] = 0
showMenu_RegLog(id)
}
else sql_account_create(id)
}
else if(g_RegisztracioVagyBejelentkezes[id] == 2)
{
if(iRowsFound == 0)
{
client_printcolor(id, SREGMENU[32][Nyelv[id]])
g_Folyamatban[id] = 0
showMenu_RegLog(id)
}
else sql_account_load(id)
}
}
public sql_account_create(id)
{
new szQuery[2548]
new len = 0
new a[191], b[191]
format(a, 190, "%s", g_Felhasznalonev[id])
format(b, 190, "%s", g_Jelszo[id])
replace_all(a, 190, "\", "\\")
replace_all(a, 190, "'", "\'")
replace_all(b, 190, "\", "\\")
replace_all(b, 190, "'", "\'")
len += format(szQuery[len], 2548, "INSERT INTO rwt_sql_register_new_s5 ")
len += format(szQuery[len], 2548-len,"(Felhasznalonev,Jelszo,Skin) VALUES('%s','%s','1')", a, b)
new szData[2];
szData[0] = id;
szData[1] = get_user_userid(id);
SQL_ThreadQuery(g_SqlTuple,"sql_account_create_thread", szQuery, szData, 2)
}
public sql_account_create_thread(FailState,Handle:Query,Error[],Errcode,szData[],DataSize)
{
if(FailState == TQUERY_CONNECT_FAILED)
{
set_fail_state("[ *HIBA* ] NEM LEHET KAPCSOLODNI AZ ADATBAZISHOZ!")
return
}
else if(FailState == TQUERY_QUERY_FAILED)
{
set_fail_state("[ *HIBA* ] A LEKERDEZES MEGSZAKADT!")
return
}
if(Errcode)
{
log_amx("[ *HIBA* ] PROBLEMA A LEKERDEZESNEL! ( %s )",Error)
return
}
new id = szData[0];
if (szData[1] != get_user_userid(id))
return;
client_printcolor(id, SREGMENU[33][Nyelv[id]])
client_printcolor(id, SREGMENU[34][Nyelv[id]], g_Felhasznalonev[id], g_Jelszo[id])
g_Folyamatban[id] = 0
g_RegisztracioVagyBejelentkezes[id] = 2
Nyelv[id] = 0
showMenu_RegLog(id)
return
}
public sql_account_load(id)
{
new szQuery[2548]
new len = 0
new a[191]
format(a, 190, "%s", g_Felhasznalonev[id])
replace_all(a, 190, "\", "\\")
replace_all(a, 190, "'", "\'")
len += format(szQuery[len], 2548, "SELECT * FROM rwt_sql_register_new_s5 ")
len += format(szQuery[len], 2548-len,"WHERE Felhasznalonev = '%s'", a)
new szData[2];
szData[0] = id;
szData[1] = get_user_userid(id);
SQL_ThreadQuery(g_SqlTuple,"sql_account_load_thread", szQuery, szData, 2)
}
public sql_account_load_thread(FailState,Handle:Query,Error[],Errcode,szData[],DataSize)
{
if(FailState == TQUERY_CONNECT_FAILED || FailState == TQUERY_QUERY_FAILED)
{
log_amx("%s", Error)
return
}
else
{
new id = szData[0];
if (szData[1] != get_user_userid(id))
return ;
new szSqlPassword[100]
SQL_ReadResult(Query, 2, szSqlPassword, 99)
if(equal(g_Jelszo[id], szSqlPassword))
{
g_Aktivitas[id] = SQL_ReadResult(Query, 5)
if (g_Aktivitas[id] > 0)
{
client_printcolor(id, SREGMENU[35][Nyelv[id]])
showMenu_RegLog(id)
return;
}
new VipTX, Vip[256];
SQL_ReadResult(Query, 4, g_Email[id], 255)
SQL_ReadResult(Query, 7, VipTX, 255)
g_Id[id] = SQL_ReadResult(Query, 0)
Skin[id] = SQL_ReadResult(Query, 11)
Oles[id] = SQL_ReadResult(Query, 6)
Rang[id] = SQL_ReadResult(Query, 10)
Dollar[id] = float(SQL_ReadResult(Query, 8))/100
Nyelv[id] = SQL_ReadResult(Query, 13)
Korvegi[id] = SQL_ReadResult(Query, 14)
Masodpercek[id] = SQL_ReadResult(Query, 9)
for(new i=0; i <= 5; i++)
{
Kulcs[id][i] = SQL_ReadResult(Query, 14+i)
}
for(new i=0; i <= 9; i++)
{
Lada[id][i] = SQL_ReadResult(Query, 14+i)
}
for(new i=0; i <= 19; i++)
{
Kesek[id][i] = SQL_ReadResult(Query, 24+i)
}
for(new i=0; i <= 135; i++)
{
Fegyverek[id][i] = SQL_ReadResult(Query, 44+i)
}
format(Vip, 255, "%s", VipTX);
replace_all(Vip, 255, "#", " ")
new Text2[2][32]; parse(Vip, Text2[0], 31, Text2[1], 31);
g_VipRang[id] = str_to_num(Text2[0]);
g_VipDatum[id] = str_to_num(Text2[1]);
g_Aktivitas[id] = SERVER_ID
//acces_creater(id)
sql_update_account(id)
client_printcolor(id, SREGMENU[36][Nyelv[id]], g_Felhasznalonev[id])
g_Folyamatban[id] = 0
g_Bejelentkezve[id] = true
//AdminBelepes(id)
//FoMenu(id)
}
else
{
client_printcolor(id, SREGMENU[37][Nyelv[id]])
g_Folyamatban[id] = 0
showMenu_RegLog(id)
}
}
}
public sql_load_server()
{
new szQuery[2048]
new len = 0
len += format(szQuery[len], 2048, "SELECT * FROM rwt_sql_register_new_s5_s ")
len += format(szQuery[len], 2048-len,"WHERE Server = '%d'", SERVER_ID)
SQL_ThreadQuery(g_SqlTuple,"sql_load_server_thread", szQuery)
}
public sql_load_server_thread(FailState,Handle:Query,Error[],Errcode,szData[],DataSize)
{
if(FailState == TQUERY_CONNECT_FAILED)
return set_fail_state("[ *HIBA* ] NEM LEHET KAPCSOLODNI AZ ADATBAZISHOZ!")
else if(FailState == TQUERY_QUERY_FAILED)
return set_fail_state("[ *HIBA* ] A LEKERDEZES MEGSZAKADT!")
if(Errcode)
return log_amx("[ *HIBA* ] PROBLEMA A LEKERDEZESNEL! ( %s )",Error)
for(new i=0; i <= 19; i++)
{
OsszesKes[i] = SQL_ReadResult(Query, 0+i)
}
for(new i=0; i <= 135; i++)
{
OsszesFegyver[i] = SQL_ReadResult(Query, 20+i)
}
return PLUGIN_CONTINUE
}
public sql_update_account(id)
{
static szQuery[2808]
new len = 0
new b[191], c[191]
new client_name[33]
get_user_name(id, client_name, 32)
format(b, 190, "%s", g_Jelszo[id])
format(c, 190, "%s", client_name)
replace_all(b, 190, "\", "\\")
replace_all(b, 190, "'", "\'")
replace_all(c, 190, "\", "\\")
replace_all(c, 190, "'", "\'")
len += format(szQuery[len], 2808, "UPDATE rwt_sql_register_new_s5 SET ")
len += format(szQuery[len], 2808-len,"Jelszo = '%s', ", b)
len += format(szQuery[len], 2808-len,"Jatekosnev = '%s', ", c)
len += format(szQuery[len],2808-len,"Email = '%s', ", g_Email[id])
len += format(szQuery[len], 2808-len,"Skin = '%d', ", Skin[id])
len += format(szQuery[len], 2808-len,"Oles = '%d', ", Oles[id])
len += format(szQuery[len], 2808-len,"Rang = '%d', ", Rang[id])
len += format(szQuery[len], 2808-len,"Dollar = '%d', ", floatround(Dollar[id]*100))
len += format(szQuery[len], 2808-len,"Vip = '%d#%d', ", g_VipRang[id], g_VipDatum[id])
len += format(szQuery[len], 2808-len,"Nyelv = '%d', ", Nyelv[id])
len += format(szQuery[len], 2808-len,"Korvegi = '%d', ", Korvegi[id])
len += format(szQuery[len], 2808-len,"Masodpercek = '%d', ", Masodpercek[id]+get_user_time(id))
for(new i=0; i <= 5; i++)
{
len += format(szQuery[len], 2808-len,"Kulcs%d = '%d', ", i, Kulcs[id][i])
}
for(new i=0; i <= 9; i++)
{
len += format(szQuery[len], 2808-len,"Lada%d = '%d', ", i, Lada[id][i])
}
for(new i=0; i <= 19; i++)
{
len += format(szQuery[len], 2808-len,"Kes%d = '%d', ", i, Kesek[id][i])
}
for(new i=0; i <= 135; i++)
{
len += format(szQuery[len], 2808-len,"Wpn%d = '%d', ", i, Fegyverek[id][i])
}
len += format(szQuery[len], 2808-len,"Aktivitas = '%d' ", g_Aktivitas[id])
len += format(szQuery[len], 2808-len,"WHERE Id = '%d'", g_Id[id])
SQL_ThreadQuery(g_SqlTuple,"sql_update_account_thread", szQuery)
}
public sql_update_server()
{
new szQuery[2548]
new len = 0
len += format(szQuery[len], 2548, "UPDATE rwt_sql_register_new_s5_s SET ")
for(new i=0; i <= 19; i++)
{
len += format(szQuery[len], 2548-len,"Kes%d = '%d', ", i, OsszesKes[i])
}
for(new i=0; i <= 134; i++)
{
len += format(szQuery[len], 2548-len,"Wpn%d = '%d', ", i, OsszesFegyver[i])
}
len += format(szQuery[len], 2548-len,"Wpn135 = '%d' ", OsszesFegyver[135])
len += format(szQuery[len], 2548-len,"WHERE Server = '%d'", SERVER_ID)
SQL_ThreadQuery(g_SqlTuple,"sql_update_servere_thread", szQuery)
}
public sql_update_servere_thread(FailState,Handle:Query,Error[],Errcode,Data[],DataSize)
{
if(FailState == TQUERY_CONNECT_FAILED)
return set_fail_state("[ *HIBA* ] NEM LEHET KAPCSOLODNI AZ ADATBAZISHOZ!")
else if(FailState == TQUERY_QUERY_FAILED)
return set_fail_state("[ *HIBA* ] A LEKERDEZES MEGSZAKADT!")
if(Errcode)
return log_amx("[ *HIBA* ] PROBLEMA A LEKERDEZESNEL! ( %s )",Error)
return PLUGIN_CONTINUE
}
public sql_update_account_thread(FailState,Handle:Query,Error[],Errcode,Data[],DataSize)
{
if(FailState == TQUERY_CONNECT_FAILED)
return set_fail_state("[ *HIBA* ] NEM LEHET KAPCSOLODNI AZ ADATBAZISHOZ!")
else if(FailState == TQUERY_QUERY_FAILED)
return set_fail_state("[ *HIBA* ] A LEKERDEZES MEGSZAKADT!")
if(Errcode)
return log_amx("[ *HIBA* ] PROBLEMA A LEKERDEZESNEL! ( %s )",Error)
return PLUGIN_CONTINUE
}