User Tag List

Page 1 of 3 1 2 3 LastLast
Results 1 to 7 of 15

Thread: [Trinity - Latest Revision] RBAC Permissions SQLs

  1. #1
    Esteemed Member
    Join Date
    Sep 2013
    Location
    Florida
    Posts
    211
    XP
    51,938
    Level
    70
    Thanks
    77
    Thanked 33 Times in 25 Posts

    [Trinity - Latest Revision] RBAC Permissions SQLs

    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:
    http://pastebin.com/CdfcH9kf

    Rbac_Linked_Permissions:
    http://pastebin.com/PU2ZfhR2

    Rbac_Permissions:
    http://pastebin.com/6yfsJcKJ
    Last edited by Andrew; 11-05-2013 at 04:53 AM.
    Achievements:
    Referrer 1 year registered Member Level XL Level LXX
    Awards:
    Pot Head Raffle Winner
    "Too often do people underestimate the power of a touch, a kiss, a hug, or even
    as little as a kind word. All which have the potential to turn a life around."

  2. The Following 6 Users Say Thank You to Andrew For This Useful Post:


  3. #2
    Founder <span style='color: #FF4500'>Tommy</span>'s Avatar
    Join Date
    Apr 2013
    Posts
    7,391
    XP
    3,449,104
    Level
    378
    Thanks
    889
    Thanked 1,856 Times in 1,119 Posts
    Thanks for sharing this with us! Little pointer: Instead of having a download for simple SQL files, you can put it on paste2.org, pastebin.com or in the code tags. \o/

  4. #3
    Original Poster
    Esteemed Member
    Join Date
    Sep 2013
    Location
    Florida
    Posts
    211
    XP
    51,938
    Level
    70
    Thanks
    77
    Thanked 33 Times in 25 Posts
    Quote Originally Posted by Tommy
    Thanks for sharing this with us! Little pointer: Instead of having a download for simple SQL files, you can put it on paste2.org, pastebin.com or in the code tags. \o/

    Thanks for the tip I'll do that now actually. Didn't think of it.
    Achievements:
    Referrer 1 year registered Member Level XL Level LXX
    Awards:
    Pot Head Raffle Winner
    "Too often do people underestimate the power of a touch, a kiss, a hug, or even
    as little as a kind word. All which have the potential to turn a life around."

  5. The Following User Says Thank You to Andrew For This Useful Post:


  6. #4
    Exalted Member Synth's Avatar
    Join Date
    Sep 2013
    Location
    Lebanon,Beirut
    Posts
    410
    XP
    2,015,866
    Level
    259
    Thanks
    43
    Thanked 160 Times in 69 Posts
    Thanks for sharing can't wait to back house and test it.

  7. The Following User Says Thank You to Synth For This Useful Post:


  8. #5
    Original Poster
    Esteemed Member
    Join Date
    Sep 2013
    Location
    Florida
    Posts
    211
    XP
    51,938
    Level
    70
    Thanks
    77
    Thanked 33 Times in 25 Posts
    Quote Originally Posted by Synth
    Thanks for sharing can't wait to back house and test it.
    Thanks for the reply :D I'll be updating the links with better code as I progressively fix my own RBAC system. Feel free to stop by the thread every once and a while for a better version if I post an update. I literally hand typed all the query's for the permissions of each rank so there is a few things missing from a few ranks etc but I've fixed a lot of it recently. Will update in the next few days when it's near complete.
    Achievements:
    Referrer 1 year registered Member Level XL Level LXX
    Awards:
    Pot Head Raffle Winner
    "Too often do people underestimate the power of a touch, a kiss, a hug, or even
    as little as a kind word. All which have the potential to turn a life around."

  9. #6
    Enthusiast Relapse's Avatar
    Join Date
    Nov 2013
    Posts
    34
    XP
    2,167
    Level
    13
    Thanks
    7
    Thanked 2 Times in 2 Posts
    Hey droppin... Are you the same guy who posted this on *******? Too lazy to look at user there, even though tab is open.

    If so.... My RBAC seems to be broken as hell... I've not yet tried your SQL's but pretty sure mine are flawless... Probably broken trinity. What rev do you use?

  10. #7
    Respected Member
    Join Date
    Mar 2014
    Posts
    127
    XP
    2,884
    Level
    15
    Thanks
    16
    Thanked 0 Times in 0 Posts
    Hey man thank you very much have just a little question :S

    186: Role: Sec Level Administrator
    187: Role: Administrator Commands
    188: Role: VIP Commands
    189: Role: Sec Level VIP
    190: Role: Developer Commands
    191: Role: Sec Level Developer
    192: Role: Sec Level Head of Staff
    193: Role: Sec Level Eventmaster
    194: Role: Sec Level Gamemaster
    196: Role: Head of Staff Commands
    197: Role: Eventmaster Commands
    198: Role: Gamemaster Commands
    What means Sec Level Administrator and what is Administrator Commands
    Is Sec Level for Test Admin or something?
    Thank you

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •