function UpIndexKey($id, $arcrank, $typeid, $sortrank = 0, $tags = '') { global $dsql, $typeid2; if (empty($typeid2)) { $typeid2 = 0; } $addtime = time(); $query = " Update `#@__arctiny` set `arcrank`='{$arcrank}', `typeid`='{$typeid}',`sortrank`='{$sortrank}' where id = '{$id}' "; $dsql->ExecuteNoneQuery($query); $query = " Update `#@__arctiny` set `typeid2`='{$typeid2}' where id = '{$id}' "; $dsql->ExecuteNoneQuery($query); /* * 处理修改后的Tag */ if ($tags != '') { $oldtag = GetTags($id); $oldtags = explode(',', $oldtag); $tagss = explode(',', $tags); foreach ($tagss as $tag) { $tag = trim($tag); if (isset($tag[12]) || $tag != stripslashes($tag)) { continue; } if (!in_array($tag, $oldtags)) { InsertOneTag($tag, $id); } } foreach ($oldtags as $tag) { if (!in_array($tag, $tagss)) { $dsql->ExecuteNoneQuery("Delete From `#@__taglist` where aid='{$id}' And tag like '{$tag}' "); $dsql->ExecuteNoneQuery("Update `#@__tagindex` set total=total-1 where tag like '{$tag}' "); } else { $dsql->ExecuteNoneQuery("Update `#@__taglist` set `arcrank` = '{$arcrank}', `typeid` = '{$typeid}' where tag like '{$tag}' "); } } } }
exit; } $query = "SELECT * FROM `#@__channeltype` WHERE id='" . $arcRow['channel'] . "'"; $cInfos = $dsql->GetOne($query); if (!is_array($cInfos)) { ShowMsg("读取频道配置信息出错!", "javascript:;"); exit; } $addtable = $cInfos['addtable']; $addRow = $dsql->GetOne("SELECT * FROM `{$addtable}` WHERE aid='{$aid}'"); if (!is_array($addRow)) { ShowMsg("读取附加信息出错!", "javascript:;"); exit; } $channelid = $arcRow['channel']; $tags = GetTags($aid); include DedeInclude("templets/article_edit.htm"); exit; } else { if ($dopost == 'save') { require_once DEDEINC . '/image.func.php'; require_once DEDEINC . '/oxwindow.class.php'; $flag = isset($flags) ? join(',', $flags) : ''; $notpost = isset($notpost) && $notpost == 1 ? 1 : 0; if (empty($typeid2)) { $typeid2 = 0; } if (!isset($autokey)) { $autokey = 0; } if (!isset($remote)) {
function UpIndexKey($id, $arcrank, $typeid, $sortrank = 0, $tags = '') { global $dsql, $typeid2; if (empty($typeid2)) { $typeid2 = 0; } $addtime = time(); $query = " UPDATE `#@__arctiny` SET `arcrank`='{$arcrank}', `typeid`='{$typeid}', `typeid2`='{$typeid2}', `sortrank`='{$sortrank}' WHERE id = '{$id}' "; $dsql->ExecuteNoneQuery($query); /* * 处理修改后的Tag */ if ($tags != '') { $oldtag = GetTags($id); $oldtags = explode(',', $oldtag); $tagss = explode(',', $tags); foreach ($tagss as $tag) { $tag = trim($tag); if (isset($tag[12]) || $tag != stripslashes($tag)) { continue; } if (!in_array($tag, $oldtags)) { InsertOneTag($tag, $id); } } foreach ($oldtags as $tag) { if (!in_array($tag, $tagss)) { $dsql->ExecuteNoneQuery("DELETE FROM `#@__taglist` WHERE aid='{$id}' AND tag LIKE '{$tag}' "); $dsql->ExecuteNoneQuery("UPDATE `#@__tagindex` SET total=total-1 WHERE tag LIKE '{$tag}' "); } else { $dsql->ExecuteNoneQuery("UPDATE `#@__taglist` SET `arcrank` = '{$arcrank}', `typeid` = '{$typeid}' WHERE tag LIKE '{$tag}' "); } } } }
/** * php5构造函数 * * @access public * @param int $aid 文档ID * @return string */ function __construct($aid) { global $dsql, $ftp; $this->IsError = FALSE; $this->ArcID = $aid; $this->PreNext = array(); $this->dsql = $dsql; $query = "SELECT channel,typeid FROM `#@__arctiny` WHERE id='{$aid}' "; $arr = $this->dsql->GetOne($query); if (!is_array($arr)) { $this->IsError = TRUE; } else { if ($arr['channel'] == 0) { $arr['channel'] = 1; } $this->ChannelUnit = new ChannelUnit($arr['channel'], $aid); $this->TypeLink = new TypeLink($arr['typeid']); if ($this->ChannelUnit->ChannelInfos['issystem'] != -1) { // 如果当前文档不是系统模型,为单表模型 $query = "SELECT arc.*,tp.reid,tp.typedir,ch.addtable\n FROM `#@__archives` arc\n LEFT JOIN #@__arctype tp on tp.id=arc.typeid\n LEFT JOIN #@__channeltype as ch on arc.channel = ch.id\n WHERE arc.id='{$aid}' "; $this->Fields = $this->dsql->GetOne($query); } else { $this->Fields['title'] = ''; $this->Fields['money'] = $this->Fields['arcrank'] = 0; $this->Fields['senddate'] = $this->Fields['pubdate'] = $this->Fields['mid'] = $this->Fields['adminid'] = 0; $this->Fields['ismake'] = 1; $this->Fields['filename'] = ''; } if ($this->TypeLink->TypeInfos['corank'] > 0 && $this->Fields['arcrank'] == 0) { $this->Fields['arcrank'] = $this->TypeLink->TypeInfos['corank']; } $this->Fields['tags'] = GetTags($aid); $this->dtp = new DedeTagParse(); $this->dtp->SetRefObj($this); $this->SplitPageField = $this->ChannelUnit->SplitPageField; $this->SplitFields = ''; $this->TotalPage = 1; $this->NameFirst = ''; $this->ShortName = 'html'; $this->FixedValues = ''; $this->TempSource = ''; $this->ftp =& $ftp; $this->remoteDir = ''; if (empty($GLOBALS['pageno'])) { $this->NowPage = 1; } else { $this->NowPage = $GLOBALS['pageno']; } //特殊的字段数据处理 $this->Fields['aid'] = $aid; $this->Fields['id'] = $aid; $this->Fields['position'] = $this->TypeLink->GetPositionLink(TRUE); $this->Fields['typeid'] = $arr['typeid']; //设置一些全局参数的值 foreach ($GLOBALS['PubFields'] as $k => $v) { $this->Fields[$k] = $v; } //为了减少重复查询,这里直接把附加表查询记录放在 $this->addTableRow 中,在 ParAddTable() 不再查询 if ($this->ChannelUnit->ChannelInfos['addtable'] != '') { $query = "SELECT * FROM `{$this->ChannelUnit->ChannelInfos['addtable']}` WHERE `aid` = '{$aid}'"; $this->addTableRow = $this->dsql->GetOne($query); } //issystem==-1 表示单表模型,单表模型不支持redirecturl这类参数,因此限定内容普通模型才进行下面查询 if ($this->ChannelUnit->ChannelInfos['addtable'] != '' && $this->ChannelUnit->ChannelInfos['issystem'] != -1) { if (is_array($this->addTableRow)) { $this->Fields['redirecturl'] = $this->addTableRow['redirecturl']; $this->Fields['templet'] = $this->addTableRow['templet']; $this->Fields['userip'] = $this->addTableRow['userip']; } $this->Fields['templet'] = empty($this->Fields['templet']) ? '' : trim($this->Fields['templet']); $this->Fields['redirecturl'] = empty($this->Fields['redirecturl']) ? '' : trim($this->Fields['redirecturl']); $this->Fields['userip'] = empty($this->Fields['userip']) ? '' : trim($this->Fields['userip']); } else { $this->Fields['templet'] = $this->Fields['redirecturl'] = ''; } } //!error }
td span { white-space: nowrap; } //--></STYLE> </HEAD> <BODY BGCOLOR="silver"> <DIV ALIGN=center> <?php echo AdminMenu(); echo FramedTable1(); $result = db_query("SELECT * FROM {categories} WHERE id = {$page_id}"); if (db_num_rows($result)) { $item = db_fetch_array($result); $frm['#tags'] = GetTags(); echo '<form method="post"><table border="0">'; echo '<tr><td width="50"></td><td><b>' . $item['name'] . '</b>:</td><td>'; echo FormInput('search', 25) . ' <input type="submit" value=" Search ">'; echo '</td><td width="50"></td></tr>'; echo '<tr><td width="50"></td><td>Tags: ' . FormSelect('cond', array('and' => 'and', 'or' => 'or')) . '</td><td>'; echo FormCheckarea('tags'); echo '</td><td width="50"></td></tr>'; echo '</table></form>'; $cond = array("C.lnum BETWEEN {$item['lnum']} AND {$item['rnum']}", "P.id = C.id_parent", "C.uniqid = G.uid_cat"); if (!empty($frm['search'])) { $cond[] = "(upper(G.name) LIKE upper('%{$frm['search']}%') OR upper(G.description) LIKE upper('%{$frm['search']}%'))"; } if (isset($frm['tags']) && count($frm['tags'])) { if ($frm['cond'] == 'or') { $cond[] = "G.id IN (SELECT id_col FROM {tag_collections} T WHERE id_tag IN (" . join(',', $frm['tags']) . "))";
function DisplayCollectionForm() { global $page_id, $frm; // Wartości domyślne if (!isset($frm)) { $frm = array('sercol' => 5, 'serrow' => 4, 'datecr' => date('Y-m-d')); } if ($page_id) { GetCollectionData($page_id); } $hier_cat = GetCategoriesHierarchy($frm[parent], $page_id, 1); // Odczytanie tagów $frm['#tags'] = GetTags(); SetCollectionTags($page_id, 'tags'); echo FramedTable1() . '<FORM METHOD="POST">' . '<TABLE BORDER=0 CELLSPACING=1 CELLPADDING=1>' . '<TR><TH> Collection </TH><TD></TD></TR>' . '<TR><TD></TD><TD ALIGN=right> ' . FormSelect('action', array('mod' => 'Modify', 'del' => 'Delete')) . ' <INPUT TYPE="submit" VALUE=" Send "> ' . '</TD></TR>' . '<TR><TD> Category: </TD><TD> ' . '<SELECT NAME="frm[parent]">' . $hier_cat . '</SELECT>' . ' Position ' . FormInput('position', 4, 1) . ' </TD></TR>' . '<TR><TD> Uniqid & Date: </TD><TD> ' . FormInput('uniqid') . ' ' . FormInput('datecr', 12) . ' </TD></TR>' . '<TR><TD> Name: </TD><TD> ' . FormInput('name') . ' </TD></TR>' . '<TR><TD> Title: </TD><TD> ' . FormInput('title') . ' </TD></TR>' . '<TR><TD> Header: </TD><TD> ' . FormInput('header') . ' </TD></TR>' . '<TR><TD> Description: </TD><TD> ' . FormText('desc', 80, 5) . '<BR>' . FormCheckbox('addbr') . ' Auto add "break line" </TD></TR>' . '<TR><TD COLSPAN=2><HR></TD></TR>' . '<TR><TD> Tags: </TD><TD> ' . FormCheckarea('tags') . ' </TD></TR>' . '<TR><TD> New tags: </TD><TD> ' . FormText('newtags', 80, 2) . ' </TD></TR>' . '<TR><TD COLSPAN=2><HR></TD></TR>' . '<TR><TD> Series: </TD><TD> ' . FormSelect('sercol', range(1, 10), 0) . ' x ' . FormSelect('serrow', range(1, 10), 0) . ' (columns x rows) ' . '</TD></TR>' . '<TR><TD> Images: </TD><TD> First number ' . FormInput('first', 4, 1) . ' Quantity ' . FormInput('quantity', 4, 1) . ' </TD></TR>' . '<TR><TD> Number holes: </TD><TD> ' . FormText('holes', 60, 2) . ' </TD></TR>' . '<TR><TD COLSPAN=2><HR></TD></TR>' . '<TR><TD> Collection directory: </TD><TD> ' . FormInput('dirgr') . ' </TD></TR>' . '<TR><TD> Image directory: </TD><TD> ' . FormInput('dirimg') . ' </TD></TR>' . '<TR><TD> Thumbnails directory: </TD><TD> ' . FormInput('dirth') . ' </TD></TR>' . '<TR><TD COLSPAN=2><HR></TD></TR>' . '<TR><TD> Pages template: </TD><TD> ' . FormInput('temppage', 50, '%02d') . ' </TD></TR>' . '<TR><TD> Images template: </TD><TD> ' . FormInput('tempimg') . ' </TD></TR>' . '<TR><TD> Thumbnails template: </TD><TD> ' . FormInput('tempth') . ' </TD></TR>' . '<TR><TD COLSPAN=2><HR></TD></TR>' . '<TR><TD> Options: </TD><TD> Links to ' . FormSelect('options', array('' => 'None', 'LP' => 'Page', 'LI' => 'Image')) . ' ' . FormCheckbox('intro') . ' Exist intro page ' . '</TD></TR>' . '<TR><TD> Image on intro page: </TD><TD> ' . FormInput('introimg') . ' </TD></TR>' . '<TR><TD> Thumbnail for group: </TD><TD> ' . FormInput('thumbimg') . ' </TD></TR>' . '</TABLE>' . '</FORM>' . FramedTable2(); if ($page_id) { DisplayThumbForm($page_id); } }