Vsro Files - Max Cap, NPC Edit, Items

[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.

[PortalDark]

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

[octaviansan]

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

[LastThief]

Originally Posted by octaviansan

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

nah

[octaviansan]

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

[fiction12]

Originally Posted by octaviansan

****...
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..

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)

[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?

[sarkoplata]

For adding items :
You should go to VT_SHARD database,

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

PackageCode of ITEM_CH_SWORD_01 will be set to PACKAGE_ITEM_CH_SWORD_01

Find "_RefScrapOfPackageItem"

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

Find "_RefShopGoods"

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

Find "_RefPriceOfPolicyItem"

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.

[fiction12]

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..

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...

[Zoxon]

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

[fiction12]

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...

Originally Posted by sarkoplata

For adding items :
You should go to VT_SHARD database,

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

PackageCode of ITEM_CH_SWORD_01 will be set to PACKAGE_ITEM_CH_SWORD_01

Find "_RefScrapOfPackageItem"

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

Find "_RefShopGoods"

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

Find "_RefPriceOfPolicyItem"

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...

[penelopee]

Originally Posted by Zoxon

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

login into SMC
Search char edid.
Search your char there.

Put new EXP in it.

[Zoxon]

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

[lesderid]

Originally Posted by fiction12

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

lol, noob.

[fiction12]

Originally Posted by lesderid

lol, noob.

was that necesary?...