$forums[name]
Post Topic | Home
";
echo "
Chat Codes
| Title |
Posted By |
Replies |
";
$select = mysql_query("SELECT * FROM forum_topics WHERE stuck = '1' AND forum = '$forums[id]' ORDER BY lastpost DESC");
while($stucktopics = mysql_fetch_array($select)) {
$sel = mysql_query("SELECT username,ID FROM user WHERE id = '$stucktopics[poster]'");
$poster = mysql_fetch_array($sel);
$topi = strip_tags($stucktopics[topic]);
$sel = mysql_query("SELECT id FROM forum_reply WHERE topic = '$stucktopics[id]'");
$num = mysql_num_rows($sel);
if(!$num) {
$num = "None!";
}
if($stucktopics[locked]) {
$a = "[";
$b = "]";
}
echo "
|
|
$num |
";
$a = "";
$b = "";
}
$select = mysql_query("SELECT * FROM forum_topics WHERE stuck = '0' AND forum = '$forums[id]' ORDER BY lastpost DESC LIMIT 35");
while($topics = mysql_fetch_array($select)) {
$sel = mysql_query("SELECT username,ID FROM user WHERE id = '$topics[poster]'");
$poster = mysql_fetch_array($sel);
$topii = strip_tags($topics[topic]);
$sel = mysql_query("SELECT id FROM forum_reply WHERE topic = '$topics[id]'");
$num = mysql_num_rows($sel);
if(!$num) {
$num = "None!";
}
if($topics[locked]) {
$a = "[";
$b = "]";
}
echo "
|
|
$num |
";
$a = "";
$b = "";
}
echo "
";
}
if($page == "viewpost") {
echo "";
$select = mysql_query("SELECT * FROM forum_topics WHERE id = '$pid'");
$num = mysql_num_rows($select);
$post = mysql_fetch_array($select);
$select = mysql_query("SELECT id,name FROM forums WHERE id = '$post[forum]'");
$forum = mysql_fetch_array($select);
$select = mysql_query("SELECT * FROM user WHERE ID = '$post[poster]'");
$usr = mysql_fetch_array($select);
$message = filter($post[message], 1);
$sig = filter($usr[sig], 1);
if($userlevel2 == 2) {
if(!$post[locked]) {
$lock = "
";
} else {
$lock = "
";
}
$options = "
$lock";
}
if($userlevel2 >= 3) {
if(!$post[locked]) {
$lock = "
";
} else {
$lock = "
";
}
if(!$post[stuck]) {
$stuck = "
";
} else {
$stuck = "
";
}
$options = "
" . $stuck . $lock;
}
$select = mysql_query("SELECT image,alt FROM avatars WHERE id = '$usr[avatar]'");
$avatarinf = mysql_fetch_array($select);
$avatar = $avatarinf[image];
$avatartext = $avatarinf[alt];
$topi = strip_tags($post[topic]);
echo "
";
echo "
$usr[usertitle]
Posts: $usr[postcount]
$reply[time]
$options
";
$select = mysql_query("SELECT * FROM forum_reply WHERE topic = '$post[id]' ORDER BY id ASC");
while ($reply = mysql_fetch_array($select)) {
if($userlevel2 == 2) {
$option = "
";
}
if($userlevel2 >= 3) {
$option = "
";
}
$sel = mysql_query("SELECT * FROM user WHERE id = '$reply[poster]'");
$usrr = mysql_fetch_array($sel);
$message = filter($reply[message], 1);
$sig = filter($usrr[sig], 1);
$sel = mysql_query("SELECT image,alt FROM avatars WHERE id = '$usrr[avatar]'");
$avatarinf = mysql_fetch_array($sel);
$avatar = $avatarinf[image];
$avatartext = $avatarinf[alt];
echo "
$usrr[usertitle]
Posts: $usrr[postcount]
$reply[time]
$option
";
}
if(!$post[locked]) {
echo "
";
}
}
if($page == "newtopic") {
if(!$forumid) {
$forumid = 1;
}
echo "
";
}
if($page == "postnewpro") {
$pid = $_POST['id'];
$topic = $_POST['topic'];
$message = $_POST['message'];
$stuck = $_POST['stuck'];
$locked = $_POST['locked'];
$select = mysql_query("SELECT id,stat FROM forums WHERE id = '$pid'");
$num = mysql_num_rows($select);
if(!$num) {
kerror("Error - The forum you want to post in does not exist.");
}
$forum = mysql_fetch_array($select);
if($forum[stat] > $userlevel2) {
kerror("Not sufficent userlevel");
}
if(!$topic) {
kerror("You forgot to enter a topic.");
}
if(!$message) {
kerror("You forgot to enter a message.");
}
//$thing = $user_data[lastpost] + 5;
if(!$locked) {
$locked = 0;
}
if(!$stuck) {
$stuck = 0;
}
$s2 = mysql_query("SELECT * FROM user WHERE username = '$YourName'");
$info = mysql_fetch_array($s2);
$lasttopic = $info[lasttopic];
$lasttopic2 = time()-$lasttopic;
if ($lasttopic!="") {
if($lasttopic2 < 60) {
kerrror("You must wait 1 minute before making a new topic!");
}
}
mysql_query("INSERT INTO forum_topics (topic,message,poster,time,lastpost,forum,stuck,locked) VALUES ('$topic','$message','$id','$date
$time','$timeofu','$forum[id]','$stuck','$locked')") or die("Error - " . mysql_error());
mysql_query("UPDATE user SET postcount = postcount+1 WHERE username = '$YourName'");
mysql_query("UPDATE user SET lasttopic = time() WHERE username = '$YourName'");
header("location: $PHP_SELF?page=viewforum&pid=$forum[id]");
die;
}
if($page == "reply") {
refered("forums.php");
$message = $_POST['message'];
$topic = $_POST['topic'];
$forum = $_POST['forum'];
$select = mysql_query("SELECT id,locked FROM forum_topics WHERE id = '$topic'");
$numtop = mysql_num_rows($select);
$topinf = mysql_fetch_array($select);
$select = mysql_query("SELECT id,stat FROM forums WHERE id = '$forum'");
$numfor = mysql_num_rows($select);
$for = mysql_fetch_array($select);
if(!$numfor) {
kerror("The thread you are trying to post on does not exist.");
}
if($for[stat] > $userlevel2) {
kerror("Oh, just go to hell, wiseass.");
}
if(!$numtop) {
kerror("That topic does not exist!");
}
if($topinf[locked]) {
kerror("That topic is locked!");
}
$s2 = mysql_query("SELECT * FROM user WHERE username = '$YourName'");
$info = mysql_fetch_array($s2);
$lastpost = $info[lastpost];
if ($lastpost!="") {
if(($lastpost+30) <= time()) {
kerrror("You must wait 30 seconds before making a new post!");
}
}
mysql_query("INSERT INTO forum_reply (message,time,poster,topic) VALUES ('$message','$date
$time','$id','$topic')") or die("Error - " . mysql_error());
mysql_query("UPDATE forum_topics SET lastpost = '$timeofu' WHERE id = '$topic'") or die("ERROR!");
mysql_query("UPDATE user SET lastpost = '$timeofu' WHERE id = '$id'");
mysql_query("UPDATE user SET postcount = postcount+1 WHERE username = '$YourName'");
mysql_query("UPDATE user SET lastpost = time() WHERE username = '$YourName'");
header("location: $PHP_SELF?page=viewpost&pid=$topic");
die;
}
if($userlevel2 >= 2) {
if($page == "deletetop") {
$select = mysql_query("SELECT poster FROM forum_topics WHERE id = '$topic'");
$num = mysql_num_rows($select);
$top = mysql_fetch_array($select);
if(!$num) {
kerror("No such topic.");
}
mysql_query("INSERT INTO deletelog (staff,poster,wen,type) VALUES ('$id','$top[poster]','$date $time','topic')");
mysql_query("DELETE FROM forum_topics WHERE id = '$topic'");
mysql_query("DELETE FROM forum_reply WHERE topic = '$topic'");
mysql_query("UPDATE user SET postcount = postcount-1 WHERE id = '$top[poster]'");
header("location: $PHP_SELF?page=viewforum&pid=$forum[id]");
}
if($page == "deleterep") {
$select = mysql_query("SELECT poster FROM forum_reply WHERE id = '$reply'");
$num = mysql_num_rows($select);
$top = mysql_fetch_array($select);
if(!$num) {
kerror("No such topic.");
}
mysql_query("UPDATE user SET postcount = postcount-1 WHERE id = '$top[poster]'");
mysql_query("INSERT INTO deletelog (staff,poster,wen,type) VALUES ('$id','$top[poster]','$date $time','reply')");
mysql_query("DELETE FROM forum_reply WHERE id = '$reply'");
header("location: $PHP_SELF?page=viewpost&pid=$post");
}
if($page == "lock") {
$select = mysql_query("SELECT id FROM forum_topics WHERE id = '$topic'");
$num = mysql_num_rows($select);
if(!$num) {
kerror("No such topic.");
}
mysql_query("UPDATE forum_topics SET locked = '1' WHERE id = '$topic'");
header("location: $PHP_SELF?page=viewpost&pid=$topic");
}
if($page == "unlock") {
$select = mysql_query("SELECT id FROM forum_topics WHERE id = '$topic'");
$num = mysql_num_rows($select);
if(!$num) {
kerror("No such topic.");
}
mysql_query("UPDATE forum_topics SET locked = '0' WHERE id = '$topic'");
header("location: $PHP_SELF?page=viewpost&pid=$topic");
}
}
if($userlevel2 >= 3) {
if($page == "edittop") {
$select = mysql_query("SELECT * FROM forum_topics WHERE id = '$topic'");
$num = mysql_num_rows($select);
$top = mysql_fetch_array($select);
if(!$num) {
kerror("No such topic.");
}
echo "
";
}
if($page == "edittoppro") {
$topicid = $_POST['topicid'];
$topic = $_POST['topic'];
$message = $_POST['message'];
if(!$topic) {
kerror("You can't leave the topic blank.");
}
if(!$message) {
kerror("You can't leave the message blank.");
}
mysql_query("UPDATE forum_topics SET topic = '$topic' WHERE id = '$topicid'");
mysql_query("UPDATE forum_topics SET message = '$message' WHERE id = '$topicid'");
header("location: $PHP_SELF?page=viewpost&pid=$topicid");
die;
}
if($page == "editrep") {
$select = mysql_query("SELECT * FROM forum_reply WHERE id = '$reply'");
$num = mysql_num_rows($select);
$rep = mysql_fetch_array($select);
if(!$num) {
kerror("No such reply.");
}
echo "
";
}
if($page == "editreppro") {
$topic = $_POST['topic'];
$reply = $_POST['reply'];
$message = $_POST['message'];
if(!$message) {
kerror("You can't leave the message blank.");
}
mysql_query("UPDATE forum_reply SET message = '$message' WHERE id = '$reply'");
header("location: $PHP_SELF?page=viewpost&pid=$topic");
die;
}
if($page == "stick") {
$select = mysql_query("SELECT id FROM forum_topics WHERE id = '$topic'");
$num = mysql_num_rows($select);
if(!$num) {
kerror("No such topic.");
}
mysql_query("UPDATE forum_topics SET stuck = '1' WHERE id = '$topic'");
header("location: $PHP_SELF?page=viewpost&pid=$topic");
}
if($page == "unstick") {
$select = mysql_query("SELECT id FROM forum_topics WHERE id = '$topic'");
$num = mysql_num_rows($select);
if(!$num) {
kerror("No such topic.");
}
mysql_query("UPDATE forum_topics SET stuck = '0' WHERE id = '$topic'");
header("location: $PHP_SELF?page=viewpost&pid=$topic");
die;
}
}