Solved How to stop database updating when player gets experience.

[SlayingWorld]

As the title says, i want to know where exactly in the cpp file can i change to stop the server from updating my database whenever a player gains exp.

The reason i want this is because im running a war server. But i only want to gain experience while im alive, but when i die i want to go back to the default level.

 

[Danger II]

You're going the wrong way, you could easily write few lines so player will be set to a specific level after their death.
Another way would be the "read-only"-function.

 

[StreamSide]

you can always edit exp events in the new tfs revs

 

[forgee]

I would probably set 'save' to 0 on first login. This should work on TFS 1.0+, if you use a different version the exact syntax will vary.

db.query("UPDATE players SET save = 0 WHERE id = " .. player:getGuid())

https://github.com/otland/forgotten...15fe5e2984d4b997f82d10769f205c/schema.sql#L44
https://github.com/otland/forgotten...7f82d10769f205c/src/iologindata.cpp#L596-L606

 

[SlayingWorld]

Problem is the newest TFS server will save/update the database even if i only gain 1 exp...

And i want to give experience per kill.

As long as you stay alive without dying you can gain experience by killing, once you die you will start back at the level you got the character.

 

[SlayingWorld]

Edit: I already put my database in read only by the way, its the first thing i went with to be honest. And it actually works, but i hate getting all those PHP updating error messages in my server console. Its gonna be pretty annoying once a lot of players start killing others, and it can end up bugging out the server.