DDR爱好者之家 Design By 杰米
function sdatetime($str){
$str=ereg_replace("-","/",$str);
$str=substr($str,5,strlen($str)-8);
return $str;
}
function reAnum($sid){ //羆莱絞计
$DROOT=getenv('DOCUMENT_ROOT');
include("sql.php3");
$db=mysql_connect($sql['host'], $sql['user'] , $sql['passwd']);
$qsql="SELECT id from bbs_docs where sid='$sid'";
$rs=mysql_db_query($sql['db'],$qsql);
return mysql_num_rows($rs);
}
function pagebar($pages) {
global $pgno;
//global $pages;
global $PHP_SELF;
global $aid;
global $OPEN_LIST;
echo "<TABLE width=85% border=0 cellPadding=0 cellSpacing=1 align=center bgcolor='#6CA6CD' class='num'>";
echo "<tr><td>";
if($pgno!=0) {
$pu=$pgno-1;
echo "<a href=$PHP_SELF?aid=$aid&pgno=$pu>[]</a>";
}
if($pgno<$pages) {
$pd=$pgno+1;
echo "<a href=$PHP_SELF?aid=$aid&pgno=$pd>[]</a>";
}
for($i=0;$i<=$pages;$i++) {
if($pgno==$i) {
echo "<b>";
echo "[".($i+1)."]";
echo "</b>";
} else {
echo "<a href=$PHP_SELF?aid=$aid&pgno=$i>";
echo "[".($i+1)."]";
echo "</a>";
}
}
echo "</td>";
echo "<TD align=right>";
echo "<a href=$PHP_SELF?proc=view&aid=$aid>";
echo "[祇ゅ彻]";
echo "</a>";
//echo "</TD>";
//echo "<TD align=right>";
if($OPEN_LIST) {
echo "<a href=$PHP_SELF?proc=colloff&aid=$aid&pgno=$pgno>";
echo "[ぃ甶秨杠肈]";
echo "</a>";
}else {
echo "<a href=$PHP_SELF?proc=collon&aid=$aid&&pgno=$pgno>";
echo "[甶秨杠肈]";
echo "</a>";
}
echo "</TD>";
echo "</tr></table>";
}
//===============================================================================
function openlist($sid) {
global $aid;
global $PHP_SELF;
$DROOT=getenv('DOCUMENT_ROOT');
include("sql.php3");
$db=mysql_connect($sql['host'], $sql['user'] , $sql['passwd']);
$qsql="SELECT * from bbs_docs where sid='$sid' order by wdate";
$rs=mysql_db_query($sql['db'],$qsql);
//if(mysql_num_rows($rs)==0) return;
//echo mysql_num_rows($rs);
while($row=mysql_fetch_array($rs)) {
$id=$row['id'];
$banner=$row['banner'];
$poster=$row['poster'];
$views=$row['views'];
$wdate=sdatetime($row['wdate']);
echo "<tr bgcolor='#F0F0F0'>";
echo "<td>";
echo "<a href=$PHP_SELF?proc=view&aid=$aid&sid=$sid&rid=$id>";
echo " <font color=#836FFF>$banner</font>";
echo "</a>";
//echo "banner is $banner";
echo "</td>";
echo "<td>";
echo $poster;
echo "</td>";
echo "<td class='num'>";
echo " ";
echo "</td>";
echo "<td class='num'>";
echo $views;
echo "</td>";
echo "<td class='num'>";
echo $wdate;
echo "</td>";
echo "</tr>";
}
}
//========================================================================
function area() {
global $PHP_SELF;
global $aid,$sid,$pgno;
global $OPEN_LIST;
$showitems=20;
$DROOT=getenv('DOCUMENT_ROOT');
include("sql.php3");
$db=mysql_connect($sql['host'], $sql['user'] , $sql['passwd']);
//============================================================
if(!$aid) {
$qsql="SELECT id from bbs_area";
$rs=mysql_db_query($sql['db'],$qsql);
$row=mysql_fetch_array($rs);
$aid=$row['id'];
}
if(!$sid) {
$qsql="SELECT id from bbs_subj where aid=$aid order by wdate DESC";
$rs=mysql_db_query($sql['db'],$qsql);
$row=mysql_fetch_array($rs);
$sid=$row['id'];
}
if(!$pgno) {//礚﹚计
//$pgno=0;
$items=0;
$qsql="SELECT id from bbs_subj where aid=$aid order by wdate DESC";
$rs=mysql_db_query($sql['db'],$qsql);
while($row=mysql_fetch_array($rs)){
$id=$row['id'];
if($id==$sid) break;
$items++;
}
$pgno=(INT)($items/$showitems);
}
//============================================================
$qsql="SELECT * from bbs_area where id=$aid ";
$rs=mysql_db_query($sql['db'],$qsql);
$row=mysql_fetch_array($rs);
$banner=$row['banner'];
$body=$row['body'];
$master=$row['master'];
echo "<center><font color=GREEN size=5><b>$banner</b></font></center>";
echo "<FORM name=mtab ENCTYPE=multipart/form-data METHOD=POST ACTION=$PHP_SELF?proc=search>";
echo "<TABLE width=85% border=0 cellPadding=0 cellSpacing=1 align=center class='tablefont'>";
echo "<tr><td>";
echo "<input type='hidden' name=aid value='$aid'>";
echo "穓碝ゅ彻:";
echo "<INPUT TYPE='TEXT' NAME='key' size=25 class='tablefont'>";
echo "<INPUT TYPE='Submit'value='琩高' class='tablefont'>";
echo "</td></tr>";
echo "</table>";
echo "</FORM>";
$qsql="SELECT * from bbs_subj where aid=$aid order by wdate DESC";
$rs=mysql_db_query($sql['db'],$qsql);
$all=mysql_num_rows($rs); //how rows
$pages=(INT)($all/$showitems); // how pages
$pgcount=$pgno*$showitems;
if($pgcount > $all) {
$pgno=$pages-1; // Page point over all pages
$pgcount=$pgno*$showitems;
}
mysql_data_seek($rs, $pgcount);
$cnt=0;
pagebar($pages);
echo "<TABLE width=85% border=0 cellPadding=0 cellSpacing=1 align=center bgcolor='#6CA6CD'>";
echo "<tr><td>";
echo "<TABLE width=100% cellPadding=1 cellSpacing=1 bgcolor=white class='tablefont'>";
echo "<tr bgcolor=#F1E1FF>";
echo "<th >夹肈</th>";
echo "<th>祇癬</th>";
echo "<th width=30>莱</th>";
echo "<th width=30></th>";
echo "<th width=70>ら戳</th>";
echo "</tr>";
while($row=mysql_fetch_array($rs)) {
if(++$cnt > $showitems) break;
$id=$row['id'];
$banner=$row['banner'];
$poster=$row['poster'];
$views=$row['views'];
$wdate=sdatetime($row['wdate']);
$docs=reAnum($id);
echo "<tr bgcolor='#F0F8FF'>";
echo "<td>";
echo "<a href=$PHP_SELF?proc=view&aid=$aid&sid=$id&rid=$id>";
if($sid==$id) echo "<font color=red>〈$banner</font>";
else echo $banner;
echo "</a>";
echo "</td>";
echo "<td>";
echo $poster;
echo "</td>";
echo "<td class='num'>";
echo $docs;
echo "</td>";
echo "<td class='num'>";
echo $views;
echo "</td>";
echo "<td class='num'>";
echo $wdate;
echo "</td>";
echo "</tr>";
if($OPEN_LIST) openlist($id);
}
echo "</td></tr></table>";
echo"</td></tr></table>";
pagebar($pages);
}
待续........
$str=ereg_replace("-","/",$str);
$str=substr($str,5,strlen($str)-8);
return $str;
}
function reAnum($sid){ //羆莱絞计
$DROOT=getenv('DOCUMENT_ROOT');
include("sql.php3");
$db=mysql_connect($sql['host'], $sql['user'] , $sql['passwd']);
$qsql="SELECT id from bbs_docs where sid='$sid'";
$rs=mysql_db_query($sql['db'],$qsql);
return mysql_num_rows($rs);
}
function pagebar($pages) {
global $pgno;
//global $pages;
global $PHP_SELF;
global $aid;
global $OPEN_LIST;
echo "<TABLE width=85% border=0 cellPadding=0 cellSpacing=1 align=center bgcolor='#6CA6CD' class='num'>";
echo "<tr><td>";
if($pgno!=0) {
$pu=$pgno-1;
echo "<a href=$PHP_SELF?aid=$aid&pgno=$pu>[]</a>";
}
if($pgno<$pages) {
$pd=$pgno+1;
echo "<a href=$PHP_SELF?aid=$aid&pgno=$pd>[]</a>";
}
for($i=0;$i<=$pages;$i++) {
if($pgno==$i) {
echo "<b>";
echo "[".($i+1)."]";
echo "</b>";
} else {
echo "<a href=$PHP_SELF?aid=$aid&pgno=$i>";
echo "[".($i+1)."]";
echo "</a>";
}
}
echo "</td>";
echo "<TD align=right>";
echo "<a href=$PHP_SELF?proc=view&aid=$aid>";
echo "[祇ゅ彻]";
echo "</a>";
//echo "</TD>";
//echo "<TD align=right>";
if($OPEN_LIST) {
echo "<a href=$PHP_SELF?proc=colloff&aid=$aid&pgno=$pgno>";
echo "[ぃ甶秨杠肈]";
echo "</a>";
}else {
echo "<a href=$PHP_SELF?proc=collon&aid=$aid&&pgno=$pgno>";
echo "[甶秨杠肈]";
echo "</a>";
}
echo "</TD>";
echo "</tr></table>";
}
//===============================================================================
function openlist($sid) {
global $aid;
global $PHP_SELF;
$DROOT=getenv('DOCUMENT_ROOT');
include("sql.php3");
$db=mysql_connect($sql['host'], $sql['user'] , $sql['passwd']);
$qsql="SELECT * from bbs_docs where sid='$sid' order by wdate";
$rs=mysql_db_query($sql['db'],$qsql);
//if(mysql_num_rows($rs)==0) return;
//echo mysql_num_rows($rs);
while($row=mysql_fetch_array($rs)) {
$id=$row['id'];
$banner=$row['banner'];
$poster=$row['poster'];
$views=$row['views'];
$wdate=sdatetime($row['wdate']);
echo "<tr bgcolor='#F0F0F0'>";
echo "<td>";
echo "<a href=$PHP_SELF?proc=view&aid=$aid&sid=$sid&rid=$id>";
echo " <font color=#836FFF>$banner</font>";
echo "</a>";
//echo "banner is $banner";
echo "</td>";
echo "<td>";
echo $poster;
echo "</td>";
echo "<td class='num'>";
echo " ";
echo "</td>";
echo "<td class='num'>";
echo $views;
echo "</td>";
echo "<td class='num'>";
echo $wdate;
echo "</td>";
echo "</tr>";
}
}
//========================================================================
function area() {
global $PHP_SELF;
global $aid,$sid,$pgno;
global $OPEN_LIST;
$showitems=20;
$DROOT=getenv('DOCUMENT_ROOT');
include("sql.php3");
$db=mysql_connect($sql['host'], $sql['user'] , $sql['passwd']);
//============================================================
if(!$aid) {
$qsql="SELECT id from bbs_area";
$rs=mysql_db_query($sql['db'],$qsql);
$row=mysql_fetch_array($rs);
$aid=$row['id'];
}
if(!$sid) {
$qsql="SELECT id from bbs_subj where aid=$aid order by wdate DESC";
$rs=mysql_db_query($sql['db'],$qsql);
$row=mysql_fetch_array($rs);
$sid=$row['id'];
}
if(!$pgno) {//礚﹚计
//$pgno=0;
$items=0;
$qsql="SELECT id from bbs_subj where aid=$aid order by wdate DESC";
$rs=mysql_db_query($sql['db'],$qsql);
while($row=mysql_fetch_array($rs)){
$id=$row['id'];
if($id==$sid) break;
$items++;
}
$pgno=(INT)($items/$showitems);
}
//============================================================
$qsql="SELECT * from bbs_area where id=$aid ";
$rs=mysql_db_query($sql['db'],$qsql);
$row=mysql_fetch_array($rs);
$banner=$row['banner'];
$body=$row['body'];
$master=$row['master'];
echo "<center><font color=GREEN size=5><b>$banner</b></font></center>";
echo "<FORM name=mtab ENCTYPE=multipart/form-data METHOD=POST ACTION=$PHP_SELF?proc=search>";
echo "<TABLE width=85% border=0 cellPadding=0 cellSpacing=1 align=center class='tablefont'>";
echo "<tr><td>";
echo "<input type='hidden' name=aid value='$aid'>";
echo "穓碝ゅ彻:";
echo "<INPUT TYPE='TEXT' NAME='key' size=25 class='tablefont'>";
echo "<INPUT TYPE='Submit'value='琩高' class='tablefont'>";
echo "</td></tr>";
echo "</table>";
echo "</FORM>";
$qsql="SELECT * from bbs_subj where aid=$aid order by wdate DESC";
$rs=mysql_db_query($sql['db'],$qsql);
$all=mysql_num_rows($rs); //how rows
$pages=(INT)($all/$showitems); // how pages
$pgcount=$pgno*$showitems;
if($pgcount > $all) {
$pgno=$pages-1; // Page point over all pages
$pgcount=$pgno*$showitems;
}
mysql_data_seek($rs, $pgcount);
$cnt=0;
pagebar($pages);
echo "<TABLE width=85% border=0 cellPadding=0 cellSpacing=1 align=center bgcolor='#6CA6CD'>";
echo "<tr><td>";
echo "<TABLE width=100% cellPadding=1 cellSpacing=1 bgcolor=white class='tablefont'>";
echo "<tr bgcolor=#F1E1FF>";
echo "<th >夹肈</th>";
echo "<th>祇癬</th>";
echo "<th width=30>莱</th>";
echo "<th width=30></th>";
echo "<th width=70>ら戳</th>";
echo "</tr>";
while($row=mysql_fetch_array($rs)) {
if(++$cnt > $showitems) break;
$id=$row['id'];
$banner=$row['banner'];
$poster=$row['poster'];
$views=$row['views'];
$wdate=sdatetime($row['wdate']);
$docs=reAnum($id);
echo "<tr bgcolor='#F0F8FF'>";
echo "<td>";
echo "<a href=$PHP_SELF?proc=view&aid=$aid&sid=$id&rid=$id>";
if($sid==$id) echo "<font color=red>〈$banner</font>";
else echo $banner;
echo "</a>";
echo "</td>";
echo "<td>";
echo $poster;
echo "</td>";
echo "<td class='num'>";
echo $docs;
echo "</td>";
echo "<td class='num'>";
echo $views;
echo "</td>";
echo "<td class='num'>";
echo $wdate;
echo "</td>";
echo "</tr>";
if($OPEN_LIST) openlist($id);
}
echo "</td></tr></table>";
echo"</td></tr></table>";
pagebar($pages);
}
待续........
DDR爱好者之家 Design By 杰米
广告合作:本站广告合作请联系QQ:858582 申请时备注:广告合作(否则不回)
免责声明:本站资源来自互联网收集,仅供用于学习和交流,请遵循相关法律法规,本站一切资源不代表本站立场,如有侵权、后门、不妥请联系本站删除!
免责声明:本站资源来自互联网收集,仅供用于学习和交流,请遵循相关法律法规,本站一切资源不代表本站立场,如有侵权、后门、不妥请联系本站删除!
DDR爱好者之家 Design By 杰米
暂无评论...
更新日志
2024年11月25日
2024年11月25日
- 凤飞飞《我们的主题曲》飞跃制作[正版原抓WAV+CUE]
- 刘嘉亮《亮情歌2》[WAV+CUE][1G]
- 红馆40·谭咏麟《歌者恋歌浓情30年演唱会》3CD[低速原抓WAV+CUE][1.8G]
- 刘纬武《睡眠宝宝竖琴童谣 吉卜力工作室 白噪音安抚》[320K/MP3][193.25MB]
- 【轻音乐】曼托凡尼乐团《精选辑》2CD.1998[FLAC+CUE整轨]
- 邝美云《心中有爱》1989年香港DMIJP版1MTO东芝首版[WAV+CUE]
- 群星《情叹-发烧女声DSD》天籁女声发烧碟[WAV+CUE]
- 刘纬武《睡眠宝宝竖琴童谣 吉卜力工作室 白噪音安抚》[FLAC/分轨][748.03MB]
- 理想混蛋《Origin Sessions》[320K/MP3][37.47MB]
- 公馆青少年《我其实一点都不酷》[320K/MP3][78.78MB]
- 群星《情叹-发烧男声DSD》最值得珍藏的完美男声[WAV+CUE]
- 群星《国韵飘香·贵妃醉酒HQCD黑胶王》2CD[WAV]
- 卫兰《DAUGHTER》【低速原抓WAV+CUE】
- 公馆青少年《我其实一点都不酷》[FLAC/分轨][398.22MB]
- ZWEI《迟暮的花 (Explicit)》[320K/MP3][57.16MB]