Featured Story with radom id

[popsantiago]

Hi,

I want to know how can put a random id in the featured story...

	{php}
	
		$link = new Link;
		
		// Edit this line here to change the story
		// to figure out what number a story is, hover your mouse over the votebox for the story
		// you'll see   javascript:vote(A, B, C, 'D', E)
		// the 2nd number (B) will be the number you enter below
		// a better version of this module will come with Pligg V1.0
		
		
		$link->id=Random ID;

		
		
		$link->read();
		$link->print_summary('summary');
	{/php}

What's the query ?

Thx.

[bbrian017]

I would like to know this too, changing it sucks!

[popsantiago]

hi brian,
It's ok for me i did it ^^
I tell you the solution tomorrow
pop

It's late in FRANCE...
See you.

[ashishhbti]

Check this.



{php}

$random_row = mysql_fetch_row(mysql_query("SELECT link_id FROM ".table_links." WHERE link_status='published' ORDER BY rand() LIMIT 1"));
$randomLinkId = $random_row['link_id'];

$link = new Link;

// Edit this line here to change the story
// to figure out what number a story is, hover your mouse over the votebox for the story
// you'll see javascript:vote(A, B, C, 'D', E)
// the 2nd number (B) will be the number you enter below
// a better version of this module will come with Pligg V1.0


$link->id=$randomLinkId ;



$link->read();
$link->print_summary('summary');

{/php}

[popsantiago]

hi,
Like that it's ok :

	{php}
	$link = new Link;
		$randomQ = mysql_query("select * from " . table_links . " where link_status='queued' order by RAND() ASC limit 0,1");
		while($random = mysql_fetch_array($randomQ))
		{
			$link_title = $random[link_title];
			$link_url = $random[link_url];
			$link_id = $random[link_id];
				
		
		$link->id=$link_id;
		
		
		$link->read();
		$link->print_summary('summary');
		}

	
	
	
	{/php}

pop

[bbrian017]

popsantiago do I replace what I have in my featured_story.tpl with this or do I add this before or after something in specific?

thanks

[popsantiago]

Originally Posted by bbrian017

popsantiago do I replace what I have in my featured_story.tpl with this or do I add this before or after something in specific?

thanks

You need to remplace the code between {php} {/php}

	{php}
		require_once(mnminclude.'link.php');
		$link = new Link;
		
		// Edit this line here to change the story
		// to figure out what number a story is, hover your mouse over the votebox for the story
		// you'll see   javascript:vote(A, B, C, 'D', E)
		// the 2nd number (B) will be the number you enter below
		// a better version of this module will come with Pligg V1.0
		
		$link->id=1;
		
		
		$link->read();
		$link->print_summary('summary');
	{/php}

I don't know if you see it but you can put (in the request) published or queued ...

pop

[skins4webs]

Great job.. Wonder if there is an easy way to make it only show random stories after a certain date.. For me I would not want a random story from a year ago.

[ashishhbti]

Originally Posted by popsantiago

hi,
Like that it's ok :

	{php}
	$link = new Link;
		$randomQ = mysql_query("select * from " . table_links . " where link_status='queued' order by RAND() ASC limit 0,1");
		while($random = mysql_fetch_array($randomQ))
		{
			$link_title = $random[link_title];
			$link_url = $random[link_url];
			$link_id = $random[link_id];
				
		
		$link->id=$link_id;
		
		
		$link->read();
		$link->print_summary('summary');
		}

	
	
	
	{/php}

pop

Can you tell me what the use of while loop here ?and whats the use of linktitle and link url ?

[bbrian017]

Originally Posted by skins4webs

Great job.. Wonder if there is an easy way to make it only show random stories after a certain date.. For me I would not want a random story from a year ago.

This is a great idea!

WOOT good thinking! Can this be done?