function GetPosts($tID, $sql2 = '', $single_post = false)
{
global $LimitJump_top, $LimitJump_bot, $total_thread_count, $thread_title_for_search;
global $wgOut, $wgRequest, $wgCookieExpiration, $wgCookiePath, $wgCookieDomain;
global $WhoWhere, $awc_tables, $tplt;
global $awcUser;
if (!$awcUser->canRead) {
return $wgOut->loginToUse();
}
$perm = new awcs_forum_perm_checks();
$post_cls = new awcs_forum_post_phase();
if ($single_post) {
$post_cls->single_post = true;
}
$word = null;
$i = null;
$html = null;
$e = array();
$tPass = array();
if ($sql2 == '') {
$check_subscribe = self::check_subscribe($tID);
if ($check_subscribe != 'no') {
$e = $check_subscribe['e'];
$tPass = $check_subscribe['tPass'];
$subscribe_info = $check_subscribe['subscribe_info'];
} else {
$tPass['subscrib_links'] = null;
}
} else {
$tPass['subscrib_links'] = null;
$tplt->kill('subscrib_links');
}
$dbr = wfGetDB(DB_SLAVE);
$this->display_mem_titles = 1;
if ($this->display_mem_titles) {
$sql = "SELECT * FROM {$awc_tables['awc_f_member_titles']} ORDER BY memtitle_postcount ASC";
$res = $dbr->query($sql);
while ($r = $dbr->fetchObject($res)) {
$post_cls->mem_post_title[$r->memtitle_id] = array('count' => $r->memtitle_postcount, 'title' => $r->memtitle_title, 'img' => $r->memtitle_img, 'css' => $r->memtitle_css);
}
unset($res, $r);
} else {
$post_cls->mem_post_title[0] = 'do_not_show';
}
// get number of threads so we can make the Page Blocks
# do something different, maybe move to sessions ro somehting
$sql = $dbr->selectSQLText(array('awc_f_threads'), array('t_topics, t_postid'), "t_id={$tID}", __METHOD__, array('OFFSET' => '0', 'LIMIT' => '1'));
$limit = '';
$tPass['page_jumps'] = null;
if ($sql2 == '') {
#$sql = "SELECT p_id FROM {$awc_tables['awc_f_posts']} WHERE p_id = $tID ";
$res = $dbr->query($sql);
$r = $dbr->fetchRow($res);
$ex['TotalPosts'] = $r['t_topics'];
$dbr->freeResult($res);
$total['TotalPosts'] = $ex['TotalPosts'];
$total['last'] = $r['t_postid'];
$limit = GetLimit($total, 'thread');
$tPass['page_jumps'] = $LimitJump_top;
#die($LimitJump_bot);
} else {
# $ex['sql2'] = $sql2;
}
# DIE($limit);
$limit_is_there = false;
# sw: highlightsearchword
$action = $wgRequest->action;
$spl = explode("/", $action);
$search_word = null;
# loop through "action" to find seach word
foreach ($spl as $k => $value) {
if (stristr($value, 'limit')) {
$post_cls->has_limit = true;
}
if (substr($value, 0, 3) == "sw:") {
$sw1 = explode("sw:", $value);
$search_word = $sw1[1];
break;
}
}
$search_word = str_replace("_", " ", $search_word);
$spl2 = explode(" ", $search_word);
# loop through seach word's
foreach ($spl2 as $k => $value) {
$sw[] = $value;
}
$perm_where = $perm->cat_forum_sql();
$limit = awcsforum_funcs::limitSplit($limit);
# awc_pdie($limit);
$sql = $dbr->selectSQLText(array('awc_f_threads', 'awc_f_posts', 'awc_f_forums', 'awc_f_cats'), array('p_id, p_title, p_post, p_user, p_userid, p_editwhy, p_editwho, p_editdate, p_date,
t_id, t_ann, t_pin, t_status, t_name, t_topics, t_hits, t_perm, t_poll, t_wiki_pageid, t_lastdate, t_pollopen,
f_posting_mesage_tmpt, f_name, f_id, f_wiki_write_perm, f_wiki_read_perm, f_passworded, cat_name, cat_id'), "{$perm_where} t_id = {$tID}", __METHOD__, array('OFFSET' => $limit['offset'], 'LIMIT' => $limit['limit'], 'ORDER BY' => 'p_thread_start DESC, p_date ASC'), array('awc_f_posts' => array('JOIN', 't_id=p_threadid'), 'awc_f_forums' => array('JOIN', 't_forumid=f_id'), 'awc_f_cats' => array('JOIN', 'f_parentid=cat_id')));
# die($sql);
if (strlen($sql2) > 0) {
$sql = $sql2;
}
$res = $dbr->query($sql);
$i = 0;
$out = array();
# $e['html'] = null;
while ($r = $dbr->fetchObject($res)) {
++$i;
if ($i == 1) {
# awc_pdie($r);
// stuff this stuff here so its not looped...
$WhoWhere['where'] = 'cid' . $r->cat_id . '|fid' . $r->f_id . '|tid' . $r->t_id . '||awc-split||' . $r->t_name;
$WhoWhere['perm'] = isset($r->f_wiki_read_perm) ? $r->f_wiki_read_perm : '';
$thread_title = $r->t_name;
$t_status = $r->t_status;
$f_posting_mesage_tmpt = isset($r->f_posting_mesage_tmpt) ? $r->f_posting_mesage_tmpt : '';
$f_wiki_write_perm = isset($r->f_wiki_write_perm) ? $r->f_wiki_write_perm : '';
if (!$awcUser->guest and awcsforum_funcs::wikidate($r->t_lastdate) > $_SESSION['awc_startTime']) {
$_SESSION['awc_rActive'][$r->t_id] = awcsforum_funcs::wikidate($r->t_lastdate);
}
$e['PostTitle'] = $r->t_name;
$e['num_topics'] = $r->t_topics;
$f_name = $r->f_name;
$fID = $r->f_id;
$t_wiki_pageid = $r->t_wiki_pageid;
if (!isset($awcUser->pw)) {
$awcUser->pw[0] = 0;
}
#die(">" . $r->f_id);
if ($perm->is_password($r->f_passworded) and !in_array($r->f_id, $awcUser->pw)) {
global $wgOut;
$password_field = '<br /><hr />' . get_awcsforum_word('forum_passworded') . '<hr />';
$password_field .= '</form><form action="' . awc_url . 'fpw" method="post" enctype="multipart/form-data">
<input name="fid" type="hidden" value="' . $r->f_id . '">
<input name="pw" type="password" size="20">
<input type="submit" value="' . get_awcsforum_word('submit') . '">
</form><br /><br />';
$wgOut->addHTML($password_field);
return;
}
$this->forum_perm_can_post = false;
if ($awcUser->canPost and $perm->can_post($f_wiki_write_perm)) {
$this->forum_perm_can_post = true;
$post_cls->forum_perm_can_post = true;
}
// end stuffed...
if (!$single_post) {
Set_AWC_Forum_BreadCrumbs('<a href="' . awc_url . 'sc/id' . $r->cat_id . '">' . $r->cat_name . '</a>');
$BreadCrumb = Set_AWC_Forum_BreadCrumbs('<a href="' . awc_url . 'sf/id' . $r->f_id . '">' . $r->f_name . '</a>', true);
$t = null;
if ($r->t_ann == "1") {
$t = get_awcsforum_word('thread_makeAnnouncement') . " ";
$e['ann'] = true;
}
if ($r->t_status == "1") {
$t = get_awcsforum_word('1indicator_locked') . " ";
$e['lock'] = true;
}
if ($r->t_pin == "1") {
$t = get_awcsforum_word('1indicator_sticky') . " ";
$e['sticky'] = true;
}
if ($r->t_pin == "1" and $r->t_status == "1") {
$t = get_awcsforum_word('1indicator_lockSticky') . " ";
}
$e['tID'] = $r->t_id;
$e['fID'] = $r->f_id;
$e['cID'] = $r->cat_id;
$e['pID'] = $r->p_id;
Set_AWC_Forum_SubTitle($r->t_name, $t . get_awcsforum_word('word_viewed') . " " . $r->t_hits . " " . get_awcsforum_word('word_times') . ", " . get_awcsforum_word('word_Withatotalof') . " " . $r->t_topics . " " . get_awcsforum_word('word_posts'), $e);
$tPass['mod_buttons'] = null;
if (UserPerm >= 2) {
$e['ann'] = $r->t_ann == '1' ? 'checked' : null;
$e['sticky'] = $r->t_pin == '1' ? 'checked' : null;
$e['lock'] = $r->t_status == '1' ? 'checked' : null;
$e['threadname'] = awcsforum_funcs::awc_html_entity_decode($thread_title);
$word['pinned_word'] = get_awcsforum_word('pinned_word');
$word['lockThread_word'] = get_awcsforum_word('lockThread_word');
$word['mod_movethread'] = get_awcsforum_word('mod_movethread');
$word['thread_makeAnnouncement'] = get_awcsforum_word('thread_makeAnnouncement');
$word['mod_post'] = get_awcsforum_word('mod_post');
if ($r->t_ann != "1" || UserPerm == 10) {
#$to_skin['mod_buttons'] = ModFormStart($r->t_id, $r->p_id, $r->f_id, awc_url, $r->t_name, $total_topics) ;
}
#if (UserPerm == 10) $to_skin['mod_buttons'] .= IsAnnonc($r->t_ann);
if (UserPerm == 10) {
$e['ann'] = $tplt->phase($word, $e, 'mod_thread_dropdown_ann', true);
} else {
$e['ann'] = '';
}
if ((UserPerm >= 2 and $r->t_ann != "1") || UserPerm == 10) {
$tPass['mod_buttons'] = $tplt->phase($word, $e, 'mod_thread_dropdown', true);
}
unset($word);
}
if ($this->userID != '0') {
$tPass['options_menu'] = null;
$word['word_thread_options_button'] = get_awcsforum_word('word_thread_options_button');
$tPass['thread_options'] = $tplt->phase($word, $tPass, 'options_dropdown', true);
} else {
$tplt->kill('options_dropdown');
$tPass['thread_options'] = null;
}
# $tPass['page_jumps'] // is set above...
$html = $tplt->phase($word, $tPass, 'thread_header', true);
unset($info, $word, $tPass);
#awc_pdie($tplt_info);
} else {
// single
Set_AWC_Forum_BreadCrumbs('<a href="' . awc_url . 'sc/id' . $r->cat_id . '">' . $r->cat_name . '</a>');
Set_AWC_Forum_BreadCrumbs('<a href="' . awc_url . 'sf/id' . $r->f_id . '">' . $r->f_name . '</a>');
Set_AWC_Forum_BreadCrumbs('<a href="' . awc_url . 'st/id' . $r->t_id . '">' . awcsforum_funcs::awc_html_entity_decode($r->t_name) . '</a>', TRUE);
$e = array();
$e['tID'] = $r->p_threadid;
$e['fID'] = $r->f_id;
$e['cID'] = $r->cat_id;
$tPass['page_jumps'] = "<b><a href='" . awc_url . "st/id" . $r->t_id . "'>" . get_awcsforum_word('click_here_for_full_thread') . "</a></b>";
$tPass['thread_options'] = null;
$html = $tplt->phase($word, $tPass, 'thread_header', true);
Set_AWC_Forum_SubTitle($r->t_name, get_awcsforum_word('single_post_sub_title'), $e);
}
if ($r->t_poll and !$single_post) {
$poll = $post_cls->display_poll($tID);
$html = $poll . $html;
}
}
// unset($_SESSION['awc_nActive'][$r->p_id]);
#if($r->p_wikipage_id != '0') $p_wikipage_id[] = $r->p_wikipage_id ;
$post_cls->load_post_phase_info($r);
// awc_pdie($post_cls);
$html .= $post_cls->display_post();
}
# end SQL loop...
unset($post_cls);
if ($i == 0) {
return;
}
$dbr->freeResult($res);
unset($dbr, $res, $r);
/*
if($this->cf_add_post_text_to_wiki){
$dbw = wfGetDB( DB_MASTER );
$wp_ids = implode(',',$p_wikipage_id);
$wiki_page = $dbw->tableName( 'page' );
$dbw->query( "UPDATE {$wiki_page} SET page_counter = page_counter + 1
WHERE page_id IN ($wp_ids)" );
}
*/
# unset($r, $this, $user_get, $ex, $sql);
if (!$single_post and strlen($sql2) == 0) {
$total_thread_count = $i;
$thread_title_for_search = $thread_title;
$yes = false;
# $awc_ViewForum = $_COOKIE['awc_forum_ThreadView'] ;
$awc_ViewForum = isset($_COOKIE['awc_forum_ThreadView']) ? $_COOKIE['awc_forum_ThreadView'] : null;
$spl = explode(",", $awc_ViewForum);
foreach ($spl as $fid) {
if ($tID == $fid) {
$yes = true;
}
}
if (!$yes) {
$dbw = wfGetDB(DB_MASTER);
$dbw->query("UPDATE {$awc_tables['awc_f_threads']} SET t_hits = t_hits + 1 WHERE t_id = {$tID}");
$expir = $this->cookie_expir;
if ($expir >= 1) {
$expir = $expir * 60 * 60;
}
$exp = time() + $expir;
# $exp = time() + $wgCookieExpiration;
setcookie('awc_forum_ThreadView', $awc_ViewForum . "," . $tID, $exp, $wgCookiePath, $wgCookieDomain);
#$_SESSION['awc_forum_ThreadView'] = $awc_ViewForum ;
unset($dbw);
}
# die($LimitJump_top);
# $html = $e['html'];
$info['page_jumps'] = $LimitJump_bot ? $LimitJump_bot : null;
$info['BreadCrumb'] = $BreadCrumb;
$html .= $tplt->phase('', $info, 'bottom_page_jumps', true);
}
$wgOut->addHTML($html);
//forum-wiki-perm
//if ($awcUser->canPost AND $t_status == "0" || UserPerm >= 2 && $i AND !$single_post){
if ((strlen($sql2) == 0 and $awcUser->canPost and $this->forum_perm_can_post and $t_status == "0" and !$single_post) || (UserPerm >= 2 && $i and !$single_post)) {
require awc_dir . '/includes/post_box.php';
$posting_box = new awcs_forum_posting_box();
$posting_box->quick_box = true;
$posting_box->f_posting_mesage_tmpt = strlen($f_posting_mesage_tmpt) > 1 ? add_tmpl_to_skin($f_posting_mesage_tmpt) : null;
#$posting_box->Thread_Title = awcsforum_funcs::awc_html_entity_decode($thread_title);
$posting_box->Thread_Title = awcsforum_funcs::awc_htmlentities($thread_title);
$posting_box->tbRows = $this->quick_height;
$posting_box->Show_ann_sticky_lock = false;
$posting_box->f_name = urlencode($f_name);
$posting_box->fID = $fID;
$posting_box->tID = $tID;
$posting_box->t_wiki_pageid = $t_wiki_pageid;
$posting_box->javaCheck = 'onsubmit="return check_quickPost()"';
$posting_box->url = awc_url . 'post/todo_' . urlencode('add_post');
//awc_pdie($subscribe_info);
if (!$awcUser->guest) {
$posting_box->subscribed_email = $subscribe_info['values']['subscribed_email'];
$posting_box->subscribed_list = $subscribe_info['values']['subscribed_list'];
$posting_box->subscribed_no = $subscribe_info['values']['subscribed_no'];
}
$html = $posting_box->box();
unset($posting_box);
$wgOut->addHTML($html);
}
return;
}
/**
* Save forum config
*
* @since Version 2.5.8
*/
function do_config_forum()
{
global $wgRequest, $wgOut, $awc, $table_1, $awcs_forum_config;
if (UserPerm != 10) {
die("Nope - Admin");
}
$dbr = wfGetDB(DB_SLAVE);
$dbw = wfGetDB(DB_MASTER);
#$yes_wikiedit = true;
# use this to see is WIki's User Table has the user_editcount feild
$table_1 = $dbr->tableName('user');
$dBaseCLS = new awcforum_cls_dBase();
$yes_wikiedit = $dBaseCLS->colCheck($table_1, 'user_editcount');
foreach ($awcs_forum_config as $q => $a) {
$a = $wgRequest->getVal($q);
if ($q != 'cf_forumversion' && $q != 'cf_forumlang') {
if ($wgRequest->getVal($q) != '') {
if ($q == 'cf_css_default') {
$css = explode('|', $a);
$a = serialize(array('Default' => $css[0]));
}
if ($q == 'cf__forumsubtitle' || $q == 'cf__forumname') {
$a = awcsforum_funcs::awc_htmlentities($a);
}
$dbw->update('awc_f_config', array('a' => $a), array('q' => $q), '');
}
}
}
// check what wiki ver this aplies to... might be older, if so elete.
# no user_editcount feild, so reste Forum Config for the "Show Wiki Edits"
if ($yes_wikiedit == false) {
$dbw->update('awc_f_config', array('a' => 'no'), array('q' => 'wikieits'), '');
}
$wgOut->redirect(awc_url . "admin");
}
function check_searchword()
{
global $kw, $awc, $wgOut;
$no_search = array();
require awc_dir . 'config/no_search.php';
foreach ($no_search as $clear_word) {
$this->searchword = str_replace($clear_word, "", $this->searchword);
}
if (strlen($this->searchword) < $this->ChrLimit) {
$er = '';
foreach ($no_search as $clear_word) {
$er .= $clear_word . "<br />";
}
$er .= '';
Set_AWC_Forum_SubTitle(get_awcsforum_word('search_word_to_short') . ' ' . $this->ChrLimit);
Set_AWC_Forum_BreadCrumbs($this->searchword, true);
$this->search_error = $wgOut->addHTML('<hr>' . get_awcsforum_word('search_word_to_short') . ' ' . $this->ChrLimit . '<hr>' . '<br />' . get_awcsforum_word('search_omitted_words') . '<hr>' . $er);
unset($no_search);
return false;
}
unset($no_search);
$this->searchword = str_replace('_', ' ', $this->searchword);
$kw = strip_tags($this->searchword);
$kw = awcsforum_funcs::awc_htmlentities($kw);
return true;
}
function find_and_replace_in($w, $str_f, $str_r)
{
global $awc_tables;
// used to print info for update page...
$out = "<b><u>Skin</u> Find/Replace:</b><br /> - Template={$w}<br /> - Find=" . awcsforum_funcs::awc_htmlentities($str_f) . "<br /> - Replace With=" . awcsforum_funcs::awc_htmlentities($str_r) . "<br /><br />";
// update TABLE_NAME set FIELD_NAME = replace(FIELD_NAME, �find this string�, �replace found string with this string�);
//$str_find = str_replace(array('"', '\''),array('\"', "\'"),$str_f);
$str_find = $str_f;
$str_replace = str_replace(array('"', '\''), array('\\"', "\\'"), $str_r);
$awc_f_theme_tplt = $this->wDB->tableName('awc_f_theme_tplt');
$sql = "SELECT *\n FROM {$awc_f_theme_tplt} \n WHERE tplt_function='{$w}'";
$res = $this->rDB->query($sql);
while ($r = $this->rDB->fetchObject($res)) {
$change = true;
/*
$check = explode(' ', str_replace($str_find, '', $str_replace));
foreach($check as $c){
$look_in = str_replace($str_find, '', $r->tplt_code);
if(strlen($c) > 2) if(strstr($look_in, $c)) $change = false;
}
*/
if (strstr($r->tplt_code, $str_r)) {
$change = false;
}
// awc_pdie($str_r);
if ($change == true) {
$this->wDB->insert('awc_f_theme_tplt_history', array('tplth_tplt_id' => $r->tplt_id, 'tplth_ver' => $r->tplt_ver, 'tplth_code' => $r->tplt_code, 'tplth_forum_ver' => $r->tplt_forum_ver, 'tplth_find' => $str_find, 'tplth_replace' => $str_replace, 'tplth_date' => $this->wDB->timestamp()));
$tplt_ver = explode('.', $r->tplt_ver);
$tplt_save = $tplt_ver[0] . '.' . ($tplt_ver[1] + 1) . '.' . $tplt_ver[2];
$tplt_id = $r->tplt_id;
$this->wDB->query("UPDATE {$awc_f_theme_tplt} \n SET tplt_code = REPLACE(tplt_code, \"{$str_find}\", \"{$str_replace}\"), tplt_ver = '{$tplt_save}' \n WHERE tplt_id={$tplt_id}");
}
}
return $out;
}
function add_new_values($css_Path)
{
global $wgRequest;
$dbw = wfGetDB(DB_MASTER);
$dbr = wfGetDB(DB_SLAVE);
$out = '';
$awc_f_theme_css = $dbr->tableName('awc_f_theme_css');
$sql = "SELECT css_thmn_id, css_thm_id FROM {$awc_f_theme_css} GROUP BY css_thmn_id";
$sql = "SELECT css_thmn_id, css_thm_id FROM {$awc_f_theme_css}";
$res = $dbr->query($sql);
while ($r = $dbr->fetchObject($res)) {
$thmn_id[] = $r->css_thmn_id;
$css_thm_id[$r->css_thmn_id] = $r->css_thm_id;
}
$dbr->freeResult($res);
$css = simplexml_load_file($css_Path);
foreach ($css as $info => $arr) {
$att_attributes = $arr->attributes();
$group_name = $att_attributes['css_section'];
$group_name = html_entity_decode($group_name, ENT_QUOTES, 'UTF-8');
#awc_pdie($att_attributes);
# foreach($arr as $info2 => $code){
#$att_attributes = $code->attributes();
$att = $att_attributes['css_att'];
$att = html_entity_decode($att, ENT_QUOTES, 'UTF-8');
$forum_ver = $att_attributes['css_forumver'];
$forum_ver = html_entity_decode($forum_ver, ENT_QUOTES, 'UTF-8');
$code = html_entity_decode($arr, ENT_QUOTES, 'UTF-8');
$add_array[$group_name][$att]['css_att'] = $att;
$add_array[$group_name][$att]['ver'] = $forum_ver;
$add_array[$group_name][$att]['code'] = $code;
// used to print info for update page...
$out .= "<b><u>CSS</u> New Attribute:</b><br /> - Section={$group_name}<br /> - Attribute=" . awcsforum_funcs::awc_htmlentities($att) . "<br /> - Code=" . awcsforum_funcs::awc_htmlentities($code) . "<br /><br />";
#}
}
foreach ($thmn_id as $id) {
$css_id[$id] = $add_array;
if (isset($css_id[$id]) and !empty($css_id[$id])) {
foreach ($css_id[$id] as $css_section => $ii) {
$sql = "SELECT css_att FROM {$awc_f_theme_css} WHERE css_section='{$css_section}' AND css_thmn_id={$id}";
$res = $dbr->query($sql);
while ($r = $dbr->fetchObject($res)) {
# ++$css_code_count;
if (array_key_exists($r->css_att, $css_id[$id][$css_section])) {
unset($css_id[$id][$css_section][$r->css_att]);
}
}
$dbr->freeResult($res);
unset($r, $ii);
}
}
}
$awc_f_theme_names = $dbw->tableName('awc_f_theme_names');
foreach ($css_id as $css_nameID => $arrs) {
$update_count = 0;
if (isset($arrs) and !empty($arrs)) {
foreach ($arrs as $section_name => $section_arr) {
foreach ($section_arr as $att) {
++$update_count;
$dbw->insert('awc_f_theme_css', array('css_section' => $section_name, 'css_att' => trim($att['css_att']), 'css_thmn_id' => $css_nameID, 'css_code' => trim($att['code']), 'css_thm_id' => $css_thm_id[$css_nameID], 'css_custom' => 0, 'css_ver' => $att['ver']));
}
unset($att);
}
unset($section_name, $section_arr);
}
$sql = "UPDATE {$awc_f_theme_names} ";
$sql .= "SET thmn_item_count = thmn_item_count + {$update_count} ";
$sql .= "WHERE thmn_id =" . $css_nameID;
$dbw->query($sql);
}
unset($thmn_id, $css_thm_id, $add_array, $res, $r, $arrs);
return $out;
}
function CleanThreadTitle($t)
{
$t = strip_tags($t);
$t = awcsforum_funcs::awc_htmlentities($t);
#$trans = get_html_translation_table(awcsforum_funcs::awc_htmlentities);
#$t = strtr($t, $trans);
$t = str_replace("[", "", $t);
$t = str_replace("]", "", $t);
$t = str_replace("{", "", $t);
$t = str_replace("}", "", $t);
$t = str_replace("'", "\\'", $t);
return $t;
}
function pm_read()
{
global $wgOut, $awcUser, $awc_tables, $tplt, $awcs_forum_config;
$pmID = str_replace('id', '', $this->id);
$post_cls = new awcs_forum_post_phase();
$post_box = new awcs_forum_posting_box();
if ($this->todo_url == 'member_options/') {
Set_AWC_Forum_SubTitle(get_awcsforum_word('mem_memCP'), $this->membername);
Set_AWC_Forum_BreadCrumbs(get_awcsforum_word('pm_readingpm'), true);
}
$dbr = wfGetDB(DB_SLAVE);
$sql = "SELECT * FROM {$awc_tables['awc_f_pms']} p, {$awc_tables['awc_f_pms_info']} pi \r\r\n WHERE p.pm_id=pi.pmi_pmid AND pi.pmi_pmid = " . $pmID . " AND pi.pmi_receipt_id = " . $this->m_id . " LIMIT 1";
$res = $dbr->query($sql);
$r = $dbr->fetchRow($res);
$post_cls->p_userid = $r['pmi_sender_id'];
$post_cls->p_user = $r['pmi_sender'];
$post_cls->p_title = $r['pm_title'];
$post_cls->p_post = $r['pm_text'];
$post_cls->p_date = $r['pmi_send_date'];
$post_cls->p_id = $r['pm_id'];
$post_cls->only_one_post = true;
if ($r['pmi_read'] == '0') {
$dbw = wfGetDB(DB_SLAVE);
$dbw->query("UPDATE {$awc_tables['awc_f_mems']} \r\r\n SET m_pmunread = m_pmunread - 1\r\r\n WHERE m_id =" . $this->m_id);
$dbw->update('awc_f_pms_info', array('pmi_read_date' => $dbw->timestamp(), 'pmi_read' => '1'), array('pmi_pmid' => $pmID), '');
}
$dbr->freeResult($res);
$word = array();
$word['delete'] = get_awcsforum_word('delete');
$word['save'] = get_awcsforum_word('mem_pm_save');
$word['quote'] = get_awcsforum_word('quote');
$url = awc_url . 'member_options/pms_change/pm_delete/id_' . $r['pmi_id'];
$t = $word['delete'] . ' ? \\n' . $r['pm_title'];
$t = str_replace(array(chr(10), chr(13), "'"), '', $t);
$info['url'] = $url;
$info['msg'] = $t;
$edit_buttons = $tplt->phase($word, $info, 'post:delete_post');
$info['url'] = awc_url . "member_options/pms_change/pm_move/id_" . $r['pmi_id'];
$edit_buttons .= $tplt->phase($word, $info, 'pm:save_pm');
$info['url'] = awc_url . "member_options/quotepm/id" . $pmID;
$edit_buttons .= $tplt->phase($word, $info, 'post:quote_button');
$post_cls->pm_links = $edit_buttons;
$out['body_info'] .= $post_cls->display_post(true);
# $st['send_to'] = $st['p_user'];
#$st['pmTitle'] = get_awcsforum_word('word_re') . ' ' . $st['p_title'];
$post_replay = null;
if (isset($this->mem_info['m_pmoptions']['m_pmautoquote'])) {
if ($this->mem_info['m_pmoptions']['m_pmautoquote'] == '1') {
$post_replay = "[quote=" . $r['pmi_sender'] . "]\n" . $r['pm_text'] . "\n[/quote] \n\n";
}
}
$m_pmautosave = get_awcsforum_word('mem_pm_savesenttosavesfolder') . '<INPUT TYPE=CHECKBOX NAME="savetosent"><br />';
if (isset($this->mem_info['m_pmoptions']['m_pmautosave'])) {
if ($this->mem_info['m_pmoptions']['m_pmautosave'] == '1') {
$m_pmautosave = get_awcsforum_word('mem_pm_savesenttosavesfolder') . '<INPUT TYPE=CHECKBOX NAME="savetosent" checked><br />';
}
}
$post_box->user_options = $m_pmautosave;
$post_box->is_pm = true;
$post_box->post = $post_replay;
$post_box->title = get_awcsforum_word('word_re') . ' ' . $r['pm_title'];
$post_box->title = awcsforum_funcs::awc_htmlentities($post_box->title);
$post_box->thread_subscribe = false;
$post_box->quick_box = false;
$post_box->box_width = "75%";
$post_box->javaCheck = 'onsubmit="return check_NewThread()"';
$post_box->url = awc_url . 'member_options/sendpm';
$post_box->mem_pm_sendto = get_awcsforum_word('mem_pm_sendto');
$post_box->mem_pm_sendto .= ' <input name="send_to" id="send_to" type="text" value="' . $r['pmi_sender'] . '" size="75%"><hr />';
$post_box->mem_pm_sendto .= "<div id='ajax_pmnames' name='ajax_pmnames'></div>";
// 2.5.8
$post_box->mem_pm_sendto .= get_awcsforum_word('words_send_to_multi_users') . ' ';
if (UserPerm < 2) {
$post_box->mem_pm_sendto .= $awcs_forum_config->cf_mem_maxpmsendusers . '<hr />';
} else {
$post_box->mem_pm_sendto .= $awcs_forum_config->cf_mod_maxpmsendusers . '<hr />';
}
$out['body_info'] .= $post_box->box();
self::display_memcp($out['body_info']);
}
