log_to_file("log.log", szQuery);

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))

        {  

            SQL_ReadResult(Query, 3, g_Email[id], 99)

 

            g_Id[id] = SQL_ReadResult(Query, 0)

 

            Lada[id] = SQL_ReadResult(Query, 5)

            Kaszt[id] = SQL_ReadResult(Query, 6)

            arany[id] = SQL_ReadResult(Query, 7)

            XP[id] = SQL_ReadResult(Query, 8)

            Szint[id] = SQL_ReadResult(Query, 9)

            hflada[id] = SQL_ReadResult(Query, 10)

            Vip[id] = SQL_ReadResult(Query, 11)

            Vipk[id] = SQL_ReadResult(Query, 12)

            VKesztyu[id] = SQL_ReadResult(Query, 13)

            nap[id] = SQL_ReadResult(Query, 14)

            ora[id] = SQL_ReadResult(Query, 15)

            perc[id] = SQL_ReadResult(Query, 16)

            mp[id] = SQL_ReadResult(Query, 17)

            Pontok[id] = SQL_ReadResult(Query, 18)

            Oles[id] = SQL_ReadResult(Query, 19)

            Eladva[id] = SQL_ReadResult(Query, 20)

            XPGy[id] = SQL_ReadResult(Query, 21)

            TKesztyu[id] = SQL_ReadResult(Query, 22)

            knifekill[id] = SQL_ReadResult(Query, 23)

            Kinyitva[id] = SQL_ReadResult(Query, 24)

            HeadShot[id] = SQL_ReadResult(Query, 25)

            kLada[id] = SQL_ReadResult(Query, 26)

            Aldas[id] = SQL_ReadResult(Query, 27)

            Kulcs[id] = SQL_ReadResult(Query, 28)

 

            for(new i = 1; i <= 4; i++)

                tervrajz[id][i] = SQL_ReadResult(Query, 28+i)

 

            for(new i = 1; i <= 119; i++)

                Fegyverek[id][i] = SQL_ReadResult(Query, 32+i)

           

            for(new i = 1; i <= 4; i++)

                Kepesseg[id][i] = SQL_ReadResult(Query, 151+i)

           

            for(new i = 1; i <= 15; i++)

                Kuldetes[id][i] = SQL_ReadResult(Query, 155+i)

           

            for(new i = 1; i <= 8; i++)

                wkill[id][i] = SQL_ReadResult(Query, 170+i)

 

            ColorChat(id, GREEN, "^4[Információ]^1 Üdv^3 %s^1, sikeresen bejelentkeztél!",g_Felhasznalonev[id])

            g_Folyamatban[id] = 0

            g_Bejelentkezve[id] = true

        }

        else

        {

            ColorChat(id, GREEN, "^4[Információ]^1 Hibás ^3Felhasználónév^1 vagy ^3Jelszó^1!")

            g_Folyamatban[id] = 0

            showMenu_RegLog(id)

        }

    }

 

public sql_update_account(id)

{  

    new szQuery[2508], len

   

    new c[191]

    new client_name[33]

    get_user_name(id, client_name, 32)

   

    format(c, 190, "%s", client_name)

   

    replace_all(c, 190, "\", "\\")

 

    len += format(szQuery[len], charsmax(szQuery)-len,"Lada = '%d', ", Lada[id])

   len += format(szQuery[len], charsmax(szQuery)-len,"Kaszt = '%d', ", Kaszt[id])

   len += format(szQuery[len], charsmax(szQuery)-len,"Arany = '%d', ", arany[id])

   len += format(szQuery[len], charsmax(szQuery)-len,"Xp = '%d', ", XP[id])

   len += format(szQuery[len], charsmax(szQuery)-len,"Szint = '%d', ", Szint[id])

   len += format(szQuery[len], charsmax(szQuery)-len,"HfLada = '%d', ", hflada[id])

   len += format(szQuery[len], charsmax(szQuery)-len,"Vip = '%d', ", Vip[id])

   len += format(szQuery[len], charsmax(szQuery)-len,"Vipkup = '%d', ", Vipk[id])

   len += format(szQuery[len], charsmax(szQuery)-len,"Vkesztyu = '%d', ", VKesztyu[id])

   len += format(szQuery[len], charsmax(szQuery)-len,"D = '%d', ", nap[id])

   len += format(szQuery[len], charsmax(szQuery)-len,"H = '%d', ", ora[id])

   len += format(szQuery[len], charsmax(szQuery)-len,"M = '%d', ", perc[id])

   len += format(szQuery[len], charsmax(szQuery)-len,"S = '%d', ", mp[id])

   len += format(szQuery[len], charsmax(szQuery)-len,"Pontok = '%d', ", Pontok[id])

   len += format(szQuery[len], charsmax(szQuery)-len,"Oles = '%d', ", Oles[id])

   len += format(szQuery[len], charsmax(szQuery)-len,"Eladva = '%d', ", Eladva[id])

   len += format(szQuery[len], charsmax(szQuery)-len,"XpGyuru = '%d', ", XPGy[id])

   len += format(szQuery[len], charsmax(szQuery)-len,"TKesztyu = '%d', ", TKesztyu[id])

   len += format(szQuery[len], charsmax(szQuery)-len,"Kesoles = '%d', ", knifekill[id])

   len += format(szQuery[len], charsmax(szQuery)-len,"Kinyitva = '%d', ", Kinyitva[id])

   len += format(szQuery[len], charsmax(szQuery)-len,"Fejloves = '%d', ", HeadShot[id])

   len += format(szQuery[len], charsmax(szQuery)-len,"KuldLada = '%d', ", kLada[id])

   len += format(szQuery[len], charsmax(szQuery)-len,"Aldas = '%d', ", Aldas[id])

   len += format(szQuery[len], charsmax(szQuery)-len,"Kulcs = '%d', ", Kulcs[id])

 

   for(new i = 1; i <= 4; i++) len += format(szQuery[len], charsmax(szQuery)-len,"Tervrajz%d = '%d', ", i, tervrajz[id][i])

   for(new i = 1; i <= 119; i++) len += format(szQuery[len], charsmax(szQuery)-len,"F%d = '%d', ", i, Fegyverek[id][i])

   for(new i = 1; i <= 4; i++) len += format(szQuery[len], charsmax(szQuery)-len,"Kepesseg%d = '%d', ", i, Kepesseg[id][i])

   for(new i = 1; i <= 15; i++) len += format(szQuery[len], charsmax(szQuery)-len,"Kuldetes%d = '%d', ", i, Kuldetes[id][i])

   for(new i = 1; i <= 8; i++) len += format(szQuery[len], charsmax(szQuery)-len,"FOles%d = '%d', ", i, wkill[id][i])

 

    len += format(szQuery[len], charsmax(szQuery)-len,"WHERE Id = '%d'", g_Id[id])