";
switch ($_GET['sort']) {
case "horses_sales":
$sort = "ORDER BY sale_fee DESC";
break;
case "horses_breed":
$sort = "ORDER BY breed";
break;
case "horses_gender":
$sort = "ORDER BY gender DESC";
break;
case "horses_feed":
$sort = "ORDER BY days_feed, days_paid";
break;
case "horses_points":
$sort = "ORDER BY points DESC";
break;
case "horses_name":
$sort = "ORDER BY name ASC";
break;
default:
$sort = "ORDER BY name ASC";
if (!$sort_order) {
$sql .= $sort;
} else {
$sql .= $sort_order;
}
break;
}
if (isset($_GET['sort']) && $player_id == $account_id && (!$sort_order || $order_by !== $sort)) {
mysqli_query($mysqli_link, "UPDATE `players` SET `sort_order` = '{$sort}' WHERE `player_id` = {$account_id}");
$sql .= $sort;
}
if (!$use_dividers) {
echo "
| Horses |
|---|
";
$sql = "SELECT horse_id, name, gender, breed, brand, stable_id, days_paid, days_feed, shows_entered, sale_fee, points FROM horses WHERE player_id='$account_id' ";
/*switch ($_GET['sort'])
{
case "horse_sales": $sql .= "ORDER BY sale_fee DESC"; break;
case "horse_breed": $sql .= "ORDER BY breed"; break;
case "horse_gender": $sql .= "ORDER BY gender DESC"; break;
case "horse_feed": $sql .= "ORDER BY days_feed, days_paid"; break;
case "horse_energy": $sql .= "ORDER BY shows_entered"; break;
case 'horse_points': $sql .= 'ORDER BY points DESC'; break;
case "horse_name":
default: $sql .= "ORDER BY name ASC";
break;
}*/
$result = @mysqli_query($mysqli_link, $sql)or die("Cannot find horses1! " . @mysqli_error($mysqli_link));
if (mysqli_num_rows($result)) {
echo "
Sale? ![](\"images/arrow-down.gif\") |
Name |
Breed |
Gender |
Feed |
Energy |
Points |
";
}
while ($row = @mysqli_fetch_array($result)) :
$horse_id = $row['horse_id'];
$name = $row['name'];
$breed = $row['breed'];
$gender = $row['gender'];
$days_paid = $row['days_paid'];
$days_feed = $row['days_feed'];
$shows_entered = $row['shows_entered'];
$stable_id = $row['stable_id'];
$brand = $row['brand'];
$sale_fee = $row['sale_fee'];
$points = number_format($row['points']);
if ($sale_fee) {
$sale = "$";
} else {
$sale = "";
}
if ($stable_id != $account_id) {
if ($days_paid < 1) {
$days_paid = "(Days Paid: $days_paid day(s).)";
} else {
$days_paid = "(Days Paid: $days_paid day(s).)";
}
if ($days_feed < 1) {
$days_feed = "(Feed left: $days_feed day(s).)";
} else {
$days_feed = "(Feed left: $days_feed day(s).)";
}
} else {
$days_paid = "";
if ($days_feed < 1) {
$days_feed = "(Feed left: $days_feed day(s).)";
} else {
$days_feed = "(Feed left: $days_feed day(s).)";
}
}
echo "
| $sale |
$name (#$horse_id) |
$breed $brand |
$gender |
$days_paid $days_feed |
$shows_entered |
$points |
";
$horse_flag = 1;
endwhile;
if (!$horse_flag) {
echo "No horses.";
} else {
echo " ";
}
echo "
|
| Dogs |
|---|
";
$sql = "SELECT dog_id, name, gender, breed, brand, kennel_id, days_paid, days_feed, shows_entered, sale_fee, points FROM dogs WHERE player_id='$account_id' ";
/* switch ($_GET['sort']) {
case "horse_sales":
$sort = "ORDER BY sale_fee DESC";
break;
case "horse_breed":
$sort = "ORDER BY breed";
break;
case "horse_gender":
$sort = "ORDER BY gender DESC";
break;
case "horse_feed":
$sort = "ORDER BY days_feed, days_paid";
break;
case "horse_energy":
$sort = "ORDER BY shows_entered";
break;
case "horse_points":
$sort = "ORDER BY points DESC";
break;
case "horse_name":
$sort = "ORDER BY name ASC";
break;
default:
$sort = "ORDER BY name ASC";
if (!$sort_order) {
$sql .= $sort;
} else {
$sql .= $sort_order;
}
break;
}*/
if (isset($_GET['sort']) && $player_id == $account_id && (!$sort_order || $order_by !== $sort)) {
mysqli_query($mysqli_link, "UPDATE `players` SET `sort_order` = '{$sort}' WHERE `player_id` = {$account_id}");
$sql .= $sort;
}
$result = @mysqli_query($mysqli_link, $sql)or die("Cannot find horses! 2 " . @mysqli_error($mysqli_link));
if (mysqli_num_rows($result)) {
echo "
| Sale? |
Name |
Breed |
Gender |
Feed |
Energy |
Points |
";
}
while ($row = @mysqli_fetch_array($result)) :
$dog_id = $row['dog_id'];
$name = $row['name'];
$breed = $row['breed'];
$gender = $row['gender'];
$days_paid = $row['days_paid'];
$days_feed = $row['days_feed'];
$shows_entered = $row['shows_entered'];
$stable_id = $row['kennel_id'];
$brand = $row['brand'];
$sale_fee = $row['sale_fee'];
$points = number_format($row['points']);
if ($sale_fee) {
$sale = "$";
} else {
$sale = "";
}
if ($stable_id != $account_id) {
if ($days_paid < 1) {
$days_paid = "(Days Paid: $days_paid day(s).)";
} else {
$days_paid = "(Days Paid: $days_paid day(s).)";
}
if ($days_feed < 1) {
$days_feed = "(Feed left: $days_feed day(s).)";
} else {
$days_feed = "(Feed left: $days_feed day(s).)";
}
} else {
$days_paid = "";
if ($days_feed < 1) {
$days_feed = "(Feed left: $days_feed day(s).)";
} else {
$days_feed = "(Feed left: $days_feed day(s).)";
}
}
echo "
| $sale |
$name (#$dog_id) |
$breed $brand |
$gender |
$days_paid $days_feed |
$shows_entered |
$points |
";
$dog_flag = 1;
endwhile;
if (!$dog_flag) {
echo "No dogs.";
} else {
echo " ";
}
echo "
| ";
} else //using dividers
{
$loop = mysqli_query($mysqli_link, "SELECT id, name FROM dividers WHERE player_id='$account_id' ORDER BY sort_order")
or die('cannot load dividers');
switch ($_GET['sort']) {
case "sales":
$sort = "ORDER BY animals.sale_fee DESC";
break;
case "breed":
$sort = "ORDER BY animals.breed";
break;
case "gender":
$sort = "ORDER BY animals.gender DESC";
break;
case "feed":
$sort = "ORDER BY animals.days_feed, animals.days_paid";
break;
case "points":
$sort = "ORDER BY animals.points DESC";
break;
case "name":
$sort = "ORDER BY animals.name ASC";
break;
default:
if ($sort_order) {
$sort = $sort_order;
} else {
$sort = "ORDER BY animals.name ASC";
}
break;
}
if (isset($_GET['sort']) && $player_id == $account_id && (!$sort_order || $order_by !== $sort)) {
mysqli_query($mysqli_link, "UPDATE `players` SET `sort_order` = '{$sort}' WHERE `player_id` = {$account_id}");
}
while ($divider = mysqli_fetch_assoc($loop)) {
echo "| " . stripslashes($divider['name']) . " |
|---|
";
$dog_sql = "SELECT dog_id AS id, 'dog' AS type, name, gender, breed, brand, kennel_id AS board, days_paid, days_feed, shows_entered, sale_fee, points FROM dogs WHERE player_id='$account_id' AND divider='{$divider['id']}' ";
$horse_sql = "SELECT horse_id AS id, 'horse' AS type, name, gender, breed, brand, stable_id AS board, days_paid, days_feed, shows_entered, sale_fee, points FROM horses WHERE player_id='$account_id' AND divider='{$divider['id']}' ";
$sql = "SELECT * FROM (($dog_sql) UNION ($horse_sql)) AS animals ";
if ($sort) {
$sql .= $sort;
}
// if($_SESSION['id'] == 22390) {die($sql);}
$animal_loop = @mysqli_query($mysqli_link, $sql)
or die("Cannot find divider animals! " . @mysqli_error($mysqli_link));
if (mysqli_num_rows($loop)) {
echo "
| Sale? |
Name |
Breed |
Gender |
Feed |
Energy |
Points |
";
}
while ($row = @mysqli_fetch_array($animal_loop)) {
$animal_id = $row['id'];
$type = $row['type'];
$name = $row['name'];
$breed = $row['breed'];
$gender = $row['gender'];
$days_paid = $row['days_paid'];
$days_feed = $row['days_feed'];
$shows_entered = $row['shows_entered'];
$board = $row['board'];
$brand = $row['brand'];
$sale_fee = $row['sale_fee'];
$points = number_format($row['points']);
if ($sale_fee) {
$sale = "$";
} else {
$sale = "";
}
if ($board != $account_id) {
if ($days_paid < 1) {
$days_paid = "(Days Paid: $days_paid day(s).)";
} else {
$days_paid = "(Days Paid: $days_paid day(s).)";
}
if ($days_feed < 1) {
$days_feed = "(Feed left: $days_feed day(s).)";
} else {
$days_feed = "(Feed left: $days_feed day(s).)";
}
} else {
$days_paid = "";
if ($days_feed < 1) {
$days_feed = "(Feed left: $days_feed day(s).)";
} else {
$days_feed = "(Feed left: $days_feed day(s).)";
}
}
echo "
| $sale |
$name (#$animal_id) |
$breed $brand |
$gender |
$days_paid $days_feed |
$shows_entered |
$points |
";
}
if (!mysqli_num_rows($animal_loop)) {
echo "| No animals in this divider. | ";
}
echo "
|
";
}
//animals not in a divider
$dog_sql = "SELECT dog_id AS id, 'dog' AS type, name, gender, breed, brand, kennel_id AS board, days_paid, days_feed, shows_entered, sale_fee, points FROM dogs WHERE player_id='$account_id' AND divider NOT IN (SELECT id FROM dividers WHERE player_id='$account_id') ";
$horse_sql = "SELECT horse_id AS id, 'horse' AS type, name, gender, breed, brand, stable_id AS board, days_paid, days_feed, shows_entered, sale_fee, points FROM horses WHERE player_id='$account_id' AND divider NOT IN (SELECT id FROM dividers WHERE player_id='$account_id') ";
switch ($_GET['sort']) {
case "sales":
$sort = "ORDER BY sale_fee DESC";
break;
case "breed":
$sort = "ORDER BY breed";
break;
case "gender":
$sort = "ORDER BY gender DESC";
break;
case "feed":
$sort = "ORDER BY days_feed, days_paid";
break;
case "points":
$sort = "ORDER BY points DESC";
break;
case "name":
$sort = "ORDER BY name ASC";
break;
default:
$sort = "ORDER BY name ASC";
if (!$sort_order) {
$horse_sql .= $sort;
} else {
$horse_sql .= $sort_order;
}
break;
}
if (isset($_GET['sort']) && $player_id == $account_id && (!$sort_order || $order_by !== $sort)) {
mysqli_query($mysqli_link, "UPDATE `players` SET `sort_order` = '{$sort}' WHERE `player_id` = {$account_id}");
$horse_sql .= $sort;
}
$animal_loop = @mysqli_query($mysqli_link, $horse_sql)
or die("Cannot find undivided horses! " . @mysqli_error($mysqli_link));
//display all unsorted horses if there are any
if (mysqli_num_rows($animal_loop)) {
echo "| Horses |
|---|
";
if (mysqli_num_rows($animal_loop)) {
echo "
| Sale? |
Name |
Breed |
Gender |
Feed |
Energy |
Points |
";
}
while ($row = @mysqli_fetch_array($animal_loop)) {
$animal_id = $row['id'];
$type = $row['type'];
$name = $row['name'];
$breed = $row['breed'];
$gender = $row['gender'];
$days_paid = $row['days_paid'];
$days_feed = $row['days_feed'];
$shows_entered = $row['shows_entered'];
$board = $row['board'];
$brand = $row['brand'];
$sale_fee = $row['sale_fee'];
$points = number_format($row['points']);
if ($sale_fee) {
$sale = "$";
} else {
$sale = "";
}
if ($board != $account_id) {
if ($days_paid < 1) {
$days_paid = "(Days Paid: $days_paid day(s).)";
} else {
$days_paid = "(Days Paid: $days_paid day(s).)";
}
if ($days_feed < 1) {
$days_feed = "(Feed left: $days_feed day(s).)";
} else {
$days_feed = "(Feed left: $days_feed day(s).)";
}
} else {
$days_paid = "";
if ($days_feed < 1) {
$days_feed = "(Feed left: $days_feed day(s).)";
} else {
$days_feed = "(Feed left: $days_feed day(s).)";
}
}
echo "
| $sale |
$name (#$animal_id) |
$breed $brand |
$gender |
$days_paid $days_feed |
$shows_entered |
$points |
";
}
if (!mysqli_num_rows($animal_loop)) {
echo "| No horses. | ";
}
echo "
|
";
}
switch ($_GET['sort']) {
case "sales":
$sort = "ORDER BY sale_fee DESC";
if ($player_id == $account_id && !$sort_order || $order_by !== $sort) {
mysqli_query($mysqli_link, "UPDATE `players` SET `sort_order` = '{$sort}' WHERE `player_id` = {$row['player_id']}");
$dog_sql .= $sort;
}
break;
case "breed":
$sort = "ORDER BY breed";
if ($player_id == $account_id && !$sort_order || $order_by !== $sort) {
mysqli_query($mysqli_link, "UPDATE `players` SET `sort_order` = '{$sort}' WHERE `player_id` = {$row['player_id']}");
$dog_sql .= $sort;
}
break;
case "gender":
$sort = "ORDER BY gender DESC";
if ($player_id == $account_id && !$sort_order || $order_by !== $sort) {
mysqli_query($mysqli_link, "UPDATE `players` SET `sort_order` = '{$sort}' WHERE `player_id` = {$row['player_id']}");
$dog_sql .= $sort;
}
break;
case "feed":
$sort = "ORDER BY days_feed, days_paid";
if ($player_id == $account_id && !$sort_order || $order_by !== $sort) {
mysqli_query($mysqli_link, "UPDATE `players` SET `sort_order` = '{$sort}' WHERE `player_id` = {$row['player_id']}");
$dog_sql .= $sort;
}
break;
case "points":
$sort = "ORDER BY points DESC";
if ($player_id == $account_id && !$sort_order || $order_by !== $sort) {
mysqli_query($mysqli_link, "UPDATE `players` SET `sort_order` = '{$sort}' WHERE `player_id` = {$row['player_id']}");
$dog_sql .= $sort;
}
break;
case "name":
$sort = "ORDER BY name ASC";
if ($player_id == $account_id && !$sort_order || $order_by !== $sort) {
mysqli_query($mysqli_link, "UPDATE `players` SET `sort_order` = '{$sort}' WHERE `player_id` = {$row['player_id']}");
$dog_sql .= $sort;
}
break;
default:
$sort = "ORDER BY name ASC";
if (!$sort_order) {
$dog_sql .= $sort;
} else {
$dog_sql .= $sort_order;
}
break;
}
$animal_loop = @mysqli_query($mysqli_link, $dog_sql)
or die("Cannot find undivided dogs! " . @mysqli_error($mysqli_link));
//display all unsorted dogs if there are any
if (mysqli_num_rows($animal_loop)) {
echo "| Dogs |
|---|
";
if (mysqli_num_rows($animal_loop)) {
echo "
| Sale? |
Name |
Breed |
Gender |
Feed |
Energy |
Points |
";
}
while ($row = @mysqli_fetch_array($animal_loop)) {
$animal_id = $row['id'];
$type = $row['type'];
$name = $row['name'];
$breed = $row['breed'];
$gender = $row['gender'];
$days_paid = $row['days_paid'];
$days_feed = $row['days_feed'];
$shows_entered = $row['shows_entered'];
$board = $row['board'];
$brand = $row['brand'];
$sale_fee = $row['sale_fee'];
$points = number_format($row['points']);
if ($sale_fee) {
$sale = "$";
} else {
$sale = "";
}
if ($board != $account_id) {
if ($days_paid < 1) {
$days_paid = "(Days Paid: $days_paid day(s).)";
} else {
$days_paid = "(Days Paid: $days_paid day(s).)";
}
if ($days_feed < 1) {
$days_feed = "(Feed left: $days_feed day(s).)";
} else {
$days_feed = "(Feed left: $days_feed day(s).)";
}
} else {
$days_paid = "";
if ($days_feed < 1) {
$days_feed = "(Feed left: $days_feed day(s).)";
} else {
$days_feed = "(Feed left: $days_feed day(s).)";
}
}
echo "
| $sale |
$name (#$animal_id) |
$breed $brand |
$gender |
$days_paid $days_feed |
$shows_entered |
$points |
";
}
if (!mysqli_num_rows($animal_loop)) {
echo "| No dogs. | ";
}
echo "
|
";
}
}
echo "
Shows  $create_show |
|---|
";
$result = @mysqli_query($mysqli_link, "SELECT type, species, show_id, name, date_format(run_date, '%c/%e/%Y') AS run_date FROM shows WHERE player_id='$account_id' AND type NOT IN (2, 4) ORDER BY show_id DESC")or die("Cannot find horses! " . @mysqli_error($mysqli_link));
while ($row = @mysqli_fetch_array($result)) :
$show_id = $row['show_id'];
$species = ucwords($row['species']);
$name = $row['name'];
$run_date = $row['run_date'];
$type = $row['type'];
if ($type == 1) {
$type = "Public";
} else {
$type = "Private";
}
echo " $type $species: $name (#$show_id) - Runs: $run_date ";
$show_flag = 1;
endwhile;
if (!$show_flag) {
echo " No shows.";
}
echo "
$public_show_allowance
$public_dshow_allowance
$private_show_allowance
$private_dshow_allowance
|
| Achievements |
|---|
";
$NUM_PER_ROW = 6;
$count = 0;
$loop = mysqli_query($mysqli_link, "
SELECT
A.name,
A.url,
A.description
FROM player_achievements P
INNER JOIN achievements A on A.id = P.achievement_id
WHERE P.player_id = '$account_id'")
or die('cannot load player achievements');
while ($achievement = mysqli_fetch_assoc($loop)) {
if (!$count) {
echo "";
} elseif ($count % $NUM_PER_ROW == 0) {
echo " ";
}
echo "
![\""](\"{$achievement['url']}\" "\\"\"")
" . stripslashes($achievement['name']) . "
| ";
$count++;
}
if (!mysqli_num_rows($loop)) {
echo " | No achievements | ";
}
echo "
|
| Events |
|---|
|
";
if ($player_id == $account_id || $my_admin == 1 || $my_admin == 2) {
$msg_flag = 0;
$result = @mysqli_query($mysqli_link, "SELECT message, date_format(date, '%c/%e/%Y') AS date FROM events WHERE player_id='$account_id' AND date>=NOW() - INTERVAL 14 DAY AND events_type!='Show Results' ORDER BY event_id DESC LIMIT 250")or die("Cannot find events! " . @mysqli_error($mysqli_link));
while ($row = @mysqli_fetch_array($result)) :
echo $row[date] . ": ".$row[message]."
";
$msg_flag = 1;
endwhile;
if (!$msg_flag) {
echo "No events.";
}
} else {
echo "You may not view others' events.";
}
/* echo "
|
| Show Events |
|---|
|
";
if ($player_id == $account_id || $my_admin) {
$msg_flag = 0;
$result = @mysql_query("SELECT message, date_format(date, '%c/%e/%Y') AS date FROM events WHERE player_id='$account_id' AND date>=NOW() - INTERVAL 14 DAY AND events_type='Show Results' ORDER BY event_id DESC LIMIT 250")or die("Cannot find events! " . @mysql_error());
while ($row = @mysql_fetch_array($result)) :
echo $row[date] . ": ".$row[message]."
";
$msg_flag = 1;
endwhile;
if (!$msg_flag) {
echo "No show events.";
}
} else {
echo "You may not view others' show events.";
} */
echo "
|
";
if ($my_admin == 5 && $player_id != $account_id && $my_admin != 0) {
echo "
| EC Options |
|---|
View Linked Accounts
";
}
if ($my_admin <= 2 && $player_id != $account_id && $my_admin != 0) {
echo "
| Moderating Options |
|---|
View Linked Accounts
";
if ($my_admin == 1) {
echo "View Messages
";
}
echo "
Boot Player
";
echo nl2br(stripcslashes($mod_notes));
echo "
Punishment Log
";
$count = 0;
$result = @mysqli_query($mysqli_link, "SELECT `mod`, against_id, operation, punishment_id, amount, date, reason, detailed_reason FROM mod_log WHERE against_id='$account_id' ORDER BY punishment_id DESC")or die("Cannot find punishments! " . @mysqli_error($mysqli_link));
while ($row = @mysqli_fetch_array($result)) :
$mod_id = $row['mod'];
$against_id = $row['against_id'];
$operation = $row['operation'];
$punishment_id = $row['punishment_id'];
$amount = $row['amount'];
$reason = $row['reason'];
$detailed_reason = $row['detailed_reason'];
$date = $row['date'];
$count++;
if ($count > 1) {
echo "
| ";
}
if ($my_admin == 1) {
echo "REVERSE PUNISHMENT: Reverse it now
$operation ($amount on $date)
Reason displayed to player: $reason
Report: $detailed_reason
Done by $mod_id | ";
} else {
echo "$operation ($amount on $date)
Reason displayed to player: $reason
Report: $detailed_reason
Done by $mod_id | ";
}
endwhile;
if (!$against_id) {
echo "| No punishments. | ";
}
echo "
|
";
}
if ($player_id == $account_id) {
echo "
|
| Settings |
|---|
If you are a basic player and wish to be able to have a layout, please message an Admin to get your account whitelisted! Accounts must be at least 14 days old.
If you are a returning player whose account has become a basic in your absence, do NOT reset your Stable/Kennel description before doing this!
Reset Stable and Kennel Description?
";
}
echo " | ";
echo <<
function openTab(evt, tabName) {
// Declare all variables
var i, tabcontent, tablinks;
// Get all elements with class="tabcontent" and hide them
tabcontent = document.getElementsByClassName("tabcontent");
for (i = 0; i < tabcontent.length; i++) {
tabcontent[i].style.display = "none";
}
// Get all elements with class="tablinks" and remove the class "active"
tablinks = document.getElementsByClassName("tablinks");
for (i = 0; i < tablinks.length; i++) {
tablinks[i].className = tablinks[i].className.replace(" active", "");
}
// Show the current tab, and add an "active" class to the link that opened the tab
document.getElementById(tabName).style.display = "block";
evt.currentTarget.className += " active";
}
// Get the element with id="defaultOpen" and click on it
document.getElementById("defaultOpen").click();
JS;
include('inc/firstgamefooter.php'); |
";
} elseif ($mod == 1) {
$mod = "
";
} elseif ($mod == 5) {
$mod = "
";
} else {
$mod = "
";
}
} else {
$mod = "";
}
if ($sopen) {
$spublic = "Public: $$sfee/week";
} else {
$spublic = "Private";
}
if ($kopen) {
$kpublic = "Public: $$kfee/week";
} else {
$kpublic = "Private";
}
if ($htickets_public) {
$htickets = "$htix ($$hticket_fee/ea)";
} else {
$htickets = "Private";
}
if ($dtickets_public) {
$dtickets = "$dtix ($$dticket_fee/ea)";
} else {
$dtickets = "Private";
}
if ($avatar) {
$avatar = "
";
}
echo "