/**
* Returns array with guild members list. If $gm == true, returns his/her data only.
* @category Guilds class
* @example Guilds::buildGuildList(false)
* @return array
**/
public function BuildGuildList()
{
if (!$this->guildId) {
$this->Log()->writeError('%s : guildId not defined', __METHOD__);
return false;
}
$memberListTmp = $this->cDB->select("\n SELECT\n `characters`.`guid`,\n `characters`.`name`,\n `characters`.`class` AS `classId`,\n `characters`.`race` AS `raceId`,\n `characters`.`gender` AS `genderId`,\n `characters`.`level`,\n `guild_member`.`rank`\n FROM `characters` AS `characters`\n LEFT JOIN `guild_member` AS `guild_member` ON `guild_member`.`guid`=`characters`.`guid` AND `guild_member`.`guildid`=?\n LEFT JOIN `guild` AS `guild` ON `guild`.`guildid`=?\n WHERE `guild`.`guildid`=? AND `characters`.`level`>=? AND `guild_member`.`guid`=`characters`.`guid`", $this->guildId, $this->guildId, $this->guildId, $this->armoryconfig['minlevel']);
$countMembers = count($memberListTmp);
for ($i = 0; $i < $countMembers; $i++) {
$memberListTmp[$i]['achPoints'] = Achievements::calculateAchievementPoints($memberListTmp[$i]['guid']);
$memberListTmp[$i]['url'] = sprintf('r=%s&cn=%s&gn=%s', urlencode($this->currentRealmInfo['name']), urlencode($memberListTmp[$i]['name']), urlencode($this->guildName));
}
return $memberListTmp;
}
/**
* Returns array with guild members list. If $gm == true, returns his/her data only.
* @category Guilds class
* @example Guilds::buildGuildList(false)
* @return array
**/
public function buildGuildList($gm = false)
{
if (!$this->guildId) {
return false;
}
if ($gm == true) {
$memberListTmp = $this->cDB->select("\n SELECT `guid`, `name`, `race`, `class`, `gender`, `level`\n FROM `characters` WHERE `guid` IN \n (\n SELECT `guid`\n FROM `guild_member`\n WHERE `guildid`=? AND `rank`=0\n ) LIMIT 1", $this->guildId);
} else {
$memberListTmp = $this->cDB->select("\n SELECT\n `characters`.`guid`,\n `characters`.`name`,\n `characters`.`class`,\n `characters`.`race`,\n `characters`.`gender`,\n `characters`.`level`,\n `guild_member`.`rank`\n FROM `characters` AS `characters`\n LEFT JOIN `guild_member` AS `guild_member` ON `guild_member`.`guid`=`characters`.`guid` AND `guild_member`.`guildid`=?\n LEFT JOIN `guild` AS `guild` ON `guild`.`guildid`=?\n WHERE `guild`.`guildid`=? AND `characters`.`level`>=? AND `guild_member`.`guid`=`characters`.`guid` AND `guild_member`.`rank` <> 0\n GROUP BY `guild_member`.`rank`", $this->guildId, $this->guildId, $this->guildId, $this->armoryconfig['minlevel']);
}
$i = 0;
$countMembers = count($memberListTmp);
for ($i = 0; $i < $countMembers; $i++) {
$memberListTmp[$i]['ach_points'] = Achievements::calculateAchievementPoints($memberListTmp[$i]['guid']);
}
return $memberListTmp;
}
