حصريااااااااااااا (Message System (create Your Own Automtic reply& reward

[™Dev Microsoft™]

بعض الصور عن البرنامج
(print screens)

[SPOILER]



[/SPOILER]


ضيف الـQuery ده
title Request Query

[SPOILER]
DECLARE @CustOmTitleRequest Varchar(30)=(select Message from _Memo where ID64 = (select MIN(ID64)from _Memo where CharID = @CharID and Message like @MessageCustom)) IF @CustOmTitleRequest like 'Title%:%Captian%' Begin update _Char set HwanLevel = 2 where CharID = @CharID End IF @CustOmTitleRequest like 'Title%:%General%' Begin update _Char set HwanLevel = 3 where CharID = @CharID End IF @CustOmTitleRequest not like 'Title%:%Captian%' and @CustOmTitleRequest not like 'Title%:%General%' Begin SET @ReplayMessage = 'Errr Please Check your spelling' End



[/SPOILER]



و عشان تتجنب Bug البرنامج هاتعمل اللي هاقولك عليه حالا ::

[SPOILER]

الـQuery ده بئا اللي هايتحط في الـProgram

if exists (select charName16 from _Char where CharID = @CharID) BEGIN DECLARE @CharName Varchar(16)= (select charName16 from _Char where CharID = @CharID)DECLARE @MessageBUG varchar(1000)= (select Message from _Memo where ID64=(select MAX(ID64)from _Memo where CharID = @CharID))INSERT INTO BugReport VALUES(@CharName,@MessageBUG,GETDATE(),'Nope')END


الـQuery ده بئا اللي هايتحط في الـSQL

USE [SRO_VT_SHARD] GO /****** Object: Table [dbo].[BugReport] Script Date: 01/16/2013 11:53:58 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_PADDING ON GO CREATE TABLE [dbo].[BugReport]( [Character_Name] [varchar](16) NOT NULL, [BugReport] [varchar](1000) NOT NULL, [Date] [varchar](100) NOT NULL, [Readed] [varchar](50) NOT NULL ) ON [PRIMARY] GO SET ANSI_PADDING OFF GO ALTER TABLE [dbo].[BugReport] ADD CONSTRAINT [DF_BugReport_Readed] DEFAULT ('nope') FOR [Readed] GO

[/SPOILER]


Link Download

[SPOILER]

عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

[/SPOILER]

[GM] Reflexs]]

استمر