phpBB.nl

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 phpbb_users WHERE user_id='5'

Line : 174
File : lottery.php

Code: Selecteer alles

Running :: CREATE TABLE `phpbb_lottery` (`id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `user_id` INT (20) NOT NULL, PRIMARY KEY(`id`), INDEX(`user_id`)) -> FAILED ---> Table 'phpbb_lottery' already exists

Running :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('lottery_cost', '1') -> FAILED ---> Duplicate entry 'lottery_cost' for key 1

Running :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('lottery_ticktype', 'single') -> FAILED ---> Duplicate entry 'lottery_ticktype' for key 1

Running :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('lottery_length', '500000') -> FAILED ---> Duplicate entry 'lottery_length' for key 1

Running :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('lottery_name', 'Lottery') -> FAILED ---> Duplicate entry 'lottery_name' for key 1

Running :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('lottery_base', '50') -> FAILED ---> Duplicate entry 'lottery_base' for key 1

Running :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('lottery_start', '0') -> FAILED ---> Duplicate entry 'lottery_start' for key 1

Running :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('lottery_reset', '0') -> FAILED ---> Duplicate entry 'lottery_reset' for key 1

Running :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('lottery_status', '0') -> FAILED ---> Duplicate entry 'lottery_status' for key 1

Running :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('lottery_items', '0') -> FAILED ---> Duplicate entry 'lottery_items' for key 1

Running :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('lottery_win_items', '') -> FAILED ---> Duplicate entry 'lottery_win_items' for key 1

Running :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('lottery_show_entries', '0') -> FAILED ---> Duplicate entry 'lottery_show_entries' for key 1

Running :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('lottery_mb', '0') -> FAILED ---> Duplicate entry 'lottery_mb' for key 1

Running :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('lottery_mb_amount', '1') -> FAILED ---> Duplicate entry 'lottery_mb_amount' for key 1

Running :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('lottery_history', '1') -> FAILED ---> Duplicate entry 'lottery_history' for key 1

Running :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('lottery_currency', '') -> FAILED ---> Duplicate entry 'lottery_currency' for key 1

Running :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('lottery_item_mcost', '1') -> FAILED ---> Duplicate entry 'lottery_item_mcost' for key 1

Running :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('lottery_item_xcost', '500') -> FAILED ---> Duplicate entry 'lottery_item_xcost' for key 1

Running :: INSERT INTO phpbb_config (config_name, config_value) VALUES ('lottery_random_shop', '') -> FAILED ---> Duplicate entry 'lottery_random_shop' for key 1

Running :: CREATE TABLE `phpbb_lottery_history` ( `id` INT UNSIGNED NOT NULL AUTO_INCREMENT, `user_id` INT (20) NOT NULL, `amount` INT (20) NOT NULL, `currency` CHAR (32) NOT NULL, `time` INT (20) NOT NULL, PRIMARY KEY(`id`), INDEX(`user_id`) ) -> FAILED ---> Table 'phpbb_lottery_history' already exists


Finished!
Some of the querys have failed, contact me so I can fix the errors.

Code: Selecteer alles

$sql = "SELECT `username`, `user_items`

Code: Selecteer alles

$sql = "SELECT `username`

Code: Selecteer alles

		#
		# 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);
			}
		}