Bug Vote Problem and Trigger Made ZoneServer Crash

[ElectricShock]

hello RZ long time no see

i just have problem in my serv

a few people using vote bug with level 1

i try "db trigger" solution to change level requir

but it just made my ZoneServer Crash

anyone have solution ?

 

[Marnkx]

hello RZ long time no see

i just have problem in my serv

a few people using vote bug with level 1

i try "db trigger" solution to change level requir

but it just made my ZoneServer Crash

anyone have solution ?

try this Query from Agony

USE [RF_WORLD]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

Create TRIGGER [dbo].[votelimit] 
   ON  [dbo].[tbl_general]
   AFTER UPDATE
AS

BEGIN
UPDATE dbo.tbl_general SET tmRaceBossVote = GETDATE() 
WHERE Serial 
IN 
(SELECT T2.Serial FROM dbo.tbl_base AS T1, dbo.tbl_general AS T2
WHERE T1.Serial = T2.Serial 
	AND T1.Lv < '51' 
	AND T2.tmRaceBossVote < CURRENT_TIMESTAMP - 1)


END
GO

 

[Agungg]

instead it was the same as before?

 

[ElectricShock]

try this Query from Agony

USE [RF_WORLD]
GO

SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

Create TRIGGER [dbo].[votelimit] 
   ON  [dbo].[tbl_general]
   AFTER UPDATE
AS

BEGIN
UPDATE dbo.tbl_general SET tmRaceBossVote = GETDATE() 
WHERE Serial 
IN 
(SELECT T2.Serial FROM dbo.tbl_base AS T1, dbo.tbl_general AS T2
WHERE T1.Serial = T2.Serial 
	AND T1.Lv < '51' 
	AND T2.tmRaceBossVote < CURRENT_TIMESTAMP - 1)


END
GO

im using this query

and then my zone crash after 2 minutes

 

[Rayzer Raid]

yea same here, using that query result to crash on zoneserver after 5-15mins

 

[Agungg]

i use triger Vote Archon server crash if a player Accept New Guild Member @Game

 

[rfan72]

open your SQL goto tbl_general open triggers and delete votelimit .
CMIIW :3