OXPUS.de

Code: Alles auswählen

Could not fetch group_ids for user

DEBUG MODE

SQL Error : 1064 You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND g.group_id NOT IN (103) AND g.group_single_user <> 1

SELECT ug.user_id FROM phpbb_groups g, phpbb_user_group ug WHERE g.group_id = ug.group_id AND ug.user_id <> AND g.group_id NOT IN (103) AND g.group_single_user <> 1 AND ug.user_pending <> 1

Line : 436
File : functions_downloads.php

Code: Alles auswählen

$sql = "SELECT d.*, c.*, c.bbcode_uid as bbuid FROM " . DOWNLOADS_TABLE . " d, " . DL_CATS_TABLE . " c

Code: Alles auswählen

Allgemeiner Fehler

Could not query recent downloads

DEBUG MODE

SQL Error : 1054 Unknown column 'c.cat' in 'where clause'

SELECT d.*, c.*, c.bbcode_uid as bbuid FROM phpbb_downloads d, phpbb_downloads_cat c WHERE c.id = d.cat AND c.cat IN (1,4,3,2,5,6) ORDER BY change_time DESC LIMIT 0, 5

Line : 434
File : portal.php

Code: Alles auswählen

// Recent Downloads
if ($board_config['recent_downloads'] > 0)
{
	include_once($phpbb_root_path . 'includes/bbcode.'.$phpEx);
	include_once($phpbb_root_path . 'includes/functions_post.'.$phpEx);
	include_once($phpbb_root_path . 'includes/functions_downloads.'.$phpEx);

	$access_cat = create_dl_overview_index(0, 0, 1);
	$sql_access_cats = (count($access_cat) == 0 || $userdata['user_level'] == ADMIN) ? ' WHERE c.id = d.cat ' : ' WHERE c.id = d.cat  AND c.id IN ('.implode(',', $access_cat).')';
	
	$sql = "SELECT d.*, c.*, c.bbcode_uid as bbuid FROM " . DOWNLOADS_TABLE . " d, " . DL_CAT_TABLE . " c
		$sql_access_cats
		ORDER BY change_time DESC
		LIMIT 0, " . $board_config['recent_downloads'];
	if (!$result = $db->sql_query($sql))
	{
		message_die(GENERAL_ERROR, 'Could not query recent downloads', '', __LINE__, __FILE__, $sql);
	}

	while ($row = $db->sql_fetchrow($result))
	{
		if ($row['new_edit'] == 1 && ((time() - $row['change_time'])) / 86400 <= $board_config['dl_new_time'] && $board_config['dl_new_time'] > 0)
		{
			$mini_img = '<img src="'.$images['icon_minipost_new'].'" border="0" />&nbsp;';
		}
		else if ($row['new_edit'] == 0 && ((time() - $row['change_time']) / 86400) <= $board_config['dl_edit_time'] && $board_config['dl_edit_time'] > 0)
		{
			$mini_img = '<img src="'.$images['icon_minipost'].'" border="0" />&nbsp;';
		}
		else
		{
			$mini_img = '';
		}

		$description = $row['file_name'];
		$cat_name = $row['cat_name'];

		if ($row['bbcode_uid'] != '')
		{
			$description = smilies_pass(bbencode_second_pass(stripslashes($description), $row['bbcode_uid']));
			$description = make_clickable($description);
			$description = str_replace("\n", "\n<br />\n", $description);
		}

		if ($row['bbuid'] != '')
		{
			$cat_name = ( $board_config['allow_html'] ) ? make_clickable($cat_name) : preg_replace('#(<)([\/]?.*?)(>)#is', "<\\2>", $cat_name);
			$cat_name = ( $board_config['allow_bbcode'] ) ? bbencode_second_pass($cat_name, $row[bbuid]) : preg_replace('/\:[0-9a-z\:]+\]/si', ']', $cat_name);
			$cat_name = ( $board_config['allow_smilies'] ) ? smilies_pass($cat_name) : $cat_name;
		}

		$description = '<span class="gensmall">'.$mini_img.'<a href="'.append_sid("dl_details.$phpEx?view=detail&id=".$row['id']."&cat=".$row['cat']).'" class="gensmall"><b>'.$description.'</b></a></span>';
		$cat_name = '<span class="gensmall">[ <a href="'.append_sid("downloads.$phpEx?cat=".$row['cat']).'" class="gensmall">'. $cat_name.'</a> ]</span>';

		$template->assign_block_vars('recent_dl_row', array(
			'DL_NAME' => $description.'<br />'.$cat_name)
		);
	}
	$total_dl = $db->sql_numrows($result);
	$db->sql_freeresult($result);

	if ($total_dl > 0)
	{
		$template->assign_block_vars('recent_dl_block', array(
			'DL_RECENT_FILES' => $lang['Recent_downloads'])
		);
	}
}
// END Recent Downloads

Code: Alles auswählen

$sql = "SELECT d.*, c.*, c.bbcode_uid as bbuid FROM " . DOWNLOADS_TABLE . " d, " . DL_CAT_TABLE . " c 

Code: Alles auswählen

$sql = "SELECT d.*, d.description as file_desc, c.*, c.bbcode_uid as bbuid FROM " . DOWNLOADS_TABLE . " d, " . DL_CAT_TABLE . " c 

Code: Alles auswählen

$description = $row['file_name'];

Code: Alles auswählen

$description = $row['file_desc'];

Code: Alles auswählen

#
# ----- [ OPEN ] -----
#
Download_Mod_Full_Pack.txt

#
# ----- [ FIND admin/index.php AND viewonline.php]-----
#
$location = $lang['downloads'];

#
# ----- [ REPLACE 3 TIMES, WITH ] -----
#
$location = $lang['Downloads'];

Code: Alles auswählen

	$sql = "SELECT d.*, d.description as file_desc, c.*, c.bbcode_uid as bbuid FROM " . DOWNLOADS_TABLE . " d, " . DL_CAT_TABLE . " c

Code: Alles auswählen

	$sql = "SELECT d.*, d.id as file_id, d.description as file_desc, c.*, c.bbcode_uid as bbuid FROM " . DOWNLOADS_TABLE . " d, " . DL_CAT_TABLE . " c

Code: Alles auswählen

		$description = '<span class="gensmall">'.$mini_img.'<a href="'.append_sid("dl_details.$phpEx?view=detail&id=".$row['id']."&cat=".$row['cat']).'" class="gensmall"><b>'.$description.'</b></a></span>';

Code: Alles auswählen

		$description = '<span class="gensmall">'.$mini_img.'<a href="'.append_sid("dl_details.$phpEx?view=detail&id=".$row['file_id']."&cat=".$row['cat']).'" class="gensmall"><b>'.$description.'</b></a></span>';

Code: Alles auswählen

Information

Zugriff verweigert!

Du hast keine Rechte, dieses zu tun!