".LBL_ADMIN_FOLDERS."\n" ."
\n"; echo "
\n"; echo "

\n"; echo "\n" ."" ."\n" ."\n" ."

\n\n"; echo "\n" ."\n" ."\t\n"; if (getConfig('rss.config.absoluteordering')) { echo "\t\n"; } echo "\t\n" ."\n"; $sql = "select id,name from " .getTable("folders"); if (getConfig('rss.config.absoluteordering')) { $sql .=" order by position asc"; } else { $sql .=" order by name asc"; } $res = rss_query($sql); $cntr = 0; while (list($id, $name) = rss_fetch_row($res)) { $name = $name == ''? LBL_HOME_FOLDER:$name; $class_ = (($cntr++ % 2 == 0)?"even":"odd"); echo "\n" ."\t\n"; if (getConfig('rss.config.absoluteordering')) { echo "\t\n"; } echo "\t\n" ."\n"; } echo "
". LBL_ADMIN_CHANNELS_HEADING_TITLE ."".LBL_ADMIN_CHANNELS_HEADING_MOVE."". LBL_ADMIN_CHANNELS_HEADING_ACTION ."
$name"; if ($id > 0) { if ($cntr > 2) { echo "". LBL_ADMIN_MOVE_UP ." - "; } echo "".LBL_ADMIN_MOVE_DOWN .""; } else { echo " "; } echo "" . LBL_ADMIN_EDIT .""; if ($id > 0) { echo "|" . LBL_ADMIN_DELETE .""; } echo "
"; echo "
\n"; } function folder_edit($fid) { $sql = "select id, name from " . getTable("folders") ." where id=$fid"; $res = rss_query($sql); list ($id, $name) = rss_fetch_row($res); echo "
\n"; echo "\n\n

Edit '$name'

\n"; echo "
\n" ."

\n" ."\n" ."\n" // Item name ."\n" ."

"; echo "

" ."
\n"; } function folder_combo($name, $selected = -1) { echo "\n\n"; } function folder_admin() { // Fix for #16: Admin (et al.) should not rely on l10n labels for actions: // Look for a meta-action first, which should be the (untranslated) *name* of // the (translated) action constant. // Fixme: should replace 'action's with a constant if (array_key_exists(CST_ADMIN_METAACTION,$_REQUEST)) { $__action__ = $_REQUEST[CST_ADMIN_METAACTION]; } elseif (array_key_exists('action',$_REQUEST)) { $__action__ = $_REQUEST['action']; } else { $__action__ = ""; } $ret__ = CST_ADMIN_DOMAIN_FOLDER; switch ($__action__) { case CST_ADMIN_EDIT_ACTION: folder_edit($_REQUEST['fid']); $ret__ = CST_ADMIN_DOMAIN_NONE; break; case CST_ADMIN_DELETE_ACTION: $id = $_REQUEST['fid']; assert(is_numeric($id)); if ($id == 0) { rss_error(LBL_ADMIN_ERROR_CANT_DELETE_HOME_FOLDER, RSS_ERROR_ERROR,true); break; } if (array_key_exists(CST_ADMIN_CONFIRMED,$_REQUEST) && $_REQUEST[CST_ADMIN_CONFIRMED] == LBL_ADMIN_YES) { $sql = "delete from " . getTable("folders") ." where id=$id"; rss_query($sql); $sql = "update " . getTable("channels") ." set parent=" . getRootFolder() . " where parent=$id"; rss_query($sql); } elseif (array_key_exists(CST_ADMIN_CONFIRMED,$_REQUEST) && $_REQUEST[CST_ADMIN_CONFIRMED] == LBL_ADMIN_NO) { // nop; } else { list($fname) = rss_fetch_row(rss_query("select name from " .getTable("folders") ." where id = $id")); echo "
\n" ."

"; printf(LBL_ADMIN_ARE_YOU_SURE,$fname); echo "

\n" ."

\n" ."\n" ."\n" ."\n" ."\n" ."

\n
\n"; $ret__ = CST_ADMIN_DOMAIN_NONE; } break; case CST_ADMIN_SUBMIT_EDIT: $id = $_REQUEST['fid']; $new_label = rss_real_escape_string($_REQUEST['f_name']); if (is_numeric($id) && strlen($new_label) > 0) { $res = rss_query("select count(*) as cnt from " . getTable("folders") ." where binary name='$new_label'"); list($cnt) = rss_fetch_row($res); if ($cnt > 0) { rss_error(sprintf(LBL_ADMIN_CANT_RENAME,$new_label), RSS_ERROR_ERROR,true); break; } rss_query("update " .getTable("folders") ." set name='$new_label' where id=$id"); } break; case LBL_ADMIN_ADD: case 'LBL_ADMIN_ADD': $label=$_REQUEST['new_folder']; assert(strlen($label) > 0); create_folder($label); break; case CST_ADMIN_MOVE_UP_ACTION: case CST_ADMIN_MOVE_DOWN_ACTION: $id = $_REQUEST['fid']; if ($id == 0) { return; } $res = rss_query("select position from " .getTable("folders") ." where id=$id"); list($position) = rss_fetch_row($res); $sql = "select id, position from " .getTable("folders") ." where id != $id order by abs($position-position) limit 2"; $res = rss_query($sql); // Let's look for a lower/higher position than the one we got. $switch_with_position=$position; while (list($oid,$oposition) = rss_fetch_row($res)) { if ( // found none yet? ($switch_with_position == $position) && ( // move up: we look for a lower position ($_REQUEST['action'] == CST_ADMIN_MOVE_UP_ACTION && $oposition < $switch_with_position) || // move up: we look for a higher position ($_REQUEST['action'] == CST_ADMIN_MOVE_DOWN_ACTION && $oposition > $switch_with_position) ) ){ $switch_with_position = $oposition; $switch_with_id = $oid; } } // right, lets! if ($switch_with_position != $position) { rss_query( "update " . getTable("folders") ." set position = $switch_with_position where id=$id" ); rss_query( "update " . getTable("folders") ." set position = $position where id=$switch_with_id" ); } break; default: break; } return $ret__; } /** * Creates a folder with the given name. Does some sanity check, * creates the folder, then returns the */ function create_folder($label, $complainonerror=true) { $res = rss_query ("select count(*) from " .getTable("folders") ." where name='" .rss_real_escape_string($label). "'"); list($exists) = rss_fetch_row($res); if ($exists > 0 && $complainonerror) { rss_error(sprintf(LBL_ADMIN_ERROR_CANT_CREATE, $label), RSS_ERROR_ERROR,true); return; } elseif ($exists == 0) { $res = rss_query("select 1+max(position) as np from " . getTable("folders")); list($np) = rss_fetch_row($res); if (!$np) { $np = "0"; } rss_query("insert into " .getTable("folders") ." (name,position) values ('" . rss_real_escape_string($label) ."', $np)"); } list($fid) = rss_fetch_row( rss_query("select id from " .getTable("folders") ." where name='". rss_real_escape_string($label) ."'")); return $fid; } ?>