 |
Board for $ctitle\n";
echo "\n";
echo " \n";
echo "![](\"$jbbc[9]\") | ";
echo "| OC | Topic | Author | Posts | Last Post (".date("T").") | Hits | \n";
$result = @mysql_query("SELECT uid,flags,topic,username,utime,hits FROM uo_chat_boards WHERE chat='$chatpath' ORDER BY $jbbc[14] $jbbc[15]", $handler);
while($thread = mysql_fetch_row($result)) {
$posts = @mysql_query("SELECT id FROM uo_chat_threads WHERE chat='$chatpath' AND id='$thread[0]'", $handler);
$posts = mysql_num_rows($posts);
echo "| $thread[1] | ".htmlentities($thread[2])." | ".htmlentities(ucwords($thread[3]))." | $posts | ".(date("g:ia, F d, Y", $thread[4]))." | ".$thread[5]." | \n";
}
@mysql_free_result($result);
echo " | ";
echo " \n";
}
function ShowPosts($chatpath, $pid) {
global $handler, $jbbc;
$result = @mysql_query("SELECT topic,flags FROM uo_chat_boards WHERE chat='$chatpath' AND uid='$pid'", $handler);
$thread = mysql_fetch_array($result);
@mysql_free_result($result);
echo "Thread for ".htmlentities($thread[0])."";
echo "\n";
echo " \n";
echo "![](\"$jbbc[5]\") | ";
$result = @mysql_query("SELECT chat,id,utime,topic,post,username FROM uo_chat_threads WHERE chat='$chatpath' AND id='$pid' ORDER BY utime ASC", $handler);
while($post = mysql_fetch_row($result)) {
echo "| ".htmlentities($post[3])." | \n";
echo "".htmlentities(ucwords($post[5]))."
".(date("g:ia, F d, Y", $post[2]))."
[Edit]
[Delete] | ".(str_replace("´","'",$post[4]))." | \n";
}
@mysql_free_result($result);
echo " | ";
echo " \n";
@mysql_query("UPDATE uo_chat_boards SET hits=hits+1 WHERE chat='$chatpath' AND uid='$pid'", $handler);
}
function ShowReplyCreateBox($chatpath, $pid, $act, $but, $show=0, $username, $password) {
global $handler, $jbblock, $ctitle, $jbbc;
if ($jbblock > 0)
echo "Note: Only members of $ctitle can post or reply on this board.";
echo " \n";
echo "Any HTML, JavaScript, CSS, and such tags can be used on the board.";
if ($show >= 1)
ShowPosts($chatpath, $pid, $handler);
}
function ShowEditBox($chatpath, $pid, $username, $password, $timer) {
global $handler, $jbbc;
$result = mysql_query("SELECT chat,id,utime,topic,post,username FROM uo_chat_threads WHERE chat='$chatpath' AND id='$pid' AND utime='$timer'", $handler);
$thread = mysql_fetch_row($result);
@mysql_free_result($result);
$thread[4] = str_replace("
","",$thread[4]);
$thread[4] = str_replace("
","",$thread[4]);
echo " \n";
ShowPosts($chatpath, $pid, $handler);
}
function ShowModBox($chatpath, $pid, $act, $but, $username, $password, $eid="") {
global $handler, $jbbc;
echo "\n";
}
function ShowSearchBox($chatpath) {
global $handler, $jbbc;
echo "\n";
}
function DoReply($chatpath, $pid, $topic, $post, $username, $password) {
global $handler, $jbblock, $jbbc;
include("../../common/helpers.php");
$userlevel = ChatVerifyLogin($username, $password, $chatpath);
if ($userlevel == -1) {
$username = "Impersonating $username";
$userlevel = 0;
}
if (($jbblock > 0) && (!$userlevel)) {
echo "This board can only be used by members of the chat.
";
echo "...Return...";
return 0;
}
$result = @mysql_query("SELECT flags FROM uo_chat_boards WHERE chat='$chatpath' AND uid='$pid'", $handler);
$thrd = mysql_fetch_row($result);
@mysql_free_result($result);
if ($thrd[0] == "O") {
$topic = strip_tags($topic);
$post = nl2br($post);
@mysql_query("INSERT INTO uo_chat_threads SET chat='$chatpath',id='$pid',utime='".(time())."',topic='".
mysql_escape_string($topic)."',post='".
mysql_escape_string($post)."',username='".
mysql_escape_string($username)."'", $handler);
@mysql_query("UPDATE uo_chat_boards SET utime='".(time())."' WHERE chat='$chatpath' AND uid='$pid'", $handler);
} else
echo "Thread Closed";
echo "...Return...";
}
function DoEdit($chatpath, $pid, $topic, $post, $username, $password, $timer) {
global $handler, $jbbc;
include("../../common/helpers.php");
$result = @mysql_query("SELECT username FROM uo_chat_threads WHERE chat='$chatpath' AND id='$pid' AND utime='$timer'", $handler);
$thrd = mysql_fetch_row($result);
@mysql_free_result($result);
if ($thrd[0] == $username) {
$etype = ", author.";
$userflags = ChatVerifyLogin($thrd[0], $password, $chatpath);
} else {
$userflags = ChatVerifyLogin($username, $password, $chatpath);
if (CheckFlags("xXZmM", $userflags))
$etype = ", moderative.";
else
$userflags = -1;
}
if ($userflags != -1) {
$result = @mysql_query("SELECT flags FROM uo_chat_boards WHERE chat='$chatpath' AND uid='$pid'", $handler);
$thrd = mysql_fetch_row($result);
@mysql_free_result($result);
if (($thrd[0] == "O") || (CheckFlags("xXZmM", $userflags))) {
$topic = strip_tags($topic);
$post = explode("\n", $post);
$last = array_pop($post);
if (!strstr($last, "Edited "))
array_push($post, $last);
else
array_pop($post);
$post = implode("\n", $post);
$post .= "\n\nEdited ".(date("g:ia, F d, Y", time()))." by ".(htmlentities(ucwords($username)))."$etype";
$post = nl2br($post);
@mysql_query("UPDATE uo_chat_threads SET post='".
mysql_escape_string($post)."',topic='".
mysql_escape_string($topic)."' WHERE chat='$chatpath' AND id='$pid' AND utime='$timer'", $handler);
//@mysql_query("UPDATE uo_chat_boards SET utime='".(time())."' WHERE chat='$chatpath' AND id='$pid'", $handler);
} else
echo "Thread Closed";
} else
echo "False Login";
echo "...Return...";
}
function DoMod($chatpath, $pid, $username, $password, $act) {
global $handler, $jbbc;
include("../../common/helpers.php");
$userflag = ChatVerifyLogin($username, $password, $chatpath);
if (CheckFlags("xXZmM",$userflag)) {
@mysql_query("UPDATE uo_chat_boards SET flags='$act' WHERE chat='$chatpath' AND uid='$pid'", $handler);
echo "...Return...";
} else {
echo "False Login";
}
}
function DoDelete($chatpath, $pid, $username, $password) {
global $handler, $jbbc;
include("../../common/helpers.php");
$userflag = ChatVerifyLogin($username, $password, $chatpath);
if (CheckFlags("xXZmM",$userflag)) {
@mysql_query("DELETE FROM uo_chat_boards WHERE chat='$chatpath' AND uid='$pid'", $handler);
@mysql_query("DELETE FROM uo_chat_threads WHERE chat='$chatpath' AND id='$pid'", $handler);
echo "...Return...";
} else {
echo "False Login";
}
}
function DoDeletePost($chatpath, $pid, $eid, $username, $password) {
global $handler, $jbbc;
include("../../common/helpers.php");
$userflag = ChatVerifyLogin($username, $password, $chatpath);
if (CheckFlags("xXZmM",$userflag)) {
@mysql_query("DELETE FROM uo_chat_threads WHERE chat='$chatpath' AND id='$pid' AND utime='$eid'", $handler);
echo "...Return...";
} else {
echo "False Login";
}
}
function DoCreate($chatpath, $topic, $post, $username, $password) {
global $handler, $jbblock, $jbbc;
include("../../common/helpers.php");
$userlevel = ChatVerifyLogin($username, $password, $chatpath);
if ($userlevel == -1) {
$username = "Impersonating $username";
$userlevel = 0;
}
if (($jbblock > 0) && (!$userlevel)) {
echo "This board can only be used by members of the chat.
";
echo "...Return...";
return 0;
}
$topic = strip_tags($topic);
if ($topic == "")
$topic = "No Topic";
$post = nl2br($post);
if ($post == "")
$post = "No Post";
@mysql_query("INSERT INTO uo_chat_boards SET chat='$chatpath',flags='O',utime='".(time())."',topic='".
mysql_escape_string($topic)."',username='".
mysql_escape_string($username)."',ctime='".(time())."'", $handler);
$pid = @mysql_insert_id($handler);
@mysql_query("INSERT INTO uo_chat_threads SET chat='$chatpath',id='$pid',utime='".(time())."',topic='".
mysql_escape_string($topic)."',post='".
mysql_escape_string($post)."',username='".
mysql_escape_string($username)."'", $handler);
echo "Thread ".htmlentities($topic)." created with ID $pid.\n...Return... ";
}
function DoSearch($chatpath, $phrase, $src_topic, $src_body, $src_auth, $maxfind) {
global $handler, $jbbc;
echo "...$chatpath, $phrase, $src_topic, $src_body, $src_auth, $maxfind";
if ($phrase != "") {
$phrase = mysql_escape_string($phrase);
if ($src_topic == "on") {
echo "Topics
\n";
echo "| Topic | Author | Posts | Last Post (".date("T").") | \n";
$found=0;
$result = mysql_query("SELECT uid,topic,username,utime FROM uo_chat_boards WHERE chat='$chatpath' AND topic LIKE '%$phrase%' ORDER BY utime DESC", $handler);
while(($thread = mysql_fetch_row($result)) && ($found < $maxfind)) {
$found++;
$post = mysql_query("SELECT count(id) FROM uo_chat_threads WHERE chat='$chatpath' AND id='$thread[0]'", $handler);
$posts = mysql_fetch_row($post);
$posts = $posts[0];
@mysql_free_result($post);
echo "| ".(($thread[1] == "") ? ("No Topic") : ($thread[1]))." | ".htmlentities(ucwords($thread[2]))." | $posts | ".(date("g:ia, F d, Y", $thread[3]))." | \n";
}
@mysql_free_result($result);
echo " \n";
}
if ($src_body == "on") {
echo "Bodies
\n";
echo "| Topic | Author | Posts | Last Post (".date("T").") | \n";
$found=0;
$result = mysql_query("SELECT id,topic,username,utime FROM uo_chat_threads WHERE chat='$chatpath' AND post LIKE '%$phrase%' ORDER BY utime DESC", $handler);
while(($thread = mysql_fetch_row($result)) && ($found < $maxfind)) {
$found++;
$post = mysql_query("SELECT count(id) FROM uo_chat_threads WHERE chat='$chatpath' AND id='$thread[0]'", $handler);
$posts = mysql_fetch_row($post);
$posts = $posts[0];
@mysql_free_result($post);
echo "| ".(($thread[1] == "") ? ("No Topic") : ($thread[1]))." | ".htmlentities(ucwords($thread[2]))." | $posts | ".(date("g:ia, F d, Y", $thread[3]))." | \n";
}
@mysql_free_result($result);
echo " \n";
}
if ($src_auth == "on") {
echo "Authors
\n";
echo "| Topic | Author | Posts | Last Post (".date("T").") | \n";
$found=0;
$result = mysql_query("SELECT id,topic,username,utime FROM uo_chat_threads WHERE chat='$chatpath' AND username LIKE '%$phrase%' ORDER BY utime DESC", $handler);
while(($thread = mysql_fetch_row($result)) && ($found < $maxfind)) {
$found++;
$post = mysql_query("SELECT count(id) FROM uo_chat_threads WHERE chat='$chatpath' AND id='$thread[0]'", $handler);
$posts = mysql_fetch_row($post);
$posts = $posts[0];
@mysql_free_result($post);
echo "| ".(($thread[1] == "") ? ("No Topic") : ($thread[1]))." | ".htmlentities(ucwords($thread[2]))." | $posts | ".(date("g:ia, F d, Y", $thread[3]))." | \n";
}
@mysql_free_result($result);
echo " \n";
}
} else
echo "Search phrase empty.";
}
$cookiedata = explode("*", $_COOKIE['pJJChat']);
if ($cookiedata[0] == "on") {
$cookuser = $cookiedata[2];
$cookpass = $cookiedata[3];
}
$username = trim($_REQUEST['username']);
if ($username == "")
$username = "Anonymous";
if ($_REQUEST['act'] == "xmod")
DoEdit($chatpath, $_REQUEST['pid'], $_REQUEST['topic'], $_REQUEST['post'], $username, $_REQUEST['password'], $_REQUEST['utime']);
else if ($_REQUEST['act'] == "mod")
ShowEditBox($chatpath, $_REQUEST['pid'], $cookuser, $cookpass, $_REQUEST['utime']);
else if ($_REQUEST['act'] == "xsrc")
DoSearch($chatpath, $_REQUEST['phrase'], $_REQUEST['src_topic'], $_REQUEST['src_body'], $_REQUEST['src_auth'], $_REQUEST['maxfind']);
else if ($_REQUEST['act'] == "src")
ShowSearchBox($chatpath);
else if ($_REQUEST['act'] == "xpdel")
DoDeletePost($chatpath, $_REQUEST['pid'], $_REQUEST['eid'], $username, $_REQUEST['password']);
else if ($_REQUEST['act'] == "pdel")
ShowModBox($chatpath, $_REQUEST['pid'], "xpdel", "Delete Post", $cookuser, $cookpass, $_REQUEST['eid']);
else if ($_REQUEST['act'] == "xdel")
DoDelete($chatpath, $_REQUEST['pid'], $username, $_REQUEST['password']);
else if ($_REQUEST['act'] == "del")
ShowModBox($chatpath, $_REQUEST['pid'], "xdel", "Delete", $cookuser, $cookpass);
else if ($_REQUEST['act'] == "xopn")
DoMod($chatpath, $_REQUEST['pid'], $username, $_REQUEST['password'], "O");
else if ($_REQUEST['act'] == "opn")
ShowModBox($chatpath, $_REQUEST['pid'], "xopn", "Open", $cookuser, $cookpass);
else if ($_REQUEST['act'] == "xcls")
DoMod($chatpath, $_REQUEST['pid'], $username, $_REQUEST['password'], "C");
else if ($_REQUEST['act'] == "cls")
ShowModBox($chatpath, $_REQUEST['pid'], "xcls", "Close", $cookuser, $cookpass);
else if ($_REQUEST['act'] == "xnew")
DoCreate($chatpath, $_REQUEST['topic'], $_REQUEST['post'], $username, $_REQUEST['password']);
else if ($_REQUEST['act'] == "xrep")
DoReply($chatpath, $_REQUEST['pid'], $_REQUEST['topic'], $_REQUEST['post'], $username, $_REQUEST['password']);
else if ($_REQUEST['act'] == "rep")
ShowReplyCreateBox($chatpath, $_REQUEST['pid'], "xrep", "Reply", 1, $cookuser, $cookpass);
else if ($_REQUEST['act'] == "new")
ShowReplyCreateBox($chatpath, $_REQUEST['pid'], "xnew", "Create", 0, $cookuser, $cookpass);
else if ($_REQUEST['pid'])
ShowPosts($chatpath, $_REQUEST['pid']);
else
ShowThreads($chatpath);
?>
|
|