Vsro Files - Max Cap, NPC Edit, Items

Page 3 of 5

10/02/2011 22:16 octaviansan#31

Doesn't matter.
Does anyone know how to add stones, items to NPC ?

How do i make Stones Stackable ? I want to make a stone to be 250 stackable.

10/02/2011 23:25 PortalDark#32

Quote:

Originally Posted by octaviansan

Doesn't matter.
Does anyone know how to add stones, items to NPC ?

How do i make Stones Stackable ? I want to make a stone to be 250 stackable.

to add to npc edit database and add them into media.pk2

10/02/2011 23:44 octaviansan#33

Is it possible to make a stone stackable 250, without editing the mediapk2?

10/03/2011 09:54 LastThief#34

Quote:

Originally Posted by octaviansan

Is it possible to make a stone stackable 250, without editing the mediapk2?

nah

10/03/2011 14:39 octaviansan#35

Damn...
Does anyone know how to change the spawn point of EU chars.
Example: I want them to spawn in Jangan.

10/09/2011 04:26 fiction12#36

Quote:

Originally Posted by octaviansan

Damn...
Does anyone know how to change the spawn point of EU chars.
Example: I want them to spawn in Jangan.

Yeah, create a chn char, then log off and go to the database, SRO_VT_SHARD copy that cords of the char (also the teleport ID) and add that in here...
SRO_VT_SHARD_INIT -> Progammability -> Stored Procedures -> dbo.AddNewChar..

Code:

INSERT INTO _Char (RefObjID, CharName16, Scale, Strength, Intellect, LatestRegion,PosX, PosY, PosZ, AppointedTeleport, InventorySize,      
				LastLogout, CurLevel, MaxLevel, RemainGold, RemainStatPoint, RemainSkillPoint, HP, MP, JobLvl_Trader, JobLvl_Hunter, JobLvl_Robber, WorldID)      
	VALUES (@RefCharID, @CharName, @CharScale, 129, 129, @[COLOR="Red"][B][U]StartRegionID, @StartPos_X, @StartPos_Y, @StartPos_Z, @DefaultTeleport[/U][/B][/COLOR], 60,      
				GetDate(), 110, 110, 1000000000, 327, 9999999, 11168,11168, 1, 1, 1, 1)

10/10/2011 18:21 Zoxon#37

add that here how? cuz if i change it i get a query error

sry. solved

A question again. How can i add + exp and 3 invertory page to the starter char?

10/10/2011 19:16 sarkoplata#38

For adding items :
You should go to VT_SHARD database,

Find "_RefPackageItem" - Where you make a item as package, example ;

Code:

PackageCode of ITEM_CH_SWORD_01 will be set to PACKAGE_ITEM_CH_SWORD_01

Find "_RefScrapOfPackageItem"

Code:

I think this is necessary but got no idea what it works for.

Find "_RefShopGoods"

Code:

Table where you edit MALL / NPC Items. Works with ITEM TAB and PackageItemName

Find "_RefPriceOfPolicyItem"

Code:

Table where you edit Prices of NPC / MALL items.You have to add 3row for each item as ive seen.

Theese are what I found out myself , PLEASE let me know if you put more info after theese.

10/10/2011 19:55 fiction12#39

Quote:

Originally Posted by Zoxon

add that here how? cuz if i change it i get a query error

sry. solved

A question again. How can i add + exp and 3 invertory page to the starter char?

Yeah go to..
SRO_VT_SHARD_INIT -> Progammability -> Stored Procedures -> dbo.AddNewChar..

Code:

INSERT INTO _Char (RefObjID, CharName16, Scale, Strength, Intellect, LatestRegion,PosX, PosY, PosZ, AppointedTeleport, InventorySize,      
				LastLogout, CurLevel, MaxLevel, RemainGold, RemainStatPoint, RemainSkillPoint, HP, MP, JobLvl_Trader, JobLvl_Hunter, JobLvl_Robber, WorldID)      
	VALUES (@RefCharID, @CharName, @CharScale, 129, 129, @StartRegionID, @StartPos_X, @StartPos_Y, @StartPos_Z, @DefaultTeleport, [COLOR="Red"][B][U]60[/U][/B][/COLOR],      
				GetDate(), 110, 110, 1000000000, 327, 9999999, 11168,11168, 1, 1, 1, 1)

Change the 60 for 109 will be 3 inventory pages now...

10/10/2011 19:58 Zoxon#40

and how to add + exp (%) to the char?

10/10/2011 20:11 fiction12#41

Quote:

Originally Posted by Zoxon

and how to add + exp (%) to the char?

Hmmm i think that is not possible, cuz there's not such table for that...

Quote:
Originally Posted by sarkoplata
For adding items :
You should go to VT_SHARD database,

Find "_RefPackageItem" - Where you make a item as package, example ;
Code:
PackageCode of ITEM_CH_SWORD_01 will be set to PACKAGE_ITEM_CH_SWORD_01
Find "_RefScrapOfPackageItem"
Code:
I think this is necessary but got no idea what it works for.
Find "_RefShopGoods"
Code:
Table where you edit MALL / NPC Items. Works with ITEM TAB and PackageItemName
Find "_RefPriceOfPolicyItem"
Code:
Table where you edit Prices of NPC / MALL items.You have to add 3row for each item as ive seen.
Theese are what I found out myself , PLEASE let me know if you put more info after theese.

Im trying to add some items to npc's too, but kinda hard since ima noob doing this, but this the way i learn, i'll try to add Npc's and stuff...

10/10/2011 20:17 penelopee#42

Quote:

Originally Posted by Zoxon

and how to add + exp (%) to the char?

10/10/2011 20:28 Zoxon#43

i didnt mean that adding by manual. I meant adding automatically when i create the char.

10/10/2011 20:28 lesderid#44

Quote:

Originally Posted by fiction12

Hmmm i think that is not possible, cuz there's not such table for that...

lol, noob.

10/10/2011 20:31 fiction12#45

Quote:

Originally Posted by lesderid

lol, noob.

was that necesary?...

Page 3 of 5