[BUG]Help me bug dbo.usp

03/13/2020 15:39 medaion#1
Good evening,
Since last night, I've been trying to fix a basic data problem.
As soon as I activate the events in the gameserver.opt
I have a crash after x time this silk spent with 1 player logged in.

Here's the error:

Code:
DB_UpdateTimeBasedEvent(dbo.usp_rz_web_event_exec): Procédure stockée 'dbo.usp_rz_web_event_exec' introuvable
I think I'm missing a procedure in my database. Do you think I would have that procedure?
I would like to fix this problem without having to disable the event time based functions.
03/13/2020 16:10 InkDevil#2
You should probably activate event_script, mit event_db in opt.
03/13/2020 16:31 medaion#3
In my gameserver.opt this line is active:

N:game.use_time_based_event_db:1
N:game.term_for_time_based_event_db:1
N:game.use_time_based_event_script:1
N:game.term_for_time_based_event_script:1

but the server crashes if a player is connected
03/13/2020 16:46 InkDevil#4
Quote:
Originally Posted by medaion View Post
In my gameserver.opt this line is active:

N:game.use_time_based_event_db:1
N:game.term_for_time_based_event_db:1
N:game.use_time_based_event_script:1
N:game.term_for_time_based_event_script:1

but the server crashes if a player is connected
use this one:
Code:
T:game.use_time_based_event_db:0
N:game.term_for_time_based_event_db:0
T:game.use_time_based_event_script:1
N:game.term_for_time_based_event_script:60
03/13/2020 17:18 medaion#5
That did fix my crash problem.
But oddly enough, I no longer receive a reward.
I'm going to do some tests with the clues you just gave me.
03/13/2020 18:09 InkDevil#6
Quote:
Originally Posted by medaion View Post
That did fix my crash problem.
But oddly enough, I no longer receive a reward.
I'm going to do some tests with the clues you just gave me.
it's triggered each 60 minutes with the code i wrote.
So if you want to have a smaller intervall, just change
term_for_time_based_event_script again
03/13/2020 18:18 medaion#7
It's okay, it's working again.
Thank you very much, but the basic flag is 8192, but it doesn't work for events.
On the other hand if I put the flag in 4 or 128 it works ...
03/13/2020 19:32 MohcenMaher#8
---------------
Quote:
CREATE PROCEDURE [dbo].[usp_rz_web_event_exec]
@nSID int,
@tnPCBang smallint
AS
BEGIN
INSERT INTO EventLogin values ( @nSID )
END
---------------
03/13/2020 20:09 medaion#9
Quote:
Originally Posted by MohcenMaher View Post
---------------

---------------

Thanks, that's exactly what I needed as a procedure to fix the buggy function!