Bug Register - 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: Bug Register (/showthread.php?tid=578747)
+- 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: Bug Register (/showthread.php?tid=578747)
Bug Register - Slawiii - 21.06.2015
i m mfind this errors in server_logs
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;
}
Re: Bug Register - Slawiii - 22.06.2015
Pleaz help !
Re: Bug Register - !damo!spiderman - 22.06.2015
The errors means that you have either more column defines than you do values or the other way around, and it's no wonder either... you have so many columns defined, its so messy plus most of them could be set as default values in your mysql table define so then you don't have to have such long query messages.
Re: Bug Register - Slawiii - 22.06.2015
ok thank you Bro Fixed !