diff options
Diffstat (limited to 'bin/delete_disabled.php.inc')
| -rw-r--r-- | bin/delete_disabled.php.inc | 51 |
1 files changed, 51 insertions, 0 deletions
diff --git a/bin/delete_disabled.php.inc b/bin/delete_disabled.php.inc new file mode 100644 index 00000000..0c163a17 --- /dev/null +++ b/bin/delete_disabled.php.inc @@ -0,0 +1,51 @@ +<?php +/* + + Copyright 2001 - 2006 Ampache.org + All Rights Reserved + + This program is free software; you can redistribute it and/or + modify it under the terms of the GNU General Public License v2 + as published by the Free Software Foundation. + + This program is distributed in the hope that it will be useful, + but WITHOUT ANY WARRANTY; without even the implied warranty of + MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the + GNU General Public License for more details. + + You should have received a copy of the GNU General Public License + along with this program; if not, write to the Free Software + Foundation, Inc., 59 Temple Place - Suite 330, Boston, MA 02111-1307, USA. + +*/ + +/** + * Delete Disabled + * This WILL DELETE MUSIC!!!! it does what it's name would suggest and deletes + * any disabled songs + */ + +/* will not delete anything if debug is true */ +$debug = true; + + +$no_session = '1'; +require ("../lib/init.php"); + +/* Get a list of filenames */ +$sql = "SELECT id,file FROM song WHERE enabled='0'"; +$db_results = mysql_query($sql,dbh()); + +while ($r = mysql_fetch_assoc($db_results)) { + + if ($debug) { + echo "Deleting: " . $r['file'] . "\n"; + } + else { + unlink($r['file']); + $sql = "DELETE FROM song WHERE id='" . sql_escape($r['id']) . "'"; + $del_results = mysql_query($sql,dbh()); + } +} // end while + +?> |