View Single Post
  #1  
Old 01-10-2010, 07:59 PM
provocating's Avatar
provocating
Demi-God
 
Join Date: Nov 2007
Posts: 2,175
Default

Just and FYI for whoever does the bots. On Linux SQL since it is case sensitive it appears the bot code goes lower case but the view is in camel case so.

DROP VIEW IF EXISTS `vwbotgroups`;
CREATE VIEW `vwbotgroups` AS
select g.BotGroupId,
g.BotGroupName,
g.BotGroupLeaderBotId,
b.Name as BotGroupLeaderName,
b.BotOwnerCharacterId,
c.name as BotOwnerCharacterName
from botgroup as g
join bots as b on g.BotGroupLeaderBotId = b.BotID
join character_ as c on b.BotOwnerCharacterID = c.id
order by b.BotOwnerCharacterId, g.BotGroupName;


Is what I had to doctor to make the grouping work.
Reply With Quote