الـجـروب الـخـاص بـالـمـنـتـدي Silkroad4arab Facebook | Official Group

**ღ♥Alexandria♥ღ** · 20-02-2013, 11:38 PM

عله سيلك رود ازاي تضيف avatar بل Query

كود بلغة HTML:

USE SRO_VT_SHARD_INIT -- SRO_VT_SHARD_INIT = database name
GO

SELECT Service,ID,CodeName128,ObjName128,OrgObjCodeName128,NameStrID128,DescStrID128,CashItem,Bionic,TypeID1,TypeID2,TypeID3,TypeID4,DecayTime,Country,Rarity,CanTrade,CanSell,CanBuy,CanBorrow,CanDrop,CanPick,CanRepair,CanRevive,CanUse,CanThrow,Price,CostRepair,CostRevive,CostBorrow,KeepingFee,SellPrice,ReqLevelType1,ReqLevel1,ReqLevelType2,ReqLevel2,ReqLevelType3,ReqLevel3,ReqLevelType4,ReqLevel4,MaxContain,RegionID,Dir,OffsetX,OffsetY,OffsetZ,Speed1,Speed2,Scale,BCHeight,BCRadius,EventID,AssocFileObj128,AssocFileDrop128,AssocFileIcon128,AssocFile1_128,AssocFile2_128,Link
FROM dbo._RefObjCommon

WHERE (CodeName128 LIKE 'ITEM_MALL_AVATAR_%_NAME%')
-- Ex:'ITEM_MALL_AVATAR_%_DRAGONDRESS%'

GROUP BY Service,ID,CodeName128,ObjName128,OrgObjCodeName128,NameStrID128,DescStrID128,CashItem,Bionic,TypeID1,TypeID2,TypeID3,TypeID4,DecayTime,Country,Rarity,CanTrade,CanSell,CanBuy,CanBorrow,CanDrop,CanPick,CanRepair,CanRevive,CanUse,CanThrow,Price,CostRepair,CostRevive,CostBorrow,KeepingFee,SellPrice,ReqLevelType1,ReqLevel1,ReqLevelType2,ReqLevel2,ReqLevelType3,ReqLevel3,ReqLevelType4,ReqLevel4,MaxContain,RegionID,Dir,OffsetX,OffsetY,OffsetZ,Speed1,Speed2,Scale,BCHeight,BCRadius,EventID,AssocFileObj128,AssocFileDrop128,AssocFileIcon128,AssocFile1_128,AssocFile2_128,Link

2. If the query query return no result it means the avatar is not added already in database.

You will have to add it in _RefObjCommon and _RefObjItem using this query i made:
Code:

كود بلغة HTML:

USE SRO_VT_SHARD_INIT
GO

BEGIN
Declare @CodeName1 varchar(129)
Declare @CodeName2 varchar(129)
Declare @Type1 varchar(129)
Declare @Type int
Declare @Gender1 varchar(129)
Declare @Gender int
END
                                                      
SET @CodeName1 = 'AVATAR_M_DRAGONDRESS'            --- @Type = DRESS/ HAT/ ATTACH
SET @CodeName2= 'avatar_m_dragondress'            --- @Gender = MALE/ FEMALE                               
SET @Type1 = 'DRESS'
SET @Gender1 = 'MALE'
                                  
                                                  

/* Query for _RefObjCommon */
IF (@Type1 = 'HAT' OR @Type1 = 'DRESS' OR @Type1 = 'ATTACH')
IF (@Type1 = 'DRESS') 
BEGIN
SET @Type = '3'
END
IF (@Type1 = 'HAT')
BEGIN
SET @Type = '1'
END 
IF (@Type1 = 'ATTACH')
BEGIN
SET @Type = '2'
END 

BEGIN
Declare @CodeName varchar(129) Set @CodeName = 'ITEM_MALL_' + @Codename1
Declare @SN varchar(74) SET @SN = 'SN_' +@CodeName
Declare @DESC varchar(74) SET @DESC = @SN + '_TT_DESC' 
Declare @BSR1 varchar(129) SET @BSR1 = 'item\avatar\'+ @CodeName2 + '.bsr'
Declare @BSR2 varchar(129) SET @BSR2 = 'item\etc\drop_ch_eventbox.bsr'
Declare @DDJ varchar(74) SET @DDJ = 'Premium\Avatar\' + @CodeName2 + '.ddj'
Declare @ObjectName varchar(129) SET @ObjectName = '??? ?? (?)'  
Declare @ObjectName1 varchar(129) SET @ObjectName1 = '[?,?,?,?,?,??]'
Declare @ObjectName2 varchar(129) SET @ObjectName2 = '[?,??]'
Declare @ObjectName3 varchar(129) SET @ObjectName3 = '[??,??]'
Declare @AssocFile varchar(129) SET @AssocFile = 'xxx' 
Declare @Link int SET @Link = (SELECT MAX(Link)+1 FROM _RefObjCommon)
Declare @ID int SET @ID = (SELECT MAX(Link)+1 FROM _RefObjCommon)
END
    BEGIN
INSERT INTO _RefObjCommon(Service,CodeName128,ObjName128,OrgObjCodeName128,NameStrID128,DescStrID128,CashItem,Bionic,TypeID1,TypeID2,TypeID3,TypeID4,DecayTime,Country,Rarity,CanTrade,CanSell,Canbuy,CanBorrow,CanDrop,CanPick,CanRepair,CanRevive,CanUse,CanThrow,Price,CostRepair,CostRevive,CostBorrow,KeepingFee,SellPrice,ReqLevelType1,ReqLevel1,ReqLevelType2,ReqLevel2,ReqLevelType3,ReqLevel3,ReqLevelType4,ReqLevel4,MaxContain,RegionID,Dir,OffsetX,OffsetY,OffsetZ,Speed1,Speed2,Scale,BCHeight,BCRadius,EventID,AssocFileObj128,AssocFileDrop128,AssocFileIcon128,AssocFile1_128,AssocFile2_128,Link)
VALUES (1,@CodeName,@ObjectName,@AssocFile,@SN,@DESC,1,0,3,1,13,@Type,180000,3,0,0,1,1,159,1,1,0,0,0,0,0,0,0,0,0,0,-1,0,-1,0,-1,0,-1,0,-1,0,0,0,0,0,0,0,100,0,0,0,@BSR1,@BSR2,@DDJ,@AssocFile,@AssocFile,@Link)
    END
    

/* Query for _RefObjItem */
IF (@Gender1 = 'MALE' OR @Gender1 = 'FEMALE')
IF (@Gender1 = 'MALE') 
BEGIN
SET @Gender = '1'
END

IF (@Gender1 = 'FEMALE') 
BEGIN
SET @Gender = '0'
END

IF (@Type1 = 'HAT' OR @Type1 = 'DRESS' OR @Type1 = 'ATTACH')
IF (@Type1 = 'DRESS') 
BEGIN
INSERT INTO _RefObjItem(ID,MaxStack,ReqGender,ReqStr,ReqInt,ItemClass,SetID,Dur_L,Dur_U,PD_L,PD_U,PDInc,ER_L,ER_U,ERInc,PAR_L,PAR_U,PARInc,BR_L,BR_U,MD_L,MD_U,MDInc,MAR_L,MAR_U,MARInc,PDStr_L,PDStr_U,MDInt_L,MDInt_U,Quivered,Ammo1_TID4,Ammo2_TID4,Ammo3_TID4,Ammo4_TID4,Ammo5_TID4,SpeedClass,TwoHanded,Range,PAttackMin_L,PAttackMin_U,PAttackMax_L,PAttackMax_U,PAttackInc,MAttackMin_L,MAttackMin_U,MAttackMax_L,MAttackMax_U,MAttackInc,PAStrMin_L,PAStrMin_U,PAStrMax_L,PAStrMax_U,MAInt_Min_L,MAInt_Min_U,MAInt_Max_L,MAInt_Max_U,HR_L,HR_U,HRInc,CHR_L,CHR_U,Param1,Desc1_128,Param2,Desc2_128,Param3,Desc3_128,Param4,Desc4_128,Param5,Desc5_128,Param6,Desc6_128,Param7,Desc7_128,Param8,Desc8_128,Param9,Desc9_128,Param10,Desc10_128,Param11,Desc11_128,Param12,Desc12_128,Param13,Desc13_128,Param14,Desc14_128,Param15,Desc15_128,Param16,Desc16_128,Param17,Desc17_128,Param18,Desc18_128,Param19,Desc19_128,Param20,Desc20_128,MaxMagicOptCount,ChildItemCount,Link)
VALUES (@ID,1,@Gender,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,574,@ObjectName1,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,4,1,0)
END

IF (@Type1 = 'HAT')
BEGIN
INSERT INTO _RefObjItem(ID,MaxStack,ReqGender,ReqStr,ReqInt,ItemClass,SetID,Dur_L,Dur_U,PD_L,PD_U,PDInc,ER_L,ER_U,ERInc,PAR_L,PAR_U,PARInc,BR_L,BR_U,MD_L,MD_U,MDInc,MAR_L,MAR_U,MARInc,PDStr_L,PDStr_U,MDInt_L,MDInt_U,Quivered,Ammo1_TID4,Ammo2_TID4,Ammo3_TID4,Ammo4_TID4,Ammo5_TID4,SpeedClass,TwoHanded,Range,PAttackMin_L,PAttackMin_U,PAttackMax_L,PAttackMax_U,PAttackInc,MAttackMin_L,MAttackMin_U,MAttackMax_L,MAttackMax_U,MAttackInc,PAStrMin_L,PAStrMin_U,PAStrMax_L,PAStrMax_U,MAInt_Min_L,MAInt_Min_U,MAInt_Max_L,MAInt_Max_U,HR_L,HR_U,HRInc,CHR_L,CHR_U,Param1,Desc1_128,Param2,Desc2_128,Param3,Desc3_128,Param4,Desc4_128,Param5,Desc5_128,Param6,Desc6_128,Param7,Desc7_128,Param8,Desc8_128,Param9,Desc9_128,Param10,Desc10_128,Param11,Desc11_128,Param12,Desc12_128,Param13,Desc13_128,Param14,Desc14_128,Param15,Desc15_128,Param16,Desc16_128,Param17,Desc17_128,Param18,Desc18_128,Param19,Desc19_128,Param20,Desc20_128,MaxMagicOptCount,ChildItemCount,Link)
VALUES (@ID,1,@Gender,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,513,@ObjectName2,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,2,0,0)
END 

IF (@Type1 = 'ATTACH')
BEGIN
INSERT INTO _RefObjItem(ID,MaxStack,ReqGender,ReqStr,ReqInt,ItemClass,SetID,Dur_L,Dur_U,PD_L,PD_U,PDInc,ER_L,ER_U,ERInc,PAR_L,PAR_U,PARInc,BR_L,BR_U,MD_L,MD_U,MDInc,MAR_L,MAR_U,MARInc,PDStr_L,PDStr_U,MDInt_L,MDInt_U,Quivered,Ammo1_TID4,Ammo2_TID4,Ammo3_TID4,Ammo4_TID4,Ammo5_TID4,SpeedClass,TwoHanded,Range,PAttackMin_L,PAttackMin_U,PAttackMax_L,PAttackMax_U,PAttackInc,MAttackMin_L,MAttackMin_U,MAttackMax_L,MAttackMax_U,MAttackInc,PAStrMin_L,PAStrMin_U,PAStrMax_L,PAStrMax_U,MAInt_Min_L,MAInt_Min_U,MAInt_Max_L,MAInt_Max_U,HR_L,HR_U,HRInc,CHR_L,CHR_U,Param1,Desc1_128,Param2,Desc2_128,Param3,Desc3_128,Param4,Desc4_128,Param5,Desc5_128,Param6,Desc6_128,Param7,Desc7_128,Param8,Desc8_128,Param9,Desc9_128,Param10,Desc10_128,Param11,Desc11_128,Param12,Desc12_128,Param13,Desc13_128,Param14,Desc14_128,Param15,Desc15_128,Param16,Desc16_128,Param17,Desc17_128,Param18,Desc18_128,Param19,Desc19_128,Param20,Desc20_128,MaxMagicOptCount,ChildItemCount,Link)
VALUES (@ID,1,@Gender,0,0,1,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,1280,@ObjectName3,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,-1,@AssocFile,1,0,0)
END 


print ''
print 'The query executed successfully.'
print ''
print '                    Query made By mneam001.'

3. Now add the avatar item mall

_RefPackageItem
_RefPricePolicyOfItem
_RefScrapOfPackageItem
_RefShopGoods

كود بلغة HTML:

USE SRO_VT_SHARD_INIT
GO

Declare @CodeName varchar (74)
Declare @yourPrice int
Declare @WhichTAB varchar(74)



SET @CodeName = 'ITEM_MALL_AVATAR_W_BLUE_SOULKNIGHT_ATTACH'            /* The Spawncode of the item you want to add */
SET @yourPrice = 130                                        /* Silkprice */
SET @WhichTAB = 'MALL_AVATAR_ATTACH'                            /* To which Tab of the Item Mall do you want to add the Item*/


Declare @Data varchar(15) SET @Data = '0'                    /*Leave '0' as long as you're adding Avatars - otherwise Quantity of Item*/
IF exists(SELECT CodeName128 FROM _RefObjCommon WHERE CodeName128 = @CodeName)
BEGIN
/*Only Avatar Tabs possible at the moment*/IF (@WhichTAB = 'MALL_AVATAR_ATTACH' OR @WhichTAB = 'MALL_AVATAR_DRESS' OR @WhichTAB = 'MALL_AVATAR_HAT') /*To make sure that the Tab is correct (in order to missspellings)*/
BEGIN

/* Codename instead of the ID */ 
Declare @ItemID int SET @ItemID = (SELECT ID FROM _RefObjCommon WHERE CodeName128 = @CodeName)

/* Which Itemdata.txt is affected in the Media.pk2*/
Declare @newItemID varchar(5)
IF (@ItemID < 5000) SET @newItemID = 5000
else if (@ItemID < 10000) SET @newItemID = 10000
else if (@ItemID < 15000) SET @newItemID = 15000
else if (@ItemID < 20000) SET @newItemID = 20000
else if (@ItemID < 25000) SET @newItemID = 25000
else if (@ItemID < 30000) SET @newItemID = 30000
else if (@ItemID < 35000) SET @newItemID = 35000
else if (@ItemID < 40000) SET @newItemID = 40000
else SET @newItemID = 45000
print ''
print @CodeName + ' from Media\server_dep\silkroad\textdata\itemdata_'+@newItemID+'.txt'
print ''
/*END which Itemdata.txt*/

/* for _RefPackageItem */
IF EXISTS (SELECT CodeName128 FROM _RefPackageItem WHERE CodeName128 = 'Package_'+@CodeName)
    BEGIN
        Declare @SN1 varchar(74) SET @SN1 = (SELECT NameStrID FROM _RefPackageItem WHERE CodeName128 = 'PACKAGE_'+@CodeName)
        Declare @DESC1 varchar(74) SET @Desc1 = (SELECT DescStrID FROM _RefPackageItem WHERE CodeName128 = 'PACKAGE_'+@CodeName)
        Declare @DDJ1 varchar(74) SET @DDJ1 = (SELECT AssocFileIcon FROM _RefPackageItem WHERE CodeName128 = 'PACKAGE_'+@CodeName)
        Declare @TOPID1 varchar (10) SET @TOPID1 = (SELECT ID FROM _RefPackageItem WHERE CodeName128 = 'PACKAGE_'+@CodeName)
            print '##Check the following lines @ refpackageitem.txt!'
            print '1    15    '+@TOPID1+'    PACKAGE_'+@CodeName+'    0    EXPAND_TERM_ALL    '+@SN1+'    '+@DESC1+'    '+@DDJ1+'    -1    xxx    -1    xxx    -1    xxx    -1    xxx'
            print ''
    END
        ELSE BEGIN
            Declare @SN varchar(74) SET @SN = (SELECT NameStrID128 FROM _RefObjCommon WHERE ID = @ItemID)
            Declare @DESC varchar(74) SET @Desc = (SELECT DescStrID128 FROM _RefObjCommon WHERE ID = @ItemID)
            Declare @DDJ varchar(74) SET @DDJ = (SELECT AssocFileIcon128 FROM _RefObjCommon WHERE ID = @ItemID)
                INSERT INTO _RefPackageItem (Service,Country,CodeName128,SaleTag,ExpandTerm,NameStrID,DescStrID,AssocFileIcon,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128) 
                VALUES (1,15,'PACKAGE_'+@CodeName,0,'EXPAND_TERM_ALL',@SN,@Desc,@DDJ,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
            Declare @TOPID varchar (10) SET @TOPID = (SELECT MAX(ID) FROM _RefPackageItem)
                print ''
                print 'Add the following line @ refpackageitem.txt'
                print '1    15    '+@TOPID+'    PACKAGE_'+@CodeName+'    0    EXPAND_TERM_ALL    '+@SN+'    '+@DESC+'    '+@DDJ+'    -1    xxx    -1    xxx    -1    xxx    -1    xxx'
                print ''
        END

/* for _RefPricePolicyOfItem */
IF EXISTS (SELECT RefPackageItemCodeName FROM _RefPricePolicyOfItem WHERE RefPackageItemCodeName = 'Package_'+@CodeName)
    BEGIN
        print '##Check the following lines @ RefPricePolicyOfItem.txt!'
        Declare @NEWPRICE1 varchar(15) SET @NEWPRICE1 = (SELECT Cost FROM _RefPricePolicyOfItem WHERE RefPackageItemCodeName = 'Package_'+@CodeName AND PaymentDevice = 2)
            print '1    15    PACKAGE_'+@CodeName+'    2    0    '+@NEWPRICE1+'    -1    xxx    -1    xxx    -1    xxx    -1    xxx'
            print '1    15    PACKAGE_'+@CodeName+'    4    0    0    -1    xxx    -1    xxx    -1    xxx    -1    xxx'
            print '1    15    PACKAGE_'+@CodeName+'    16    0    0    -1    xxx    -1    xxx    -1    xxx    -1    xxx'
            print ''
    END
        ELSE BEGIN
            INSERT INTO _RefPricePolicyOfItem (Service,Country,RefPackageItemCodeName,PaymentDevice,PreviousCost,Cost,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128)
            VALUES (1,15,'PACKAGE_'+@CodeName,2,0,@yourPrice,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
            INSERT INTO _RefPricePolicyOfItem (Service,Country,RefPackageItemCodeName,PaymentDevice,PreviousCost,Cost,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128)
            VALUES (1,15,'PACKAGE_'+@CodeName,4,0,0,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
            INSERT INTO _RefPricePolicyOfItem (Service,Country,RefPackageItemCodeName,PaymentDevice,PreviousCost,Cost,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128)
            VALUES (1,15,'PACKAGE_'+@CodeName,16,0,0,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
        Declare @NEWPRICE varchar(15) SET @NEWPRICE = @yourPrice
            print ''
            print 'Add the following lines @ refpricepolicyofitem.txt'
            print '1    15    PACKAGE_'+@CodeName+'    2    0    '+@NEWPRICE+'    -1    xxx    -1    xxx    -1    xxx    -1    xxx'
            print '1    15    PACKAGE_'+@CodeName+'    4    0    0    -1    xxx    -1    xxx    -1    xxx    -1    xxx'
            print '1    15    PACKAGE_'+@CodeName+'    16    0    0    -1    xxx    -1    xxx    -1    xxx    -1    xxx'
            print ''
        END

/* for _RefShopGoods */
IF EXISTS (SELECT RefPackageItemCodeName FROM _RefShopGoods WHERE RefPackageItemCodeName = 'Package_'+@CodeName AND RefTabCodeName = @WhichTAB)
    BEGIN
        print '##Check the following lines @ RefShopGoods.txt!'
        Declare @WhichTAB1 varchar(74) SET @WhichTAB1 = (SELECT RefTabCodeName FROM _RefShopGoods WHERE RefPackageItemCodeName = 'PACKAGE_'+@CodeName)
        Declare @newSLOTINDEX1 varchar(15) SET @newSLOTINDEX1 = (SELECT SlotIndex FROM _RefShopGoods WHERE RefPackageItemCodeName = 'PACKAGE_'+@CodeName AND RefTabCodeName = @WhichTAB1)
        print '1    15    '+@WhichTAB1+'    '+'PACKAGE_'+@CodeName+'    '+@newSLOTINDEX1+'    -1    xxx    -1    xxx    -1    xxx    -1    xxx'
        print ''
    END
        ELSE BEGIN
            Declare @newSLOTINDEX varchar(15) SET @newSLOTINDEX = (SELECT MAX(SlotIndex) FROM _RefShopGoods WHERE RefTabCodeName = @WhichTAB)+1
            INSERT INTO _RefShopGoods (Service,Country,RefTabCodeName,RefPackageItemCodeName,SlotIndex,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128)
            VALUES (1,15,@WhichTAB,'PACKAGE_'+@CodeName,@newSLOTINDEX,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
            print ''
            print 'Add the following line @ refshopgoods.txt'
            print '1    15    '+@WhichTAB+'    '+'PACKAGE_'+@CodeName+'    '+@newSLOTINDEX+'    -1    xxx    -1    xxx    -1    xxx    -1    xxx'
            print ''
        END

/* for _RefScrapOfPackageItem */
IF EXISTS (SELECT RefPackageItemCodeName FROM _RefScrapOfPackageItem WHERE RefPackageItemCodeName = 'Package_'+@CodeName AND RefItemCodeName = @CodeName)
    BEGIN
        print '##Check the following lines @ RefScrapOfPackageItem.txt!'
        Declare @ScrapIndex1 varchar(15)
        SET @ScrapIndex1 = (SELECT [Index] FROM _RefScrapOfPackageItem WHERE RefItemCodeName = @CodeName)
        Declare @Data1 varchar(15) SET @Data1 = (SELECT Data FROM _RefScrapOfPackageItem WHERE RefItemCodeName = @CodeName)
        print '1    15    '+'PACKAGE_'+@CodeName+'    '+@CodeName+'    0    0    '+@Data1+'    0    0    0    0    0    0    0    0    0    0    0    0    0    -1    xxx    -1    xxx    -1    xxx    -1    xxx    '+@ScrapIndex1    
        print ''
    END
        ELSE BEGIN
            INSERT INTO _RefScrapOfPackageItem (Service,Country,RefPackageItemCodeName,RefItemCodeName,OptLevel,Variance,Data,MagParamNum,MagParam1,MagParam2,MagParam3,MagParam4,MagParam5,MagParam6,MagParam7,MagParam8,MagParam9,MagParam10,MagParam11,MagParam12,Param1,Param1_Desc128,Param2,Param2_Desc128,Param3,Param3_Desc128,Param4,Param4_Desc128)
            VALUES (1,15,'PACKAGE_'+@CodeName,@CodeName,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,0,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
            Declare @ScrapIndex varchar(15)
            SET @ScrapIndex = (SELECT [Index] FROM _RefScrapOfPackageItem WHERE RefItemCodeName = @CodeName)
                print ''
                print 'Add the following line @ refscrapofpackageitem.txt'
                print '1    15    '+'PACKAGE_'+@CodeName+'    '+@CodeName+'    0    0    '+@Data+'    0    0    0    0    0    0    0    0    0    0    0    0    0    -1    xxx    -1    xxx    -1    xxx    -1    xxx    '+@ScrapIndex
                print ''
        END
    print ''
    print ''
    print 'Done!'
END
ELSE BEGIN
print 'The @WhichTAB value is incorrect!'
END
END
else begin 
print '@CodeName value does not exist.'
end

4. If the avatar was already in database just add it in item mall (step3) and don't forget to put service 1 for the avatar (_RefObjCommon) and saletag 0. (in server and media)

Set service 1 query:

كود بلغة HTML:

USE SRO_VT_SHARD_INIT
 GO
 
 UPDATE [dbo].[_RefObjCommon]
 SET Service = 1
 WHERE CodeName128 like '%HerePutAvatarCode%

'

Set saletag 0 query:

كود بلغة HTML:

USE SRO_VT_SHARD_INIT
 GO
 
 UPDATE _RefPackageItem
 SET SaleTag = '0'
 WHERE (CodeName128 LIKE 'PACKAGE_ITEM_MALL_AVATAR%')

t saletag 0 in media.pk2:

صوره من PC

**Mr Z!dane** · 21-02-2013, 01:02 AM

يا باشا الناس مش فهما حاجة ياريت يكون الشرح عربي
ينـــقل الي
عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

**elfr3on2010** · 21-02-2013, 05:54 AM

تسلم ايدك

**Hussein Alwr** · 04-03-2013, 09:15 PM

فين الترجمة !!

**WeGs** · 06-03-2013, 04:11 PM

اقتباس:

المشاركة الأصلية كتبت بواسطة HusseinAlor عفوا ,,, لايمكنك مشاهده الروابط لانك غير مسجل لدينا [ للتسجيل اضغط هنا ]

فين الترجمة !!

معلش اصل جوجل تعبانه شوية

**Hussein Alwr** · 06-03-2013, 07:05 PM

هو الكويرى ده هيفيد ناس كتير أوى بما فيهم أنا شخصياً بس ياريت لو حد يقولنا
هنعمل أيه وهنضيف أيه وهنغير أيه مش الاخ وأخده كوبى وباست وخلاص

**ĴũŠţ ŘũĻèŠ** · 06-03-2013, 07:09 PM

يا ريت تكتب بالعربى .. و ياريت صور

**MissDooM** · 06-03-2013, 09:51 PM

مش فاهم

**Hussein Alwr** · 09-03-2013, 12:25 AM

هو الموضوع مفيد جداً بس عاوز حد يشرحه بالعربى لإن كدا الواحد مش فاهم أى حاجة
ولا حتى هيعمل أيه لإنى بجد محتاج الكويرى ده وكويرى الأن بى سى والحمد لله
أنت بتأخد الموضوع كوبى من موقع أجنبى وبتيجى تحته باسط بس بتغير العنوان والمقدمة

**Tigger** · 14-05-2014, 11:05 AM

Good Jop

المواضيع المتشابهه
الموضوع	كاتب الموضوع	المنتدى	الردود	آخر مشاركة
ازاي تضيف HP و MP Xx-Large	ღ♥Alexandria♥ღ	قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة	16	14-05-2014 11:01 AM
(¯`·.» الان و حصريا علي سيلك رود عرب ازاي تضيف Lucky Powder D10~D11~D12~D13 to «.·`¯)	ღ♥Alexandria♥ღ	قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة	12	14-05-2014 09:46 AM
ازاى تضيف Silkroad-R Skills	Cursed_Devil	قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة	16	13-05-2014 11:05 AM
لو عايز تضيف avatar في الـ item mall	™Dev Microsoft™	قسم المواضيع المكررة و المخالفة	1	29-10-2013 04:40 PM
ازاي تضيف Item في الــــــــ NPC	ღ♥Alexandria♥ღ	قسم الشروحات و البرامج المستخدمة في عمل السيرفرات الخاصة	1	01-03-2013 06:06 PM

يتصفح الموضوع حالياً : 1 (0 عضو و 1 زائر)

	تسجيل الدخول دائمآ