widgets.php

<?php

function renderOpenLadders($title, $from, $count, $page = null)
{
	$query = "SELECT ladderID, name, summary, COUNT(userID) AS players "
		. "FROM ladders "
		. "LEFT JOIN ladderPlayers USING (ladderID) "
		. "WHERE visibility = 'PUBLIC' AND ladders.active = '1' "
		. "AND ((joinStatus IS NULL) OR (joinStatus = 'JOINED' AND ladderPlayers.active = '1')) "
		. "GROUP BY ladderID, name, summary "
		. "ORDER BY players DESC ";
	
	$render = function($ladder) {
		$nameHtml = htmlentities($ladder["name"]);
		$summaryHtml = htmlentities($ladder["summary"]);
		return "<tr><td><a href=\"ladder.php?ladder={$ladder["ladderID"]}\">$nameHtml</a></td><td>$summaryHtml</td><td><a href=\"ranking.php?ladder={$ladder["ladderID"]}\">{$ladder["players"]}</a></td></tr>\n";
	};
	
	return renderLongtable($title, "There are currently no open ladders available.", "ladders open-ladders", array("Name", "Description", "Players"), $query, $render, "ladders.php", 50, $page, $from, $count);
}

function renderMyLadders($userID, $title, $from, $count, $page = null)
{
	$userIDSql = db()->addSlashes($userID);
	$query = "SELECT ladderID, name, summary, rank, joinStatus "
		. "FROM ladders INNER JOIN ladderPlayers USING(ladderID) "
		. "WHERE ladderPlayers.userID = '$userIDSql' AND ladderPlayers.active = 1 AND ladders.active = 1 AND (ladderPlayers.joinStatus = 'JOINED' OR ladderPlayers.joinStatus = 'SIGNEDUP') "
		. "ORDER BY name ASC ";
	
	$render = function($ladder) use($userID) {
		$nameHtml = htmlentities($ladder["name"]);
		$summaryHtml = htmlentities($ladder["summary"]);
		if ($ladder["joinStatus"] == "JOINED") {
			$rankingUrlHtml = htmlentities("ranking.php?ladder={$ladder["ladderID"]}&player=$userID");
			$rankHtml = "<a href=\"$rankingUrlHtml\">{$ladder["rank"]}</a>";
		} else if ($ladder["joinStatus"] == "SIGNEDUP") {
			$rankHtml = "<em>Waiting for approval</em>";
		}
		return "<tr><td><a href=\"ladder.php?ladder={$ladder["ladderID"]}\">$nameHtml</a></td><td>$summaryHtml</td><td>$rankHtml</td></tr>\n";
	};
	
	return renderLongtable($title, "You are not currently playing on any ladders.", "ladders my-ladders", array("Name", "Description", "Rank"), $query, $render, "myladders.php", 50, $page, $from, $count);
}

function renderRanking($ladderID, $title, $emptyMessage, $highlightUserID, $from, $count, $page = null)
{
	$ladderIDSql = db()->addSlashes($ladderID);
	$query = "SELECT rating, rank, userID, name "
		. "FROM ladderPlayers INNER JOIN users USING(userID) "
		. "WHERE ladderPlayers.ladderID = '$ladderIDSql' "
		. "AND ladderPlayers.joinStatus = 'JOINED' "
		. "AND rank > 0 "
		. "ORDER BY rank ASC, userID ASC ";
	
	$render = function($player) use($ladderID, $highlightUserID) {
		$rankHtml = htmlentities($player["rank"]);
		$ratingHtml = htmlentities($player["rating"]);
		$nameHtml = htmlentities($player["name"]);
		$userIDHtml = htmlentities($player["userID"]);
		$class = "";
		if ($highlightUserID !== null && $player["userID"] == $highlightUserID) {
			$class = " class=\"active\"";
		}
		return "<tr$class><td>$rankHtml</td><td><a href=\"player.php?ladder=$ladderID&amp;player=$userIDHtml\">$nameHtml</a></td><td>$ratingHtml</td></tr>\n";
	};
	
	$urlBase = "ranking.php?ladder=$ladderID";
	if ($highlightUserID !== null) {
		$urlBase .= "&player=$highlightUserID";
	}
	
	return renderLongtable($title, $emptyMessage, "ranking", array("Rank", "Name", "Rating"), $query, $render, $urlBase, 50, $page, $from, $count);
}

function renderGames($userID, $ladderID, $title, $emptyMessage, $from, $count, $page = null)
{
	$header = array();
	$header[] = "Name";
	
	$userIDSql = db()->addSlashes($userID);
	$ladderIDSql = db()->addSlashes($ladderID);
	$select = "
		SELECT ladderGames.gameID,
			ladderGames.warlightGameID,
			ladderGames.name AS gameName,
			ladderGames.htmlName as htmlName,
			ladderGames.status,
			ladderGames.winningUserID,
			ladders.ladderID as ladderID,
			ladders.name AS ladderName,
			winningUser.name AS winningUserName
		";
	$fromSql = "
		FROM ladderGames
			INNER JOIN ladders USING(ladderID)
			LEFT JOIN users AS winningUser ON winningUser.userID = ladderGames.winningUserID
		";
	$where = "
		WHERE status = 'FINISHED'
		";
	if ($ladderID !== null) {
		$where .= "AND ladderGames.ladderID = '$ladderIDSql' ";
	} else {
		$header[] = "Ladder";
	}
	
	if ($userID !== null) {
		$select .= "
			, opponent.userID AS opponentUserID
			, opponent.name AS opponentName
			";
		$fromSql .= "
			INNER JOIN gamePlayers AS playerYou USING(gameID)
			INNER JOIN gamePlayers AS playerOpponent USING(gameID)
			INNER JOIN users AS opponent ON playerOpponent.userID = opponent.userID
			";
		$where .= "
			AND playerYou.userID = '$userIDSql'
			AND opponent.userID <> '$userIDSql'
			";
		$header[] = "Opponent";
	}
	$query = $select . $fromSql . $where . " ORDER BY endTime DESC";
	
	$header[] = "Winner";
	
	$render = function($game) use($ladderID, $userID) {
		$gameNameHtml = htmlentities($game["gameName"]);
		$ladderNameHtml = htmlentities($game["ladderName"]);
		
		if ($userID === null) {
			$class = "game-neutral";
		} else if ($game["winningUserID"] === null) {
			$class = "game-draw";
		} else if($game["winningUserID"] == $userID) {
			$class = "game-won";
		} else {
			$class = "game-lost";
		}
		$class .= " game-finished";
		
		$output = "<tr class=\"$class\">";
		$output .= "<td>{$game["htmlName"]}</td>";
		if ($ladderID === null) {
			$output .= "<td><a href=\"ladder.php?ladder={$game["ladderID"]}\">$ladderNameHtml</a></td>";
		}
		if ($userID !== null) {
			$opponentNameHtml = htmlentities($game["opponentName"]);
			$output .= "<td><a href=\"player.php?ladder={$game["ladderID"]}&amp;player={$game["opponentUserID"]}\">$opponentNameHtml</a></td>";
		}
		if ($game["winningUserName"] === null) {
			$output .= "<td>-</td>";
		} else {
			$winnerNameHtml = htmlentities($game["winningUserName"]);
			$output .= "<td><a href=\"player.php?ladder={$game["ladderID"]}&amp;player={$game["winningUserID"]}\">$winnerNameHtml</a></td>";
		}
		$output .= "</tr>\n";
		return $output;
	};
	
	return renderLongtable($title, $emptyMessage, "games my-games", $header, $query, $render, "games.php?" . ($userID !== null ? "player=$userID" : "") . ($ladderID !== null ? ($userID !== null ? "&" : "") . "ladder=$ladderID" : ""), 50, $page, $from, $count);
}

function renderAcceptList($ladderID, $title, $from, $count, $page = null)
{
	$ladderIDSql = db()->addSlashes($ladderID);
	$query = "SELECT userID, name "
		. "FROM ladderPlayers LEFT JOIN users USING (userID) "
		. "WHERE ladderID = '$ladderIDSql' AND joinStatus = 'SIGNEDUP' "
		. "ORDER BY joinTime DESC ";
	
	$render = function($user) use($ladderID) {
		$nameHtml = htmlentities($user["name"]);
		$acceptUrlHtml = htmlentities("acceptplayer.php?ladder={$ladderID}&player={$user["userID"]}&accept=1");
		$rejectUrlHtml = htmlentities("acceptplayer.php?ladder={$ladderID}&player={$user["userID"]}&accept=0");
		return "<tr><td><a href=\"player.php?ladder={$ladderID}&amp;player={$user["userID"]}\">$nameHtml</a></td><td><a href=\"$acceptUrlHtml\">Accept player</a></td><td><a href=\"$rejectUrlHtml\">Reject player</a></td></tr>\n";
	};
	
	return renderLongtable($title, "There are no players waiting to join this ladder.", "acceptlist", array("Name", "Accept", "Reject"), $query, $render, "acceptlist.php?ladder=$ladderID", 50, $page, $from, $count);
}

function renderLadderTemplates($ladderID, $formAction, $nameField, $templateIDField, $action)
{
	$ladderIDSql = db()->addSlashes($ladderID);
	$query = "SELECT templateID, warlightTemplateID, name FROM ladderTemplates WHERE ladderID='$ladderIDSql' ORDER BY name ASC";
	
	$render = function($template) use($ladderID) {
		$nameHtml = htmlentities($template["name"]);
		$deleteHtml = "<button type=\"submit\" name=\"remove-template\" value=\"{$template["templateID"]}\" class=\"btn btn-default form-control\">Remove Template</button>";
		return "<tr><td>$nameHtml</td><td><a href=\"http://warlight.net/MultiPlayer?TemplateID={$template["warlightTemplateID"]}\">{$template["warlightTemplateID"]}</a></td><td>$deleteHtml</td></tr>\n";
	};
	
	return renderEditTable("No templates are configured for this ladder yet.", "laddertemplatelist templates", array("Name", "ID", ""), $query, $render, $formAction,
		"<tr><td><input type=\"text\" name=\"$nameField\" class=\"stretch\" /></td><td><input type=\"text\" name=\"$templateIDField\" class=\"stretch\" /></td><td><input type=\"hidden\" name=\"action\" value=\"$action\" /><input type=\"submit\" value=\"Add Template\" class=\"btn btn-default form-control\" /></td></tr>");
}

function renderLadderMods($ladderID, $formAction, $userIDField, $action)
{
	$ladderIDSql = db()->addSlashes($ladderID);
	$query = "SELECT userID, name FROM ladderAdmins INNER JOIN users USING (userID) WHERE ladderID='$ladderIDSql' ORDER BY name ASC";
	
	$render = function($admin) use($ladderID) {
		$nameHtml = htmlentities($admin["name"]);
		$deleteHtml = "<button type=\"submit\" name=\"remove-admin\" value=\"{$admin["userID"]}\" class=\"btn btn-default form-control\">Remove Moderator</button>";
		return "<tr><td><a href=\"player.php?ladder={$ladderID}&amp;player={$admin["userID"]}\">$nameHtml</a></td><td>$deleteHtml</td></tr>\n";
	};
	
	$users = db()->query("SELECT userID, name FROM ladderPlayers INNER JOIN users USING (userID) WHERE ladderID='$ladderIDSql' AND ladderPlayers.joinStatus = 'JOINED' ORDER BY name ASC")->fetchList();
	$options = "";
	foreach($users as $user) {
		$nameHtml = htmlentities($user["name"]);
		$options .= "<option value=\"{$user["userID"]}\">$nameHtml</option>\n";
	}
	
	return renderEditTable("This ladder doesn't have any moderators.", "laddermodlist mods", array("Name", ""), $query, $render, $formAction,
		"<tr><td><select name=\"$userIDField\" class=\"form-control stretch\">$options</select></td><td><input type=\"hidden\" name=\"action\" value=\"$action\" /><input type=\"submit\" value=\"Add Moderator\" class=\"btn btn-default form-control\" /></td></tr>");
}

function renderMyLadderSettings($userID)
{
	$userIDSql = db()->addSlashes($userID);
	$query = "SELECT ladderID, name, summary "
		. "FROM ladders INNER JOIN ladderPlayers USING(ladderID) "
		. "WHERE ladderPlayers.userID = '$userIDSql' AND ladderPlayers.active = 1 AND ladders.active = 1 "
		. "ORDER BY name ASC ";
	
	$render = function($ladder) use($userID) {
		$nameHtml = htmlentities($ladder["name"]);
		$summaryHtml = htmlentities($ladder["summary"]);
		$settingsUrlHtml = htmlentities("mysettings.php?ladder={$ladder["ladderID"]}");
		return "<tr><td><a href=\"$settingsUrlHtml\">$nameHtml</a></td><td>$summaryHtml</td></tr>\n";
	};
	
	return renderEditTable("You are not currently playing on any ladders.", "laddersettingslist ladders", array("Name", "Description"), $query, $render, null, null);
}