Oh no! Where's the JavaScript?
Your Web browser does not have JavaScript enabled or does not support JavaScript. Please enable JavaScript on your Web browser to properly view this Web site, or upgrade to a Web browser that does support JavaScript.
Not a member yet? Click here to register.
Forgot Password?

20.000 spam message within a day.

Asked Modified Viewed 3,366 times
G
Geri
G
Geri 10
  • Junior Member, joined since
  • Contributed 24 posts on the community forums.
  • Started 7 threads in the forums
  • Started this discussions
asked
Junior Member

yeah, in comments (news-comments). i cant even view they ip addresses. whatever.

what is the proper SQL command, to delete all comments that contain the "viagra", 'cialis" texts ?
0 replies

6 posts

G
Geri
G
Geri 10
  • Junior Member, joined since
  • Contributed 24 posts on the community forums.
  • Started 7 threads in the forums
  • Started this discussions
answered
Junior Member

i quicky have written a script to delete the messages, becouse the solution needed immediately. if somebody have the same spambot, should use this script:



<?php
/*-------------------------------------------------------+
| PHPFusion Content Management System
| Copyright (C) 2002 - 2011 Nick Jones
| http://www.php-fusion.co.uk/
+--------------------------------------------------------+
| Filename: news.php
| Author: Nick Jones (Digitanium)
+--------------------------------------------------------+
| This program is released as free software under the
| Affero GPL license. You can redistribute it and/or
| modify it under the terms of this license which you
| can read by viewing the included agpl.txt or online
| at www.gnu.org/licenses/agpl.html. Removal of this
| copyright header is strictly prohibited without
| written permission from the original author(s).
+--------------------------------------------------------*/
require_once "maincore.php";
require_once THEMES."templates/header.php";

// Predefined variables, do not edit these values
$i = 0;

// Number of news displayed

echo '<script type="text/javascript">';
echo "function ujratolt(){";
echo " window.location.reload()";
echo "}";
echo "window.setInterval( 'ujratolt()', 10000);";
echo "</script>";


$displayComments = 100000;

$result = dbquery("   SELECT comment_id, comment_item_id, comment_type, comment_message
               FROM ".DB_COMMENTS."
               WHERE comment_hidden='0'
               ORDER BY comment_datestamp DESC
               ");
if (dbrows($result)) {
   $output = "";
   $i = 0;
   while($data = dbarray($result)) {
      if ($i == $displayComments) { break; }
      if ($data['comment_type'] == "N") {
         $access = dbcount(   "(news_id)", DB_NEWS,
                        "news_id='".$data['comment_item_id']."' AND
                        ".groupaccess('news_visibility')." AND
                        (news_start='0'||news_start<=".time().") AND
                        (news_end='0'||news_end>=".time().")
                        ");


         if ($access > 0) {
if(strstr($data['comment_message'], "viagra") || strstr($data['comment_message'], "cialis") || strstr($data['comment_message'], "Tramadol") || strstr($data['comment_message'], "xanax") || strstr($data['comment_message'], "tramadol")  || strstr($data['comment_message'], "zolpidem")  ){
               echo "spam: ".$data['comment_message']."<br><br>";
               $w="/news.php?readmore=120&c_start=0&c_action=delete&comment_id=".$data['comment_id'];
               echo $w."<br><br>";
               echo "<iframe src='".$w."' width='16' height='16' ></iframe>";
            }
         }
      }
   }
}
         
      




just save it as spam.php, and execute in firefox with admin priviliges. it will do the trick until an officinal solution will born on this situation
Edited by Homdax on 20-11-2012 08:54,
0 replies
V
Vyper69
V
Unprecedented Times call for Unprecedented Measures
  • Senior Member, joined since
  • Contributed 551 posts on the community forums.
  • Started 146 threads in the forums
answered
Senior Member

And just why don't you use the simple question for registration. It would fix alot of your headache.
0 replies
P
PolarFox
P
  • Veteran Member, joined since
  • Contributed 1,633 posts on the community forums.
  • Started 29 threads in the forums
answered
Veteran Member

DELETE FROM TABLE XXX WHERE comment_message LIKE %viagra%

something like this, fast and easy.
0 replies
M
Masy
M
Masy 10
  • Newbie, joined since
  • Contributed 4 posts on the community forums.
  • Started 1 thread in the forums
answered
Newbie

First disable all the contact/reaction information issues from public to SuperUser.
And look/control if the spam reduses to zero...

If not, You're site is infected. You have to remove all the php-fusion files and database completely. And build up You're site from the scratch...

And check out You're internet traffic by You're Provider. You're hosting a site...

With 20.000 spam messages a day I would immediatly shut down my site.
If You stay on hosting You've got a big problem within the EU...
What's going out? Did You checked that issue?

My respond is close all down. Remove all and build all up with the newest version of PHPFusion...

Greetings,
0 replies
G
Geri
G
Geri 10
  • Junior Member, joined since
  • Contributed 24 posts on the community forums.
  • Started 7 threads in the forums
  • Started this discussions
answered
Junior Member

my site was not infected, the bot figured out to bypass rechapta2
0 replies
K
Kamillo
K
------------------------------
PHP-Fusion PL Crew | Spam Cop | My Site
  • Senior Member, joined since
  • Contributed 244 posts on the community forums.
  • Started 23 threads in the forums
answered
Senior Member

You can try This easy solution. Works perfect with bots.
0 replies

Labels

None yet

Statistics

  • Views 0 views
  • Posts 6 posts
  • Votes 0 votes
  • Topic users 5 members

5 participants

P
P
  • Veteran Member, joined since
  • Contributed 1,633 posts on the community forums.
  • Started 29 threads in the forums
K
K
------------------------------
PHP-Fusion PL Crew | Spam Cop | My Site
  • Senior Member, joined since
  • Contributed 244 posts on the community forums.
  • Started 23 threads in the forums
G
G
Geri 10
  • Junior Member, joined since
  • Contributed 24 posts on the community forums.
  • Started 7 threads in the forums
  • Started this discussions
V
V
Unprecedented Times call for Unprecedented Measures
  • Senior Member, joined since
  • Contributed 551 posts on the community forums.
  • Started 146 threads in the forums
M
M
Masy 10
  • Newbie, joined since
  • Contributed 4 posts on the community forums.
  • Started 1 thread in the forums

Notifications

Track thread

You are not receiving notifications from this thread.

Related Questions

Not yet