MW_052_053_alpha2 (released 12-21-03)

[JerryChen]

I just update the sql files, but it has error 1017.

So i look the World.EXe status, i found a problem:Wrong name/pass: name='eqemu'

then i open mysql and run this command

INSERT INTO account SET name='eqemu', password='eqemu', status=200;


Now it's working

[cybermax]

Originally Posted by Scorpious2k

I wrote a conversion program for Scorpious2k Server Interested?

You could post one on the 3rd party forum indeed... I am in no rush tho, cos its just a private server for me and the kid i have like 6 characters, so i just remade them and summoned the gear again.. But i imagine it would be more peeps than me that would be interested tho

[rockocool]

Scorpious2K, could you please post this program? either here or in 3rd PT? thanks!

Originally Posted by Scorpious2k

I wrote a conversion program for Scorpious2k Server Interested?

I wasn't sure anyone but Conan at BrightBlade was looking for anything like this... maybe I should put a topic in 3rd PT...

[Scorpious2k]

Posted:
http://www.eqemulator.net/forums/viewtopic.php?t=12165

[mollymillions]

There are a lot of duplicated spawns in the DB, they may be intentional but I wanted to get rid of them. e.g.

SELECT zone, x, y, z, left(npc_types.name,32) AS Name, count(spawn2.id) AS SpawnCount
FROM spawn2, spawnentry, npc_types
WHERE spawn2.spawngroupID = spawnentry.spawngroupID
AND spawnentry.npcID = npc_types.ID
AND spawn2.pathgrid = 0
GROUP by zone, x, y, z, npc_types.name
HAVING SpawnCount > 1
ORDER BY zone, x, y, z, npc_types.name

Here's a query to construct a query to delete the last spawn added for each replicated spawn (i didn

[Kroeg]

is this query built to delete anything other than the duplicate spawns? If so, hold off.. the My World team is tackling this problem (and has been for a few days) already.

When we merged data from another worldbuilder's sources, the transition wasn't entirely seemless =P but we're cleaning it up now. The id #s for the duplicate npcs are far too high, and contain strange lootdrop entries. Next DB release should contain a fix to this problem, but don't quote me. Sometimes we release the DBs before they're ready just to satisfy worldbuilders and serverops.. although I'm pretty sure this is the basis of our next release

Mollymillions -- We (MW DB Team) need you on our team.. check out #npcmovdb (and stay longer than 5 minutes, hehe.).

[grues0me]

I loaded this database up and have a problem:

One thing is that the guards don assist me when i flee to them from a fight. I realized the diconnects after dying too.

Second - are the trainers in? Do i have to source a different quest.sql in or are basic quests already in?

[farce]

Quests arent part of the db.

dunno about guards assisting.. they dont even attack a mob that is set to spawn 2 inches from them.

Disconnect on death is a known issue,and fixed for future releases.

One thing is that the guards don assist me when i flee to them from a fight.

thats done with factions in the DB

[grues0me]

I see. How about the trainers...i hail them and they wont reply...is this a prob with my setup or can someone confirm that its not working...

what happens when you right click on them? and are you running
the newest DB with the NPCID fixxes in it?

[Shawn319]

[quote=mollymillions]There are a lot of duplicated spawns in the DB, they may be intentional but I wanted to get rid of them. e.g.

SELECT zone, x, y, z, left(npc_types.name,32) AS Name, count(spawn2.id) AS SpawnCount
FROM spawn2, spawnentry, npc_types
WHERE spawn2.spawngroupID = spawnentry.spawngroupID
AND spawnentry.npcID = npc_types.ID
AND spawn2.pathgrid = 0
GROUP by zone, x, y, z, npc_types.name
HAVING SpawnCount > 1
ORDER BY zone, x, y, z, npc_types.name

Here's a query to construct a query to delete the last spawn added for each replicated spawn (i didn

[grues0me]

Originally Posted by mattmeck

what happens when you right click on them? and are you running
the newest DB with the NPCID fixxes in it?

I am using live eq with Emu5.3Dr2 and mw_052_053_alpha2.

Right clicking opens a merchant window with no items in it.

The fix...i am not sure which you mean, but if you meant the classfix.sql...i gonna try it now.

I "think" thats what you need, with the last SOE patch they changed the class ID #'s, so it through everything off.

[grues0me]

Thanks that fix did it. My only problems now are now:

1. Health bars of the mob never decrease. I copied the fix i found on the board into the mob.cpp, no help.

2. The crash-on-dying bug. I realize it must have to do with the 400 damage some mob do, but i didnt found a fix on the board, except the global change of the max damage via sql commands.