Problem with update database

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

CacheServer.exe

Quote:

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...

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.

Quote:

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?

Quote:

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.

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

Quote:

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?

Quote:

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.

Quote:

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..

Quote:

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?

Quote:

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?

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

Quote:

Originally Posted by KingKeesie Yes what is your skypename? i will add u we can talk from there

adar_elkabetz

Up

Help