Author Topic: MRSync - A MySQL rank synchronizer  (Read 243 times)

0 Members and 1 Guest are viewing this topic.

Offline captain1342

  • Newbie
  • *
  • Posts: 18
  • Karma: 1
    • View Profile
    • Aperture-Hosting
MRSync - A MySQL rank synchronizer
« on: December 17, 2016, 10:52:39 AM »
I made a MySQL synchronizer for ULX. It can be found here: http://steamcommunity.com/sharedfiles/filedetails/?id=819586794&result=1
A Showcase Video can be found here: https://www.youtube.com/watch?v=laI7pr1aJVs

Addon Description:

Synchronize your ULX ranks across your servers.
An ULX rank synchronizer

MRSync

MySQL
Rank
Synchronizer

You are a big community with more than 1 server and you are tired of adding everyone on all servers to their rank manually? Well then this script is something for you!

It saves the user's ranks in a MySQL database and allows to rank everyone on every server of your's.

To keep your community automated.

#Features#

Saving ranks on:
Serverleave ( just for the leaved user )
Servershutdown ( for all user's that are unline currently. WARNING: Just works if you user "quit" command )

Loading ranks on
Server Spawn Event

Having an ignore ranks list
The following ranks are cross server with team: "allserver" ( means: it ignores the server team setting and adds them on all servers to their rank's )
owner
superadmin
admin

#What do I need?#

Of yourse you need ULX and ULib for this to work.

First you need to Install MySQLoo which can be found here: http://facepunch.hatt.co/showthread.php?t=1357773
An exelent instruction of how to Install it can be found here: https://help.serenityservers.net/index.php?title=Garrysmod:How_to_install_mysqloo_or_tmysql

After that you need to setup a database for your ranks.
1. Create a user for MRSync with a complex password
2. Add a database scheme to it for MRSync.
3. Now Open on your server your Server.cfg and add the following things:

ulxsync_host "<Hostname/IP or your database>"
ulxsync_port <Port of your database>
ulxsync_database "<Sheme name from Step 2>"
ulxsync_username "<Username from Step 1>"
ulxsync_password "<Password from Step 1>"
ulxsync_servergroup "<The Server's Group (like: sandbox or darkrp)>"

4. Start your server! If it says:

[MRSync] Connected to database

then you successfully installed MRSync, if not feel free to contact me

#Planned features#

- Webpanel
- Ability to change the ignored ranks list without unpacking the gma file
- Intigration in XGUI
- Rank backups

#Support#

Please use my support ticked system at: https://support.aperture-hosting.de/
Or mail me under: Webmaster@Rainbow-Dash.com

#Other things#

Follow me on Twitter: @RainbowDashNet
Follow me on GitHub: https://github.com/captain1242
Aperture-Hosting Leader

Web: https://Aperture-Hosting.de
Mail: Webmaster@Aperture-Hosting.de
Github: https://github.com/captain1242
"Hosting with Vision"

Offline Bite That Apple

  • Hero Member
  • *****
  • Posts: 844
  • Karma: 375
  • Apple Innovations 2010®
    • View Profile
    • Fun 4 Everyone Gaming
Re: MRSync - A MySQL rank synchronizer
« Reply #1 on: December 18, 2016, 11:36:49 AM »
Not too bad, I made something kinda like this a few years ago, but defiantly not anything to this extent. Good job.
Quote from: John F. Kennedy 1963
A man may die, nations may rise and fall, but an idea lives on.
In most cases I do not make addons for people. You may ask, and I may or may not accept, paying me will not change the answer if it was no. Feel free to try.


My Created Addons:
> Player Connect/Disconnect Message < ---- > URL Playsound Addon < ---------- > Leaderboards Records < ----------------
> Player Chat Tags < ----------------------------- > Last Joined Checker < ------------- > Workshop Dupes Permissions < ------
> Utime Hour Changer Addon < ---------------- > Autopromote XGUI Version < ---- > UtimeMOO Server/Global Edition < --
> Give Weapon Addon < ------------------------- > Player Force Spawn < ------------- >
> Set Modelany Addon < ------------------------- > Set Spawn Points < ---------------- >
> Apple H.U.D. < ----------------------------------- > Advanced Anti Noclip Killing < -- >

Offline captain1342

  • Newbie
  • *
  • Posts: 18
  • Karma: 1
    • View Profile
    • Aperture-Hosting
Re: MRSync - A MySQL rank synchronizer
« Reply #2 on: December 20, 2016, 06:14:12 AM »

@Bite That Apple
Thanks. I am glad you like it.

@Everyone
I am optimistic and think I may be able to release the web panel soon.
If you have feature requests i am glad to hear them :D
Aperture-Hosting Leader

Web: https://Aperture-Hosting.de
Mail: Webmaster@Aperture-Hosting.de
Github: https://github.com/captain1242
"Hosting with Vision"

Offline Riotline

  • Newbie
  • *
  • Posts: 2
  • Karma: 0
    • View Profile
Re: MRSync - A MySQL rank synchronizer
« Reply #3 on: January 10, 2017, 05:49:20 PM »
My server's pointshop models disappear when I install the MRSync Addon.

This also causes TTT to make everyone stay in spectator. I also gave MRSync Root access to my database with its own database

Also causes this error:
Code: [Select]
[ULib] addons/mrsync_-_keep_your_ranks_synchronized_819586794/lua/autorun/server
/../../mysqllua/mysql_main.lua:100: attempt to call method 'query' (a nil value)

  1. fn - addons/mrsync_-_keep_your_ranks_synchronized_819586794/lua/autorun/ser
ver/../../mysqllua/mysql_main.lua:100
   2. unknown - lua/ulib/shared/hook.lua:110

if i remove every single addon it works but if i add any other addon it doesn't work
« Last Edit: January 10, 2017, 09:08:05 PM by Riotline »

Offline Unknown Gamer

  • Jr. Member
  • **
  • Posts: 78
  • Karma: -2
    • View Profile
    • TrueKnife TTT
Re: MRSync - A MySQL rank synchronizer
« Reply #4 on: January 13, 2017, 05:40:22 PM »
Could you post your code to GitHub? I don't want to have to go to Steam to download something thats MySQL related...
Newb Coder. Soon to get better

Offline captain1342

  • Newbie
  • *
  • Posts: 18
  • Karma: 1
    • View Profile
    • Aperture-Hosting
Re: MRSync - A MySQL rank synchronizer
« Reply #5 on: January 14, 2017, 10:23:41 AM »
@Unknown Gamer

Yeah wait ill Upload it Real Quick

@Riotline

We talked about it and we couldnt find a mistake ... The responded error just means that MySQLoo couldnt be loaded.

@all Big Update Really soon

Features that I will release:

- It will be a Complete new addon
- ULX Ban Synchronisation
- XGUI Intigration
- Ability to disable unwanted Features
Aperture-Hosting Leader

Web: https://Aperture-Hosting.de
Mail: Webmaster@Aperture-Hosting.de
Github: https://github.com/captain1242
"Hosting with Vision"