Random Adoption

[nitrogen]

I'm trying to build a "Pokemon" adoptables site.
Here's what I'm trying to do:
1) Quickly make all adoptables/Pokemon have the same egg image (SQL query/script modification?)
2) Edit the adopt.php page so that it serves a random adoptable (only one) (the user won't be able to tell which adoptable it is as they all have the same image)
This way the user won't know what they're adopting (no name, aids don't help, etc.) until they get past the egg phase.
Here's an example of what I'm trying to do:
http://www.virtuadopt.com/adopt.php

This is a Pokémon egg. I am not sure what it will hatch into. Just name it, and treat it well, someday, it may hatch into marvelous Pokémon species!

Is there a way to set the "level up" click amount to a span of numbers? Example: egg 1 will hatch after 5-10 clicks.

Is there also a quick way to add images? I have 500+ jpg images that I need to convert to gifs and upload. The Admin CP is way to slow at adding images (one at a time).[hr]
I figured out how to get number 2 to work. I searched the forum and found this:
http://www.rusnakweb.com/forum/showthread.php?tid=365
which helped a lot. I'm still trying to figure out how to get all the adoptables to share the same egg image without manually editing every single one and how to upload 500+ adoptables at once.
New "todo":
Get adopt.php to display eggs horizontally.

[Seapyramid]

Eggs are easy.. when making the "new adoptable" give them all the same egg image.

For horizontal change article content of your adopt.php page at line 127 to

$article_content = $article_content."
<a href='adopt.php?id=".$aid."'><img src='".$eggimage."' border='0'></a>&nbsp;&nbsp;";

Horizontal and no name or description like at http://mysticgrove.net/grove/adopt.php

Uploading I can't help you. :(

[nitrogen]

I tried uploading all the pictures to the picuploads directory but they don't show up. I think database editing is needed (?).[hr]
I just tried. The adopt.php file at the forum thread:
http://www.rusnakweb.com/forum/showthread.php?tid=365
doesn't work with the latest release. A few includes and functions are missing.

[Xius]

Delete the .htaccess file in picuploads, the same thing happened to me.

And, to show only 1 random adoptable...

Find:

PHP Code:

// Begin the output of all the adoptables to the user...

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


Replace:

PHP Code:

$query = "SELECT * FROM ".$prefix."adoptables"; 


With:

PHP Code:

$query = "SELECT * FROM ".$prefix."adoptables ORDER BY RAND() LIMIT 1"; 


And you will now have a random adoptable each time.
If you want an example of what it looks like: Http://PokemonEpiphany.com/adopt.php

[trollis76]

For me that code didn't work.
This was working for me:

$query = "SELECT * FROM ".$prefix."adopts_adoptables ORDER BY RAND() LIMIT 1";