/**
* @param int The current menu item
* @param string CSS suffix
*/
function show_poll_vote_form($Itemid, &$params)
{
global $database;
$query = "SELECT p.id, p.title" . "\n FROM #__polls AS p" . "\n INNER JOIN #__poll_menu AS pm ON pm.pollid = p.id" . "\n WHERE ( pm.menuid = " . (int) $Itemid . " OR pm.menuid = 0 )" . "\n AND p.published = 1";
$database->setQuery($query);
$polls = $database->loadObjectList();
if ($database->getErrorNum()) {
echo "MB " . $database->stderr(true);
return;
}
// try to find poll component's Itemid
$query = "SELECT id" . "\n FROM #__menu" . "\n WHERE type = 'components'" . "\n AND published = 1" . "\n AND link = 'index.php?option=com_poll'";
$database->setQuery($query);
$_Itemid = $database->loadResult();
if ($_Itemid) {
$_Itemid = '&Itemid=' . $_Itemid;
}
$z = 1;
foreach ($polls as $poll) {
if ($poll->id && $poll->title) {
$query = "SELECT id, text" . "\n FROM #__poll_data" . "\n WHERE pollid = " . (int) $poll->id . "\n AND text != ''" . "\n ORDER BY id";
$database->setQuery($query);
if (!($options = $database->loadObjectList())) {
echo "MD " . $database->stderr(true);
return;
}
poll_vote_form_html($poll, $options, $_Itemid, $params, $z);
$z++;
}
}
}
function show_poll_vote_form($Itemid)
{
global $database;
$Itemid = mosGetParam($_REQUEST, 'Itemid', 0);
$query1 = "SELECT p.id, p.title" . "\nFROM #__polls AS p, #__poll_menu AS pm" . "\nWHERE (pm.menuid='{$Itemid}' OR pm.menuid='0') AND p.id=pm.pollid" . "\nAND p.published=1";
$database->setQuery($query1);
$polls = $database->loadObjectList();
if ($database->getErrorNum()) {
echo "MB " . $database->stderr(true);
return;
}
if ($polls) {
foreach ($polls as $poll) {
if ($poll->id && $poll->title) {
$query = "SELECT id, text FROM #__poll_data" . "\nWHERE pollid='{$poll->id}' AND text <> ''" . "\nORDER BY id";
$database->setQuery($query);
if (!($options = $database->loadObjectList())) {
echo "MD " . $database->stderr(true);
return;
}
poll_vote_form_html($poll, $options, $Itemid);
}
}
}
}
