Thread: Mys 1.3.1 Group sort
View Single Post
  #17  
Old 05-06-2012, 03:22 AM
StarGirl's Avatar
StarGirl StarGirl is offline
Member
 
Join Date: Feb 2012
Posts: 45
Gender: Female
Credits: 8,063
StarGirl is on a distinguished road
Default

Quote:
Originally Posted by Aasixx View Post
Alright, here's myadopts.php
Code:
<?php

include("functions/functions.php");
include("functions/functions_users.php");
include("functions/functions_adopts.php");
include("css/pagination.css");
include("inc/lang.php");

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

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

if($isloggedin == "yes"){
	if($act == ""){
		$article_title = "Your Adoptables";
		// We need to get all of the user's adoptables from the database and display them...
 		$query = "SELECT * FROM ".constant("PREFIX")."owned_adoptables, 
								".constant("PREFIX")."adoptables, 
								".constant("PREFIX")."levels WHERE 	".constant("PREFIX")."owned_adoptables.owner = '{$loggedinname}' 
														AND ".constant("PREFIX")."adoptables.type = ".constant("PREFIX")."owned_adoptables.type 
														AND ".constant("PREFIX")."levels.thisislevel = ".constant("PREFIX")."owned_adoptables.currentlevel 
														AND ".constant("PREFIX")."levels.adoptiename = ".constant("PREFIX")."adoptables.type 
														ORDER BY ".constant("PREFIX")."owned_adoptables.totalclicks";
	    $rowsperpage = 10;
        $pagination = new Pagination($adopts, $query, $rowsperpage, "http://www.".constant("DOMAIN").constant("SCRIPTPATH")."/myadopts.php");
        $pagination->setPage($_GET[page]);
	    $query = "SELECT * FROM ".constant("PREFIX")."owned_adoptables, 
								".constant("PREFIX")."adoptables, 
								".constant("PREFIX")."levels WHERE 	".constant("PREFIX")."owned_adoptables.owner = '{$loggedinname}' 
														AND ".constant("PREFIX")."adoptables.type = ".constant("PREFIX")."owned_adoptables.type 
														AND ".constant("PREFIX")."levels.thisislevel = ".constant("PREFIX")."owned_adoptables.currentlevel 
														AND ".constant("PREFIX")."levels.adoptiename = ".constant("PREFIX")."adoptables.type 
														ORDER BY ".constant("PREFIX")."owned_adoptables.totalclicks LIMIT {$pagination->getLimit()},{$rowsperpage}";
		$stmt = $adopts->query($query);

		$article_content = "<table>
								<tr>
									<th></th><th>Name and Type</th><th>Image</th><th>Clicks</th>
								</tr>";

		while($row = $stmt->fetchObject()){
			if($row->usealternates == 'yes') $image = $row->alternateimage; 
			else $image = $row->primaryimage; 
			if($row->currentlevel == 0) $image = $row->eggimage; 
			if($image=='') $image = $row->primaryimage; 
			
			$article_content .= "<tr>
									<td><center><img src='picuploads/{$row->gender}.png'></center></td>
									<td><center><em>{$row->name}</em> the {$row->type}</center></td>
									<td><center><a href='myadopts.php?act=manage&id={$row->aid}'><img src='{$image}'></a></center></td>
									<td><center>{$row->totalclicks}</center></td>
								</tr>";
		}
		$article_content .= "</table><br /><br />{$pagination->showPage()}</div>";
	}
	elseif($act == "manage"){
	
		// We are managing a specific adoptable		
		if(!is_numeric($id)){
			$article_title = $err_idnoexist;
			$article_content = $err_idnoexist_text;
		}
		else{
			// See if the adoptable actually exists...

			$row = $adopts->select("owned_adoptables", array(), "owner='{$loggedinname}' and aid='{$id}'")->fetchObject();	

			// Check that the adoptable exists for real, or show an error...
			if($row->aid == $id){
			
				// The adoptable does exist, so we show the image and junk to the user...
				$image = getcurrentimage($id);
				$article_title = "Managing {$row->name}";
				$article_content = "<img src='{$image}'><br /><br />This page allows you to manage {$row->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 {$row->name}</a><br />
									<a href='myadopts.php?act=stats&id={$id}'><img src='templates/icons/stats.gif' border=0> Get Stats for {$row->name}</a><br />
									<a href='myadopts.php?act=bbcode&id={$id}'><img src='templates/icons/bbcodes.gif' border=0> Get BBCodes / HTML Codes for {$row->name}</a><br />
									<a href='myadopts.php?act=rename&id={$id}'><img src='templates/icons/title.gif' border=0> Rename {$row->name}</a><br />
									<a href='myadopts.php?act=trade&id={$id}'><img src='templates/icons/trade.gif' border=0> Change Trade Status {$row->name}</a><br />
									<a href='myadopts.php?act=freeze&id={$id}'><img src='templates/icons/freeze.gif' border=0> Freeze or Unfreeze {$row->name}</a><br />

<a href='myadopts.php?act=group&id={$id}'> Group {$row->name}</a><br />  
									<a href='myadopts.php?act=pound&id={$id}'><img src='templates/icons/delete.gif' border=0> Pound {$row->name}</a></b>";
			}
			else{
				$article_title = $err_idnoexist;
				$article_content = $err_idnoexist_text;
			}
		}
	} // End the MANAGE action code
	elseif($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...

			$row = $adopts->select("owned_adoptables", array(), "owner='{$loggedinname}' and aid='{$id}'")->fetchObject();				
			if($row->aid == $id){
				// The adoptable exists, so we show the stats for it...

				$image = getcurrentimage($id);
				$nextlevelexists = getnextlevelexists($row->type, $row->currentlevel);

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

				if($nextlevelexists == TRUE){
					$nextlevel = $row->currentlevel + 1;

					$levels = $adopts->select("levels", array(), "adoptiename='{$row->type}' and thisislevel='{$nextlevel}'")->fetchObject();	
					$requiredclicks= $levels->requiredclicks; //The adoptable's ID

				} // 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 - $row->totalclicks;
					$nloutput = "{$nextlevel}<br />Clicks Required for Level Increase: {$ctg}";
				}
				else $nloutput = "This adoptable is at its maximum level";

				$article_title = "{$row->name}'s Statistics:";
				$article_content = "<img src='{$image}'><br /><br />
									<b>Total Clicks: {$row->totalclicks}<br />
									Gender: <img src='picuploads/{$row->gender}.png'><br />
									Trade Status: {$row->tradestatus}<br />
									Current Level: {$row->currentlevel}<br />
									Next Level: {$nloutput}<br /></b>";

				// Voters Information...

				$article_content .= "<h2>{$row->name}'s Voters:</h2><br />
									{$lang_voters_explain}<br /><br />
									<table width='450' border='1'>
										<tr>
											<td width='129'><strong>Username:</strong></td>
											<td width='156'><strong>Date Voted: </strong></td>
											<td width='82'><strong>Profile:</strong></td>
											<td width='55'><strong>PM:</strong></td>
										</tr>";

				// Select the voters from the DB

				$stmt = $adopts->select("vote_voters", array(), "adoptableid='{$id}' ORDER BY date DESC LIMIT 10");
				while($row = $stmt->fetchObject()) {
					if($row->username == "") $row->username = "Guest";
					if($row->username == "Guest"){
						$article_content .= "<tr>
											<td><div align='left'>Guest</div></td>
											<td><div align='left'>{$row->date}</div></td>
											<td><div align='center'></div></td>
											<td><div align='center'></div></td>
										</tr>";
					}
					else{
						$article_content .= "<tr>
											<td><div align='left'>{$row->username}</div></td>
											<td><div align='left'>{$row->date}</div></td>
											<td><div align='center'><a href='profile.php?user={$row->username}' target='_blank'><img src='templates/buttons/profile.gif' border=0></a></div></td>
											<td><div align='center'><a href='messages.php?act=newpm&user={$row->username}' target='_blank'><img src='templates/buttons/pm.gif' border=0></a></div></td>
										</tr>";
					}
				}
				$article_content .= "</table><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
	elseif($act == "bbcode"){
		if(is_numeric($id)){
			// Now we see if the adoptable actually exists...

			$row = $adopts->select("owned_adoptables", array(), "owner='{$loggedinname}' and aid='{$id}'")->fetchObject();				
			if($row->aid == $id){
				$altbb = grabanysetting("usealtbbcode");

				// Adoptable exists, so show the BBCode:
				$article_title = "Codes for {$row->name}";
				$article_content = "{$lang_bbcode_explain}<br />
									<p><u>Forum Codes / BBCode: </u></p>
									<p>
										<textarea name='textarea' cols='50' rows='4'>
											
										</textarea>
									</p>";

				if($altbb == "yes"){
				
					// Use the seo friendly alternate bbcodes...
					$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'>
											
										</textarea>
									</p>";
				}				
				$article_content .= "<p><u>HTML Code</u>:</p>
									<p>
										<textarea name='textarea' cols='50' rows='4'>
											<a href=\"http://www.".constant("DOMAIN").constant("SCRIPTPATH")."/levelup.php?id={$row->aid}\" target=\"_blank\">
												<img src=\"http://www.".constant("DOMAIN").constant("SCRIPTPATH")."/siggy.php?id={$row->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...
	elseif($act == "rename"){
		// We are renaming an adoptable

		if(is_numeric($id)){
		
			// Now we see if the adoptable actually exists...
			$row = $adopts->select("owned_adoptables", array(), "owner='{$loggedinname}' and aid='{$id}'")->fetchObject();	

			if($row->aid == $id){
			
				$image = getcurrentimage($id);
				if($row->isfrozen != "yes"){
					if($more == ""){
						$article_title = "Rename {$row->name}";
						$article_content = "<img src='{$image}'><br />{$lang_rename}{$row->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, lets first check if the user is its original owner.
                        $row = $adopts->select("pounds", array(), "aid='{$id}'")->fetchObject();
	                    if(!empty($row->firstowner) and $loggedinname != $row->firstowner){
                            $article_title = "Cannot rename";
                            $article_content = "The site admin has specified that only original owners can rename their adoptables.";                     
                        }
                        else{						
					   	    $adopts->update("owned_adoptables", array("name" => $more), "aid='{$id}' and owner='{$loggedinname}'");
						    $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;
		}
	}
	elseif($act == "trade"){
		// We are setting the trade status for an adoptable...

		if(is_numeric($id)){
			// Now we see if the adoptable actually exists...

			$row = $adopts->select("owned_adoptables", array(), "owner='{$loggedinname}' and aid='{$id}'")->fetchObject();	
			if($row->aid == $id){
				$image = getcurrentimage($id); // Get the image for the adopt...

				if($more == ""){
					$article_title = "Setting trade status for {$row->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 />";
				}
				elseif($more == "confirm"){ 			
					$article_title = "Change trade status successfully";
					if($row->tradestatus == "fortrade"){
						$adopts->update("owned_adoptables", array("tradestatus" => 'notfortrade'), "aid='{$id}' and owner='{$loggedinname}'");
						$article_content = "The adoptable's trade status is now Not for Trade";
					}                
					elseif($row->tradestatus == "notfortrade"){
					    $adopts->update("owned_adoptables", array("tradestatus" => 'fortrade'), "aid='{$id}' and owner='{$loggedinname}'");
						$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;
		}
	}
	elseif($act == "freeze"){
		// We are freezing an adoptable here...

		if(is_numeric($id)){
			// Now we see if the adoptable actually exists...

			$row = $adopts->select("owned_adoptables", array(), "owner='{$loggedinname}' and aid='{$id}'")->fetchObject();	
			if($row->aid == $id){
			
				$image = getcurrentimage($id); // Get the image for the adopt...
				if($more == ""){
					if($row->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>{$row->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...

					if($more == "freeze"){
						$frz = "yes";
						$article_title = "{$row->name} Frozen Successfully";
					}
					elseif($more == "unfreeze"){
						$frz = "no";
						$article_title = "{$row->name} Unfrozen Successfully";
					}

					$adopts->update("owned_adoptables", array("isfrozen" => $frz), "aid='{$id}' and owner='{$loggedinname}'");
					$article_content = "Action Complete. You may now manage {$row->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;
		}
	}
	elseif($act == "pound"){
		if(is_numeric($id)){
		
			// Now we see if the adoptable actually exists...
			$row = $adopts->select("owned_adoptables", array(), "owner='{$loggedinname}' and aid='{$id}'")->fetchObject();	
			if($row->aid == $id){
				$image = getcurrentimage($id); // Get the image for the adopt...
				if($more == ""){
					$article_title = "Pound {$row->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 {$row->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 {$row->name}! <img src='templates/icons/yes.gif' border=0></a></b></center><br />";
				}
				elseif($more == "confirm"){
					// Validate the pet can be pounded
					$adopt = new Pound($row->aid, "pound");
                    if($adopt->settings->system->active == "no"){
   	                   $article_title = "Invalid Action";
		               $article_content = "The admin has turned off pound feature, please contact him/her for further explanation.";                    
                    }
                    elseif($adopt->validate() == TRUE){
	                   $adopt->dopound();
	                   $article_title = $lang_pound_title_complete;
		               $article_content = $adopt->message;
	                }
	                else{
	                   $article_title = "An error has occurred";
                       $article_content = $adopt->message;	 
	                }
				}
				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;
		}
	elseif($act == "group"){
            if(is_numeric($id)){
        
            // Now we see if the adoptable actually exists...
            $row = $adopts->select("owned_adoptables", array(), "owner='{$loggedinname}' and aid='{$id}'")->fetchObject();    
            $petname = $row->name;
            if($row->aid == $id){
$row = $adopts->select("owned_adoptables", array(), "owner='{$loggedinname}' and aid='{$id}'")->fetchObject();
        $article_title = "Group {$row->name}";
         if($row->group == 0){
        $article_content = "{$row->name} is not in a group. ";
         }
         else{
         $groupname = $row->group;
         $row = $adopts->select("pet_groups", array(), "user='{$loggedinname}' and id='{$groupname}'")->fetchObject();
         $groupname = $row->name;
         $article_content = "{$row->name} is in the group '{$groupname}'.";
         }
      $article_content .= "Select a group to move {$petname} into:<br><br>";
$stmt = $adopts->select("pet_groups", array(), "user='{$loggedinname}'");
while($row = $stmt->fetchObject()) {
  $groupid=$row->id;
  $name=$row->name;
  $code .= "<option value='{$groupid}'>{$name}</option>";
}

$article_content .= "  <form name='form' method='get' action='hatchery.php?'>
<input name='id' type='hidden' id='id' value='{$id}'>
<input name='act' type='hidden' id='act' value='changegroup'>
    <select name='group' id='group'>
      <option value='none' selected> </option>
    {$code}
    </select><br>
 <input type='submit' name='submit' value='Move'>
    </form>";
           }
     }
}
elseif($act == "changegroup"){
// Check if form was submitted
  if($submit == "Move"){
  // Check group exists
        $row = $adopts->select("pet_groups", array(), "user='{$loggedinname}' and id='{$group}'")->fetchObject();    
    if($row->id == $group and $row->user == $loggedinname){
    // Check if pet exists
        $row = $adopts->select("owned_adoptables", array(), "owner='{$loggedinname}' and aid='{$id}'")->fetchObject();    
        if($row->aid == $id){
        // Move it
         $adopts->update("owned_adoptables", array("group" => $group), "aid='{$id}' and owner='{$loggedinname}'");
            $article_title = "Moved {$row->name}";
                        $article_content = "{$row->name} was moved to a new group.<br><br>
                        <a href='groups.php?id={$group}'>Check out the new group</a>";
        }
        else{
        $article_title = "Invalid ID";
                $article_content = "This pet doesn't exist.";
        }
    }
    else{
    $article_title = "Invalid Group";
        $article_content = "This group doesn't exist.";
    }
  }
  else{
  $article_title = "";
  $article_content = "";
  }
}
    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);

?>
Yeah, the if's got caught up somewhere. Try replacing it all with:
PHP Code:
<?php

include("functions/functions.php");
include(
"functions/functions_users.php");
include(
"functions/functions_adopts.php");
include(
"css/pagination.css");
include(
"inc/lang.php");

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

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

if(
$isloggedin == "yes"){
    if(
$act == ""){
        
$article_title "Your Adoptables";
        
// We need to get all of the user's adoptables from the database and display them...
         
$query "SELECT * FROM ".constant("PREFIX")."owned_adoptables, 
                                "
.constant("PREFIX")."adoptables, 
                                "
.constant("PREFIX")."levels WHERE     ".constant("PREFIX")."owned_adoptables.owner = '{$loggedinname}
                                                        AND "
.constant("PREFIX")."adoptables.type = ".constant("PREFIX")."owned_adoptables.type 
                                                        AND "
.constant("PREFIX")."levels.thisislevel = ".constant("PREFIX")."owned_adoptables.currentlevel 
                                                        AND "
.constant("PREFIX")."levels.adoptiename = ".constant("PREFIX")."adoptables.type 
                                                        ORDER BY "
.constant("PREFIX")."owned_adoptables.totalclicks";
        
$rowsperpage 10;
        
$pagination = new Pagination($adopts$query$rowsperpage"http://www.".constant("DOMAIN").constant("SCRIPTPATH")."/myadopts.php");
        
$pagination->setPage($_GET[page]);
        
$query "SELECT * FROM ".constant("PREFIX")."owned_adoptables, 
                                "
.constant("PREFIX")."adoptables, 
                                "
.constant("PREFIX")."levels WHERE     ".constant("PREFIX")."owned_adoptables.owner = '{$loggedinname}
                                                        AND "
.constant("PREFIX")."adoptables.type = ".constant("PREFIX")."owned_adoptables.type 
                                                        AND "
.constant("PREFIX")."levels.thisislevel = ".constant("PREFIX")."owned_adoptables.currentlevel 
                                                        AND "
.constant("PREFIX")."levels.adoptiename = ".constant("PREFIX")."adoptables.type 
                                                        ORDER BY "
.constant("PREFIX")."owned_adoptables.totalclicks LIMIT {$pagination->getLimit()},{$rowsperpage}";
        
$stmt $adopts->query($query);

        
$article_content "<table>
                                <tr>
                                    <th></th><th>Name and Type</th><th>Image</th><th>Clicks</th>
                                </tr>"
;

        while(
$row $stmt->fetchObject()){
            if(
$row->usealternates == 'yes'$image $row->alternateimage
            else 
$image $row->primaryimage
            if(
$row->currentlevel == 0$image $row->eggimage
            if(
$image==''$image $row->primaryimage
            
            
$article_content .= "<tr>
                                    <td><center><img src='picuploads/
{$row->gender}.png'></center></td>
                                    <td><center><em>
{$row->name}</em> the {$row->type}</center></td>
                                    <td><center><a href='myadopts.php?act=manage&id=
{$row->aid}'><img src='{$image}'></a></center></td>
                                    <td><center>
{$row->totalclicks}</center></td>
                                </tr>"
;
        }
        
$article_content .= "</table><br /><br />{$pagination->showPage()}</div>";
    }
    elseif(
$act == "manage"){
    
        
// We are managing a specific adoptable        
        
if(!is_numeric($id)){
            
$article_title $err_idnoexist;
            
$article_content $err_idnoexist_text;
        }
        else{
            
// See if the adoptable actually exists...

            
$row $adopts->select("owned_adoptables", array(), "owner='{$loggedinname}' and aid='{$id}'")->fetchObject();    

            
// Check that the adoptable exists for real, or show an error...
            
if($row->aid == $id){
            
                
// The adoptable does exist, so we show the image and junk to the user...
                
$image getcurrentimage($id);
                
$article_title "Managing {$row->name}";
                
$article_content "<img src='{$image}'><br /><br />This page allows you to manage {$row->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 {$row->name}</a><br />
                                    <a href='myadopts.php?act=stats&id=
{$id}'><img src='templates/icons/stats.gif' border=0> Get Stats for {$row->name}</a><br />
                                    <a href='myadopts.php?act=bbcode&id=
{$id}'><img src='templates/icons/bbcodes.gif' border=0> Get BBCodes / HTML Codes for {$row->name}</a><br />
                                    <a href='myadopts.php?act=rename&id=
{$id}'><img src='templates/icons/title.gif' border=0> Rename {$row->name}</a><br />
                                    <a href='myadopts.php?act=trade&id=
{$id}'><img src='templates/icons/trade.gif' border=0> Change Trade Status {$row->name}</a><br />
                                    <a href='myadopts.php?act=freeze&id=
{$id}'><img src='templates/icons/freeze.gif' border=0> Freeze or Unfreeze {$row->name}</a><br />

<a href='myadopts.php?act=group&id=
{$id}'> Group {$row->name}</a><br />  
                                    <a href='myadopts.php?act=pound&id=
{$id}'><img src='templates/icons/delete.gif' border=0> Pound {$row->name}</a></b>";
            }
            else{
                
$article_title $err_idnoexist;
                
$article_content $err_idnoexist_text;
            }
        }
    } 
// End the MANAGE action code
    
elseif($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...

            
$row $adopts->select("owned_adoptables", array(), "owner='{$loggedinname}' and aid='{$id}'")->fetchObject();                
            if(
$row->aid == $id){
                
// The adoptable exists, so we show the stats for it...

                
$image getcurrentimage($id);
                
$nextlevelexists getnextlevelexists($row->type$row->currentlevel);

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

                
if($nextlevelexists == TRUE){
                    
$nextlevel $row->currentlevel 1;

                    
$levels $adopts->select("levels", array(), "adoptiename='{$row->type}' and thisislevel='{$nextlevel}'")->fetchObject();    
                    
$requiredclicks$levels->requiredclicks//The adoptable's ID

                
// 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 $row->totalclicks;
                    
$nloutput "{$nextlevel}<br />Clicks Required for Level Increase: {$ctg}";
                }
                else 
$nloutput "This adoptable is at its maximum level";

                
$article_title "{$row->name}'s Statistics:";
                
$article_content "<img src='{$image}'><br /><br />
                                    <b>Total Clicks: 
{$row->totalclicks}<br />
                                    Gender: <img src='picuploads/
{$row->gender}.png'><br />
                                    Trade Status: 
{$row->tradestatus}<br />
                                    Current Level: 
{$row->currentlevel}<br />
                                    Next Level: 
{$nloutput}<br /></b>";

                
// Voters Information...

                
$article_content .= "<h2>{$row->name}'s Voters:</h2><br />
                                    
{$lang_voters_explain}<br /><br />
                                    <table width='450' border='1'>
                                        <tr>
                                            <td width='129'><strong>Username:</strong></td>
                                            <td width='156'><strong>Date Voted: </strong></td>
                                            <td width='82'><strong>Profile:</strong></td>
                                            <td width='55'><strong>PM:</strong></td>
                                        </tr>"
;

                
// Select the voters from the DB

                
$stmt $adopts->select("vote_voters", array(), "adoptableid='{$id}' ORDER BY date DESC LIMIT 10");
                while(
$row $stmt->fetchObject()) {
                    if(
$row->username == ""$row->username "Guest";
                    if(
$row->username == "Guest"){
                        
$article_content .= "<tr>
                                            <td><div align='left'>Guest</div></td>
                                            <td><div align='left'>
{$row->date}</div></td>
                                            <td><div align='center'></div></td>
                                            <td><div align='center'></div></td>
                                        </tr>"
;
                    }
                    else{
                        
$article_content .= "<tr>
                                            <td><div align='left'>
{$row->username}</div></td>
                                            <td><div align='left'>
{$row->date}</div></td>
                                            <td><div align='center'><a href='profile.php?user=
{$row->username}' target='_blank'><img src='templates/buttons/profile.gif' border=0></a></div></td>
                                            <td><div align='center'><a href='messages.php?act=newpm&user=
{$row->username}' target='_blank'><img src='templates/buttons/pm.gif' border=0></a></div></td>
                                        </tr>"
;
                    }
                }
                
$article_content .= "</table><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
    
elseif($act == "bbcode"){
        if(
is_numeric($id)){
            
// Now we see if the adoptable actually exists...

            
$row $adopts->select("owned_adoptables", array(), "owner='{$loggedinname}' and aid='{$id}'")->fetchObject();                
            if(
$row->aid == $id){
                
$altbb grabanysetting("usealtbbcode");

                
// Adoptable exists, so show the BBCode:
                
$article_title "Codes for {$row->name}";
                
$article_content "{$lang_bbcode_explain}<br />
                                    <p><u>Forum Codes / BBCode: </u></p>
                                    <p>
                                        <textarea name='textarea' cols='50' rows='4'>
                                            
                                        </textarea>
                                    </p>"
;

                if(
$altbb == "yes"){
                
                    
// Use the seo friendly alternate bbcodes...
                    
$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'>
                                            
                                        </textarea>
                                    </p>"
;
                }                
                
$article_content .= "<p><u>HTML Code</u>:</p>
                                    <p>
                                        <textarea name='textarea' cols='50' rows='4'>
                                            <a href=\"http://www."
.constant("DOMAIN").constant("SCRIPTPATH")."/levelup.php?id={$row->aid}\" target=\"_blank\">
                                                <img src=\"http://www."
.constant("DOMAIN").constant("SCRIPTPATH")."/siggy.php?id={$row->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...
    
elseif($act == "rename"){
        
// We are renaming an adoptable

        
if(is_numeric($id)){
        
            
// Now we see if the adoptable actually exists...
            
$row $adopts->select("owned_adoptables", array(), "owner='{$loggedinname}' and aid='{$id}'")->fetchObject();    

            if(
$row->aid == $id){
            
                
$image getcurrentimage($id);
                if(
$row->isfrozen != "yes"){
                    if(
$more == ""){
                        
$article_title "Rename {$row->name}";
                        
$article_content "<img src='{$image}'><br />{$lang_rename}{$row->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, lets first check if the user is its original owner.
                        
$row $adopts->select("pounds", array(), "aid='{$id}'")->fetchObject();
                        if(!empty(
$row->firstowner) and $loggedinname != $row->firstowner){
                            
$article_title "Cannot rename";
                            
$article_content "The site admin has specified that only original owners can rename their adoptables.";                     
                        }
                        else{                        
                               
$adopts->update("owned_adoptables", array("name" => $more), "aid='{$id}' and owner='{$loggedinname}'");
                            
$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;
        }
    }
    elseif(
$act == "trade"){
        
// We are setting the trade status for an adoptable...

        
if(is_numeric($id)){
            
// Now we see if the adoptable actually exists...

            
$row $adopts->select("owned_adoptables", array(), "owner='{$loggedinname}' and aid='{$id}'")->fetchObject();    
            if(
$row->aid == $id){
                
$image getcurrentimage($id); // Get the image for the adopt...

                
if($more == ""){
                    
$article_title "Setting trade status for {$row->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 />"
;
                }
                elseif(
$more == "confirm"){             
                    
$article_title "Change trade status successfully";
                    if(
$row->tradestatus == "fortrade"){
                        
$adopts->update("owned_adoptables", array("tradestatus" => 'notfortrade'), "aid='{$id}' and owner='{$loggedinname}'");
                        
$article_content "The adoptable's trade status is now Not for Trade";
                    }                
                    elseif(
$row->tradestatus == "notfortrade"){
                        
$adopts->update("owned_adoptables", array("tradestatus" => 'fortrade'), "aid='{$id}' and owner='{$loggedinname}'");
                        
$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;
        }
    }
    elseif(
$act == "freeze"){
        
// We are freezing an adoptable here...

        
if(is_numeric($id)){
            
// Now we see if the adoptable actually exists...

            
$row $adopts->select("owned_adoptables", array(), "owner='{$loggedinname}' and aid='{$id}'")->fetchObject();    
            if(
$row->aid == $id){
            
                
$image getcurrentimage($id); // Get the image for the adopt...
                
if($more == ""){
                    if(
$row->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>{$row->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...

                    
if($more == "freeze"){
                        
$frz "yes";
                        
$article_title "{$row->name} Frozen Successfully";
                    }
                    elseif(
$more == "unfreeze"){
                        
$frz "no";
                        
$article_title "{$row->name} Unfrozen Successfully";
                    }

                    
$adopts->update("owned_adoptables", array("isfrozen" => $frz), "aid='{$id}' and owner='{$loggedinname}'");
                    
$article_content "Action Complete. You may now manage {$row->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;
        }
    }
    elseif(
$act == "pound"){
        if(
is_numeric($id)){
        
            
// Now we see if the adoptable actually exists...
            
$row $adopts->select("owned_adoptables", array(), "owner='{$loggedinname}' and aid='{$id}'")->fetchObject();    
            if(
$row->aid == $id){
                
$image getcurrentimage($id); // Get the image for the adopt...
                
if($more == ""){
                    
$article_title "Pound {$row->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 
{$row->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 
{$row->name}! <img src='templates/icons/yes.gif' border=0></a></b></center><br />";
                }
                elseif(
$more == "confirm"){
                    
// Validate the pet can be pounded
                    
$adopt = new Pound($row->aid"pound");
                    if(
$adopt->settings->system->active == "no"){
                          
$article_title "Invalid Action";
                       
$article_content "The admin has turned off pound feature, please contact him/her for further explanation.";                    
                    }
                    elseif(
$adopt->validate() == TRUE){
                       
$adopt->dopound();
                       
$article_title $lang_pound_title_complete;
                       
$article_content $adopt->message;
                    }
                    else{
                       
$article_title "An error has occurred";
                       
$article_content $adopt->message;     
                    }
                }
                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;
        }
        }
    elseif(
$act == "group"){
            if(
is_numeric($id)){
        
            
// Now we see if the adoptable actually exists...
            
$row $adopts->select("owned_adoptables", array(), "owner='{$loggedinname}' and aid='{$id}'")->fetchObject();    
            
$petname $row->name;
            if(
$row->aid == $id){
$row $adopts->select("owned_adoptables", array(), "owner='{$loggedinname}' and aid='{$id}'")->fetchObject();
        
$article_title "Group {$row->name}";
         if(
$row->group == 0){
        
$article_content "{$row->name} is not in a group. ";
         }
         else{
         
$groupname $row->group;
         
$row $adopts->select("pet_groups", array(), "user='{$loggedinname}' and id='{$groupname}'")->fetchObject();
         
$groupname $row->name;
         
$article_content "{$row->name} is in the group '{$groupname}'.";
         }
      
$article_content .= "Select a group to move {$petname} into:<br><br>";
$stmt $adopts->select("pet_groups", array(), "user='{$loggedinname}'");
while(
$row $stmt->fetchObject()) {
  
$groupid=$row->id;
  
$name=$row->name;
  
$code .= "<option value='{$groupid}'>{$name}</option>";
}

$article_content .= "  <form name='form' method='get' action='hatchery.php?'>
<input name='id' type='hidden' id='id' value='
{$id}'>
<input name='act' type='hidden' id='act' value='changegroup'>
    <select name='group' id='group'>
      <option value='none' selected> </option>
    
{$code}
    </select><br>
 <input type='submit' name='submit' value='Move'>
    </form>"
;
           }
     }
}
elseif(
$act == "changegroup"){
// Check if form was submitted
  
if($submit == "Move"){
  
// Check group exists
        
$row $adopts->select("pet_groups", array(), "user='{$loggedinname}' and id='{$group}'")->fetchObject();    
    if(
$row->id == $group and $row->user == $loggedinname){
    
// Check if pet exists
        
$row $adopts->select("owned_adoptables", array(), "owner='{$loggedinname}' and aid='{$id}'")->fetchObject();    
        if(
$row->aid == $id){
        
// Move it
         
$adopts->update("owned_adoptables", array("group" => $group), "aid='{$id}' and owner='{$loggedinname}'");
            
$article_title "Moved {$row->name}";
                        
$article_content "{$row->name} was moved to a new group.<br><br>
                        <a href='groups.php?id=
{$group}'>Check out the new group</a>";
        }
        else{
        
$article_title "Invalid ID";
                
$article_content "This pet doesn't exist.";
        }
    }
    else{
    
$article_title "Invalid Group";
        
$article_content "This group doesn't exist.";
    }
  }
  else{
  
$article_title "";
  
$article_content "";
  }
}
    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);

?>
And can you also re-download groups.php, there's something I put in that made it so that only you can see your own groups and nobody else. Sorry ^^
Reply With Quote