0) { $set = ''; while ($row = mysql_fetch_array($result)) $set .= $row['cid'] . ','; $set = '(' . substr($set, 0, -1) . ')'; $sql = "UPDATE {$CONFIG['TABLE_CATEGORIES']} " . "SET parent = '0' " . "WHERE parent=cid OR parent NOT IN $set"; $result = db_query($sql); } } function get_subcat_data($parent, $ident = '') { global $CONFIG, $CAT_LIST; $sql = "SELECT cid, name, description " . "FROM {$CONFIG['TABLE_CATEGORIES']} " . "WHERE parent = '$parent' " . "ORDER BY pos"; $result = db_query($sql); if (($cat_count = mysql_num_rows($result)) > 0) { $rowset = db_fetch_rowset($result); $pos = 0; foreach ($rowset as $subcat) { if ($pos > 0) { $CAT_LIST[] = array('cid' => $subcat['cid'], 'parent' => $parent, 'pos' => $pos++, 'prev' => $prev_cid, 'cat_count' => $cat_count, 'name' => $ident . $subcat['name']); $CAT_LIST[$last_index]['next'] = $subcat['cid']; } else { $CAT_LIST[] = array('cid' => $subcat['cid'], 'parent' => $parent, 'pos' => $pos++, 'cat_count' => $cat_count, 'name' => $ident . $subcat['name']); } $prev_cid = $subcat['cid']; $last_index = count($CAT_LIST) -1; get_subcat_data($subcat['cid'], $ident . '   '); } } } function update_cat_order() { global $CAT_LIST, $CONFIG; foreach ($CAT_LIST as $category) db_query("UPDATE {$CONFIG['TABLE_CATEGORIES']} SET pos='{$category['pos']}' WHERE cid = '{$category['cid']}' LIMIT 1"); } function cat_list_box($highlight = 0, $curr_cat, $on_change_refresh = true) { global $CAT_LIST, $PHP_SELF,$lang_albmgr_php; if ($on_change_refresh) { $lb = <<< EOT EOT; } else { $lb = <<< EOT EOT; } $lb .= ' ' . $lang_albmgr_php['no_category'] . "\n"; foreach($CAT_LIST as $category) if ($category['cid'] != 1 && $category['cid'] != $curr_cat) { $lb .= ' " . $category['name'] . "\n"; } elseif ($category['cid'] != 1 && $category['cid'] == $curr_cat) { $lb .= ' " . $category['name'] . "\n"; } $lb .= << EOT; return $lb; } function form_alb_thumb() { global $CONFIG, $lang_catmgr_php, $lang_modifyalb_php, $current_category, $cid; $results = db_query("SELECT pid, filepath, filename, url_prefix FROM {$CONFIG['TABLE_PICTURES']},{$CONFIG['TABLE_ALBUMS']} WHERE {$CONFIG['TABLE_PICTURES']}.aid = {$CONFIG['TABLE_ALBUMS']}.aid AND {$CONFIG['TABLE_ALBUMS']}.category = '$cid' AND approved='YES' ORDER BY filename"); if (mysql_num_rows($results) == 0) { echo << {$lang_modifyalb_php['alb_thumb']} {$lang_modifyalb_php['alb_empty']} EOT; return; } echo << var Pic = new Array() Pic[0] = 'images/nopic.jpg' EOT; $initial_thumb_url = 'images/nopic.jpg'; $img_list = array(0 => $lang_modifyalb_php['last_uploaded']); while ($picture = mysql_fetch_array($results)) { $thumb_url = get_pic_url($picture, 'thumb'); echo "Pic[{$picture['pid']}] = '" . $thumb_url . "'\n"; if ($picture['pid'] == $current_category['thumb']) $initial_thumb_url = $thumb_url; $img_list[$picture['pid']] = htmlspecialchars($picture['filename']); } // while echo << EOT; $thumb_cell_height = $CONFIG['thumb_width'] + 17; echo << {$lang_catmgr_php['cat_thumb']} EOT; foreach($img_list as $pid => $pic_name) { echo ' ' . $pic_name . "\n"; } echo << EOT; } function display_cat_list() { global $CAT_LIST, $PHP_SELF; $CAT_LIST3 = $CAT_LIST; foreach ($CAT_LIST3 as $key => $category) { echo " \n"; echo ' ' . $category['name'] . '' . "\n"; if ($category['pos'] > 0) { echo ' ' . '' . '' . "\n"; } else { echo ' ' . ' ' . '' . "\n"; } if ($category['pos'] < $category['cat_count']-1) { echo ' ' . '' . '' . "\n"; } else { echo ' ' . ' ' . '' . "\n"; } if ($category['cid'] != 1) { echo ' ' . '' . '' . "\n"; } else { echo ' ' . ' ' . '' . "\n"; } echo ' ' . '' . '' . '' . "\n"; echo ' ' . "\n" . cat_list_box($category['parent'], $category['cid']) . "\n" . '' . "\n"; echo " \n"; } } function verify_children($parent, $cid) { global $CONFIG, $children; $sql = "SELECT cid " . "FROM {$CONFIG['TABLE_CATEGORIES']} " . "WHERE parent = '$parent' "; $result = db_query($sql); if (($cat_count = mysql_num_rows($result)) > 0) { while ($row = mysql_fetch_array($result)) { $children[]=$row['cid']; // call this function again to this this // child's children verify_children($row['cid'], $cid); } } return false; } $op = isset($HTTP_GET_VARS['op']) ? $HTTP_GET_VARS['op'] : ''; $current_category = array('cid' => '0', 'name' => '', 'parent' => '0', 'description' => ''); switch ($op) { case 'move': if (!isset($HTTP_GET_VARS['cid1']) || !isset($HTTP_GET_VARS['cid2']) || !isset($HTTP_GET_VARS['pos1']) || !isset($HTTP_GET_VARS['pos2'])) cpg_die(CRITICAL_ERROR, sprintf($lang_catmgr_php['miss_param'], 'move'), __FILE__, __LINE__); $cid1 = (int)$HTTP_GET_VARS['cid1']; $cid2 = (int)$HTTP_GET_VARS['cid2']; $pos1 = (int)$HTTP_GET_VARS['pos1']; $pos2 = (int)$HTTP_GET_VARS['pos2']; db_query("UPDATE {$CONFIG['TABLE_CATEGORIES']} SET pos='$pos1' WHERE cid = '$cid1' LIMIT 1"); db_query("UPDATE {$CONFIG['TABLE_CATEGORIES']} SET pos='$pos2' WHERE cid = '$cid2' LIMIT 1"); break; case 'setparent': if (!isset($HTTP_GET_VARS['cid']) || !isset($HTTP_GET_VARS['parent'])) cpg_die(CRITICAL_ERROR, sprintf($lang_catmgr_php['miss_param'], 'setparent'), __FILE__, __LINE__); $cid = (int)$HTTP_GET_VARS['cid']; $parent = (int)$HTTP_GET_VARS['parent']; $children=array(); verify_children($cid, $cid); if (!in_array($parent, $children)){ db_query("UPDATE {$CONFIG['TABLE_CATEGORIES']} SET parent='$parent', pos='-1' WHERE cid = '$cid' LIMIT 1"); }else{ cpg_die(ERROR, "You cannot move a category into its own child", __FILE__, __LINE__); } break; case 'editcat': if (!isset($HTTP_GET_VARS['cid'])) cpg_die(CRITICAL_ERROR, sprintf($lang_catmgr_php['miss_param'], 'editcat'), __FILE__, __LINE__); $cid = (int)$HTTP_GET_VARS['cid']; $result = db_query("SELECT cid, name, parent, description, thumb FROM {$CONFIG['TABLE_CATEGORIES']} WHERE cid = '$cid' LIMIT 1"); if (!mysql_num_rows($result)) cpg_die(ERROR, $lang_catmgr_php['unknown_cat'], __FILE__, __LINE__); $current_category = mysql_fetch_array($result); break; case 'updatecat': if (!isset($HTTP_POST_VARS['cid']) || !isset($HTTP_POST_VARS['parent']) || !isset($HTTP_POST_VARS['name']) || !isset($HTTP_POST_VARS['description'])) cpg_die(CRITICAL_ERROR, sprintf($lang_catmgr_php['miss_param'], 'updatecat'), __FILE__, __LINE__); $name = trim($HTTP_POST_VARS['name']); if (empty($name)){ break; } $cid = (int)$HTTP_POST_VARS['cid']; $parent = (int)$HTTP_POST_VARS['parent']; $thumb = (int)$HTTP_POST_VARS['thumb']; $name = trim($HTTP_POST_VARS['name']) ? addslashes($HTTP_POST_VARS['name']) : '<???>'; $description = addslashes($HTTP_POST_VARS['description']); $children=array(); verify_children($cid, $cid); if (!in_array($parent, $children)){ db_query("UPDATE {$CONFIG['TABLE_CATEGORIES']} SET parent='$parent', name='$name', description='$description', thumb='$thumb' WHERE cid = '$cid' LIMIT 1"); }else{ db_query("UPDATE {$CONFIG['TABLE_CATEGORIES']} SET name='$name', description='$description', thumb='$thumb' WHERE cid = '$cid' LIMIT 1"); } break; case 'createcat': if (!isset($HTTP_POST_VARS['parent']) || !isset($HTTP_POST_VARS['name']) || !isset($HTTP_POST_VARS['description'])) cpg_die(CRITICAL_ERROR, sprintf($lang_catmgr_php['miss_param'], 'createcat'), __FILE__, __LINE__); $name = trim($HTTP_POST_VARS['name']); if (empty($name)){ break; } $parent = (int)$HTTP_POST_VARS['parent']; $name = trim($HTTP_POST_VARS['name']) ? addslashes($HTTP_POST_VARS['name']) : '<???>'; $description = addslashes($HTTP_POST_VARS['description']); db_query("INSERT INTO {$CONFIG['TABLE_CATEGORIES']} (pos, parent, name, description) VALUES ('10000', '$parent', '$name', '$description')"); break; case 'deletecat': if (!isset($HTTP_GET_VARS['cid'])) cpg_die(CRITICAL_ERROR, sprintf($lang_catmgr_php['miss_param'], 'deletecat'), __FILE__, __LINE__); $cid = (int)$HTTP_GET_VARS['cid']; $result = db_query("SELECT parent FROM {$CONFIG['TABLE_CATEGORIES']} WHERE cid = '$cid' LIMIT 1"); if ($cid == 1) cpg_die(ERROR, $lang_catmgr_php['usergal_cat_ro'], __FILE__, __LINE__); if (!mysql_num_rows($result)) cpg_die(ERROR, $lang_catmgr_php['unknown_cat'], __FILE__, __LINE__); $del_category = mysql_fetch_array($result); $parent = $del_category['parent']; $result = db_query("UPDATE {$CONFIG['TABLE_CATEGORIES']} SET parent='$parent' WHERE parent = '$cid'"); $result = db_query("UPDATE {$CONFIG['TABLE_ALBUMS']} SET category='$parent' WHERE category = '$cid'"); $result = db_query("DELETE FROM {$CONFIG['TABLE_CATEGORIES']} WHERE cid='$cid' LIMIT 1"); break; } fix_cat_table(); get_subcat_data(0); update_cat_order(); pageheader($lang_catmgr_php['manage_cat']); echo << function confirmDel(catName) { return confirm("{$lang_catmgr_php['confirm_delete']} (" + catName + ") ?"); } EOT; starttable('100%'); echo << {$lang_catmgr_php['category']} {$lang_catmgr_php['operations']} {$lang_catmgr_php['move_into']}

EOT; display_cat_list(); echo << EOT; endtable(); echo "
\n"; starttable('100%', $lang_catmgr_php['update_create'], 2); $lb = cat_list_box($current_category['parent'], $current_category['cid'], false); $op = $current_category['cid'] ? 'updatecat' : 'createcat'; echo <<

{$lang_catmgr_php['parent_cat']} $lb {$lang_catmgr_php['cat_title']} {$lang_catmgr_php['cat_desc']} {$current_category['description']} EOT; form_alb_thumb(); echo << EOT; endtable(); pagefooter(); ob_end_flush(); ?>