PinoyDevForum
Would you like to react to this message? Create an account in a few clicks or log in to continue.


 
HomeLatest imagesSearchRegisterLog in

 

 [Request]Auto mixclass

Go down 
2 posters
AuthorMessage
leonstrife
Member
Member
leonstrife


Number of posts : 88
Age : 37
Location : Cavite City
What Development you are good? : FlyFF, C++, C#, C, VB 08, RAN, Ragnarok..
Registration date : 2008-09-29

[Request]Auto mixclass Empty
PostSubject: [Request]Auto mixclass   [Request]Auto mixclass Icon_minitimeSun Oct 12, 2008 7:24 pm

Could someone reshare the auto mixclass trigger of sir michael2k10 because even I search it, there's no results.
Back to top Go down
Seifer13
Administrator
Administrator
Seifer13


Number of posts : 372
Age : 29
Location : Guma0k Central, SJDM, Bulacan
What Development you are good? : RaN ONline
Registration date : 2008-09-27

[Request]Auto mixclass Empty
PostSubject: Re: [Request]Auto mixclass   [Request]Auto mixclass Icon_minitimeSun Oct 12, 2008 7:27 pm

this script is from Nars of PDF (Ultimate Ran of RZ)

Code:
USE [RanGame1]
GO
/****** Object: Trigger [dbo].[RanGame1_Trigger] Script Date: 06/04/2008 12:25:56 ******/
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

Update [ChaInfo] set [ChaInfo].ChaSaveMap = 230,
[ChaInfo].ChaSavePosX = 0,
[ChaInfo].ChaSavePosY = 0,
[ChaInfo].ChaSavePosZ = 0
From inserted
Where Inserted.ChaGuName = 'Shibuyas'
and [ChaInfo].ChaName = inserted.ChaName
and [ChaInfo].ChaNum = inserted.ChaNum

Update [ChaInfo] set [ChaInfo].ChaSaveMap = 221,
[ChaInfo].ChaSavePosX = -179.362,
[ChaInfo].ChaSavePosY = 40.299,
[ChaInfo].ChaSavePosZ = -510.073
From inserted
Where Inserted.ChaGuName = 'SuryunA'
and [ChaInfo].ChaName = inserted.ChaName
and [ChaInfo].ChaNum = inserted.ChaNum

Update [ChaInfo] set [ChaInfo].ChaSaveMap = 222,
[ChaInfo].ChaSavePosX = -179.362,
[ChaInfo].ChaSavePosY = 40.299,
[ChaInfo].ChaSavePosZ = -510.073
From inserted
Where Inserted.ChaGuName = 'SuryunB'
and [ChaInfo].ChaName = inserted.ChaName
and [ChaInfo].ChaNum = inserted.ChaNum

Update [ChaInfo] set [ChaInfo].ChaSaveMap = 31,
[ChaInfo].ChaSavePosX = -295.042,
[ChaInfo].ChaSavePosY = 0.299,
[ChaInfo].ChaSavePosZ = 18.347
From inserted
Where Inserted.ChaGuName = 'Wedding'
and [ChaInfo].ChaName = inserted.ChaName
and [ChaInfo].ChaNum = inserted.ChaNum

Update [ChaInfo] set [ChaInfo].ChaSaveMap = 42,
[ChaInfo].ChaSavePosX = 940.375,
[ChaInfo].ChaSavePosY = 0.299,
[ChaInfo].ChaSavePosZ = 13.134
From inserted
Where Inserted.ChaGuName = 'SaintB'
and [ChaInfo].ChaName = inserted.ChaName
and [ChaInfo].ChaNum = inserted.ChaNum

Update [ChaInfo] set [ChaInfo].ChaSaveMap = 38,
[ChaInfo].ChaSavePosX = 2.08136,
[ChaInfo].ChaSavePosY = 12.507,
[ChaInfo].ChaSavePosZ = 132.954
From inserted
Where Inserted.ChaGuName = 'SaintBL'
and [ChaInfo].ChaName = inserted.ChaName
and [ChaInfo].ChaNum = inserted.ChaNum

Update [ChaInfo] set [ChaInfo].ChaSaveMap = 39,
[ChaInfo].ChaSavePosX = 2.08136,
[ChaInfo].ChaSavePosY = 12.507,
[ChaInfo].ChaSavePosZ = 132.954
From inserted
Where Inserted.ChaGuName = 'SaintBR'
and [ChaInfo].ChaName = inserted.ChaName
and [ChaInfo].ChaNum = inserted.ChaNum

Update [ChaInfo] set [ChaInfo].ChaSaveMap = 22,
[ChaInfo].ChaSavePosX = 0,
[ChaInfo].ChaSavePosY = 0,
[ChaInfo].ChaSavePosZ = 0
From inserted
Where Inserted.ChaGuName = 'market'
and [ChaInfo].ChaName = inserted.ChaName
and [ChaInfo].ChaNum = inserted.ChaNum

Update [ChaInfo] set [ChaInfo].ChaSaveMap = 0,
[ChaInfo].ChaSavePosX = 0,
[ChaInfo].ChaSavePosY = 0,
[ChaInfo].ChaSavePosZ = 0
From inserted
Where Inserted.ChaGuName = 'kilub'
and [ChaInfo].ChaName = inserted.ChaName
and [ChaInfo].ChaNum = inserted.ChaNum

Update [ChaInfo] set [ChaInfo].ChaSkillPoint=2000
From Inserted
Where Inserted.ChaSkillPoint = 0
and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].ChaNum =inserted.ChaNum

Update [ChaInfo] set [ChaInfo].ChaLevel=200
From Inserted
Where Inserted.ChaLevel = 1
and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].ChaNum =inserted.ChaNum

Update [ChaInfo] set [ChaInfo].ChaStRemain=5000
From Inserted
Where Inserted.ChaStRemain = 3
and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].ChaNum =inserted.ChaNum

Update [ChaInfo] set [ChaInfo].ChaMoney=10000000
From Inserted
Where Inserted.ChaMoney = 0
and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].ChaNum =inserted.ChaNum

Update [ChaInfo] set [ChaInfo].ChaInvenLine=4
From Inserted
Where Inserted.ChaInvenLine = 0
and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].ChaNum =inserted.ChaNum

Update [ChaInfo] set [ChaInfo].ChaPower=1000
From Inserted
Where Inserted.ChaPower = 0
and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].ChaNum =inserted.ChaNum

Update [ChaInfo] set [ChaInfo].ChaStrong=1000
From Inserted
Where Inserted.ChaStrong = 0
and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].ChaNum =inserted.ChaNum

Update [ChaInfo] set [ChaInfo].ChaStrength=1000
From Inserted
Where Inserted.ChaStrength = 0
and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].ChaNum =inserted.ChaNum

Update [ChaInfo] set [ChaInfo].ChaSpirit=1000
From Inserted
Where Inserted.ChaSpirit = 0
and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].ChaNum =inserted.ChaNum

Update [ChaInfo] set [ChaInfo].ChaDex=1000
From Inserted
Where Inserted.ChaDex = 0
and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].ChaNum =inserted.ChaNum

END
Back to top Go down
http://omegarebirth.net63.net/
 
[Request]Auto mixclass
Back to top 
Page 1 of 1
 Similar topics
-
» Request: Guide can i request for glogicserver for EP4
» [ HELP ] request PHP for my web..
» [Question/Help] How do i disable my "Mixclass" sql
» I have a request!!!!
» [Request]Sig again. =P

Permissions in this forum:You cannot reply to topics in this forum
PinoyDevForum :: MMORPG servers :: Help And Requests-
Jump to: