コード例 #1
0
ファイル: keke_backup_class.php プロジェクト: pengfeiaaa/web
 static function querySelect($table_name, $field, $tablefields)
 {
     $db_factory = new db_factory();
     $fori = 0;
     $forlimit = 500;
     $sqlCount = $db_factory->get_count("select count(*) from " . $table_name);
     if (!$sqlCount) {
         return false;
     }
     $tabledump = '';
     $numfields = count($tablefields);
     while ($fori <= $sqlCount) {
         $sql = $db_factory->query("select * from " . $table_name . " limit " . $fori . "," . $forlimit);
         foreach ($sql as $r) {
             $row = array_values($r);
             $sqlmsg = $comma = '';
             for ($i = 0; $i < $numfields; $i++) {
                 $sqlmsg .= $comma . (!empty($row[$i]) && (self::strexists($tablefields[$i]['Type'], 'char') || self::strexists($tablefields[$i]['Type'], 'text')) ? '0x' . bin2hex($row[$i]) : '\'' . mysql_escape_string($row[$i]) . '\'');
                 $comma = ',';
             }
             $tabledump .= " INSERT INTO " . $table_name . "  VALUES(" . $sqlmsg . ") ;\n";
         }
         $fori += $forlimit;
     }
     return $tabledump;
 }
 function setUp()
 {
     $this->db =& db_factory::instance();
     $this->_clean_up();
     $this->_init_site_object();
     $this->object->set_attribute('controller_name', 'site_object_controller');
     $controller_id = site_object_controller::get_id('site_object_controller');
     $this->object->set_attribute('controller_id', $controller_id);
     debug_mock::init($this);
     $user =& user::instance();
     $user->_set_id(10);
     $tree =& tree::instance();
     $values['identifier'] = 'root';
     $values['object_id'] = 100;
     $this->root_node_id = $tree->create_root_node($values, false, true);
     $class_id = $this->object->get_class_id();
     $this->db->sql_insert('sys_site_object', array('id' => 100, 'class_id' => $class_id, 'current_version' => 1));
     $values['identifier'] = 'ru';
     $values['object_id'] = 1;
     $this->parent_node_id = $tree->create_sub_node($this->root_node_id, $values);
     $this->db->sql_insert('sys_site_object', array('id' => 1, 'class_id' => $class_id, 'current_version' => 1));
     $values['identifier'] = 'document';
     $values['object_id'] = 10;
     $this->sub_node_id = $tree->create_sub_node($this->parent_node_id, $values);
     $this->db->sql_insert('sys_site_object', array('id' => 10, 'class_id' => $class_id, 'current_version' => 1));
 }
コード例 #3
0
  function setUp()
  {
    $this->db =& db_factory :: instance();
    $this->links_manager =& new links_manager();

    $this->_clean_up();
  }
コード例 #4
0
 function pub_mode_init($std_cache_name, $data = array())
 {
     global $kekezu;
     global $_lang;
     $release_info = $this->_std_obj->_release_info;
     switch ($this->_pub_mode) {
         case "professional":
             break;
         case "guide":
             break;
         case "onekey":
             if (!$release_info) {
                 $sql = " select model_id,task_title,task_desc,indus_id,indus_pid,\n\t\t\t\t\t\ttask_cash_coverage,start_time,end_time,contact from %switkey_task where task_id='%d' and model_id='%d'";
                 $task_info = db_factory::get_one(sprintf($sql, TABLEPRE, $data['t_id'], $this->_model_id));
                 $task_info or kekezu::show_msg($_lang['operate_notice'], $_SERVER['HTTP_REFERER'], 3, $_lang['not_exsist_relation_task_and_not_user_onekey'], "warning");
                 $release_info = $this->onekey_mode_format($task_info);
                 $allow_time = $task_info['end_time'] - $task_info['start_time'];
                 $task_day = date('Y-m-d', $allow_time + time());
                 $release_info['txt_task_day'] = $task_day;
                 $release_info['task_cash_cove'] = $task_info['task_cash_coverage'];
                 $this->save_task_obj($release_info, $std_cache_name);
             }
             break;
     }
 }
 function setUp()
 {
     $this->db = db_factory::instance();
     debug_mock::init($this);
     $this->driver = new materialized_path_driver_test_version();
     $this->_clean_up();
 }
コード例 #6
0
  function setUp()
  {
    parent :: setUp();

    $this->db =& db_factory :: instance();

    $tree =& tree :: instance();

    $values['identifier'] = 'root';
    $this->node_id_root = $tree->create_root_node($values, false, true);

    $values['identifier'] = 'ru';
    $values['object_id'] = 1;
    $this->node_id_ru = $tree->create_sub_node($this->node_id_root, $values);

    $values['identifier'] = 'document';
    $values['object_id'] = 10;
    $this->node_id_document = $tree->create_sub_node($this->node_id_ru, $values);

    $values['identifier'] = 'doc1';
    $values['object_id'] = 20;
    $this->node_id_doc1 = $tree->create_sub_node($this->node_id_ru, $values);

    $values['identifier'] = 'doc2';
    $values['object_id'] = 30;
    $this->node_id_doc2 = $tree->create_sub_node($this->node_id_ru, $values);
  }
コード例 #7
0
	function full_text_search()
	{
		$this->db =& db_factory :: instance();
		$this->indexer =& new full_text_indexer();
		
		$this->use_boolean_mode = $this->_check_boolean_mode();
	}
コード例 #8
0
 public function process_report($op_result, $type)
 {
     global $_lang;
     $trans_name = $this->get_transrights_name($this->_report_type);
     $op_result = $this->op_result_format($op_result);
     if ($op_result['action']) {
         if ($op_result['product_remove'] == 1) {
             $res = db_factory::execute(sprintf(" update %switkey_service set service_status='3' where service_id='%d'", TABLEPRE, $this->_obj_info['origin_id']));
             $this->process_notify('pass', $this->_report_info, $this->_user_info, $this->_to_user_info, $op_result['process_result']);
             $this->change_status($this->_report_id, '4', $op_result, $op_result['process_result']);
             $res and kekezu::admin_show_msg($trans_name . $_lang['deal_success'], "index.php?do=trans&view=report&type={$type}", "3", '', 'success') or kekezu::admin_show_msg($trans_name . $_lang['deal_fail'], "index.php?do=trans&view=process&type={$type}&report_id=" . $this->_report_id, "3", '', 'warning');
         }
         if ($op_result['product_remove'] == 2) {
             $this->process_notify('nopass', $this->_report_info, $this->_user_info, $this->_to_user_info, $op_result['process_result']);
             $res = $this->change_status($this->_report_id, '3', $op_result, $op_result, $op_result['reply']);
             $res and kekezu::admin_show_msg($trans_name . $_lang['deal_success'], "index.php?do=trans&view=rights&type={$type}", "3", '', 'success') or kekezu::admin_show_msg($trans_name . $_lang['deal_fail'], "index.php?do=trans&view=process&type={$type}&report_id=" . $this->_report_id, "3", '', 'warning');
         }
         if ($op_result['product_remove'] == 3) {
             $this->disablePeople();
             $this->process_notify('pass', $this->_report_info, $this->_user_info, $this->_to_user_info, $op_result['process_result']);
             $res = $this->change_status($this->_report_id, '4', $op_result, $op_result['process_result']);
             $res and kekezu::admin_show_msg($trans_name . $_lang['deal_success'], "index.php?do=trans&view=rights&type={$type}", "3", '', 'success') or kekezu::admin_show_msg($trans_name . $_lang['deal_fail'], "index.php?do=trans&view=process&type={$type}&report_id=" . $this->_report_id, "3", '', 'warning');
         }
     }
 }
コード例 #9
0
 function setUp()
 {
     $this->db =& db_factory::instance();
     $this->stats_uri = new stats_uri_self_test_version($this);
     $this->stats_uri->stats_uri();
     $this->_clean_up();
 }
コード例 #10
0
  function setUp()
  {
    $this->db =& db_factory :: instance();
    $this->db_table_test =& db_table_factory :: instance('test1');

    $this->_clean_up();
  }
コード例 #11
0
 function db_table()
 {
     $this->_db_table_name = $this->_define_db_table_name();
     $this->_columns = $this->_define_columns();
     $this->_constraints = $this->_define_constraints();
     $this->_db =& db_factory::instance();
 }
コード例 #12
0
 function setUp()
 {
     $this->db = db_factory::instance();
     debug_mock::init($this);
     $this->driver = new nested_sets_driver_test_version();
     $this->_clean_up();
 }
コード例 #13
0
  function setUp()
  {
    $this->report = new stats_referers_report();
    $this->db =& db_factory :: instance();

    $this->_clean_up();
  }
コード例 #14
0
 function setUp()
 {
     $this->db =& db_factory::instance();
     $this->stats_referer = new stats_referer_self_test_version($this);
     $this->stats_referer->stats_referer();
     $this->_clean_up();
 }
コード例 #15
0
 public function getwithdata()
 {
     $connection = db_factory::factory(DB_TYPE);
     $sql = "select * from userdao order by username";
     $results = $connection->getArray($sql);
     $this->populate($results, 'user');
 }
コード例 #16
0
 function pub_mode_init($std_cache_name, $data = array())
 {
     global $kekezu;
     global $_lang;
     $release_info = $this->_std_obj->_release_info;
     switch ($this->_pub_mode) {
         case "professional":
             break;
         case "guide":
             break;
         case "onekey":
             if (!$release_info) {
                 $sql = " select model_id,task_title,task_desc,indus_id,indus_pid,\n\t\t\t\t\t\ttask_cash,contact from %switkey_task where task_id='%d' and model_id='%d'";
                 $task_info = db_factory::get_one(sprintf($sql, TABLEPRE, $data['t_id'], $this->_model_id));
                 $task_info or kekezu::show_msg($_lang['operate_notice'], $_SERVER['HTTP_REFERER'], 3, $_lang['not_exsist_relation_task_and_not_user_onekey'], "warning");
                 $release_info = $this->onekey_mode_format($task_info);
                 $allow_time = $kekezu->get_show_day($task_info['task_cash'], $this->_model_id);
                 $task_day = date('Y-m-d', $allow_time * 24 * 3600 + time());
                 $release_info['txt_task_day'] = $task_day;
                 $release_info['txt_task_cash'] = intval($task_info['task_cash']);
                 $prize_info = db_factory::query(sprintf("select * from %switkey_task_prize where task_id='%d'", TABLEPRE, $data['t_id']));
                 foreach ($prize_info as $v) {
                     $release_info['txt_prize' . $v['prize'] . '_num'] = $v['prize_count'];
                     $release_info['txt_prize' . $v['prize'] . '_cash'] = intval($v['prize_cash']);
                 }
                 $this->save_task_obj($release_info, $std_cache_name);
             }
             break;
     }
 }
コード例 #17
0
 public function getpaginateddata($position)
 {
     $connection = db_factory::factory(DB_TYPE);
     $sql = "SELECT id,name,message FROM PaginateDao ORDER BY id DESC LIMIT {$position} ," . ITEM_PER_PAGE;
     $results = $connection->getArray($sql);
     $this->populate($results, 'paginate');
 }
コード例 #18
0
 function _valid_perform()
 {
     $object_data =& fetch_mapped_by_url();
     $data = $this->_export();
     $phpbb_user_data['user_rank'] = $data['rank'];
     $db =& db_factory::instance();
     return $db->sql_update('phpbb_users', $phpbb_user_data, array('user_id' => $object_data['id']));
 }
コード例 #19
0
 public function index()
 {
     $connection = db_factory::factory(DB_TYPE);
     $sql = "SELECT COUNT(*) as num FROM PaginateDao";
     $result = $connection->getArray($sql);
     $pages = ceil((int) $result[0]['num'] / ITEM_PER_PAGE);
     return $pages;
 }
コード例 #20
0
  function site_object_controller_tester($class_name)
  {
    $this->db =& db_factory :: instance();

    $this->class_name = $class_name;

    parent :: LimbTestCase();
  }
コード例 #21
0
ファイル: model.class.php プロジェクト: liuguogen/weixin
 public function __construct()
 {
     if (!isset($this->db_config[$this->db_setting])) {
         $this->db_setting = 'default';
     }
     //$this->table_name = $this->table_name;
     $this->db = db_factory::get_instance($this->db_config)->get_database($this->db_setting);
 }
コード例 #22
0
ファイル: CustomFields.php プロジェクト: huangbinzd/kppwGit
 public function isFieldsExsits()
 {
     $col_info = db_factory::query("show COLUMNS FROM " . $this->_tbname . " WHERE Field='" . $this->_tbfield . "' ");
     if ($col_info) {
         return true;
     }
     return false;
 }
コード例 #23
0
  function site_object_tester($class_name) 
  {
  	$this->db =& db_factory :: instance();
  	
  	$this->class_name = $class_name;

  	parent :: UnitTestCase();
  }
コード例 #24
0
 function setUp()
 {
     $this->db = db_factory::instance();
     $this->stats_counter = new stats_counter_test_version($this);
     $this->stats_counter->stats_counter();
     $this->stats_counter->setReturnValue('_is_home_hit', false);
     $this->stats_counter->setReturnValue('_is_new_audience', false);
     $this->_clean_up();
 }
コード例 #25
0
 function setUp()
 {
     $this->db =& db_factory::instance();
     $this->_clean_up();
     $this->object = new mocked_site_object_test_version($this);
     $this->object->site_object();
     $user =& user::instance();
     $user->_set_id(10);
 }
コード例 #26
0
function checkFieldName($name, $model_id)
{
    $result = db_factory::get_one("SELECT f_name FROM `" . TABLEPRE . "witkey_custom_fields` where f_name = '" . kekezu::escape($name) . "' and model_id=" . intval($model_id));
    if ($result['f_name']) {
        return true;
    } else {
        return false;
    }
}
コード例 #27
0
ファイル: database.php プロジェクト: ailingsen/pigcms
 function __construct()
 {
     //$this->update_log_db = bpBase::loadModel('update_log_model');
     parent::__construct();
     $checkAccess = $this->exitWithoutAccess('system', 'manage');
     $this->dbConfig = array('default' => array('hostname' => DB_HOSTNAME, 'database' => DB_NAME, 'username' => DB_USER, 'password' => DB_PASSWORD, 'tablepre' => TABLE_PREFIX, 'charset' => DB_CHARSET, 'type' => 'mysql', 'debug' => DEBUG, 'pconnect' => 0, 'autoconnect' => 0));
     bpBase::loadSysClass('db_factory');
     $this->db = db_factory::get_instance($this->dbConfig)->get_database('default');
 }
コード例 #28
0
 function setUp()
 {
     $this->db =& db_factory::instance();
     $this->cart_handler =& new special_db_cart_handler($this);
     $this->cart_handler->db_cart_handler(10);
     $this->user = new Mockuser($this);
     $this->cart_handler->setReturnReference('_get_user', $this->user);
     $this->_clean_up();
 }
コード例 #29
0
 public function goods_top_end()
 {
     $goods_list = db_factory::query(sprintf(" select a.service_id  ,b.end_time from %switkey_service a left join %switkey_payitem_record b on a.service_id=b.obj_id\n\t\t\t\t where a.model_id=6 and a.goodstop=1 and b.obj_type='goods' and b.end_time<%d order by service_id desc ", TABLEPRE, TABLEPRE, time()));
     if (is_array($goods_list)) {
         foreach ($goods_list as $k => $v) {
             keke_shop_class::updateGoodsTop($v['service_id']);
         }
     }
 }
コード例 #30
0
 function &fetch_version($version, $sql_params = array())
 {
     $db_table =& $this->_get_db_table();
     $table_name = $db_table->get_table_name();
     $id = $this->get_id();
     $sql = sprintf("SELECT\n\t\t\t\t\t\t\t\t%s\n\t\t\t\t\t\t\t\tssot.id as node_id, \r\n\t\t\t\t\t\t\t\tssot.parent_id as parent_node_id, \n\t\t\t\t\t\t\t\tssot.level as level,\n\t\t\t\t\t\t\t\ttn.*,\n\t\t\t\t\t\t\t\ttn.id as record_id,\n\t\t\t\t\t\t\t\ttn.object_id as id\n\t\t\t\t\t\t\t\tFROM \n\t\t\t\t\t\t\t\tsys_site_object_tree as ssot,\n\t\t\t\t\t\t\t\t{$table_name} as tn\r\n\t\t\t\t\t\t\t\t%s\r\n\t\t\t\t\t\t\t\tWHERE \n\t\t\t\t\t\t\t\tssot.object_id = {$id} AND \n\t\t\t\t\t\t\t\ttn.object_id = {$id} AND\n\t\t\t\t\t\t\t\ttn.version = {$version}\n\t\t\t\t\t\t\t\t%s", $this->_add_sql($sql_params, 'columns'), $this->_add_sql($sql_params, 'tables'), $this->_add_sql($sql_params, 'conditions'));
     $db =& db_factory::instance();
     $db->sql_exec($sql);
     return $db->fetch_row();
 }