Well the more I mess with stuff the more I think this is a code issue, not a DB issue. For example, I deleted every entry for lavastorm in the zonepoints_raw table.
Code:
DELETE FROM zonepoints_raw WHERE zone ='lavastorm'
Even after doing this I could still zone from lavastorm to sol a, sol b, and nektulos, but still not soltemple. Next, I decided to mess around with the number field in the zone_points table. I changed id 657's (lavastorm --> najena) number to something other than 1.
Code:
UPDATE zone_points SET number = 7 WHERE id = 657
When I did this I could not longer zone from lavastorm to najena. Instead I would just keeping running right past where the zone line should be. As soon as I changed number back to 1 I could zone perfectly. So that got me thinking that number is pretty important, so I tested this again, but this time with the lavastorm to nektulos zoneline.
Code:
UPDATE zone_points SET number = 30 WHERE id = 659
Well guess what? It still worked! I set the number to 255. I could still zone from lavastorm to nektulos. So, I took it a step further. I completely deleted that record from the table.
Code:
DELETE FROM zone_points WHERE id = 659
Guess what? Yeah, I still could zone perfectly fine. Except this time I got put somewhere else in nektulos forest, most likely because the server tried to find target_(x,y,z) values and didn't find them, so it defaults to something else. So the number field seems to matter sometimes, but not always. But that still didn't answer my initial question. What the hell is determining when I'm supposed to zone?
It doesn't seem like it is taking this from the DB. Does the EQ client send a packet to the server when it hits a zoneline that is defined in the zone file possibly? Is the client sending a packet but our server isn't catching some of these and that is why we can zone sometimes but not others? I've looked at the code briefly but not enough to follow everything that is going on. I'd like to packet collect on EQLive and see if different packet structures are being sent when you zone from certain zones. The only problem is that when I run packet collector I am getting discconected when I zone. Anyway, I just thought I would share my findings and see if it brings anything out. I'd like to get this zoning issue fixed.
Hybrid Mode
