Guild Window bug

[robinreg]

I posted it in PEQ website for mysql submission with you being credit for it. =)

[GLGanjika]

Below tested with [Rev 2142 /eqemu 0.8.0]
Botguildmembers.sql

CREATE TABLE IF NOT EXISTS `botguildmembers` (
  `char_id` int(11) NOT NULL default '0',
  `guild_id` mediumint(8) unsigned NOT NULL default '0',
  `rank` tinyint(3) unsigned NOT NULL default '0',
  `tribute_enable` tinyint(3) unsigned NOT NULL default '0',
  `total_tribute` int(10) unsigned NOT NULL default '0',
  `last_tribute` int(10) unsigned NOT NULL default '0',
  `banker` tinyint(3) unsigned NOT NULL default '0',
  `public_note` text NULL,
  PRIMARY KEY  (`char_id`)
) ENGINE=InnoDB;

DROP VIEW IF EXISTS `vwGuildMembers`;
CREATE VIEW `vwGuildMembers` AS
  select 'C' as mobtype,
cm.char_id,
cm.guild_id,
cm.rank,
cm.tribute_enable,
cm.total_tribute,
cm.last_tribute,
cm.banker,
cm.public_note,
cm.alt
from guild_members as cm
union all
select 'B' as mobtype,
bm.char_id,
bm.guild_id,
bm.rank,
bm.tribute_enable,
bm.total_tribute,
bm.last_tribute,
bm.banker,
bm.public_note,
0 as alt
from botguildmembers as bm;

Sorta confused me how it was written in the OP so i figured i'd share
[inside code brackets] to make things clearer. Great work to the
dude who figured this out, Vexyl linked me here and it fixed my
guild window, epic post indeed, just trying to add clarity.

[lerxst2112]

Originally Posted by GLGanjika

Below tested with [Rev 2142 /eqemu 0.8.0]

This is already in the rev 2142 database when you source load_bots.sql.