Register for your free account! | Forgot your password?

Go Back   elitepvpers > Popular Games > Silkroad Online > SRO Private Server
You last visited: Today at 02:41

  • Please register to post and access all features, it's quick, easy and FREE!

Advertisement



media.pk2 strange behavior (refshopgoods)

Discussion on media.pk2 strange behavior (refshopgoods) within the SRO Private Server forum part of the Silkroad Online category.

Reply
 
Old   #1
 
379332's Avatar
 
elite*gold: 0
Join Date: May 2007
Posts: 297
Received Thanks: 71
media.pk2 strange behavior (refshopgoods)

Am I the only one who try to E.G put service 0 in Pine or MAGIC CUBE, patch media, and my client just simply doesn`t open?
The same is happening when I try to add avatar, all the codes are correct on TXT, just missing on Refshopgoods, if I add the avatar there my game doesn`t open too, and I'm fallowing a guide step by step, just a quick question, if the avatar is missing on reshopgood on the database and than I add it, does the server needs a RR?
EDIT1:just deleted magic cubes/pine lines from .txt and worked, but I'm still having the issue of trying a new code
379332 is offline  
Old 06/29/2012, 10:10   #2

 
Haxor's Avatar
 
elite*gold: 0
Join Date: Feb 2008
Posts: 3,777
Received Thanks: 1,455
I was have the same mistake
tried like 3-4 hours and game wasnt opening
The mistake was that i put space instead of tab

When you add to refshopgoods use tab between each 2 and you fine
Haxor is offline  
Old 06/29/2012, 10:25   #3
 
379332's Avatar
 
elite*gold: 0
Join Date: May 2007
Posts: 297
Received Thanks: 71
Quote:
Originally Posted by saif1999 View Post
I was have the same mistake
tried like 3-4 hours and game wasnt opening
The mistake was that i put space instead of tab

When you add to refshopgoods use tab between each 2 and you fine
correct me if i'm wrong, E.G
I'm using this
Code:
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
by:H34D_B4NG3R
I check all the database and txt, the only thing that its missing on my database/txt is the Refshopgoods lines.
If i have something like this.
Code:
1	15	MALL_AVATAR_DRESS	PACKAGE_ITEM_MALL_AVATAR_W_CARNIVAL	17	-1	xxx	-1	xxx	-1	xxx	-1	xxx
where 17 is the slot on item mall right?
I have to place the same code into the Refshopgoods, does it need to be as in the same order show into the database?
Code:
1	15	MALL_AVATAR_DRESS	PACKAGE_ITEM_MALL_AVATAR_W_ARABIA_2	15	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	MALL_AVATAR_DRESS	PACKAGE_ITEM_MALL_AVATAR_W_CARNIVAL	17	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	MALL_AVATAR_DRESS	PACKAGE_ITEM_MALL_AVATAR_W_CARNIVAL_2	35	-1	xxx	-1	xxx	-1	xxx	-1	xxx
or i can put into the txt like this
Code:
1	15	STORE_WC_TRADER_TAB2	PACKAGE_ITEM_CH_W_TRADE_TRADER_04	0	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	STORE_WC_TRADER_TAB2	PACKAGE_ITEM_CH_W_TRADE_TRADER_05	1	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	MALL_AVATAR_DRESS	PACKAGE_ITEM_MALL_AVATAR_W_CARNIVAL	17	-1	xxx	-1	xxx	-1	xxx	-1	xxx
Don`t know if any1 will understand what i just said LOL.
379332 is offline  
Old 06/29/2012, 10:35   #4

 
Haxor's Avatar
 
elite*gold: 0
Join Date: Feb 2008
Posts: 3,777
Received Thanks: 1,455
Yes
Do refshop goods in txt same as in db
And yes the number '17' is slot index
If your server running without errors when starting it
So the problem is from media.pk2 i think
Haxor is offline  
Old 06/29/2012, 10:37   #5
 
379332's Avatar
 
elite*gold: 0
Join Date: May 2007
Posts: 297
Received Thanks: 71
Quote:
Originally Posted by saif1999 View Post
Yes
Do refshop goods in txt same as in db
And yes the number '17' is slot index
If your server running without errors when starting it
So the problem is from media.pk2 i think
Sweet, I will sleep now, almost 6AM here. I've been smashing my head on the keyboard all day trying to figure that out, I'll keep the updates up of my progression. Thanks for the info. I hope it works.
EDIT:NOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOOES, still the same error ;/

any1 have new idea?
Code:
1    	15    	MALL_AVATAR_DRESS    	PACKAGE_ITEM_MALL_AVATAR_M_ANGEL_WING_DRESS    	40    	-1    	xxx    	-1    	xxx    	-1    	xxx    	-1    	xxx
1	15	MALL_AVATAR_DRESS	PACKAGE_ITEM_MALL_AVATAR_M_ARABIA	2	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	MALL_AVATAR_DRESS	PACKAGE_ITEM_MALL_AVATAR_M_ARABIA_2	14	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	MALL_AVATAR_DRESS	PACKAGE_ITEM_MALL_AVATAR_M_CARNIVAL	16	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	MALL_AVATAR_DRESS	PACKAGE_ITEM_MALL_AVATAR_M_CARNIVAL_2	34	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	MALL_AVATAR_DRESS	PACKAGE_ITEM_MALL_AVATAR_M_CHINGCHU	20	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	MALL_AVATAR_DRESS	PACKAGE_ITEM_MALL_AVATAR_M_CLOWN	4	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	MALL_AVATAR_DRESS	PACKAGE_ITEM_MALL_AVATAR_M_DARKLKNIGHT	24	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	MALL_AVATAR_DRESS	PACKAGE_ITEM_MALL_AVATAR_M_EARTHSPIRIT	38	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	MALL_AVATAR_DRESS	PACKAGE_ITEM_MALL_AVATAR_M_FAIRY_2	22	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	MALL_AVATAR_DRESS	PACKAGE_ITEM_MALL_AVATAR_M_HWARANG	28	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	MALL_AVATAR_DRESS	PACKAGE_ITEM_MALL_AVATAR_M_KNIGHT	0	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	MALL_AVATAR_DRESS	PACKAGE_ITEM_MALL_AVATAR_M_KNIGHT_3	18	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	MALL_AVATAR_DRESS	PACKAGE_ITEM_MALL_AVATAR_M_NEWDEVIL	30	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	MALL_AVATAR_DRESS	PACKAGE_ITEM_MALL_AVATAR_M_PIRATE_2	10	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	MALL_AVATAR_DRESS	PACKAGE_ITEM_MALL_AVATAR_M_PIRATECREW	12	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	MALL_AVATAR_DRESS	PACKAGE_ITEM_MALL_AVATAR_M_PIRATECREW_2	26	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	MALL_AVATAR_DRESS	PACKAGE_ITEM_MALL_AVATAR_M_SAINTWARRIOR	32	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	MALL_AVATAR_DRESS	PACKAGE_ITEM_MALL_AVATAR_M_SPARTA	8	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	MALL_AVATAR_DRESS	PACKAGE_ITEM_MALL_AVATAR_M_TURKEY	6	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1	15	MALL_AVATAR_DRESS	PACKAGE_ITEM_MALL_AVATAR_W_ADMIRAL	37	-1	xxx	-1	xxx	-1	xxx	-1	xxx
1    	15    	MALL_AVATAR_DRESS    	PACKAGE_ITEM_MALL_AVATAR_W_ANGEL_WING_DRESS    	41    	-1    	xxx    	-1    	xxx    	-1    	xxx    	-1    	xxx
added both M and W angel wing dress, with the TAB not just spacing, and still game doesn`t open (its the same way on DB too.)

86 views and no1 knows this, really? Ç.Ç
379332 is offline  
Reply


Similar Threads Similar Threads
[Verlosung]Strange Flamethrower|Strange Kunai
10/05/2011 - Team Fortress 2 - 16 Replies
Schreibt einfach eine Zahl zwischen 1 und 5. Jeder kann nur eine der beiden Waffen gewinnen. Viel Glück!
Can anyone trade a strange rocket launcher for a strange pistol?
09/27/2011 - Team Fortress 2 - 1 Replies
bleh
New Hackshield behavior?
06/15/2009 - Mabinogi - 10 Replies
Well as of last update any change to client.exe or pleione.dll, standard.dll, etc will make your client to display a Server cant be reached message kicking you out, YES i did fix the crc32 for testing, it will always do this, even with no hacks/mods loaded, discuz!
GameMaster (GM) and their behavior
09/14/2008 - Cabal Online - 4 Replies
Hi all, one of my guildmates got banned. but he isnt using any kind of Bot. This is some kind of funny storie. So listen ^^ He was killing Spectors in Undead Ground. Then a Player came to him and started to KS my guild mate. After several time that player started to cry dont KS me. And then he started to shout to my guildmate u are a Bot. Till then my Guildmate didnt do anthing. But after that he just sweard to that player who insulted him. That player who provoked my Guildmate to swear...
Strange instance behavior
07/06/2008 - WoW Private Server - 3 Replies
Hi! I have found some similar “problems” so I wanted to ask for help here. Yesterday I set up my own server using “Novo’s Easy WoW Emulator”. Everything works fine except one thing seems strange: I wanted to relive old days and solo some old raid instances, for example “Blackwing Lar”. But the instance seemed different… for example there was no starting event at Razorgore, no scene of Nefarius fighting Vael and no Lord Victor at his throne (instead some dragonlings (the ones coming when...



All times are GMT +1. The time now is 02:41.


Powered by vBulletin®
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
SEO by vBSEO ©2011, Crawlability, Inc.
This site is protected by reCAPTCHA and the Google Privacy Policy and Terms of Service apply.

Support | Contact Us | FAQ | Advertising | Privacy Policy | Terms of Service | Abuse
Copyright ©2024 elitepvpers All Rights Reserved.