Code: Select all
<?php
$use_jquery = true;
include ('header.inc');
?>
<td width="5"><img src="image/specer.png" width="1" height="1"></td>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr align="left" valign="top">
<td width="8"><img src="image/th-midbody-left.jpg" width="8" height="29"></td>
<td class="t-header-bg"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="29" align="center" valign="middle" class="normal_text06">QUEST GUIDES</td>
</tr>
</table></td>
<td width="8"><img src="image/th-midbody-right.jpg" width="8" height="29"></td>
</tr>
</table></td>
</tr>
<tr>
<td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr align="left" valign="top">
<td width="1" bgcolor="#756649"><img src="image/specer.png" width="1" height="1"></td>
<td width="1" bgcolor="#A18E6E"><img src="image/specer.png" width="1" height="1"></td>
<td width="1" bgcolor="#474B48"><img src="image/specer.png" width="1" height="1"></td>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="1" align="left" valign="top" bgcolor="#474B48"><img src="image/specer.png" width="1" height="1"></td>
</tr>
<tr>
<td align="left" valign="top" class="box_4">
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td>
<?php
function questview($id) {
require_once ('../mysql_connect.php');//connect to db
include ('includes/steps.php');
/* query for item */
$query = "SELECT * FROM quest WHERE id=$id";
$result = mysql_query ($query);
/* if we get no results back, error out */
$numrtn = mysql_num_rows($result);
if ($numrtn == 0) {
echo "The quest guide requested cannot be found\n";
echo $id;
return;
}
$row = mysql_fetch_assoc($result);
/* easier to read variables and
* striping out tags */
$id = $row['id'];
$name = $row['name'];
$contributors = $row['contributors'];
$guideby = $row['guideby'];
$added = $row['added'];
$location = $row['startinglocation'];
$members = $row['members'];
$description = $row['description'];
$difficulty = $row['difficulty'];
$requirements = $row['requirements'];
$items = $row['items'];
$reward = $row['reward'];
$guide = $row['mainbody'];
$length = $row['length'];
$updated = $row['updated'];
if ($members == "Y") {
$mem = "members only quest</b>, so it can only be done on a <b>members</b> server.";
}else{
$mem = "non-members quest</b>.";
}
if ($updated == 0){
$up = 'No-one has updated this quest guide';
}else{
$date2 = date("l jS F Y @ H:i:s ", $updated);
$up = 'It was last updated on '.$date2;
}
if ($contributors != ""){
$con = 'Thanks also to <b>'.$contributors.'</b> for changes.';
}else{
$con = 'No-one else has contributed to this quest guide.';
}
//$date = date("D M jS, Y g:i a", $added);
$date = date("l jS F Y @ H:i:s ", $added);
echo '
<div id="quest"><table width="100%" border="0">
<tr>
<td>
<h1 align="center">'.$name.'</h1>
';
echo step_js();
echo pick_clue($id);
echo toggle_reward();
echo toggle_clue();
echo '<br>';
echo '
<p class="text1">This quest guide was written by <b>'.$guideby.'</b> for use on Runehints and entered into the database on '.$date.'. '.$up.'. '.$con.' <br /></p>
<p><span class="text1"><br />This quest is <b>'.$mem.'</span></p>
<p>
<span class="qtitle">Description: </span><span class="text1">'.$description.'</span></p>
<p><span class="qtitle">Difficulty Level: </span><span class="text1">'.$difficulty.'</span></p>
<p>
<span class="qtitle">Requirements: </span><span class="text1">'.$requirements.'</span></p>
<p>
<span class="qtitle">Items Needed During Quest: </span><span class="text1">'.$items.'</span></p>
<p>
<span class="qtitle">Starting Location: </span><span class="text1">'.$location.'</span></p>
<p><span class="qtitles">Quest Instructions:</span></p>';
echo list_steps($id, true);
echo '<p>
<div id="rewardwrap" style="display:none;"><span class="qtitle">Reward: </span><span class="text1">'.$reward.'</span></div></p>
</td>
</tr>
</table></div> ';
}
function selectquest(){
require_once ('../mysql_connect.php');//connect to db
global $sitestyle;
?>
<?php
$result = mysql_query("SELECT * FROM quest");
$num_rows = mysql_num_rows($result);
?>
<table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="left" valign="top" class="normal_text02"><div align="justify">There are a total of <? echo $num_rows; ?> quest guides in our database. There are Free guides and Member guides. On RuneHints, all guides are free to use, but the Member guides require you to be on a RuneScape Member server to use them.</div></td>
</tr>
<tr>
<td height="15" align="left" valign="top"> </td>
</tr>
<tr>
<td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr align="left" valign="top">
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr align="left" valign="top">
<td width="16"><img src="image/011.jpg" width="16" height="26"></td>
<td align="left" valign="top" class="quest_033"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="26" align="center" valign="middle" class="normal_text07">FREE QUEST GUIDES</td>
</tr>
</table></td>
<td width="16"><img src="image/022.jpg" width="16" height="26"></td>
</tr>
</table></td>
</tr>
<tr>
<td align="left" valign="top" class="box_5"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<?php
/* query for quests */
$n_query = "SELECT id, name, difficulty, members, sorter FROM quest WHERE members='n' ORDER BY sorter ASC";
$n_result = mysql_query ($n_query);
while ($n_row = mysql_fetch_assoc($n_result)) {
$n_name = $n_row['name'];
//$n_guideby = $n_row['guideby'];
$n_difficulty = $n_row['difficulty'];
$id = $n_row['id'];
/* place table row data in
* easier to use variables.
* & display the data */
echo '<tr align="left" valign="top"><td width="275" class="normal_text05"><a href="quest.php?flibble=questview&id='.$id.'&ic=1" style="color:#EED8B4;"><b>'.$n_name.'</b></a></td><td> </td><td width="73" class="normal_text05">'.$n_difficulty.'</td></tr>';
}
/* finish up table*/
?>
</table></td>
</tr>
<tr>
<td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr align="left" valign="top">
<td width="49"><img src="image/0022.jpg" width="49" height="17"></td>
<td height="17" bgcolor="#69582D"><img src="image/specer.png" width="1" height="1"></td>
<td width="49"><img src="image/0033.jpg" width="49" height="17"></td>
</tr>
</table></td>
</tr>
</table></td>
<td width="20"><img src="image/specer.png" width="1" height="1"></td>
<td><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr align="left" valign="top">
<td width="16"><img src="image/011.jpg" width="16" height="26"></td>
<td class="quest_033"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="26" align="center" valign="middle" class="normal_text07">MEMBER QUEST GUIDES</td>
</tr>
</table></td>
<td width="16"><img src="image/022.jpg" width="16" height="26"></td>
</tr>
</table></td>
</tr>
<tr>
<td align="left" valign="top" bgcolor="#675A45" class="box_5"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<?php
/* query for quests */
$y_query = "SELECT id, name, difficulty, members, sorter FROM quest WHERE members='y' ORDER BY sorter ASC";
$y_result = mysql_query ($y_query);
while ($y_row = mysql_fetch_assoc($y_result)) {
$y_name = $y_row['name'];
//$y_guideby = $y_row['guideby'];
$y_difficulty = $y_row['difficulty'];
$yid = $y_row['id'];
/* place table row data in
* easier to use variables.
* & display the data */
echo '<tr align="left" valign="top"><td width="275" class="normal_text05"><a href="quest.php?flibble=questview&id='.$yid.'&ic=1" style="color:#EED8B4;"><b>'.$y_name.'</b></a></td><td> </td><td width="73" class="normal_text05">'.$y_difficulty.'</td></tr>';
}
/* finish up table*/?>
</table></td>
</tr>
<tr>
<td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr align="left" valign="top">
<td width="49"><img src="image/0022.jpg" width="49" height="17"></td>
<td height="17" bgcolor="#69582D"><img src="image/specer.png" width="1" height="1"></td>
<td width="49"><img src="image/0033.jpg" width="49" height="17"></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table></td>
</tr>
</table>
<?php
}
switch($_GET['flibble']) {
case 'selectquest':
selectquest();
break;
case 'questview':
questview($_GET['id']);
break;
default:
selectquest();
}
?>
</td></tr></table>
</td></tr></table>
</td>
<td width="1" bgcolor="#756649"><img src="image/specer.png" width="1" height="1"></td>
<td width="1" bgcolor="#A18E6E"><img src="image/specer.png" width="1" height="1"></td>
<td width="1" bgcolor="#474B48"><img src="image/specer.png" width="1" height="1"></td>
</tr>
</table></td>
</tr>
<tr>
<td align="left" valign="top"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr align="left" valign="top">
<td width="63"><img src="image/0a.jpg" width="63" height="20"></td>
<td valign="bottom"><table width="100%" border="0" cellspacing="0" cellpadding="0">
<tr>
<td height="17" align="left" valign="top" bgcolor="#746232"><img src="image/specer.png" width="1" height="1"></td>
</tr>
<tr>
<td height="1" align="left" valign="top" bgcolor="#474B48"><img src="image/specer.png" width="1" height="1"></td>
</tr>
<tr>
<td height="1" align="left" valign="top" bgcolor="#A18E6E"><img src="image/specer.png" width="1" height="1"></td>
</tr>
<tr>
<td height="1" align="left" valign="top" bgcolor="#756649"><img src="image/specer.png" width="1" height="1"></td>
</tr>
</table></td>
<td width="63"><img src="image/0b.jpg" width="63" height="20"></td>
</tr>
</table></td>
</tr>
<tr>
<td height="5" align="left" valign="top"><img src="image/specer.png" width="1" height="1"></td>
</tr>
</table></td>
<td width="5"><img src="image/specer.png" width="1" height="1"></td>
</tr>
</table>
<?
include('footer.inc');
?>If you don't see the problem, the site is cut off at site stats there has to be something in that code stopping it. I can not see it, can you?