}
}
}
$result = dbquery("DELETE FROM " . DB_POSTS . " WHERE thread_id IN (" . $thread_ids . ") AND forum_id='" . $_GET['forum_id'] . "'");
$deleted_posts = mysql_affected_rows();
$result = dbquery("DELETE FROM " . DB_THREADS . " WHERE thread_id IN (" . $thread_ids . ") AND forum_id='" . $_GET['forum_id'] . "'");
$deleted_threads = mysql_affected_rows();
$result = dbquery("DELETE FROM " . DB_THREAD_NOTIFY . " WHERE thread_id IN (" . $thread_ids . ")");
$result = dbquery("DELETE FROM " . DB_FORUM_ATTACHMENTS . " WHERE thread_id IN (" . $thread_ids . ")");
$result = dbquery("DELETE FROM " . DB_FORUM_POLL_OPTIONS . " WHERE thread_id IN (" . $thread_ids . ")");
$result = dbquery("DELETE FROM " . DB_FORUM_POLL_VOTERS . " WHERE thread_id IN (" . $thread_ids . ")");
$result = dbquery("DELETE FROM " . DB_FORUM_POLLS . " WHERE thread_id IN (" . $thread_ids . ")");
if ($settings['enable_tags']) {
// Pimped: tag
require_once INCLUDES . "tag_include.php";
delete_tags($thread_ids, "F");
}
$result = dbquery("SELECT post_datestamp, post_author FROM " . DB_POSTS . "\r\n\t\tWHERE forum_id='" . $_GET['forum_id'] . "' ORDER BY post_datestamp DESC LIMIT 1");
if (dbrows($result)) {
$ldata = dbarray($result);
$forum_lastpost = "forum_lastpost='" . $ldata['post_datestamp'] . "', forum_lastuser='******'post_author'] . "'";
} else {
$forum_lastpost = "forum_lastpost='0', forum_lastuser='******'";
}
$result = dbquery("UPDATE " . DB_FORUMS . " SET " . $forum_lastpost . ", forum_postcount=forum_postcount-" . $deleted_posts . ", forum_threadcount=forum_threadcount-" . $deleted_threads . " WHERE forum_id='" . $_GET['forum_id'] . "'");
}
$rows_left = dbcount("(thread_id)", DB_THREADS, "forum_id='" . $_GET['forum_id'] . "'") - 3;
if ($rows_left <= $rowstart && $rowstart > 0) {
$rowstart = (ceil($rows_left / $settings['threads_per_page']) - 1) * $settings['threads_per_page'];
}
redirect($rowstart == 0 ? make_url(FORUM . FUSION_SELF . "?forum_id=" . $_GET['forum_id'], BASEDIR . "forum-" . $_GET['forum_id'] . "-", $fdata['forum_name'], ".html") : make_url(FORUM . FUSION_SELF . "?forum_id=" . $_GET['forum_id'] . "&page=" . $_GET['page'], BASEDIR . "forum-" . $_GET['forum_id'] . "-page-" . $_GET['page'] . "-", $fdata['forum_name'], ".html"));
function save_person_salsa($s)
{
global $db;
global $DIA;
#parse types
if ($s['type']) {
foreach ($s['type'] as $item) {
$s[$item] = 1;
}
}
$tags = array();
#parse tag types
if ($s['activist_skills']) {
foreach ($s['activist_skills'] as $i) {
$tags[] = $i;
}
}
if ($s['activist_interests']) {
foreach ($s['activist_interests'] as $i) {
$tags[] = $i;
}
}
if ($s['issues']) {
foreach ($s['issues'] as $i) {
$tags[] = $i;
}
}
$s['tag'] = $tags;
#parse group types
if ($s['email_lists']) {
$s['group_KEYS'] = $s['email_lists'];
}
#parse trigger types
if ($s['email_triggers']) {
$email_triggers = person_parse_triggers($s['email_triggers']);
$s = array_merge($s, $email_triggers);
}
if ($s['supporter_KEY']) {
$s['key'] = $s['supporter_KEY'];
#if update remove the tags from the supporter
delete_tags($s['supporter_KEY'], 'Skill');
delete_tags($s['supporter_KEY'], 'Volunteer');
delete_tags($s['supporter_KEY'], 'Issue');
unset($s['supporter_KEY']);
}
# make sure that corps dont get on the email list
if ($s['corporate'] == 1 or $s['celeberit'] == 1) {
$s['Receive_Email'] = '-99';
}
if ($s['Email']) {
$supporter = check_supporter($s['Email']);
if ($supporter['supporter_KEY']) {
if ($supporter['Receive_Email']) {
unset($s['Receive_Email']);
}
}
}
#print_r($s); die();
$supporter_KEY = $DIA->save('supporter', $s);
return $supporter_KEY;
}
if (dbrows($result)) {
$data = dbarray($result);
if (!empty($data['news_image']) && file_exists(IMAGES_N . $data['news_image'])) {
unlink(IMAGES_N . $data['news_image']);
}
if (!empty($data['news_image_t1']) && file_exists(IMAGES_N_T . $data['news_image_t1'])) {
unlink(IMAGES_N_T . $data['news_image_t1']);
}
if (!empty($data['news_image_t2']) && file_exists(IMAGES_N_T . $data['news_image_t2'])) {
unlink(IMAGES_N_T . $data['news_image_t2']);
}
$result = dbquery("DELETE FROM " . DB_NEWS . " WHERE news_id='" . $_POST['news_id'] . "'");
$result = dbquery("DELETE FROM " . DB_COMMENTS . " WHERE comment_item_id='" . $_POST['news_id'] . "' and comment_type='N'");
$result = dbquery("DELETE FROM " . DB_RATINGS . " WHERE rating_item_id='" . $_POST['news_id'] . "' and rating_type='N'");
if ($settings['enable_tags']) {
delete_tags($_POST['news_id'], "N");
}
log_admin_action("admin-1", "admin_news_deleted", "", "", $data['news_subject'] . " (ID: " . $_POST['news_id'] . ")");
redirect(FUSION_SELF . $aidlink . "&status=del");
} else {
redirect(FUSION_SELF . $aidlink);
}
} else {
if (isset($_POST['preview'])) {
$news_subject = stripinput($_POST['news_subject']);
$news_cat = isnum($_POST['news_cat']) ? $_POST['news_cat'] : "0";
$body = phpentities(stripslash($_POST['body']));
$bodypreview = str_replace("src='" . str_replace("../", "", IMAGES_N), "src='" . IMAGES_N, stripslash($_POST['body']));
if ($_POST['body2']) {
$body2 = phpentities(stripslash($_POST['body2']));
$body2preview = str_replace("src='" . str_replace("../", "", IMAGES_N), "src='" . IMAGES_N, stripslash($_POST['body2']));
/**
* Deletes all tags linked to no photo
*/
function delete_orphan_tags()
{
$orphan_tags = get_orphan_tags();
if (count($orphan_tags) > 0) {
$orphan_tag_ids = array();
foreach ($orphan_tags as $tag) {
$orphan_tag_ids[] = $tag['id'];
}
delete_tags($orphan_tag_ids);
}
}
} else {
redirect(FUSION_SELF . $aidlink . "&status=sn&pid=" . $page_id, true);
}
} else {
redirect(FUSION_SELF . $aidlink . "&status=pw");
}
} else {
if (isset($_POST['delete']) && (isset($_POST['page_id']) && isnum($_POST['page_id']))) {
$result = dbquery("SELECT page_title FROM " . DB_CUSTOM_PAGES . " WHERE page_id='" . $_POST['page_id'] . "'");
if (dbrows($result)) {
$data = dbarray($result);
}
$result = dbquery("DELETE FROM " . DB_CUSTOM_PAGES . " WHERE page_id='" . $_POST['page_id'] . "'");
$result = dbquery("DELETE FROM " . DB_SITE_LINKS . " WHERE link_url='viewpage.php?page_id=" . $_POST['page_id'] . "'");
if ($settings['enable_tags']) {
delete_tags($_POST['page_id'], "C");
}
// Pimped: tag
log_admin_action("admin-1", "admin_custompage_deleted", "", "", $data['page_title'] . " (ID: " . $_POST['page_id'] . ")");
redirect(FUSION_SELF . $aidlink . "&status=del");
} else {
if (isset($_POST['preview'])) {
$addlink = isset($_POST['add_link']) ? " checked='checked'" : "";
$page_title = stripinput($_POST['page_title']);
$page_access = $_POST['page_access'];
$page_content = stripslash($_POST['page_content']);
$page_keywords = $_POST['page_keywords'];
// meta
$comments = isset($_POST['page_comments']) ? " checked='checked'" : "";
$ratings = isset($_POST['page_ratings']) ? " checked='checked'" : "";
if (check_admin_pass(isset($_POST['admin_password']) ? stripinput($_POST['admin_password']) : "")) {
}
$page['infos'][] = l10n('Tags <em>%s</em> merged into tag <em>%s</em>', implode(', ', $tags_deleted), $name_of_tag[$destination_tag_id]);
}
}
}
// +-----------------------------------------------------------------------+
// | delete tags |
// +-----------------------------------------------------------------------+
if (isset($_POST['delete']) and isset($_POST['tags'])) {
$query = '
SELECT name
FROM ' . TAGS_TABLE . '
WHERE id IN (' . implode(',', $_POST['tags']) . ')
;';
$tag_names = array_from_query($query, 'name');
delete_tags($_POST['tags']);
$page['infos'][] = l10n_dec('The following tag was deleted', 'The %d following tags were deleted', count($tag_names)) . ' : ' . implode(', ', $tag_names);
}
// +-----------------------------------------------------------------------+
// | delete orphan tags |
// +-----------------------------------------------------------------------+
if (isset($_GET['action']) and 'delete_orphans' == $_GET['action']) {
check_pwg_token();
delete_orphan_tags();
$_SESSION['page_infos'] = array(l10n('Orphan tags deleted'));
redirect(get_root_url() . 'admin.php?page=tags');
}
// +-----------------------------------------------------------------------+
// | add a tag |
// +-----------------------------------------------------------------------+
if (isset($_POST['add']) and !empty($_POST['add_tag'])) {
$result = dbquery("UPDATE " . DB_FORUMS . " SET forum_postcount=forum_postcount-1 WHERE forum_id = '" . $_GET['forum_id'] . "'");
$result = dbquery("SELECT attach_name FROM " . DB_FORUM_ATTACHMENTS . " WHERE post_id='" . $_GET['post_id'] . "'");
if (dbrows($result)) {
// Pimped: Multi-Upload
while ($attach = dbarray($result)) {
unlink(FORUM_ATT . $attach['attach_name']);
}
$result2 = dbquery("DELETE FROM " . DB_FORUM_ATTACHMENTS . " WHERE post_id='" . $_GET['post_id'] . "'");
}
$posts = dbcount("(post_id)", DB_POSTS, "thread_id='" . $_GET['thread_id'] . "'");
if (!$posts) {
$result = dbquery("DELETE FROM " . DB_THREADS . " WHERE thread_id='" . $_GET['thread_id'] . "' AND forum_id='" . $_GET['forum_id'] . "'");
$result = dbquery("DELETE FROM " . DB_THREAD_NOTIFY . " WHERE thread_id='" . $_GET['thread_id'] . "'");
$result = dbquery("UPDATE " . DB_FORUMS . " SET forum_threadcount=forum_threadcount-1 WHERE forum_id = '" . $_GET['forum_id'] . "'");
if ($settings['enable_tags']) {
delete_tags((int) $_GET['thread_id'], "F");
}
// Pimped: tag
}
$result = dbquery("SELECT * FROM " . DB_FORUMS . " WHERE forum_id='" . $_GET['forum_id'] . "' AND forum_lastuser='******'post_author'] . "' AND forum_lastpost='" . $pdata['post_datestamp'] . "'");
if (dbrows($result)) {
$result = dbquery("SELECT forum_id,post_author,post_datestamp FROM " . DB_POSTS . " WHERE forum_id='" . $_GET['forum_id'] . "' ORDER BY post_datestamp DESC LIMIT 1");
if (dbrows($result)) {
$pdata2 = dbarray($result);
$result = dbquery("UPDATE " . DB_FORUMS . " SET forum_lastpost='" . $pdata2['post_datestamp'] . "', forum_lastuser='******'post_author'] . "' WHERE forum_id='" . $_GET['forum_id'] . "'");
} else {
$result = dbquery("UPDATE " . DB_FORUMS . " SET forum_lastpost='0', forum_lastuser='******' WHERE forum_id='" . $_GET['forum_id'] . "'");
}
}
if ($posts) {
$result = dbcount("(thread_id)", DB_THREADS, "thread_id='" . $_GET['thread_id'] . "' AND thread_lastpost='" . $pdata['post_datestamp'] . "' AND thread_lastuser='******'post_author'] . "'");
$result = dbquery("UPDATE " . DB_FORUM_ATTACHMENTS . " SET thread_id='" . $_POST['new_thread_id'] . "' WHERE post_id IN(" . $move_posts_add . ")");
$new_thread = dbarray(dbquery("\r\n\t\t\t\t\t\t\tSELECT forum_id, thread_id, post_id, post_author, post_datestamp \r\n\t\t\t\t\t\t\tFROM " . DB_POSTS . " \r\n\t\t\t\t\t\t\tWHERE thread_id='" . $_POST['new_thread_id'] . "' \r\n\t\t\t\t\t\t\tORDER BY post_datestamp DESC \r\n\t\t\t\t\t\t\tLIMIT 1\r\n\t\t\t\t\t\t"));
$result = dbquery("UPDATE " . DB_THREADS . " SET thread_lastpost='" . $new_thread['post_datestamp'] . "', thread_lastpostid='" . $new_thread['post_id'] . "', thread_postcount=thread_postcount+" . $num_posts . ", thread_lastuser='******'post_author'] . "' WHERE thread_id='" . $_POST['new_thread_id'] . "'");
$result = dbquery("UPDATE " . DB_FORUMS . " SET forum_lastpost='" . $new_thread['post_datestamp'] . "', forum_postcount=forum_postcount+" . $num_posts . ", forum_lastuser='******'post_author'] . "' WHERE forum_id='" . $_POST['new_forum_id'] . "'");
$old_thread = dbarray(dbquery("\r\n\t\t\t\t\t\t\tSELECT forum_id, thread_id, post_id, post_author, post_datestamp \r\n\t\t\t\t\t\t\tFROM " . DB_POSTS . " \r\n\t\t\t\t\t\t\tWHERE thread_id='" . $pdata['thread_id'] . "' \r\n\t\t\t\t\t\t\tORDER BY post_datestamp DESC \r\n\t\t\t\t\t\t\tLIMIT 1\r\n\t\t\t\t\t\t"));
if (!dbcount("(post_id)", DB_POSTS, "thread_id='" . $pdata['thread_id'] . "'")) {
$result = dbquery("UPDATE " . DB_FORUMS . " SET forum_lastpost='" . $old_thread['post_datestamp'] . "', forum_postcount=forum_postcount-" . $num_posts . ", forum_threadcount=forum_threadcount-1, forum_lastuser='******'post_author'] . "' WHERE forum_id='" . $pdata['forum_id'] . "'");
$result = dbquery("DELETE FROM " . DB_THREADS . " WHERE thread_id='" . $pdata['thread_id'] . "'");
$result = dbquery("DELETE FROM " . DB_THREAD_NOTIFY . " WHERE thread_id='" . $pdata['thread_id'] . "'");
$result = dbquery("DELETE FROM " . DB_FORUM_POLL_VOTERS . " WHERE thread_id='" . $pdata['thread_id'] . "'");
$result = dbquery("DELETE FROM " . DB_FORUM_POLL_OPTIONS . " WHERE thread_id='" . $pdata['thread_id'] . "'");
$result = dbquery("DELETE FROM " . DB_FORUM_POLLS . " WHERE thread_id='" . $pdata['thread_id'] . "'");
if ($settings['enable_tags']) {
// Pimped: tag
require_once INCLUDES . "tag_include.php";
delete_tags((int) $pdata['thread_id'], "F");
}
} else {
$result = dbquery("UPDATE " . DB_THREADS . " SET thread_lastpost='" . $old_thread['post_datestamp'] . "', thread_lastpostid='" . $old_thread['post_id'] . "', thread_postcount=thread_postcount-" . $num_posts . ", thread_lastuser='******'post_author'] . "' WHERE thread_id='" . $pdata['thread_id'] . "'");
$result = dbquery("UPDATE " . DB_FORUMS . " SET forum_lastpost='" . $old_thread['post_datestamp'] . "', forum_postcount=forum_postcount-" . $num_posts . ", forum_lastuser='******'post_author'] . "' WHERE forum_id='" . $pdata['forum_id'] . "'");
}
$pid = count($array_post) - 1;
redirect(FORUM . "viewthread.php?thread_id=" . $_POST['new_thread_id'] . "&pid=" . $array_post[$pid] . "#post_" . $array_post[$pid]);
} else {
redirect(FORUM . "viewthread.php?thread_id=" . $fdata['thread_id'] . "&rowstart=" . $_GET['rowstart'] . "&error=2");
}
} else {
redirect(FORUM . "viewthread.php?thread_id=" . $fdata['thread_id'] . "&rowstart=" . $_GET['rowstart'] . "&error=3");
}
} else {
redirect(FORUM . "index.php");
// Pimped: tag
insert_tags($id, "A", $tag_name);
// Pimped: tag
}
log_admin_action("admin-1", "admin_article_added", "", "", $subject);
redirect(FUSION_SELF . $aidlink . "&status=sn");
}
} elseif (isset($_POST['delete']) && (isset($_POST['article_id']) && isnum($_POST['article_id']))) {
$result = dbquery("SELECT article_subject FROM " . DB_ARTICLES . " WHERE article_id=" . $_POST['article_id']);
if (dbrows($result)) {
$data = dbarray($result);
$result = dbquery("DELETE FROM " . DB_ARTICLES . " WHERE article_id='" . $_POST['article_id'] . "'");
$result = dbquery("DELETE FROM " . DB_COMMENTS . " WHERE comment_item_id='" . $_POST['article_id'] . "' and comment_type='A'");
$result = dbquery("DELETE FROM " . DB_RATINGS . " WHERE rating_item_id='" . $_POST['article_id'] . "' and rating_type='A'");
if ($settings['enable_tags']) {
delete_tags($_POST['article_id'], "A");
}
// Pimped: tag
log_admin_action("admin-1", "admin_article_deleted", "", "", $data['article_subject']);
redirect(FUSION_SELF . $aidlink . "&status=del");
} else {
redirect(FUSION_SELF . $aidlink . "&status=deln");
}
} else {
if (isset($_POST['preview'])) {
$article_cat = $_POST['article_cat'];
$subject = stripinput($_POST['subject']);
$body = phpentities(stripslash($_POST['body']));
$body2 = phpentities(stripslash($_POST['body2']));
$bodypreview = str_replace("src='" . str_replace("../", "", IMAGES_A), "src='" . IMAGES_A, stripslash($_POST['body']));
$body2preview = str_replace("src='" . str_replace("../", "", IMAGES_A), "src='" . IMAGES_A, stripslash($_POST['body2']));
