I actually figured this out in like 5 min so
If anyone is interested what I did was make another adopt.php file coping the original and of course giving it a different name. and change this line 32 and 33
Code:
$query = "SELECT * FROM {$prefix}adoptables, {$prefix}adoptables_conditions
WHERE {$prefix}adoptables_conditions.id = {$prefix}adoptables.id";
with this
Code:
$query = "SELECT * FROM {$prefix}adoptables WHERE {$prefix}adoptables.class = 'fire' ";
As you can see I only selected from one database and I wanted it sorted by class. So that Database class is paying off :)
Now I just need to link to the new page on my main site. And this does in fact work.