A Mysql -> bukkit group sync plugin

Discussion in 'Archived: Plugin Requests' started by jd1378, Apr 16, 2014.

  1. Offline

    jd1378

    i want a plugin that sync my group manager player's groups with my Mysql server!
    please note that group id's to be on plugin . like this :
    groups :
    1 : 'guest'
    2 : 'member'
    ....
    and one important note : i Don't want a plugin to sync group with forum , cms ...
    i need to sync it with a simple mysql table .
    its better to be sync on join or quit
    ideas for command :
    /gms reload
    /gms SyncAll

    mysql server columns : Username(ign) , group_id
    Group manager : Essentials group manager
     
  2. Offline

    ShadowWizardMC

    jd1378 We need to know what permissions system you are using and if it has an API that we can access. If your using PEX there is a MYSQL backend that you can use to sync ranks on different servers.
     
  3. Online

    timtower Administrator Administrator Moderator

  4. Offline

    jd1378

    so any one can do it ?

    @timtower can you make this for me ?
     
  5. Online

    timtower Administrator Administrator Moderator

    Maybe, a small maybe.
    And try the tahg button instead of copying my profile link.
    jd1378 was bored, you are lucky.
    https://www.dropbox.com/s/ky4gmsajq3enjhy/MySQLGroupSynch.jar
    No reload command, will never be there.
    Also no syncall command, don't feel like adding that.
    Will try to sync on join.
    Edit the config before saying that it doesn't work.

    If you get errors:
    Full startup log or it didn't happen
     
  6. Offline

    jd1378

    timtower Hi .
    Thanks for making that for me ! but the bad news it doesn't work (when i connect to server my group does not change) :(
    here is the startup log and config !
    http://www.hastebin.com/hivumiliri.vhdl
    and please plz plz make the group listing on plugin and read group ids from mysql , that way it will take less size .
    and im sry :p:
     
  7. Online

    timtower Administrator Administrator Moderator

    jd1378 Are you seriously worried about that couple bytes? If so: get rid of the database and do it by hand.
    Will keep using the names.
    Will try to find the bug when I have the time.
     
  8. Offline

    jd1378

    timtower lol , srry im taking that back . but please find the bug when you have time .;)
     
  9. Online

    timtower Administrator Administrator Moderator

  10. Offline

    jd1378

    timtower its working perfectly without any errors ! Thank you So much !

    Can you add a timed Sync ? and what does it do when i join the server ? does it only receive my players's group or the whole table data ?
     
    timtower likes this.
  11. Online

    timtower Administrator Administrator Moderator

    Will give more lag as it needs to loop through the entire table, needs to retrieve the entire table.
    Code:
    SELECT * FROM table WHERE player = playername
     
  12. Offline

    jd1378

    and the timed sync ?
     
  13. Online

    timtower Administrator Administrator Moderator

    That is the more lag part
     
  14. Offline

    jd1378

    timtower Tnx for everything you did and the time you spent for this plugin , have a good time !
     
    timtower likes this.
  15. Offline

    jd1378

    hi timtower .
    i really like to see the source code , because i want to start programming . please show me if you already have it .
     
  16. Online

    timtower Administrator Administrator Moderator

    jd1378 Try a decompiler. And start with more basic plugin instead of Vault permission groups and mysql.
     
  17. Offline

    jd1378

Share This Page