Ulysses Stuff > Releases
ULX MySQLOO
SatoshiAaron:
How do we install MySQLOO... I have the plugin installed here, but I can't find the MySQLOO that is required!
ms333:
--- Quote from: SatoshiAaron on August 15, 2013, 03:51:18 AM ---How do we install MySQLOO... I have the plugin installed here, but I can't find the MySQLOO that is required!
--- End quote ---
http://facepunch.com/showthread.php?t=1220537
Organik:
--- Quote from: Marmaduke on August 14, 2013, 09:14:14 AM ---I managed to get it mostly working but I still have one problem.
I got rid of all the errors by wrapping the code in an "if SERVER then" if statement. But I still had issues with the script adding the user to the correct usergroup when they joined (saving the groups works fine, but if the player joins the server with a usergroup that doesn't match the database, their usergroup would not change). I fixed this by changing:
"ulx.adduserids(nil,ply:SteamID(),D.groups)"
to
"ulx.adduserid(nil,ply:SteamID(),D.groups)"
Now the script works as I want it to but there is one issue.
My ulx menu seems to fail to load a lot of data. There are no maps in the maps list. There are no adverts in the adverts list (although adverts still display in chat). In the sandbox subtab of the settings tab, no sliders are appearing. In the group manager menu, group members are not appearing, and permissions are not appearing.
I've done some testing over the past few hours and the problems stated above seem to be from the fact I changed "ulx.adduserids(nil,ply:SteamID(),D.groups)" to "ulx.adduserid(nil,ply:SteamID(),D.groups)". If I change it back, all the information is displayed correctly, however the script doesn't change users usergroups.
Any help is appreciated.
Thanks
--- End quote ---
This is the exact same conclusion I've come to see as well. It would be nice if we can get one of the lua pro's on here to run through and update this script. Or maybe just shed some light on the issue at hand.
rainbow Dash:
--- Quote from: Organik on August 15, 2013, 01:07:46 PM ---This is the exact same conclusion I've come to see as well. It would be nice if we can get one of the lua pro's on here to run through and update this script. Or maybe just shed some light on the issue at hand.
--- End quote ---
--- Quote ---lua pro's on here to run through and update this script...
--- End quote ---
If only that would happen... I so desperately want need this for my PHP Forum Signature thing im making (which loves grayscaling )
MKServers:
Sorry all, I have been really busy recently but finally I am at a point where I can take a hour or so and update the code for GMod 13 correctly with create table abilities. Will edit this post as soon as I finish it. Will also be testing everything to make sure everything works because I shouldn't be screwing anyone over.
EDIT:
Also, I was really stupid and made a custom function outside of this file called ulx.adduserids(). I am making a new custom function WITHIN THIS FILE so it will avoid displaying chat and still update. I am still reading through other peoples errors and fixing them as I fix this script up.
--- Quote from: rainbow Dash on July 09, 2013, 04:56:40 AM ---I think this has been approached wrong.
In my opinion, It would be much better if this didn't read the ranks from the external database, but rather synced the local data file with the remote database whenever a player's rank changes, or a player connects. This way, any connection problems can be overlooked quite easily, and cause minimal disruptions for the server in the event of a failed connection, as the remote database would simply become a backup, only with the added feature of being able to display a players rank in a loadingurl.
How one would go about doing this, is beyond me. I have ideas, I just can't make them.
Your welcome to whomever feels inspired by that.
--- End quote ---
There is an issue this. Simply the fact that this is used to sync across servers. If I read off a local file, on another server the database would get a new rank and that user wouldn't get the correct rank.
HOWERVER I need to hook into when a player is given a new rank to update whenever ranks change. This would work as a much more effective way of handling the rankings.
Found the hooks that I needed and should be able to use them correctly to go about this better.
UPDATE
Most of the script is done. Once I figure out how I want to handle putting this on a server with already defined users, I will put up the new script.
Okay, I have decided that it will not accept users that were added before the MySQL was implemented. Sorry, but this is to avoid exploits that could be possible with other ways i thought of. I will upload the new GMod 13 version which I have tested. It will create a table and insert data as needed. It will also save the name in case you need it(loading screens or something?) If anyone has a better idea for avoiding exploits and loading predefined users, please shoot me a message. Other then that, happy servering.
To install MySQLOO, go here: http://facepunch.com/showthread.php?t=1220537
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version