| |
| |
|
|
|
|
| |
|
| |
|
| :: |
| Author |
Message |
kyle1745
Joined: 21 Dec 2007
Posts: 32
|
 Posted: Sat Jan 26, 2008 3:04 am Post subject: No Dupe? |
|
|
How can I revert this SQL change from No Dupe? I did not care for how it modified the look of my forum so I am removing this mod.
ALTER TABLE `phpbb_topics` ADD INDEX ( `topic_last_post_id` );
Thanks,
Kyle |
|
|
| Back to top |
|
 |
|
|
dcz
Administrateur - Site Admin
Joined: 28 Apr 2006
Posts: 15242
|
| Posted: Sun Jan 27, 2008 9:52 am Post subject: Re: No Dupe? |
|
|
Before you do so, just know you can use the mod keeping your index exactly as before, but wihtout duplicate on the last post link, in includes/functions_display.php, replace :
| Code: | // Limit in chars for the last post link text.
$char_limit = 25;
// Limit topic text link to $char_limit, without breacking words
$topic_text_lilnk = $char_limit > 0 && ( ( $length = utf8_strlen($phpbb_seo->seo_censored[$row['topic_id']]) ) > $char_limit ) ? utf8_strlen($fragment = utf8_substr($phpbb_seo->seo_censored[$row['topic_id']], 0, $char_limit + 1 - 4)) < $length + 1 ? preg_replace('`\s*\S*$`', '', $fragment) . ' ...' : $phpbb_seo->seo_censored[$row['topic_id']] : $phpbb_seo->seo_censored[$row['topic_id']];
$last_post_link = '<a href="' . append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id_last_post'] . '&t=' . $row['topic_id']) . '" title="' . $phpbb_seo->seo_censored[$row['topic_id']] . ' : ' . $phpbb_seo->seo_opt['topic_forum_name'][$row['topic_id']] . '">' . $topic_text_lilnk . '</a>'; |
with :
| Code: | | $last_post_link = ''; |
And you won't have the topic title added.
You would not need the code change on template either.
Anyway, to drop an index :
| Code: | | DROP INDEX `topic_last_post_id` ON `phpbb_topics`; |
++ |
_________________
Useful links :
SEO Forum || SEO Directory || SEO phpBB || SEO phpBB3 || Search
____________________
Liens Utiles :
Forum référencement || Annuaire référencement || Référencement phpBB || Référencement phpBB3 || Recherche |
|
| Back to top |
|
|
|
| Navigation |
Similar Topics |
|
|
|
|
|
|
|
| |
|
|
|
|
| |
|
|
|
|
| |
