湖中沉 发表于 2011-3-30 14:15:06

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

source/module/category/house/broker.php
搜索
$multipage = multi($_G['category_threadcount'], $_G['tpp'], $page, "$modurl?mod=broker&action=my&uid=$uid");
改为


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

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

$query = DB::query("SELECT t.*, ts.* FROM ".DB::table('category_'.$modidentifier.'_thread')." t
                INNER JOIN ".DB::table('category_sortvalue')."$sortid ts ON t.tid=ts.tid
                WHERE t.authorid='$uid' ORDER BY ts.displayorder DESC, ts.dateline DESC LIMIT $start_limit, $_G");
页: [1]
查看完整版本: 房产个人房源分页问题修正