query($query); if ( $rows ) { foreach ($rows as $row) { $all_maintainers[$row['maintainer']] = $row['value']; } } print( "

" );
	print_r( $all_maintainers );
	print( "

" ); $snippets[0] = <<

Add a new maintainer ... Assuming you are new here, add your Torn API key

HTML; // Let maintainer select (or delete) a player $query = <<prepare($query); $stmt->execute( [$maintainer[0]] ); $rows = $stmt->fetchAll(); /* print("

");
	print( "\$rows:\n" );
	print_r($rows);
	print("

"); */ $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] .= <<

$player[1]"; $snippets[2] .= ""; $snippets[2] .= ""; $snippets[2] .= ""; $snippets[2] .= "\n\t\t\t\t\t

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( "

" );
		print( "[\$key, \$value]" );
		print_r( [$key, $value] );
		print( "

" ); */ $player_properties[] = json_decode( $value['property'] ); if ($key == 'name') { $name = $value['value']; } } $query = <<query( $query ); $properties = []; foreach ($stmt as $row) { $properties[] = $row['property']; } $snippets[3] = ''; /* print("

");
	print_r($player_properties);
	print_r($properties);
	print_r( [$player, $maintainer[0]] );
	print("

\n"); */ $snippets[3] = <<

-->

HTML; } if ( $screen == 4 ) { $query = <<prepare($query); // $player = $_REQUEST['player']; // $maintainer = $_REQUEST['maintainer']; $stmt->execute( [$maintainer[0], $player] ); $row = $stmt->fetch(); $snippets[4] = << Are you sure you want to delete ${row['value']} ${player}? \n\t\t\t\t\t

HTML; }