Bug: 5.7 DR4 CVS May 29

[WildcardX]

Hello. I am running a server with the 5.7 DR4 server from the May 29 CVS I downloaded from cvs.biosphere.net. I am using the new TCSWORLD 57alpha1 database with the table update applied from the www.projecteq.com website as well as the sql update included in the CVS zip file that was dated May 20.

When I go to select a character and enter the world, one of my 5 zone.exe processes begins to spam a seemingly neverending "Error loading NPCs from database. Bad Query." My character is never allowed to enter the world.. After a few minutes, the client reports "zone unavailable"

When I compiled my world.exe, zone.exe and emmsharemem.dll i noticed a few errors about the npc_types.h and npc_types.cpp files. After searching the forum here, I found a post that suggested these 2 files are no longer in use and it works to just remove them from the project. So I did so and compiled. Not sure if that contributes to the error or not. I am a c++ programmer, but I am new to the emu code so I havent really looked at this myself.

Anyway, just wanted to let the powers that be know of this, just in case for some reason you dont, but I bet you do

[m0oni9]

Have you read this thread? You might be missing the AC column also.

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

"Error loading NPCs from database. Bad Query." means that the mysql server gave some sort of error when querying from the database. It should probably be changed to not spam you. The way it was changed to work is as follows:

1. On zone boot, all relevant rows from npc_types are loaded from the database. (initial load)
2. If any npc_type is not loaded, and needs to be, load it from database. (load on request)

So you get one error from the initial npc_types load. Then, since no NPCs are loaded, once it tries to spawn them it tries to load them all individually, giving all the spam.

Also, NPC types are no longer in shared memory. Uou should be able to reload NPC types for the current zone by doing a #repop.

[WildcardX]

Very cool.. I ran that script and got an error message back, so I ran the alter table command in the post and got no error message. I then re ran the first script and I no longer got any error messages... very nice.

I then reloaded the server. However, I still cant log into the server. On the server side I am seeing a lot of "unknown opcode" messages of various numbers like 0x02ea and 0x00ee. Not sure what those mean but I would guess it has something to do with my client patched current to EQ live. Anyway, I dont mean this to be a support request, just offering feedback to the developers as they continue to work on the server code.

[WildcardX]

I spend my whole day on working with my server which I described above. I found the following bugs that may or may not be known, but I just wanted to offer what I learned anyway.

1. I make a new character from scratch. The only race that I could actually get into the game with as a new character are Iksar and Human. All other races, I can make the character, but when I go to log in, my client reports "you have been disconnected" and I end up back at the login screen if I am lucky. With the human or iksar characters, if I zone, I may or may not get the boot back to the login screen, it all just depended what zones were involved. I noticed I could #zone sebilis with no problems, but if I #zone to ecommons then I would end up at the login screen. In all cases, once I either camp out my new character or I zone and arrive at the login screen, I can never log my character back into the game. The only thing I could do is make another new character. I noticed once when I was in sebilis, I did #zone overthere but ended up on trakanons teeth. From there I repeated #zone overthere and arrived finally in OT at the succor xyz coordinates. When I tried to log back on after rebooting, in a ll cases, I got the "zone unavailable" message on my client.

2. Combat. I was very pleased when my level 1 human wussie stormed into the orc camp in ecommons that I aggroed the whole camp and all those orcs came to put the hurt on me, but I noticed I wasnt taking any damage. I double checked, and I was not in GM mode or any invulnerable mode and I had no buffs, but I wasnt getting hurt. I should have been dead. so I targetted one and turned on auto attack but the only thing that happend was a message "ERROR: String not found. (13)". BAH!!! After a few more seconds, my client died and I ended up at the login screen and, you guessed it, I couldn't log back into the game as that char.

3. Targetting. I noticed that when I went to #level 65 myself, I got a error message about "no target" even though I clearly had targetted myself... Same thing with spells like a buff or a heal...

4. Clicking the elevator button in poknowledge zones a player to Firiona Vie, which zones me, the human, back to the login screen and, thats right, now I can't log back in... hehe But I guess this is more a DB issue for projecteq.net...

5. Existing characters. I imported a couple chars I saved in a .sql from my 5.6 server I made last month or so, but I wasn't able to log into the game as those either... Saw a message on the server in the zone console about "player profile prior to March 26 patch being converted" , but then I saw a bunch of odd characters that just looked like a string message gone wrong... weird ascii code characters is really all I could describe it as, obviously an error and then my client would report "zone unavailable".

6. I did notice that if I tried to change my characters "camped" location in database to coordinates I knew should have been "safe", that after I tried to login in only to see the "zone unavailable" message,sometimes the server code would alter the coordinates... ??? ... like for example, i tried to change a character to this LOC in poknowledge, zoneid 202: x= 3.93 y = 777.04 z = 4.06, but the server would change the z cordinate to z = 0.00406 .. not sure why... and I also noticed on my other new characters, sometimes when I would just zone but fail that the zone name and coordinates where recorded, but the zoneid was recorded as 0. I tried to manually correct this with the proper zoneid but that never worked. I still got the "zone unavailable" message. I also tried to change these characters to a different zone altogether, like to poknowledge or east cabilis, but I still got the "zone unavailable" message..

It's almost bed time for me so I put EQEmu to rest and I'm gonna go toss in a DVD and watch some tv until I drift off to la la land, hehe. I hope something I typed here is valuable in getting out a new release..

Oh yes, my client is patched to EQLive as of May 29. I didnt want to, but I sold my eq live account for CA$H and part of the deal was I'd move all my characters to the bazaar so I had to log back in hehe Oh well, I got a nice check now

[cofruben]

not all opcodes are updated,just wait for next release or go collecting some