投票结果统计问题

http://www.huzhenbbs.com/thread-774-1-2.html

我有个贴子，地址如上

共13个选项，投票时最多可选5项，投票贴显示共47位会员投票

如何可以一次性查到哪47位会员来参与了投票呢？


另外：
投票结果直观图中看某选项为2人投票，但在查看详细投票人时只能看到一人会员ID 如下图

http://www.huzhenbbs.com/forum.p ... iewvote&tid=774
你输入这个网址即能看投票结果

是否开启了游客允许投票

ARCHY` 发表于 2011-9-2 18:50
是否开启了游客允许投票

您好，没有~

otherbank 发表于 2011-9-2 16:18
http://www.huzhenbbs.com/forum.php?mod=misc&action=viewvote&tid=774
你输入这个网址即能看投票结果

还得一项项看，这样统计投票会员很难统计~

pigcais 发表于 2011-9-4 11:22
还得一项项看，这样统计投票会员很难统计~

有办法了修改代码，刚调试出来

pigcais 发表于 2011-9-4 11:22
还得一项项看，这样统计投票会员很难统计~

修改文件source\module\forum\ forum_misc.php的479-520行代码

1. require_once libfile('function/post');
   
2. $polloptionid = is_numeric($_G['gp_polloptionid']) ? $_G['gp_polloptionid'] : '';
   
3. 
   
4. $page = intval($_GET['page']) ? intval($_GET['page']) : 1;
   
5. $perpage = 100;
   
6. 
   
7. $overt = DB::result_first("SELECT overt FROM ".DB::table('forum_poll')." WHERE tid='$_G[tid]'");
   
8. 
   
9. $polloptions = array();
   
10. $query = DB::query("SELECT polloptionid, polloption FROM ".DB::table('forum_polloption')." WHERE tid='$_G[tid]'");
    
11. while($options = DB::fetch($query)) {
    
12. if(empty($polloptionid)) {
    
13. $polloptionid = $options['polloptionid'];
    
14. }
    
15. $options['polloption'] = preg_replace("/\[url=(https?){1}:\/\/([^\["']+?)\](.+?)\[\/url\]/i",
    
16. "<a href="\\1://\\2" target="_blank">\\3</a>", $options['polloption']);
    
17. $polloptions[] = $options;
    
18. }
    
19. 
    
20. $arrvoterids = array();
    
21. if($overt || $_G['adminid'] == 1 || $thread['authorid'] == $_G['uid']) {
    
22. $voterids = '';
    
23. $voterids = DB::result_first("SELECT voterids FROM ".DB::table('forum_polloption')." WHERE polloptionid='$polloptionid'");
    
24. $arrvoterids = explode("\t", trim($voterids));
    
25. } else {
    
26. showmessage('thread_poll_nopermission');
    
27. }
    
28. 
    
29. if(!empty($arrvoterids)) {
    
30. $count = count($arrvoterids);
    
31. $multi = $perpage * ($page - 1);
    
32. $multipage = multi($count, $perpage, $page, "forum.php?mod=misc&action=viewvote&tid=$_G[tid]&polloptionid=$polloptionid".( $_G[gp_handlekey] ? "&handlekey=".$_G[gp_handlekey] : '' ));
    
33. $arrvoterids = array_slice($arrvoterids, $multi, $perpage);
    
34. }
    
35. $voterlist = $voter = array();
    
36. if($voterids = dimplode($arrvoterids)) {
    
37. $query = DB::query("SELECT uid, username FROM ".DB::table('common_member')." WHERE uid IN ($voterids)");
    
38. while($voter = DB::fetch($query)) {
    
39. $voterlist[] = $voter;
    
40. }
    
41. }
    
42. include template('forum/viewthread_poll_voter');

复制代码

替换为

1. 
   
2.   require_once libfile('function/post');
   
3. $polloptionid = is_numeric($_G['gp_polloptionid']) ? $_G['gp_polloptionid'] : '0';
   
4. $page = intval($_GET['page']) ? intval($_GET['page']) : 1;
   
5. $perpage = 100;
   
6. $overt = DB::result_first("SELECT overt FROM ".DB::table('forum_poll')." WHERE tid='$_G[tid]'");
   
7. $polloptions = array();
   
8.   $options['polloptionid'] = 0;
   
9.   $options['polloption'] = preg_replace("/\[url=(https?){1}:\/\/([^\["']+?)\](.+?)\[\/url\]/i",
   
10.    "<a href="\\1://\\2" target="_blank">\\3</a>", "all user");
    
11.   $polloptions[] = $options;
    
12. $query = DB::query("SELECT polloptionid, polloption FROM ".DB::table('forum_polloption')." WHERE tid='$_G[tid]'");
    
13. while($options = DB::fetch($query)) {
    
14.   $options['polloption'] = preg_replace("/\[url=(https?){1}:\/\/([^\["']+?)\](.+?)\[\/url\]/i",
    
15.    "<a href="\\1://\\2" target="_blank">\\3</a>", $options['polloption']);
    
16.   $polloptions[] = $options;
    
17. }
    
18. $arrvoterids = array();
    
19. if($overt || $_G['adminid'] == 1 || $thread['authorid'] == $_G['uid']) {
    
20.   if($polloptionid == '0'){
    
21.    $voterids = DB::query("SELECT uid FROM ".DB::table('forum_pollvoter')." WHERE tid='$_G[tid]' order by uid");
    
22.    while($voteuid = DB::fetch($voterids)) {
    
23.     $arrvoterids[] = $voteuid['uid'];
    
24.    }
    
25.   }else{
    
26.    $voterids = '';
    
27.    $voterids = DB::result_first("SELECT voterids FROM ".DB::table('forum_polloption')." WHERE polloptionid='$polloptionid'");
    
28.    $arrvoterids = explode("\t", trim($voterids));
    
29.   }
    
30. } else {
    
31.   showmessage('thread_poll_nopermission');
    
32. }
    
33. if(!empty($arrvoterids)) {
    
34.   $count = count($arrvoterids);
    
35.   $multi = $perpage * ($page - 1);
    
36.   $multipage = multi($count, $perpage, $page, "forum.php?mod=misc&action=viewvote&tid=$_G[tid]&polloptionid=$polloptionid".( $_G[gp_handlekey] ? "&handlekey=".$_G[gp_handlekey] : '' ));
    
37.   $arrvoterids = array_slice($arrvoterids, $multi, $perpage);
    
38. }
    
39. $voterlist = $voter = array();
    
40. if($voterids = dimplode($arrvoterids)) {
    
41.   $query = DB::query("SELECT uid, username FROM ".DB::table('common_member')." WHERE uid IN ($voterids)");
    
42.   while($voter = DB::fetch($query)) {
    
43.    $voterlist[] = $voter;
    
44.   }
    
45. }
    
46. include template('forum/viewthread_poll_voter');

复制代码

otherbank 发表于 2011-9-4 12:48

太强了，这样方便多了！

非常感谢！