EQEmulator Forums - Wierd Guild Problems

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

- Support::Windows Servers (https://www.eqemulator.org/forums/forumdisplay.php?f=587)

- - Wierd Guild Problems (https://www.eqemulator.org/forums/showthread.php?t=32636)

Wierd Guild Problems

I have the newest REV of emu and PEQ. forsome reason when i create a guild the tags pop on my head but i cannot add anyone to the guild even with #get set command and no names pop up in my Guild window im usuing SoF client. use to work fine . with this client. any ideas?

Sorry to bump fixed it with this:

Code:

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;