- Joined
- Dec 28, 2006
- Messages
- 130
- Reaction score
- 0
What was the line to make all items free? Thanks!
UPDATE items SET buyprice = 0;
UPDATE items SET sellprice = 1 WHERE buyprice = '0' AND sellprice > '0';
UPDATE items SET itemextendedcost = 0;
to remove some of the items limitations I would do the following
first set all items gold costs to 0:
than the sellable items (buyprice larger 0) should cost only 1 copper, so you can sell them to the npc but they don't bring much money so that you can't cheat:Code:UPDATE items SET buyprice = 0;
than the extended costs at all prizeless items should be removed too:Code:UPDATE items SET sellprice = 1 WHERE buyprice = '0' AND sellprice > '0';
you can also change lots of other values like required skill in the same way.Code:UPDATE items SET itemextendedcost = 0;
hopes this helps