Foppe
/
slork


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251
							<?php

ini_set('display_errors', 1);
ini_set('display_startup_errors', 1);
error_reporting(E_ALL);

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

$pdo = null;
try {
	$pdo = new PDO("sqlite:" . "${db_path}/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);
	if ( $rows ) {
		foreach ($rows as $row) {
			$all_maintainers[$row['maintainer']] = $row['value'];
		}
	}
	print( "<pre>" );
	print_r( $all_maintainers );
	print( "</pre>" );
	$snippets[0] = <<<HTML
		<form>
				<!-- This form adds a new maintainer -->
			<div class="form-group">
				<label for="newAPIKey">Add a 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><hr><p>&nbsp;</p></div>
		<!-- This part selects an existing maintainer -->
		<form>
			<div class="form-group">
				<label for="existingMaintainer">... or select an 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 ) {
	// New player
	$snippets[2] = <<<HTML
	<form id="player-new">
		<div class="form-group">
			<label for="player-new">Add new player ...</label>
			<input type="hidden" name="maintainer" value="$maintainer[0]" form="player-new">
			<input type="number" name="player" form="player-new">
			<button class="btn btn-primary" name="action" value="p" form="player-new">New</button>
		</div>	
	</form>
	<div>
	<p>&nbsp;</p><hr><p>&nbsp;</p>
	</div>
HTML;

	// 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( "\$rows:\n" );
	print_r($rows);
	print("</pre>");
	*/
	$players_id = array();
	foreach ($rows as $row) {
		$players_id[] = array($row['player'], $row['value'] . " [" . $row['player'] . "]");
	}
	$snippets[2] .= "... or edit existing player";
	foreach ($players_id as $player) {
		$snippets[2] .= <<<HTML
			<div>
				<form id="player_edit_${player[0]}">
					<ul class="list-group list-group-flush">
HTML;


		$snippets[2] .= "\n\t\t\t\t\t\t<li class=\"w-100 p-3 list-group-item\">$player[1]";
		$snippets[2] .= "<input type=\"hidden\" name=\"player\" value=\"$player[0]\" form=\"player_edit_${player[0]}\"></td><td>";
		$snippets[2] .= "<input type=\"hidden\" name=\"maintainer\" value=\"$maintainer[0]\" form=\"player_edit_${player[0]}\">";
		$snippets[2] .= "<button class=\"btn btn-primary float-right btn-sm\" name=\"action\" value=\"e\" form=\"player_edit_${player[0]}\">Edit</button>";
		$snippets[2] .= "<button class=\"btn btn-danger float-right btn-sm\" name=\"action\" value=\"r\" form=\"player_edit_${player[0]}\">Remove</button>\n\t\t\t\t\t</li>";


		$snippets[2] .= <<<HTML
	\n				</ul>
				</form>
			</div>
HTML;
	}
	$snippets[2] .= <<<HTML
	<div>
		<p>&nbsp;</p>
		<a href="./index.php"><button class="btn btn-info">Ready</button></a>
	</div>
HTML;
}

if ( $screen == 3 ) {
	// Edit properties of player
	// Provided is $_REQUEST['player']
	// $maintainer[id, 'name'] is also available in this section
	$player = $_REQUEST['player'];
	$query = <<<QUERY
	SELECT player_properties.property, player.value 
		FROM player_properties
		JOIN player ON player_properties.player = player.player
		WHERE player_properties.player = ? 
		AND player_properties.maintainer = ?
		AND player.property = 'name';
QUERY;
	$stmt = $pdo->prepare( $query );
	$stmt->execute( [$player, $maintainer[0]] );
	//$rows = $stmt->fetchAll();
	$player_properties = [];
	$name = '?';
	foreach ($stmt as $key => $value) {
		// @TODO This is one row now since we store it in a JSON string
		/*
		print( "<pre>" );
		print( "[\$key, \$value]" );
		print_r( [$key, $value] );
		print( "</pre>" );
		*/
		$player_properties[] = json_decode( $value['property'] );
		if ($key == 'name') {
			$name = $value['value'];
		}
	}
	$query = <<<QUERY
	SELECT property, parent FROM properties;
QUERY;
	$stmt = $pdo->query( $query );
	$properties = [];
	foreach ($stmt as $row) {
		$properties[] = $row['property'];
	}
	$snippets[3] = '';
	/*
	print("<pre>");
	print_r($player_properties);
	print_r($properties);
	print_r( [$player, $maintainer[0]] );
	print("</pre>\n");
	*/
	$snippets[3] = <<<HTML
	<!--
	<div>
		<p>&nbsp;</p>
		<hr>
		<p>&nbsp;</p>	
	</div>
	-->
	<form id="player-edit">
		<div class="form-group">
			<label for="player-edit">Select properties for player ${name} [${player}]</label>
			<select class="selectpicker" multiple form="player-edit" name="properties[]">
				<option>ALL</option>
				<option>NONE</option>
HTML;
	$snippets[3] .= "\n";
	/*
	print("<pre>" );
	print("\$player_properties:\n");
	print_r( $player_properties );
	print( "</pre>" );
	*/
	foreach ( $properties as $property ) {
		$selected = '';
		if ( in_array( $property, $player_properties[0] ) ) {
			$selected = ' selected';
		}
		$snippets[3] .= "\t\t\t\t<option${selected}>${property}</option>\n";
	};
	$snippets[3] .= <<<HTML
			</select>
			<input type="hidden" name="action" value="s">
			<input type="hidden" name="maintainer" value="${maintainer[0]}">
			<input type="hidden" name="player" value="${player}">
		</div>
		<button class="btn-save btn btn-primary btn-sm">Save</button>
	</form>
	<div>
		<p>&nbsp;</p>
		<a href="./index.php?action=m&maintainer=${maintainer[0]}"><button class="btn btn-info">Ready</button></a>
	</div>
HTML;

}

if ($screen == 4) {
	$query = <<<QUERY
		"SELECT value FROM player WHERE maintainer = ? AND player = ? AND property = 'name';
QUERY;
	$stmt = $pdo->prepare($query);
	$player = $_REQUEST['player'];
	$maintainer = $_REQUEST['maintainer'];
	$stmt->execute( [$maintainer, $player] );
	$row = $stmt->fetchAll()[0];

	$snippets[4] = <<<HTML
	<form id="player_delete_${player}">
		<label for="player_delete_${player}">Are you sure you want to delete ${row['value']} ${player}?</label>
		<input type="hidden" name="player" value="$player" form="player_delete_${player}"></td><td>
		<input type="hidden" name="maintainer" value="$maintainer" form="player_delete_${player}">
		<button class="btn btn-danger float-right btn-sm" name="action" value="x" form="player_delete_${player}">Remove</button>\n\t\t\t\t\t</li>
	</form>
	<div>
		<p>&nbsp;</p>
		<a href="./index.php?action=m&maintainer=${maintainer}"><button class="btn btn-info">Ready</button></a>
	</div>
HTML;

}