/** * @see AbstractStatGenerator::__construct() */ public function __construct($statTypeID) { parent::__construct($statTypeID); // user $this->sqlSelects .= "ugml_users.id\r\n\t\t\t\t\t\t\t\t\tAS userID,\r\n\t\t\t\t\t\t\t\tugml_users.username,"; $this->sqlJoins .= " LEFT JOIN ugml_users\r\n\t\t\t\t\t\t\t\tON ugml_stat_entry.relationalID = ugml_users.id "; // alliance $this->sqlSelects .= "ugml_alliance.id\r\n\t\t\t\t\t\t\t\t\tAS allianceID,\r\n\t\t\t\t\t\t\t\tugml_alliance.ally_tag\r\n\t\t\t\t\t\t\t\t\tAS allianceTag,\r\n\t\t\t\t\t\t\t\tugml_alliance.ally_name\r\n\t\t\t\t\t\t\t\t\tAS allianceName,"; $this->sqlJoins .= " LEFT JOIN ugml_alliance\r\n\t\t\t\t\t\t\t\tON ugml_users.ally_id = ugml_alliance.id "; }
/** * @see AbstractStatGenerator::__construct() */ public function __construct($statTypeID) { parent::__construct($statTypeID); // alliance $this->sqlSelects .= " ugml_alliance.id\n\t\t\t\t\t\t\t\t\tAS allianceID,\n\t\t\t\t\t\t\t\tugml_alliance.ally_name\n\t\t\t\t\t\t\t\t\tAS allianceName,\n\t\t\t\t\t\t\t\tugml_alliance.ally_tag\n\t\t\t\t\t\t\t\t\tAS allianceTag,"; $this->sqlJoins .= " LEFT JOIN ugml_alliance\n\t\t\t\t\t\t\t\tON ugml_stat_entry.relationalID = ugml_alliance.id"; // members and average $this->sqlSelects .= " COUNT(*)\n\t\t\t\t\t\t\t\t\tAS membersCount,\n\t\t\t\t\t\t\t\tugml_stat_entry.points * COUNT(*)\n\t\t\t\t\t\t\t\t\tAS entirePoints,\n\t\t\t\t\t\t\t\tugml_stat_entry.points\n\t\t\t\t\t\t\t\t\tAS average,"; $this->sqlJoins .= " LEFT JOIN ugml_users\n\t\t\t\t\t\t\t\tON ugml_alliance.id = ugml_users.ally_id"; $this->sqlGroupBy .= " ugml_alliance.id,"; }