[BUG]Help me bug dbo.usp

[medaion]

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:

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.

[InkDevil]

You should probably activate event_script, mit event_db in opt.

[medaion]

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

[InkDevil]

Originally Posted by medaion

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:

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

[medaion]

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.

[InkDevil]

Originally Posted by medaion

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

[medaion]

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

[MohcenMaher]

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

CREATE PROCEDURE [dbo].[usp_rz_web_event_exec]
@nSID int,
@tnPCBang smallint
AS
BEGIN
INSERT INTO EventLogin values ( @nSID )
END

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

[medaion]

Originally Posted by MohcenMaher

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

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

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