Having multiple Featured Adoptables?

[rosepose]

Well, here I have my click page:

http://solaeria.net/click.php

But what I need is to have multiple featured adoptables on the same page. How would I go about doing that?

-Rose

[Ashje]

Would repeating the script work?

[BMR777]

I'll look into this when I get back. I don't have the code with me right now. :(

[rosepose]

Repeating the script just posts the same adoptable twice :3

[Rsmiley]

In functions.php in the /inc/ folder find

PHP Code:

$sql_query = "SELECT * FROM owned_adoptables ORDER BY RAND() LIMIT 1";
$result = mysql_query($sql_query); 


and modify the "LIMIT 1" to "LIMIT {NUMBER OF FEATURED ADOPTABLES YOU WANT}" example "LIMIT 50" would show 50 featured adoptables!

Hope i helped :D[hr]
Be advised...

I noticed you had

Member Login:
Below an adoptable will appear for you to click. Clicking would earn you coins, if you were logged in. Refresh to get another adoptable to click.

Featured Adoptable
Clover
Level: 0
Owner: Mystral

If you do the more than 1 featured adoptable. You will break the template!!

Just an FWI

[kisazeky]

Oh my god please don't show 50. :x

That will KILL your server.

Also you stole my idea Rose! How dare you!!

http://digiadopt.l4rge.com/clicks.php

You might want to include an iframe too for the adoptable pages, for the people who click normally.

[Seapyramid]

Originally Posted by kisazeky

Oh my god please don't show 50. :x

That will KILL your server.

ROFL You haven't visited my site have you? 50 - 5000 adoptables available on random at any time in 11 nurserys :)

[rosepose]

Kisa, I stole your idea? The click page has been on SE since it opened :3 Which was at least 2 weeks before yours ><[hr]
And no, I'm not even going to show 1 anymore as it's pretty darn server-killing.