BattleMatch Start/Stop Trigger

[advenire]

I didn't tested new edition but old edition was works fine and I fixed some bugs with it. :surprise:

CREATE TRIGGER [BattleMatch_IO] ON [dbo].[tblGameID1]
for update



AS


begin

if update(map)

begin
declare @_gameid varchar(14)
declare @_map_d int
declare @_map_i int
select @_map_d = map, @_gameid = gameid from deleted
select @_map_i = map from inserted

if @_map_d = 21 and @_map_i = 132

begin

insert tblgameid2 select * from deleted

UPDATE TBLGAMEID1 SET Lvl = '1' where gameid = @_gameid
UPDATE TBLGAMEID1 SET Item = '0' where gameid = @_gameid
UPDATE TBLGAMEID1 SET Strength = '10' where gameid = @_gameid
UPDATE TBLGAMEID1 SET Spirit = '10' where gameid = @_gameid
UPDATE TBLGAMEID1 SET Dexterity = '10' where gameid = @_gameid
UPDATE TBLGAMEID1 SET Power = '10' where gameid = @_gameid
UPDATE TBLGAMEID1 SET Fame = '0' where gameid = @_gameid
UPDATE TBLGAMEID1 SET HP = '10' where gameid = @_gameid
UPDATE TBLGAMEID1 SET MP = '10' where gameid = @_gameid
UPDATE TBLGAMEID1 SET SP = '10' where gameid = @_gameid
UPDATE TBLGAMEID1 SET DP = '10' where gameid = @_gameid
UPDATE TBLGAMEID1 SET Bonus = '2' where gameid = @_gameid
UPDATE TBLGAMEID1 SET Money = '300' where gameid = @_gameid
UPDATE TBLGAMEID1 SET QuickItem = '0' where gameid = @_gameid
UPDATE TBLGAMEID1 SET BankMoney = '200000000' where gameid = @_gameid
UPDATE TBLGAMEID1 SET BankItem = '0' where gameid = @_gameid
UPDATE TBLGAMEID1 SET StoryQuestState = '-1' where gameid = @_gameid
UPDATE TBLGAMEID1 SET Bonus2 = '0' where gameid = @_gameid
UPDATE TBLGAMEID1 SET SBonus = '0' where gameid = @_gameid
UPDATE TBLGAMEID1 SET STotalBonus = '0' where gameid = @_gameid
UPDATE TBLGAMEID1 SET BankSigMoney = '0' where gameid = @_gameid
UPDATE TBLGAMEID1 SET BankItem2 = '0' where gameid = @_gameid

end

else if (@_map_d >= 132 and @_map_d <= 136) and @_map_i = 21

begin

update tblgameid1 set GameID = (select GameID from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set BillID = (select BillID from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set Lvl = (select Lvl from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set Face = (select Face from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set Map = (select Map from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set X = (select X from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set Y = (select Y from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set TileKind = (select TileKind from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set Item = (select Item from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set Equipment = (select Equipment from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set Skill = (select Skill from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set SpecialSkill = (select SpecialSkill from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set Strength = (select Strength from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set Spirit = (select Spirit from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set Dexterity = (select Dexterity from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set Power = (select Power from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set Fame = (select Fame from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set Experiment = (select Experiment from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set HP = (select HP from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set MP = (select MP from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set SP = (select SP from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set DP = (select DP from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set Bonus = (select Bonus from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set Money = (select Money from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set QuickItem = (select QuickItem from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set QuickSkill = (select QuickSkill from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set QuickSpecialSkill = (select QuickSpecialSkill from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set BankMoney = (select BankMoney from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set BankItem = (select BankItem from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set SETimer = (select SETimer from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set PKTimer = (select PKTimer from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set Color1 = (select Color1 from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set Color2 = (select Color2 from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set PoisonUsedDate = (select PoisonUsedDate from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set LovePoint = (select LovePoint from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set ArmyHired = (select ArmyHired from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set ArmyMarkIndex = (select ArmyMarkIndex from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set Permission = (select Permission from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set BonusInitCount = (select BonusInitCount from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set StoryQuestState = (select StoryQuestState from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set QuestItem = (select QuestItem from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set SubQuestKind = (select SubQuestKind from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set SubQuestClientNPCID = (select SubQuestClientNPCID from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set SubQuestClientNPCFace = (select SubQuestClientNPCFace from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set SubQuestClientNPCMap = (select SubQuestClientNPCMap from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set SubQuestItem = (select SubQuestItem from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set SubQuestDestFace = (select SubQuestDestFace from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set SubQuestDestMap = (select SubQuestDestMap from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set SubQuestTimer = (select SubQuestTimer from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set SubQuestGiftExperience = (select SubQuestGiftExperience from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set SubQuestGiftFame = (select SubQuestGiftFame from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set SubQuestGiftItem = (select SubQuestGiftItem from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set OPArmy = (select OPArmy from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set OPPKTimer = (select OPPKTimer from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set SurvivalEvent = (select SurvivalEvent from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set SurvivalTime = (select SurvivalTime from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set Bonus2 = (select Bonus2 from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set SBonus = (select SBonus from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set STotalBonus = (select STotalBonus from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set PKPenaltyCount = (select PKPenaltyCount from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set PKPenaltyDecreaseTimer = (select PKPenaltyDecreaseTimer from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set SigMoney = (select SigMoney from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set BankSigMoney = (select BankSigMoney from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set BankItem2 = (select BankItem2 from tblgameid2 where gameid = @_gameid) where gameid = @_gameid
update tblgameid1 set TLETimer = (select TLETimer from tblgameid2 where gameid = @_gameid) where gameid = @_gameid

delete from tblgameid2 where gameid = @_gameid

end

else if (@_map_d > = 132 and @_map_d <= 136) and @_map_i = 43

begin

update tblgameid1 set map='132', x='50', y='25' where gameid = @_gameid

end


end


end


It was created by FREEZONE™ - Redmoon Freeserver Develop Team. (http://club.ipop.co.kr/renovatio) - For Korean ONLY!!

[MentaL]

[Nickyy]

This is for Battle Dimension not battlematch, and it is not neccessary if you use the RMS_USERDB_INSERTBATTLEID procedure.