USE [SRO_VT_SHARD] GO /****** Object: StoredProcedure [dbo].[_AddNewCOS] Script Date: 02/10/2012 11:32:15 ******/ SET ANSI_NULLS OFF GO SET QUOTED_IDENTIFIER ON GO
/* --´õ ÀÌ»ó ÀÌ Ä÷³¿¡´Â µ¥ÀÌÅ͸¦ ³ÖÁö ¾Ê´Â´Ù! UPDATE _Char SET EngagedCOS = CoS_ID WHERE CharID = OwNeRCharID IF (@@ERROR <> 0 OR @@ROWCOUNT = 0) BEGIN ROLLBACK TRANSACTION RETURN -3 END */ if( @itemID <> 0 ) begin update _Items set Data = CoS_ID where ID64 = @itemID if( @@error <> 0 or @@rowcount = 0 ) begin rollback transaction return -4 end
--BEGIN ADDITIONAL 112 SLOT IN GRAB PETS FOR 7684 DAYS declare serial64 bigint select serial64 = Serial64 from _Items where Data = CoS_ID exec _AddTimedJobForPet CoS_ID,5,22926,1992999999,1111708465,1,112,0,0,0, 0,0 serial64 --BEGIN ADDITIONAL 112 SLOT IN GRAB PETS FOR 7684 DAYS
--BEGIN ADDITIONAL 112 SLOT IN GRAB PETS FOR 30 DAYS
declare serial64 bigint
select serial64 = Serial64 from _Items where Data = CoS_ID
exec _AddTimedJobForPet CoS_ID,5,22926 newtime,1111708465,1,112,0,0,0,0,0 serial64
--BEGIN ADDITIONAL 112 SLOT IN GRAB PETS FOR 30 DAYS