*NEW* Improved, moving DB for 050 DR5(updated 11/13)

tcsmyworld · #1 11-03-2003, 10:40 AM

This is my most recent 044 moving DB converted to 050 DR5 format.

*NEW*- Working zone points , Class GM's corrected.
Works with CVS

http://tcstoys.sytes.net/MWnpcmovDB_050_alpha0_3_3.zip

Working vendors , most items priced correctly.
Faction working.
NPC's have loot.

Hope you all enjoy it

Go to websites progress page to see what zones move.

Note: has a few small glitches that i will be working on over the next few days , but it is playable as is.

Kroeg · #2 11-03-2003, 11:15 AM

Man, this is awesome. Thanks for all of your fine work, that lead me to run a server as it was!

Can this be sourced into an exhisting database, or is this an entire db in itself?

If this is an entire db, can we just source in the grid tables and possibly keep our current database?

Edgar1898 · #3 11-03-2003, 12:24 PM

Yo, before too many of you start complaining, the inventory table listed in this db is off. It SHOULD be:

mysql> describe inventory;
+---------+-----------------------+------+-----+---------+-------+
| Field | Type | Null | Key | Default | Extra |
+---------+-----------------------+------+-----+---------+-------+
| charid | int(10) unsigned | YES | | 0 | |
| slotid | smallint(6) unsigned | YES | MUL | 0 | |
| itemid | mediumint(7) unsigned | YES | | 0 | |
| charges | tinyint(3) unsigned | YES | | 0 | |
+---------+-----------------------+------+-----+---------+-------+
4 rows in set (0.00 sec)

Using the wrong inventory table will give you all kinds of errors. Its not a code problem, just this db problem.

tcsmyworld · #4 11-05-2003, 02:03 PM

Sorry about inventory table, thanks for the heads-up Edgar1898, uploading fixed version now.

As for sourcing this into another DB Kroeg , this is a stand-alone DB , complete with spawns, loot, vendors, and movement in about 25 or so zones.
It is based on Drawdes last DB release , so if you are using his npc and spawn tables the spawn2 and grid tables may work for you.

Kroeg · #5 11-06-2003, 01:00 AM

cool, thanks for your time =]

Kroeg · #6 11-07-2003, 02:12 AM

tcs... sorry to overbug if i do, but have you noticed a bug where players lose all their loot upon zoning? This I have noticed happening with MWnpcmovDB alpha 3 and dr5. World actually reported an error having to do with "AddLootdropToNpc"
and referred to nothing else. What would you recommend taking a look at to fix the item saving bug?

The verbose error output is as follows:
The bug was recreated successfully everytime upon zoning and firstlogin;

[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.0
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading npcs
[Status] Loading npc faction lists
[Status] Loading loot tables
[Status] Loading doors
[Status] Loading guilds
[Status] Loading factions
[Status] Loading corpse timers
[Status] Loading what ever is left
[CommandLevels] block not found in ADDON.INI.
[Status] Loading commands
[Status] 148 commands loaded
[Status] Entering sleep mode
Connected to worldserver: 12.240.246.52:9000
[Status] Weather should change in 5494 seconds
Init: Loading zone lists, zone state or spawn list, player corpsesZonepoints loa
ded into memory
Parser::ClearCache
, timezone data - Done. ZoneID = 19; Time Offset = 0
Reading zhdr file './cfg/rivervale.cfg'
Using database for safe coords.
Zone safe coords are x = 0; y = 0; z= 4
Reading zhdr file './cfg/rivervale.cfg'
Using database for safe coords.
Zone safe coords are x = 0; y = 0; z= 4
Using default zone header data...
Converting old zone data...
[Status] Loading Objects from DB...
[Status] Loading doors for rivervale ...
[Status] Done loading doors for rivervale ...
Petition 0 pettime = 0
[Status] Zone Bootup: rivervale (19)
Received Message SyncWorldTime
Time Broadcast Packet: EQTime [05:04 am]
[Status] 66606 New client from ip:12.240.246.52 port:3781
[Error] Warning: Invalid PlayerAA_Struct size found in database
[Error] HandlePacket() Opcode error: Unexpected packet during CLIENT_CONNECTING:
opcode: 0x0081, size: 0
[Error] SaveInventory query 'REPLACE INTO inventory VALUES(1,30,20490,1)': #1136
: Column count doesn't match value count at row 1
[Error] SaveInventory query 'REPLACE INTO inventory VALUES(1,13,20490,1)': #1136: Column count doesn't match value count at row 1
Unknown SpawnAppearance type: 0x0005 value: 0x0000000f
Zoning to safe coords: misty (33)
[Status] Zoning 'Kroeg' to: misty (33) x=0, y=-1063512064, z=0
Flushing Queue!
Queue Flushed!
Client disconnected (cs=d): Kroeg
Dropping client: Process=false, ip=12.240.246.52, port=3781
Automatic shutdown
[Status] Zone Shutdown: rivervale (19)

Kroeg · #7 11-07-2003, 03:26 AM

excuse so many posts in so little time. I have fixed this error... it seems that the line "color" in "inventory" causes this error. i don't know enough about sql to know why, I just know that removing the line "color" from table "inventory" solved this, and now players keep their items upon zoning.

tcsmyworld · #8 11-07-2003, 03:40 AM

The inventory table has been fixed , and the fixed DB was uploaded to replace the bad one. (D/L now has corrected version)

Kroeg · #9 11-07-2003, 03:55 AM

that was happening with the most recent downloaded version of the moving db. (I downloaded a fresh copy lastnight while I was trying to debug the problem)

cybermax · #10 11-10-2003, 12:42 AM

Tested this DB with the todays CVS version (4 hours ago or so), but it seems there are fewer zones working than crashing..

Can you verify that every "startzone" works with this DB release and the current CVS TCS?

tcsmyworld · #11 11-10-2003, 02:16 AM

There seems to be a crash bug in public CVS , fix should be out in next CVS push.

Conan · #12 11-11-2003, 01:22 AM

[Status] CURRENT_ZONE_VERSION: EQEMu 0.5.0
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading npcs
[Status] Loading NPCTypes from database...
[Status] Loading npc faction lists
[Status] Loading NPC Faction Lists from database...
[Status] Loading loot tables
[Status] Loading Loot tables from database...
[Status] Loading doors
[Status] Loading Doors from database...
[Status] FileLoadSPDat() Loading spells from spells_us.txt
[Status] FileLoadSPDat() spells loaded: 4352
[Status] Loading guilds
[Status] Loading factions
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] 148 commands loaded
[Status] Weather should change in 12576 seconds
Init: Loading zone lists, zone state or spawn list, player corpsesZonepoints loa
ded into memory
Parser::ClearCache
, timezone data - Done. ZoneID = 54; Time Offset = 0
Couldn't find/read ./cfg/gfaydark.cfg. (returning -1)
Couldn't find/read ./cfg/gfaydark.cfg. (returning -1)
Corrupt (or nonexistant) zhdr file ./cfg/gfaydark.cfg -- fread count = -1 (shoul
d be 214)
Using default zone header data...
[Status] Loading Objects from DB...
[Status] Loading doors for gfaydark ...
[Status] Done loading doors for gfaydark ...
Petition 0 pettime = 0
[Status] Zone Bootup: gfaydark (54)
Connected to worldserver: 192.168.1.7:9000
Error in AddLootDropToNPC: dbitem=0, item#=9099, lootdrop_id=315
Error in AddLootDropToNPC: dbitem=0, item#=9099, lootdrop_id=315

I just source in this db this morning and upon loading a zone I get this error tcsy, DB problem? Its nothing big but Would like to get as little erros as posible. Thanks

Conan

cybermax · #13 11-11-2003, 01:50 AM

Just downloaded todays CVS, and recompiled.. Still zone.exe crashing upon zoning to startzone on most character races.. (WestFreeport, Cabilis West..++)

Dunno if todays update was just minor fixes, and that something larger will come.. Or if its the database that has become corrupted somehow..

tcsmyworld · #14 11-11-2003, 08:16 AM

I reverted back to CVS from a few days ago , it doesn't crash on zoning.
As for these=
Error in AddLootDropToNPC: dbitem=0, item#=9099, lootdrop_id=315
Error in AddLootDropToNPC: dbitem=0, item#=9099, lootdrop_id=315
They are leftovers from my original items DB , I'm working on getting them all cleaned up.
They have no affect on the server , other than not adding a few loot items to spawns.

There is another crash bug that seems to be related to faction/aggro , causes crash when an npc assists you.

Remember that the Binaries are Dev Release , and as such , not perfect yet , the DB is also an "alpha" version , meaning that it needs to be tested and tweaked yet, it's far from being a finished product.

rubyrhinosaur · #15 11-12-2003, 01:12 AM

lets get that team up so we can finish the db lol