end map dilemma

[talmera]

Hi, I've been coding a cross server experience system for my community and I have it mostly ready for public testing but I'm having trouble figuring out how to get it to save the exp when the map is getting changed I have it saving fine on player disconnect.

I was wondering what would be the best approach to do this?

[Eccid]

Try using the Shutdown Hook and making it save then.

[talmera]

oh cool I completely missed that hook when looking for a solution XD thanks I'll give it a go.

[talmera]

Hmmm so I set up this function for use on the Shutdown hook you suggested but it's not called on map change like I was hoping?

Code: Lua

1. function saveAll()
2.        
3.         for k,v in pairs( player.GetAll() ) do
4.        
5.                 local PlyFormat = string.Replace(v:SteamID(), ":", "")
6.                 local PlySteam = v:SteamID()
7.                 local saver = Database:query("UPDATE exp_storage SET `exp_total`='" .. tec_PlyExp[PlySteam] .. "' WHERE `steam_id`='" .. PlyFormat .. "'" )
8.                
9.                 saver.onSuccess = function()
10.                         print("[TGEXP] User saved to database")
11.                 end
12.                
13.                 saver.onError = function()
14.                         print("[TGEXP] save failed on leave")
15.                 end
16.                
17.                 saver:start()
18.        
19.         end
20. end
21.  
22. hook.Add( "ShutDown", "savingAll", saveAll )

*Notes*

I am using the MySQLoo "addon" to update a database with the new values a player has for exp and I'm attempting to save all players on map change/server shutdown.

*Update*

after some tinkering it appears to be working now.

[Megiddo]

Gmod crashes a lot, I'd recommend saving in intervals you're comfortable losing. E.g., if you only want to lose up to 30 seconds of data, save every 30 seconds.