function update_data($post) { $id = $post["id"]; $title = $post["image_title"]; $date = $post["image_date"]; $category = $post["image_category"]; $gear = $post["image_gear"]; $description = $post["image_description"]; $host = "localhost"; $user = "******"; $pass = ""; $db = "gallery"; $table = "gallery_photos"; $query = 'UPDATE ' . $table . ' SET TITLE="' . $title . '", DATE="' . $date . '", CATEGORY="' . $category . '", DESCRIPTION="' . $description . '", GEAR="' . $gear . '" WHERE ID="' . $id . '"'; $mysqli = new mysqli($host, $user, $pass, $db); if ($mysqli->connect_errno) { printf("Connect failed: %s\n", $mysqli->connect_error); exit; } if ($mysqli->query($query)) { foreach ($post["keys"] as &$val) { update_tags($id, $val); } return true; } }
<?php // Update the tags for a thread include 'init.php'; $thread_id = (int) $_POST['thread_id']; $thread = get_thread($thread_id); if (!$thread) { die('Thread not found.'); } $tags = $_POST['tags']; update_tags($thread_id, $tags); header('Location: thread.php?updated=tags&t=' . $thread_id);
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']); } $news_image = ""; $news_image_t1 = ""; $news_image_t2 = ""; } $result = dbquery("UPDATE " . DB_NEWS . " SET news_subject='{$news_subject}', news_cat='{$news_cat}', news_end='{$news_end_date}', news_image='{$news_image}', news_news='{$body}', news_extended='{$body2}', news_breaks='{$news_breaks}'," . ($news_start_date != 0 ? " news_datestamp='{$news_start_date}'," : "") . " news_start='{$news_start_date}', news_image_t1='{$news_image_t1}', news_image_t2='{$news_image_t2}', news_visibility='{$news_visibility}', news_draft='{$news_draft}', news_sticky='{$news_sticky}', news_keywords='{$news_keywords}', news_allow_comments='{$news_comments}', news_allow_ratings='{$news_ratings}' WHERE news_id='" . $_POST['news_id'] . "'"); // Pimped: key if ($settings['enable_tags']) { update_tags($_POST['news_id'], "N", $tag_name); } log_admin_action("admin-1", "admin_news_edited", "", "", $news_subject . " (ID: " . $_POST['news_id'] . ")"); redirect(FUSION_SELF . $aidlink . "&status=su" . ($error ? "&error={$error}" : "")); } else { redirect(FUSION_SELF . $aidlink); } } else { if ($news_sticky == "1") { $result = dbquery("UPDATE " . DB_NEWS . " SET news_sticky='0' WHERE news_sticky='1'"); } $result = dbquery("INSERT INTO " . DB_NEWS . " (news_subject, news_cat, news_news, news_extended, news_breaks, news_name, news_datestamp, news_start, news_end, news_image, news_image_t1, news_image_t2, news_visibility, news_draft, news_sticky, news_reads, news_keywords, news_allow_comments, news_allow_ratings) VALUES ('{$news_subject}', '{$news_cat}', '{$body}', '{$body2}', '{$news_breaks}', '" . $userdata['user_id'] . "', '" . ($news_start_date != 0 ? $news_start_date : time()) . "', '{$news_start_date}', '{$news_end_date}', '{$news_image}', '{$news_image_t1}', '{$news_image_t2}', '{$news_visibility}', '{$news_draft}', '{$news_sticky}', '0', '{$news_keywords}', '{$news_comments}', '{$news_ratings}')"); $id = mysql_insert_id(); if ($settings['enable_tags']) { insert_tags($id, "N", $tag_name); }
} if (isset($_POST['save'])) { $page_title = stripinput($_POST['page_title']); $page_access = isnum($_POST['page_access']) ? $_POST['page_access'] : "0"; $page_content = addslash($_POST['page_content']); $tag_name = isset($_POST['tag_name']) ? stripinput($_POST['tag_name']) : ""; // Pimped: tag $page_keywords = stripinput($_POST['page_keywords']); // meta $comments = isset($_POST['page_comments']) ? "1" : "0"; $ratings = isset($_POST['page_ratings']) ? "1" : "0"; if (check_admin_pass(isset($_POST['admin_password']) ? stripinput($_POST['admin_password']) : "")) { if (isset($_POST['page_id']) && isnum($_POST['page_id'])) { $result = dbquery("UPDATE " . DB_CUSTOM_PAGES . " SET page_title='{$page_title}', page_access='{$page_access}', page_content='{$page_content}', page_keywords='{$page_keywords}', page_allow_comments='{$comments}', page_allow_ratings='{$ratings}' WHERE page_id='" . $_POST['page_id'] . "'"); if ($settings['enable_tags']) { update_tags($_POST['page_id'], "C", $tag_name); } // Pimped: tag log_admin_action("admin-1", "admin_custompage_edited", "", "", $page_title . " (ID: " . $_POST['page_id'] . ")"); } else { $result = dbquery("INSERT INTO " . DB_CUSTOM_PAGES . " (page_title, page_access, page_content, page_keywords, page_allow_comments, page_allow_ratings) VALUES ('{$page_title}', '{$page_access}', '{$page_content}', '{$page_keywords}', '{$comments}', '{$ratings}')"); $page_id = mysql_insert_id(); log_admin_action("admin-1", "admin_custompage_added", "", "", $page_title . " (ID: " . $page_id . ")"); if (isset($_POST['add_link'])) { $data = dbarray(dbquery("SELECT link_order FROM " . DB_SITE_LINKS . " ORDER BY link_order DESC LIMIT 1")); $link_order = $data['link_order'] + 1; $result = dbquery("INSERT INTO " . DB_SITE_LINKS . " (link_name, link_url, link_seo_url,link_visibility, link_position, link_window, link_order) VALUES ('{$page_title}', 'viewpage.php?page_id={$page_id}', 'page-" . $page_id . "-" . clean_subject_urlrewrite($page_title) . ".html', '{$page_access}', '1', '0', '{$link_order}')"); // Pimped SEO Url added if ($settings['enable_tags']) { $id = mysql_insert_id(); // Pimped: tag
if (isset($_POST['tag'])) { $tag = $_POST['tag']; } if (isset($_POST['tagType'])) { $tagType = $_POST['tagType']; } //+++++++++++++++++++++++++++++++++++++++++++++++++ //Insert tags for a given user //+++++++++++++++++++++++++++++++++++++++++++++++++ function update_tags($tag, $userID, $tagType) { $servername = "127.0.0.1"; $username = "******"; $password = "******"; $dbname = "who_what"; // Create connection $conn = new mysqli($servername, $username, $password, $dbname); // Check connection if ($conn->connect_error) { die("Connection failed: " . $conn->connect_error); } $sql = "INSERT into tbl_tags (tag,tagType,userID) VALUES ('" . $tag . "','" . $tagType . "','" . $userID . "')"; $result = $conn->query($sql); $conn->close(); } //Check for mandatory tag fields and insert. //Once inserted, echo the new tag set if (isset($_POST['tag']) && isset($_POST['userID'])) { update_tags($tag, $userID, $tagType); echo get_tags($userID); }
$sql = ""; } else { $sql = ", post_edituser='******'user_id'] . "', post_edittime='" . time() . "'"; } $result = dbquery("UPDATE " . DB_POSTS . " SET post_message='" . $message . "', post_smileys='{$smileys}'" . $sql . " WHERE post_id='" . $_GET['post_id'] . "'"); if ($pdata['first_post'] == $_GET['post_id']) { // Pimped if ($subject != "") { $result = dbquery("UPDATE " . DB_THREADS . " SET thread_subject='{$subject}' WHERE thread_id='" . (int) $_GET['thread_id'] . "'"); } if ($settings['forum_thread_description'] && isset($_POST['description'])) { $result = dbquery("UPDATE " . DB_THREADS . " SET thread_description='{$description}' WHERE thread_id='" . (int) $_GET['thread_id'] . "'"); } } if ($settings['enable_tags'] && (iMOD || iMEMBER && $tdata['thread_author'] == $userdata['user_id'])) { update_tags((int) $_GET['thread_id'], "F", $tag_name); // Pimped: tag } if (isset($_POST['delete_attach']) && is_array($_POST['delete_attach'])) { $aresult = dbquery("SELECT attach_id, attach_name FROM " . DB_FORUM_ATTACHMENTS . " WHERE post_id='" . $_GET['post_id'] . "'"); if (dbrows($aresult)) { while ($adata = dbarray($aresult)) { // Pimped: Multi-Upload if (in_array($adata['attach_id'], $_POST['delete_attach'])) { unlink(FORUM_ATT . $adata['attach_name']); $result = dbquery("DELETE FROM " . DB_FORUM_ATTACHMENTS . " WHERE attach_id='" . $adata['attach_id'] . "'"); $result = dbquery("UPDATE " . DB_POSTS . " SET post_attachments=post_attachments-1 WHERE post_id='" . $_GET['post_id'] . "'"); } } } }
$tag_name = isset($_POST['tag_name']) ? stripinput($_POST['tag_name']) : ""; // Pimped: tag $article_keywords = stripinput($_POST['article_keywords']); // meta $draft = isset($_POST['article_draft']) ? "1" : "0"; if (!isset($_COOKIE['articles_wysiwyg_editor']) || !$_COOKIE['articles_wysiwyg_editor'] || !$settings['wysiwyg_enabled']) { $breaks = isset($_POST['line_breaks']) ? "y" : "n"; } else { $breaks = "n"; } $comments = isset($_POST['article_comments']) ? "1" : "0"; $ratings = isset($_POST['article_ratings']) ? "1" : "0"; if (isset($_POST['article_id']) && isnum($_POST['article_id'])) { $result = dbquery("UPDATE " . DB_ARTICLES . " SET article_cat='" . intval($_POST['article_cat']) . "', article_subject='{$subject}', article_snippet='{$body}', article_article='{$body2}', article_draft='{$draft}', article_breaks='{$breaks}', article_keywords='{$article_keywords}', article_allow_comments='{$comments}', article_allow_ratings='{$ratings}' WHERE article_id='" . $_POST['article_id'] . "'"); if ($settings['enable_tags']) { update_tags($_POST['article_id'], "A", $tag_name); } // Pimped: tag log_admin_action("admin-1", "admin_article_edited", "", "", $subject); redirect(FUSION_SELF . $aidlink . "&status=su"); } else { $result = dbquery("INSERT INTO " . DB_ARTICLES . " (article_cat, article_subject, article_snippet, article_article, article_draft, article_breaks, article_name, article_datestamp, article_reads, article_keywords, article_allow_comments, article_allow_ratings) VALUES ('" . intval($_POST['article_cat']) . "', '{$subject}', '{$body}', '{$body2}', '{$draft}', '{$breaks}', '" . $userdata['user_id'] . "', '" . time() . "', '0', '{$article_keywords}', '{$comments}', '{$ratings}')"); if ($settings['enable_tags']) { $id = mysql_insert_id(); // 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"); }