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;
}
