database_num_rows($database->database_query("SELECT NULL FROM se_forummoderators WHERE forummoderator_user_id='$user_id'")) == 0) {
return false;
} else {
return true;
}
} else {
if($database->database_num_rows($database->database_query("SELECT NULL FROM se_forummoderators WHERE forummoderator_user_id='$user_id' AND forummoderator_forum_id='$forum_id'")) == 0) {
return false;
} else {
return true;
}
}
} // END forum_is_moderator() METHOD
// THIS METHOD RETURNS AN ARRAY OF PERMISSIONS SETTINGS FOR A USER IN A GIVEN FORUM
// INPUT: $forum_id REPRESENTING THE FORUM ID OF THE FORUM TO RETRIEVE PERMISSIONS FOR
// OUTPUT: AN ARRAY OF FORUM PERMISSIONS FOR THE USER
function forum_permission($forum_id) {
global $database, $user, $setting;
// SET LEVEL ID
if($user->user_exists) { $level_id = $user->level_info["level_id"]; } else { $level_id = 0; }
$permission['is_moderator'] = false;
$permission['allowed_to_view'] = false;
$permission['allowed_to_post'] = false;
$permission['allowed_to_editall'] = false;
$permission['allowed_to_deleteall'] = false;
$permission['allowed_to_move'] = false;
$permission['allowed_to_close'] = false;
$permission['allowed_to_stick'] = false;
// CHECK IF MODERATOR
if($user->user_exists && $this->forum_is_moderator($user->user_info["user_id"], $forum_id)) {
$permission['is_moderator'] = true;
$permission['allowed_to_view'] = true;
$permission['allowed_to_post'] = true;
if(substr($setting['setting_forum_modprivs'], 0, 1) == 1) { $permission['allowed_to_editall'] = true; }
if(substr($setting['setting_forum_modprivs'], 1, 1) == 1) { $permission['allowed_to_deleteall'] = true; }
if(substr($setting['setting_forum_modprivs'], 2, 1) == 1) { $permission['allowed_to_move'] = true; }
if(substr($setting['setting_forum_modprivs'], 3, 1) == 1) { $permission['allowed_to_close'] = true; }
if(substr($setting['setting_forum_modprivs'], 4, 1) == 1) { $permission['allowed_to_stick'] = true; }
// IF NOT MODERATOR, CHECK ABOUT PERMISSIONS
} else {
$forumlevel_query = $database->database_query("SELECT forumlevel_post FROM se_forumlevels WHERE forumlevel_forum_id='$forum_id' AND forumlevel_level_id='$level_id'");
if($database->database_num_rows($forumlevel_query) == 1) {
$permission['allowed_to_view'] = true;
$forumlevel_info = $database->database_fetch_assoc($forumlevel_query);
if($forumlevel_info["forumlevel_post"]) { $permission['allowed_to_post'] = true; }
}
}
return $permission;
} // END forum_permission() METHOD
// THIS METHOD LISTS ALL FORUM CATEGORIES AND FORUMS
// INPUT: $cat_id (OPTIONAL) REPRESENTING THE FORUM CATEGORY TO RETRIEVE FORUMS FROM
// OUTPUT: AN ARRAY OF CATEGORIES WITH FULL FORUM AND MODERATOR INFO
function forum_list_home1($cat_id = 0) {
global $database, $user;
// SET LEVEL ID
if($user->user_exists) { $level_id = $user->level_info["level_id"]; } else { $level_id = 0; }
// GET FORUM CATEGORIES
//if($cat_id == 0) { $sql = "SELECT * FROM se_forumcats WHERE forumcat_id=52 OR forumcat_id=51 OR forumcat_id=38 OR forumcat_id=39 ORDER BY forumcat_order"; } else { $sql = "SELECT * FROM se_forumcats WHERE cat_id='$cat_id'"; }
//$forumcats = $database->database_query($sql);
//while($forumcat_info = $database->database_fetch_assoc($forumcats))
{
// GET FORUMS
$forum_array = Array();
$forums = $database->database_query("SELECT * FROM se_forums WHERE forum_id=52 OR forum_id=51 OR forum_id=38 OR forum_id=39 ORDER BY forum_order");
while($forum_info = $database->database_fetch_assoc($forums)) {
$show_forum = false;
/* if($database->database_num_rows($database->database_query("SELECT NULL FROM se_forumlevels WHERE forumlevel_forum_id='$forum_info["forum_id"]' AND forumlevel_level_id='$level_id'")) == 1) {
$show_forum = true;
} elseif($user->user_exists && $this->forum_is_moderator($user->user_info["user_id"], $forum_info["forum_id"])) {
$show_forum = true;
}*/
$show_forum = true;
if($show_forum) {
// SE_Language::_preload_multi($forum_info["forum_title"], $forum_info["forum_desc"]);
// GET MODERATORS
/* $mod_array = Array();
$mod_array_id = Array();
$mods = $database->database_query("SELECT se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname FROM se_forummoderators LEFT JOIN se_users ON se_forummoderators.forummoderator_user_id=se_users.user_id WHERE se_forummoderators.forummoderator_forum_id='$forum_info["forum_id"]' AND se_users.user_id IS NOT NULL");
while($user_info = $database->database_fetch_assoc($mods)) {
$mod_user = new se_user();
$mod_user->user_info["user_id"] = $user_info["user_id"];
$mod_user->user_info["user_username"] = $user_info["user_username"];
$mod_user->user_info["user_fname"] = $user_info["user_fname"];
$mod_user->user_info["user_lname"] = $user_info["user_lname"];
$mod_user->user_displayname();
$mod_array[] = $mod_user;
}
$forum_info["forum_mods"] = $mod_array;
*/
// GET LAST POST
$lastpost = $database->database_query("SELECT se_forumposts.forumpost_id, se_forumposts.forumpost_date, se_forumposts.forumpost_authoruser_id, se_forumtopics.forumtopic_id, se_forumtopics.forumtopic_subject, se_forumposts.forumpost_excerpt, se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname,se_users.user_enabled, se_users.user_photo FROM se_forumposts LEFT JOIN se_forumtopics ON se_forumposts.forumpost_forumtopic_id=se_forumtopics.forumtopic_id LEFT JOIN se_users ON se_forumposts.forumpost_authoruser_id=se_users.user_id WHERE se_forumtopics.forumtopic_forum_id='{$forum_info["forum_id"]}' AND se_forumposts.forumpost_deleted='0' group by se_forumtopics.forumtopic_id ORDER BY se_forumposts.forumpost_id DESC LIMIT 1");
if($database->database_num_rows($lastpost) > 0) {
$x=0;
while($lastpost_info = $database->database_fetch_assoc($lastpost)){
$forum_info["lastpost"] = true;
// GET POST AUTHOR
$author = new se_user();
if($lastpost_info['forumpost_authoruser_id'] != $lastpost_info['user_id']) {
$author->user_exists = false;
} else {
$author->user_exists = true;
$author->user_info['user_enabled']=$lastpost_info['user_enabled'];
$author->user_info['user_id'] = $lastpost_info['user_id'];
if($lastpost_info['user_enabled']<=0){
$author->user_info['user_username'] = "*Deleted*";
}
else{
$author->user_info['user_username'] = $lastpost_info['user_username'];
}
$author->user_info['user_fname'] = $lastpost_info['user_fname'];
$author->user_info['user_lname'] = $lastpost_info['user_lname'];
$author->user_info['user_photo'] = $lastpost_info['user_photo'];
$author->user_displayname();
}
$lastpost_info["author"] = $author;
$forum_info["lastpost_info"] = $lastpost_info;
$forum_array[] = $forum_info;
$x++;
if($x>=5){break;}
}
} else {
$forum_info["lastpost"] = false;
}
/*
if($forum_info["lastpost"]) {
$forum_info[is_read] = false;
if(isset($_COOKIE["forum_{$user->user_info["user_id"]}_$forum_info["forum_id"]"])) {
if($_COOKIE["forum_{$user->user_info["user_id"]}_$forum_info["forum_id"]"] >= $forum_info["lastpost_info"]["forumpost_date"]) {
$forum_info[is_read] = true;
}
}
} else {
$forum_info[is_read] = true;
}
*/
}
}
//SE_Language::_preload($forumcat_info["forumcat_title"]);
$forumcat_info["forums"] = $forum_array;
$forumcat_array[] = $forumcat_info;
}
return $forumcat_array;
}
function forum_list_home($cat_id = 0) {
global $database, $user;
// SET LEVEL ID
if($user->user_exists) { $level_id = $user->level_info["level_id"]; } else { $level_id = 0; }
// GET FORUM CATEGORIES
//if($cat_id == 0) { $sql = "SELECT * FROM se_forumcats WHERE forumcat_id=52 OR forumcat_id=51 OR forumcat_id=38 OR forumcat_id=39 ORDER BY forumcat_order"; } else { $sql = "SELECT * FROM se_forumcats WHERE cat_id='$cat_id'"; }
//$forumcats = $database->database_query($sql);
//while($forumcat_info = $database->database_fetch_assoc($forumcats))
{
// GET FORUMS
$forum_array = Array();
$forums = $database->database_query("SELECT * FROM se_forums WHERE forum_id=52 OR forum_id=51 OR forum_id=38 OR forum_id=39 ORDER BY forum_order");
while($forum_info = $database->database_fetch_assoc($forums)) {
$show_forum = false;
/* if($database->database_num_rows($database->database_query("SELECT NULL FROM se_forumlevels WHERE forumlevel_forum_id='$forum_info["forum_id"]' AND forumlevel_level_id='$level_id'")) == 1) {
$show_forum = true;
} elseif($user->user_exists && $this->forum_is_moderator($user->user_info["user_id"], $forum_info["forum_id"])) {
$show_forum = true;
}*/
$show_forum = true;
if($show_forum) {
// SE_Language::_preload_multi($forum_info["forum_title"], $forum_info["forum_desc"]);
// GET MODERATORS
/* $mod_array = Array();
$mod_array_id = Array();
$mods = $database->database_query("SELECT se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname FROM se_forummoderators LEFT JOIN se_users ON se_forummoderators.forummoderator_user_id=se_users.user_id WHERE se_forummoderators.forummoderator_forum_id='$forum_info["forum_id"]' AND se_users.user_id IS NOT NULL");
while($user_info = $database->database_fetch_assoc($mods)) {
$mod_user = new se_user();
$mod_user->user_info["user_id"] = $user_info["user_id"];
$mod_user->user_info["user_username"] = $user_info["user_username"];
$mod_user->user_info["user_fname"] = $user_info["user_fname"];
$mod_user->user_info["user_lname"] = $user_info["user_lname"];
$mod_user->user_displayname();
$mod_array[] = $mod_user;
}
$forum_info["forum_mods"] = $mod_array;
*/
// GET LAST POST
$lastpost = $database->database_query("SELECT se_forumposts.forumpost_id, se_forumposts.forumpost_date, se_forumposts.forumpost_authoruser_id, se_forumtopics.forumtopic_id, se_forumtopics.forumtopic_subject, se_forumposts.forumpost_excerpt, se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname,se_users.user_enabled, se_users.user_photo FROM se_forumposts LEFT JOIN se_forumtopics ON se_forumposts.forumpost_forumtopic_id=se_forumtopics.forumtopic_id LEFT JOIN se_users ON se_forumposts.forumpost_authoruser_id=se_users.user_id WHERE se_forumtopics.forumtopic_forum_id='{$forum_info["forum_id"]}' AND se_forumposts.forumpost_deleted='0' group by se_forumtopics.forumtopic_id ORDER BY se_forumposts.forumpost_date DESC LIMIT 1");
if($database->database_num_rows($lastpost) > 0) {
$x=0;
while($lastpost_info = $database->database_fetch_assoc($lastpost)){
$forum_info["lastpost"] = true;
// GET POST AUTHOR
$author = new se_user();
if($lastpost_info['forumpost_authoruser_id'] != $lastpost_info['user_id']) {
$author->user_exists = false;
} else {
$author->user_exists = true;
$author->user_info['user_id'] = $lastpost_info['user_id'];
$author->user_info['user_enabled']=$lastpost_info['user_enabled'];
if($lastpost_info['user_enabled']<=0){
$author->user_info['user_username'] = "*Deleted*";
}
else{
$author->user_info['user_username'] = $lastpost_info['user_username'];
}
$author->user_info['user_fname'] = $lastpost_info['user_fname'];
$author->user_info['user_lname'] = $lastpost_info['user_lname'];
$author->user_info['user_photo'] = $lastpost_info['user_photo'];
$author->user_displayname();
}
$lastpost_info["author"] = $author;
$forum_info["lastpost_info"] = $lastpost_info;
$forum_array[] = $forum_info;
$x++;
if($x>=5){break;}
}
} else {
$forum_info["lastpost"] = false;
}
/*
if($forum_info["lastpost"]) {
$forum_info[is_read] = false;
if(isset($_COOKIE["forum_{$user->user_info["user_id"]}_$forum_info["forum_id"]"])) {
if($_COOKIE["forum_{$user->user_info["user_id"]}_$forum_info["forum_id"]"] >= $forum_info["lastpost_info"]["forumpost_date"]) {
$forum_info[is_read] = true;
}
}
} else {
$forum_info[is_read] = true;
}
*/
}
}
//SE_Language::_preload($forumcat_info["forumcat_title"]);
$forumcat_info["forums"] = $forum_array;
$forumcat_array[] = $forumcat_info;
}
return $forumcat_array;
}
function forum_list_home_old($cat_id = 0) {
global $database, $user;
// SET LEVEL ID
if($user->user_exists) { $level_id = $user->level_info["level_id"]; } else { $level_id = 0; }
// GET FORUM CATEGORIES
if($cat_id == 0) { $sql = "SELECT * FROM se_forumcats WHERE forumcat_id!=18 AND forumcat_id!=23 ORDER BY forumcat_order"; } else { $sql = "SELECT * FROM se_forumcats WHERE cat_id='$cat_id'"; }
$forumcats = $database->database_query($sql);
while($forumcat_info = $database->database_fetch_assoc($forumcats)) {
// GET FORUMS
$forum_array = Array();
$forums = $database->database_query("SELECT * FROM se_forums WHERE forum_id!=23 AND forum_forumcat_id='{$forumcat_info["forumcat_id"]}' ORDER BY forum_order");
while($forum_info = $database->database_fetch_assoc($forums)) {
$show_forum = false;
/* if($database->database_num_rows($database->database_query("SELECT NULL FROM se_forumlevels WHERE forumlevel_forum_id='$forum_info["forum_id"]' AND forumlevel_level_id='$level_id'")) == 1) {
$show_forum = true;
} elseif($user->user_exists && $this->forum_is_moderator($user->user_info["user_id"], $forum_info["forum_id"])) {
$show_forum = true;
}*/
$show_forum = true;
if($show_forum) {
// SE_Language::_preload_multi($forum_info["forum_title"], $forum_info["forum_desc"]);
// GET MODERATORS
/* $mod_array = Array();
$mod_array_id = Array();
$mods = $database->database_query("SELECT se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname FROM se_forummoderators LEFT JOIN se_users ON se_forummoderators.forummoderator_user_id=se_users.user_id WHERE se_forummoderators.forummoderator_forum_id='$forum_info["forum_id"]' AND se_users.user_id IS NOT NULL");
while($user_info = $database->database_fetch_assoc($mods)) {
$mod_user = new se_user();
$mod_user->user_info["user_id"] = $user_info["user_id"];
$mod_user->user_info["user_username"] = $user_info["user_username"];
$mod_user->user_info["user_fname"] = $user_info["user_fname"];
$mod_user->user_info["user_lname"] = $user_info["user_lname"];
$mod_user->user_displayname();
$mod_array[] = $mod_user;
}
$forum_info["forum_mods"] = $mod_array;
*/
// GET LAST POST
$lastpost = $database->database_query("SELECT se_forumposts.forumpost_id, se_forumposts.forumpost_date, se_forumposts.forumpost_authoruser_id, se_forumtopics.forumtopic_id, se_forumtopics.forumtopic_subject, se_forumposts.forumpost_excerpt, se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname,se_users.user_enabled, se_users.user_photo FROM se_forumposts LEFT JOIN se_forumtopics ON se_forumposts.forumpost_forumtopic_id=se_forumtopics.forumtopic_id LEFT JOIN se_users ON se_forumposts.forumpost_authoruser_id=se_users.user_id WHERE se_forumtopics.forumtopic_forum_id='{$forum_info["forum_id"]}' AND se_forumposts.forumpost_deleted='0' group by se_forumtopics.forumtopic_id ORDER BY se_forumposts.forumpost_id DESC LIMIT 3");
if($database->database_num_rows($lastpost) > 0) {
$x=0;
while($lastpost_info = $database->database_fetch_assoc($lastpost)){
$forum_info["lastpost"] = true;
// GET POST AUTHOR
$author = new se_user();
if($lastpost_info['forumpost_authoruser_id'] != $lastpost_info['user_id']) {
$author->user_exists = false;
} else {
$author->user_exists = true;
$author->user_info['user_id'] = $lastpost_info['user_id'];
$author->user_info['user_enabled']=$lastpost_info['user_enabled'];
if($lastpost_info['user_enabled']<=0){
$author->user_info['user_username'] = "*Deleted*";
}
else{
$author->user_info['user_username'] = $lastpost_info['user_username'];
}
$author->user_info['user_fname'] = $lastpost_info['user_fname'];
$author->user_info['user_lname'] = $lastpost_info['user_lname'];
$author->user_info['user_photo'] = $lastpost_info['user_photo'];
$author->user_displayname();
}
$lastpost_info["author"] = $author;
$forum_info["lastpost_info"] = $lastpost_info;
$forum_array[] = $forum_info;
$x++;
if($x>=5){break;}
}
} else {
$forum_info["lastpost"] = false;
}
/*
if($forum_info["lastpost"]) {
$forum_info[is_read] = false;
if(isset($_COOKIE["forum_{$user->user_info["user_id"]}_$forum_info["forum_id"]"])) {
if($_COOKIE["forum_{$user->user_info["user_id"]}_$forum_info["forum_id"]"] >= $forum_info["lastpost_info"]["forumpost_date"]) {
$forum_info[is_read] = true;
}
}
} else {
$forum_info["is_read"] = true;
}
*/
}
}
//SE_Language::_preload($forumcat_info["forumcat_title"]);
$forumcat_info["forums"] = $forum_array;
$forumcat_array[] = $forumcat_info;
}
return $forumcat_array;
} // END forum_list() METHOD
// THIS METHOD LISTS ALL FORUM CATEGORIES AND FORUMS
// INPUT: $cat_id (OPTIONAL) REPRESENTING THE FORUM CATEGORY TO RETRIEVE FORUMS FROM
// OUTPUT: AN ARRAY OF CATEGORIES WITH FULL FORUM AND MODERATOR INFO
function forum_list($cat_id = 0) {
global $database, $user;
// SET LEVEL ID
if($user->user_exists) { $level_id = $user->level_info["level_id"]; } else { $level_id = 0; }
// GET FORUM CATEGORIES
if($cat_id == 0) { $sql = "SELECT * FROM se_forumcats ORDER BY forumcat_order"; } else { $sql = "SELECT * FROM se_forumcats WHERE cat_id='$cat_id'"; }
$forumcats = $database->database_query($sql);
while($forumcat_info = $database->database_fetch_assoc($forumcats)) {
// GET FORUMS
$forum_array = Array();
$forums = $database->database_query("SELECT * FROM se_forums WHERE forum_forumcat_id='{$forumcat_info["forumcat_id"]}' ORDER BY forum_order");
while($forum_info = $database->database_fetch_assoc($forums)) {
$show_forum = false;
if($database->database_num_rows($database->database_query("SELECT NULL FROM se_forumlevels WHERE forumlevel_forum_id='{$forum_info["forum_id"]}' AND forumlevel_level_id='$level_id'")) == 1) {
$show_forum = true;
} elseif($user->user_exists && $this->forum_is_moderator($user->user_info["user_id"], $forum_info["forum_id"])) {
$show_forum = true;
}
if($show_forum) {
SE_Language::_preload_multi($forum_info["forum_title"], $forum_info["forum_desc"]);
// GET MODERATORS
$mod_array = Array();
$mod_array_id = Array();
$mods = $database->database_query("SELECT se_users.user_id, se_users.user_username, se_users.user_enabled, se_users.user_fname, se_users.user_lname FROM se_forummoderators LEFT JOIN se_users ON se_forummoderators.forummoderator_user_id=se_users.user_id WHERE se_forummoderators.forummoderator_forum_id='{$forum_info["forum_id"]}' AND se_users.user_id IS NOT NULL");
while($user_info = $database->database_fetch_assoc($mods)) {
$mod_user = new se_user();
$mod_user->user_info["user_id"] = $user_info["user_id"];
$mod_user->user_info["user_username"] = $user_info["user_username"];
if($user_info['user_enabled']<=0){
$mod_user->user_info['user_username'] = "*Deleted*";
}
else{
$mod_user->user_info['user_username'] = $user_info['user_username'];
}
$mod_user->user_info["user_fname"] = $user_info["user_fname"];
$mod_user->user_info["user_lname"] = $user_info["user_lname"];
$mod_user->user_displayname();
$mod_array[] = $mod_user;
}
$forum_info["forum_mods"] = $mod_array;
// GET LAST POST
$lastpost = $database->database_query("SELECT se_forumposts.forumpost_id, se_forumposts.forumpost_date, se_forumposts.forumpost_authoruser_id, se_forumtopics.forumtopic_id, se_forumtopics.forumtopic_subject, se_forumposts.forumpost_excerpt, se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname,se_users.user_enabled, se_users.user_photo FROM se_forumposts LEFT JOIN se_forumtopics ON se_forumposts.forumpost_forumtopic_id=se_forumtopics.forumtopic_id LEFT JOIN se_users ON se_forumposts.forumpost_authoruser_id=se_users.user_id WHERE se_forumtopics.forumtopic_forum_id='{$forum_info["forum_id"]}' AND se_forumposts.forumpost_deleted='0' ORDER BY se_forumposts.forumpost_id DESC LIMIT 1");
if($database->database_num_rows($lastpost) == 1) {
$lastpost_info = $database->database_fetch_assoc($lastpost);
$forum_info["lastpost"] = true;
// GET POST AUTHOR
$author = new se_user();
if($lastpost_info['forumpost_authoruser_id'] != $lastpost_info['user_id']) {
$author->user_exists = false;
} else {
$author->user_exists = true;
$author->user_info['user_id'] = $lastpost_info['user_id'];
if($lastpost_info['user_enabled']<=0){
$author->user_info['user_username'] = "*Deleted*";
}
else{
$author->user_info['user_username'] = $lastpost_info['user_username'];
}
$author->user_info['user_enabled'] = $lastpost_info['user_enabled'];
$author->user_info['user_fname'] = $lastpost_info['user_fname'];
$author->user_info['user_lname'] = $lastpost_info['user_lname'];
$author->user_info['user_photo'] = $lastpost_info['user_photo'];
$author->user_displayname();
}
$lastpost_info["author"] = $author;
$forum_info["lastpost_info"] = $lastpost_info;
} else {
$forum_info["lastpost"] = false;
}
/*
if($forum_info["lastpost"]) {
$forum_info[is_read] = false;
if(isset($_COOKIE["forum_{$user->user_info["user_id"]}_$forum_info["forum_id"]"])) {
if($_COOKIE["forum_{$user->user_info["user_id"]}_$forum_info["forum_id"]"] >= $forum_info["lastpost_info"]["forumpost_date"]) {
$forum_info[is_read] = true;
}
}
} else {
$forum_info[is_read] = true;
}
*/
$forum_array[] = $forum_info;
}
}
SE_Language::_preload($forumcat_info["forumcat_title"]);
$forumcat_info["forums"] = $forum_array;
$forumcat_array[] = $forumcat_info;
}
return $forumcat_array;
} // END forum_list() METHOD
// THIS METHOD LISTS ALL TOPICS IN A FORUM
// INPUT: $forum_id REPRESENTING THE FORUM ID OF THE FORUM TO RETRIEVE TOPICS FROM
// $start REPRESENTING THE TOPIC TO START WITH
// $limit REPRESENTING THE NUMBER OF TOPICS TO RETURN
// OUTPUT: AN ARRAY OF TOPIC INFORMATION
function forum_topic_list($forum_id, $start, $limit) {
global $database, $user;
if($_GET["sortby"]=="newtopics"){$sortby="forumtopic_id";}
else{$sortby="forumtopic_date";}
// GET TOPICS
$sql = "SELECT se_forumlogs.forumlog_date, se_forumtopics.* FROM se_forumtopics LEFT JOIN se_forumlogs ON (se_forumtopics.forumtopic_id=se_forumlogs.forumlog_forumtopic_id AND se_forumlogs.forumlog_user_id='{$user->user_info["user_id"]}') WHERE forumtopic_forum_id='$forum_id' ORDER BY forumtopic_sticky DESC, $sortby DESC LIMIT $start, $limit";
$forumtopics = $database->database_query($sql);
$forumtopic_array = Array();
while($forumtopic_info = $database->database_fetch_assoc($forumtopics)) {
// GET LAST POST
$lastpost = $database->database_query("SELECT se_forumposts.forumpost_id, se_forumposts.forumpost_date, se_forumposts.forumpost_excerpt, se_forumposts.forumpost_authoruser_id, se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname, se_users.user_photo, se_users.user_enabled FROM se_forumposts LEFT JOIN se_users ON se_forumposts.forumpost_authoruser_id=se_users.user_id WHERE se_forumposts.forumpost_forumtopic_id='{$forumtopic_info["forumtopic_id"]}' AND se_forumposts.forumpost_deleted='0' ORDER BY se_forumposts.forumpost_id DESC LIMIT 1");
if($database->database_num_rows($lastpost) == 1) {
$lastpost_info = $database->database_fetch_assoc($lastpost);
$forumtopic_info["lastpost"] = true;
// GET POST AUTHOR
$author = new se_user();
if($lastpost_info['forumpost_authoruser_id'] != $lastpost_info['user_id']) {
$author->user_exists = false;
} else {
$author->user_exists = true;
$author->user_info['user_id'] = $lastpost_info['user_id'];
if($lastpost_info['user_enabled']<=0){
$author->user_info['user_username'] = "*Deleted*";
}
else{
$author->user_info['user_username'] = $lastpost_info['user_username'];
}
$author->user_info['user_enabled'] = $lastpost_info['user_enabled'];
$author->user_info['user_fname'] = $lastpost_info['user_fname'];
$author->user_info['user_lname'] = $lastpost_info['user_lname'];
$author->user_info['user_photo'] = $lastpost_info['user_photo'];
$author->user_displayname();
}
$lastpost_info["author"] = $author;
$forumtopic_info["lastpost_info"] = $lastpost_info;
} else {
$forumtopic_info["lastpost"] = false;
}
if($forumtopic_info["forumlog_date"] == NULL || $forumtopic_info["forumlog_date"] < $forumtopic_info["forumtopic_date"]) {
$forumtopic_info["is_new"] = true;
} else {
$forumtopic_info["is_new"] = false;
}
$forumtopic_array[] = $forumtopic_info;
}
return $forumtopic_array;
} // END forum_topic_list() METHOD
// THIS METHOD CREATES A NEW TOPIC
// INPUT: $forum_id REPRESENTING THE FORUM ID OF THE FORUM TO CREATE TOPIC IN
// $forum_title REPRESENTING THE TITLE OF THE FORUM
// $topic_title REPRESENTING THE TOPIC TITLE
// $post_body REPRESENTING THE POST'S BODY
// OUTPUT:
function forum_topic_new($forum_id, $forum_title, $topic_title, $post_body) {
global $database, $user, $actions;
$is_error = 0;
$nowdate = time();
// SET ERRORS
if(trim($topic_title) == "") { $is_error = 6000066; }
if(trim(str_replace("<p>", "", str_replace("</p>", "", $post_body))) == "") { $is_error = 6000067; }
// IF NO ERROR, CREATE TOPIC
if($is_error == 0) {
// CREATE EXCERPT
$excerpt = $this->forum_excerpt($this->forum_bbcode_parse_clean($post_body));
// INSERT INTO FORUM TOPIC TABLE
if(SE_DEBUG){
$database->database_query("INSERT INTO se_forumtopics (forumtopic_forum_id, forumtopic_creatoruser_id, forumtopic_date, forumtopic_subject, forumtopic_excerpt) VALUES ('$forum_id', '{$user->user_info["user_id"]}', '$nowdate', '".$database->database_real_escape_string(json_encode($topic_title))."', '$excerpt')");
}
else{
$database->database_query("INSERT INTO se_forumtopics (forumtopic_forum_id, forumtopic_creatoruser_id, forumtopic_date, forumtopic_subject, forumtopic_excerpt) VALUES ('$forum_id', '{$user->user_info["user_id"]}', '$nowdate', '".$database->database_real_escape_string($topic_title)."', '$excerpt')");
}
$forumtopic_id = $database->database_insert_id();
// ADD POST
$this->forum_post_new($forum_id, $forumtopic_id, $topic_title, $post_body, true);
// ADD ACTION
if($user->user_exists) {
$actions->actions_add($user, "forumtopic", Array($user->user_info['user_username'], $user->user_displayname, $forum_id, SE_Language::get($forum_title), $forumtopic_id, $topic_title, $excerpt), Array(), 0, false, 'forum', $forum_id, 0);
}
}
return Array('is_error' => $is_error, 'topic_id' => $forumtopic_id);
} // END forum_topic_new() METHOD
// THIS METHOD CREATES A NEW POST
// INPUT: $forum_id REPRESENTING THE FORUM ID OF THE FORUM TO CREATE TOPIC IN
// $topic_id REPRESENTING THE ID OF THE TOPIC TO ADD THE POST TO
// $topic_title REPRESENTING THE TITLE OF THE TOPIC
// $post_body REPRESENTING THE POST'S BODY
// $new_topic (OPTIONAL) REPRESENTING WHETHER THIS IS THE FIRST POST IN THE NEW TOPIC
// OUTPUT:
function forum_post_new($forum_id, $topic_id, $topic_title, $post_body, $new_topic = false) {
global $database, $user, $actions, $notify, $url;
$is_error = 0;
$nowdate = time();
// SET ERRORS
if(trim(str_replace("<p>", "", str_replace("</p>", "", $post_body))) == "") { $is_error = 6000067; }
// IF NO ERROR, ADD POST
if($is_error == 0) {
// UPLOAD FORUM MEDIA
$forummedia_id = $this->forum_media_new($topic_id);
// CLEAN, CENSOR, ETC
$post_body = $this->forum_bbcode_parse_clean($post_body);
// CREATE EXCERPT
$excerpt = $this->forum_excerpt($post_body);
// INSERT INTO FORUM POST TABLE
$database->database_query("INSERT INTO se_forumposts (forumpost_forumtopic_id, forumpost_authoruser_id, forumpost_date, forumpost_excerpt, forumpost_body, forumpost_forummedia_id) VALUES ('$topic_id', '{$user->user_info["user_id"]}', '$nowdate', '$excerpt', '$post_body', '$forummedia_id')");
$forumpost_id = $database->database_insert_id();
addspampoint(17, $user->user_info["user_id"]);
// IF NEW TOPIC, UPDATE FORUM TABLE
if($new_topic) {
$database->database_query("UPDATE se_forums SET forum_totaltopics=forum_totaltopics+1 WHERE forum_id='$forum_id'");
// IF REPLY, UPDATE FORUM AND FORUMTOPIC TABLE
} else {
$database->database_query("UPDATE se_forums SET forum_totalreplies=forum_totalreplies+1 WHERE forum_id='$forum_id'");
$database->database_query("UPDATE se_forumtopics SET forumtopic_date='$nowdate', forumtopic_totalreplies=forumtopic_totalreplies+1 WHERE forumtopic_id='$topic_id' AND forumtopic_forum_id='$forum_id'");
// ADD ACTION
if($user->user_exists) {
$actions->actions_add($user, "forumpost", Array($user->user_info['user_username'], $user->user_displayname, $forum_id, $topic_id, $topic_title, $forumpost_id, $excerpt), Array(), 0, false, 'forum', $forum_id, 0, $forumpost_id);
}
// SEND NOTIFICATION
if($user->user_exists) { $poster = $user->user_displayname; } else { $poster = SE_Language::get(835); }
// SEND REPLY NOTIFICATION
$topic_starter = $database->database_fetch_assoc($database->database_query("SELECT se_forumposts.forumpost_authoruser_id FROM se_forumposts WHERE forumpost_forumtopic_id='{$topic_id}' ORDER BY forumpost_id ASC LIMIT 1"));
if($topic_starter['forumpost_authoruser_id'] != $user->user_info['user_id']) {
$starter = new se_user(Array($topic_starter['forumpost_authoruser_id']));
if($starter->user_exists) {
$notifytype = $notify->notify_add($starter->user_info["user_id"], 'forumreply', $topic_id, Array($forum_id, $topic_id, $forumpost_id), Array($topic_title), FALSE, $forumpost_id);
$object_url = $url->url_base.vsprintf($notifytype["notifytype_url"], Array($forum_id, $topic_id, $forumpost_id));
$starter->user_settings();
if($starter->usersetting_info['usersetting_notify_forumreply']) {
$replace=array("[displayname]"=>$starter->user_displayname,
"[commenter]"=>$poster,
"[topicname]"=>$topic_title,
"[link]"=>"$object_url" );
send_systememail("forumreply", $starter->user_info['user_email'], $replace);
// send_systememail("forumreply", $starter->user_info['user_email'], Array($starter->user_displayname, $poster, $topic_title, "$object_url"));
}
}
}
}
// UPDATE USER'S TOTAL POSTS
$database->database_query("INSERT INTO se_forumusers (forumuser_user_id, forumuser_totalposts) VALUES ('{$user->user_info["user_id"]}', 1) ON DUPLICATE KEY UPDATE forumuser_totalposts=forumuser_totalposts+1");
}
return Array('is_error' => $is_error, 'post_id' => $forumpost_id);
} // END forum_post_new() METHOD
// THIS METHOD UPLOADS AN IMAGE FOR A POST
// INPUT: $topic_id REPRESENTING THE ID OF THE TOPIC TO WHICH IMAGE IS BEING UPLOADED
// OUTPUT: THE FORUMMEDIA ID OF UPLOADED FILE
function forum_media_new($topic_id) {
global $database;
// SET KEY VARIABLES
$forummedia_id = 0;
$file_maxsize = 2048000;
$file_exts = Array('jpg', 'jpeg', 'gif', 'png', 'bmp');
$file_types = Array('image/jpeg', 'image/pjpeg', 'image/jpg', 'image/jpe', 'image/pjpg', 'image/x-jpeg', 'image/x-jpg', 'image/gif', 'image/x-gif', 'image/png', 'image/x-png', 'image/bmp');
$file_maxwidth = 650;
$file_maxheight = 1000;
// START NEW UPLOAD
$new_media = new se_upload();
$new_media->new_upload('post_media', $file_maxsize, $file_exts, $file_types, $file_maxwidth, $file_maxheight);
// UPLOAD AND RESIZE PHOTO IF NO ERROR
if($new_media->is_error == 0) {
// INSERT ROW INTO MEDIA TABLE
$database->database_query("INSERT INTO se_forummedia (forummedia_forumtopic_id) VALUES ('{$topic_id}')");
$forummedia_id = $database->database_insert_id();
// CHECK IF IMAGE RESIZING IS AVAILABLE, OTHERWISE MOVE UPLOADED IMAGE
if($new_media->is_image == 1) {
// MAKE SURE SUBDIRECTORY EXISTS
$subdir = './uploads_forum/'.$topic_id.'/';
if(!is_dir($subdir)) {
mkdir($subdir, 0777);
chmod($subdir, 0777);
}
$file_dest = $subdir.$forummedia_id.".jpg";
// UPLOAD FILE
$new_media->upload_photo($file_dest);
$file_ext = "jpg";
$file_filesize = filesize($file_dest);
} else {
// MAKE SURE SUBDIRECTORY EXISTS
$subdir = './uploads_forum/'.$topic_id.'/';
if(!is_dir($subdir)) {
mkdir($subdir, 0777);
chmod($subdir, 0777);
}
$file_dest = $subdir.$forummedia_id.".".$new_media->file_ext;
$new_media->upload_file($file_dest);
$file_ext = $new_media->file_ext;
$file_filesize = filesize($file_dest);
}
// DELETE FROM DATABASE IF ERROR
if($new_media->is_error) {
$database->database_query("DELETE FROM se_forummedia WHERE forummedia_id='$forummedia_id' AND forummedia_forumtopic_id='$topic_id'");
@unlink($file_dest);
$forummedia_id = 0;
// UPDATE ROW IF NO ERROR
} else {
$database->database_query("UPDATE se_forummedia SET forummedia_ext='$file_ext', forummedia_filesize='$file_filesize' WHERE forummedia_id='$forummedia_id' AND forummedia_forumtopic_id='$topic_id'");
}
}
return $forummedia_id;
} // END forum_media_new() METHOD
// THIS METHOD CREATES AN EXCERPT FROM TEXT
// INPUT: $body REPRESENTING THE TEXT TO RETRIEVE THE EXCERPT FROM
// $chars (OPTIONAL) REPRESENTING THE NUMBER OF CHARACTERS FOR THE EXCERPT
// OUTPUT: A STRING WITHOUT HTML REPRESENTING THE EXCERPT FOR THE BODY OF TEXT
function forum_excerpt($body, $chars = 100) {
global $database;
// HTMLSPECIALCHARS_DECODE
$body = htmlspecialchars_decode($body, ENT_QUOTES);
// GET RID OF EXCESS WHITE SPACE
$body = preg_replace('/\s\s+/', ' ', $body);
// GET RID OF HTML
$body = strip_tags($body);
// GET RID OF BBCODE (QUOTES AND SUCH)
$body = $this->forum_quote_regex($body);
// TRUNCATE TO $chars
$body = substr($body, 0, $chars);
// HTMLSPECIALCHARS
$body = htmlspecialchars($body, ENT_QUOTES);
// RETURN EXCERPT
return $body;
} // END forum_excerpt() METHOD
// RECURSIVE REGEX ESCAPE
// INPUT:
// OUTPUT:
function forum_quote_regex($string) {
$regex = '/\[quote\=[^\]]*?\](.*?\[\/quote\])/is';
while(preg_match($regex, $string, $matches)) {
if(preg_match($regex, $matches[1], $new_matches)) {
$string = str_replace($matches[1], $this->forum_quote_regex($matches[1]), $string);
} else {
$string = str_replace($matches[0], ' ', $string);
}
}
return $string;
} // END forum_excerpt() METHOD
// THIS METHOD CLEANS AND PARSES A STRING FOR BBCODE
// INPUT: $string REPRESENTING THE STRING TO PARSE
// OUTPUT: A PARSED STRING
function forum_bbcode_parse_clean($string) {
// FIX LINE BREAKS
$string = htmlspecialchars_decode($string, ENT_QUOTES);
$string = censor($string);
if (!preg_match('/<[^>]+>/', $string))
$string = preg_replace(array("/\\r\\n/", "/\\r/", "/\\n/"), array("[br]", "[br]", "[br]"), $string);
// CLEAN HTML
$allowed_html = "ol,ul,li,strong,em,u,strike,p,br,a,embed,img,object,param";
$string = cleanHTML($string, $allowed_html, Array("style"));
// FIX LINE BREAKS
$string = str_replace("[br]", "
", $string);
$string = preg_replace('/\s+
\s+/i', '
', $string);
$string = preg_replace('/(
){3,}/is', '
', $string);
// RE-ENCODE
$string = htmlspecialchars($string, ENT_QUOTES);
return $string;
} // END forum_bbcode_parse_clean() METHOD
// THIS METHOD CLEANS AND PARSES A STRING FOR BBCODE
// INPUT: $string REPRESENTING THE STRING TO PARSE
// OUTPUT: A PARSED STRING
function forum_bbcode_parse_view($string) {
// DO [quote]
$open_quote = preg_match_all('/\[quote\=(.*?)\]/i', $string, $matches);
$close_quote = preg_match_all('/\[\/quote\]/i', $string, $matches);
$total_tags = ( $open_quote>$close_quote ? $close_quote : $open_quote );
if($total_tags) {
$string = preg_replace('/\[quote\=(.*?)\]/i', "