09-01-2017, 06:11 AM
|
#1
|
|
|
• ÇáÇäÜÊÜÓÜÇÈ » Sep 2012
|
|
• ÑÞÜã ÇáÚÜÖÜæíÜÉ » 105765
|
|
• ÇáãÔÜÜÜÇÑßÜÇÊ » 3,011
|
|
• ÇáÜÏæáÜÉ » ÊÍÊ ÇáÈÍÑ
|
|
• ÇáÜåÜæÇíÜÉ » hack Site
|
|
• ÇÓÜã ÇáÜÓÜíÜÑÝÜÑ » No Server
|
|
• ÇáÜÌÜäÜÓ » Male
|
|
• äÞÜÇØ ÇáÊÞííã » 25
|
|
|
|
.gif)
pro plus notice
AddLogİtem
|
|
|
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
begin
--------------------- Promaker ile farkı hissetmeye devam -----------------------
insert _LogItemPlus(CharID, Serial64, Plus, Data, Lido) values(@CharID, @ItemSerial, @strDesc_separado, GetDate(), '0')
end
end
if(@Operation = 90 and @strDesc_separado >= 9)
begin
declare @iname varchar(129)
declare @iid int
declare @cname varchar(64)
select @iid = RefItemID from SRO_VT_SHARD.dbo._Items where Serial64 = @ItemSerial
set @iname = (select Name from SRO_VT_SHARD.dbo._ItemName where CodeName128 = (select NameStrID128 from SRO_VT_SHARD.dbo._RefObjCommon where id = @iid))
select @cname = CharName16 from SRO_VT_SHARD.dbo._Char where CharID = @CharID
if exists (select nOptValue from SRO_VT_SHARD.dbo._BindingOptionWithItem where bOptType=2 and nItemDBID = (select ID64 from SRO_VT_SHARD.dbo._Items where Serial64=@ItemSerial))
begin
declare @advvalue varchar(10) = (select nOptValue from SRO_VT_SHARD.dbo._BindingOptionWithItem where bOptType=2 and nItemDBID = (select ID64 from SRO_VT_SHARD.dbo._Items where Serial64=@ItemSerial))
insert PlusNotice(Sent, Message)values(0,@cname + ' has increased ' + @iname + ' to [Lvl ' + CAST(@strDesc_separado AS NVARCHAR) + '] (Adv ' + @advvalue + ')' )
end
else
insert PlusNotice(Sent, Message)values(0,@cname + ' has increased ' + @iname + ' to [Lvl ' + CAST(@strDesc_separado AS NVARCHAR) + '] (No Adv)')
end
IF (@Operation = 90 AND @strDesc like '%Opt%')
BEGIN
DECLARE @Opt tinyint = (select OptLevel from SRO_VT_SHARD.dbo._Items where Serial64 = @ItemSerial)
IF (@Opt = 36)
BEGIN
UPDATE SRO_VT_SHARD.dbo._Items SET OptLevel = 35 WHERE Serial64 = @ItemSerial
END
END
|
|
|
|
USE [SRO_VT_LOG]
GO
/****** Object: Table [dbo].[PlusNotice] Script Date: 23.03.2016 15:10:34 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_PADDING ON
GO
CREATE TABLE [dbo].[PlusNotice](
[Sent] [int] NOT NULL CONSTRAINT [DF_PlusNotice_Sent] DEFAULT ((0)),
[message] [varchar](max) NOT NULL,
[Date] [datetime] NOT NULL CONSTRAINT [DF_PlusNotice_Date] DEFAULT (getdate())
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
SET ANSI_PADDING OFF
GO
|
mega:///#!jgNA3QjY!85P-gL09l5cLGCK84M31cHk9nOxarEOPNEW79tZARWQ
|
|
|
|