hlmod.hu

public sql_account_check(id)
{
new szQuery[2048]
new len = 0

new a[191]

format(a, 190, "%s", g_UserName[id])

replace_all(a, 190, "\", "\\")
replace_all(a, 190, "'", "\'")

len += format(szQuery[len], 2048, "SELECT * FROM exodus_go_2017 ")
len += format(szQuery[len], 2048-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_RegistOrLogin[id] == 1)
{
if(iRowsFound > 0)
{
ColorChat(id, GREEN, "^4%s^1 Ezzel a Felhasználónévvel már Regisztráltak!", PR)
g_InProgress[id] = 0
showMenu_RegLog(id)
}
else sql_account_create(id)
}
else if(g_RegistOrLogin[id] == 2)
{
if(iRowsFound == 0)
{
ColorChat(id, GREEN, "^4%s^1 Hibás ^3Felhasználónév^1 vagy ^3Jelszó^1!", PR)
g_InProgress[id] = 0
showMenu_RegLog(id)
}
else sql_account_load(id)
}
}
public sql_account_create(id)
{
new szQuery[2048]
new len = 0

new a[191], b[191], c[191]

format(a, 190, "%s", g_UserName[id])
format(b, 190, "%s", g_Password[id])
format(c, 190, "%s", g_UserMail[id])

replace_all(a, 190, "\", "\\")
replace_all(a, 190, "'", "\'")
replace_all(b, 190, "\", "\\")
replace_all(b, 190, "'", "\'")
replace_all(c, 190, "\", "\\")
replace_all(c, 190, "'", "\'")

len += format(szQuery[len], 2048, "INSERT INTO exodus_go_2017 ")
len += format(szQuery[len], 2048-len,"(Felhasznalonev,Jelszo,Email) VALUES('%s','%s','%s')", a, b, c)

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;

new szName[32];
get_user_name(id, szName, charsmax(szName));
ColorChat(0, GREEN, "^4%s^1 Sikeresen regisztráltál a szerverre kedves:^4 %s^1 érezd jól magad.!", C_PR, szName)
if(g_UserMail[id][0] == EOS) ColorChat(id, GREEN, "^4%s^1 Sikeresen regisztráltál! Felhasználónév:^3 %s^1 | Jelszó:^3 %s", C_PR, g_UserName[id], g_Password[id])
else ColorChat(id, GREEN, "^4%s^1 Sikeresen regisztráltál! Felhasználónév:^3 %s^1 | Jelszó:^3 %s^1 | E-Mail:^3 %s", C_PR, g_UserName[id], g_Password[id], g_UserMail[id])
g_InProgress[id] = 0;
g_WeapSwitch[id] = 0;
g_RegistOrLogin[id] = 2;
showMenu_RegLog(id)
return
}
public showMenu_RegLog(id)
{
new szMenu[121]
format(szMenu, charsmax(szMenu), "%s \r- \dRegisztráció és Bejelentkezés", PR)
new menu = menu_create(szMenu, "menu_reglog");

formatex(szMenu, charsmax(szMenu), "\yFelhasználónév:\w %s^n", g_UserName[id][0] == EOS ? "Nincs megadva \r*" : g_UserName[id])
menu_additem(menu, szMenu, "0", 0);
formatex(szMenu, charsmax(szMenu), "\yJelszó:\w %s%s", g_Password[id][0] == EOS ? "Nincs megadva \r*" : LenStars[strlen(g_Password[id])], g_RegistOrLogin[id] == 2 ? "^n" : "")
menu_additem(menu, szMenu, "1", 0);
if(g_RegistOrLogin[id] == 1 ){
formatex(szMenu, charsmax(szMenu), "\yJelszó újra:\w %s^n", g_Password1[id][0] == EOS ? "Nincs megadva \r*" : LenStars[strlen(g_Password1[id])])
menu_additem(menu, szMenu, "2", 0);
formatex(szMenu, charsmax(szMenu), "\yE-Mail:\w %s^n^n", g_UserMail[id][0] == EOS ? "Nincs megadva" : g_UserMail[id])
menu_additem(menu, szMenu, "3", 0);
}

if(g_RegistOrLogin[id] == 1 ) menu_additem(menu, "\rRegisztráció", "4", 0);
else menu_additem(menu, "\rBejelentkezés", "4", 0);

menu_display(id, menu, 0);
return PLUGIN_HANDLED;
}
public menu_reglog(id, menu, item)
{
if(item == MENU_EXIT)
{
menu_destroy(menu);
return PLUGIN_CONTINUE;
}

new data[9], szName[64];
new access, callback;
menu_item_getinfo(menu, item, access, data,charsmax(data), szName,charsmax(szName), callback);
new key = str_to_num(data);

switch(key)
{
case 0:
{
client_cmd(id, "messagemode FELHASZNALONEV")
showMenu_RegLog(id)
}
case 1:
{
client_cmd(id, "messagemode JELSZAVAD")
showMenu_RegLog(id)
}
case 2:
{
client_cmd(id, "messagemode JELSZAVAD_UJRA")
showMenu_RegLog(id)
}
case 3:
{
client_cmd(id, "messagemode EMAIL")
showMenu_RegLog(id)
}
case 4: cmdRegisztracioBejelentkezes(id)
}
return PLUGIN_HANDLED;
}
public plugin_cfg()
{
g_SqlTuple = SQL_MakeDbTuple(SQLINFO[0], SQLINFO[1], SQLINFO[2], SQLINFO[3]);
}
public sql_account_load(id)
{
new szQuery[2048]
new len = 0

new a[191]

format(a, 190, "%s", g_UserName[id])

replace_all(a, 190, "\", "\\")
replace_all(a, 190, "'", "\'")

len += format(szQuery[len], 2048, "SELECT * FROM exodus_go_2017 ")
len += format(szQuery[len], 2048-len,"WHERE Felhasznalonev = '%s'", a)

new szData[2];
szData[0] = id;
szData[1] = get_user_userid(id);

SQL_ThreadQuery(g_SqlTuple,"QuerySelectData", szQuery, szData, 2)
}
public QuerySelectData(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_Password[id], szSqlPassword))
{
SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Email"), g_UserMail[id]);
g_Id[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Id"));
g_Dollar[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Dollar"));
g_Time[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Ido"));
g_MVP[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "MVP"));
g_Rang[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Rang"));
g_Kills[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Olesek"));
g_Key[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Kulcs"));
g_WeapSwitch[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Skinek"));
g_Hud[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Hud"));
g_Vip[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Vip"));
g_VipTime[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "VipTime"));
g_Premium[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "Premium"));
g_Quest[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "QuestH"));
g_QuestMVP[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "QuestMVP"));
g_QuestKills[0][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "QuestNeed"));
g_QuestKills[1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "QuestHave"));
g_QuestWeapon[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "QuestWeap"));
g_QuestHead[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "QuestHead"));
g_Erem[id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "ErdemErem"));
g_Jutalom[0][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "JutLada"));
g_Jutalom[1][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "JutKulcs"));
g_Jutalom[2][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "JutPont"));
g_Jutalom[3][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, "JutDoll"));

for(new i;i < d_FGY; i++)
{
new String[64];
formatex(String, charsmax(String), "F%d", i);
g_Weapon[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String));
}

for(new i;i < STAWP; i++)
{
new String[64];
formatex(String, charsmax(String), "A%d", i);
g_sTAWP[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String));
}

for(new i;i < STKALA; i++)
{
new String[64];
formatex(String, charsmax(String), "U%d", i);
g_sTAK[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String));
}

for(new i;i < STCOLT; i++)
{
new String[64];
formatex(String, charsmax(String), "M%d", i);
g_sTM4[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String));
}

for(new i;i < STDEAGLE; i++)
{
new String[64];
formatex(String, charsmax(String), "G%d", i);
g_sTDG[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String));
}

for(new i;i < STUSP; i++)
{
new String[64];
formatex(String, charsmax(String), "S%d", i);
g_sTUSP[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String));
}
for(new i;i < STKNIFE; i++)
{
new String[64];
formatex(String, charsmax(String), "K%d", i);
g_sTKNIFE[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String));
}

for(new i;i < d_LMAX; i++)
{
new String[64];
formatex(String, charsmax(String), "L%d", i);
g_Case[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String));
}

for(new i;i < SKINS; i++)
{
new String[64];
formatex(String, charsmax(String), "Skin%d", i);
Skin[i][id] = SQL_ReadResult(Query, SQL_FieldNameToNum(Query, String));
}
new szName[32];
get_user_name(id, szName, charsmax(szName));

ColorChat(0, GREEN, "^4%s^3 %s^1, sikeresen bejelentkeztél, köszöntelek a szerveren.",C_PR, g_UserName[id])
if(g_VipTime[id] > 1) g_Vip[id] = 1
if(get_user_flags(id) & ADMIN) ColorChat(0, GREEN, "%s ^1Egy ^4Admin ^1bejelentkezett:^3 %s", C_PR, szName);
if(get_user_flags(id) & ADMIN_USER && g_Vip[id] == 1) ColorChat(0, GREEN, "%s ^1Egy ^4VIP ^1bejelentkezett:^3 %s", C_PR, szName);
g_InProgress[id] = 0
g_LoggedIn[id] = true
openMainMenu(id)
}
else
{
ColorChat(id, GREEN, "^4%s^1 Hibás ^3Felhasználónév^1 vagy ^3Jelszó^1!", PR)
g_InProgress[id] = 0
showMenu_RegLog(id)
}
}
}
public QuerySetData(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 client_putinserver(id)
{
g_LoggedIn[id] = false;
}
public client_disconnect(id)
{
g_InProgress[id] = 0

if(g_LoggedIn[id])
{
sql_update_account(id, 0);
sql_update_account(id, 1);
sql_update_account(id, 1);
}

if(Kirakva[0][id] == 1) g_Market[0]--;
if(Kirakva[1][id] == 1) g_Market[1]--;

for(new i;i < d_LMAX; i++) g_Case[i][id] = 0;
for(new i;i < d_FGY; i++) g_Weapon[i][id] = 0;
for(new i;i < STAWP; i++) g_sTAWP[i][id] = 0;
for(new i;i < STKALA; i++) g_sTAK[i][id] = 0;
for(new i;i < STCOLT; i++) g_sTM4[i][id] = 0;
for(new i;i < STDEAGLE; i++) g_sTDG[i][id] = 0;
for(new i;i < STUSP; i++) g_sTUSP[i][id] = 0;
for(new i;i < STKNIFE; i++) g_sTKNIFE[i][id] = 0;
for(new i;i < SKINS; i++) Skin[i][id] = 0;
for(new i;i < 2; i++) g_QuestKills[i][id] = 0;
for(new i;i < 4; i++) g_Jutalom[i][id] = 0;

g_Dollar[id] = 0;
g_Key[id] = 0;
g_Kills[id] = 0;
g_Rang[id] = 0;
g_MVP[id] = 0;
g_Premium[id] = 0;
g_Time[id] = 0;
g_Vip[id] = 0;
g_VipTime[id] = 0;
g_WeapSwitch[id] = 0;
g_Quest[id] = 0;
g_QuestWeapon[id] = 0;
g_QuestMVP[id] = 0;
g_QuestHead[id] = 0;
g_Erem[id] = 0;

g_LoggedIn[id] = false

g_UserName[id][0] = EOS
g_Password[id][0] = EOS
g_Password1[id][0] = EOS
g_UserMail[id][0] = EOS
g_Id[id] = 0
}
public sql_update_account(const id, const part)
{
static sQuery[4096];
new iLen;
new sName[32];

get_user_name(id, sName, charsmax(sName));

replace_all(sName, charsmax(sName), "\", "\\")
replace_all(sName, charsmax(sName), "'", "\'")

iLen += formatex(sQuery[iLen], charsmax(sQuery), "UPDATE exodus_go_2017 SET ");

if ( part == 0 )
{
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen,"Olesek = '%i', ", g_Kills[id]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen,"Rang = '%i', ", g_Rang[id]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen,"Dollar = '%i', ", g_Dollar[id]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen,"Kulcs = '%i', ", g_Key[id]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen,"Skinek = '%i', ", g_WeapSwitch[id]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen,"Hud = '%i', ", g_Hud[id]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen,"Premium = '%i', ", g_Premium[id]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen,"MVP = '%i', ", g_MVP[id]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen,"Vip = '%i', ", g_Vip[id]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen,"Vip = '%i', ", g_Vip[id]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen,"VipTime = '%i', ", g_VipTime[id]-get_user_time(id));
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen,"Ido = '%i', ", g_Time[id]+get_user_time(id));
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen,"Ido = '%i', ", g_Time[id]+get_user_time(id));
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen,"QuestH = '%i', ", g_Quest[id]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen,"QuestMVP = '%i', ", g_QuestMVP[id]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen,"QuestNeed = '%i', ", g_QuestKills[0][id]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen,"QuestHave = '%i', ", g_QuestKills[1][id]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen,"QuestWeap = '%i', ", g_QuestWeapon[id]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen,"QuestHead = '%i', ", g_QuestHead[id]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen,"ErdemErem = '%i', ", g_Erem[id]);

for(new i;i < d_FGY; i++) iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen,"F%d = '%i', ", i, g_Weapon[i][id]);
for(new i;i < STAWP; i++) iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen,"A%d = '%i', ", i, g_sTAWP[i][id]);
for(new i;i < STKALA; i++) iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen,"U%d = '%i', ", i, g_sTAK[i][id]);
for(new i;i < STCOLT; i++) iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen,"M%d = '%i', ", i, g_sTM4[i][id]);
}
if ( part == 1 )
{
for(new i;i < STDEAGLE; i++) iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen,"G%d = '%i', ", i, g_sTDG[i][id]);
for(new i;i < STUSP; i++) iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen,"S%d = '%i', ", i, g_sTUSP[i][id]);
for(new i;i < STKNIFE; i++) iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen,"K%d = '%i', ", i, g_sTKNIFE[i][id]);
for(new i;i < d_LMAX; i++) iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen,"L%d = '%i', ", i, g_Case[i][id]);
for(new i;i < SKINS; i++) iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen,"Skin%d = '%i', ", i, Skin[i][id]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen,"JutLada = '%i', ", g_Jutalom[0][id]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen,"JutKulcs = '%i', ", g_Jutalom[1][id]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen,"JutPont = '%i', ", g_Jutalom[2][id]);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen,"JutDoll = '%i', ", g_Jutalom[3][id]);
}

iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen,"Jatekosnev = '%s' ", sName);
iLen += formatex(sQuery[iLen], charsmax(sQuery)-iLen,"WHERE Id = '%i'", g_Id[id]);

SQL_ThreadQuery(g_SqlTuple, "QuerySetData", sQuery)
}