PRIMARY KEY (album_id),

KEY album_order (album_order),

KEY album_datestamp (album_datestamp)

// Delete User

} elseif (isset($_GET['step']) && $_GET['step'] == "delete" && $user_id && (!$isAdmin || iSUPERADMIN)) {

    if (isset($_POST['delete_user'])) {

        $result = dbquery("SELECT user_id, user_avatar FROM ".DB_USERS." WHERE user_id='".$user_id."' AND user_level>".USER_LEVEL_SUPER_ADMIN);

        if (dbrows($result)) {

            // Delete avatar

            $data = dbarray($result);

            if ($data['user_avatar'] != "" && file_exists(IMAGES."avatars/".$data['user_avatar'])) {

                @unlink(IMAGES."avatars/".$data['user_avatar']);

            }

            if (db_exists(DB_PHOTOS)) {

                // Delete photos

                $result = dbquery("SELECT album_id, photo_filename, photo_thumb1, photo_thumb2 FROM ".DB_PHOTOS." WHERE photo_user='".$user_id."'");

                if (dbrows($result)) {

                    while ($data = dbarray($result)) {

                        $result = dbquery("DELETE FROM ".DB_PHOTOS." WHERE photo_user='".intval($user_id)."'");

                        @unlink(IMAGES_G.$data['photo_filename']);

                        @unlink(IMAGES_G_T.$data['photo_thumb1']);

                        @unlink(IMAGES_G_T.$data['photo_thumb2']);

                    }

                }

            }

// photoalbum -------------------

$result = dbquery("

   SELECT ".DB_PHOTO_ALBUMS.".album_title, ".DB_PHOTOS.".photo_id

   FROM ".DB_PHOTO_ALBUMS.", ".DB_PHOTOS."

   WHERE ".DB_PHOTO_ALBUMS.".album_id = ".DB_PHOTOS.".album_id 

");

$album = array();

while ($data = dbarray($result)) {

   $album[] = $data['album_title'];

   $album[] = $data['photo_id'];

}

$temp = opendir(PHOTOS);

while ($file = readdir($temp)) {

   if (!in_array($file, array(".", "..", "/", "index.php")) && !is_dir(PHOTOS.$file)) {

      $slut = strpos($file, ".");

      $smlg = substr($file, 0, $slut);

      $navn = "";

      for ($i = 1; $i < count($album); $i = $i+2) {

         if ($smlg == $album[$i]) {

            $navn = $album[$i-1];

            break;

         }

      }

      $image_files[] = "['".$navn." album: ".$file."','".$settings['siteurl']."images/photoalbum/".$file."'], ";

   }

}

closedir($temp);

sort($image_files);



//Figure Database -----------------------

$result = dbquery("

   SELECT ".DB_FIGURE_MANUFACTURER.".album_title, ".DB_FIGURES.".figure_id

   FROM ".DB_FIGURE_MANUFACTURER.", ".DB_FIGURES."

   WHERE ".DB_FIGURE_MANUFACTURER.".album_id = ".DB_FIGURES.".manufacturer_id 

");

$album = array();

while ($data = dbarray($result)) {

   $album[] = $data['manufacturer_title'];

   $album[] = $data['figure_id'];

}

$temp = opendir(FIGURES);

while ($file = readdir($temp)) {

   if (!in_array($file, array(".", "..", "/", "index.php")) && !is_dir(FIGURES.$file)) {

      $slut = strpos($file, ".");

      $smlg = substr($file, 0, $slut);

      $navn = "";

      for ($i = 1; $i < count($manufacturer); $i = $i+2) {

         if ($smlg == $manufacturer[$i]) {

            $navn = $manufacturer[$i-1];

            break;

         }

      }

      $image_files[] = "['".$navn." manufacturer: ".$file."','".$settings['siteurl']."images/manufacturer/".$file."'], ";

   }

}

closedir($temp);

sort($image_files);





// FIGURE DATABASE END

   // Photo´s

   elseif (preg_match('/photogallery.php/i', $_SERVER['PHP_SELF']) || preg_match('|/gallery/photo/([0-9]+)/|', $_SERVER['REQUEST_URI'], $matches) && multilang_table("PG")) {

      if (isset($_GET['photo_id']) && isnum($_GET['photo_id']) || !empty($matches) && $matches['1'] > 0) {

         $data = dbarray(dbquery("SELECT pha.album_id, pha.album_language, ph.album_id

                           FROM ".DB_PHOTO_ALBUMS." pha

                           LEFT JOIN ".DB_PHOTOS." ph ON pha.album_id = ph.album_id

                           WHERE ph.photo_id='".(isset($_GET['photo_id']) ? $_GET['photo_id'] : $matches['1'])."'

                           GROUP BY ph.photo_id"));

         if ($data['album_language']." != ".LANGUAGE) {

            echo set_language($data['album_language']);

         }

      }

   }



   // Photo Albums

   elseif (preg_match('/photogallery.php/i', $_SERVER['PHP_SELF']) || preg_match('|/gallery/([0-9]+)/|', $_SERVER['REQUEST_URI'], $matches) && multilang_table("PG")) {

      if (isset($_GET['album_id']) && isnum($_GET['album_id']) || !empty($matches) && $matches['1'] > 0) {

         $data = dbarray(dbquery("SELECT album_language FROM ".DB_PHOTO_ALBUMS." WHERE album_id='".(isset($_GET['album_id']) ? $_GET['album_id'] : $matches['1'])."'"));

         if ($data['album_language']." != ".LANGUAGE) {

            echo set_language($data['album_language']);

         }

      }

   }

if (isset($_GET['defuse']) && isnum($_GET['defuse'])) {