Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Not a member yet? Click here to register.
Forgot Password?
  1. Home
  2. Discussion Forum
  3. PHPFusion 8 Support
  4. Modifications and Requests - 8
  5. Getting votes from forum poll in viewforum.php

Getting votes from forum poll in viewforum.php

Asked Modified Viewed 3,386 times
Back to Forum Index Previous Topic Next Topic
Print
Z
Zidane55
Z
  • Member, joined since
  • Contributed 90 posts on the community forums.
  • Started 26 threads in the forums
  • Started this discussions
asked
Member

Hello, is it possible to get the Poll Option 1 from a forum poll in a thread inside the viewforum.php? So it says how many votes(poll option 1) there has been made in the thread inside the viewforum.php, just like you can see how many views there has been in a thread in the viewforum.php

You can see what I want in the picture( [stemmer] is the poll option 1)

I have tried a bit my self to include the below code:

Code Download source
<td class='tbl1'>[".$pvdata['forum_poll_option_votes']." ".($pvdata['forum_poll_option_votes'] == 1 ? $locale['global_133'] : $locale['global_134'])."]</td>


To the viewforum.php(look at the bold text):

Code Download source
<?php
/*-------------------------------------------------------+
| PHPFusion Content Management System
| Copyright (C) 2002 - 2009 Nick Jones
| http://www.php-fusion.co.uk/
+--------------------------------------------------------+
| Filename: viewforum.php
| Author: Nick Jones (Digitanium)
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at www.gnu.org/licenses/agpl.html. Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
require_once "../maincore.php";
require_once THEMES."templates/header.php";
include LOCALE.LOCALESET."forum/main.php";
include INFUSIONS."forum_threads_list_panel/locale/".$settings['locale'].".php";

if (!isset($lastvisited) || !isnum($lastvisited)) { $lastvisited = time(); }

if (!isset($_GET['forum_id']) || !isnum($_GET['forum_id'])) { redirect("/forum/ekspertforslag.php"); }

if (!isset($_GET['rowstart']) || !isnum($_GET['rowstart'])) { $_GET['rowstart'] = 0; }

$threads_per_page = 20;

add_to_title($locale['global_200'].$locale['400']);

$result = dbquery(
   "SELECT f.*, f2.forum_name AS forum_cat_name FROM ".DB_FORUMS." f
   LEFT JOIN ".DB_FORUMS." f2 ON f.forum_cat=f2.forum_id
   WHERE f.forum_id='".$_GET['forum_id']."'"
);
if (dbrows($result)) {
   $fdata = dbarray($result);
   if (!checkgroup($fdata['forum_access']) || !$fdata['forum_cat']) { redirect("/forum/ekspertforslag.php"); }
} else {
   redirect("/forum/ekspertforslag.php");
}

if ($fdata['forum_post']) {
   $can_post = checkgroup($fdata['forum_post']);
} else {
   $can_post = false;
}

if (iSUPERADMIN) { define("iMOD", true); }

if (!defined("iMOD") && iMEMBER && $fdata['forum_moderators']) {
   $mod_groups = explode(".", $fdata['forum_moderators']);
   foreach ($mod_groups as $mod_group) {
      if (!defined("iMOD") && checkgroup($mod_group)) { define("iMOD", true); }
   }
}

if (!defined("iMOD")) { define("iMOD", false); }

$caption = $fdata['forum_cat_name']." :: ".$fdata['forum_name'];
add_to_title($locale['global_201'].$fdata['forum_name']);

if (isset($_POST['delete_threads']) && iMOD) {
   $thread_ids = "";
   if (isset($_POST['check_mark']) && is_array($_POST['check_mark'])) {
      foreach ($_POST['check_mark'] as $thisnum) {
         if (isnum($thisnum)) { $thread_ids .= ($thread_ids ? "," : "").$thisnum; }
      }
   }
   if ($thread_ids) {
      $result = dbquery("SELECT post_author, COUNT(post_id) as num_posts FROM ".DB_POSTS." WHERE thread_id IN (".$thread_ids.") GROUP BY post_author");
      if (dbrows($result)) {
         while ($pdata = dbarray($result)) {
            $result2 = dbquery("UPDATE ".DB_USERS." SET user_posts=user_posts-".$pdata['num_posts']." WHERE user_id='".$pdata['post_author']."'");
         }
      }
      $result = dbquery("SELECT attach_name FROM ".DB_FORUM_ATTACHMENTS." WHERE thread_id IN (".$thread_ids.")");
      if (dbrows($result)) {
         while ($data = dbarray($result)) {
            unlink(FORUM."attachments/".$data['attach_name']);
         }
      }
      $result = dbquery("DELETE FROM ".DB_POSTS." WHERE thread_id IN (".$thread_ids.")");
      $deleted_posts = mysql_affected_rows();
      $result = dbquery("DELETE FROM ".DB_THREADS." WHERE thread_id IN (".$thread_ids.")");
      $deleted_threads = mysql_affected_rows();
      $result = dbquery("DELETE FROM ".DB_THREAD_NOTIFY." WHERE thread_id IN (".$thread_ids.")");
      $result = dbquery("DELETE FROM ".DB_FORUM_ATTACHMENTS." WHERE thread_id IN (".$thread_ids.")");
      $result = dbquery("DELETE FROM ".DB_FORUM_POLL_OPTIONS." WHERE thread_id IN (".$thread_ids.")");
      $result = dbquery("DELETE FROM ".DB_FORUM_POLL_VOTERS." WHERE thread_id IN (".$thread_ids.")");
      $result = dbquery("DELETE FROM ".DB_FORUM_POLLS." WHERE thread_id IN (".$thread_ids.")");
      $result = dbquery("SELECT post_datestamp, post_author FROM ".DB_POSTS." WHERE forum_id='".$_GET['forum_id']."' ORDER BY post_datestamp DESC LIMIT 1");
      if (dbrows($result)) {
         $ldata = dbarray($result);
         $forum_lastpost = "forum_lastpost='".$ldata['post_datestamp']."', forum_lastuser='".$ldata['post_author']."'";
      } else {
         $forum_lastpost = "forum_lastpost='0', forum_lastuser='0'";
      }
      $result = dbquery("UPDATE ".DB_FORUMS." SET ".$forum_lastpost.", forum_postcount=forum_postcount-".$deleted_posts.", forum_threadcount=forum_threadcount-".$deleted_threads." WHERE forum_id='".$_GET['forum_id']."'");
   }
   $rows_left = dbcount("(thread_id)", "threads", "forum_id='".$_GET['forum_id']."'") - 3;
   if ($rows_left <= $_GET['rowstart'] && $_GET['rowstart'] > 0) {
      $_GET['rowstart'] = ((ceil($rows_left / $threads_per_page)-1) * $threads_per_page);
   }
   redirect(FUSION_SELF."?forum_id=".$_GET['forum_id']."&rowstart=".$_GET['rowstart']);
}
$rows = 
dbcount("(thread_id)", DB_THREADS, "forum_id='".$_GET['forum_id']."' AND thread_sticky='0'");

opentable($locale['450a']);
echo "<!--pre_forum--><div class='tbl2'><a href='/forum/ekspertforslag.php'>".$settings['sitename']."</a> :: ".$caption."</div>\n";

if ($rows > $threads_per_page || (iMEMBER && $can_post)) {
   echo "<table cellspacing='0' cellpadding='0' width='100%'>\n<tr>\n";
   if ($rows > $threads_per_page) { echo "<td style='padding:4px 0px 4px 0px'>".makePageNav($_GET['rowstart'],$threads_per_page,$rows,3,FUSION_SELF."?forum_id=".$_GET['forum_id']."&amp;")."</td>\n"; }
   if (iMEMBER && $can_post) { echo "<td align='right' style='padding:4px 0px 4px 0px'><a href='post.php?action=newthread&amp;forum_id=".$_GET['forum_id']."'><img src='".get_image("newthread")."' alt='".$locale['566']."' style='border:0px;' /></a></td>\n"; }
   echo "</tr>\n</table>\n";
}

if (iMOD) { echo "<form name='mod_form' method='post' action='".FUSION_SELF."?forum_id=".$_GET['forum_id']."&amp;rowstart=".$_GET['rowstart']."'>\n"; }
echo "<table cellpadding='0' cellspacing='1' width='100%' class='tbl-border'>\n<tr>\n";
echo "<td width='1%' class='tbl2' style='white-space:nowrap'>&nbsp;&nbsp;</td>\n";
echo "<td width='1%' class='tbl2' style='white-space:nowrap'>&nbsp;</td>\n";
echo "<td class='tbl2'><b>".$locale['451']."</b></td>\n";
echo "<td class='tbl2'><b>".$locale['412as']."</b></td>\n";
echo "<td align='center' width='1%' class='tbl2' style='white-space:nowrap'><b>".$locale['453']."</b></td>\n";
echo "<td align='center' width='1%' class='tbl2' style='white-space:nowrap'><b>".$locale['A404']."</b></td>\n</tr>\n";

if ($_GET['rowstart'] == 0) {
   $result = dbquery(
      "SELECT t.*, tu1.user_name AS user_author, tu2.user_name AS user_lastuser FROM ".DB_THREADS." t
      LEFT JOIN ".DB_USERS." tu1 ON t.thread_author = tu1.user_id
      LEFT JOIN ".DB_USERS." tu2 ON t.thread_lastuser = tu2.user_id
      WHERE t.forum_id='".$_GET['forum_id']."' AND thread_sticky='1' ORDER BY thread_lastpost DESC"
   );
   if (dbrows($result)) {
      while ($tdata = dbarray($result)) {

      //problem solved
      $result_s = dbquery("SELECT * FROM ".DB_POSTS." WHERE thread_id=".$tdata['thread_id']."");
      $data_s = dbarray($result_s);
       if ($data_s['post_solved'] == 1) {
      $mark = "<img src='".INFUSIONS."forum_threads_list_panel/images/cmark.gif' alt='".$locale['ftl130']."'>";
      } else {
          $mark = "<img src='".INFUSIONS."forum_threads_list_panel/images/blank1.gif' alt='".$locale['ftl131']."'>";
         }
      //problem solved

      echo "<tr>\n";
         if ($tdata['thread_locked']) {

            echo "<td align='center' class='tbl1'>$mark</td><td align='center' width='1%' class='tbl1' style='white-space:nowrap'><img src='".get_image("folderlock")."' alt='".$locale['564']."' /></td>";
         } else  {
            if ($tdata['thread_lastpost'] > $lastvisited) {
               $thread_match = $tdata['thread_id']."\|".$tdata['thread_lastpost']."\|".$fdata['forum_id'];
               if (iMEMBER && preg_match("(^\.{$thread_match}$|\.{$thread_match}\.|\.{$thread_match}$)", $userdata['user_threads'])) {
                  $folder = "<img src='".get_image("folder")."' alt='".$locale['561']."' />";
               } else {
                  $folder = "<img src='".get_image("foldernew")."' alt='".$locale['560']."' />";
               }
            } else {
               $folder = "<img src='".get_image("folder")."' alt='".$locale['561']."' />";
            }
            echo "<td align='center' class='tbl1'>$mark</td><td align='center' width='25' class='tbl1'>$folder</td>";
         }
         $reps = ceil($tdata['thread_postcount'] / $threads_per_page);
         $threadsubject = "<a href='ekspertforslaget.php?thread_id=".$tdata['thread_id']."'>".$tdata['thread_subject']."</a>";
         if ($reps > 1) {
            $ctr = 0; $ctr2 = 1; $pages = "";
            while ($ctr2 <= $reps) {
               $pnum = "<a href='ekspertforslaget.php?thread_id=".$tdata['thread_id']."&amp;rowstart=$ctr'>$ctr2</a> ";
               $pages = $pages.$pnum; $ctr = $ctr + $threads_per_page; $ctr2++;
            }
            $threadsubject .= "<br />(".$locale['455'].trim($pages).")";
}
         echo "<td width='100%' class='tbl1'>";
         if (iMOD) { echo "<input type='checkbox' name='check_mark[]' value='".$tdata['thread_id']."' />\n"; }
         echo "<img src='".get_image("stickythread")."' alt='".$locale['474']."' style='vertical-align:middle;' />\n";
         echo $threadsubject."<!--forum_thread_title_cell--></td>\n";
         echo "<td width='1%' class='tbl2' style='white-space:nowrap'><a href='../profile.php?lookup=".$tdata['thread_author']."'>".$tdata['user_author']."</a></td>\n";
         
         echo "<td align='center' width='1%' class='tbl2' style='white-space:nowrap'>".$pdata['forum_poll_votes']."</td>\n";

         echo "<td align='center' width='1%' class='tbl2' style='white-space:nowrap'>".$tdata['thread_views']."</td>\n";
         echo "<td width='1%' class='tbl2' style='white-space:nowrap'>".showdate("forumdate", $tdata['thread_lastpost'])."<br />\n";
         echo "</tr>\n";
   }
      $threadcount = dbrows($result);
   } else {
      $threadcount = 0;
   }
}

if ($rows) {
   $result = dbquery(
      "SELECT t.*, tu1.user_name AS user_author, tu2.user_name AS user_lastuser FROM ".DB_THREADS." t
      LEFT JOIN ".DB_USERS." tu1 ON t.thread_author = tu1.user_id
      LEFT JOIN ".DB_USERS." tu2 ON t.thread_lastuser = tu2.user_id
      WHERE t.forum_id='".$_GET['forum_id']."' AND thread_sticky='0' ORDER BY thread_lastpost DESC LIMIT ".$_GET['rowstart'].",$threads_per_page"
   );
   $numrows = dbrows($result);
   while ($tdata = dbarray($result)) {

        //problem solved
      $result_s = dbquery("SELECT * FROM ".DB_POSTS." WHERE thread_id=".$tdata['thread_id']."");
      $data_s = dbarray($result_s);
       if ($data_s['post_solved'] == 1) {
      $mark = "<img src='".INFUSIONS."forum_threads_list_panel/images/cmark.gif' alt='".$locale['ftl130']."'>";
      } else {
          $mark = "<img src='".INFUSIONS."forum_threads_list_panel/images/blank1.gif' alt='".$locale['ftl131']."'>";
         }
   //problem solved

      $thread_match = $tdata['thread_id']."\|".$tdata['thread_lastpost']."\|".$fdata['forum_id'];
      echo "<tr>\n";
      if ($tdata['thread_locked']) {
         echo "<td align='center' class='tbl2'>$mark</td><td align='center' width='25' class='tbl2'><img src='".get_image("folderlock")."' alt='".$locale['564']."' /></td>";
      } else  {
         if ($tdata['thread_lastpost'] > $lastvisited) {
            if (iMEMBER && preg_match("(^\.{$thread_match}$|\.{$thread_match}\.|\.{$thread_match}$)", $userdata['user_threads'])) {
               $folder = "<img src='".get_image("folder")."' alt='".$locale['561']."' />";
            } else {
               $folder = "<img src='".get_image("foldernew")."' alt='".$locale['560']."' />";
            }
         } else {
            $folder = "<img src='".get_image("folder")."' alt='".$locale['561']."' />";
         }
         echo "<td align='center' class='tbl1'>$mark</td><td align='center' width='1%' class='tbl1' style='white-space:nowrap'>$folder</td>";
      }
      $reps = ceil($tdata['thread_postcount'] / $threads_per_page);
      $threadsubject = "<a href='ekspertforslaget.php?thread_id=".$tdata['thread_id']."'>".$tdata['thread_subject']."</a>";
      if ($reps > 1) {
         $ctr = 0; $ctr2 = 1; $pages = "";
         while ($ctr2 <= $reps) {
            $pnum = "<a href='ekspertforslaget.php?thread_id=".$tdata['thread_id']."&amp;rowstart=$ctr'>$ctr2</a> ";
            $pages = $pages.$pnum; $ctr = $ctr + $threads_per_page; $ctr2++;
         }
         $threadsubject .= "<br />(".$locale['455'].trim($pages).")";
      }
      echo "<td width='100%' class='tbl1'>";
      if (iMOD) { echo "<input type='checkbox' name='check_mark[]' value='".$tdata['thread_id']."' />\n"; }
      echo $threadsubject."</td>\n";
[big][i]echo "<td align='center' width='1%' class='tbl2' style='white-space:nowrap'>[".$pvdata['forum_poll_option_votes']." ".($pvdata['forum_poll_option_votes'] == 1 ? $locale['global_133'] : $locale['global_134'])."]</td>\n";
[/i][/big]      echo "<td align='center' width='1%' class='tbl1' style='white-space:nowrap'>".$tdata['thread_views']."</td>\n";
      echo "<td width='1%' align='center' class='tbl1' style='white-space:nowrap'>".showdate("forumdate", $tdata['thread_lastpost'])."<br /><a href='../profile.php?lookup=".$tdata['thread_author']."'>".$tdata['user_author']."</a></td>\n";
      echo "</tr>\n";
   }
   echo "</table><!--sub_forum_table-->\n";
} else {
   if (!$threadcount) {
      echo "<tr>\n<td colspan='6' class='tbl1' style='text-align:center'>".$locale['456']."</td>\n</tr>\n</table><!--sub_forum_table-->\n";
   } else {
      echo "</table><!--sub_forum_table-->\n";
   }
}

$threadcount = "";
if (iMOD) {
   if ($threadcount || $rows) {
      echo "<table cellspacing='0' cellpadding='0' width='100%'>\n<tr>\n<td style='padding-top:5px'>";
      echo "<a href='#' onclick=\"javascript:setChecked('mod_form','check_mark[]',1);return false;\">".$locale['460']."</a> ::\n";
      echo "<a href='#' onclick=\"javascript:setChecked('mod_form','check_mark[]',0);return false;\">".$locale['461']."</a></td>\n";
      echo "<td align='right' style='padding-top:5px'><input type='submit' name='delete_threads' value='".$locale['462']."' class='button' onclick=\"return confirm('".$locale['463']."');\" /></td>\n";
      echo "</tr>\n</table>\n";
   }
$threadcount = "";
   echo "</form>\n";
   if ($threadcount || $rows) {
      echo "<script type='text/javascript'>\n"."function setChecked(frmName,chkName,val) {\n";
      echo "dml=document.forms[frmName];\n"."len=dml.elements.length;\n"."for(i=0;i < len;i++) {\n";
      echo "if(dml.elements[i].name == chkName) {\n"."dml.elements[i].checked = val;\n}\n}\n}\n";
      echo "</script>\n";
   }
}

if ($rows > $threads_per_page || (iMEMBER && $can_post)) {
   echo "<table cellspacing='0' cellpadding='0' width='100%'>\n<tr>\n";
   if ($rows > $threads_per_page) { echo "<td style='padding-top:5px'>".makePageNav($_GET['rowstart'],$threads_per_page,$rows,3,FUSION_SELF."?forum_id=".$_GET['forum_id']."&amp;")."</td>\n"; }
   if (iMEMBER && $can_post) { echo "<td align='right' style='padding-top:5px'><a href='post.php?action=newthread&amp;forum_id=".$_GET['forum_id']."'><img src='".get_image("newthread")."' alt='".$locale['566']."' style='border:0px;' /></a></td>\n"; }
   echo "</tr>\n</table>\n";
}

$forum_list = ""; $current_cat = "";
$result = dbquery(
   "SELECT f.forum_id, f.forum_name, f2.forum_name AS forum_cat_name
   FROM ".DB_FORUMS." f
   INNER JOIN ".DB_FORUMS." f2 ON f.forum_cat=f2.forum_id
   WHERE ".groupaccess('f.forum_access')." AND f.forum_cat!='0' AND f.forum_cat IN (79) ORDER BY f2.forum_order ASC, f.forum_order ASC"
);
while ($data2 = dbarray($result)) {
   if ($data2['forum_cat_name'] != $current_cat) {
      if ($current_cat != "") { $forum_list .= "</optgroup>\n"; }
      $current_cat = $data2['forum_cat_name'];
      $forum_list .= "<optgroup label='".$data2['forum_cat_name']."'>\n";
   }
   $sel = ($data2['forum_id'] == $fdata['forum_id'] ? " selected='selected'" : "");
   $forum_list .= "<option value='".$data2['forum_id']."'$sel>".$data2['forum_name']."</option>\n";
}
$forum_list .= "</optgroup>\n";
echo "<div style='padding-top:5px'>\n".$locale['540']."<br />\n";
echo "<select name='jump_id' class='textbox' onchange=\"jumpforum(this.options[this.selectedIndex].value);\">";
echo $forum_list."</select>\n</div>\n";

echo "<div><hr />\n";
echo "<img src='".INFUSIONS."forum_threads_list_panel/images/blank1.gif' alt='".$locale['ftl133']."' style='vertical-align:middle;' />&nbsp;\n";
echo "<img src='".get_image("folder")."' alt='".$locale['561']."' style='vertical-align:middle;' /> - ".$locale['473']."<br /><br />\n";
echo "<img src='".INFUSIONS."forum_threads_list_panel/images/blank1.gif' alt='".$locale['ftl133']."' style='vertical-align:middle;' />&nbsp;\n";
echo "<img src='".get_image("foldernew")."' alt='".$locale['561']."' style='vertical-align:middle;' /> - ".$locale['473aa']."<br /><br />\n";
echo "</div><!--sub_forum-->\n";
closetable();

echo "<script type='text/javascript'>\n"."function jumpforum(forumid) {\n";
echo "document.location.href='".FORUM."viewekspert.php?forum_id='+forumid;\n}\n";
echo "</script>\n";

list($threadcount, $postcount) = dbarraynum(dbquery("SELECT COUNT(thread_id), SUM(thread_postcount) FROM ".DB_THREADS." WHERE forum_id='".$_GET['forum_id']."'"));
if(isnum($threadcount) && isnum($postcount)){
   dbquery("UPDATE ".DB_FORUMS." SET forum_postcount='$postcount', forum_threadcount='$threadcount' WHERE forum_id='".$_GET['forum_id']."'");
}

require_once THEMES."templates/footer.php";
?>
Zidane55 attached the following file:
unavngivet_6.png [No information available / 48 Downloads]
0 replies
There are no post found.

Category Forum

Modifications and Requests - 8

Labels

None yet

Statistics

  • Views 0 views
  • Posts 0 posts
  • Votes 0 votes
  • Topic users 1 member

1 participant

Z
Z
  • Member, joined since
  • Contributed 90 posts on the community forums.
  • Started 26 threads in the forums
  • Started this discussions

Notifications

Track thread

You are not receiving notifications from this thread.

Related Questions

Not yet