<?php
include 'header.php';
require_once 'dbConnection.php';
$connection = new dbConnection();
$result = $connection->Select("SELECT A.WishID, A.WisherID, A.PerformerID, A.WisherComplain, A.PerformerComplain, C.FirstName WisherFName, C.LastName WisherLName, C.Rank WisherRank, D.FirstName PerformerFName, D.LastName PerformerLName, D.Rank PerformerRank\nFROM `courts` AS A\nJOIN `Wishes` AS B \n\tON A.WishID=B.WishID \nJOIN Users AS C \n\tON A.WisherID=C.UserID\nJOIN Users AS D \n\tON A.PerformerID=D.UserID\n");
echo <<<HTML
<div class="center-block">
<div id="centerCourtz">
\t<div class="overflowOuter">
\t<div class="centerCourtzRaws">
HTML;
$count = 1;
while ($row = $result->fetch_assoc()) {
if (!file_exists("images/profiles/{$row['WisherID']}.jpg")) {
$wisherProfileImage = 'not-found.png';
} else {
$wisherProfileImage = $row['WisherID'] . '.jpg' . '?' . time();
}
if (!file_exists("images/profiles/{$row['PerformerID']}.jpg")) {
$performerProfileImage = 'not-found.png';
} else {
$performerProfileImage = $row['PerformerID'] . '.jpg' . '?' . time();
}
echo <<<HTML
\t<div class="courtz-row">
\t\t<div class="buttons">
\t\t\t\t<div class="button" onclick="buttonsBackground(id,{$row['WishID']})" id="plus{$count}"><img src="buttons/ButtonPLUS1.png"/></div>
\t\t\t\t<div class="button" onclick="buttonsBackground(id,{$row['WishID']})" id="favo{$count}"><img src="buttons/ButtonFAVO1.png"/></div>
\t\t\t\t<div class="button" onclick="buttonsBackground(id,{$row['WishID']})" id="minus{$count}"><img src="buttons/ButtonMINUS1.png"/></div>
\t\t\t</div>
