Pagina 1 van 1

aangepaste car-mod mysql probleem

Geplaatst: 15 feb 2005, 19:26
door Stefanouz
om de profielen wat leuker te maken heb ik de car-mod gedownload, waar je wat over auto's kan neerzetten veranderd in een "favo-modification". origineel kon je vertellen wat je motor enzo was, ik had ervan gemaakt, dat je kon vertellen wat je favo artiest enzo was.

alles zitten veranderen en uiteindelijk geinstalleerd. nergens op het eerste gezicht een foutmelding, maar als je wat gaat toevoegen, en je drukt op OK in profiel, krijg je de volgende melding:

Code: Selecteer alles

Could not update users table

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax near ' user_birthday = '7125', user_next_birthday_greeting = '2005', user_sig = 'Ja...' at line 3

UPDATE phpbb_users SET user_email = 'stefan@ertje.nl', user_icq = '', user_website = 'http://www.ertje.nl/phpBB2/', user_occ = 'Scholier :(', user_from = 'nenkaas stinkt', user_interests = 'Ertje.nl onderhouden!', user_Favo_muziek = '', user_Favo_film = '', user_Favo_tvserie = '', user_Favo_website = 'd', user_Favo_auto = '', user_Favo_artiest = '', user_Favo_color = '', , user_birthday = '7125', user_next_birthday_greeting = '2005', user_sig = 'Ja... en dat is dus mijn mening :)', user_sig_bbcode_uid = '2cd0b10558', user_viewemail = 1, user_aim = 'heb+ik+niet...', user_yim = 'is afwezig...', user_msnm = 'stefanouz@gmail.com, stefanouz@spymac.com, stefan@ertje.nl', user_attachsig = 1, user_allowsmile = 1, user_allowhtml = 0, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_notify_pm = 1, user_popup_pm = 1, user_timezone = 1, user_rankset_id = 1, user_dateformat = 'd M Y h:i a', user_lang = 'dutch', user_style = 1, user_active = 1, user_actkey = '' WHERE user_id = 2

Line : 616
File : /opt/content/ertje.nl/HTML/phpBB2/includes/usercp_register.php

dit is de code van mijn mod:


Code: Selecteer alles

################################################################################### 
## 
## Hack Title: Add info-Favo to profile 
## Hack Version: 0.0.1 
## Author: hobo < portal@hacksphpbb.ru > http://www.hacksphpbb.ru
##
## Description:  Add info-Favo to profile (mark, film, tvserie, website, auto, artiest, color, url_foto)
##
## Files to edit: 8
##		admin/admin_users.php
##	                language/lang_english/lang_main.php
##              	includes/usercp_viewprofile.php 
##	                includes/usercp_register.php
##      		includes/usercp_avatar.php 
##              	templates/xxx/admin/user_edit_body.tpl
## 	                templates/xxx/profile_add_body.tpl 
##      	        templates/xxx/profile_view_body.tpl 
##
################################################################################### 
## 
## Installation/Author Notes: 
## First always backup the files that you're going to edit. 
## 
## This hacks adds a new column to your 'user' table. 
##
################################################################################### 
#
#-----[ SQL ]-------------------------------------------
#  
# You may have to change your database prefix

ALTER TABLE phpbb_users ADD user_Favo_muziek VARCHAR(255) AFTER user_interests;
ALTER TABLE phpbb_users ADD user_Favo_film VARCHAR(255) AFTER user_Favo_muziek;
ALTER TABLE phpbb_users ADD user_Favo_tvserie VARCHAR(255) AFTER user_Favo_film;
ALTER TABLE phpbb_users ADD user_Favo_website VARCHAR(255) AFTER user_Favo_tvserie;
ALTER TABLE phpbb_users ADD user_Favo_auto VARCHAR(255) AFTER user_Favo_website;
ALTER TABLE phpbb_users ADD user_Favo_artiest VARCHAR(255) AFTER user_Favo_website;
ALTER TABLE phpbb_users ADD user_Favo_color VARCHAR(255) AFTER user_Favo_artiest;


##
################################################################################### 
# 
#-----[ OPEN ]------------------------------------------ 
#  
# language/lang_english/lang_english.php
# 
#-----[ FIND ]---------------------------------------------------
# 
$lang['Interests'] = 'Èíòåðåñû';

# 
#-----[ ADD BELOW ]---------------------------------------------------
# 
$lang['Favo'] = 'Favo';
$lang['Favo_muziek'] = 'Favo muziek';
$lang['Favo_film'] = 'Favo film';
$lang['Favo_tvserie'] = 'Favo tvserie';
$lang['Favo_website'] = 'Favo website';
$lang['Favo_auto'] = 'Favo auto';
$lang['Favo_artiest'] = 'Favo artiest';
$lang['Favo_Color'] = 'Lievelingskleur';



# 
#-----[ OPEN ]------------------------------------------ 
#  
# includes/usercp_viewprofile.php
# 
#-----[ FIND ]---------------------------------------------------
# 
	'INTERESTS' => ( $profiledata['user_interests'] ) ? $profiledata['user_interests'] : '&nbsp;',

# 
#-----[ ADD BELOW ]---------------------------------------------------
# 
	'Favo_muziek' => ( $profiledata['user_Favo_muziek'] ) ? $profiledata['user_Favo_muziek'] : '&nbsp;',
	'Favo_film' => ( $profiledata['user_Favo_film'] ) ? $profiledata['user_Favo_film'] : '&nbsp;',
	'Favo_tvserie' => ( $profiledata['user_Favo_tvserie'] ) ? $profiledata['user_Favo_tvserie'] : '&nbsp;',
	'Favo_website' => ( $profiledata['user_Favo_website'] ) ? $profiledata['user_Favo_website'] : '&nbsp;',
	'Favo_auto' => ( $profiledata['user_Favo_auto'] ) ? $profiledata['user_Favo_auto'] : '&nbsp;',
	'Favo_artiest' => ( $profiledata['user_Favo_artiest'] ) ? $profiledata['user_Favo_artiest'] : '&nbsp;',
	'Favo_COLOR' => ( $profiledata['user_Favo_color'] ) ? $profiledata['user_Favo_color'] : '&nbsp;',
	'L_Favo' => $lang['Favo'],
	'L_Favo_muziek' => $lang['Favo_muziek'],
	'L_Favo_film' => $lang['Favo_film'],
	'L_Favo_tvserie' => $lang['Favo_tvserie'],
	'L_Favo_website' => $lang['Favo_website'],
	'L_Favo_auto' => $lang['Favo_auto'],
	'L_Favo_artiest' => $lang['Favo_artiest'],
	'L_Favo_COLOR' => $lang['Favo_Color'],
	

# 
#-----[ OPEN ]------------------------------------------ 
#  
# includes/usercp_register.php
# 
#-----[ FIND ]---------------------------------------------------
# 
	$strip_var_list = array('username' => 'username', 'email' => 'email', 'icq' => 'icq', 'aim' => 'aim', 'msn' => 'msn', 'yim' => 'yim', 'website' => 'website', 'location' => 'location', 'occupation' => 'occupation', 'interests' => 'interests');

# 
#-----[ IN-LINE FIND ]---------------------------------------------------
# 
'interests'

# 
#-----[ IN-LINE ADD ]---------------------------------------------------
# 
, 'Favo_muziek' => 'Favo_muziek', 'Favo_film' => 'Favo_film', 'Favo_tvserie' => 'Favo_tvserie', 'Favo_website' => 'Favo_website', 'Favo_auto' => 'Favo_auto', 'Favo_artiest' => 'Favo_artiest', 'Favo_color' => 'Favo_color',

# 
#-----[ FIND ]---------------------------------------------------
# 
	validate_optional_fields($icq, $aim, $msn, $yim, $website, $location, $occupation, $interests, $signature);

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

# 
#-----[ IN-LINE ADD ]---------------------------------------------------
# 
, $Favo_muziek, $Favo_film, $Favo_tvserie, $Favo_website, $Favo_auto, $Favo_artiest, $Favo_color

# 
#-----[ FIND (1st occurence) ]---------------------------------------------------
# 
		$interests = stripslashes($interests);

# 
#-----[ ADD BELOW ]---------------------------------------------------
# 
		$Favo_muziek = stripslashes($Favo_muziek);
		$Favo_film = stripslashes($Favo_film);
		$Favo_tvserie = stripslashes($Favo_tvserie);
		$Favo_website = stripslashes($Favo_website);
		$Favo_auto = stripslashes($Favo_auto);
		$Favo_artiest = stripslashes($Favo_artiest);
		$Favo_color = stripslashes($Favo_color);
		

# 
#-----[ FIND ]---------------------------------------------------
# 
			$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_occ = '" . str_replace("\'", "''", $occupation) . "', user_from = '" . str_replace("\'", "''", $location) . "', user_interests = '" . str_replace("\'", "''", $interests) . "', 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_allowhtml = $allowhtml, user_allowbbcode = $allowbbcode, user_allow_viewonline = $allowviewonline, user_notify = $notifyreply, user_notify_pm = $notifypm, user_popup_pm = $popuppm, 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 . "

# 
#-----[ IN-LINE FIND ]---------------------------------------------------
# 
$interests) . "'

# 
#-----[ IN-LINE ADD ]---------------------------------------------------
# 
, user_Favo_muziek = '" . str_replace("\'", "''", $Favo_muziek) . "', user_Favo_film = '" . str_replace("\'", "''", $Favo_film) . "', user_Favo_tvserie = '" . str_replace("\'", "''", $Favo_tvserie) . "', user_Favo_website = '" . str_replace("\'", "''", $Favo_website) . "', user_Favo_auto = '" . str_replace("\'", "''", $Favo_auto) . "', user_Favo_artiest = '" . str_replace("\'", "''", $Favo_artiest) . "', user_Favo_color = '" . str_replace("\'", "''", $Favo_color) . "',


# 
#-----[ FIND ]---------------------------------------------------
# 
			$sql = "INSERT INTO " . USERS_TABLE . "	(user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_sig, 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_level, user_allow_pm, user_active, user_actkey)
				VALUES ($user_id, '" . str_replace("\'", "''", $username) . "', " . time() . ", '" . str_replace("\'", "''", $password) . "', '" . str_replace("\'", "''", $email) . "', '" . str_replace("\'", "''", $icq) . "', '" . str_replace("\'", "''", $website) . "', '" . str_replace("\'", "''", $occupation) . "', '" . str_replace("\'", "''", $location) . "', '" . str_replace("\'", "''", $interests) . "', '" . str_replace("\'", "''", $signature) . "', '$signature_bbcode_uid', $avatar_sql, $viewemail, '" . str_replace("\'", "''", str_replace(' ', '+', $aim)) . "', '" . str_replace("\'", "''", $yim) . "', '" . str_replace("\'", "''", $msn) . "', $attachsig, $allowsmilies, $allowhtml, $allowbbcode, $allowviewonline, $notifyreply, $notifypm, $popuppm, $user_timezone, '" . str_replace("\'", "''", $user_dateformat) . "', '" . str_replace("\'", "''", $user_lang) . "', $user_style, 0, 1, ";

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

# 
#-----[ IN-LINE ADD ]---------------------------------------------------
# 
, user_Favo_muziek, user_Favo_film, user_Favo_tvserie, user_Favo_website, user_Favo_auto, user_Favo_artiest, user_Favo_color,

# 
#-----[ IN-LINE FIND ]---------------------------------------------------
# 
$interests) . "'

# 
#-----[ IN-LINE ADD ]---------------------------------------------------
# 
, '" . str_replace("\'", "''", $Favo_muziek) . "', '" . str_replace("\'", "''", $Favo_film) . "', '" . str_replace("\'", "''", $Favo_tvserie) . "', '" . str_replace("\'", "''", $Favo_website) . "', '" . str_replace("\'", "''", $Favo_auto) . "', '" . str_replace("\'", "''", $Favo_artiest) . "', '" . str_replace("\'", "''", $Favo_color) . "'


# 
#-----[ FIND (2nd occurence) ]---------------------------------------------------
# 
	$interests = stripslashes($interests);

# 
#-----[ ADD BELOW ]---------------------------------------------------
# 
	$Favo_muziek = stripslashes($Favo_muziek);
	$Favo_film = stripslashes($Favo_film);
	$Favo_tvserie = stripslashes($Favo_tvserie);
	$Favo_website = stripslashes($Favo_website);
	$Favo_auto = stripslashes($Favo_auto);
	$Favo_artiest = stripslashes($Favo_artiest);
	$Favo_color = stripslashes($Favo_color);
	


# 
#-----[ FIND ]---------------------------------------------------
# 
	$interests = $userdata['user_interests'];

# 
#-----[ ADD BELOW ]---------------------------------------------------
# 
	$Favo_muziek = $userdata['user_Favo_muziek'];
	$Favo_film = $userdata['user_Favo_film'];
	$Favo_tvserie = $userdata['user_Favo_tvserie'];
	$Favo_website = $userdata['user_Favo_website'];
	$Favo_auto = $userdata['user_Favo_auto'];
	$Favo_artiest = $userdata['user_Favo_artiest'];
	$Favo_color = $userdata['user_Favo_color'];
	

# 
#-----[ FIND ]---------------------------------------------------
# 
display_avatar_gallery($mode, $avatar_category, $user_id, $email, $current_email, $coppa, $username, $email, &$new_password, &$cur_password, $password_confirm, $icq, $aim, $msn, $yim, $website, $location, $occupation, $interests, $signature, $viewemail, $notifypm, $popuppm, $notifyreply, $attachsig, $allowhtml, $allowbbcode, $allowsmilies, $allowviewonline, $user_style, $user_lang, $user_timezone, $user_dateformat, $userdata['session_id']);

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

# 
#-----[ IN-LINE ADD ]---------------------------------------------------
# 
, $Favo_muziek, $Favo_film, $Favo_tvserie, $Favo_website, $Favo_auto, $Favo_artiest, $Favo_color

# 
#-----[ FIND (just a quote) ]--------------------------
# 
	$template->assign_vars(array(
		.
		.
		.
		.
		'INTERESTS' => $interests,

# 
#-----[ ADD BELOW ]---------------------------------------------------
# 
		'Favo_muziek' => $Favo_muziek,
		'L_Favo_muziek' => $lang['Favo_muziek'],
		'Favo_film' => $Favo_film,
		'L_Favo_film' => $lang['Favo_film'],
		'Favo_tvserie' => $Favo_tvserie,
		'L_Favo_tvserie' => $lang['Favo_tvserie'],
		'Favo_website' => $Favo_website,
		'L_Favo_website' => $lang['Favo_website'],
		'Favo_auto' => $Favo_auto,
		'L_Favo_auto' => $lang['Favo_auto'],
		'Favo_artiest' => $Favo_artiest,
		'L_Favo_artiest' => $lang['Favo_artiest'],
		'Favo_COLOR' => $Favo_color,
		'L_Favo_COLOR' => $lang['Favo_Color'],
		


# 
#-----[ OPEN ]------------------------------------------ 
#  
# includes/usercp_avatar.php
# 
#-----[ FIND ]---------------------------------------------------
# 
function display_avatar_gallery($mode, &$category, &$user_id, &$email, &$current_email, &$coppa, &$username, &$email, &$new_password, &$cur_password, &$password_confirm, &$icq, &$aim, &$msn, &$yim, &$website, &$location, &$occupation, &$interests, &$signature, &$viewemail, &$notifypm, &$popuppm, &$notifyreply, &$attachsig, &$allowhtml, &$allowbbcode, &$allowsmilies, &$hideonline, &$style, &$language, &$timezone, &$dateformat, &$session_id)

# 
#-----[ IN-LINE FIND ]---------------------------------------------------
# 
&$dateformat

# 
#-----[ IN-LINE ADD ]---------------------------------------------------
# 
, &$Favo_muziek, &$Favo_film, &$Favo_tvserie, &$Favo_website, &$Favo_auto, &$Favo_artiest, &$Favo_color

# 
#-----[ FIND ]---------------------------------------------------
# 
$params = array('coppa', 'user_id', 'username', 'email', 'current_email', 'cur_password', 'new_password', 'password_confirm', 'icq', 'aim', 'msn', 'yim', 'website', 'location', 'occupation', 'interests', 'signature', 'viewemail', 'notifypm', 'popuppm', 'notifyreply', 'attachsig', 'allowhtml', 'allowbbcode', 'allowsmilies', 'hideonline', 'style', 'language', 'timezone', 'dateformat');

# 
#-----[ IN-LINE FIND ]---------------------------------------------------
# 
'dateformat'

# 
#-----[ IN-LINE ADD ]---------------------------------------------------
# 
, 'Favo_muziek', 'Favo_film', 'Favo_tvserie', 'Favo_website', 'Favo_auto', 'Favo_artiest', 'Favo_color', 'Favo_color'


# 
#-----[ OPEN ]------------------------------------------ 
#  
# admin/admin_users.php 
# 
#-----[ FIND ]---------------------------------------------------
# 
		$interests = ( !empty($HTTP_POST_VARS['interests']) ) ? trim(strip_tags( $HTTP_POST_VARS['interests'] ) ) : '';

# 
#-----[ ADD BELOW ]---------------------------------------------------
# 
		$Favo_muziek = ( !empty($HTTP_POST_VARS['Favo_muziek']) ) ? trim(strip_tags( $HTTP_POST_VARS['Favo_muziek'] ) ) : ''; 
		$Favo_film = ( !empty($HTTP_POST_VARS['Favo_film']) ) ? trim(strip_tags( $HTTP_POST_VARS['Favo_film'] ) ) : ''; 
		$Favo_tvserie = ( !empty($HTTP_POST_VARS['Favo_tvserie']) ) ? trim(strip_tags( $HTTP_POST_VARS['Favo_tvserie'] ) ) : ''; 
		$Favo_website = ( !empty($HTTP_POST_VARS['Favo_website']) ) ? trim(strip_tags( $HTTP_POST_VARS['Favo_website'] ) ) : ''; 
		$Favo_auto= ( !empty($HTTP_POST_VARS['music']) ) ? trim(strip_tags( $HTTP_POST_VARS['Favo_auto'] ) ) : ''; 
		$Favo_artiest = ( !empty($HTTP_POST_VARS['Favo_artiest']) ) ? trim(strip_tags( $HTTP_POST_VARS['Favo_artiest'] ) ) : ''; 
		$Favo_color = ( !empty($HTTP_POST_VARS['Favo_color']) ) ? trim(strip_tags( $HTTP_POST_VARS['Favo_color'] ) ) : ''; 
		
# 
#-----[ FIND ]---------------------------------------------------
# 
validate_optional_fields($icq, $aim, $msn, $yim, $website, $location, $occupation, $interests, $signature); 

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

# 
#-----[ IN-LINE ADD ]---------------------------------------------------
# 
, $Favo_muziek, $Favo_film, $Favo_tvserie, $Favo_website, $Favo_auto, $Favo_artiest, $Favo_color,

# 
#-----[ FIND (1st occurence) ]--------------------------------------------
# 
			$interests = htmlspecialchars(stripslashes($interests));

# 
#-----[ AFTER ADD ]---------------------------------------------------
# 
		$Favo_muziek = htmlspecialchars(stripslashes($Favo_muziek));
		$Favo_film = htmlspecialchars(stripslashes($Favo_film));
		$Favo_tvserie = htmlspecialchars(stripslashes($Favo_tvserie));
		$Favo_website = htmlspecialchars(stripslashes($Favo_website));
		$Favo_auto = htmlspecialchars(stripslashes($Favo_auto));
		$Favo_artiest = htmlspecialchars(stripslashes($Favo_artiest));
		$Favo_color = htmlspecialchars(stripslashes($Favo_color));
		

# 
#-----[ FIND ]---------------------------------------------------
# 
			$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_occ = '" . str_replace("\'", "''", $occupation) . "', user_from = '" . str_replace("\'", "''", $location) . "', user_interests = '" . str_replace("\'", "''", $interests) . "', user_sig = '" . str_replace("\'", "''", $signature) . "', user_viewemail = $viewemail, user_aim = '" . str_replace("\'", "''", $aim) . "', user_yim = '" . str_replace("\'", "''", $yim) . "', user_msnm = '" . str_replace("\'", "''", $msn) . "', user_attachsig = $attachsig, user_sig_bbcode_uid = '$signature_bbcode_uid', user_allowsmile = $allowsmilies, user_allowhtml = $allowhtml, user_allowavatar = $user_allowavatar, user_allowbbcode = $allowbbcode, user_allow_viewonline = $allowviewonline, user_notify = $notifyreply, user_allow_pm = $user_allowpm, user_notify_pm = $notifypm, user_popup_pm = $popuppm, user_lang = '" . str_replace("\'", "''", $user_lang) . "', user_style = $user_style, user_timezone = $user_timezone, user_dateformat = '" . str_replace("\'", "''", $user_dateformat) . "', user_active = $user_status, user_rank = $user_rank" . $avatar_sql . "

# 
#-----[ IN-LINE FIND ]---------------------------------------------------
# 
$interests) . "'

# 
#-----[ IN-LINE ADD ]---------------------------------------------------
# 
, user_Favo_muziek = '" . str_replace("\'", "''", $Favo_muziek) . "', user_Favo_film = '" . str_replace("\'", "''", $Favo_film) . "', user_Favo_tvserie = '" . str_replace("\'", "''", $Favo_tvserie) . "', user_Favo_website = '" . str_replace("\'", "''", $Favo_website) . "', user_Favo_auto = '" . str_replace("\'", "''", $Favo_auto) . "', user_Favo_artiest = '" . str_replace("\'", "''", $Favo_artiest) . "', user_Favo_color = '" . str_replace("\'", "''", $Favo_color) . "'

# 
#-----[ FIND (2nd occurence) ]-------------------------------------------
# 
			$interests = htmlspecialchars(stripslashes($interests));

# 
#-----[ ADD BELOW ]---------------------------------------------------
# 
			$Favo_muziek = htmlspecialchars(stripslashes($Favo_muziek));
			$Favo_film = htmlspecialchars(stripslashes($Favo_film));
			$Favo_tvserie = htmlspecialchars(stripslashes($Favo_tvserie));
			$Favo_website = htmlspecialchars(stripslashes($Favo_website));
			$Favo_auto = htmlspecialchars(stripslashes($Favo_auto));
			$Favo_artiest = htmlspecialchars(stripslashes($Favo_artiest));
			$Favo_color = htmlspecialchars(stripslashes($Favo_color));
			

# 
#-----[ FIND ]---------------------------------------------------
# 
		$interests = htmlspecialchars($this_userdata['user_interests']);

# 
#-----[ ADD BELOW ]---------------------------------------------------
# 
		$Favo_muziek = htmlspecialchars($this_userdata['user_Favo_muziek']);
		$Favo_film = htmlspecialchars($this_userdata['user_Favo_film']);
		$Favo_tvserie = htmlspecialchars($this_userdata['user_Favo_tvserie']);
		$Favo_website = htmlspecialchars($this_userdata['user_Favo_website']);
		$Favo_auto = htmlspecialchars($this_userdata['user_Favo_auto']);
		$Favo_artiest = htmlspecialchars($this_userdata['user_Favo_artiest']);
		$Favo_color = htmlspecialchars($this_userdata['user_Favo_color']);
		

# 
#-----[ FIND ]---------------------------------------------------
# 
			$s_hidden_fields .= '<input type="hidden" name="interests" value="' . str_replace("\"", """, $interests) . '" />';

# 
#-----[ ADD BELOW ]---------------------------------------------------
# 
			$s_hidden_fields .= '<input type="hidden" name="Favo_muziek" value="' . str_replace("\"", """, $Favo_muziek) . '" />'; 
			$s_hidden_fields .= '<input type="hidden" name="Favo_film" value="' . str_replace("\"", """, $Favo_film) . '" />'; 
			$s_hidden_fields .= '<input type="hidden" name="Favo_tvserie" value="' . str_replace("\"", """, $Favo_tvserie) . '" />'; 
			$s_hidden_fields .= '<input type="hidden" name="Favo_website" value="' . str_replace("\"", """, $Favo_website) . '" />'; 
			$s_hidden_fields .= '<input type="hidden" name="Favo_auto" value="' . str_replace("\"", """, $Favo_auto) . '" />'; 
			$s_hidden_fields .= '<input type="hidden" name="Favo_artiest" value="' . str_replace("\"", """, $Favo_artiest) . '" />'; 
			$s_hidden_fields .= '<input type="hidden" name="Favo_color" value="' . str_replace("\"", """, $Favo_color) . '" />'; 
			
# 
#-----[ FIND ]---------------------------------------------------
# 
			'INTERESTS' => $interests,

# 
#-----[ ADD BELOW ]---------------------------------------------------
# 
			'Favo_muziek' => $Favo_muziek,
			'L_Favo_muziek' => $lang['Favo_muziek'],
			'Favo_film' => $Favo_film,
			'L_Favo_film' => $lang['Favo_film'],
			'Favo_tvserie' => $Favo_tvserie,
			'L_Favo_tvserie' => $lang['Favo_tvserie'],
			'Favo_website' => $Favo_website,
			'L_Favo_website' => $lang['Favo_website'],
			'Favo_auto' => $Favo_auto,
			'L_Favo_auto' => $lang['Favo_auto'],
			'Favo_artiest' => $Favo_artiest,
			'L_Favo_artiest' => $lang['Favo_artiest'],
			'Favo_COLOR' => $Favo_color,
			'L_Favo_COLOR' => $lang['Favo_Color'],
			



# 
#-----[ OPEN ]------------------------------------------ 
#  
# templates/xxx/profile_add_body.tpl
# 
#-----[ FIND ]---------------------------------------------------
# 
	<tr> 
	  <td class="row1"><span class="gen">{L_SIGNATURE}:</span><br /><span class="gensmall">{L_SIGNATURE_EXPLAIN}<br /><br />{HTML_STATUS}<br />{BBCODE_STATUS}<br />{SMILIES_STATUS}</span></td>
	  <td class="row2"> 
		<textarea name="signature"style="width: 300px"  rows="6" cols="30" class="post">{SIGNATURE}</textarea>
	  </td>
	</tr>

# 
#-----[ ADD BELOW ]---------------------------------------------------
# 

	<tr> 
	  <td class="catSides" colspan="2" height="28">&nbsp;</td>
	</tr>
	<tr> 
	  <th class="thSides" colspan="2" height="25" valign="middle">{L_Favo}</th>
	</tr>
	<tr> 
	  <td class="row1"><span class="gen">{L_Favo_muziek}:</span></td>
	  <td class="row2"> <input type="text" class="post"style="width: 200px"  name="Favo_muziek" size="35" maxlength="150" value="{Favo_muziek}" /> </td>
	</tr>
	<tr> 
	  <td class="row1"><span class="gen">{L_Favo_film}:</span></td>
	  <td class="row2"> <input type="text" class="post"style="width: 200px"  name="Favo_film" size="35" maxlength="150" value="{Favo_film}" /> </td>
	</tr>
	<tr> 
	  <td class="row1"><span class="gen">{L_Favo_tvserie}:</span></td>
	  <td class="row2"> <input type="text" class="post"style="width: 200px"  name="Favo_tvserie" size="35" maxlength="150" value="{Favo_tvserie}" /> </td>
	</tr>
	<tr> 
	  <td class="row1"><span class="gen">{L_Favo_website}:</span></td>
	  <td class="row2"> <input type="text" class="post"style="width: 200px"  name="Favo_website" size="35" maxlength="150" value="{Favo_website}" /> </td>
	</tr>
	<tr> 
	  <td class="row1"><span class="gen">{L_Favo_auto}:</span></td>
	  <td class="row2"> <input type="text" class="post"style="width: 200px"  name="Favo_auto" size="35" maxlength="150" value="{Favo_auto}" /> </td>
	</tr>
	<tr> 
	  <td class="row1"><span class="gen">{L_Favo_artiest}:</span></td>
	  <td class="row2"> <input type="text" class="post"style="width: 200px"  name="Favo_artiest" size="35" maxlength="150" value="{Favo_artiest}" /> </td>
	</tr>
	<tr> 
	  <td class="row1"><span class="gen">{L_Favo_COLOR}:</span></td>
	  <td class="row2"> <input type="text" class="post"style="width: 200px"  name="Favo_color" size="35" maxlength="150" value="{Favo_COLOR}" /> </td>
	</tr>
	

# 
#-----[ OPEN ]------------------------------------------ 
#  
# templates/xxx/profile_view_body.tpl
# 
#-----[ FIND ]---------------------------------------------------
# 
		<tr> 
		  <td valign="middle" nowrap="nowrap" align="right"><span class="gen">{L_ICQ_NUMBER}:</span></td>
		  <td class="row1"><script language="JavaScript" type="text/javascript"><!-- 

		if ( navigator.userAgent.toLowerCase().indexOf('mozilla') != -1 && navigator.userAgent.indexOf('5.') == -1 && navigator.userAgent.indexOf('6.') == -1 )
			document.write(' {ICQ_IMG}');
		else
			document.write('<table cellspacing="0" cellpadding="0" border="0"><tr><td nowrap="nowrap"><div style="position:relative;height:18px"><div style="position:absolute">{ICQ_IMG}</div><div style="position:absolute;left:3px;top:-1px">{ICQ_STATUS_IMG}</div></div></td></tr></table>');
		  
		  //--></script><noscript>{ICQ_IMG}</noscript></td>
		</tr>
	  </table>
	</td>
  </tr>

# 
#-----[ ADD BELOW ]---------------------------------------------------
# 
  <tr>
	<td class="row1" valign="top" colspan="2"><table width="100%" border="0" cellspacing="1" cellpadding="3">
		<tr> 
		  <td valign="middle" align="right" nowrap="nowrap"><span class="gen">{L_Favo_muziek}:</span></td>
		  <td class="row1" valign="middle" width="100%"><b><span class="gen">{Favo_muziek}</span></b></td>
		</tr>
		<tr> 
		  <td valign="middle" align="right" nowrap="nowrap"><span class="gen">{L_Favo_film}:</span></td>
		  <td class="row1" valign="middle" width="100%"><b><span class="gen">{Favo_film}</span></b></td>
		</tr>
		<tr> 
		  <td valign="middle" align="right" nowrap="nowrap"><span class="gen">{L_Favo_tvserie}:</span></td>
		  <td class="row1" valign="middle" width="100%"><b><span class="gen">{Favo_tvserie}</span></b></td>
		</tr>
		<tr> 
		  <td valign="middle" align="right" nowrap="nowrap"><span class="gen">{L_Favo_website}:</span></td>
		  <td class="row1" valign="middle" width="100%"><b><span class="gen">{Favo_website}</span></b></td>
		</tr>
		<tr> 
		  <td valign="middle" align="right" nowrap="nowrap"><span class="gen">{L_Favo_auto}:</span></td>
		  <td class="row1" valign="middle" width="100%"><b><span class="gen">{Favo_auto}</span></b></td>
		</tr>
		<tr> 
		  <td valign="middle" align="right" nowrap="nowrap"><span class="gen">{L_Favo_artiest}:</span></td>
		  <td class="row1" valign="middle" width="100%"><b><span class="gen">{Favo_artiest}</span></b></td>
		</tr>
		<tr> 
		  <td valign="middle" align="right" nowrap="nowrap"><span class="gen">{L_Favo_COLOR}:</span></td>
		  <td class="row1" valign="middle" width="100%"><b><span class="gen">{Favo_COLOR}</span></b></td>
		</tr>
		</table>
	</td>
  </tr>


# 
#-----[ OPEN ]------------------------------------------ 
#  
# templates/xxx/admin/user_edit_body.tpl
# 
#-----[ FIND ]---------------------------------------------------
# 
	<tr> 
	  <td class="row1"><span class="gen">{L_SIGNATURE}</span><br />
		<span class="gensmall">{L_SIGNATURE_EXPLAIN}<br />
		<br />
		{HTML_STATUS}<br />
		{BBCODE_STATUS}<br />
		{SMILIES_STATUS}</span></td>
	  <td class="row2"> 
		<textarea class="post" name="signature" rows="6" cols="45">{SIGNATURE}</textarea>
	  </td>
	</tr>

# 
#-----[ ADD BELOW ]---------------------------------------------------
# 
	<tr> 
	  <td class="catSides" colspan="2" height="28">&nbsp;</td>
	</tr>
	<tr> 
	  <th class="thSides" colspan="2" height="25" valign="middle">{L_Favo}</th>
	</tr>
	<tr> 
	  <td class="row1"><span class="gen">{L_Favo_muziek}:</span></td>
	  <td class="row2"> <input type="text" class="post" name="Favo_muziek" size="35" maxlength="150" value="{Favo_muziek}" /> </td>
	</tr>
	<tr> 
	  <td class="row1"><span class="gen">{L_Favo_film}:</span></td>
	  <td class="row2"> <input type="text" class="post" name="Favo_film" size="35" maxlength="150" value="{Favo_film}" /> </td>
	</tr>
	<tr> 
	  <td class="row1"><span class="gen">{L_Favo_tvserie}:</span></td>
	  <td class="row2"> <input type="text" class="post" name="Favo_tvserie" size="35" maxlength="150" value="{Favo_tvserie}" /> </td>
	</tr>
	<tr> 
	  <td class="row1"><span class="gen">{L_Favo_website}:</span></td>
	  <td class="row2"> <input type="text" class="post" name="Favo_website" size="35" maxlength="150" value="{Favo_website}" /> </td>
	</tr>
	<tr> 
	  <td class="row1"><span class="gen">{L_Favo_auto}:</span></td>
	  <td class="row2"> <input type="text" class="post" name="Favo_auto" size="35" maxlength="150" value="{Favo_auto}" /> </td>
	</tr>
	<tr> 
	  <td class="row1"><span class="gen">{L_Favo_artiest}:</span></td>
	  <td class="row2"> <input type="text" class="post" name="Favo_artiest" size="35" maxlength="150" value="{Favo_artiest}" /> </td>
	</tr>
	<tr> 
	  <td class="row1"><span class="gen">{L_Favo_COLOR}:</span></td>
	  <td class="row2"> <input type="text" class="post" name="Favo_color" size="35" maxlength="150" value="{Favo_COLOR}" /> </td>
	</tr>
	


################################################################################### 

Geplaatst: 15 feb 2005, 19:32
door Paul
er staan 2 komma's in de query naast elkaar. Haal er een weg en waarschijnlijk werkt het :D

Geplaatst: 15 feb 2005, 19:38
door Bee
Ik vind dit trouwens wel een heel erg beta mod, versie 0.0.1 :o Meestal zijn die niet bedoelt voor gebruik op drukbezochte websites :wink:

Geplaatst: 15 feb 2005, 19:49
door Paul
bee schreef:Ik vind dit trouwens wel een heel erg beta mod, versie 0.0.1 :o Meestal zijn die niet bedoelt voor gebruik op drukbezochte websites :wink:
Zijn niet bijna alle mods beta?

Geplaatst: 15 feb 2005, 20:33
door Stefanouz
paulus schreef:er staan 2 komma's in de query naast elkaar. Haal er een weg en waarschijnlijk werkt het :D
waar? :roll: :?:

Geplaatst: 15 feb 2005, 20:34
door Paul
Daar:

Code: Selecteer alles

 user_Favo_color = '', ,

Geplaatst: 15 feb 2005, 21:33
door Stefanouz
ja, dat is in de error.

waar staat dat dan in de code? :? ben n00biej 8)

Geplaatst: 15 feb 2005, 22:25
door nielsiej
Stefanouz schreef:ja, dat is in de error.

waar staat dat dan in de code? :? ben n00biej 8)
Ergens in de code hierboven wat je moet plaatsen..

Zelfs ik weet dat nog.. :roll:

Geplaatst: 16 feb 2005, 10:29
door Stefanouz
ja, maar k kan niks vinden :(

Geplaatst: 16 feb 2005, 17:21
door Paul
Er staan 2 komma's en eentje daarvan moet je weghalen :roll:
(In usercp_register.php in de update qeury!)

Geplaatst: 17 feb 2005, 08:59
door Stefanouz
ja :bier: bedankt! het is gelukt, het werkt goed :thumb:

Geplaatst: 17 feb 2005, 12:13
door Stefanouz
iemand wou zich registreren en kreeg daarbij de volgende error:

Code: Selecteer alles

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_interests, user_Favo_muziek, user_Favo_film, user_Favo_tvserie, user_Favo_website, user_Favo_auto, user_Favo_artiest, user_Favo_color, user_sig, 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_rankset_id, user_dateformat, user_lang, user_style, user_level, user_allow_pm, user_birthday, user_next_birthday_greeting, user_active, user_actkey) VALUES (24, 'Anoniempje', 1108638762, 'f575ffaaa7951a92623cbdf807a8eca1', 'ik_ben_anoniem_anoniempje@hotmail.com', '', '', '', 'Den bosch', '', '', '', '', 0, 0, '', '', '', 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 'D M d, Y g:i a', 'dutch', 1, 0, 1, '6089', '2005', 1, '')

Line : 692
File : /opt/content/ertje.nl/HTML/phpBB2/includes/usercp_register.php
heb code nagekeke maar kan er maar niet achter kome wat er foiut aan zou kunnen zijn, weten jullie dit?

Geplaatst: 17 feb 2005, 12:15
door Paul
Ja het aantal kollomen is verschillend met het aantal in te voegen dingen.

Geplaatst: 17 feb 2005, 14:11
door Stefanouz
kolommen in database?

Geplaatst: 17 feb 2005, 14:43
door Paul
Neej in de query.

Geplaatst: 17 feb 2005, 14:51
door Stefanouz
wat bedoel je met query, ik snap er echt geen *** van :idea: :?:

Geplaatst: 17 feb 2005, 15:01
door Paul
Deze query:

Code: Selecteer alles

INSERT INTO phpbb_users (user_id, username, user_regdate, user_password, user_email, user_icq, user_website, user_occ, user_from, user_interests, user_Favo_muziek, user_Favo_film, user_Favo_tvserie, user_Favo_website, user_Favo_auto, user_Favo_artiest, user_Favo_color, user_sig, 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_rankset_id, user_dateformat, user_lang, user_style, user_level, user_allow_pm, user_birthday, user_next_birthday_greeting, user_active, user_actkey) VALUES (24, 'Anoniempje', 1108638762, 'f575ffaaa7951a92623cbdf807a8eca1', 'ik_ben_anoniem_anoniempje@hotmail.com', '', '', '', 'Den bosch', '', '', '', '', 0, 0, '', '', '', 1, 1, 1, 1, 1, 0, 1, 1, 1, 1, 'D M d, Y g:i a', 'dutch', 1, 0, 1, '6089', '2005', 1, '') 
Daar staan meer rijen in als dat er in worden gevoegt.

Geplaatst: 17 feb 2005, 20:03
door Stefanouz
dat snap ik niet...

forum gaat toch uit dit weekend ivm verhuizing van host en ik ga weekend weg, dus geen beheerder/moderator dan :)

Geplaatst: 24 feb 2005, 15:28
door Stefanouz
zou iemand voor me kunne kijke want ik snap er echt geen ene ***** van :(