1. This forum is in read-only mode.

I cant get my pokemon rosters code to work

Discussion in 'Non-Emulation Help' started by king_leo, Mar 7, 2010.

  1. king_leo

    king_leo Well-Known Member

    well im coding a pokemon rpg ok and i made a roster code (dont worry about the background) but it wont work since when you click 1 it does not work it just goes blank again

    here is code:
    Code:
    <?php 
require("db.php");
?>
<center><head><title>TPSRPG :: Manage Roster</title></head>
<div id="centercol">
<center><h2>Manage Roster</h2></center>
<?php
if($_GET['Slot'] && $_GET['ID']){
$check = mysql_num_rows(mysql_query("SELECT * FROM pokemon WHERE owner='".$_COOKIE['ID_my_site']."' AND id='".$_GET['ID']."'"));
if($_GET['Slot']>6 || $_GET['Slot']<0){
echo "<center>Incorrect slot!</center><hr>";
}
else{
if($check==0){
echo "<center>This Pokemon isn't yours!</center><hr>";
}
else {
$slot = mysql_fetch_array(mysql_query("SELECT * FROM pokemon WHERE owner='".$_COOKIE['ID_my_site']."' AND slot='".$_GET['Slot']."'"));
mysql_query("UPDATE pokemon SET slot='0' WHERE owner='".$_COOKIE['ID_my_site']."' AND id='".$slot['id']."'");
mysql_query("UPDATE pokemon SET slot='".$_GET['Slot']."' WHERE owner='".$_COOKIE['ID_my_site']."' AND id='".$_GET['ID']."' ");
$change = mysql_fetch_array(mysql_query("SELECT * FROM pokemon WHERE owner='".$_COOKIE['ID_my_site']."' AND id='".$_GET['ID']."'"));
$sh = $change['shiny'];
$sw = $change['shadow'];
$gold = $change['golden'];
$evnt = $change['event'];
$storm = $change['storm'];
if($sh==1){
$status = "Shiny";}
elseif($sw==1){
$status = "Shadow";}
elseif($gold==1){
$status = "Golden";}
elseif($evnt==1){
$status = "Event";}
elseif($storm1==1){
$status = "Storm";}
else{
$status = '';}
echo "<center>Your slot #".$_GET['Slot']." has been successfully changed to ".$status." ".$change['pokemon']."!</center>";
echo "<hr>";
}
}
}
if($_GET['Reset']==Yes){
mysql_query("UPDATE pokemon SET slot='0' WHERE owner='".$_COOKIE['ID_my_site']."' AND slot='1'");
mysql_query("UPDATE pokemon SET slot='0' WHERE owner='".$_COOKIE['ID_my_site']."' AND slot='2'");
mysql_query("UPDATE pokemon SET slot='0' WHERE owner='".$_COOKIE['ID_my_site']."' AND slot='3'");
mysql_query("UPDATE pokemon SET slot='0' WHERE owner='".$_COOKIE['ID_my_site']."' AND slot='4'");
mysql_query("UPDATE pokemon SET slot='0' WHERE owner='".$_COOKIE['ID_my_site']."' AND slot='5'");
mysql_query("UPDATE pokemon SET slot='0' WHERE owner='".$_COOKIE['ID_my_site']."' AND slot='6'");
echo "<center>Resetted</center><hr>";
}
?>
<center>
<table width="100%" border="1" cellspacing="1" style="text-align: center; font-size:10;">
<th colspan="3">Current Roster

[<a href="roster.php?Type=All&Reset=Yes">Reset Roster</a>]</th>
<tr>
<?php
$g=1;
while($g<=3){
$roster = mysql_fetch_array(mysql_query("SELECT * FROM pokemon WHERE owner='".$_COOKIE['ID_my_site']."' AND slot='$g'"));
$alt = $roster['pokemon'];
$animated = $roster['image'];
$lvl = $roster['lvl'];
$sh = $roster['shiny'];
$sw = $roster['shadow'];
$gold = $roster['golden'];
$evnt = $roster['event'];
$storm = $roster['storm'];
if($sh==1){
$image = $roster['image'];
$pokename = "Shiny ".$roster['pokemon']."";}
elseif($sw==1){
$image = $roster['image'];
$pokename = "Shadow ".$roster['pokemon']."";}
elseif($gold==1){
$image = $roster['image'];
$pokename = "Golden ".$roster['pokemon']."";}
elseif($evnt==1){
$image = $roster['image'];
$pokename = "Event ".$roster['pokemon']."";}
elseif($storm==1){
$image = $roster['image'];
$pokename = "Storm ".$roster['pokemon']."";}
else {
$image = $roster['image'];
$pokename = $roster['pokemon'];}
if($alt==''){
echo "<td colspan='1' width='33%'>No image
None - Level: 0</td>";
}
else{
echo "<td colspan='1' width='33%'><img src='".$image."' alt='".$alt."'/>
".$pokename." (".$roster['gender'].") Level: ".$roster['lvl']."
</td>";
}
$g++;
}
?>
</tr>
<tr>
<?php
$g=4;
while($g<=6){
$roster = mysql_fetch_array(mysql_query("SELECT * FROM pokemon WHERE owner='".$_COOKIE['ID_my_site']."' AND slot='$g'"));
$alt = $roster['pokemon'];
$animated = $roster['image'];
$lvl = $roster['lvl'];
$sh = $roster['shiny'];
$sw = $roster['shadow'];
$gold = $roster['golden'];
$evnt = $roster['event'];
$storm = $roster['storm'];
if($sh==1){
$image = $roster['image'];
$pokename = "Shiny ".$roster['pokemon']."";}
elseif($sw==1){
$image = $roster['image'];
$pokename = "Shadow ".$roster['pokemon']."";}
elseif($gold==1){
$image = $roster['image'];
$pokename = "Golden ".$roster['pokemon']."";}
elseif($evnt==1){
$image = $roster['image'];
$pokename = "Event ".$roster['pokemon']."";}
elseif($storm==1){
$image = $roster['image'];
$pokename = "Storm ".$roster['pokemon']."";}
else {
$image = $roster['image'];
$pokename = $roster['pokemon'];}
if($alt==''){
echo "<td colspan='1' width='33%'>No image
None - Level: 0</td>";
}
else{
echo "<td colspan='1' width='33%'><img src='".$image."' alt='".$alt."'/>
".$pokename." (".$roster['gender'].") Level: ".$roster['lvl']."
</td>";
}
$g++;
}
?>
</tr>
</table>


<table width="480px" border="1" cellspacing="1" style="text-align: center; font-size:10;">
<th colspan="3">Your box</th>
<tr><td colspan="3">[<a href="roster.php?Type=All">All</a>] [Normal] [Shiny]</td></tr>
<?php
if($_GET['Type']==All){
$box = mysql_query("SELECT * FROM pokemon WHERE owner='".$_COOKIE['ID_my_site']."' AND slot='0' ORDER BY pokemon ASC");
while($result = mysql_fetch_array($box)){
$sh = $roster['shiny'];
$sw = $roster['shadow'];
$gold = $roster['golden'];
$evnt = $roster['event'];
$storm = $roster['storm'];
if($sh==1){
$status = "Shiny";}
elseif($sw==1){
$status = "Shadow";}
elseif($gold==1){
$status = "Golden";}
elseif($evnt==1){
$status = "Event";}
elseif($storm==1){
$status = "Storm";}
else{
$status = '';}
echo "<tr><td colspan='2' width='320'>".$status." ".$result['pokemon']." (".$result['gender'].") - Level: ".$result['lvl']."</td>
<td colspan='1' width='160'>[<a href='roster.php?Type=".$_GET['Type']."&Slot=1&ID=".$result['id']."'>1</a>]
[<a href='roster.php?Type=".$_GET['Type']."&Slot=2&ID=".$result['id']."'>2</a>]
[<a href='roster.php?Type=".$_GET['Type']."&Slot=3&ID=".$result['id']."'>3</a>]
[<a href='roster.php?Type=".$_GET['Type']."&Slot=4&ID=".$result['id']."'>4</a>]
[<a href='roster.php?Type=".$_GET['Type']."&Slot=5&ID=".$result['id']."'>5</a>]
[<a href='roster.php?Type=".$_GET['Type']."&Slot=6&ID=".$result['id']."'>6</a>]</td></tr>";
}
}
if($_GET['Type']==Normal)
?>
</table>
</center>
</div>
</center>
    thats the code and if you have a working code or think you do please post and here is what it looks like
    [​IMG]
     
    king_leo, Mar 7, 2010
    #1