veranderingen in acp profiel
Forumregels
Sinds 1 januari 2009 wordt phpBB2 niet meer ondersteund.
Onderstaande informatie is verouderd en dient uitsluitend als archief.
Sinds 1 januari 2009 wordt phpBB2 niet meer ondersteund.
Onderstaande informatie is verouderd en dient uitsluitend als archief.

Ik zie niet 123 ets verkeerd, maar probeer eens uit of hij wel de update querrie uitvoert:
Zet achter
en kijk dan of je die tekst te zien krijgt als je een profiel update.
Zet achter
Code: Selecteer alles
// Update entry in DB
//
if( !$error )
{Code: Selecteer alles
print("Update zou uitgevoerd moeten worden!<br />");kep hem hierin gezet:
ik weet niet of hij goed staat. En waar staat database update? 
Code: Selecteer alles
$sql = "UPDATE " . USERS_TABLE . "
[b]print($sql);[/b]
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_profile_view_popup = $profile_view_popup, user_birthday='$birthday', user_next_birthday_greeting=$next_birthday_greeting, 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_notes_mail = $notes_mail, 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, profile = '$profiel', may_profile = '$profiel_mag', profile_on = '$profiel_aan', $user_gender = '$gender'" . $avatar_sql . "
WHERE user_id = $user_id";
Okee nu heb ik hem hier neergezet.. kan best zijn dat hij weer fout staat, sorry
Code: Selecteer alles
if( $result = $db->sql_query($sql) )
{
if( isset($rename_user) )
{
$sql = "UPDATE " . GROUPS_TABLE . "
SET group_name = '".str_replace("\'", "''", $rename_user)."'
WHERE group_name = '".str_replace("'", "''", $this_userdata['username'] )."'";
if( !$result = $db->sql_query($sql) )print($sql);
{
message_die(GENERAL_ERROR, 'Could not rename users group', '', __LINE__, __FILE__, $sql);
}
}Code: Selecteer alles
if( !$result = $db->sql_query($sql) )print($sql);
{
message_die(GENERAL_ERROR, 'Could not rename users group', '', __LINE__, __FILE__, $sql);
} Code: Selecteer alles
if( !$result = $db->sql_query($sql) );
{
message_die(GENERAL_ERROR, 'Could not rename users group', '', __LINE__, __FILE__, $sql);
}
print($sql);ik heb hem in verschillende posities gezet, onder de { tag, er achter enz.. maar ik zie helemaal geen effect, ik snap er zelf niets van. ik heb hem zo staan:
Code: Selecteer alles
if( $result = $db->sql_query($sql) )
{
if( isset($rename_user) )
{
$sql = "UPDATE " . GROUPS_TABLE . "
SET group_name = '".str_replace("\'", "''", $rename_user)."'
WHERE group_name = '".str_replace("'", "''", $this_userdata['username'] )."'";
if( !$result = $db->sql_query($sql) )
{
message_die(GENERAL_ERROR, 'Could not rename users group', '', __LINE__, __FILE__, $sql);
}
}
print($sql);Nee daar moet ie ook niet, had zelf ook niet goed opgelet zag ik
. Maar het is alleen maar bedoeld om te kijken wat hij precies als querrie opgeeft, het lost (nog) niks op.
Dat moet boven
Dat moet boven
Code: Selecteer alles
if( $result = $db->sql_query($sql) )
{
if( isset($rename_user) )En toen kwam dit
:
Code: Selecteer alles
UPDATE phpbb_users SET user_email = 'Truud17@gmail.com', user_icq = '', user_website = 'http://www.unchallenged.nl', user_occ = 'Webdesigner', user_from = 'Groningen', user_interests = 'Computer, Lezen, Film kijken, Muziek luisteren, Stadten, Vrienden', user_profile_view_popup = 1, user_birthday='999999', user_next_birthday_greeting=0, user_sig = '[img:1807305872]http://www.unexpected-fate.net/pictures-of-you/ew/amyLJ002.gif[/img:1807305872]', user_viewemail = 1, user_aim = '', user_yim = '', user_msnm = 'Truud17@gmail.com', user_attachsig = 1, user_sig_bbcode_uid = '1807305872', user_allowsmile = 1, user_allowhtml = 0, user_allowavatar = 1, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_allow_pm = 1, user_notes_mail = 1, user_notify_pm = 1, user_popup_pm = 1, user_lang = 'dutch', user_style = 2, user_timezone = 2, user_dateformat = 'D d M Y H:i', user_active = 1, user_rank = 1, profile = '
Naam: Trudy
Woonplaats: Groningen
Leeftijd: 18
Obsessies: Computer, Games, Films, Muziek, Shoppen
Place: New Zealand
Favo Tv series:
Angel/Buffy/Charmed/Dawsons-creek/24/CSI/Roswell/Joan-of-Arcadia/Smallville/Numb3rs/Dead-like-me/Without-a-trace/Point-pleasant/Tru-calling/The-oc/Lost/Everwood
Favo Films:
Lord of the rings
Favo Songtekst:
Who can say
where the road goes
where the day flows
- only time
And who can say
if your love grows
as your heart chose
- only time
Who can say
why your heart sighs
as your love flies
- only time
And who can say
why your heart cries
when your love lies
- only time
Who can say
when the roads meet
that love might be
in your heart
And who can say
when the day sleeps
if the night keeps
all your heart
Night keeps all your heart
Who can say
if your love grows
as your heart chose
- only time
And who can say
where the road goes
where the day flows
- only time
Who knows - only time
Who knows - only time', may_profile = '1', profile_on = '1', = '1' WHERE user_id = 2