SA-MP Forums Archive
Slow MySQL load, or script issue? - Printable Version

+- SA-MP Forums Archive (https://sampforum.blast.hk)
+-- Forum: SA-MP Scripting and Plugins (https://sampforum.blast.hk/forumdisplay.php?fid=8)
+--- Forum: Scripting Help (https://sampforum.blast.hk/forumdisplay.php?fid=12)
+---- Forum: Help Archive (https://sampforum.blast.hk/forumdisplay.php?fid=89)
+---- Thread: Slow MySQL load, or script issue? (/showthread.php?tid=108609)



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?