/**
* 购物车时间
*
* @param string $oid 订单ID
* @return string
*/
function carTime($oid)
{
global $dsql;
$row = $dsql->GetOne("SELECT stime FROM #@__shops_orders WHERE oid='{$oid}'");
return Mydate('Y-m-d h:i:s', $row['stime']);
}
$bdarcs->Start = $start;
echo $bdarcs->toXml();
} elseif ($dopost == 'sitemap_urls') {
header("Content-Type: text/xml; charset=utf-8");
if (empty($_GET['pwd']) || $_GET['pwd'] != ($bdpwd = baidu_get_setting('bdpwd'))) {
baidu_header_status(404);
return 1;
}
$type = empty($_GET['type']) ? 1 : intval($_GET['type']);
$query = "SELECT distinct(url),create_time from `#@__plus_baidusitemap_list` WHERE `type`={$type} group by url";
$dsql->SetQuery($query);
$dsql->Execute('dd');
$xmlstr = '<?xml version="1.0" encoding="UTF-8"?>
<sitemapindex>';
while ($row = $dsql->GetArray('dd')) {
$row['create_time'] = Mydate('Y-m-d', $row['create_time']);
$xmlstr .= "\r\n <sitemap>\r\n <loc><![CDATA[{$row['url']}]]></loc>\r\n <lastmod>{$row['create_time']}</lastmod>\r\n </sitemap>";
}
$xmlstr .= "\r\n</sitemapindex>";
echo $xmlstr;
} elseif ($dopost == 'site_id') {
$checksign = $_GET['checksign'];
$site_id = $_GET['site_id'];
if (!$checksign || strlen($checksign) !== 32) {
echo json_encode(array('status' => 0));
exit;
}
if (!$site_id) {
echo json_encode(array('status' => 0));
exit;
}
function toXml()
{
global $dsql, $cfg_webname, $cfg_basehost, $cfg_soft_lang;
$addonQuery = $limitQuery = "";
if (!empty($this->Typeid)) {
$addonQuery .= "AND arc.typeid=" . intval($this->Typeid);
$typeinfos = $this->getType($this->Typeid);
}
if ($this->SitemapType == 2) {
$setupmaxaid = baidu_get_setting('setupmaxaid');
$addonQuery .= "AND arc.id>" . intval($setupmaxaid);
}
$this->Start = intval($this->Start);
//var_dump($typeinfos);exit();
if (!empty($this->Row)) {
$limitQuery = "LIMIT {$this->Start}," . intval($this->Row);
}
$query = "SELECT arc.*,arc.senddate AS pubdate,tp.typedir,tp.typename,tp.isdefault,tp.defaultname,tp.namerule,\n\t\t\ttp.namerule2,tp.ispart,tp.moresite,tp.siteurl,tp.sitepath,at.body\n\t\t\tFROM `{$this->MainTable}` arc LEFT JOIN `#@__arctype` tp ON arc.typeid=tp.id\n LEFT JOIN `#@__addonarticle` at ON arc.id=at.aid\n\t\t\tWHERE arc.arcrank=0 AND arc.arcrank > -1 AND arc.channel=1 {$addonQuery} ORDER BY arc.senddate DESC {$limitQuery}";
//var_dump($query);
$dsql->SetQuery($query);
$dsql->Execute('dd');
$xmlstr = '<?xml version="1.0" encoding="UTF-8"?>
<urlset>';
$setupmaxaid = 0;
while ($row = $dsql->GetArray('dd')) {
$row['id'] = isset($row['aid']) ? $row['aid'] : $row['id'];
$row['filename'] = $row['arcurl'] = GetFileUrl($row['id'], $row['typeid'], $row['senddate'], $row['title'], 1, 0, $row['namerule'], $row['typedir'], 0, '', $row['moresite'], $row['siteurl'], $row['sitepath']);
$row['showdate'] = Mydate('Y-m-d', $row['pubdate']);
$row['priority'] = 0;
$row['body'] = isset($row['body']) ? Html2Text($row['body']) : '';
$row['body'] = empty($row['body']) ? $row['description'] : $row['body'];
//var_dump($row);exit;
if (preg_match("#c#", $row['flag'])) {
$row['priority'] = '1.0';
}
if (!isset($typeinfos)) {
$typeinfos = $this->getType($row['typeid']);
}
//var_dump($typeinfo);exit();
//var_dump($row);
$row['source'] = trim(Html2Text($row['source']));
$row['title'] = baidu_strip_invalid_xml($row['title']);
$row['body'] = baidu_strip_invalid_xml($row['body']);
$addstr = $copyrightstr = $yearstr = "";
$copyrightstr = !empty($row['source']) ? "\r\n\t\t\t\t\t<copyrightHolder><name><![CDATA[{$row['source']}]]></name></copyrightHolder>" : '';
$addstr .= empty($row['litpic']) ? "" : "\r\n\t\t\t\t\t<image><![CDATA[{$row['litpic']}]]></image>";
$yearstr = Mydate('Y', $row['pubdate']);
$rowxmlstr = <<<EOT
\t
\t<url>
\t\t\t<loc><![CDATA[{$cfg_basehost}{$row['filename']}]]></loc>
\t\t\t<lastmod>{$row['showdate']}</lastmod>
\t\t\t<changefreq>always</changefreq>
\t\t\t<priority>{$row['priority']}</priority>
\t\t\t<data>
\t\t\t\t<Webpage>
\t\t\t\t\t<name><![CDATA[{$row['title']}]]></name>
\t\t\t\t\t<url><![CDATA[{$cfg_basehost}{$row['filename']}]]></url>
\t\t\t\t\t<provider>
\t\t\t\t\t\t<name><![CDATA[{$cfg_webname}]]></name>
\t\t\t\t\t\t<url><![CDATA[{$cfg_basehost}]]></url>
\t\t\t\t\t</provider>
\t\t\t\t\t<description><![CDATA[{$row['description']}]]></description>
<text><![CDATA[{$row['body']}]]></text>
<keywords><![CDATA[{$row['keywords']}]]></keywords>
\t\t\t\t\t<breadcrumb><![CDATA[{$typeinfos['position']}]]></breadcrumb>
\t\t\t\t\t{$addstr}
<isPartOf>
\t\t\t\t\t\t<name><![CDATA[{$typeinfos['typename']}]]></name>
\t\t\t\t\t\t<url><![CDATA[{$cfg_basehost}{$typeinfos['typelink']}]]></url>
\t\t\t\t\t</isPartOf>
{$copyrightstr}
\t\t\t\t\t<copyrightYear>{$yearstr}</copyrightYear>
\t\t\t\t</Webpage>
\t\t\t</data>
\t\t</url>
EOT;
if ($cfg_soft_lang == 'gb2312') {
$rowxmlstr = gb2utf8($rowxmlstr);
}
//var_dump($rowxmlstr);exit;
$xmlstr .= $rowxmlstr;
}
//exit($xmlstr);
$xmlstr .= "\r\n</urlset>";
//$xmldata['content'] = $xmlstr;
return $xmlstr;
}
\t\t</p>
\t</body>
</html>
EOT;
echo $str;
exit;
} elseif ($dopost == 'viewsub') {
$query = "SELECT * FROM `#@__plus_baidusitemap_list` ORDER BY sid DESC";
$dsql->SetQuery($query);
$dsql->Execute('dd');
$liststr = "";
while ($arr = $dsql->GetArray('dd')) {
$typestr = $arr['type'] == 1 ? '[全量]' : '[增量]';
$arr['isok'] = $arr['isok'] == 0 ? '<font color="red">未提交</font>' : '<font color="green">已提交</font>';
$arr['create_time'] = Mydate('Y-m-d H:m:i', $arr['create_time']);
$liststr .= <<<EOT
<tr align="center" bgcolor="#FFFFFF" height="26" onmousemove="javascript:this.bgColor='#FCFDEE';" onmouseout="javascript:this.bgColor='#FFFFFF';">
\t\t\t<td>{$typestr}
\t\t\t</td>
\t\t\t<td><a href="{$arr['url']}" target="_blank">{$arr['url']}</a>
\t\t\t</td>
\t\t\t<td>{$arr['create_time']}</td>
\t\t\t</td>
\t\t</tr>
EOT;
}
//返回成功信息
$msg = <<<EOT
<table width="98%" border="0" align="center" cellpadding="3" cellspacing="1" bgcolor="#D6D6D6">
\t<tbody>
}
//积分操作记录
if ($dopost == 'jifenlog') {
Helper_Archive::loadModule('common');
$_model = new CommonModule('#@__member_jifen_log');
$head = '<table width="1000" border="0" cellspacing="0" cellpadding="0">
<tr>
<th width="125" height="30" align="left" scope="col">时间</th>
<th width="475" align="left" scope="col">操作</th>
</tr>';
$foot = '</table>';
$offset = ($curpage - 1) * $pagesize;
$arr = $_model->getAll("memberid='{$uid}'", "addtime desc", "{$offset},{$pagesize}");
foreach ($arr as $row) {
$addtime = Mydate('Y-m-d H:i:s', $row['addtime']);
$out .= ' <tr>
<td height="50">' . $addtime . '</td>
<td>' . $row['content'] . '</td>
</tr>';
}
$out = !empty($out) ? $head . $out . $foot : $nocontent_msg;
$totalnum = $_model->getCount("memberid='{$uid}'");
$totalpage = ceil($totalnum / $pagesize);
$pageinfo = setPageInfo($curpage, $totalpage);
$data = array('list' => $out, 'pageinfo' => $pageinfo);
echo json_encode($data);
exit;
}
/*
