EQEmulator Forums - Guild Window bug

EQEmulator Forums (https://www.eqemulator.org/forums/index.php)

- Development::Bug Reports (https://www.eqemulator.org/forums/forumdisplay.php?f=591)

- - Guild Window bug (https://www.eqemulator.org/forums/showthread.php?t=31402)

Guild Window bug

This fixes a guild window bug that got introduced with 1551, guild window stops working but only with servers running bots, 3 other people had the same issue and this fixes it.
The fix adds missing Alt tables that the server expects to be there but arent.

ALTER TABLE `botguildmembers` ADD `alt` TINYINT UNSIGNED NOT NULL DEFAULT '0' AFTER `public_note` ;

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,
bm.alt
from botguildmembers as bm;

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

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

Code:

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.

Quote:

Originally Posted by GLGanjika (Post 211148)

Below tested with [Rev 2142 /eqemu 0.8.0]

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

es not solve the problem

thanks to songie or whoever taught songie that, I copy/pasted songie's commands above into navicat new query ..guild windows works now =) server with bots as well... saw it change on zone before we even rebooted ... 3 years later but still helped me out =)
hugs!
edit:just for anyone else's info.. RoF Client, peqdbrev 2506 It wasn't super important but it was bugging me =) glad it is fixed.

Edit it fixed the guild management window and we're able to go into the guild hall but the management window won't let me assign bankers/ranks thru it. So the only thing now that needs fixed if it's possible is actually using the guild management window to promote/set access, does let me do Guild MOTD.. doesn't let us use the guild banker though. Anyone know what's missing? Not super important, just asking =)