[Tegila]

i jsut went thorugh and worked this out to adjust the prices of all my defiant etc stuff, im jsut wondering if i did it right (i popped in terror infused for all classes bc extravagant consigned sucks and more things to alter, and the disadvantage to terror infused is it's all/all thus not very wel lspecialized even into archetype, but then i left the extravagant side pieces in and put no weapons, to make it less a gimme) i have the stuff already on merchant but prices were all over the place i saw.

'use peq'

UPDATE items SET cost = 2000 WHERE name LIKE 'Crude Defiant%';
UPDATE items SET cost = 7000 WHERE name LIKE 'Simple Defiant%';
UPDATE items SET cost = 15000 WHERE name LIKE 'Rough Defiant%';
UPDATE items SET cost = 50000 WHERE name LIKE 'Ornate Defiant%';
UPDATE items SET cost = 150000 WHERE name LIKE 'Flawed Defiant%';
UPDATE items SET cost = 500000 WHERE name LIKE 'Intricate Defiant%';
UPDATE items SET cost = 1500000 WHERE name LIKE 'Elaborate Defiant%';
UPDATE items SET cost = 5000000 WHERE name LIKE 'Elegant Defiant%';
UPDATE items SET cost = 15000000 WHERE name LIKE 'Terror Infused%';

UPDATE items SET cost = 2000 WHERE name LIKE 'Crude Adept%';
UPDATE items SET cost = 7000 WHERE name LIKE 'Simple Adept%';
UPDATE items SET cost = 15000 WHERE name LIKE 'Rough Adept%';
UPDATE items SET cost = 50000 WHERE name LIKE 'Ornate Adept%';
UPDATE items SET cost = 150000 WHERE name LIKE 'Flawed Adept%';
UPDATE items SET cost = 500000 WHERE name LIKE 'Intricate Adept%';
UPDATE items SET cost = 1500000 WHERE name LIKE 'Elaborate Adept%';
UPDATE items SET cost = 5000000 WHERE name LIKE 'Elegant Adept%';
UPDATE items SET cost = 15000000 WHERE name LIKE 'Extravagant Adept%';

UPDATE items SET cost = 2000 WHERE name LIKE 'Crude Combatant%';
UPDATE items SET cost = 7000 WHERE name LIKE 'Simple Combatant%';
UPDATE items SET cost = 15000 WHERE name LIKE 'Rough Combatant%';
UPDATE items SET cost = 50000 WHERE name LIKE 'Ornate Combatant%';
UPDATE items SET cost = 150000 WHERE name LIKE 'Flawed Combatant%';
UPDATE items SET cost = 500000 WHERE name LIKE 'Intricate Combatant%';
UPDATE items SET cost = 1500000 WHERE name LIKE 'Elaborate Combatant%';
UPDATE items SET cost = 5000000 WHERE name LIKE 'Elegant Combatant%';
UPDATE items SET cost = 15000000 WHERE name LIKE 'Extravagant Combatant%';

UPDATE items SET cost = 2000 WHERE name LIKE 'Crude Summoner%';
UPDATE items SET cost = 7000 WHERE name LIKE 'Simple Summoner%';
UPDATE items SET cost = 15000 WHERE name LIKE 'Rough Summoner%';
UPDATE items SET cost = 50000 WHERE name LIKE 'Ornate Summoner%';
UPDATE items SET cost = 150000 WHERE name LIKE 'Flawed Summoner%';
UPDATE items SET cost = 500000 WHERE name LIKE 'Intricate Summoner%';
UPDATE items SET cost = 1500000 WHERE name LIKE 'Elaborate Summoner%';
UPDATE items SET cost = 5000000 WHERE name LIKE 'Elegant Summoner%';
UPDATE items SET cost = 15000000 WHERE name LIKE 'Extravagant Summoner%';

if that looks right, awesome. if not ill see if i can modify what you put up. i didnt read through it, i found another thread detailing putting up new merchants without an editor. but, this being first code im putting together with just the pieces, not substitution from a copy n paste job, and it affects a lot of stuff, id like a second opinion before i put it through to the db

edit: looking at that and the stats i think ill lower the extravagant stuff some, its nowhere near the stats of terror of course. i mostly tripled and rounded up to next round 5 somethign number after the first 3 tiers, i thought tripling 7 to 21 was both a little steep (at the early part of that gear) and messy for my end pricing goals lol edit2: yeah went up on the terror to 20k and down on extravagant to 10k, thats still steep for the extravagant, but this isnt a server where everyone is giving it away, and i think im going to remove it all from teh drop table, so that its not a luck thing to get, but a work thing (farm the plat on a mostly empty server) for the level etc.

that means i need to use the script linked before to remove what defiants might be active in loottables too now, or would i jsut do somethign like

DELETE * FROM `lootdrop` WHERE `name` LIKE 'GLB-%';

being that the items are still on teh items table of course, would that work? or wrong wording?

Edit PRICE not cost lol