public function init() { parent::init(); $this->user = Yii::app()->session['user']; $this->_table = 'users'; $this->db = EduDataBase::getConnection(); $this->layout = null; }
public function init() { parent::init(); $this->user = Yii::app()->session['advertiser']; $this->_table = 'users'; $this->db = EduDataBase::getConnection(); $this->layout = null; Yii::import('application.models.advertiser.*'); }
public function emailUnique() { $db = EduDataBase::getConnection(); $query = "SELECT * FROM {{users}} WHERE email = :email"; $values = array(':email' => $this->email); $recored = $db->createCommand($query)->bindValues($values)->queryRow(); if (!empty($recored)) { $this->addError('email', 'Email "' . $this->email . '" đã tồn tại rồi'); } }
public function init() { parent::init(); // if ($_SERVER['HTTP_HOST'] == 'techz24.com' || $_SERVER['HTTP_HOST'] == 'www.techz24.com') { // $user = Yii::app()->session['user']; // $ip = ip_address(); // if (empty($user) && $ip != '118.71.87.162') { // echo '<meta name="robots" content="noindex, nofollow">'; // die('Comming soon...'); // } // } $this->db = EduDataBase::getConnection(); }
public function ruleUnique() { $action = Yii::app()->controller->action->id; $db = EduDataBase::getConnection(); $query = "SELECT * FROM {{rule}} WHERE rule = :rule"; if ($action == 'edit') { $query .= " AND id <> " . $_GET['id']; } $values = array(':rule' => $this->rule); $recored = $db->createCommand($query)->bindValues($values)->queryRow(); if (!empty($recored)) { $this->addError('rule', 'Nhóm "' . $this->rule . '" đã tồn tại rồi'); } }
private function searchVideo($args) { //ini_set('memory_limit', '-1'); $db2 = EduDataBase::getConnection('db2'); if (isset($args[1])) { $query = "SELECT * FROM {{video_search}} WHERE is_run = 0 ORDER BY id " . $args[1] . " LIMIT 1"; } else { $query = "SELECT * FROM {{video_search}} WHERE is_run = 0 LIMIT 1"; } $row = $db2->createCommand($query)->queryRow(); if (empty($row)) { die('Het du lieu roi'); } $query = "SELECT * FROM {{video_source}}"; $list = $db2->createCommand($query)->queryAll(); $list_source = array(); $search_result = array(); $total_source = 0; $count_run = 0; echo "Tim kiem video: " . $row['keywords'] . "\n"; foreach ($list as $item) { //`video_search_id`, `source_id`, `html_data` $result = $this->findVideo($item, $row); if ($result == false) { continue; } $have_data = $result['have_data']; unset($result['have_data']); yii_insert_row('source_html', $result, 'db2', true); if ($have_data == 1) { $total_source++; } $count_run++; $search_result[$item['id']] = $have_data; } //`search_result`, `total_source`, `is_run` $update = "UPDATE {{video_search}} SET count_run = :count_run, search_result = :search_result, total_source = :total_source, is_run = :is_run WHERE id = :id"; $values = array(':search_result' => json_encode($search_result), ':total_source' => $total_source, ':is_run' => 1, ':count_run' => $count_run, ':id' => $row['id']); $db2->createCommand($update)->bindValues($values)->execute(); echo "Done\n\n"; sleep(1); echo "------------------------------------------------\n"; echo "Chay them lan nua\n"; echo "------------------------------------------------\n"; $args[0] = 'search'; $this->run($args); }
public function init() { parent::init(); $this->db = EduDataBase::getConnection(); $this->user = Yii::app()->session['advertiser']; if (empty($this->user)) { $query_string = '?dest=' . base64_encode($_SERVER['REQUEST_URI']); $redirect = '/advertiser/login/index' . $query_string; $this->redirect($redirect); } //chon ngon ngu cho site // $lang = 'vi'; // Yii::app()->sourceLanguage = '00'; // Yii::app()->language = $lang; Yii::import('application.models.advertiser.*'); Yii::app()->setSystemViewPath(ROOT_PATH . '/protected/views/system'); }
private function zipLanguageData($lang_id) { $query = "SELECT * FROM {{languages}} WHERE id = " . $lang_id; $db_global = EduDataBase::getConnection('db_global'); $language = $db_global->createCommand($query)->queryRow(); if (empty($language)) { echo "Khong ton tai ngon ngu voi id = " . $lang_id . "\n"; die; } $font_version = $language['font_version']; $audio_version = $language['audio_version']; //kiem tra neu co file cu thi xoa di $zip_filename = 'language_' . $lang_id . '.zip'; $file_zip = PRIVATE_TMP_PATH . '/' . $zip_filename; if (file_exists($file_zip)) { @unlink($file_zip); } $zip = new ZipArchive(); $zip->open($file_zip, ZipArchive::CREATE); //copy game audio $game_audio_path = GAME_AUDIO_PATH . '/' . $lang_id . '/' . $audio_version; if (is_dir($game_audio_path)) { $paths = array(); $dir = new DirectoryIterator($game_audio_path); foreach ($dir as $fileinfo) { if (!$fileinfo->isDot() && $fileinfo->isFile()) { $file = $game_audio_path . '/' . $fileinfo->getFilename(); $key = str_replace(GAME_AUDIO_PATH . '/', '', $file); $paths[$key] = $file; } } if (!empty($paths)) { foreach ($paths as $localname => $filename) { $zip->addFile($filename, 'gameaudio/' . $localname); } } echo "Copy xong game audio\n"; } $fonts_path = FONT_PATH . '/' . $lang_id . '/' . $font_version; if (is_dir($fonts_path)) { $paths = array(); $dir = new DirectoryIterator($fonts_path); foreach ($dir as $fileinfo) { if (!$fileinfo->isDot() && $fileinfo->isFile()) { $file = $fonts_path . '/' . $fileinfo->getFilename(); $key = str_replace(FONT_PATH . '/', '', $file); $paths[$key] = $file; } } if (!empty($paths)) { foreach ($paths as $localname => $filename) { $zip->addFile($filename, 'fonts/' . $localname); } } echo "Copy xong fonts\n"; } $zip->close(); echo "Tao file zip: " . $file_zip . " thanh cong\n"; }
public function init() { parent::init(); $this->db = EduDataBase::getConnection(); $this->_controller = Yii::app()->getController(); }
private function PushAndroid() { $os_type = 2; $db = EduDataBase::getConnection('db_global'); $query = "SELECT * FROM {{push_queue}} WHERE is_push = 0 AND os = " . $os_type; $row = $db->createCommand($query)->queryRow(); if (empty($row)) { die("Da het push queue\n"); } $push_queue_id = $row['id']; $registrationIds = array($row['device_token']); $msg = array('payload' => array('aps' => array('body' => 'Edu push', 'alert' => $row['message']), 'some_extra_key' => '+1')); $fields = array('registration_ids' => $registrationIds, 'data' => $msg); $appInfo = $this->getAppInfo($row['app_id']); $headers = array('Authorization: key=' . $appInfo['api_access_key'], 'Content-Type: application/json'); $ch = curl_init(); curl_setopt($ch, CURLOPT_URL, 'https://android.googleapis.com/gcm/send'); curl_setopt($ch, CURLOPT_POST, true); curl_setopt($ch, CURLOPT_HTTPHEADER, $headers); curl_setopt($ch, CURLOPT_RETURNTRANSFER, true); curl_setopt($ch, CURLOPT_SSL_VERIFYPEER, false); curl_setopt($ch, CURLOPT_POSTFIELDS, json_encode($fields)); $result = curl_exec($ch); curl_close($ch); var_dump($result); echo "\n"; $info = json_decode($result, true); if ($info['failure'] == 1) { $query = "UPDATE {{push}} SET uninstall = 1 WHERE device_token = :device_token"; $values = array(':device_token' => $row['device_token']); $db_device = EduDataBase::getConnection('db_device'); $db_device->createCommand($query)->bindValues($values)->execute(); } $query = "UPDATE {{push_queue}} SET is_push = 1 WHERE id = " . $push_queue_id; $db->createCommand($query)->execute(); sleep(1); $args[0] = 'android'; $this->run($args); }
function yii_update_row($table, $params, $condition = '1', $db = 'db') { if (empty($table)) { throw new Exception('Vui long nhap ten bang'); } if (empty($params)) { throw new Exception('Vui long nhap du lieu de thuc thi cau lenh update'); } $fields = array_keys($params); $query = "UPDATE {{" . $table . "}} SET "; $tags = array(); foreach ($fields as $field) { $tags[] = '`' . $field . '`' . ' = :' . $field; } $query .= implode(', ', $tags) . " WHERE " . $condition; $database = EduDataBase::getConnection($db); $values = array(); foreach ($params as $key => $vl) { $values[':' . $key] = trim($vl); } return $database->createCommand($query)->bindValues($values)->execute(); }
public function init() { parent::init(); $this->db = EduDataBase::getConnection(); $this->db_crawler = EduDataBase::getConnection('db_crawler'); }