How To Config PVP Server based on vsro files

10/06/2011 11:54 ahmed4ever2u#1
Hi all After greeting

i finished installing the server Very well and i'm Online in the game

But i wanna Cfg the database to use the server for fun like being lvl 100 with full set in the inventory

Thank You for reading my post
10/06/2011 14:16 badji#2
SRO_VT_SHARD>Programmability>stored Procedures> AddNewChar (modify) =

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)



this for start lvl sp gold etc

items on bottom page

example :

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_PREMIUM_VIETNAM_GOLDTIME_PLU S',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_REVERSE_RETURN_SCROLL',50,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_GLOBAL_CHATTING',50,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_HWAN_POTION',20,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_11_SET_B_RARE',1,7



IF ANYONE KNOWS HOW TO ADD FB ITEMS OR WEAPONS WITH GOOD STATS RIGHT AWAY AFTER CREATE CHAR PM or post it here


ty
10/06/2011 14:18 18andLife#3
Quote:
Originally Posted by badji View Post
SRO_VT_SHARD>Programmability>stored Procedures> AddNewChar (modify) =

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)



this for start lvl sp gold etc

items on bottom page

example :

exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_PREMIUM_VIETNAM_GOLDTIME_PLU S',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_REVERSE_RETURN_SCROLL',50,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_GLOBAL_CHATTING',50,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_HWAN_POTION',20,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_11_SET_B_RARE',1,7



IF ANYONE KNOWS HOW TO ADD FB ITEMS OR WEAPONS WITH GOOD STATS RIGHT AWAY AFTER CREATE CHAR PM or post it here


ty
it's not possible to change the stats or add blues to starter items ;)
10/06/2011 14:27 LastThief#4
Quote:
Originally Posted by 18andLife View Post
it's not possible to change the stats or add blues to starter items ;)
some body already the both changes check ads section for something like dragon sro

@topic
you will also create kral egy sro and tell ppl that you've programmed it :awesome:?
10/06/2011 14:42 18andLife#5
Quote:
Originally Posted by LastThief View Post
some body already the both changes check ads section for something like dragon sro
Those items were FB with 100% stats at the NPC. not in the inventory when you start ;)
10/06/2011 16:16 ahmed4ever2u#6
Quote:
Originally Posted by LastThief View Post
you will also create kral egy sro and tell ppl that you've programmed it :awesome:?
[Only registered and activated users can see links. Click Here To Register...]


WITH YOUR FREAK WORDS ABOUT PROGRAMMING MY OWN SERVER

@ 18andlife

Would you like to share your pvp server cfg ( cap 100 )


Edit
Quote:
Originally Posted by 18andLife View Post
Those items were FB with 100% stats at the NPC. not in the inventory when you start ;)
its easy to rip Them
10/06/2011 16:25 18andLife#7
Quote:
Originally Posted by ahmed4ever2u View Post

@ 18andlife

Would you like to share your pvp server cfg ( cap 100 )
no.
10/06/2011 16:51 tifalord#8
Quote:
Originally Posted by LastThief View Post
some body already the both changes check ads section for something like dragon sro

@topic
you will also create kral egy sro and tell ppl that you've programmed it :awesome:?
i don't know why u hate Arabs and Egyptians .

:confused::confused:
10/06/2011 21:27 LastThief#9
Quote:
Originally Posted by tifalord View Post
i don't know why u hate Arabs and Egyptians .

:confused::confused:
simply most of them are retards

@ahmed4ever2u

I don't remember your old site but you said on it that you've programmed srevo :aweomse:
10/07/2011 08:27 ichigo14000#10
and how to start all char in jangan ?
10/07/2011 10:09 alexutublade#11
SRO_VT_SHARD --> Programmability --> Stored Procedures --> dbo._AddNewChar -->
Quote:
VALUES (@RefCharID, @CharName, @CharScale, 20, 20, @StartRegionID, @StartPos_X, @StartPos_Y, @StartPos_Z, @DefaultTeleport, 45,
GetDate(), 1, 1, 0, 0, 0, 200,200, 1, 1, 1, 1)
Just modify the bolded ones with the coord`s.
Thx to LastThief.
10/07/2011 13:32 tifalord#12
Quote:
Originally Posted by LastThief View Post
simply most of them are retards

@ahmed4ever2u

I don't remember your old site but you said on it that you've programmed srevo :aweomse:
same as France people . ROFL
10/07/2011 13:43 ichigo14000#13
Quote:
Originally Posted by alexutublade View Post
SRO_VT_SHARD --> Programmability --> Stored Procedures --> dbo._AddNewChar -->
Just modify the bolded ones with the coord`s.
Thx to LastThief.
start in chines with eu or...?
10/07/2011 16:38 lesderid#14
Quote:
Originally Posted by 18andLife View Post
it's not possible to change the stats or add blues to starter items ;)
It is. :P
10/07/2011 23:00 ahmed4ever2u#15
Quote:
Originally Posted by lesderid View Post
It is. :P
So would you please tell us how?