user_timeline.php

是个关于网格编程的程序

<?php
//*****************************************
//       id: user_timeline
//       EasyTalk V3.0 2008.5.6 20:50
//       by 仙踪云影
//*****************************************
require_once '../common.php';

$id=$_GET['id'];
$ext=$_GET['ext'];
$callback=$_GET['callback'];
$count=isset($_GET['count'])?$_GET['count']:20;
if ($count>20)
$count=20;
//json start
if ($ext=="json") {
require_once '../map/gbk2unicode.php';
function ex($str){return "[".$str."]";}
$qswh=new qswhGBK("../map/qswhGBK.php");
if ($id) {
$condition="where user_id='$id' order by share_id desc";
} else {
$condition="order by share_id desc";
}
if ($callback)
	echo "$callback.callBack([";
else
    echo "[";
$sql = "SELECT share_id,user_id,user_name,user_pic,content_body,share_time FROM ".$DBprefix."share ".$condition." limit $count";
$query = $db->query($sql);
while($data = $db->fetch_array($query))
{
	$share_id=$data['share_id'];
	$suid=$data['user_id'];
	$suname=$data['user_name'];
	$supic=$data['user_pic'];
	if ($supic=="") {
	$supic="$webaddr/images/jiwai/noavatar.jpg";
	}
	$content_body=$data['content_body'];
	$tem=explode("|et|",$content_body);
	$tem7=get_substr($content_body,0,7);
	if ($tem7=="[movie]"){
		$content_body="分享了视频";
	}
	if ($tem7=="[music]"){
		$content_body="分享了音乐";
	}
	if ($tem[1]) {
		$content_body=$tem[0];
	}
	$content_body=str_replace('"','',$content_body);
	$share_time=$data['share_time'];
	$share_time=gmdate('D,d,M,Y,H:i:s',$share_time+8*3600). ",+0800";

	$sql2 = "SELECT user_province,user_info FROM ".$DBprefix."users where user_id='$suid'";
	$query2 = $db->query($sql2);
	$data2 = $db->fetch_array($query2);
	$suprovince=$data2['user_province'];
	if ($suprovince=="选择省份 选择城市" || $suprovince=="0") {
	$suprovince="";
	}
	$suprovince=str_replace("省","",$suprovince);
	$suprovince=str_replace("市","",$suprovince);
	$suprovince=$qswh->gb2u($suprovince,3);
	$suinfo=$data2['user_info'];
	$suinfo=str_replace('"','',$suinfo);

	$tem="{\"created_at\":\"$share_time\",\"id\":\"$share_id\",\"text\":\"$content_body\",\"user\":{\"screen_name\":\"$suname\",\"id\":\"$suid\",\"name\":\"$suname\",\"location\":\"$suprovince\",\"description\":\"$suinfo\",\"profile_image_url\":\"$supic\",\"url\":\"$webaddr/home/u.$suid\",\"protected\":\"false\"}},";
	$tem = str_replace(array("\r", "\n"), array("", "<br />"), $tem);
	$json_meg=$json_meg.$tem;
	}
	$json_meg=substr("$json_meg", 0, -1); 
	echo $json_meg;

	if ($callback)
		echo "])";
	else
		echo "]";
}
//json end



//rss start
if ($ext=="rss") {

if ($id) {
$condition2="where user_id='$id' order by share_id desc";
$sql = "select * from ".$DBprefix."users where user_id='$id'";
$query = $db->query($sql);
$data = $db->fetch_array($query);
$name=$data['username'];
} else {
$condition2="order by share_id desc";
$name="大家";
}

header("Content-type: application/xml");
echo "<?xml version=\"1.0\" encoding=\"gbk\"?>\n".
     "  <rss version=\"2.0\">\n".
     "  <channel>\n".
     "  <title>EasyTalk | $name</title>\n".
     "  <link>$webaddr/home.php?uid=$id</link>\n".
     "  <description>EasyTalk - ".$name."在做什么…</description>\n";

$sql = "SELECT share_id,content_body,share_time,type FROM ".$DBprefix."share ".$condition2." limit $count";
$query = $db->query($sql);
while($data = $db->fetch_array($query))
{
	$share_id=$data['share_id'];
	$content_body=$data['content_body'];
	$tem=explode("|et|",$content_body);
	$tem7=get_substr($content_body,0,7);
	if ($tem7=="[movie]"){
		$content_body="分享了视频";
	}
	if ($tem7=="[music]"){
		$content_body="分享了音乐";
	}
	if ($tem[1]) {
		$content_body=$tem[0];
	}

	$type=$data['type'];
	$share_time=$data['share_time'];
	$share_time=gmdate('y-m-d H:i:s',$share_time+8*3600);

	echo "    <item>\n".
		 "     <title>$name: $content_body [$type]</title>\n".
		 "     <description><![CDATA[$name: $content_body [$type]]]></description>\n".
		 "     <pubDate>$share_time</pubDate>\n".
		 "     <guid>$webaddr/viewblog.php?id=$share_id</guid>\n".
		 "     <link>$webaddr/viewblog.php?id=$share_id</link>\n".
		 "   </item>\n";
	 } 
	echo "  </channel>\n".
		 "  </rss>";
 } 
//rss end

//xml start
if ($ext=="xml") {
if ($id) {
$condition3="where user_id='$id' order by share_id desc";
} else {
$condition3="order by share_id desc";
}

header("Content-type: application/xml");
echo "<?xml version=\"1.0\" encoding=\"gbk\"?>\n".
     "<statuses>\n";

$sql = "SELECT * FROM ".$DBprefix."share ".$condition3." limit $count";
$query = $db->query($sql);
while($data = $db->fetch_array($query))
{
	$share_id=$data['share_id'];
	$xml_uid=$data['user_id'];
	$xml_uname=$data['user_name'];
	$xml_upic=$data['user_pic'];
	$content_body=$data['content_body'];
	$tem=explode("|et|",$content_body);
	$tem7=get_substr($content_body,0,7);
	if ($tem[1]) {
		$content_body=$tem[0];
	}
	if ($tem7=="[movie]"){
		$content_body="分享了视频";
	}
	if ($tem7=="[music]"){
		$content_body="分享了音乐";
	}
	$type=$data['type'];
	$share_time=$data['share_time'];
	$share_time=gmdate('D M d H:i:s',$share_time+8*3600). " +0000 ".gmdate('Y',$share_time+8*3600);

	$sql2 = "SELECT user_province,user_info FROM ".$DBprefix."users where user_id='$xml_uid'";
	$query2 = $db->query($sql2);
	$data2 = $db->fetch_array($query2);
	$suprovince=$data2['user_province'];
	if ($suprovince=="选择省份 选择城市" || $suprovince=="0") {
	$suprovince="";
	}
	$suinfo=$data2['user_info'];
		echo "<status>\n".
		     "<created_at>$share_time</created_at>\n".
		     "<id>$share_id</id>\n".
		     "<text>$content_body</text>\n".
		     "<user>\n".
		     "	<screen_name>$xml_uname</screen_name>\n".
		     "	<id>$xml_uid</id>\n".
		     "	<name>$xml_uname</name>\n".
		     "	<location>$suprovince</location>\n".
		     "	<description>$suinfo</description>\n".
		     "	<profile_image_url>$xml_upic</profile_image_url>\n".
		     "	<url>$webaddr/home/u.$xml_uid</url>\n".
		     "	<protected>false</protected>\n".
		     "</user>\n".
	         "</status>\n";
}
echo "</statuses>";
}
//xml end
 ?>