Slow MySQL load, or script issue? -
Devine - 14.11.2009
For some reason whenever someone logs into my server, they start falling from the sky, but then about 5 seconds later, it'll finally spawn them. They can't use any commands or speak at all. Is this a script issue, or is it MySQL not loading the players right away? If it's a script issue, where should I look at? I looked at OnPlayerLogin and everything looked fine.
Re: Slow MySQL load, or script issue? -
iLinx - 14.11.2009
is your mysql server host localhost or is it on a remote server, becuase if its on a remote server the problem may be that its taking a while to connect to the remote server
Re: Slow MySQL load, or script issue? -
Devine - 14.11.2009
Quote:
Originally Posted by iLinx
is your mysql server host localhost or is it on a remote server, becuase if its on a remote server the problem may be that its taking a while to connect to the remote server
|
It's on localhost.
Re: Slow MySQL load, or script issue? -
iLinx - 14.11.2009
Then it's probably a script issue. I would start at the login command work my way up.
Also if your logging in first and then spawning, it might be something in the OnPlayerSpawn aswell, i had a problem with something like this but it was with a filebased user system, and i found the problem under OnPlayerSpawn
Re: Slow MySQL load, or script issue? -
Devine - 14.11.2009
This isn't a script I've written from scratch because I'm not that familiar with MySQL, I downloaded it.. but from what I know OnPlayerSpawn and OnPlayerLogin look perfectly fine..
Re: Slow MySQL load, or script issue? -
Devine - 15.11.2009
Ugh.. bump :P
Re: Slow MySQL load, or script issue? -
DiddyBop - 15.11.2009
Dont bump it.. people will see it man just patience..
post your onplayerspawn script....
Re: Slow MySQL load, or script issue? -
Devine - 15.11.2009
Here;
http://pastebin.com/m733abc8c
I know someone will probably be thinking "I won't help you because it's GF." Well, I just started editting this script. I found a GF edit with MySQL and wanted to use it, but since I found this bug I wanted to figure out the bug before editting it.
Re: Slow MySQL load, or script issue? -
Devine - 15.11.2009
Gah.. I hate to bump this but this is really holding me back, I need to get it fixed ASAP.. anyone?
Re: Slow MySQL load, or script issue? -
Marcel - 16.11.2009
Do you have any code in OnPlayerUpdate?