}
$result = $pdb->Execute($sql);
if (!$result) {
flash();
} else {
pheader("Location:album.php");
}
}
setvar("AlbumTypes", $_PB_CACHE['albumtype']);
if (isset($_GET['do'])) {
$do = trim($_GET['do']);
if (!empty($_GET['id'])) {
$id = intval($_GET['id']);
}
if ($do == "del" && !empty($id)) {
$result = $album->del(intval($id), "member_id=" . $_SESSION['MemberID']);
}
if ($do == "edit") {
if (!empty($id)) {
$album_info = $pdb->GetRow("SELECT a.title,a.description,ab.id,a.attachment,ab.type_id FROM {$tb_prefix}albums ab LEFT JOIN {$tb_prefix}attachments a ON a.id=ab.attachment_id WHERE ab.member_id=" . $_SESSION['MemberID'] . " AND ab.id={$id}");
if (!empty($album_info['attachment'])) {
$album_info['image'] = pb_get_attachmenturl($album_info['attachment'], "../");
}
setvar("item", $album_info);
}
$tpl_file = "album_edit";
template($tpl_file);
exit;
}
}
$joins[] = "LEFT JOIN {$tb_prefix}albums a ON a.attachment_id=Attachment.id";
flash();
} else {
flash("success", "album.php");
}
}
setvar("AlbumTypes", $_PB_CACHE['albumtype']);
if (isset($_GET['do'])) {
$do = trim($_GET['do']);
if (!empty($_GET['id'])) {
$id = intval($_GET['id']);
}
if ($do == "del" && !empty($id)) {
//get attach info
$album_info = $pdb->GetRow("SELECT * FROM {$tb_prefix}albums ab WHERE ab.member_id=" . $the_memberid . " AND ab.id={$id}");
$attachment->del($album_info['attachment_id'], "member_id=" . $the_memberid);
$result = $album->del(intval($id), "member_id=" . $the_memberid);
}
if ($do == "edit") {
if (!empty($id)) {
$album_info = $pdb->GetRow("SELECT a.title,a.description,ab.id,a.attachment,ab.type_id FROM {$tb_prefix}attachments a LEFT JOIN {$tb_prefix}albums ab ON a.id=ab.attachment_id WHERE a.member_id=" . $the_memberid . " AND a.id={$id}");
if (!empty($album_info['attachment'])) {
$album_info['image'] = pb_get_attachmenturl($album_info['attachment'], "../");
}
setvar("item", $album_info);
}
$tpl_file = "album_edit";
template($tpl_file);
exit;
}
}
$joins[] = "LEFT JOIN {$tb_prefix}attachments Attachment ON Album.attachment_id=Attachment.id";
