folgende Fehlermeldung bekomme ich bei der Installation:
Code: Alles auswählen
SQL ERROR INDEX command denied to user 'XYZ'@'localhost' for table 'phpbb_topics'
Gruß
Code: Alles auswählen
SQL ERROR INDEX command denied to user 'XYZ'@'localhost' for table 'phpbb_topics'
finde ich eigenatig, da ich diese "advanced_last_topic_titles.php" ja gar nicht editiert habe, da hab ich ja gar nicht dran rumgespielt.Parse error: syntax error, unexpected T_STATIC, expecting T_OLD_FUNCTION or T_FUNCTION or T_VAR or '}' in /var/www/web705/html/Forum/includes/mods/advanced_last_topic_titles.php on line 27
Code: Alles auswählen
<?php
/**
*
* @package NV Advanced Last Topic Titles
* @version $Id$
* @copyright (c) 2005 phpBB Group
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/
/**
* @ignore
*/
if (!defined('IN_PHPBB'))
{
exit;
}
/**
*
*/
class phpbb_mods_advanced_last_topic_titles
{
/**
* Is the MOD activated in the ACP?
*/
static public $is_active = true;
/**
* Shall we ignore forum passwords and view the topic-title nevertheless?
*/
static public $ignore_password = false;
/**
* Shall we ignore the permissions and view the topic-title nevertheless?
*/
static public $ignore_permissions = false;
/**
* Display topic-title or last-post-title?
*/
static public $use_topic_title = true;
/**
* Link to topic (1), first-unread-post (2) or to the last post (0 || >2)
*/
static public $link_url = 1;
/**
* If the title is longer, we cut it down to this length. (0 means 64 and is the maximum)
*/
static public $length_limit = 64;
/**
* Initialise the MOD and populate the config values to the template.
*/
static public function initialise()
{
global $config;
self::$is_active = (bool) $config['altt_active'];
if (!self::$is_active)
{
return;
}
global $user, $template;
$user->add_lang('mods/info_acp_altt');
self::$ignore_password = (bool) $config['altt_ignore_password'];
self::$ignore_permissions = (bool) $config['altt_ignore_rights'];
self::$use_topic_title = (bool) $config['altt_link_name'];
self::$link_url = (int) $config['altt_link_url'];
self::$length_limit = (($config['altt_char_limit'] <= 0) || ($config['altt_char_limit'] >= 64)) ? 64 : $config['altt_char_limit'];
$template->assign_var('S_ALTT_ACTIVE', self::$is_active);
$style_tags = array();
if ($config['altt_style_bold'])
{
$style_tags[] = "font-weight: bold;";
}
if ($config['altt_style_italic'])
{
$style_tags[] = "font-style: italic;";
}
if ($config['altt_style_adv'])
{
$style_tags[] = $config['altt_style_adv2'];
}
if (!empty($style_tags))
{
$template->assign_var('ALTT_STYLE', implode(' ', $style_tags));
}
}
/**
* Extend the query as we need the topic_title and some more values from the TOPICS_TABLE
*/
static public function inject_sql($sql_array)
{
if (!self::$is_active)
{
return $sql_array;
}
// Is the topics-table already left-joined for some SEO-MOD?
$already_left_joined = false;
foreach ($sql_array['LEFT_JOIN'] as $left_join)
{
if (isset($left_join['FROM'][TOPICS_TABLE]))
{
$already_left_joined = true;
break;
}
}
if (!$already_left_joined)
{
$sql_array['LEFT_JOIN'][] = array(
'FROM' => array(TOPICS_TABLE => 't'),
'ON' => "f.forum_last_post_id = t.topic_last_post_id AND t.topic_moved_id = 0"
);
}
$altt_values = array('t.topic_title', 't.topic_id', 't.topic_last_post_id');
$select_values = explode(', ', $sql_array['SELECT']);
$sql_array['SELECT'] = implode(', ', array_unique(array_merge($select_values, $altt_values)));
return $sql_array;
}
/**
* We need to "cache" the forum_id in a seperated key, so it's not overwritten.
*/
static public function inject_forum_row($row)
{
if (!self::$is_active)
{
return $row;
}
$row['nv_permission_forum_id'] = (int) $row['forum_id'];
return $row;
}
/**
* Put the data we need into the $forum_rows which is used to loop data into the template.
*/
static public function inject_forum_row_values($forum_rows, $parent_id, $row)
{
if (!self::$is_active)
{
return $forum_rows;
}
$forum_rows[$parent_id]['topic_title'] = $row['topic_title'];
$forum_rows[$parent_id]['topic_id'] = $row['topic_id'];
$forum_rows[$parent_id]['nv_permission_forum_id'] = $row['forum_id'];
$forum_rows[$parent_id]['forum_password'] = $row['forum_password'];
return $forum_rows;
}
/**
* Display the data, we edit the last row which was published and add our data to it.
*/
static public function display_information($row)
{
if (!self::$is_active)
{
return false;
}
if ($row['forum_last_post_id'])
{
global $auth;
$password_protected = !(self::$ignore_password || !$row['forum_password']);
$permissions_protected = !(self::$ignore_permissions || $auth->acl_get('f_read', $row['nv_permission_forum_id']));
if (!$password_protected && !$permissions_protected)
{
global $template, $phpbb_root_path, $phpEx;
$altt_link_name = (self::$use_topic_title) ? $row['topic_title'] : $row['forum_last_post_subject'];
$altt_link_name_short = (utf8_strlen(htmlspecialchars_decode($altt_link_name)) > self::$length_limit + 3 )? htmlspecialchars((utf8_substr(htmlspecialchars_decode($altt_link_name), 0, self::$length_limit) . '...')) : ($altt_link_name);
switch (self::$link_url)
{
case 1:
$altt_link_url = append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id_last_post'] . '&t=' . $row['topic_id']);
break;
case 2:
$altt_link_url = append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id_last_post'] . '&t=' . $row['topic_id'] . '&view=unread') . '#unread';
break;
default:
$altt_link_url = append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id_last_post'] . '&p=' . $row['forum_last_post_id']) . '#p' . $row['forum_last_post_id'];
break;
}
$template->alter_block_array('forumrow', array(
'ALTT_LINK_NAME_SHORT' => censor_text($altt_link_name_short),
'ALTT_LINK_NAME' => censor_text($altt_link_name),
'U_ALTT_LINK' => $altt_link_url,
), true, 'change');
}
}
}
}
[Fix] "This forum is protected." when topic was moved (Bug: #797)nickvergessen hat geschrieben:MOD-Titel: NV advanced last topic titles
MOD-Version: 1.3.2
MOD-Beschreibung:MOD-Download: Download v1.3.2
- Fügt in die Forenliste den Titel des letzten Beitrages oder Themas (je nach ACP-Einstellung) hinzu.
phpBB-Version: phpBB 3.0.8
phpBB-Sprachen: de, en, fr
phpBB-Styles: prosilver, subsilver2
MOD-Demo: Development-Themen:
Bitte ladet den MOD nicht in eine Download-Bank, ohne mich zu fragen.