phpBB2Refugees.com Logo
Not affiliated with or endorsed by the phpBB Group

Register •  Login 

Continue the legacy...

Welcome to all phpBB2 Refugees!Wave Smilie

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.

Undo Delete Users


 
Search this topic... | Search General Support... | Search Box
Register or Login to Post    Index » General Support  Previous TopicPrint TopicNext Topic
Author Message
Sylver Cheetah 53
Board Member



Joined: 17 Dec 2008

Posts: 426
Location: Milky Way


flag
PostPosted: 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? icon_sad.gif
_________________
Image link
My Forum || My Blog

phpBB2 forever! icon_smile.gif
Back to top
Ram
Board Member



Joined: 23 Dec 2008

Posts: 100
Location: Somewhere over the rainbow


flag
PostPosted: 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


flag
PostPosted: Sat Dec 27, 2008 10:00 am 
Post subject: Re: Undo Delete Users

Yes, I have lots of databases. icon_smile.gif 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. icon_confused.gif

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! icon_smile.gif
Back to top
drathbun
Board Member



Joined: 24 Jul 2008

Posts: 729
Location: Texas


flag
PostPosted: 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


flag
PostPosted: 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


flag
PostPosted: 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


flag
PostPosted: Sat Dec 27, 2008 4:39 pm 
Post subject: Re: Undo Delete Users

I've installed Post Associator MOD, but I got some problems. icon_sad.gif
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. icon_confused.gif
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. icon_smile.gif

_________________
Image link
My Forum || My Blog

phpBB2 forever! icon_smile.gif
Back to top
dogs and things
Board Member



Joined: 18 Nov 2008

Posts: 628
Location: Spain


flag
PostPosted: 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? icon_question.gif

_________________
phpBB2 will never die, I hope!
Back to top
~Cowboy~
Board Member



Joined: 08 Dec 2008

Posts: 297
Location: Chicago


flag
PostPosted: 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. icon_wink.gif
Back to top
Sylver Cheetah 53
Board Member



Joined: 17 Dec 2008

Posts: 426
Location: Milky Way


flag
PostPosted: 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. icon_wink.gif
_________________
Image link
My Forum || My Blog

phpBB2 forever! icon_smile.gif
Back to top
Display posts from previous:   
Register or Login to Post    Index » General Support  Previous TopicPrint TopicNext Topic
Page 1 of 1 All times are GMT - 4 Hours
 
Jump to:  

Index • About • FAQ • Rules • Privacy • Search •  Register •  Login 
Not affiliated with or endorsed by the phpBB Group
Powered by phpBB2 © phpBB Group
Generated in 0.0614 seconds using 17 queries. (SQL 0.0113 Parse 0.0008 Other 0.0494)
phpBB Customizations by the phpBBDoctor.com
Template Design by DeLFlo and MomentsOfLight.com Moments of Light Logo