21.06.2015, 23:17
i m mfind this errors in server_logs
Pleaz how to Fix it
Register Dialog script:
Pleaz help
PHP код:
[01:07:52] errorid: 1136 | error: Column count doesn't match value count at row 1 | resultid: -1 | extraid: -1 | callback: NULL | query: INSERT INTO `Accounts` (`Key`,`Name`,`IP`,`Password`,`RegisterDate`,`LoggedIn`,`Level`,`Vip`,`rVip`,`LastOn`,`Cash`,`Score`,`Kills`,`Deaths`,`Online`,`Rank`,`BestKillings`,`KillingSpree`,`Drugs`,`TimesOnServer`,`Coins`,`SAdmin`,`FavSkin`,`UseSkin`,`Description1`,`Description2`,Description3,`Positive`,`Negative`,`Clan`,`ClanRank`,`E-Mail`,`ClanPoints`,`ClanDeaths`,`ClanOnline`,`ClanJoined`,`Kicks`, `Bans`,`Jails`,`Warns`,`ClearChats`,`ReactionTest`,`MathTest`,`Mutes`,`ARatio`,`Property`,`Jailed`,`JailTime`,`Frozen`,`FreezeTime`,`RAdmin`,`ChatColor`,`DriftScore`,`DuelScore`,`vSpawn_X`,`vSpawn_Y`,`vSpawn_Z`,`vSpawn_A`,`Offer_ID`,`TopOnline`,`AdminWarns`,`OwnedCarID`, `Cookies`, `Cakes`, `Biscuits`, `Icecreams`) VALUES(0, '[xB]Slawi', '105.156.204.91', '74DFC2B27ACFA364DA55F93A5CAEE29CCAD3557247EDA238831B3E9BD931B01D77FE994E4F12B9D4CFA92A124461D2065197D8CF7F33FC88566DA2DB2A4D6EAE', '2015-6-22', '1', '0', '0', '0', '2015-6-22', '500', '0', '0', '0', '00:00:00', '0', '0', '0', '0', '1', '0', '0', 0, 0, ' ', ' ', ' ', 0, 0, 'None', 0, ' ', 0,0,'0:0:0','None', 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, 0, 0, 0, 0, 0)
Register Dialog script:
PHP код:
case RegDialog:
{
if ( !response )
return ShowPlayerDialog( playerid, RegDialog, DIALOG_STYLE_PASSWORD, "{FFFFFF}Register {FF0000}Failed !", "{FF0000}ERROR:\n\n{FFFFFF}You must obligatory register your account!", "Register", "" );
new
rPassword[ 25 ]
;
if ( sscanf( inputtext, "s[25]", rPassword ) )
return ShowPlayerDialog( playerid, RegDialog, DIALOG_STYLE_PASSWORD, "{FFFFFF}Register {FF0000}Failed !", "{FFFFFF}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, "{FFFFFF}Register {FF0000}Failed !", "{FFFFFF}The password must be between 6 and 24 characters!", "Register", "" );
new Buf[ 129 ];
WP_Hash( Buf, 129, rPassword );
mysql_real_escape_string( Buf, Buf );
new
liYear,
liMonth,
liDay,
pNaMe[ 25 ]
;
getdate( liYear, liMonth, liDay );
GetPlayerName( playerid, pNaMe, 25 );
mysql_real_escape_string( pNaMe, pNaMe );
gsString[ 0 ] = EOS;
format( gsString, sizeof gsString, "INSERT INTO `Accounts` (`Key`,`Name`,`IP`,`Password`,`RegisterDate`,`LoggedIn`,`Level`,`Vip`,`rVip`,`LastOn`,`Cash`,`Score`,`Kills`,\
`Deaths`,`Online`,`Rank`,`BestKillings`,`KillingSpree`,`Drugs`,`TimesOnServer`,`Coins`,`SAdmin`,`FavSkin`,`UseSkin`,`Description1`,`Description2`,Description3," );
format( gsString, sizeof gsString, "%s`Positive`,`Negative`,`Clan`,`ClanRank`,`E-Mail`,`ClanPoints`,`ClanDeaths`,`ClanOnline`,`ClanJoined`,`Kicks`, \
`Bans`,`Jails`,`Warns`,`ClearChats`,`ReactionTest`,`MathTest`,`Mutes`,`ARatio`,`Property`,`Jailed`,`JailTime`,`Frozen`,`FreezeTime`,`RAdmin`,`ChatColor`,", gsString );
format( gsString, sizeof gsString, "%s`DriftScore`,`DuelScore`,`vSpawn_X`,`vSpawn_Y`,`vSpawn_Z`,`vSpawn_A`,`Offer_ID`,`TopOnline`,`AdminWarns`,`OwnedCarID`, `Cookies`, `Cakes`, `Biscuits`, `Icecreams`)", gsString );
format( gsString, sizeof gsString, "%s VALUES(0, '%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, ' ', ' ', ' ', 0, 0, 'None', 0, ' ', 0", gsString, pNaMe, GetPlayerIPEx( playerid ), Buf, liYear, liMonth, liDay, liYear, liMonth, liDay );
format( gsString, sizeof( gsString ), "%s,0,'0:0:0','None', 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, 0, 0, 0, 0, 0)", gsString );
mysql_query( gsString );
PlayerInfo[ playerid ][ AccID ] = mysql_insert_id( );
format( gsString, 144, "INFO: {FF0000}%s {FFFFFF}Has registred on server, making have {FF0000}%s {FFFFFF}registred players on server!", PlayerName( playerid ), FormatNumber( PlayerInfo[ playerid ][ AccID ] ) );
SendClientMessageToAll( COLOR_YELLOW, gsString );
ShowPlayerDialog( playerid, DIALOG_EMAIL, DIALOG_STYLE_INPUT, "{FF0000}#2 {FFFFFF}Type your E-Mail", "{FFFFFF}Ok, now the last step before you can play on our server.\n\
{00FF00}Please enter your e-mail adress !\n\n\
{FFFFFF}Why we need your e-mail adress? Because if you loose your password\n\
you can change it by press '{00FF00}Recover Password{FFFFFF}'\n\
on Player Control Panel at {FF0000}www.omp-samp.tk/pcp", "Enter", "" );
PlayerInfo[ playerid ][ LoggedIn ] = 1;
GivePlayerMoney( playerid, 500 );
return 1;
}