Vsro Files - Max Cap, NPC Edit, Items

10/02/2011 01:02 octaviansan#1
Hello,

Since i managed to get the server files to run. I shall soon buy a dedicated server.
So my questions if anyone if willing to tell me ( tutorial,guide ).

1. How do i set the Maximum Cap, and set all new char with that level + Items in inventory.
2. How do i Edit the NPC (database, media) to add vigors, avatars and stones.

If anyone could post even a little information it would be helpfull.
Thanks
10/02/2011 01:06 18andLife#2
Quote:
Originally Posted by octaviansan View Post
Hello,

Since i managed to get the server files to run. I shall soon buy a dedicated server.
So my questions if anyone if willing to tell me ( tutorial,guide ).

1. How do i set the Maximum Cap, and set all new char with that level + Items in inventory.
2. How do i Edit the NPC (database, media) to add vigors, avatars and stones.

If anyone could post even a little information it would be helpfull.
Thanks

second question: you have to add the items in 4 tables ;) also in media.pk2
10/02/2011 01:27 proboyxd#3
eh make it PVP like Coronita server it was great

good luck
10/02/2011 02:15 PortalDark#4
for lvl cap and mastery cap is debugging gameserver.exe
10/02/2011 03:58 Dr.Abdelfattah#5
Quote:
Originally Posted by PortalDark View Post
for lvl cap and mastery cap is debugging gameserver.exe
that's right but the question here :D can i increase the level cap to 140 for example : )) ?
10/02/2011 04:23 Getzabelz#6
Quote:
Originally Posted by Dr.Abdelfattah View Post
that's right but the question here :D can i increase the level cap to 140 for example : )) ?
Yes, you can
10/02/2011 05:17 Dr.Abdelfattah#7
Quote:
Originally Posted by Getzabelz View Post
Yes, you can
i don't try to test that before but i think u must need to make some edit with database too to set the EXP of each lvl after lv 110 !!
10/02/2011 08:10 lesderid#8
Quote:
Originally Posted by Dr.Abdelfattah View Post
i don't try to test that before but i think u must need to make some edit with database too to set the EXP of each lvl after lv 110 !!
Umm, no. DB has level information from level 1 to 140. (140 being the 'max cap' Joymax planned for SRO)
10/02/2011 16:35 octaviansan#9
Ok,
Server is working.
Reg Page Working.
Manage to get Instant lv110/100 + Items in inventory
SP and Gold when u create a char.

Now, i need to know how:
1. to make EU chars spawn in jangan?
2. Add automatic account silks.
3. A good tutorial/guide how to add items in NPC , mediapk2.
10/02/2011 17:05 JENZO#10
Quote:
Originally Posted by octaviansan View Post
Ok,
Server is working.
Reg Page Working.
Manage to get Instant lv110/100 + Items in inventory
SP and Gold when u create a char.

Now, i need to know how:
1. to make EU chars spawn in jangan?
2. Add automatic account silks.
3. A good tutorial/guide how to add items in NPC , mediapk2.
so me 2

i can add item in invntory in any new char but i need know how i can make it Lv110 And auto silk and SP And Gold And 3 Page
10/02/2011 17:11 octaviansan#11
Quote:
Originally Posted by JENZO View Post
so me 2

i can add item in invntory in any new char but i need know how i can make it Lv110 And auto silk and SP And Gold And 3 Page
Go Database -> SRO_VT_SHARD_INIT -> Progammability -> Stored Procedures -> dbo.AddNewChar

Then, u edit the staring lvl, maximum lvl, etc.
Here's my edit:
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, 60,      
				GetDate(), 110, 110, 1000000000, 327, 9999999, 11168,11168, 1, 1, 1, 1)
10/02/2011 17:15 PortalDark#12
Quote:
Originally Posted by octaviansan View Post
Go Database -> SRO_VT_SHARD_INIT -> Progammability -> Stored Procedures -> dbo.AddNewChar

Then, u edit the staring lvl, maximum lvl, etc.
Here's my edit:
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, 60,      
				GetDate(), 110, 110, 1000000000, 327, 9999999, 11168,11168, 1, 1, 1, 1)
i dont know if it helps, but maybe a trigger could do if someone wanna set start silk, or is there already one?
10/02/2011 17:15 octaviansan#13
Well tomorrow im going to buy more ram, set up the server, post here on epvp.
But i need a tutorial showing how to add silks automatic to a new account.
10/02/2011 17:17 PortalDark#14
Quote:
Originally Posted by octaviansan View Post
Well tomorrow im going to buy more ram, set up the server, post here on epvp.
But i need a tutorial showing how to add silks automatic to a new account.
well, make a trigger on sql to add silks when there is an insert done
10/02/2011 17:19 octaviansan#15
Sorry, im noob.
How do i do that, could u give me the sql command?