phpBB.de

Code: Alles auswählen

Could not insert data into users table

DEBUG MODE

SQL Error : 1136 Column count doesn't match value count at row 1

INSERT INTO phpbb_users (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, 
user_occ, user_from, user_plz, user_from_flag, user_interests, user_sig, user_css, user_sig_bbcode_uid, user_avatar, 
user_avatar_type, user_viewemail, user_aim, user_yim, user_msnm, user_attachsig, user_allowsmile, user_allowhtml, 
user_allowbbcode, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_timezone, user_dateformat, 
user_lang, user_style, user_gender, user_level, user_allow_pm, user_custom_color, user_allow_mass_pm, user_birthday, 
user_next_birthday_greeting, user_active, user_actkey) VALUES 
(75, 'M****', 1053806398, '0d46ab3a230b1d60501c80746fa1ecc9', 
'i****@********.net, '147209388', 'http://www.*****_*****.net', '', 'Linz, Oberösterreich', '', 'austria.gif', 
'D2 LoD, Webdesignen', 'mobile | webdesign | :dance2: [img:402231efec]
http://www.************.de/board/images/smiles/wazzup_sg.gif[/img:402231efec] :dance2: | 
http://www.************.de info@mobile-webdesign.de', 
'402231efec', '', '', 0, 1, '', '', '************@********, 1, 1, 1, 1, 1, 1, 1, 1, 1, 'D M d, Y g:i a', 
'english', 3, 0, 1, '', '1', 0, 1, '2', '999999', '', 0, '4c55eece')

Line : 563
File : /home/www/******/html/board/includes/usercp_register.php

Code: Alles auswählen

## MOD Title: Custom username color defined in profile
## MOD Version: 2.0.2
## MOD Author: Acecool < webmaster@acecoolco.com > ( Josh M. M. ) http://www.acecoolco.com 
## MOD Description: Lets users choose a username color in profile if they have enough posts. 

Code: Alles auswählen

includes/function_validate.php

#
#-----[ FIND ]------------------------------------------
#

//
// Does supplementary validation of optional profile fields. This expects common stuff like trim() and strip_tags()
// to have already been run. Params are passed by-ref, so we can set them to the empty string if they fail.
//
function validate_optional_fields(&$icq, &$aim, &$msnm, &$yim, &$website, &$location, &$occupation, &$interests, &$sig)
{
	$check_var_length = array('aim', 'msnm', 'yim', 'location', 'occupation', 'interests', 'sig');

	for($i = 0; $i < count($check_var_length); $i++)
	{
		if ( strlen($$check_var_length[$i]) < 2 )
		{
			$$check_var_length[$i] = '';
		}
	}

	// ICQ number has to be only numbers.
	if ( !preg_match('/^[0-9]+$/', $icq) )
	{
		$icq = '';
	}
	
	// website has to start with http://, followed by something with length at least 3 that
	// contains at least one dot.
	if ( $website != "" )
	{
		if ( !preg_match('#^http:\/\/#i', $website) )
		{
			$website = 'http://' . $website;
		}

		if ( !preg_match('#^http\\:\\/\\/[a-z0-9\-]+\.([a-z0-9\-]+\.)?[a-z]+#i', $website) )
		{
			$website = '';
		}
	}

	return;
}

#
#-----[ IN-LINE FIND]------------------------------------------ 
#

&$interests

#
#-----[ IN-LINE AFTER, ADD]------------------------------------------ 
#

, &$custom_color

#
#-----[ IN-LINE FIND]
#

		if (!preg_match('#^http[s]?\\:\\/\\/[a-z0-9\-]+\.([a-z0-9\-]+\.)?[a-z]+#i', $website))
		{
			$website = '';
		}
	}

#
#-----[ AFTER, ADD]
#

	// Custom_color should not contain characters that are not usable in HTML color code
	if ( !preg_match('/^[0-9A-Fa-f]{6}$/', $custom_color) )
	{
		$custom_color = '';
	}