SA-MP Forums Archive
What is wrong ? - 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: What is wrong ? (/showthread.php?tid=326103)


What is wrong ? - Edvin - 16.03.2012

Hi.

When a player join the server, i want to automaticlly make an anncount.
Here is my code:
Код:
format( Query, sizeof( Query ), "INSERT INTO `Accounts` \
											     VALUES(NULL, '%s', '%s', '%s', '%s', '1', '%d', '%d', '%d', '%s', '%d'", PlayerName( playerid ), GetPlayerIPEx( playerid ), dUser( PlayerName2( playerid ) ).( "password_hash" ), dUser( PlayerName( playerid ) ).( "RegisteredDate" ), FI[ 0 ], FI[ 1 ], FI[ 2 ], dUser( PlayerName( playerid ) ).( "LastOn" ), FI[ 3 ] );
				format( Query, sizeof( Query ), "%s, '%d', '%d', '%d', '%d:%d:%d', '%d', '0', '%d', '%d', '%d', '%d', \
    											     '0', '0', '%d', '%d'", Query, FI[ 4 ], FI[ 5 ], FI[ 6 ], FI[ 7 ], FI[ 8 ], FI[ 9 ], FI[ 10 ], FI[ 11 ], FI[ 12 ], FI[ 13 ], FI[ 14 ], xCoins, FI[ 15 ] );
				format( Query, sizeof( Query ), "%s, '%d', '%d', '%s', '%s', '%s', '0', '0'", Query, FI[ 16 ], FI[ 17 ], dUser( PlayerName( playerid ) ).( "Description1" ), dUser( PlayerName( playerid ) ).( "Description2" ), dUser( PlayerName( playerid ) ).( "Description3" ) );
				db_query( PDB, Query );
What is wrong? It don't insert in the database ... i check it for 3-4 times, and i don't find the problem ...

Re: What is wrong ? - T0pAz - 16.03.2012

Show your mysql log using mysql_debug(1);

Re: What is wrong ? - Edvin - 16.03.2012

That code is not for MySQL , it's SQLite :P