function add_photos($checked, $type, $dir) { global $zipfile; if ($type == 'collections') { foreach ($checked as $cid) { $query = "SELECT * FROM `" . PLOGGER_TABLE_PREFIX . "collections` WHERE `id`='" . intval($cid) . "'"; $result = run_query($query); while ($row = mysql_fetch_assoc($result)) { $query = "SELECT * FROM `" . PLOGGER_TABLE_PREFIX . "albums` WHERE `parent_id`='" . $row['id'] . "'"; $newresult = run_query($query); $newchecked = array(); while ($newrow = mysql_fetch_assoc($newresult)) { $newchecked[] = $newrow['id']; } $newdir = $row['name']; $i = 1; while (is_dir($newdir)) { $newdir = $row['name'] . '(' . $i++ . ')'; } // $zipfile -> add_dir($dir . $newdir); add_photos($newchecked, 'collection', $dir . $newdir . '/'); } } } else { if ($type == 'collection') { foreach ($checked as $aid) { $query = "SELECT * FROM `" . PLOGGER_TABLE_PREFIX . "albums` WHERE `id`='" . intval($aid) . "'"; $result = run_query($query); while ($row = mysql_fetch_assoc($result)) { $query = "SELECT * FROM `" . PLOGGER_TABLE_PREFIX . "pictures` WHERE `parent_album`='" . $row['id'] . "'"; $newresult = run_query($query); $newchecked = array(); while ($newrow = mysql_fetch_assoc($newresult)) { $newchecked[] = $newrow['id']; } $newdir = $row['name']; $i = 1; while (is_dir($newdir)) { $newdir = $row['name'] . '(' . $i++ . ')'; } // $zipfile -> add_dir($dir . $newdir); add_photos($newchecked, 'album', $dir . $newdir . '/'); } } } elseif ($type == 'album' || $type == 'search') { foreach ($checked as $pid) { $query = "SELECT * FROM `" . PLOGGER_TABLE_PREFIX . "pictures` WHERE `id`='" . intval($pid) . "'"; $result = run_query($query); while ($row = mysql_fetch_assoc($result)) { $file_contents = file_get_contents('plog-content/images/' . $row['path'], true); $zipfile->add_file($file_contents, $row['path']); } } } } return; }
function add_photos($checked, $type, $dir) { global $zipfile; if ($type == "collections") { foreach ($checked as $cid) { $query = "SELECT * FROM `" . TABLE_PREFIX . "collections` WHERE `id`='" . intval($cid) . "'"; $result = run_query($query); while ($row = mysql_fetch_assoc($result)) { $query = "SELECT * FROM `" . TABLE_PREFIX . "albums` WHERE `parent_id`='" . $row["id"] . "'"; $newresult = run_query($query); $newchecked = array(); while ($newrow = mysql_fetch_assoc($newresult)) { $newchecked[] = $newrow["id"]; } $newdir = $row["name"]; $i = 1; while (is_dir($newdir)) { $newdir = $row["name"] . " (" . $i++ . ")"; } // $zipfile -> add_dir($dir . $newdir); add_photos($newchecked, "collection", $dir . $newdir . "/"); } } } elseif ($type == "collection") { foreach ($checked as $aid) { $query = "SELECT * FROM `" . TABLE_PREFIX . "albums` WHERE `id`='" . intval($aid) . "'"; $result = run_query($query); while ($row = mysql_fetch_assoc($result)) { $query = "SELECT * FROM `" . TABLE_PREFIX . "pictures` WHERE `parent_album`='" . $row["id"] . "'"; $newresult = run_query($query); $newchecked = array(); while ($newrow = mysql_fetch_assoc($newresult)) { $newchecked[] = $newrow["id"]; } $newdir = $row["name"]; $i = 1; while (is_dir($newdir)) { $newdir = $row["name"] . " (" . $i++ . ")"; } // $zipfile -> add_dir($dir . $newdir); add_photos($newchecked, "album", $dir . $newdir . "/"); } } } elseif ($type == "album" || $type == "search") { foreach ($checked as $pid) { $query = "SELECT * FROM `" . TABLE_PREFIX . "pictures` WHERE `id`='" . intval($pid) . "'"; $result = run_query($query); while ($row = mysql_fetch_assoc($result)) { $file_contents = file_get_contents("images/" . $row["path"], true); $zipfile->add_file($file_contents, $row["path"]); } } } return; }