Giving pets a Gender

[Arianna]

This is my first 'mod', and a small one at it. I hope you like it.
This mod is so your pets can have gender. I'd love to have a breeding system, but there's no way I'm going to be able to make that.

First what we're going to do is we're going to open 'myadopts.php'.
Find this part:

$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");

And change it to this:

$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");
$gender=@mysql_result($result,$i,"gender");
$totalclicks=@mysql_result($result,$i,"totalclicks");

Then, later down, you'll see something like this:

$article_title = $name."'s Statistics:";
$article_content = "<img src='".$image."'><br><br>
<b>Total Clicks: ".$totalclicks."<br>
Current Level: ".$currentlevel."<br>
Next Level: ".$nloutput."<br></b>";

Change it to this:

$article_title = $name."'s Statistics:";
$article_content = "<img src='".$image."'><br><br>
<b>Total Clicks: ".$totalclicks."<br>
Gender: ".$gender."<br>
Current Level: ".$currentlevel."<br>
Next Level: ".$nloutput."<br></b>";

Great, so now we can show the gender. We're not done, though. Save this and open 'doadopt.php'.
Under this:

if($name == ""){
$name = $type;
}

Add this code:

//The gender mod
$tempgender = rand(0, 1);
if($tempgender == "0") {
$gender = "Female";
unset($tempgender);
}
else {
$gender = "Male";
unset($tempgender);
}

Now we're going to change this:

mysql_query("INSERT INTO ".$prefix."owned_adoptables VALUES ('', '$type', '$name','$loggedinname','0','0', '$code', '','$alts','notfortrade','no')");

To this:

mysql_query("INSERT INTO ".$prefix."owned_adoptables VALUES ('', '$type', '$name','$loggedinname','0','0', '$code', '','$alts','notfortrade','no','$gender')");

Last but not least, we need another column in our owned_adoptables table. Go in to it, and insert a column called 'gender'. Use the same kind of settings you'd use for a name, and insert the column.

You should be done. Try adopting a creature, and then viewing it's stats. You'll see which gender it is!


Please tell me what I messed up here. I know this has been done before, I just wanted to try it myself.

~Arianna

---

Also, I don't know how to put it in for already existing pets. Any help there?

 

[exdiogene]

You could add a form to doadopt.php to let people select the gender too

 

[Arianna]

That's cool. Is there any way that I could do that?
I liked having 'random' genders, but I'm sure the users of the site would like that more. xD

 

[exdiogene]

instead of your random number to select gender code, try this:

<form id="form1" name="form1" method="post" action="">
  <p>
    <label>
    Male:</label>
    <label>
      <input type="radio" name="Genderselect" value="male" id="Genderselect_0" />
    </label>
    <br />
    <label>
    Female:</label>
    <label>
      <input type="radio" name="Genderselect" value="female" id="Genderselect_1" />
    </label>
    <br />
  </p>
</form>

$gender = $_GET[genderselect];

 

[gabeki]

you can also display the gender in the user profile, like this
http://www.maplepet.co.cc/perfil.php?user=admin

just an idea

 

[Arianna]

Yes, I have them displaying on the myadopts.php page.

 

[Arianna]

I think I found a problem, I'm going to go back in and edit it. Wish me luck!

 

[rosepose]

I just tried to install this, managed to adopt the pet, and then was told it didn't exist O___O

So, I guess the script didn't go through to the database?

 

[Seapyramid]

Sorry but I can't trouble shoot. Not using this one. Mystic Grove has a totally different system using majick to reproduce.

Sea

 

[Arianna]

How weird - it works for me. Are you sure that you've created the 'gender' column correctly? May I see your code so I can compare it with mine?

 

[rosepose]

Ok, here I have:

<?php

// **********************************************************************
// Rusnak PHP Adoptables Script
// Copyright 2009 Brandon Rusnak
// For help and support: http://www.rusnakweb.com/forum/
//
// Redistribution prohibited without written permission
// **********************************************************************

// Wake the sleeping giant

// **********************************************************************
// Basic Configuration Info
// **********************************************************************

include("inc/functions.php");
include("inc/config.php");
include("lang/lang.php");

$themeurl = grabanysetting("themeurl");

// **********************************************************************
// Define our top links by calling getlinks()
// **********************************************************************

$links = getlinks();

// **********************************************************************
// Define our ads by calling getads()
// **********************************************************************

$ads = getads("any");

// **********************************************************************
// Grab any dynamic article content from the content table
// **********************************************************************

$pagecontent = getsitecontent("index");
$article_title = $pagecontent[title];
$article_content = $pagecontent[content];
$article_content = nl2br($article_content);

// **********************************************************************
// Grab any settings that we will need for the current page from the DB
// **********************************************************************

$browsertitle = grabanysetting("browsertitle");
$sitename = grabanysetting("sitename");
$slogan = grabanysetting("slogan");

// **********************************************************************
// Check and see if the user is logged in to the site
// **********************************************************************

$loginstatus = logincheck();
$isloggedin = $loginstatus[loginstatus];
$loggedinname = $loginstatus[username];

// **********************************************************************
// End Prepwork - Output the page to the user
// This file actually processes the adoption of a pet...
// **********************************************************************

$id = $_GET["id"];
$id = preg_replace("/[^a-zA-Z0-9s]/", "", $id);
$id = secure($id);

$promocode = $_GET["promocode"];
$promocode = preg_replace("/[^a-zA-Z0-9\\040.]/", "", $promocode);
$promocode = secure($promocode);

$name = $_GET["name"];
$name = preg_replace("/[^a-zA-Z0-9\\040.]/", "", $name);
$name = secure($name);

if($isloggedin == "yes"){

// I guess the first thing to do is see if we have a valid adoptable ID submitted...

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

$article_title = $err_idnoexist;
$article_content = $err_idnoexist_text;

}
else{

// The adoptable ID appears to be valid, so we need to double check that it is valid by pulling up the adoptable in the DB

$query = "SELECT * FROM ".$prefix."adoptables WHERE id='$id'";
$result = mysql_query($query);
$num = mysql_numrows($result);

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

$aid=@mysql_result($result,$i,"id"); //The adoptable's ID
$type=@mysql_result($result,$i,"type");
$description=@mysql_result($result,$i,"description");
$eggimage=@mysql_result($result,$i,"eggimage");

$i++;
}

if($id == $aid){

// The ID submitted matches an existing adoptable type

$canadopt = canadopt($aid, "adopting", $promocode);

// If we can adopt this creature, do the adoption
// Otherwise we show an error...

if($canadopt == "yes"){

// **********************************************************************
// BEGIN the actual adoption process
// **********************************************************************

// First we see if we have a custom name.
// If not, we use the default name

if($name == ""){
$name = $type;
}
//The gender mod
$tempgender = rand(0, 1);
if($tempgender == "0") {
$gender = "Female";
unset($tempgender);
}
else {
$gender = "Male";
unset($tempgender);
}

// Now we determine if we are using alternate images or not

$alts = getaltstatus($id, 0, 0);

// Now we actually process the adoption and add it to the database...
// We need a unique code for the adoptable so we can show it to the user when we're done here...

$code = rand(1, 20000);


mysql_query("INSERT INTO ".$prefix."owned_adoptables VALUES ('', '$type', '$name','$loggedinname','0','0', '$code', '','$alts','notfortrade','no','$gender')");

// Adoption complete, show the user a confirmation screen...
// We need to show the adoptable info from the database...

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

//Loop out code
$i=0;
while ($i < 1) {
 
$id=@mysql_result($result,$i,"aid"); 


$i++;
}


$article_title = $name." adopted successfully";
$article_content = "<img src='".$eggimage."'><br>".$congrats1." ".$name.".  You can now manage ".$name." on the 
<a href='myadopts.php'>My Adopts</a> page.<br><br><b><a href='myadopts.php?act=manage&id=".$id."'>Click Here to Manage ".$name."</a><br>
<a href='myadopts.php?act=bbcode&id=".$id."'>Click Here to get BBCodes / HTML Codes for ".$name."</a></b><br><br>
Be sure and <a href='levelup.php?id=".$id.">feed</a> ".$name." with clicks so that they grow!";



// **********************************************************************
// END the actual adoption process
// **********************************************************************


}
else{

$article_title = $accden;
$article_content = $adoptnoper;

}


} // End the if for if $id == $aid
else{

// Adoptable does not exist, show an error.

$article_title = $err_idnoexist;
$article_content = $err_idnoexist_text;

} // End the else for if $id == $aid


} // End the valid ID input else test statement (bulk of code goes above here)


} // End the log in check IF
else{

// Guests cannot adopt pets, so why bother...
$article_title = $guesttitleerror;
$article_content = $guesterror;

} // End the log in check ELSE 

// **********************************************************************
// Begin Template Definition
// **********************************************************************

//Define our current theme
$file = $themeurl;

// Do the template changes and echo the ready template
$template = file_get_contents($file);

$template = replace(':ARTICLETITLE:',$article_title,$template);
$template = replace(':ARTICLECONTENT:',$article_content,$template);
$template = replace(':ARTICLEDATE:',$article_date,$template);

$template = replace(':BROWSERTITLE:',$browsertitle,$template);
$template = replace(':SITENAME:',$sitename,$template);

//Define our links
$template = replace(':LINKSBAR:',$links,$template);

//Get the content for the side bar...

$sidebar = getsidebar();
$template = replace(':SIDEFEED:',$sidebar,$template);

//Get the ad content...
$template = replace(':ADS:',$ads,$template);

//Get the slogan info
$template = replace(':SLOGAN:',$slogan,$template);


echo $template;

// **********************************************************************
// End Template Definition
// **********************************************************************



?>

that's doadopt.php.

And:

<?php

// **********************************************************************
// Rusnak PHP Adoptables Script
// Copyright 2009 Brandon Rusnak
// For help and support: http://www.rusnakweb.com/forum/
//
// Redistribution prohibited without written permission
// **********************************************************************

// Wake the sleeping giant

// **********************************************************************
// Basic Configuration Info
// **********************************************************************

include("inc/functions.php");
include("inc/config.php");
include("lang/lang.php");

$themeurl = grabanysetting("themeurl");

// **********************************************************************
// Define our top links by calling getlinks()
// **********************************************************************

$links = getlinks();

// **********************************************************************
// Define our ads by calling getads()
// **********************************************************************

$ads = getads("any");

// **********************************************************************
// Grab any dynamic article content from the content table
// **********************************************************************

$pagecontent = getsitecontent("index");
$article_title = $pagecontent[title];
$article_content = $pagecontent[content];
$article_content = nl2br($article_content);

// **********************************************************************
// Grab any settings that we will need for the current page from the DB
// **********************************************************************

$browsertitle = grabanysetting("browsertitle");
$sitename = grabanysetting("sitename");
$slogan = grabanysetting("slogan");

// **********************************************************************
// Check and see if the user is logged in to the site
// **********************************************************************

$loginstatus = logincheck();
$isloggedin = $loginstatus[loginstatus];
$loggedinname = $loginstatus[username];

// **********************************************************************
// End Prepwork - Output the page to the user
// This file lets a user manage their adoptables...
// **********************************************************************

$id = $_GET["id"];
$id = preg_replace("/[^a-zA-Z0-9s]/", "", $id);
$id = secure($id);

$act = $_GET["act"];
$act = preg_replace("/[^a-zA-Z0-9\\040.]/", "", $act);
$act = secure($act);

$more = $_GET["more"];
$more = preg_replace("/[^a-zA-Z0-9\\040.]/", "", $more);
$more = secure($more);

if($isloggedin == "yes"){

if($act == ""){

// No action specified, we just show all the adoptables with a manage link

$article_title = $loggedinname."'s Adoptables";
$article_content = $lang_adoptmanagement."<br>";

// We need to get all of the user's adoptables from the database and display them...

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

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

$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");

// Our code to determine if we show the table or not...


$article_content = $article_content."<table width='440' border='1'><tr>";



// Output the table information...
// Get the current adoptable's image

$image = getcurrentimage($aid);

$article_content = $article_content."<td><div align='center'><p>".$name."</p><p><a href='myadopts.php?act=manage&id=".$aid."'><img src='".$image."' border=0></a></p><p>
<b><a href='myadopts.php?act=manage&id=".$aid."'>Manage</a></b></p></div></td>";


$article_content = $article_content."</tr></table><br>";


$i++;

}

}
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 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
$currentlevel=@mysql_result($result,$i,"currentlevel");
$type=@mysql_result($result,$i,"type");
$name=@mysql_result($result,$i,"name");

$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 ".$name;
$article_content = "<img src='".$image."'><br><br>This page allows you to manage ".$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 ".$name."</a><br>
<a href='myadopts.php?act=stats&id=".$id."'><img src='templates/icons/stats.gif' border=0> Get Stats for ".$name."</a><br>
<a href='myadopts.php?act=bbcode&id=".$id."'><img src='templates/icons/bbcodes.gif' border=0> Get BBCodes / HTML Codes for ".$name."</a><br>
<a href='myadopts.php?act=rename&id=".$id."'><img src='templates/icons/title.gif' border=0> Rename ".$name."</a><br>
<a href='myadopts.php?act=freeze&id=".$id."'><img src='templates/icons/freeze.gif' border=0> Freeze or Unfreeze ".$name."</a><br>
<a href='myadopts.php?act=kill&id=".$id."'><img src='templates/icons/delete.gif' border=0> Kill ".$name."</a></b>";

}
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 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
$currentlevel=@mysql_result($result,$i,"currentlevel");
$type=@mysql_result($result,$i,"type");
$name=@mysql_result($result,$i,"name");
$gender=@mysql_result($result,$i,"gender");
$totalclicks=@mysql_result($result,$i,"totalclicks");


$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 = mysql_query($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 = $name."'s Statistics:";
$article_content = "<img src='".$image."'><br><br>
<b>Total Clicks: ".$totalclicks."<br>
Gender: ".$gender."<br>
Current Level: ".$currentlevel."<br>
Next Level: ".$nloutput."<br></b>";

// Voters Information...

$article_content = $article_content."<h2>".$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

$query = "SELECT * FROM ".$prefix."vote_voters WHERE adoptableid='$id' ORDER BY date DESC LIMIT 10";
$result = mysql_query($query);
$num = mysql_numrows($result);

$i=0;
while ($i < $num) {

$date=@mysql_result($result,$i,"date"); 
$username=@mysql_result($result,$i,"username"); 

if($username == ""){

$username = "Guest";

}

if($username == "Guest"){

$article_content = $article_content."<tr>
    <td><div align='left'>Guest</div></td>
    <td><div align='left'>".$date."</div></td>
    <td><div align='center'></div></td>
    <td><div align='center'></div></td>
  </tr>";

}
else{

$article_content = $article_content."<tr>
    <td><div align='left'>".$username."</div></td>
    <td><div align='left'>".$date."</div></td>
    <td><div align='center'><a href='profile.php?user=".$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=".$username."' target='_blank'><img src='templates/buttons/pm.gif' border=0></a></div></td>
  </tr>";


}



$i++;
}

$article_content = $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
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 = 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
$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 ".$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 = 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
$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 ".$name;
$article_content = "<img src='".$image."'><br>".$lang_rename."".$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."'";
mysql_query($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 == "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 = 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
$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>".$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."'";
mysql_query($query);

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

$article_content = "Action Complete.  You may now manage ".$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 == "trade"){

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

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

///////////////////////////////////////////////////////////////
// X - X - X - X - X - X - X - X - X - X - X - X - X - X - X //
// We are killing an adoptable here...                       //
// X - X - X - X - X - X - X - X - X - X - X - X - X - X - X //
///////////////////////////////////////////////////////////////

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
$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 = "Killing ".$name;
$article_content = "<img src='".$image."'><br>".$lang_kill."<br><br>".$lang_kill_warning."<br><br>
<center><b><a href='myadopts.php?act=kill&id=".$id."&more=confirm'><img src='templates/icons/delete.gif' border=0> Kill ".$name." - THIS CANNOT BE UNDONE! <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 KILL ".$name."!  Go Somewhere Safe. <img src='templates/icons/yes.gif' border=0></a></b></center><br>";

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

// Actually run the execution

$query = "DELETE FROM ".$prefix."owned_adoptables WHERE aid='$id' and owner='$loggedinname'";
mysql_query($query);

$article_title = $lang_kill_title_complete;
$article_content = $lang_kill_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


// **********************************************************************
// Begin Template Definition
// **********************************************************************

//Define our current theme
$file = $themeurl;

// Do the template changes and echo the ready template
$template = file_get_contents($file);

$template = replace(':ARTICLETITLE:',$article_title,$template);
$template = replace(':ARTICLECONTENT:',$article_content,$template);
$template = replace(':ARTICLEDATE:',$article_date,$template);

$template = replace(':BROWSERTITLE:',$browsertitle,$template);
$template = replace(':SITENAME:',$sitename,$template);

//Define our links
$template = replace(':LINKSBAR:',$links,$template);

//Get the content for the side bar...

$sidebar = getsidebar();
$template = replace(':SIDEFEED:',$sidebar,$template);

//Get the ad content...
$template = replace(':ADS:',$ads,$template);

//Get the slogan info
$template = replace(':SLOGAN:',$slogan,$template);


echo $template;

// **********************************************************************
// End Template Definition
// **********************************************************************



?>

That's myadopts.php.

This is what my gender table looks like:
gender varchar(40) latin1_swedish_ci Yes NULL

I think it looks as it should... I'm probably wrong though XD

Thanks :3

 

[bondsam123]

Hi
Well,Thanks for posting your experience here in this forum.I am happy to see the good awareness created due to this topic.I like this article very much and its way of representation.I want to more about these topic.I am waiting for your positive reply.
Thanks

 

[SieghartZeke]

Err..i dont know what i need to put to create a new table in my owned_adoptable database....

 

[SieghartZeke]

Ehy....I need a ansewer 4 my problem!!
How to make a new table in owned_adoptable?

 

[Arianna]

I'm afraid you can't make a table inside of a table. What do you mean?

Rosepose, has your problem been solved?

 

[Seapyramid]

Ehy....I need a ansewer 4 my problem!!
How to make a new table in owned_adoptable?

Last time I will offer the suggestion!! Try to learn something first & maybe people can help you. Yes, you are a minor, that does not mean all are here to serve you! I have given you the links to help you. Help yourself so we can better help you!

 

[SieghartZeke]

But where is this link???

 

[Seapyramid]

But where is this link???

http://www.w3schools.com/PHP/DEfaULT.asP again

Sea

 

[Arianna]

I'm 13, too, and I don't think that it's that hard to google something. The link that Sea has given you will help you.

 

[exdiogene]

I learned the basics of PHP from there Now im studying A-level PHP work 2 years early