#
# --------------
# ald
# --------------
# 管理商店
#
# 档案: bbs.php
# 说明: 管理商店的程式.
# 作者: wgg
# 电子邮件: wgg@buccone.com
# 首页网址: http://www.yespod.com
# 版本: 1.0
#
# 版权注意:
#
# 本软体著作权http://www.yespod.com 作者: wgg 所有.
#
# 本人保留对本软体之更改与订正之权利, 任何人不得任意修改本
# 软体之任一部份(如须更改请先通知作者)。使用者执行本软体所
# 需之设定或美化外观所需之更改不在此限。使用者没有本人同意
# 不得将本软体放置网站供他人下载或翻译成其他语言。使用者须
# 将版权说明和著作权申明保留不得删除。
#
# 如有违反著作权法之规定, 本人自动保留追诉之权利。
#
# 如有任何疑问请与wgg连络。
# =====================================================================
# 辅助程式
# ---------------------------------------------------------------------
include "config.php";
include "global.inc.php"; //villy
$connection = mysql_connect($db_host,$db_admin,$db_pass) or die("錯誤! 無法登錄 MySQL 資料庫, 請查明暱稱或密碼是否是設定錯誤...");
$show_page=$_GET["show_page"];
$sign=$_GET["sign"];
##########################################################
## 客户留言板 ##
##########################################################
if ($sign == "1")
{
$bbsanswer ="
\n";
$Cururl=$_SERVER["SERVER_NAME"];
//echo "server:".$Cururl;
$short_site_url = short_url($Cururl);
$pagenumber=10;###这是显示留言每页显示条数的控制变量###
if (!$show_page) { $show_page=1; }
/*
$result = mysql($db_name, "SELECT * FROM $db_table_forum WHERE display = 'ON' AND dele <> 'yes' AND sign = '1' AND dspweb = '$short_site_url' ORDER BY landtime DESC ");
$toto = mysql_num_rows($result);
*/
$query_start=($show_page-1)*$pagenumber;
echo $query_start;
$result = mysql($db_name, "SELECT * FROM $db_table_forum WHERE display = 'ON' AND dele <> 'yes' AND sign = '1' AND dspweb = '$short_site_url' ORDER BY landtime DESC LIMIT $query_start ,10");
$toto = 100;//直接写成100,为加快查询速度,只显示100条记录
$stop=1;
$maxpage=($toto%$pagenumber);
if ($maxpage != 0 || $toto == 0){
$maxpage=intval($toto/$pagenumber)+1;
}else {
$maxpage=($toto/$pagenumber);
}
$show_page_last= $show_page - 1;
$i=( $show_page_last * $pagenumber );
if ( $toto > ($show_page * $pagenumber) ){
$torecno= $show_page * $pagenumber;
}else{
$torecno = $toto;
}
$next=0;
$page_last= $show_page - 1;
if ($toto > ($show_page * $pagenumber)){
$next=1;
}else{
$next=0;
}
//$totomax = $toto + 1000;
///限定查询数
$totomax = $toto;
$products =<<
|
最新$totomax 条信息 | 共 $maxpage 页 | 当前第 $show_page 页
EOT;
if ($show_page > 1) {
$products .=">>首页\n";
$products .="|上页|\n";
}else{
$products .=">>首页\n";
$products .="|上页|\n";
}
if ($next == 1){
$page_next= $show_page + 1;
$products .="下页|\n";
$products .="尾页<<\n";
}else{
$products .="|下页|\n";
$products .="尾页<<\n";
}
$products .=<< |
EOT;
///////就是限定查询$pagenumber条显示
$i=0;
$torecno=$pagenumber-1;
////////
if ($torecno <> '') {
while ($i < $torecno){
$pid=mysql_result($result,$i,"id");
$surname=mysql_result($result,$i,"surname");
$surname = stripslashes($surname);
$surname = ereg_replace("\"\'\;\(\)", "", "$surname");
$addr=mysql_result($result,$i,"addr");
$addr = stripslashes($addr);
$addr = ereg_replace("\"\'\;\(\)", "", "$addr");
$query=mysql_result($result,$i,"query");
$query = stripslashes($query);
$query = ereg_replace("\"\'\;\(\)", "", "$query");
$answer=mysql_result($result,$i,"answer");
$answer = stripslashes($answer);
$answer = ereg_replace("\"\'\;\(\)", "", "$answer");
$landtime=mysql_result($result,$i,"landtime");
//$ip=mysql_result($result,$i,"ip"); //villy
$ip = ''; //villy
$age=mysql_result($result,$i,"age");
$mess ="$landtime ";
$mess .="$addr ";
$mess .="$surname";
$mess .=" ";
$mess .="[来自 $ip 这个IP]问:";
$bbsanswer .= <<
$mess
|
$query
回复:$answer
| |
EOT;
$mess = "";
$i++;
}
}
$bbsanswer .= <<
EOT;
@mysql_free_result();
@mysql_close();
$client_ip= IP(); //villy
$header_file= "bbs.html";
$file = fopen($header_file, "r");
$header = fread($file, filesize($header_file));
$header = eregi_replace('#bbsanswer#', $bbsanswer, $header);
$header = eregi_replace('#client_ip#', $client_ip, $header); //villy
fclose($file);
echo $header;
exit;
}
##########################################################
## 客户成功案例 ##
##########################################################
if ($sign == "2"){
$bbsanswer ="\n";
$result = mysql($db_name, "SELECT * FROM $db_table_forum WHERE display = 'ON' AND dele <> 'yes' AND sign = '2' AND dspweb = '$short_site_url' ORDER BY landtime DESC ");
$toto = mysql_num_rows($result);
$stop=1;
$pagenumber=20;###这是显示留言每页显示条数的控制变量###
$maxpage=($toto%$pagenumber);
if ($maxpage != 0 || $toto == 0){
$maxpage=intval($toto/$pagenumber)+1;
}else {
$maxpage=($toto/$pagenumber);
}
if (!$show_page) { $show_page=1; }
$show_page_last= $show_page - 1;
$i=( $show_page_last * $pagenumber );
if ( $toto > ($show_page * $pagenumber) ){
$torecno= $show_page * $pagenumber;
}else{
$torecno = $toto;
}
$next=0;
$page_last= $show_page - 1;
if ($toto > ($show_page * $pagenumber)){
$next=1;
}else{
$next=0;
}
$totomax= $toto+1000;
$products =<<
|
共有 $totomax 条信息 | 共 $maxpage 页 | 当前第 $show_page 页
EOT;
if ($show_page > 1) {
$products .=">>首页\n";
$products .="|上页|\n";
}else{
$products .=">>首页\n";
$products .="|上页|\n";
}
if ($next == 1){
$page_next= $show_page + 1;
$products .="下页|\n";
$products .="尾页<<\n";
}else{
$products .="|下页|\n";
$products .="尾页<<\n";
}
$products .=<< |
EOT;
if ($torecno <> '') {
while ($i < $torecno){
$pid=mysql_result($result,$i,"id");
$surname=mysql_result($result,$i,"surname");
$surname = stripslashes($surname);
$surname = ereg_replace("\"\'\;\(\)", "", "$surname");
$addr=mysql_result($result,$i,"addr");
$addr = stripslashes($addr);
$addr = ereg_replace("\"\'\;\(\)", "", "$addr");
$query=mysql_result($result,$i,"query");
$query = stripslashes($query);
$query = ereg_replace("\"\'\;\(\)", "", "$query");
$answer=mysql_result($result,$i,"answer");
$answer = stripslashes($answer);
$answer = ereg_replace("\"\'\;\(\)", "", "$answer");
$landtime=mysql_result($result,$i,"landtime");
//$ip=mysql_result($result,$i,"ip"); //villy
$ip = ''; //villy
$age=mysql_result($result,$i,"age");
$mess = "$addr ";
$mess .="$surname";
$mess .=" ";
$mess .="$age";
$mess .="岁 ";
$mess .="$answer - [$landtime] [IP:$ip]";
$bbsanswer .= <<
 |
 |
 |
 |
|
 |
 |
 |
 |
EOT;
$mess ="";
$i++;
}
}
$bbsanswer .= <<
EOT;
@mysql_free_result();
@mysql_close();
$header_file= "succeed.htm";
$file = fopen($header_file, "r");
$header = fread($file, filesize($header_file));
$header = eregi_replace('#bbsanswer#', $bbsanswer, $header);
fclose($file);
echo $header;
exit;
}
?>