Mysidia Adoptables Support Forum

Mysidia Adoptables Support Forum (http://www.mysidiaadoptables.com/forum/index.php)
-   Questions and Supports (http://www.mysidiaadoptables.com/forum/forumdisplay.php?f=18)
-   -   organizing adopts (http://www.mysidiaadoptables.com/forum/showthread.php?t=3762)

Nemesis 06-26-2012 03:26 PM

organizing adopts
 
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 06-28-2012 08:32 PM

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

Hall of Famer 06-30-2012 01:23 PM

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 06-30-2012 02:04 PM

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

Hall of Famer 06-30-2012 02:20 PM

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 06-30-2012 03:03 PM

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


All times are GMT -5. The time now is 12:38 PM.

Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.