<?php
/***************************************************************************
* admin_mx_poll.php
* -------------------
* Version : 3.0
* Date : 15 May 2002
*
* copyright : (C) 2002 MX-System
* email :
support@mx-system.com
*
* Modified this source for multilanguage and include in the portal
*
*
* Date : Samedi 04 Fevrier 2002
* Auteur : BOBE version 2.0 (utilisation du système des templates))
* GAUTHIER Julien version 1.0 (La version d'origine)
* email :
bobe@2037.biz &
gjai@free.fr
*
* Script for phpbb.biz & 2037.biz
*
*
***************************************************************************/
//
//Parametres Pour phpbb
//
//$no_page_header = TRUE;
if( !empty($setmodules) )
{
$filename = basename(__FILE__);
$module['Portal']['Poll Administration'] = 'admin/' . $filename;
return;
}
define('IN_MX_PORTAL', 1);
//
// Security and page header
//
require('./pagestart.php');
if( isset($HTTP_POST_VARS['submit']) )
{
$mode = "submit";
}
if($mode == "submit")
{
$new[Poll_Topic_id] = $HTTP_POST_VARS[Poll_Topic_id] ;
$sql = "UPDATE " . CONFIG_POLL_TABLE . " SET poll_topic_id = $new[Poll_Topic_id] " ;
if( !$db->sql_query($sql) )
{
message_die(GENERAL_ERROR, "Failed to update poll configuration table ", "", __LINE__, __FILE__, $sql);
}
$message = $lang['Module_Config_updated'] . "<br /><br />" . sprintf($lang['Click_return_moduleadmin'], "<a href=\"" . append_sid("admin_mx_poll.$phpEx") . "\">", "</a>") . "<br /><br />" . sprintf($lang['Click_return_admin_index'], "<a href=\"" . append_sid("index.$phpEx?pane=right") . "\">", "</a>");
message_die(GENERAL_MESSAGE, $message);
}
else
{
$config = read_poll_config();
$template->set_filenames(array( "admin_poll" => "admin/admin_mx_poll.tpl"));
$template->assign_vars(array(
"L_ADMIN_POLL_TITLE" => $lang['Poll Administration'],
"L_ADMIN_POLL_EXPLAIN" => $lang['admin_poll_explain'],
"L_DATE" => $lang['Date'],
"L_POLL_QUESTION" => $lang['Poll_question'],
"L_TOPIC" => $lang['Topic'] ,
"L_POLL_NO" => $lang['POLL_NO'],
"L_ADMIN_POLL_ACTION" => $lang['admin_poll_action'],
"L_MSG_NO_POLL" => $lang['No_Poll_Exist'],
"L_POLL_OPT" => $lang['Poll_option'],
"L_NBR_ANSWERS" => $lang['admin_poll_nbr_answers'],
"L_POLL_USERS" => $lang['admin_poll_users'],
"L_POLL_SETTINGS" => $lang['Poll_Settings'] ,
"L_POLL_DISPLAY" => $lang['Poll_Display'] ,
"POLL_SELECT" => poll_select( $config['poll_topic_id'], 'Poll_Topic_id') ,
"S_CONFIG_ACTION" => append_sid("admin_mx_poll.$phpEx"),
"L_SUBMIT" => $lang['Submit'],
"L_RESET" => $lang['Reset']
));
if($mode == "view")
{
$sql="SELECT * FROM " . VOTE_DESC_TABLE . " AS v, " . TOPICS_TABLE . " AS t WHERE v.topic_id = t.topic_id ORDER BY vote_id DESC";
$result = $db->sql_query($sql);
$row = $db->sql_fetchrow($result);
$id = $row[vote_id];
$poll_title = $row[vote_text];
$topic_id = $row[topic_id];
$tstamp = $row -> vote_start;
$date = create_date($board_config['default_dateformat'], $tstamp, $board_config['board_timezone']);
$topic_title = $row[topic_title];
$template->assign_block_vars("pollrow",array(
"ID" => $row[vote_id],
"TITLE_TOPIC" => $row[topic_title],
"TITLE_POLL" => $row[vote_text],
"U_VIEW_TOPIC" => append_sid( $phpbb_root_path . "viewtopic.php?t=" . $row[topic_id]),
"T_ID" => $row[topic_id],
"POLL_DATE" => $date ));
$sql="SELECT * FROM " . VOTE_USERS_TABLE . " AS v, " . USERS_TABLE . " AS u WHERE v.vote_id =$id AND v.vote_user_id = u.user_id";
$result = $db->sql_query($sql);
while( $row = $db->sql_fetchrow($result) )
{
$id = $row[vote_id];
$user_id = $row[vote_user_id];
$ip = $row[vote_user_ip];
$username = $row[username];
$users_list .= '<a href="../profile.'.$phpEx.'?mode=viewprofile&u='.$user_id.'" target="_blank" class="mainmenu">'.$username.'</a> - ';
}
$template->assign_block_vars("details",array(
'USERS_LIST' => $users_list ));
$sql="SELECT * FROM " . VOTE_RESULTS_TABLE . " WHERE vote_id=$id ORDER BY vote_option_id";
$result = $db->sql_query($sql);
while( $row = $db->sql_fetchrow($result) )
{
$template->assign_block_vars("details.answerrow",array(
"ID_OPTION" => $row[vote_option_id],
"OPTION" => $row[vote_option_text],
"NB_ANSWER" => $row[vote_result],
"U_VIEW_TOPIC" => append_sid( $phpbb_root_path . "viewtopic.php?t=" . $topic_id),
"T_ID" => $topic_id,
"POLL_DATE" => $date
));
}
}
elseif ( $mode == "delete" )
{
$sql1="DELETE FROM ".$table_prefix."vote_desc WHERE vote_id = '$id'";
$sql2="DELETE FROM ".$table_prefix."results WHERE vote_id = '$id'";
$sql3="DELETE FROM ".$table_prefix."voters WHERE vote_id = '$id'";
$sql4="UPDATE ".$table_prefix."topics SET topic_vote = '0' WHERE topic_id ='$t_id' ";
$result = $db->sql_query($sql1);
$result = $db->sql_query($sql2);
$result = $db->sql_query($sql3);
$result = $db->sql_query($sql4);
$message = $lang['admin_poll_deleted'] . "<br /><br />" . sprintf($lang['Click_return_admin_pool'], "<a href=\"" . append_sid("admin_mx_poll.php") . "\">", "</a>") . "<br /><br />" . sprintf($lang['Click_return_admin_index'], "<a href=\"" . append_sid("index.$phpEx?pane=right") . "\">", "</a>");
message_die(GENERAL_MESSAGE, $message);
}
else
{
// Read the poll's
$sql="SELECT * FROM " . VOTE_DESC_TABLE . " AS v, " . TOPICS_TABLE . " AS t WHERE v.topic_id = t.topic_id ORDER BY vote_id DESC";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, 'Could not obtain poll definition', '', __LINE__, __FILE__, $sql);
}
$nb_poll = mysql_num_rows($result);
if ( $nb_poll != '0' )
{
while( $row = $db->sql_fetchrow($result) )
{
$date = create_date($board_config['default_dateformat'], $row[vote_start], $board_config['board_timezone']);
$template->assign_block_vars("pollrow",array(
"ID" => $row[vote_id],
"TITLE_TOPIC" => $row[topic_title],
"TITLE_POLL" => $row[vote_text],
"U_VIEW_TOPIC" => append_sid( $phpbb_root_path . "viewtopic.php?t=" . $row[topic_id]),
"T_ID" => $row[topic_id],
"POLL_DATE" => $date
));
}
}
else
{
$template->assign_block_vars("empty",array());
}
}
// include('./page_header_admin.'.$phpEx);
$template->pparse('admin_poll');
}
include('./page_footer_admin.'.$phpEx);
?>
