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

[SPOILER]
http://i.imgur.com/FcGlN.png
http://i.imgur.com/h3K6A.png
http://i.imgur.com/zZWFG.png
[/SPOILER]

http://www5.0zz0.com/2013/10/31/02/766996312.png
ضيف الـ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


http://img547.imageshack.us/img547/6...ff9bf4da9f.png
[/SPOILER]

http://www5.0zz0.com/2013/10/31/02/766996312.png

و عشان تتجنب 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]

http://www5.0zz0.com/2013/10/31/02/766996312.png
Link Download

[SPOILER][/SPOILER]