Random Survey Block

testy1 · Involved Joined: Apr 06, 2008 Posts: 483

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

draxx · Worker Joined: Nov 19, 2003 Posts: 186

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.

Guardian2003 · 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.