| Zeile 3 | Zeile 3 |
|---|
* MyBB 1.2
* Copyright � 2006 MyBB Group, All Rights Reserved
*
|
* MyBB 1.2
* Copyright � 2006 MyBB Group, All Rights Reserved
*
|
* Website: http://www.mybboard.com
* License: http://www.mybboard.com/eula.html
| * Website: http://www.mybboard.net
* License: http://www.mybboard.net/eula.html
|
*
|
*
|
* $Id: post.php 2394 2006-11-10 04:55:06Z Tikitiki $
| * $Id: post.php 4005 2008-07-10 17:53:25Z Tikitiki $
|
*/
|
*/
|
| |
// Disallow direct access to this file for security reasons
if(!defined("IN_MYBB"))
{
die("Direct initialization of this file is not allowed.<br /><br />Please make sure IN_MYBB is defined.");
}
|
/*
EXAMPLE USE:
|
/*
EXAMPLE USE:
|
| Zeile 60 | Zeile 66 |
|---|
/**
* Array of data used to update a post.
|
/**
* Array of data used to update a post.
|
*
* @var array
*/
| *
* @var array
*/
|
var $post_update_data = array();
/**
| var $post_update_data = array();
/**
|
| Zeile 115 | Zeile 121 |
|---|
{
$user = get_user($post['uid']);
$post['username'] = $user['username'];
|
{
$user = get_user($post['uid']);
$post['username'] = $user['username'];
|
}
| }
|
// After all of this, if we still don't have a username, force the username as "Guest" (Note, this is not translatable as it is always a fallback)
if(!$post['username'])
{
| // After all of this, if we still don't have a username, force the username as "Guest" (Note, this is not translatable as it is always a fallback)
if(!$post['username'])
{
|
| Zeile 152 | Zeile 158 |
|---|
$post['tid'] = $db->fetch_field($query, "tid");
}
// Here we determine if we're editing the first post of a thread or not.
|
$post['tid'] = $db->fetch_field($query, "tid");
}
// Here we determine if we're editing the first post of a thread or not.
|
$options = array(
| $options = array(
|
"limit" => 1,
"limit_start" => 0,
"order_by" => "dateline",
| "limit" => 1,
"limit_start" => 0,
"order_by" => "dateline",
|
| Zeile 203 | Zeile 209 |
|---|
}
// Subject is valid - return true.
|
}
// Subject is valid - return true.
|
return true;
}
/**
| return true;
}
/**
|
* Verifies a post message.
*
* @param string The message content.
| * Verifies a post message.
*
* @param string The message content.
|
| Zeile 222 | Zeile 228 |
|---|
if(my_strlen($post['message']) == 0)
{
$this->set_error("missing_message");
|
if(my_strlen($post['message']) == 0)
{
$this->set_error("missing_message");
|
return false;
}
| return false;
}
|
// If this board has a maximum message length check if we're over it.
else if(my_strlen($post['message']) > $mybb->settings['maxmessagelength'] && $mybb->settings['maxmessagelength'] > 0 && is_moderator($post['fid'], "", $post['uid']) != "yes")
{
| // If this board has a maximum message length check if we're over it.
else if(my_strlen($post['message']) > $mybb->settings['maxmessagelength'] && $mybb->settings['maxmessagelength'] > 0 && is_moderator($post['fid'], "", $post['uid']) != "yes")
{
|
| Zeile 260 | Zeile 266 |
|---|
/**
* Verify that the user is not flooding the system.
|
/**
* Verify that the user is not flooding the system.
|
*
| *
|
* @return boolean True
*/
function verify_post_flooding()
| * @return boolean True
*/
function verify_post_flooding()
|
| Zeile 297 | Zeile 303 |
|---|
/**
* Verifies the image count.
|
/**
* Verifies the image count.
|
*
* @return boolean True when valid, false when not valid.
| *
* @return boolean True when valid, false when not valid.
|
*/
function verify_image_count()
{
| */
function verify_image_count()
{
|
| Zeile 308 | Zeile 314 |
|---|
// Get the permissions of the user who is making this post or thread
$permissions = user_permissions($post['uid']);
|
// Get the permissions of the user who is making this post or thread
$permissions = user_permissions($post['uid']);
|
|
|
// Fetch the forum this post is being made in
$forum = get_forum($post['fid']);
// Check if this post contains more images than the forum allows
if($post['savedraft'] != 1 && $mybb->settings['maxpostimages'] != 0 && $permissions['cancp'] != "yes")
|
// Fetch the forum this post is being made in
$forum = get_forum($post['fid']);
// Check if this post contains more images than the forum allows
if($post['savedraft'] != 1 && $mybb->settings['maxpostimages'] != 0 && $permissions['cancp'] != "yes")
|
{
if($post['options']['disablesmilies'] == "yes")
{
require_once MYBB_ROOT."inc/class_parser.php";
$parser = new postParser;
// Parse the message.
$parser_options = array(
"allow_html" => $forum['allowhtml'],
"allow_mycode" => $forum['allowmycode'],
"allow_smilies" => $forum['allowmilies'],
"allow_imgcode" => $forum['allowimgcode']
);
| {
require_once MYBB_ROOT."inc/class_parser.php";
$parser = new postParser;
// Parse the message.
$parser_options = array(
"allow_html" => $forum['allowhtml'],
"allow_mycode" => $forum['allowmycode'],
"allow_imgcode" => $forum['allowimgcode']
);
if($post['options']['disablesmilies'] != "yes")
{
$parser_options['allow_smilies'] = $forum['allowsmilies'];
}
else
{
$parser_options['allow_smilies'] = "no";
}
|
|
|
$image_check = $parser->parse_message($post['message'], $parser_options);
// And count the number of image tags in the message.
$image_count = substr_count($image_check, "<img");
if($image_count > $mybb->settings['maxpostimages'])
{
// Throw back a message if over the count with the number of images as well as the maximum number of images per post.
$this->set_error("too_many_images", array(1 => $image_count, 2 => $mybb->settings['maxpostimages']));
return false;
}
| $image_check = $parser->parse_message($post['message'], $parser_options);
|
|
|
| | // And count the number of image tags in the message.
$image_count = substr_count($image_check, "<img");
if($image_count > $mybb->settings['maxpostimages'])
{
// Throw back a message if over the count with the number of images as well as the maximum number of images per post.
$this->set_error("too_many_images", array(1 => $image_count, 2 => $mybb->settings['maxpostimages']));
return false;
|
}
}
}
/**
* Verify the reply-to post.
|
}
}
}
/**
* Verify the reply-to post.
|
*
| *
|
* @return boolean True when valid, false when not valid.
*/
function verify_reply_to()
| * @return boolean True when valid, false when not valid.
*/
function verify_reply_to()
|
| Zeile 380 | Zeile 390 |
|---|
$query = $db->simple_select(TABLE_PREFIX."posts", "pid", "tid='{$post['tid']}'", $options);
$reply_to = $db->fetch_array($query);
$post['replyto'] = $reply_to['pid'];
|
$query = $db->simple_select(TABLE_PREFIX."posts", "pid", "tid='{$post['tid']}'", $options);
$reply_to = $db->fetch_array($query);
$post['replyto'] = $reply_to['pid'];
|
}
| }
|
return true;
}
|
return true;
}
|
| Zeile 398 | Zeile 408 |
|---|
// If we don't assign it as 0.
if(!$post['icon'] || $post['icon'] < 0)
|
// If we don't assign it as 0.
if(!$post['icon'] || $post['icon'] < 0)
|
{
| {
|
$post['icon'] = 0;
}
return true;
}
|
$post['icon'] = 0;
}
return true;
}
|
|
|
/**
* Verify the dateline.
*
| /**
* Verify the dateline.
*
|
| Zeile 415 | Zeile 425 |
|---|
// The date has to be numeric and > 0.
if($dateline < 0 || is_numeric($dateline) == false)
|
// The date has to be numeric and > 0.
if($dateline < 0 || is_numeric($dateline) == false)
|
{
| {
|
$dateline = time();
}
}
| $dateline = time();
}
}
|
| Zeile 433 | Zeile 443 |
|---|
$time = time();
// Verify all post assets.
|
$time = time();
// Verify all post assets.
|
|
if($this->method != "update" && !$post['savedraft'])
{
$this->verify_post_flooding();
}
|
if($this->method == "insert" || array_key_exists('uid', $post))
{
$this->verify_author();
|
if($this->method == "insert" || array_key_exists('uid', $post))
{
$this->verify_author();
|
}
| }
|
if($this->method == "insert" || array_key_exists('subject', $post))
|
if($this->method == "insert" || array_key_exists('subject', $post))
|
{
| {
|
$this->verify_subject();
|
$this->verify_subject();
|
}
| }
|
if($this->method == "insert" || array_key_exists('message', $post))
{
|
if($this->method == "insert" || array_key_exists('message', $post))
{
|
| Zeile 451 | Zeile 466 |
|---|
}
if($this->method == "insert" || array_key_exists('dateline', $post))
|
}
if($this->method == "insert" || array_key_exists('dateline', $post))
|
{
$this->verify_dateline();
}
if($this->method != "update" && !$post['savedraft'])
{
$this->verify_post_flooding();
}
| {
$this->verify_dateline();
}
|
if($this->method == "insert" || array_key_exists('replyto', $post))
|
if($this->method == "insert" || array_key_exists('replyto', $post))
|
{
| {
|
$this->verify_reply_to();
}
if($this->method == "insert" || array_key_exists('icon', $post))
{
$this->verify_post_icon();
|
$this->verify_reply_to();
}
if($this->method == "insert" || array_key_exists('icon', $post))
{
$this->verify_post_icon();
|
}
| }
|
if($this->method == "insert" || array_key_exists('options', $post))
|
if($this->method == "insert" || array_key_exists('options', $post))
|
{
| {
|
$this->verify_options();
|
$this->verify_options();
|
}
| }
|
$plugins->run_hooks_by_ref("datahandler_post_validate_post", $this);
// We are done validating, return.
$this->set_validated(true);
if(count($this->get_errors()) > 0)
|
$plugins->run_hooks_by_ref("datahandler_post_validate_post", $this);
// We are done validating, return.
$this->set_validated(true);
if(count($this->get_errors()) > 0)
|
{
| {
|
return false;
}
else
{
return true;
|
return false;
}
else
{
return true;
|
}
| }
|
}
| }
|
| Zeile 522 | Zeile 532 |
|---|
{
// Automatic subscription to the thread
if($post['options']['emailnotify'] != "no" && $post['uid'] > 0)
|
{
// Automatic subscription to the thread
if($post['options']['emailnotify'] != "no" && $post['uid'] > 0)
|
{
| {
|
$query = $db->simple_select(TABLE_PREFIX."favorites", "fid", "uid='".intval($post['uid'])."' AND tid='".intval($post['tid'])."' AND type='s'", array("limit" => 1));
$already_subscribed = $db->fetch_field($query, "fid");
if(!$already_subscribed)
| $query = $db->simple_select(TABLE_PREFIX."favorites", "fid", "uid='".intval($post['uid'])."' AND tid='".intval($post['tid'])."' AND type='s'", array("limit" => 1));
$already_subscribed = $db->fetch_field($query, "fid");
if(!$already_subscribed)
|
| Zeile 558 | Zeile 568 |
|---|
{
$newclosed = "closed='no'";
log_moderator_action($modlogdata, "Thread opened");
|
{
$newclosed = "closed='no'";
log_moderator_action($modlogdata, "Thread opened");
|
}
| }
|
// Stick the thread.
if($modoptions['stickthread'] == "yes" && $thread['sticky'] != 1)
{
$newstick = "sticky='1'";
log_moderator_action($modlogdata, "Thread stuck");
|
// Stick the thread.
if($modoptions['stickthread'] == "yes" && $thread['sticky'] != 1)
{
$newstick = "sticky='1'";
log_moderator_action($modlogdata, "Thread stuck");
|
}
| }
|
// Unstick the thread.
if($modoptions['stickthread'] != "yes" && $thread['sticky'])
|
// Unstick the thread.
if($modoptions['stickthread'] != "yes" && $thread['sticky'])
|
| Zeile 576 | Zeile 586 |
|---|
// Execute moderation options.
if($newstick && $newclosed)
|
// Execute moderation options.
if($newstick && $newclosed)
|
{
| {
|
$sep = ",";
}
if($newstick || $newclosed)
| $sep = ",";
}
if($newstick || $newclosed)
|
| Zeile 587 | Zeile 597 |
|---|
WHERE tid='{$thread['tid']}'
");
}
|
WHERE tid='{$thread['tid']}'
");
}
|
}
| }
|
// Fetch the forum this post is being made in
$forum = get_forum($post['fid']);
// Decide on the visibility of this post.
if($forum['modposts'] == "yes" && is_moderator($thread['fid'], "", $thread['uid']) != "yes")
|
// Fetch the forum this post is being made in
$forum = get_forum($post['fid']);
// Decide on the visibility of this post.
if($forum['modposts'] == "yes" && is_moderator($thread['fid'], "", $thread['uid']) != "yes")
|
{
$visible = 0;
}
| {
$visible = 0;
}
else
{
$visible = 1;
}
}
if($visible == 1)
{
$now = time();
if($forum['usepostcounts'] != "no")
{
$queryadd = ",postnum=postnum+1";
}
|
else
{
|
else
{
|
$visible = 1;
| $queryadd = '';
|
}
|
}
|
| | $db->query("UPDATE ".TABLE_PREFIX."users SET lastpost='{$now}' {$queryadd} WHERE uid='{$post['uid']}'");
|
}
|
}
|
|
|
$post['pid'] = intval($post['pid']);
$post['uid'] = intval($post['uid']);
$query = $db->simple_select(TABLE_PREFIX."posts", "tid", "pid='{$post['pid']}' AND uid='{$post['uid']}' AND visible='-2'");
| $post['pid'] = intval($post['pid']);
$post['uid'] = intval($post['uid']);
$query = $db->simple_select(TABLE_PREFIX."posts", "tid", "pid='{$post['pid']}' AND uid='{$post['uid']}' AND visible='-2'");
|
| Zeile 610 | Zeile 635 |
|---|
// Are we updating a post which is already a draft? Perhaps changing it into a visible post?
if($draft_check)
|
// Are we updating a post which is already a draft? Perhaps changing it into a visible post?
if($draft_check)
|
{
| {
|
// Update a post that is a draft
$this->post_update_data = array(
"subject" => $db->escape_string($post['subject']),
| // Update a post that is a draft
$this->post_update_data = array(
"subject" => $db->escape_string($post['subject']),
|
| Zeile 618 | Zeile 643 |
|---|
"uid" => $post['uid'],
"username" => $db->escape_string($post['username']),
"dateline" => intval($post['dateline']),
|
"uid" => $post['uid'],
"username" => $db->escape_string($post['username']),
"dateline" => intval($post['dateline']),
|
"message" => $db->escape_string($post['message']),
"ipaddress" => $db->escape_string($post['ipaddress']),
"includesig" => $post['options']['signature'],
"smilieoff" => $post['options']['disablesmilies'],
"visible" => $visible,
"posthash" => $db->escape_string($post['posthash'])
);
$plugins->run_hooks_by_ref("datahandler_post_insert_post", $this);
| "message" => $db->escape_string($post['message']),
"ipaddress" => $db->escape_string($post['ipaddress']),
"includesig" => $post['options']['signature'],
"smilieoff" => $post['options']['disablesmilies'],
"visible" => $visible,
"posthash" => $db->escape_string($post['posthash'])
);
$plugins->run_hooks_by_ref("datahandler_post_insert_post", $this);
|
$db->update_query(TABLE_PREFIX."posts", $this->post_update_data, "pid='{$post['pid']}'");
$this->pid = $post['pid'];
}
| $db->update_query(TABLE_PREFIX."posts", $this->post_update_data, "pid='{$post['pid']}'");
$this->pid = $post['pid'];
}
|
| Zeile 672 | Zeile 697 |
|---|
$thread = get_thread($post['tid']);
require_once MYBB_ROOT.'inc/class_parser.php';
$parser = new Postparser();
|
$thread = get_thread($post['tid']);
require_once MYBB_ROOT.'inc/class_parser.php';
$parser = new Postparser();
|
| |
$done_users = array();
|
$subject = $parser->parse_badwords($thread['subject']);
$excerpt = $parser->strip_mycode($post['message']);
$excerpt = my_substr($excerpt, 0, $mybb->settings['subscribeexcerpt']).$lang->emailbit_viewthread;
|
$subject = $parser->parse_badwords($thread['subject']);
$excerpt = $parser->strip_mycode($post['message']);
$excerpt = my_substr($excerpt, 0, $mybb->settings['subscribeexcerpt']).$lang->emailbit_viewthread;
|
| |
// Parse badwords
$excerpt = $parser->parse_badwords($excerpt);
|
// Fetch any users subscribed to this thread and queue up their subscription notices
$query = $db->query("
|
// Fetch any users subscribed to this thread and queue up their subscription notices
$query = $db->query("
|
| Zeile 694 | Zeile 725 |
|---|
}
$done_users[$subscribedmember['uid']] = 1;
if($subscribedmember['language'] != '' && $lang->language_exists($subscribedmember['language']))
|
}
$done_users[$subscribedmember['uid']] = 1;
if($subscribedmember['language'] != '' && $lang->language_exists($subscribedmember['language']))
|
{
| {
|
$uselang = $subscribedmember['language'];
}
elseif($mybb->settings['bblanguage'])
| $uselang = $subscribedmember['language'];
}
elseif($mybb->settings['bblanguage'])
|
| Zeile 728 | Zeile 759 |
|---|
}
$emailsubject = sprintf($emailsubject, $subject);
$emailmessage = sprintf($emailmessage, $subscribedmember['username'], $post['username'], $mybb->settings['bbname'], $subject, $excerpt, $mybb->settings['bburl'], $thread['tid']);
|
}
$emailsubject = sprintf($emailsubject, $subject);
$emailmessage = sprintf($emailmessage, $subscribedmember['username'], $post['username'], $mybb->settings['bbname'], $subject, $excerpt, $mybb->settings['bburl'], $thread['tid']);
|
$new_email = array(
"mailto" => $db->escape_string($subscribedmember['email']),
"mailfrom" => '',
"subject" => $db->escape_string($emailsubject),
"message" => $db->escape_string($emailmessage)
);
| $new_email = array(
"mailto" => $db->escape_string($subscribedmember['email']),
"mailfrom" => '',
"subject" => $db->escape_string($emailsubject),
"message" => $db->escape_string($emailmessage),
"headers" => ''
);
|
$db->insert_query(TABLE_PREFIX."mailqueue", $new_email);
unset($userlang);
$queued_email = 1;
|
$db->insert_query(TABLE_PREFIX."mailqueue", $new_email);
unset($userlang);
$queued_email = 1;
|
}
| }
|
// Have one or more emails been queued? Update the queue count
if($queued_email == 1)
{
$cache->updatemailqueue();
|
// Have one or more emails been queued? Update the queue count
if($queued_email == 1)
{
$cache->updatemailqueue();
|
}
| }
$thread_update = array("replies" => "+1");
|
// Update forum count
|
// Update forum count
|
update_thread_count($post['tid']);
update_forum_count($post['fid']);
$cache->updatestats();
}
| update_thread_counters($post['tid'], $thread_update);
update_forum_counters($post['fid'], array("posts" => "+1"));
}
|
// Post is stuck in moderation queue
else if($visible == 0)
{
// Update the unapproved posts count for the current thread and current forum
|
// Post is stuck in moderation queue
else if($visible == 0)
{
// Update the unapproved posts count for the current thread and current forum
|
update_thread_count($post['tid']);
update_forum_count($post['fid']);
}
if($visible != -2)
{
$now = time();
if($forum['usepostcounts'] != "no")
{
$queryadd = ",postnum=postnum+1";
}
else
{
$queryadd = '';
}
$db->query("UPDATE ".TABLE_PREFIX."users SET lastpost='{$now}' {$queryadd} WHERE uid='{$post['uid']}'");
| update_thread_counters($post['tid'], array("unapprovedposts" => "+1"));
update_forum_counters($post['fid'], array("unapprovedposts" => "+1"));
|
}
// Return the post's pid and whether or not it is visible.
| }
// Return the post's pid and whether or not it is visible.
|
| Zeile 790 | Zeile 808 |
|---|
$thread = &$this->data;
// Validate all thread assets.
|
$thread = &$this->data;
// Validate all thread assets.
|
| |
if(!$thread['savedraft'])
{
$this->verify_post_flooding();
}
|
if($this->method == "insert" || array_key_exists('uid', $thread))
|
if($this->method == "insert" || array_key_exists('uid', $thread))
|
{
| {
|
$this->verify_author();
|
$this->verify_author();
|
}
| }
|
if($this->method == "insert" || array_key_exists('subject', $thread))
|
if($this->method == "insert" || array_key_exists('subject', $thread))
|
{
| {
|
$this->verify_subject();
}
if($this->method == "insert" || array_key_exists('message', $thread))
|
$this->verify_subject();
}
if($this->method == "insert" || array_key_exists('message', $thread))
|
{
| {
|
$this->verify_message();
$this->verify_image_count();
|
$this->verify_message();
$this->verify_image_count();
|
}
| }
|
if($this->method == "insert" || array_key_exists('dateline', $thread))
|
if($this->method == "insert" || array_key_exists('dateline', $thread))
|
{
| {
|
$this->verify_dateline();
|
$this->verify_dateline();
|
}
| }
|
if($this->method == "insert" || array_key_exists('icon', $thread))
|
if($this->method == "insert" || array_key_exists('icon', $thread))
|
{
| {
|
$this->verify_post_icon();
|
$this->verify_post_icon();
|
}
| }
|
if($this->method == "insert" || array_key_exists('options', $thread))
{
$this->verify_options();
|
if($this->method == "insert" || array_key_exists('options', $thread))
{
$this->verify_options();
|
}
if(!$thread['savedraft'])
{
$this->verify_post_flooding();
}
| }
|
$plugins->run_hooks_by_ref("datahandler_post_validate_thread", $this);
|
$plugins->run_hooks_by_ref("datahandler_post_validate_thread", $this);
|
| Zeile 898 | Zeile 916 |
|---|
// Are we updating a post which is already a draft? Perhaps changing it into a visible post?
if($draft_check)
|
// Are we updating a post which is already a draft? Perhaps changing it into a visible post?
if($draft_check)
|
{
| {
|
$this->thread_insert_data = array(
|
$this->thread_insert_data = array(
|
"subject" => $db->escape_string($thread['subject']),
"icon" => intval($thread['icon']),
"username" => $db->escape_string($thread['username']),
"dateline" => intval($thread['dateline']),
| "subject" => $db->escape_string($thread['subject']),
"icon" => intval($thread['icon']),
"username" => $db->escape_string($thread['username']),
"dateline" => intval($thread['dateline']),
|
"lastpost" => intval($thread['dateline']),
"lastposter" => $db->escape_string($thread['username']),
"visible" => $visible
);
|
"lastpost" => intval($thread['dateline']),
"lastposter" => $db->escape_string($thread['username']),
"visible" => $visible
);
|
$plugins->run_hooks_by_ref("datahandler_post_insert_thread", $this);
| $plugins->run_hooks_by_ref("datahandler_post_insert_thread", $this);
|
$db->update_query(TABLE_PREFIX."threads", $this->thread_insert_data, "tid='{$thread['tid']}'");
|
$db->update_query(TABLE_PREFIX."threads", $this->thread_insert_data, "tid='{$thread['tid']}'");
|
$this->post_insert_data = array(
"subject" => $db->escape_string($thread['subject']),
"icon" => intval($thread['icon']),
"username" => $db->escape_string($thread['username']),
"dateline" => intval($thread['dateline']),
|
$this->post_insert_data = array(
"subject" => $db->escape_string($thread['subject']),
"icon" => intval($thread['icon']),
"username" => $db->escape_string($thread['username']),
"dateline" => intval($thread['dateline']),
|
"message" => $db->escape_string($thread['message']),
"ipaddress" => $db->escape_string(get_ip()),
"includesig" => $thread['options']['signature'],
| "message" => $db->escape_string($thread['message']),
"ipaddress" => $db->escape_string(get_ip()),
"includesig" => $thread['options']['signature'],
|
| Zeile 954 | Zeile 972 |
|---|
$db->insert_query(TABLE_PREFIX."threads", $this->thread_insert_data);
$this->tid = $db->insert_id();
|
$db->insert_query(TABLE_PREFIX."threads", $this->thread_insert_data);
$this->tid = $db->insert_id();
|
|
|
$this->post_insert_data = array(
"tid" => $this->tid,
"fid" => $thread['fid'],
| $this->post_insert_data = array(
"tid" => $this->tid,
"fid" => $thread['fid'],
|
| Zeile 976 | Zeile 994 |
|---|
$this->pid = $db->insert_id();
// Now that we have the post id for this first post, update the threads table.
|
$this->pid = $db->insert_id();
// Now that we have the post id for this first post, update the threads table.
|
$firstpostup = array("firstpost" => $pid);
$db->update_query(TABLE_PREFIX."threads", $firstpostup, "tid='{$tid}'");
| $firstpostup = array("firstpost" => $this->pid);
$db->update_query(TABLE_PREFIX."threads", $firstpostup, "tid='{$this->tid}'");
|
}
// If we're not saving a draft there are some things we need to check now
if(!$thread['savedraft'])
{
|
}
// If we're not saving a draft there are some things we need to check now
if(!$thread['savedraft'])
{
|
// Automatic subscription to the thread
| // Automatically subscribe the user to this thread if they've chosen to.
|
if($thread['options']['emailnotify'] != "no" && $thread['uid'] > 0)
{
|
if($thread['options']['emailnotify'] != "no" && $thread['uid'] > 0)
{
|
$favoriteadd = array(
"uid" => intval($thread['uid']),
"tid" => intval($this->tid),
"type" => "s"
| $insert_favorite = array(
'uid' => intval($thread['uid']),
'tid' => $this->tid,
'type' => 's'
|
);
|
);
|
$db->insert_query(TABLE_PREFIX."favorites", $favoriteadd);
| $db->insert_query(TABLE_PREFIX.'favorites', $insert_favorite);
|
}
|
}
|
|
|
// Perform any selected moderation tools.
if(is_moderator($thread['fid'], "", $thread['uid']) == "yes" && is_array($thread['modoptions']))
{
$modoptions = $thread['modoptions'];
$modlogdata['fid'] = $this->tid;
$modlogdata['tid'] = $thread['tid'];
|
// Perform any selected moderation tools.
if(is_moderator($thread['fid'], "", $thread['uid']) == "yes" && is_array($thread['modoptions']))
{
$modoptions = $thread['modoptions'];
$modlogdata['fid'] = $this->tid;
$modlogdata['tid'] = $thread['tid'];
|
|
|
// Close the thread.
if($modoptions['closethread'] == "yes")
{
| // Close the thread.
if($modoptions['closethread'] == "yes")
{
|
| Zeile 1011 | Zeile 1029 |
|---|
// Stick the thread.
if($modoptions['stickthread'] == "yes")
|
// Stick the thread.
if($modoptions['stickthread'] == "yes")
|
{
| {
|
$newstick = "sticky='1'";
log_moderator_action($modlogdata, "Thread stuck");
|
$newstick = "sticky='1'";
log_moderator_action($modlogdata, "Thread stuck");
|
}
| }
|
// Execute moderation options.
if($newstick && $newclosed)
{
| // Execute moderation options.
if($newstick && $newclosed)
{
|
| Zeile 1030 | Zeile 1048 |
|---|
");
}
}
|
");
}
}
|
// If we have a registered user then update their post count and last post times.
if($thread['uid'] > 0)
{
$user = get_user($thread['uid']);
$update_query = array();
// Only update the lastpost column of the user if the date of the thread is newer than their last post.
if($thread['dateline'] > $user['lastpost'])
{
$update_query[] = "lastpost='".$thread['dateline']."'";
}
// Update the post count if this forum allows post counts to be tracked
if($forum['usepostcounts'] != "no")
{
$update_query[] = "postnum=postnum+1";
}
// Only update the table if we need to.
if(is_array($update_query))
{
$update_query = implode(", ", $update_query);
$db->query("UPDATE ".TABLE_PREFIX."users SET $update_query WHERE uid='".$thread['uid']."'");
}
}
// Queue up any forum subscription notices to users who are subscribed to this forum.
$excerpt = my_substr($thread['message'], 0, $mybb->settings['subscribeexcerpt']).$lang->emailbit_viewthread;
$query = $db->query("
SELECT u.username, u.email, u.uid, u.language
FROM ".TABLE_PREFIX."forumsubscriptions fs, ".TABLE_PREFIX."users u
WHERE fs.fid='".intval($thread['fid'])."'
AND u.uid=fs.uid
AND fs.uid!='".intval($thread['uid'])."'
AND u.lastactive>'{$forum['lastpost']}'
");
while($subscribedmember = $db->fetch_array($query))
|
if($visible == 1)
|
{
|
{
|
if($done_users[$subscribedmember['uid']])
{
continue;
}
$done_users[$subscribedmember['uid']] = 1;
// Determine the language pack we'll be using to send this email in and load it if it isn't already.
if($subscribedmember['language'] != '' && $lang->language_exists($subscribedmember['language']))
{
$uselang = $subscribedmember['language'];
}
else if($mybb->settings['bblanguage'])
{
$uselang = $mybb->settings['bblanguage'];
}
else
{
$uselang = "english";
| // If we have a registered user then update their post count and last post times.
if($thread['uid'] > 0)
{
$user = get_user($thread['uid']);
$update_query = array();
// Only update the lastpost column of the user if the date of the thread is newer than their last post.
if($thread['dateline'] > $user['lastpost'])
{
$update_query[] = "lastpost='".$thread['dateline']."'";
}
// Update the post count if this forum allows post counts to be tracked
if($forum['usepostcounts'] != "no")
{
$update_query[] = "postnum=postnum+1";
}
// Only update the table if we need to.
if(!empty($update_query))
{
$update_query = implode(", ", $update_query);
$db->query("UPDATE ".TABLE_PREFIX."users SET $update_query WHERE uid='".$thread['uid']."'");
}
|
}
|
}
|
if($uselang == $mybb->settings['bblanguage'])
{
$emailsubject = $lang->emailsubject_forumsubscription;
$emailmessage = $lang->email_forumsubscription;
}
else
| // Queue up any forum subscription notices to users who are subscribed to this forum.
$excerpt = my_substr($thread['message'], 0, $mybb->settings['subscribeexcerpt']).$lang->emailbit_viewthread;
// Parse badwords
require_once MYBB_ROOT."inc/class_parser.php";
$parser = new postParser;
$excerpt = $parser->parse_badwords($excerpt);
$query = $db->query("
SELECT u.username, u.email, u.uid, u.language
FROM ".TABLE_PREFIX."forumsubscriptions fs, ".TABLE_PREFIX."users u
WHERE fs.fid='".intval($thread['fid'])."'
AND u.uid=fs.uid
AND fs.uid!='".intval($thread['uid'])."'
AND u.lastactive>'{$forum['lastpost']}'
");
while($subscribedmember = $db->fetch_array($query))
|
{
|
{
|
if(!isset($langcache[$uselang]['emailsubject_forumsubscription']))
| if($done_users[$subscribedmember['uid']])
|
{
|
{
|
$userlang = new MyLanguage;
$userlang->set_path(MYBB_ROOT."inc/languages");
$userlang->set_language($uselang);
$userlang->load("messages");
$langcache[$uselang]['emailsubject_forumsubscription'] = $userlang->emailsubject_forumsubscription;
$langcache[$uselang]['email_forumsubscription'] = $userlang->email_forumsubscription;
unset($userlang);
| continue;
|
}
|
}
|
$emailsubject = $langcache[$uselang]['emailsubject_forumsubscription'];
$emailmessage = $langcache[$uselang]['email_forumsubscription'];
}
$emailsubject = sprintf($emailsubject, $forum['name']);
$emailmessage = sprintf($emailmessage, $subscribedmember['username'], $thread['username'], $forum['name'], $mybb->settings['bbname'], $thread['subject'], $excerpt, $mybb->settings['bburl'], $this->tid, $thread['fid']);
$new_email = array(
"mailto" => $db->escape_string($subscribedmember['email']),
"mailfrom" => '',
"subject" => $db->escape_string($emailsubject),
"message" => $db->escape_string($emailmessage)
);
$db->insert_query(TABLE_PREFIX."mailqueue", $new_email);
unset($userlang);
$queued_email = 1;
}
// Have one or more emails been queued? Update the queue count
if($queued_email == 1)
{
$cache->updatemailqueue();
}
// Automatically subscribe the user to this thread if they've chosen to.
if($thread['options']['emailnotify'] != "no" && $thread['uid'] > 0)
{
$insert_favorite = array(
'uid' => intval($thread['uid']),
'tid' => $this->tid,
'type' => 's'
);
$db->insert_query(TABLE_PREFIX.'favorites', $insert_favorite);
| $done_users[$subscribedmember['uid']] = 1;
// Determine the language pack we'll be using to send this email in and load it if it isn't already.
if($subscribedmember['language'] != '' && $lang->language_exists($subscribedmember['language']))
{
$uselang = $subscribedmember['language'];
}
else if($mybb->settings['bblanguage'])
{
$uselang = $mybb->settings['bblanguage'];
}
else
{
$uselang = "english";
}
if($uselang == $mybb->settings['bblanguage'])
{
$emailsubject = $lang->emailsubject_forumsubscription;
$emailmessage = $lang->email_forumsubscription;
}
else
{
if(!isset($langcache[$uselang]['emailsubject_forumsubscription']))
{
$userlang = new MyLanguage;
$userlang->set_path(MYBB_ROOT."inc/languages");
$userlang->set_language($uselang);
$userlang->load("messages");
$langcache[$uselang]['emailsubject_forumsubscription'] = $userlang->emailsubject_forumsubscription;
$langcache[$uselang]['email_forumsubscription'] = $userlang->email_forumsubscription;
unset($userlang);
}
$emailsubject = $langcache[$uselang]['emailsubject_forumsubscription'];
$emailmessage = $langcache[$uselang]['email_forumsubscription'];
}
$emailsubject = sprintf($emailsubject, $forum['name']);
$emailmessage = sprintf($emailmessage, $subscribedmember['username'], $thread['username'], $forum['name'], $mybb->settings['bbname'], $thread['subject'], $excerpt, $mybb->settings['bburl'], $this->tid, $thread['fid']);
$new_email = array(
"mailto" => $db->escape_string($subscribedmember['email']),
"mailfrom" => '',
"subject" => $db->escape_string($emailsubject),
"message" => $db->escape_string($emailmessage),
"headers" => ''
);
$db->insert_query(TABLE_PREFIX."mailqueue", $new_email);
unset($userlang);
$queued_email = 1;
}
// Have one or more emails been queued? Update the queue count
if($queued_email == 1)
{
$cache->updatemailqueue();
}
|
}
}
| }
}
|
| Zeile 1144 | Zeile 1163 |
|---|
$db->update_query(TABLE_PREFIX."attachments", $attachmentassign, "posthash='{$thread['posthash']}'");
}
|
$db->update_query(TABLE_PREFIX."attachments", $attachmentassign, "posthash='{$thread['posthash']}'");
}
|
// Thread is public - update the forum counts.
if($visible == 1 || $visible == 0)
{
$cache->updatestats();
update_thread_count($this->tid);
update_forum_count($thread['fid']);
| if($visible == 1)
{
$query = $db->simple_select(TABLE_PREFIX."attachments", "COUNT(aid) AS attachmentcount", "pid='{$this->pid}' AND visible='1'");
$attachmentcount = $db->fetch_field($query, "attachmentcount");
if($attachmentcount > 0)
{
update_thread_counters($this->tid, array("attachmentcount" => "+{$attachmentcount}"));
}
update_thread_data($this->tid);
update_forum_counters($thread['fid'], array("threads" => "+1", "posts" => "+1"));
}
else if($visible == 0)
{
update_thread_data($this->tid);
update_thread_counters($thread['tid'], array("replies" => 0, "unapprovedposts" => 1));
update_forum_counters($thread['fid'], array("unapprovedthreads" => "+1", "unapprovedposts" => "+1"));
|
}
// Return the post's pid and whether or not it is visible.
| }
// Return the post's pid and whether or not it is visible.
|
| Zeile 1157 | Zeile 1187 |
|---|
"pid" => $this->pid,
"tid" => $this->tid,
"visible" => $visible
|
"pid" => $this->pid,
"tid" => $this->tid,
"visible" => $visible
|
);
| );
|
}
/**
| }
/**
|
| Zeile 1226 | Zeile 1256 |
|---|
$plugins->run_hooks_by_ref("datahandler_post_update_thread", $this);
$db->update_query(TABLE_PREFIX."threads", $this->thread_update_data, "tid='".intval($post['tid'])."'");
|
$plugins->run_hooks_by_ref("datahandler_post_update_thread", $this);
$db->update_query(TABLE_PREFIX."threads", $this->thread_update_data, "tid='".intval($post['tid'])."'");
|
}
}
// Prepare array for post updating.
| }
}
// Prepare array for post updating.
|
$this->pid = $post['pid'];
if(isset($post['subject']))
| $this->pid = $post['pid'];
if(isset($post['subject']))
|
| Zeile 1266 | Zeile 1296 |
|---|
$this->post_update_data['edituid'] = intval($post['edit_uid']);
$this->post_update_data['edittime'] = time();
}
|
$this->post_update_data['edituid'] = intval($post['edit_uid']);
$this->post_update_data['edittime'] = time();
}
|
|
|
$plugins->run_hooks_by_ref("datahandler_post_update", $this);
$db->update_query(TABLE_PREFIX."posts", $this->post_update_data, "pid='".intval($post['pid'])."'");
| $plugins->run_hooks_by_ref("datahandler_post_update", $this);
$db->update_query(TABLE_PREFIX."posts", $this->post_update_data, "pid='".intval($post['pid'])."'");
|
| Zeile 1290 | Zeile 1320 |
|---|
{
$db->delete_query(TABLE_PREFIX."favorites", "type='s' AND uid='{$post['uid']}' AND tid='{$post['tid']}'");
}
|
{
$db->delete_query(TABLE_PREFIX."favorites", "type='s' AND uid='{$post['uid']}' AND tid='{$post['tid']}'");
}
|
update_thread_attachment_count($post['tid']);
| |
|
|
update_forum_count($post['fid']);
| update_forum_lastpost($post['fid']);
|
}
}
?>
| }
}
?>
|