Foppe
/
slork


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107
							<?php

// This file contains HTML snippets for the several possible forms

$pdo = null;
try {
	$pdo = new PDO("sqlite:" . './slork.sqlite');
} catch (PDOException $e) {
	// handle the exception here
}

$snippets = [];

if ( $screen == 0 ) {
	// Select all maintainers
	$query = <<<QUERY
		SELECT maintainer.maintainer, player.value 
		FROM maintainer 
		JOIN player ON maintainer.maintainer = player.player
		WHERE player.property = 'name';
QUERY;
	$all_maintainers = [];
	$rows = $pdo->query($query);
	foreach ($rows as $row) {
		$all_maintainers[$row['maintainer']] = $row['value'];
	}
	$snippets[0] = <<<HTML
		<form>
				<!-- This form adds a new maintainer -->
			<div class="form-group">
				<label for="newAPIKey">New maintainer</label>
				<input type="hidden" name="action" value="i">
				<input type="password" class="form-control" name="api" id="newAPIKey" aria-describedby="newAPIKey" placeholder="Enter API key">
				<small id="newAPIKey" class="form-text text-muted">Assuming you are new here, add your Torn API key</small>
			</div>
			<button type="submit" class="btn btn-primary">Submit</button>
		</form>
		<div><p>&nbsp;</p></div>
		<h4>OR</h4>
		<!-- This part selects an existing maintainer -->
		<form>
			<div class="form-group">
				<label for="existingMaintainer">Existing maintainer</label>
				<input type="hidden" name="action" value="m">
				<select class="form-control" name="maintainer" id="existingMaintainer">
					<option></option><!-- Empty option -->
HTML;

	foreach ($all_maintainers as $maintainer_key => $maintainer_value) {
		$snippets[0] .= "\t\t\t\t<option value=\"$maintainer_key\">$maintainer_value [$maintainer_key]</option>\n";
	}

	$snippets[0] .= <<<HTML
				</select>
			</div>
			<button type="submit" class="btn btn-primary">Submit</button>
		</form>
HTML;
}

if ( $screen == 2 ) {
	// Let maintainer select (or delete) a player
	$query = <<<SQL
		SELECT player, value FROM player 
		WHERE maintainer = ?
		AND property = 'name' 
		--AND player != ?
SQL;
	$stmt = $pdo->prepare($query);
	$stmt->execute([$maintainer[0]]);
	$rows = $stmt->fetchAll();
	print("<pre>");
	print_r($rows);
	print("</pre>");
	$players_id = array();
	foreach ($rows as $row) {
		$players_id[] = array($row['player'], $row['value'] . " [" . $row['player'] . "]");
	}

	$snippets[2] = <<<HTML
		<form id="player">
			<div class="form-group">
				<table class="table">
					<thead>
						<tr>
							<th>Player</th><th>Edit</th><th>Remove</th>
						</tr>
					</thead>
					<tbody>
HTML;

	foreach ($players_id as $player) {
		$snippets[2] .= "\n\t\t\t\t\t<tr>";
		$snippets[2] .= "\n\t\t\t\t\t\t<td>$player[1]";
		$snippets[2] .= "<input type=\"hidden\" name=\"player\" value=\"$player[0]\" form=\"player\"></td><td>";
		$snippets[2] .= "<input type=\"hidden\" name=\"maintainer\" value=\"$maintainer[0]\" form=\"player\">";
		$snippets[2] .= "<button class=\"btn btn-primary\" name=\"action\" value=\"e\" form=\"player\">Edit</button></td>";
		$snippets[2] .= "<td><button class=\"btn btn-danger\" name=\"action\" value=\"x\" form=\"player\">Remove</button></td>\n\t\t\t\t\t</tr>";
	}

	$snippets[2] .= <<<HTML
	\n				</tbody>
				</table>
			</div>
		</form>
HTML;
}