Ulysses Stuff > Releases
ULib MySQL Authentication
Bite That Apple:
--- Quote from: MrPresident on April 04, 2015, 04:07:30 PM ---Also, thanks for pointing out the connection callbacks. I didn't know those existed.
--- End quote ---
Yeah, most of my server runs on MySQL; utime, lastlogin, chats, private addons I've made, ect.
MrPresident:
Heavily modified.
I did a pure conversion before which meant that whenever the SaveUsers function was called, it wanted to do queries for every user in the users table. Which could have been THOUSANDS. I didn't see this as a problem because when I tested it I have 9 and it worked fine.
Since it's not writing a file anymore, there was no need to override users who's info hasn't changed.
The system will now only query the database and update information for players who's information has changed. This should cut back a ton on SQL server load and the system should actually work not for people with larger databases.
Durpy?:
This might be a bit late but I'm currently having issues with this. The issue is ranks resettings due to an auto promotion system I have.
In a nutshell, when a player connects to the server, the db is offline and the server isn't connected to it, resulting in your rank being a regular user, during that time it takes too long for the server to connect to the db before the server starts the auto promotion, and in turn overriding your original rank. Is there any way around this?
MrPresident:
Not really. Is your database hosted externally? Free Database hosts are typically pretty slow.
This is a hacky implementation of MYSQL for ULib, it's not really something I want to spend a lot of time trying to perfect.
If it works, it works, otherwise, you might want to look for another solution for cross-server ranks.
JamminR:
Additionally, we (Team Ulysses) see this issue repeatedly with non-mySQL authentication and autopromote scripts.
I'm of the belief that, preferably, don't use them, and if your going to use them, find/have the author of the one you use make them more tolerant to delays in authentication.
Our forum has several posts over the years reporting this same issue due to autopromote scripts.
Navigation
[0] Message Index
[#] Next page
[*] Previous page
Go to full version