[Voldemort]

Can someone with fresh eye take a look on this, where I have made mistake that they wont saving into DB, because first 3 queries saves as need.

pawn Код:

strcat(query4,"UPDATE Pinfo SET");
    format(string,sizeof(string), " HackSkill = '%d',",Pinfo[playerid][HackSkill]); strcat(query4,string);
    format(string,sizeof(string), " Mod = '%d',",Pinfo[playerid][Mod]); strcat(query4,string);
    format(string,sizeof(string), " CrashX = '%0.2f',",Pinfo[playerid][CrashX]); strcat(query4,string);
    format(string,sizeof(string), " CrashY = '%0.2f',",Pinfo[playerid][CrashY]); strcat(query4,string);
    format(string,sizeof(string), " CrashZ = '%0.2f',",Pinfo[playerid][CrashZ]); strcat(query4,string);
    format(string,sizeof(string), " CrashVW = '%d',",Pinfo[playerid][CrashVW]); strcat(query4,string);
    format(string,sizeof(string), " CrashInt = '%d',",Pinfo[playerid][CrashInt]); strcat(query4,string);
    format(string,sizeof(string), " CrashDuty = '%d',",Pinfo[playerid][CrashDuty]); strcat(query4,string);
    format(string,sizeof(string), " EnterID = '%d',",Pinfo[playerid][EnterID]); strcat(query4,string);
    format(string,sizeof(string), " Crashed = '%d',",Pinfo[playerid][Crashed]); strcat(query4,string);
    format(string,sizeof(string), " PlayerSes = '%d',",Pinfo[playerid][PlayerSes]); strcat(query4,string);
    format(string,sizeof(string), " CrashDis = '%d',",Pinfo[playerid][CrashDis]); strcat(query4,string);
    format(string,sizeof(string), " DutyArmour = '%d',",Pinfo[playerid][DutyArmour]); strcat(query4,string);
    format(string,sizeof(string), " Gold = '%d',",Pinfo[playerid][Gold]); strcat(query4,string);
    format(string,sizeof(string), " FlighTime = '%d',",Pinfo[playerid][FlighTime]); strcat(query4,string);
    format(string,sizeof(string), " GPowder = '%d',",Pinfo[playerid][GPowder]); strcat(query4,string);
    format(string,sizeof(string), " Metal = '%d',",Pinfo[playerid][Metal]); strcat(query4,string);
    format(string,sizeof(string), " GReady = '%d',",Pinfo[playerid][GReady]); strcat(query4,string);
    format(string,sizeof(string), " SerVer = '%d',",Pinfo[playerid][SerVer]); strcat(query4,string);
    format(string,sizeof(string), " LastIP = '%s',",Pinfo[playerid][LastIP]); strcat(query4,string);
    format(string,sizeof(string), " Priest = '%d',",Pinfo[playerid][Priest]); strcat(query4,string);
    format(string,sizeof(string), " Married = '%d',",Pinfo[playerid][Married]); strcat(query4,string);
    format(string,sizeof(string), " MarHouse = '%d',",Pinfo[playerid][MarHouse]); strcat(query4,string);
    format(string,sizeof(string), " RPSkill = '%d',",Pinfo[playerid][RPSkill]); strcat(query4,string);
    format(string,sizeof(string), " Mask = '%d',",Pinfo[playerid][Mask]); strcat(query4,string);
    format(string,sizeof(string), " PetrolCan = '%d',",Pinfo[playerid][PetrolCan]); strcat(query4,string);
    format(string,sizeof(string), " Tut = '%d',",Pinfo[playerid][Tut]); strcat(query4,string);
    format(string,sizeof(string), " TempReg = '%d',",Pinfo[playerid][TempReg]); strcat(query4,string);
    format(string,sizeof(string), " Weed = '%d',",Pinfo[playerid][Weed]); strcat(query4,string);*/
    format(string,sizeof(string), " Seeds = '%d' WHERE PlayerName = '%s'",Pinfo[playerid][Seeds],username); strcat(query4,string);
    mysql_query(query4);
    
    strcat(query5,"UPDATE Pinfo SET");
    format(string,sizeof(string), " MarReady = '%d',",Pinfo[playerid][MarReady]); strcat(query5,string);
    format(string,sizeof(string), " MarAmount = '%d',",Pinfo[playerid][MarAmount]); strcat(query5,string);
    format(string,sizeof(string), " Paper = '%d',",Pinfo[playerid][Paper]); strcat(query5,string);
    format(string,sizeof(string), " Lighter = '%d',",Pinfo[playerid][Lighter]); strcat(query5,string);
    format(string,sizeof(string), " Cigar = '%d',",Pinfo[playerid][Cigar]); strcat(query5,string);
    format(string,sizeof(string), " AdminCode = '%s',",Pinfo[playerid][AdminCode]); strcat(query5,string);
    format(string,sizeof(string), " Helmet = '%d',",Pinfo[playerid][Helm]); strcat(query5,string);
    format(string,sizeof(string), " PlayerHealth = '%.2f',",Pinfo[playerid][PHealth]); strcat(query5,string);
    format(string,sizeof(string), " TimeInJob = '%d',",Pinfo[playerid][TimeInJob]); strcat(query5,string);
    format(string,sizeof(string), " TmpFaction = '%d',",Pinfo[playerid][TmpFaction]); strcat(query5,string);
    format(string,sizeof(string), " Resign = '%d',",Pinfo[playerid][Resign]); strcat(query5,string);
    format(string,sizeof(string), " Helper = '%d',",Pinfo[playerid][Helper]); strcat(query5,string);
    format(string,sizeof(string), " M3UList1 = '%s',",Pinfo[playerid][M3UList1]); strcat(query5,string);
    format(string,sizeof(string), " Title1 = '%s',",Pinfo[playerid][Title1]); strcat(query5,string);
    format(string,sizeof(string), " M3UList2 = '%s',",Pinfo[playerid][M3UList2]); strcat(query5,string);
    format(string,sizeof(string), " Title2 = '%s',",Pinfo[playerid][Title2]); strcat(query5,string);
    format(string,sizeof(string), " M3UList3 = '%s',",Pinfo[playerid][M3UList3]); strcat(query5,string);
    format(string,sizeof(string), " Title3 = '%s',",Pinfo[playerid][Title3]); strcat(query5,string);
    format(string,sizeof(string), " M3UList4 = '%s',",Pinfo[playerid][M3UList4]); strcat(query5,string);
    format(string,sizeof(string), " Title4 = '%s',",Pinfo[playerid][Title4]); strcat(query5,string);
    format(string,sizeof(string), " M3UList5 = '%s',",Pinfo[playerid][M3UList5]); strcat(query5,string);
    format(string,sizeof(string), " Title5 = '%s',",Pinfo[playerid][Title5]); strcat(query5,string);
    format(string,sizeof(string), " SkinProLap = '%d',",Pinfo[playerid][SkinProLaps]); strcat(query5,string);
    format(string,sizeof(string), " SkinVictim = '%d',",Pinfo[playerid][SkinVictim]); strcat(query5,string);
    format(string,sizeof(string), " SkinSub = '%d',",Pinfo[playerid][SkinSub]); strcat(query5,string);
    format(string,sizeof(string), " SkinZip = '%d',",Pinfo[playerid][SkinZip]); strcat(query5,string);
    format(string,sizeof(string), " SkinBin = '%d',",Pinfo[playerid][SkinBin]); strcat(query5,string);
    format(string,sizeof(string), " SkinDid = '%d' WHERE PlayerName = '%s'",Pinfo[playerid][SkinDid],username); strcat(query5,string);
    mysql_query(query5);

Also can someone tell some way, how to load 174 values from sql, in easy way, sscanf fail, same as strtok

[armyoftwo]

Have you checked MySQL logs?
Why you don't want to use sscanf? There are other ways and they are slower than sscanf.

[gamer931215]

You know that only the values of strings need '' quotemarks right ?
Ints/floats and stuff dont need 'value'

I dont know if it makes a difference though, since we dont got the complete script we cannot test it :P

[dice7]

Quote:

Originally Posted by gamer931215 You know that only the values of strings need '' quotemarks right ? Ints/floats and stuff dont need 'value' I dont know if it makes a difference though, since we dont got the complete script we cannot test it :P

No they don't.


Is your query string big enough ?