Translate
Sub Menu
Links Menu
Online Users

In total there are 59 users online :: 2 registered, 0 hidden and 57 guests

Most users ever online was 372 on Thu May 09, 2019 3:50 am

Registered users: Google [Bot], Majestic-12 [Bot] based on users active over the past 60 minutes

Last Online
In order to view the online list you have to be registered and logged in.



We are a free and open
community, all are welcome.

Click here to Register

[SOLVED] How to restore Anonymous user?

Looking for support for the IntegraMOD project? This is the forum for you!

Moderator: Integra Moderator

[SOLVED] How to restore Anonymous user?

PostAuthor: Waynder » Fri Feb 25, 2011 8:06 am

deleted it from phpmyadmin cuz i wasnt thinking straight =P


so if someone can give me code to run it in phpmyadmin so i can restore it?


thanx in advance

Waynder
Newbie
Newbie
 
Posts: 21
Joined: Sat Jun 16, 2007 9:46 am

Re: How to restore Anonymous user?

PostAuthor: Helter » Fri Feb 25, 2011 3:57 pm

this should do it
Code: Select all
INSERT INTO phpbb_users VALUES(-1, 0, 'Anonymous', '', 0, 0, 0, 1296601943, 0, 0, 0.00, NULL, '', '', 0, 0, 0, 0, 0, NULL, 0, 0, 0, 1, 1, 1, 1, 1, 0, 1, 0, 1, 0, NULL, '', 0, NULL, 0, '', '', '', '', '', NULL, '', '', '', NULL, '', '', '', '', 1, 1, 1, 1, 1, 1, 1, '0.0.0.0', 1, 0, 1, 0, 0, '0.0.0.0', '', 0, '0', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 15, 5, 1, 1, 1, 2, 2, 1, 1, 1, 1, 1, 0, 7, 1, 5, 1, 1, 3, 3, 3, 1, 1, 1, 1, 1, 0, 0, NULL, 15, NULL, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, '0', '0', '', '', 0, 0);
Image
Please do not PM for support
User avatar
Helter
Administrator
Administrator
 
Posts: 4125
Joined: Sat Mar 11, 2006 4:46 pm
Location: Seattle Wa

Re: How to restore Anonymous user?

PostAuthor: Waynder » Sat Feb 26, 2011 8:16 am

=/


damn


"
Code: Select all
#1136 - Column count doesn't match value count at row 1

Waynder
Newbie
Newbie
 
Posts: 21
Joined: Sat Jun 16, 2007 9:46 am

Re: How to restore Anonymous user?

PostAuthor: Helter » Sun Feb 27, 2011 5:17 pm

here is the full table/ youll have to compare and see if you have any additions (added mods) or if your missing anything (possibly a different version)

Code: Select all
--
-- Table structure for table 'phpbb_users'
--

CREATE TABLE phpbb_users (
  user_id mediumint(8) NOT NULL default '0',
  user_active tinyint(1) default '1',
  username varchar(25) NOT NULL default '',
  user_password varchar(32) NOT NULL default '',
  user_session_time int(11) NOT NULL default '0',
  user_session_page smallint(5) NOT NULL default '0',
  user_lastvisit int(11) NOT NULL default '0',
  user_regdate int(11) NOT NULL default '0',
  user_level tinyint(4) default '0',
  user_posts mediumint(8) unsigned NOT NULL default '0',
  user_timezone decimal(5,2) NOT NULL default '0.00',
  user_style tinyint(4) default NULL,
  user_lang varchar(255) default NULL,
  user_dateformat varchar(14) NOT NULL default 'd M Y H:i',
  user_new_privmsg smallint(5) unsigned NOT NULL default '0',
  user_unread_privmsg smallint(5) unsigned NOT NULL default '0',
  user_last_privmsg int(11) NOT NULL default '0',
  user_login_tries smallint(5) unsigned NOT NULL default '0',
  user_last_login_try int(11) NOT NULL default '0',
  user_emailtime int(11) default NULL,
  user_viewemail tinyint(1) default NULL,
  user_attachsig tinyint(1) default NULL,
  user_setbm tinyint(1) NOT NULL default '0',
  user_allowhtml tinyint(1) default '1',
  user_allowbbcode tinyint(1) default '1',
  user_allowsmile tinyint(1) default '1',
  user_allowavatar tinyint(1) NOT NULL default '1',
  user_allowphoto tinyint(1) NOT NULL default '1',
  user_allow_pm tinyint(1) NOT NULL default '1',
  user_allow_viewonline tinyint(1) NOT NULL default '1',
  user_notify tinyint(1) NOT NULL default '1',
  user_notify_pm tinyint(1) NOT NULL default '0',
  user_popup_pm tinyint(1) NOT NULL default '0',
  user_rank int(11) default '0',
  user_avatar varchar(100) default NULL,
  user_avatar_type tinyint(4) NOT NULL default '0',
  user_photo varchar(100) default NULL,
  user_photo_type tinyint(4) NOT NULL default '0',
  user_email varchar(255) default NULL,
  user_icq varchar(15) default NULL,
  user_website varchar(100) default NULL,
  user_from varchar(100) default NULL,
  user_sig text,
  user_sig_bbcode_uid varchar(10) default NULL,
  user_aim varchar(255) default NULL,
  user_yim varchar(255) default NULL,
  user_msnm varchar(255) default NULL,
  user_skype varchar(255) default NULL,
  user_occ varchar(100) default NULL,
  user_interests varchar(255) default NULL,
  user_actkey varchar(32) default NULL,
  user_newpasswd varchar(32) default NULL,
  ct_search_time int(11) default '1',
  ct_search_count mediumint(8) default '1',
  ct_last_mail int(11) default '1',
  ct_last_post int(11) default '1',
  ct_post_counter mediumint(8) default '1',
  ct_last_pw_reset int(11) default '1',
  ct_enable_ip_warn tinyint(1) default '1',
  ct_last_used_ip varchar(16) default '0.0.0.0',
  ct_login_count mediumint(8) default '1',
  ct_login_vconfirm tinyint(1) default '0',
  ct_last_pw_change int(11) default '1',
  ct_global_msg_read tinyint(1) default '0',
  ct_miserable_user tinyint(1) default '0',
  ct_last_ip varchar(16) default '0.0.0.0',
  user_realname varchar(25) NOT NULL default '',
  user_gender tinyint(1) unsigned NOT NULL default '0',
  user_birthday varchar(8) NOT NULL default '0',
  user_last_birthday int(11) unsigned NOT NULL default '0',
  user_home_phone varchar(20) default NULL,
  user_home_fax varchar(20) default NULL,
  user_work_phone varchar(20) default NULL,
  user_work_fax varchar(20) default NULL,
  user_cellular varchar(20) default NULL,
  user_pager varchar(20) default NULL,
  user_summer_time tinyint(1) unsigned NOT NULL default '0',
  user_list_option varchar(255) default NULL,
  user_allow_email tinyint(1) NOT NULL default '1',
  user_allow_website tinyint(1) NOT NULL default '1',
  user_allow_messenger tinyint(1) NOT NULL default '1',
  user_allow_real tinyint(1) NOT NULL default '1',
  user_allow_sig tinyint(1) NOT NULL default '1',
  user_viewpm tinyint(1) NOT NULL default '1',
  user_viewwebsite tinyint(1) NOT NULL default '1',
  user_viewmessenger tinyint(1) NOT NULL default '1',
  user_viewreal tinyint(1) NOT NULL default '1',
  user_viewavatar tinyint(1) NOT NULL default '1',
  user_viewphoto tinyint(1) NOT NULL default '1',
  user_viewsig tinyint(1) NOT NULL default '1',
  user_viewimg tinyint(1) NOT NULL default '1',
  user_buddy_friend_display tinyint(1) default '1',
  user_buddy_ignore_display tinyint(1) default '1',
  user_buddy_friend_of_display tinyint(1) default '1',
  user_buddy_ignored_by_display tinyint(1) default '1',
  user_watched_topics_per_page smallint(3) default '15',
  user_privmsgs_per_page smallint(3) default '5',
  user_sub_forum tinyint(1) NOT NULL default '1',
  user_split_cat tinyint(1) NOT NULL default '1',
  user_last_topic_title tinyint(1) NOT NULL default '1',
  user_sub_level_links tinyint(1) NOT NULL default '2',
  user_display_viewonline tinyint(1) NOT NULL default '2',
  user_announcement_date_display tinyint(1) NOT NULL default '1',
  user_announcement_display tinyint(1) NOT NULL default '1',
  user_announcement_display_forum tinyint(1) NOT NULL default '1',
  user_announcement_split tinyint(1) NOT NULL default '1',
  user_announcement_forum tinyint(1) NOT NULL default '1',
  user_calendar_display_open tinyint(1) NOT NULL default '0',
  user_calendar_header_cells tinyint(1) NOT NULL default '7',
  user_fdow tinyint(1) NOT NULL default '1',
  user_calendar_nb_row tinyint(2) unsigned NOT NULL default '5',
  user_calendar_birthday tinyint(1) NOT NULL default '1',
  user_calendar_forum tinyint(1) NOT NULL default '1',
  user_last_topics_from_started tinyint(2) NOT NULL default '3',
  user_last_topics_from_replied tinyint(2) NOT NULL default '3',
  user_last_topics_from_ended tinyint(2) NOT NULL default '3',
  user_last_topics_from_split tinyint(1) NOT NULL default '1',
  user_last_topics_from_forum tinyint(1) NOT NULL default '1',
  user_split_global_announce tinyint(1) NOT NULL default '1',
  user_split_announce tinyint(1) NOT NULL default '1',
  user_split_sticky tinyint(1) NOT NULL default '1',
  user_split_topic_split tinyint(1) NOT NULL default '0',
  user_points decimal(11,0) NOT NULL default '0',
  user_unread_topics text,
  user_topics_last_per_page smallint(2) NOT NULL default '15',
  user_flag varchar(25) default NULL,
  user_holidays tinyint(1) unsigned NOT NULL default '2',
  user_warnings smallint(5) default '0',
  user_rules int(11) NOT NULL default '0',
  rating_status tinyint(3) unsigned NOT NULL default '0',
  user_extra tinyint(2) NOT NULL default '0',
  user_allowsignature tinyint(1) NOT NULL default '1',
  user_actviate_date int(11) default '0',
  user_expire_date int(11) default '0',
  user_inactive_emls tinyint(1) NOT NULL default '0',
  user_inactive_last_eml int(11) NOT NULL default '0',
  user_state varchar(3) NOT NULL default '0',
  user_country varchar(3) NOT NULL default '0',
  phpBBSecurity_answer text NOT NULL,
  phpBBSecurity_question text NOT NULL,
  phpBBSecurity_login_tries smallint(5) NOT NULL default '0',
  phpBBSecurity_pm_sent smallint(1) NOT NULL default '0',
  PRIMARY KEY  (user_id),
  KEY user_session_time (user_session_time)
) ENGINE=MyISAM DEFAULT CHARSET=latin1;

--
-- Dumping data for table 'phpbb_users'
--

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_login_tries, user_last_login_try, user_emailtime, user_viewemail, user_attachsig, user_setbm, user_allowhtml, user_allowbbcode, user_allowsmile, user_allowavatar, user_allowphoto, user_allow_pm, user_allow_viewonline, user_notify, user_notify_pm, user_popup_pm, user_rank, user_avatar, user_avatar_type, user_photo, user_photo_type, user_email, user_icq, user_website, user_from, user_sig, user_sig_bbcode_uid, user_aim, user_yim, user_msnm, user_skype, user_occ, user_interests, user_actkey, user_newpasswd, ct_search_time, ct_search_count, ct_last_mail, ct_last_post, ct_post_counter, ct_last_pw_reset, ct_enable_ip_warn, ct_last_used_ip, ct_login_count, ct_login_vconfirm, ct_last_pw_change, ct_global_msg_read, ct_miserable_user, ct_last_ip, user_realname, user_gender, user_birthday, user_last_birthday, user_home_phone, user_home_fax, user_work_phone, user_work_fax, user_cellular, user_pager, user_summer_time, user_list_option, user_allow_email, user_allow_website, user_allow_messenger, user_allow_real, user_allow_sig, user_viewpm, user_viewwebsite, user_viewmessenger, user_viewreal, user_viewavatar, user_viewphoto, user_viewsig, user_viewimg, user_buddy_friend_display, user_buddy_ignore_display, user_buddy_friend_of_display, user_buddy_ignored_by_display, user_watched_topics_per_page, user_privmsgs_per_page, user_sub_forum, user_split_cat, user_last_topic_title, user_sub_level_links, user_display_viewonline, user_announcement_date_display, user_announcement_display, user_announcement_display_forum, user_announcement_split, user_announcement_forum, user_calendar_display_open, user_calendar_header_cells, user_fdow, user_calendar_nb_row, user_calendar_birthday, user_calendar_forum, user_last_topics_from_started, user_last_topics_from_replied, user_last_topics_from_ended, user_last_topics_from_split, user_last_topics_from_forum, user_split_global_announce, user_split_announce, user_split_sticky, user_split_topic_split, user_points, user_unread_topics, user_topics_last_per_page, user_flag, user_holidays, user_warnings, user_rules, rating_status, user_extra, user_allowsignature, user_actviate_date, user_expire_date, user_inactive_emls, user_inactive_last_eml, user_state, user_country, phpBBSecurity_answer, phpBBSecurity_question, phpBBSecurity_login_tries, phpBBSecurity_pm_sent) VALUES
(-1, 0, 'Anonymous', '', 0, 0, 0, 1296601943, 0, 0, 0.00, NULL, '', '', 0, 0, 0, 0, 0, NULL, 0, 0, 0, 1, 1, 1, 1, 1, 0, 1, 0, 1, 0, NULL, '', 0, NULL, 0, '', '', '', '', '', NULL, '', '', '', NULL, '', '', '', '', 1, 1, 1, 1, 1, 1, 1, '0.0.0.0', 1, 0, 1, 0, 0, '0.0.0.0', '', 0, '0', 0, NULL, NULL, NULL, NULL, NULL, NULL, 0, NULL, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 1, 15, 5, 1, 1, 1, 2, 2, 1, 1, 1, 1, 1, 0, 7, 1, 5, 1, 1, 3, 3, 3, 1, 1, 1, 1, 1, 0, 0, NULL, 15, NULL, 2, 0, 0, 0, 0, 1, 0, 0, 0, 0, '0', '0', '', '', 0, 0),
Image
Please do not PM for support
User avatar
Helter
Administrator
Administrator
 
Posts: 4125
Joined: Sat Mar 11, 2006 4:46 pm
Location: Seattle Wa

Re: How to restore Anonymous user?

PostAuthor: Waynder » Mon Feb 28, 2011 12:13 am

cant get it to work...

oke... it doesnt have to work...
problem is that i cant got on my site now to extract articles that i have in KB... im doing whole new site in stargate now and would like to use old articles...

any other way to get that?

Waynder
Newbie
Newbie
 
Posts: 21
Joined: Sat Jun 16, 2007 9:46 am

Re: How to restore Anonymous user?

PostAuthor: Helter » Mon Feb 28, 2011 1:02 pm

go through your db and find another inactive user. Youll know they are inactive by the second entry. It should be 0. Edit this user to be anonymous.
the most critical of the entries will be the first 4 however you should copy the first 10 to be sure your nor assigning posts to your anonymous user

user_id,
user_active,
username,
user_password,
user_session_time,
user_session_page,
user_lastvisit,
user_regdate,
user_level,
user_posts,

-1, 0, 'Anonymous', '', 0, 0, 0, 1296601943, 0, 0,
Image
Please do not PM for support
User avatar
Helter
Administrator
Administrator
 
Posts: 4125
Joined: Sat Mar 11, 2006 4:46 pm
Location: Seattle Wa

Re: How to restore Anonymous user?

PostAuthor: Waynder » Tue Mar 01, 2011 1:34 am

nice idea....

its working.... thanx a million <img>

Waynder
Newbie
Newbie
 
Posts: 21
Joined: Sat Jun 16, 2007 9:46 am

Re: How to restore Anonymous user?

PostAuthor: Helter » Tue Mar 01, 2011 8:56 am

your welcome. Im glad you got it solved
Image
Please do not PM for support
User avatar
Helter
Administrator
Administrator
 
Posts: 4125
Joined: Sat Mar 11, 2006 4:46 pm
Location: Seattle Wa


Return to IntegraMOD Support Forum

Who is online

Registered users: Google [Bot], Majestic-12 [Bot]

cron