[Solved] Relog Lv 40 Get PVP

[rfan72]

hey all..
i want to ask you
is this correct query if player lv 40 can get pvp 50000 ?

use RF_WORLD
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE TRIGGER [dbo].[AutoPvp]
ON [dbo].[tbl_base]
FOR UPDATE
AS
BEGIN

declare @serial int

set @serial = (select serial from tbl_base where Lv = '40')

update tbl_pvporderview set PvpCash=50000 where Serial = @serial
End

i edit this query rom AutoPvp by play time and Insert Pvp . if i try this query my player can get 50000 pvp if they get lv 40. but i just want to know if my query had an error ?

Thank's before, sorry for my bad english.

[MentaL]

[ammandes]

lol no need query.just design your tbl_pvporderview

[imback]

isn't it better if edit by Quest Dat Reward ?