Ulysses Stuff > Releases

ULX MySQLOO

<< < (13/15) > >>

MrPresident:
Sorry, 2 things.

1. It should be noted that this script doesn't set up the database table for you. You'll need to take a look at the code and create the table yourself using the fields that the script expects.
2. I didn't actually use the connection info from the settings up top apparently. Take a look down a few functions into the code and modify the connection info there. I don't remember why I didn't just use the variables. I think I might have been having some issues with it.

Hive01:
Hey guys i got this script working.

HOWEVER.

The fact that every time a player joins it rewrites users.txt causes a huge lag when the servers got a fair few players on it...

e.g. a player joins, it checks users.txt and rewrites the player to user if the player doesnt exist..


The end result is EVERY player that joins gets their rank written to users.txt and this causes lag while the server reads/writes the file...

Any workaround for this?

MrPresident:
Which script are you using?

What I did to fix that problem... and this is NOT RECOMMENDED unless you know what you are doing...


Inside of the ULib.ucl.addUser function I modified it to NOT write to the text file.
If you don't feel comfortable doing that, you could also modify whichever MySQL script you are using not to use the addUser function on a player unless they aren't a user. Only setting their group if they are above guest.

When you run addUser (Even if they don't have a group) it creates an entry inside of the users.txt file. When this file gets big enough, the server will hitch when players join the server.

JakeGriffin:
Mr President,

thanks for your script again, but one thing - could you possibly tell me which way to create the table entries? I know how to, I mean the structure for each field. Mine are as follows, but I don't know if it is correct.



Thanks.

Also, same as last script. It says MySQLOO cannot be found even though it is definitely installed - I use it for other things. Where exactly should I have put the file?

MrPresident:

Navigation

[0] Message Index

[#] Next page

[*] Previous page

Go to full version