Speciale rank toevoegen?

[Orange Paradise]

:s wrom kan het niet over msn dan
anyway wat moet ik doen dan om het op te lossen?
Ik ben al geen held met mods installeren ik heb alleen de heel makkelijke gedaan..

[Paul]

Geef admin_users.php eens in een tekstbestand, en de link hier.

[Orange Paradise]

http://www.forum.vonne85.nl

http://www.vonne85.nl/other/admin_users.txt

[Paul]

maak van

Code: Selecteer alles

				$error = TRUE;
				$error_msg .= ( ( isset($error_msg) ) ? '<br />' : '' ) . $lang['Admin_user_fail'];

eens

Code: Selecteer alles

message_die(GENERAL_ERROR,"Could not run query","",__LINE__,__FILE__,$sql);

En zeg wat je dan ziet.

[Orange Paradise]

Code: Selecteer alles

Could not run query

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ''2 WHERE user_id = 3' at line 2

UPDATE phpbb_users SET user_email = 'orange.sunrise85@gmail.com', user_icq = '', user_website = 'http://www.vonne85.nl', user_occ = 'Productie medewerker & assistent turnen', user_from = 'B''veld', user_interests = 'Me moppie!! , turnen, lesgeven met turnen, kids, rollercoasters, prutsen op comp', user_birthday='5607', user_next_birthday_greeting=2007, user_sig = ':giveheart: [* I (L) My Beertje*] :giveheart: [img:7234c60506]http://www.vonne85.nl/other/missangel.jpg[/img:7234c60506]', user_viewemail = 0, user_aim = '', user_yim = '', user_msnm = 'Ask me!', user_attachsig = 1, user_sig_bbcode_uid = '7234c60506', user_allowsmile = 1, user_allowhtml = 1, user_allowavatar = 1, user_allowbbcode = 1, user_allow_viewonline = 1, user_notify = 0, user_allow_pm = 1, user_notify_pm = 1, user_popup_pm = 1, user_lang = 'dutch', user_style = 4, user_timezone = 2, user_dateformat = 'D M d, Y g:i a', user_active = 1, user_rank = 1, user_gender = '2 WHERE user_id = 3

Line : 737
File : admin_users.php

[Paul]

Zoek:

Code: Selecteer alles

				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_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_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, user_gender = '$gender" . $avatar_sql . "
				WHERE user_id = $user_id";

vervang met:

Code: Selecteer alles

				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_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_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, user_gender = '$gender'" . $avatar_sql . "
				WHERE user_id = $user_id";

[Orange Paradise]

Heel erg bedankt! hij doet het
Is het updaten van phpbb erg moeilijk? is er hier miss een tutorial over ofzo?
Gaan de mods eigenlijk verloren dan?

[Paul]

http://www.phpbb.nl/kb.php?mode=article&k=113

[Orange Paradise]

Gaan de mods verloren als je em update?

[Paul]

Lees die link

[Orange Paradise]

ik had het al gelezen sorry

[Orange Paradise]

Weet iemand nog een oplossing voor het feit dat als je het forum opgaat en ej leest 1 post dat ie gelijk alles als gelezen aangeeft...?

[Paul]

Hoe staan je cookie instellingen in admin?

[Orange Paradise]

Cookie domein: staat niets
Cookie naam: phpbb2mysql
Cookie pad: /
Cookie secure [ https ]
Zet deze optie alleen aan als je server gebruik maakt van SSL: Uitschakelen
Sessie lengte [ seconds ] 3600

[Bee]

Copyright van Iris ontbreekt -> geen recht op support. Neem contact op met een moderator als het weer in orde is.