My sql saving problem? - Printable Version

My sql saving problem? - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+--- Thread: My sql saving problem? (/showthread.php?tid=569488)

My sql saving problem? still not solve - SequenceCuz - 31.03.2015

still not save into sql why

PHP код:



    format(query, sizeof(query), "UPDATE `user_accounts` SET `Hungry`=%i,\

    `Thirsty`=%i \

    `Energy`=%i WHERE `UserID` = %i",

        i[pHungry], i[pThirsty], i[pEnergy],

        i[pUserID]);

    mysql_function_query(gSQLHandle, query, false, "SaveUserAccount", "ii", playerid, 3);

Re: My sql saving problem? - SequenceCuz - 31.03.2015

bumping not saved

Re: My sql saving problem? - JeaSon - 31.03.2015

as you forgot a comma near "`Thirsty`=%i \"
try this and also post mysql logs

PHP код:



 format(query, sizeof(query), "UPDATE `user_accounts` SET `Hungry`=%i,\ 

    `Thirsty`=%i, \ 

    `Energy`=%i WHERE `UserID` = %i", 

        i[pHungry], i[pThirsty], i[pEnergy], 

        i[pUserID]); 

    mysql_function_query(gSQLHandle, query, false, "SaveUserAccount", "ii", playerid, 3);

Re: My sql saving problem? - SequenceCuz - 31.03.2015

Quote:

Originally Posted by Namer

as you forgot a comma near "`Thirsty`=%i \"
try this and also post mysql logs

PHP код:



 format(query, sizeof(query), "UPDATE `user_accounts` SET `Hungry`=%i,\ 

    `Thirsty`=%i, \ 

    `Energy`=%i WHERE `UserID` = %i", 

        i[pHungry], i[pThirsty], i[pEnergy], 

        i[pUserID]); 

    mysql_function_query(gSQLHandle, query, false, "SaveUserAccount", "ii", playerid, 3);

hahahhh that my small mistake but a big problemmmm

thank you very much man +REPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPPP P