myts; $uid=0; $uname=""; if(!empty($_GET['uid']) and $_GET['uid']>0){ $uid=intval($_GET['uid']); $query = "SELECT uname, name FROM ".$xoopsDB->prefix("users")." WHERE uid='".$uid."'"; $result = $xoopsDB->query($query); if ( $line = $xoopsDB->fetchArray($result)){ if( $d3dConf->mod_config['use_name'] == 1 && !empty($line['name'])) { $uname=mb_convert_encoding($line['name']. constant('_MD_DIARY_PERSON'), "UTF-8"); } else { $uname=mb_convert_encoding($line['uname']. constant('_MD_DIARY_PERSON'), "UTF-8"); } }else{ $uid=0; } } if(!empty($_GET['cid']) and $_GET['cid']>0){ $cid=intval($_GET['cid']); $category->uid=$uid; $category->cid=$cid; $category->getchildren($mydirname); if($category->children){ $whr_cid =" AND d.cid IN (".implode(",",$category->children).") "; } else { $whr_cid =" AND d.cid=".$cid; } } else { $cid=0; $whr_cid = ""; } //if(empty($uname)){exit();} mkrdf_php4($mydirname, $uid, $uname, $cid, $whr_cid); function mkrdf_php4($mydirname, $uid, $uname, $cid=0, $whr_cid="") { global $myts, $xoopsDB, $xoopsConfig, $xoopsModule, $d3dConf; header("Content-type: text/xml; charset=UTF-8"); echo ''."\n"; echo ''."\n"; echo ' '."\n"; if(empty($uname)){ echo ' '."\n"; }else{ echo ' '."\n"; } if(empty($uname)){ echo ' '.XOOPS_URL."/modules/".$mydirname."/index.php?page=diarylist".''."\n"; }else{ echo ' '.XOOPS_URL."/modules/".$mydirname."/index.php?req_uid=".$uid.''."\n"; } echo ' '."\n"; echo ' ja'."\n"; echo ' '."\n"; // get timezone offset $tzd = date('O', time()); $tzd = substr( chunk_split( $tzd, 3, ':' ), 0, 6 ); // for neglect future entry $now = date( "Y-m-d H:i:s" ); $whr_ctime = " AND create_time<'".$now."'"; // dc:date $query = "SELECT d.create_time, d.uid FROM ".$xoopsDB->prefix($mydirname."_diary"). " d LEFT JOIN " .$xoopsDB->prefix($mydirname.'_config'). " c ON d.uid=c.uid LEFT JOIN " .$xoopsDB->prefix($mydirname.'_category')." cat ON (d.cid=cat.cid AND (d.uid=cat.uid OR cat.uid=0)) WHERE (d.openarea='0' OR d.openarea IS NULL) AND (c.openarea='0' OR c.openarea IS NULL) AND (cat.openarea='0' OR cat.openarea IS NULL) ".$whr_cid.$whr_ctime; if($uid>0){ $query .= " AND uid='".$uid."' "; } $query .= " ORDER BY create_time DESC LIMIT 0,1"; $result = $xoopsDB->query($query); if ( $line = $xoopsDB->fetchArray($result)){ $entry_uid=intval($line['uid']); $ctime=split("[-: ]",$line['create_time']); $temp_time = mktime($ctime[3],$ctime[4],$ctime[5],$ctime[1],$ctime[2],$ctime[0]); //$tmp=gmdate("Y-m-d\TH:i:s+09:00", mktime($ctime[3],$ctime[4],$ctime[5],$ctime[1],$ctime[2],$ctime[0])); //$tmp=MyformatTimestamp(mktime($ctime[3],$ctime[4],$ctime[5],$ctime[1],$ctime[2],$ctime[0]), "Y-m-d\TH:i:s+09:00"); $tmp=MyformatTimestamp($temp_time, "Y-m-d\TH:i:s".$tzd); }else{ //$tmp=gmdate("Y-m-d")."T".gmdate("H:i:s")."+09:00"; //$tmp=gmdate("Y-m-d")."T".gmdate("H:i:s").$tzd; $tmp=date("Y-m-d")."T".date("H:i:s").$tzd; } echo ' '.$tmp.''."\n"; if($uid>0){ $query = "SELECT blogtype FROM ".$xoopsDB->prefix($mydirname."_config")." WHERE uid='".$uid."'"; $result = $xoopsDB->query($query); $line = mysql_fetch_array($result, MYSQL_ASSOC); } // diary in this site ------------------------------------- if(empty($uid) or empty($line['blogtype'])){ // items $query = "SELECT d.uid AS uid, d.bid AS bid, d.title AS title, d.diary AS diary, d.create_time AS create_time, d.dohtml as dohtml FROM ".$xoopsDB->prefix($mydirname."_diary")." d LEFT JOIN " .$xoopsDB->prefix($mydirname.'_config'). " c ON d.uid=c.uid LEFT JOIN " .$xoopsDB->prefix($mydirname.'_category')." cat ON (d.cid=cat.cid AND (d.uid=cat.uid OR cat.uid=0)) WHERE (d.openarea='0' OR d.openarea IS NULL) AND (c.openarea='0' OR c.openarea IS NULL) AND (cat.openarea='0' OR cat.openarea IS NULL) ".$whr_cid.$whr_ctime; if($uid>0){ $query .= " AND d.uid='".$uid."' "; } $query .= " ORDER BY create_time DESC LIMIT 0,30"; // items echo ' '."\n"; echo ' '."\n"; $result = $xoopsDB->query($query); while ( $line = $xoopsDB->fetchArray($result)){ echo ''."\n"; } echo ' '."\n"; echo ' '."\n"; echo ' '."\n"; // item $result = $xoopsDB->query($query); while ( $line = $xoopsDB->fetchArray($result)){ echo ' '."\n"; echo ' '."\n"; echo ' '.XOOPS_URL."/modules/".$mydirname."/detail.php?bid=".$line['bid'].''."\n"; echo ' '.htmlSpecialChars(mb_convert_encoding($line['title'], "UTF-8")).''."\n"; echo ' '."\n"; echo ' '.htmlSpecialChars(mb_convert_encoding($d3dConf->func->substrTarea($line['diary'], $line['dohtml'], 300, true, "UTF-8"), "UTF-8", "auto")).''."\n"; //date $lastmodify=split("[-: ]",$line['create_time']); $tmp=MyformatTimestamp(mktime($lastmodify[3],$lastmodify[4],$lastmodify[5],$lastmodify[1],$lastmodify[2],$lastmodify[0]), "Y-m-d\TH:i:s".$tzd); echo ' '.$tmp.''."\n"; echo ' '."\n"; } } echo ''."\n"; // ------------------------------------- } function MyformatTimestamp($time, $format, $timeoffset=""){ global $xoopsConfig, $xoopsUser; $usertimestamp = xoops_getUserTimestamp($time, $timeoffset); return date($format, $usertimestamp); } ?>