Mysidia Adoptables Support Forum

Mysidia Adoptables Support Forum (http://www.mysidiaadoptables.com/forum/index.php)
-   Questions and Supports (http://www.mysidiaadoptables.com/forum/forumdisplay.php?f=18)
-   -   *Grumbles* (http://www.mysidiaadoptables.com/forum/showthread.php?t=2217)

SilverDragonTears 06-24-2011 03:21 PM

*Grumbles*
 
I have done a lot of added coding to my site.. and yesterday I released a new adopt. Now on the myadopt.php page it shows 4 of each new adopt. Can anyone think why this may be happening?

Hall of Famer 06-24-2011 03:34 PM

There are two possibilities:

1. You accidentally copied your adoptables four times.
2. Your mysql query in myadopts.php runs 4 times after you manipulated your codes.

Of course I believe its the second possibility. Cant really be sure atm, would you mind posting the entire script of your myadopts.php to this forum enclosed with [PHP] tags? I will see what I can do to help you.

SilverDragonTears 06-24-2011 03:50 PM

PHP Code:

<?php

include("inc/functions.php");

//***************//
//  START SCRIPT //
//***************//

$id $_GET["id"];
$act $_GET["act"];
$more $_GET["more"];

if(
$isloggedin == "yes"){

if(
$act == ""){
    
$article_title "Your Adoptables";
    
$article_content "

        <center>
        <div style='width: 22%; float: left;'><a href='trade.php'>Trade</a><br>
        <a href='breeding.php'>Breed</a></div>
        <div style='width: 22%; float: left;'><a href='account.php'>Account Settings</a><br>
        <a href='profile.php'>Members List</a></div>
        <div style='width: 22%; float: left;'><a href='donate.php'>Donate to Friends</a><br>
        <a href='sort.php'>Sort Adopts</a></div></center>

        <br>
        <br>
        <br>
        <br>
        Share this link with others to show them your Den<br>
        <input type='text' size='100' value='http://www.robynsworld.net/SilvAdopts/den.php?u=
$loggedinname'><br>
        <a href='http://www.robynsworld.net/SilvAdopts/den.php?u=
$loggedinname'>http://www.robynsworld.net/SilvAdopts/den.php?u=$loggedinname</a><br>
        <table style='width: 720px;' class='vamid'><tbody>
    <tr><th>SilvA Fox</th><th>Name</th><th>Level</th><th>Manage</th><th>Get Codes</th><th>Clicks</th></tr>"
;
    
// We need to get all of the user's adoptables from the database and display them...
    
$query "SELECT * FROM ".$prefix."owned_adoptables, ".$prefix."adoptables, ".$prefix."levels WHERE ".$prefix."owned_adoptables.owner = '{$loggedinname}'"
    
." AND ".$prefix."adoptables.type = ".$prefix."owned_adoptables.type AND ".$prefix."levels.thisislevel = ".$prefix."owned_adoptables.currentlevel AND ".$prefix."levels.adoptiename = "
    
.$prefix."adoptables.type  ORDER BY ".$prefix."owned_adoptables.sort, ".$prefix."owned_adoptables.totalclicks";
    
$result runquery($query);
    
$num mysql_numrows($result);
    
//Loop out code
    
$i=0;
    while (
$i $num) {
        
$aid=@mysql_result($result,$i$prefix."owned_adoptables.aid");
        
$currentlevel=@mysql_result($result,$i$prefix."owned_adoptables.currentlevel");
        
$gender=@mysql_result($result,$i$prefix."owned_adoptables.gender");
        
$isfrozen=@mysql_result($result,$i$prefix."owned_adoptables.isfrozen");
        
$type=@mysql_result($result,$i$prefix."owned_adoptables.type");
        
$name=@mysql_result($result,$i$prefix."owned_adoptables.name");
        
$eggimage=@mysql_result($result,$i$prefix."adoptables.eggimage");
        
$usealternates=@mysql_result($result,$i$prefix."owned_adoptables.usealternates");
        
$totalclicks=@mysql_result($result,$i$prefix."owned_adoptables.totalclicks");
        
$primaryimage=@mysql_result($result,$i$prefix."levels.primaryimage");
        
$alternateimage=@mysql_result($result,$i$prefix."levels.alternateimage");
        if (
$usealternates=='yes') { $image $alternateimage; }
        else { 
$image $primaryimage; }
        if (
$currentlevel==0) { $image $eggimage; }
        if (
$image=='') { $image $primaryimage; }
        
$article_content .= "<tr><td><a href='myadopts.php?act=manage&id={$aid}'><img src='{$image}'></a></td><td>";

if(
$isfrozen == 'no') {
    
$article_content .= '';
} else {
    
$article_content .= '<img src=\'http://inky.org/rpg/agents-maps/snowflake.png\'>';
    
}

$article_content .= "<img src='picuploads/{$gender}.png'> <em><em>".stripslashes($name)."</em></em></td><td>{$currentlevel}</td><td><a href='myadopts.php?act=manage&id={$aid}'>Actions</a></td><td><a href='myadopts.php?act=bbcode&id={$aid}'>Get Codes</a></td><td>{$totalclicks}</td></tr>";
        
$i++;
    }
    
$article_content .= "</tbody></table>";

}
else if(
$act == "manage"){

// We are managing a specific adoptable

if($id == "" or !is_numeric($id)){

$article_title $err_idnoexist;
$article_content $err_idnoexist_text;

}
else{

// See if the adoptable actually exists...

$query "SELECT * FROM ".$prefix."owned_adoptables as o LEFT JOIN ".$prefix."adoptables as a on a.type=o.type WHERE owner='$loggedinname' and aid='$id'";
$result runquery($query);
$num mysql_numrows($result);

//Loop out code
$i=0;
while (
$i 1) {

$aid=@mysql_result($result,$i,"aid"); //The adoptable's ID
$currentlevel=@mysql_result($result,$i,"currentlevel");
$type=@mysql_result($result,$i,"type");
$name=@mysql_result($result,$i,"name");
$tradestatus=@mysql_result($result,$i,"tradestatus");
$father=@mysql_result($result,$i,"father");
$mother=@mysql_result($result,$i,"mother");
$adultdescription=@mysql_result($result,$i,"adultdescription");

$i++;
}

// Check that the adoptable exists for real, or show an error...

if($aid == $id){

// The adoptable does exist, so we show the image and junk to the user...

$image getcurrentimage($id);

$article_title "Managing "  stripslashes($name);
$article_content "<img src='".$image."'><br><br>This page allows you to manage ".stripslashes($name).".  Click on an option below to change settings.<br><br>
<b><a href='levelup.php?id="
.$id."'><img src='templates/icons/add.gif' border=0> Level Up ".stripslashes($name)."</a><br>
<a href='myadopts.php?act=stats&id="
.$id."'><img src='templates/icons/stats.gif' border=0> Get Stats for ".stripslashes($name)."</a><br>
<a href='myadopts.php?act=bbcode&id="
.$id."'><img src='templates/icons/bbcodes.gif' border=0> Get BBCodes / HTML Codes for ".stripslashes($name)."</a><br>
<a href='myadopts.php?act=rename&id="
.$id."'><img src='templates/icons/title.gif' border=0> Rename ".stripslashes($name)."</a><br>
<a href='myadopts.php?act=trade&id="
.$id."'><img src='templates/icons/trade.gif' border=0> Change Trade Status ".stripslashes($name)."</a><br>
<a href='myadopts.php?act=freeze&id="
.$id."'><img src='templates/icons/freeze.gif' border=0> Freeze or Unfreeze ".stripslashes($name)."</a><br>
<a href='myadopts.php?act=pound&id="
.$id."'><img src='templates/icons/delete.gif' border=0> Pound ".stripslashes($name)."</a></b><br>";

}
else{

$article_title $err_idnoexist;
$article_content $err_idnoexist_text;

}

}

// End the MANAGE action code
else if($act == "stats"){

// We are getting the stats for the adoptable
// Check that an ID was submitted...

if(is_numeric($id)){

// Now we see if the adoptable actually exists...

$query "SELECT * FROM ".$prefix."owned_adoptables as o LEFT JOIN ".$prefix."adoptables as a on o.type=a.type WHERE owner='$loggedinname' and aid='$id'";
$result runquery($query);
$num mysql_numrows($result);

//Loop out code
$i=0;
while (
$i 1) {

$aid=@mysql_result($result,$i,"aid"); //The adoptable's ID
$currentlevel=@mysql_result($result,$i,"currentlevel");
$type=@mysql_result($result,$i,"type");
$name=@mysql_result($result,$i,"name");
$totalclicks=@mysql_result($result,$i,"totalclicks");
$gender=@mysql_result($result,$i,"gender");
$isfrozen=@mysql_result($result,$i,"isfrozen");
$tradestatus=@mysql_result($result,$i,"tradestatus");
$father=@mysql_result($result,$i,"father");
$mother=@mysql_result($result,$i,"mother");

$getFather mysql_query('SELECT `name` 
                           FROM ' 
$prefix 'owned_adoptables 
                           WHERE `aid` = ' 
$father
                         
);
                         
$getMother mysql_query('SELECT `name` 
                           FROM ' 
$prefix 'owned_adoptables 
                           WHERE `aid` = ' 
$mother
                         
);

$nFather mysql_fetch_assoc($getFather);
$nFather $nFather['name'];
$nMother mysql_fetch_assoc($getMother);
$nMother $nMother['name'];
$adultdescription=@mysql_result($result,$i,"adultdescription");

$i++;
}

if(
$aid == $id){

// The adoptable exists, so we show the stats for it...


$image getcurrentimage($id);
$nextlevelexists getnextlevelexists($type$currentlevel);

$nextlevel "";

// If a higher level exists, get that level's information...

if($nextlevelexists == "true"){

$nextlevel $currentlevel 1;

$query "SELECT * FROM ".$prefix."levels WHERE adoptiename='$type' and thisislevel='$nextlevel'";
$result runquery($query);
$num mysql_numrows($result);

$i=0;
while (
$i 1) {

$requiredclicks=@mysql_result($result,$i,"requiredclicks"); //The adoptable's ID


$i++;
}


// End grab next level info...

// Determine what to show for next level:

if($nextlevelexists == "true" and $nextlevel != ""){

// See how many more clicks to go

$ctg $requiredclicks totalclicks;

$nloutput $nextlevel."<br>Clicks Required for Level Increase: ".$ctg;

}
else{

$nloutput "This adoptable is at its maximum level";

}


$article_title stripslashes($name)."'s Statistics:";
$article_content "<img src='".$image."'><br><br>
<b>Total Clicks: "
.$totalclicks."<br>";

if(
$isfrozen == 'no') {
    
$article_content .= '';
} else {
    
$article_content .= '<img src=\'http://inky.org/rpg/agents-maps/snowflake.png\'> ';
     
}

$article_content .= "
Gender: <img src='picuploads/
{$gender}.png'><br>";

if(
$nFather == '' && $nMother == '') {
    
$article_content .= 'Den born<br>';
} else {
    
$article_content .= 'Father: ' $nFather '<br> 
                  Mother: ' 
$nMother '<br>';
    
}

$article_content .= "Trade Status: ".$tradestatus."<br> 
Current Level: "
.$currentlevel."<br>
Next Level: "
.$nloutput."<br>

<b>Description:<br>
 "
.$adultdescription."<br>";
}
else{

$article_title $err_idnoexist;
$article_content $err_idnoexist_text;

}

}
else{

$article_title $err_idnoexist;
$article_content $err_idnoexist_text;


}


}

 
// End the STATS code
else if($act == "bbcode"){

if(
is_numeric($id)){

// Now we see if the adoptable actually exists...

$query "SELECT * FROM ".$prefix."owned_adoptables WHERE owner='$loggedinname' and aid='$id'";
$result runquery($query);
$num mysql_numrows($result);

//Loop out code
$i=0;
while (
$i 1) {

$aid=@mysql_result($result,$i,"aid"); //The adoptable's ID
$currentlevel=@mysql_result($result,$i,"currentlevel");
$type=@mysql_result($result,$i,"type");
$name=@mysql_result($result,$i,"name");
$totalclicks=@mysql_result($result,$i,"totalclicks");
$isfrozen=@mysql_result($result,$i,"isfrozen");

$i++;
}

if(
$aid == $id){

$altbb grabanysetting("usealtbbcode");

// Adoptable exists, so show the BBCode:

$article_title "Codes for ".stripslashes($name);
$article_content $lang_bbcode_explain."<br>
<p><u>Forum Codes / BBCode: </u></p>
<p>
  <textarea name='textarea' cols='50' rows='4'>[url=http://www."
.$domain."".$scriptpath."/levelup.php?id=".$aid."][img]http://www.".$domain."".$scriptpath."/siggy.php?id=".$aid."[/img][/url]
</textarea>
</p>"
;

if(
$altbb == "yes"){

// Use the seo friendly alternate bbcodes...

$article_content $article_content."<p><u>Alternate BBCodes (Use if the above do not work on a forum): </u></p>
<p>
  <textarea name='textarea' cols='50' rows='4'>[url=http://www."
.$domain."".$scriptpath."/levelup.php?id=".$aid."][img]http://www.".$domain."".$scriptpath."/get/".$aid.".gif[/img][/url]
</textarea>
</p>"
;

}



$article_content $article_content."<p><u>HTML Code</u>:</p>
<p>
<textarea name='textarea' cols='50' rows='4'><a href=\"http://www."
.$domain."".$scriptpath."/levelup.php?id=".$aid."\" target=\"_blank\">
<img src=\"http://www."
.$domain."".$scriptpath."/siggy.php?id=".$aid."\" border=0></a>
  </textarea>
   
</p>"
;

}
else{

$article_title $err_idnoexist;
$article_content $err_idnoexist_text;

}


}
else{

$article_title $err_idnoexist;
$article_content $err_idnoexist_text;

}




// End the BBCODE generation for the adoptable...
else if($act == "rename"){

// We are renaming an adoptable

if(is_numeric($id)){

// Now we see if the adoptable actually exists...

$query "SELECT * FROM ".$prefix."owned_adoptables WHERE owner='$loggedinname' and aid='$id'";
$result runquery($query);
$num mysql_numrows($result);

//Loop out code
$i=0;
while (
$i 1) {

$aid=@mysql_result($result,$i,"aid"); //The adoptable's ID
$currentlevel=@mysql_result($result,$i,"currentlevel");
$type=@mysql_result($result,$i,"type");
$name=@mysql_result($result,$i,"name");
$totalclicks=@mysql_result($result,$i,"totalclicks");
$isfrozen=@mysql_result($result,$i,"isfrozen");

$i++;
}

if(
$aid == $id){

$image getcurrentimage($id);

if(
$isfrozen != "yes"){

if(
$more == ""){

$article_title "Rename ".stripslashes($name);
$article_content "<img src='".$image."'><br>".$lang_rename."".stripslashes($name)."".$lang_rename2."<br>
<form name='form1' method='get' action='myadopts.php'>
  <p>Adoptable Name: 
    <input name='more' type='text' id='more'>
    <input name='id' type='hidden' id='id' value='"
.$id."'>
    <input name='act' type='hidden' id='act' value='rename'>
</p>
  <p>
    <input type='submit' name='Submit' value='Rename Adoptable'>
</p>
</form>"
;

}
else{

// We are renaming the adoptable

// The adoptable exists, so now we can rename it...

$query "UPDATE ".$prefix."owned_adoptables SET name='".$more."' WHERE aid='".$id."' and owner='".$loggedinname."'";
runquery($query);


$article_title $lang_rename_success_title;
$article_content "<img src='".$image."'><br>".$lang_rename_success."".$more.".  You can now manage ".$more." on the <a href='myadopts.php?act=manage&id=".$id."'>My Adopts</a> page.";

}
}
else{

// We cannot rename a frozen adoptable...

$article_title $lang_frozen_title;
$article_content $lang_frozen."<a href='manage.php?act=freeze&id=".$id."&more=unfreeze'>unfreeze</a> ".$lang_frozen2;

}


}
else{

$article_title $err_idnoexist;
$article_content $err_idnoexist_text;

}
}
else{

$article_title $err_idnoexist;
$article_content $err_idnoexist_text;

}

}

else if(
$act == "trade"){

// We are setting the trade status for an adoptable...


if(is_numeric($id)){

// Now we see if the adoptable actually exists...

$query "SELECT * FROM ".$prefix."owned_adoptables WHERE owner='$loggedinname' and aid='$id'";
$result mysql_query($query);
$num mysql_numrows($result);

//Loop out code
$i=0;
while (
$i 1) {

$aid=@mysql_result($result,$i,"aid"); //The adoptable's ID
$tradestatus=@mysql_result($result,$i,"tradestatus");

$i++;
}

if(
$aid == $id){

$image getcurrentimage($id); // Get the image for the adopt...

if($more == ""){

$article_title "Setting trade status for ".stripslashes($name);
$article_content "Are you sure you wish to change the trade status of this adoptable?<center><b><a href='myadopts.php?act=trade&id=".$id."&more=confirm'>Yes I'd like to change its trade status</a></b><br><br>
<b><a href='myadopts.php'>Nope I change my mind!  Go back to the previous page.</a></b></center><br>"
;

}

else if(
$more == "confirm"){  
  if(
$tradestatus == "fortrade"){
  
$newtradestatus "notfortrade";
  
$query "UPDATE ".$prefix."owned_adoptables SET tradestatus='".$newtradestatus."' WHERE aid='".$id."' and owner='".$loggedinname."'";
  
runquery($query);
  
$article_title "Change trade status successfully";
  
$article_content "The adoptable's trade status is now Not for Trade";
  }                
  else if(
$tradestatus == "notfortrade"){
  
$newtradestatus "fortrade";
  
$query "UPDATE ".$prefix."owned_adoptables SET tradestatus='".$newtradestatus."' WHERE aid='".$id."' and owner='".$loggedinname."'";
  
runquery($query);
  
$article_title "Change trade status successfully";
  
$article_content "The adoptable's trade status is now For Trade";
  }
  else{
  
$article_title "Something is very very wrong";
  
$article_content "Please check phpmyadmin to see if the settings are correct, or report your issue to Mysidia Adoptables support forum";
  }
}

else{

$article_title "Invalid Action";
$article_content "Invalid Action Specified";

}
}

else{

$article_title $err_idnoexist;
$article_content $err_idnoexist;

}
}
else{

$article_title $err_idnoexist;
$article_content $err_idnoexist_text;

}

}

else if(
$act == "freeze"){

// We are freezing an adoptable here...

if(is_numeric($id)){

// Now we see if the adoptable actually exists...

$query "SELECT * FROM ".$prefix."owned_adoptables WHERE owner='$loggedinname' and aid='$id'";
$result runquery($query);
$num mysql_numrows($result);

//Loop out code
$i=0;
while (
$i 1) {

$aid=@mysql_result($result,$i,"aid"); //The adoptable's ID
$currentlevel=@mysql_result($result,$i,"currentlevel");
$type=@mysql_result($result,$i,"type");
$name=@mysql_result($result,$i,"name");
$totalclicks=@mysql_result($result,$i,"totalclicks");
$isfrozen=@mysql_result($result,$i,"isfrozen");

$i++;
}

if(
$aid == $id){

$image getcurrentimage($id); // Get the image for the adopt...

if($more == ""){

if(
$isfrozen == "yes"){
$status "<img src='templates/icons/freeze.gif'> Frozen<br>";
$go "<a href='myadopts.php?act=freeze&id=".$id."&more=unfreeze'><img src='templates/icons/unfreeze.gif' border=0> Unfreeze This Adoptable</a>";
}
else{
$status "<img src='templates/icons/unfreeze.gif'> Not Frozen<br>";
$go "<a href='myadopts.php?act=freeze&id=".$id."&more=freeze'><img src='templates/icons/freeze.gif' border=0> Freeze This Adoptable</a>";
}

$article_title $lang_freeze_title;
$article_content "<img src='".$image."'><br><b>".stripslashes($name)."'s Current Status: ".$status."</b><br>".$lang_freeze."<br><br><b>".$go."</b><br><br>
"
.$lang_freeze_warning."";



}
else{

// We are actually freezing or unfreezing the adopt...

$frz "no";

if(
$more == "freeze"){

$frz "yes";

}

$query "UPDATE ".$prefix."owned_adoptables SET isfrozen='".$frz."' WHERE aid='".$id."' and owner='".$loggedinname."'";
runquery($query);

if(
$frz == "yes"){
$article_title stripslashes($name)." Frozen Successfully";
}
else{
$article_title stripslashes($name)." Unfrozen Successfully";
}

$article_content "Action Complete.  You may now manage ".stripslashes($name)." on the <a href='myadopts.php?act=manage&id=".$id."'>My Adopts</a> page.";





}

}
else{

$article_title $err_idnoexist;
$article_content $err_idnoexist_text;

}
}
else{

$article_title $err_idnoexist;
$article_content $err_idnoexist_text;

}


}

else if(
$act == "pound"){


if(
is_numeric($id)){

// Now we see if the adoptable actually exists...

$query "SELECT * FROM ".$prefix."owned_adoptables WHERE owner='$loggedinname' and aid='$id'";
$result runquery($query);
$num mysql_numrows($result);

//Loop out code
$i=0;
while (
$i 1) {

$aid=@mysql_result($result,$i,"aid"); //The adoptable's ID
$currentlevel=@mysql_result($result,$i,"currentlevel");
$type=@mysql_result($result,$i,"type");
$name=@mysql_result($result,$i,"name");
$totalclicks=@mysql_result($result,$i,"totalclicks");
$isfrozen=@mysql_result($result,$i,"isfrozen");

$i++;
}

if(
$aid == $id){

$image getcurrentimage($id); // Get the image for the adopt...

if($more == ""){

$article_title "Pound ".stripslashes($name);
$article_content "<img src='".$image."'><br>".$lang_pound."<br><br>".$lang_pound_warning."<br><br>
<center><b><a href='myadopts.php?act=pound&id="
.$id."&more=confirm'><img src='templates/icons/delete.gif' border=0> Pound ".stripslashes($name)." - I dont want it anymore! <img src='templates/icons/delete.gif' border=0></a></b><br><br>
<b><a href='myadopts.php'><img src='templates/icons/yes.gif' border=0> DO NOT Pound "
.stripslashes($name)."! <img src='templates/icons/yes.gif' border=0></a></b></center><br>";

}
else if(
$more == "confirm"){

// Actually run the execution

$query "UPDATE ".$prefix."owned_adoptables SET owner='SYSTEM' WHERE aid='".$id."'";
runquery($query); 

$article_title $lang_pound_title_complete;
$article_content $lang_pound_complete;

}
else{

$article_title "Invalid Action";
$article_content "Invalid Action Specified";

}


}
else{

$article_title $err_idnoexist;
$article_content $err_idnoexist_text;

}
}
else{

$article_title $err_idnoexist;
$article_content $err_idnoexist_text;

}

}
else{

// No valid action specified :: show an error

$article_title $lang_invalid_action_title;
$article_content $lang_invalid_action;

}



}
else{

$article_title $accden;
$article_content $reqlogin;

// End is logged in check else


//***************//
//  OUTPUT PAGE  //
//***************//

echo showpage($article_title$article_content$date);

?>


SilverDragonTears 06-24-2011 09:18 PM

Finally hours and one headache later I fixed it ^^

Hall of Famer 06-25-2011 03:04 PM

umm wait a sec, you figured out what went wrong already? I just happened to read your script and was thinking about how to fix it. XD

SilverDragonTears 06-28-2011 05:46 PM

=) Somehow there were extra images in the database of that certain egg so I just removed them and then it was fixed =) I think I underestimate my ability to fix things sometimes =p

Hall of Famer 06-29-2011 03:10 PM

Ah thats good to know, there must be a reason why you had duplicated entries in your database all of a sudden. If you believe it was a bug, let us know and we will see whether theres a way to prevent it from ever happening.


All times are GMT -5. The time now is 12:12 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.