[Release] Auto Party Re-from Event ( Manageable) + Auto notice ( Simple )

[tiesto556]

Originally Posted by Eslam Galull

- The same Old Auto Re-from Event i have released before

but this time you can manage everything inside ., with working plus notice so you wont open a plus notice program




btw if i added more things in this project it will be edited here in the same topic to prevent spam






Frist Prog setting :
- its clear enough !


Execute those querys into Your SHARD LOG

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

Scan Link




Download :
in attach ( V0.4 )

Thanks

[mohamedbebo99]

plz edit the Procedure to give an item as reward <3