<?php
  error_reporting(255);

  $streamdir = '.';


    if (empty($_POST['urldata'])) {
?>

<form method="post" action="">
<textarea name="urldata" rows="4" cols="70">
</textarea>
<br />
<input type="submit" value="Delete from stream">
</form>


<?php
    } else {

      $configdata = parse_ini_file($streamdir."/config/config.inc");

      MYSQL_CONNECT($configdata['mysqlhost'], $configdata['mysqluser'], $configdata['mysqlpass']) OR DIE("Unable to connect to database");
      @mysql_select_db($configdata['mysqldbname']) or die("Unable to select database");

      $urllist = explode("\n",$_POST['urldata']);
   foreach ($urllist as $url) {
     $url = trim($url);
       if (empty($url)) { continue; }
     $url = urldecode($url);

     MYSQL_QUERY("UPDATE galleries SET gallery_state='disable' WHERE gallery_url='$url'");

   }

      MYSQL_CLOSE();   

   }
?>

<?php
  error_reporting(255);

  $smartpath   = './st/';

  include_once($smartpath.'classes/mysql.php');
  $hostname   = $mysql['db_host'];
  $dbname   = $mysql['db_name'];
  $dbuser   = $mysql['db_user'];
  $dbpass   = $mysql['db_password'];

    if (empty($_POST['urldata'])) {
?>

<form method="post" action="">
<textarea name="urldata" rows="4" cols="70">
</textarea>
<br />
<input type="submit" value="Delete from smart thumbs">
</form>


<?php
    } else {

      MYSQL_CONNECT($hostname, $dbuser, $dbpass) OR DIE("Unable to connect to database");
      @mysql_select_db($dbname) or die("Unable to select database");

      $urllist = explode("\n",$_POST['urldata']);
   foreach ($urllist as $url) {
     $url = trim($url);
       if (empty($url)) { continue; }
     $url = urldecode($url);

     $sql = "SELECT * FROM st_galleries WHERE url='$url'";
     $mainres = mysql_query($sql);
     $number = MYSQL_NUMROWS($mainres);
       if ($number>0) {
         $galrow = mysql_fetch_array($mainres);
         do
         {
      $id = $galrow['ID'];
      MYSQL_QUERY("UPDATE st_galleries_1
       SET
          enabled='0',
          active='0',
          text_active='0'
       WHERE ID='$id'");

         } while ($galrow = mysql_fetch_array($mainres));
       }

   MYSQL_QUERY("UPDATE st_galleries
    SET
       'delete'='1'
    WHERE url='$url'");


   }
      MYSQL_CLOSE();   
   }
?>