مشاهدة النسخة كاملة : ازاى اخلى اخر + فى اللعبة + 13 ؟؟
™_Zezo_™
19-09-2015, 02:03 AM
سلام عليكم
اولا شكرا لعدم الاهتمام بمواضيعى وبمواضيع الناس الاخرى
ثانيا انا عاوز اعرف ازاى اخلى الجيم اخر + فيها +13 بس ارجو المساعدة + الشرح لاانى مستجد فى الشغل فى الداتا والميديا
Dangers SrO
19-09-2015, 02:04 PM
MAX PLUS = 13 If you try making More Than 13 = Back To 13 --
if (@eventID = 9 or @eventID = 11 or @eventID = 6)
begin
update SRO_VT_SHARD.dbo._Items set SRO_VT_SHARD.dbo._Items.OptLevel = 13 where SRO_VT_SHARD.dbo._Items.optLevel >= 13
END
™_Zezo_™
19-09-2015, 03:35 PM
MAX PLUS = 13 If you try making More Than 13 = Back To 13 --
if (@eventID = 9 or @eventID = 11 or @eventID = 6)
begin
update SRO_VT_SHARD.dbo._Items set SRO_VT_SHARD.dbo._Items.OptLevel = 13 where SRO_VT_SHARD.dbo._Items.optLevel >= 13
END
حضرتك انا لو عملت الكويرى دا فى ال SRO_VT_SHARD كدا هيبقى اخر + فى اللعبة + 13 ؟؟و ول عاوز ازود اغير رقم 13 ؟؟ وانهو رقم 13 لاان فى 3 ارقام ولا اغير كلو ؟
Dangers SrO
19-09-2015, 03:39 PM
اكيد لما تديفو هيبقا اخرها +13
Back To 13 دي لو حد رفع اكتر من +13 هيرجع تاني لما يسافر :)
™_Zezo_™
19-09-2015, 03:46 PM
اكيد لما تديفو هيبقا اخرها +13
Back To 13 دي لو حد رفع اكتر من +13 هيرجع تاني لما يسافر :)
طيب ولية كدا العذاب دا ^_^ انا عاوز محدش يقدر يرفع عن +13
Dangers SrO
19-09-2015, 03:51 PM
انا قولت لي حضرتك دا لو صادف و رفع مثلا +14 لهيرجع تاني +13
™_Zezo_™
19-09-2015, 04:24 PM
انا قولت لي حضرتك دا لو صادف و رفع مثلا +14 لهيرجع تاني +13
شكرا هجرب وهقولك
Dangers SrO
19-09-2015, 04:27 PM
Ok
CritYouDown
19-09-2015, 04:52 PM
حضرتك انا لو عملت الكويرى دا فى ال SRO_VT_SHARD كدا هيبقى اخر + فى اللعبة + 13 ؟؟و ول عاوز ازود اغير رقم 13 ؟؟ وانهو رقم 13 لاان فى 3 ارقام ولا اغير كلو ؟
دا تحطوا فى SRO_VT_SHARDLOG ==> Procedure ==> _AddLogItem
حطوا فى الاخر خالص و دوس F5
او الكود دا فى
SRO_VT_SHARDLOG ==> Procedure ==> _AddLogItem
IF (@Operation = 90 AND @strDesc like '%Opt: +14%')
BEGIN
UPDATE SRO_VT_SHARD.dbo._Items SET OptLevel = 13 WHERE Serial64 = @ItemSerial
END
حطوا فى الاخر خالص و دوس F5
™_Zezo_™
19-09-2015, 05:07 PM
حضرتك انا جربتو عمنلى مشكلة فى الداتا وال SR_GameServer مش بيتقبل الداتا
CritYouDown
19-09-2015, 05:13 PM
حضرتك انا جربتو عمنلى مشكلة فى الداتا وال SR_GameServer مش بيتقبل الداتا
يبقا اكيد عملتوا غلط
جرب الـ Query دا و قولى
USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_AddLogItem] Script Date: 9/19/2015 5:17:36 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-------------------------------------------------------------------------------------------------------------------
-- Step 2
-- ±âء¸ ¾ئہجإغ ·خ±× ہش·آ Stored procedure ¼ِء¤
-- DataBase : Shard Log
ALTER procedure [dbo].[_AddLogItem]
@CharID int,
@ItemRefID int,
@ItemSerial bigint,
@dwData int,
@TargetStorage tinyint,
@Operation tinyint,
@Slot_From tinyint,
@Slot_To tinyint,
@EventPos varchar(64),
@strDesc varchar(128),
@Gold bigint -- #ifdef EXTEND_GOLD_TYPE »ًہش
as
declare @strDesc_separado varchar(128)
declare @len_desc1 int
declare @len_pos int
declare @len_desc int
set @len_pos = len(@EventPos)
set @len_desc = len(@strDesc)
if (@len_pos > 0 and @len_desc > 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, EventPos, strDesc, Serial64, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³أ¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @EventPos, @strDesc, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³أ¼
end
else if (@len_pos > 0 and @len_desc = 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, EventPos, Serial64, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³أ¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @EventPos, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³أ¼
end
else if (@len_pos = 0 and @len_desc > 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, strDesc, Serial64, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³أ¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @strDesc, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³أ¼
end
else if (@len_pos = 0 and @len_desc = 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, Serial64, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³أ¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³أ¼
end
-- ہ¯·ل ¾ئہجإغ ±¸ہشہج¸é!
-- #define LOG_ITEMEVENT_BUY_CASHITEM (BYTE)35
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 = 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 AND @strDesc like '%Opt: +14%')
BEGIN
UPDATE SRO_VT_SHARD.dbo._Items SET OptLevel = '13' WHERE Serial64 = @ItemSerial
END
™_Zezo_™
19-09-2015, 05:23 PM
يبقا اكيد عملتوا غلط
جرب الـ Query دا و قولى
USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_AddLogItem] Script Date: 9/19/2015 5:17:36 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-------------------------------------------------------------------------------------------------------------------
-- Step 2
-- ±âء¸ ¾ئہجإغ ·خ±× ہش·آ Stored procedure ¼ِء¤
-- DataBase : Shard Log
ALTER procedure [dbo].[_AddLogItem]
@CharID int,
@ItemRefID int,
@ItemSerial bigint,
@dwData int,
@TargetStorage tinyint,
@Operation tinyint,
@Slot_From tinyint,
@Slot_To tinyint,
@EventPos varchar(64),
@strDesc varchar(128),
@Gold bigint -- #ifdef EXTEND_GOLD_TYPE »ًہش
as
declare @strDesc_separado varchar(128)
declare @len_desc1 int
declare @len_pos int
declare @len_desc int
set @len_pos = len(@EventPos)
set @len_desc = len(@strDesc)
if (@len_pos > 0 and @len_desc > 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, EventPos, strDesc, Serial64, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³أ¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @EventPos, @strDesc, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³أ¼
end
else if (@len_pos > 0 and @len_desc = 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, EventPos, Serial64, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³أ¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @EventPos, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³أ¼
end
else if (@len_pos = 0 and @len_desc > 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, strDesc, Serial64, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³أ¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @strDesc, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³أ¼
end
else if (@len_pos = 0 and @len_desc = 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, Serial64, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³أ¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³أ¼
end
-- ہ¯·ل ¾ئہجإغ ±¸ہشہج¸é!
-- #define LOG_ITEMEVENT_BUY_CASHITEM (BYTE)35
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 = 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 AND @strDesc like '%Opt: +14%')
BEGIN
UPDATE SRO_VT_SHARD.dbo._Items SET OptLevel = '13' WHERE Serial64 = @ItemSerial
END
حاضر ثوانى بس على فكرة انا عملتو فى ال لاانو مكتوب اصلا Shard !
وقالى انو متعملش
™_Zezo_™
19-09-2015, 05:26 PM
يبقا اكيد عملتوا غلط
جرب الـ Query دا و قولى
USE [SRO_VT_SHARDLOG]
GO
/****** Object: StoredProcedure [dbo].[_AddLogItem] Script Date: 9/19/2015 5:17:36 PM ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-------------------------------------------------------------------------------------------------------------------
-- Step 2
-- ±âء¸ ¾ئہجإغ ·خ±× ہش·آ Stored procedure ¼ِء¤
-- DataBase : Shard Log
ALTER procedure [dbo].[_AddLogItem]
@CharID int,
@ItemRefID int,
@ItemSerial bigint,
@dwData int,
@TargetStorage tinyint,
@Operation tinyint,
@Slot_From tinyint,
@Slot_To tinyint,
@EventPos varchar(64),
@strDesc varchar(128),
@Gold bigint -- #ifdef EXTEND_GOLD_TYPE »ًہش
as
declare @strDesc_separado varchar(128)
declare @len_desc1 int
declare @len_pos int
declare @len_desc int
set @len_pos = len(@EventPos)
set @len_desc = len(@strDesc)
if (@len_pos > 0 and @len_desc > 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, EventPos, strDesc, Serial64, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³أ¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @EventPos, @strDesc, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³أ¼
end
else if (@len_pos > 0 and @len_desc = 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, EventPos, Serial64, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³أ¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @EventPos, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³أ¼
end
else if (@len_pos = 0 and @len_desc > 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, strDesc, Serial64, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³أ¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @strDesc, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³أ¼
end
else if (@len_pos = 0 and @len_desc = 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, Serial64, Gold) -- #ifdef EXTEND_GOLD_TYPE ±³أ¼
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @ItemSerial, @Gold) -- #ifdef EXTEND_GOLD_TYPE ±³أ¼
end
-- ہ¯·ل ¾ئہجإغ ±¸ہشہج¸é!
-- #define LOG_ITEMEVENT_BUY_CASHITEM (BYTE)35
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 = 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 AND @strDesc like '%Opt: +14%')
BEGIN
UPDATE SRO_VT_SHARD.dbo._Items SET OptLevel = '13' WHERE Serial64 = @ItemSerial
END
الكويرى التانى دا اعملو فى ال Log ? واغير -- Shard Log
الى SRO_VT_SHARDLOG ??
CritYouDown
19-09-2015, 05:30 PM
الكويرى التانى دا اعملو فى ال Log ? واغير -- Shard Log
الى SRO_VT_SHARDLOG ??
لا متغيرش حاجه انا مظبطهولك
اعملوا زى ماهو كده
™_Zezo_™
19-09-2015, 05:49 PM
لا متغيرش حاجه انا مظبطهولك
اعملوا زى ماهو كده
تمام اتعمل بس بردو ال SR_Game مش متقبل الداتا
اية الحل ؟
CritYouDown
19-09-2015, 05:53 PM
تمام اتعمل بس بردو ال SR_Game مش متقبل الداتا
اية الحل ؟
ده اكيد عندك مشكله من حاجه تانيه هات Screenshot
من الـ Error
™_Zezo_™
19-09-2015, 05:54 PM
دا تحطوا فى SRO_VT_SHARDLOG ==> Procedure ==> _AddLogItem
حطوا فى الاخر خالص و دوس F5
او الكود دا فى
SRO_VT_SHARDLOG ==> Procedure ==> _AddLogItem
IF (@Operation = 90 AND @strDesc like '%Opt: +14%')
BEGIN
UPDATE SRO_VT_SHARD.dbo._Items SET OptLevel = 13 WHERE Serial64 = @ItemSerial
END
حطوا فى الاخر خالص و دوس F5
جارى التجربة
™_Zezo_™
19-09-2015, 05:57 PM
دا تحطوا فى SRO_VT_SHARDLOG ==> Procedure ==> _AddLogItem
حطوا فى الاخر خالص و دوس F5
او الكود دا فى
SRO_VT_SHARDLOG ==> Procedure ==> _AddLogItem
IF (@Operation = 90 AND @strDesc like '%Opt: +14%')
BEGIN
UPDATE SRO_VT_SHARD.dbo._Items SET OptLevel = 13 WHERE Serial64 = @ItemSerial
END
حطوا فى الاخر خالص و دوس F5
Procedure مش لااقى دى
Hamza FiGo
20-09-2015, 01:50 AM
ياباشا موضوع الماكس بلاص من برامج الحماية زي K-Gaurd علشان متلفش وتحتار كتير
vBulletin® v3.8.11, Copyright ©2000-2026, vBulletin Solutions, Inc