Vsro System Auto Party Reform Event

CREATE PROCEDURE _Silk_ADD_CHARNAME -- ============================================= 
/*
ADD Silk Procedure By Eslam Galal
*/
-- ============================================= 
@silk INT, 
@CharName16 VARCHAR(512) 


AS 
BEGIN
Declare @UserID int = (select UserJID from SRO_VT_SHARD.dbo._User where CharID = (SELECT CharID FROM SRO_VT_SHARD.dbo._Char where CharName16 = @CharName16))


IF EXISTS ( Select * From SRO_VT_ACCOUNT.dbo.SK_Silk Where JID = @UserID )
BEGIN
UPDATE SRO_VT_ACCOUNT.dbo.SK_Silk set silk_own = silk_own + @silk where JID = @UserID
END
ELSE 
BEGIN
INSERT SRO_VT_ACCOUNT.dbo.SK_Silk (JID,silk_own,silk_gift,silk_point) Values (@UserID,@Silk,0,0)
END

END

USE [SRO_VT_SHARDLOG]GO




/****** Object: Table [dbo].[PlusNotice] Script Date: 14.06.2013 18:09:33 ******/
SET ANSI_NULLS ON
GO




SET QUOTED_IDENTIFIER ON
GO




SET ANSI_PADDING ON
GO




CREATE TABLE [dbo].[PlusNotice](
[Sent] [int] NOT NULL,
[Message] [varchar](300) NOT NULL,
[Date] [datetime] NOT NULL
) ON [PRIMARY]




GO




SET ANSI_PADDING OFF
GO




ALTER TABLE [dbo].[PlusNotice] ADD CONSTRAINT [DF_PlusNotice_Sent] DEFAULT ((0)) FOR [Sent]
GO




ALTER TABLE [dbo].[PlusNotice] ADD CONSTRAINT [DF_PlusNotice_Date] DEFAULT (getdate()) FOR [Date]

GO