مشكلة 2*1

[omar hapshy]

اولا مشكلة في
SR_ShardManager و SR_GameServer
http://e.top4top.net/p_199au2o2.jpg

ثانيا : SR_GameServer
اجي ابلص او اشتري اي حاجة او اضرب اسكرول او اي حاجة بتظهر كدة بس العبة شغاله تمام اية الحل في المشكلة
http://d.top4top.net/p_199htdb1.png

لو الصورة مش بينة خد رابط مباشر
http://d.top4top.net/p_199htdb1.png

[Dev.Ri3o]

ال Procedure فى ال addlogitem فى حاجة غلط ال SR_GameServer مش بيقراها

[omar hapshy]

ال Procedure فى ال addlogitem فى حاجة غلط ال SR_GameServer مش بيقراها
لا غيرتها وبرضو يا ريت الي يعرف الحل يحطو ويكون صحيح:thumbup:

[™Shi6on]

امسح كل لي ف
_RefServerEvent,
_RefServerEventReward,
_RefServerEventReward
_ExpUPForPlayers
,_RefServerEventReward
_SpawnMonster .
و جرب ..

و اتأكد من الiis
بس خد backup الاول

[omar hapshy]

المشكلة الاولي تمام اتحلت لكن الثانية بقي كل اما اشتري اي حاجة او اعمل + او اضرب اسكرول تظهر بس الصورة الي عندك الثانية دي علي +

[™Shi6on]

ال Procedure لي فى addlogitem في حاجات غلط ..
حاول تخده من db تانيه و جرب ..

[omar hapshy]

ال Procedure لي فى addlogitem في حاجات غلط ..
حاول تخده من db تانيه و جرب ..

جربت وبرضو نفس الكلام
USE [SRO_VT_SHARD]
GO
/****** Object: StoredProcedure [dbo].[_AddLogItem] Script Date: 20/07/2016 03:13:42 م ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER OFF
GO


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)
as
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)
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @EventPos, @strDesc, @ItemSerial)
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)
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @EventPos, @ItemSerial)
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)
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @strDesc, @ItemSerial)
end
else if (@len_pos = 0 and @len_desc = 0)
begin
insert _LogEventItem (EventTime, CharID, ItemRefID, dwData, TargetStorage, Operation, Slot_From, Slot_To, Serial64)
values(GetDate(), @CharID, @ItemRefID, @dwData, @TargetStorage, @Operation, @Slot_From, @Slot_To, @ItemSerial)
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

[™Shi6on]

USE [SRO_VT_LOG]
GO
/****** Object: StoredProcedure [dbo].[_AddLogItem] Script Date: 02/13/2014 13:04:26 ******/
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



insert into _OperationDetectHUH values (@CharID, @Operation, @Slot_From, @Slot_To, @EventPos, @strDesc, @ItemRefID, GETDATE())
RETURN
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 srsly learn how to use TV next time xDDD I don't use meeting :s
if (@Operation = 35)
begin
insert _LogCashItem (RefItemID, CharID, Cnt, EventTime, Serial64)
values(@ItemRefID, @CharID, @dwData, GetDate(), @ItemSerial)
end

IF (@Operation = '41')
-- ##############################################
-- TESTING AT LEAST
-- ##############################################
begin

IF (@ItemRefID = '47063')
begin
Declare @Charname varchar(64);
Select @Charname = Charname16
FROM sro_vt_Shard.dbo._Char where CharID = @CharID

exec sro_vt_shard.dbo._ADD_ITEM_EXTERN @Charname,'ITEM_EVENT_RENT_REVERSE_RETURN_SCROLL', 5,1

end
end

جرب ده

[omar hapshy]

Shi6on
انت راجل محترم

[™Shi6on]

Shi6on
انت راجل محترم

انا تحت امرك ^^"