Amazing Ran

EP3-EP4 mix , up to 300d skills, ALL skills and set are Free, come and Join us
 
HomeHome  Portal*Portal*  FAQFAQ  SearchSearch  MemberlistMemberlist  UsergroupsUsergroups  RegisterRegister  Log inLog in  

Share | 
 

 reborn trigger

View previous topic View next topic Go down 
AuthorMessage
[GM]Crimson`Chase
Game-Master
Game-Master


Number of posts : 7
Registration date : 2008-12-07

PostSubject: 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

Back to top Go down
View user profile
[GM]Crimson`Chase
Game-Master
Game-Master


Number of posts : 7
Registration date : 2008-12-07

PostSubject: 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
Back to top Go down
View user profile
minimauz
Member
Member


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

PostSubject: Re: reborn trigger   Thu Dec 18, 2008 5:41 pm

Nice Abry 2loy 2loy mo lng pag help d2!thx sa script
Back to top Go down
View user profile
•poseidon•
Member
Member


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

PostSubject: Re: reborn trigger   Thu Dec 18, 2008 7:58 pm

this thread will delete soon cause this Reborn will not work in our server..!!
Back to top Go down
View user profile
[GM]Crimson`Chase
Game-Master
Game-Master


Number of posts : 7
Registration date : 2008-12-07

PostSubject: 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...
Back to top Go down
View user profile
minimauz
Member
Member


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

PostSubject: Re: reborn trigger   Fri Dec 19, 2008 5:52 pm

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..
Back to top Go down
View user profile
[GM]Crimson`Chase
Game-Master
Game-Master


Number of posts : 7
Registration date : 2008-12-07

PostSubject: 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
Back to top Go down
View user profile
[GM]Crimson`Chase
Game-Master
Game-Master


Number of posts : 7
Registration date : 2008-12-07

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

MInIMAUZ..CnU..KBA..GUS2..KITA..MAKILALA..BAKA..GAWIn..PAKITAnG..ASSISTAnT..KO^_6
Back to top Go down
View user profile
Sponsored content




PostSubject: Re: reborn trigger   

Back to top Go down
 
reborn trigger
View previous topic View next topic Back to top 
Page 1 of 1
 Similar topics
-
» The Bleeding Scythe reborn
» Chrono Trigger
» Final Fantasy XIV A Realm Reborn - Béta test phase 1
» [A] Reborn scourge - RP
» Chrono Trigger Remastered Soundtrack!

Permissions in this forum:You cannot reply to topics in this forum
Amazing Ran :: General Discussions-
Jump to: