Welcome!

Join our community of MMO enthusiasts and game developers! By registering, you'll gain access to discussions on the latest developments in MMO server files and collaborate with like-minded individuals. Join us today and unlock the potential of MMO server development!

Join Today!

Plss HELP DEVELOPER

Status
Not open for further replies.
Newbie Spellweaver
Joined
Jul 16, 2008
Messages
23
Reaction score
0
Can ANYONE GIVE ME THE TRIGGER PLS...

OF EP4 CHAR MIX CLASS THANKS :construct :construct :construct
 
Experienced Elementalist
Joined
Jun 7, 2008
Messages
231
Reaction score
1
this
man
is
shenanigans
i
hate
this
damn
man
banned
infract
him
her
his
she
he
grrrrrrrrr..
 
Upvote 0
Newbie Spellweaver
Joined
Aug 31, 2006
Messages
61
Reaction score
1
Here it is :
Code:
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 ***
 
Last edited by a moderator:
Upvote 0
Status
Not open for further replies.
Back
Top