function hesk_stray_article($id) { global $hesk_settings, $hesklang, $article; // Set article to category ID 1 $article['catid'] = 1; // Update database hesk_dbQuery("UPDATE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "kb_articles` SET `catid`=1 WHERE `id`='" . intval($id) . "' LIMIT 1"); // Update count of articles in categories update_count(); // Return new category ID return 1; }
if (mysql_num_rows($query_run) >= 1) { return true; } } } function ip_add($ip) { $query = "INSERT INTO `hits_ip` VALUES ('{$ip}')"; $query_run = mysql_query($query); } function update_count() { $query = "SELECT `count` FROM `hits_count`"; if ($query_run = mysql_query($query)) { $count = mysql_result($query_run, 0, 'count'); $count_inc = $count + 1; $query_update = "UPDATE `hits_count` SET `count` = '{$count_inc}'"; $query_update_run = mysql_query($query_update); } } if (!ip_exists($user_ip)) { update_count(); ip_add($user_ip); echo $user_ip . ' Does not exist written to ' . '<br>'; } else { echo $user_ip . ' Already Exists!!' . '<br>'; } ?>
function save_article() { global $hesk_settings, $hesklang, $hesk_error_buffer; /* A security check */ hesk_token_check('POST'); $hesk_error_buffer = array(); $id = intval(hesk_POST('id')) or hesk_error($hesklang['kb_art_id']); $catid = intval(hesk_POST('catid', 1)); $type = intval(hesk_POST('type')); $type = $type < 0 || $type > 2 ? 0 : $type; $html = $hesk_settings['kb_wysiwyg'] ? 1 : (empty($_POST['html']) ? 0 : 1); $now = hesk_date(); $old_catid = intval(hesk_POST('old_catid')); $old_type = intval(hesk_POST('old_type')); $old_type = $old_type < 0 || $old_type > 2 ? 0 : $old_type; $subject = hesk_input(hesk_POST('subject')) or $hesk_error_buffer[] = $hesklang['kb_e_subj']; if ($html) { if (empty($_POST['content'])) { $hesk_error_buffer[] = $hesklang['kb_e_cont']; } $content = hesk_getHTML(hesk_POST('content')); } else { $content = hesk_input(hesk_POST('content')) or $hesk_error_buffer[] = $hesklang['kb_e_cont']; $content = nl2br($content); $content = hesk_makeURL($content); } $sticky = isset($_POST['sticky']) ? 1 : 0; $keywords = hesk_input(hesk_POST('keywords')); $extra_sql = ''; if (hesk_POST('resetviews') == 'Y') { $extra_sql .= ',`views`=0 '; } if (hesk_POST('resetvotes') == 'Y') { $extra_sql .= ',`votes`=0, `rating`=0 '; } /* Article attachments */ define('KB', 1); require_once HESK_PATH . 'inc/posting_functions.inc.php'; require_once HESK_PATH . 'inc/attachments.inc.php'; $attachments = array(); for ($i = 1; $i <= 3; $i++) { $att = hesk_uploadFile($i); if (!empty($att)) { $attachments[$i] = $att; } } $myattachments = ''; /* Any errors? */ if (count($hesk_error_buffer)) { // Remove any successfully uploaded attachments if ($hesk_settings['attachments']['use']) { hesk_removeAttachments($attachments); } $_SESSION['edit_article'] = array('type' => $type, 'html' => $html, 'subject' => $subject, 'content' => hesk_input(hesk_POST('content')), 'keywords' => $keywords, 'catid' => $catid, 'sticky' => $sticky, 'resetviews' => isset($_POST['resetviews']) ? 'Y' : 0, 'resetvotes' => isset($_POST['resetvotes']) ? 'Y' : 0); $tmp = ''; foreach ($hesk_error_buffer as $error) { $tmp .= "<li>{$error}</li>\n"; } $hesk_error_buffer = $tmp; $hesk_error_buffer = $hesklang['rfm'] . '<br /><br /><ul>' . $hesk_error_buffer . '</ul>'; hesk_process_messages($hesk_error_buffer, './manage_knowledgebase.php?a=edit_article&id=' . $id); } /* Add to database */ if (!empty($attachments)) { foreach ($attachments as $myatt) { hesk_dbQuery("INSERT INTO `" . hesk_dbEscape($hesk_settings['db_pfix']) . "kb_attachments` (`saved_name`,`real_name`,`size`) VALUES ('" . hesk_dbEscape($myatt['saved_name']) . "', '" . hesk_dbEscape($myatt['real_name']) . "', '" . intval($myatt['size']) . "')"); $myattachments .= hesk_dbInsertID() . '#' . $myatt['real_name'] . ','; } $extra_sql .= ", `attachments` = CONCAT(`attachments`, '" . $myattachments . "') "; } /* Update article in the database */ $revision = sprintf($hesklang['revision2'], $now, $_SESSION['name'] . ' (' . $_SESSION['user'] . ')'); hesk_dbQuery("UPDATE `" . hesk_dbEscape($hesk_settings['db_pfix']) . "kb_articles` SET\r\n `catid`=" . intval($catid) . ",\r\n `subject`='" . hesk_dbEscape($subject) . "',\r\n `content`='" . hesk_dbEscape($content) . "',\r\n `keywords`='" . hesk_dbEscape($keywords) . "' {$extra_sql} ,\r\n `type`='" . intval($type) . "',\r\n `html`='" . intval($html) . "',\r\n `sticky`='" . intval($sticky) . "',\r\n `history`=CONCAT(`history`,'" . hesk_dbEscape($revision) . "')\r\n WHERE `id`='" . intval($id) . "' LIMIT 1"); $_SESSION['artord'] = $id; // Update proper category article count // (just do them all to be sure, don't compliate...) update_count(); // Update article order update_article_order($catid); hesk_process_messages($hesklang['your_kb_mod'], './manage_knowledgebase.php?a=manage_cat&catid=' . $catid, 'SUCCESS'); }