function print_files()
{
$data = array();
//should declare array to be used to hold valid input files
echo '<b>Ingesting the data files that are in the data directory!</b>';
echo '<br>*******************************************************<br>';
$dirfiles = listdir(ES__PLUGIN_DIR . "data");
if ($dirfiles) {
foreach ($dirfiles as $key => $filename) {
if (substr($filename, -4) == '.txt' && !is_dir($filename)) {
$data[$filename] = php_strip_whitespace($filename);
$theData = make_post($filename);
insert_post($theData);
echo "<br>";
echo "<br>Finished.";
echo "<br>";
} else {
$other[$filename] = !is_dir($filename) ? file_get_contents($filename) : '';
}
}
$myFile = ES__PLUGIN_DIR . "/data/test.txt";
$fh = fopen($myFile, 'r');
$theData = fread($fh, filesize($myFile));
fclose($fh);
}
insert_post($theData);
echo "<br>";
echo "<br>Finished.";
echo "<br>";
}
function insert_post_with_attach($message, $subject, $forum_id, $user_id, $user_name, $user_attach_sig, $filenames, $topic_id = NULL, $topic_type = POST_NORMAL, $do_notification = false, $notify_user = false, $current_time = 0, $error_die_function = '', $html_on = 0, $bbcode_on = 1, $smilies_on = 1)
{
// First, post the message
$error_die_function = $error_die_function == '' ? "message_die" : $error_die_function;
$post_details = insert_post($message, $subject, $forum_id, $user_id, $user_name, $user_attach_sig, $topic_id, $topic_type, $do_notification, $notify_user, $current_time, $error_die_function, $html_on, $bbcode_on, $smilies_on);
// Now, post a attachment for each of the files listed in $filenames
$attachments = array();
foreach ($filenames as $filename) {
$attachments[] = add_attach($user_id, $post_details['post_id'], $filename, $filename, $error_die_function);
}
$post_details['attachments'] = $attachments;
return $post_details;
}
<?php
include '../model/messages.php';
//CRUD messages
if ($_POST['method'] == 'insertmsg') {
insert_msg();
}
if ($_POST['method'] == 'insertpost') {
insert_post();
}
if ($_POST['method'] == 'showmsg') {
show_msg();
}
if ($_POST['method'] == 'showMsgsFromChatRoom') {
showMsgsFromChatRoom();
}
</td>
</tr><?php
}
}
?>
</table><?php
}
if ($_POST["action"] == "addnew") {
if (post_exists($_POST["id"], "post")) {
$data = "title='" . $_POST["title"] . "', content='" . $_POST["content"] . "'";
update_post($_POST["id"], $data);
echo "updated post!";
echo "<a href=?action=new&id=" . $_POST["id"] . ">Edit again</a> | ";
echo "<a href=" . get_blog_stuff("url") . "blog.htm#post" . $_POST["id"] . ">Visit</a>";
} else {
insert_post($_POST["title"], $_POST["content"]);
echo "inserted post";
}
} elseif ($_GET["action"] == "new") {
?>
<form method="post" action="<?php
echo $_SERVER["PHP_SELF"];
?>
">
<input type="hidden" name="action" value="addnew">
<input name="title" id="title" value="<?php
echo get_post_stuff($_GET["id"], "title");
?>
">
<input name="id" type="hidden" value="<?php
echo $_GET["id"];
function topic_move($topic_id, $to_forum_id, $from_forum_id = null, $leave_shadow = false, $insert_bot_msg = false)
{
global $log_action;
$to_forum_id = (int) $to_forum_id;
// Verify input params
if (!($topic_csv = get_id_csv($topic_id))) {
return false;
}
if (!forum_exists($to_forum_id)) {
return false;
}
if ($from_forum_id && (!forum_exists($from_forum_id) || $to_forum_id == $from_forum_id)) {
return false;
}
// Get topics info
$where_sql = ($forum_csv = get_id_csv($from_forum_id)) ? "AND forum_id IN({$forum_csv})" : '';
$sql = "SELECT * FROM " . BB_TOPICS . " WHERE topic_id IN({$topic_csv}) AND topic_status != " . TOPIC_MOVED . " {$where_sql}";
$topics = array();
$sync_forums = array($to_forum_id => true);
foreach (DB()->fetch_rowset($sql) as $row) {
if ($row['forum_id'] != $to_forum_id) {
$topics[$row['topic_id']] = $row;
$sync_forums[$row['forum_id']] = true;
}
}
if (!$topics or !($topic_csv = get_id_csv(array_keys($topics)))) {
return false;
}
// Insert topic in the old forum that indicates that the topic has moved
if ($leave_shadow) {
$shadows = array();
foreach ($topics as $topic_id => $row) {
$shadows[] = array('forum_id' => $row['forum_id'], 'topic_title' => $row['topic_title'], 'topic_poster' => $row['topic_poster'], 'topic_time' => TIMENOW, 'topic_status' => TOPIC_MOVED, 'topic_type' => POST_NORMAL, 'topic_vote' => $row['topic_vote'], 'topic_views' => $row['topic_views'], 'topic_replies' => $row['topic_replies'], 'topic_first_post_id' => $row['topic_first_post_id'], 'topic_last_post_id' => $row['topic_last_post_id'], 'topic_moved_id' => $topic_id, 'topic_last_post_time' => $row['topic_last_post_time']);
}
if ($sql_args = DB()->build_array('MULTI_INSERT', $shadows)) {
DB()->query("INSERT INTO " . BB_TOPICS . $sql_args);
}
}
DB()->query("UPDATE " . BB_TOPICS . " SET forum_id = {$to_forum_id} WHERE topic_id IN({$topic_csv})");
DB()->query("UPDATE " . BB_POSTS . " SET forum_id = {$to_forum_id} WHERE topic_id IN({$topic_csv})");
DB()->query("UPDATE " . BB_BT_TORRENTS . " SET forum_id = {$to_forum_id} WHERE topic_id IN({$topic_csv})");
// Bot
if ($insert_bot_msg) {
foreach ($topics as $topic_id => $row) {
insert_post('after_move', $topic_id, $to_forum_id, $row['forum_id']);
}
sync('topic', array_keys($topics));
}
// Sync
sync('forum', array_keys($sync_forums));
// Log action
foreach ($topics as $topic_id => $row) {
$log_action->mod('mod_topic_move', array('forum_id' => $row['forum_id'], 'forum_id_new' => $to_forum_id, 'topic_id' => $topic_id, 'topic_title' => $row['topic_title']));
}
return true;
}
if (isset($_GET['state'])) {
$state = $_GET['state'];
} else {
$state = -1;
}
if (isset($_GET['county'])) {
$county = $_GET['county'];
} else {
$county = -1;
}
if (isset($_GET['city'])) {
$city = $_GET['city'];
} else {
$city = -1;
}
insert_post($conn, $author, $title, $content, $state, $county, $city);
} catch (PDOException $e) {
echo "Connection failed: " . $e->getMessage();
return;
}
$conn = null;
function insert_post($conn, $author, $title, $content, $state, $county, $city)
{
echo $state;
$stmt = $conn->prepare("INSERT INTO posts (author, title, content, state, county, city) VALUES (:author,:title,:content,:state,:county,:city);");
$stmt->bindparam(':author', $author);
$stmt->bindparam(':title', $title);
$stmt->bindparam(':content', $content);
$stmt->bindparam(':state', $state);
$stmt->bindparam(':county', $county);
$stmt->bindparam(':city', $city);
function create_page($title, $content)
{
return insert_post($title, $content, "page");
}
}
?>
</ul>
</div> <!-- header -->
<div id = 'sort_menu'>
<ul>
<li><a href = '../feels/index.php?m=latest'>Latest</a></li>
<li><a href = '../feels/index.php?m=p_today'>Popular Today</a></li>
<li><a href = '../feels/index.php?m=p_week'>Popular This Week</a></li>
<li><a href = '../feels/index.php?m=all_time'>Popular All Time</a></li>
<li><a href = '../feels/index.php?m=random'>Random</a></li>
<li><a class = 'active' href = 'index.php'>Post</a></li>
</ul>
</div> <!-- sort menu -->
<?php
require_once "../scripts/functions.php";
if (!isset($_POST['u_name']) || !isset($_POST['body'])) {
die;
}
$name = $_POST['u_name'];
$body = $_POST['body'];
if (insert_post($name, $body)) {
echo "<div style = \n\t\t\t\t' text-align: center; color: #39f; font-size: 2em;\n\t\t\t\t margin: 0 auto; margin-top: 32px; padding: 32px; font-family: Sans-Serif;'>\n\t\t\t\t Feel posted successfully!</div>";
} else {
echo "<div style = \n\t\t\t\t' text-align: center; color: #8F0000; font-size: 2em;\n\t\t\t\t margin: 0 auto; margin-top: 64px; padding: 32px; font-family: Sans-Serif;'>\n\t\t\t\t There was an error processing your request.</div>";
}
?>
</body>
</html>
if (!DB()->sql_query($sql)) {
message_die(GENERAL_ERROR, 'Could not update topics watch table', '', __LINE__, __FILE__, $sql);
}
$sql_where = !empty($HTTP_POST_VARS['split_type_beyond']) ? " post_time >= {$post_time} AND topic_id = {$topic_id}" : "post_id IN ({$post_id_sql})";
$sql = "UPDATE " . POSTS_TABLE . "\r\n\t\t\t\t\tSET topic_id = {$new_topic_id}, forum_id = {$new_forum_id}\r\n\t\t\t\t\tWHERE {$sql_where}";
if (!DB()->sql_query($sql, END_TRANSACTION)) {
message_die(GENERAL_ERROR, 'Could not update posts table', '', __LINE__, __FILE__, $sql);
}
//bot
if (isset($_POST['after_split_to_old'])) {
require_once FT_ROOT . 'includes/functions_post.php';
insert_post('after_split_to_old', $topic_id, $forum_id, '', $new_topic_id, str_replace("\\'", "''", $post_subject));
}
if (isset($_POST['after_split_to_new'])) {
require_once FT_ROOT . 'includes/functions_post.php';
insert_post('after_split_to_new', $new_topic_id, $new_forum_id, $forum_id, $new_topic_id, '', $topic_id);
}
//bot end
sync('topic', $new_topic_id);
sync('topic', $topic_id);
sync('forum', $new_forum_id);
sync('forum', $forum_id);
$template->assign_vars(array('META' => '<meta http-equiv="refresh" content="3;url=' . "viewtopic.php?" . POST_TOPIC_URL . "={$topic_id}&sid=" . $userdata['session_id'] . '">'));
//bot
$message = $lang['Topic_split'] . '<br /><br /><a href="' . "viewtopic.php?" . POST_TOPIC_URL . "={$topic_id}&sid=" . $userdata['session_id'] . '">' . $lang['Topic_split_old'] . '</a>';
$message .= ' :: <a href="' . "viewtopic.php?" . POST_TOPIC_URL . "={$new_topic_id}&sid=" . $userdata['session_id'] . '">' . $lang['Topic_split_new'] . '</a>';
//bot end
message_die(GENERAL_MESSAGE, $message);
}
} else {
if ($post_id_sql && $delete_posts) {
if (isset($_GET['state'])) {
$state = $_GET['state'];
} else {
$state = -1;
}
if (isset($_GET['county'])) {
$county = $_GET['county'];
} else {
$county = -1;
}
if (isset($_GET['city'])) {
$city = $_GET['city'];
} else {
$city = -1;
}
insert_post($conn, $author, $question, $state, $county, $city);
} catch (PDOException $e) {
echo "Connection failed: " . $e->getMessage();
return;
}
$conn = null;
function insert_post($conn, $author, $question, $content, $state, $county, $city)
{
echo $state;
$stmt = $conn->prepare("INSERT INTO polls (author, question, state, county, city) VALUES (:author,:question,:state,:county,:city);");
$stmt->bindparam(':author', $author);
$stmt->bindparam(':question', $question);
$stmt->bindparam(':state', $state);
$stmt->bindparam(':county', $county);
$stmt->bindparam(':city', $city);
$stmt->execute();
<?php
session_start();
include_once '../includes/db_access.php';
include_once '../includes/functions.php';
$title = $_POST["title"];
$author = $_SESSION["uname"];
$anchor = $_POST["anchor"];
$content = $_POST["content"];
$type = NULL;
if (!isset($_POST["video"])) {
$type = "1";
} else {
$type = "2";
}
$order = $_POST["order"];
$post_id = insert_post($title, $author, $anchor, $content, $type, $video = NULL, $status = 0, $order);
<?php
include 'functions.php';
session_start();
check_valid_user();
do_html_header('Write Post');
$author_id = $_POST['author_id'];
$category = $_POST['category'];
$title = $_POST['title'];
$body = $_POST['body'];
$result = insert_post($author_id, $title, $body, $category);
if ($result) {
echo "Insert your post successfully.";
} else {
echo "Fail to insert your post.";
}
do_html_url('blog', 'Back to Home');
do_html_footer();
<?php
session_start();
if (isset($_POST["submit"]) and !empty($_POST["box"])) {
$id = $_SESSION['id'];
$rollno = $_SESSION['rollno'];
$status = $_POST["box"];
include "db.php";
$connectionStatus = connect_db();
$result = insert_post($connectionStatus, $id, $rollno, $status);
if ($result) {
echo "success";
header("Location: status.php?id=&v=Success");
} else {
echo "Error";
}
header("Location: status.php");
} else {
header("Location: status.php?id=error&v=Error: All fields mandatory");
}
