View Single Post
  #1  
Old 06-01-2010, 08:06 AM
songie
Sarnak
 
Join Date: Dec 2009
Posts: 43
Default 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;
__________________
--You start casting "Extra Content"--
--You Hit your database for 9.999 Damage, you have slain your Server--
--Please wait reinstalling!--/Sigh
Reply With Quote