Raised This Month: $ Target: $400
 0% 

SQL not loading or saving correctly?


Post New Thread Reply   
 
Thread Tools Display Modes
Author Message
Y060N
BANNED
Join Date: Dec 2011
Location: www.equilibriumcs.com
Old 04-24-2012 , 01:34   SQL not loading or saving correctly?
Reply With Quote #1

Well, people report losing their XP after playing and it saving fine for a week or more. It seems to happen to 1-2 people a day and I don't really want this to happen.

Right now I have it to read out of my vault file if they aren't inside the SQL because I converted over to SQL.

Last edited by Y060N; 04-27-2012 at 12:35.
Y060N is offline
iBrazilian
Senior Member
Join Date: May 2011
Old 04-24-2012 , 11:28   Re: SQL not loading or saving correctly?
Reply With Quote #2

I ran into this problem recently, don't recall the fix.
__________________
Pokemod Season 5 [ |||||||||| Complete]
iBrazilian is offline
.Dare Devil.
Veteran Member
Join Date: Sep 2010
Old 04-24-2012 , 12:02   Re: SQL not loading or saving correctly?
Reply With Quote #3

if you saving a things on client_disconnect, then that may will happen ( no save correctly )
.Dare Devil. is offline
Y060N
BANNED
Join Date: Dec 2011
Location: www.equilibriumcs.com
Old 04-24-2012 , 13:50   Re: SQL not loading or saving correctly?
Reply With Quote #4

When I strictly used nvault to save on client_disconnect, it never had this problem. Do you mind explaining why it is different with SQL?
Y060N is offline
<VeCo>
Veteran Member
Join Date: Jul 2009
Location: Bulgaria
Old 04-24-2012 , 14:19   Re: SQL not loading or saving correctly?
Reply With Quote #5

Where do you load this?
__________________
<VeCo> is offline
Y060N
BANNED
Join Date: Dec 2011
Location: www.equilibriumcs.com
Old 04-24-2012 , 14:34   Re: SQL not loading or saving correctly?
Reply With Quote #6

I load it on client_putinserver, and I save it in client_disconnect

Last edited by Y060N; 04-24-2012 at 14:34.
Y060N is offline
Exolent[jNr]
Veteran Member
Join Date: Feb 2007
Location: Tennessee
Old 04-24-2012 , 14:34   Re: SQL not loading or saving correctly?
Reply With Quote #7

Quote:
Originally Posted by Y060N View Post
When I strictly used nvault to save on client_disconnect, it never had this problem. Do you mind explaining why it is different with SQL?
You are threading queries on client disconnect.
When the map changes, all players are being sent the disconnect forward.
If there are any threaded queries left queued up when the map ends, they do not get executed.
__________________
No private work or selling mods.
Quote:
Originally Posted by xPaw View Post
I love you exolent!
Exolent[jNr] is offline
Y060N
BANNED
Join Date: Dec 2011
Location: www.equilibriumcs.com
Old 04-24-2012 , 14:36   Re: SQL not loading or saving correctly?
Reply With Quote #8

Well they might not get executed, so I will change that. But does that explain why their stats are getting reset? If it's not getting executed, then their stats should be the same as map start, but it seems that people are losing XP after 3-4 days of playing on the server.

As in all stats are brought to 0 and saved then.

Last edited by Y060N; 04-24-2012 at 14:37.
Y060N is offline
Exolent[jNr]
Veteran Member
Join Date: Feb 2007
Location: Tennessee
Old 04-24-2012 , 14:38   Re: SQL not loading or saving correctly?
Reply With Quote #9

You may be saving before the stats could be loaded for the player.
Such as:
1. Player joins
2. Queue to load stats
3. Player disconnects
4. Blank stats are saved
5. Player is not here, so loaded stats are discarded.
__________________
No private work or selling mods.
Quote:
Originally Posted by xPaw View Post
I love you exolent!
Exolent[jNr] is offline
Y060N
BANNED
Join Date: Dec 2011
Location: www.equilibriumcs.com
Old 04-24-2012 , 14:41   Re: SQL not loading or saving correctly?
Reply With Quote #10

So, you you suspect saving at the end of every round would be better? I understand the theory. One of my players is a good friend that got reset, and one time he got disconnected for being AFK. When he came back into the server all his stats were 0. He didn't connect and disconnect or anything like that.

Last edited by Y060N; 04-24-2012 at 14:42.
Y060N is offline
Reply



Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump


All times are GMT -4. The time now is 07:52.


Powered by vBulletin®
Copyright ©2000 - 2024, vBulletin Solutions, Inc.
Theme made by Freecode