Maniaplanet Forum

Code: Select all

public function getTopBetwins ($limit = -1) {
		global $aseco;

		$appendix = '';
		if ($limit > 0) {
			$appendix = 'LIMIT '. $limit;
		}

		if ($this->config['SCORETABLE_LISTS'][0]['TOP_BETWINS'][0]['DISPLAY'][0] === true) {
			// Calculate the Average
			$query = "
			SELECT
				`p`.`Login`,
				`p`.`Nickname`,
				((`b`.`wins` / `b`.`stake`) * `b`.`countwins`) AS `won`
			FROM `betting` AS `b`
			LEFT JOIN `%prefix%players` AS `p` ON `p`.`Login` = `b`.`login`
			WHERE `b`.`wins` > 0
			AND `p`.`Nickname` IS NOT NULL
			ORDER BY `won` DESC
			". $appendix .";
			";
		}
		else {
			// Get the Planets
			$query = "
			SELECT
				`p`.`Login`,
				`p`.`Nickname`,
				`b`.`wins` AS `won`
			FROM `betting` AS `b`
			LEFT JOIN `%prefix%players` AS `p` ON `p`.`Login` = `b`.`login`
			WHERE `b`.`wins` > 0
			AND `p`.`Nickname` IS NOT NULL
			ORDER BY `won` DESC
			". $appendix .";
			";
		}