<?php
if($_POST["joke"]) {

	$host = "localhost";
	$username = "connorm_jokes";
	$password = "omglol!@#123";
	$db = "connorm_jokes";

	mysql_connect($host, $username, $password) or die(mysql_error());
	mysql_select_db($db) or die(mysql_error());

	$joke = mysql_real_escape_string($_POST["joke"]);
	$words = explode(" ", $joke);

	$randjokes = mysql_query("SELECT * FROM `jokes`");
	$jokeid = round(rand(1, mysql_num_rows($randjokes)), 0);
	$jokerow = mysql_fetch_array(mysql_query("SELECT * from `jokes` WHERE `id`=$jokeid"));

	while($jokerow["joke"] == "Q: Why did the chicken cross the road?<br />
A: To go the the other side!") {
		$jokeid = round(rand(1, mysql_num_rows($randjokes)), 0);
		$jokerow = mysql_fetch_array(mysql_query("SELECT * from `jokes` WHERE `id`=$jokeid"));
	}
	if($jokerow["flag"] > 0){
		echo '<div style="display: block;" id="flagwarning"><p><strong>warning</strong>warning: this joke has been flagged by one of more people as innapropriate. it may contain topics that for mature views. if you would like to continue, click "ignore" below. if you would like a new joke, click "gimme another". keep in mind that the thoughts expressed in these jokes are not to be taken to heart and are only meant to be humorous. all jokes are submitted by visitors and do not reflect the thoughts of jokepop.</p><p><a href="javascript: hideWarning();">ignore</a> | <a href="javascript: newJoke();">gimme another</a></p><p></p></div><div style="display: none;" id="jokecontainer"><div id="rfrbar"><iframe frameborder="0" scrolling="no" src="rateframe.php?id=' . $jokerow["id"] . '" width="85" height="16"></iframe><a class="flaglink" id="f' . $jokerow["id"] . '" href="#flag">flag</a><a class="reportlink" id="r' . $jokerow["id"] . '" href="#report">report</a><br class="clear" /></div>';
		echo '<div id="thejoke">' . strip_tags($jokerow["joke"], '<br><br />') . '</div>';
		echo '<div id="googleads"><iframe frameborder="0" scrolling="no" src="adsframe.php?id=' . $jokerow["id"] . '" width="468" height="15"></iframe></div></div>';
	} else {
		echo '<div style="display: none;" id="flagwarning"></div><div style="display: block;" id="jokecontainer"><div id="rfrbar"><iframe frameborder="0" scrolling="no" src="rateframe.php?id=' . $jokerow["id"] . '" width="85" height="16"></iframe><a class="flaglink" id="f' . $jokerow["id"] . '" href="#flag">flag</a><a class="reportlink" id="r' . $jokerow["id"] . '" href="#report">report</a><br class="clear" /></div>';
		echo '<div id="thejoke">' . strip_tags($jokerow["joke"], '<br><br />') . '</div>';
		echo '<div id="googleads"><iframe frameborder="0" scrolling="no" src="adsframe.php?id=' . $jokerow["id"] . '" width="468" height="15"></iframe></div></div>';
	}
		$insert = "INSERT INTO `jokes` (joke, user, flag, report, total_votes, total_value, used_ips) VALUES ('$joke', 'anon', '0', '0', '0', '0', '')";
		mysql_query($insert) or die(mysql_error());

}
if($_POST["new"]){
	if($_POST["new"] == "yes"){
		$host = "localhost";
		$username = "connorm_jokes";
		$password = "omglol!@#123";
		$db = "connorm_jokes";

		mysql_connect($host, $username, $password) or die(mysql_error());
		mysql_select_db($db) or die(mysql_error());

		$joke = mysql_real_escape_string(nl2br($_POST["joke"]));
		$words = explode(" ", $joke);

		$randjokes = mysql_query("SELECT * FROM `jokes`");
		$jokeid = round(rand(1, mysql_num_rows($randjokes)), 0);
		$jokerow = mysql_fetch_array(mysql_query("SELECT * from `jokes` WHERE `id`=$jokeid"));

		while($jokerow["joke"] == "Q: Why did the chicken cross the road?<br />
A: To go the the other side!") {
				$jokeid = round(rand(1, mysql_num_rows($randjokes)), 0);
				$jokerow = mysql_fetch_array(mysql_query("SELECT * from `jokes` WHERE `id`=$jokeid AND `flag`=0 "));
		}

		echo '<div style="display: none;" id="flagwarning"></div><div style="display: block;" id="jokecontainer"><div id="rfrbar"><iframe frameborder="0" scrolling="no" src="rateframe.php?id=' . $jokerow["id"] . '" width="85" height="16"></iframe><a class="flaglink" id="f' . $jokerow["id"] . '" href="#flag">flag</a><a class="reportlink" id="r' . $jokerow["id"] . '" href="#report">report</a><br class="clear" /></div>';
		echo '<div id="thejoke">' . strip_tags($jokerow["joke"], '<br><br />') . '</div>';
		echo '<div id="googleads"><iframe frameborder="0" scrolling="no" src="adsframe.php?id=' . $jokerow["id"] . '" width="468" height="15"></iframe></div></div>';
	} else {
		//
	}
}
if($_POST["nojoke"]){
	echo "you are an asshole";
}
?>