MyBB Community Forums

I just deleted usergroup id = 8

and now here is my usergroup numbering:

Guests = 1
Registered = 2
Super Moderators = 3
Administrators = 4
Awaiting Activation = 5
Moderators = 6
Banned = 7

Guru = 9
VIP = 10

my question is how can I make usergroup Guru to #8 and VIP to #9

Why? These group ids generally aren't visible to visitors.

Changing the group id involves updating:
mybb_calendarpermissions (gid)
mybb_forumpermissions (gid)
mybb_groupleaders (gid)
mybb_joinrequests (gid)
mybb_promotions (originalusergroup, newusergroup)
mybb_spiders (usergroup)
mybb_threadprefixes (groups)
mybb_usergroups (gid)
mybb_users (usergroup, additionalgroups, displaygroup)

Don't forget to update the AUTO_INCREMENT value of mybb_usergroups or else you will get a gap on inserting your next group.