<?php
include "settings.php";
	
$qSQL = mysql_query("SELECT questions.*, users.* FROM questions INNER JOIN users ON questions.uID = users.uID WHERE qID = '".mysql_real_escape_string($_GET["id"])."'") or exit(mysql_error());
$q = mysql_fetch_object($qSQL);

if(mysql_num_rows($qSQL) == 0) {
    $_SESSION["questerror"] = "Det finns ingen fråga på denna adress";
    header("Location: /");
}

$catSQL = mysql_query("SELECT cName, cID FROM categories WHERE cID = '".mysql_real_escape_string($q->cID)."'") or exit(mysql_error());
$cata = mysql_fetch_object($catSQL);

$title = htmlspecialchars(stripslashes($q->qTitle));
include "header.php";
?>
		<!-- start of content -->
			<div id="content">
				<div id="content_inside">
					<div id="content_left">
						
	<?php if(isset($_SESSION["Questionerror"])): ?>
		<div class="error">
			<strong>Ajajaj, nu blev det något fel!</strong><br />
			<?php echo $_SESSION["Questionerror"]; unset($_SESSION['Questionerror']); ?>
		</div>
	<?php elseif(isset($_SESSION["Questionmessage"])): ?>
		<div class="success">
			<strong>Meddelande från Answer.se</strong><br />
			<?php echo $_SESSION["Questionmessage"]; unset($_SESSION['Questionmessage']); ?>
		</div>
	<?php endif; ?>

	<?php if(preg_match('/google/i', $_SERVER["HTTP_REFERER"])): ?>
	<div class="nosearch">
		<strong> Hittade du inte vad du letar efter? </strong><br />
		Du kan ställa din fråga <a href="/question/">här</a>
	</div>
    <?php endif; ?>
						<?php
							#Visar frågan
							echo "<div id=\"question_big\">";
								
								echo "<div id=\"question_big_head\">";
									echo "<div id=\"question_big_avatar\">";
									
									echo "<img src=\"".$q->uAvatar."\" class=\"avatar\"  id=\"".$q->qID."\" onMouseOver=\"mouseHover.show2('".$q->uID."', '".$q->qID."')\" />";

									
									
									echo "</div>";
									
									echo "<h1>".htmlspecialchars(stripslashes($q->qTitle))."</h1>";
									echo "Frågad av <a href=\"/anvandare/".$q->uID.".html\">" . $q->uNickname . "</a>. ";
                                    if($cata != null)
									    echo "Sorterad i <a href=\"/kategori/".removeSpecialChars($cata->cName).",".$cata->cID."/\">" . $cata->cName . "</a>";
									
									echo "<div style=\"clear: both;\"></div>";
								echo "</div>";
								
								
								echo "<div id=\"question_big_content\">";
									echo "<p>". fix_post(stripslashes(nl2br(htmlspecialchars($q->qText))))."</p>";									
								echo "</div>";
								
								echo "<div id=\"question_big_extras\">";
								
								echo "<div style=\"float:right;\"><a href=\"http://www.pusha.se/posta?url=http://www.answer.se" . $_SERVER["REQUEST_URI"] . "&title=" . htmlspecialchars($q->qTitle) . "&description=". substr(htmlspecialchars($q->qText), 0, 200)."\"><img src=\"http://www.pusha.se/pics/pusha_16_16.gif\" alt=\"Pusha\" /></a></div> ";
								
								echo "<img src=\"/images/answer_new.gif\" /> <a href=\"".$_SERVER["REQUEST_URI"]."#answer\">Svara på frågan</a> &nbsp;<img src=\"/images/favorit.gif\" /> <a href=\"/spara/".$q->qID."/\">Spara i favoriter</a>";
								#echo " &nbsp;<img src=\"/images/flag_red.gif\" /> <a href=\"#\">Anmäl frågan</a>";
								
								if(isset($_SESSIOn['uID']) && $_SESSION["uID"] == $q->uID){
									if($q->qLock==0){
										echo " &nbsp;<img src=\"/images/lock.gif\" /> <a href=\"/las/".$q->qID."/\">Lås frågan</a>";
									}else{
										echo " &nbsp;<img src=\"/images/lock.gif\" /> <a href=\"/las/".$q->qID."/\">Öppna frågan</a>";
									}
								}
								echo "</div>";
								echo "<div style=\"clear: left;\"></div>";
							echo "</div>";
							if(!isset($_SESSION["uID"]) && false) {
							?>
							<script type="text/javascript"><!--
								google_ad_client = "pub-7464749075410173";
								/* Answer */
								google_ad_slot = "0100755128";
								google_ad_width = 468;
								google_ad_height = 60;
								//-->
								</script>
								<script type="text/javascript"
								src="http://pagead2.googlesyndication.com/pagead/show_ads.js">
							</script>
							<?php
							}
							$cSQL = mysql_query("SELECT COUNT(answers.aID) as Antal FROM answers WHERE answers.qID = '".$q->qID."'") or exit(mysql_error());
							$c = mysql_fetch_object($cSQL);
							
							if($c->Antal>0){
								echo "<h2>".$c->Antal." Svar</h2>";
							}else{
								echo "<h2>Inget svar ännu</h2>";
							}
							
							
							#Visar det bästa svaret
							$bSQL = mysql_query("SELECT answers.*, users.* FROM answers INNER JOIN users ON answers.uID = users.uID WHERE answers.qID = '".$q->qID."' AND answers.aVotesUp >= 1  ORDER BY aVotesUp - aVotesDown DESC, aID LIMIT 1") or exit(mysql_error());
							$b = mysql_fetch_object($bSQL);
							if($b && $b->aID){
								echo "<div id='svar-".$b->aID."' class=\"answer\">";
									echo "<div class=\"answer_avatar\">";
										echo "<img src=\"".$b->uAvatar."\" class=\"avatar\" id=\"".$b->aID."\" onMouseOver=\"mouseHover.show2('".$b->uID."', '".$b->aID."')\" />";
									echo "</div>";
									
									echo "<div class=\"answer_best_box\">";
										echo "<div class=\"answer_best_inside\">";
											echo "<h3>Bästa svaret</h3>";
											echo "<p>". fix_post(stripslashes(nl2br(htmlspecialchars($b->aText))))."</p>";
											
											echo "<span class=\"answer_extra\">";
												
													$tidsen = get_time_difference($b->aDate, date("Y-m-d H:i:s"));
													
													
													
													if($_SESSION["uID"]&&$b->uID!=$_SESSION["uID"]){
														$vSQL = mysql_query("SELECT vID FROM votes WHERE aID = '".$b->aID."' AND uID = '".$_SESSION["uID"]."'") or exit(mysql_error());
														$v = mysql_fetch_object($vSQL);
													
														if(!$v->vID){
															echo "<a href=\"/rosta/".$b->aID.",u/\"><img src=\"/images/thumbup.png\" border=\"0\"></a>  (".$b->aVotesUp.") ";
															echo "<a href=\"/rosta/".$b->aID.",d/\"><img src=\"/images/thumbdown.png\" border=\"0\"></a>  (".$b->aVotesDown.")";
														}else{
															echo "<img src=\"/images/thumbup2.png\" border=\"0\"> (".$b->aVotesUp.") ";
															echo "<img src=\"/images/thumbdown2.png\" border=\"0\"> (".$b->aVotesDown.")";
														}
													}else{
															echo "<img src=\"/images/thumbup2.png\" border=\"0\"> (".$b->aVotesUp.") ";
															echo "<img src=\"/images/thumbdown2.png\" border=\"0\"> (".$b->aVotesDown.")";
														}
													echo " - Svar av <a href=\"/anvandare/".$b->uID.".html\">".$b->uNickname."</a> för ".$tidsen."<br />";
												echo "</span>";
											
										echo "</div>";
										echo "<div class=\"answer_best_bottom\"></div>";
									echo "</div>";
								echo "</div>";
								echo "<div style=\"clear: left;\"></div>";
							}
							
							#Visar alla svar
							$aSQL = mysql_query("SELECT answers.*, users.* FROM answers INNER JOIN users ON answers.uID = users.uID WHERE answers.qID = '".$q->qID."'  ORDER BY aVotesUp - aVotesDown DESC, aID ASC") or exit(mysql_error());
							

							while($a = mysql_fetch_array($aSQL)){
								if(!$b || ($b && $a["aID"] != $b->aID)){
									echo "<div id='svar-".$a["aID"]."' class=\"answer\">";
										echo "<div class=\"answer_avatar\">";
											echo "<img src=\"".$a["uAvatar"]."\" class=\"avatar\" id=\"".$a["aID"]."\" onMouseOver=\"mouseHover.show2('".$a["uID"]."', '".$a["aID"]."')\" />";
										echo "</div>";
										echo "<div class=\"answer_box\">";
											echo "<div class=\"answer_inside\">";
												echo "<p>".fix_post(stripslashes(nl2br(htmlspecialchars($a["aText"]))))."</p>";
											
											
												echo "<span class=\"answer_extra\">";
												
													$tidsen = get_time_difference($a["aDate"], date("Y-m-d H:i:s"));
													
													
													
													if(isset($_SESSION["uID"]) && $a["uID"] != $_SESSION["uID"]) {
														$vSQL = mysql_query("SELECT vID FROM votes WHERE aID = '".$a["aID"]."' AND uID = '".$_SESSION["uID"]."'") or exit(mysql_error());
														$v = mysql_fetch_object($vSQL);
													
														if(!$v->vID){
															echo "<a href=\"/rosta/".$a["aID"].",u/\"><img src=\"/images/thumbup.png\" border=\"0\"></a>  (".$a["aVotesUp"].") ";
															echo "<a href=\"/rosta/".$a["aID"].",d/\"><img src=\"/images/thumbdown.png\" border=\"0\"></a>  (".$a["aVotesDown"].")";
														}else{
															echo "<img src=\"/images/thumbup2.png\" border=\"0\"> (".$a["aVotesUp"].") ";
															echo "<img src=\"/images/thumbdown2.png\" border=\"0\"> (".$a["aVotesDown"].")";
														}
													}else{
															echo "<img src=\"/images/thumbup2.png\" border=\"0\"> (".$a["aVotesUp"].") ";
															echo "<img src=\"/images/thumbdown2.png\" border=\"0\"> (".$a["aVotesDown"].")";
														}
													echo " - Svar av <a href=\"/anvandare/".$a["uID"].".html\">".$a["uNickname"]."</a> för ".$tidsen."<br />";
												echo "</span>";
											echo "</div>";
											
										echo "<div class=\"answer_bottom\"></div>";
										
										echo "</div>";
									echo "</div>";
									
									echo "<div style=\"clear: both;\"></div>";
								}
							}
							
						?>
<?php if($q->qLock != 1): ?>
	<form name="answer" id="answer" method="POST" action="answer_post.php?id=<?=$q->qID;?>" style="margin-top: 10px;">
		<br />
		<?php
		echo "<div class=\"answer\">";
			echo "<div class=\"answer_avatar\">";
				if(isset($_SESSION["uID"])){
					$avatar = mysql_query("SELECT uAvatar FROM users WHERE uID = '".$_SESSION["uID"]."'");
					$uAvatar = mysql_fetch_object($avatar);
					echo "<img src=\"/".$uAvatar->uAvatar."\" class=\"avatar\" />";
				}
                else{
					echo "<img src=\"/avatars/unknown.png\" class=\"avatar\" />";
				}
			echo "</div>";
			echo "<div class=\"answer_box\">";
				echo "<div class=\"answer_inside\">";
		?>
			<b>Ditt svar på frågan</b><br />
				<textarea cols="50" rows="5" name="aText" style="width: 500px; height: 80px; margin-top: 5px;"></textarea><br /><br />
				<input type="submit" value="Skicka Svar" class="big_submit">
		<?php
				echo "</div>";
				
				echo "<div class=\"answer_bottom\"></div>";
				
			echo "</div>";
		echo "</div>";
		?>
	</form>
<?php else: ?>
	<br /><br /><h2>Skaparen av frågan har valt att låsa den.</h2>
<?php endif; ?>

					</div>
					
					<div id="content_right">
						<?php include "sidebar.php"; ?>
						
						<div style="clear: both;"></div>
					</div>
					
					
				</div>
			</div>
		<!-- end of content -->
<?php include "footer.php"; ?>