SA-MP Forums Archive
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)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: SQL (/showthread.php?tid=195142)



SQL - Gh0sT_ - 01.12.2010

Quote:

format( qline, 1024, "UPDATE `"TABLENAME"` SET `PinigaiRankose` = '%i', `PinigaiBanke` = '%i', `Patirtis` = '%i', `Ieskomumas` = '%i', `Interior` = '%d', `AdministratoriausLygis` = '%d', `PozicijaX` = '%f', `PozicijaY` = '%f', `PozicijaZ` = 'f'",\
GetPlayerMoneyEx( playerid ), GetPVarInt(playerid, "Banke"), GetPlayerScore( playerid ), GetPlayerWantedLevel( playerid ), GetPlayerInterior( playerid ), GetPVarInt( playerid, "Administratorius" ), pX, pY, pZ, GetPVarInt( playerid, "VairavimoTeises"), GetPVarInt( playerid, "Uzsaldymas"));

What's wrong? Because when i compile pawno, I get nothing. ( no message or same shit, only white screen. When i delete this, works good.. ) And, if there are some big fail, srry, because im a green boy at mysql..


Re: SQL - dice7 - 01.12.2010

You do know that TABLENAME needs to be a name of your table in your db ?


Re: SQL - Gh0sT_ - 01.12.2010

#define TABLENAME "zLENTELE"


Re: SQL - dice7 - 01.12.2010

Remove the \. It will also give you a lot of errors.