-- First
<?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 = "<table>
<tr><th></th><th>Name and Type</th><th>Image</th><th>Level</th><th>Clicks</th><th>Next Level</th><th>Frozen/Trade</th><th>Feed</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.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");
$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");
$currentlevel=@mysql_result($result, $i, $prefix."owned_adoptables.currentlevel");
$isfrozen=@mysql_result($result, $i, $prefix."owned_adoptables.isfrozen");
$tradestatus=@mysql_result($result, $i, $prefix."owned_adoptables.tradestatus");
if(getnextlevelexists($type, $currentlevel) == "true")
{
$res = mysql_query("SELECT * FROM ".$prefix."levels WHERE thisislevel = {$currentlevel} +1");
$reqClicks = @mysql_result($res, 0, "requiredclicks");
$reqClicks = $currentlevel +1 . " / " . $reqClicks . " Clicks";
}
else
{
$reqClicks = "Max level reached";
}
if ($usealternates=='yes') { $image = $alternateimage; }
else { $image = $primaryimage; }
if ($currentlevel==0) { $image = $eggimage; }
if ($image=='') { $image = $primaryimage; }
$article_content .= "<tr><td><img src='picuploads/{$gender}.png'></td><td><em>{$name}</em> the {$type}</td><td><a href='myadopts.php?act=manage&id={$aid}'><img src='{$image}'></a></td><td>{$currentlevel}</td><td>{$totalclicks}</td><td>{$reqClicks}</td><td>{$isfrozen} / {$tradestatus}</td><td><a href='levelup.php?id={$aid}'>Feed {$name}</a></tr>";
$i++;
}
$article_content .= "</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 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");
$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=trade&id=".$id."'><img src='templates/icons/trade.gif' border=0> Change Trade Status ".$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=pound&id=".$id."'><img src='templates/icons/delete.gif' border=0> Pound ".$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 = 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");
$tradestatus=@mysql_result($result,$i,"tradestatus");
$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 = $name."'s Statistics:";
$article_content = "<img src='".$image."'><br><br>
<b>Total Clicks: ".$totalclicks."<br>
Gender: <img src='picuploads/{$gender}.png'><br>
Trade Status: ".$tradestatus."<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 = runquery($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 = 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 ".$name;
$article_content = $lang_bbcode_explain."<br>
<p><u>Forum Codes / BBCode: </u></p>
<p>
<textarea name='textarea' cols='50' rows='4'>http://www.".$domain."".$scriptpath."/siggy.php?id=".$aid." (http://www.".$domain."".$scriptpath."/levelup.php?id=".$aid.")
</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'>http://www.".$domain."".$scriptpath."/get/".$aid.".gif\" (http://www.".$domain."".$scriptpath."/levelup.php?id=".$aid.")
</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 ".$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."'";
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 ".$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>".$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 = $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 == "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 ".$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 ".$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 ".$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);
?>
Make sure your layout is wide enough to display all the data and backup your file before using the code above.
-- Second
It shouldn't do that. Maybe you've edited the code before. Post it here, I'll take a look and see what's wrong.
-- Third
I'm not sure about this one, but please do try it.
Put it inside the inc/bbcode.php
$text = preg_replace('|\[table\](.+?)\[\/table\]|i', '<table>$1</table>', $text);
$text = preg_replace('|\[th\](.+?)\[\/th\]|i', '<th>$1</th>', $text);
$text = preg_replace('|\[tr\](.+?)\[\/tr\]|i', '<tr>$1</tr>', $text);
$text = preg_replace('|\[td\](.+?)\[\/td\]|i', '<td>$1</td>', $text);
-- Fourth
The backslash is to escape the character to prevent SQL injection
-- Last?
You have to edit the database manually and then remove the theme folder from the templates folder.
For the database, you'll have to delete the corresponding row to the theme in adopts_themes table.