Some SQL Query's for small population servers.
I was reading in another thread how someone was wanting a SQL Query to run on their server to Adjust Mob hps and dmg output.
Well I'll share what I use on my server for those that want to adjust it and use it as they see fit. Remember to BACKUP before making any adjustments (good habit to get into). For Mob HP's I use the following Query: It uses a base hp formula then adjusts it from there based on the mobs Bodytype (Nastier mobs will have more hps IE Dragons, Giants, Avatars etc). Code:
#HP Adjustment based on level, bodytype, fabled and bonus hps Ok on to damage: I looked at the avg dmg min & max dmg for each level and it was a very simple design. Max dmg is based on the mobs level x2 till around 40th then its x3 then it goes up from there. Granted some mobs hit alot harder than others for their level (Hill Giants come to mind). After looking over the data, I decided I wanted a smoother line of progression than what they had so I used this: Again it uses a base line for min/max dmg then I moded it further by npc bodytype and at the end if its a fabled mob. Code:
update npc_types set mindmg= 1 ,maxdmg = 1 where id > 999 and level = 0; I was tired of the simple store bought Plate/Chain mail items being grossly over priced so I came up with this to adjust not only the simple items but also the more powerful magical items as well. In simple terms it most of the attributes of an item and put a number number on it. Based on that number and other factors it will come up with a price for said item and when its done it will set minstatus back to 0. It should not effect not wearable items like spells, crafting supplies, gems etc but it did effect the food items with stats: Code:
update items set minstatus = aagi + ac + accuracy + acha + adex + aint + asta + astr + attack + avoidance + awis + banedmgamt + banedmgraceamt + extradmgamt + damage*3 + damageshield + elemdmgamt + haste*3 + hp + regen + mana + manaregen + enduranceregen + spellshield + strikethrough; Code:
#Potion Casting Time Fix Anyways just wanted to share some of the SQL Query's I've used on my little server. Feel free to adjust them how you like, just remember to make regular backups before making any adjustments (good habit to get into!) |
Wow. Just, wow. :shock:
I'll be giving these a run when I get a moment. Thanks so much for putting these up! :D Awesome, awesome stuff! |
More than welcome. Love the custom load screens you done up so when I saw you asking someone about a query you found for Wow Servers, I figured why not post what I had? They are easy to adjust, just do some simple math and see what you come out with.
The funny thing is, I started out doing a Lineage II EMU server years ago and came up with a simple query formula for hps based on level. So I've tweaked this over the years to suit whatever EMU I'm working on :) Anyways here's an Example of before and after the Query's Lord Nagafen: before: 33,349 hps Damage: 140 to 300 pts after: 10,796 hps Damage: 83 to 273 pts Granted some mobs will have more hps or do more damage (or both in some cases) than what they had listed before. That is where you can go in and tweak the formula then rerun the Query. ATM My giants are MEAN. They are GIANTS. They have more hit points than the normal giants did in game. Example: 35th level hill giant before: 1575 hps Damage 14 to 70pts after: 2809 hps Damage 26 to 106pts Want to tone the giants down? Just change the Adjustment on the bodytype: Code:
update npc_types set hp = 1.75*hp where id > 999 and bodytype = 4; Sorry I didn't add comments on the Body types to make it easier to know which is what (seems I did on the dmg query though :) ) |
Merc Quest Script
We have bots enabled on my server so I've modified the Bot quest to fit our needs. Removed the item requirements and changed up the level range and coin cost and of course added saylinks :)
I've also added a Bot Command Quest script to the bots on my server. You can read more on that topic here Modified Congdar's Aediles_Thrall.pl quest Code:
############################################ |
Whoa! They just keep rolling in! I'm really surprised no one else has commented on this.
Well, you have my thanks, that's for sure. :D |
I messed up lol
So what would be the easiest way to undo doing this (obv without just restoring the backup).
Quote:
|
All times are GMT -4. The time now is 01:35 AM. |
Powered by vBulletin®, Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.