Item Stats are all 100% oO?

elsarif94 · 2013-03-26T18:02:45+01:00

Hey guys uhm i wanted to ask why all Stats are 100% is it a visual bug or what and how can i fix this ? clean items.. btw http://epvpimg.com/L9idg

USE [SRO_VT_SHARD_INIT]
GO
/****** Object: StoredProcedure [dbo].[_FN_ADD_INITIAL_EQUIP] Script Date: 26.03.2013 20:29:38 ******/
SET ANSI_NULLS OFF
GO
SET QUOTED_IDENTIFIER OFF
GO
-------------------------------------------------------------------------------------
ALTER PROCEDURE [dbo].[_FN_ADD_INITIAL_EQUIP]
@CharID AS INT,
@Slot AS TINYINT,
@RefItemID AS INT,
@Data AS INT
AS
----------------------------------------------------------
-- Step1. 아이템 집어 넣으려는 인벤토리 슬롯이 비었는가 확인
----------------------------------------------------------
DECLARE @ItemInSlot BIGINT
SET @ItemInSlot = 0
SELECT @ItemInSlot = ItemID FROM _Inventory WHERE CharID = @CharID AND Slot = @Slot
IF (@ItemInSlot <> 0)
BEGIN
RETURN -1
END
----------------------------------------------------------
-- Step2. 아이템 생성
----------------------------------------------------------
DECLARE @NewItem BIGINT
DECLARE @Serial BIGINT
SET @Serial = 0

EXEC @NewItem = _STRG_ALLOC_ITEM_NoTX @Serial OUTPUT
IF (@NewItem = 0)
BEGIN
RETURN -2
END

IF (EXISTS(SELECT ItemID FROM _Inventory WHERE ItemID = @NewItem))
BEGIN
RETURN -181818
END
IF (EXISTS(SELECT ItemID FROM _Chest WHERE ItemID = @NewItem))
BEGIN
RETURN -282828
END
UPDATE _Items SET RefItemID = @RefItemID, OptLevel = 0, Variance = 0, Data = @Data WHERE ID64 = @NewItem
IF (@@ERROR <> 0)
BEGIN
RETURN -3
END
----------------------------------------------------------
-- Step3. 아이템 세팅
----------------------------------------------------------
UPDATE _Inventory SET ItemID = @NewItem WHERE CharID = @CharID AND Slot = @Slot
IF (@@ERROR <> 0)
BEGIN
RETURN -4
END
RETURN @NewItem

u mean this or ?

yep, and it seems fine. It is most likely a client-side error. Upload ur server_dep folder from the media somewhere. Its easy to fix it. Itemdataxxx.txt seems to be lightly fucked up.

Easiest solution:
Put ur item name into there and run the query. You will get a line for the itemdataxx.txt file. Check if it is the same as in ur media. Check the items that u are wearing right now, since their stats are bugged. Assuming this is only fucked up client sidedly, it should all be working normally ingame tho.

Code:

Declare @Codename128 varchar(max) = 
(Select Codename128 from _refobjcommon where codename128 like '%ITEMNAME HERE%')
SELECT 
    _RefObjCommon.Service,_RefObjCommon.ID,_RefObjCommon.CodeName128,_RefObjCommon.ObjName128,_RefObjCommon.OrgObjCodeName128,_RefObjCommon.NameStrID128,_RefObjCommon.DescStrID128,_RefObjCommon.CashItem,_RefObjCommon.Bionic,_RefObjCommon.TypeID1,_RefObjCommon.TypeID2,_RefObjCommon.TypeID3,_RefObjCommon.TypeID4,_RefObjCommon.DecayTime,_RefObjCommon.Country,_RefObjCommon.Rarity,_RefObjCommon.CanTrade,_RefObjCommon.CanSell,_RefObjCommon.CanBuy,_RefObjCommon.CanBorrow,_RefObjCommon.CanDrop,_RefObjCommon.CanPick,_RefObjCommon.CanRepair,_RefObjCommon.CanRevive,_RefObjCommon.CanUse,_RefObjCommon.CanThrow,_RefObjCommon.Price,_RefObjCommon.CostRepair,_RefObjCommon.CostRevive,_RefObjCommon.CostBorrow,_RefObjCommon.KeepingFee,_RefObjCommon.SellPrice,_RefObjCommon.ReqLevelType1,_RefObjCommon.ReqLevel1,_RefObjCommon.ReqLevelType2,_RefObjCommon.ReqLevel2,_RefObjCommon.ReqLevelType3,_RefObjCommon.ReqLevel3,_RefObjCommon.ReqLevelType4,_RefObjCommon.ReqLevel4,_RefObjCommon.MaxContain,_RefObjCommon.RegionID,_RefObjCommon.Dir,_RefObjCommon.OffsetX,_RefObjCommon.OffsetY,_RefObjCommon.OffsetZ,_RefObjCommon.Speed1,_RefObjCommon.Speed2,_RefObjCommon.Scale,_RefObjCommon.BCHeight,_RefObjCommon.BCRadius,_RefObjCommon.EventID,_RefObjCommon.AssocFileObj128,_RefObjCommon.AssocFileDrop128,_RefObjCommon.AssocFileIcon128,_RefObjCommon.AssocFile1_128,_RefObjCommon.AssocFile2_128,_RefObjItem.MaxStack,_RefObjItem.ReqGender,_RefObjItem.ReqStr,_RefObjItem.ReqInt,_RefObjItem.ItemClass,_RefObjItem.SetID,_RefObjItem.Dur_L,_RefObjItem.Dur_U,_RefObjItem.PD_L,_RefObjItem.PD_U,_RefObjItem.PDInc,_RefObjItem.ER_L,_RefObjItem.ER_U,_RefObjItem.ERInc,_RefObjItem.PAR_L,_RefObjItem.PAR_U,_RefObjItem.PARInc,_RefObjItem.BR_L,_RefObjItem.BR_U,_RefObjItem.MD_L,_RefObjItem.MD_U,_RefObjItem.MDInc,_RefObjItem.MAR_L,_RefObjItem.MAR_U,_RefObjItem.MARInc,_RefObjItem.PDStr_L,_RefObjItem.PDStr_U,_RefObjItem.MDInt_L,_RefObjItem.MDInt_U,_RefObjItem.Quivered,_RefObjItem.Ammo1_TID4,_RefObjItem.Ammo2_TID4,_RefObjItem.Ammo3_TID4,_RefObjItem.Ammo4_TID4,_RefObjItem.Ammo5_TID4,_RefObjItem.SpeedClass,_RefObjItem.TwoHanded,_RefObjItem.Range,_RefObjItem.PAttackMin_L,_RefObjItem.PAttackMin_U,_RefObjItem.PAttackMax_L,_RefObjItem.PAttackMax_U,_RefObjItem.PAttackInc,_RefObjItem.MAttackMin_L,_RefObjItem.MAttackMin_U,_RefObjItem.MAttackMax_L,_RefObjItem.MAttackMax_U,_RefObjItem.MAttackInc,_RefObjItem.PAStrMin_L,_RefObjItem.PAStrMin_U,_RefObjItem.PAStrMax_L,_RefObjItem.PAStrMax_U,_RefObjItem.MAInt_Min_L,_RefObjItem.MAInt_Min_U,_RefObjItem.MAInt_Max_L,_RefObjItem.MAInt_Max_U,_RefObjItem.HR_L,_RefObjItem.HR_U,_RefObjItem.HRInc,_RefObjItem.CHR_L,_RefObjItem.CHR_U,_RefObjItem.Param1,_RefObjItem.Desc1_128,_RefObjItem.Param2,_RefObjItem.Desc2_128,_RefObjItem.Param3,_RefObjItem.Desc3_128,_RefObjItem.Param4,_RefObjItem.Desc4_128,_RefObjItem.Param5,_RefObjItem.Desc5_128,_RefObjItem.Param6,_RefObjItem.Desc6_128,_RefObjItem.Param7,_RefObjItem.Desc7_128,_RefObjItem.Param8,_RefObjItem.Desc8_128,_RefObjItem.Param9,_RefObjItem.Desc9_128,_RefObjItem.Param10,_RefObjItem.Desc10_128,_RefObjItem.Param11,_RefObjItem.Desc11_128,_RefObjItem.Param12,_RefObjItem.Desc12_128,_RefObjItem.Param13,_RefObjItem.Desc13_128,_RefObjItem.Param14,_RefObjItem.Desc14_128,_RefObjItem.Param15,_RefObjItem.Desc15_128,_RefObjItem.Param16,_RefObjItem.Desc16_128,_RefObjItem.Param17,_RefObjItem.Desc17_128,_RefObjItem.Param18,_RefObjItem.Desc18_128,_RefObjItem.Param19,_RefObjItem.Desc19_128,_RefObjItem.Param20,_RefObjItem.Desc20_128,_RefObjItem.MaxMagicOptCount,_RefObjItem.ChildItemCount
    FROM _RefObjCommon INNER JOIN _RefObjItem ON _RefObjCommon.Link=_RefObjItem.ID
    WHERE _RefObjCommon.CodeName128 LIKE @Codename128  ORDER BY _RefObjCommon.ID ASC