Removing Costs and Conditions of obtaining items

**Xeneth** · 12-28-2007

The Query To Execute

Code:

UPDATE `items` SET ItemExtendedCost = 0 WHERE `entry` BETWEEN '1' and '40000';

The Query Defined.

UPDATE "items" = Table that the query is being executed in. (replace ascent with whatever your world database is named)

WHERE "entry" = Column

BETWEEN '1' and '40000'; = Lines to be Edited according to selected column.

Variables.

Code:

SET ? = 0

? = Item Extended Cost = Removes Arena point requirement/Honor Point Requirement

? = ArenaRankRequirement = Disables Arena Rank Requirement

? = RequiredFaction = Disables Faction Requirment (Revered, Exalted, Et'cetra)

? = RequiredFactionStanding = Disables Required Faction Standing (Thrallmar, Scryers, Et'cetra)

? = buyprice = How much the item will cost if in a shop

? = sellprice = How much the item will sell for (I set to 1 for every item in the game, So when you trash items you'd normally have to type in "Delete" for, You can just sell to vendor, It's faster and your players will thank you for it)

Spread this guide like a wildfire
I don't care if i don't get credit for it, This is information that anyone with half a brain should already know.
I would also like to thank MMOWNED for all the knowledge you've given me.

Special thanks goes to

Mafiaboy

Julianx

Illadin1

Gastric

WARNING

ONCE YOU'VE EDITED THE TABLE, THE ONLY WAY TO GET THESE VALUES BACK IS TO RELOAD YOUR DATABASE OR ADD VALUES TO 40000 ITEMS MANUALLY

**chanceless** · 12-29-2007

well thank you for ehm stealing my post... without credits to me or adding me to the thanks? Wow, you are sooo great...
.....

**Xeneth** · 12-30-2007

Stealing what post?! I didn't steal your post, I simplified it.

Instead of going *Down Key* *0* for 30 minutes you can just type in this 1 query and it has way more information in it.

**Xeneth** · 01-01-2008

Bump

<filler>

**Xeneth** · 01-09-2008

Simplified this Further, Here's a list of all the queries, Just paste this and mass execute

Code:

UPDATE `items` SET ItemExtendedCost = 0 WHERE `entry` BETWEEN '1' and '40000';
UPDATE `items` SET ArenaRankRequirement = 0 WHERE `entry` BETWEEN '1' and '40000';
UPDATE `items` SET RequiredFaction = 0 WHERE `entry` BETWEEN '1' and '40000';
UPDATE `items` SET RequiredFactionStanding = 0 WHERE `entry` BETWEEN '1' and '40000';
UPDATE `items` SET buyprice = 0 WHERE `entry` BETWEEN '1' and '40000';
UPDATE `items` SET sellprice = 1 WHERE `entry` BETWEEN '1' and '40000';

***TraPStaR*** · 01-09-2008

here i'll make it noob simplified

Code:

UPDATE `items` SET ItemExtendedCost = 0;
UPDATE `items` SET ArenaRankRequirement = 0;
UPDATE `items` SET RequiredFaction = 0;
UPDATE `items` SET RequiredFactionStanding = 0;
UPDATE `items` SET buyprice = 0;
UPDATE `items` SET sellprice = 1;

this does them all no mater what

**Xeneth** · 01-19-2008

Bump, I've seen some people Posting about how to add/remove costs and whatnot, Figured this would be useful. In my honest opinion i think this little guide got under rated. Not saying that because it's my work, and I "just want rep" I tend to step outside myself and judge myself.

I over think and over say everything haha, Sorry