Jump to content

yuws

Members
 View Profile  See their activity

  • Posts

    37

  • Joined

  • Last visited

    Never

Profile Information

  • Gender
    Not Telling

yuws's Achievements

Newbie

Newbie (1/5)

0

Reputation

  1. yuws
    bump
  2. yuws
    ?????
  3. yuws
    im releasing site soon i need the help fast please help.
  4. yuws
    Help please its urgent!
  5. yuws
    someone help please!
  6. yuws
    Well im trying to connect with php sockets to show data. Here's my code.. <?php include("inc/db.php"); include("inc/terms.php"); if ($_COOKIE['agreed'] == $agreement) { function checkonline($ext) { $address = $ext."no-ip.com"; $churl = @fsockopen($address, 43594, $errno, $errstr, 1); if ($churl) return 0; else return 1; } function socket_raw_connect($ext) { $socket = @fsockopen($ext.".no-ip.com", 43597, $errno, $errstr, 1); $ret = 0; if($socket) { while (!@feof($socket)) { $ret += @fgets($socket, 4096); } } else if(!$socket){ $ret = 0; } return $ret; @fclose($socket); } function e($w,$m,$s,$h,$p,$l) { $r = 0; $lt = "us"; $lte = "Unknown"; if ($r==0) { echo "<tr>"; $r=1; } else { echo "<tr class=r2>"; $r=0; } echo "<td class=".($m==0?"f":"m").">"; if($s==0) echo "<a href=\"play.php?ext=".$h."\">"."World ".$w."</a>"; else echo "World ".$w; echo "</td>"; if($l == 1){ $lt = "us"; $lte = "US Central 1";} if($s == 1) $pop = $p." Players"; if($s == 0) $pop = "OFFLINE"; if($s == 2) $pop = "FULL"; echo "<td>".$pop."</td>"; echo "<td class=\"".$lt."\">".$lte."</td>"; echo "<td class=".($m==0?"f>Free":"m>Members")."</td>"; echo "</tr>"; } ?> <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd"> <html xmlns:IE> <head> <meta http-equiv="Expires" content="0"> <meta http-equiv="Pragma" content="no-cache"> <meta http-equiv="Cache-Control" content="no-cache"> <meta name="MSSmartTagsPreventParsing" content="TRUE"> <title>Funified - the massive online adventure game</title> <link href="http://funified.com/css/basic.css" rel="stylesheet" type="text/css" media="all"> <link href="http://funified.com/css/server.css" rel="stylesheet" type="text/css" media="all"> </head> <body> <div id="body"> <div class="server_list" align="center"> <div style="text-align: center; background: none;"> <div class="titleframe e"> <b>Select a world</b><br> <a href="http://funified.com/index.php" class=c>Home</a> </div> </div> <br> <div class="e" style="width: 601px; text-align: center;"> <h1>Quick select (Recommended)</h1> This will choose the best world for you based on available space and your location. <div class="text"> <div id="top-text-left">(Free world)</div> <div id="top-text-right">(Members world)</div> </div> <div class="buttons"> <div class="button" id="button-left"> <a href="play.php?ext=w2" class="button"><span class="lev_1"><span>(World 2)</span></span><br><br>Choose best free world for me</a> </div> <div class="button" id="button-right"> <a href="play.php?ext=w1" class="button"><span class="lev_1"><span>(World 1)</span></span><br><br>Choose best members only world for me</a> </div> </div> </div> <br> <div class="e" style="width: 601px; text-align: center;"> <h1>Advanced select (For experienced players)</h1> If there is a particular world that you want to use, choose it by clicking on its name.<br>You can reorder the list by clicking on the arrows. <table class="server" cellpadding="3" cellspacing="0"> <tr class="slist_header"> <td style="border-left: 2px solid #8E7246"> <a href="list.php?order=wMLP"><img src="http://funified.com/images/serverlist/arrow_up.gif" alt="(^)"></a> <a href="list.php?order=WMLP"><img src="http://funified.com/images/serverlist/arrow_down.gif" alt="(v)"></a> World </td> <td> <a href="list.php?order=pMLW"><img src="http://funified.com/images/serverlist/arrow_up.gif" alt="(^)"></a> <a href="list.php?order=PMLW"><img src="http://funified.com/images/serverlist/arrow_down.gif" alt="(v)"></a> Players </td> <td> <a href="list.php?order=lMPW"><img src="http://funified.com/images/serverlist/arrow_up.gif" alt="(^)"></a> <a href="list.php?order=LMPW"><img src="http://funified.com/images/serverlist/arrow_down.gif" alt="(v)"></a> Location (by distance) </td> <td style="border-right: 2px solid black"> <a href="list.php?order=mLPW"><img src="http://funified.com/images/serverlist/arrow_up.gif" alt="(^)"></a> <a href="list.php?order=MLPW"><img src="http://funified.com/images/serverlist/arrow_down.gif" alt="[v]"></a> Type </td> </tr> <?php $ListQuery = mysql_query("SELECT * FROM `servers`") or die(mysql_error()); while($List = mysql_fetch_array($ListQuery)) { $h = $List['h']; $m = $List['m']; $w = $List['w']; $s = checkonline($h); $p = 0; if($s == 1) $p = socket_raw_connect($h); $l = $List['l']; if($p == 2000) $s = 2; e($w,$m,$s,$h,$p,$l); //echo $h.$m.$w.$s.$p."!".$l; } ?> </table> </div> </div> </div> </body> </html> <?php } ?> There's something wrong with function checkonline($ext) { $address = $ext."no-ip.com"; $churl = @fsockopen($address, 43594, $errno, $errstr, 1); if ($churl) return 0; else return 1; } function socket_raw_connect($ext) { $socket = @fsockopen($ext.".no-ip.com", 43597, $errno, $errstr, 1); $ret = 0; if($socket) { while (!@feof($socket)) { $ret += @fgets($socket, 4096); } } else if(!$socket){ $ret = 0; } return $ret; @fclose($socket); } in my servers data base 'h' is funified funified.no-ip.org is my ip. i need help connecting!
  7. yuws

    Forums topic

    yuws replied to yuws's topic in PHP Coding Help

    i made this over a year ago, by knowledge in php is far gone atm. If you can help me out i will give you full credits. possibly funds also, talk on msn please.
  8. yuws

    whats wrong?

    yuws replied to yuws's topic in PHP Coding Help

    ok i fixed it, thanks alot man! your the best, mind looking at my other topic? can you go on msn? i added you.
  9. yuws

    Forums topic

    yuws replied to yuws's topic in PHP Coding Help

    anyone? i really need help!
  10. yuws

    whats wrong?

    yuws replied to yuws's topic in PHP Coding Help

    nope errors <?php include("db.php"); $query = mysql_query("SELECT * FROM general WHERE lin = 1"); $loggedin = 0; while ($row = mysql_fetch_array($query)) { $loggedin++; } echo number_format($loggedin, 0); ?> Warning: Unexpected character in input: '\' (ASCII=92) state=1 in /home/funified/public_html/inc/playersonline.php on line 4 Parse error: syntax error, unexpected T_STRING in /home/funified/public_html/inc/playersonline.php on line 4
  11. yuws
    what's wrong with this code i keep getting this error! Warning: Unexpected character in input: '\' (ASCII=92) state=1 in /home/funified/public_html/inc/playersonline.php on line 2 Parse error: syntax error, unexpected T_STRING in /home/funified/public_html/inc/playersonline.php on line 2 Here's the code: <?php $query = mysql_query('SELECT * FROM general WHERE lin = 1'); $loggedin = 0; while ($row = mysql_fetch_array($query)) { $loggedin++; } echo "$loggedin"; ?>
  12. yuws
    Hi, im making a custom forums, and ive been having some problems. Here is the code for viewing posts <?php include('mysql.php'); ?> <?php if (isset($_GET['p'])) { $topic = $_GET['p']; } else { $topic = 1; } $tnamequery = 'SELECT * FROM `[f]topic` WHERE `num` = \''.$topic.'\''; $tnameresult = mysql_query($tnamequery); while ($tnamerow = @mysql_fetch_assoc($tnameresult)) { $forumnum = $tnamerow['forum']; $topicname = $tnamerow['name']; } $fnamequery = 'SELECT * FROM `[f]forums` WHERE `num` = \''.$forumnum.'\''; $fnameresult = mysql_query($fnamequery); while ($fnamerow = @mysql_fetch_assoc($fnameresult)) { $catnum = $fnamerow['cat']; $forumname = $fnamerow['name']; } $cnamequery = 'SELECT * FROM `[f]cats` WHERE `num` = \''.$catnum.'\''; $cnameresult = mysql_query($cnamequery); while ($cnamerow = @mysql_fetch_assoc($cnameresult)) { $catname = $cnamerow['name']; } $findertext = ' <a href=viewforum.php?f='.$forumnum.'>'.$forumname.'</a> > <a href="viewpost.php?p='.$topic.'">'.$topicname.'</a>'; ?> <?php include('header.php'); ?> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <?php // Check how many pages to make $postcount = 0; $pagecount = 0; $countquery = 'SELECT * FROM `[f]post` WHERE `topic` = \''.$topic.'\' ORDER BY `num` ASC'; $countresult = mysql_query($countquery); while ($countrow = @mysql_fetch_assoc($countresult)) { $postcount++; } $pagecount = ceil($postcount/10); if ($pagecount == 0) { $pagecount = 1; } // Now set page if (isset($_GET['pg'])) { $page = $_GET['pg']; } else { $page = 1; } if(isset($_COOKIE['rs_usr'])) { $reply = '<img src="ico/reply.gif" /> <a href="post.php?t='.$topic.'">Reply</a> '; } echo ' <tr bgcolor="#000000"> <td colspan="1" class="brown-left">Page <b>'.$page.'</b> of <b>'.$pagecount.' </td> <td colspan="1" class="brown-right" align="right">'.$reply.' <img src="ico/refresh.gif" width="15" height="15" /><a href="'.$_SERVER['PHP_SELF'].'?p='.$_GET['p'].'"> Refresh</a></td> </tr><tr><td colspan="2"> </td>'; $postquery = 'SELECT * FROM `[f]topic` WHERE `num` = \''.$topic.'\''; $postresult = mysql_query($postquery); while ($postrow = @mysql_fetch_assoc($postresult)) { $userquery = 'SELECT * FROM `players` WHERE `username` = \''.$postrow['username'].'\''; $userresult = mysql_query($userquery); while ($userrow = @mysql_fetch_assoc($userresult)) { if ($userrow['donator'] == 1) { $title = '<div class="modtype">Donator</div>'; $icon = '<img src="ico/donator_1.gif" /> '; } if ($userrow['rigts'] == 0) { $bordercolor = "#3f2e0f"; $leftcolor = "#2c200a"; $rightcolor = "#1f1707"; } if ($userrow['rights'] == 1) { $title = '<div class="modtype">Forum Mod</div>'; $icon = '<img src="ico/crown_green.gif" /> '; $bordercolor = "#294729"; $leftcolor = "#092709"; $rightcolor = "#092009"; } if ($userrow['rights'] == 2) { $title = '<div class="modtype">Funified Mod</div>'; $icon = '<img src="ico/crown_gold.gif" /> '; $bordercolor = "#957c07"; $leftcolor = "#645305"; $rightcolor = "#403503"; } if ($userrow['rights'] == 3) { $title = '<div class="modtype">Funified Owner</div>'; $icon = '<img src="ico/crown_gold.gif" /> '; $bordercolor = "#0066CC"; $leftcolor = "#003399"; $rightcolor = "#003366"; } if ($userrow['rights'] == 4) { $title = '<div class="modtype">Funified Co-Owner</div>'; $icon = '<img src="ico/crown_pink.gif" /> '; $bordercolor = "#0066CC"; $leftcolor = "#003399"; $rightcolor = "#003366"; } echo ' <tr> <td width="150" rowspan="2" bgcolor="'.$leftcolor.'" style="border: 4px solid '.$bordercolor.'; border-right: 0px none;" align="center" valign="top">'.$icon.' '.$postrow['username'].'<br />'.$title.'</td> <td align="right" bgcolor="'.$rightcolor.'" style="border-top: 4px solid '.$bordercolor.'; color: #888888; border-right: 4px solid '.$bordercolor.';" valign="top">'.$postrow['date'].'</td> </tr> <tr> <td align="left" bgcolor="'.$rightcolor.'" valign="top" style="border-bottom: 4px solid '.$bordercolor.'; border-right: 4px solid '.$bordercolor.';">'.$postrow['text'].'<br /><br /></td> </tr> <tr> <td colspan="2"> </td> </tr>'; } } $postquery = 'SELECT * FROM `[f]post` WHERE `topic` = \''.$_GET['p'].'\' ORDER BY `num` ASC'; $postresult = mysql_query($postquery); $postlimit = 5; $postnum = -1; while ($postrow = @mysql_fetch_assoc($postresult)) { $postlimit++; $userquery = 'SELECT * FROM `players` WHERE `username` = \''.$postrow['username'].'\''; $userresult = mysql_query($userquery); while ($userrow = @mysql_fetch_assoc($userresult)) { if ($userrow['donator'] == 1) { $title = '<div class="modtype">Donator</div>'; $icon = '<img src="ico/donator_1.gif" /> '; } if ($userrow['rigts'] == 0) { $bordercolor = "#3f2e0f"; $leftcolor = "#2c200a"; $rightcolor = "#1f1707"; } if ($userrow['rights'] == 1) { $title = '<div class="modtype">Forum Mod</div>'; $icon = '<img src="ico/crown_green.gif" /> '; $bordercolor = "#294729"; $leftcolor = "#092709"; $rightcolor = "#092009"; } if ($userrow['rights'] == 2) { $title = '<div class="modtype">Funified Mod</div>'; $icon = '<img src="ico/crown_gold.gif" /> '; $bordercolor = "#8c7a16"; $leftcolor = "#4c4205"; $rightcolor = "#3e3605"; } if ($userrow['rights'] == 3) { $title = '<div class="modtype">Funified Owner</div>'; $icon = '<img src="ico/crown_gold.gif" /> '; $bordercolor = "#0066CC"; $leftcolor = "#003399"; $rightcolor = "#003366"; } if ($userrow['rights'] == 4) { $title = '<div class="modtype">Funified Co-Owner</div>'; $icon = '<img src="ico/crown_pink.gif" /> '; $bordercolor = "#0066CC"; $leftcolor = "#003399"; $rightcolor = "#003366"; } $hidden = $postrow['hidden']; if($hidden == 0){ echo ' <tr> <td width="150" rowspan="2" bgcolor="'.$leftcolor.'" style="border: 4px solid '.$bordercolor.'; border-right: 0px none;" align="center" valign="top">'.$icon.' '.$postrow['username'].'<br />'.$title.'</td> <td align="right" bgcolor="'.$rightcolor.'" style="border-top: 4px solid '.$bordercolor.'; color: #888888; border-right: 4px solid '.$bordercolor.';" valign="top">'.$postrow['date'].'</td> </tr> <tr> <td align="left" bgcolor="'.$rightcolor.'" valign="top" style="border-bottom: 4px solid '.$bordercolor.'; border-right: 4px solid '.$bordercolor.';">'.$postrow['text'].'<br /><br /></td> </tr> <tr> <td colspan="2"> </td> </tr> '; } else { /* $bordercolor = "#3f2e0f"; $leftcolor = "#2c200a"; $rightcolor = "#1f1707"; */ echo ' <tr> <td width="150" rowspan="2" bgcolor="#2c200a" style="border: 4px solid #3f2e0f; border-right: 0px none;" align="center" valign="top"></td> <td align="right" bgcolor="#1f1707" style="border-top: 4px solid #3f2e0f; color: #888888; border-right: 4px solid #3f2e0f;" valign="top">'.$postrow['date'].'</td> </tr> <tr> <td align="left" bgcolor="#1f1707" valign="top" style="border-bottom: 4px solid #3f2e0f; border-right: 4px solid #3f2e0f;">The contents of this message have been hidden<br /><br /></td> </tr> <tr> <td colspan="2"> </td> </tr> '; } } } ?> </table><br /> <center>Quick find code: <?php echo $topic; ?></center> <?php include('footer.php'); ?> Im trying to make it use pages but its not working. If anyone can help me add pages and fix some security problems that would be awesome! http://www.funified.com/forum/funpost.php?p=1070 is an example. If you have msn tell me =D
  13. yuws
    anyone going to help?
  14. yuws
    anyone?
  15. yuws
    Ive been building a custom forums, and i was wondering if anyone would check it over and maybe add security fixes? And also i need help with showing pages for posts/topic, mines bugged. Here is the forum.php file, which is the file that shows the topic. <?php include('mysql.php'); ?> <?php if (isset($_GET['f'])) { $forum = $_GET['f']; } else { $forum = 1; } $fnamequery = 'SELECT * FROM `[f]forums` WHERE `num` = '.$forum.''; $fnameresult = mysql_query($fnamequery); while ($fnamerow = mysql_fetch_assoc($fnameresult)) { $forumname = $fnamerow['name']; $catnum = $fnamerow['cat']; } $cnamequery = 'SELECT * FROM `[f]cats` WHERE `num` = '.$catnum.''; $cnameresult = mysql_query($cnamequery); while ($cnamerow = mysql_fetch_assoc($cnameresult)) { $catname = $cnamerow['name']; } $findertext = '<a href=viewforum.php?f='.$forum.'>'.$forumname.'</a>'; // [save for post] ' > <a href=viewforum.php?f='.$forum.'>'.$forumname.'</a>' ?> <?php include('header.php'); ?> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <tr> <td> </td> <td width="10%" align="center" valign="middle" class="bold">Posts</td> <td width="25%" class="bold">Last Post</td> </tr> <?php // Check how many pages to make $postcount = 0; $pagecount = 0; $countquery = 'SELECT * FROM `[f]topic` WHERE `forum` = '.$forum.' ORDER BY `num` DESC'; $countresult = mysql_query($countquery); while ($countrow = mysql_fetch_assoc($countresult)) { $postcount++; } $pagecount = ceil($postcount/20); if ($pagecount == 0) { $pagecount = 1; } // Now set page if (isset($_GET['p'])) { $page = $_GET['p']; } else { $page = 1; } if(isset($_COOKIE['rs_usr'])) { $userQuery = mysql_query("SELECT `mgroup` FROM `uber3_players` WHERE `name` = '".$_COOKIE['rs_usr']."'") or die(mysql_error()); $userRow = mysql_fetch_array($userQuery); $rights = $userRow['mgroup']; if($forum == 1 && $rights >= 4){ $reply = '<img src="ico/reply.gif" /> <a href="post.php?f='.$forum.'">New Topic</a> '; } else if($forum != 1){ $reply = '<img src="ico/reply.gif" /> <a href="post.php?f='.$forum.'">New Topic</a> '; } } $startpost = ($page - 1) * 20; echo ' <tr bgcolor="#000000"> <td colspan="1" style="border-left: 2px solid #382418; border-top: 2px solid #382418;">Page <b>'.$page.'</b> of <b>'.$pagecount.' </td> <td colspan="2" style="border-right: 2px solid #382418; border-top: 2px solid #382418;" align="right">'.$reply.' <img src="ico/refresh.gif" width="15" height="15" /><a href="'.$_SERVER['PHP_SELF'].'?f='.$_GET['f'].'"> Refresh</a></td> </tr> <tr>'; $forumquery = 'SELECT * FROM `[f]topic` WHERE `forum` = '.$forum.' ORDER BY `num` DESC'; $forumresult = mysql_query($forumquery); while ($forumrow = mysql_fetch_assoc($forumresult)) { if($forumrow['name'] == "") $forumrow['name'] = "Untitled"; $hidden = $forumrow['hidden']; if($hidden == 0){ echo ' <td align="left" valign="top" style="border-left: 2px solid #382418;" bgcolor="#191919"><a href="viewpost.php?p='.$forumrow['num'].'">'.$forumrow['name'].'</a><br />Created by '.$forumrow['username'].'</td> <td width="10%" align="center" valign="middle" bgcolor="#191919">'.$forumrow['postcount'].'</td> <td width="25%" style="border-right: 2px solid #382418;" bgcolor="#191919">'.$forumrow['lastpostdate'].'<br /> by '.$forumrow['lastpostname'].'</td> </tr> <tr> <td colspan="3" style="border-left: 2px solid #382418; border-right: 2px solid #382418;" bgcolor="#000000"> </td> </tr>'; } else { echo ' <td align="left" valign="top" style="border-left: 2px solid #382418;" bgcolor="#191919">This thread has been hidden</td> <td width="10%" align="center" valign="middle" bgcolor="#191919"></td> <td width="25%" style="border-right: 2px solid #382418;" bgcolor="#191919"></td> </tr> <tr> <td colspan="3" style="border-left: 2px solid #382418; border-right: 2px solid #382418;" bgcolor="#000000"> </td> </tr>'; } } echo ' <tr> <td colspan="3" style="border-top: 2px solid #382418;"> </td> </tr>'; ?> </table><br /> <?php include('footer.php'); ?> Here is viewpost.php, which is the file that shows the post. <?php include('mysql.php'); ?> <?php if (isset($_GET['p'])) { $topic = $_GET['p']; } else { $topic = 1; } $tnamequery = 'SELECT * FROM `[f]topic` WHERE `num` = \''.$topic.'\''; $tnameresult = mysql_query($tnamequery); while ($tnamerow = mysql_fetch_assoc($tnameresult)) { $forumnum = $tnamerow['forum']; $topicname = $tnamerow['name']; } $fnamequery = 'SELECT * FROM `[f]forums` WHERE `num` = \''.$forumnum.'\''; $fnameresult = mysql_query($fnamequery); while ($fnamerow = mysql_fetch_assoc($fnameresult)) { $catnum = $fnamerow['cat']; $forumname = $fnamerow['name']; } $cnamequery = 'SELECT * FROM `[f]cats` WHERE `num` = \''.$catnum.'\''; $cnameresult = mysql_query($cnamequery); while ($cnamerow = mysql_fetch_assoc($cnameresult)) { $catname = $cnamerow['name']; } $findertext = ' <a href=viewforum.php?f='.$forumnum.'>'.$forumname.'</a> > <a href="viewpost.php?p='.$topic.'">'.$topicname.'</a>'; ?> <?php include('header.php'); ?> <table width="100%" border="0" cellspacing="0" cellpadding="0"> <?php // Check how many pages to make $postcount = 0; $pagecount = 0; $countquery = 'SELECT * FROM `[f]post` WHERE `topic` = \''.$topic.'\' ORDER BY `num` ASC'; $countresult = mysql_query($countquery); while ($countrow = mysql_fetch_assoc($countresult)) { $postcount++; } $pagecount = ceil($postcount/10); if ($pagecount == 0) { $pagecount = 1; } // Now set page if (isset($_GET['pg'])) { $page = $_GET['pg']; } else { $page = 1; } if(isset($_COOKIE['rs_usr'])) { $reply = '<img src="ico/reply.gif" /> <a href="post.php?t='.$topic.'">Reply</a> '; } echo ' <tr bgcolor="#000000"> <td colspan="1" class="brown-left">Page <b>'.$page.'</b> of <b>'.$pagecount.' </td> <td colspan="1" class="brown-right" align="right">'.$reply.' <img src="ico/refresh.gif" width="15" height="15" /><a href="'.$_SERVER['PHP_SELF'].'?p='.$_GET['p'].'"> Refresh</a></td> </tr><tr><td colspan="2"> </td>'; $postquery = 'SELECT * FROM `[f]topic` WHERE `num` = \''.$topic.'\''; $postresult = mysql_query($postquery); while ($postrow = mysql_fetch_assoc($postresult)) { $userquery = 'SELECT * FROM `uber3_players` WHERE `name` = \''.$postrow['username'].'\''; $userresult = mysql_query($userquery); while ($userrow = mysql_fetch_assoc($userresult)) { if ($userrow['mgroup'] == 0) { $title = ''; //User $icon = ''; $bordercolor = "#3f2e0f"; $leftcolor = "#2c200a"; $rightcolor = "#1f1707"; } if ($userrow['mgroup'] == 1) { $title = '<div class="modtype">Forum Mod</div>'; $icon = '<img src="ico/crown_green.gif" /> '; $bordercolor = "#294729"; $leftcolor = "#092709"; $rightcolor = "#092009"; } if ($userrow['mgroup'] == 4) { $title = '<div class="modtype">Funified Mod</div>'; $icon = '<img src="ico/crown_gold.gif" /> '; $bordercolor = "#957c07"; $leftcolor = "#645305"; $rightcolor = "#403503"; } if ($userrow['mgroup'] == 9) { $title = '<div class="modtype">Funified Mod</div>'; $icon = '<img src="ico/crown_gold.gif" /> '; $bordercolor = "#294729"; $leftcolor = "#092709"; $rightcolor = "#092009"; } echo ' <tr> <td width="150" rowspan="2" bgcolor="'.$leftcolor.'" style="border: 4px solid '.$bordercolor.'; border-right: 0px none;" align="center" valign="top">'.$icon.' '.$postrow['username'].'<br />'.$title.'</td> <td align="right" bgcolor="'.$rightcolor.'" style="border-top: 4px solid '.$bordercolor.'; color: #888888; border-right: 4px solid '.$bordercolor.';" valign="top">'.$postrow['date'].'</td> </tr> <tr> <td align="left" bgcolor="'.$rightcolor.'" valign="top" style="border-bottom: 4px solid '.$bordercolor.'; border-right: 4px solid '.$bordercolor.';">'.$postrow['text'].'<br /><br /></td> </tr> <tr> <td colspan="2"> </td> </tr>'; } } $postquery = 'SELECT * FROM `[f]post` WHERE `topic` = \''.$_GET['p'].'\' ORDER BY `num` ASC'; $postresult = mysql_query($postquery); $postlimit = 0; $postnum = -1; while ($postrow = mysql_fetch_assoc($postresult)) { $postlimit++; $userquery = 'SELECT * FROM `uber3_players` WHERE `name` = \''.$postrow['username'].'\''; $userresult = mysql_query($userquery); while ($userrow = mysql_fetch_assoc($userresult)) { if ($userrow['mgroup'] == 0) { $title = ''; //Users $icon = ''; $bordercolor = "#3f2e0f"; $leftcolor = "#261d14"; $rightcolor = "#1f1707"; } if ($userrow['mgroup'] == 1) { $title = '<div class="modtype">Forum Mod</div>'; $icon = '<img src="ico/crown_green.gif" /> '; $bordercolor = "#294729"; $leftcolor = "#092709"; $rightcolor = "#092009"; } if ($userrow['mgroup'] == 4) { $title = '<div class="modtype">Funified Mod</div>'; $icon = '<img src="ico/crown_gold.gif" /> '; $bordercolor = "#8c7a16"; $leftcolor = "#4c4205"; $rightcolor = "#3e3605"; } if ($userrow['mgroup'] == { $title = '<div class="modtype">Funified Mod</div>'; $icon = '<img src="ico/crown_gold.gif" /> '; $bordercolor = "#8c7a16"; $leftcolor = "#4c4205"; $rightcolor = "#3e3605"; } $hidden = $postrow['hidden']; if($hidden == 0){ echo ' <tr> <td width="150" rowspan="2" bgcolor="'.$leftcolor.'" style="border: 4px solid '.$bordercolor.'; border-right: 0px none;" align="center" valign="top">'.$icon.' '.$postrow['username'].'<br />'.$title.'</td> <td align="right" bgcolor="'.$rightcolor.'" style="border-top: 4px solid '.$bordercolor.'; color: #888888; border-right: 4px solid '.$bordercolor.';" valign="top">'.$postrow['date'].'</td> </tr> <tr> <td align="left" bgcolor="'.$rightcolor.'" valign="top" style="border-bottom: 4px solid '.$bordercolor.'; border-right: 4px solid '.$bordercolor.';">'.$postrow['text'].'<br /><br /></td> </tr> <tr> <td colspan="2"> </td> </tr> '; } else { /* $bordercolor = "#3f2e0f"; $leftcolor = "#2c200a"; $rightcolor = "#1f1707"; */ echo ' <tr> <td width="150" rowspan="2" bgcolor="#2c200a" style="border: 4px solid #3f2e0f; border-right: 0px none;" align="center" valign="top"></td> <td align="right" bgcolor="#1f1707" style="border-top: 4px solid #3f2e0f; color: #888888; border-right: 4px solid #3f2e0f;" valign="top">'.$postrow['date'].'</td> </tr> <tr> <td align="left" bgcolor="#1f1707" valign="top" style="border-bottom: 4px solid #3f2e0f; border-right: 4px solid #3f2e0f;">The contents of this message have been hidden<br /><br /></td> </tr> <tr> <td colspan="2"> </td> </tr> '; } } } ?> </table><br /> <center>Quick find code: <?php echo $topic; ?></center> <?php include('footer.php'); ?> And posting topics/ replys is messed up. when you reply/make a topic, it doesn't make it into a new line if its long, it just keeps the post getting longer and longer. here is post.php <?php include ('mysql.php'); if (isset($_POST['Submit']) && isset($_COOKIE['rs_usr'])) { // Set correct date $date = date(j."-".M."-".Y." ".H.":".i.":".s); // Well, we have to get a few pieces of data =D if (!isset($_POST['topic'])) { $topic = $_POST['forum']; $topicquery = 'SELECT * FROM `[f]topic` WHERE `num` = \''.$topic.'\''; $topicresult = mysql_query($topicquery); while ($topicrow = mysql_fetch_assoc($topicresult)) { $forum = $topicrow['forum']; $topicpostz = $topicrow['postcount']; } $forumquery = 'SELECT * FROM `[f]forums` WHERE `num` = \''.$forum.'\''; $forumresult = mysql_query($forumquery); while ($forumrow = mysql_fetch_assoc($forumresult)) { $forumpostz = $forumrow['postcount']; } $topicpostz++; $forumpostz++; } else { $forum = $_POST['forum']; $forumquery = 'SELECT * FROM `[f]forums` WHERE `num` = \''.$forum.'\''; $forumresult = mysql_query($forumquery); while ($forumrow = mysql_fetch_assoc($forumresult)) { $forumthreadz = $forumrow['threadcount']; } $forumthreadz++; } // Now we get all our input, and stuff them into variables // Make sure there not trying to use html =3 $message = str_replace("<", "<", $_POST['message']); $message = str_replace(">", ">", $message); // Add the breaks $message = str_replace(" ", "<br />", $message); $hide = 0; // Now onto topic, make sure there not trying to use HTML $name = str_replace("<", "<", $_POST['topic']); $name = str_replace(">", ">", $name); if($name == "") $name = "Untitled"; // Just to put everything in a line and avoid MySQL errors $name = str_replace(" ", " ", $name); // Now, were done with all the updating CRAP, now to add the post =3 // Now, if its a post, we want this: if (!isset($_POST['topic'])) { mysql_query("INSERT INTO `[f]post` (`num`, `topic`, `text`, `username`, `date`) VALUES ('', '".$topic."', '".$message."', '".$_COOKIE['rs_usr']."', '".$date."')"); mysql_query("UPDATE `[f]forums` SET `postcount` = '".$forumpostz."', `lastpostdate` = '".$date."', `lastpostname` = '".$_COOKIE['rs_usr']."' WHERE `num` = '".$forum."' ") or die('Error1'); mysql_query("UPDATE `[f]topic` SET `postcount` = '".$topicpostz."', `lastpostdate` = '".$date."', `lastpostname` = '".$_COOKIE['rs_usr']."' WHERE `num` = '".$topic."'") or die('Error2'); } else { // Else we want this: mysql_query("UPDATE `[f]forums` SET `threadcount` = '".$forumthreadz."', `lastpostdate` = '".$date."', `lastpostname` = '".$_COOKIE['rs_usr']."' WHERE `num` = '".$forum."'") or die('Error3'); mysql_query("INSERT INTO `[f]topic` ( `num` , `forum` , `name` , `text` , `username` , `postcount` , `lastpostdate` , `lastpostname` , `date`, `hidden`) VALUES (NULL, '".$forum."', '".$name."', '".$message."', '".$_COOKIE['rs_usr']."', '1', '".$date."', '".$_COOKIE['rs_usr']."', '".$date."', '".$hide."')") or die(mysql_error()); } // Now, we setup our redirect =) Go to the post! // If it was a post, we want to go into the topic if (!isset($_POST['topic'])) { $redirect = "viewpost.php?p=".$topic; } else { // Else we know its a new topic, and we want to view it on in the forum $redirect = "viewforum.php?f=".$forum; } // Well, now there redirected and blah blah $posttext = ' <table width="100%" border="0" cellspacing="0" cellpadding="0" style="border: 2px solid #382418; background-color: #1c1610;"> <tr> <td><center>You will be redirected shortly</center><meta http-equiv="Refresh" content="2;url='.$redirect.'"></td> </tr> </table>'; } else if (!isset($_POST['Submit']) && isset($_COOKIE['rs_usr'])) { if (isset($_GET['t'])) { $foruminput = '<tr><td width="150">Topic:</td><td><input type="text" name="forum" value="'.$_GET['t'].'" readonly="readonly" /></td></tr>'; } else { $foruminput = ' <tr><td width="150">Topic Name:</td><td><input type="text" name="topic"></td></tr> <tr><td width="150">Forum:</td><td><input type="text" name="forum" value="'.$_GET['f'].'" readonly="readonly" /></td></tr>'; } $posttext = ' <form action="'.$_SERVER['PHP_SELF'].'" method="post"> <table width="100%" border="0" cellspacing="0" cellpadding="0" style="border: 2px solid #382418; background-color: #1c1610;"> <tr><td width="150">Username:</td><td>'.$crown.''.$_COOKIE['rs_usr'].'</td></tr> '.$foruminput.' <tr><td width="150" align="left" valign="top">Message:</td><td><textarea style="width: 100%;" rows="10" name="message"></textarea></td></tr> <tr><td colspan="2" align="center" valign="top"><input type="submit" name="Submit" value="Submit"></td></tr> </table> </form>'; } else { $posttext = ' <table width="100%" border="0" cellspacing="0" cellpadding="0" style="border: 2px solid #382418; background-color: #1c1610;"> <tr> <td>You must be logged in to use this feature.</td> </tr> </table>'; } include ('header.php'); echo $posttext; include ('footer.php'); Any other files needed just tell me. If you have any fixes just paste the code. Thanks , Yuws
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.