Register for your free account! | Forgot your password?

Go Back   elitepvpers > MMORPGs > Dekaron > Dekaron Private Server
You last visited: Today at 05:08

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



Question about SQL JOB

Discussion on Question about SQL JOB within the Dekaron Private Server forum part of the Dekaron category.

Reply
 
Old 11/13/2015, 18:06   #16
 
elite*gold: 22
Join Date: Sep 2015
Posts: 951
Received Thanks: 81
Is there any way of what ive asked?
Proxynear is offline  
Old 11/13/2015, 21:52   #17
 
freez00's Avatar
 
elite*gold: 0
Join Date: Jun 2011
Posts: 415
Received Thanks: 140
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).
freez00 is offline  
Old 11/14/2015, 15:05   #18



 
guesswho-.-'s Avatar
 
elite*gold: 393
Join Date: Jan 2012
Posts: 2,445
Received Thanks: 1,102
Quote:
Originally Posted by freez00 View Post
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-.- is offline  
Old 11/14/2015, 15:08   #19
 
elite*gold: 22
Join Date: Sep 2015
Posts: 951
Received Thanks: 81
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?
Proxynear is offline  
Old 11/14/2015, 15:10   #20



 
guesswho-.-'s Avatar
 
elite*gold: 393
Join Date: Jan 2012
Posts: 2,445
Received Thanks: 1,102
rank higher than the csv handles, bugged items?
guesswho-.- is offline  
Old 11/14/2015, 15:16   #21
 
elite*gold: 22
Join Date: Sep 2015
Posts: 951
Received Thanks: 81
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
Proxynear is offline  
Old 11/14/2015, 15:18   #22



 
guesswho-.-'s Avatar
 
elite*gold: 393
Join Date: Jan 2012
Posts: 2,445
Received Thanks: 1,102
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
guesswho-.- is offline  
Reply




All times are GMT +1. The time now is 05:11.


Powered by vBulletin®
Copyright ©2000 - 2026, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2026 elitepvpers All Rights Reserved.