startheaders(); include "mysql.php"; global $c; $is=mysql_query("SELECT u.*,us.* FROM users u LEFT JOIN userstats us ON u.userid=us.userid WHERE u.userid=$userid",$c) or die(mysql_error()); $ir=mysql_fetch_array($is); check_level(); $fm=money_formatter($ir['money']); $cm=money_formatter($ir['credits'],''); $lv=date('F j, Y, g:i a',$ir['laston']); $h->userdata($ir,$lv,$fm,$cm); $h->menuarea(); case "forums": forums(); break; function forums() { $_GET['topic'] = abs((int) $_GET['topic']); $_GET['reply'] = abs((int) $_GET['reply']); $_GET['t'] = abs((int) $_GET['t']); global $ir,$c,$userid,$data; if($_GET['topic']) { $_GET['act2']="viewtopic"; $_GET['t']=$_GET['topic']; } if($_GET['reply']) { $_GET['act2']="reply"; $_GET['t']=$_GET['reply']; } switch($_GET['act2']) { case "viewtopic": forums_viewtopic(); break; case "reply": forums_reply(); break; case "newtopicform": forums_newt_form(); break; case "newtopicsub": forums_newt_sub(); break; default: forums_idx(); break; } } function forums_idx() { global $ir,$c,$userid,$data; print "Welcome to Ruined City forums! [Start New Topic]
"; $tpcs=mysql_query("SELECT t.*,u1.username as startername,u2.username as lastpostername FROM forums_topics t LEFT JOIN users u1 ON t.ft_userid=u1.userid LEFT JOIN users u2 ON t.ft_lastposterid=u2.userid WHERE t.ft_id={$data['ID']} ORDER BY t.ft_lastpost DESC",$c); while($t=mysql_fetch_array($tpcs)) { print ""; } print "

Topic	Starter	Replies	Views	Last Post
{$t['ft_title']}	{$t['startername']}	{$t['ft_replies']}	{$t['ft_views']}	"; print date('F j Y, g:i:s a',$t['ft_lastpost']); print " By: {$t['lastpostername']}

"; } function forums_viewtopic() { global $ir,$c,$userid,$data; $tpcd=mysql_query("SELECT t.*,u1.* FROM forums_topics t LEFT JOIN users u1 ON t.ft_userid=u1.userid WHERE t.ft_id={$_GET['t']}",$c); mysql_query("UPDATE forums_topics SET ft_views=ft_views+1 WHERE ft_id={$_GET['t']}",$c); $topic=mysql_fetch_array($tpcd); $posts[0]['username']=$topic['username']; $posts[0]['userid']=$topic['userid']; $posts[0]['time']=$topic['ft_starttime']; $posts[0]['level']=$topic['level']; $posts[0]['nr']=1; $posts[0]['text']=str_replace("\n","
",$topic['ft_text']); $cntr=0; $pq=mysql_query("SELECT r.*,u.* FROM forums_replies r LEFT JOIN users u ON r.fr_userid=u.userid WHERE r.fr_topic={$_GET['t']} ORDER BY fr_posttime ASC;",$c); while($r=mysql_fetch_array($pq)) { $cntr++; $posts[$cntr]['username']=$r['username']; $posts[$cntr]['userid']=$r['userid']; $posts[$cntr]['time']=$r['fr_posttime']; $posts[$cntr]['level']=$r['level']; $posts[$cntr]['nr']=$cntr+1; $posts[$cntr]['text']=str_replace("\n","
",$r['fr_text']); } print ""; foreach($posts as $cpost) { print ""; } print "

{$topic['ft_title']}
Post #{$cpost['nr']}	Time Posted: ".date('F j Y, g:i:s a',$cpost['time'])."
{$cpost['username']} Level: {$cpost['level']}	{$cpost['text']}

"; print "
"; print "

Add Reply
Your Post: (no HTML, linebreaks automatically converted to <br />)

"; } function forums_reply() { global $ir,$c,$userid,$data; $t=$_GET['t']; $post=str_replace(array("<",">","'"),array("<",">","''"),$_POST['textpost']); mysql_query("INSERT INTO forums_replies VALUES('',$userid,{$data['ID']},$t,'$post',unix_timestamp())",$c); mysql_query("UPDATE forums_topics SET ft_replies=ft_replies+1,ft_lastpost=unix_timestamp(),ft_lastposterid=$userid WHERE ft_id=$t",$c); print "

News
Reply Posted!

"; forums_viewtopic(); } function forums_newt_form() { global $ir,$c,$userid,$data; print "Creating New Topic....

Title:
Your Topic: (no HTML, linebreaks automatically converted to <br />)

"; } function forums_newt_sub() { global $ir,$c,$userid,$data; $title=str_replace(array("<",">","'"),array("<",">","''"),$_POST['topictitle']); $post=str_replace(array("<",">","'"),array("<",">","''"),$_POST['topictext']); mysql_query("INSERT INTO forums_topics VALUES('',$userid,{$data['ID']},'$title','$post',0,0,unix_timestamp(),$userid, unix_timestamp())",$c); $iq=mysql_query("SELECT max(ft_id) AS tid FROM forums_topics",$c); $iee=mysql_fetch_array($iq); print "

News
Topic Posted!

"; $_GET['t']=$iee['tid']; forums_viewtopic(); } $h->endpage(); ?>