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