SA-MP Forums Archive
My sql / Scripting wrong?[Help][SQL] - 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 / Scripting wrong?[Help][SQL] (/showthread.php?tid=570451)


My sql / Scripting wrong?[Help][SQL] - SequenceCuz - 10.04.2015

hey this line

PHP код:
stock SaveHouse(id)
{
    if(!Iter_Contains(Houses, id)) return 0;
    mysql_format(gSQLHandle, query, sizeof(query), "UPDATE houses SET HouseName='%s', HouseOwner='%s', HousePassword='%s', HouseLock=%d, HouseMoney=%d, LastEntered=%d WHERE ID=%d",
    HouseData[id][Name], HouseData[id][Owner], HouseData[id][Password], HouseData[id][LockMode], HouseData[id][SafeMoney], HouseData[id][LastEntered], id);
    mysql_tquery(gSQLHandle, query, "", "");
    HouseData[id][Save] = false;
    return 1;
} 
Why it not save the house system? can someone explain

iff you guys wanna get more information about the code tell me

if someone can help help me

AW: My sql / Scripting wrong?[Help][SQL] - Mencent - 10.04.2015

Hello!

What is printing?
PHP код:
stock SaveHouse(id)
{
    if(!Iter_Contains(Houses, id)) return 0;
    mysql_format(gSQLHandle, query, sizeof(query), "UPDATE houses SET HouseName='%s', HouseOwner='%s', HousePassword='%s', HouseLock=%d, HouseMoney=%d, LastEntered=%d WHERE ID=%d",
    HouseData[id][Name], HouseData[id][Owner], HouseData[id][Password], HouseData[id][LockMode], HouseData[id][SafeMoney], HouseData[id][LastEntered], id);
    print(query);
    mysql_tquery(gSQLHandle, query, "", "");
    HouseData[id][Save] = false;
    return 1;
} 
Mencent

Re: My sql / Scripting wrong?[Help][SQL] - SequenceCuz - 10.04.2015

you want me to put the print there?

so if it success it will proceed in the log?

ok i'll try

AW: My sql / Scripting wrong?[Help][SQL] - Mencent - 10.04.2015

Ok, do this!

Mencent

Re: My sql / Scripting wrong?[Help][SQL] - SequenceCuz - 10.04.2015

WTF .

I dont understand why it save now!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!

i just put the print on it <<< this doesn't effect the code ikr

AW: My sql / Scripting wrong?[Help][SQL] - Mencent - 10.04.2015

So it works now?

Mencent

Re: My sql / Scripting wrong?[Help][SQL] - SequenceCuz - 10.04.2015

yes, but i don't understand why it work

I'll try to delete the print code and see if the print affect my code waittt....

AW: My sql / Scripting wrong?[Help][SQL] - Mencent - 10.04.2015

Ok, this is weird

Re: My sql / Scripting wrong?[Help][SQL] - SequenceCuz - 10.04.2015

yesss weird ,, the print make the code save

cuz when i delete the print it doesn't save anymore

i want someone to explain this

btw thank you

Re: My sql / Scripting wrong?[Help][SQL] - SequenceCuz - 10.04.2015

https://sampforum.blast.hk/showthread.php?tid=570454