reborn trigger

Subject: reborn trigger Thu Dec 18, 2008 11:33 am

Code:

REATE TRIGGER [dbo].[reborn_by_seifer] ON [dbo].[ChaInfo]
after update
as
BEGIN

Update [ChaInfo] set [ChaInfo].ChaLevel=1, -- Level that you get after reborn
[ChaInfo].ChaReborn=[ChaInfo].ChaReborn + 1, -- Reborn counter
[ChaInfo].ChaExp=0, -- Set Exp back to 0
[ChaInfo].ChaStRemain = (100*[ChaInfo].ChaReborn), -- how many stat points you get per reborn
[ChaInfo].ChaMoney = [ChaInfo].ChaMoney - 1000000000, -- Optional : Reborn cost 2m
[ChaInfo].ChaSkillPoint = (10*[ChaInfo].ChaReborn), -- Set the Skillpoints per reborn
[ChaInfo].ChaSkills = NULL, -- Optional : Forget all skills after reborn
[ChaInfo].ChaSkillSlot = NULL, -- Optional : Delete shortcut list of skills
[ChaInfo].ChaQuest = NULL -- Optional : Delete quest list (need restart all quests) after reborn
From Inserted
Where Inserted.ChaLevel = 300 -- Level to reborn
and [ChaInfo].ChaReborn < 10 -- Max Reborn number
and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].UserNum =inserted.UserNum
and [ChaInfo].ChaBright >= 0 -- Optional : Require 0 or more attr for reborn
and [ChaInfo].ChaMoney >= 1000000000 -- Optional : Require 2m gold for reborn

End

Subject: Re: reborn trigger Thu Dec 18, 2008 11:35 am

CREATE TRIGGER [dbo].[NewChar_Level] ON [dbo].[ChaInfo]
after update
as
BEGIN

Update [ChaInfo] set [ChaInfo].ChaLevel=100
From Inserted
Where Inserted.ChaLevel = 1 and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].UserNum =inserted.UserNum

Update [ChaInfo] set [ChaInfo].ChaSkillPoint=400
From Inserted
Where Inserted.ChaSkillPoint = 0 and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].UserNum =inserted.UserNum

Update [ChaInfo] set [ChaInfo].ChaStRemain=500
From Inserted
Where Inserted.ChaStRemain = 3 and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].UserNum =inserted.UserNum

Update [ChaInfo] set [ChaInfo].ChaMoney=1000
From Inserted
Where Inserted.ChaMoney = 0 and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].UserNum =inserted.UserNum

Update [ChaInfo] set [ChaInfo].ChaPower=100
From Inserted
Where Inserted.ChaPower = 0 and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].UserNum =inserted.UserNum

Update [ChaInfo] set [ChaInfo].ChaStrong=100
From Inserted
Where Inserted.ChaStrong = 0 and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].UserNum =inserted.UserNum

Update [ChaInfo] set [ChaInfo].ChaStrength=100
From Inserted
Where Inserted.ChaStrength = 0 and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].UserNum =inserted.UserNum

Update [ChaInfo] set [ChaInfo].ChaSpirit=100
From Inserted
Where Inserted.ChaSpirit = 0 and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].UserNum =inserted.UserNum

Update [ChaInfo] set [ChaInfo].ChaDex=100
From Inserted
Where Inserted.ChaDex = 0 and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].UserNum =inserted.UserNum

Update [ChaInfo] set [ChaInfo].ChaIntel=100
From Inserted
Where Inserted.ChaIntel = 0 and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].UserNum =inserted.UserNum

Member Number of posts : 2 Registration date : 2008-12-07

Nice Abry 2loy 2loy mo lng pag help d2!thx sa script

Member Number of posts : 4 Registration date : 2008-12-16

this thread will delete soon cause this Reborn will not work in our server..!!

Subject: Re: reborn trigger Fri Dec 19, 2008 4:12 pm

anong..wla..gumana..na..kya...aus..na..ung..reborn..natin...

WLA....KA..KAC..nA22LOG..SA..SERVER

MAG..APPLY..KPA..CO-ADMIn..OR..GM..WLA..KA..nAMAn..ALAM...

Member Number of posts : 2 Registration date : 2008-12-07

nag mamarunong lng yan eh...pag pa senxahan mo na yan abry nag mamarunong lng yan wala nmn alm yan eh heheh na banned na yan...inalis na sa pagiging co admin..

Subject: Re: reborn trigger Fri Dec 19, 2008 9:07 pm

ahahaha uu nga wla naman karapatanyan a pagiging co-admin
mas marami paaq alam dyan eh mas may karapatan aq sa..pagiging
CO.ADMIn..kac..aq..lagi..2mu2long..kay..BRYONZ

TSAKA...D..KO..ALAM..nA..CO-ADMIn..YAn
ALAM..KO..GUEST...LnG..YAn,,D2^_6

Subject: Re: reborn trigger Fri Dec 19, 2008 9:08 pm

MInIMAUZ..CnU..KBA..GUS2..KITA..MAKILALA..BAKA..GAWIn..PAKITAnG..ASSISTAnT..KO^_6