Problem with update database

[adarelk2]

If i enter this command in the sql
Update Character_TBL set m_nlevel=1
Its updated but when i login to game its return again ...
Its not realy updated for update somthing in character_tbl i need to shutdown my server everytime, im using v15 someone can send me a code on php for update level?
Its for credit panel

[Meutledaron]

CacheServer.exe

[adarelk2]

Originally Posted by Meutledaron

CacheServer.exe

what to do with him?

Please help i dont know what to do
The command /level work but why if i change in the sql
Its not updated i need to close the server...

[xTwiLightx]

The data is being kept in the Cache - so you'll need to figure out how to prevent some of the character data being kept in the cache or that the servers are always relying on the data coming from the DBs instead of the cache.

[adarelk2]

Originally Posted by xTwiLightx

The data is being kept in the Cache - so you'll need to figure out how to prevent some of the character data being kept in the cache or that the servers are always relying on the data coming from the DBs instead of the cache.

Ok, can you explain me about the cache?

[xTwiLightx]

Originally Posted by adarelk2

Ok, can you explain me about the cache?

https://en.wikipedia.org/wiki/Cache_(computing)

Long story short: A cache saves stuff to prevent loading that stuff over and over again.

And no, I won't (and can't) tell you how the Cache Server in Flyff works. Do your own research, read the code and learn from it.

[KingKeesie]

Just close your server and edit your database after just start server again. So cache will be loaded from database again

[adarelk2]

Originally Posted by xTwiLightx

https://en.wikipedia.org/wiki/Cache_(computing)

Long story short: A cache saves stuff to prevent loading that stuff over and over again.

And no, I won't (and can't) tell you how the Cache Server in Flyff works. Do your own research, read the code and learn from it.

I readed it but my english is not the best so i didnt understand...
Can you send me a code php for update level?

[KingKeesie]

Originally Posted by adarelk2

I readed it but my english is not the best so i didnt understand...
Can you send me a code php for update level?

You should not do this inside your database because you need to change level and exp and much more so this will give you probably some buggs ingame. Just gave it right for admin or gamemaster and use your gm commands ingame, Much easier.

[adarelk2]

Originally Posted by KingKeesie

You should not do this inside your database because you need to change level and exp and much more so this will give you probably some buggs ingame. Just gave it right for admin or gamemaster and use your gm commands ingame, Much easier.

I want to build credit panel if you know what i mean...
Set reset,change nick,get money,and all this..

[KingKeesie]

Originally Posted by adarelk2

I want to build credit panel if you know what i mean...
Set reset,change nick,get money,and all this..

Okay now i understand what ur planning. So witch update statements you already have?

[adarelk2]

Originally Posted by KingKeesie

Okay now i understand what ur planning. So witch update statements you already have?

i didnt understand what you mean
can you explain again?
btw do you have skype?

[KingKeesie]

Yes what is your skypename? i will add u we can talk from there

[adarelk2]

Originally Posted by KingKeesie

Yes what is your skypename? i will add u we can talk from there

adar_elkabetz

Up

[adarelk2]

Help