[Trinity - Latest Revision] RBAC Permissions SQLs

[Wise]

So I've been doing a lot of WoW Emulation recently and I've been learning a lot about it over the last 3 months so I've noticed one of the main things people don't have setup properly is RBAC permissions and there is little to no posts I've found with help regarding SQLs for set permissions so I've decided to take the time to not only manually fix my own RBAC system, but provide the community with the SQLs for them as my frist release ever.

I hope you enjoy and appreciate my work although it's not that impressive. I'd just like to help people fix their RBAC systems because it is a pain. Everything in these SQLs is correct ~90%. There might still be a few missing but the majority of them are linked to each rank.



The ranks are setup as well as a VIP rank added with a few commands and will be listed below with their Security Levels:

-----------------------------------------------



0 - Players




1 - VIP




2 - Gamemaster





3 - Eventmaster




4 - Head of Staff




5 - Developer




6 - Administrator







SQL Querys

-----------------------------------------------


Rbac_Default_Permissions:
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET - Pastebin.com (http://pastebin.com/CdfcH9kf)


Rbac_Linked_Permissions:
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET - Pastebin.com (http://pastebin.com/PU2ZfhR2)


Rbac_Permissions:
/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */; /*!40101 SET - Pastebin.com (http://pastebin.com/6yfsJcKJ)