public static function getMilestones()
{
$getMilestones = TPP::db()->query("SELECT `id`, `name`, `time` FROM `milestone` WHERE `visible` = 1 ORDER BY `time`");
$return = [];
if ($getMilestones) {
while ($mile = $getMilestones->fetch()) {
$newMilestone = new self();
$newMilestone->setAttributes($mile);
$newMilestone->time = Helper::getDateTime($newMilestone->time);
$return[] = $newMilestone;
}
}
return $return;
}
/**
* getCredits: Return all credits
* @return array Array of all Credit objects
*/
public static function getCredits()
{
self::prepareGenerations();
$getCredits = TPP::db()->query("\n\t\t\tSELECT `id`, `name`, `title`, `pokemon`, `quote`, `gen_flags`, `link`\n\t\t\tFROM `credits`\n\t\t\tWHERE `order_id` > 0\n\t\t\tAND `visible` = 1\n\t\t\tORDER BY `order_id`, `id`\n\t\t");
$return = [];
if ($getCredits) {
while ($credit = $getCredits->fetch()) {
$newCredit = new self();
$newCredit->setAttributes($credit);
$newCredit->quote = self::getQuote($newCredit->quote);
$newCredit->generations = self::getGenerations((int) $newCredit->gen_flags);
$return[] = $newCredit;
}
}
return $return;
}
public function getFields()
{
$fields = [];
$getFields = TPP::db()->query("\n\t\tSELECT\n\t\t\tf.`name`,\n\t\t\tpfe.`pokemon_id`,\n\t\t\tpfe.`value`\n\t\tFROM\n\t\t\t`pokemon_field_eav` pfe,\n\t\t\t`field` f\n\t\tWHERE\n\t\t\tpfe.`pokemon_id` = {$this->id}\n\t\tAND\n\t\t\tpfe.`field_id` = f.`id`");
while ($fi = $getFields->fetch()) {
$fields[$fi['name']] = $fi['value'];
}
if (isset($fields['next_move'])) {
$move = new Move();
$move->name = $fields['next_move'];
unset($fields['next_move']);
if (isset($fields['next_move_level'])) {
$move->level = $fields['next_move_level'];
unset($fields['next_move_level']);
}
$fields['next_move'] = $move;
}
return $fields;
}
<?php
use TPP\Models\TPP;
define('TPP_DEBUG', false);
require "vendor/autoload.php";
require "models/Init.php";
new Init();
TPP::initializeConnection();
return ['paths' => ['migrations' => 'db/migrations', 'seeds' => 'db/seeds'], 'environments' => ['default_migration_table' => 'migrations', 'default_database' => 'development', 'development' => ['name' => DB_DATABASE . TWITCHVERSION, 'connection' => TPP::db()]]];
/**
* @return array
*/
public function getMessages()
{
$getMessages = TPP::db()->prepare("\r\n SELECT m.`id`, m.`message`, m.`sent_user`, s.`suggestion`\r\n FROM `message` m\r\n LEFT JOIN `suggestion` s ON m.`suggestion_id` = s.`id`\r\n WHERE m.`read` = 0 AND m.`ip` = :ip\r\n ORDER BY `date_created` ASC\r\n LIMIT 1") or die(TPP::db()->error);
$getMessages->execute([':ip' => $_SERVER['REMOTE_ADDR']]);
if ($getMessages->rowCount() > 0) {
while ($m = $getMessages->fetch()) {
$return = ['message' => $m['message'], 'id' => $m['id'], 'sentUser' => $m['sent_user'], 'suggestion' => $m['suggestion']];
}
return $return;
}
return [];
}
