Question about SQL JOB

Is there any way of what ive asked?

What I did Proxy was put a SQL script to send items by mail every day players log in as reward. Anything you want to give a player in the user_character table requires the player to not be logged in. guesswho's example was to automatically give a player ppoints when they log out. Since the server exe has a hold on that database table when a player is logged in, ppoints can only be given by the server (DK Square or mobs that give ppoints when you kill them).

Quote:

Originally Posted by freez00 What I did Proxy was put a SQL script to send items by mail every day players log in as reward. Anything you want to give a player in the user_character table requires the player to not be logged in. guesswho's example was to automatically give a player ppoints when they log out. Since the server exe has a hold on that database table when a player is logged in, ppoints can only be given by the server (DK Square or mobs that give ppoints when you kill them).

my example saves the additional PP in a column that is not affected by the session server at any point. its there to hold the data until they log out, then it gets applied.
giving PP by killing mobs defeats the purpose of giving stuff for staying online, it requires players to put some effort in it. he wants to have as many online (be it afk or not) players as possible and thats his way to convince them to do so.
as far as I know only mail and cash db can be updated in real time with the player online. Since he's unable to add item->PP exchanger, I believe the way I presented is the best since I also provided the queries.

guesswho i got another question to you because it is some problem at ASM.
I put test server online and after my friends connect on it the dekaronserver.exe randomly crashes (its not about ram because it was 32gb) .
When i look at debug , theres non error , after i click close the program when it shows the pop up of crash , in debug i just see Castserver restarting . So what can be the real problem?

rank higher than the csv handles, bugged items?

What u mean with rank highter than csv?
And bugged items ? If it happens maybe exe crash at loading
I really cant find the why , just updated mob heals , teleports and nothing more and it is just crashing

the server doesnt auto-correct your rank.
like, for example, if you have certain items that dont exist on the server side, it'll correct it and 'remove' them from your character (client still shows them because sessionserver forwards data straight from the db without handling it) after you relog.
when your last rank is 40 and one of the players has rank 45 somehow, the server wont autocorrect it and will crash. fishy programming but then again there are ways to prevent it