2.x/Gastgebruiker verwijderd: verschil tussen versies
Uit phpBB.nl Wiki
k |
|||
| Regel 1: | Regel 1: | ||
| − | + | Om een abusievelijk verwijderde gastgebruiker in [[phpBB2]] opnieuw toe te voegen voer je naar je database manager en voer je de volgende SQL query uit: | |
| − | <code sql>INSERT INTO phpbb_users (user_id, user_active, username, user_password, user_session_time, user_session_page, user_lastvisit, user_regdate, user_level, user_posts, user_timezone, user_style, user_lang, user_dateformat, user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_emailtime, user_viewemail, user_attachsig, user_allowhtml, user_allowbbcode, user_allowsmile, user_allowavatar, user_allow_pm, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_rank, user_avatar, user_avatar_type, user_email, user_icq, user_website, user_from, user_sig, user_sig_bbcode_uid, user_aim, user_yim, user_msnm, user_occ, user_interests, user_actkey, user_newpasswd) VALUES('-1', '0', 'Anonymous', '', '0', '0', '0', '1082539867', '0', '0', '0.00', NULL, '', '', '0', '0', '0', NULL, '0', '0', '1', '1', '1', '1', '0', '1', '0', '1', '0', NULL, '', '0', '', '', '', '', '', NULL, '', '', '', '', '', '', '');</code> | + | <code sql>INSERT INTO phpbb_users ( |
| + | user_id, user_active, username, user_password, user_session_time, user_session_page, | ||
| + | user_lastvisit, user_regdate, user_level, user_posts, user_timezone, user_style, user_lang, user_dateformat, | ||
| + | user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_emailtime, user_viewemail, user_attachsig, | ||
| + | user_allowhtml, user_allowbbcode, user_allowsmile, user_allowavatar, user_allow_pm, user_allow_viewonline, | ||
| + | user_notify, user_notify_pm, user_popup_pm, user_rank, user_avatar, user_avatar_type, user_email, user_icq, | ||
| + | user_website, user_from, user_sig, user_sig_bbcode_uid, user_aim, user_yim, user_msnm, user_occ, user_interests, | ||
| + | user_actkey, user_newpasswd) | ||
| + | VALUES('-1', '0', 'Anonymous', '', '0', '0', '0', '1082539867', '0', '0', '0.00', NULL, | ||
| + | '', '', '0', '0', '0', NULL, '0', '0', '1', '1', '1', '1', '0', '1', '0', '1', '0', NULL, '', '0', '', '', '', '', | ||
| + | '', NULL, '', '', '', '', '', '', '');</code> | ||
| − | Als je een andere prefix gebruikt, moet je die natuurlijk veranderen, vergeet dit niet! | + | Als je een andere database-prefix gebruikt (hier ''phpbb_'') , moet je die natuurlijk veranderen, vergeet dit niet! |
[[Categorie:PhpBB2]] | [[Categorie:PhpBB2]] | ||
[[Categorie:Beheer]] | [[Categorie:Beheer]] | ||
Versie van 25 mrt 2009 om 11:41
Om een abusievelijk verwijderde gastgebruiker in phpBB2 opnieuw toe te voegen voer je naar je database manager en voer je de volgende SQL query uit:
INSERT INTO phpbb_users (
user_id, user_active, username, user_password, user_session_time, user_session_page,
user_lastvisit, user_regdate, user_level, user_posts, user_timezone, user_style, user_lang, user_dateformat,
user_new_privmsg, user_unread_privmsg, user_last_privmsg, user_emailtime, user_viewemail, user_attachsig,
user_allowhtml, user_allowbbcode, user_allowsmile, user_allowavatar, user_allow_pm, user_allow_viewonline,
user_notify, user_notify_pm, user_popup_pm, user_rank, user_avatar, user_avatar_type, user_email, user_icq,
user_website, user_from, user_sig, user_sig_bbcode_uid, user_aim, user_yim, user_msnm, user_occ, user_interests,
user_actkey, user_newpasswd)
VALUES('-1', '0', 'Anonymous', , '0', '0', '0', '1082539867', '0', '0', '0.00', NULL,
, , '0', '0', '0', NULL, '0', '0', '1', '1', '1', '1', '0', '1', '0', '1', '0', NULL, , '0', , , , ,
, NULL, , , , , , , );
Als je een andere database-prefix gebruikt (hier phpbb_) , moet je die natuurlijk veranderen, vergeet dit niet!
