phpBB.nl

Code: Selecteer alles

 
Could not update users table

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near 'user_website2 = 'http://www.phpbbhacks.com/', user_occ = '', user_from = 'Dalen/' at line 2

UPDATE phpbb_users SET user_email = 'michaelwiekens@gmail.com', user_icq = '315324956', user_website = 'http://www.torrentgame.nl/forum'user_website2 = 'http://www.phpbbhacks.com/', user_occ = '', user_from = 'Dalen/Drenthe/Holland', user_interests = 'alles wat met een computer temalen heeft', user_birthday = '6007', user_next_birthday_greeting = '2006', user_sig = '', user_sig_bbcode_uid = '', user_viewemail = 1, user_aim = '', user_yim = 'Diablo_Gamer', user_msnm = 'michaelwiekens@hotmail.com', user_attachsig = 0, user_allowsmile = 1, user_autospell = 1, user_allowhtml = 0, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_notify_pm = 1, user_popup_pm = 1, user_timezone = 2, user_dateformat = 'd M Y h:i a', user_lang = 'dutch', user_style = 2, user_active = 1, user_actkey = '', user_country = 'netherlands' WHERE user_id = 2

Line : 619
File : usercp_register.php 

Code: Selecteer alles

			{

Code: Selecteer alles

# 
#-----[ OPEN ]------------------------------------------ 
# 
includes/usercp_register.php

# 
#-----[ FIND ]------------------------------------------ 
# 
$strip_var_list = array('username' =>

# 
#-----[ IN-LINE FIND ]------------------------------------------ 
# 
'website' => 'website',

# 
#-----[ IN-LINE AFTER, ADD ]------------------------------------------ 
# 
'website2' => 'website2',

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

# 
#-----[ IN-LINE FIND ]------------------------------------------ 
# 
$website

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

# 
#-----[ FIND ]------------------------------------------ 
# 
$website = stripslashes($website);

# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 
$website = stripslashes($website);

# 
#-----[ FIND ]------------------------------------------ 
# 
if ( $website != '' )
	{
		rawurlencode($website);
	}
# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 
if ( $website2 != '' )
	{
		rawurlencode($website2);
	}

# 
#-----[ FIND ]------------------------------------------ 
# 
$sql = "UPDATE " . USERS_TABLE . "

# 
#-----[ IN-LINE FIND ]------------------------------------------ 
# 
user_website = '" . str_replace("\'", "''", $website) . "'

# 
#-----[ IN-LINE AFTER, ADD ]------------------------------------------ 
# 
user_website2 = '" . str_replace("\'", "''", $website2) . "'

# 
#-----[ FIND ]------------------------------------------ 
# 
$sql = "INSERT INTO " . USERS_TABLE .

# 
#-----[ IN-LINE FIND ]------------------------------------------ 
# 
user_website,

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

# 
#-----[ FIND ]------------------------------------------ 
# 
$sql = "UPDATE " . USERS_TABLE . "

# 
#-----[ IN-LINE FIND ]------------------------------------------ 
# 
'" . str_replace("\'", "''", $website) . "',

# 
#-----[ IN-LINE AFTER, ADD ]------------------------------------------ 
# 
'" . str_replace("\'", "''", $website2) . "',

# 
#-----[ FIND ]------------------------------------------ 
# 
'WEB_SITE' => $website,

# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 
'WEB_SITE2' => $website2,

# 
#-----[ FIND ]------------------------------------------ 
# 
$website = stripslashes($website);

# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 
$website2 = stripslashes($website2);

# 
#-----[ FIND ]------------------------------------------ 
# 
$website = $userdata['user_website'];


# 
#-----[ AFTER, ADD ]------------------------------------------ 
# 
$website2 = $userdata['user_website2'];

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

# 
#-----[ IN-LINE FIND ]------------------------------------------ 
# 
$website,

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

# 
#-----[ FIND ]------------------------------------------ 
# 
'WEBSITE' => $website,

# 
#-----[ AFTER, ADD ]------------------------------------------ 
#
'WEBSITE2' => $website2,

# 
#-----[ OPEN ]------------------------------------------ 
# 

Code: Selecteer alles

				$key_len = 54 - ( strlen($server_url) );
				$key_len = ( $key_len > 6 ) ? $key_len : 6;
				$user_actkey = substr($user_actkey, 0, $key_len);

				if ( $userdata['session_logged_in'] )
				{
					session_end($userdata['session_id'], $userdata['user_id']);
				}
			}
			else
			{
				$user_active = 1;
				$user_actkey = '';
			}

			$sql = "UPDATE " . USERS_TABLE . "
				SET " . $username_sql . $passwd_sql . "user_email = '" . str_replace("\'", "''", $email) ."', user_icq = '" . str_replace("\'", "''", $icq) . "', user_website = '" . str_replace("\'", "''", $website) ."', user_website2 = '" . str_replace("\'", "''", $website2) . "', user_occ = '" . str_replace("\'", "''", $occupation) . "', user_from = '" . str_replace("\'", "''", $location) . "', user_interests = '" . str_replace("\'", "''", $interests) . "', user_birthday = '$birthday', user_next_birthday_greeting = '$next_birthday_greeting', user_sig = '" . str_replace("\'", "''", $signature) . "', user_sig_bbcode_uid = '$signature_bbcode_uid', user_viewemail = $viewemail, user_aim = '" . str_replace("\'", "''", str_replace(' ', '+', $aim)) . "', user_yim = '" . str_replace("\'", "''", $yim) . "', user_msnm = '" . str_replace("\'", "''", $msn) . "', user_attachsig = $attachsig, user_allowsmile = $allowsmilies, user_autospell = $spellcheck, user_allowhtml = $allowhtml, user_allowbbcode = $allowbbcode, user_allow_viewonline = $allowviewonline, user_notify = $notifyreply, user_notify_pm = $notifypm, user_popup_pm = $popup_pm, user_timezone = $user_timezone, user_dateformat = '" . str_replace("\'", "''", $user_dateformat) . "', user_lang = '" . str_replace("\'", "''", $user_lang) . "', user_style = $user_style, user_active = $user_active, user_actkey = '" . str_replace("\'", "''", $user_actkey) . "'" . $avatar_sql . ", user_country = '" . str_replace("\'", "''", $user_country) . "'
				WHERE user_id = $user_id";
			if ( !($result = $db->sql_query($sql)) )