Latest posts for the topic "How I make to show resulted in columns?"

How I make to show resulted in columns?

hugosenna — GMT

Como faço para exibir resultados em colunas ?

How I make to show resulted in columns?

[img]http://img476.imageshack.us/img476/6526/poll9lj.th.jpg[/img]

respostas em colunas

hugosenna — GMT

[url]http://img476.imageshack.us/img476/6526/poll9lj.jpg[/url]

how to show opçoes of answers in columns?

como mostrar opçoes de respostas em colunas ?

[img]http://img476.imageshack.us/img476/6526/poll9lj.jpg[/img]

jalmz — GMT

Hi Carbz,

Gud pm.. HOw to do this?

jalmz — GMT

Carbz,
How I make to show resulted in columns?

[img]http://img476.imageshack.us/img476/6526/poll9lj.jpg[/img]

thanks...

-jalmz

Carbonize — GMT

Can you do me an example of what you mean? the results or the options?

jalmz — GMT

the options.. where the user will vote.. thanks carbz

jalmz — GMT

here is it carbz...

[img]http://img157.imageshack.us/img157/5061/samplejj3.jpg[/img]

like this one....

Carbonize — GMT

Would require some recoding of the script or the use of a div I think.

jalmz — GMT

how? i have the idea how to put the picture.
the problem is that, how to make that one in 4 coloumn.. huhuhu

Carbonize — GMT

The pictures are easy as you can use HTML when making the poll ) and that is possibly a way to achieve what you want.

jalmz — GMT

[quote="Carbonize"]The pictures are easy as you can use HTML when making the poll ) and that is possibly a way to achieve what you want.[/quote]

then how can i make my poll in 4 columns..? pls.. carbz.. help

jalmz — GMT

carbz?

Carbonize — GMT

Sorry have been tied up with work due to impending audit. Do the options appear in the order you enter them?

jalmz — GMT

[quote="Carbonize"]Sorry have been tied up with work due to impending audit. Do the options appear in the order you enter them?[/quote]

what do you mean?

Carbonize — GMT

Might be worth you dropping Auron a PM as he's more familiar with AP.

jalmz — GMT

[quote="Carbonize"]Might be worth you dropping Auron a PM as he's more familiar with AP.[/quote]

thanks carbz

Auron — GMT

go to the poll admin panel then the templates section.

edit the templates to how you want the results to appear.

for more info on templates check my sig.

Auron

jalmz — GMT

thanks auron.. =)

jalmz — GMT

Hi auron,

i want to have like this one...

[img]http://img157.imageshack.us/img157/5061/samplejj3.jpg[/img]

i downloaded already the guide. but i cant find the solution.

Carbonize — GMT

Yes I'm not sure that can be achieved using the templates. Would need a loop. eg

[code]$theDisplay = '';
$theCount = 0;
while (fetch results stuff)
{
$theCount++;
if ($theCount == 5)
{
$theDisplay .= "\n\n\n";
$theCount = 0;
}
else
{
$theDisplay .= "\n";
}
}
if ($theCount != 0)
{
for($i = $theCount; $i < 5; $i++)
{
$theDisplay .= "\n";
}
$theDisplay .= "\n";
}
$theDisplay .= '

{POLL STUFF}

';[/code]

Only a quick idea probably has bugs and I know the vriables aer not correct.

Auron — GMT

afaik, the poll loops round using the same bit of html for each option.
so you'd have to modify the template yourself and whatever file calls the template.

the poll is designed to start the table -> echo each option with the html from the template -> then end the table.
In the admin panel when editing the template it is only possible to display one option at a time, if you doubled up the code for the options you would most likely get each option twice resulting in two columns.

jalmz — GMT

[quote="Carbonize"]Yes I'm not sure that can be achieved using the templates. Would need a loop. eg

[code]$theDisplay = '';
$theCount = 0;
while (fetch results stuff)
{
$theCount++;
if ($theCount == 5)
{
$theDisplay .= "\n\n\n";
$theCount = 0;
}
else
{
$theDisplay .= "\n";
}
}
if ($theCount != 0)
{
for($i = $theCount; $i < 5; $i++)
{
$theDisplay .= "\n";
}
$theDisplay .= "\n";
}
$theDisplay .= '

{POLL STUFF}

';[/code]

Only a quick idea probably has bugs and I know the vriables aer not correct.[/quote]

what is the correct variable carbz?

Carbonize — GMT

Don't know as I don't use AP and I cannot download zip files whilst at work.

jalmz — GMT

[quote="Auron"]afaik, the poll loops round using the same bit of html for each option.
so you'd have to modify the template yourself and whatever file calls the template.

the poll is designed to start the table -> echo each option with the html from the template -> then end the table.
In the admin panel when editing the template it is only possible to display one option at a time, if you doubled up the code for the options you would most likely get each option twice resulting in two columns.[/quote]

its hard to do.....

jalmz — GMT

[quote="Carbonize"]Don't know as I don't use AP and I cannot download zip files whilst at work.[/quote]

Hi carbz,

in display_loop.html

this is the code

[code]

$data[option_text]
[/code]

Carbonize — GMT

It would be the code in the poll that calls the templates I would need to look at.

jalmz — GMT

what about this one..

INCLUDE
class_poll.php

[code] /**
* ----------------------------------------------
* Advanced Poll 2.0.7 (PHP/MySQL)
* Copyright (c) Chi Kien Uong
* URL: http://www.proxy2.de
* ----------------------------------------------
*/

class poll {

var $db;
var $tbl;
var $pollvars;
var $poll_view_html;
var $poll_result_html;
var $options;
var $options_text;
var $poll_question;
var $form_forward;
var $template_set;
var $ip;

function poll() {
global $POLLTBL, $CLASS;
$this->tbl = $POLLTBL;
$this->poll_view_html = array();
$this->poll_result_html = array();
$this->options = array();
$this->options_text = array();
$this->poll_question = array();
$this->form_forward = basename($_SERVER['PHP_SELF']);

$this->ip = getenv("REMOTE_ADDR");
$this->db = &$CLASS["db"];
$this->pollvars = $this->db->fetch_array($this->db->query("SELECT * FROM ".$this->tbl['poll_config']));
$this->template_set = "default";

if ($this->pollvars['result_order'] == "asc") {
$this->pollvars['result_order'] = "ORDER BY votes ASC";
} elseif ($this->pollvars['result_order'] == "desc") {
$this->pollvars['result_order'] = "ORDER BY votes DESC";
} else {
$this->pollvars['result_order'] = '';
}
}

function set_template_set($template_set='') {
if (!empty($template_set)) {
$template_set = addslashes($template_set);
$this->db->fetch_array($this->db->query("SELECT * FROM ".$this->tbl['poll_tplset']." WHERE tplset_name='$template_set'"));
if ($this->db->record) {
$this->template_set = $template_set;
} else {
$this->template_set = "default";
}
} else {
$this->template_set = "default";
}
return $this->template_set;
}

function set_display_order($order='') {
switch ($order) {
case "asc":
$this->pollvars['result_order'] = "ORDER BY votes ASC";
break;
case "desc":
$this->pollvars['result_order'] = "ORDER BY votes DESC";
break;
default:
$this->pollvars['result_order'] = "";
return false;
}
return true;
}

function set_display_result($result='') {
switch ($result) {
case "votes":
$this->pollvars['type'] = "votes";
break;
case "percent":
$this->pollvars['type'] = "percent";
break;
default:
return false;
}
return true;
}

function set_max_bar_length($max_bar_length=0) {
if ($max_bar_length && $max_bar_length>0) {
$this->pollvars['img_length'] = $max_bar_length;
return true;
} else {
return false;
}
}

function set_max_bar_height($max_bar_height=0) {
if ($max_bar_height && $max_bar_height>0) {
$this->pollvars['img_height'] = $max_bar_height;
return true;
} else {
return false;
}
}

function get_poll_tpl($tpl) {
$tpl = addslashes($tpl);
$this->db->fetch_array($this->db->query("SELECT x.*, y.* from ".$this->tbl['poll_tplset']." x, ".$this->tbl['poll_tpl']." y where x.tplset_name='$this->template_set' and x.tplset_id=y.tplset_id AND y.title='$tpl'"));
if ($this->db->record['template']) {
$this->db->record['template'] = ereg_replace("\"", "\\\"", $this->db->record['template']);
return $this->db->record['template'];
} else {
return false;
}
}

function get_poll_data($poll_id) {
$poll_id = intval($poll_id);
if (!isset($this->options[$poll_id])) {
$this->db->query("SELECT SUM(votes) as total FROM ".$this->tbl['poll_data']." WHERE (poll_id = '$poll_id')");
$this->db->fetch_array($this->db->result);
$this->options[$poll_id]['total'] = $this->db->record['total'];
$this->db->query("SELECT * FROM ".$this->tbl['poll_data']." WHERE (poll_id = '$poll_id') ".$this->pollvars['result_order']);
while ($this->db->fetch_array($this->db->result)) {
$option_id_arr[] = $this->db->record['option_id'];
$option_text_arr[] = $this->db->record['option_text'];
$option_votes_arr[] = $this->db->record['votes'];
$option_color_arr[] = $this->db->record['color'];
}
$this->options[$poll_id]['option_id'] = $option_id_arr;
$this->options[$poll_id]['option_text'] = $option_text_arr;
$this->options[$poll_id]['votes'] = $option_votes_arr;
$this->options[$poll_id]['color'] = $option_color_arr;
for ($i=0,$maxvote=0; $i $maxvote = ($option_votes_arr[$i]>$maxvote) ? $option_votes_arr[$i] : $maxvote;
}
$this->options[$poll_id]['maxvote'] = $maxvote;
}
return $this->options[$poll_id];
}

function get_poll_option($poll_id) {
$poll_id = intval($poll_id);
if (!isset($this->options_text[$poll_id])) {
$query = $this->db->query("SELECT option_id, option_text FROM ".$this->tbl['poll_data']." WHERE (poll_id = '$poll_id') order by option_id asc");
while ($data = $this->db->fetch_array($query)) {
$option_id_arr[] = $this->db->record['option_id'];
$option_text_arr[] = $this->db->record['option_text'];
}
$this->options_text[$poll_id]['option_id'] = $option_id_arr;
$this->options_text[$poll_id]['option_text'] = $option_text_arr;
}
return $this->options_text[$poll_id];
}

function get_poll_question($poll_id) {
$poll_id = intval($poll_id);
if (!isset($this->poll_question[$poll_id])) {
$row = $this->db->fetch_array($this->db->query("SELECT question FROM ".$this->tbl['poll_index']." WHERE (poll_id = '$poll_id')"));
$this->poll_question[$poll_id] = $row['question'];
}
return $this->poll_question[$poll_id];
}

function display_poll($poll_id) {
$poll_id = intval($poll_id);
if (!isset($this->poll_view_html[$poll_id]) || !isset($this->poll_view_html[$poll_id][$this->template_set])) {
$pollvars = $this->pollvars;
if (!isset($this->options_text[$poll_id])) {
$this->get_poll_option($poll_id);
}
$question = $this->get_poll_question($poll_id);
eval("\$display_html = \"".$this->get_poll_tpl("display_head")."\";");
$loop_html = $this->get_poll_tpl("display_loop");
for ($i=0;$ioptions_text[$poll_id]['option_id']);$i++) {
$data['option_text'] = $this->options_text[$poll_id]['option_text'][$i];
$data['option_id'] = $this->options_text[$poll_id]['option_id'][$i];
eval("\$display_html .= \"$loop_html\";");
}
eval("\$display_html .= \"".$this->get_poll_tpl("display_foot")."\";");
$this->poll_view_html[$poll_id][$this->template_set] = $display_html;
}
return $this->poll_view_html[$poll_id][$this->template_set];
}

function view_poll_result($poll_id,$vote_stat=0) {
$poll_id = intval($poll_id);
if (!isset($this->poll_result_html[$poll_id]) || !isset($this->poll_result_html[$poll_id][$this->template_set])) {
$pollvars = $this->pollvars;
$row = $this->db->fetch_array($this->db->query("SELECT * FROM ".$this->tbl['poll_index']." WHERE (poll_id = '$poll_id')"));
if (!$row) {
return "";
}
$question = $row['question'];
$VOTE = ($vote_stat==1) ? $this->pollvars['voted'] : '';
$COMMENT = ($row['comments']==1) ? "template_set','$poll_id','width=230,height=320,toolbar=no,statusbar=no'))\">".$this->pollvars['send_com']."" : '';
eval("\$result_html = \"".$this->get_poll_tpl("result_head")."\";");
$i=0;
$loop_html = $this->get_poll_tpl("result_loop");
if (!isset($this->options[$poll_id])) {
$this->get_poll_data($poll_id);
}
$maxvote = ($this->options[$poll_id]['maxvote'] == 0) ? 1 : $this->options[$poll_id]['maxvote'];
$totalvotes = ($this->options[$poll_id]['total'] == 0) ? 1 : $this->options[$poll_id]['total'];
for ($i=0;$ioptions[$poll_id]['option_id']);$i++) {
$img_width = (int) ($this->options[$poll_id]['votes'][$i]*$this->pollvars['img_length']/$maxvote);
$vote_count = $this->options[$poll_id]['votes'][$i];
$vote_percent = sprintf("%.2f",($this->options[$poll_id]['votes'][$i]*100/$totalvotes));
$vote_val = ($this->pollvars['type'] == "percent") ? sprintf("%.1f",($this->options[$poll_id]['votes'][$i]*100/$totalvotes))."%" : $vote_count;
$option_text = $this->options[$poll_id]['option_text'][$i];
$option_votes = $this->options[$poll_id]['votes'][$i];
$poll_color = $this->options[$poll_id]['color'][$i];
eval("\$result_html .= \"$loop_html\";");
}
$total_votes = $this->options[$poll_id]['total'];
eval("\$result_html .= \"".$this->get_poll_tpl("result_foot")."\";");
$this->poll_result_html[$poll_id][$this->template_set] = $result_html;
}
return $this->poll_result_html[$poll_id][$this->template_set];
}

function update_poll($poll_id,$option_id) {
$poll_id = intval($poll_id);
$option_id = intval($option_id);
$this->db->query("UPDATE ".$this->tbl['poll_data']." SET votes=votes+1 WHERE (poll_id='$poll_id') AND (option_id='$option_id')");
$row = $this->db->fetch_array($this->db->query("SELECT logging as logging FROM ".$this->tbl['poll_index']." WHERE (poll_id = '$poll_id')"));
$timestamp = time();
if ($this->pollvars['check_ip'] == 2) {
$this->db->query("INSERT INTO ".$this->tbl['poll_ip']." (poll_id,ip_addr,timestamp) VALUES ('$poll_id','$this->ip','$timestamp')");
}
if ($row['logging'] == 1) {
$host = @gethostbyaddr($this->ip);
$agent = addslashes(getenv("HTTP_USER_AGENT"));
$this->db->query("INSERT INTO ".$this->tbl['poll_log']." (poll_id,option_id,timestamp,ip_addr,host,agent) VALUES ('$poll_id','$option_id','$timestamp','$this->ip','$host','$agent')");
}
}

function get_latest_poll_id() {
$this->db->query("SELECT poll_id FROM ".$this->tbl['poll_index']." WHERE (status < '2') ORDER BY TIMESTAMP DESC LIMIT 1");
$this->db->fetch_array($this->db->result);
return (!isset($this->db->record['poll_id'])) ? 0 : $this->db->record['poll_id'];
}

function get_random_poll_id() {
$timestamp = time();
$this->db->query("SELECT poll_id FROM ".$this->tbl['poll_index']." WHERE (status=1 AND exp_time>$timestamp) OR (status=1 AND expire=0)");
while ($this->db->fetch_array($this->db->result)) {
$poll_id_arr[] = $this->db->record['poll_id'];
}
if (!isset($poll_id_arr)) {
return 0;
}
$available = sizeof($poll_id_arr)-1;
srand((double) microtime() * 1000000);
$random_id = ($available>0) ? rand(0,$available) : 0;
return $poll_id_arr[$random_id];
}

function is_active_poll_id($poll_id) {
$poll_id = intval($poll_id);
$this->db->fetch_array($this->db->query("SELECT * FROM ".$this->tbl['poll_index']." WHERE (poll_id='$poll_id' AND status=1)"));
if (!$this->db->record) {
return false;
} elseif ($this->db->record['expire']==0) {
return true;
}
return ($this->db->record['exp_time'] }

function is_valid_poll_id($poll_id) {
$poll_id = intval($poll_id);
if ($poll_id>0) {
$this->db->fetch_array($this->db->query("SELECT poll_id FROM ".$this->tbl['poll_index']." WHERE poll_id=$poll_id AND status<'2'"));
return ($this->db->record['poll_id']) ? true : false;
} else {
return false;
}
}

function has_voted($poll_id) {
$poll_id = intval($poll_id);
$pollcookie = $poll_id;
if (isset($_COOKIE['AdvancedPoll'][$pollcookie])) {
return true;
}
if ($this->pollvars['check_ip']==2) {
$today = time()-$this->pollvars['lock_timeout']*3600;
$this->db->query("DELETE FROM ".$this->tbl['poll_ip']." WHERE (timestamp < $today)");
$this->db->fetch_array($this->db->query("SELECT * FROM ".$this->tbl['poll_ip']." WHERE (ip_addr = '$this->ip' and poll_id='$poll_id')"));
return ($this->db->record) ? true : false;
}
}

function get_query_strg($self) {
if (isset($_SERVER['QUERY_STRING']) && !empty($_SERVER['QUERY_STRING'])) {
if (ereg("($self=[0-9]+)",$_SERVER['QUERY_STRING'],$regs)) {
$_SERVER['QUERY_STRING'] = str_replace($regs[1], "", $_SERVER['QUERY_STRING']);
}
$_SERVER['QUERY_STRING'] = str_replace("$self=", "", $_SERVER['QUERY_STRING']);
if (empty($_SERVER['QUERY_STRING'])) {
$append = $_SERVER['PHP_SELF']."?";
} else {
$query_vars = explode("&",$_SERVER['QUERY_STRING']);
$append = $_SERVER['PHP_SELF']."?";
for ($i=0; $i if (!empty($query_vars[$i])) {
$append .= $query_vars[$i]."&";
}
}
}
} else {
$append = $_SERVER['PHP_SELF']."?";
}
return $append;
}

function poll_process($poll_id='') {
$poll_ident = (isset($_POST['poll_ident'])) ? intval($_POST['poll_ident']) : "";
if ($poll_ident == "") {
if (isset($_GET['poll_ident'])) {
$poll_ident = intval($_GET['poll_ident']);
}
}

$option_id = (isset($_POST['option_id'])) ? intval($_POST['option_id']) : "";
if ($option_id == "") {
if (isset($_GET['option_id'])) {
$option_id = intval($_GET['option_id']);
}
}

$action = (isset($_POST['action'])) ? trim($_POST['action']) : "";
if ($action == "") {
if (isset($_GET['action'])) {
$action = trim($_GET['action']);
}
}

if ($poll_id=="random") {
$poll_id = (empty($poll_ident)) ? $this->get_random_poll_id() : $poll_ident;
} elseif ($poll_id=="newest") {
$poll_id = $this->get_latest_poll_id();
}
if ($this->is_valid_poll_id($poll_id)) {
$voted = $this->has_voted($poll_id);
$is_active = $this->is_active_poll_id($poll_id);
if ($action=="results" && $poll_id==$poll_ident) {
return $this->view_poll_result($poll_id,0);
} elseif (!$is_active) {
return $this->view_poll_result($poll_id,0);
} elseif ($is_active && $voted) {
return $this->view_poll_result($poll_id,1);
} elseif (!$voted && isset($option_id) && $action=="vote" && $poll_id==$poll_ident) {
$this->update_poll($poll_id,$option_id);
return $this->view_poll_result($poll_id,0);
} else {
return $this->display_poll($poll_id);
}
} else {
$error = "Poll ID ".intval($poll_id)." does not exist.";
return $error;
}
}

} ?> [/code]

jalmz — GMT

carbz?

Carbonize — GMT

Sorry I'm a tad busy at present. I will download it to my laptop for when I get some free time.

jalmz — GMT

[quote="Carbonize"]Sorry I'm a tad busy at present. I will download it to my laptop for when I get some free time.[/quote]

Thanks Carbz. =)

jalmz — GMT

Auron can you help me??