function __construct($tablename, $templatedir = '', $lurdtempdir = '')
{
global $dsql;
$prefix = "#@__";
$this->tplName = str_replace($prefix, '', $tablename);
$this->tableName = str_replace($prefix, $GLOBALS['cfg_dbprefix'], $tablename);
$this->templateDir = $templatedir;
$this->lurdTempdir = empty($lurdtempdir) ? $this->templateDir . '/lurd' : $lurdtempdir;
parent::__construct();
$this->AnalyseTable();
$ct = isset($GLOBALS['ct']) ? $GLOBALS['ct'] : request('ct', '');
if (!empty($ct)) {
$this->SetParameter('ct', $ct);
}
$this->SetParameter('ac', 'list');
}
$wheresql .= " AND (groupname like '%" . $keyword . "%' OR des like '%" . $keyword . "%' OR creater like '%" . $keyword . "%')";
}
if (!isset($username)) {
$username = '';
}
if (!empty($username)) {
$wheresql .= " AND creater like '%" . $username . "%'";
}
if (!isset($store)) {
$store = -1;
}
if ($store > 0) {
$wheresql .= " AND (storeid='" . $store . "' OR rootstoreid='" . $store . "')";
}
$sql = "SELECT * FROM #@__groups {$wheresql} ORDER BY stime DESC";
$dl = new DataListCP();
$dl->pageSize = 20;
$dl->SetParameter("username", $username);
$dl->SetParameter("store", $store);
$dl->SetParameter("keyword", $keyword);
//这两句的顺序不能更换
$dl->SetTemplate(DEDEADMIN . "/templets/group_main.htm");
//载入模板
$dl->SetSource($sql);
//设定查询SQL
$dl->Display();
//显示
function GetGroupstore($id)
{
global $db;
$row = $db->GetOne("SELECT storename,tops FROM #@__store_groups WHERE storeid='{$id}'");
if (empty($price)) {
$price = $row['price'];
}
if (empty($des)) {
$des = addslashes($row['des']);
} else {
$des = cn_substrR($des, 255);
}
$dsql->ExecuteNoneQuery("UPDATE #@__shops_delivery SET dname='{$dname}',price='{$price}',des='{$des}' WHERE pid='{$id}'");
}
ShowMsg("成功修改配送方式!", "shops_delivery.php");
exit;
}
}
}
$deliveryarr = array();
$dsql->SetQuery("SELECT pid,dname,price,des FROM #@__shops_delivery ORDER BY orders ASC");
$dsql->Execute();
while ($row = $dsql->GetArray()) {
$deliveryarr[] = $row;
}
$dlist = new DataListCP();
$dlist->pageSize = 25;
//设定每页显示记录数（默认25条）
//这两句的顺序不能更换
$dlist->SetTemplate(DEDEADMIN . "/templets/shops_delivery.htm");
//载入模板
$dlist->SetSource("SELECT `pid`,`dname`,`price`,`des` FROM #@__shops_delivery ORDER BY `orders` ASC");
//设定查询SQL
$dlist->Display();
//显示
$config = AutoCharset(unserialize(utf82gb($row['config'])));
} else {
if ($cfg_soft_lang == 'gb2312') {
$config = unserialize($row['config']);
}
}
foreach ($config as $key => $v) {
$config[$key]['value'] = "";
}
if ($cfg_soft_lang == 'utf-8') {
$config = AutoCharset($config, 'utf-8', 'gb2312');
$config = serialize($config);
$config = gb2utf8($config);
} else {
$config = serialize($config);
}
$query = "UPDATE `#@__payment` SET fee='',config='{$config}',enabled='0' WHERE id='{$pid}'";
$dsql->ExecuteNoneQuery($query);
//同时需要删除对应的缓存
$m_file = DEDEDATA . "/payment/" . $row['code'] . ".php";
@unlink($m_file);
ShowMsg("删除成功！", "sys_payment.php");
exit;
}
}
}
$sql = "SELECT * FROM `#@__payment` ORDER BY rank ASC";
$dlist = new DataListCP();
$dlist->SetTemplet(DEDEADMIN . "/templets/sys_payment.htm");
$dlist->SetSource($sql);
$dlist->display();
<?php /** * @version $Id: mygroup.php 1 12:11 2010年9月13日Z tianya $ * @package DedeCMS.Module.Group * @copyright Copyright (c) 2007 - 2010, DesDev, Inc. * @license http://help.dedecms.com/usersguide/license.html * @link http://www.dedecms.com */ require_once dirname(__FILE__) . "/system/config.php"; require_once DEDEINC . "/datalistcp.class.php"; $menutype = 'mydede'; $sql = "SELECT * FROM #@__groups WHERE ishidden='0' AND uid='" . $cfg_ml->M_ID . "' ORDER BY threads DESC,stime DESC"; $dl = new DataListCP(); $dl->pageSize = 20; //这两句的顺序不能更换 $dl->SetTemplate(_SYSTEM_ . "/mygroup.htm"); //载入模板 $dl->SetSource($sql); //设定查询SQL $dl->Display(); //显示
<?php
/**
* 自定义模型管理
*
* @version $Id: mychannel_main.php 1 15:26 2010年7月20日Z tianya $
* @package DedeCMS.Administrator
* @copyright Copyright (c) 2007 - 2010, DesDev, Inc.
* @license http://help.dedecms.com/usersguide/license.html
* @link http://www.dedecms.com
*/
require_once dirname(__FILE__) . '/config.php';
CheckPurview('temp_Other');
require_once DEDEINC . '/datalistcp.class.php';
setcookie("ENV_GOBACK_URL", $dedeNowurl, time() + 3600, '/');
$sql = "SELECT myt.aid,myt.tagname,tp.typename,myt.timeset,myt.endtime\r\n FROM `#@__mytag` myt LEFT JOIN `#@__arctype` tp ON tp.id=myt.typeid ORDER BY myt.aid DESC ";
$dlist = new DataListCP();
$dlist->SetTemplet(DEDEADMIN . '/templets/mytag_main.htm');
$dlist->SetSource($sql);
$dlist->display();
function TestType($tname)
{
return $tname == '' ? '所有栏目' : $tname;
}
function TimeSetValue($ts)
{
return $ts == 0 ? '不限时间' : '限时标记';
}
$dlist->pageSize = $_vars['pagesize'];
$dlist->SetParameter("mtype", $mtype);
$dlist->SetParameter("uid", $_vars['userid']);
$dlist->SetParameter("action", $action);
$dlist->SetTemplate(DEDEMEMBER . "/space/{$_vars['spacestyle']}/listalbum.htm");
$dlist->SetSource($query);
$dlist->Display();
exit;
} else {
if ($action == 'guestbook') {
if (empty($mtype)) {
$mtype = 0;
}
include_once DEDEINC . '/datalistcp.class.php';
$query = "SELECT mg.*,mb.face,mb.userid,mb.sex From `#@__member_guestbook` mg \n left join `#@__member` mb on mb.userid=mg.gid \n where mg.mid='{$_vars['mid']}' order by mg.aid desc";
$dlist = new DataListCP();
$dlist->pageSize = 10;
$dlist->SetParameter("uid", $_vars['userid']);
$dlist->SetParameter("action", $action);
$dlist->SetTemplate(DEDEMEMBER . "/space/{$_vars['spacestyle']}/guestbook.htm");
$dlist->SetSource($query);
$dlist->Display();
exit;
} else {
if ($action == 'friend') {
if (empty($mtype)) {
$mtype = 0;
}
include_once DEDEINC . '/arc.memberlistview.class.php';
include_once DEDEINC . '/channelunit.func.php';
$query = "SELECT arc.*,tp.typedir,tp.typename,tp.isdefault,tp.defaultname,tp.namerule,tp.namerule2,tp.ispart,tp.moresite,tp.siteurl,tp.sitepath\n from `#@__archives` arc\n left join `#@__arctype` tp on arc.typeid=tp.id\n where arc.mid='{$_vars['mid']}' {$addqSql} order by arc.id desc";
//获得是否审核的表述
function IsChecklog($ischeck)
{
$s = '';
$s = $ischeck == '1' ? "<font color=blue>已审核</font>" : "<font color=red>未审核</font>";
return $s;
}
function JstrimJajxLog($str, $len)
{
$str = cn_substr($str, $len);
$str = str_replace(''', '"', $str);
$str = str_replace('<', '<', $str);
$str = str_replace('>', '>', $str);
return $str;
}
$row = $dsql->GetOne("SELECT COUNT({$id}) AS dd FROM {$table}");
$totalnum = $row['dd'];
$rows = $dsql->GetOne("SELECT COUNT({$id}) AS dd FROM {$table} WHERE ischeck=1");
$checknum = $rows['dd'];
$rowss = $dsql->GetOne("SELECT COUNT({$id}) AS dd FROM {$table} WHERE ischeck=0");
$ischecknum = $rowss['dd'];
$sql = "SELECT * FROM {$table} WHERE 1=1 {$where} ORDER BY dtime DESC";
$dlist = new DataListCP();
$dlist->pageSize = 20;
$dlist->SetParameter("type", $type);
$dlist->SetParameter("totalnum", $totalnum);
$dlist->SetParameter("checknum", $checknum);
$dlist->SetParameter("ischecknum", $ischecknum);
$dlist->SetTemplate($tpl);
$dlist->SetSource($sql);
$dlist->Display();
//列表
$dsql->SetQuery($where_sql . " order by id desc limit {$offset},{$num}");
$dsql->Execute();
while ($list_row = $dsql->GetObject()) {
$topid = $list_row->topid;
if ($list_row->zuozhe) {
$list_zz = '<a style="color:#025b81;" href="' . $cfg_indexurl . 'author/?' . $list_row->id . '.html" target="_blank" title="' . $list_row->zuozhe . '">' . $list_row->zuozhe . '</a>';
} else {
$list_zz = '<font style="color:#343434;">未记录</font>';
}
$gxlb_i++;
$gxlb_i % 2 == 0 ? $class = ' class="odd"' : ($class = '');
$list_str .= '
<li' . $class . '>
<div class="c"><a href="' . $cfg_indexurl . SBYOU_NET_catalog($topid, 'typedir') . '.html" title="' . str_replace('·', '', SBYOU_NET_catalog($topid, 'typename')) . '">[' . str_replace('·', '', SBYOU_NET_catalog($topid, 'typename')) . ']</a></div>
<div class="title">
<div class="t"><a href="' . $cfg_indexurl . ltrim($list_row->typedir, '/') . '/" title="' . $list_row->typename . '" target="_blank">' . $list_row->typename . '</a></div>
<div class="n">' . SbYOU_Net_NEW($list_row->id, ltrim($list_row->typedir, '/')) . '</div>
</div>
<div class="words">' . $list_row->booksize . '</div>
<div class="author">' . $list_zz . '</div>
<div class="abover">' . ($list_row->overdate == 0 ? '<span>连载</span>' : '<font style="color:blue">完结</font>') . '</div>
<div class="time">' . date('Y-m-d', $list_row->lastupdate) . '</div>
</li>
';
}
//加载模板
require_once DEDEINC . "/datalistcp.class.php";
$dlist = new DataListCP();
$dlist->SetTemplet($cfg_basedir . $cfg_templets_dir . "/" . $cfg_df_style . "/shuku.htm");
$dlist->Display();
exit;
} else {
if ($job == 'check') {
$query = "Update `#@__feedback` set ischeck=1 where id in({$ids}) ";
$dsql->ExecuteNoneQuery($query);
ShowMsg("成功审核指定评论!", $_COOKIE['ENV_GOBACK_URL'], 0, 500);
exit;
} else {
$bgcolor = '';
$typeid = isset($typeid) && is_numeric($typeid) ? $typeid : 0;
$aid = isset($aid) && is_numeric($aid) ? $aid : 0;
$keyword = !isset($keyword) ? '' : $keyword;
$ip = !isset($ip) ? '' : $ip;
$tl = new TypeLink($typeid);
$openarray = $tl->GetOptionArray($typeid, $admin_catalogs, 0);
$addsql = $typeid != 0 ? " And typeid in (" . GetSonIds($typeid) . ")" : '';
$addsql .= $aid != 0 ? " And aid={$aid} " : '';
$addsql .= $ip != '' ? " And ip like '{$ip}' " : '';
$querystring = "select * from `#@__feedback` where msg like '%{$keyword}%' {$addsql} order by dtime desc";
$dlist = new DataListCP();
$dlist->pageSize = 15;
$dlist->SetParameter('aid', $aid);
$dlist->SetParameter('ip', $ip);
$dlist->SetParameter('typeid', $typeid);
$dlist->SetParameter('keyword', $keyword);
$dlist->SetTemplate(DEDEADMIN . '/templets/feedback_main.htm');
$dlist->SetSource($querystring);
$dlist->Display();
}
}
}
exit;
}
} else {
function GetState($state)
{
if ($state == "0") {
return "<font color='red'>未发送</font>";
} else {
return "已发送";
}
}
function GetSendTimeMk($mktime)
{
if ($mktime == "0") {
return "<font color='red'>未发送</font>";
} else {
return MyDate('Y-m-d H:i:s', $mktime);
}
}
function GetCount($typeid)
{
global $dsql;
$row = $dsql->GetOne("SELECT COUNT(typeid) as cc FROM `#@__mail_order`");
return $row['cc'];
}
$sql = "SELECT t.*,p.typename FROM `#@__mail_title` AS t LEFT JOIN `#@__mail_type` AS p ON t.typeid=p.id ORDER BY t.id desc";
$dlist = new DataListCP();
$dlist->SetTemplet(DEDEADMIN . "/templets/mail_title_send.htm");
$dlist->SetSource($sql);
$dlist->display();
}
<?php
require_once dirname(__FILE__) . '/config.php';
CheckPurview('a_List,a_AccList,a_MyList');
require_once DEDEINC . '/datalistcp.class.php';
if (empty($cid)) {
$cid = '0';
$whereSql = '';
}
if ($cid != 0) {
require_once DEDEINC . '/channelunit.func.php';
$whereSql = " And arc.typeid in (" . GetSonIds($cid) . ")";
}
$query = "SELECT arc.*,tp.typename FROM `#@__archives` AS arc\r\nLEFT JOIN #@__arctype AS tp ON arc.typeid = tp.id\r\nWHERE arc.arcrank = '-2' {$whereSql} order by arc.id desc";
$dlist = new DataListCP();
$dlist->SetTemplet(DEDEADMIN . "/templets/recycling.htm");
$dlist->SetSource($query);
$dlist->display();
<?php
require_once dirname(__FILE__) . '/config.php';
CheckRank(0, 0);
require_once DEDEINC . '/datalistcp.class.php';
setcookie('ENV_GOBACK_URL', GetCurUrl(), time() + 3600, '/');
$query = "Select * From `#@__member_operation` where mid='" . $cfg_ml->M_ID . "' And product='archive' order by aid desc";
$dlist = new DataListCP();
$dlist->pageSize = 20;
$dlist->SetTemplate(DEDEMEMBER . '/templets/mypay.htm');
$dlist->SetSource($query);
$dlist->Display();
$ismaster = implode(",", $master);
$db->ExecuteNoneQuery("UPDATE #@__groups SET ismaster='{$ismaster}' WHERE groupid='{$id}'");
}
ShowMsg("{$msg}", "-1");
exit;
} else {
if ($action = "join") {
$row = $db->GetOne("SELECT isjoin FROM #@__group_user WHERE uid='{$uid}' AND gid='{$id}' AND isjoin='0'");
if (is_array($row)) {
$db->ExecuteNoneQuery("UPDATE #@__group_user SET isjoin='1' WHERE uid='{$uid}' AND gid='{$id}'");
}
}
}
}
$sql = "SELECT * FROM #@__group_user WHERE gid='{$id}' ORDER BY jointime DESC";
$dl = new DataListCP();
$dl->pageSize = 20;
$dl->SetParameter("id", $id);
$dl->SetParameter("gid", $gid);
//这两句的顺序不能更换
$dl->SetTemplate(_SYSTEM_ . "/mygroup_member.htm");
//载入模板
$dl->SetSource($sql);
//设定查询SQL
$dl->Display();
//显示
function filter($var)
{
return $var == '' ? false : true;
}
function GetMaster($user)
$whereSql = '';
if (!empty($folder)) {
$whereSql = "WHERE folder='{$folder}'";
}
$postuser = "******";
if ($folder == "inbox" || $folder == '') {
$postuser = "******";
}
if (!empty($keyword)) {
$whereSql .= " AND (subject like '%" . $keyword . "%' OR message like '%" . $keyword . "%')";
}
if (!empty($username)) {
$whereSql .= " AND floginid like '%" . $username . "%'";
}
$sql = "SELECT * FROM #@__member_pms {$whereSql} ORDER BY sendtime desc";
$dlist = new DataListCP();
$dlist->pagesize = 25;
$dlist->SetParameter("folder", $folder);
$dlist->SetParameter("username", $username);
$dlist->SetParameter("keyword", $keyword);
$dlist->SetTemplate(DEDEADMIN . "/templets/member_pm.htm");
$dlist->SetSource($sql);
$dlist->Display();
$dlist->Close();
function GetFolders($me)
{
if ($me == "outbox") {
return '发件箱';
} else {
if ($me == "inbox") {
return '收件箱';
$title = $row['title'];
}
if (empty($notice)) {
$notice = $row['notice'];
}
$db->ExecuteNoneQuery("UPDATE #@__group_notice SET notice='" . $notice . "',title='" . $title . "' WHERE id='{$id}'");
}
}
}
unset($row);
//列表加载模板
$wheresql = "WHERE gid='{$gid}'";
if (!empty($keyword)) {
$wheresql .= " AND (title like '%" . $keyword . "%' OR notice like '%" . $keyword . "%')";
}
if (!empty($username)) {
$wheresql .= " AND uname like '%" . $username . "%'";
}
$sql = "SELECT * FROM #@__group_notice {$wheresql} ORDER BY stime DESC";
$dl = new DataListCP();
$dl->pageSize = 20;
$dl->SetParameter("keyword", $keyword);
$dl->SetParameter("username", $username);
$dl->SetParameter("gid", $gid);
//这两句的顺序不能更换
$dl->SetTemplate(DEDEADMIN . "/templets/group_notice.htm");
//载入模板
$dl->SetSource($sql);
//设定查询SQL
$dl->Display();
//显示
$dsql->Execute();
while ($sbYou_neT_row = $dsql->GetObject()) {
$topid = $sbYou_neT_row->topid;
$sbyou_typeimg = ltrim($sbYou_neT_row->typeimg, '/');
if (!$sbyou_typeimg) {
$randPICID = rand(1, 50);
$sbyou_typeimg = "uploads/empty/" . $randPICID . ".jpg";
}
$sByou_NET_list .= '
<li>
<a href="' . $BOOK_URL . ltrim($sbYou_neT_row->typedir, '/') . '/" target="_blank" class="preview"><img src="' . $BOOK_URL . $sbyou_typeimg . '" alt="" width="84" height="112"/></a>
<div class="cbody">
<a href="' . $BOOK_URL . ltrim($sbYou_neT_row->typedir, '/') . '/" target="_blank" class="title">' . $sbYou_neT_row->typename . '</a> <span class="endpl">最近更新：<small>' . date('Y-m-d H:i:s', $sbYou_neT_row->lastupdate) . '</small></span>
<p class="intro">' . sbyou_nEt_cut_str($sbYou_neT_row->description, '90', '0', 'gbk') . '</p>
<span class="info">
<small class="view">浏览:</small>' . $sbYou_neT_row->bookclick . '<small class="hpd">推荐:</small>' . $sbYou_neT_row->tuijian . '<small class="pl">字数:</small>' . $sbYou_neT_row->booksize . '
<small class="btn">
[<a class="yd" href="' . $BOOK_URL . ltrim($sbYou_neT_row->typedir, '/') . '/" target="_blank">立即阅读</a>]
[<a class="sm" href="' . $BOOK_URL . ltrim($sbYou_neT_row->typedir, '/') . '/chapter.html" target="_blank">查看书目</a>]
[<a class="xz" href="' . $TXT_URL . '?topid=' . $topid . '&id=' . $sbYou_neT_row->id . '&date=' . $sbYou_neT_row->lastupdate . '" target="_blank">下载TXT</a>]
</small>
</span>
</div>
</li>
';
}
//加载模板
require_once DEDEINC . "/datalistcp.class.php";
$dlist = new DataListCP();
$dlist->SetTemplet(DEDEMEMBER . '/templets/caicai.htm');
$dlist->Display();
$row = $dsql->GetOne("Select typename,ishidden From `#@__arctype` where id='{$id}' ");
if ($row['ishidden'] == 1) {
exit;
}
$typename = ConvertStr($row['typename']);
//当前栏目下级分类
$dsql->SetQuery("Select id,typename From `#@__arctype` where reid='{$id}' And channeltype=1 And ishidden=0 And ispart<>2 order by sortrank");
$dsql->Execute();
while ($row = $dsql->GetObject()) {
$channellistnext .= "<a href='wap.php?action=list&id={$row->id}'>" . ConvertStr($row->typename) . "</a> ";
}
//栏目内容(分页输出)
$sids = GetSonIds($id, 1, true);
$varlist = "cfg_webname,typename,channellist,channellistnext,cfg_templeturl";
ConvertCharset($varlist);
$dlist = new DataListCP();
$dlist->SetTemplet($cfg_templets_dir . "/wap/list.wml");
$dlist->pageSize = 10;
$dlist->SetParameter("action", "list");
$dlist->SetParameter("id", $id);
$dlist->SetSource("Select id,title,pubdate,click From `#@__archives` where typeid in({$sids}) And arcrank=0 order by id desc");
$dlist->Display();
exit;
} else {
if ($action == 'article') {
//文档信息
$query = "\r\n\t Select tp.typename,tp.ishidden,arc.typeid,arc.title,arc.arcrank,arc.pubdate,arc.writer,arc.click,addon.body From `#@__archives` arc \r\n\t left join `#@__arctype` tp on tp.id=arc.typeid\r\n\t left join `#@__addonarticle` addon on addon.aid=arc.id\r\n\t where arc.id='{$id}'\r\n\t";
$row = $dsql->GetOne($query, MYSQL_ASSOC);
foreach ($row as $k => $v) {
${$k} = $v;
}
if (is_array($row)) {
ShowMsg("关键字已存在库中！", "-1");
exit;
}
$inquery = "INSERT INTO `#@__keywords`(keyword,rank,sta,rpurl) VALUES ('{$keyword}','{$rank}','1','{$rpurl}');";
$dsql->ExecuteNoneQuery($inquery);
ShowMsg("成功增加一个关键字！", $ENV_GOBACK_URL);
exit;
}
}
if (empty($keyword)) {
$keyword = '';
$addquery = '';
} else {
$addquery = " WHERE keyword LIKE '%{$keyword}%' ";
}
$sql = "SELECT * FROM `#@__keywords` {$addquery} ORDER BY rank DESC";
$dlist = new DataListCP();
$dlist->pageSize = 20;
$dlist->SetParameter("keyword", $keyword);
$dlist->SetTemplate(DEDEADMIN . "/templets/article_keywords_main.htm");
$dlist->SetSource($sql);
$dlist->Display();
function GetSta($sta)
{
if ($sta == 1) {
return '';
} else {
return ' checked="1" ';
}
}
* @license http://help.dedecms.com/usersguide/license.html
* @link http://www.dedecms.com
*/
require_once dirname(__FILE__) . "/config.php";
require_once DEDEINC . "/datalistcp.class.php";
CheckPurview('shops_Operations');
if (!isset($oid)) {
exit("<a href='javascript:window.close()'>无效操作!</a>");
}
$oid = preg_replace("#[^-0-9A-Z]#", "", $oid);
if (empty($oid)) {
exit("<a href='javascript:window.close()'>无效订单号!</a>");
}
$row = $dsql->GetOne("SELECT * FROM #@__shops_userinfo WHERE oid='{$oid}'");
$sql = "SELECT o.*,p.title,p.price as uprice,d.dname FROM #@__shops_orders as o left join #@__shops_products as p on o.oid=p.oid left join #@__shops_delivery as d on d.pid=o.pid WHERE o.oid='{$oid}'";
$dlist = new DataListCP();
$dlist->pageSize = 20;
$dlist->SetParameter("oid", $oid);
$dlist->SetTemplate(DEDEADMIN . "/templets/shops_operations_cart.htm");
$dlist->SetSource($sql);
$dlist->Display();
$dlist->Close();
function GetSta($sta, $oid)
{
global $dsql;
$row = $dsql->GetOne("SELECT paytype FROM #@__shops_orders WHERE oid='{$oid}'");
$payname = $dsql->GetOne("SELECT name,fee FROM #@__payment WHERE id='{$row['paytype']}'");
if ($sta == 0) {
return $payname['name'] . " 手续费:" . $payname['fee'] . "元";
} else {
if ($sta == 1) {
$row['des'] = stripslashes($row['des']);
$rs = $dsql->GetOne("SELECT * FROM #@__shops_orders WHERE userid='" . $cfg_ml->M_ID . "' AND oid='{$oid}'");
$row['state'] = $rs['state'];
$row['stime'] = $rs['stime'];
$row['cartcount'] = $rs['cartcount'];
$row['price'] = $rs['price'];
$row['uprice'] = $rs['price'] / $rs['cartcount'];
$row['dprice'] = $rs['dprice'];
$row['priceCount'] = $rs['priceCount'];
$rs = $dsql->GetOne("SELECT `dname` FROM #@__shops_delivery WHERE pid='{$rs['pid']}' LIMIT 0,1");
$row['dname'] = $rs['dname'];
unset($rs);
$addsql = " AND oid='" . $oid . "'";
}
$sql = "SELECT * FROM #@__shops_products WHERE userid='" . $cfg_ml->M_ID . "' {$addsql} ORDER BY aid ASC";
$dl = new DataListCP();
$dl->pageSize = 20;
if (!empty($oid)) {
$dl->SetParameter('oid', $oid);
}
//这两句的顺序不能更换
$dl->SetTemplate(dirname(__FILE__) . "/templets/shops_products.htm");
//载入模板
$dl->SetSource($sql);
//设定查询SQL
$dl->Display();
} else {
if ($dopost == 'del') {
$ids = explode(',', $ids);
if (isset($ids) && is_array($ids)) {
foreach ($ids as $id) {
</tr>
</table>
</form>
<?php
exit;
} else {
if ($action == 'editsave') {
$db->ExecuteNoneQuery("UPDATE #@__store_groups SET storename='{$storename}',tops='{$tops}',orders='{$orders}' WHERE storeid='{$catid}'");
$msg = "成功修改栏目：{$catid} = {$storename} ！";
} else {
if ($action == 'uprank') {
foreach ($_POST as $rk => $rv) {
if (preg_match('#rank#i', $rk)) {
$catid = str_replace('rank_', '', $rk);
$db->ExecuteNoneQuery("UPDATE #@__store_groups SET orders='{$rv}' WHERE storeid='{$catid}'");
}
}
$msg = "成功更改排序 ！";
}
}
}
$sql = "SELECT storeid,storename,tops,orders FROM #@__store_groups WHERE tops=0 ORDER BY orders ASC";
$dl = new DataListCP();
$dl->pageSize = 20;
//这两句的顺序不能更换
$dl->SetTemplate(DEDEADMIN . "/templets/group_store.htm");
//载入模板
$dl->SetSource($sql);
//设定查询SQL
$dl->Display();
//显示
exit;
} else {
ShowMsg("添加分类成功！", "mail_type.php");
exit;
}
} elseif ($dopost == "editsave") {
if ($typename == "") {
ShowMsg("分类名不能为空", "-1");
exit;
}
$typename = Html2Text($typename, 1);
$description = Html2Text($description, 1);
$query = "UPDATE #@__mail_type SET typename='{$typename}',description='{$description}' WHERE id={$id}";
if (!$dsql->ExecuteNoneQuery($query)) {
ShowMsg("更新数据库#@__mail_type表时出错，请检查！", "javascript:;");
exit;
} else {
ShowMsg("更改分类成功！", "mail_type.php");
exit;
}
} elseif ($dopost == "delete") {
$dsql->ExecuteNoneQuery("Delete From `#@__mail_type` where id='{$id}'");
ShowMsg("删除分类成功！", "mail_type.php");
exit;
} else {
$sql = "SELECT * FROM `#@__mail_type` ORDER BY id ";
$dlist = new DataListCP();
$dlist->SetTemplet(DEDEADMIN . "/templets/mail_type_main.htm");
$dlist->SetSource($sql);
$dlist->display();
}
$dquery .= " OR aid='{$id}' ";
}
}
if ($dquery != "") {
$dquery = " WHERE " . $dquery;
}
$dsql->ExecuteNoneQuery("DELETE FROM #@__moneycard_record {$dquery}");
ShowMsg("成功删除指定的记录！", "cards_manage.php");
exit;
} else {
$addsql = '';
if (isset($isexp)) {
$addsql = " WHERE isexp='{$isexp}' ";
}
$sql = "SELECT * FROM #@__moneycard_record {$addsql} ORDER BY aid DESC";
$dlist = new DataListCP();
$dlist->pageSize = 25;
//设定每页显示记录数（默认25条）
if (isset($isexp)) {
$dlist->SetParameter("isexp", $isexp);
}
$dlist->dsql->SetQuery("SELECT * FROM #@__moneycard_type ");
$dlist->dsql->Execute('ts');
while ($rw = $dlist->dsql->GetArray('ts')) {
$TypeNames[$rw['tid']] = $rw['pname'];
}
$tplfile = DEDEADMIN . "/templets/cards_manmage.htm";
//这两句的顺序不能更换
$dlist->SetTemplate($tplfile);
//载入模板
$dlist->SetSource($sql);
}
}
$query = "INSERT INTO `{$diy->table}` (`id`, `ifcheck` {$addvar}) VALUES (NULL, 0 {$addvalue})";
if ($dsql->ExecuteNoneQuery($query)) {
$goto = "diy_list.php?action=list&diyid={$diy->diyid}";
showmsg('发布成功', $goto);
} else {
showmsg('对不起，发布不成功', '-1');
}
}
}
} else {
if ($action == 'list') {
include_once DEDEINC . '/datalistcp.class.php';
$query = "SELECT * FROM {$diy->table} ORDER BY id DESC";
$datalist = new DataListCP();
$datalist->pageSize = 10;
$datalist->SetParameter('action', 'list');
$datalist->SetParameter('diyid', $diyid);
$datalist->SetTemplate(DEDEADMIN . '/templets/diy_list.htm');
$datalist->SetSource($query);
$fieldlist = $diy->getFieldList();
$datalist->Display();
} else {
if ($action == 'edit') {
if (empty($do)) {
$id = isset($id) && is_numeric($id) ? $id : 0;
if (empty($id)) {
showMsg('非法操作！未指定id', 'javascript:;');
exit;
}
if (empty($ftype)) {
$wsql = " F.mid='{$cfg_ml->M_ID}' AND F.ftype <> '-1' ";
$tname = "所有好友";
} else {
if ($ftype == 1) {
$wsql = " F.mid='{$cfg_ml->M_ID}' AND F.ftype = '1' ";
$tname = "特别关注";
} else {
if ($ftype == -1) {
$wsql = " F.mid='{$cfg_ml->M_ID}' AND F.ftype = '-1' ";
$tname = "黑名单";
}
}
}
$query = "SELECT F.*,G.groupname FROM `#@__member_group` AS G LEFT JOIN #@__member_friends AS F ON F.groupid=G.id WHERE {$wsql} ORDER BY F.id DESC";
$dlist = new DataListCP();
$dlist->pageSize = 20;
$dlist->SetParameter("ftype", $ftype);
$dlist->SetTemplate(dirname(__FILE__) . '/templets/myfriend.htm');
$dlist->SetSource($query);
$dlist->Display();
}
}
/**
* 获取用户信息
*
* @param int $uid 用户UID
* @param string $_field 用户字段
* @return string
*/
function getUserInfo($uid, $_field = 'uname')
$row3 = "INSERT INTO\r\n `#@__member_pms` (`floginid`,`fromid`,`toid`,`tologinid`,`folder`,`subject`,`sendtime`,`writetime`,`hasview`,`isadmin`,`message`)\r\n VALUES ('admin','{$row['id']}','{$cfg_ml->M_ID}','{$cfg_ml->M_LoginID}','inbox','{$row['subject']}','{$row['sendtime']}','{$row['writetime']}','{$row['hasview']}','{$row['isadmin']}','{$row['message']}')";
$dsql->ExecuteNoneQuery($row3);
}
}
if ($state == "1") {
$wsql = " toid='{$cfg_ml->M_ID}' AND folder='inbox' AND writetime!='' and hasview=1";
$tname = "收件箱";
} else {
if ($state == "-1") {
$wsql = "toid='{$cfg_ml->M_ID}' AND folder='inbox' AND writetime!='' and hasview=0";
$tname = "收件箱";
} else {
$wsql = " toid='{$cfg_ml->M_ID}' AND folder='inbox' AND writetime!=''";
$tname = "收件箱";
}
}
} else {
$wsql = " `fromid` ='{$cfg_ml->M_ID}' AND folder LIKE 'outbox'";
$tname = "已发信息";
}
$query = "SELECT * FROM `#@__member_pms` WHERE {$wsql} ORDER BY sendtime DESC";
$dlist = new DataListCP();
$dlist->pageSize = 20;
$dlist->SetParameter("dopost", $dopost);
$dlist->SetTemplate(DEDEMEMBER . '/templets/pm-main.htm');
$dlist->SetSource($query);
$dlist->Display();
}
}
}
}
$keywords = preg_replace("#[\"\r\n\t\\*\\?\\(\\)\$%']#", " ", trim($keywords));
$keywords = addslashes($keywords);
$addsql = "WHERE gid='{$id}' AND closed='0' ";
if ($typeid > 0) {
$addsql .= "AND smalltype='{$typeid}' ";
}
if (!empty($keywords)) {
$addsql .= "AND subject like '%" . $keywords . "%' ";
}
function _get_smalltype($id, $_field = 'name')
{
global $db;
$row = $db->GetOne("SELECT `id`,`name` FROM `#@__group_smalltypes` WHERE id='{$id}'");
if (isset($row[$_field])) {
return '[' . $row[$_field] . ']';
}
}
static $row_fields = false;
$sql = "SELECT tid,subject,digest,displayorder,replies,lastpost,lastposter,smalltype,author,views FROM #@__group_threads {$addsql} ORDER BY displayorder DESC, lastpost DESC";
$dl = new DataListCP();
$dl->pageSize = 20;
$dl->SetParameter('id', $id);
$dl->SetParameter("keywords", $keywords);
$dl->SetParameter("typeid", $typeid);
//这两句的顺序不能更换
$dl->SetTemplate(GROUP_TPL . '/groupdisplay.html');
//载入模板
$dl->SetSource($sql);
//设定查询SQL
$dl->Display();
//显示
$wheres[] = " spacesta = '{$spacesta}' ";
}
if ($matt != 10) {
$wheres[] = " matt= '{$matt}' ";
}
$whereSql = join(' AND ', $wheres);
if ($whereSql != '') {
$whereSql = ' WHERE ' . $whereSql;
}
$dsql->SetQuery("SELECT name FROM `#@__member_model`");
$dsql->Execute();
while ($row = $dsql->GetArray()) {
$MemberModels[] = $row;
}
$sql = "SELECT * FROM `#@__member` {$whereSql} ORDER BY {$sortkey} DESC ";
$dlist = new DataListCP();
$dlist->SetParameter('sex', $sex);
$dlist->SetParameter('spacesta', $spacesta);
$dlist->SetParameter('matt', $matt);
$dlist->SetParameter('mtype', $mtype);
$dlist->SetParameter('sortkey', $sortkey);
$dlist->SetParameter('keyword', $keyword);
$dlist->SetTemplet(DEDEADMIN . "/templets/member_main.htm");
$dlist->SetSource($sql);
$dlist->display();
function GetMemberName($rank, $mt)
{
global $MemberTypes;
if (isset($MemberTypes[$rank])) {
if ($mt == 'ut') {
return " <font color='red'>待升级：" . $MemberTypes[$rank] . "</font>";
<?php
/**
* 自定义表单列表管理
*
* @version $Id: diy_main.php 1 18:31 2010年7月12日Z tianya $
* @package DedeCMS.Administrator
* @copyright Copyright (c) 2007 - 2010, DesDev, Inc.
* @license http://help.dedecms.com/usersguide/license.html
* @link http://www.dedecms.com
*/
require_once dirname(__FILE__) . "/config.php";
CheckPurview('c_List');
require_once DEDEINC . "/datalistcp.class.php";
require_once DEDEINC . "/common.func.php";
setcookie("ENV_GOBACK_URL", $dedeNowurl, time() + 3600, "/");
$sql = "Select `diyid`,`name`,`table` From #@__diyforms order by diyid asc";
$dlist = new DataListCP();
$dlist->SetTemplet(DEDEADMIN . "/templets/diy_main.htm");
$dlist->SetSource($sql);
$dlist->display();
$dlist->Close();
