Bug Report; character freeze on login

[WildcardX]

John, the server's query regarding the source code i wrote to allow or not allow combat in specified zones looks like the following:

if (RunQuery(query, MakeAnyLenString(&query, "SELECT ztype,"
		"fog_red,fog_green,fog_blue,fog_minclip,fog_maxclip,"
		"fog_red2,fog_green2,fog_blue2,fog_minclip2,fog_maxclip2,"
		"fog_red3,fog_green3,fog_blue3,fog_minclip3,fog_maxclip3,"
		"fog_red4,fog_green4,fog_blue4,fog_minclip4,fog_maxclip4,"
		"sky,zone_exp_multiplier,safe_x,safe_y,safe_z,underworld,"
		"minclip,maxclip,time_type,canbind,cancombat"
		" from zone where zoneidnumber=%i",zoneid), errbuf, &result)) {
		safe_delete_array(query);

As you can see, if your table does not have a "cancombat" column then this will give you an error.

What does this have to do with Angelox's reported problem of getting stuck in geography or walking off land in the game? Nothing. Neither does the source code I wrote for not allowing it to rain in a zone that has not rain (a dungeon, etc). The weather code simply changes the weather and has no factor in moving a player. Neither does the code that decides if you can attack something in a zone.

I'm more interested in hearing more details such as which client was used or can this be re-produced on another server, like PEQ. I think that would be more germain.

[John Adams]

Right. That's what I meant... that change, or additional field, should not be causing any problems.

[WildcardX]

None what so ever.. 100% unrelated. It would be like suggesting the implementation of player sacrifice spells was causing Angelox to get trapped in zone geography.

[Angelox]

Well, this is embarassing but serves me right for not reading the log

Required SQL:
ALTER TABLE `zone` ADD `cancombat` tinyint(4) NOT NULL default '1';
UPDATE `zone` SET `cancombat` = 0 WHERE short_name = 'nexus';
UPDATE `zone` SET `cancombat` = 0 WHERE short_name = 'poknowledge';
UPDATE `zone` SET `cancombat` = 0 WHERE short_name = 'potranquility';

That solved the problem - I'm sorry to trouble you guys with this problem. Next time I will hopefully try harder before running my mouth.

[KLS]

While the cfg failing to load correctly will certainly cause many problems. It would be pretty obvious as the zone would spit out giant error messages. I'm really baffled as to what could be causing this.

edit: pssh nice to see it all worked out.