| View previous topic :: View next topic |
| Author |
Message |
Colocation
Site Admin
Joined: Jan 07, 2004
Posts: 412
|
 Posted: Mon Jul 26, 2004 1:09 am Post subject: Random Surveys Block |
 |
|
How do we randomise this block to present differing surveys?
| Code: |
if (eregi("block-Survey.php", $_SERVER['PHP_SELF'])) {
Header("Location: index.php");
die();
}
global $prefix, $multilingual, $currentlang, $db, $boxTitle, $content, $pollcomm, $user, $cookie;
if ($multilingual == 1) {
$querylang = "WHERE planguage='$currentlang' AND artid='0'";
} else {
$querylang = "WHERE artid='0'";
}
$sql = "SELECT pollID FROM ".$prefix."_poll_desc $querylang ORDER BY pollID DESC LIMIT 1";
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$pollID = $row[pollID];
if ($pollID == 0 || $pollID == "") {
$content = "";
} else {
if(!isset($url))
$url = sprintf("modules.php?name=Surveys&op=results&pollID=%d", $pollID);
$content .= "<form action=\"modules.php?name=Surveys\" method=\"post\">";
$content .= "<input type=\"hidden\" name=\"pollID\" value=\"".$pollID."\">";
$content .= "<input type=\"hidden\" name=\"forwarder\" value=\"".$url."\">";
$sql2 = "SELECT pollTitle, voters FROM ".$prefix."_poll_desc WHERE pollID=$pollID";
$result2 = $db->sql_query($sql2);
$row2 = $db->sql_fetchrow($result2);
$pollTitle = $row2[pollTitle];
$voters = $row2[voters];
$boxTitle = _SURVEY;
$content .= "<font class=\"content\"><b>$pollTitle</b></font><br><br>\n";
$content .= "<table border=\"0\" width=\"100%\">";
for($i = 1; $i <= 12; $i++) {
$sql3 = "SELECT pollID, optionText, optionCount, voteID FROM ".$prefix."_poll_data WHERE (pollID=$pollID) AND (voteID=$i)";
$result3 = $db->sql_query($sql3);
$row3 = $db->sql_fetchrow($result3);
if(isset($row3)) {
$optionText = $row3[optionText];
if ($optionText != "") {
$content .= "<tr><td valign=\"top\"><input type=\"radio\" name=\"voteID\" value=\"".$i."\"></td><td width=\"100%\"><font class=\"content\">$optionText</font></td></tr>\n";
}
}
}
$content .= "</table><br><center><font class=\"content\"><input type=\"submit\" value=\""._VOTE."\"></font><br>";
if (is_user($user)) {
cookiedecode($user);
}
for($i = 0; $i < 12; $i++) {
$sql4 = "SELECT optionCount FROM ".$prefix."_poll_data WHERE (pollID=$pollID) AND (voteID=$i)";
$result4 = $db->sql_query($sql4);
$row4 = $db->sql_fetchrow($result4);
$optionCount = $row4[optionCount];
$sum = (int)$sum+$optionCount;
}
$content .= "<br><font class=\"content\"><a href=\"modules.php?name=Surveys&op=results&pollID=$pollID&mode=$cookie[4]&order=$cookie[5]&thold=$cookie[6]\"><b>"._RESULTS."</b></a><br><a href=\"modules.php?name=Surveys\"><b>"._POLLS."</b></a><br>";
if ($pollcomm) {
$numcom = $db->sql_numrows($db->sql_query("SELECT * FROM ".$prefix."_pollcomments WHERE pollID='$pollID'"));
$content .= "<br>"._VOTES.": <b>$sum</b> <br> "._PCOMMENTS." <b>$numcom</b>\n\n";
} else {
$content .= "<br>"._VOTES." <b>$sum</b>\n\n";
}
$content .= "</font></center></form>\n\n";
} |
|
|
| Back to top |
|
 |
Humpa
Site Admin
Joined: Feb 05, 2004
Posts: 23
|
| Posted: Tue Jul 27, 2004 12:35 am Post subject: |
|
|
I haven't tested this, but I don't have any Polls in my db and I am in a rush.
Change this one line:
$sql = "SELECT pollID FROM ".$prefix."_poll_desc $querylang ORDER BY pollID DESC LIMIT 1";
To this:
| Code: |
$numrows = mysql_numrows(mysql_query("SELECT * FROM ".$prefix."_poll_desc $querylang"));
if ($numrows > 1) {
mt_srand((double)microtime()*1000000);
$numrows = $numrows-1;
$poll_number = mt_rand(0, $numrows);
$sql = "SELECT pollID FROM ".$prefix."_poll_desc $querylang DESC LIMIT $poll_number,1";
} else {
$sql = "SELECT pollID FROM ".$prefix."_poll_desc $querylang ORDER BY pollID DESC LIMIT 1";
}
//$sql = "SELECT pollID FROM ".$prefix."_poll_desc $querylang ORDER BY pollID DESC LIMIT 1"; |
Let me know how it works ...
Humpa |
|
| Back to top |
|
|
Colocation
Site Admin
Joined: Jan 07, 2004
Posts: 412
|
| Posted: Tue Jul 27, 2004 3:24 am Post subject: Ideas |
|
|
Well it's not major, just comes back with
"There isn't content right now for this block."
Hmmmm, ideas? |
|
| Back to top |
|
|
Humpa
Site Admin
Joined: Feb 05, 2004
Posts: 23
|
| Posted: Tue Jul 27, 2004 4:03 am Post subject: |
|
|
oops .. sorry.
That's why I like to test these things first. :/
Change this one line:
$sql = "SELECT pollID FROM ".$prefix."_poll_desc $querylang ORDER BY pollID DESC LIMIT 1";
To this:
| Code: |
$numrows = mysql_numrows(mysql_query("SELECT * FROM ".$prefix."_poll_desc $querylang"));
if ($numrows > 1) {
mt_srand((double)microtime()*1000000);
$numrows = $numrows-1;
$poll_number = mt_rand(0, $numrows);
$sql = "SELECT pollID FROM ".$prefix."_poll_desc $querylang ORDER BY pollID DESC LIMIT $poll_number,1";
} else {
$sql = "SELECT pollID FROM ".$prefix."_poll_desc $querylang ORDER BY pollID DESC LIMIT 1";
}
//$sql = "SELECT pollID FROM ".$prefix."_poll_desc $querylang ORDER BY pollID DESC LIMIT 1"; |
Let me know how it works now (I forgot the "ORDER BY pollID" in one of the lines ...
Humpa |
|
| Back to top |
|
|
Colocation
Site Admin
Joined: Jan 07, 2004
Posts: 412
|
| Posted: Tue Jul 27, 2004 4:16 am Post subject: Charming |
|
|
Oh that's pretty now...
Works like a charmer. |
|
| Back to top |
|
|
|
Forum FAQ
Search
Usergroups
Profile
Login to check your private messages
Login
