/**
* Connects to the DB, gets the data from DB
* and creates an array of users which were stored in DB
* @param nothing
* @return true, if the array containing users was created, false if an error appeared
*/
public function generateArray()
{
try {
$userArr = DB::getInstance()->getAllUsers();
// Connect to DB and get users
foreach ($userArr as $oneUser) {
// For each row that represents one user
$user = new User();
$x = 0;
// Counter
foreach ($oneUser as $userData) {
// Set user data. Each cell in the row represents user's data
if ($x == 1) {
$user->setUsername($userData);
} elseif ($x == 2) {
$user->setPassword($userData);
}
$x++;
}
$this->add($user);
}
return true;
} catch (Exception $e) {
// Catch exception
$this->errorMsg = $e->getMessage();
// Get error message
return false;
}
}
public static function run_json($sql)
{
$result = parent::getInstance()->getConnection()->query($sql);
// reset json response
JSON::$response = array();
// If query failed, return `false`
if ($result === FALSE) {
JSON::$response[] = array("sql" => "nok");
return;
}
if ($result === TRUE) {
JSON::$response[] = array("sql" => "ok");
return;
}
// reset json response
JSON::$response = array();
// If query was successful, retrieve all the rows into an array or True
JSON::$response[] = array("sql" => "ok");
$rows = array();
while ($row = $result->fetch_assoc()) {
// echoing JSON response
JSON::$response[] = $row;
}
return;
}
/**
* @brief Execute update
**/
function moduleUpdate()
{
$oDB =& DB::getInstance();
$oModuleModel =& getModel('module');
$oModuleController =& getController('module');
return new Object(0, 'success_updated');
}
/**
* @brief 업데이트 실행
**/
function moduleUpdate()
{
$oModuleModel = getModel('module');
$oModuleController = getController('module');
$oDB = DB::getInstance();
// 트리거 일괄 추가
foreach ($this->add_triggers as $trigger) {
if (!$oModuleModel->getTrigger($trigger[0], $trigger[1], $trigger[2], $trigger[3], $trigger[4])) {
$oModuleController->insertTrigger($trigger[0], $trigger[1], $trigger[2], $trigger[3], $trigger[4]);
}
}
if (!$oDB->isColumnExists('alliance_sites', 'title')) {
$oDB->addColumn('alliance_sites', 'title', 'varchar', 250, '', true);
$oDB->addIndex('alliance_sites', 'unique_title', 'title', true);
}
if (!$oDB->isColumnExists('alliance_logs', 'type')) {
$oDB->addColumn('alliance_logs', 'type', 'char', 20, '', true);
}
if (!$oDB->isColumnExists('alliance_contents', 'site_srl')) {
$oDB->addColumn('alliance_contents', 'site_srl', 'number', 11, 0, true);
$oDB->addIndex('alliance_contents', 'idx_site_srl', 'site_srl');
}
if (!$oDB->isColumnExists('alliance_messages', 'title')) {
$oDB->addColumn('alliance_messages', 'title', 'varchar', 250, '', true);
}
/* 2011.03.12 - 연합 정보 테이블의 count 칼럼 제거 */
if ($oDB->isColumnExists('alliance_info', 'count')) {
$oDB->dropColumn('alliance_info', 'count');
}
return new Object(0, 'success_updated');
}
public function search($same, $keyword, $field)
{
$search = DB::getInstance()->query("SELECT * FROM suppliers WHERE {$same} = '{$keyword}'");
foreach ($search->results() as $s) {
return $s->{$field};
}
}
public static function count()
{
$sql = "SELECT count(*) as count FROM " . self::getTable();
$query = DB::getInstance()->prepare($sql);
$query->execute();
return $query->fetch()['count'];
}
/**
* Construct importer
* @param string $fileName relative to FRONTEND_PATH
*/
public function __construct($fileName)
{
$this->Reader = new BigFileReaderGZip($fileName);
$this->DB = DB::getInstance();
$this->AccountID = USER_MUST_LOGIN ? SessionAccountHandler::getId() : 0;
$this->Results = new RunalyzeJsonImporterResults();
}
public function __construct($page = null)
{
$this->_db = DB::getInstance();
//set default home page
$page = Input::get('page') ? Input::get('page') : Config::get('home');
$this->find($page);
}
/**
* @brief Execute update
**/
function moduleUpdate()
{
$oModuleModel =& getModel('module');
$oModuleController =& getController('module');
$oDB =& DB::getInstance();
// 2007. 10. 17 document.insertDocument, updateDocument, deleteDocument trigger property for
if (!$oModuleModel->getTrigger('document.insertDocument', 'tag', 'controller', 'triggerArrangeTag', 'before')) {
$oModuleController->insertTrigger('document.insertDocument', 'tag', 'controller', 'triggerArrangeTag', 'before');
}
if (!$oModuleModel->getTrigger('document.insertDocument', 'tag', 'controller', 'triggerInsertTag', 'after')) {
$oModuleController->insertTrigger('document.insertDocument', 'tag', 'controller', 'triggerInsertTag', 'after');
}
if (!$oModuleModel->getTrigger('document.updateDocument', 'tag', 'controller', 'triggerArrangeTag', 'before')) {
$oModuleController->insertTrigger('document.updateDocument', 'tag', 'controller', 'triggerArrangeTag', 'before');
}
if (!$oModuleModel->getTrigger('document.updateDocument', 'tag', 'controller', 'triggerInsertTag', 'after')) {
$oModuleController->insertTrigger('document.updateDocument', 'tag', 'controller', 'triggerInsertTag', 'after');
}
if (!$oModuleModel->getTrigger('document.deleteDocument', 'tag', 'controller', 'triggerDeleteTag', 'after')) {
$oModuleController->insertTrigger('document.deleteDocument', 'tag', 'controller', 'triggerDeleteTag', 'after');
}
// 2007. 10. 17 modules are deleted when you delete all registered triggers that add tag
if (!$oModuleModel->getTrigger('module.deleteModule', 'tag', 'controller', 'triggerDeleteModuleTags', 'after')) {
$oModuleController->insertTrigger('module.deleteModule', 'tag', 'controller', 'triggerDeleteModuleTags', 'after');
}
// tag in the index column of the table tag
if (!$oDB->isIndexExists("tags", "idx_tag")) {
$oDB->addIndex("tags", "idx_tag", array("document_srl", "tag"));
}
return new Object(0, 'success_updated');
}
public function clear($user_id)
{
$sql = "delete FROM cart where user_id = {$user_id}";
$db = DB::getInstance(Config::get('db.host'), Config::get('db.user'), Config::get('db.password'), Config::get('db.db_name'));
$res = $db->query($sql);
return true;
}
public function Authenticate($Username = false, $Password = false, $Remember = false)
{
if ($Username !== false && $Password !== false) {
//Confirm Input
$UserData = DB::getInstance()->table("Users")->where("Username", $Username)->get(1)[0];
$HashedPassAttempt = Hash::make(Input::get("Password"), $UserData->Salt);
if ($HashedPassAttempt == $UserData->Password) {
Session::put("UserID", $UserData->UserID);
if ($Remember == 'on') {
//Was Remember Me Checkbox ticked?
$hashCheck = DB::getInstance()->table("user_sessions")->where('user_id', $UserData->UserID)->get();
//Check for existing session
if (count($hashCheck) == 0) {
//If there is not an existing hash
$hash = Hash::unique();
DB::getInstance()->table('user_sessions')->insert(array('user_id' => $UserData->UserID, 'hash' => $hash));
} else {
//use existing hash if found
$hash = $hashCheck[0]->hash;
}
$Cookie = Cookie::put(Config::get("remember/cookie_name"), $hash, Config::get("remember/cookie_expiry"));
//Set cookie
}
return $this->form($UserData->UserID);
//Return User MetaTable
} else {
throw new Exception('Invalid Username or Password');
}
} else {
throw new Exception('Invalid Username or Password');
}
return false;
}
public static function saveProductCombinationSetting($id_product, $id_product_attribute, $display_button, $id_shop)
{
$id_giveit_product = DB::getInstance()->getValue('
SELECT `id_giveit_product`
FROM `' . _DB_PREFIX_ . self::$definition['table'] . '`
WHERE `id_product` = "' . (int) $id_product . '"
AND `id_product_attribute` = "' . (int) $id_product_attribute . '"
AND `id_shop` = "' . (int) $id_shop . '"
');
if ($display_button == '') {
return DB::getInstance()->Execute('
DELETE FROM `' . _DB_PREFIX_ . self::$definition['table'] . '`
WHERE `id_giveit_product` = "' . (int) $id_giveit_product . '"
');
}
if ($id_giveit_product) {
return DB::getInstance()->Execute('
UPDATE `' . _DB_PREFIX_ . self::$definition['table'] . '`
SET
`display_button` = "' . (int) $display_button . '"
WHERE `id_giveit_product` = "' . (int) $id_giveit_product . '"
');
}
return DB::getInstance()->Execute('
INSERT INTO `' . _DB_PREFIX_ . self::$definition['table'] . '`
(`id_product`, `id_product_attribute`, `display_button`, `id_shop`, `date_add`, `date_upd`)
VALUES
("' . (int) $id_product . '", "' . (int) $id_product_attribute . '", "' . (int) $display_button . '", "' . (int) $id_shop . '", "' . date('Y-m-d H:i:s') . '", "' . date('Y-m-d H:i:s') . '")
');
}
function GetChiefwhipByMunicipalityId($idMunicipality)
{
$sql = "SELECT DISTINCT\r\n\t\t\t\t\tanc_administrator.id_administrator AS 'id_chiefwhip',\r\n\t\t\t\t\tCONCAT(anc_administrator.first_name, ' ', anc_administrator.last_name) AS 'chiefwhip_name'\r\n\t\t\t\tFROM \r\n\t\t\t\t\tanc_administrator \r\n\t\t\t\tWHERE\r\n\t\t\t\t\tanc_administrator.id_municipality ='" . $idMunicipality . "' \r\n\t\t\t\tAND\r\n\t\t\t\t\tanc_administrator.id_administratortype='4' \r\n\t\t\t\tAND \r\n\t\t\t\t anc_administrator.administrator_status='1'";
//echo $sql; exit;
DB::getInstance()->query($querySuccess, $sql, $recordSet);
return $recordSet;
}
/**
* @brief 타임라인 게시판의 자식 게시판 등록
* @param int $module_srl
* @param array $target_srls
* @return object
*/
function insertAttachInfo($module_srl, $target_srls = array())
{
// 인자 유효성 검증
if (!($module_srl && is_numeric($module_srl))) {
return new Object(-1, 'msg_timeline_no_module_srl');
}
if (!is_array($target_srls)) {
return new Object(-1, 'msg_invalid_request');
}
$oDB = DB::getInstance();
$oDB->begin();
// DB에 남아 있는 자식 게시판 정보 삭제
$output = $this->deleteAttachInfo($module_srl);
if (!$output->toBool()) {
// DB 접근에 문제가 생겼을 경우 롤백
$oDB->rollback();
return $output;
}
$args = new stdClass();
$args->module_srl = $module_srl;
$args->priority = 0;
// 배열로 입력 받은 target_srl 값을 하나씩 등록
foreach ($target_srls as $target_srl) {
$args->target_srl = $target_srl;
$args->priority++;
$output = executeQuery('timeline.insertAttachInfo', $args);
if (!$output->toBool()) {
// DB 접근에 문제가 생겼을 경우 롤백
$oDB->rollback();
return $output;
}
}
$oDB->commit();
return new Object();
}
function Index()
{
echo '【DB类测试】<br />';
$db = DB::getInstance();
echo '1.查询 Cache 表 k 值为 plugins 的记录（单条）<br />记录信息：';
dump($db->table('cache')->field(array('k', 'v'))->where(array('k' => 'plugins'))->find());
echo '生成的SQL：' . $db->getLastSql() . '<br /><br />';
echo '2.查询 sign_log 表的全部记录并统计签到经验（多条）<br />记录信息：';
dump($db->table('sign_log')->field(array('SUM(exp)' => 'exp'))->group('uid')->select());
echo '生成的SQL：' . $db->getLastSql() . '<br /><br />';
echo '3.在 Cache 表插入一条记录<br />';
$data = array('k' => 'test', 'v' => 'test');
$flag = $db->table('cache')->insert($data);
echo '生成的SQL：' . $db->getLastSql() . '<br />影响条数：' . intval($flag) . '<br /><br />';
echo '4.在 Cache 表更新 k 值为 plugins 的记录<br />';
$data['v'] = "testnow";
$flag = $db->table('cache')->where(array('k' => 'test'))->update($data);
echo '生成的SQL：' . $db->getLastSql() . '<br />影响条数：' . intval($flag) . '<br /><br />';
echo '5.在 Cache 表删除 k 值为 plugins 的记录<br />';
$flag = $db->table('cache')->where(array('k' => 'test'))->delete();
echo '生成的SQL：' . $db->getLastSql() . '<br />影响条数：' . intval($flag) . '<br /><br />';
echo '6.在 sign_log 表查询 uid 值为 4 且 date 值为 20140517 的签到记录<br />';
dump($db->table(array('sign_log' => 'l'))->join(array('_table' => 'my_tieba', '_as' => 't', '_on' => 't.tid = l.tid', '_type' => 'LEFT JOIN'))->where(array('l.uid' => '4', 'l.date' => '20140517'))->order('l.uid DESC')->select());
echo '生成的SQL：' . $db->getLastSql() . '<br />影响条数：' . intval($flag) . '<br /><br />';
echo '用时' . (microtime(true) - START_TIME) * 1000 . '毫秒<br /><br />';
echo '【GET测试】<br />GET值：';
dump($_GET);
}
/**
* @brief 카운터 기록
**/
function procCounterExecute()
{
$oDB =& DB::getInstance();
$oDB->begin();
$site_module_info = Context::get('site_module_info');
$site_srl = (int) $site_module_info->site_srl;
// 로그를 검사
$oCounterModel =& getModel('counter');
// 오늘자 row가 있는지 체크하여 없으면 등록
if (!$oCounterModel->isInsertedTodayStatus($site_srl)) {
$this->insertTodayStatus(0, $site_srl);
// 기존 row가 있으면 사용자 체크
} else {
// 등록되어 있지 않은 아이피일 경우
if (!$oCounterModel->isLogged($site_srl)) {
// 로그 등록
$this->insertLog($site_srl);
// unique 및 pageview 등록
$this->insertUniqueVisitor($site_srl);
} else {
// pageview 등록
$this->insertPageView($site_srl);
}
}
$oDB->commit();
}
public function __construct()
{
/* Get all modules then select only payment ones*/
$modules = Module::getModulesOnDisk();
foreach ($modules as $module) {
if ($module->tab == 'Payment') {
if ($module->id) {
$module->country = array();
$countries = DB::getInstance()->ExecuteS('SELECT id_country FROM ' . _DB_PREFIX_ . 'module_country WHERE id_module = ' . intval($module->id));
foreach ($countries as $country) {
$module->country[] = $country['id_country'];
}
$module->currency = array();
$currencies = DB::getInstance()->ExecuteS('SELECT id_currency FROM ' . _DB_PREFIX_ . 'module_currency WHERE id_module = ' . intval($module->id));
foreach ($currencies as $currency) {
$module->currency[] = $currency['id_currency'];
}
$module->group = array();
$groups = DB::getInstance()->ExecuteS('SELECT id_group FROM ' . _DB_PREFIX_ . 'module_group WHERE id_module = ' . intval($module->id));
foreach ($groups as $group) {
$module->group[] = $group['id_group'];
}
} else {
$module->country = NULL;
$module->currency = NULL;
$module->group = NULL;
}
$this->paymentModules[] = $module;
}
}
parent::__construct();
}
/**
* Execute update
*
* @return Object
*/
function moduleUpdate()
{
$oDB = DB::getInstance();
if (!$oDB->isColumnExists("addons", "is_used_m")) {
$oDB->addColumn("addons", "is_used_m", "char", 1, "N", TRUE);
}
if (!$oDB->isColumnExists("addons_site", "is_used_m")) {
$oDB->addColumn("addons_site", "is_used_m", "char", 1, "N", TRUE);
}
// 2011. 7. 29. add is_fixed column
if (!$oDB->isColumnExists('addons', 'is_fixed')) {
$oDB->addColumn('addons', 'is_fixed', 'char', 1, 'N', TRUE);
// move addon info to addon_site table
$output = executeQueryArray('addon.getAddons');
if ($output->data) {
foreach ($output->data as $row) {
$args = new stdClass();
$args->site_srl = 0;
$args->addon = $row->addon;
$args->is_used = $row->is_used;
$args->is_used_m = $row->is_used_m;
$args->extra_vars = $row->extra_vars;
executeQuery('addon.insertSiteAddon', $args);
}
}
}
return new Object(0, 'success_updated');
}
public function __construct($user = NULL)
{
//get db instance
$this->_db = DB::getInstance();
//get session name, which is just 'user'. See init.php
$this->_sessionName = Config::get('session/session_name');
$this->_cookieName = Config::get('remember/cookie_name');
if (!$user) {
//if a user has NOT been defined
if (Session::exists($this->_sessionName)) {
$user = Session::get($this->_sessionName);
//check if user exists
if ($this->find($user)) {
//if there is a session and the user exists,
//signify they're logged in
$this->_isLoggedIn = true;
} else {
//process logout
}
}
} else {
//if a user HAS been defined
$this->find($user);
}
//end if
}
public function fetch()
{
$result = array();
try {
$stmt = DB::getInstance()->prepare("SELECT *\n\t\t\t\t\t\t\t\t\t\t\t\t\tFROM config\n\t\t\t\t\t\t\t\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t(id = :config_id OR :config_id=0) AND\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t(name = :name OR :name='') AND\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t(value = :value OR :value='') AND\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t(create_date = FROM_UNIXTIME(:create_date) OR :create_date=0) AND\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t(update_date = FROM_UNIXTIME(:update_date) OR :update_date=0)");
$stmt->bindParam(':config_id', $this->getConfigId(), PDO::PARAM_INT);
$stmt->bindParam(':name', $this->getName(), PDO::PARAM_STR);
$stmt->bindParam(':value', $this->getValue(), PDO::PARAM_STR);
$stmt->bindParam(':create_date', $this->getCreateDate(), PDO::PARAM_INT);
$stmt->bindParam(':update_date', $this->getUpdateDate(), PDO::PARAM_INT);
$stmt->execute();
$result = $stmt->fetch(PDO::FETCH_ASSOC);
} catch (PDOException $e) {
echo $e->getMessage();
echo $e->getTraceAsString();
}
if (!empty($result)) {
$this->setConfigId((int) $result['id']);
$this->setName($result['name']);
$this->setValue($result['value']);
$this->setCreateDate($result['create_date']);
$this->setUpdateDate($result['update_date']);
return true;
}
return false;
}
private function _getDB($settings)
{
if (!defined('DB_HOST')) {
define('DB_HOST', $settings['hostname']);
// set database host
}
if (!defined('DB_USER')) {
define('DB_USER', $settings['username']);
// set database user
}
if (!defined('DB_PASS')) {
define('DB_PASS', $settings['password']);
// set database password
}
if (!defined('DB_NAME')) {
define('DB_NAME', $settings['dbname']);
// set database name
}
if (!defined('SEND_ERRORS_TO')) {
define('SEND_ERRORS_TO', '*****@*****.**');
//set email notification email address
}
if (!defined('DISPLAY_DEBUG')) {
define('DISPLAY_DEBUG', true);
//display db errors?
}
$database = \DB::getInstance();
return $database;
}
function buildAction($name = '')
{
if (empty($name)) {
$db = DB::getInstance();
$tables = $db->getTables(DB_NAME);
foreach ($tables as $table) {
$table = str_replace(DB_PREFIX, '', $table);
buildAction($table);
}
} else {
$name = ucwords($name);
echo '正在生成' . $name . 'Action类...';
$filename = APP_PATH . 'Lib/Action/' . $name . 'Action.class.php';
if (!file_exists($filename)) {
$content = "<?php \n";
$content .= "class " . $name . "Action extends Action \n{\n";
$content .= "}\n?>";
if (file_put_contents($filename, $content)) {
echo "...Complete\n";
} else {
echo "...Fail\n";
}
} else {
echo "...Exists\n";
}
}
}
/**
* Counter logs
*
* @return void
**/
function counterExecute()
{
$oDB =& DB::getInstance();
$oDB->begin();
$site_module_info = Context::get('site_module_info');
$site_srl = (int) $site_module_info->site_srl;
// Check the logs
$oCounterModel =& getModel('counter');
// Register today's row if not exist
if (!$oCounterModel->isInsertedTodayStatus($site_srl)) {
$this->insertTodayStatus(0, $site_srl);
// check user if the previous row exists
} else {
// If unregistered IP
if (!$oCounterModel->isLogged($site_srl)) {
// Leave logs
$this->insertLog($site_srl);
// Register unique and pageview
$this->insertUniqueVisitor($site_srl);
} else {
// Register pageview
$this->insertPageView($site_srl);
}
}
$oDB->commit();
}
function convert_product_price()
{
$taxes = Db::getInstance()->executeS('SELECT * FROM ' . _DB_PREFIX_ . 'tax');
$taxRates = array();
foreach ($taxes as $data) {
$taxRates[$data['id_tax']] = (double) $data['rate'] / 100;
}
$resource = DB::getInstance()->executeS('SELECT `id_product`, `price`, `id_tax`
FROM `' . _DB_PREFIX_ . 'product`', false);
if (!$resource) {
return array('error' => 1, 'msg' => Db::getInstance()->getMsgError());
}
// was previously die(mysql_error())
while ($row = DB::getInstance()->nextRow($resource)) {
if ($row['id_tax']) {
$price = $row['price'] * (1 + $taxRates[$row['id_tax']]);
$decimalPart = $price - (int) $price;
if ($decimalPart < 1.0E-6) {
$newPrice = (double) number_format($price, 6, '.', '');
$newPrice = Tools::floorf($newPrice / (1 + $taxRates[$row['id_tax']]), 6);
DB::getInstance()->execute('UPDATE `' . _DB_PREFIX_ . 'product` SET `price` = ' . $newPrice . ' WHERE `id_product` = ' . (int) $row['id_product']);
}
}
}
}
function moduleUpdate()
{
$oModuleModel = getModel('module');
$oModuleController = getController('module');
$oDB =& DB::getInstance();
foreach ($this->triggers as $trigger) {
if (!$oModuleModel->getTrigger($trigger[0], $trigger[1], $trigger[2], $trigger[3], $trigger[4])) {
$oModuleController->insertTrigger($trigger[0], $trigger[1], $trigger[2], $trigger[3], $trigger[4]);
}
}
if (!$oDB->isColumnExists('androidpushapp_gcmregid', 'member_srl')) {
$oDB->addColumn('androidpushapp_gcmregid', 'member_srl', 'number', 11);
}
if (!$oDB->isColumnExists('androidpushapp_gcmregid', 'setting')) {
$oDB->addColumn('androidpushapp_gcmregid', 'setting', 'text');
}
if (!$oDB->isColumnExists('androidpushapp_gcmregid', 'setting_board')) {
$oDB->addColumn('androidpushapp_gcmregid', 'setting_board', 'text');
}
if (!$oDB->isColumnExists('androidpushapp_gcmregid', 'last_login')) {
$oDB->addColumn('androidpushapp_gcmregid', 'last_login', 'date');
}
if (!$oDB->isColumnExists('androidpushapp_gcmregid', 'sort')) {
$oDB->addColumn('androidpushapp_gcmregid', 'sort', 'char', 1, 'W', 'true');
}
return new Object(0, 'success_updated');
}
/**
* @breif module update
*/
function moduleUpdate()
{
$oModuleController =& getController('module');
$oModuleModel =& getModel('module');
$oDB =& DB::getInstance();
if (!$oDB->isColumnExists('epay_transactions', 'target_module')) {
$oDB->addColumn('epay_transactions', 'target_module', 'varchar', '80');
}
// 2012-04-06 regdate index added.
if (!$oDB->isIndexExists('epay_transactions', 'idx_regdate')) {
$oDB->addIndex('epay_transactions', 'idx_regdate', 'regdate');
}
// 2012-04-24 order_title column added.
if (!$oDB->isColumnExists('epay_transactions', 'order_title')) {
$oDB->addColumn('epay_transactions', 'order_title', 'varchar', '250');
}
// 2013-07-28 p_member_srl index added.
if (!$oDB->isIndexExists('epay_transactions', 'idx_member_srl')) {
$oDB->addIndex('epay_transactions', 'idx_member_srl', 'p_member_srl');
}
// added on 2015/06/13
if (!$oModuleModel->getTrigger('cympusadmin.getManagerMenu', 'epay', 'model', 'triggerGetManagerMenu', 'before')) {
$oModuleController->insertTrigger('cympusadmin.getManagerMenu', 'epay', 'model', 'triggerGetManagerMenu', 'before');
}
return new Object(0, 'success_updated');
}
public static function getTopicName($topicid)
{
$query = "SELECT * FROM topics WHERE topicID=?";
$param = array(0 => array($topicid, PDO::PARAM_STR));
$res = DB::getInstance()->prepareAndExecuteQueryWithResult($query, $param);
return $res;
}
function read($session_key)
{
if (!$session_key || !$this->session_started) {
return;
}
$oCacheHandler =& CacheHandler::getInstance('object');
if ($oCacheHandler->isSupport()) {
$cache_key = 'object:' . $session_key;
$output->data = $oCacheHandler->get($cache_key);
}
if (!$output->data) {
$args->session_key = $session_key;
$columnList = array('session_key', 'cur_mid', 'val');
$output = executeQuery('session.getSession', $args, $columnList);
// Confirm there is a table created if read error occurs
if (!$output->toBool()) {
$oDB =& DB::getInstance();
if (!$oDB->isTableExists('session')) {
$oDB->createTableByXmlFile($this->module_path . 'schemas/session.xml');
}
if (!$oDB->isColumnExists("session", "cur_mid")) {
$oDB->addColumn('session', "cur_mid", "varchar", 128);
}
$output = executeQuery('session.getSession', $args);
}
// Check if there is a table created in case there is no "cur_mid" value in the sessions information
if (!isset($output->data->cur_mid)) {
$oDB =& DB::getInstance();
if (!$oDB->isColumnExists("session", "cur_mid")) {
$oDB->addColumn('session', "cur_mid", "varchar", 128);
}
}
}
return $output->data->val;
}
public function __construct($user = null)
{
$this->_db = DB::getInstance();
$this->_sessionName = Config::get('session/session_name');
$this->_cookieName = Config::get('remember/cookie_name');
$this->_admSessionName = Config::get('session/admin_name');
if (!$user) {
if (Session::exists($this->_sessionName)) {
$user = Session::get($this->_sessionName);
if ($this->find($user)) {
$this->_isLoggedIn = true;
} else {
// process logout
}
}
if (Session::exists($this->_admSessionName)) {
$user = Session::get($this->_admSessionName);
if ($this->find($user)) {
$this->_isAdmLoggedIn = true;
} else {
// process logout
}
}
} else {
$this->find($user);
}
}
/**
* @brief 업데이트(업그레이드)
**/
function moduleUpdate()
{
$oDB =& DB::getInstance();
$oModuleModel =& getModel('module');
$oModuleController =& getController('module');
if (!$oModuleModel->getTrigger('file.downloadFile', 'nstore_digital', 'controller', 'triggerCheckPermission', 'before')) {
$oModuleController->insertTrigger('file.downloadFile', 'nstore_digital', 'controller', 'triggerCheckPermission', 'before');
}
if (!$oModuleModel->getTrigger('file.downloadFile', 'nstore_digital', 'controller', 'triggerUpdateDownloadedCount', 'after')) {
$oModuleController->insertTrigger('file.downloadFile', 'nstore_digital', 'controller', 'triggerUpdateDownloadedCount', 'after');
}
if (!$oModuleModel->getTrigger('nproduct.getProcModules', 'nstore_digital', 'model', 'triggerGetProcModules', 'before')) {
$oModuleController->insertTrigger('nproduct.getProcModules', 'nstore_digital', 'model', 'triggerGetProcModules', 'before');
}
if (!$oModuleModel->getTrigger('epay.processPayment', 'nstore_digital', 'controller', 'triggerProcessPayment', 'after')) {
$oModuleController->insertTrigger('epay.processPayment', 'nstore_digital', 'controller', 'triggerProcessPayment', 'after');
}
if (!$oModuleModel->getTrigger('epay.processReview', 'nstore_digital', 'controller', 'triggerProcessReview', 'before')) {
$oModuleController->insertTrigger('epay.processReview', 'nstore_digital', 'controller', 'triggerProcessReview', 'before');
}
if (!$oDB->isColumnExists('nstore_digital_cart', 'period')) {
$oDB->addColumn('nstore_digital_cart', 'period', 'number', 11);
$oDB->addIndex('nstore_digital_cart', 'idx_period', 'period');
}
}