i want back delete member

[se7o.com]

hii
i cant write english good

i have some problem at my fourm

and important member was delete

i want back him

his topic still in

but  by gust

i have serch and find

UPDATE smf_messages SET ID_MEMBER='THEIR_NEW_ID' WHERE postername='OLD_USERNAME';

from phpmy admin

but i  dont know how it work

[karlbenson]

Once the user has re-registered (or you have recreated their account).
You can then restore the posts to that username by performing that query in phpmyadmin

UPDATE smf_messages SET ID_MEMBER='THEIR_NEW_ID' WHERE postername='OLD_USERNAME';

Change smf_ to your forums table prefix, change THEIR_NEW_ID to the users new user id.
And change their OLD_USERNAME to that the users only name was eg


UPDATE myforum1_messages SET ID_MEMBER='1999' WHERE postername='BurtyBob';

[Oldiesmann]

In 2.0, this functionality is built-in. There is a reattributePosts function in Subs.php in 1.1, but I don't know how well it works, and there's no interface for it.

Make sure you run "find and repair any errors" after that as topics will still be shown as being started by a guest for that person (there's no easy query to update it). You may need to run "Recount all totals and statistics" as well.

[se7o.com]

i will try agine and tell u

[se7o.com]

"You have to choose at least one column to display"


what can i do

[greyknight17]

Type the query given to you in the SQL query on database area.

[se7o.com]

i will put it in the white box than in the attach pic


it gives me

"You have to choose at least one column to display"

[greyknight17]

Sorry...missed the top part. Don't go into the Query tab at the top. Choose SQL instead and copy/paste the query given to you earlier.

[se7o.com]

thank uuuuu

[se7o.com]

if i want merge to member


i have member register more one time

i wantg merge all his account


Good Boy

hes ID is  25

and

GOOD MAN

hes ID is 3432

i want GOOD MAN his ID  is 25

Can u under stand

[[SiNaN]]

se7o.com, it needs more work than it seems to as ID of a member is widely used in the database. You have to change the ID of "GOOD MAN" to "Good Boy"s ID in every table.

If you want, you can start a new topic about merging users in the SMF Coding Discussion board, where it may get definite answers.

[JimM]

Here's a post that talks about merging 2 members.  You might find the information you need there.  Be sure to back up your database before trying this though.

http://www.simplemachines.org/community/index.php?topic=212588.msg1496327#msg1496327

[se7o.com]

thank u all

[GMCbris]

Can I jump in

I have just run this query and it tell me :

Affected rows: 387 (Query took 5.8806 sec)

I assume that it has worked

But the forum doesnt show any changes to the users account.

Is there something else I need to do?

Thanks

GMC

[GMCbris]

Can I jump in

I have just run this query and it tell me :

Affected rows: 387 (Query took 5.8806 sec)

I assume that it has worked

But the forum doesnt show any changes to the users account.

Is there something else I need to do?

Thanks

GMC

Bump

[JimM]

You might want to start a new topic as the OP has already marked this one as solved.