function option_sub_cat($parent_id, $cat, $pre) { $db = new FQuery(); $sql = $db->select(FDBPrefix . "article_category", "*", "parent_id={$parent_id} AND id!={$_REQUEST['id']}"); while ($qr = mysql_fetch_array($sql)) { $s = multipleSelected($cat, $qr['id']); echo "<option value='{$qr['id']}' {$s}>{$pre} |_ {$qr['name']}</option>"; option_sub_cat($qr['id'], $cat, $pre . " "); } }
" style="min-width:120px;" required="required"> <option value=""></option> <?php $_GET['id'] = 0; $db = new FQuery(); $db->connect(); $sql = $db->select(FDBPrefix . 'article_category', '*', 'parent_id=0'); while ($qrs = mysql_fetch_array($sql)) { if ($qrs['level'] >= $_SESSION['USER_LEVEL']) { if ($qr['category'] == $qrs['id']) { $s = "selected"; } else { $s = ""; } echo "<option value='{$qrs['id']}' {$s}>{$qrs['name']}</option>"; option_sub_cat($qrs['id'], ''); } } ?> </select></td> </tr> <tr> <td class="row-title" title="<?php echo Active_Status; ?> ">Status</td> <td> <?php if ($qr['status'] or $_GET['act'] == 'add') { $status1 = "selected checked"; $status0 = "";
function option_sub_cat($parent_id, $pre) { $db = new FQuery(); $db->connect(); $sql = $db->select(FDBPrefix . "article_category", "*", "parent_id={$parent_id} AND id!={$_REQUEST['id']}"); while ($qr = mysql_fetch_array($sql)) { //select article 'info'rmation $sql2 = $db->select(FDBPrefix . 'article', '*', "id={$_REQUEST['id']}"); $at = mysql_fetch_array($sql2); //select article category 'info'rmation $sql3 = $db->select(FDBPrefix . 'article_category', '*', "id={$_REQUEST['id']}"); $pd = mysql_fetch_array($sql3); if ($pd['parent_id'] == $qr['id'] or $at['category'] == $qr['id']) { $s = "selected"; } else { $s = ""; } echo "<option value='{$qr['id']}' {$s}>{$pre} |_ {$qr['name']}</option>"; option_sub_cat($qr['id'], $pre . " "); } }
function option_sub_cat($parent_id, $pre) { $db = new FQuery(); $db->connect(); if (!isset($_REQUEST['id']) or $_REQUEST['act'] == 'add') { $sql = $db->select(FDBPrefix . "article_category", "*", "parent_id={$parent_id}"); } else { $sql = $db->select(FDBPrefix . "article_category", "*", "parent_id={$parent_id} AND id != {$_REQUEST['id']}"); } while ($qr = @mysql_fetch_array($sql)) { if ($qr['level'] >= $_SESSION['USER_LEVEL']) { $scat = $pcat = 0; if (isset($_REQUEST['id'])) { $scat = oneQuery('article', 'id', $_REQUEST['id'], 'category'); $pcat = oneQuery('article_category', 'id', $scat, 'parent_id'); } if ($pcat == $qr['id'] or $scat == $qr['id']) { $s = "selected"; } else { $s = ""; } echo "<option value='{$qr['id']}' {$s}>{$pre}|_ {$qr['name']}</option>"; option_sub_cat($qr['id'], $pre . " "); } } }
?> "><?php echo Parent_category; ?> </span></td> <td><select name="parent_id" class="parents" data-placeholder="<?php echo Choose_category; ?> " style="min-width:125px;"> <option value=''></option> <?php $level = $row['level']; $sql2 = $db->select(FDBPrefix . 'article_category', '*', 'parent_id=0'); while ($row2 = mysql_fetch_array($sql2)) { echo "<option value='{$row2['id']}'>{$row2['name']}</option>"; option_sub_cat($row2['id'], ""); } ?> </select></td> </tr> <tr> <td class="row-title"><span class="tips" title="<?php echo Category_level; ?> "><?php echo Access_Level; ?> </span></td> <td><select name="level" > <?php $sql2 = $db->select(FDBPrefix . 'user_group');
<tr class="category"> <td class="row-title">Category</td> <td> <select id="cat"> <?php $db = new FQuery(); $db->connect(); $sql = $db->select(FDBPrefix . 'article_category', '*', 'parent_id=0'); while ($qrs = mysql_fetch_array($sql)) { if ("?app=article&view=category&id={$qrs['id']}" == $qr['link']) { $s = "selected"; } else { $s = ""; } echo "<option value='{$qrs['id']}' {$s}>{$qrs['name']}</option>"; option_sub_cat($qrs['id'], '', $qr['link']); } ?> </select> </td> </tr> <tr class="item" > <td class="row-title">Article</td> <td> <input type="hidden" value="?app=article&view=item&id=<?php echo $id; ?> " id="pgs" size="20" readonly /> <input type="text" value="<?php