Guild Hall

[Gigfel]

Hello, if I zone into the Guild Hall an Instance has been created and my Character added to the Table "instance_list_player".
But when i exit the Guild Hall, the Entry that i am inside this Instance wont be deleted.
The next time you enter the Guild Hall, the Server tries to create the Entry in the Table again and the Query crashes.
There is no Problem to get back into the Guild Hall, but i get the Query Error Log, so i thought i report this little Bug.

[Uleat]

Need some more information here:

- Client version?
- Have you modified your server code/db entries regarding instances?
- Are you switching among client versions?


Last I recall was that the guild's 'Guild Hall' instance was active for 24 hours.

[Gigfel]

Hello Uleat,

i only use UF Client and i didnt have made any changes to the Database, it is a fresh clean installation of the PEQ.
Yes the Guild Hall will be active for around 24 hours, thats the message says which i get in Chat when i enter it.
I did zone into the Instance and she has been created, next time i zone into the GH again it was 13 hours laiter.

[provocating]

One thing to check are the quest globals, see if an entry is being created there and check the time of when it expires, you may have to use the FROM_UNIXTIME function to get the real expire date. The Guild Hall instancing is controlled a lot from the player quest script in the Guild Lobby, look at this section.

sub EVENT_CLICKDOOR 
{
	if($doorid == 2 || $doorid == 4 || $doorid == 40 || $doorid == 42) 
	{
    		if($uguild_id > 0) 
    		{
      			if (defined($qglobals{"ginstance$uguild_id"})) 
      			{
        			$guildinstance = $qglobals{"ginstance$uguild_id"};
        			quest::AssignToInstance($guildinstance);
        			quest::MovePCInstance(345, $guildinstance, -1.00, -1.00, 3.34);
      			}
      			else 
      			{
        			$guildinstance = quest::CreateInstance("guildhall", 1, 86400);
        			quest::AssignToInstance($guildinstance); 
        			quest::setglobal("ginstance$uguild_id",$guildinstance,7,"H24");
        			quest::MovePCInstance(345, $guildinstance, -1.00, -1.00, 3.34)
      			}
    		}
  	}
  	if((($doorid >= 5) && ($doorid <= 38)) ||  (($doorid >= 43) && ($doorid <= 76)))
  	{
		$client->OpenLFGuildWindow();
  	}
}