Is there a way to change usernames?

or maybe I could make the login case-insensitive?

I don't know about making it case sensitive, but if you want to change a username, just get into your database and change that field in the minibb_users thingy. It won't update previous posts, but will change the username

Thanks for the guick reply.

Just changing the database is not the best trick... Still, old username will be kept in posts table, so probably you will need to change it too.

Out of curiosity, why is the username duplicated in the posts table? Since poster_id is already in there, you can just join the posts and users tables based on the poster_id.

Also, the case-sensitive logins are a little bit inconvenient sometimes... I ended up hacking my forum to make it case insensitive.

Sorry if I sound like I'm complaining a bunch. Really I'm quite impressed with MiniBB. It's very cool. :)

Out of curiosity, why is the username duplicated in the posts table?

1) Because of the speed. Joining tables is much-much slower than simple selects, specially on large databases.
2) If you delete a user, his nickname is saved in each posts. So, you can remove the user saving his posts.

Also, the case-sensitive logins are a little bit inconvenient sometimes

It will be fixed in 2.0.

Hi folks,

What sql queries do I have to execute in order to change the username of a member ? New username should appear in all his/her messages on the forum.

I assume I have to run a query in minibbtable_posts, minibbtable_topics and minibbtable_users.

Regards,
P.

I think, something like...

Substitute 'NEW_USERNAME' for the new username you want to appear, and 'OLD_USERNAME' for the current name. You must know 'USER_ID' in advance. Hope you know how to do it :-) [roll over cursor on "Member" title and you'll see something like ....action=userinfo&user=USER_ID ]

I think, if you'd have private messages add-on, it's much difficult to change username in it's storage files... a special script is needed for changing usernames. But on another side, it's not really necessary it to do it for some kind of "mailing" program... It's kind a separate script.

Hello, just a thought:

as we store user_id in every table it is needed, why we don't store username only in minibbtable_users? then it would require only updating one table and queries in our code would use left join statements?

Paul,

Thanks.

daniel gerzo
left join statements - :-) well, they will kill your server fast, when you have a large amount of visitors. If you study miniBB code, you will see there is only one function using JOIN statement (just because there is no other way to get the data other than that), and this function is from admin panel (not often usage).

I think we also need to change topic_last_poster?

Vishal P. Rao
That's correct, I've fixed the code above. Thanks!