PDA

View Full Version : Where are all the NPCs and doors?


shanen98
11-11-2004, 04:38 PM
I have almost successfully set up a server. I can login to it but there are no NPCs or doors. What files do I need to source to get these. Also there is a lot of confusion of which sql files need to be sourced with which version of the database... A list would be nice.

Thanks in advance,

Shane

Sarepean
11-12-2004, 01:10 AM
What version are you using???

-Sarepean

shanen98
11-12-2004, 05:00 AM
PEQ_Kunark_RC1. Any help would be appreciated.

shanen98
11-12-2004, 07:42 AM
Some more information... I also tried to load the 5.8 classic. And again no NPCs. Got doors this time but they wouldnt open. What am I missing? The line "Error loading NPCs from database. Bad query." from zone.exe repeats itself about a hundred times but I do not know how to fix it.

Here is the output for the zone.exe and world.exe:


Zone.exe output:

[Status] CURRENT_ZONE_VERSION: EQEMu 0.6.0-DR2
[Status] Loading Variables
[Status] Loading zone names
[Status] Loading items
[Status] EMuShareMem loaded
[Status] Loading npcs
[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] FileLoadSPDat() Loading spells from ./spells_us.txt
[Status] FileLoadSPDat() spells loaded: 6299
[Status] Loading guilds
[Status] Loading factions
[Status] Loading AA effects
[Status] Loading swarm spells
[Status] Loading tributes
[Error] Error in LoadTributes first query 'SELECT id,name,descr FROM tributes':
#1146: Table 'eq.tributes' doesn't exist
[Status] Loading corpse timers
[Status] Loading what ever is left
[Status] Loading commands
[Status] 172 commands loaded
[Status] Entering sleep mode
Connected to worldserver: localhost:9000
Map header: 34479 faces, 292 nodes, 47197 facelists
Loaded map: 103437 vertices, 34479 faces
Map BB: (-706.72 -> 1175.53, -899.63 -> 699.72, -307.88 -> 99.97)
Map ./Maps/qeynos.map loaded.
[Status] Weather should change in 394 seconds
Error loading NPCs from database. Bad query.
Init: Loading zone lists, zone state or spawn list, player corpses, traps
, timezone data - Done. ZoneID = 1; Time Offset = 0
Successfully loaded Zone Config.
[Status] Loading Objects from DB...
[Status] Loading Ground Spawns from DB...
[Status] Loading doors for qeynos ...
[Status] Done loading doors for qeynos ...
[Status] Loading AA information...
[Status] Loading Merchant Lists...
[Status] Loading Temporary Merchant Lists...
[Status] Zone Bootup: qeynos (1)
Received Message SyncWorldTime
Time Broadcast Packet: EQTime [05:16 pm]
Error loading NPCs from database. Bad query.
[Snip] The line above repeats itself over 100 times.[/Snip]
[Status] 86766 New client from ip:66.191.152.197 port:2861
Read group ID for 'Mymejuus': 0
[Error] HandlePacket() Opcode error: Unexpected packet during CLIENT_CONNECTING:
opcode: 0x02f5, size: 4
Unexpected packet during CLIENT_CONNECTING: OpCode: 0x02f5, size: 4
0: 48 1F 73 00 | H.s.
Dropping client: Process=false, ip=66.191.152.197, port=2861
[Status] Zone Shutdown: qeynos (1)




World.exe output:

[Status] CURRENT_WORLD_VERSION:EQEMu 0.6.0-DR2
[Status] Loading variables..
[Status] Loading zones..
[Status] Clearing groups..
[Status] Loading items..
[Status] EMuShareMem loaded
[Status] Loading items from database: count=34229
Invalid worldname, please edit LoginServer.ini. Server name must be at least 10
characters.
Invalid worldshortname, please edit LoginServer.ini. Short server name must be
at least 3 characters.
[Status] ./LoginServer.ini read.
[Status] Loading guild ranks..
[Status] Loading ./addon.ini..
[Status] Loading EQ time of day..
[Status] Deleted 0 stale player corpses from database
[Status] Deleted 0 stale player backups from database
Breaking linux compiles....
TCP listening on: 66.191.152.197:9000
World server listening on: 66.191.152.197:9000
Connected to LoginServer: newlogin1.eqemulator.net:5994
25531 New TCP connection: 127.0.0.1:2856
New zoneserver: #1 127.0.0.1:2856
25563 New TCP connection: 127.0.0.1:2857
New zoneserver: #2 127.0.0.1:2857
Zoneserver SetConnectInfo: 127.0.0.1:2856: 66.191.152.197:8781
Zoneserver SetConnectInfo: 127.0.0.1:2857: 66.191.152.197:8780
69828 New client from ip: 66.191.152.197 port: 2859
Logged in: FirstLogin LS#63695: shanen98
Received unknown opcode: 0x02eb size:0 bytes
Read group ID for 'Mymejuus': 0
0: 20 2C 30 2C 20 2E 4D 79 - 6D 65 6A 75 75 73 2C 30 | ,0, .Mymejuus,0
16: 36 37 61 37 39 64 34 00 | 67a79d4.
Attempting autobootup of qeynos (1) for Mymejuus
Zoneserver SetZone: 66.191.152.197:8780 qeynos (1)
Enter world: Mymejuus: qeynos (1)
Broadcasting a world time update
Zoneserver SetZone: 66.191.152.197:8780 qeynos (1)
Received unknown opcode: 0x0376 size:0 bytes
Client disconnected
Removing client from ip:66.191.152.197 port:2859
217094 New client from ip: 66.191.152.197 port: 2863
Logged in: FirstLogin LS#63695: shanen98
Zoneserver SetZone: 66.191.152.197:8780 (0)
Received unknown opcode: 0x02eb size:0 bytes
Received unknown opcode: 0x00ee size:0 bytes
Client disconnected
Removing client from ip:66.191.152.197 port:2863



Again any help would be greatly appreciated.

Shane

phasepuma
11-12-2004, 09:23 AM
http://www.eqemulator.net/forums/viewtopic.php?t=15492

Actually, I didn't do this fix.. I downloaded all the map files, resourced again and - it worked.

go figure.

shanen98
11-12-2004, 11:00 AM
Removed database and started over. Sourced in PEQ_Kunark_RC1.sql from http://projecteq.net/getfiles.php.

Then proceeded to source in merchantlist_temp.sql, doors_update.sql and doorsdata.sql.

I logged in and again no NPCs and doors are still messed up.

I still get errors in the zone.exe that I do not know how to fix:

The relevant errors are:


[Status] Zone Bootup: Qeynos (1)
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.
Error loading NPCs from database. Bad query.


The error loading NPCs from database repeats well over 100 times. And then I get some more errors:


Read group ID for 'Allana': 0
[Error] HandlePacket() Opcode error: Unexpected packet during CLIENT_CONNECTING:
opcode: 0x02f5, size: 4
Unexpected packet during CLIENT_CONNECTING: OpCode: 0x02f5, size: 4
0: 48 1F 73 00 | H.s.
[Error] HandlePacket() Opcode error: Unexpected packet during CLIENT_CONNECTING:
opcode: 0x0355, size: 4
Unexpected packet during CLIENT_CONNECTING: OpCode: 0x0355, size: 4
0: 48 1F 73 00 | H.s.
Dropping client: Process=false, ip=66.191.152.197, port=1463
[Status] Zone Shutdown: qeynos (1)


The world.exe shows a couple of errors:

Received unknown opcode: 0x02eb size:0 bytes
Received unknown opcode: 0x00ee size:0 bytes


I am using the EQEmulator 0.6.0-DR2 downloaded from the Sourceforge site. I also tried using the Perl-precompiled that was provided by someone on the forums.

Are there other sql files I need to source or different version of the World.exe, zone.exe and EMUShareMem.dll?

Again any help is appreciated. Thanks,

Shane