1 Topic by SpAZ

  • SpAZ
  • Member
  • Offline
  • Registered: 2004-09-14
  • Posts: 47

Topic: mod via mySQL

hi, i was wondering if it is possible to make some1 an admin or the owner again via mySQL coz i used a phpbb 2 punbb converter and it went wrong and deleted my user.... lucky me that i've had the forums in matanence the whole time so no1 registered wink so if its possible to make some1 the owner again via mySQL plz can u tell me sad it would be a big help big_smile

*removed by Rickard*
^ 1337 php and mySQL sig
Like annoying people with visual basic? http://www.annoyingvb.com <-- the home for virus/spammers/trojans. ect source code!

SpAZ's Website

  • From: 127.0.0.1
  • Registered: 2001-11-02
  • Posts: 9,167

Re: mod via mySQL

UPDATE users SET status=2 WHERE username='SpAZ';

"Programming is like sex: one mistake and you have to support it for the rest of your life."

Rickard's Website

  • From: Gothenburg, Sweden
  • Registered: 2002-07-03
  • Posts: 946

Re: mod via mySQL

SpAZ wrote:

hi, i was wondering if it is possible to make some1 an admin or the owner again via mySQL coz i used a phpbb 2 punbb converter and it went wrong and deleted my user....

Do you know which user (it's id)? (I'm the one written the converters, and it's not good when it's loosing users)

4 Reply by SpAZ

  • SpAZ
  • Member
  • Offline
  • Registered: 2004-09-14
  • Posts: 47

Re: mod via mySQL

hi, i ran that query and i get :-

Database spaz_forums running on localhost 
Error

SQL-query :  

UPDATE users SET STATUS =2 WHERE username = 'SpAZ' 

MySQL said: 


#1146 - Table 'spaz_forums.users' doesn't exist 

[Documentation] · [Back]

i have these:-

spaz_forums  
  forum_bans
  forum_categories
  forum_censoring
  forum_config
  forum_forums
  forum_messages
  forum_online
  forum_polls
  forum_posts
  forum_ranks
  forum_reports
  forum_search_matches
  forum_search_results
  forum_search_words
  forum_subscriptions
  forum_topics
  forum_users

and yeah the user is SpAZ

*removed by Rickard*
^ 1337 php and mySQL sig
Like annoying people with visual basic? http://www.annoyingvb.com <-- the home for virus/spammers/trojans. ect source code!

SpAZ's Website

  • Frank H
  • Former PunBB Developer
  • Offline
  • Registered: 2003-03-16
  • Posts: 1,423

Re: mod via mySQL

replace users in the query to forum_users

6 Reply by SpAZ

  • SpAZ
  • Member
  • Offline
  • Registered: 2004-09-14
  • Posts: 47

Re: mod via mySQL

i figured that out big_smile ty!

*removed by Rickard*
^ 1337 php and mySQL sig
Like annoying people with visual basic? http://www.annoyingvb.com <-- the home for virus/spammers/trojans. ect source code!

SpAZ's Website