Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Solved: 8 Years, 11 Months, 3 Weeks ago phpbb3 > mybb | problem with users
#4
Solved: 8 Years, 11 Months, 3 Weeks ago
(01-25-2011, 09:48 AM)Raz0r90 Wrote: Is there a place I can look these 'commands' things up?

Not really, I make them up as they're needed. The steps are pretty simple, this one went like this:
  1. Go into phpMyAdmin
  2. Go to the users table
  3. Click SQL
  4. Change the SELECT * FROM to UPDATE
  5. Between the table name and the WHERE put SET and the field I want to change (which I get from the right hand pane) followed by = and 'value' (in this case 0 for off)
  6. Delete the 1 after WHERE and replace it with the field name again, followed by = 'value' (which in this case is 1, since they're on)
  7. Query made. Test it. It works. Give to the user.


Messages In This Thread
phpbb3 > mybb | problem with users - by Raz0r90 - 01-24-2011, 10:06 AM
RE: phpbb3 > mybb | problem with users - by Dylan M. - 01-25-2011, 03:56 PM

Forum Jump:


Users browsing this thread: 1 Guest(s)