| mido22421 |
13-03-2015 12:46 AM |
Program Auto Notice Plus + الشرح
السلام عليكم ورحمة الله وبركاته
النهارده انتكلام علي ال Notice Plus
1-البرنامج ده من زمان وفي ناس كتير مش عارف تعمل الكلام ده
2-عشان كده لازم عملكم شرح عشان الناس تفهم ازاي اشغل البرنامج
Program Auto Notice Plus
1- Ip Server
2- Port Server
3- Locale
4- Version Server
Connect to Server
5- Account ID لاوم يكون GM او GA عشان ال Notice
6- PW
Login
في صور تظهر فيه Enter Image code
7- هتجيب اسم الاكونت
8-دوس علي Select Char
------------------------------------
الصور رقم 2 SQL
1- Server Name
2-SRO_VT_SHARDLOG
3- Uesr Name SQL
4- PW SQL
[ stop = stop :D ]
[ Activate = Start ]
http://i.epvpimg.com/JCdhd.png
http://i.epvpimg.com/drbQc.png
Table Query
1
اقتباس:
USE [SRO_VT_SHARDLOG]
GO
/****** Object: Table [dbo].[PlusNotice_mido22421] 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_mido22421](
[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_mido22421] ADD CONSTRAINT [DF_PlusNotice_mido22421_Sent] DEFAULT ((0)) FOR [Sent]
GO
ALTER TABLE [dbo].[PlusNotice_mido22421] ADD CONSTRAINT [DF_PlusNotice_mido22421_Date] DEFAULT (getdate()) FOR [Date]
GO
|
2- Name Wepon
اقتباس:
USE [SRO_VT_SHARD]
GO
/****** Object: Table [dbo].[_ItemName] Script Date: 09/11/2013 12:38:45 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[_ItemName](
[CodeName128] [varchar](50) NOT NULL,
[Name] [varchar](50) NOT NULL
) ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
|
3- SRO_VT_SHARDLOG > Programmability >_AddLogItem
حط ده في اخر ال Query
اقتباس:
if (@Operation = 35)
begin
insert _LogCashItem (RefItemID, CharID, Cnt, EventTime, Serial64)
values(@ItemRefID, @CharID, @dwData, GetDate(), @ItemSerial)
end
if (@Operation = 90 OR @Operation = 160)
begin
set @len_desc1 = CHARINDEX (']',@strDesc)
if(@len_desc1 = 9)
begin
set @strDesc = SUBSTRING(@strDesc,0,9)
set @strDesc_separado = SUBSTRING(@strDesc, 8, 1)
end
else if(@len_desc1 = 10)
begin
set @strDesc = SUBSTRING(@strDesc,0,10)
set @strDesc_separado = SUBSTRING(@strDesc, 8, 2)
end
if(@strDesc_separado >= 8)
begin
--set @strDesc_separado = @len_desc1
insert _LogItemPlus(CharID, Serial64, Plus, Data, Lido) values(@CharID, @ItemSerial, @strDesc_separado, GetDate(), '0')
end
end
if(@Operation = 90)
begin
declare @iname varchar(129)
declare @iid int
declare @cname varchar(64)
select @iid = RefItemID from SRO_VT_SHARD.dbo._Items where Serial64 = @ItemSerial
select @iname = Name from SRO_VT_SHARD.dbo._ItemName where CodeName128 in
(select CodeName128 from SRO_VT_SHARD.dbo._RefObjCommon where id = @iid)
select @cname = CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID
if(@strDesc_separado >= 8)
insert PlusNotice(Sent, Message)values(0,'[' +@cname + '] has increased [' + @iname + '] to [Lvl ' + CAST(@strDesc_separado AS NVARCHAR) + ']')
end
|
http://i.epvpimg.com/J0PJb.png
التحميل Notice Plus Mido22421
الاسكان
نحن نختلف عن الاخرون
|
