phpBB.nl

Code: Selecteer alles

# 
#-----[ OPEN ]------------------------------------------ 
# 

includes/constants.php

# 
#-----[ FIND ]------------------------------------------ 
#

define('PAGE_GROUPCP', -11);

# 
#-----[ AFTER, ADD ]------------------------------------------ 
#

define('PAGE_LINKS', -14);

# 
#-----[ FIND ]------------------------------------------ 
# 

define('VOTE_USERS_TABLE', $table_prefix.'vote_voters');

# 
#-----[ AFTER, ADD ]------------------------------------------ 
#

define('LINKS_TABLE', $table_prefix.'links');
define('LINK_CATEGORIES_TABLE', $table_prefix.'link_categories');
define('LINK_CONFIG_TABLE', $table_prefix.'link_config');

# 
#-----[ OPEN ]------------------------------------------ 
#

language/lang_english/lang_admin.php

# 
#-----[ AT THE END, ADD ]------------------------------- 
#

$lang['Links'] ='Links Admin';

# 
#-----[ OPEN ]------------------------------------------ 
#

index.php

# 
#-----[ FIND ]------------------------------------------ 
#

init_userprefs($userdata);

# 
#-----[ AFTER, ADD ]------------------------------------------ 
#

require($phpbb_root_path . 'language/lang_' . $board_config['default_lang'] . '/lang_main_link.' . $phpEx);

# 
#-----[ FIND ]------------------------------------------ 
#

$is_auth_ary = auth(AUTH_VIEW, AUTH_LIST_ALL, $userdata, $forum_data);

# 
#-----[ AFTER, ADD ]------------------------------------------ 
#

$sql = "SELECT *
		FROM ". LINK_CONFIG_TABLE;
	if(!$result = $db->sql_query($sql))
	{
		message_die(GENERAL_ERROR, "Could not query Link config information", "", __LINE__, __FILE__, $sql);
	}
	
	while( $row = $db->sql_fetchrow($result) )
	{
		$link_config_name = $row['config_name'];
		$link_config_value = $row['config_value'];
		$link_config[$link_config_name] = $link_config_value;
		$link_self_img = $link_config['site_logo'];
		$site_logo_height = $link_config['height'];
		$site_logo_width = $link_config['width'];
	}

# 
#-----[ FIND ]------------------------------------------ 
#

'L_ONLINE_EXPLAIN' => $lang['Online_explain'],

# 
#-----[ AFTER, ADD ]------------------------------------------ 
#

		'L_LINKS' => $lang['Site_links'],
		'U_LINKS' => append_sid("links.$phpEx"),
		'U_LINKS_JS' => "links.js.$phpEx",
		'U_SITE_LOGO' => $link_self_img,
		'SITE_LOGO_WIDTH' => $site_logo_width,
		'SITE_LOGO_HEIGHT' => $site_logo_height,

# 
#-----[ OPEN ]------------------------------------------ 
#

templates/subSilver/index_body.tpl

# 
#-----[ FIND ]------------------------------------------ 
#

<!-- BEGIN switch_user_logged_out --> 
<form method="post" action="{S_LOGIN_ACTION}">

# 
#-----[ BEFORE, ADD ]------------------------------------------ 
#

<table width="100%" cellpadding="3" cellspacing="1" border="0" class="forumline">
  <tr> 
	<td class="catLeft" width="100%" height="22"><span class="cattitle"><a href="{U_LINKS}" class="cattitle">{L_LINKS}</a></span></td>
	<td class="catRight" nowrap="nowrap" align="center"><span class="cattitle">{SITENAME}</span></td>
  </tr>
  <tr> 
	<td class="row1" nowrap="nowrap"><iframe marginwidth="0" marginheight="0" src="{U_LINKS_JS}" frameborder="0" scrolling="no" width="100%" height="{SITE_LOGO_HEIGHT}"></iframe></td>
	<td class="row2" nowrap="nowrap"><img src="{U_SITE_LOGO}" alt="{SITENAME}" width="{SITE_LOGO_WIDTH}" height="{SITE_LOGO_HEIGHT}" border="0" /></td>
  </tr>
</table>

# 
#-----[ SAVE/CLOSE ALL FILES ]------------------------------------------ 
# 
# EoM

Code: Selecteer alles

Couldn not query links list.

DEBUG MODE

SQL Error : 1054 Unknown column 'l.user_id' in 'where clause'

SELECT l.*, u.username FROM phpbb_links l, phpbb_users u WHERE l.user_id = u.user_id ORDER BY link_id DESC LIMIT 0, 10

Line : 168
File : admin_links.php

Code: Selecteer alles

Could not query links list

DEBUG MODE

SQL Error : 1054 Unknown column 'link_category' in 'field list'

SELECT link_category FROM phpbb_links WHERE link_active = 1 AND link_category = 1

Line : 674
File : links.php