Beispiel #1
0
 /**
  * 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;
 }
Beispiel #2
0
 /**
  * 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;
 }