1.1 final DB addon, plus 4.4dr1 files, items DB, etc

Drawde · #1 05-19-2003, 12:17 AM

http://edwardpinniger.bctalk.net/eq/worlddata1.1.zip

New features in this version (since 1.1beta)
- Fixed zones (fixed NPC locations, added loot tables and missing NPCS):
Chardok, Dalnir, Sebilis, Kurn's Tower, Cazic-Thule, Befallen, Najena, Ocean of Tears
- NPC spell lists for all classes
- Adjusted damage formula for NPCs (should be more accurate now, once the new AC/mitigation code is in)
- Reduced mana regeneration for NPCs
- More or less complete loot tables for old-world and Kunark creatures (many NPCs, especially quest-related
ones, still don't have the correct loot)
- Nearly complete merchant lists (including spell vendor lists for all classes and level ranges, at last..)
- A few more tradeskill recipes
- Tradeskill objects (forges, looms etc.) in towns (note: with the current EQEmu code, using these will put a copy of
them in your inventory, rather than opening them directly; this is a code issue, not a DB issue!)

Things that I'll (hopefully) include in future versions:
- Fix Timorous Deep, Skyfire Mtns, Kithicor (undead), Mistmoore, Runnyeye, Kedge Keep
- Velious and Luclin zones
- Special abilities and spells for NPC races (dragon roar/charm, ghoul root, spider/snake poison, etc.)
- Complete faction list
- Faction increases for killing orcs, gnolls, goblins etc (the code for this is in EQNPC, I just haven't tested it yet)
- Working boats
- Visible equipment for guards and NPCs (partly working ATM)
- More tradeskill recipes
- Spell research (including research item loot drops) - working on this ATM but it isn't functional in this release version
- Spell loot drops
- Ground spawn objects for quests

For DB installation instructions read the readme.txt in the world data zip.

To run this DB you need the EQEmu 4.4dr1 binaries and DB format (many DB changes since 4.3), all these files can be downloaded in
this zip - http://edwardpinniger.bctalk.net/eq/44dr1.zip . It contains both a blank db.sql if you don't already have an EQEmu DB,
and an upgrade .sql file if you already have an 0.4.3 DB , as well as the world, zone and minilogin server .exes.

If you don't already have item/book data in your DB, download http://edwardpinniger.bctalk.net/eq/itemsbooks.zip and
source the files in the zip (items.sql, books.sql) in with MySQL.

I've also updated my "EQNPC" parser program (generates MySQL data for EQEmu from a text list of NPCs), it can be downloaded
from http://edwardpinniger.bctalk.net/eq/eqnpc.zip . Earlier versions won't work with 4.4dr1.

jbb · #2 05-19-2003, 02:30 AM

Looks like you've put a great deal of effort into this and it's looking good!

I downloaded it and tried it out. I had quite a few problems loading the database due to problems in the sql but found a way to fix most of them.

I created an enchanter in felwithe and found with amusement that all the guards and npcs in felwithe buff and heal me when I walk past them! Interesting faction side effect I guess. But fun.
[ I should add that I modifed some of the code slightly so it's possible that last part wouldn't happen in an offical copy]

Trumpcard · #3 05-19-2003, 03:15 AM

Yea, there are a few bugs we need to work out..

One is the agro/faction bug, the other is npc's buffing you. I kind of like the idea, but should make it configurable.. no more begging for sow, just stand next to a friendly shaman long enough.

ALTRUSTIC_NPCS (0/1)

Also, theres some bugs in the purchase code related to amounts when you buy/sell.

Any code fixes you guys have, make sure to post them. The dev team has been really slow lately, we're all suffering from 'GOSTD' syndrome.. (Got other shit to do)

Once again Drawde, awesome work, I can't wait to try it out !

a_Guest03 · #4 05-19-2003, 04:10 AM

Congrats, Drawde! Mitigation is making progress, and I know NPC equations should be close to accurate. I might require that you adjust ATK ratings for mobs when the PC damage mitigation is done, but I think you can understand the basic formula enough from my posts to fudge it closely today.

Drawde · #5 05-19-2003, 04:36 AM

Currently the damage formula is 3+(2*level) with increases to the level multiplier for higher-level mobs. Originally it was 2.7*level but I reduced it to allow for the STR damage adjustment for NPCs, which will be added to EQEmu fairly soon I think (from what I've read).

Buffing NPCs wouldn't be a bad feature, providing the buffs they cast weren't totally out of your level range. Something like SoW or a strength buff isn't too unbalancing for a low-level character, but Aegolism or something is ridiculous - the HP boost is around 20x your base hitpoints at level 3-4.
They're already thinking of adding a level restriction for player-cast buffs on EQLive, so level-1 players can't get KEI and Aegolism to effectively get the HPs and mana pool of a 30+ character..

Apart from the faction and merchant issue, another bug/problem I noticed was with quest scripts. The buffer for scripts seems to be smaller than in earlier versions, and if an EVENT_x block in a script is too long, it actually crashes the server, rather than just not working.

Velosity · #6 05-19-2003, 01:47 PM

That would help people level if they are on a legit server, and would reduce the begging from noobs for buffs . . . id stand next to a cleric though lol, maybe they heal too

Bigpull · #7 05-19-2003, 03:33 PM

There is a boat system in place in cvs just need pathing for all the boats.

The buffs are a faction issue, and live has had level limits for quite awhile and exploits around them for just as long.

bpogue99 · #8 05-19-2003, 03:58 PM

Awesome work Drawde, spectacular release!

Velosity · #9 05-19-2003, 04:31 PM

I got everything working with Drawdes new db and stuff, the buffing if your sitting there chatting can get quite annoying, yet ive gotten skin like diamond and a bunch of strs, dexes and agis, along with all resist buffs lol

But overall Great work Drawde

One problem im having on my server ive noticed alot of servers have a problem with is the #zone command, set the status too low and it tells the user Your status is not high enough to use this command, yet i set defaultstatus=20 in my loginserver.ini and bam, it tells everyone (but me since im server op) that the command doesnt exist . . . . . . . ive also tried changing the !zone in addon.ini to 0 and 10, still no luck. Any suggestions?

IAboracorba · #10 05-20-2003, 03:59 AM

error 1136: Columm count doesn

a_Guest03 · #11 05-20-2003, 07:33 AM

Bora, these files are for the 4.4DR version of eqemu. That's a direct release, which is different than a downloaded and installed sort of release.

Guys, correct me if I'm wrong, but I think the DR versions are available by using cvs. The "official", supported version of eqemu that handles this is not yet available. Drawde is just preparing for the most current version of eqemu. The files will work if you obtain 4.4DR by cvs and use that version instead.

eqemu 4.3 will give errors when you try to load this, because the database for 4.3 and 4.4DR are different. There is no workaround, because they are version incompatible. Drawde may release a version that is designed for 4.3, but I wouldn't pressure him for it. His work on 4.4 is much appreciated, and highly anticipated.

Trumpcard · #12 05-20-2003, 08:24 AM

Thats true. I send Drawde compiled binaries straight from CVS for him to test with, I doubt it's backwards compatible with anything. A better option might be for someone to make a site and start compiling weekly cvs builds of the code. It looks like official builds might not be happening much anymore.

Arastiroth · #13 05-24-2003, 08:16 PM

Quote:

Originally Posted by a_Guest03

Bora, these files are for the 4.4DR version of eqemu. That's a direct release, which is different than a downloaded and installed sort of release.

Guys, correct me if I'm wrong, but I think the DR versions are available by using cvs. The "official", supported version of eqemu that handles this is not yet available. Drawde is just preparing for the most current version of eqemu. The files will work if you obtain 4.4DR by cvs and use that version instead.

eqemu 4.3 will give errors when you try to load this, because the database for 4.3 and 4.4DR are different. There is no workaround, because they are version incompatible. Drawde may release a version that is designed for 4.3, but I wouldn't pressure him for it. His work on 4.4 is much appreciated, and highly anticipated.

Ok, if you need to download the CVS version of EQemu how does someone do that? I went to the Sourceforge and looked around, but I'm not sure what I need/need to do. I download the files and use Drawde's DB and then source in the required files and get tons of errors (as said above). If having the CVS build of Eqemu fixes that then it would be nice to know how to go about doing that? Any comments are appreciated. I'm not a complete newbie in this, but it's still a little bit confusing to the point where I rather ask then guess.

Thanks for any help and for your time.

baba_booey · #14 05-25-2003, 09:29 AM

I got the database working, very nice work Drawde. The way I did it may or may not be correct, I probably did a worthless step or 2, npc's may have the wrong items and spells, but for the most part it seems to work. Here is how I did it.

Source the db.sql from http://edwardpinniger.bctalk.net/eq/44dr1.zip then source the update44dr1.sql from that same zip. Then source the db.sql again (sounds silly but it worked...) then source Drawde's reloaddb.sql. Source books.sql, and then items...the items.sql in http://edwardpinniger.bctalk.net/eq/itemsbooks.zip didn't work for me, so I used an older files items_44dr1.txt that I think came with the last beta of Drawde's database, but I'm not sure.
I'm sure doing it this way will make a few strange errors, but hey, it works for someone that can't use the cvs.

bpogue99 · #15 05-25-2003, 06:05 PM

Hey Drawde,

I rebuilt my server from scratch tonight using your latest db, exe link, books/items. Will sourcing in the npcmov_alpha from tcs break this setup in some manner?

Thanks!

bill