SQlite stats save - 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: SQlite stats save (/showthread.php?tid=553056)
+- 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: SQlite stats save (/showthread.php?tid=553056)
SQlite stats save - DkrX - 27.12.2014
No work S:, Do not save anything S:
pawn Код:
public OnPlayerDisconnect(playerid, reason)
{
new
Query[ 200 ], // We need to create such a query so we can format it.
year,month,day
;
getdate(year,month,day);
if(pInfo[playerid][USER_LOGGED_IN] == true)
{
format(Query, sizeof(Query), "UPDATE `users` SET Money = '%d', Score = '%d', EXP = '%d', Kills = '%d', Deaths = '%d', Wanted = '%d', JailTime = '%d', Job = '%d', Fstyle = '%d', PlaceHit = '%d', C4 = '%d', tie = '%d', BC = '%d', BP = '%d', Cutie = '%d', Dia = '%02d', Mes = '%02d', Ano = '%d', IP = '%s' WHERE `Username` = '%s' COLLATE NOCASE",
GetPlayerMonez(playerid),
GetPlayerScore(playerid),
pInfo[playerid][EXP],
pInfo[playerid][Kills],
pInfo[playerid][Deaths],
pInfo[playerid][Wanted],
pInfo[playerid][JailTime],
pInfo[playerid][Job],
pInfo[playerid][FStyle],
pInfo[playerid][Placehit],
pInfo[playerid][C4],
pInfo[playerid][Tie],
pInfo[playerid][BreakC],
pInfo[playerid][BreakP],
pInfo[playerid][Cutie],
day,
month,
year,
pInfo[playerid][Uip],
DB_Escape(GetPlayerName(playerid))); // Gather the name of the player then escape it.
// querying the formatted Query
db_query(Database, Query);
// We're going to reset this variable to false.
pInfo[playerid][USER_LOGGED_IN] = false;
}
return 1;
}
Re: SQlite stats save - Ahmad45123 - 27.12.2014
Change db_query(Database, Query); to :
pawn Код:
if(db_query(Database, Query))
{
print("Yes");
}
else
{
print("No");
}
Respuesta: SQlite stats save - DkrX - 27.12.2014
printed no D:
Re: SQlite stats save - Pottus - 27.12.2014
Get SQLite Improved and enable error checking.
https://sampforum.blast.hk/showthread.php?tid=303682
Put this at top of your script
pawn Код:
#define DB_QUERY_ERRORS true
#include <sqlitei>
https://github.com/Zeex/amx_assembly
The problem right now however is your query size is 200 when the string length is much greater than that.
Re: Respuesta: SQlite stats save - Ahmad45123 - 27.12.2014
Quote:
|
Originally Posted by DkrX
 printed no D:
|
Make sure everything is right..
or just do what Pottus said.
Respuesta: Re: SQlite stats save - DkrX - 27.12.2014
Quote:
|
Originally Posted by Pottus
Get SQLite Improved and enable error checking.
https://sampforum.blast.hk/showthread.php?tid=303682 Put this at top of your script pawn Код:
https://github.com/Zeex/amx_assembly The problem right now however is your query size is 200 when the string length is much greater than that. |
Re: SQlite stats save - Pottus - 27.12.2014
Yes you need the library then you will be good to go any query errors will show up for you in Windows the real nice thing about is it will tell you exactly where the problem.
What you do is download this link https://github.com/Zeex/amx_assembly/archive/master.zip extract that to your include folder make sure you extract the folder amx_assembly-master as well all the files should be in there.
Now simply rename amx_assembly-master to amx_assembly and you should have error checking enabled.
Re: Respuesta: Re: SQlite stats save - Ahmad45123 - 27.12.2014
Quote:
|
Originally Posted by DkrX
top? fatal error 111: user error: amx_assembly is required for DB_QUERY_ERRORS. Get it here: github.com/zeex/amx_assembly
|
Just do what is written...
Download amx_assembly from github.com/zeex/amx_assembly
Respuesta: Re: Respuesta: Re: SQlite stats save - DkrX - 27.12.2014
Quote:
|
Originally Posted by Pottus
Yes you need the library then you will be good to go any query errors will show up for you in Windows the real nice thing about is it will tell you exactly where the problem.
|
Quote:
|
Originally Posted by Ahmad45123
Cant you read ?
Just do what is written... Download amx_assembly from github.com/zeex/amx_assembly |
SQLitei Error: (db_query) near " ": syntax error
Re: Respuesta: Re: Respuesta: Re: SQlite stats save - Ahmad45123 - 27.12.2014
Quote:
|
Originally Posted by DkrX
sorry sorry, ready!
SQLitei Error: (db_query) near " ": syntax error |