Extra velden in profiel

Nymphy · Bericht door **Nymphy** » 03 mar 2005, 23:03

Ik heb net een aantal extra velden toegevoegd in het profiel..

maar het probleem is als volgt :

als ik mijn profiel wil editen zie ik niks staan naast de invoervelden (dus wat wat is)

als ik gewoon naar een profiel kijk zie ik ook alles staan

Maar in de admin als ik naar een profiel toe ga zie ik het er wel naast staan..

In de language files klopt verder alles.. maar in welke file mist nu iets ?

Stef · Bericht door **Stef** » 03 mar 2005, 23:06

In lang_main óf in usercp_register.php óf profile_add_body.tpl.
$lang[''] = ''; 'L_*' => $lang[''], {L_*}

Nymphy · Bericht door **Nymphy** » 03 mar 2005, 23:08

usercp_register heb ik dit in gezet :

Code: Selecteer alles

# 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 ]---------------------------------------------------
# 
, 'roken' => 'roken', 'broer' => 'broer', 'verkering' => 'verkering', 'auto' => 'auto', 'film' => 'film', 'game' => 'game', 'muziek' => 'muziek', 'kleur' => 'kleur', 'lied' => 'lied', 'huisdieren' => 'huisdieren'

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

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

# 
#-----[ IN-LINE ADD ]---------------------------------------------------
# 
, $roken, $broer, $verkering, $auto, $film, $game, $muziek, $kleur, $lied, $huisdieren

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

# 
#-----[ ADD BELOW ]---------------------------------------------------
# 
		$roken = stripslashes($roken);
		$broer = stripslashes($broer);
		$verkering = stripslashes($verkering);
		$auto = stripslashes($auto);
		$film = stripslashes($film);
		$game = stripslashes($game);
		$muziek = stripslashes($muziek);
		$kleur = stripslashes($kleur);
		$lied = stripslashes($lied);
		$huisdieren = stripslashes($huisdieren);

# 
#-----[ 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_roken = '" . str_replace("\'", "''", $roken) . "', user_broer = '" . str_replace("\'", "''", $broer) . "', user_verkering = '" . str_replace("\'", "''", $verkering) . "', user_auto = '" . str_replace("\'", "''", $auto) . "', user_film = '" . str_replace("\'", "''", $film) . "', user_game = '" . str_replace("\'", "''", $game) . "', user_muziek = '" . str_replace("\'", "''", $muziek) . "', user_kleur = '" . str_replace("\'", "''", $kleur) . "', user_lied = '" . str_replace("\'", "''", $lied) . "', user_huisdieren = '" . str_replace("\'", "''", $huisdieren) . "'


# 
#-----[ 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_roken, user_broer, user_verkering, user_auto, user_film, user_game, user_muziek, user_kleur, user_lied, user_huisdieren

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

# 
#-----[ IN-LINE ADD ]---------------------------------------------------
# 
, '" . str_replace("\'", "''", $roken) . "', '" . str_replace("\'", "''", $broer) . "', '" . str_replace("\'", "''", $verkering) . "', '" . str_replace("\'", "''", $auto) . "', '" . str_replace("\'", "''", $film) . "', '" . str_replace("\'", "''", $game) . "', '" . str_replace("\'", "''", $muziek) . "', '" . str_replace("\'", "''", $kleur) . "', '" . str_replace("\'", "''", $lied) . "', '" . str_replace("\'", "''", $huisdieren) . "'


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

# 
#-----[ ADD BELOW ]---------------------------------------------------
# 
	$roken = stripslashes($roken);
	$broer = stripslashes($broer);
	$verkering = stripslashes($verkering);
	$auto = stripslashes($auto);
	$film = stripslashes($film);
	$game = stripslashes($game);
	$muziek = stripslashes($muziek);
	$kleur = stripslashes($kleur);
	$lied = stripslashes($lied);
	$huisdieren = stripslashes($huisdieren);


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

# 
#-----[ ADD BELOW ]---------------------------------------------------
# 
	$roken = $userdata['user_roken'];
	$broer = $userdata['user_broer'];
	$verkering = $userdata['user_verkering'];
	$auto = $userdata['user_auto'];
	$film = $userdata['user_film'];
	$game = $userdata['user_game'];
	$muziek = $userdata['user_muziek'];
	$kleur = $userdata['user_kleur'];
	$lied = $userdata['user_lied'];
	$huisdieren = $userdata['user_huisdieren'];

# 
#-----[ 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 ]---------------------------------------------------
# 
, $roken, $broer, $verkering, $auto, $film, $game, $muziek, $kleur, $lied, $huisdieren

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

# 
#-----[ ADD BELOW ]---------------------------------------------------
# 
		'ROKEN' => $roken,
		'L_ROKEN' => $lang['Roken'],
		'BROER' => $broer,
		'L_BROER' => $lang['Broer'],
		'VERKERING' => $verkering,
		'L_VERKERING' => $lang['Verkering'],
		'AUTO' => $auto,
		'L_AUTO' => $lang['Auto'],
		'FILM' => $film,
		'L_FILM' => $lang['Film'],
		'GAME' => $game,
		'L_GAME' => $lang['Game'],
		'MUZIEK' => $muziek,
		'L_MUZIEK' => $lang['Muziek'],
		'KLEUR' => $kleur,
		'L_KLEUR' => $lang['Kleur'],
		'LIED' => $lied,
		'L_LIED' => $lang['Lied'],
		'HUISDIEREN' => $huisdieren,
		'L_HUISDIEREN' => $lang['Huisdieren'],

en in profiel_add_body dit :

Code: Selecteer alles

#-----[ 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> 
	  <td class="row1"><span class="gen">{L_ROKEN}:</span></td>
	  <td class="row2"> <input type="text" class="post"style="width: 200px"  name="car_mark" size="35" maxlength="150" value="{ROKEN}" /> </td>
	</tr>
	<tr> 
	  <td class="row1"><span class="gen">{L_BROER}:</span></td>
	  <td class="row2"> <input type="text" class="post"style="width: 200px"  name="car_model" size="35" maxlength="150" value="{BROER}" /> </td>
	</tr>
	<tr> 
	  <td class="row1"><span class="gen">{L_VERKERING}:</span></td>
	  <td class="row2"> <input type="text" class="post"style="width: 200px"  name="car_year" size="35" maxlength="150" value="{VERKERING}" /> </td>
	</tr>
	<tr> 
	  <td class="row1"><span class="gen">{L_AUTO}:</span></td>
	  <td class="row2"> <input type="text" class="post"style="width: 200px"  name="car_engine" size="35" maxlength="150" value="{AUTO}" /> </td>
	</tr>
	<tr> 
	  <td class="row1"><span class="gen">{L_FILM}:</span></td>
	  <td class="row2"> <input type="text" class="post"style="width: 200px"  name="car_wheel" size="35" maxlength="150" value="{FILM}" /> </td>
	</tr>
	<tr> 
	  <td class="row1"><span class="gen">{L_GAME}:</span></td>
	  <td class="row2"> <input type="text" class="post"style="width: 200px"  name="car_trans" size="35" maxlength="150" value="{GAME}" /> </td>
	</tr>
	<tr> 
	  <td class="row1"><span class="gen">{L_MUZIEK}:</span></td>
	  <td class="row2"> <input type="text" class="post"style="width: 200px"  name="car_color" size="35" maxlength="150" value="{MUZIEK}" /> </td>
	</tr>
	<tr> 
	  <td class="row1"><span class="gen">{L_KLEUR}:</span></td>
	  <td class="row2"> <input type="text" class="post"style="width: 200px"  name="car_foto" size="35" maxlength="150" value="{KLEUR}" /> </td>
	</tr>
	<tr> 
	  <td class="row1"><span class="gen">{L_LIED}:</span></td>
	  <td class="row2"> <input type="text" class="post"style="width: 200px"  name="car_foto" size="35" maxlength="150" value="{LIED}" /> </td>
	</tr>
	<tr> 
	  <td class="row1"><span class="gen">{L_HUISDIEREN}:</span></td>
	  <td class="row2"> <input type="text" class="post"style="width: 200px"  name="car_foto" size="35" maxlength="150" value="{HUISDIEREN}" /> </td>
	</tr>

in de lang file dit :

Code: Selecteer alles

#-----[ ADD BELOW ]---------------------------------------------------
# 
$lang['Roken'] = 'Rook je ?';
$lang['Broer'] = 'Broers/Zussen';
$lang['Verkering'] = 'Relatie/Single';
$lang['Auto'] = 'Favoriete Auto';
$lang['Film'] = 'Favoriete Film';
$lang['Game'] = 'Favoriete Game';
$lang['Muziek'] = 'Favoriete Muziek';
$lang['Kleur'] = 'Favoriete Kleur';
$lang['Lied'] = 'Lievelingslied';
$lang['Huisdieren'] = 'Huisdieren';

*edit* ik ontdek net nog een fout.. hij zet de gegevens ook niet in de db als ik ze via de admin invoer..

Dit heb ik ingegeven voor de DB te updaten :

Code: Selecteer alles

ALTER TABLE phpbb_users ADD user_roken VARCHAR(255) AFTER user_interests;
ALTER TABLE phpbb_users ADD user_broer VARCHAR(255) AFTER user_roken;
ALTER TABLE phpbb_users ADD user_verkering VARCHAR(255) AFTER user_broer;
ALTER TABLE phpbb_users ADD user_auto VARCHAR(255) AFTER user_verkering;
ALTER TABLE phpbb_users ADD user_film VARCHAR(255) AFTER user_auto;
ALTER TABLE phpbb_users ADD user_game VARCHAR(255) AFTER user_film;
ALTER TABLE phpbb_users ADD user_muziek VARCHAR(255) AFTER user_game;
ALTER TABLE phpbb_users ADD user_kleur VARCHAR(255) AFTER user_muziek;
ALTER TABLE phpbb_users ADD user_lied VARCHAR(255) AFTER user_kleur;
ALTER TABLE phpbb_users ADD user_huisdieren VARCHAR(255) AFTER user_lied;

Stef · Bericht door **Stef** » 03 mar 2005, 23:18

Die lang file neem ik aan dat het lang_main is?

Nymphy · Bericht door **Nymphy** » 03 mar 2005, 23:20

yup klopt

Nymphy · Bericht door **Nymphy** » 05 mar 2005, 16:07

Grotendeels is het nu opgelost.. (thnx to cheeta)

alleen als ik een van die velden bewerk en ik druk op ok gaat alles goed maar als ik dan weer mijn profiel ga bekijken staat er helemaal niets..

als ik in de db ga kijken staat er ook niets ingevuld..

dus op de een of andere manier voegt ie het niet toe in de db..

wie oh wie kan me helpen ?

Cheeta · Bericht door **Cheeta** » 05 mar 2005, 16:34

je was wat dingetje vergeten en paar kleine foutjes

nu moet alles werken waarneer ga je hem releasen

Nymphy · Bericht door **Nymphy** » 05 mar 2005, 16:40

releasen

jij bent gek