Hi,
I want to brainstorm with you guys about a thing that happened to me today. I am consulting with you AFTER all what i did in hope the i didn't do anything too stupid.
It all started 2 days ago, i was on vacation and i logged in to my vBulletin forum using a WAP skin(via my cellphone), My username is MDreamer (It was userid 1) I typed Mdreamer as user and my password.
What happened after that was that a new user with the same letters (just not case sensitive Mdreamer instead of MDreamer) was created and posted my message. It was odd.. I waited until I'll get home and i saw it on a regular PC and in fact, i had 2 users with the same name!
I (stupidly) decided to marge those. userid 1 (me, the original Admin) and the new Mdreamer userid 3592 (the new guy) what happened after that is the BOTH of the users where deleted it wasn't protected via config.php because i forgot a comma
I just realized I lost my admin. I had another back-door user for emergencies that i used to get a new admin for my vBulletin. Everything was back to normal except that all my messages became a Guset messages
I couldn't allow is.. so (take a deep breath) i decided to do some SQL statements in the DB to get ownership on my original messages so people and i can search for them. I am a BI/OLAD/ELT/SQL programer so i felt at home. I made a reversed engineered ERD and I created a new user and updated the "ownership" for it:
UPDATE 'post'
SET 'userid' = 3592
where 'username' = MDreamer
UPDATE 'thread'
SET 'posterid' = 3592
where 'postusername' = MDreamer
I also updated the message counter in 'user' table.
Then I merged the user with another user with admin right and everything seems to be ok.. but i can't change the userid. when i tried then i got some really weird stuff.
Did i damaged the DB? can I change somehow the userid with a vBulletin tool? I am afired that in the next upgrade or change i will run into serious trouble but i had no choice...
please advice.
Thanks
Maayan Dreamer
I want to brainstorm with you guys about a thing that happened to me today. I am consulting with you AFTER all what i did in hope the i didn't do anything too stupid.
It all started 2 days ago, i was on vacation and i logged in to my vBulletin forum using a WAP skin(via my cellphone), My username is MDreamer (It was userid 1) I typed Mdreamer as user and my password.
What happened after that was that a new user with the same letters (just not case sensitive Mdreamer instead of MDreamer) was created and posted my message. It was odd.. I waited until I'll get home and i saw it on a regular PC and in fact, i had 2 users with the same name!
I (stupidly) decided to marge those. userid 1 (me, the original Admin) and the new Mdreamer userid 3592 (the new guy) what happened after that is the BOTH of the users where deleted it wasn't protected via config.php because i forgot a comma
I just realized I lost my admin. I had another back-door user for emergencies that i used to get a new admin for my vBulletin. Everything was back to normal except that all my messages became a Guset messages
I couldn't allow is.. so (take a deep breath) i decided to do some SQL statements in the DB to get ownership on my original messages so people and i can search for them. I am a BI/OLAD/ELT/SQL programer so i felt at home. I made a reversed engineered ERD and I created a new user and updated the "ownership" for it:
UPDATE 'post'
SET 'userid' = 3592
where 'username' = MDreamer
UPDATE 'thread'
SET 'posterid' = 3592
where 'postusername' = MDreamer
I also updated the message counter in 'user' table.
Then I merged the user with another user with admin right and everything seems to be ok.. but i can't change the userid. when i tried then i got some really weird stuff.
Did i damaged the DB? can I change somehow the userid with a vBulletin tool? I am afired that in the next upgrade or change i will run into serious trouble but i had no choice...
please advice.
Thanks
Maayan Dreamer
Comment