About My Server

04/09/2012 00:47 david1919#1
How i Can Make FREE Start ITEM ?
and Free SILKS?

and when i join ACC i open in SQL (gm account)

its open CHAR LV1 and no max lvl?

TY FOR HELPERS
04/09/2012 00:59 ღ ∂ Ropp#2
Free silks, you can use a query to add silk to everyone's accounts.. also you can add it into register.
Free starting item you need to add it into the database, go to sro_vt_shard --> program-ability--> stored procedure --> dbo._AddNewChar and edit what you want to start with in there.
04/09/2012 01:01 david1919#3
how i can chenge in _AddNewChar item i open it and i dont know what do in this

can u give me Image Or Video?
04/09/2012 01:01 ღ ∂ Ropp#4
Yeah give me a second , i'll find the links for you ;']

#EDIT;

[ Credits to Dr.Abdelfattah; ]

" Databases > SRO_VT_SHARD_INIT > Programmability > Stored Procedures > _AddNewChar.dbo
Right click it, click "Modify"
to add start items to your inventory scroll to the bottom
add lines like this :

exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SWORD_11_SET_B_RARE',1,12
ITEM_CH_SWORD_11_SET_B_RARE means Fight nova sword, obviously.... 1 means amount, 12 means plussvalue

like this :
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CODE',(Amount),(Plusvalue)

mine looks like this

Spoiler:

Code:
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_PREMIUM_VIETNAM_GOLDTIME_PLU S',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_HP_SUPERSET_5_BAG',1000,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_MP_SUPERSET_5_BAG',1000,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_MALL_REVERSE_RETURN_SCROLL',50,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_MALL_INVENTORY_ADDITION',1,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_HWAN_POTION',20,1
exec _ADD_ITEM_EXTERN @CharName,'ITEM_EVENT_HWAN_POTION',20,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,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SHIELD_11_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_TBLADE_11_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BLADE11_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_BOW_11_SET_B_RARE',1,12
exec _ADD_ITEM_EXTERN @CharName,'ITEM_CH_SPEAR_11_SET_B_RARE',1,12 "


[ Silk registerring , credits to whoever made this, since people are fighting over who made it! ]

[Only registered and activated users can see links. Click Here To Register...]
04/09/2012 01:08 david1919#5
how i can make GRAB PET ? and avatar?
04/09/2012 01:10 ღ ∂ Ropp#6
Umm, I don't think there is threads around here for those, try going to ragez0ne or something..
04/09/2012 01:11 david1919#7
and the guide how make silk when register
its dont give when i register its give when i will worte it in SQL id char and how many silk give to this ID
04/09/2012 01:12 ღ ∂ Ropp#8
Yeah, it's the easiest way, unless you add it into your register page with xampp or something.
04/09/2012 01:15 david1919#9
ok TY bro u help me so much
but what GRAB PET code for start item>?

and how make START lvl 110?
04/09/2012 01:16 ღ ∂ Ropp#10
Starting level 110, you would have to do another procedure in that list, and change it from 1 to 110, uhh let me search for it.
And no problem david, make sure to press thanks ;].
04/09/2012 01:19 david1919#11
every post u got thanks but now i need know how make START LVL 110
04/09/2012 01:29 ღ ∂ Ropp#12
Let me find a guide for you, uno momento ;']

EDIT;

Go to Database -> SRO_VT_SHARD -> Progammability -> Stored Procedures -> dbo.AddNewChar

change this...

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)

to something else that you prefer ;'] !

Don't forget to like.

REMEMBER !
Google is your best friend , or the search bar *_____*
04/09/2012 01:33 david1919#13
i found it now :)
04/09/2012 01:40 ღ ∂ Ropp#14
Great , have fun with your server, if you need anything else post on my visitors page !
I'm always here to help hun ;].
04/09/2012 01:47 david1919#15
its dont open char 110 its again just Lv1