Need help with SMF

[Colleen]

Does anyone know if it's possible to take some posts from one user and move them over to another user? I am splitting an account into two and don't see a way to do this.

[Colleen]

So, I'm thinking I'll have to convert my forum to a forum which allows splitting of users, then convert it back, wonderful.

[Big Dan]

I've never heard of any forum software that allows associating posts from one user to another unless you're merging accounts.

A quick a dirty way would be to find the posts in the database and change UID associated with. If it's not a large amount of posts, it should be pretty easy. I don't know SMF's database structure or I'd offer more help.

[sawz]

i have seen user accounts deleted, then those posts were attributed to another member. i remember doing this for someone.

using SMF

[Colleen]

I've never heard of any forum software that allows associating posts from one user to another unless you're merging accounts.

A quick a dirty way would be to find the posts in the database and change UID associated with. If it's not a large amount of posts, it should be pretty easy. I don't know SMF's database structure or I'd offer more help.

I have the dump in front of me and it's my own account, I have 600+ posts and want to move the majority.

It doesn't look like an easy task is my only problem. Because the ID, if it were beside my name or email I would globally find and replace, but it's not. hmmm... I'll have to think about this.

I shouldn't have been posting personal stuff as an admin. A member brought this to my attention and it made sense for the niche we're in. Well at least I don't have 1,000 posts.

i have seen user accounts deleted, then those posts were attributed to another member. i remember doing this for someone.

using SMF

I can't delete the admin account is the problem. I need an admin account and it should be ID#1.

[unr]

Can't you just manually edit post count? :\

[Colleen]

Why would I want to edit the post count?

[sawz]

sounds like you have a small database.
i'm pretty sure i can juggle these posts around.

if you'll send me a copy of the dump, i'll see what i can do with it.

[unr]

to 'technically' split the posts? :\


Maybe I'm dumb and didn't realize you actually wanted individual posts split, not post count?

[Colleen]

I'm capable of messing with the dump, thanks anyway.

unr, nvm. I'm not gonna bother with it.

[sawz]

ok, i only got 3 or 4 posts. so maybe what i say don't mean much, right now.

this can be done.

i would copy the admin row from smf_members, then delete the account. any posts made by the admin remain. and the admin is a guest.

so i do this query:

UPDATE smf_messages SET ID_MEMBER = 777 WHERE posterName = 'Admin';

777 being the users id number where the posts are going.

now you can restore the admin row, or create a new account and change their id number to 1 in the database.

make sure you backup your database before you do this.
force of habit with me.

duck soup

[Colleen]

Thanks Sawz. It's something I may attempt over the weekend. The only crappy part is several posts I did want to keep under the admin account and not go all to my new account. Such as announcement posts, stickies, etc... forum related stuff.