phpBB España Oficial

Código: Seleccionar todo

//
// Generate the page
//
$template->pparse('body');

include($phpbb_root_path . 'includes/page_tail.'.$phpEx);

Código: Seleccionar todo

//
// Encuesta en el Indice de los Foros
//
$fetchpoll = phpbb_fetch_poll($CFG['poll_forum']);

if (!empty($fetchpoll))
{
	$template->assign_vars(array(		
		'S_POLL_QUESTION' => $fetchpoll['vote_text'],
		'S_POLL_ACTION' => append_sid('posting.'.$phpEx.'?'.POST_TOPIC_URL.'='.$fetchpoll['topic_id']),
		'S_TOPIC_ID' => $fetchpoll['topic_id'],
		'L_SUBMIT_VOTE' => $lang['Submit_vote'],
		'L_LOGIN_TO_VOTE' => $lang['Login_to_vote']		
		)
	);

	for ($i = 0; $i < count($fetchpoll['options']); $i++)
	{
		$template->assign_block_vars('poll_option_row', array(
			'OPTION_ID' => $fetchpoll['options'][$i]['vote_option_id'],
			'OPTION_TEXT' => $fetchpoll['options'][$i]['vote_option_text'],
			'VOTE_RESULT' => $fetchpoll['options'][$i]['vote_result'],
			)
		);
	}	
}
else
{
	$template->assign_vars(array(		
		'S_POLL_QUESTION' => $lang['No_poll'],
		'DISABLED' => 'disabled="disabled"'
		)
	);
}

Código: Seleccionar todo

<tr>
	<td align="left" valign="top"><span class="gensmall">{L_ONLINE_EXPLAIN}</span></td>
</tr>

Código: Seleccionar todo

<form method="post" action="{S_POLL_ACTION}">
	  <table width="100%" cellpadding="2" cellspacing="1" border="0" class="forumline">
	   <tr>
		<td class="catHead" height="25"><span class="genmed"><b>{L_POLL}</b></span></td>
	   </tr>
	   <tr>
		<td class="row1" align="left">
			<div align="center" class="gensmall"><b>{S_POLL_QUESTION}</b></div><br />
			<!-- BEGIN poll_option_row -->
			<input type="radio" name="vote_id" value="{poll_option_row.OPTION_ID}" /><span class="gensmall">{poll_option_row.OPTION_TEXT}&nbsp;[{poll_option_row.VOTE_RESULT}]</span><br />
			<!-- END poll_option_row -->
			<br />
			<!-- BEGIN switch_user_logged_out -->
			<div align="center">{L_LOGIN_TO_VOTE}</div>
			<!-- END switch_user_logged_out -->
			<!-- BEGIN switch_user_logged_in -->
			<div align="center" class="gensmall"><input type="submit" class="mainoption" name="submit" value="{L_VOTE_BUTTON}" {DISABLED} /></div>
			<input type="hidden" name="topic_id" value="{S_TOPIC_ID}" />
			<input type="hidden" name="mode" value="vote" />
			<!-- END switch_user_logged_in -->
			<br />
		</td>
	   </tr>
	  </table>
	  </form>

Código: Seleccionar todo

?>

Código: Seleccionar todo

$lang['Poll'] = 'Encuesta';
$lang['Login_to_vote'] = 'Debe identificarse para Votar';
$lang['Vote'] = 'Votar';
$lang['No_poll'] = 'No hay Encuesta en este momento';

Código: Seleccionar todo

Fatal error: Call to undefined function: phpbb_fetch_poll() in d:\easyphp1-8\www\phpbb2\index.php on line 481

Código: Seleccionar todo

$fetchpoll = phpbb_fetch_poll($CFG['poll_forum']);

Código: Seleccionar todo

?>

Código: Seleccionar todo

function phpbb_fetch_poll($forum_sql)
{
	global $db;

	$sql = 'SELECT
			  t.*,
			  vd.*
			FROM
			  ' . TOPICS_TABLE	 . ' AS t,
			  ' . VOTE_DESC_TABLE  . ' AS vd
			WHERE
			  t.forum_id IN (' . $forum_sql . ') AND
			  t.topic_status <> 1 AND
			  t.topic_status <> 2 AND
			  t.topic_vote = 1 AND
			  t.topic_id = vd.topic_id
			ORDER BY
			  t.topic_time DESC
			LIMIT
			  0,1';

	if (!$query = $db->sql_query($sql))
	{
		message_die(GENERAL_ERROR, 'Could not query poll information', '', __LINE__, __FILE__, $sql);
	}

	$result = $db->sql_fetchrow($query);

	if ($result)
	{
		$sql = 'SELECT
				  *
				FROM
				  ' . VOTE_RESULTS_TABLE . '
				WHERE
				  vote_id = ' . $result['vote_id'] . '
				ORDER BY
				  vote_option_id';

		if (!$query = $db->sql_query($sql))
		{
			message_die(GENERAL_ERROR, 'Could not query vote result information', '', __LINE__, __FILE__, $sql);
		}

		while ($row = $db->sql_fetchrow($query))
		{
			$result['options'][] = $row;
		}		
	}

	return $result;
} // end func phpbb_fetch_poll

Código: Seleccionar todo

define('IN_PHPBB', true);

Código: Seleccionar todo

// ID de los foros de los que se obtendrán las encuestas: Separa por comas si eliges varios foros. Ejemplo: '3'
$CFG['poll_forum'] = '7';

Código: Seleccionar todo

		'L_LOGIN_TO_VOTE' => $lang['Login_to_vote']		
		)

Código: Seleccionar todo

		'L_POLL' => $lang['Poll'],
		'L_VOTE_BUTTON' => $lang['Submit_vote'],

Código: Seleccionar todo

Fatal error: Call to a member function sql_query() on a non-object in /home/posimob/public_html/porty/includes/functions.php on line 964