Plss HELP DEVELOPER

[cayon_bubu]

Can ANYONE GIVE ME THE TRIGGER PLS...

OF EP4 CHAR MIX CLASS THANKS :construct :construct :construct

 

[Abry]

new
thread
but
same
topic
with
the
other
one

 

[Tenzou]

this
man
is
bullshit
i
hate
this
damn
man
banned
infract
him
her
his
she
he
grrrrrrrrr..

 

[trespazzer]

Here it is :

USE [RanGame1]
GO
/****** Object: Trigger [dbo].[RanGame1_Trigger] Script Date: 06/03/2008 19:27:43 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE TRIGGER [dbo].[RanGame1_Trigger] ON [dbo].[ChaInfo]
after update
as
BEGIN

Update [ChaInfo] set [ChaInfo].ChaClass = 16
From inserted
Where Inserted.ChaClass = 1
and [ChaInfo].ChaName = inserted.ChaName
and [ChaInfo].ChaNum = inserted.ChaNum

Update [ChaInfo] set [ChaInfo].ChaClass = 16
From inserted
Where Inserted.ChaClass = 2
and [ChaInfo].ChaName = inserted.ChaName
and [ChaInfo].ChaNum = inserted.ChaNum

Update [ChaInfo] set [ChaInfo].ChaClass = 32
From inserted
Where Inserted.ChaClass = 4
and [ChaInfo].ChaName = inserted.ChaName
and [ChaInfo].ChaNum = inserted.ChaNum

Update [ChaInfo] set [ChaInfo].ChaClass = 32
From inserted
Where Inserted.ChaClass = 8
and [ChaInfo].ChaName = inserted.ChaName
and [ChaInfo].ChaNum = inserted.ChaNum

End

* But i think, you may ask us again, HOW TO REMOVE THIS TRIGGER. Want to know why ? try it.

** this trigger, I got from someone here, sorry for the name, I couldnot remember. It is not mine. So, credit and thanks to him ***

 

[austhistikated]

Warning @ TS!
Use the search button first...
It doesnt took me 5 minutes to search for the trigger...
And dont do double threading!.
Thread Closed.