: Welcome To UnixRAN Online :
Would you like to react to this message? Create an account in a few clicks or log in to continue.

: Welcome To UnixRAN Online :

Your RAN Online Private Server
 
HomePortalGallerySearchLatest imagesRegisterLog in

 

 Try my Auto Reborn

Go down 
AuthorMessage
mapapoye

mapapoye


Number of posts : 4
Registration date : 2007-07-08

Try my Auto Reborn Empty
PostSubject: Try my Auto Reborn   Try my Auto Reborn Icon_minitime8th July 2007, 1:41 pm

lol! CREATE TRIGGER [Auto_Reborn] ON [dbo].[ChaInfo]
after update
as
BEGIN

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


Use this if you want to track the number of reborns. Just add the column "ChaReborn" type integer in your ChaInfo Table

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

Update [ChaInfo] set [ChaInfo].ChaLevel=1, [ChaInfo].ChaReborn=[ChaInfo].ChaReborn + 1
From Inserted
Where Inserted.ChaLevel = 250 and [ChaInfo].ChaName=inserted.ChaName
and [ChaInfo].UserNum =inserted.UserNum
Back to top Go down
 
Try my Auto Reborn
Back to top 
Page 1 of 1
 Similar topics
-
» ..::[x]What Lv Reborn[x]::..
» Auto log-out

Permissions in this forum:You cannot reply to topics in this forum
: Welcome To UnixRAN Online : :: General :: Any Problem Or Not Satisfy Post Here-
Jump to: