| |
| |
|
|
|
|
| |
|
| |
|
| :: |
| Author |
Message |
remixed
Joined: 09 May 2008
Posts: 2
|
 Posted: Sat May 10, 2008 12:06 pm Post subject: canver/phpbb3 portal with advanced seo mod |
|
|
Hello,
The Advanced seo mod is running and i just installed the phpbb3 portal or the canver portal (the same).
It works, but i would love to see that the topic links in the portal are also seo and not viewtopic.php?...
I have searched but couldn't find a anwser, the version: 1.2.2 is stable.
This is a part of the recent.php (where the topics are shown in).
| Code: | <?php
/*
*
* @package phpBB3 Portal a.k.a canverPortal ( www.phpbb3portal.com )
* @version $Id: recent.php,v 1.5 2008/02/09 08:18:14 angelside Exp $
* @copyright (c) Canver Software - www.canversoft.net
* @license http://opensource.org/licenses/gpl-license.php GNU Public License
*
*/
if (!defined('IN_PHPBB') or !defined('IN_PORTAL'))
{
die('Hacking attempt');
exit;
}
/**
*/
//
// Exclude forums
//
$sql_where = '';
if ($config['portal_exclude_forums'])
{
$exclude_forums = explode(',', $config['portal_exclude_forums']);
foreach ($exclude_forums as $i => $id)
{
if ($id > 0)
{
$sql_where .= ' AND forum_id <> ' . trim($id);
}
}
}
//
// Recent announcements
//
$sql = 'SELECT topic_title, forum_id, topic_id
FROM ' . TOPICS_TABLE . '
WHERE topic_status <> ' . FORUM_LINK . '
AND topic_approved = 1
AND ( topic_type = ' . POST_ANNOUNCE . ' OR topic_type = ' . POST_GLOBAL . ' )
' . $sql_where . '
ORDER BY topic_time DESC';
$result = $db->sql_query_limit($sql, $config['portal_max_topics']);
while( ($row = $db->sql_fetchrow($result)) && ($row['topic_title']) )
{
// auto auth
if ( ($auth->acl_get('f_read', $row['forum_id'])) || ($row['forum_id'] == '0') )
{
$template->assign_block_vars('latest_announcements', array(
'TITLE' => character_limit($row['topic_title'], $config['portal_recent_title_limit']),
'FULL_TITLE' => censor_text($row['topic_title']),
'U_VIEW_TOPIC' => append_sid("{$phpbb_root_path}viewtopic.$phpEx", 'f=' . $row['forum_id'] . '&t=' . $row['topic_id'])
));
}
}
$db->sql_freeresult($result);
|
i ques that if you know how to change this one, i can change the rest with the same code..? |
|
|
| Back to top |
|
 |
|
|
dcz
Administrateur - Site Admin
Joined: 28 Apr 2006
Posts: 13354
|
| Posted: Wed May 14, 2008 2:00 pm Post subject: Re: canver/phpbb3 portal with advanced seo mod |
|
|
Try replacing :
| Code: | $sql = 'SELECT topic_title, forum_id, topic_id
|
with :
| Code: | | $sql = 'SELECT topic_title, forum_id, topic_id, topic_type |
and adding :
| Code: |
if ( empty($phpbb_seo->seo_url['topic'][$row['topic_id']]) ) {
if ($row['topic_type'] == POST_GLOBAL) {
$phpbb_seo->seo_opt['topic_type'][$row['topic_id']] = POST_GLOBAL;
}
$phpbb_seo->seo_url['topic'][$row['topic_id']] = $phpbb_seo->format_url(censor_text($row['topic_title']));
} |
after :
| Code: | if ( ($auth->acl_get('f_read', $row['forum_id'])) || ($row['forum_id'] == '0') )
{ |
Should do it except for regular announces in case you do use the virtual folder trick and do not use the forum url cache.
Problem with the portal you are using is, it's not really well coded, I would not consider it this stable.
For example, in the code you posted :
| Code: | | WHERE topic_status <> ' . FORUM_LINK . ' |
Does not make sens, only forums can be forum links. But ho well, if it works ...
++ |
_________________
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 |
|
|
remixed
Joined: 09 May 2008
Posts: 2
|
| Posted: Fri May 16, 2008 1:55 pm Post subject: Re: canver/phpbb3 portal with advanced seo mod |
|
|
It worked!!  
http://www.criminalspoint.com/home.html at the left side I've put a little box "Active Topics". That is with the nice seo links AND it links you directly to the latest answer.
Thank you for your help!! |
|
|
| Back to top |
|
|
|
| Navigation |
Similar Topics |
|
|
|
|
|
|
|
| |
|
|
|
|
| |
|
|
|
|
| |
