MyBB Community Forums

Full Version: Another forum team problem :P
You're currently viewing a stripped down version of our content. View the full version with proper formatting.
Pages: 1 2 3 4 5
Can you run these queries in phpMyAdmin??

SELECT `usergroup`, `additionalgroups` FROM `mybb_users` WHERE `uid` = '5';
SELECT `username` FROM `mybb_users` WHERE `usergroup` = '6' OR `additionalgroups` LIKE '%6%';

What are the results??
Uhh I'm at phpMyAdmin, I click on my database, I click on query, now what? There are a lot of different things, and I don't know where to put those two queries.
Just click the SQL tag at the top and paste the queries into the big box...
I can put them in at the same time, right?
Don't think so, just put in one, get the results, run the other one, get the results, post the reply here.
For the first one, I got this:

Showing rows 0 - 0 (1 total, Query took 0.0006 sec)

And then it shows extra stuff like, "Show row(s) starting from record #0 in horizontal mode and repeat headers after 100 cells", and it shows a chart that says usergroup, additionalgroups, check all, and uncheck all.
I need the actual results, that doesn't help. Might be quicker if I can have phpMyAdmin login details and I'll run them...
Uhh how will I give them to you, if you have PMs disabled?
Oh, crap, sorry about that, turned on again.
PM'd.
Pages: 1 2 3 4 5