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.

Altering deleted users' names? (2 questions)


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



Joined: 30 Dec 2008

Posts: 48



PostPosted: Sat Feb 07, 2009 3:08 am 
Post subject: Altering deleted users' names? (2 questions)

1) Is it possible to change the name attached to a deleted member's posts (without reverting to an earlier database backup from before they were deleted)?

2) When a member is deleted, the color of their name changes (from white to yellow on the theme I use). When you are looking at one of the forum pages listing all of the threads, if a now deleted member had started a topic or was the last to reply, their name is seen as a different color than all of the remaining/active members' ...is there a way to change that color to look like everyone else's again?
Back to top
~Cowboy~
Board Member



Joined: 08 Dec 2008

Posts: 297
Location: Chicago


flag
PostPosted: Sat Feb 07, 2009 5:52 am 
Post subject: Re: Altering deleted users' names? (2 questions)

If you delete a member I believe their posts revert to "Guest". Once they go to guest it would be exceedingly difficult to change it to a different member name.

If you're having a problem with that, I think the best thing to do is to change the member name before you ban them and then change their password. That effectively gives their posts a different name, and ties up their email address that they registered with, and then you could do an IP ban also if you wish too. Then you can place their original name on the banned names list so they can not use it to re-register if they evade the IP ban by using a dynamic IP address.

_________________
Image link
We are not refugees we are trail blazers. icon_wink.gif
Back to top
drathbun
Board Member



Joined: 24 Jul 2008

Posts: 663
Location: Texas


flag
PostPosted: Sat Feb 07, 2009 5:57 am 
Post subject: Re: Altering deleted users' names? (2 questions)

Actually, I don't think it would be hard. When a user is deleted their username is stored in the post_username field in the phpbb_posts table. If you check your deleted posts you'll probably see the username there. So if you wanted to update all posts that were made by "Fred" and change them to "Barney" you could, in theory, do this:
Code:
update phpbb_posts
set post_username = 'Barney'
where post_username = 'Fred'

As far as the color thing... that's not standard code, so it would depend on the MOD in use.

~Cowboy~ the "guest" is their member status, but the username still exists and I believe could be updated.

_________________
phpBBDoctor Blog
Back to top
~Cowboy~
Board Member



Joined: 08 Dec 2008

Posts: 297
Location: Chicago


flag
PostPosted: Sat Feb 07, 2009 6:21 am 
Post subject: Re: Altering deleted users' names? (2 questions)

Once you add them to all the other guests posts by deleting the original poster the name remains in the database? If that is so I can see it being done but wouldn't it still be easier to do it through the ACP by simply changing their name in their profile page?
_________________
Image link
We are not refugees we are trail blazers. icon_wink.gif
Back to top
dogs and things
Board Member



Joined: 18 Nov 2008

Posts: 621
Location: Spain


flag
PostPosted: Sat Feb 07, 2009 8:35 am 
Post subject: Re: Altering deleted users' names? (2 questions)

1- Have a look at Post Associator.
_________________
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 Feb 07, 2009 1:23 pm 
Post subject: Re: Altering deleted users' names? (2 questions)

Yes, Post Associator for the first question, and for the second... There are different colors just because the usernames are links to their profiles, and the guest can not, because they don't have a profile anymore. You could change link color from overall_header.tpl, I think. icon_smile.gif
_________________
Image link
My Forum || My Blog

phpBB2 forever! icon_smile.gif
Back to top
~Cowboy~
Board Member



Joined: 08 Dec 2008

Posts: 297
Location: Chicago


flag
PostPosted: Sat Feb 07, 2009 5:59 pm 
Post subject: Re: Altering deleted users' names? (2 questions)

dogs and things wrote:
1- Have a look at Post Associator.


WOW, I don't think I have ever seen that one before ... very nice indeed. icon_biggrin.gif

_________________
Image link
We are not refugees we are trail blazers. icon_wink.gif
Back to top
dogs and things
Board Member



Joined: 18 Nov 2008

Posts: 621
Location: Spain


flag
PostPosted: Sat Feb 07, 2009 6:15 pm 
Post subject: Re: Altering deleted users' names? (2 questions)

I discovered this brillant MOD not so long ago and wondered why it is such an unknown MOD as I find it a very good MOD, almost a must have IMO.

Thoul has written more very nice MODs, they're all available from his site.

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



Joined: 08 Dec 2008

Posts: 297
Location: Chicago


flag
PostPosted: Sat Feb 07, 2009 6:27 pm 
Post subject: Re: Altering deleted users' names? (2 questions)

I will be spending more time there to check his stuff out icon_biggrin.gif
Thanks for taking the time to post that Dogs and Things . It will be useful to me. Image link

_________________
Image link
We are not refugees we are trail blazers. icon_wink.gif
Back to top
Chapter 24
Board Member



Joined: 30 Dec 2008

Posts: 48



PostPosted: Sat Feb 07, 2009 7:03 pm 
Post subject: Re: Altering deleted users' names? (2 questions)

Thanks for the tips icon_smile.gif
I will look into the Post Associator MOD as well as Drathbun's method.
Thanks also for the clue about changing the color Sylver Cheetah. I still don't know how to do it, but it gives me a starting point for figuring it out.
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
 
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.0272 seconds using 15 queries. (SQL 0.0015 Parse 0.0009 Other 0.0248)
phpBB Customizations by the phpBBDoctor.com
Template Design by DeLFlo and MomentsOfLight.com Moments of Light Logo