Mysidia Adoptables Support Forum - Having multiple Featured Adoptables?

Mysidia Adoptables Support Forum (http://www.mysidiaadoptables.com/forum/index.php)

- Questions and Supports (http://www.mysidiaadoptables.com/forum/forumdisplay.php?f=18)

- - Having multiple Featured Adoptables? (http://www.mysidiaadoptables.com/forum/showthread.php?t=579)

rosepose

03-28-2009 02:25 PM

Having multiple Featured Adoptables?

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

03-28-2009 03:51 PM

RE: Having multiple Featured Adoptables?

Would repeating the script work?

BMR777

03-28-2009 06:08 PM

RE: Having multiple Featured Adoptables?

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

rosepose

03-28-2009 08:28 PM

RE: Having multiple Featured Adoptables?

Repeating the script just posts the same adoptable twice :3

Rsmiley

03-28-2009 10:38 PM

RE: Having multiple Featured Adoptables?

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

03-30-2009 03:04 PM

RE: Having multiple Featured Adoptables?

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

03-30-2009 05:28 PM

RE: Having multiple Featured Adoptables?

Quote:

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

03-30-2009 07:48 PM

RE: Having multiple Featured Adoptables?

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.

All times are GMT -5. The time now is 05:55 PM.