</head> <?php $topic = trim($_GET['topic']); $newMessage = $_GET['newmessage']; $messageNumber = $_GET['messagenumber']; mysql_connect("dirtpage1.db.6263223.hostedresource.com", "dirtpage1", "Jason7734") or die(mysql_error()); mysql_select_db("dirtpage1") or die(mysql_error()); include_once '../phpfunctions.php'; // //MAIN QUERY // $query = "SELECT * FROM messages WHERE topic = '{$topic}' ORDER BY score DESC"; $result = mysql_query($query) or die(mysql_error()); $num_rows = mysql_num_rows($result); echo "<br><a href = \"http://www.dirtpage.com/x/page.php?topic=" . $topic . "&mode=message\"> <span class=\"smallblack\"><u>messages</u></span></a><span class=\"smallblack\"> ({$num_rows} total)</span>"; $i = 0; $query = "SELECT * FROM messages WHERE topic = '{$topic}' ORDER BY score DESC limit 25"; $result = mysql_query($query) or die(mysql_error()); while ($row = mysql_fetch_array($result)) { $i++; echo "<div class = \"message_b\" name = \"" . $row['message_id'] . "\"><span class = \"message\" name = \"hello\">{$i}. " . hyper($row['message']) . "</span><br>"; //$m = $row['message_id']; //$query2 = "SELECT * FROM responses WHERE message_id = '$m' ORDER BY score DESC limit 1"; //$result2 = mysql_query($query2) or die(mysql_error()); //while($row2 = mysql_fetch_array($result2)) //{echo "<span class = \"m\"> -" . hyper($row2['response']) . "</span>";} ?> </div><?php } echo "<br>";
<br /><br /> <form name="post"id="post_caption" onSubmit="return false;"><br /> </h1><span id="post"> <input type="text" name="new_caption" size="65" value="" maxlength="125" autocomplete="off"></span> <input id="button" type="submit" value="post new caption"> </form> <?php $query = "SELECT * FROM captions WHERE picture = '{$picture}' ORDER BY score DESC"; $result = mysql_query($query) or die(mysql_error()); $i = 0; while ($row = mysql_fetch_array($result)) { $i++; echo "<span class=\"smallyellow\">{$i}. </span>"; echo "<span class = \"message\">" . hyper($row['caption']) . "</span>" . "<span class = \"t\">" . " (" . $row['score'] . ") </span> "; if ($odd = $row['score'] % 2) { $pic1 = "http://www.dirtpage.com/graphics/up.png"; $class1 = "up"; $pic2 = "http://www.dirtpage.com/graphics/down.png"; $class2 = "down"; } else { $pic2 = "http://www.dirtpage.com/graphics/up.png"; $class2 = "up"; $pic1 = "http://www.dirtpage.com/graphics/down.png"; $class1 = "down"; } ?> <a href="javascript:void(0)"> <img class = <?php echo $class1; ?>
echo "<br />"; } echo "</ol>"; break; case "top_items": echo "<span class = \"pinktitle\">highest rated items</span> <br><br>"; // QUERY $query = "SELECT 'messages' as table_name, topic, message as item, score, origin, message_id as item_id\r\n FROM messages \r\n UNION\r\n SELECT 'pictures' as table_name, topic, picture as item, score, origin, picture_id as item_id\r\n FROM pictures \r\n ORDER BY score DESC limit 50"; $result = mysql_query($query) or die(mysql_error()); $i = 0; while ($row = mysql_fetch_array($result)) { $i++; // MESSAGES if ($row['table_name'] == 'messages') { echo "<table ><tr ><td valign=\"top\"><span class=\"smallwhite\">{$i}.</span></td>"; echo "<td valign=\"top\" width= \"600\" style=\"padding-left:5px; \">\r\n\r\n<A HREF=\"page/?topic=" . str_replace(" ", "+", $row['topic']) . "\"><span class = \"smallyellow\">" . $row['topic'] . " : </span></a>\r\n<span class = \"smallwhite\">" . hyper($row['item']) . "</span>"; ?> <br></td> </tr></table> <?php } //PICTURES if ($row['table_name'] == 'pictures') { echo "<table ><tr ><td valign = \"top\"><span class=\"smallwhite\"> {$i}.</span> </td>"; echo "<td valign = \"top\"><A HREF=\"page/?topic=" . str_replace(" ", "+", $row['topic']) . "\"><span class = \"smallyellow\"> " . $row['topic'] . " : </span></a></td>"; echo "<td valign = \"top\"> <a href = \"http://www.dirtpage.com/page.php?topic=" . $row['topic'] . "&mode=picture&picture=" . $row['item'] . "\"><img src=\"pictures/" . $row['item'] . "\" height=\"150\" border=\"black\"></a></td>"; echo "<td valign = \"top\">"; echo "</td><td valign = \"bottom\" style=\"padding-left:20px; padding-right:20px;\"><span class = \"tinywhite\">"; // CAPTION $item = $row['item']; $query2 = "SELECT * FROM captions WHERE picture = '{$item}' ORDER BY score DESC limit 1";
$class2 = "up"; $pic1 = "http://www.dirtpage.com/thumbdowngray.jpg"; $class1 = "down"; } echo "<div style=\"border: 1px green dashed\";><table ><tr>"; echo "<td valign = \"top\" width = \"600\">"; echo "<span class = \"bigblue\">" . hyper($row['message']) . "</span>"; $query2 = "SELECT * FROM responses WHERE message_id = '{$message}' ORDER BY score DESC"; $result2 = mysql_query($query2) or die(mysql_error()); $num_rows = mysql_num_rows($result2); //echo "<br> <span class = \"tinypink\"> <br>responses ($num_rows) </span>"; $m = $row['message_id']; $query2 = "SELECT * FROM responses WHERE message_id = '{$m}' ORDER BY score DESC limit 1"; $result2 = mysql_query($query2) or die(mysql_error()); while ($row2 = mysql_fetch_array($result2)) { echo "<br><span class = \"smallwhite\"><br>-" . hyper($row2['response']) . "</span><br>"; } echo "</td>"; //echo "<td width = \"400\">"; //$m = $row['message_id']; //$query2 = "SELECT * FROM responses WHERE message_id = '$m' ORDER BY score DESC limit 3"; //$result2 = mysql_query($query2) or die(mysql_error()); //while($row2 = mysql_fetch_array($result2)) //{echo "<span class = \"tinywhite\">" . hyper($row2['response']) . "</span><br><br>";} //echo "</td>"; echo "<td valign = \"top\" width = \"100\">"; echo "<span class = \"t\">" . " (" . $row['score'] . ") </span> "; echo "<a href=\"javascript:void(0)\"> <img class = \"{$class1}\" name =\"" . $row['message_id'] . "\" src=\"{$pic1}\" border = \"0\"/> </a>"; echo "<a href=\"javascript:void(0)\"> <img class = \"{$class2}\" name = \"" . $row['message_id'] . "\" src=\"{$pic2}\" border = \"0\"/></a><span class =\"del\" name=\"" . $row['message_id'] . "\"></span>"; echo "<br><br>"; echo "</td>";
?> <A HREF="http://www.dirtpage.com/page/<?php echo str_replace(" ", "+", $theirName); ?> "><?php if ($num_results > 0) { echo "<span class = \"messageresults\"> (see all) </a></span>"; echo "<br><br>"; } while ($row = mysql_fetch_array($result)) { ?> <A HREF="http://www.dirtpage.com/page/<?php echo str_replace(" ", "+", trim($row['person'])); ?> "><?php echo "<span class = \"comment2\">" . ucwords($row['person']) . " : " . "</span></a>" . "<span class = \"comment\">" . hyper($row['comment']) . "</span>"; echo "<br><br>"; } echo "</div><br>"; ?> </div>
mysql_select_db("dirtpage1") or die(mysql_error()); echo "<h3> Top rated dirt </h3> "; $query = "SELECT * FROM people where (rank > garbage) ORDER BY rank DESC LIMIT 100"; $result = mysql_query($query) or die(mysql_error()); echo "<ol class = \"comment\" >"; while ($row = mysql_fetch_array($result)) { ?> <A HREF="http://www.dirtpage.com/page/<?php echo str_replace(" ", "+", $row['person']); ?> "> <?php echo "<span class = \"topic\">" . $row['person'] . " : " . "</span></a>" . "<span class = \"comment\">" . hyper($row['comment']) . "</span>"; echo "<br>"; echo "<br>"; } break; case "disputed": mysql_connect("dirtpage1.db.6263223.hostedresource.com", "dirtpage1", "Jason7734") or die(mysql_error()); mysql_select_db("dirtpage1") or die(mysql_error()); echo "<h3> Top rated garbage </h3> "; $query = "SELECT * FROM people where (rank <= garbage) ORDER BY rank DESC LIMIT 25"; $result = mysql_query($query) or die(mysql_error()); echo "<ol class = \"comment\" >"; while ($row = mysql_fetch_array($result)) { ?> <A HREF="http://www.dirtpage.com/page/<?php
?> " src="<?php echo $pic2; ?> " border = "0"/> </a><span class ="del" name="<?php echo $row['id']; ?> "><span class = "manip"> x </span></span> <br> </li> <?php $p = $row['pic']; $query2 = "SELECT * FROM captions WHERE pic = '{$p}' ORDER BY rank DESC limit 1"; $result2 = mysql_query($query2) or die(mysql_error()); while ($row2 = mysql_fetch_array($result2)) { echo "<span class = \"m\">" . hyper($row2['caption']) . "</span><br><br>"; } } echo "</ol>"; ?> <script type="text/javascript" src="http://www.dirtpage.com/jsfunctions.js"></script>
echo "</span><br><br>"; ?> <?php $query = "SELECT * FROM messages WHERE (message like '%{$topic_searched} %' or message like '% {$topic_searched}%' or message like '{$topic_searched}') \r\nORDER BY score DESC limit 100"; $result = mysql_query($query) or die(mysql_error()); $num_results2 = mysql_num_rows($result); while ($row = mysql_fetch_array($result)) { $topic = $row['topic']; echo "<A HREF=\"http://www.dirtpage.com/page.php?topic=" . str_replace(" ", "+", $topic) . "\"><span class=\"smallyellow\">" . $topic . ": </span></a><br>"; echo "<span class = \"message\">" . hyper($row['message']) . "</span>"; echo "<br><br>"; } echo "<br></div>"; ?> <span id = "right"> <?php include $_SERVER['DOCUMENT_ROOT'] . '/divfillers/right.php'; ?> </span>
include "functions.php"; // //MAIN QUERY // echo "<div class = \"extra\">"; echo "<div class = \"options\">"; ?> <A HREF="http://www.dirtpage.com/page/<?php echo str_replace(" ", "+", $theirName); ?> "><?php echo "<span class = \"goto\">main page - </a></span>"; ?> <A HREF="http://www.dirtpage.com/results/<?php echo str_replace(" ", "+", $theirName); ?> "><?php echo "<span name = \"{$theirName}\" class = \"search\">search</span></a><br></div>"; echo "<ol>"; $query = "SELECT * FROM people\r\nWHERE person = '{$theirName}'\r\nORDER BY rank DESC limit 3"; $result = mysql_query($query) or die(mysql_error()); while ($row = mysql_fetch_array($result)) { echo "<br><span class = \"message\"><li>" . hyper($row['comment']) . "</span><br>"; } echo "<ol></div><br>"; ?>
$class2 = "down"; } else { $pic2 = "http://www.dirtpage.com/thumbgray.jpg"; $class2 = "up"; $pic1 = "http://www.dirtpage.com/thumbdowngray.jpg"; $class1 = "down"; } echo "<div style=\"border: 1px green dashed\";><table><tr><td>"; echo "<td><A HREF=\"http://www.dirtpage.com/x/page.php?topic=" . $topic . "&mode=picture&picture=" . $row['picture'] . "\">"; echo "<img src=\"../../../../x/pictures/" . $row['picture'] . "\" width=\"200\"></a></td>"; echo "<td width=\"400\" style=\"padding-left: 25px;\"> "; $p = $row['picture']; $query2 = "SELECT * FROM captions WHERE picture = '{$p}' ORDER BY score DESC limit 1"; $result2 = mysql_query($query2) or die(mysql_error()); while ($row2 = mysql_fetch_array($result2)) { echo "<span class = \"bigwhite\">" . hyper($row2['caption']) . "</td>"; } echo "<td valign = \"top\" align=\"right\" ><span class = \"t\">" . " (" . $row['score'] . ") </span> "; echo "<a href=\"javascript:void(0)\"> <img class = \"{$class1}\" name =\"" . $row['message_id'] . "\" src=\"{$pic1}\" border = \"0\"/> </a>"; echo "<a href=\"javascript:void(0)\"> <img class = \"{$class2}\" name = \"" . $row['message_id'] . "\" src=\"{$pic2}\" border = \"0\"/></a><span class =\"del\" name=\"" . $row['message_id'] . "\"></span><br></span><br><span class = \"tinywhite\"></span></td>"; echo "</tr></table></div><br>"; } ?>
<?php $query = "SELECT * FROM captions WHERE (caption like '%{$topic_searched} %' or caption like '% {$topic_searched}%' or caption like '{$topic_searched}') AND picture not like '%{$topic_searched}%'\r\nORDER BY score DESC limit 50"; $result = mysql_query($query) or die(mysql_error()); $num_results2 = mysql_num_rows($result); while ($row = mysql_fetch_array($result)) { $p = $row['picture']; $query4 = "SELECT * FROM pictures WHERE picture like '{$p}'"; $result4 = mysql_query($query4) or die(mysql_error()); while ($row4 = mysql_fetch_array($result4)) { $topic = $row4['topic']; } echo "<A HREF=\"http://www.dirtpage.com/page.php?topic=" . str_replace(" ", "+", $topic) . "\"><span class=\"smallyellow\">" . $topic . "</span></a><br>"; echo "<a href = \"http://www.dirtpage.com/page.php?topic=" . $topic . "&mode=picture&picture=" . $row['picture'] . "\"><img src=\"pictures/" . $row['picture'] . "\" height=\"150\" border=\"black\"></a>"; ?> <br><?php echo "<span class = \"tinysilver\">" . strtolower($row['caption']) . "</span>" . "<span class = \"message\">" . hyper($row['message']) . "</span>"; echo "<br><br>"; } echo "<br></div>"; ?> <span id = "right"> <?php include $_SERVER['DOCUMENT_ROOT'] . '/divfillers/right.php'; ?> </span>
?> > </form> <br><br /> <?php $query = "SELECT 'messages' as table_name, message as item, score, message_id as item_id\r\n FROM messages WHERE topic = '{$topic}' \r\n UNION\r\n SELECT 'pictures' as table_name, picture as item, score, picture_id as item_id\r\n FROM pictures WHERE topic = '{$topic}' \r\n ORDER BY score DESC"; $result = mysql_query($query) or die(mysql_error()); $i = 0; while ($row = mysql_fetch_array($result)) { $i++; if ($row['table_name'] == 'messages') { echo "<table ><tr ><td valign=\"top\"><span class=\"smallyellow\">{$i}.</span></td>"; echo "<td valign=\"top\" width= \"600\">\r\n\r\n<span class = \"smallwhite\">" . hyper($row['item']) . " </span>" . "<span class = \"smallyellow\">" . " (" . $row['score'] . ") </span> "; if ($odd = $row['score'] % 2) { $pic1 = "http://www.dirtpage.com/thumbgray.jpg"; $class1 = "up"; $pic2 = "http://www.dirtpage.com/thumbdowngray.jpg"; $class2 = "down"; } else { $pic2 = "http://www.dirtpage.com/thumbgray.jpg"; $class2 = "up"; $pic1 = "http://www.dirtpage.com/thumbdowngray.jpg"; $class1 = "down"; } ?> <a href="javascript:void(0)"> <img class = <?php echo $class1; ?>
?> <div id = "container"> <div id = "output"> <span class = "redtitle"> top-rated dirt</span> <br><br> <?php echo "<ol>"; while ($row = mysql_fetch_array($result)) { ?> <li><A HREF="http://www.dirtpage.com/page/<?php echo str_replace(" ", "+", $row['person']); ?> "> <?php echo "<span class = \"smalltopic\"><span class = \"card\">" . $row['person'] . "</span> : " . "</span></a>" . "<span class = \"comment\">" . hyper($row['comment']) . "</span>"; echo "<br>"; echo "<br>"; } echo "</ol></div></div><div id = \"boxes\"></div>"; break; case "disputed": mysql_connect("dirtpage1.db.6263223.hostedresource.com", "dirtpage1", "Jason7734") or die(mysql_error()); mysql_select_db("dirtpage1") or die(mysql_error()); echo "<h3> Top rated garbage </h3> "; $query = "SELECT * FROM people where (rank <= garbage) ORDER BY rank DESC LIMIT 25"; $result = mysql_query($query) or die(mysql_error()); echo "<ol class = \"comment\" >"; while ($row = mysql_fetch_array($result)) { ?>
> <input type="hidden" name="act" value="postmessage"> <input id="button" type="submit" value="add new recommendation"> </form> <?php $query = "SELECT * FROM seealsos WHERE topic = '{$theirName}' ORDER BY score DESC"; $result = mysql_query($query) or die(mysql_error()); echo "<ol>"; while ($row = mysql_fetch_array($result)) { echo "<li><span class = \"message\">" . hyper($row['see_also']) . "</span>" . "<span class = \"t\">" . " (" . $row['score'] . ") </span> "; if ($odd = $row['rank'] % 2) { $pic1 = "http://www.dirtpage.com/thumbgray.jpg"; $class1 = "up"; $pic2 = "http://www.dirtpage.com/thumbdowngray.jpg"; $class2 = "down"; } else { $pic2 = "http://www.dirtpage.com/thumbgray.jpg"; $class2 = "up"; $pic1 = "http://www.dirtpage.com/thumbdowngray.jpg"; $class1 = "down"; } ?> <a href="javascript:void(0)"> <img class = <?php echo $class1; ?>
</form> <br /> <?php // QUERY $query = "SELECT 'messages' as table_name, message as item, score, message_id as item_id\r\n FROM messages WHERE topic = '{$topic}' \r\n UNION\r\n SELECT 'pictures' as table_name, picture as item, score, picture_id as item_id\r\n FROM pictures WHERE topic = '{$topic}' \r\n ORDER BY score DESC"; $result = mysql_query($query) or die(mysql_error()); $i = 0; while ($row = mysql_fetch_array($result)) { $i++; // MESSAGES if ($row['table_name'] == 'messages') { echo "<table ><tr ><td valign=\"top\"><span class=\"smallyellow\">{$i}.</span></td>"; echo "<td valign=\"top\" width= \"600\" style=\"padding-left:5px; \">\r\n<span class = \"smallwhite\">" . hyper($row['item']) . "</span>" . "<span class = \"smallyellow\">" . " (" . $row['score'] . ") </span> "; if ($odd = $row['score'] % 2) { $pic1 = "http://www.dirtpage.com/thumbgray.jpg"; $class1 = "message_up"; $pic2 = "http://www.dirtpage.com/thumbdowngray.jpg"; $class2 = "message_down"; } else { $pic2 = "http://www.dirtpage.com/thumbgray.jpg"; $class2 = "message_up"; $pic1 = "http://www.dirtpage.com/thumbdowngray.jpg"; $class1 = "message_down"; } ?> <a href="javascript:void(0)"> <img class = <?php echo $class1; ?>
<?php $query = "SELECT * FROM messages WHERE (message like '%{$topic_searched} %' or message like '% {$topic_searched}%' or message like '{$topic_searched}') AND topic not like '%{$topic_searched}%'\r\nORDER BY score DESC limit 50"; $result = mysql_query($query) or die(mysql_error()); $num_results = mysql_num_rows($result); if ($num_results > 0) { echo "<span class = \"topic2\" ><br><u>Message Matchess</u></span><br><br>"; } while ($row = mysql_fetch_array($result)) { ?> <A HREF="page/?topic=<?php echo str_replace(" ", "+", $row['topic']); ?> "><?php echo "<span class = \"comment2\"><span class = \"card\">" . strtolower($row['topic']) . "</span> : " . "</span></a>" . "<span class = \"comment\">" . hyper($row['message']) . "</span>"; echo "<br><br>"; } echo "<br></div></div>"; ?> </span> </div> </div>
<?php $query = "SELECT * FROM people WHERE comment like '%{$theirName}%'AND person not like '%{$theirName}%'\r\nORDER BY rank DESC limit 75"; $result = mysql_query($query) or die(mysql_error()); $num_results = mysql_num_rows($result); if ($num_results > 0) { echo "<span class = \"topic2\" ><u>Message Matches</u></span><br><br>"; } while ($row = mysql_fetch_array($result)) { ?> <A HREF="http://www.dirtpage.com/page/<?php echo str_replace(" ", "+", trim($row['person'])); ?> "><?php echo "<span class = \"comment2\"><span class = \"card\">" . strtolower($row['person']) . "</span> : " . "</span></a>" . "<span class = \"comment\">" . hyper($row['comment']) . "</span>"; echo "<br><br>"; } echo "<br></div></div>"; ?> <script type="text/javascript"> header(); $("#messageresults").hide();
echo "<A HREF=\"http://www.dirtpage.com/page/" . $theirName . "\"><span class=\"topic\">" . $theirName . "</span></a>"; echo "<div class = \"options\">"; ?> <A HREF="http://www.dirtpage.com/page/<?php echo str_replace(" ", "+", $theirName); ?> "><?php echo "<span class = \"goto\">main page - </a></span>"; ?> <A HREF="http://www.dirtpage.com/results/<?php echo str_replace(" ", "+", $theirName); ?> "><?php echo "<span class = \"search\">search</span></a><br></div>"; $query = "SELECT * FROM people\r\nWHERE person = '{$theirName}'\r\nORDER BY rank DESC limit 50"; $result = mysql_query($query) or die(mysql_error()); echo "<ol>"; while ($row = mysql_fetch_array($result)) { echo "<span class = \"m\"><li>" . hyper($row['comment']) . "</span>"; ?> <br><br> <?php } echo "</ol></span>"; ?>
?> <form name="chat"id="chat" onSubmit="return false;"> <br> <span class = "post"><INPUT TYPE=radio NAME="recentwhat" value="post" id="post" checked> <span class = "message">new messages</span></span> <span class = "view"><INPUT TYPE=radio NAME="recentwhat" value="view" id="view"> <span class = "smalltopic">page views</span></span> <br> </form><?php $query = "SELECT * FROM feed where type = 'post' ORDER BY id DESC limit {$limit}"; $result = mysql_query($query) or die(mysql_error()); while ($row = mysql_fetch_array($result)) { list($posttopic, $postmessage) = explode(":", $row['event']); echo "<A HREF=\"http://www.dirtpage.com/page/" . str_replace(" ", "+", $posttopic) . "\"><span class = \"smalltopic\"><span class = \"card\">" . strtolower($posttopic) . "</span></span></a><span class = \"smalltopic\">: </span><span class = \"message\">" . hyper(strtolower($postmessage)) . "</span><br><br>"; } } if ($val == "view") { ?> <form name="chat"id="chat" onSubmit="return false;"> <br> <span class = "post"><INPUT TYPE=radio NAME="recentwhat" value="post" id="post"> <span class = "message">new messages</span></span> <span class = "view"><INPUT TYPE=radio NAME="recentwhat" value="view" id="view" checked> <span class = "smalltopic">page views</span></span> <br> </form><?php $query = "SELECT * FROM feed where type = 'view' ORDER BY id DESC limit {$limit}";
echo "<span name = \"{$theirName}\" class = \"search\"><A HREF=\"http://www.dirtpage.com/results/" . str_replace(" ", "+", $theirName) . "\">search</a></span></span><br><br>"; ?> <form name="post"id="test" onSubmit="return false;"><br /> </h1><span id="post"> <input type="text" name="newmessage" size="28" value="" maxlength="125" autocomplete="off"></span> <input type="hidden" name="topic" value= <?php echo "\"{$theirName}\""; ?> > <input type="hidden" name="act" value="postmessage"> <input id="button" type="submit" value="add new item"> </form> <?php $query = "SELECT * FROM people WHERE person = '{$theirName}' ORDER BY rank DESC"; $result = mysql_query($query) or die(mysql_error()); echo "<ol>"; while ($row = mysql_fetch_array($result)) { echo "<li><span class = \"message\">" . hyper($row['comment']) . "</span>" . "<span class = \"t\">" . " (" . $row['rank'] . ") </span> "; if ($odd = $row['rank'] % 2) { $pic1 = "http://www.dirtpage.com/thumbgray.jpg"; $class1 = "up"; $pic2 = "http://www.dirtpage.com/thumbdowngray.jpg"; $class2 = "down"; } else { $pic2 = "http://www.dirtpage.com/thumbgray.jpg"; $class2 = "up"; $pic1 = "http://www.dirtpage.com/thumbdowngray.jpg"; $class1 = "down"; } ?> <a href="javascript:void(0)"> <img class = <?php echo $class1; ?>