/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 [ 106 ] » db_factory::execute ( arguments )
0
string(661) "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 = 35 group by a.uid order by b.recommend desc,b.seller_credit desc,a.on_sale desc "
101 } 102 }else{ 103 $strWhere .= " order by b.recommend desc,b.seller_credit desc,a.on_sale desc "; 104 } 105 $arrCityInfo = CommonClass::getDistrictById($p); 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 );
-
/home/wwwroot/qtnonfu/lib/db/db_factory.php [ 95 ] » keke_db->execute ( arguments )
0
string(661) "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 = 35 group by a.uid order by b.recommend desc,b.seller_credit desc,a.on_sale desc "
90 $db_obj = &keke_db::get_instance ( $dbtype ); 91 return self::$db_obj = $db_obj; 92 } 93 public static function execute($sql) { 94 self::init (); 95 return self::$db_obj->execute ( $sql ); 96 } 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){
-
/home/wwwroot/qtnonfu/lib/db/db_factory.php [ 65 ] » mysql_drver->execute ( arguments )
0
string(661) "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 = 35 group by a.uid order by b.recommend desc,b.seller_credit desc,a.on_sale desc "
60 } 61 public function updatetable($tablename, $setsqlarr, $wheresqlarr) { 62 return $this->_mydb->update ( $tablename, $setsqlarr, $wheresqlarr ); 63 } 64 public function execute($sql) { 65 $res = $this->_mydb->execute ( $sql ); 66 return $res ? $res : 0; 67 } 68 public function get_query_num() { 69 return $this->_mydb->get_query_num (); 70 }
-
/home/wwwroot/qtnonfu/lib/db/mysql_driver.php [ 144 ] » mysql_drver->execute_sql ( arguments )
0
string(661) "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 = 35 group by a.uid order by b.recommend desc,b.seller_credit desc,a.on_sale desc "
139 } 140 $this->free_result (); 141 return $datalist; 142 } 143 public function execute($updatesql) { 144 $this->execute_sql ( $updatesql ); 145 $res = mysql_affected_rows ( $this->_link ); 146 $this->free_result (); 147 return $res; 148 } 149 protected function execute_sql($sql, $is_nubuffer = 0) {
-
/home/wwwroot/qtnonfu/lib/db/mysql_driver.php [ 153 ] » mysql_drver->halt ( arguments )
0
string(32) "Got error 28 from storage engine"
1
string(661) "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 = 35 group by a.uid order by b.recommend desc,b.seller_credit desc,a.on_sale desc "
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;