Sziasztok! Olyan Problémám lenne hogy amikor regisztrálni akarok a szerveremre akkor ezt dobja ki és egy mezõt se hoz létre. Itt a hibakód amit a konzolba ír:
[17:04:54] errorid: 1136 | error: Column count doesn\'t match value count at row 1 | resultid: -1 | extraid: -1 | callback: NULL | query: INSERT INTO `users` VALUES(1, \'Jack449\', \'127.0.0.1\', \'FCA4E535B1421AA9B4673C15FEDBD7F761684E22EA43F8ACF184991E073E26D9552B6ABE8306BA28B8E5F7F4897BBAFC68F1A07D06961F9500227BF88717F0DC\', \'2014-9-6\', \'1\', \'0\', \'0\', \'0\', \'2014-9-6\', \'500\', \'0\', \'0\', \'0\', \'00:00:00\', \'0\', \'0\', \'0\', \'0\', \'1\', \'0\', \'0\', \'0\', \'0\', \'empty\', \'empty\', \'empty\', \'0\', \'0\', \'0\', \'None\', \'0\', \' \', 0, \'0\', \'0\', \'0\', \'0\', \'0\', \'0\', \'0\', \'0\', \'0\', \'0\', \'0\', \'0\', \'0\', \'0\', \'0\', \'0\', \'0\', \'00:00\', \'0\', \'00:00\', \'0\', \'0xFFFFFFFF\', 0, 0, 0, 0, 0.0, 0.0, 0.0, 0.0, 0, 0)
Itt a source-code:
case RegDialog:
{
if ( !response )
return ShowPlayerDialog( playerid, RegDialog, DIALOG_STYLE_PASSWORD, \"\"W\"Register {FF0000}Failed !\", \"{FF0000}ERROR:\\n\\n\"W\"You must obligatory register your account!\", \"Register\", \"\" );
new
rPassword[ 25 ]
;
if ( sscanf( inputtext, \"s[25]\", rPassword ) )
return ShowPlayerDialog( playerid, RegDialog, DIALOG_STYLE_PASSWORD, \"\"W\"Register {FF0000}Failed !\", \"\"W\"You must type a password if you want to register!\", \"Register\", \"\" );
if ( strlen( rPassword ) < 6 || strlen( rPassword ) > 25 )
return ShowPlayerDialog( playerid, RegDialog, DIALOG_STYLE_PASSWORD, \"\"W\"Register {FF0000}Failed !\", \"\"W\"The password must be between 6 and 24 characters!\", \"Register\", \"\" );
gsString[ 255 ] = EOS;
new
Buf[ 255 ]
;
WP_Hash( Buf, 255, rPassword );
new
liYear,
liMonth,
liDay
;
getdate( liYear, liMonth, liDay );
//registertables
format( gsString, sizeof( gsString ), \"INSERT INTO `users` \\
VALUES(1, \'%s\', \'%s\', \'%s\', \'%d-%d-%d\', \'1\', \'0\', \'0\', \'0\', \'%d-%d-%d\', \'500\', \\
\'0\', \'0\', \'0\', \'00:00:00\', \'0\', \'0\', \'0\', \'0\', \'1\', \'0\', \'0\', \\
\'0\', \'0\', \'empty\', \'empty\', \'empty\', \'0\', \'0\', \'0\', \'None\', \'0\', \' \', 0\", PlayerName( playerid ), GetPlayerIPEx( playerid ), Buf, liYear, liMonth, liDay, liYear, liMonth, liDay );
format( gsString, sizeof( gsString ), \"%s, \'0\', \'0\', \'0\', \'0\', \'0\', \'0\', \'0\', \'0\', \'0\', \'0\', \'0\', \'0\', \'0\', \\
\'0\', \'0\', \'0\', \'0\', \'00:00\', \'0\', \'00:00\', \'0\', \'0xFFFFFFFF\', \\
0, 0, 0, 0, 0.0, 0.0, 0.0, 0.0, 0, 0)\", gsString );
mysql_query( gsString );
PlayerInfo[ playerid ][ AccID ] = mysql_insert_id( );
format( gsString, sizeof(gsString), \"\"R\"[sE] {%06x}%s(%i) {3BBD44}has registered, making the server have a total of {87CEFA}%d {3BBD44}players registered.\", GetPlayerColor( playerid ) >>> 8, PlayerName( playerid ), playerid, PlayerInfo[ playerid ][ AccID ] );
SendClientMessageToAll( ~1, gsString );
[mod]Kitettem helyetted a megfelelõ code tageket.[/mod]