Social Network Marketing Tycoon

**GeorgeB** · 06-02-2007, 02:05 PM

Ok my board is all set up and imported from phpBB

JibberNet Forums - Powered by vBulletin

Now I need to get rid of the thousands (yes thousands) of spam posts made while my board sat dormant as a phpBB board.

What I want to do is run a special query for each keyword that is likely spam like cialis, viagra, *****, etc.

BUT... most of the posts are just single posts in threads, so will that mess things up if I do a query direct to the DB like that?

Am I going about this the wrong way? Please help!!

**MonkeyBiz** · 06-02-2007, 07:16 PM

Do you get traffic from the spam keywords? I have an old phpbb forum which is full of ringtone and pills and other **** spam and I just let it it accumulate. Its like a free content keyword automation system. I get almost 1000 hits a day from search engines from the spam keywords and the related adsense and yahoo publisher ads pay pretty well. Im thinking of launching 10 more of these phpbb forums and having spammers 'populate' it with keyword spam.

**aydoubleyou** · 06-02-2007, 07:56 PM

****ty. good luck with it.

nice looking template though

**Fredto** · 06-03-2007, 12:19 AM

Funny how I never thought of that...

I have an old board literally filled with spam (more than 11mb of spam in the DB), I should do something with that...

**Asian** · 06-03-2007, 05:07 AM

Quote:

Originally Posted by Worldwebuser

Do you get traffic from the spam keywords? I have an old phpbb forum which is full of ringtone and pills and other **** spam and I just let it it accumulate. Its like a free content keyword automation system. I get almost 1000 hits a day from search engines from the spam keywords and the related adsense and yahoo publisher ads pay pretty well. Im thinking of launching 10 more of these phpbb forums and having spammers 'populate' it with keyword spam.

Woah getting paid to be spammed :tt1:

**GeorgeB** · 06-03-2007, 12:10 PM

So can anyone help with my actual issue?

**amirfl** · 06-04-2007, 06:08 PM

You can try the Phpbb Admin Toolkit by Starfoxtj.

I can't post URL's yet so just do a google search for the download site.

Hope this helps.

**microdude431** · 06-04-2007, 08:20 PM

Quote:

Originally Posted by amirfl

You can try the Phpbb Admin Toolkit by Starfoxtj.

I can't post URL's yet so just do a google search for the download site.

Hope this helps.

Great idea, here is the link:

PHPBB Admin ToolKit :: Starfoxtj

**imported_mondala** · 06-05-2007, 02:29 PM

I know the anti-spam acp for phpbb will list you all inactive users, vbulletin does this within the acp... might lose some legit users in the process though but just before maitenance you could send a mail to all your users letting them know that if there (0 post) account was removed to just re-register.

**john546** · 06-30-2007, 08:51 PM

The thing is, not everyone would want spam on their forums if they are using it as a business tool or as a part of their main site as it just makes the whole site look much more unprofessional.

Also, I would watch with some of the spam as it's likely to break Adsense's TOS with a majority of the spam.

Good luck anyway.

**cpvr** · 07-13-2007, 05:58 PM

Have you fixed this problem yet?

**Frito Pie** · 07-13-2007, 08:31 PM

Did you figure it out George? I took a look at your site (nice skin!) and it seems to be very tidy.

**imported_Bart** · 07-16-2007, 12:58 AM

This mod will force a user to answer a question on the
registration form viz what is 5 + 2 ?

So automated spam bots will not be able to register

Edit: /template/subSilver/profile_add_body.tpl

Look for ""
and add a new row (code snippet below) right ABOVE it.
----------------
<tr>
<td class="row1">How much is 5+2 *</td>
<td class="row2">
<input type="text" class="post" style="width: 200px" name="math_question" size="6" maxlength="6" value="" />
</td>
</tr>
--------------

Edit: /includes/usercp_register.php

Look for --> if ($board_config['enable_confirm'] && $mode == 'register')
put the following the code snippets just above it

---------------------------------
if (!isset($_POST['math_question']) || $_POST['math_question'] != '7')
{
$error = TRUE;
$error_msg .= (isset($error_msg) ? ' ' : '') . "Incorrect answer to the mathematical question...";
}
---------------------------------

The final file should look like this
=====================
else if ( $mode == 'register' )
{
if ( empty($username) || empty($new_password) || empty($password_confirm) || empty($email) )
{
$error = TRUE;
$error_msg .= ( ( isset($error_msg) ) ? ' ' : '' ) . $lang['Fields_empty'];
};

if (!isset($_POST['math_question']) || $_POST['math_question'] != '7')
{
$error = TRUE;
$error_msg .= (isset($error_msg) ? ' ' : '') . "Incorrect answer to the mathematical question...";
}
}

**imported_Bart** · 07-16-2007, 01:00 AM

Sorry only works with phpbb versions

**GeorgeB** · 07-16-2007, 01:27 AM

I did them by hand

**jesterx** · 07-16-2007, 01:30 AM

great info ta