What is wrong ?
#1

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 ...
Reply
#2

Show your mysql log using mysql_debug(1);
Reply
#3

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


Forum Jump:


Users browsing this thread: 1 Guest(s)