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 []; }