function deleteCookbooks($user_id, $link)
{
$sql = "SELECT cookbook_id FROM Cookbook_list WHERE user_id = '{$user_id}'";
$result = $link->query($sql);
$count = $result->num_rows;
$i = 0;
if ($count > 0) {
while ($row = $result->fetch_assoc()) {
$cb_id[$i] = $row['cookbook_id'];
//store all cookbook ids to array
deleteTags("COOKBOOK", $cb_id[$i], $link);
//delete cookbook tags
deleteFriends("COOKBOOK", $cb_id[$i], $link);
//check privacy to delete friends
$i++;
}
for ($j = 0; $j < $i; $j++) {
$current = $cb_id[$j];
$sql4 = "DELETE FROM Cookbook WHERE cookbook_id = '{$current}'";
//delete cookbook
if ($link->query($sql4) != true) {
//unsuccessful query
echo "ERROR: Could not able to execute {$sql3}. " . $link->connect_error;
}
}
}
}
// update entry
$queryResult = updateTags($link, 'location');
// assign message to query result
$message = $queryResult ? '<span class="fi-asterisk alertHeader" aria-hidden="true"></span><h2>Success!</h2> Location has been updated!' : '<span class="fi-asterisk alertHeader" aria-hidden="true"></span><h2>Warning!</h2> Location was not updated. Please try again.';
$messageSpanClass = $queryResult ? 'info' : 'alert';
// display query result message
$queryAlert = '<div data-alert class="alert-box ' . $messageSpanClass . '">
<span class="queryMessage">' . $message . '</span>
<a href="#" class="close">×</a>
</div>
<script>$(".alert-box").hide().prependTo("#queryAlert").slideDown(800, "swing");</script>
';
}
if (isset($_POST['btnDeleteLocation'])) {
// update entry
$queryResult = deleteTags($link, 'location');
// assign message to query result
$message = $queryResult ? '<span class="fi-asterisk alertHeader" aria-hidden="true"></span><h2>Success!</h2> Location has been deleted!' : '<span class="fi-asterisk alertHeader" aria-hidden="true"></span><h2>Warning!</h2> Location was not deleted. Please try again.';
$messageSpanClass = $queryResult ? 'info' : 'alert';
// display query result message
$queryAlert = '<div data-alert class="alert-box ' . $messageSpanClass . '">
<span class="queryMessage">' . $message . '</span>
<a href="#" class="close">×</a>
</div>
<script>$(".alert-box").hide().prependTo("#queryAlert").slideDown(800, "swing");</script>
';
}
if (isset($_POST['btnAddLocation'])) {
// update entry
$queryResult = addTags($link, 'location');
// assign message to query result
/**
* The screen you'll see after submitting an entry. It stores the entry, updates the indices (pivot's
* content indices, and the search index), rebuilds the frontpage and XML & Atom feeds, and then it
* displays a list of the latest entries.
*
*/
function entrysubmit_screen()
{
global $db, $config_array, $Pivot_Vars, $entry, $Cfg, $Users, $Paths, $Weblogs, $filtered_words;
// check against unauthorised direct access.
check_csrf();
$db = new db();
$entry = get_entry_from_post();
if (!$entry['title'] == "" || !$entry['introduction'] == "" || !$entry['user'] == "") {
// in this part, we remove the entry from the categories in which
// the current user is not allowed to post entries
foreach ($entry['category'] as $my_cat) {
$allowed = explode("|", $Cfg['cat-' . $my_cat]);
if (in_array($Pivot_Vars['user'], $allowed)) {
$allowed_cats[] = $my_cat;
} else {
$message .= '<br />';
$message .= sprintf(lang('entries', 'entry_catnopost'), $m_cat);
debug("not in category: " . $my_cat);
}
}
$entry['category'] = $allowed_cats;
$db->set_entry($entry);
if ($db->save_entry(TRUE)) {
$message = sprintf(lang('entries', 'entry_saved_ok') . $message, '<i>' . trimtext($entry['title'], 25) . '</i>');
} else {
$message = sprintf(lang('entries', 'entry_saved_ok'), '<i>' . trimtext($entry['title'], 25) . '</i>');
}
// only trigger the ping if it's a new entry..
if ($entry['code'] == ">" && $entry['status'] == "publish") {
$ping = TRUE;
} else {
$ping = FALSE;
}
// only notify if entry is published, and is either new or status changed to publish.
if ($entry['status'] == "publish") {
if ($entry['code'] == ">" || $entry['oldstatus'] != "publish") {
$notified = notify_new('entry', $db->entry);
$notified = "<br /><br />" . $notified;
}
}
// if the global index as they are made var is set - can continue
if ('1' == $Cfg['search_index']) {
/*
2004/10/16 =*=*= JM
an entry should only be indexed if both are true:
- 'publish'==$entry['status']
- current date is at least equal to $entry['publish_date']
I lie, there is another case...
it is conceivable that this is a timed publish AND the time has come
I will leave this to timed publish routines - if I can find them...
-> pvLib ... it's flagged
and of course, providing that there is at least one
category where it would be indexed...
something else that can't be tested... if the user changes a normal
publish to a timed-publish, or puts on hold when it was previously
normal. user should reindex in this case
*/
// check status and date
if ('publish' == $entry['status'] || 'timed' == $entry['status'] && $entry['publish_date'] <= date('Y-m-d-H-i')) {
// categories...
if (can_search_cats(cfg_cat_nosearchindex(), $entry['category'])) {
include_once 'modules/module_search.php';
update_index($db->entry);
debug('update search index: ' . $db->entry['code']);
}
}
}
// perhaps send a trackback ping.
if ($Pivot_Vars['tb_url'] != "" && $entry['status'] == "publish") {
debug("tburl: " . $Pivot_Vars['tb_url']);
require_once 'includes/send_trackback.php';
$weblogs = find_weblogs_with_cat($db->entry['category']);
if (isset($Weblogs[$weblogs[0]])) {
$my_url = $Paths['host'] . make_filelink($db->entry['code'], $weblogs[0], '');
$weblog_title = $Weblogs[$weblogs[0]]['name'];
debug("TRACKBACK ping: {$my_url}");
$message .= '<br />';
$message .= sprintf(lang('entries', 'entry_ping_sent'), $Pivot_Vars['tb_url']);
$tb_urls = explode("\n", $Pivot_Vars['tb_url']);
// make the contents of what to send with the trackback..
$tb_contents = parse_step4($entry['introduction']);
if ($Pivot_Vars['convert_lb'] == 2) {
$tb_contents = pivot_textile($tb_contents);
} else {
if ($Pivot_Vars['convert_lb'] == 3 || $Pivot_Vars['convert_lb'] == 4) {
$tb_contents = pivot_markdown($tb_contents, $Pivot_Vars['convert_lb']);
}
}
$tb_contents = trimtext(strip_tags($tb_contents), 255);
foreach ($tb_urls as $tb_url) {
$tb_url = trim($tb_url);
if (isurl($tb_url)) {
trackback_send($Pivot_Vars['tb_url'], $my_url, $entry['title'], $weblog_title, $tb_contents);
}
}
}
}
// Update the tags for this entry if it's published and remove the old tags if not
if ($db->entry['status'] == 'publish') {
writeTags($db->entry['keywords'], $_POST['f_keywords_old'], $db->entry['code']);
} else {
deleteTags($_POST['f_keywords_old'], $db->entry['code']);
}
}
generate_pages($db->entry['code'], TRUE, TRUE, TRUE, $ping);
entries_screen($message . $notified);
}
/**
* Deletes the current entry (and it's tags and comments).
*
* @return void
*/
function delete_entry()
{
// Delete all tags, comments and trackbacks before deleting the actual entry
deleteTags($this->entry['keywords'], $this->entry['code']);
foreach ($this->entry['comments'] as $key => $value) {
$this->delete_comment($key, false);
}
foreach ($this->entry['trackbacks'] as $key => $value) {
$this->delete_trackback($key, false);
}
unlink($this->set_filename());
unset($this->date_index[$this->entry['code']]);
unset($this->cat_index[$this->entry['code']]);
unset($this->entry_index[$this->entry['code']]);
unset($this->uri_index[$this->entry['code']]);
$this->write_entry_index(TRUE);
$this->write_date_index();
}
function delete_entry()
{
deleteTags($this->entry['keywords'], $this->entry['code']);
debug("unlink: " . $this->set_filename());
unlink($this->set_filename());
unset($this->date_index[$this->entry['code']]);
unset($this->cat_index[$this->entry['code']]);
unset($this->entry_index[$this->entry['code']]);
$this->write_entry_index(TRUE);
$this->write_date_index();
}
}
}
if ($erros != '') {
redirectMsg('./tags.php?' . $ruta, __('Errors ocurred while trying to delete tags.', 'galleries') . '<br />' . $errors, 1);
die;
} else {
redirectMsg('./tags.php?' . $ruta, __('Tags deleted successfully!', 'galleries'), 0);
die;
}
}
$op = rmc_server_var($_REQUEST, 'op', '');
switch ($op) {
case 'new':
formTags();
break;
case 'edit':
formTags(1);
break;
case 'save':
saveTags();
break;
case 'saveedit':
saveTags(1);
break;
case 'delete':
deleteTags();
break;
default:
showTags();
break;
}
