An administrator on my website accsidentally deleted my account. I created me a new admin account through his account and now on my profile i am u=60
I really need to be u=1 because now it says u=1 doesnt exsist. How do I do This!!!!!???
Thanks SOOOOO Much!
Brianjw
(need fast replies)
Ps. I also need help with the shoutbox, it is in the center of the screen and not in the area. Take a look: http://brianjwilson.com/forum
Brian, I'm not sure but I think you can access the database members table and change your ID_MEMBER from 60 to 1 manually ONLY IF the #1 account is actually deleted.
As for your shoutbox I can't view it probably because I'm a guest. If its the TP shoutbox just go into your blocks manager and move it to the left or right side.
The shoutbox,
I mean it's supposed to be on the left but it is spread all over the screen.
Yes, and I can't even see a shoutbox on your site because you have not given guests the permission to see it.
Also i wonder how on eart you could let any one in as admin to change things in the management.
There are 4 people in this world i trust with that kind of thing, and even if they could change things they wouldent even try to unless i ask them to.
Let this be a good reminder to others that read this, Dont ever let anyone in as admins, look what might happen if you do...... ;)
The shoutbox problem turned out to have connection with the big admin problem. Once I went into my database and made me #1 again the shoutbox was back on the left where it should be.
Also, (more Help),,,
Since my account was deleted all my posts I've made say "Guest" under them. Is there a way I can make it show my picture and my username and my signature. etc. This will be the only problem I need to solve and that will be all.
Thanks,
Brianjw ;D
Dont think there is a way exept add the amount of post to the new account, and update your avatar the same way
Run this query in your phpMyAdmin. Of course, changing the stuff it tells you to.
UPDATE smf_messages set ID_MEMBER = *ID YOU WANT TO KEEP* WHERE ID_MEMBER = *ID YOU WANT TO DESTROY*
It is the same email as this one now. But i'll give it a try! ;)
I changed my post so it wasn't using email anymore. :)
The problem is I don't want to delete an account or posts. I have all the posts I've made except for todays say "Guest" under them. I want to keep those posts and I want it to say I am a member with the image etc. on all the posts.
...
Brianjw :)
IchBin's SQL statement updates the id of the poster to your id. Basically, if your id is now 1 and the id for guests is 0, then you simply use those values in the SQL statement IchBin provided (within your phpMyAdmin) and it will change all those guest posts to say they are from you.
brilliant query! I must note this one down somewhere