Foppe
/
slork


			
				
					
						
						
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100
							<?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
}
// 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 = [];
$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;

$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;