• Registered: 2005-07-15
  • Posts: 47

Topic: hmm..junior administrator mod 80% done. Help?

I'm wondering what SQL query would I do to make it so, it bumps the mod group id to 3, guests to 4, and members to 5. Anyone know? :s because the Junior Admin group has be to 2 in order to work correctly with my mod..and the default is 2 for mods.

2 Reply by Reines (edited by Reines 2006-01-30 03:41)

  • Reines
  • Reines
  • Senior Member
  • Offline
  • Registered: 2004-10-07
  • Posts: 304

Re: hmm..junior administrator mod 80% done. Help?

The IDs are defined in common.php, but you will need to shift the ids in the groups table too.

Reines's Website

3 Reply by Mr Puto (edited by Mr Puto 2006-01-30 03:51)

  • Registered: 2005-07-15
  • Posts: 47

Re: hmm..junior administrator mod 80% done. Help?

Yeah, but people don't want to go into phpMyAdmin just to do this mod. So I need a query to shift them up.

  • Smartys
  • Former PunBB Developer
  • Offline
  • Registered: 2004-04-30
  • Posts: 7,844

Re: hmm..junior administrator mod 80% done. Help?

Well, assuming you edit common.php to reflect this

update prefixusers set group_id = group_id + 1 where group_id > 1 and group_id < 5

change prefix to the DB prefix thing

  • Registered: 2005-07-15
  • Posts: 47

Re: hmm..junior administrator mod 80% done. Help?

Thank you.