Adding adoptable >.<

[blondbananamix]

<?php

include("inc/functions.php");
$admin = true;

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

if($isloggedin == "yes"){

$group = getgroup();
$cancp = cancp($group);
$canedit = cando($group, "canmanageadopts");

if($cancp == "yes" and $canedit == "yes"){

// We are logged in and can access this page, so let's get the post info...
$name = $_POST["name"];
$description = $_POST["description"];
$cost = $_POST['cost'];
$imageurl = $_POST["imageurl"];
$existingimageurl = $_POST["existingimageurl"];
$cba = $_POST["cba"];
$promocode = $_POST["promocode"];
$freqcond = $_POST["freqcond"];
$number = $_POST["number"];
$datecond = $_POST["datecond"];
$date = $_POST["date"];
$adoptscond = $_POST["adoptscond"];
//////////////////////////////////////////////////////////////////////
$maxnumcond = $_POST["maxnumcond"];
$morethannum = $_POST["morethannum"];
$usergroupcond = $_POST["usergroupcond"];
$usergroups = $_POST["usergroups"];
//////////////////////////////////////////////////////////////////////
$alternates = $_POST["alternates"];
$altoutlevel = $_POST["altoutlevel"];
$altchance = $_POST["altchance"];

// Now we run some checks to make sure that we have a go.

$error = ""; 

if($name == ""){
$error = "You did not enter in a name for the adoptable.  Please go back and try again.";
}

if($name == ""){
$error = "You did not enter in a name for the adoptable.  Please go back and try again.";
}

if($imageurl == "" and $existingimageurl == "none"){
$error = "You did not select an image for this adoptable.  Please go back and make sure an image is selected for this adopt.";
}

if($imageurl != "" and $existingimageurl != "none"){
$error = "You selected two images for the adoptable's egg image.  Please go back and make sure that either the image textbox is blank or the image dropdown box is set to No Exising Image.";
}

if($cba != "always" and $cba != "promo" and $cba != "conditions"){
$error = "You did not choose a valid scenario when this adoptable can be adopted.  Please go back and either select the Always option, the Promo option or the Conditions option.";
}

//If we are using a promo code, we should have a promo code in the box...
if($cba == "promo" and $promocode == ""){
$error = "You selected that this adoptable is available for adoption only with a promo code, but you did not enter in a promo code.  Please go back and either change this setting or type in a valid promo code.";
}

//If we are using conditions...

if($cba == "conditions"){

	if($freqcond == "enabled" and !is_numeric($number)){
	$error = "A condition is enabled but is blank or has an incorrect value.  Please go back and double check your conditions and that they contain valid input.";
	}

	if($datecond == "enabled" and $date == ""){
	$error = "A condition is enabled but is blank or has an incorrect value.  Please go back and double check your conditions and that they contain valid input.";
	}

	if($adoptscond == "enabled"){
	
		if($moreless == "" or !is_numeric($morelessnum) or $levelgrle == "" or !is_numeric($grlelevel)){
		$error = "A condition is enabled but is blank or has an incorrect value.  Please go back and double check your conditions and that they contain valid input.";
		}
	}

	if($maxnumcond == "enabled" and !is_numeric($morethannum)){

	$error = "A condition is enabled but is blank or has an incorrect value.  Please go back and double check your conditions and that they contain valid input.";

	}

	if($usergroupcond == "enabled" and !is_numeric($usergroups)){

	$error = "A condition is enabled but is blank or has an incorrect value.  Please go back and double check your conditions and that they contain valid input.";

	}


}

if($alternates == "enabled"){

		if(!is_numeric($altoutlevel) or !is_numeric($altchance)){
		$error = "There has been an error with the adoptable's alternate settings you selected.  Please go back and make sure the alternate values are filled in correctly.";
		}

}

//Check and see if an adoptable with this name already exists...

$query = "SELECT * FROM ".$prefix."adoptables WHERE type = '$name'";
$result = runquery($query);
$num = mysql_numrows($result);

if($num > 0){
$error = "An adoptable with this name already exists in your database.  Please go back and rename the adoptable to something different.";
}

//If we have an error, show it.  Otherwise continue...

if($error != ""){
$article_title = "An Error Has Occurred!";
$article_content = $error;
}
else{

//There has been no error, continue with the addition of the adoptable to the system...

//First determine which image URL to use...

$eggimage = "";

if($imageurl != "" and $existingimageurl == "none"){
$eggimage = $imageurl;
}
else{
$eggimage = $existingimageurl;
}

runquery("INSERT INTO ".$prefix."adoptables VALUES ('', '$name', '$description','$eggimage','$cba','$promocode', '$freqcond', '$number','$datecond','$date','$adoptscond','$maxnumcond','$morethannum','$usergroupcond','$usergroups','$alternates','$altoutlevel','$altchance', '$cost')");
// insert our level thing
runquery("INSERT INTO ".$prefix."levels VALUES ('$name', '0', '0', '$eggimage','','','')");

$article_title = "Adoptable Added Successfully";
$article_content = "Your adoptable, ".$name.", has been added to the database successfully.  You can now <a href='admin.php?set=adopts&do=addlevel'>Add a Level</a> to this adoptable.  You can also <a href='admin.php'>go back to the Admin CP index page</a>.";

}


} //This bracket ends the check of whether or not this user can access the adopts portion of the ACP


}



else{

$article_title = "Access Denied";
$article_content = "Access Denied";

}

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

echo showpage($article_title, $article_content, $date);

?>

What is the adopts_adoptables structure?