channel_49
06-16-2007, 09:42 PM
1) Since there are a lot of bugged quests (example level 1 quests that give 90+ silver), what I did is make a scale for quests as a temporary fix for quest rewards till the quests can all be individually fixed.
What the query does is make level 1 quests that is suppose to give money give 30 copper, and increase as the quest level goes up, and same for xp. The problem is that quests that are suppose to give more or less will be giving the same amount. Although I made sure that quests that are suppose to give no xp will give no xp, and same for money.
This also fixes quests that give 10000 copies of an item as a reward because someone put the itemID as the item count...
2) I also extracted from the dbc the 2.1.1 (6739) build faction ID list and skills ID list since all the ones I could find for dl are out of date.
The other lists are a little bit big to clean up, so I'm trying another method to clean them up before I release them.
What the query does is make level 1 quests that is suppose to give money give 30 copper, and increase as the quest level goes up, and same for xp. The problem is that quests that are suppose to give more or less will be giving the same amount. Although I made sure that quests that are suppose to give no xp will give no xp, and same for money.
This also fixes quests that give 10000 copies of an item as a reward because someone put the itemID as the item count...
2) I also extracted from the dbc the 2.1.1 (6739) build faction ID list and skills ID list since all the ones I could find for dl are out of date.
The other lists are a little bit big to clean up, so I'm trying another method to clean them up before I release them.