Jump to content

[SOLVED] cant figure out why it wont display.

kendallkamikaze

By kendallkamikaze
in PHP Coding Help

Recommended Posts

kendallkamikaze Member

kendallkamikaze

Posted
Posted

This particular code

<table class=table cellspacing='2' cellpadding='2'>
<tr><td>

<table class="table" cellpadding="0" cellspacing="0" width="550">
  <tbody>
    <tr>
      <td class="tablegreen">Your Merit Cabinet</td></tr> 
<tr><td class='tabletd'><center>
<?php 

$playerid=$_GET['id']; 

$sql="SELECT * FROM diplomas WHERE userid='$id'";
$result=mysql_query($sql);

while($r=mysql_fetch_array($result))
{	

$diploma=$r["diploma"];

echo " <img src='$diploma'> ";
}
?>
</td></tr>
<tr><td class='tabletd'>
<?php 


if ($mTeam!=="1") 

{ 


$sql="SELECT * FROM teams WHERE id='$mTeam'";
$result=mysql_query($sql);

while($r=mysql_fetch_array($result))
{	

$name=$r["name"];
$type=$r["type"];
$banner=$r["banner"];

echo " <center><BR><a href='team_page.php'><img src='$banner'> <br>
<b> You are a member of the $name Team! </b><br>
Click to Go to Your Team's Page</a></center>";
}
}
?>
</td></tr></table>
</td></tr></table>

<br><br>

 

in conjunction with the code below, wont display the <img src='$diploma'>

 

<?php
include 'header.php';?>

<?php
if ($mStatus!="Banned") {
echo " "; }
else {
echo "<script>
<!--
  window.location= 'banned.php'
//-->
</script>"; }
?>

<style type="text/css">
table {
border-width: 2px;
border-spacing: 2px;
border-color: #000000;
border-collapse: collapse;
}

</style>



<?php

$sql="SELECT * FROM messages WHERE Recipient='$id' and new='yes' limit 0,1";
$result=mysql_query($sql);

while($r=mysql_fetch_array($result))
{	
echo "<br><br>New Messages ";

}

?>


<?php

$sql="SELECT * FROM player WHERE id='$id'";
$result=mysql_query($sql);

while($r=mysql_fetch_array($result))
{	

$pid=$r["id"];
$Playername=$r["Playername"];
$Passwordd=$r["Password"];
$Description=$r["Description"];
$Points=$r["Points"];
$AcademyLevel=$r["AcademyLevel"];
$Money=$r["Money"];
$Status=$r["Status"];
$GirlScout=$r["GirlScout"];
$gold=$r["gold"];
$diploma=$r["diploma"];
$lastlog=$r["lastlog"];



if($_GET[action] == "changepassword2"){
if($_POST[oldpass] != $Passwordd){print "Wrong old password."; include "footer.php"; exit;}
mysql_query("update player set Password='$_POST[newpass]' where id='$id'");

print "<font color=red>You changed your password.</font> You have been signed out for verification. <a href=index.php> Click here to sign back in.</a><br><br>"; 
exit;}
if($_GET[action] == "changepassword1"){PRINT "
<form method=post action=player_estate.php?action=changepassword2>
Old Pass:<input type=text name='oldpass'><br>
New Pass: <input type=text name='newpass'><br>
<input type=submit value='Change Pass'></form>";
}



echo "<h2>Welcome to Your Estate $Playername!</h2> You Are ID #$id <br><br><br> $Description <br><br>";
}
?>
<table class=table cellspacing='2' cellpadding='2'>
<tr><td>
<table border='0px' bordercolor='#959081' cellpadding='2' cellspacing='2' width='550'>
    <tr>
      <td valign='top' class='tablegreen' colspan='4'>
      <center>Your Information</center>
      </td>
    </tr>
<?php

$sql="SELECT * FROM player WHERE id='$id'";
$result=mysql_query($sql);
$mMoney= number_format ($mMoney);

while($r=mysql_fetch_array($result))
{	

$Points=$r["Points"];
$Money=$r["Money"];
$Status=$r["Status"];
$AcademyLevel=$r["AcademyLevel"];
$GirlScout=$r["GirlScout"];
$gold=$r["gold"];
$lastlog=$r["lastlog"];

echo "<tr><td class='tabletd'><font size='1pt'> <B>Points:</B> $Points </TD>
<TD class='tabletd'><font size='1pt'> <B>Money:</B> $$mMoney </TD>
<TD class='tabletd'><font size='1pt'> <B>Status:</B> $Status </TD>
<TD class='tabletd'><font size='1pt'> <B>Level:</B> $AcademyLevel </TD></tr>
<tr><td class='tabletd'><font size='1pt'><B>Girl Scout Cookies:</B> $GirlScout </font></TD>
<TD class='tabletd'><font size='1pt'> <B>Golden Tokens:</B> $gold </font></TD>
<td class='tabletd'><font size='1pt'> <B>Last Log-in:</B> $lastlog </font></TD>
<td class='tabletd'><font size='1pt'> <a href='player_awards.php?id=$id'>Players Awards</A> </font></center>"; 
}

?> 
</td></tr></table>
</td></tr></table>
<br>

<table class=table cellspacing='2' cellpadding='2'>
<tr><TD>
<table Class="table" bordercolor="#000000" cellpadding="2" cellspacing="2" width="550">
   <tr>
     <td class="tablegreen" colspan="5">Horses in Main Barn
     </td>
   </tr>

<?php

$sql="SELECT * FROM horsedata WHERE Owner='$id' and Pregnant!='Yes' and DOB > 0 and retired!='yes' ORDER BY id asc";
$result=mysql_query($sql);

while($r=mysql_fetch_array($result))
{	

$horseid=$r["id"];
$Name=$r["Name"];
$Breed=$r["Breed"];
$Gender=$r["Gender"];
$brand=$r["brand"];
$Forsale=$r["Forsale"];

echo "<TR><TD class='tabletd' width='44px'><center> #$horseid </center></TD>
<TD class='tabletd' width='190px'><font size='2pt'><a href='horse_individual.php?id=$horseid'>$Name</a></td>
<TD class='tabletd' width='40px'><center>$Gender</center></td>
<TD class='tabletd' width='210px'><center> $Breed </center></TD>
<TD class='tabletd'> <font color='#696969'> $brand</font>";

}
?> 
</TD></tr>
<tr><td class="tablegreen" colspan="5">Horses in Retirement Center</td></tr>

<?php

$sql="SELECT * FROM horsedata WHERE Owner='$id' and Retired='Yes'";
$result=mysql_query($sql);

while($r=mysql_fetch_array($result))
{	

$id=$r["id"];
$Name=$r["Name"];
$Breed=$r["Breed"];
$Gender=$r["Gender"];
$Retired=$r["Retired"];

echo "
<TR><TD class='tabletd' width='44px'><center> #$horseid </center></TD>
<TD class='tabletd' width='190px'><font size='2pt'><a href='horse_individual.php?id=$horseid'>$Name</a></TD>
<TD class='tabletd' width='40px'><center>$Gender</center></TD>
<TD class='tabletd' width='210px'><center> $Breed </center></TD>
<TD class='tabletd'> <font color='#696969'> $brand</font>";
}
?> 
</TD></tr>

<tr><td class="tablegreen" colspan="5">Horses in Foaling Block</td></tr>

<?php

$sql="SELECT * FROM horsedata WHERE Owner='$id' and Pregnant='Yes'";
$result=mysql_query($sql);

while($r=mysql_fetch_array($result))
{	

$id=$r["id"];
$Name=$r["Name"];
$Breed=$r["Breed"];
$Gender=$r["Gender"];

echo "<TR><TD class='tabletd' width='150px'><font size='2pt'><a href='horse_individual.php?id=$horseid'>$Name</a></td>
<TD class='tabletd'>$Gender</td><TD class='tabletd'> #$horseid </TD>
<TD class='tabletd'> $Breed </TD><TD class='tabletd'> <font color='#696969'> $brand</font>";
}
?> 
</TD></tr>

<?php

$sql="SELECT * FROM horsedata WHERE Owner='$id' and DOB < 1";
$result=mysql_query($sql);

while($r=mysql_fetch_array($result))
{	

$id=$r["id"];
$Name=$r["Name"];
$Breed=$r["Breed"];
$Gender=$r["Gender"];


echo "<TR><TD class='tabletd' width='150px'><font size='2pt'><a href='horse_individual.php?id=$horseid'>$Name</a></td>
<TD class='tabletd'>$Gender</td>
<TD class='tabletd'> #$horseid </TD>
<TD class='tabletd'> $Breed </TD>
<TD class='tabletd'> <font color='#696969'> $brand</font>";
}
?> 
</TD></tr></table>
</td></tr></table>

<BR>

<table class=table cellspacing='2' cellpadding='2'>
<tr><td>

<table class="table" cellpadding="0" cellspacing="0" width="550">
  <tbody>
    <tr>
      <td class="tablegreen">Your Merit Cabinet</td></tr> 
<tr><td class='tabletd'><center>
<?php 

$playerid=$_GET['id']; 

$sql="SELECT * FROM diplomas WHERE userid='$id'";
$result=mysql_query($sql);

while($r=mysql_fetch_array($result))
{	

$diploma=$r["diploma"];

echo " <img src='$diploma'> ";
}
?>
</td></tr>
<tr><td class='tabletd'>
<?php 


if ($mTeam!=="1") 

{ 


$sql="SELECT * FROM teams WHERE id='$mTeam'";
$result=mysql_query($sql);

while($r=mysql_fetch_array($result))
{	

$name=$r["name"];
$type=$r["type"];
$banner=$r["banner"];

echo " <center><BR><a href='team_page.php'><img src='$banner'> <br>
<b> You are a member of the $name Team! </b><br>
Click to Go to Your Team's Page</a></center>";
}
}
?>
</td></tr></table>
</td></tr></table>

<br><br>

<hr>
<center>

<h3> Update your personal records. </h3>




<?php

echo "
<b> Update Your Player Name </b> <BR><font size='1pt'>Limit of 30 letter/symbols.</font><form name='upname' method='post' action='player_upname.php'>
<input type='hidden' name='id' value='$id'>
<input type='text' MAXLENGTH='30' name='Playername' value='$Playername'>
<input type='submit' value='Update Name'></form>
";


?>

<?php

echo "
<b> Update Your Player Advertisement </b><BR><font size='1pt'>Limit of 70 letter/symbols.</font><form name='upad' method='post' action='player_upad.php'>
<input type='hidden' name='id' value='$id'>
<input type='text' MAXLENGTH='70' name='Ad' VALUE='$Ad'>
<input type='submit' value='Update Advertisement'></form>
"; ?>


<?php

echo "
<br><br>
<b> Update Your Description </b><br>
<form name='uprecords' method='post'
action='player_updesc.php'>
<input type='hidden' name='id' value='$id'>
<textarea cols='56' rows='13' name='Description'>
$Description </textarea><br>
<input type='submit' value='update description'></form>
";

?>

<?php

$sql="SELECT * FROM player WHERE id='$id' ";
$result=mysql_query($sql);

while($r=mysql_fetch_array($result))
{	

$Playername=$r["Playername"];
$pid=$r["id"];

print "
<a href=player_estate.php?action=changepassword1>Change My Password</a><br><Br>";

}
?>


<BR><BR>
<HR><BR><BR>
<b> <a href="buy_cookies.php"> Want Golden Tokens? Buy them here!! </a> <br><br>
<b> <a href="player_upgrade.php"> Upgrade an account today! </a> <br><br>
Go to your <a href="referer.php">Referal Center</a> to refer a player or to see what you can trade your referals in for!<BR><BR>
<B>Find out what cool things you can trade your Girl Scout Cookies/Golden Tokens in for by clicking <a href="http://www.one-stride.net/girlscout.php">here</a>!</b>

<br><br><b> Want to earn referal points? Use one of the <a href="banners.php">banners</a> to advertise! </b><br><br><b> <a href="unattended.php"> Purchase your low digit account today!</a>
<BR>
<BR><BR><BR>





<?php

include 'footer.php';

?>

 

any ideas? it was working then i adjusted something...but i cant remember what and it stopped :(

kendallkamikaze Member

kendallkamikaze

Posted
  • Author
Posted

i tried that. it didnt work. basically theres two different tables...player table then diploma table. player on there is id, player id on diploma is userid. I need it to read that the playerid is equal to userid on the diploma table

Archived

This topic is now archived and is closed to further replies.

Go to topic listing
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.