| 最新相册 |
| include("../album/scrolljpg1.inc.php");?> |
| 留言簿 |
consql($db_host,$db_user,$db_pin,$db_name);
$forumid=1;
$is_del=0;#不显示被删除主题。
$sql = "SELECT *
FROM `lybn`
WHERE forumid='$forumid' and `is_del`='$is_del'
ORDER BY `is_top` DESC,`last_accesstime` DESC
LIMIT 10";
$result=mysql_query($sql);
while($row=mysql_fetch_object($result))
{
$i++;
#$row=mysql_fetch_object($result);
#echo $tmp_face;
?>
if($row->is_top==1)
{
echo " ";
if($row->voteid==1)
{
echo " ";
}
}else{
if($row->voteid==1)
{
echo " ";
}else{
echo " ";
}
}
?>
echo $row->topic; ?> |
( echo $row->poster; ?> echo date("m-d H:i",$row->last_accesstime);?>[ echo $row->replies; ?>]) |
} #end for
?>
|
555555555555
| 砍大山 |
consql($db_host,$db_user,$db_pin,$db_name);
$forumid=2;
$is_del=0;#不显示被删除主题。
$sql = "SELECT *
FROM `lybn`
WHERE forumid='$forumid' and `is_del`='$is_del'
ORDER BY `is_top` DESC,`last_accesstime` DESC
LIMIT 10";
$result=mysql_query($sql);
while($row=mysql_fetch_object($result))
{
$i++;
#$row=mysql_fetch_object($result);
#echo $tmp_face;
?>
if($row->is_top==1)
{
echo " ";
if($row->voteid==1)
{
echo " ";
}
}else{
if($row->voteid==1)
{
echo " ";
}else{
echo " ";
}
}
?>
echo $row->topic; ?> |
( echo $row->poster; ?> echo date("m-d H:i",$row->topicid);?>[ echo $row->replies; ?>]) |
} #end for
?>
|
|
| require_once('../riji/calendar_mod.php');?> |
|
consql($db_host,$db_user,$db_pin,$db_name);
$sql="select * from riji ORDER BY `lastmodify` DESC LIMIT 5";
if(isset($_GET['u']))
{
if($_GET['u']==$_SESSION['username'])
{
$sql="select * from riji WHERE username='".$_GET['u']."' ORDER BY `lastmodify` DESC LIMIT 10";
}else{
$sql="select * from riji WHERE username='".$_GET['u']."' and niming='0' ORDER BY `lastmodify` DESC LIMIT 10";
}
}
$result=mysql_query($sql);
while($row=mysql_fetch_object($result))
{
?>
| |
echo date(n月d日,$row->dateline);
echo " ";
switch (date("w",$row->dateline)) {
case "1":
echo "星期一";
break;
case "2":
echo "星期二";
break;
case "3":
echo "星期三";
break;
case "4":
echo "星期四";
break;
case "5":
echo "星期五";
break;
case "6":
echo "星期六";
break;
case "0":
echo "星期日";
break;
default:
echo "今天放假";
break;
}
echo " ";
if($row->tianqi<6 and $row->tianqi>0) echo " tianqi.".gif>";
#echo " 作者:";
if($row->niming==1)
{
#echo $row->userid;
}else{
#echo $row->username;
}
#echo " 于".date("Y-m-d H:i:s",$row->topicid);
?> |
if($row->is_del==1)
{
echo " $row->delreason";
}else{
#$content=ubb($row->content,$em_path);
#$content =csubstr($row->riji,0,56);
$content = mb_substr($row->riji,0,28,'utf-8');
$Ubb = new exUbb();
$Ubb->setString($content);
$content = $Ubb->parse();
#echo "rijiid."\" >";
echo "";
#echo "";
echo " ".$content."……";
#echo "";
#echo " ".$row->riji;
}
?> |
}#end while($row=mysql_fetch_object($result))
?> |
|