vSRO Paylaşım Fgw Dc Fix
- Konuyu Başlatan Osbo
- Başlangıç tarihi
semih abi es
thanks for sharing~~
tesekurler
Üst üste post gönderildiği için tek mesajda birleştirildi:
YENi 2019 + sql icin bu uyumsuz
ALTER PROCEDURE [dbo].[_AddTimedJob]
@CharID INT,
@Category TINYINT,
@JobID INT,
@TimeToKeep INT,
@Data1 INT,
@Data2 INT,
--## begin composite item
@Data3 INT,
@Data4 INT,
@Data5 INT,
@Data6 INT,
@Data7 INT,
@Data8 INT,
@Serial64 BIGINT,
@JID INT
--## end composite item
AS
BEGIN
-- Char kontrol
IF NOT EXISTS (SELECT 1 FROM _Char WHERE CharID = @CharID)
RETURN -1
-- Süre kontrol
IF (@TimeToKeep <= 0)
RETURN -2
DECLARE @NewJobID INT
SET @NewJobID = 0
/*
JobID = 1 -> Guild
Category = 2
Serial64 = 0 -> Guild timed job
*/
IF (@JobID = 1 AND @Category = 2 AND @Serial64 = 0)
BEGIN
-- Guild timed job → CharID = 0
INSERT INTO _TimedJob
(
CharID, Category, JobID, TimeToKeep,
Data1, Data2, Data3, Data4,
Data5, Data6, Data7, Data8,
Serial64, JID
)
VALUES
(
0, @Category, @JobID, @TimeToKeep,
@Data1, @Data2, @Data3, @Data4,
@Data5, @Data6, @Data7, @Data8,
@Serial64, @JID
)
END
ELSE
BEGIN
-- Normal character timed job
INSERT INTO _TimedJob
(
CharID, Category, JobID, TimeToKeep,
Data1, Data2, Data3, Data4,
Data5, Data6, Data7, Data8,
Serial64, JID
)
VALUES
(
@CharID, @Category, @JobID, @TimeToKeep,
@Data1, @Data2, @Data3, @Data4,
@Data5, @Data6, @Data7, @Data8,
@Serial64, @JID
)
END
SET @NewJobID = @@IDENTITY
IF (@@ERROR <> 0 OR @@ROWCOUNT = 0)
RETURN -3
RETURN @NewJobID
END
bu guncel querydir bilginize calisiyor denedim
tşk şekerim
