Spider page phpbb mod

Tags: Web Development, Phpbb
Email this Topic • Print this Page

Read Discussion
Reply to All

At gadget's request here is the spider page mod.

Installation:

Code:

############################################################## 

## MOD Title: Spyder Manage

## MOD Author: netclectic < EMAIL REMOVED BY ADMIN > (Adrian Cockbutn) http://www.netclectic.com 

## MOD Description: Adds a page which lists all topics with a link to viewtopic (without a session id).

##     Also adds dynamic meta keywords to viewtopic.

## MOD Version: 0.9.0 BETA

## 

## Installation Level: Easy

## Installation Time: 5 Minutes 

## Files To Edit: (2) page_header.php, overall_footer.php

## Included Files: (2) spyder_manage.php, spyder_manage_body.tpl

############################################################## 

## For Security Purposes, Please Check: http://www.phpbb.com/mods/downloads/ for the 

## latest version of this MOD. Downloading this MOD from other sites could cause malicious code 

## to enter into your phpBB Forum. As such, phpBB will not offer support for MOD's not offered 

## in our MOD-Database, located at: http://www.phpbb.com/mods/downloads/ 

############################################################## 

## Author Notes: 

##  

##     This mod assumes you have already installed... 

##  

##        [*] the enhance-google-indexing mod

##        [*] and the GoogleSingleSession mod

##  

##     both of which are available here - http://www.phpbb.com/phpBB/viewtopic.php?p=252424

##

############################################################## 

## Before Adding This MOD To Your Forum, You Should Back Up All Files Related To This MOD 

############################################################## 



# 

#-----[ COPY ]------------------------------------------ 

# 

copy spyder_manage.php to spyder_manage.php

copy spyder_manage_body.tpl to templates/subSilver/spyder_manage_body.tpl



# 

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

# 

includes/page_header.php



# 

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

# 

define('HEADER_INC', TRUE);



# 

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

# 

// add meta tags - we only want to do this for searchbots

if ( isset($HTTP_GET_VARS[POST_TOPIC_URL]) )

{

	$topic_id = intval($HTTP_GET_VARS[POST_TOPIC_URL]);

}

else if ( isset($HTTP_GET_VARS['topic']) )

{

	$topic_id = intval($HTTP_GET_VARS['topic']);

}



if ( $topic_id && ($userdata['session_id'] ==  md5(d8ef2eab)) ) 

{

    $sql = "SELECT c.cat_title, f.forum_name, t.topic_title 

            FROM " . TOPICS_TABLE . " t, " . FORUMS_TABLE . " f, " . CATEGORIES_TABLE . " c 

            WHERE f.forum_id = t.forum_id 

            AND c.cat_id = f.cat_id 

            AND t.topic_id = $topic_id";

    if( ($result = $db->sql_query($sql)) )

    {

        if ( $meta_row = $db->sql_fetchrow($result) )

        {

            $meta_description = '<meta name=description content="' . $meta_row['cat_title'] . ' :: ' . $meta_row['forum_name'] . ' :: ' . $meta_row['topic_title'] . '">';

        }

    }

    $sql = "SELECT w.word_text 

            FROM " . TOPICS_TABLE . " t, " . SEARCH_MATCH_TABLE . " m, " . SEARCH_WORD_TABLE . " w 

            WHERE t.topic_first_post_id = m.post_id 

            AND m.word_id = w.word_id 

            AND w.word_common = 0 

            AND t.topic_id = $topic_id";

    if( ($result = $db->sql_query($sql)) )

    {

        $meta_keywords = '';

        while ( $meta_row = $db->sql_fetchrow($result) )

        {

            $meta_keywords .= ($meta_keywords=='') ? $meta_row['word_text'] : ',' . $meta_row['word_text'];

        }

        $meta_keywords = '<meta name=keywords content="' . $meta_keywords . '">';

    }    

}



# 

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

# 

templates/subSilver/overall_footer.tpl



# 

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

# 

phpBB Group



# 

#-----[ IN-LINE AFTER, ADD ]----------------------------

# 

<a href="spyder_manage.php" class="gensmall">.</a>



# 

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

# 

# EoM

Topic Stats
Top Replies
Link/Embed

Type: Discussion • Score: 1 • Views: 6,557 • Replies: 36

spyder_manage_body.tpl

Code:

<table width="100%" cellspacing="2" cellpadding="2" border="0">

    <tr><td><a href="{U_INDEX}" class="nav">{L_INDEX}</a></td></tr>

</table>

<table width="100%" cellpadding="2" cellspacing="1" border="0" class="forumline">

    <tr><th class="thTop">{L_CAT}</th>

        <th class="thTop">{L_FORUM}</th>

        <th class="thTop">{L_TOPIC}</th>

    </tr>



    <!-- BEGIN topic_row -->

    <tr><td class="cat"><a href="{topic_row.CAT_URL}" class="cattitle">{topic_row.CAT_TILE}</a></td>

        <td class="cat"><a href="{topic_row.FORUM_URL}" class="cattitle">{topic_row.FORUM_NAME}</a></td>

        <td class="cat"><a href="{topic_row.TOPIC_URL}" class="cattitle">{topic_row.TOPIC_TITLE}</a></td>

    </tr>

    <tr><td colspan="3" class="row1"><span class="genmed">{topic_row.POST_TEXT}</tr>

    <tr>

        <td class="row2" align="left" colspan="2"><span class="genmed">{L_REPLIES}: {topic_row.TOPIC_REPLIES}</span></td>

        <td class="row2" align="right"><span class="genmed"><a href="{topic_row.LAST_POST}" class="genmed">{L_LASTPOST}</a></span></td>

    </tr>

    <!-- END topic_row -->

    <!-- BEGIN switch_more -->

    <tr><td colspan="3" class="row3" align="right"><a href="{NEXT_URL}" class="gen">{L_NEXT}</a></td></tr>

    <!-- END switch_more -->

</table>

0 Replies

spyder_manage.php

Code:

<?php

/***************************************************************************

 *                             spyder_manage.php

 *                            -------------------

 *   Author  		: 	netclectic - Adrian Cockburn - EMAIL REMOVED BY ADMIN

 *   Created 		: 	Saturday, Oct 05, 2002

 *	 Last Updated	:	Saturday, Oct 05, 2002

 *

 *	 Version		: 	Spyder Manage - 0.9.0 BETA

 *

 ***************************************************************************/

define('IN_PHPBB', true);

$phpbb_root_path = './';

include($phpbb_root_path . 'extension.inc');

include($phpbb_root_path . 'common.'.$phpEx);

include($phpbb_root_path . 'includes/functions_post.'.$phpEx);

include($phpbb_root_path . 'includes/bbcode.'.$phpEx);



$userdata = session_pagestart($user_ip, PAGE_INDEX);

init_userprefs($userdata);



include($phpbb_root_path . 'includes/page_header.'.$phpEx);



$sql = "SELECT count(t.topic_id) as total_spider_topics 

        FROM " . TOPICS_TABLE . " t, " . FORUMS_TABLE . " f 

        WHERE f.forum_id = t.forum_id 

        AND f.auth_view <= " . AUTH_REG;

if( !($result = $db->sql_query($sql)) )

{

	message_die(GENERAL_ERROR, 'Could not query count info', '', __LINE__, __FILE__, $sql);

}

if ($countrow = $db->sql_fetchrow($result))

{

    $total_spider_topics = $countrow['total_spider_topics'];

}



        

if( isset($HTTP_GET_VARS['offset']) || isset($HTTP_POST_VARS['offset']) )

{

	$offset = ( isset($HTTP_POST_VARS['offset']) ) ? intval($HTTP_POST_VARS['offset']) : intval($HTTP_GET_VARS['offset']);

}

else

{

	$offset = 0;

}



$sql = "SELECT c.cat_id, c.cat_title, f.forum_id, f.forum_name, f.forum_desc, f.auth_view, t.topic_id, t.topic_title, t.topic_last_post_id, t.topic_replies, p.bbcode_uid, p.post_text 

        FROM " . CATEGORIES_TABLE . " c, " . FORUMS_TABLE . " f, " . TOPICS_TABLE . " t, " . POSTS_TEXT_TABLE . " p  

        WHERE c.cat_id = f.cat_id 

        AND f.forum_id = t.forum_id 

        AND p.post_id = t.topic_first_post_id 

        AND f.auth_view <= " . AUTH_REG . " 

        ORDER BY t.topic_last_post_id DESC 

        LIMIT $offset, 100";

if( !($result = $db->sql_query($sql)) )

{

	message_die(GENERAL_ERROR, 'Could not query topic info', '', __LINE__, __FILE__, $sql);

}



$template->set_filenames(array(

	'body' => 'spyder_manage_body.tpl')

);



while( $topicrow = $db->sql_fetchrow($result))

{

	$bbcode_uid = $topicrow['bbcode_uid'];

    $cat_url = 'index.php?' . POST_CAT_URL . '=' . $topicrow['cat_id'];

    $cat_title = $topicrow['cat_title'];

    

    $forum_url = 'viewforum.php?' . POST_FORUM_URL . '=' . $topicrow['forum_id'];

    $forum_name = $topicrow['forum_name'];

    

    $topic_url = 'viewtopic.' . $phpEx . '?' . POST_TOPIC_URL . '=' . $topicrow['topic_id'];

    $topic_title = $topicrow['topic_title'];

    

    $last_post = 'viewtopic.' . $phpEx . '?' . POST_POST_URL . '=' . $topicrow['topic_last_post_id'] . '#' . $topicrow['topic_last_post_id'];

    $topic_replies = $topicrow['topic_replies'];

    

    $post_url = '';

    

    

    $post_text = '';

    if ( $topicrow['auth_view'] == 0 )

    {

        $post_text = $topicrow['post_text'];

        $post_text = preg_replace('#(<)([\/]?.*?)(>)#is', "<\\2>", $post_text);

    	$post_text = bbencode_second_pass($post_text, $bbcode_uid);

    	$post_text = make_clickable($post_text);

    }

    $template->assign_block_vars( 'topic_row', array(

        'CAT_URL' => $cat_url,

        'CAT_TILE' => $cat_title,

        'FORUM_URL' => $forum_url,

        'FORUM_NAME' => $forum_name,

        'TOPIC_URL' => $topic_url,

        'TOPIC_TITLE' => $topic_title,

        'TOPIC_REPLIES' => $topic_replies,

        'LAST_POST' => $last_post,

        'POST_TEXT' => $post_text

        )

    );

}



$offset = $offset + 100;

if ( ($total_spider_topics - $offset) > 0 )

{

	$next_url = $_SCRIPT_NAME . '?offset=' . $offset;

    $template->assign_block_vars( 'switch_more', array ());

    

}

$template->assign_vars( array (

    'L_CAT' => $lang['Category'],

    'L_FORUM' => $lang['Forum'],

    'L_TOPIC' => $lang['Topic'],

    'L_LASTPOST' => $lang['Last_Post'],

    'L_NEXT' => $lang['Next'],

    'L_REPLIES' => $lang['Replies'],



    'NEXT_URL' => $next_url

    )

);



$template->pparse('body');



include($phpbb_root_path . 'includes/page_tail.'.$phpEx);

?>

0 Replies

The above code is to place this in your forum directory.

I modified the code for use one level above the directory (for better search engine page rank) and also modified the code for use by humans.

Mine looks like this:

http://www.able2know.com/allinone.php

The original like this:

http://www.able2know.com/ataglance.php

Note that in the original example I am using it oen directory above the way it was intended.

I will now post the code for my way.

0 Replies

Code:

<?php

/***************************************************************************

 *                             spyder_manage.php

 *                            -------------------

 *   Author  		: 	netclectic - Adrian Cockburn - EMAIL REMOVED BY ADMIN, Craven de Kere ( www.able2know.com)

 *   Created 		: 	Saturday, Oct 05, 2002

 *	 Last Updated	:	June, 2003

 *

 *	 Version		: 	A2K Spyder Manage - 1.0.0 BETA

 *

 ***************************************************************************/

define('IN_PHPBB', true);

$phpbb_root_path = 'forums/';

include($phpbb_root_path . 'extension.inc');

include($phpbb_root_path . 'common.'.$phpEx);

include($phpbb_root_path . 'includes/functions_post.'.$phpEx);

include($phpbb_root_path . 'includes/bbcode.'.$phpEx);



$userdata = session_pagestart($user_ip, PAGE_INDEX);

init_userprefs($userdata);



$page_title = $lang['At a Glance'];

include($phpbb_root_path . 'includes/page_header2.'.$phpEx);



$sql = "SELECT count(t.topic_id) as total_spider_topics 

        FROM " . TOPICS_TABLE . " t, " . FORUMS_TABLE . " f 

        WHERE f.forum_id = t.forum_id 

        AND f.auth_view <= " . AUTH_REG;

if( !($result = $db->sql_query($sql)) )

{

	message_die(GENERAL_ERROR, 'Could not query count info', '', __LINE__, __FILE__, $sql);

}

if ($countrow = $db->sql_fetchrow($result))

{

    $total_spider_topics = $countrow['total_spider_topics'];

}



        

if( isset($HTTP_GET_VARS['offset']) || isset($HTTP_POST_VARS['offset']) )

{

	$offset = ( isset($HTTP_POST_VARS['offset']) ) ? intval($HTTP_POST_VARS['offset']) : intval($HTTP_GET_VARS['offset']);

}

else

{

	$offset = 0;

}



$sql = "SELECT c.cat_id, c.cat_title, f.forum_id, f.forum_name, f.forum_desc, f.auth_view, t.topic_id, t.topic_title, t.topic_last_post_id, t.topic_replies, p.bbcode_uid, p.post_text 

        FROM " . CATEGORIES_TABLE . " c, " . FORUMS_TABLE . " f, " . TOPICS_TABLE . " t, " . POSTS_TEXT_TABLE . " p  

        WHERE c.cat_id = f.cat_id 

        AND f.forum_id = t.forum_id 

        AND p.post_id = t.topic_first_post_id 

        AND f.auth_view <= " . AUTH_REG . " 

        ORDER BY t.topic_last_post_id DESC 

        LIMIT $offset, 100";

if( !($result = $db->sql_query($sql)) )

{

	message_die(GENERAL_ERROR, 'Could not query topic info', '', __LINE__, __FILE__, $sql);

}



$template->set_filenames(array(

	'body' => 'spyder_manage_body2.tpl')

);



while( $topicrow = $db->sql_fetchrow($result))

{

	$bbcode_uid = $topicrow['bbcode_uid'];

    $cat_url = 'forums/index.php?' . POST_CAT_URL . '=' . $topicrow['cat_id'];

    $cat_title = $topicrow['cat_title'];

    

    $forum_url = 'forums/viewforum.php?' . POST_FORUM_URL . '=' . $topicrow['forum_id'];

    $forum_name = $topicrow['forum_name'];

    

    $topic_url = 'forums/viewtopic.' . $phpEx . '?' . POST_TOPIC_URL . '=' . $topicrow['topic_id'];

    $topic_title = $topicrow['topic_title'];

    

    $last_post = 'forums/viewtopic.' . $phpEx . '?' . POST_POST_URL . '=' . $topicrow['topic_last_post_id'] . '#' . $topicrow['topic_last_post_id'];

    $topic_replies = $topicrow['topic_replies'];

    

    $post_url = '';

    

    

    $post_text = '';

    if ( $topicrow['auth_view'] == 0 )

    {

        $post_text = $topicrow['post_text'];

        $post_text = preg_replace('#(<)([\/]?.*?)(>)#is', "<\\2>", $post_text);

    	$post_text = bbencode_second_pass($post_text, $bbcode_uid);

    	$post_text = make_clickable($post_text);

    }

    $template->assign_block_vars( 'topic_row', array(

        'CAT_URL' => $cat_url,

        'CAT_TILE' => $cat_title,

        'FORUM_URL' => $forum_url,

        'FORUM_NAME' => $forum_name,

        'TOPIC_URL' => $topic_url,

        'TOPIC_TITLE' => $topic_title,

        'TOPIC_REPLIES' => $topic_replies,

        'LAST_POST' => $last_post,

        'POST_TEXT' => $post_text

        )

    );

}



$offset = $offset + 100;

if ( ($total_spider_topics - $offset) > 0 )

{

	$next_url = $_SCRIPT_NAME . '?offset=' . $offset;

    $template->assign_block_vars( 'switch_more', array ());

    

}

$template->assign_vars( array (

    'L_CAT' => $lang['Category'],

    'L_FORUM' => $lang['Forum'],

    'L_TOPIC' => $lang['Topic'],

    'L_LASTPOST' => $lang['Last_Post'],

    'L_NEXT' => $lang['Next'],

    'L_REPLIES' => $lang['Replies'],



    'NEXT_URL' => $next_url

    )

);



$template->pparse('body');



include($phpbb_root_path . 'includes/page_tail2.'.$phpEx);

?>

Note that there is a page title to decide on (needs a lang file entry.

And I call page_header2.php instead of page_header.php

page_header2.php calls overall_header2.tpl whose links are modified to use one level above.

I will post my tpl file.

0 Replies

spyder_manage_body2.tpl

Code:

<table width="100%" cellpadding="2" cellspacing="1" border="0" class="forumline">

    <tr><th class="thTop">All the forums at a glance</th>

    </tr>

    <tr><td class="cat"></td>

    </tr>

    <tr><td class="row1" align="center"><span class="genmed"><a href="http://www.able2know.com/forums/search.php?search_id=newposts">New Post Search</a></span><br />

<span class="genmed"><a href="http://www.able2know.com/forums/search.php?search_id=egosearch">Your Posts</a></span><br />

<span class="genmed"><a href="http://www.able2know.com/allthetopics.php">New Topics</a></span><br />



    </tr>

    <tr>

        <td class="row2"></td>

    </tr>

    <tr><td class="row3"></td></tr>



</table>

<table width="100%" cellspacing="2" cellpadding="2" border="0">

    <tr><td><a href="{U_INDEX}" class="nav">{L_INDEX}</a></td></tr>

</table>

<table width="100%" cellpadding="2" cellspacing="1" border="0" class="forumline">

    <!-- BEGIN switch_more -->

    <tr><td colspan="3" class="row3" align="right"><a href="{NEXT_URL}" class="gen">Next Page</a></td></tr>

    <!-- END switch_more -->

    <tr><th class="thTop" width="20%" >{L_FORUM}</th>

        <th class="thTop" width="35%">{L_TOPIC}</th>

        <th class="thTop" width="20%"></th>

    </tr>



    <!-- BEGIN topic_row -->

    <tr><td class="row1" width="20%" ><a href="{topic_row.FORUM_URL}" class="cattitle">{topic_row.FORUM_NAME}</a></td>

        <td class="row1" ><a href="{topic_row.TOPIC_URL}" class="cattitle">{topic_row.TOPIC_TITLE}</a></td>

        <td class="row1" width="20%" ><span class="gen"><a href="{topic_row.LAST_POST}" class="gen">{L_LASTPOST}</a> 

          ({topic_row.TOPIC_REPLIES})</span></td>

    </tr>

    <!-- END topic_row -->

    <!-- BEGIN switch_more -->

    <tr><td colspan="3" class="row3" align="right"><a href="{NEXT_URL}" class="gen">Next Page</a></td></tr>

    <!-- END switch_more -->

</table>

0 Replies

There are a few kinks to work out. I'll be happy to help anyone who needs it.

0 Replies

first and foremost, once again, THANK YOU THANK YOU THANK YOU! Your help has been most truly appreciated - and i think it's amazing you're not holding your code close to the vest, saying it's some sort of proprietary this or that and keeping it secret - you're like a human GNU license! (or make that hamster)...
Here's a question for you based on your response to my using a redirect:
my html.index pretty much has header tags, some robot stuff which gets ignored, and then a redirect to my gadgetaddict/forums/index.php - i know you said redirects were a google no-no - is there a way i can install your mods above so google will go to them directly, or can i do something to avoid the redirect at least for google? i was wondering if there was a way to cut and paste or do something with a sessions.php subset, so that upon going to index.html, google gets recognized and directed to the at-a-glance equivalenent - what do you think?
google did find my site (ONCE) and did make it to index.php (i believe) at which point it did not spider, and did not come back. I did register with dmoz a couple of months ago, but i'm wondering if i should also register with the subdirectories.
I've also been largely considering scrapping the site and starting over (last last last choice) in case i am very google-unfriendly. which i don't want to be. i want to be a google friend. i want google to sleep over nights and weekends.
my index.html file is this:

<html>
<head>
<TITLE>Gadget Addict! Home of Gizmo, the original Gadget Addict!</TITLE>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Description" CONTENT="A gadgeteer's dream! Gadgets, gizmos and more - reviews, news, toys, hobbies, recreation games computers pdas - we review anything interesting! FREE">
<META NAME="Keywords" CONTENT="gadgetaddict, Gadget Addict, Gadgets, Gizmo, Gizmos, Gadgeteer, electronics, reviews, news, free, forums, community, recreation, friendly, electronic, pockt pc, palm, pda, pocktpc">
<META NAME="ROBOTS" CONTENT="INDEX, FOLLOW">
<META NAME="REVISIT-AFTER" CONTENT="1 DAYS">


</head>
<body bgcolor="#FFFFFF" text="#000000">
<script language="javascript">

</script>
</body>
</html>

so basically when all is said and done, it's only a redirect to forums/phprtal./php
somehow, my tribute to Craven did not show up - strange Smile

what i'd love to do is put in a check if it's google - and if it is then run the spidering code - is that easily accomplished?

0 Replies

gadgetaddict wrote:

first and foremost, once again, THANK YOU THANK YOU THANK YOU! Your help has been most truly appreciated - and i think it's amazing you're not holding your code close to the vest, saying it's some sort of proprietary this or that and keeping it secret - you're like a human GNU license! (or make that hamster)...

No problem. Like I said, it's netclectic's code and since he was a human GNU to me I am morally obligated to pass it on.

gadgetaddict wrote:

Here's a question for you based on your response to my using a redirect:
my html.index pretty much has header tags, some robot stuff which gets ignored, and then a redirect to my gadgetaddict/forums/index.php - i

Well, there are ways to do that redirect in PHP in a way that search Engines won't recognize. But that redirect is the result of sloppy portal code. There is no reason for the redirect and the people who made that did so for one reason:

Thay were too lazy to figure out how to put the "portal" in a different directory than the forum so they has to do a quick and dirty (very dirty) workaround.

gadgetaddict wrote:

know you said redirects were a google no-no - is there a way i can install your mods above so google will go to them directly, or can i do something to avoid the redirect at least for google?

First of all you don't want to setup different site structure or content for Google. This is called "cloaking" and serach engines penalize this severely.

Google's favorite page on your site would be an index.html or PHP page in your root directory (the root of your domain).

The spider page doesn't ahve to be the index page. You can just link to it in your header or footer.

gadgetaddict wrote:

i was wondering if there was a way to cut and paste or do something with a sessions.php subset, so that upon going to index.html, google gets recognized and directed to the at-a-glance equivalenent - what do you think?

Google would notice this. They don't mind having teh session IDs stripped (and the way I gave you that stripps the IDs for all guests is even better).

They would probably consider the tactic you ask for to be "cloaking" and you don't want a Google blacklisting.

gadgetaddict wrote:

google did find my site (ONCE) and did make it to index.php (i believe) at which point it did not spider, and did not come back. I did register with dmoz a couple of months ago, but i'm wondering if i should also register with the subdirectories.

Google won't spider your site without a page rank. Making it accessible is one thing, getting the page rank is another.

You need inbound links for pagerank so yes, DMOZ is VERY important. DMOZ and Yahoo are the most important links you can get.

gadgetaddict wrote:

I've also been largely considering scrapping the site and starting over (last last last choice) in case i am very google-unfriendly. which i don't want to be. i want to be a google friend. i want google to sleep over nights and weekends.
my index.html file is this:

To know Google is to love Google (and to hate Google).

If you want info on Page Rank boosting please ask in a new thread. I'll tell you how I got a PR of 6 in one day of work (and a few weeks of waiting).

gadgetaddict wrote:

<html>
<head>
<TITLE>Gadget Addict! Home of Gizmo, the original Gadget Addict!</TITLE>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<META NAME="Description" CONTENT="A gadgeteer's dream! Gadgets, gizmos and more - reviews, news, toys, hobbies, recreation games computers pdas - we review anything interesting! FREE">
<META NAME="Keywords" CONTENT="gadgetaddict, Gadget Addict, Gadgets, Gizmo, Gizmos, Gadgeteer, electronics, reviews, news, free, forums, community, recreation, friendly, electronic, pockt pc, palm, pda, pocktpc">
<META NAME="ROBOTS" CONTENT="INDEX, FOLLOW">
<META NAME="REVISIT-AFTER" CONTENT="1 DAYS">


</head>
<body bgcolor="#FFFFFF" text="#000000">
<script language="javascript">

</script>
</body>
</html>

First of all, Google doesn't pay attention to meta tags. Just an FYI. All work with Meta tags is wasted if google is your target.

You are using a meta tag refresh. That is the type of redirect that almost all search engines hate.

If you'd liek I can try to give you better redirect options but they woudl all be workarounds. The ideal is to use good directory structure instead of redirects.

gadgetaddict wrote:

what i'd love to do is put in a check if it's google - and if it is then run the spidering code - is that easily accomplished?

Yes, very easy. I'll give you the code as long as you know that cloaking is even worse for search engines than is redirecting.

Caveat: cloaking can be used very effectively but you need to know your stuff and you still might get blacklisted.

0 Replies

Thanks Craven - no cloaking for me. Geez, wish i could figure out the quotes properly so i could give detailed treatment to your responses - anyway, here goes:
phpbbfm is due to "upgrade" again in a few days - supposedly the upgrade is a bunch of bug fixes.
i did contact my web hosting service, and i BELIEVE i am allowed/capable of duplicating my sql database - at that point, i could do whatever install i want and use that duplicate database for testing - i completely understand what you mean by starting with the vanilla phpbb and adding my own mods or the few approved mods - my only concern is then i'm really in trouble - i'll lose my portal (you mentioned you use fetch) and i'd lose my banner management - two of the things i'd hate to give up.
If i am going to scrap my phpbbfm, then i would have to change the entire directory structure. if i'm going to keep phpbbffm (the devil you know is better than...) then i would ask for better structuring - for whatever it's worth, i decided to install under the /forums subdirectory (yeah me, i chose that over /phpbbfm) - but maybe i'd be better off moving everything up a directory or two?
are there any easy fixes or is this one going to be a doozy?
and can you tell me how i double tagged the headers that will make google hate me even more - or better yet, how do i fix it?
geez, i think i'm a full time job for you Smile

0 Replies

Hmm.

I really really think you should go the vanilla route.

I can walk you through each step from backing up to setting up a new portal and banner management system.

But if you really want to keep FM then I can help, but almost everything you do will be to work arround errors rather than fixing them.

Don't worry about going vanilla. It would actually be easier than fixing FM.

0 Replies

Thanks Craven - if you're willing to help i'd be an imbecile to say, "uh, no, i'd rather stick with my buggy phpbbfm, thank you" Smile

I checked with my provider, and i'm allowed 3 sql databases - so my first order of business would be to duplicate the database and rename it, then install phpbb 2.05, and then BEG! I would likely be able to install fetch if the instructions are in english and written for an idiot, i'd be able to install those spider mods you mentioned above, and that would leave my biggest concern - banner management - ipowerweb (my host) has something but i don't love it - the banner management i have now is decent - not that i ever made a penny from banners, mind you, but i'd like to know that i could Smile

so that really leaves me to find the banner management mod and install that separately - what i'll do is duplicate the db and install phpbb while leaving the existing board up - it should coexist, i believe as long as i use separate subdirectories - in the meantime, is there something special i should do, like do you want me to install to a particular subdirectory off my route?
should i also post a new topic, "Can you help me upgrade phpbb" or something to that effect? the things that i'm asking for help with, would likely be of benefit to anyone with a vanilla board. Thanks again Craven - your willingness to help is a credit to caged animals everywhere!

0 Replies

I used to host this forum on ipowerweb (until they suspended us for "MYSQL abuse", a euphemism for "you got too popular so we are kicking you off".

So what I'm trying to say is that I know ipowerweb well.

Depending on the size of your DB you can back it up yourself through phpMyAdmin.

But you can also ask ipowerweb to turn it on for you.

I am well aware of the banner system you speak of. It's not unique to ipowerweb (in fact I have it isntalled on this server though I never use it).

It sucks. There is no way to say it nicely. It does not "manage" banners it simply rotates them at random.

I can help you install the best free ad tracking system and bannermanagement software that there is.

It uses a database though.

I used to use it here but with over to 100,000 page views a day it was using too mcuh in way of system resources.

If you start a thread on upgrading your phpbb board I will walk you through every single step.

As to the portal I can help you too.

It might be as simple as uploading the files (depending onw hat you want and where you want it).

0 Replies

Thanks CdK - I don't know if i mentioned ipowerweb overtly, or if you gave me the ol' finger, err, who is, or whatever, but that's fine - heck, i'd give you my passwords if you'd want em! (but if you're like me, you won't remember em in a day - and then the headaches....)
The "best" banner system i'm aware of is from Neils Chr. Denmark, and the one I'm using now - a couple of minor gripes, but it seems to be getting the job done.
I'll post a thread asking for the help (which is all I do anyway) Smile

or should i post separate threads:
1) Help! How do I set up my mysql database?
2) Help! How do I set up my brand new phpbb download?
3) Help! How do I optomize my board for google?
4) Help! What are the best modifications I should do to my new board?

what do you think? Heck, this is a whole series (whether you wanted it to be or not!)
Should I start those threads? Is there a way to mention on the main page that you're creating this "series" to help new webmasters? I'm sure it would be of benefit to virtually anyone who hosts with phpbb!

0 Replies

You mentioned ipowerweb in your post. But I was about to find your host myself when you mentioned the 3 databases (a limit I remember well from them).

In any case just an FYI, whois will not usually return host info.

I am unfamiliar with Neils' banner code.

He is a fantastic webmaster and produces great code that I have pored over on many an occasion but even without seeing it I can tell you that it's not the best. phpadsnew is a project that is to ad management what phpbb is to forums.

Separate questions are better for search engines :-) but I'll answer it any way you want. For your sake I recommend one thread because I'll give you a step by step from there.

As to the passwords I have no problem entering someone's server and doing the work myself. But I do have 3 quibbles.

1) The ole "teach to fish" rather than "give a fish" analogy.

2) I'd not want to be responsible for screwups (and even when you do everything right things can go wrong).

3) the main one, I do not want to have anyone's passwords. If something goes wrong a month down the line you might think I "hacked" you.

And with ipowerweb you need to ask them to change your password and then they will ask you for the last 4 digits of the credit card you used to buy the hosting.

It's therefore not too easy to change the password and I'd not like to know it'.

In any case, I can walk you through this so it should be quite easy.

0 Replies

Thanks Craven - So I won't tell you the password is <whispering> Bosco - you did see that seinfeld episode, right? otherwise i look like a complete shmo (well, what else is new)
okay, so register would show ipowerweb. somebody should show em! don't know if they're any good, but they've not crashed on me (that i'm aware of) so i have no complaints, well, except for my sciatica, but that's for another part of the forum...
I have to go home soon to tuck in my little one (well, after dinner) so i'm out of commission for the rest of the day.
Should I create a new thread, "Help! How do I get started with phpbb?" and we can take it from there? I also realize, oh, you may have better things to do than baby sit me all day, so of course I realize I'm subject to your convenience. BTW - i agree with the fish thing. And the shoes - you know the shoes reference, right? Smile

Here's what I think makes the most sense: I'll post the new thread, and tomorrow early a.m. i'll download phpbb 2.05, duplicate and rename my database, and do my best to get phpbb 2.05 working as a clean board with my database, then come sniffing around for more help - does that sound okay? and is there a recommended directory you suggest i use? I am already using forums, but i can set it up as say, forums2 and then delete all references to that "2" when the original board is deleted - make sense?
Thanks Craven!

0 Replies

ipowerweb is a host that I recommend (for that niche of virtual hosting with lots of bandwidth).

I have even affiliated with them.

Your plan sounds good, how do you intend to backup your DB? Through phpMyAdmin (the database thing you have in your ipowerweb control panel)?

I recommend that you use a subdirectory that you can keep permanent. forums2 is only fine if you want to leave it that way. Otherwise you'll ahve to make minor tweaks to the phpbb configuration when you change the folder name.

It's really no big deal though.

0 Replies

Okay - laying awake this a.m. between when the baby first chirped, and then finally let lose with a 5 alarmer, i was thinking of doing this:
move what i have now to forums 2, and just get that site working for the time being while we create forums - although now thinking about it, i should just make the new site forum, and leave it as forum - i'd rather have the s, but if it's the diffrence between changing the subdirectory in a bunch of modules, i can do without the s.
ipowerweb actually gave me a few quick instructions how to duplicate the database, and here they are:

1) Export the current DB into a .SQL file using the PHPMYADMIN function in the MYSQL Section of CPANEL.

2) Create a second DB using the MYSQL option.

3) Import the .SQL file into the DB using the PHPMYADMIN option.

sounds like a plan to me!
Any suggestions about what i should do differently, or does it sound, err, sound?
Thanks!
Gary
UPDATE: I was feeling brave, so i was going to start by doing the 3 steps above - except i cant' figure out how to get phpmyadmin to let me do anything other than create or delete a database - i could find no way to export the database into a sql file - am i supposed to write a snippet of php code to do this? if so, ugh!!!!!!!!!!

0 Replies

Look at the bottom of the page. There is a link to phpmyadmin

On another thread I gave instructions on how to backup. Lemme know if I need to elaborate.

0 Replies

i'm soooooo confused! and i'm trying to be careful to tread lightly - i see your mood - don't want to get bitten by a rabid hamster bodybuilder!
i can go into phpadmin through my board directly, or through cpanel but then i'm comptely stuck.
i scrolled down on your site and mine and i don't see the myadmin reference - sorry to make so much extra work for you!
I will do a search on the site to see if i can find the sql backup thread you mentioned....

0 Replies

Read Discussion
Reply to All

Spider page phpbb mod

Related Topics