[Top][All Lists]
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Phpgroupware-cvs] CVS: polls/inc functions.inc.php,1.12,1.13
From: |
Dave Hall <address@hidden> |
Subject: |
[Phpgroupware-cvs] CVS: polls/inc functions.inc.php,1.12,1.13 |
Date: |
Fri, 15 Nov 2002 04:07:45 -0500 |
Update of /cvsroot/phpgroupware/polls/inc
In directory subversions:/tmp/cvs-serv16750/inc
Modified Files:
functions.inc.php
Log Message:
patch #641
Index: functions.inc.php
===================================================================
RCS file: /cvsroot/phpgroupware/polls/inc/functions.inc.php,v
retrieving revision 1.12
retrieving revision 1.13
diff -C2 -r1.12 -r1.13
*** functions.inc.php 20 Feb 2002 13:42:21 -0000 1.12
--- functions.inc.php 15 Nov 2002 09:07:42 -0000 1.13
***************
*** 1,221 ****
! <?php
! /**************************************************************************\
! * phpGroupWare - Polls *
! * http://www.phpgroupware.org *
! * The file is based on phpPolls *
! * Copyright (c) 1999 Till Gerken (address@hidden)
*
! * -------------------------------------------- *
! * This program is free software; you can redistribute it and/or modify it *
! * under the terms of the GNU General Public License as published by the *
! * Free Software Foundation; either version 2 of the License, or (at your *
! * option) any later version. *
! \**************************************************************************/
!
! /* $Id$ */
!
! $GLOBALS['phpgw']->db->query("select * from phpgw_polls_settings");
! while ($GLOBALS['phpgw']->db->next_record())
! {
!
$GLOBALS['poll_settings'][$GLOBALS['phpgw']->db->f('setting_name')] =
$GLOBALS['phpgw']->db->f('setting_value');
! }
!
! function add_template_row(&$tpl,$label,$value)
! {
!
$GLOBALS['phpgw']->nextmatchs->template_alternate_row_color(&$tpl);
! $tpl->set_var('td_1',$label);
! $tpl->set_var('td_2',$value);
! $tpl->parse('rows','row',True);
! }
!
! function verify_uservote($poll_id)
! {
! if ($GLOBALS['poll_settings']['allow_multiable_votes'])
! {
! return True;
! }
!
! $GLOBALS['phpgw']->db->query("select count(*) from
phpgw_polls_user where user_id='" . $GLOBALS['phpgw_info']['user']['account_id']
! . "' and poll_id='$poll_id'",__LINE__,__FILE__);
! $GLOBALS['phpgw']->db->next_record();
!
! if ($GLOBALS['phpgw']->db->f(0) == 0)
! {
! return True;
! }
! else
! {
! return False;
! }
! // return ($db->f(0)?True:False);
! }
!
! function poll_viewResults($poll_id,$website=False)
! {
! $GLOBALS['phpgw']->db->query("SELECT SUM(option_count) AS sum
FROM phpgw_polls_data WHERE poll_id='$poll_id'",__LINE__,__FILE__);
! $GLOBALS['phpgw']->db->next_record();
! $poll_sum = (int)$GLOBALS['phpgw']->db->f(0);
!
! $GLOBALS['phpgw']->db->query("select poll_title from
phpgw_polls_desc where poll_id='$poll_id'",__LINE__,__FILE__);
! $GLOBALS['phpgw']->db->next_record();
!
! $out = '<p><table border="0" align="center" width="50%">';
! $out .= ' <tr>' . "\n"
! . ' <td colspan="3" bgcolor="' .
$GLOBALS['phpgw_info']['theme']['th_bg'] . '" align="center">'
! . $GLOBALS['phpgw']->db->f('poll_title') . '</td>' .
"\n"
! . '</tr>' . "\n";
!
! $GLOBALS['phpgw']->db->query("SELECT * FROM phpgw_polls_data
WHERE poll_id='$poll_id'",__LINE__,__FILE__);
! while ($GLOBALS['phpgw']->db->next_record())
! {
! $poll_optionText =
$GLOBALS['phpgw']->db->f('option_text');
! $poll_optionCount =
$GLOBALS['phpgw']->db->f('option_count');
!
! $tr_color =
$GLOBALS['phpgw']->nextmatchs->alternate_row_color($tr_color);
! $out .= ' <tr bgcolor="' . $tr_color . '">' . "\n";
!
! if ($poll_optionText != '')
! {
! $out .= " <td>$poll_optionText</td>\n";
!
! if ($poll_sum)
! {
! $poll_percent = 100 * $poll_optionCount
/ $poll_sum;
! }
! else
! {
! $poll_percent = 0;
! }
!
! if ($poll_percent > 0)
! {
! $poll_percentScale =
(int)($poll_percent * 1);
! $out .= ' <td><img src="' .
$GLOBALS['phpgw_info']['server']['webserver_url']
! . '/polls/images/pollbar.gif"
height="12" width="' . $poll_percentScale
! . '"></td>' . "\n";
! }
! else
! {
! $out .= ' <td> </td>' . "\n";
! }
!
! $out .= printf(' <td> %.2f %% (%d)</td>' .
"\n" . ' </tr>' . "\n", $poll_percent, $poll_optionCount);
!
! $out .= ' </tr>' . "\n";
! }
! }
!
! $out .= ' <tr bgcolor="' .
$GLOBALS['phpgw_info']['theme']['bgcolor'] . '">' . "\n"
! . ' <td>' . lang('Total votes') . ': ' . $poll_sum .
'</td>' . "\n"
! . ' </tr>' . "\n"
! . '</table>' . "\n";
!
! if($website)
! {
! return $out;
! }
! else
! {
! echo $out;
! }
! }
!
! function poll_getResults($poll_id)
! {
! $ret = array();
!
! $GLOBALS['phpgw']->db->query("SELECT SUM(option_count) AS sum
FROM phpgw_polls_data WHERE poll_id='$poll_id'",__LINE__,__FILE__);
! $GLOBALS['phpgw']->db->next_record();
! $poll_sum = $GLOBALS['phpgw']->db->f('sum');
!
! $GLOBALS['phpgw']->db->query("SELECT poll_title FROM
phpgw_polls_desc WHERE poll_id='$poll_id'",__LINE__,__FILE__);
! $GLOBALS['phpgw']->db->next_record();
!
! $poll_title = $GLOBALS['phpgw']->db->f('poll_title');
!
! $ret[0] = array(
! 'title' => $poll_title,
! 'votes' => $poll_sum
! );
!
! // select next vote option
! $GLOBALS['phpgw']->db->query("SELECT * FROM phpgw_polls_data
WHERE poll_id='$poll_id'",__LINE__,__FILE__);
! while ($GLOBALS['phpgw']->db->next_record())
! {
! $ret[] = array(
! 'text' =>
$GLOBALS['phpgw']->db->f('option_text'),
! 'votes' =>
$GLOBALS['phpgw']->db->f('option_count')
! );
! }
!
! return $ret;
! }
!
! function poll_generateUI($poll_id='',$website=False)
! {
! if(!$poll_id)
! {
! $GLOBALS['phpgw']->db->query("select max(poll_id) from
phpgw_polls_desc",__LINE__,__FILE__);
! $GLOBALS['phpgw']->db->next_record();
! $poll_id = $GLOBALS['phpgw']->db->f(0);
! }
!
! if(!verify_uservote($poll_id))
! {
! return False;
! }
!
! $GLOBALS['phpgw']->db->query("select poll_title from
phpgw_polls_desc where poll_id='$poll_id'",__LINE__,__FILE__);
! $GLOBALS['phpgw']->db->next_record();
!
! $out = "\n";
! $out .= '<form action="' .
$GLOBALS['phpgw']->link('/polls/vote.php') . '" method="post">' . "\n";
! $out .= '<input type="hidden" name="poll_id" value="' .
$poll_id . '">' . "\n";
! // $out .= '<input type="hidden" name="poll_forwarder" value="' .
$poll_forwarder . '">';
! $out .= '<table border="0" align="center" width="50%">' . "\n"
! . ' <tr>' . "\n"
! . ' <td colspan="2" bgcolor="' .
$GLOBALS['phpgw_info']['theme']['th_bg'] . '" align="center"> '
! . $GLOBALS['phpgw']->db->f('poll_title') .
' </td>' . "\n"
! . ' </tr>' . "\n";
!
! $GLOBALS['phpgw']->db->query("SELECT * FROM phpgw_polls_data
WHERE poll_id='$poll_id'",__LINE__,__FILE__);
! while($GLOBALS['phpgw']->db->next_record())
! {
! $tr_color =
$GLOBALS['phpgw']->nextmatchs->alternate_row_color($tr_color);
! $out .= ' <tr bgcolor="' . $tr_color . '">' . "\n"
! . ' <td align="center"><input type="radio"
name="poll_voteNr" value="'
! . $GLOBALS['phpgw']->db->f('vote_id') .
'"></td>' . "\n"
! . ' <td> ' .
$GLOBALS['phpgw']->db->f('option_text') . '</td>' . "\n"
! . ' </tr>' . "\n";
! }
!
! $out .= ' <tr bgcolor="' .
$GLOBALS['phpgw_info']['theme']['bgcolor'] . '">' . "\n"
! . ' <td colspan="2"> </td>' . "\n"
! . ' </tr>' . "\n"
! . ' <tr bgcolor="' .
$GLOBALS['phpgw_info']['theme']['bgcolor'] . '">' . "\n"
! . ' <td colspan="2" align="center">'
! . ' <input name="submit" type="submit" value="' .
lang('Vote') . '"></td>' . "\n"
! . ' </tr>' . "\n"
! . '</table>' . "\n" . '</form>' . "\n";
!
! if($website)
! {
! return $out;
! }
! else
! {
! echo $out;
! }
! }
!
! function display_poll($website=False)
! {
! if(!verify_uservote($GLOBALS['poll_settings']['currentpoll']))
! {
! return
poll_viewResults($GLOBALS['poll_settings']['currentpoll'],$website);
! }
! else
! {
! return
poll_generateUI($GLOBALS['poll_settings']['currentpoll'],$website);
! }
! }
! ?>
--- 1,221 ----
! <?php
! /**************************************************************************\
! * phpGroupWare - Polls *
! * http://www.phpgroupware.org *
! * The file is based on phpPolls *
! * Copyright (c) 1999 Till Gerken (address@hidden)
*
! * -------------------------------------------- *
! * This program is free software; you can redistribute it and/or modify it *
! * under the terms of the GNU General Public License as published by the *
! * Free Software Foundation; either version 2 of the License, or (at your *
! * option) any later version. *
! \**************************************************************************/
!
! /* $Id$ */
!
! $GLOBALS['phpgw']->db->query("select * from phpgw_polls_settings");
! while ($GLOBALS['phpgw']->db->next_record())
! {
!
$GLOBALS['poll_settings'][$GLOBALS['phpgw']->db->f('setting_name')] =
$GLOBALS['phpgw']->db->f('setting_value');
! }
!
! function add_template_row(&$tpl,$label,$value)
! {
!
$GLOBALS['phpgw']->nextmatchs->template_alternate_row_color(&$tpl);
! $tpl->set_var('td_1',$label);
! $tpl->set_var('td_2',$value);
! $tpl->parse('rows','row',True);
! }
!
! function verify_uservote($poll_id)
! {
! if ($GLOBALS['poll_settings']['allow_multiable_votes'])
! {
! return True;
! }
!
! $GLOBALS['phpgw']->db->query("select count(*) from
phpgw_polls_user where user_id='" . $GLOBALS['phpgw_info']['user']['account_id']
! . "' and poll_id='$poll_id'",__LINE__,__FILE__);
! $GLOBALS['phpgw']->db->next_record();
!
! if ($GLOBALS['phpgw']->db->f(0) == 0)
! {
! return True;
! }
! else
! {
! return False;
! }
! // return ($db->f(0)?True:False);
! }
!
! function poll_viewResults($poll_id,$website=False)
! {
! $GLOBALS['phpgw']->db->query("SELECT SUM(option_count) AS sum
FROM phpgw_polls_data WHERE poll_id='$poll_id'",__LINE__,__FILE__);
! $GLOBALS['phpgw']->db->next_record();
! $poll_sum = (int)$GLOBALS['phpgw']->db->f(0);
!
! $GLOBALS['phpgw']->db->query("select poll_title from
phpgw_polls_desc where poll_id='$poll_id'",__LINE__,__FILE__);
! $GLOBALS['phpgw']->db->next_record();
!
! $out = '<p><table border="0" align="center" width="50%">';
! $out .= ' <tr>' . "\n"
! . ' <td colspan="3" bgcolor="' .
$GLOBALS['phpgw_info']['theme']['th_bg'] . '" align="center">'
! . stripslashes($GLOBALS['phpgw']->db->f('poll_title'))
. '</td>' . "\n"
! . '</tr>' . "\n";
!
! $GLOBALS['phpgw']->db->query("SELECT * FROM phpgw_polls_data
WHERE poll_id='$poll_id'",__LINE__,__FILE__);
! while ($GLOBALS['phpgw']->db->next_record())
! {
! $poll_optionText =
stripslashes($GLOBALS['phpgw']->db->f('option_text'));
! $poll_optionCount =
$GLOBALS['phpgw']->db->f('option_count');
!
! $tr_color =
$GLOBALS['phpgw']->nextmatchs->alternate_row_color($tr_color);
! $out .= ' <tr bgcolor="' . $tr_color . '">' . "\n";
!
! if ($poll_optionText != '')
! {
! $out .= " <td>$poll_optionText</td>\n";
!
! if ($poll_sum)
! {
! $poll_percent = 100 * $poll_optionCount
/ $poll_sum;
! }
! else
! {
! $poll_percent = 0;
! }
!
! if ($poll_percent > 0)
! {
! $poll_percentScale =
(int)($poll_percent * 1);
! $out .= ' <td><img src="' .
$GLOBALS['phpgw_info']['server']['webserver_url']
! . '/polls/images/pollbar.gif"
height="12" width="' . $poll_percentScale
! . '"></td>' . "\n";
! }
! else
! {
! $out .= ' <td> </td>' . "\n";
! }
!
! $out .= printf(' <td> %.2f %% (%d)</td>' .
"\n" . ' </tr>' . "\n", $poll_percent, $poll_optionCount);
!
! $out .= ' </tr>' . "\n";
! }
! }
!
! $out .= ' <tr bgcolor="' .
$GLOBALS['phpgw_info']['theme']['bgcolor'] . '">' . "\n"
! . ' <td>' . lang('Total votes') . ': ' . $poll_sum .
'</td>' . "\n"
! . ' </tr>' . "\n"
! . '</table>' . "\n";
!
! if($website)
! {
! return $out;
! }
! else
! {
! echo $out;
! }
! }
!
! function poll_getResults($poll_id)
! {
! $ret = array();
!
! $GLOBALS['phpgw']->db->query("SELECT SUM(option_count) AS sum
FROM phpgw_polls_data WHERE poll_id='$poll_id'",__LINE__,__FILE__);
! $GLOBALS['phpgw']->db->next_record();
! $poll_sum = $GLOBALS['phpgw']->db->f('sum');
!
! $GLOBALS['phpgw']->db->query("SELECT poll_title FROM
phpgw_polls_desc WHERE poll_id='$poll_id'",__LINE__,__FILE__);
! $GLOBALS['phpgw']->db->next_record();
!
! $poll_title =
stripslashes($GLOBALS['phpgw']->db->f('poll_title'));
!
! $ret[0] = array(
! 'title' => $poll_title,
! 'votes' => $poll_sum
! );
!
! // select next vote option
! $GLOBALS['phpgw']->db->query("SELECT * FROM phpgw_polls_data
WHERE poll_id='$poll_id'",__LINE__,__FILE__);
! while ($GLOBALS['phpgw']->db->next_record())
! {
! $ret[] = array(
! 'text' =>
stripslashes($GLOBALS['phpgw']->db->f('option_text')),
! 'votes' =>
$GLOBALS['phpgw']->db->f('option_count')
! );
! }
!
! return $ret;
! }
!
! function poll_generateUI($poll_id='',$website=False)
! {
! if(!$poll_id)
! {
! $GLOBALS['phpgw']->db->query("select max(poll_id) from
phpgw_polls_desc",__LINE__,__FILE__);
! $GLOBALS['phpgw']->db->next_record();
! $poll_id = $GLOBALS['phpgw']->db->f(0);
! }
!
! if(!verify_uservote($poll_id))
! {
! return False;
! }
!
! $GLOBALS['phpgw']->db->query("select poll_title from
phpgw_polls_desc where poll_id='$poll_id'",__LINE__,__FILE__);
! $GLOBALS['phpgw']->db->next_record();
!
! $out = "\n";
! $out .= '<form action="' .
$GLOBALS['phpgw']->link('/polls/vote.php') . '" method="post">' . "\n";
! $out .= '<input type="hidden" name="poll_id" value="' .
$poll_id . '">' . "\n";
! // $out .= '<input type="hidden" name="poll_forwarder" value="' .
$poll_forwarder . '">';
! $out .= '<table border="0" align="center" width="50%">' . "\n"
! . ' <tr>' . "\n"
! . ' <td colspan="2" bgcolor="' .
$GLOBALS['phpgw_info']['theme']['th_bg'] . '" align="center"> '
! . stripslashes($GLOBALS['phpgw']->db->f('poll_title'))
. ' </td>' . "\n"
! . ' </tr>' . "\n";
!
! $GLOBALS['phpgw']->db->query("SELECT * FROM phpgw_polls_data
WHERE poll_id='$poll_id'",__LINE__,__FILE__);
! while($GLOBALS['phpgw']->db->next_record())
! {
! $tr_color =
$GLOBALS['phpgw']->nextmatchs->alternate_row_color($tr_color);
! $out .= ' <tr bgcolor="' . $tr_color . '">' . "\n"
! . ' <td align="center"><input type="radio"
name="poll_voteNr" value="'
! . $GLOBALS['phpgw']->db->f('vote_id') .
'"></td>' . "\n"
! . ' <td> ' .
$GLOBALS['phpgw']->db->f('option_text') . '</td>' . "\n"
! . ' </tr>' . "\n";
! }
!
! $out .= ' <tr bgcolor="' .
$GLOBALS['phpgw_info']['theme']['bgcolor'] . '">' . "\n"
! . ' <td colspan="2"> </td>' . "\n"
! . ' </tr>' . "\n"
! . ' <tr bgcolor="' .
$GLOBALS['phpgw_info']['theme']['bgcolor'] . '">' . "\n"
! . ' <td colspan="2" align="center">'
! . ' <input name="submit" type="submit" value="' .
lang('Vote') . '"></td>' . "\n"
! . ' </tr>' . "\n"
! . '</table>' . "\n" . '</form>' . "\n";
!
! if($website)
! {
! return $out;
! }
! else
! {
! echo $out;
! }
! }
!
! function display_poll($website=False)
! {
! if(!verify_uservote($GLOBALS['poll_settings']['currentpoll']))
! {
! return
poll_viewResults($GLOBALS['poll_settings']['currentpoll'],$website);
! }
! else
! {
! return
poll_generateUI($GLOBALS['poll_settings']['currentpoll'],$website);
! }
! }
! ?>
[Prev in Thread] |
Current Thread |
[Next in Thread] |
- [Phpgroupware-cvs] CVS: polls/inc functions.inc.php,1.12,1.13,
Dave Hall <address@hidden> <=
- Prev by Date:
[Phpgroupware-cvs] CVS: email/inc class.html_widgets.inc.php,1.1,1.2
- Next by Date:
[Phpgroupware-cvs] CVS: polls admin.php,1.15,1.16 admin_addanswer.php,1.13,1.14 admin_editanswer.php,1.6,1.7 admin_editquestion.php,1.7,1.8 admin_settings.php,1.9,1.10 admin_viewquestion.php,1.8,1.9
- Previous by thread:
[Phpgroupware-cvs] CVS: email/inc class.html_widgets.inc.php,1.1,1.2
- Next by thread:
[Phpgroupware-cvs] CVS: polls admin.php,1.15,1.16 admin_addanswer.php,1.13,1.14 admin_editanswer.php,1.6,1.7 admin_editquestion.php,1.7,1.8 admin_settings.php,1.9,1.10 admin_viewquestion.php,1.8,1.9
- Index(es):