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 cannot get it to work.
Which char do i need to PM to get this message system work?
Can someone help me, and maybe explain this stored procedure?
I am learning SQL at this moment, so every learnmoment i will take with open arms.
ALTER procedure [dbo].[_ItemSerials]
@[Only registered and activated users can see links. Click Here To Register...]charname varchar(256)
as
DECLARE @[Only registered and activated users can see links. Click Here To Register...]D int = (SELECT CharID FROM _Char WITH (NOLOCK) where CharName16 = @[Only registered and activated users can see links. Click Here To Register...]charname)
DECLARE @[Only registered and activated users can see links. Click Here To Register...] bigint
DECLARE @[Only registered and activated users can see links. Click Here To Register...]emID int
DECLARE @[Only registered and activated users can see links. Click Here To Register...]ame varchar(256)
SELECT @[Only registered and activated users can see links. Click Here To Register...] = Serial64 , @[Only registered and activated users can see links. Click Here To Register...]emID = RefItemID
FROM _Items I inner join _Inventory V
WITH (NOLOCK) ON I.ID64 = V.ItemID
WHERE v.CharID = @[Only registered and activated users can see links. Click Here To Register...]D AND v.Slot = 13
SELECT @[Only registered and activated users can see links. Click Here To Register...]ame = Name FROM _ItemName Z inner join _RefObjCommon K WITH (NOLOCK) ON Z.CodeName128 = K.CodeName128 WHERE K.ID = @[Only registered and activated users can see links. Click Here To Register...]emID
IF @[Only registered and activated users can see links. Click Here To Register...] != '1170654428139618305'
BEGIN
IF @[Only registered and activated users can see links. Click Here To Register...]ame IS NULL
BEGIN
INSERT INTO _ELYSON_EXT.dbo._Chat (send,sendto,Message,date)
VALUES ('1' @[Only registered and activated users can see links. Click Here To Register...]CharName,'Your Item Serial is: ['+ CAST @[Only registered and activated users can see links. Click Here To Register...] AS VARCHAR(256))+'] please remember to save this number, it can help in tough times.',GETDATE())
END
ELSE IF @[Only registered and activated users can see links. Click Here To Register...]ame IS NOT NULL
BEGIN
DECLARE @[Only registered and activated users can see links. Click Here To Register...] Varchar(256) = (SELECT Name FROM _ItemName WHERE Name = @[Only registered and activated users can see links. Click Here To Register...]ame)
INSERT INTO _ELYSON_EXT.dbo._Chat (send,sendto,Message,date)
VALUES ('1' @[Only registered and activated users can see links. Click Here To Register...]CharName,'Your [' @[Only registered and activated users can see links. Click Here To Register...]+'] Serial is: ['+ CAST @[Only registered and activated users can see links. Click Here To Register...] AS VARCHAR(256))+'] please remember to save this number, it can help in tough times.',GETDATE())
END
END
ELSE IF @[Only registered and activated users can see links. Click Here To Register...] = '1170654428139618305'
BEGIN
INSERT INTO _ELYSON_EXT.dbo._Chat (send,sendto,Message,date)
VALUES ('1' @[Only registered and activated users can see links. Click Here To Register...]CharName,'Please put something on the frist slot then use the service.' ,GETDATE())
END
Thanks!
Greetings,
Killerflood
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 cannot get it to work.
Which char do i need to PM to get this message system work?
Can someone help me, and maybe explain this stored procedure?
I am learning SQL at this moment, so every learnmoment i will take with open arms.
ALTER procedure [dbo].[_ItemSerials]
@[Only registered and activated users can see links. Click Here To Register...]charname varchar(256)
as
DECLARE @[Only registered and activated users can see links. Click Here To Register...]D int = (SELECT CharID FROM _Char WITH (NOLOCK) where CharName16 = @[Only registered and activated users can see links. Click Here To Register...]charname)
DECLARE @[Only registered and activated users can see links. Click Here To Register...] bigint
DECLARE @[Only registered and activated users can see links. Click Here To Register...]emID int
DECLARE @[Only registered and activated users can see links. Click Here To Register...]ame varchar(256)
SELECT @[Only registered and activated users can see links. Click Here To Register...] = Serial64 , @[Only registered and activated users can see links. Click Here To Register...]emID = RefItemID
FROM _Items I inner join _Inventory V
WITH (NOLOCK) ON I.ID64 = V.ItemID
WHERE v.CharID = @[Only registered and activated users can see links. Click Here To Register...]D AND v.Slot = 13
SELECT @[Only registered and activated users can see links. Click Here To Register...]ame = Name FROM _ItemName Z inner join _RefObjCommon K WITH (NOLOCK) ON Z.CodeName128 = K.CodeName128 WHERE K.ID = @[Only registered and activated users can see links. Click Here To Register...]emID
IF @[Only registered and activated users can see links. Click Here To Register...] != '1170654428139618305'
BEGIN
IF @[Only registered and activated users can see links. Click Here To Register...]ame IS NULL
BEGIN
INSERT INTO _ELYSON_EXT.dbo._Chat (send,sendto,Message,date)
VALUES ('1' @[Only registered and activated users can see links. Click Here To Register...]CharName,'Your Item Serial is: ['+ CAST @[Only registered and activated users can see links. Click Here To Register...] AS VARCHAR(256))+'] please remember to save this number, it can help in tough times.',GETDATE())
END
ELSE IF @[Only registered and activated users can see links. Click Here To Register...]ame IS NOT NULL
BEGIN
DECLARE @[Only registered and activated users can see links. Click Here To Register...] Varchar(256) = (SELECT Name FROM _ItemName WHERE Name = @[Only registered and activated users can see links. Click Here To Register...]ame)
INSERT INTO _ELYSON_EXT.dbo._Chat (send,sendto,Message,date)
VALUES ('1' @[Only registered and activated users can see links. Click Here To Register...]CharName,'Your [' @[Only registered and activated users can see links. Click Here To Register...]+'] Serial is: ['+ CAST @[Only registered and activated users can see links. Click Here To Register...] AS VARCHAR(256))+'] please remember to save this number, it can help in tough times.',GETDATE())
END
END
ELSE IF @[Only registered and activated users can see links. Click Here To Register...] = '1170654428139618305'
BEGIN
INSERT INTO _ELYSON_EXT.dbo._Chat (send,sendto,Message,date)
VALUES ('1' @[Only registered and activated users can see links. Click Here To Register...]CharName,'Please put something on the frist slot then use the service.' ,GETDATE())
END
Thanks!
Greetings,
Killerflood