/**
* @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,";
}