HomeFAQSearchRegisterLog in

Share | 
 

 [Request]Auto mixclass

Go down 
AuthorMessage
leonstrife
Member
Member
avatar

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

PostSubject: [Request]Auto mixclass   Sun 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
View user profile
Seifer13
Sub-Administrator
avatar

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

PostSubject: Re: [Request]Auto mixclass   Sun 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

_________________
Stay as a nice and good PDFers even you do a bighelp to all PDF Members,,,
~=OmegaRaN Episode 4 Private Server Owner=~
Back to top Go down
View user profile http://omegarebirth.net63.net/
 
[Request]Auto mixclass
Back to top 
Page 1 of 1
 Similar topics
-
» image edit request please read
» Response_Code = -1 Error_Message = Request Error
» How to add auto-resize
» How to capture an AJAX request with SeleniumRC test?
» Command for auto populated text verification.

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