Example #1
0
 public function send()
 {
     if (Config::db('profiling')) {
         $profile = View::create('profile', array('profile' => DB::profile()))->render();
         $this->output = preg_replace('#</body>#', $profile . '</body>', $this->output);
     }
     return parent::send();
 }
Example #2
0
 function __construct()
 {
     $config = Config::db();
     $this->host = $config['host'];
     $this->database = $config['database'];
     $this->username = $config['username'];
     $this->password = $config['password'];
 }
Example #3
0
 public static function getDb()
 {
     if (self::$db == null) {
         $dbName = PREFIX;
         $mongo = new Mongo();
         self::$db = $mongo->{$dbName};
     }
     return self::$db;
 }
Example #4
0
 public static function table($name = null)
 {
     if (is_null(static::$prefix)) {
         static::$prefix = Config::db('prefix', '');
     }
     if (!is_null($name)) {
         return static::$prefix . $name;
     }
     return static::$prefix . static::$table;
 }
 /**
     Returns the memoized database connection or creates a new one..
 */
 public static function getDB()
 {
     if (self::$db === null) {
         $config = self::$config['database'];
         $db = new mysqli($config['server'], $config['user'], $config['pass'], $config['db']);
         $db->set_charset('utf8');
         self::$db = $db;
     }
     return self::$db;
 }
 public function actionIndex()
 {
     if (Yii::app()->user->isGuest) {
         $this->redirect(Yii::app()->homeUrl);
     }
     $this->pageTitle = Yii::t('title', 'Character list');
     $criteria = new CDbCriteria();
     $criteria->select = 'name, account_id, account_name, exp, race, player_class, creation_date';
     $criteria->join = 'INNER JOIN ' . Config::db('db') . '.log_referals ON (log_referals.slave_id = t.account_id AND log_referals.master_id = "' . Yii::app()->user->id . '" AND status = "unpaid")';
     $referals = Players::model()->findAll($criteria);
     $form = new LogReferals();
     if (isset($_POST['LogReferals'])) {
         $form->attributes = $_POST['LogReferals'];
         $check_isset = LogReferals::model()->count('master_id = ' . Yii::app()->user->id . ' AND slave_id = ' . $form->slave_id . ' AND status = "unpaid"');
         if ($check_isset != 1) {
             Yii::app()->user->setFlash('message', '<div class="flash_error">' . Yii::t('pers', 'You have no referrŠ°ls.') . '</div>');
             $this->refresh();
         }
         $master = AccountData::model()->find('id = ' . Yii::app()->user->id);
         $check_ip = AccountData::model()->count('id = ' . $form->slave_id . ' AND last_ip = "' . $master->last_ip . '"');
         if ($check_ip != 0) {
             $log = LogReferals::model()->find('master_id = ' . Yii::app()->user->id . ' AND slave_id = ' . $form->slave_id . ' AND status = "unpaid"');
             $log->status = 'blocked';
             $log->update(false);
             Yii::app()->user->setFlash('message', '<div class="flash_error">' . Yii::t('pers', 'You have no referrŠ°ls.') . '</div>');
             $this->refresh();
         }
         $criteria = new CDbCriteria();
         $criteria->select = 'exp';
         $criteria->condition = 'account_id = ' . $form->slave_id;
         $criteria->order = 'exp DESC';
         $criteria->limit = 1;
         $check_lvl = Players::model()->find($criteria);
         if (Info::lvl($check_lvl->exp) < Config::get('referal_level')) {
             Yii::app()->user->setFlash('message', '<div class="flash_error">' . Yii::t('pers', 'Less than the minimum level.') . '</div>');
             $this->refresh();
         }
         $criteria = new CDbCriteria();
         $criteria->condition = 'id = ' . Yii::app()->user->id;
         $money = AccountData::model()->find($criteria);
         $money[Yii::app()->params->money] = $money[Yii::app()->params->money] + Config::get('referal_bonus');
         $money->save();
         $criteria = new CDbCriteria();
         $criteria->condition = 'id = ' . $form->slave_id;
         $money = AccountData::model()->find($criteria);
         $money[Yii::app()->params->money] = $money[Yii::app()->params->money] + Config::get('referal_bonus_ref');
         $money->save();
         $log = LogReferals::model()->find('master_id = ' . Yii::app()->user->id . ' AND slave_id = ' . $form->slave_id . ' AND status = "unpaid"');
         $log->status = 'complete';
         $log->update(false);
         Yii::app()->user->setFlash('message', '<div class="flash_success">' . Yii::t('pers', 'Bonus credit applied!') . '</div>');
         $this->refresh();
     }
     $this->render('/pers', array('model' => Players::getPlayers(), 'referals' => $referals));
 }
Example #7
0
/**
 * Returns an array of ids for posts that have the specified tag
 *
 * @param string
 * @return array
 */
function get_posts_with_tag($tag)
{
    $tag_ext = Extend::where('key', '=', 'post_tags')->get();
    $tag_id = $tag_ext[0]->id;
    $prefix = Config::db('prefix', '');
    $posts = array();
    foreach (Query::table($prefix . 'post_meta')->where('extend', '=', $tag_id)->where('data', 'LIKE', '%' . $tag . '%')->get() as $meta) {
        $posts[] = $meta->post;
    }
    return array_unique($posts);
}
Example #8
0
 public function has_table($table)
 {
     $default = Config::db('default');
     $db = Config::db('connections.' . $default . '.database');
     $sql = 'SHOW TABLES FROM `' . $db . '`';
     list($result, $statement) = DB::ask($sql);
     $statement->setFetchMode(PDO::FETCH_NUM);
     $tables = array();
     foreach ($statement->fetchAll() as $row) {
         $tables[] = $row[0];
     }
     return in_array($table, $tables);
 }
Example #9
0
 public function run()
 {
     if (Yii::app()->getController()->id == 'news' && Yii::app()->getController()->action->id == 'index') {
         $criteria = new CDbCriteria();
         $criteria->select = 'name, exp, gender, race, player_class, online';
         $criteria->condition = 'exp > 100';
         $criteria->order = 'weekly_kill DESC, all_kill DESC, ap DESC, gp DESC';
         $criteria->join = 'INNER JOIN ' . Config::db('ls') . '.account_data ON (account_data.id=t.account_id AND account_data.access_level < ' . Config::get('hide_top') . ')';
         $criteria->limit = 10;
         $model = Players::model()->with('abyssRank')->findAll($criteria);
         $this->render('widgetPvp', array('model' => $model));
     }
 }
Example #10
0
 public function actionOnline()
 {
     $this->pageTitle = Yii::t('title', 'Players online');
     $criteria = new CDbCriteria();
     $criteria->select = 'name, account_id, exp, gender, race, player_class, world_id, show_location';
     $criteria->condition = 'online = 1';
     $criteria->order = 'exp DESC, ap DESC';
     $criteria->join = 'INNER JOIN ' . Config::db('ls') . '.account_data ON (account_data.id=t.account_id AND account_data.access_level < ' . Config::get('hide_top') . ')';
     $pages = new CPagination(Players::model()->count($criteria));
     $pages->pageSize = Config::get('page_top');
     $pages->applyLimit($criteria);
     $model = Players::model()->with('abyssRank')->findAll($criteria);
     $this->render('online', array('model' => $model, 'pages' => $pages));
 }
Example #11
0
 public function run()
 {
     // Binder do banco
     $this->db = new Database();
     global $db;
     $db = $this->db;
     $this->dbo = new DatabaseOld();
     global $dbo;
     $dbo = $this->dbo;
     // Binder dos configs
     $this->config = (object) array('db' => Config::db(), 'email' => Config::email());
     // Binder do request
     Request::build();
     // Binder do router
     $this->router = new Router();
 }
Example #12
0
 static function addToIndex($id)
 {
     $indexThese = array('title', 'creator', 'subject', 'publisher', 'contributor', 'identifier', 's:subtitle', 's:isbn', 's:tag');
     $prefix = Config::db('prefix', '');
     $title = Input::get('title');
     $input = Input::get('extend.metadata_wtf');
     $metadata = self::parse_wtf($input);
     if (empty($metadata['.']['title'])) {
         $metadata['.']['title'][] = $title;
     }
     $query = Query::table($prefix . 'wtfsearch')->where('post_id', '=', $id);
     $query->delete();
     foreach ($metadata['.'] as $k => $vals) {
         if (in_array($k, $indexThese)) {
             foreach ($vals as $val) {
                 $query->insert(array('post_id' => $id, 'meta_key' => $k, 'meta_value' => normalize($val)));
             }
         }
     }
     //var_dump($prefix, $metadata, $id);
     //die;
 }
/**
 * Returns an array of unique tags that exist on post given post,
 * empty array if no tags are found.
 *
 * @return array
 */
function get_tags_for_post($post_id)
{
    $tag_ext = Extend::where('key', '=', 'post_tags')->where('type', '=', 'post')->get();
    $tag_id = $tag_ext[0]->id;
    $prefix = Config::db('prefix', '');
    $tags = array();
    $index = 0;
    $meta = Query::table($prefix . 'post_meta')->left_join('posts', 'posts.id', '=', 'post_meta.post')->where('posts.status', '=', 'published')->where('extend', '=', $tag_id)->where('post', '=', $post_id)->get();
    $post_meta = json_decode($meta[0]->data);
    if (!trim($post_meta->text) == "") {
        foreach (explode(",", $post_meta->text) as $tag_text) {
            $tags[$index] = trim($tag_text);
            $index += 1;
        }
    }
    return array_unique($tags);
}
Example #14
0
<?php

use Illuminate\Database\Capsule\Manager as Capsule;
$capsule = new Capsule();
$capsule->addConnection(\Config::db());
$capsule->setAsGlobal();
$capsule->bootEloquent();
Example #15
0
 public function tableName()
 {
     return Config::db('db') . '.news';
 }
Example #16
0
 public function tableInfo($str, $column)
 {
     $query = "select * from information_schema.columns \nwhere table = '" . Config::db()->dbname . "' TABLE_NAME = '" . $str . "' \nAND COLUMN_NAME = '" . $column . "_id'";
     $table = $this->query($query);
     return count($table) > 0;
 }
Example #17
0
 public function tableName()
 {
     return Config::db('gs') . '.abyss_rank';
 }
Example #18
0
 public function tableName()
 {
     return Config::db('gs') . '.droplist';
 }
Example #19
0
 private static function makePrimary()
 {
     $envdb = getenv('DATABASE_URL');
     $dbopts = parse_url($envdb);
     $connstr = $envdb ? 'pgsql:dbname=' . ltrim($dbopts['path'], '/') . ';host=' . $dbopts['host'] : Config::db('connstr');
     $user = $envdb ? $dbopts['user'] : Config::db('user');
     $pass = $envdb ? $dbopts['pass'] : Config::db('pass');
     $db = new PDO($connstr, $user, $pass);
     $db->setAttribute(PDO::ATTR_ERRMODE, PDO::ERRMODE_EXCEPTION);
     static::add('primary', $db);
 }
 public function tableName()
 {
     return Config::db('gs') . '.siege_locations';
 }
Example #21
0
 public function tableName()
 {
     return Config::db('db') . '.log_referals';
 }
Example #22
0
 public function tableName()
 {
     return Config::db('gs') . '.broker';
 }
Example #23
0
 public function tableName()
 {
     return Config::db('gs') . '.player_quests';
 }
Example #24
0
 public function tableName()
 {
     return Config::db('gs') . '.legions';
 }
Example #25
0
 public function tableName()
 {
     return Config::db('ls') . '.account_data';
 }
 public function actionSettings()
 {
     if (Yii::app()->user->isGuest) {
         $this->redirect(Yii::app()->homeUrl);
     }
     $this->pageTitle = Yii::t('title', 'Account settings');
     $model = AccountData::model()->findByPk(Yii::app()->user->id);
     $model->scenario = 'edit';
     $form2 = Players::model()->findAll('account_id = ' . Yii::app()->user->id);
     if (isset($_POST['AccountData'])) {
         $model->attributes = $_POST['AccountData'];
         if ($this->hashPassword($model->current_password) == $model->password) {
             if (!empty($model->new_password)) {
                 $model->password = $this->hashPassword($model->new_password);
             }
             if ($model->save()) {
                 Yii::app()->user->setFlash('message', '<div class="flash_success">' . Yii::t('main', 'Settings modified!') . '</div>');
                 $this->refresh();
             }
         } else {
             Yii::app()->user->setFlash('message', '<div class="flash_error">' . Yii::t('account', 'Incorrect password!') . '</div>');
             $this->refresh();
         }
     }
     if (isset($_POST['Players'])) {
         $clear = Yii::app()->db->createCommand('UPDATE ' . Config::db('gs') . '.players SET show_location = 0, show_inventory = 0 WHERE account_id = ' . Yii::app()->user->id);
         $clear->execute();
         if (isset($_POST['Players']['show_location'])) {
             $command = Yii::app()->db->createCommand('UPDATE ' . Config::db('gs') . '.players SET show_location = 1 WHERE id=:id');
             foreach ($_POST['Players']['show_location'] as $key => $value) {
                 $command->execute(array(':id' => $key));
             }
         }
         if (isset($_POST['Players']['show_inventory'])) {
             $command = Yii::app()->db->createCommand('UPDATE ' . Config::db('gs') . '.players SET show_inventory = 1 WHERE id=:id');
             foreach ($_POST['Players']['show_inventory'] as $key => $value) {
                 $command->execute(array(':id' => $key));
             }
         }
         Yii::app()->user->setFlash('message2', '<div class="flash_success">' . Yii::t('main', 'Settings modified!') . '</div>');
         $this->refresh();
     }
     $this->render('settings', array('form' => $model, 'form2' => $form2));
 }