public static function getMilestones()
{
$getMilestones = TPP::db()->query("SELECT `id`, `name`, `time` FROM `milestone` WHERE `visible` = 1 ORDER BY `time`") or die(TPP::db()->error);
while ($mile = $getMilestones->fetch_assoc()) {
$newMilestone = new self();
$newMilestone->setAttributes($mile);
$newMilestone->time = FuncHelp::getDateTime($newMilestone->time);
$return[] = $newMilestone;
}
return $return;
}
public static function getPokemon($where = null, $order = null, $limit = null)
{
if (!is_null($where)) {
$where = ' WHERE ' . $where;
}
if (!is_null($order)) {
$order = ' ORDER BY ' . $order;
}
if (!is_null($limit)) {
$limit = ' LIMIT ' . $limit;
}
$getPokemon = TPP::db()->query("SELECT\r\n\t\t\tp.`id`, p.`pokemon`, p.`name`, p.`level`, p.`nickname`, p.`gender`, p.`hold_item`, p.`status`, p.`box_id`, p.`poke_ball`, p.`comment`,\r\n\t\t\tGROUP_CONCAT(DISTINCT m.`name` SEPARATOR ',') as `moves`,\r\n\t\t\ts.`status` as `status_name`\r\n\t\t\tFROM `pokemon` p\r\n\t\t\tLEFT JOIN `move` m\r\n\t\t\tON m.`pokemon` = p.`id`\r\n\t\t\tJOIN `status` s\r\n\t\t\tON s.`id` = p.`status`\r\n\t\t\t" . $where . " GROUP BY p.`id`" . $order . $limit) or die(TPP::db()->error);
while ($pok = $getPokemon->fetch_assoc()) {
$newPokemon = new self();
$newPokemon->setAttributes(array('id' => $pok['id'], 'name' => $newPokemon->setName($pok['name'], $pok['pokemon']), 'pokemon' => $newPokemon->setPokemon($pok['pokemon']), 'level' => $newPokemon->setLevel($pok['level']), 'nickname' => $newPokemon->setNickname($pok['nickname']), 'poke_ball' => $newPokemon->setPokeBall($pok['poke_ball']), 'gender' => $newPokemon->setGender($pok['gender']), 'hold_item' => $newPokemon->setHoldItem($pok['hold_item']), 'status' => $pok['status_name'], 'comment' => FuncHelp::getDateTime($pok['comment']), 'moves' => $newPokemon->setMoves($pok['moves'])));
$newPokemon->setAttributes($newPokemon->getFields());
$return[] = $newPokemon;
}
return $return;
}
<div class="tpp-app tpp-app-header">
<div class="page-header">
<h1>
<a href="http://www.twitch.tv/twitchplayspokemon"><!--
--><strong><i class="fa fa-external-link"></i>Twitch Plays Pokémon</strong><!--
--></a><!--
--><a href="" class="pop-out btn btn-danger btn-xs"><i class="fa fa-expand"></i>Pop out</a>
<span class="pull-right last-update">Last update: <?php
echo FuncHelp::getDateTime($general->last_update);
?>
</span>
</h1><?php
if (!empty($messages)) {
$this->render('general/_messages', array('messages' => $messages));
}
?>
<div class="pull-left current-status">
<p>Current Goal: <strong><?php
echo utf8_decode($general->current_goal);
?>
</strong></p>
<p>Optional Goal: <strong><?php
echo !empty($general->optional_goal) ? utf8_decode($general->optional_goal) : '-';
?>
</strong></p>
<p>Current Location: <strong><?php
echo utf8_decode($general->current_location);
?>
<tr><?php
foreach ($badges as $b) {
?>
<td><?php
echo isset($b->time) ? FuncHelp::getDateTime($b->time) : '<em>Not yet</em>';
?>
</td><?php
}
?>
</tr>
