Going solo - suggestions for where to start?

[GeorgeS]

Another possibility is to vary the equation by factoring into it a bit of randomness -


UPDATE npc_types SET hp=FLOOR(-5 + (25 * level) + 1.12 * (level ^ 2)+RAND()*level*2) WHERE level<50;

This add's a slight variance by level

GeorgeS

[John Adams]

GeorgeS, you are truly brilliant. I had never really considered doing the math in the SQL statements themselves... could save me hours of script writing. Hehe!

[Rhodan]

Are the NPCs really all that similar? I had thought they would have been a lot different - making en-mass changes like that impractical.

I'll have to dig into the NPC tables and have a look - so far I was just looking at zones and some scripting.

I really wish I could buff my GTW resist up to 200+...


(GTW= go to work).

[paaco]

man George you are rediculous with MySQL. I would never even attempt to come up with something like that or all the mobs on my server would be messed up lol :(

[Rhodan]

Originally Posted by paaco

man George you are rediculous with MySQL. I would never even attempt to come up with something like that or all the mobs on my server would be messed up lol :(

Thats where making a copy of the DB to practice on comes in handy

[GeorgeS]

To make a quick backup, copy the npc_types files (.frm .MYD , .MYI)These are found in C:\mysql\data\

GeorgeS

[Rhodan]

Well, its turning out that editing the NPCs really is a viable option and probably the more practicle thing to do. Thanks to folks here and on Cavedude's site (search is handy!) I've gotten lots of ideas how to modify mobs etc to tone them down.

What I haven't found yet is an easy way to increase health and mana regeneration rates for players. I do have an idea though!

This version of EQ (Titanium) supports charms and augs and I'm hoping EQEmu does as well. In Live, you get a kobold charm for completing the newbie zone quests. I'm thinking I could add this charm (which turns out to be one of the better ones in end game) that comes fitted with flowing thought and regeneration augs. THese would be removable so you could transfer them to a new charm if you choose to change later on. Of course they would be no-drop so you couldn't make 8 characters and get 8 augs all packed into one charm

I saw an item creation tutorial around here someplace. I'll have to go looking again.