organizing adopts

[Nemesis]

How could I go about organizing adoptables on my site. Since I am doing pokemon I plan on adding all 650 of them. I do not want all 650 listed on one page but rather organize them by generation and Type.

So any suggestions on how to go about doing this? thanks.

Also I tried using promo codes but that just adds the Pokemon to the available adopts page and will get messy.

I think I saw someone had adopts listed like in item shops so how could I do that too?

[Nemesis]

I actually figured this out in like 5 min so :Q:

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
$query = "SELECT * FROM {$prefix}adoptables, {$prefix}adoptables_conditions
WHERE {$prefix}adoptables_conditions.id = {$prefix}adoptables.id";

with this

$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.

[Hall of Famer]

umm are you using Mys v1.3.0 now? Just curious since you were apparently not using the new database class and methods in the sample code you provided.

[Nemesis]

oh poo i am :( so if i update im going to lose all of my improvements :(

[Hall of Famer]

I see, this is kinda unfortunate. If so you may as well use Mys v1.3.0 till the next major release is available, I mean Mys v1.4.0, not the upcoming v1.3.2.

[Nemesis]

ya im not sure how i missed that last update. but so far i havent encountered any errors and i'll just run the site in beta till then