日日操夜夜添-日日操影院-日日草夜夜操-日日干干-精品一区二区三区波多野结衣-精品一区二区三区高清免费不卡

新增自定義列表頁(yè)：

查詢SQL語(yǔ)句:

統(tǒng)計(jì)記錄: select count(*) as total from [!db.pre!]enewsmember

查詢記錄: select u.*,ui.* from [!db.pre!]enewsmember u LEFT JOIN [!db.pre!]enewsmemberadd ui ON u.userid=ui.userid where u.checked=1 order by u.userfen desc /*這個(gè)是按積分最多排列，自己可以改一下看按什么排列*/

使用列表模板:選一個(gè)列表模板

列表模板LIST.VAR里的會(huì)員信息調(diào)用代碼：（勾選使用程序代碼）

—————————————————————————————————————————————

$uid=$empire->fetch1("select * from {$dbtbpre}enewsmemberadd where userid={$r[userid]}");

$usql=$empire->fetch1("select * from {$dbtbpre}enewsmember where userid = {$r['userid']}");

$ntsql=$empire->fetch1("select count(*) as newstotal from {$dbtbpre}ecms_download where userid={$r['userid']}"); /*投稿數(shù)查詢*/

$userpic=$uid['userpic']?$uid['userpic']:$public_r[newsurl].'e/data/images/nouserpic.gif';/*會(huì)員頭像*/

$jifen=$usql['userfen'];/*積分*/

$tg=$ntsql[newstotal]; /*統(tǒng)計(jì)會(huì)員投稿數(shù)*/

$listtemp='

<li class="userl">

<a href="/u/1" class="pic"><img src="'.$userpic.'" width="55" height="55" alt="admin"></a>

<p><a href="/u/1" target="_blank">admin</a></p>

<p class="xm"><b>積分：</b>'.$jifen.' </p>

<p><b>書籍：</b>'.$tg.'本</p>

</li>';

—————————————————————————————————————————————