Hij deed het goed, totdat de trekking is geweest. sindsdien krijg ik deze error:
Code: Selecteer alles
Error getting information from users table!
DEBUG MODE
SQL Error : 1054 Unknown column 'user_items' in 'field list'
SELECT `username`, `user_items` FROM phpbb2_users WHERE user_id='2'
Line : 174
File : lottery.php Code: Selecteer alles
<?php
/***************************************************************************
* lottery.php
* -------------------
* Version : 2.0.3
* email : zarath@knightsofchaos.com
* forums : http://www.ffsource.net/forums/
*
***************************************************************************/
/***************************************************************************
*
* copyright (C) 2004 Zarath
*
* 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.
*
* This program is distributed in the hope that it will be useful,
* but WITHOUT ANY WARRANTY; without even the implied warranty of
* MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
* GNU General Public License for more details.
*
* http://www.gnu.org/copyleft/gpl.html
*
***************************************************************************/
define('IN_PHPBB', true);
$phpbb_root_path = './';
include($phpbb_root_path . 'extension.inc');
include($phpbb_root_path . 'common.' . $phpEx);
//
// Start session management
//
$userdata = session_pagestart($user_ip, PAGE_INDEX);
init_userprefs($userdata);
//
// End session management
//
#
# Begin page functions
#
function duration($seconds)
{
global $lang;
switch($seconds)
{
case $seconds > 86399:
{
$days = preg_replace("/\..*/", '', ($seconds / 86400));
$seconds = ($seconds - ($days * 86400));
$string .= ( $days > 1 ) ? $days .' ' . $lang['lottery_days'] . ', ' : $days .' ' . $lang['lottery_day'] . ', ';
}
case $seconds > 3599:
{
$hours = preg_replace("/\..*/", '', ($seconds / 3600));
$seconds = ( $days > 0 ) ? 0 : ($seconds - ($hours * 3600));
if ( $seconds != 0 ) { $string .= ( $hours > 1 ) ? $hours .' ' . $lang['lottery_hours'] . ', ' : $hours .' ' . $lang['lottery_hour'] . ', '; }
else { break; }
}
case $seconds > 59:
{
$minutes = preg_replace("/\..*/", '', ($seconds / 60));
$seconds = ( $hours > 0 ) ? 0 : ($seconds - ($minutes * 60));
if ( $seconds != 0 ) { $string .= ( $minutes > 1) ? $minutes .' ' . $lang['lottery_minutes'] . ', ' : $minutes .' ' . $lang['lottery_minute'] . ', '; }
else { break; }
}
case $seconds > 0:
{
$string .= ( $seconds > 1 ) ? $seconds . ' ' . $lang['lottery_seconds'] . ', ' : $seconds . ' ' . $lang['lottery_second'] . ', ';
}
}
$string = substr($string, 0, -2);
return $string;
}
#
# End page functions
#
# Register action variable!
#
if ( isset($HTTP_GET_VARS['action']) || isset($HTTP_POST_VARS['action']) ) { $action = ( isset($HTTP_POST_VARS['action']) ) ? $HTTP_POST_VARS['action'] : $HTTP_GET_VARS['action']; }
else { $action = ''; }
#
# Finish registering variable
#
if ( !(DEFINED('SHOP_TABLE')) )
{
define('SHOP_ITEM_TABLE', 'phpbb_shopitems');
}
if ( !($board_config['lottery_status']) ) { message_die(GENERAL_MESSAGE, $lang['lottery_disabled']); }
//
// Get user's current entry information
//
$sql = "SELECT *
FROM " . LOTTERY_TABLE . "
WHERE user_id='{$userdata['user_id']}'";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, sprintf($lang['lottery_error_selecting'], 'lottery'), '', __LINE__, __FILE__, $sql);
}
$sql_count = $db->sql_numrows($result);
//
// Check multiple tickets?
//
$tickbuy = ( ($board_config['lottery_ticktype'] == "single") && ($sql_count > 0) ) ? 0 : 1;
//check if lottery should be drawn
$timeleft = ( $board_config['lottery_start'] + $board_config['lottery_length'] ) - time();
$thetime = time();
if ($timeleft < 1)
{
$sql = "SELECT *
FROM " . LOTTERY_TABLE;
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, sprintf($lang['lottery_error_selecting'], 'lottery'), '', __LINE__, __FILE__, $sql);
}
$sql_count = $db->sql_numrows($result);
if ($sql_count > 0)
{
//
// Calculate current prizepool
//
$pool = ($sql_count * $board_config['lottery_cost']) + $board_config['lottery_base'];
//
// Select winner
//
list($usec, $sec) = explode(' ', microtime());
$seed = (float) $sec + ((float) $usec * 100000);
srand($seed);
$randnum = rand(1, $sql_count);
$randnum--;
for ($i = 0; $i < $sql_count; $i++)
{
if (!( $row = $db->sql_fetchrow($result) ))
{
message_die(GENERAL_ERROR, sprintf($lang['lottery_error_selecting'], 'lottery'), '', __LINE__, __FILE__, $sql);
}
if ($i == $randnum)
{
break;
}
}
//
// Get winner's name and current items (incase items need to be added!)
//
$sql = "SELECT `username`, `user_items`
FROM " . USERS_TABLE . "
WHERE user_id='{$row['user_id']}'";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, sprintf($lang['lottery_error_selecting'], 'users'), '', __LINE__, __FILE__, $sql);
}
if (!( $row2 = $db->sql_fetchrow($result) ))
{
message_die(GENERAL_ERROR, sprintf($lang['lottery_error_selecting'], 'lottery'), '', __LINE__, __FILE__, $sql);
}
$winnername = addslashes($row2['username']);
#
# Explode items array, loop over items array to make sure all item exist
# Replace all RANDOM (lowercase) items with items from price to price [in store]
#
$item_array = explode(';', $board_config['lottery_win_items']);
$add_items = array();
for ($i = 0; $i < count($item_array); $i++)
{
$item_array[$i] = trim($item_array[$i]);
if ( strtolower($item_array[$i]) == 'random' )
{
$shop_sql = ( !empty($board_config['lottery_random_shop']) ) ? "AND shop = '" . addslashes($board_config['lottery_random_shop']) . "'" : '';
$sql = "SELECT name
FROM " . SHOP_ITEM_TABLE . "
WHERE cost > '" . $board_config['lottery_item_mcost'] . "'
AND cost < '" . $board_config['lottery_item_xcost'] . "'
" . $shop_sql . "
ORDER BY RAND()
LIMIT 0, 1";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, sprintf($lang['lottery_error_selecting'], 'shop items'), '', __LINE__, __FILE__, $sql);
}
$sql_count = $db->sql_numrows($result);
if ( $sql_count > 0 )
{
if (!( $item_row = $db->sql_fetchrow($result) ))
{
message_die(GENERAL_ERROR, sprintf($lang['lottery_error_selecting'], 'shop items'), '', __LINE__, __FILE__, $sql);
}
$add_items[] = $item_row['name'];
}
}
elseif ( !empty($item_array[$i]) )
{
$sql = "SELECT *
FROM " . SHOP_ITEM_TABLE . "
WHERE name = '" . addslashes($item_array[$i]) . "'";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, sprintf($lang['lottery_error_selecting'], 'shop items'), '', __LINE__, __FILE__, $sql);
}
$sql_count = $db->sql_numrows($result);
if ( $sql_count > 0 )
{
$add_items[] = $item_array[$i];
}
}
}
if ( count($add_items) > 0 )
{
$new_items = addslashes($row2['user_items'] . 'ß' . implode('Þß', $add_items) . 'Þ');
#
# Add up new total & insert into database
#
$sql = "UPDATE " . USERS_TABLE . "
SET user_items = '$new_items'
WHERE user_id='{$row['user_id']}'";
if ( !($db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, sprintf($lang['lottery_error_updating'], 'users'), '', __LINE__, __FILE__, $sql);
}
}
#
# Support for the cash mod, check for other currency set -- if none or failed, use user_points
#
if ( DEFINED('CASH_TABLE') )
{
$cash_sql_where = ( !empty($board_config['lottery_currency']) ) ? "WHERE cash_name = '{$board_config['lottery_currency']}'" : '';
$sql = "SELECT `cash_dbfield`, `cash_name`
FROM " . CASH_TABLE . "
" . $cash_sql_where;
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, sprintf($lang['lottery_error_selecting'], 'cash'), '', __LINE__, __FILE__, $sql);
}
if ( $db->sql_numrows($result) )
{
if (!( $cash_row = $db->sql_fetchrow($result) ))
{
message_die(GENERAL_ERROR, sprintf($lang['lottery_error_selecting'], 'cash'), '', __LINE__, __FILE__, $sql);
}
$currency_db = $cash_row['cash_dbfield'];
$currency_name = $cash_row['cash_name'];
}
}
else
{
$currency_db = 'user_points';
$currency_name = $board_config['points_name'];
}
#
# Add up new total & insert into database
#
$sql = "UPDATE " . USERS_TABLE . "
SET " . $currency_db . " = " . $currency_db . " + $pool
WHERE user_id='{$row['user_id']}'";
if ( !($db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, sprintf($lang['lottery_error_updating'], 'users'), '', __LINE__, __FILE__, $sql);
}
$sql = "INSERT INTO " . LOTTERY_HISTORY_TABLE . "
(user_id, amount, currency, time)
VALUES ('{$row['user_id']}', '$pool', '$currency_name', '$thetime')";
if ( !($db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, sprintf($lang['lottery_error_inserting'], 'lottery history'), '', __LINE__, __FILE__, $sql);
}
}
//
// Begin reset of lottery
//
$sql = "DELETE FROM " . LOTTERY_TABLE;
if ( !($db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, sprintf($lang['lottery_error_deleting'], 'lottery'), '', __LINE__, __FILE__, $sql);
}
if ($board_config['lottery_reset'])
{
$sql = "UPDATE " . CONFIG_TABLE . "
SET config_value='$thetime'
WHERE config_name='lottery_start'";
if ( !($db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, sprintf($lang['lottery_error_updating'], 'config'), '', __LINE__, __FILE__, $sql);
}
}
else
{
$sql = "UPDATE " . CONFIG_TABLE . "
SET config_value='off'
WHERE config_name='lottery_status'";
if ( !($db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, sprintf($lang['lottery_error_updating'], 'config'), '', __LINE__, __FILE__, $sql);
}
$sql = "UPDATE " . CONFIG_TABLE . "
SET config_value='0'
WHERE config_name='lottery_start'";
if ( !($db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, sprintf($lang['lottery_error_updating'], 'config'), '', __LINE__, __FILE__, $sql);
}
}
header("Location: lottery.php");
exit;
}
//end lottery draw check
//default lottery page
if ( empty($action) )
{
$template->set_filenames(array(
'body' => 'lottery_index_body.tpl')
);
$duration = duration($timeleft);
$title = $board_config['lottery_name'] . $lang['lottery_information'];
#
# Begin action checking and toggling!
#
if ( ($tickbuy) || ($board_config['lottery_history']) )
{
if ( $tickbuy )
{
#
# Begin switch to allow user to buy a ticket!
#
if ( $board_config['lottery_mb'] )
{
$template->assign_block_vars('switch_tickets_multi', array());
}
else
{
$template->assign_block_vars('switch_tickets_single', array());
}
}
if ( $board_config['lottery_history'] )
{
$template->assign_block_vars('switch_view_history', array());
$sql = "SELECT *
FROM " . LOTTERY_HISTORY_TABLE . "
WHERE user_id = '{$userdata['user_id']}'";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, sprintf($lang['lottery_error_selecting'], 'lottery'), '', __LINE__, __FILE__, $sql);
}
if ( $db->sql_numrows($result) > 0 )
{
$template->assign_block_vars('switch_view_personal', array());
}
}
$template->assign_block_vars('switch_are_actions', array());
}
#
# Begin switch to allow full display (full pot & current entries)!
#
if ( $board_config['lottery_show_entries'] )
{
$template->assign_block_vars('switch_full_display', array());
$sql = "SELECT *
FROM " . LOTTERY_TABLE;
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, sprintf($lang['lottery_error_selecting'], 'lottery'), '', __LINE__, __FILE__, $sql);
}
$total_entries = $db->sql_numrows($result);
$total_pool = ($board_config['lottery_cost'] * $total_entries) + $board_config['lottery_base'];
}
#
# Begin currency checking (name)
#
if ( DEFINED('CASH_TABLE') )
{
$currency_name = $board_config['lottery_currency'];
}
else
{
$currency_name = $board_config['points_name'];
}
#
# Begin checks, switch and rearrangements of items in lottery
#
if ( ($board_config['lottery_items']) && (strlen($board_config['lottery_win_items']) > 3) )
{
$lottery_items = str_replace(';', ', ', $board_config['lottery_win_items']);
$template->assign_block_vars('switch_items', array());
}
#
# Grab last winner from lottery -- ORDERED BY TIME
#
$sql = "SELECT t1.*, t2.username
FROM " . LOTTERY_HISTORY_TABLE . " as t1, " . USERS_TABLE . " as t2
WHERE t2.user_id = t1.user_id
ORDER BY time DESC";
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, sprintf($lang['lottery_error_selecting'], 'lottery history'), '', __LINE__, __FILE__, $sql);
}
if ( $db->sql_numrows($result) > 0 )
{
if (!( $row = $db->sql_fetchrow($result) ))
{
message_die(GENERAL_ERROR, sprintf($lang['lottery_error_selecting'], 'lottery'), '', __LINE__, __FILE__, $sql);
}
$template->assign_block_vars('switch_last_winner', array(
'WINNER_NAME' => $row['username']));
}
$page_title = $board_config['lottery_name'];
$template->assign_vars(array(
'TICKETS_OWNED' => $sql_count,
'L_PRIZE_BASE' => $board_config['lottery_base'],
'L_TICKET_COST' => $board_config['lottery_cost'],
'L_TOTAL_PRIZE' => $total_pool,
'L_CURRENT_ENTRIES' => $total_entries,
'L_ITEM_PRIZE' => $lottery_items,
'S_CONFIG_ACTION' => append_sid('lottery.'.$phpEx),
'L_CURRENCY' => $currency_name,
'L_DURATION' => $duration,
'L_NAME' => $board_config['lottery_name'],
'L_INFO_TITLE' => $board_config['lottery_name'] . ' ' . $lang['lottery_information'],
'L_ACTIONS_TITLE' => $lang['lottery_actions'],
'L_TICKET_OWNED' => $lang['lottery_tickets_owned'],
'L_TICKETS_COST' => $lang['lottery_ticket_cost'],
'L_BASE_POOL' => $lang['lottery_base_pool'],
'L_CURRENT_POOL' => $lang['lottery_current_entries'],
'L_TOTAL_POOL' => $lang['lottery_total_pool'],
'L_ITEM_DRAW' => $lang['lottery_item_draw'],
'L_TIME_DRAW' => $lang['lottery_time_draw'],
'L_LAST_WINNER' => $lang['lottery_last_winner'],
'I_BUY_TICKET' => $lang['lottery_buy_ticket'],
'I_BUY_TICKETS' => $lang['lottery_buy_tickets'],
'I_VIEW_HISTORY' => $lang['lottery_view_history'],
'I_VIEW_PHISTORY' => $lang['lottery_view_phistory']
));
$template->assign_block_vars('', array());
}
elseif ($action == 'options')
{
if ( !$userdata['session_logged_in'] )
{
$redirect = "lottery.$phpEx&action=options";
header('Location: ' . append_sid("login.$phpEx?redirect=$redirect", true));
exit;
}
#
# Register the globals for both actions [allows checks]
#
if ( isset($HTTP_GET_VARS['amount']) || isset($HTTP_POST_VARS['amount']) ) { $amount = ( isset($HTTP_POST_VARS['amount']) ) ? intval($HTTP_POST_VARS['amount']) : intval($HTTP_GET_VARS['amount']); }
else { $amount = ''; }
if ( isset($HTTP_GET_VARS['view_history']) || isset($HTTP_POST_VARS['view_history']) ) { $view_history = ( isset($HTTP_POST_VARS['view_history']) ) ? htmlspecialchars($HTTP_POST_VARS['view_history']) : htmlspecialchars($HTTP_GET_VARS['view_history']); }
else { $view_history = ''; }
if ( isset($HTTP_GET_VARS['view_personal']) || isset($HTTP_POST_VARS['view_personal']) ) { $view_personal = ( isset($HTTP_POST_VARS['view_personal']) ) ? htmlspecialchars($HTTP_POST_VARS['view_personal']) : htmlspecialchars($HTTP_GET_VARS['view_personal']); }
else { $view_personal = ''; }
if ( isset($HTTP_GET_VARS['start']) || isset($HTTP_POST_VARS['start']) ) { $start = ( isset($HTTP_POST_VARS['start']) ) ? intval($HTTP_POST_VARS['start']) : intval($HTTP_GET_VARS['start']); }
else { $start = 0; }
if ( isset($HTTP_GET_VARS['buy_ticket']) || isset($HTTP_POST_VARS['buy_ticket']) ) { $buy_ticket = ( isset($HTTP_POST_VARS['buy_ticket']) ) ? $HTTP_POST_VARS['buy_ticket'] : $HTTP_GET_VARS['buy_ticket']; }
else { $buy_ticket = ''; }
if ( isset($HTTP_GET_VARS['buy_tickets']) || isset($HTTP_POST_VARS['buy_tickets']) ) { $buy_tickets = ( isset($HTTP_POST_VARS['buy_tickets']) ) ? $HTTP_POST_VARS['buy_tickets'] : $HTTP_GET_VARS['buy_tickets']; }
else { $buy_tickets = ''; }
if ( !empty($buy_ticket) || !empty($buy_tickets) )
{
#
# Make sure they can buy a ticket & have enough gil!
#
if ( !($tickbuy) )
{
message_die(GENERAL_MESSAGE, $lang['lottery_too_many_tickets']);
}
$amount = ( ($amount < 1) || ($amount > 9999) ) ? 1 : $amount;
$ticket_cost = $board_config['lottery_cost'] * $amount;
#
# Make sure if buying MULTIPLE tickets, they are allowed to -- and it doesn't exceed the max
#
if ( $board_config['lottery_ticktype'] != 'multi' || !($board_config['lottery_mb']) )
{
$amount = 1;
}
else
{
if ($amount > $board_config['lottery_mb_amount']) { $amount = $board_config['lottery_mb_amount']; }
}
#
# Begin checks on multiple currencies, if they exist!
#
if ( DEFINED('CASH_TABLE') )
{
$cash_sql_where = ( !empty($board_config['lottery_currency']) ) ? "WHERE cash_name = '{$board_config['lottery_currency']}'" : '';
$sql = "SELECT `cash_dbfield`
FROM " . CASH_TABLE . "
" . $cash_sql_where;
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, sprintf($lang['lottery_error_selecting'], 'cash'), '', __LINE__, __FILE__, $sql);
}
if ( $db->sql_numrows($result) )
{
if (!( $row = $db->sql_fetchrow($result) ))
{
message_die(GENERAL_ERROR, sprintf($lang['lottery_error_selecting'], 'cash'), '', __LINE__, __FILE__, $sql);
}
if ( ($userdata[$row['cash_dbfield']] - $ticket_cost) < 0 )
{
$msg = ( $amount == '1' ) ? $lang['lottery_purchased_ticket'] : sprintf($lang['lottery_purchased_tickets'], $amount);
message_die(GENERAL_MESSAGE, $lang['lottery_purchased_ne'] . $row['cash_name'] . $msg);
}
$sql = "UPDATE " . USERS_TABLE . "
SET " . $row['cash_dbfield'] . " = " . $row['cash_dbfield'] . " - $ticket_cost
WHERE user_id='{$userdata['user_id']}'";
if ( !($db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, sprintf($lang['lottery_error_updating'], 'users'), '', __LINE__, __FILE__, $sql);
}
$cash_done = 1;
}
}
if ( !($cash_done) )
{
if ( ($userdata['user_points'] - $ticket_cost) < 0 )
{
$msg = ( $amount == '1' ) ? $lang['lottery_purchased_ticket'] : sprintf($lang['lottery_purchased_tickets'], $amount);
message_die(GENERAL_MESSAGE, $lang['lottery_purchased_ne'] . $board_config['points_name'] . $msg);
}
$sql = "UPDATE " . USERS_TABLE . "
SET user_points = user_points - $ticket_cost
WHERE user_id='{$userdata['user_id']}'";
if ( !($db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, sprintf($lang['lottery_error_updating'], 'users'), '', __LINE__, __FILE__, $sql);
}
}
$sql = "INSERT INTO " . LOTTERY_TABLE . "
(user_id)
VALUES ('{$userdata['user_id']}')";
for ($i = 0; $i < $amount; $i++)
{
if ( !($db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, sprintf($lang['lottery_error_inserting'], 'lottery'), '', __LINE__, __FILE__, $sql);
}
}
$msg = ( $amount < 2 ) ? sprintf($lang['lottery_ticket_bought'], $board_config['lottery_name']) : sprintf($lang['lottery_tickets_bought'], $amount, $board_config['lottery_name']);
message_die(GENERAL_MESSAGE, $msg);
}
elseif ( !empty($view_history) || ( !empty($view_personal) ) )
{
#
# History Layers, these will be fairly basic, just a straight check of SQL and output to a template.
# Two choices, self history (will probably be empty most of them...) and full history. Not sure how
# I'm going to implement the second, at the moment it's just view all history. :P
#
#
# Finish registering variables!
#
$template->set_filenames(array(
'body' => 'lottery_history_body.tpl')
);
#
# Make sure the lottery history is enabled! [or at least viewable]
#
if ( !($board_config['lottery_history']) ) { message_die(GENERAL_MESSAGE, $lang['lottery_history_disabled']); }
if ( !empty($view_personal) )
{
$sql = "SELECT t1.*, t2.username
FROM " . LOTTERY_HISTORY_TABLE . " as t1, " . USERS_TABLE . " as t2
WHERE t1.user_id = '{$userdata['user_id']}'
AND t2.user_id = t1.user_id
ORDER BY time DESC
LIMIT $start, {$board_config['topics_per_page']}";
# Pagination SQL Query...
$page_sql = "SELECT count(*) AS total
FROM " . LOTTERY_HISTORY_TABLE . "
WHERE user_id='{$userdata['user_id']}'";
}
elseif ( !empty($view_history) )
{
$sql = "SELECT t1.*, t2.username
FROM " . LOTTERY_HISTORY_TABLE . " as t1, " . USERS_TABLE . " as t2
WHERE t2.user_id = t1.user_id
ORDER BY time DESC
LIMIT $start, {$board_config['topics_per_page']}";
# Pagination SQL Query...
$page_sql = "SELECT count(*) AS total
FROM " . LOTTERY_HISTORY_TABLE;
}
else { message_die(GENERAL_MESSAGE, $lang['lottery_no_history_type']); }
if ( !($result = $db->sql_query($sql)) )
{
message_die(GENERAL_ERROR, sprintf($lang['lottery_error_selecting'], 'lottery history'), '', __LINE__, __FILE__, $sql);
}
$sql_count = $db->sql_numrows($result);
if ( $sql_count < 1 )
{
#
# Code to toggle no history!
#
$template->assign_block_vars('switch_no_history', array(
'MESSAGE' => $lang['lottery_no_history']));
}
else
{
#
# Begin of loops over history to directly output it on the history page! :)
#
for ($i = 0; $i < $sql_count; $i++)
{
if (!( $row = $db->sql_fetchrow($result) ))
{
message_die(GENERAL_ERROR, sprintf($lang['lottery_error_selecting'], 'lottery history'), '', __LINE__, __FILE__, $sql);
}
$rownum = ( $i % 2 ) ? 'row1' : 'row2';
$template->assign_block_vars('listrow', array(
'ROW_CLASS' => $rownum,
'HISTORY_NUM' => $i + 1 + $start,
'HISTORY_WINNER' => $row['username'],
'HISTORY_AMOUNT' => $row['amount'],
'HISTORY_CURRENCY' => $row['currency'],
'HISTORY_TIME' => create_date($board_config['default_dateformat'], $row['time'], $board_config['board_timezone']))
);
}
$template->assign_block_vars('switch_title_info', array());
}
#
# Begin pagination based on topics per page... I REALLY hate pagination, but it's the only way to stop
# Massive build ups on a single page.
#
if ( !($result = $db->sql_query($page_sql)) )
{
message_die(GENERAL_ERROR, sprintf($lang['lottery_error_selecting'], 'lottery history'), '', __LINE__, __FILE__, $sql);
}
$sql_count = $db->sql_numrows($result);
if ( ($total = $db->sql_fetchrow($result)) && ($sql_count > 0) )
{
$total_history = $total['total'];
if ( $total_history > $board_config['topics_per_page'] )
{
$pagination = generate_pagination("lottery.$phpEx?action=options&view_history=$view_history&view_personal=$view_personal", $total_history, $board_config['topics_per_page'], $start). ' ';
}
else
{
$pagination = ' ';
}
}
#
# Finished pagination, now wrapping up the page and displaying it...
#
$page_title = $board_config['lottery_name'];
$next_location = ' -> <a href="' . append_sid("lottery.$phpEx") . '" class="nav">' . $board_config['lottery_name'] . '</a> -> <a href="' . append_sid("lottery.php") . '" class="nav">' . $board_config['lottery_name'] . ' ' . $lang['lottery_history'] . '</a>';
$template->assign_vars(array(
'L_HISTORY' => $lang['lottery_current_history'],
'L_ID' => $lang['lottery_ID'],
'L_WINNER' => $lang['lottery_winner'],
'L_AMOUNT_WON' => $lang['lottery_amount_won'],
'L_TIME_WON' => $lang['lottery_time_won'],
'L_TOTAL_HISTORY' => sprintf($lang['lottery_total_history'], $total_history),
'LOCATION' => $next_location,
'PAGINATION' => $pagination,
'PAGE_NUMBER' => sprintf($lang['Page_of'], ( floor( $start / $board_config['topics_per_page'] ) + 1 ), ceil( $total_history / $board_config['topics_per_page'] )),
'L_GOTO_PAGE' => $lang['Goto_page']
));
$template->assign_block_vars('', array());
}
else
{
header("Location: lottery.php");
}
}
else
{
message_die(GENERAL_MESSAGE, $lang['lottery_invalid_command']);
}
//
// Start output of page
//
include($phpbb_root_path . 'includes/page_header.' . $phpEx);
//
// Generate the page
//
$template->pparse('body');
include($phpbb_root_path . 'includes/page_tail.' . $phpEx);
?>