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.
|