Random Survey Block

Involved Joined: Apr 06, 2008 Posts: 484

looks like you have only made slight modifications?

Code:




/** added for random - Random stuff from chatserv **/





mt_srand((double)microtime()*1000000);


$total = $db->sql_numrows($db->sql_query("select * from ".$prefix."_poll_desc"));


if ($total==0) $artrand=0;


else


$artrand = mt_rand(0,($total-1));


$pollID = $artrand;





// OLD list($pollID) = $db->sql_fetchrow($db->sql_query('SELECT pollID FROM '.$prefix.'_poll_desc '.$querylang.' ORDER BY pollID DESC LIMIT 1'));


list($pollID) = $db->sql_fetchrow($db->sql_query('SELECT pollID FROM '.$prefix.'_poll_desc '.$querylang.' ORDER BY pollID DESC LIMIT '.$artrand.', 1'));





/** end add -- translated by draxx **/

Seems to work nice m8

Involved Joined: Nov 19, 2003 Posts: 282

I actually had chatserv make me a random survey block a long time ago - all I did was take his code snippit out of that block from then and modify it to fit the new format.

I really did nothing but translate a line of code.

Posted: Tue Apr 28, 2009 8:00 am

My own tests;
Odd and Even numbers of polls (not that it matters) - OK
PollID sanitized using intval() to limit chance of injection in the sql query - OK
Rendered Output - Compliance to XHTML 1.0 Transitional and CSS 3 - Passed
Notice and other PHP errors - None

Comments
To avoid possible clashes with the standard block, I would recommend you change the variable $pollID to something unique.