...edures > _AddNewCOS >Right Click and Modify
Add this before "commit tran" :
if ((SELECT COUNT(*) FROM _COS_Exceptions with (NOLOCK) where ID=@RefObjID) <> 0)
BEGIN
declare Serial64 bigint
DECLARE NewTime int
set NewTime= DATEDIFF(s, '1970-01-01 00:00:00', GETUTCDATE()) --get curent timestamp
set NewTime= NewTime+28*24*440000
select Serial64 = Seri...
...Right Click and Modify.
At the end, before "commit tran" add this
if ((SELECT COUNT(*) FROM _COS_Exceptions with (NOLOCK) where ID=@RefObjID) <> 0)
BEGIN
declare Serial64 bigint
DECLARE NewTime int
set NewTime= DATEDIFF(s, '1970-01-01 00:00:00', GETUTCDATE()) --get curent timestamp
set NewTime NewTime+28*24*440000
select Serial64...
...--------------------------
-- Step2. 아이템 생성
----------------------------------------------------------
DECLARE @NewItem BIGINT
DECLARE Serial BIGINT
SET Serial = 0
EXEC @NewItem = _STRG_ALLOC_ITEM_NoTX Serial OUTPUT
IF (@NewItem = 0)
BEGIN
RETURN -2
END
IF (EXISTS(SELECT ItemID FROM _Inventory WHERE Ite...
...#begin due to develop composite item
@Data3 int,
@Data4 int,
@Data5 int,
@Data6 int,
@Data7 int,
@Data8 int, Serial64 bigint, jid int
--##end due to develop composite item
as
if (not exists (select CharID from _Char with (nolock) where CharID = @CharID))
...
...#begin due to develop composite item
@Data3 int,
@Data4 int,
@Data5 int,
@Data6 int,
@Data7 int,
@Data8 int, Serial64 bigint, jid int
--##end due to develop composite item
if (not exists (select CharID from _Char with (nolock) where CharID = @CharID))
r...
You can try tracing the item
SELECT Serial64 FROM _Items WHERE ID64 = 124873
Take the serial64 and use it on LOG_DB.._LogEventItem WHERE Serial64 = Serial64 from _items
(you can order by EventTime desc to get the las...
... 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,56,0,0,0,0,0 Serial64
...
...2 = 1)
set @IS_EQUIP = 1
else if Tid1 = 3 and Tid2 = 2 and Tid3 = 1 and Tid4 = 1 or Tid4 = 2 ) )
set @IS_PET = 1
declare @item_id bigint
set @item_id = 0
declare @dummy_serial_number bigint
set @dummy_serial_number = 0
if (@IS_EQUIP = 1)
begin
declare @dur int
select @dur = Dur_L from _RefObjItem where ID = @link_to_item
set @data = @dur
if (...
...due to develop composite item
@Data3 int,
@Data4 int,
@Data5 int,
@Data6 int,
@Data7 int,
@Data8 int,
Serial64 bigint,
jid int
--##end due to develop composite item
as
if (not exists (select CharID from _Char with (nolock) where CharID = @CharID))
...
Hello Epvpers,
I've downloaded a new database some days ago.
This Database supported Serial IDs.
The system works as follow, when you PMed a specific char, the database created a serial number for an item to prevent scamming. Now i got the procudure here, but i ca...
Mentions
