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
Moderator: Integra Moderator
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);
--
-- 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),
Registered users: Google [Bot], Helter, Unspecified Bot