Guild Window bug

[songie]

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;

[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 (http://www.eqemulator.org/forums/member.php?u=112058) linked me here and it fixed my
guild window, epic post indeed, just trying to add clarity.

[lerxst2112]

Below tested with [Rev 2142 /eqemu 0.8.0]


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

[javewow]

es not solve the problem

[tiarabobera]

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.

[tiarabobera]

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 =)