/home/wwwroot/qtnonfu/lib/db/mysql_driver.php[ 187 ]
182 }
183 public function getErrno() {
184 return ($this->_link) ? mysql_errno ( $this->_link ) : mysql_errno ();
185 }
186 public function halt($message = '', $sql = '') {
187 throw new keke_exception ( ':error [ :query ]', array ('msg'=>$message,':error' => mysql_error ( $this->_link ), ':query' => $sql ), mysql_errno ( $this->_link ) );
188 exit ();
189 }
190 public function special_filed(&$value) {
191 if ('*' == $value || false !== strpos ( $value, '(' ) || false !== strpos ( $value, '.' ) || false !== strpos ( $value, '`' )) {
192 } else {
-
/home/wwwroot/qtnonfu/index.php [ 144 ] » require ( arguments )
0
string(44) "/home/wwwroot/qtnonfu/control/sellerlist.php"
139 $nowurl = $_SERVER['PHP_SELF']; 140 } 141 142 return $nowurl; 143 } 144 require 'control/' . $do . '.php'; 145 require $kekezu->_tpl_obj->template ( $do );
-
/home/wwwroot/qtnonfu/control/sellerlist.php [ 111 ] » db_factory::query ( arguments )
0
string(676) "select a.*,b.user_type,b.seller_level,b.skill_ids,b.city,b.province,b.indus_id,b.indus_pid,b.seller_total_num,b.seller_good_num,b.seller_level, if(b.seller_total_num>0,b.seller_good_num/b.seller_total_num,0) as good_rate ,sum(if((d.fina_action='task_bid' or d.fina_action='sale_service'),fina_cash,0)) as totalcash from keke_witkey_shop as a left join keke_witkey_space b on a.uid = b.uid left join keke_witkey_auth_record c on a.uid=c.uid left join keke_witkey_finance d on a.uid=d.uid where 1=1 and a.shop_status=1 and b.skill_ids like '%蔬菜瓜果%' and b.province = 16 group by a.uid order by b.recommend desc,b.seller_credit desc,a.on_sale desc limit 0 ,10"
106 $intCount = db_factory::execute($strSql . $strWhere ); 107 $strPages = $kekezu->_page_obj->getPages ( $intCount, $intPagesize, $intPage, $strUrl ); 108 $strWhere .= $strPages ['where']; 109 110 //服务商列表 111 $arrSellerLists = db_factory::query ( $strSql . $strWhere ); 112 113 // 显示当前登录用户的信息 start 114 if($intPage == 1 && $gUid){ 115 $strCurrentSql = "select a.*,b.user_type,b.seller_level,b.skill_ids,b.city,b.province,b.indus_id,b.indus_pid,b.seller_total_num,b.seller_good_num,b.seller_level, 116 if(b.seller_total_num>0,b.seller_good_num/b.seller_total_num,0) as good_rate ,sum(if((d.fina_action='task_bid' or d.fina_action='sale_service'),fina_cash,0)) as totalcash
-
/home/wwwroot/qtnonfu/lib/db/db_factory.php [ 102 ] » keke_db->query ( arguments )
0
string(676) "select a.*,b.user_type,b.seller_level,b.skill_ids,b.city,b.province,b.indus_id,b.indus_pid,b.seller_total_num,b.seller_good_num,b.seller_level, if(b.seller_total_num>0,b.seller_good_num/b.seller_total_num,0) as good_rate ,sum(if((d.fina_action='task_bid' or d.fina_action='sale_service'),fina_cash,0)) as totalcash from keke_witkey_shop as a left join keke_witkey_space b on a.uid = b.uid left join keke_witkey_auth_record c on a.uid=c.uid left join keke_witkey_finance d on a.uid=d.uid where 1=1 and a.shop_status=1 and b.skill_ids like '%蔬菜瓜果%' and b.province = 16 group by a.uid order by b.recommend desc,b.seller_credit desc,a.on_sale desc limit 0 ,10"
1
int(0)
97 public static function query($sql, $is_cache = 0, $cache_time = 0, $is_unbuffer = 0) { 98 $db = self::init (); 99 $result=''; 100 if(IS_CACHE){ 101 $cache_time > 0||is_null($cache_time) and ($result = self::db_cache ( 1, $sql, $cache_time ) and $cached=1); 102 $result or ($result = self::$db_obj->query ( $sql, $is_unbuffer ) and $cached=0); 103 if($result&&$result!='QUERY_EMPTY'){ 104 !$cached&&self::db_set_cache ($sql, $cache_time, $result ); 105 return $result; 106 }else{ 107 !$cached&&self::db_set_cache ($sql, $cache_time);
-
/home/wwwroot/qtnonfu/lib/db/db_factory.php [ 81 ] » mysql_drver->query ( arguments )
0
string(676) "select a.*,b.user_type,b.seller_level,b.skill_ids,b.city,b.province,b.indus_id,b.indus_pid,b.seller_total_num,b.seller_good_num,b.seller_level, if(b.seller_total_num>0,b.seller_good_num/b.seller_total_num,0) as good_rate ,sum(if((d.fina_action='task_bid' or d.fina_action='sale_service'),fina_cash,0)) as totalcash from keke_witkey_shop as a left join keke_witkey_space b on a.uid = b.uid left join keke_witkey_auth_record c on a.uid=c.uid left join keke_witkey_finance d on a.uid=d.uid where 1=1 and a.shop_status=1 and b.skill_ids like '%蔬菜瓜果%' and b.province = 16 group by a.uid order by b.recommend desc,b.seller_credit desc,a.on_sale desc limit 0 ,10"
1
int(0)
76 } 77 public function get_one($sql) { 78 return $this->_mydb->get_one_row ( $sql ); 79 } 80 public function query($sql, $is_unbuffer = 0) { 81 return $this->_mydb->query ( $sql, $is_unbuffer ); 82 } 83 public function __destruct() { 84 $this->_mydb->close (); 85 } 86 }
-
/home/wwwroot/qtnonfu/lib/db/mysql_driver.php [ 33 ] » mysql_drver->execute_sql ( arguments )
0
string(676) "select a.*,b.user_type,b.seller_level,b.skill_ids,b.city,b.province,b.indus_id,b.indus_pid,b.seller_total_num,b.seller_good_num,b.seller_level, if(b.seller_total_num>0,b.seller_good_num/b.seller_total_num,0) as good_rate ,sum(if((d.fina_action='task_bid' or d.fina_action='sale_service'),fina_cash,0)) as totalcash from keke_witkey_shop as a left join keke_witkey_space b on a.uid = b.uid left join keke_witkey_auth_record c on a.uid=c.uid left join keke_witkey_finance d on a.uid=d.uid where 1=1 and a.shop_status=1 and b.skill_ids like '%蔬菜瓜果%' and b.province = 16 group by a.uid order by b.recommend desc,b.seller_credit desc,a.on_sale desc limit 0 ,10"
1
int(0)
28 } 29 mysql_select_db ( $this->_dbname, $this->_link ) or $this->halt ( 'select database:' . $this->_dbname . ' fail!' ); 30 return $this->_link; 31 } 32 public function query($sql, $is_unbuffer = 0) { 33 $this->execute_sql ( $sql, $is_unbuffer ); 34 $result = array (); 35 while ( ($rs = $this->fetch_array ()) != false ) { 36 $result [] = $rs; 37 } 38 $this->free_result ();
-
/home/wwwroot/qtnonfu/lib/db/mysql_driver.php [ 153 ] » mysql_drver->halt ( arguments )
0
string(32) "Got error 28 from storage engine"
1
string(676) "select a.*,b.user_type,b.seller_level,b.skill_ids,b.city,b.province,b.indus_id,b.indus_pid,b.seller_total_num,b.seller_good_num,b.seller_level, if(b.seller_total_num>0,b.seller_good_num/b.seller_total_num,0) as good_rate ,sum(if((d.fina_action='task_bid' or d.fina_action='sale_service'),fina_cash,0)) as totalcash from keke_witkey_shop as a left join keke_witkey_space b on a.uid = b.uid left join keke_witkey_auth_record c on a.uid=c.uid left join keke_witkey_finance d on a.uid=d.uid where 1=1 and a.shop_status=1 and b.skill_ids like '%蔬菜瓜果%' and b.province = 16 group by a.uid order by b.recommend desc,b.seller_credit desc,a.on_sale desc limit 0 ,10"
148 } 149 protected function execute_sql($sql, $is_nubuffer = 0) { 150 ! is_resource ( $this->_link ) and $this->dbConnection (); 151 $is_nubuffer == 1 and $query_type = "mysql_unbuffered_query" or $query_type = "mysql_query"; 152 array_push($this->_query_sql, $sql); 153 $this->_last_query_id = $query_type ( $sql, $this->_link ) or $this->halt ( mysql_error (), $sql ); 154 $this->_query_num ++; 155 return $this->_last_query_id; 156 } 157 public function get_query_num() { 158 return $this->_query_num;