Add silk with history log and more

[Valroller]

Hello, Everyone

I created new tool to help you to find silk history by user name and calculate how many silk user charged.

there is 2 options more for change hwn level and give character gold or edit the gold value.










Execute the following querys " query credits for Chernobyl"
First query

PHP Code:

USE [SRO_VT_ACCOUNT]
GO

/****** Object:  Table [dbo].[AddSilkLog]    Script Date: 01/28/2012 00:56:24 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE TABLE [dbo].[AddSilkLog](
    [username] [nvarchar](max) NULL,
    [silk_charged] [bigint] NULL,
    [time] [ntext] NULL,
    [status] [nvarchar](max) NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]

GO 


second query

PHP Code:

USE [SRO_VT_ACCOUNT]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO

CREATE PROCEDURE [dbo].[AddSilk]
    @USERNAME varchar(32),
    @SILKS INT
    AS
BEGIN
    SET NOCOUNT ON;
    
    
    
DECLARE @JID INT
DECLARE @EXISTS INT
DECLARE @ACCOUNT_EXISTS INT
DECLARE @SILK_ADD INT
DECLARE @TIME VARCHAR(100) = (SELECT GETDATE())
SET @SILK_ADD = @SILKS
SET @JID = (select JID from TB_User where StrUserID=@USERNAME)
SET @EXISTS = (select COUNT(*) from SK_Silk where JID=@JID)
SET @ACCOUNT_EXISTS = (select count(JID) from TB_User where StrUserID=@USERNAME)

IF @ACCOUNT_EXISTS < 1
BEGIN
insert into AddSilkLog(username,silk_charged,time,status) values(@USERNAME,@SILK_ADD,@TIME,'FAILED [invalid uname]')
END

ELSE

BEGIN -- if account exists [start]

if @EXISTS > 0
BEGIN
update SK_Silk set silk_own = (silk_own + @SILK_ADD) where JID=@JID
insert into AddSilkLog(username,silk_charged,time,status) values(@USERNAME,@SILK_ADD,@TIME,'CHARGED')
END
ELSE
BEGIN
insert into SK_Silk(JID,silk_own,silk_gift,silk_point) values(@JID,@SILK_ADD,0,0)
insert into AddSilkLog(username,silk_charged,time,status) values(@USERNAME,@SILK_ADD,@TIME,'CHARGED')
END



END


END -- if account exists [end] 


Thank me

[PortalDark]

#approved

[PlayPVP]

thanks will test it now.

[SayedKate]

great program

Thanks me

-- I will

[Crue*]

Good Jop

[Valroller]

Originally Posted by Crue*

Good Jop

Thank you