房产个人房源分页问题修正

湖中沉

source/module/category/house/broker.php
搜索

1. $multipage = multi($_G['category_threadcount'], $_G['tpp'], $page, "$modurl?mod=broker&action=my&uid=$uid");

复制代码

改为

1. 
   
2. $multipage = multi($_G['category_threadcount'], $_G['tpp'], $page, "$modurl?mod=broker&action=my&uid=$uid&sortid=$sortid");

复制代码

搜索

1. $query = DB::query("SELECT t.*, ts.* FROM ".DB::table('category_'.$modidentifier.'_thread')." t
   
2. LEFT JOIN ".DB::table('category_sortvalue')."$sortid ts ON t.tid=ts.tid
   
3. WHERE t.authorid='$uid' ORDER BY ts.displayorder DESC, ts.dateline DESC LIMIT $start_limit, $_G[tpp]");

复制代码

改为

1. 
   
2. $query = DB::query("SELECT t.*, ts.* FROM ".DB::table('category_'.$modidentifier.'_thread')." t
   
3.                 INNER JOIN ".DB::table('category_sortvalue')."$sortid ts ON t.tid=ts.tid
   
4.                 WHERE t.authorid='$uid' ORDER BY ts.displayorder DESC, ts.dateline DESC LIMIT $start_limit, $_G[tpp]");

复制代码