Bug Register
#1

i m mfind this errors in server_logs

PHP код:
[01:07:52errorid1136 errorColumn 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) 
Pleaz how to Fix it


Register Dialog script:
PHP код:
        case RegDialog:
        {
            if ( !
response )
                return 
ShowPlayerDialogplayeridRegDialogDIALOG_STYLE_PASSWORD"{FFFFFF}Register {FF0000}Failed !""{FF0000}ERROR:\n\n{FFFFFF}You must obligatory register your account!""Register""" );
            new
                
rPassword25 ]
            ;
            if ( 
sscanfinputtext"s[25]"rPassword ) )
                return 
ShowPlayerDialogplayeridRegDialogDIALOG_STYLE_PASSWORD"{FFFFFF}Register {FF0000}Failed !""{FFFFFF}You must type a password if you want to register!""Register""" );
            if ( 
strlenrPassword ) < || strlenrPassword ) > 25 )
                return 
ShowPlayerDialogplayeridRegDialogDIALOG_STYLE_PASSWORD"{FFFFFF}Register {FF0000}Failed !""{FFFFFF}The password must be between 6 and 24 characters!""Register""" );
            new 
Buf129 ];
            
WP_HashBuf129rPassword );
            
mysql_real_escape_stringBufBuf );
            new
                
liYear,
                
liMonth,
                
liDay,
                
pNaMe25 ]
            ;
            
getdateliYearliMonthliDay );
            
GetPlayerNameplayeridpNaMe25 );
            
mysql_real_escape_stringpNaMepNaMe );
            
gsString] = EOS;
            
formatgsStringsizeof 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," 
);
            
formatgsStringsizeof 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 );
            
formatgsStringsizeof gsString"%s`DriftScore`,`DuelScore`,`vSpawn_X`,`vSpawn_Y`,`vSpawn_Z`,`vSpawn_A`,`Offer_ID`,`TopOnline`,`AdminWarns`,`OwnedCarID`, `Cookies`, `Cakes`, `Biscuits`, `Icecreams`)"gsString );
            
formatgsStringsizeof 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"
gsStringpNaMeGetPlayerIPExplayerid ), BufliYearliMonthliDayliYearliMonthliDay );
            
formatgsStringsizeofgsString ), "%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_querygsString );
            
PlayerInfoplayerid ][ AccID ] = mysql_insert_id( );
            
formatgsString144"INFO: {FF0000}%s {FFFFFF}Has registred on server, making have {FF0000}%s {FFFFFF}registred players on server!"PlayerNameplayerid ), FormatNumberPlayerInfoplayerid ][ AccID ] ) );
            
SendClientMessageToAllCOLOR_YELLOWgsString );
            
ShowPlayerDialogplayeridDIALOG_EMAILDIALOG_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""" );
            
PlayerInfoplayerid ][ LoggedIn ] = 1;
            
GivePlayerMoneyplayerid500 );
            return 
1;
        } 
Pleaz help
Reply


Messages In This Thread
Bug Register - by Slawiii - 21.06.2015, 23:17
Re: Bug Register - by Slawiii - 22.06.2015, 00:34
Re: Bug Register - by !damo!spiderman - 22.06.2015, 01:28
Re: Bug Register - by Slawiii - 22.06.2015, 01:57

Forum Jump:


Users browsing this thread: 1 Guest(s)