Hi,
i think its no a thread problem. It only happens in replys.
I think it must be in this code section (I modified it..):
}elseif ($action == "qu") {
$thread = mysql_query ("SELECT thrtopic,thrid,thrtext,thrstarter FROM ".BOARD_TCONT_TABLE." WHERE thrid='$threadid' AND thrforid='$bid'");
while ($row = mysql_fetch_array($thread)) {
$thrid = $row['thrid'];
$thrtopic = $row['thrtopic'];
$thrtext = format_boardtext($row['thrtext'], $boardconfig['html_board'], $boardconfig['wordwrap_board'], $boardconfig['bb_board'], $boardconfig['bb_image_board'],1);
$thrstarter = $row['thrstarter'];
$subject_form = "RE :".$thrtopic."";
$reply = "";
$hans = mysql_query ("SELECT repuser,reptext FROM egly_boardtrep WHERE repthrid='$thrid'");
while ($row = mysql_fetch_array($hans)) {
$replier = $row['repuser'];
$replytext = format_boardtext($row['reptext'], $boardconfig['html_board'], $boardconfig['wordwrap_board'], $boardconfig['bb_board'], $boardconfig['bb_image_board'],1);
$replyspicker .="<table width=\"700\" border=\"0\" align=\"center\" cellpadding=\"4\" cellspacing=\"0\" class=\"threadspicker\">\n";
$replyspicker .="<tr>\n";
$replyspicker .="<td width=\"150\" valign=\"top\"><b>$replier</b> schrieb: </td>\n";
$replyspicker .="<td>\n";
$replyspicker .="<p>$replytext</p></td>\n";
$replyspicker .="</tr>\n";
$replyspicker .="</table>\n";
$replyspicker .="<br>\n";
};
}
}
$forums = mysql_query ("SELECT board_id,board_catid,board_name,board_moderator_id,auth_reply FROM ".BOARD_TABLE." WHERE board_id ='$bid' ");
while ($row = mysql_fetch_array($forums)) {
$board_id = $row['board_id'];
$board_catid = $row['board_catid'];
$board_name = $row['board_name'];
$board_moderator_id = $row['board_moderator_id'];
$auth_reply = $row['auth_reply'];
}
if ( (empty($threadid) || $threadid < 0 || $bid < 0 )) {
$error_board = $lang['board_badrequest'];
}
if ($error_board) {
$main_template = "board";
include(ROOT_PATH.'includes/page_header.php');
show_error_board($error_board);
}
$subject_form .= $headline ;
$categories = mysql_query ("SELECT catid,catname FROM ".BOARD_CAT_TABLE." WHERE catid ='$board_catid'");
while ($row = mysql_fetch_array($categories)) {
$catid = $row['catid'];
$catname = $row['catname'];
}
$txt_clickstream = "<a href=\"board.php\">".$boardconfig['board_name']."</a>".$config['category_separator']."<a href=\"showboard.php?bid=$board_id\">$board_name</a>".$config['category_separator']."<a href=\"showthread.php?bid=$board_id&threadid=$threadid\"> $subject_form</a>".$config['category_separator']."".$lang['new_reply']."";
if ( $user_info['user_level'] < $auth_reply ){
$iconmsg="<img src=\"".TEMPLATE_PATH."/board_images/danger.gif\" border=\"0\"> ";
$msg = $lang['board_register'];
$txt_clickstream = "".$lang['board_badrequest']."";
$content ="";
$redirectpage="<meta http-equiv=refresh content=\"11; url=board.php \">"; }
else {
if ($user_info['user_level'] == GUEST || $user_info['user_level'] == USER_AWAITING) {
$sender_name = "<input name=\"username_form\" maxlength=\"15\" type=\"text\" class=\"inputarea\" id=\"username_form\" size=\"50\">";
$sender_id = GUEST ;
}else {
$sender_name = ($user_info['user_level'] != GUEST) ? $user_info['user_name'] : "";
$sender_id = ($user_info['user_id'] != GUEST) ? $user_info['user_id'] : "";
$sender_email = ($user_info['user_level'] != GUEST) ? $user_info['user_email'] : "";
$sender_name_hidden = "<input type=\"hidden\" name=\"username_form\" value=\"$sender_name\">";
}
if ($boardconfig['bb_board'] == 1 ) {
$site_template->register_vars(array(
"smiles" => $smiles,
"lang_bbcode" => $lang['bbcode'],
"lang_tag_prompt" => $lang['tag_prompt'],
"lang_link_text_prompt" => $lang['link_text_prompt'],
"lang_link_url_prompt" => $lang['link_url_prompt'],
"lang_link_email_prompt" => $lang['link_email_prompt'],
"lang_list_type_prompt" => $lang['list_type_prompt'],
"lang_list_item_prompt" => $lang['list_item_prompt']
));
$bbcode = $site_template->parse_template("bbcodeboard");
}
$site_template->register_vars(array(
"sender_name_hidden" =>$sender_name_hidden,
"lang_name" => $lang['name'],
"lang_subject" => $lang['subject'],
"lang_massage" => $lang['massage'],
"lang_post_reply" => $lang['post_reply'],
"threadid" =>$threadid,
"board_id" => $board_id,
"showtopic" => $showtopic,
"replyquote" =>$editpost,
"subject" =>$subject_form,
"reply" =>$reply,
"sender_id" => $sender_id,
"bbcode" => $bbcode,
"sender_name" => $sender_name,
"thrtext" => $thrtext,
"thrstarter" => $thrstarter,
"replyspicker" => $replyspicker,
"replier" => $replier,
"replytext" => $replytext
));
$content = $site_template->parse_template("boardform_reply");
$error = 0;
if ($action == "post_reply") {
$reply= (isset($HTTP_POST_VARS['message_form'])) ? un_htmlspecialchars(trim($HTTP_POST_VARS['message_form'])) : "";
$user_name_field = get_user_table_field("", "user_name");
if (!empty($user_name_field)) {
if ($site_db->not_empty("SELECT $user_name_field FROM ".USERS_TABLE." WHERE $user_name_field = '".strtolower($username_form)."' AND ".get_user_table_field("", "user_id")." <> '".$user_info['user_id']."'")) {
$msg .= (($msg != "") ? "<br />" : "").$lang['username_exists'];
$error = 1;
}
}
if ($username_form == "") {
$msg .= (($msg != "") ? "<br />" : "").$lang['name_required'];
$error = 1;
}
if ($subject_form == "") {
$msg .= (($msg != "") ? "<br />" : "").$lang['subject_required'];
$error = 1;
}
if ($message_form == "") {
$msg .= (($msg != "") ? "<br />" : "").$lang['massage_required'];
$error = 1;
}
if ($error) {
$iconmsg="<img src=\"".TEMPLATE_PATH."/board_images/danger.gif\" border=\"0\"> ";
$txt_clickstream = "<a href=\"board.php\">".$boardconfig['board_name']."</a>".$config['category_separator']."".$lang['error_proses']."";
}
if (!$error) {
$dbdate = time();
mysql_query ("UPDATE ".BOARD_TABLE." SET board_posts=board_posts+1, board_lastpost_id='$threadid', board_lastpost_user='$username_form', board_lastpost_date='$dbdate' WHERE board_id = '$bid'");
mysql_query ("UPDATE ".BOARD_TINDEX_TABLE." SET thrreplies=thrreplies+1, thrlastpost_id='$userid', thrlastpost_user='$username_form', thrlastpost_date='$dbdate' WHERE thrid = '$threadid'");
mysql_query ("INSERT INTO ".BOARD_TREP_TABLE." (repthrid,repforid,reptopic,repuser,repuser_id,reptext,repdate,repposterip) VALUES ('$threadid','$bid','$subject_form','$username_form','$sender_id','$message_form','$dbdate','$REMOTE_ADDR')");
mysql_query ("UPDATE ".USERS_TABLE." SET user_posts=user_posts+1 WHERE user_name = '$username_form'");
mysql_query ("UPDATE ".BOARD_STAT_TABLE." SET totalposts=totalposts+1");
$reply_page = $boardconfig['posts_perpage'];
$thread_rep = mysql_query ("SELECT * FROM ".BOARD_TREP_TABLE." WHERE repthrid ='$threadid'");
$total_reply = mysql_numrows ($thread_rep);
$getlastpage = ceil($total_reply / $reply_page);
mysql_query ("UPDATE ".BOARD_TABLE." SET board_lastpost_page='$getlastpage' WHERE board_id = '$bid'");
mysql_query ("UPDATE ".BOARD_TINDEX_TABLE." SET thrlastpost_page='$getlastpage' WHERE thrid = '$threadid'");
$sql = "SELECT board_name, board_moderator, board_moderator_email, board_mod_emailpost FROM ".BOARD_TABLE." WHERE board_id = '$bid'";
$result = $site_db->query($sql);
$num_rows = $site_db->get_numrows($result);
$row = array();
while ($row = $site_db->fetch_array($result)) {
$board_id = $row['board_id'];
$board_name = $row['board_name'];
$board_moderator = $row['board_moderator'];
$board_moderator_email = $row['board_moderator_email'];
$board_mod_emailpost = $row['board_mod_emailpost'];
}
$site_db->free_result($result);
//////////////////////////////////////////
////////////Eglys Email@reply/////////////
//////////////////////////////////////////
$sql = "SELECT user_email FROM ".BOARD_TREP_TABLE.", ".USERS_TABLE." WHERE "
.USERS_TABLE.".user_id = ".BOARD_TREP_TABLE.".repuser_id AND
repthrid = '$threadid' group by user_email";
$result = $site_db->query($sql);
$row = array();
while ($row = $site_db->fetch_array($result)) {
$repuser = $row['repuser_id'];
$repmailto = $row['user_email'];
$from = "Antwort@Fotostube.net"; //insert your email adress here
$post_url=$script_url."/showthread.php?bid=$bid&threadid=$threadid&page=$getlastpage";
include_once(ROOT_PATH.'includes/email.php');
$site_email = new Email();
$site_email->set_from($from);
$site_email->set_to($repmailto);
$site_email->set_subject($subject_form);
$site_email->register_vars(array(
"recipient_name" => $board_moderator,
"forum_name" => $board_name,
"sender_name" => $username_form,
"topics_url" => $post_url,
"topics_content" => $message_form,
"about" => $lang['new_reply'],
"board_name" => $boardconfig['board_name']
));
$site_email->set_body("board_mailtopics", $config['language_dir']);
$site_email->send_email();
}
$sql= "SELECT user_email FROM ".BOARD_TCONT_TABLE.", ".USERS_TABLE." WHERE "
.USERS_TABLE.".user_id = ".BOARD_TCONT_TABLE.".thrstarter_id AND
thrid = '$threadid' ";
$result = $site_db->query($sql);
$row = array();
while ($row = $site_db->fetch_array($result)) {
$repuser = $row['repuser_id'];
$repmailto = $row['user_email'];
$thrstarter2 =$row['thrstarter_id'];
if ($thrstarter2 <> $repuser) {
$from = "Antwort@Fotostube.net"; // insert your email adress here
$post_url=$script_url."/showthread.php?bid=$bid&threadid=$threadid&page=$getlastpage";
include_once(ROOT_PATH.'includes/email.php');
$site_email = new Email();
$site_email->set_from($from);
$site_email->set_to($repmailto);
$site_email->set_subject($subject_form);
$site_email->register_vars(array(
"recipient_name" => $board_moderator,
"forum_name" => $board_name,
"sender_name" => $username_form,
"topics_url" => $post_url,
"topics_content" => $message_form,
"about" => $lang['new_reply'],
"board_name" => $boardconfig['board_name']
));
$site_email->set_body("board_mailtopics", $config['language_dir']);
$site_email->send_email();
}else {}}
//////////////////////////////////////////
//////////End Eglys Email@reply///////////
//////////////////////////////////////////
if ($board_mod_emailpost == 1) {
// send email to moderator of this forum
$post_url=$script_url."/showthread.php?bid=$bid&threadid=$threadid&page=$getlastpage";
$site_email = new Email();
$site_email->set_from($sender_email, $username_form);
$site_email->set_to($board_moderator_email);
$site_email->set_subject($subject_form);
$site_email->register_vars(array(
"recipient_name" => $board_moderator,
"forum_name" => $board_name,
"sender_name" => $username_form,
"topics_url" => $post_url,
"topics_content" => $message_form,
"about" => $lang['new_reply'],
"board_name" => $boardconfig['board_name']
));
$site_email->set_body("board_mailtopics", $config['language_dir']);
$site_email->send_email();
} else { // email not send
}
$txt_clickstream = "<a href=\"board.php\">".$boardconfig['board_name']."</a>".$config['category_separator']."".$lang['redirect_msg']."";
$redirectpage = "<meta http-equiv=refresh content=\"3; url=showthread.php?bid=$bid&threadid=$threadid&page=$getlastpage#last \">";
$content ="";
$msg= "<br><center>".$lang['redirect_msg']." <br> <a href=\"showthread.php?bid=$bid&threadid=$threadid&page=$getlastpage#last\">".$lang['redirect_msglink']." </a></center><br>";
}
}
}
}; // end if
$site_template->register_vars(array(
"content" => $content,
"reply" => htmlspecialchars(stripslashes($reply)),
"threadid" =>$threadid,
"board_id" => $board_id,
"msg" => $msg,
"iconmsg" => $iconmsg,
"lang_info" => $lang['board_langinfo'],
"clickstream" => $clickstream
));
$boardcontent = $site_template->parse_template("boardcontent");
It only happens sometimes...
