[Guide] How to take away arena points costs from arena vendors PICS

[chanceless]

Hello!
If you are running or planning on running a pvp funserver, you probably want your players to be able to buy arena S1 and S2. Now, in the mosts DBs you need arena points to buy the gear as default. Didnt find any guide for tacking this away so I decided to make my own guide.

1. Open up your Navicat/SQLyog
2. Open your DB, and go to the 'Items' table.

3. Merc(S2) Arena is at the second last page and the last. Go to the second last page(default)

4. Scroll to the left end, there it should be a row called 'ItemExtendedCost'
5. Scroll down and whenever there is something in that row, change it to 0. This do take some time

6. Now do the same with the last page
7. You should be done, go in to your server and test. If it doesn't work you have done something wrong.

Its the same for T1, T2, T3, T4, T5 and T6

//Chanceless
All credit goes to me and MMowned
Searched the site, didnt find anything similar!

[freshfish]

Thats a nice trick i will try it later.

[Sharpshooter007]

nice i like it.

[chaoticd35]

Yes this worked for me,,Thanks +Rep

[Zokmag]

Nice +Rep!

[Festigio]

Nice guide. +Rep

[Dee2001]

hmm, mabe if you look a bit harder and test a bit more u could mabe find out how to "add" cost to items take some experimenting though

[exorsist]

Nice guide... Now i am not needed to Get all the honor

[hadi]

how do i save when i do it?

[Xeneth]

http://www.mmowned.com/forums/emulat...tml#post496164

[s_t_f_u0]

so this actually works?

[Incinerator]

so this actually works?

STFU (and no i dont mean to do said action) yeah this works. but if you can work with queries and such have that ability use the xeneth one .. it takes 5 seconds to run vs the 3k hours of down 0 down 0 down 0 down 0..

While i don't knock chanceless at all.. this is the way i did a few things i should have set a query up for.. the only suggestion i would give to him is that you could set up a simple filter.. since hes using navi ill guide that way.

top of page there is a button "Filter Wizard"

press that then you get a box ... it comes up default something like

<entry id> is equal to <?>
<add filter> <apply or press ctrl+r>

change click.. entry id... use drop down box to edit field to use "extitemcost" i believe the colum is called..

change "is equal to" into "is greater than" and the <?> to 0

press ctrl + r

this will show you ONLY things that cost EXTENDED items..

if you know what your lookin for say.. badge of justices and just want to remove that put that item number into it..


You can also right click and "save view" in the top box to come back to it later.






If you have added special cost items you can continue to add filters and add the value to "not eqal to" "your value"

sorry if thats confusing when i get a min later i will get a couple screenies to help out..