A mean, hungry Norrath - Faction Update
I've decided to make Norrath a mean place for my players. Most animals, insects, undead, and giants con KoS. With the help of Govtcheese and Rangerdown I wrote the following simple queries to change the faction of animals, insects, and undead to KoS. There are a few exceptions and more can be added easily by modifying the query. I've added other sql that i've written for my server. I remind you my server is not an easy one, so the code is written to make life a little tough in Norrath.
1. KoS animals, undead, insects, and giants: Code:
DELETE FROM npc_faction USING npc_types RIGHT JOIN npc_faction ON npc_types.npc_faction_id = npc_faction.id WHERE npc_types.race <> 216 And npc_types.race <> 42 And npc_types.race <> 188 And npc_types.race <> 189 AND npc_types.bodytype = 21 Or npc_types.bodytype=4 or npc_types.bodytype=3 or npc_types.bodytype=22; Code:
UPDATE items SET nodrop=0 WHERE magic=1; Code:
DELETE FROM merchantlist USING merchantlist, items WHERE merchantlist.item=items.id AND items.magic=1; Code:
UPDATE faction_list SET base=base * 4 WHERE base < 0; Code:
UPDATE npc_faction_entries SET value = value * 12; Code:
UPDATE npc_types SET AC=(((level*level)/1.1)+15) where AC=0; I will be releasing more KoS updates for the higher end mobs in the next few weeks. If there are questions, feel free to post on this forum. The AC line was compiled from another user, with a small mod. Thanks! derf |
Keep up the great work. I will be adding the faction updates to my script.
For anyone doing faction updates, PLEASE use SQL commands like above so everyone can update their DBs. |
Quote:
Code:
UPDATE faction_list SET base=base * 4 WHERE base < 0; Code:
UPDATE faction_list SET base=base - (base * 4); |
Quote:
|
All times are GMT -4. The time now is 08:13 AM. |
Powered by vBulletin®, Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.