pun_poll (Page 4 of 5)

function show_voted($topic_id) {
    global $forum_user,$forum_db,$lang_pun_poll,$lang_topic,$forum_url;
    
    /* select votes */
    $query = array(
        'SELECT'    => 'user_id, answer_id',
        'FROM'        => 'voting',
        'WHERE'        => 'topic_id='.$topic_id
    );
    $result = $forum_db->query_build($query) or error(__FILE__, __LINE__);
    while($row = $forum_db->fetch_assoc($result))
        $votes[$row['user_id']] = $row['answer_id'];
    
    /* select answer string of votes */
    $answers_str = implode(',',$votes);

    if(!empty($answers_str)) {
        $query = array(
            'SELECT'    => 'id,answer',
            'FROM'        => 'answers',
            'WHERE'        => 'id in('.$answers_str.')'
        );

        $result = $forum_db->query_build($query) or error(__FILE__, __LINE__);
        while($row = $forum_db->fetch_assoc($result))
            $answers[$row['id']] = $row['answer'];
            
        /* select user names */
        $ids = implode(',',array_keys($votes));
        $query = array(
            'SELECT'    => 'id,username,num_posts',
            'FROM'        => 'users',
            'WHERE'        => 'id in ('.$ids.')'
        );
        $result = $forum_db->query_build($query) or error(__FILE__, __LINE__);
        while($row = $forum_db->fetch_assoc($result)) {
            $names[$row['id']]['name'] = $row['username'];
            $names[$row['id']]['posts'] = $row['num_posts'];
        }
        
        $return = array();
        foreach($votes as $id=>$answ_id)
            $return[] = '<a href="'.forum_link($forum_url['user'], $id).'" title="'.$lang_pun_poll['Voting answer'].': '.forum_htmlencode($answers[$answ_id]).'; '.$lang_topic['Posts info'].' '.$names[$id]['posts'].'">'.forum_htmlencode($names[$id]['name']).'</a>';
        
        return implode(', ',$return);
    } else return $lang_pun_poll['No voters'];
}

'No voters'                        =>  'No voters',

if($forum_user['is_admmod']) {
                    require $ext_info['path'].'/functions.php';
                    $main_elements['<!-- forum_main_pagepost_top -->'] .= '<div class="ct-box info-box"><p>'.show_voted($id).'</p></div>';
                }

    <div id="spoiler-container" class="mf-box checkbox" style="border:0px solid black;">    
    <span id="spoiler-button" onClick="if(this.innerHTML=='Create Poll'){this.parentNode.getElementsByTagName('div')[0].style.display = 'block';this.innerHTML='Hide';} else {this.parentNode.getElementsByTagName('div')[0].style.display = 'none';this.innerHTML='Create Poll';}">Create Poll</span>
    <div id="spoiler-hidebox">
<fieldset class="frm-group group<?php echo ++$forum_page['group_count'] ?>">

</div></div>