aangepaste car-mod mysql probleem

Hulp nodig bij een modificaties of op zoek naar een MOD? Bekijk ons archief. Support wordt helaas niet meer verleend.
Forumregels

Sinds 1 januari 2009 wordt phpBB2 niet meer ondersteund.
Onderstaande informatie is verouderd en dient uitsluitend als archief.phpBB2.0.x
Gesloten
Stefanouz
Berichten: 76
Lid geworden op: 01 jan 2005, 10:40

aangepaste car-mod mysql probleem

Bericht door Stefanouz » 15 feb 2005, 19:26

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>
	


###################################################################################
Omhoog
Gebruikersavatar
Paul
Beheerder
Beheerder
Berichten: 20315
Lid geworden op: 23 okt 2003, 11:38
Locatie: Utrecht
Contacteer:
Contacteer Paul

Bericht door Paul » 15 feb 2005, 19:32

er staan 2 komma's in de query naast elkaar. Haal er een weg en waarschijnlijk werkt het :D
Omhoog
Gebruikersavatar
Bee
Berichten: 13403
Lid geworden op: 29 aug 2004, 10:30

Bericht door Bee » 15 feb 2005, 19:38

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:
... Maar ik modereer (nog) niet.
Omhoog
Gebruikersavatar
Paul
Beheerder
Beheerder
Berichten: 20315
Lid geworden op: 23 okt 2003, 11:38
Locatie: Utrecht
Contacteer:
Contacteer Paul

Bericht door Paul » 15 feb 2005, 19:49

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?
Omhoog
Stefanouz
Berichten: 76
Lid geworden op: 01 jan 2005, 10:40

Bericht door Stefanouz » 15 feb 2005, 20:33

paulus schreef:er staan 2 komma's in de query naast elkaar. Haal er een weg en waarschijnlijk werkt het :D
waar? :roll: :?:
Omhoog
Gebruikersavatar
Paul
Beheerder
Beheerder
Berichten: 20315
Lid geworden op: 23 okt 2003, 11:38
Locatie: Utrecht
Contacteer:
Contacteer Paul

Bericht door Paul » 15 feb 2005, 20:34

Daar:

Code: Selecteer alles

 user_Favo_color = '', ,
Omhoog
Stefanouz
Berichten: 76
Lid geworden op: 01 jan 2005, 10:40

Bericht door Stefanouz » 15 feb 2005, 21:33

ja, dat is in de error.

waar staat dat dan in de code? :? ben n00biej 8)
Omhoog
nielsiej
Berichten: 86
Lid geworden op: 16 jan 2005, 09:36

Bericht door nielsiej » 15 feb 2005, 22:25

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:
Omhoog
Stefanouz
Berichten: 76
Lid geworden op: 01 jan 2005, 10:40

Bericht door Stefanouz » 16 feb 2005, 10:29

ja, maar k kan niks vinden :(
Omhoog
Gebruikersavatar
Paul
Beheerder
Beheerder
Berichten: 20315
Lid geworden op: 23 okt 2003, 11:38
Locatie: Utrecht
Contacteer:
Contacteer Paul

Bericht door Paul » 16 feb 2005, 17:21

Er staan 2 komma's en eentje daarvan moet je weghalen :roll:
(In usercp_register.php in de update qeury!)
Omhoog
Stefanouz
Berichten: 76
Lid geworden op: 01 jan 2005, 10:40

Bericht door Stefanouz » 17 feb 2005, 08:59

ja :bier: bedankt! het is gelukt, het werkt goed :thumb:
Omhoog
Stefanouz
Berichten: 76
Lid geworden op: 01 jan 2005, 10:40

Bericht door Stefanouz » 17 feb 2005, 12:13

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?
Omhoog
Gebruikersavatar
Paul
Beheerder
Beheerder
Berichten: 20315
Lid geworden op: 23 okt 2003, 11:38
Locatie: Utrecht
Contacteer:
Contacteer Paul

Bericht door Paul » 17 feb 2005, 12:15

Ja het aantal kollomen is verschillend met het aantal in te voegen dingen.
Omhoog
Stefanouz
Berichten: 76
Lid geworden op: 01 jan 2005, 10:40

Bericht door Stefanouz » 17 feb 2005, 14:11

kolommen in database?
Omhoog
Gebruikersavatar
Paul
Beheerder
Beheerder
Berichten: 20315
Lid geworden op: 23 okt 2003, 11:38
Locatie: Utrecht
Contacteer:
Contacteer Paul

Bericht door Paul » 17 feb 2005, 14:43

Neej in de query.
Omhoog
Stefanouz
Berichten: 76
Lid geworden op: 01 jan 2005, 10:40

Bericht door Stefanouz » 17 feb 2005, 14:51

wat bedoel je met query, ik snap er echt geen *** van :idea: :?:
Omhoog
Gebruikersavatar
Paul
Beheerder
Beheerder
Berichten: 20315
Lid geworden op: 23 okt 2003, 11:38
Locatie: Utrecht
Contacteer:
Contacteer Paul

Bericht door Paul » 17 feb 2005, 15:01

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.
Omhoog
Stefanouz
Berichten: 76
Lid geworden op: 01 jan 2005, 10:40

Bericht door Stefanouz » 17 feb 2005, 20:03

dat snap ik niet...

forum gaat toch uit dit weekend ivm verhuizing van host en ik ga weekend weg, dus geen beheerder/moderator dan :)
Omhoog
Stefanouz
Berichten: 76
Lid geworden op: 01 jan 2005, 10:40

Bericht door Stefanouz » 24 feb 2005, 15:28

zou iemand voor me kunne kijke want ik snap er echt geen ene ***** van :(
Omhoog
Gesloten

Terug naar “2.0 Modificaties”