Welcome to all phpBB2 Refugees!This site is intended to continue support for the legacy 2.x line of the phpBB2 bulletin board package. If you are a fan of phpBB2, please, by all means register, post, and help us out by offering your suggestions. We are primarily a community and support network. Our secondary goal is to provide a phpBB2 MOD Author and Styles area. |
|
Author |
Message |
Sylver Cheetah 53 Board Member
Joined: 17 Dec 2008
Posts: 426 Location: Milky Way
|
Posted: Sat Dec 27, 2008 8:55 am Post subject: Undo Delete Users |
|
|
There is an MOD out there for undoing a delete user by mistake? _________________ Image link
My Forum || My Blog
phpBB2 forever! |
|
Back to top |
|
|
Ram Board Member
Joined: 23 Dec 2008
Posts: 100 Location: Somewhere over the rainbow
|
Posted: Sat Dec 27, 2008 9:10 am Post subject: Re: Undo Delete Users |
|
|
Did you have a recent save of your database? |
|
Back to top |
|
|
Sylver Cheetah 53 Board Member
Joined: 17 Dec 2008
Posts: 426 Location: Milky Way
|
Posted: Sat Dec 27, 2008 10:00 am Post subject: Re: Undo Delete Users |
|
|
Yes, I have lots of databases. Also, I have a database for about a week ago installed on my computer, and that user did not post in that period of time, so it should be no changes. I guess I could take him (usr ID 9) from the phpMyAdmin, but I am not sure how, and then how to import him on my board.
LATER EDIT: I've looked into phpbb_users table and I've found the user. When I click on EXPORT, I get this:
Code: | -- phpMyAdmin SQL Dump
-- version 2.11.9.2
-- http://www.phpmyadmin.net
--
-- Host: localhost
-- Generation Time: Dec 27, 2008 at 04:03 PM
-- Server version: 5.0.67
-- PHP Version: 5.2.6
SET SQL_MODE="NO_AUTO_VALUE_ON_ZERO";
--
-- Database: `friends3`
--
-- --------------------------------------------------------
--
-- Table structure for table `phpbb_users`
--
CREATE TABLE IF NOT EXISTS `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_emailtime` int(11) default NULL,
`user_viewemail` tinyint(1) default NULL,
`user_attachsig` tinyint(1) default NULL,
`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_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_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_occ` varchar(100) default NULL,
`user_interests` varchar(255) default NULL,
`user_actkey` varchar(32) default NULL,
`user_newpasswd` varchar(32) default NULL,
`user_login_tries` smallint(5) unsigned NOT NULL default '0',
`user_last_login_try` int(11) NOT NULL default '0',
`user_unread_topics` text,
`user_show_quickreply` tinyint(1) NOT NULL default '1',
`user_quickreply_mode` tinyint(1) NOT NULL default '1',
`user_open_quickreply` tinyint(1) NOT NULL default '1',
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_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`, `user_login_tries`, `user_last_login_try`, `user_unread_topics`, `user_show_quickreply`, `user_quickreply_mode`, `user_open_quickreply`) VALUES
(9, 1, 'Lavy''s', 'a4071a733524830eda22d91b06b9c91c', 1199203300, 0, 1197656194, 1148210741, 1, 598, 3.00, 91, 'romanian', 'd.m.Y H:i', 2, 0, 1227797496, NULL, 1, 1, 1, 1, 1, 1, 1, 0, 0, 1, 1, 28, 'http://i11.tinypic.com/2py7zma.jpg', 2, 'lavinia_16a@yahoo.com', '299315917', 'http://friendsforever.myforum.ro/', 'On the highest place of your heart !!!', '[img:7dcc81e5fd]http://i10.tinypic.com/2zsd2f8.jpg[/img:7dcc81e5fd]', '7dcc81e5fd', 'laviniutza_lavy', 'lavinia_16a@yahoo.com', 'LavysLav@hotmail.com', 'Love is a Force of Nature !!!', 'See California and Hermosa Beach .', '', NULL, 0, 0, '1197656194;305:0;323:0;226:0;74:0;320:0;179:0;194:0;30:0;33:0;173:1546893;166:1546991//1199203060//', 1, 1, 1); |
If I import it to my online board, it should work? There are no risks? _________________ Image link
My Forum || My Blog
phpBB2 forever! |
|
Back to top |
|
|
drathbun Board Member
Joined: 24 Jul 2008
Posts: 729 Location: Texas
|
Posted: Sat Dec 27, 2008 10:53 am Post subject: Re: Undo Delete Users |
|
|
You do not want to import your entire user table, no. Else you will reset post counts, passwords or other profile items that may have changed, last visit dates...
What you want would be to insert only the user for user_id 9. You also need to insert a row into phpbb_user_group and phpbb_groups that match up.
Going to move this to support for further posting, thanks. _________________ phpBBDoctor Blog |
|
Back to top |
|
|
espicom Board Member
Joined: 24 Nov 2008
Posts: 55 Location: Woodstock, IL
|
Posted: Sat Dec 27, 2008 12:50 pm Post subject: Re: Undo Delete Users |
|
|
Not to mention reattaching the posts that user made to them, because they all would now be marked as "guest"....
Undeleting a user is not a simple task! |
|
Back to top |
|
|
dogs and things Board Member
Joined: 18 Nov 2008
Posts: 628 Location: Spain
|
Posted: Sat Dec 27, 2008 12:58 pm Post subject: Re: Undo Delete Users |
|
|
Simply create a new user account with the same data as the deleted account and then use Post Associator MOD to associate the guest posts that belonged to the deleted user with the newly created account. _________________ phpBB2 will never die, I hope! |
|
Back to top |
|
|
Sylver Cheetah 53 Board Member
Joined: 17 Dec 2008
Posts: 426 Location: Milky Way
|
Posted: Sat Dec 27, 2008 4:39 pm Post subject: Re: Undo Delete Users |
|
|
I've installed Post Associator MOD, but I got some problems.
Inserted rows: 1
Warning: #1366 Incorrect integer value: 'NULL' for column 'user_emailtime' at row 1
Code: | SQL query:
INSERT INTO `friends3`.`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`, `user_login_tries`, `user_last_login_try`, `user_unread_topics`, `user_show_quickreply`, `user_quickreply_mode`, `user_open_quickreply`) VALUES ('9', '1', 'Lavy''''s', 'a4071a733524830eda22d91b06b9c91c', '1199203300[...] |
That is because where it sais "NULL" I did not know what to put and I write "NULL" also. Anyway, the user has been created, but it seems that some stuff is not right. For example, in the signature she got this: [img:9b5f490fbf]http://i10.tinypic.com/2zsd2f8.jpg[/img:9b5f490fbf] I think it should be an image or something, I can't remember.
I succesufully reasociated the posts and subjects, but now she got 1196, and not 598 posts. So the post count has not been resync.
I did all this changes on my computer first, too see how it works. I will redo them to my online board after I see that everything is perfect. _________________ Image link
My Forum || My Blog
phpBB2 forever! |
|
Back to top |
|
|
dogs and things Board Member
Joined: 18 Nov 2008
Posts: 628 Location: Spain
|
Posted: Sat Dec 27, 2008 6:06 pm Post subject: Re: Undo Delete Users |
|
|
1196 = 598 x 2. So she has twice the amount of posts she had before this.
Hmm, wonder why? _________________ phpBB2 will never die, I hope! |
|
Back to top |
|
|
~Cowboy~ Board Member
Joined: 08 Dec 2008
Posts: 297 Location: Chicago
|
Posted: Sat Dec 27, 2008 6:10 pm Post subject: Re: Undo Delete Users |
|
|
Could it be she now has credit for every guest post ever made?
Just a thought... _________________ Image link
We are not refugees we are trail blazers. |
|
Back to top |
|
|
Sylver Cheetah 53 Board Member
Joined: 17 Dec 2008
Posts: 426 Location: Milky Way
|
Posted: Sun Dec 28, 2008 7:39 am Post subject: Re: Undo Delete Users |
|
|
No, that's not it. When I recreated her account, I put her old settings back, including the amount of posts. Then, I added to her account or her old posts back. Probably I can just change it back to 598 from phpMyAdmin. _________________ Image link
My Forum || My Blog
phpBB2 forever! |
|
Back to top |
|
|
|
Not affiliated with or endorsed by the phpBB Group
Powered by phpBB2 © phpBB Group
Generated in 0.0592 seconds using 16 queries. (SQL 0.0144 Parse 0.0009 Other 0.0440) |
phpBB Customizations by the phpBBDoctor.com
Template Design by DeLFlo and MomentsOfLight.com
|
|