Here is my code:
Code: Select all
<?php
include_once 'connect.php';
session_start();
?>
<link href="style.css" rel="stylesheet" type="text/css" />
<div id="login2" div align="center">
<?php
if (isset($_SESSION['player']))
{
$player=$_SESSION['player'];
}
else
{
echo "Not Logged in <br><br> <A href='login.php'>Login</a>";
exit;
}
?>
</div>
<?php
$qname=$_POST['name'];
$bypass = 0;
$newquest = 0;
$playerinfo="SELECT * from gamers where playername='$player'";
$playerinfo2=mysql_query($playerinfo) or die("could not get player stats!");
$playerinfo3=mysql_fetch_array($playerinfo2);
$id=$playerinfo3['id'];
$questinfo="SELECT * from questgivers WHERE name='$qname'";
$questinfo2=mysql_query($questinfo) or die(mysql_error());
$questinfo3=mysql_fetch_array($questinfo2);
$questname = $questinfo3['name'];
$level = $playerinfo3['level'];
$house = "SELECT * from playerquests where pname='$playerinfo3[playername]' AND name='$questname' order by level DESC Limit 1";
$house2 = mysql_query($house) or die(mysql_error());
$house3 = mysql_fetch_array($house2);
if (!isset($house3['name']))
{
$house3['level'] = 1;
$newquest = 1;
}
$selectquest="SELECT * from questgivers where name='$questname' AND level='$house3[level]'";
$selectquest2=mysql_query($selectquest) or die(mysql_error());
$selectquest3=mysql_fetch_array($selectquest2);
if (!isset($selectquest3['name']))
{
echo "There are no available quests at this time.<br><br>";
}
else
{
print "<center><h3>Quests</h3></center>";
print "<center>";
print "<table border='0' width='70%' cellspacing='20'>";
print "<tr><td width='25%' valign='top'>";
print "</td>";
print "<td valign='top' width='75%'>";
$selectquests="SELECT * from questgivers where pid='$playerinfo3[playername]'";
$selectquests2=mysql_query($selectquests) or die(mysql_error());
print "<table border='1' bordercolor='black' bgcolor='#ffffff' >";
print "<tr><td>Name<font color='ffffff'>_________________</td><td>Experience<font color='ffffff'>_</td><td>Gold<font color='ffffff'>_</td></tr>";
while($selectquests3=mysql_fetch_array($selectquests2))
{
print "<tr><td>$selectquests3[name]</td><td>$selectquests3[exper]</td><td>$selectquests3[credits]</td><td><a href='questsaccepted.php?name=$questinfo3[name]'>Accept</a></td</tr>";
}
echo "</table>";
echo "</td></tr>";
echo "</table>";
echo "<br><br><a href='index.php'>Home</a>";
}