Restore A Deleted Member

[ra7al]

========================================
========================================

بسم الله الرحمن الرحيم

========================================
This hack hade made By : .:: MAGHOOL ::.
Translate By : Ra7al
i'll Try To Support It with all i knew;)
========================================

Hack Name : Restore A Deleted Member

========================================

Please remember to click Mark as Installed (https://vborg.vbsupport.ru/vborg_miscactions.php?do=installhack&threadid=147378) if you use this modification
========================================

About this hack:
One of the biggest problems on forums as you may know is
Merge Users and deleted Member and when u going to updata
your forum Counters maybe get database error as there member
the Counters can't find them or there posts or when Merge Users
or delet any one you find the last member ID ^ EX : 3000 : ^ and
the forum counters read the him 2999 Soo this hack made for
allow you to restore the member iD as u can get the right number
for updata your counter or see the number of member
== Note == this hack Just allow you to restore the member ID
Not his posts

========================================
Instructions :-

Use This Hack Carefully
first make sure the userid not used

========================================
========================================
1-
Upload this file

undelet.php
to
/your forum root/admincp/



upload this file

cpnav_undeletuser.xml
to
your forum root/includes/xml
========================================
2-
open this link

http://www.xxxxx.com/your forum root/admincp/undelet.php?do=add

and change

xxxxx

to your site link


::: You Will Find The hack Under vBulletin Options List :::

Demo :-

http://img264.imageshack.us/img264/4213/restmo2.gif

http://img501.imageshack.us/img501/2821/rest2fv0.gif


Tested:
vBulletin Version : 3.6.4
And should work with ( 3.6.0 - 3.6.1 - 3.6.2 - 3.6.3 - 3.6.5 )

Versions:
v1.0 : v 2.0 - Arabic releases ( 3.0.X )
v3.0.0 - First English release ( 3.6.X )
=========================================
Mad By :-

.:: MAGOOL ::.

translate By :-

.:: Ra7al ::.

12:05 AM ( +2 GMT ) 16/5/2007
==========================================

[thincom2000]

Ah, I recently had to do this manually for some Guest posts I also added manually. This may have eliminated some confusion, so if I need to do that again in the future, I know where to look. Thanks!

[Cyburbia]

Just a couple of suggestions:

* Sorry to be picky about grammar, but "Restore The Deleted Member" implies that there's only one deleted member on the entire site. It should be "Restore A Deleted Member". (Replacing "a" with "the" seems to be common among those who speak Arabic as a first language, so I understand why you may have used it.)
* It would be more logical if this was under the "Users" category.

[ra7al]

Ah, I recently had to do this manually for some Guest posts I also added manually. This may have eliminated some confusion, so if I need to do that again in the future, I know where to look. Thanks!

your are wellcome and be sure to use it

Just a couple of suggestions:

* Sorry to be picky about grammar, but "Restore The Deleted Member" implies that there's only one deleted member on the entire site. It should be "Restore A Deleted Member". (Replacing "a" with "the" seems to be common among those who speak Arabic as a first language, so I understand why you may have used it.)
* It would be more logical if this was under the "Users" category.

:D i'll do it Now thanx for UR suggestions :up:

[Mrdby]

worth having anybody?

[TheBlackPoet]

i tried it.. but i dont know the member's old id #.... even so.. this is a good admin item and it should be something available in the core application.... so, good job..

[Mackenzie s]

If I were you, the next thing I'd add was restore by username. ;)

[Almotmaiz.Net]

Nice ...

this wut i search for ..
thnx Ra7al

[subzero06]

Yeah, it will be MUCH better if its restore by username! most people dont remember the ids

[ra7al]

worth having anybody?

:confused::confused:

i tried it.. but i dont know the member's old id #.... even so.. this is a good admin item and it should be something available in the core application.... so, good job..

yes it's good and only one like this here :D...

If I were you, the next thing I'd add was restore by username. ;)

i'll try to do this but if i can't you will the one who will do it

Nice ...

this wut i search for ..
thnx Ra7al

any time AlMotmaiz
and i happy for you find
what u search for :cool:

Yeah, it will be MUCH better if its restore by username! most people dont remember the ids
But i think the IDS can be find in your database and can get it
from MYPHPADMIN and the ID is only One but the username anyone
can take it after something like Merge Users so i made it restore
By the IDS

[bela-meaad]

fantastic

Thanks ;)

[Mrdby]

so no errors?

[ra7al]

fantastic

Thanks ;)

u r wellcome :D

so no errors?

on what ??:rolleyes:

[Joe Gronlund]

How do you use this hack, the member i want to restore has been deleted, and their username is not clickable..
Can i still restore them???

[Carlos2]

I have one problem with this, i restore the deleted member, with his correct ID and email, but his old posts and threads still look that they were created by other user, by a guest. How can i put that those threads and posts are of him??

[Carlos2]

Ah, I recently had to do this manually for some Guest posts I also added manually. This may have eliminated some confusion, so if I need to do that again in the future, I know where to look. Thanks!How do you do it manually? how do you assign those guest posts to a registered user??

[Joe Gronlund]

I think we both are having the same problem...

[Carlos2]

I think we both are having the same problem...Yes Joe, but thincom2000 says that it can be do it manually. Hope somebody knows how and tell us.

[Carlos2]

Yes, you have to go to mysql, to your database, the table called post, and find the post in postid and put the user id in the post you want ;)

Anybody knows how can i put in the Admin Cp, that nobody can delete any user? I want that nobody can delete a user.

[ra7al]

How do you use this hack, the member i want to restore has been deleted, and their username is not clickable..
Can i still restore them???

you can restore his ID with Different name

I have one problem with this, i restore the deleted member, with his correct ID and email, but his old posts and threads still look that they were created by other user, by a guest. How can i put that those threads and posts are of him??

run this with your SQL :-
UPDATE post SET userid = XX WHERE userid = 0;
and relace XX with THE ID

Use This with your own risk :confused:

[Carlos2]

you can restore his ID with Different name



run this with your SQL :-
UPDATE post SET userid = XX WHERE userid = 0;
and relace XX with THE ID

Use This with your own risk :confused:
Thanks, friend, but if you have more than a deleted member, all the posts become to the same, but it is very useful. Thanks ;)

Do you know how can i put in the Admin Panel that nobody can delete users? I want that nobody can delete users in my forum.

[ra7al]

No .. i don't knew

but i'll look for it

[ra7al]

try this way

https://vborg.vbsupport.ru/external/2007/05/4.jpg

https://vborg.vbsupport.ru/external/2007/05/4.jpg

https://vborg.vbsupport.ru/external/2007/05/4.jpg

[Carlos2]

try this way

https://vborg.vbsupport.ru/attachment.php?attachmentid=64672&stc=1&d=1180024153

https://vborg.vbsupport.ru/attachment.php?attachmentid=64673&stc=1&d=1180024153

https://vborg.vbsupport.ru/attachment.php?attachmentid=64674&stc=1&d=1180024153

Sure friend, but if i put that they cant change avatars, banner users, etc, i want only to dissappear the delete user option. Thanks

[ra7al]

o.k
i'll see again for other way

[Carlos2]

o.k
i'll see again for other way


Thanks man, if you know how please tell me.

[intensecool]

u can search your user id in mysql database

[karabaja3]

hi there. i'm having this problem?

Invalid SQL:
INSERT INTO jos_users (id, name, username, email, password, usertype, block, sendEmail, gid, registerDate,lastvisitDate, params)
VALUES ('2046',
'',
'Jeo25',
'jeo2345@gmail.com',
'e72581f8614727a152dec6fcfc739ad2',
'Registered',
'0',
'0',
'18',
'2008-05-05T11:15:35',
'2008-05-05T11:15:35',
''
);

MySQL Error : Duplicate entry '2046' for key 1
Error Number : 1062

what's wrong?

[silvermerc]

Does this mod work with 3.7

[Arrogant-One]

Okay, this is the scoop.

During the recent forum spam attacks where hundreds of bots signed up to OzChess and spammed mostly pornography, measures were taken to deal with this. One of which entailed the Admin deleting all banned accounts. Unfortunately he didn't know that a couple of those accounts were regular users who had misbehaved and were serving a week in the penalty box. Now their posts show up as, well, probably best I show you (please click below), and their accounts are deleted.

http://www.ozchess.com.au/9663-post61.html

I'd like to know if this mod can assist me in restoring the 2 affected (deleted) accounts and attribute these posts back to the authoring account?

Best Regards,

AO

[Nelson58]

Will this work on VB 4.2 PL2, and if not, could someone suggest some modifications so it will?

Thanks,

Nelson
www.Hobby-Machinist.com