leonstrife Member
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
| Subject: [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. | |
|
Seifer13 Administrator
Number of posts : 372 Age : 29 Location : Guma0k Central, SJDM, Bulacan What Development you are good? : RaN ONline Registration date : 2008-09-27
| Subject: 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 | |
|