[ABD] Bot Indexing MOD v1.1.1

[raymonkondos]

I installed PHP MOD BOT v1.2 on phpbb 2.0.15

One of the my users got this message, does anyone know what is wrong?

phpBB : Critical Error

Error creating new session

DEBUG MODE

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

INSERT INTO phpbb_sessions (session_id, session_user_id, session_start,
session_time, session_ip, session_page, session_logged_in, is_robot,
session_admin) VALUES ('ae2c4290039d8969bc01c2a959bfaace', -1,
1119396348,
1119396348, '52d5e40e', 0, 0, '0', 0)

Line : 173
File : sessions.php

[raymonkondos]

Later I checked my database and there is indeed an is_robot mentioned in the field column

[webmedic]

yes you are missing the correct tables. there is a php file that should come with it that will take care of that for you.

[webmedic]

sorry posted to slow. Bo back over the install and make sure there are no errors anyplace.

[raymonkondos]

yes you are missing the correct tables. there is a php file that should come with it that will take care of that for you.

What do you mean by missing the correct tables ... could you elaborate? How do you think I should fix the problem?

I checked the modifications as came in the instructions and there is nothing wrong in them.

However, I did not not see any other user with similar complaint ... and this is somewhat strange.

[webmedic]

I'm sorry I posted to slow and saw afterwards that the tables were there. My advice would be to remove the mod and reinstall it.

[raymonkondos]

I'm sorry I posted to slow and saw afterwards that the tables were there. My advice would be to remove the mod and reinstall it.

I think so ... I would definetly do so since I had received new problems,
but I wonder if this mod is compliant with phpbb v2.0.15 because the instructions say it is good for 2.0.11

Thanks anyway

[Kowoshiarah]

Hello ,

I have one minor problem . Why my bots are staying in "Index Forum" always ? it's normal ?

I applied URL rewriting on my forums .

Thank in advance for yours answers .

If not , I have applied a modification about this mod . I propose you my addon

This addon count bots in the who's online block .

Ex : "In total there are 2 users online :: 1 Registered, 0 Hidden, 0 Guests and 1 Bot "

Code: Select all

#
#-----[ Open ]----------------------------------------------
#
     includes/page_header.php

#
#-----[ Find ]----------------------------------------------
#

     if( $row['is_robot'] )
            {
               $online_userlist = $row['is_robot'] . (($online_userlist!='') ? ', ' : '') . $online_userlist;
            }

#
#-----[ Replace by ]----------------------------------------------
#

if( $row['is_robot'] )
            {     
                                        $guests_online--;
                    $bot_count++;
               $online_userlist = $row['is_robot'] . (($online_userlist!='') ? ', ' : '') . $online_userlist;
            }

#
#-----[ Find ]----------------------------------------------
#

   $total_online_users = $logged_visible_online + $logged_hidden_online + $guests_online;

#
#-----[ Replace by ]----------------------------------------------
#

  $total_online_users = $logged_visible_online + $logged_hidden_online + $guests_online + $bot_count;

#
#-----[ Find]----------------------------------------------
#

else
   {
      $l_g_user_s = $lang['Guest_users_total'];
   }

#
#-----[ After addon ]----------------------------------------------
#

if ( $bot_count == 0 )
   {
      $l_bot = $lang['Bot_nul'];
   }
   else if ( $bot_count == 1 )
   {
      $l_bot = $lang['Bot_one'];
   }
   else
   {
      $l_bot = $lang['Bot_total'];
   }

#
#-----[ Find]----------------------------------------------
#

    $l_online_users .= sprintf($l_g_user_s, $guests_online);

#
#-----[ After addon ]----------------------------------------------
#

   $l_online_users .= sprintf($l_bot, $bot_count);

#
#-----[ Save and close]----------------------------------------------
#

#
#-----[ Open ]----------------------------------------------
#
 
   language/lang_english/lang_main.php

#
#-----[ Find]----------------------------------------------
#

$lang['Hidden_users_zero_total'] = '0 Hidden and ';
$lang['Hidden_user_total'] = '%d Hidden and ';
$lang['Hidden_users_total'] = '%d Hidden and ';

#
#-----[ Replace by]----------------------------------------------
#

$lang['Hidden_users_zero_total'] = '0 Hidden, ';
$lang['Hidden_user_total'] = '%d Hidden, ';
$lang['Hidden_users_total'] = '%d Hidden, ';

#
#-----[ Find ]----------------------------------------------
#

$lang['Guest_users_zero_total'] = '0 Guests';
$lang['Guest_users_total'] = '%d Guests';
$lang['Guest_user_total'] = '%d Guest';

#
#-----[ Replace by ]----------------------------------------------
#

$lang['Guest_users_zero_total'] = '0 Guests and ';
$lang['Guest_users_total'] = '%d Guests and ';
$lang['Guest_user_total'] = '%d Guest and';


#
#-----[ Find ]----------------------------------------------
#

$lang['Guest_users_zero_total'] = '0 Guests and ';
$lang['Guest_users_total'] = '%d Guests and ';
$lang['Guest_user_total'] = '%d Guest and';

#
#-----[ After addon ]----------------------------------------------
#

$lang['Bot_nul'] = '0 Bots';
$lang['Bot_total'] = '%d Bots';
$lang['Bot_one'] = '%d Bot';

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

I hope that this Addon already does not exist

PS : Sorry for my english , I'm French and doesn't speak english very well

[ridinhighspeeds]

Awesome Kowoshiarah thanks for the code!

You look like you're from that show 7th heaven.

[svennson]

english :
thanks great add-on

francais :
Merci , trés bien add-on

nederlands
prachtig mooie add-on

[CICarScene]

Will this stop this happening?

and Is anyone else getting this?

Basically bots (ask jeeves etc) are maxing out my forum..





Basically the bot spawns multi connections and floods my forum, it basically maxes out the forum, which makes the forum drops all connections

so if someone has just logged in and clicked view new posts, and at that moment the forum drops all connections, they are logged out and when log back in again see zero new posts as they were logged out If you have "stay connected" ticked, it obviosuily keeps you logged in, but as the server dropped your connection it looks like you logged out and back in again, and again all posts will then be read

I have tried this on numerous servers, from my own one to different hosting companies and the same thing keeps happening!

help!! as it is very annoying to say the least! any ideas? will this mod stop this from happening?

anyone ?

[Kowoshiarah]

You're welcome (De rien)

For my first question , do you know some answers ? Thank

I have one minor problem . Why my bots are staying in "Index Forum" always ? it's normal ?

[raymonkondos]

I don't get it, once the number of pages crawled by Googlebot for instance reach as many as 250 (5%) the number gets reduced again probably on each visit. Is that supposed to be normal thing?

[raymonkondos]

Difficult?

[jozomannen]

I haven't read all pages, but I've found a bug and I have some things I would like to have better:

I installed the mod for about 3-4 weeks ago, I think it's the latest release

I want it to show the botname instead of Guest in Admin Index

I want to have the bot's ordered alphabetically on the Manage Bots -page