ღ♥Alexandria♥ღ
20-02-2013, 11:38 PM
http://www3.0zz0.com/2012/12/26/15/187243625.gif
عله سيلك رود ازاي تضيف avatar بل Query
USE SRO_VT_SHARD_INIT -- SRO_VT_SHARD_INIT = database name
GO
SELECT Service,ID,CodeName128,ObjName128,OrgObjCodeName12 8,NameStrID128,DescStrID128,CashItem,Bionic,TypeID 1,TypeID2,TypeID3,TypeID4,DecayTime,Country,Rarity ,CanTrade,CanSell,CanBuy,CanBorrow,CanDrop,CanPick ,CanRepair,CanRevive,CanUse,CanThrow,Price,CostRep air,CostRevive,CostBorrow,KeepingFee,SellPrice,Req LevelType1,ReqLevel1,ReqLevelType2,ReqLevel2,ReqLe velType3,ReqLevel3,ReqLevelType4,ReqLevel4,MaxCont ain,RegionID,Dir,OffsetX,OffsetY,OffsetZ,Speed1,Sp eed2,Scale,BCHeight,BCRadius,EventID,AssocFileObj1 28,AssocFileDrop128,AssocFileIcon128,AssocFile1_12 8,AssocFile2_128,Link
FROM dbo._RefObjCommon
WHERE (CodeName128 LIKE 'ITEM_MALL_AVATAR_%_NAME%')
-- Ex:'ITEM_MALL_AVATAR_%_DRAGONDRESS%'
GROUP BY Service,ID,CodeName128,ObjName128,OrgObjCodeName12 8,NameStrID128,DescStrID128,CashItem,Bionic,TypeID 1,TypeID2,TypeID3,TypeID4,DecayTime,Country,Rarity ,CanTrade,CanSell,CanBuy,CanBorrow,CanDrop,CanPick ,CanRepair,CanRevive,CanUse,CanThrow,Price,CostRep air,CostRevive,CostBorrow,KeepingFee,SellPrice,Req LevelType1,ReqLevel1,ReqLevelType2,ReqLevel2,ReqLe velType3,ReqLevel3,ReqLevelType4,ReqLevel4,MaxCont ain,RegionID,Dir,OffsetX,OffsetY,OffsetZ,Speed1,Sp eed2,Scale,BCHeight,BCRadius,EventID,AssocFileObj1 28,AssocFileDrop128,AssocFileIcon128,AssocFile1_12 8,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:
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,OrgOb jCodeName128,NameStrID128,DescStrID128,CashItem,Bi onic,TypeID1,TypeID2,TypeID3,TypeID4,DecayTime,Cou ntry,Rarity,CanTrade,CanSell,Canbuy,CanBorrow,CanD rop,CanPick,CanRepair,CanRevive,CanUse,CanThrow,Pr ice,CostRepair,CostRevive,CostBorrow,KeepingFee,Se llPrice,ReqLevelType1,ReqLevel1,ReqLevelType2,ReqL evel2,ReqLevelType3,ReqLevel3,ReqLevelType4,ReqLev el4,MaxContain,RegionID,Dir,OffsetX,OffsetY,Offset Z,Speed1,Speed2,Scale,BCHeight,BCRadius,EventID,As socFileObj128,AssocFileDrop128,AssocFileIcon128,As socFile1_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,@AssocF ile,@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,It emClass,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,MDI nc,MAR_L,MAR_U,MARInc,PDStr_L,PDStr_U,MDInt_L,MDIn t_U,Quivered,Ammo1_TID4,Ammo2_TID4,Ammo3_TID4,Ammo 4_TID4,Ammo5_TID4,SpeedClass,TwoHanded,Range,PAtta ckMin_L,PAttackMin_U,PAttackMax_L,PAttackMax_U,PAt tackInc,MAttackMin_L,MAttackMin_U,MAttackMax_L,MAt tackMax_U,MAttackInc,PAStrMin_L,PAStrMin_U,PAStrMa x_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,De sc1_128,Param2,Desc2_128,Param3,Desc3_128,Param4,D esc4_128,Param5,Desc5_128,Param6,Desc6_128,Param7, Desc7_128,Param8,Desc8_128,Param9,Desc9_128,Param1 0,Desc10_128,Param11,Desc11_128,Param12,Desc12_128 ,Param13,Desc13_128,Param14,Desc14_128,Param15,Des c15_128,Param16,Desc16_128,Param17,Desc17_128,Para m18,Desc18_128,Param19,Desc19_128,Param20,Desc20_1 28,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,It emClass,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,MDI nc,MAR_L,MAR_U,MARInc,PDStr_L,PDStr_U,MDInt_L,MDIn t_U,Quivered,Ammo1_TID4,Ammo2_TID4,Ammo3_TID4,Ammo 4_TID4,Ammo5_TID4,SpeedClass,TwoHanded,Range,PAtta ckMin_L,PAttackMin_U,PAttackMax_L,PAttackMax_U,PAt tackInc,MAttackMin_L,MAttackMin_U,MAttackMax_L,MAt tackMax_U,MAttackInc,PAStrMin_L,PAStrMin_U,PAStrMa x_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,De sc1_128,Param2,Desc2_128,Param3,Desc3_128,Param4,D esc4_128,Param5,Desc5_128,Param6,Desc6_128,Param7, Desc7_128,Param8,Desc8_128,Param9,Desc9_128,Param1 0,Desc10_128,Param11,Desc11_128,Param12,Desc12_128 ,Param13,Desc13_128,Param14,Desc14_128,Param15,Des c15_128,Param16,Desc16_128,Param17,Desc17_128,Para m18,Desc18_128,Param19,Desc19_128,Param20,Desc20_1 28,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,It emClass,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,MDI nc,MAR_L,MAR_U,MARInc,PDStr_L,PDStr_U,MDInt_L,MDIn t_U,Quivered,Ammo1_TID4,Ammo2_TID4,Ammo3_TID4,Ammo 4_TID4,Ammo5_TID4,SpeedClass,TwoHanded,Range,PAtta ckMin_L,PAttackMin_U,PAttackMax_L,PAttackMax_U,PAt tackInc,MAttackMin_L,MAttackMin_U,MAttackMax_L,MAt tackMax_U,MAttackInc,PAStrMin_L,PAStrMin_U,PAStrMa x_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,De sc1_128,Param2,Desc2_128,Param3,Desc3_128,Param4,D esc4_128,Param5,Desc5_128,Param6,Desc6_128,Param7, Desc7_128,Param8,Desc8_128,Param9,Desc9_128,Param1 0,Desc10_128,Param11,Desc11_128,Param12,Desc12_128 ,Param13,Desc13_128,Param14,Desc14_128,Param15,Des c15_128,Param16,Desc16_128,Param17,Desc17_128,Para m18,Desc18_128,Param19,Desc19_128,Param20,Desc20_1 28,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
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_'+@new ItemID+'.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,Na meStrID,DescStrID,AssocFileIcon,Param1,Param1_Desc 128,Param2,Param2_Desc128,Param3,Param3_Desc128,Pa ram4,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,PaymentDev ice,PreviousCost,Cost,Param1,Param1_Desc128,Param2 ,Param2_Desc128,Param3,Param3_Desc128,Param4,Param 4_Desc128)
VALUES (1,15,'PACKAGE_'+@CodeName,2,0,@yourPrice,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
INSERT INTO _RefPricePolicyOfItem (Service,Country,RefPackageItemCodeName,PaymentDev ice,PreviousCost,Cost,Param1,Param1_Desc128,Param2 ,Param2_Desc128,Param3,Param3_Desc128,Param4,Param 4_Desc128)
VALUES (1,15,'PACKAGE_'+@CodeName,4,0,0,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
INSERT INTO _RefPricePolicyOfItem (Service,Country,RefPackageItemCodeName,PaymentDev ice,PreviousCost,Cost,Param1,Param1_Desc128,Param2 ,Param2_Desc128,Param3,Param3_Desc128,Param4,Param 4_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,RefPackageItemCode Name,SlotIndex,Param1,Param1_Desc128,Param2,Param2 _Desc128,Param3,Param3_Desc128,Param4,Param4_Desc1 28)
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,RefItemCod eName,OptLevel,Variance,Data,MagParamNum,MagParam1 ,MagParam2,MagParam3,MagParam4,MagParam5,MagParam6 ,MagParam7,MagParam8,MagParam9,MagParam10,MagParam 11,MagParam12,Param1,Param1_Desc128,Param2,Param2_ Desc128,Param3,Param3_Desc128,Param4,Param4_Desc12 8)
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:
USE SRO_VT_SHARD_INIT
GO
UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%HerePutAvatarCode%'
Set saletag 0 query:
USE SRO_VT_SHARD_INIT
GO
UPDATE _RefPackageItem
SET SaleTag = '0'
WHERE (CodeName128 LIKE 'PACKAGE_ITEM_MALL_AVATAR%')
t saletag 0 in media.pk2:
http://img20.imageshack.us/img20/9058/refzv.png
صوره من PC
عله سيلك رود ازاي تضيف avatar بل Query
USE SRO_VT_SHARD_INIT -- SRO_VT_SHARD_INIT = database name
GO
SELECT Service,ID,CodeName128,ObjName128,OrgObjCodeName12 8,NameStrID128,DescStrID128,CashItem,Bionic,TypeID 1,TypeID2,TypeID3,TypeID4,DecayTime,Country,Rarity ,CanTrade,CanSell,CanBuy,CanBorrow,CanDrop,CanPick ,CanRepair,CanRevive,CanUse,CanThrow,Price,CostRep air,CostRevive,CostBorrow,KeepingFee,SellPrice,Req LevelType1,ReqLevel1,ReqLevelType2,ReqLevel2,ReqLe velType3,ReqLevel3,ReqLevelType4,ReqLevel4,MaxCont ain,RegionID,Dir,OffsetX,OffsetY,OffsetZ,Speed1,Sp eed2,Scale,BCHeight,BCRadius,EventID,AssocFileObj1 28,AssocFileDrop128,AssocFileIcon128,AssocFile1_12 8,AssocFile2_128,Link
FROM dbo._RefObjCommon
WHERE (CodeName128 LIKE 'ITEM_MALL_AVATAR_%_NAME%')
-- Ex:'ITEM_MALL_AVATAR_%_DRAGONDRESS%'
GROUP BY Service,ID,CodeName128,ObjName128,OrgObjCodeName12 8,NameStrID128,DescStrID128,CashItem,Bionic,TypeID 1,TypeID2,TypeID3,TypeID4,DecayTime,Country,Rarity ,CanTrade,CanSell,CanBuy,CanBorrow,CanDrop,CanPick ,CanRepair,CanRevive,CanUse,CanThrow,Price,CostRep air,CostRevive,CostBorrow,KeepingFee,SellPrice,Req LevelType1,ReqLevel1,ReqLevelType2,ReqLevel2,ReqLe velType3,ReqLevel3,ReqLevelType4,ReqLevel4,MaxCont ain,RegionID,Dir,OffsetX,OffsetY,OffsetZ,Speed1,Sp eed2,Scale,BCHeight,BCRadius,EventID,AssocFileObj1 28,AssocFileDrop128,AssocFileIcon128,AssocFile1_12 8,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:
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,OrgOb jCodeName128,NameStrID128,DescStrID128,CashItem,Bi onic,TypeID1,TypeID2,TypeID3,TypeID4,DecayTime,Cou ntry,Rarity,CanTrade,CanSell,Canbuy,CanBorrow,CanD rop,CanPick,CanRepair,CanRevive,CanUse,CanThrow,Pr ice,CostRepair,CostRevive,CostBorrow,KeepingFee,Se llPrice,ReqLevelType1,ReqLevel1,ReqLevelType2,ReqL evel2,ReqLevelType3,ReqLevel3,ReqLevelType4,ReqLev el4,MaxContain,RegionID,Dir,OffsetX,OffsetY,Offset Z,Speed1,Speed2,Scale,BCHeight,BCRadius,EventID,As socFileObj128,AssocFileDrop128,AssocFileIcon128,As socFile1_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,@AssocF ile,@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,It emClass,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,MDI nc,MAR_L,MAR_U,MARInc,PDStr_L,PDStr_U,MDInt_L,MDIn t_U,Quivered,Ammo1_TID4,Ammo2_TID4,Ammo3_TID4,Ammo 4_TID4,Ammo5_TID4,SpeedClass,TwoHanded,Range,PAtta ckMin_L,PAttackMin_U,PAttackMax_L,PAttackMax_U,PAt tackInc,MAttackMin_L,MAttackMin_U,MAttackMax_L,MAt tackMax_U,MAttackInc,PAStrMin_L,PAStrMin_U,PAStrMa x_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,De sc1_128,Param2,Desc2_128,Param3,Desc3_128,Param4,D esc4_128,Param5,Desc5_128,Param6,Desc6_128,Param7, Desc7_128,Param8,Desc8_128,Param9,Desc9_128,Param1 0,Desc10_128,Param11,Desc11_128,Param12,Desc12_128 ,Param13,Desc13_128,Param14,Desc14_128,Param15,Des c15_128,Param16,Desc16_128,Param17,Desc17_128,Para m18,Desc18_128,Param19,Desc19_128,Param20,Desc20_1 28,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,It emClass,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,MDI nc,MAR_L,MAR_U,MARInc,PDStr_L,PDStr_U,MDInt_L,MDIn t_U,Quivered,Ammo1_TID4,Ammo2_TID4,Ammo3_TID4,Ammo 4_TID4,Ammo5_TID4,SpeedClass,TwoHanded,Range,PAtta ckMin_L,PAttackMin_U,PAttackMax_L,PAttackMax_U,PAt tackInc,MAttackMin_L,MAttackMin_U,MAttackMax_L,MAt tackMax_U,MAttackInc,PAStrMin_L,PAStrMin_U,PAStrMa x_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,De sc1_128,Param2,Desc2_128,Param3,Desc3_128,Param4,D esc4_128,Param5,Desc5_128,Param6,Desc6_128,Param7, Desc7_128,Param8,Desc8_128,Param9,Desc9_128,Param1 0,Desc10_128,Param11,Desc11_128,Param12,Desc12_128 ,Param13,Desc13_128,Param14,Desc14_128,Param15,Des c15_128,Param16,Desc16_128,Param17,Desc17_128,Para m18,Desc18_128,Param19,Desc19_128,Param20,Desc20_1 28,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,It emClass,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,MDI nc,MAR_L,MAR_U,MARInc,PDStr_L,PDStr_U,MDInt_L,MDIn t_U,Quivered,Ammo1_TID4,Ammo2_TID4,Ammo3_TID4,Ammo 4_TID4,Ammo5_TID4,SpeedClass,TwoHanded,Range,PAtta ckMin_L,PAttackMin_U,PAttackMax_L,PAttackMax_U,PAt tackInc,MAttackMin_L,MAttackMin_U,MAttackMax_L,MAt tackMax_U,MAttackInc,PAStrMin_L,PAStrMin_U,PAStrMa x_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,De sc1_128,Param2,Desc2_128,Param3,Desc3_128,Param4,D esc4_128,Param5,Desc5_128,Param6,Desc6_128,Param7, Desc7_128,Param8,Desc8_128,Param9,Desc9_128,Param1 0,Desc10_128,Param11,Desc11_128,Param12,Desc12_128 ,Param13,Desc13_128,Param14,Desc14_128,Param15,Des c15_128,Param16,Desc16_128,Param17,Desc17_128,Para m18,Desc18_128,Param19,Desc19_128,Param20,Desc20_1 28,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
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_'+@new ItemID+'.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,Na meStrID,DescStrID,AssocFileIcon,Param1,Param1_Desc 128,Param2,Param2_Desc128,Param3,Param3_Desc128,Pa ram4,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,PaymentDev ice,PreviousCost,Cost,Param1,Param1_Desc128,Param2 ,Param2_Desc128,Param3,Param3_Desc128,Param4,Param 4_Desc128)
VALUES (1,15,'PACKAGE_'+@CodeName,2,0,@yourPrice,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
INSERT INTO _RefPricePolicyOfItem (Service,Country,RefPackageItemCodeName,PaymentDev ice,PreviousCost,Cost,Param1,Param1_Desc128,Param2 ,Param2_Desc128,Param3,Param3_Desc128,Param4,Param 4_Desc128)
VALUES (1,15,'PACKAGE_'+@CodeName,4,0,0,-1,'xxx',-1,'xxx',-1,'xxx',-1,'xxx')
INSERT INTO _RefPricePolicyOfItem (Service,Country,RefPackageItemCodeName,PaymentDev ice,PreviousCost,Cost,Param1,Param1_Desc128,Param2 ,Param2_Desc128,Param3,Param3_Desc128,Param4,Param 4_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,RefPackageItemCode Name,SlotIndex,Param1,Param1_Desc128,Param2,Param2 _Desc128,Param3,Param3_Desc128,Param4,Param4_Desc1 28)
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,RefItemCod eName,OptLevel,Variance,Data,MagParamNum,MagParam1 ,MagParam2,MagParam3,MagParam4,MagParam5,MagParam6 ,MagParam7,MagParam8,MagParam9,MagParam10,MagParam 11,MagParam12,Param1,Param1_Desc128,Param2,Param2_ Desc128,Param3,Param3_Desc128,Param4,Param4_Desc12 8)
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:
USE SRO_VT_SHARD_INIT
GO
UPDATE [dbo].[_RefObjCommon]
SET Service = 1
WHERE CodeName128 like '%HerePutAvatarCode%'
Set saletag 0 query:
USE SRO_VT_SHARD_INIT
GO
UPDATE _RefPackageItem
SET SaleTag = '0'
WHERE (CodeName128 LIKE 'PACKAGE_ITEM_MALL_AVATAR%')
t saletag 0 in media.pk2:
http://img20.imageshack.us/img20/9058/refzv.png
صوره من PC