Klaida su saugojimu

[Karolis.exe]

Sveiki, taigi iššoko klaida su saugojimu. Kai į serverį jungiuosi su nauju vartotoju - viskas čiki piki, tačiau tik atsijungus ir prisijungus, nebeturiu nieko, atsirandu 0,0,0 kordinatėse kaimeliuose. Viskas su phpmyadmin yra sujungta, vartotoją matau, kiti dalykai irgi kraunasi tačiau paskyros informacijos nesaugo. Pats saugojimas yra padarytas.

 

Į mysql_logą gaunu tokį dalyką :

[13:15:18] [ERROR] cache_get_row_int - invalid datatype

[13:15:20] [ERROR] cache_get_row_int - invalid datatype

[B4SSY!]

Parodyk kaip saugai.

[Karolis.exe]

Parodyk kaip saugai.

 

                    Save player info

                    ----------------

*/

players.savePlayerData(pid) {

    printf("[CPlayer.p]: Player: %s savePlayerData function execute.", GetPlayerNameEx(pid));

    new queryBuff[ 8000  ];

    if( thePlayer.SQL_ID[pid] == 0 && thePlayer.Xp[pid]){

        printf("%s neissaugota, nes blogi duomenys.", GetPlayerNameEx(pid));

        return 1;

    }

    strcat(queryBuff, "UPDATE zaidejai SET ");

    strcat(queryBuff, smallf("SQL_ID = '%i',", thePlayer.SQL_ID[pid]));

    strcat(queryBuff, smallf("Name = '%s',", GetPlayerNameEx(pid)));

    strcat(queryBuff, smallf("Password = '%s',", thePlayer.Password[pid]));

    strcat(queryBuff, smallf("Xp = '%i',", thePlayer.Xp[pid]));

    strcat(queryBuff, smallf("Money = '%i',", thePlayer.Money[pid]));

    strcat(queryBuff, smallf("AdminLvl = '%i',", thePlayer.AdminLvl[pid]));

    strcat(queryBuff, smallf("SpawnX = '%f',", thePlayer.SpawnX[pid]));

    strcat(queryBuff, smallf("SpawnY = '%f',", thePlayer.SpawnY[pid]));

    strcat(queryBuff, smallf("SpawnZ = '%f',", thePlayer.SpawnZ[pid]));

    strcat(queryBuff, smallf("drabuziai = '%i',", thePlayer.drabuziai[pid]));

    if( thePlayer.uniforma[pid] < 0 ) {

        strcat(queryBuff, "uniforma = '-1',");

    } else {

        strcat(queryBuff, smallf("uniforma = '%i',", thePlayer.uniforma[pid]));

    }

    

    if( thePlayer.uniformad[pid] < 0 ) {

        strcat(queryBuff, "uniformad = '-1',");

    } else {

        strcat(queryBuff, smallf("uniformad = '%i',", thePlayer.uniformad[pid]));

    }

    strcat(queryBuff, smallf("health = '%f',", GetPlayerHealthEx(pid)));

    strcat(queryBuff, smallf("armour = '%f',", thePlayer.Armour[pid]));

    strcat(queryBuff, smallf("Wanted = '%i',", thePlayer.Wanted[pid]));

    strcat(queryBuff, smallf("Drunk = '%i',", thePlayer.Drunk[pid]));

    strcat(queryBuff, smallf("Interior = '%i',", thePlayer.Interior[pid]));

    strcat(queryBuff, smallf("passChange = '%i',", thePlayer.passChange[pid]));

    strcat(queryBuff, smallf("Virtual = '%i',", thePlayer.Virtual[pid]));

    strcat(queryBuff, smallf("Vip = '%i',", thePlayer.Vip[pid]));

    strcat(queryBuff, smallf("mute = '%i',", thePlayer.mute[pid]));

    strcat(queryBuff, smallf("timeonline = '%i',", thePlayer.timeonline[pid]));

    strcat(queryBuff, smallf("timetoday = '%i',", thePlayer.timetoday[pid]));

    strcat(queryBuff, smallf("Lytis = '%i',", thePlayer.Lytis[pid]));

    strcat(queryBuff, smallf("jailTime = '%i',", thePlayer.jailTime[pid]));

    strcat(queryBuff, smallf("lastip = '%s',", thePlayer.lastip[pid]));

    strcat(queryBuff, smallf("lastdate = '%s',", thePlayer.lastdate[pid]));

    strcat(queryBuff, smallf("email = '%s',", thePlayer.email[pid]));

    strcat(queryBuff, smallf("direktorius = '%i',", thePlayer.direktorius[pid]));

    strcat(queryBuff, smallf("pavaduotojas = '%i',", thePlayer.pavaduotojas[pid]));

    strcat(queryBuff, smallf("sedejas = '%i',", thePlayer.sedejas[pid]));

    strcat(queryBuff, smallf("isidarbino = '%i',", thePlayer.isidarbino[pid]));

    strcat(queryBuff, smallf("disp = '%i',", thePlayer.disp[pid]));

    strcat(queryBuff, smallf("pd_xp = '%i',", thePlayer.pd_xp[pid]));

    strcat(queryBuff, smallf("md_xp = '%i',", thePlayer.md_xp[pid]));

    strcat(queryBuff, smallf("taxi_xp = '%i',", thePlayer.taxi_xp[pid]));

    strcat(queryBuff, smallf("mech_xp = '%i',", thePlayer.mech_xp[pid]));

    strcat(queryBuff, smallf("fur_xp = '%i',", thePlayer.fur_xp[pid]));

    strcat(queryBuff, smallf("banke = '%i',", thePlayer.banke[pid]));

    strcat(queryBuff, smallf("bankopin = '%i',", thePlayer.bankopin[pid]));

    if( thePlayer.car2[pid] < 0 ) {

        strcat(queryBuff, "car2 = '-1',");

    } else {

        strcat(queryBuff, smallf("car2 = '%i',", thePlayer.car2[pid]));

    }

    if( thePlayer.car1[pid] < 0 ) {

        strcat(queryBuff, "car1 = '-1',");

    } else {

        strcat(queryBuff, smallf("car1 = '%i',", thePlayer.car1[pid]));

    }

    strcat(queryBuff, smallf("car1 = '%i',", thePlayer.car1[pid]));

    strcat(queryBuff, smallf("car2 = '%i',", thePlayer.car2[pid]));

    strcat(queryBuff, smallf("alga = '%i',", thePlayer.alga[pid]));

    strcat(queryBuff, smallf("viplaikas = '%i',", thePlayer.viplaikas[pid]));

    strcat(queryBuff, smallf("telefonas = '%i',", thePlayer.telefonas[pid]));

    strcat(queryBuff, smallf("navigacija = '%i',", thePlayer.navigacija[pid]));

    strcat(queryBuff, smallf("saskaita = '%i',", thePlayer.saskaita[pid]));

    strcat(queryBuff, smallf("kreditai = '%i',", thePlayer.kreditai[pid]));

    strcat(queryBuff, smallf("teorija = '%i',", thePlayer.teorija[pid]));

    strcat(queryBuff, smallf("teises = '%i' WHERE Name = '%s'", thePlayer.teises[pid], GetPlayerNameEx(pid)));

    //print("first query");

    mysql_function_query(DbHandle, queryBuff, false, "SendQuery", "" );

    // ammo and guns

    format(queryBuff, sizeof queryBuff, "");

    strcat(queryBuff, "UPDATE zaidejai SET ");

    for(new tmpas=0; tmpas<12; tmpas++) { 

        GetPlayerWeaponData(playerid,tmpas,playerWeapons[0][tmpas][pid],playerWeapons[1][tmpas][pid]);

        strcat(queryBuff, smallf("Ginklas%i = '%i',", tmpas, playerWeapons[0][tmpas][pid]));

        strcat(queryBuff, smallf("Ammo%i = '%i',", tmpas, playerWeapons[1][tmpas][pid]));

    }

 

    // other

    strcat(queryBuff, smallf("aro_xp = '%i',", thePlayer.aro_xp[pid]));

    strcat(queryBuff, smallf("priziuretojas = '%i',", thePlayer.priziuretojas[pid]));

    strcat(queryBuff, smallf("gvadas = '%i',", thePlayer.gvadas[pid]));

    strcat(queryBuff, smallf("glicenzija = '%i',", thePlayer.glicenzija[pid]));

    strcat(queryBuff, smallf("reputacija = '%i',", thePlayer.reputacija[pid]));

    strcat(queryBuff, smallf("adminlaikas = '%i',", thePlayer.adminlaikas[pid]));

    strcat(queryBuff, smallf("pasiekimas1 = '%i',", thePlayer.pasiekimas1[pid]));

    strcat(queryBuff, smallf("pasiekimas2 = '%i',", thePlayer.pasiekimas2[pid]));

    strcat(queryBuff, smallf("pasiekimas3 = '%i',", thePlayer.pasiekimas3[pid]));

    strcat(queryBuff, smallf("pasiekimas4 = '%i',", thePlayer.pasiekimas4[pid]));

    strcat(queryBuff, smallf("pasiekimas5 = '%i',", thePlayer.pasiekimas5[pid]));

    strcat(queryBuff, smallf("pasiekimas6 = '%i',", thePlayer.pasiekimas6[pid]));

    strcat(queryBuff, smallf("pasiekimas7 = '%i',", thePlayer.pasiekimas7[pid]));

    strcat(queryBuff, smallf("pasiekimas8 = '%i',", thePlayer.pasiekimas8[pid]));

    strcat(queryBuff, smallf("pasiekimas9 = '%i',", thePlayer.pasiekimas9[pid]));

    strcat(queryBuff, smallf("pasiekimas10 = '%i',", thePlayer.pasiekimas10[pid]));

    strcat(queryBuff, smallf("pasiekimas11 = '%i',", thePlayer.pasiekimas11[pid]));

    strcat(queryBuff, smallf("pasiekimas12 = '%i',", thePlayer.pasiekimas12[pid]));

    strcat(queryBuff, smallf("pasiekimas13 = '%i',", thePlayer.pasiekimas13[pid]));

    strcat(queryBuff, smallf("pasiekimas14 = '%i',", thePlayer.pasiekimas14[pid]));

    strcat(queryBuff, smallf("pasiekimas15 = '%i',", thePlayer.pasiekimas15[pid]));

    strcat(queryBuff, smallf("siltnamis = '%i',", thePlayer.siltnamis[pid]));

    strcat(queryBuff, smallf("kanapiuseklos = '%i',", thePlayer.kanapiuseklos[pid]));

    strcat(queryBuff, smallf("weed = '%i',", thePlayer.weed[pid]));

    strcat(queryBuff, smallf("meskere = '%i',", thePlayer.meskere[pid]));

    strcat(queryBuff, smallf("masalas = '%i',", thePlayer.masalas[pid]));

    strcat(queryBuff, smallf("zuvys = '%i',", thePlayer.zuvys[pid]));

    strcat(queryBuff, smallf("zuvukiekis = '%i',", thePlayer.zuvukiekis[pid]));

    strcat(queryBuff, smallf("velykuevent = '%i',", thePlayer.velykuevent[pid]));

    strcat(queryBuff, smallf("eventkint1 = '%i',", thePlayer.eventkint1[pid]));

    strcat(queryBuff, smallf("eventkint2 = '%i',", thePlayer.eventkint2[pid]));

    strcat(queryBuff, smallf("eventkint3 = '%i',", thePlayer.eventkint3[pid]));

    strcat(queryBuff, smallf("eventkint4 = '%i',", thePlayer.eventkint4[pid]));

    strcat(queryBuff, smallf("eventkint5 = '%i',", thePlayer.eventkint5[pid]));

    strcat(queryBuff, smallf("eventkint6 = '%i',", thePlayer.eventkint6[pid]));

    strcat(queryBuff, smallf("eventkint7 = '%i',", thePlayer.eventkint7[pid]));

    strcat(queryBuff, smallf("eventkint8 = '%i',", thePlayer.eventkint8[pid]));

    strcat(queryBuff, smallf("eventkint9 = '%i',", thePlayer.eventkint9[pid]));

    strcat(queryBuff, smallf("eventkint10 = '%i',", thePlayer.eventkint10[pid]));

    strcat(queryBuff, smallf("pasiekimas18 = '%i',", thePlayer.pasiekimas18[pid]));

    strcat(queryBuff, smallf("pasiekimas16 = '%i',", thePlayer.pasiekimas16[pid]));

    strcat(queryBuff, smallf("pasiekimas17 = '%i',", thePlayer.pasiekimas17[pid]));

    if( thePlayer.vverslas[pid] < 0 ) {

        strcat(queryBuff, "vverslas = '-1',");

    } else {

        strcat(queryBuff, smallf("vverslas = '%i',", thePlayer.vverslas[pid]));

    }

    if( thePlayer.vpelnas[pid] < 0 ) {

        strcat(queryBuff, "vpelnas = '-1',");

    } else {

        strcat(queryBuff, smallf("vpelnas = '%i',", thePlayer.vpelnas[pid]));

    }

 

    

    strcat(queryBuff, smallf("vpelnasmin = '%i',", thePlayer.vpelnasmin[pid]));

    strcat(queryBuff, smallf("viela = '%i',", thePlayer.viela[pid]));

    strcat(queryBuff, smallf("drkisp = '%i',", thePlayer.drkisp[pid]));

    strcat(queryBuff, smallf("telbusena = '%i',", thePlayer.telbusena[pid]));

    strcat(queryBuff, smallf("agurkai = '%i',", thePlayer.agurkai[pid]));

    strcat(queryBuff, smallf("pomidorai = '%i',", thePlayer.pomidorai[pid]));

    strcat(queryBuff, smallf("agurkuseklos = '%i',", thePlayer.agurkuseklos[pid]));

    strcat(queryBuff, smallf("pomidoruseklos = '%i',", thePlayer.pomidoruseklos[pid]));

    strcat(queryBuff, smallf("statymas = '%i',", thePlayer.statymas[pid]));

    strcat(queryBuff, smallf("statymosuma = '%i',", thePlayer.statymosuma[pid]));

    strcat(queryBuff, smallf("dylerio_xp = '%i',", thePlayer.dylerio_xp[pid]));

    strcat(queryBuff, smallf("pasiekimas19 = '%i',", thePlayer.pasiekimas19[pid]));

    strcat(queryBuff, smallf("pasiekimas20 = '%i',", thePlayer.pasiekimas20[pid]));

    strcat(queryBuff, smallf("pasiekimas21 = '%i',", thePlayer.pasiekimas21[pid]));

    strcat(queryBuff, smallf("drangas = '%i',", thePlayer.drangas[pid]));

    strcat(queryBuff, smallf("cigaretes = '%i',", thePlayer.cigaretes[pid]));

    strcat(queryBuff, smallf("ziebtuvelis = '%i',", thePlayer.ziebtuvelis[pid]));

    strcat(queryBuff, smallf("zvejoxp = '%i',", thePlayer.zvejoxp[pid]));

    strcat(queryBuff, smallf("kvietimai = '%i',", thePlayer.kvietimai[pid]));

    strcat(queryBuff, smallf("kvietimaitoday = '%i',", thePlayer.kvietimaitoday[pid]));

    strcat(queryBuff, smallf("salmas = '%i',", thePlayer.salmas[pid]));

    strcat(queryBuff, smallf("bakelis = '%i',", thePlayer.bakelis[pid]));

    strcat(queryBuff, smallf("bkuras = '%f' WHERE Name = '%s'", thePlayer.bkuras[pid], GetPlayerNameEx(pid)));

    //print("second query");

    mysql_function_query(DbHandle, queryBuff, false, "SendQuery", "" );

    format(queryBuff, sizeof queryBuff, "");

    //strcat(queryBuff, smallf("imigruotas = '%i',", thePlayer.imigruotas[pid]));

    strcat(queryBuff, "UPDATE zaidejai SET ");

    strcat(queryBuff, smallf("padejo = '%i',", thePlayer.padejo[pid]));

    strcat(queryBuff, smallf("rukymas = '%i',", thePlayer.rukymas[pid]));

    strcat(queryBuff, smallf("gerimas = '%i',", thePlayer.gerimas[pid]));

    strcat(queryBuff, smallf("pasiekimas22 = '%i',", thePlayer.pasiekimas22[pid]));

    strcat(queryBuff, smallf("pasiekimas23 = '%i',", thePlayer.pasiekimas23[pid]));

    strcat(queryBuff, smallf("pasiekimas24 = '%i',", thePlayer.pasiekimas24[pid]));

    strcat(queryBuff, smallf("pasiekimas25 = '%i',", thePlayer.pasiekimas25[pid]));

    strcat(queryBuff, smallf("pasiekimas26 = '%i',", thePlayer.pasiekimas26[pid]));

    if( thePlayer.namas[pid] < 0 ) {

        strcat(queryBuff, "namas = '-1',");

    } else {

        strcat(queryBuff, smallf("namas = '%i',", thePlayer.namas[pid]));

    }

    if( thePlayer.pverslas[pid] < 0 ) {

        strcat(queryBuff, "pverslas = '-1',");

    } else {

        strcat(queryBuff, smallf("pverslas = '%i',", thePlayer.pverslas[pid]));

    }

    strcat(queryBuff, smallf("moderatorius = '%i',", thePlayer.moderatorius[pid]));

    strcat(queryBuff, smallf("moderatoriustime = '%i',", thePlayer.moderatoriustime[pid]));

    strcat(queryBuff, smallf("bankChange = '%i',", thePlayer.bankChange[pid]));

    strcat(queryBuff, smallf("stocks = '%i',", thePlayer.stocks[pid]));

    strcat(queryBuff, smallf("kauke = '%i',", thePlayer.kauke[pid]));

    strcat(queryBuff, smallf("vipisp = '%i', ", thePlayer.vipisp[pid]));

    strcat(queryBuff, smallf("eventfontake = '%i', ", thePlayer.eventfontake[pid]));

    strcat(queryBuff, smallf("apsiaustas = '%i', ", thePlayer.apsiaustas[pid]));

    strcat(queryBuff, smallf("apsiaustaslaikas = '%i' ", thePlayer.apsiaustaslaikas[pid]));

    // where statement

    strcat(queryBuff, smallf("WHERE Name = '%s'", GetPlayerNameEx(pid)));

    // debug

    //print(queryBuff);

    //print("last query");

    mysql_function_query(DbHandle, queryBuff, false, "SendQuery", "" );

 

 

    // NEXT

 

    format(queryBuff, sizeof queryBuff, "");

    //strcat(queryBuff, smallf("imigruotas = '%i',", thePlayer.imigruotas[pid]));

    strcat(queryBuff, "UPDATE zaidejai SET ");

    strcat(queryBuff, smallf("phouse = '%i', ", thePlayer.phouse[pid]));

    strcat(queryBuff, smallf("kepure = '%i',", thePlayer.kepure[pid]));

    strcat(queryBuff, smallf("settingsAdmin = '%i',", thePlayer.settingsAdmin[pid]));

    strcat(queryBuff, smallf("settingsVip = '%i',", thePlayer.settingsVip[pid]));

    strcat(queryBuff, smallf("settingsKick = '%i', ", thePlayer.settingsKick[pid]));

    strcat(queryBuff, smallf("kdovana = '%i', ", thePlayer.kdovana[pid]));

    strcat(queryBuff, smallf("sraScore = '%i', ", thePlayer.sraScore[pid]));

    strcat(queryBuff, smallf("emigruotas = '%i', ", thePlayer.emigruotas[pid]));

    strcat(queryBuff, smallf("adminisp = '%i', ", thePlayer.adminisp[pid]));

    strcat(queryBuff, smallf("atimtiGun = '%i', ", thePlayer.atimtiGun[pid]));

    strcat(queryBuff, smallf("atimtiNark = '%i', ", thePlayer.atimtiNark[pid]));

    strcat(queryBuff, smallf("atimtosTeises = '%i', ", thePlayer.atimtosTeises[pid]));

    strcat(queryBuff, smallf("darbas = '%i',", thePlayer.darbas[pid]));

    strcat(queryBuff, smallf("car3 = '%i',", thePlayer.car3[pid]));

    strcat(queryBuff, smallf("pasas = '%i',", thePlayer.pasas[pid]));

    strcat(queryBuff, smallf("gauja = '%i',", thePlayer.gauja[pid]));

    strcat(queryBuff, smallf("kauliukas = '%i',", thePlayer.kauliukas[pid]));

    strcat(queryBuff, smallf("radistas = '%i',", thePlayer.radistas[pid]));

    strcat(queryBuff, smallf("valiuta = '%f',", thePlayer.valiuta[pid]));

    strcat(queryBuff, smallf("adraudimas = '%i',", thePlayer.adraudimas[pid]));

    strcat(queryBuff, smallf("vdraudimas = '%f',", thePlayer.vdraudimas[pid]));

 

    strcat(queryBuff, smallf("pasiekimas27 = '%i',", thePlayer.pasiekimas27[pid]));

    strcat(queryBuff, smallf("pasiekimas28 = '%i',", thePlayer.pasiekimas28[pid]));

    strcat(queryBuff, smallf("gtgaliojimas = '%i', ", thePlayer.gtgaliojimas[pid]));

    strcat(queryBuff, smallf("garazas = '%i', ", thePlayer.garazas[pid]));

    strcat(queryBuff, smallf("laimetavarzybu = '%i', ", thePlayer.laimetavarzybu[pid]));

    strcat(queryBuff, smallf("klubas = '%i', ", thePlayer.klubas[pid]));

    strcat(queryBuff, smallf("gpav = '%i', ", thePlayer.gpav[pid]));

    strcat(queryBuff, smallf("klubovadas = '%i', ", thePlayer.klubovadas[pid]));

    strcat(queryBuff, smallf("klubopav = '%i', ", thePlayer.klubopav[pid]));

    strcat(queryBuff, smallf("klausimas = '%s', ", thePlayer.klausimas[pid]));

    strcat(queryBuff, smallf("atsakymas = '%s', ", thePlayer.atsakymas[pid]));

    strcat(queryBuff, smallf("klausimoapsauga = '%i', ", thePlayer.klausimoapsauga[pid]));

    strcat(queryBuff, smallf("visoRida = '%f',", thePlayer.visoRida[pid]));

    strcat(queryBuff, smallf("freeVip = '%i', ", thePlayer.freeVip[pid]));

    strcat(queryBuff, smallf("kroviniai = '%i', ", thePlayer.kroviniai[pid]));

    strcat(queryBuff, smallf("kroviniai_today = '%i', ", thePlayer.kroviniai_today[pid]));

    strcat(queryBuff, smallf("kontraktas = '%i' ", thePlayer.kontraktas[pid]));

 

 

    // where statement

    strcat(queryBuff, smallf("WHERE Name = '%s'", GetPlayerNameEx(pid)));

    // debug

    //print(queryBuff);

    //print("last query");

    mysql_function_query(DbHandle, queryBuff, false, "SendQuery", "" );

 

    //next

 

    format(queryBuff, sizeof queryBuff, "");

    //strcat(queryBuff, smallf("imigruotas = '%i',", thePlayer.imigruotas[pid]));

    strcat(queryBuff, "UPDATE zaidejai SET ");

    

    strcat(queryBuff, smallf("fteises = '%i', ", thePlayer.fteises[pid]));

    strcat(queryBuff, smallf("mteises = '%i', ", thePlayer.mteises[pid]));

    strcat(queryBuff, smallf("lteises = '%i' ", thePlayer.lteises[pid]));

 

 

    // where statement

    strcat(queryBuff, smallf("WHERE Name = '%s'", GetPlayerNameEx(pid)));

    // debug

    //print(queryBuff);

    //print("last query");

    mysql_function_query(DbHandle, queryBuff, false, "SendQuery", "" );

    return(true);

}

[B4SSY!]

Pasidares LoadPlayerData?