MyBB Community Forums

i was trying plugin name VIP Member ship
thats make me set some one from member to vip member
and i can set the time end

i was trying it on myself i put from forum owner(my rank i can access to admin cp) to VIP User i set end time 1 hour then i still VIP and i cant access to admin cp please help
http://www.xbat.co.cc

Run this query in PHPMyAdmin or whatever Database Manager you use:

UPDATE `mybb_users` SET usergroup='4' WHERE uid='X'

Replace X with your uid.

Go to your hosts control panel and launch phpMyAdmin.
Run the following command:

UPDATE mybb_users SET usergroup=4 WHERE uid=1

Note:
Assuming your UID is 1 (default for first member : admin).
Assuming your database table prefix is mybb_ (default), if not, change what is.
Assuming your usergroup is 4 (default for Administrators), if not, change what is.

i didnt understand anything i go to phpmyadmin
there is was 5 database
and only i can click on it is connect now

PHPmyadmin>databases>choose the database you installed mybb on>SQL tab>enter the query.

in fact i dont know what is it
cuz i hosted by byethost and he is install it to me without i upload it
and what is the query

Login to your cPanel of byethost and find the tool phpMyAdmin.

or

Ask the admin or support team of byethost in their support forum to do that for you.

this is the picture now please what can i fill in black

no mate just do to this
PHPMYADMIN>databases>"the database you installed mybb on">sql tab
enter the query and your done
that place to do queries on mysql not a specific database
so you must do the select statement to select the database

thx aloooooooooooooooooooooot the problem is solved
special thanks to

effone & Vernier
for giving me a right code

and special thanks to
illusionalp
for telling me the right place