Padding Member Count...OR...

Discussion in 'Site Feedback' started by Gustav, Jul 29, 2010.

  1. Gustav Banned Banned

    Messages:
    12,575

    Please Register or Log in to view the hidden image!




    28 members online
    24 are listed
    4 are then hidden
    of the 24, i recognize kat, read and quad
    that leaves 21
    all are spammers

    good going sci
     
  2. Guest Guest Advertisement



    to hide all adverts.
  3. Gustav Banned Banned

    Messages:
    12,575
    and 10 minutes later....

    Please Register or Log in to view the hidden image!




    4 lines of spammers

    pathetic!
     
  4. Guest Guest Advertisement



    to hide all adverts.
  5. Gremmie "Happiness is a warm gun" Valued Senior Member

    Messages:
    2,593
    I could go visible... Would break up the spammer line.

    Please Register or Log in to view the hidden image!

     
  6. Guest Guest Advertisement



    to hide all adverts.
  7. Stryder Keeper of "good" ideas. Valued Senior Member

    Messages:
    13,105
    I hear brick walls are good listeners.

    Seriously though, we are stuck with those spammers appearing as live while utilising the software without any hacks or alterations. Personally I did try on my own experimental board a hack some time back.

    Simply put you create a folder with a .htaccess "DENY" list. The list has to be rewritten from the database for Banned IP's and Canonical domains. When a "banned" member attempts to login, rather than getting the default template with the ban message (Which does consume bandwidth) they are instead pointed to a "gateway" that doesn't exist within the folder that has the .htaccess file.

    The spammer just gets a 401 header rather than an actual page being sent, this thereby saves bandwidth for legitimate logins.

    It can be rigged to only handle ex-members that are in the SPAMMER usergroup rather than BANNED members.(incase they are only temporary)

    It's something I personally would have implemented however it's not my site, it's something that you'd have to petition for and that could take a while.
     
  8. Chipz Banned Banned

    Messages:
    838
    Stryder, the "banned" page is 3.6 kb. I doubt the bandwidth is worth the CPU time required to check.
     
  9. Stryder Keeper of "good" ideas. Valued Senior Member

    Messages:
    13,105
    Well the problem is with "Banned" spammer bots that just idle like Zombie servers. Most of them can't actually post anything because they are already banned however they might alter their homepage or interests etc to try and manipulate search engine entries about their various spammer sites.

    The banned page is actually far less than it use to be and unfortunately it's not created by a CRON event to my knowledge, it's actually rebuilt every load.

    All these things might seem trivial but they all add up in the end.

    An anecdote of this is when this site use to allow signatures many years ago. I used a freeserver that gave 10Gb per month in bandwidth where I hosted one small less than 35kb image in my signature. The problem was that every post I made would have the signature in and in long threads where I'd replied a number of times meant that the image was loaded multiple times. [Obviously browser cache's have got more advanced since then] I was finding that within about 2 weeks of the month I was consuming all 10Gb of bandwidth which meant the server would automatically cut off the images from loading. This was just caused by the pageloads from users, search engines, robots and spammers. (Spammers were less back then)

    This expressed both the popularity of the site and the problem with signatures. To my knowledge it was one of the things that got the signatures and in house hosted images stopped on the site. (Bandwidth was always a premium.)
     
    Last edited: Oct 6, 2010
  10. Stryder Keeper of "good" ideas. Valued Senior Member

    Messages:
    13,105
    Something for Gustav:

    http://www.alexa.com/siteinfo/sciforums.com

    According to Alexa one of the highest sort out words other than "Science" and "Windows XP" that are used to find sciforums is "Pokemon", Another rather unusual factoid is apparently sciforums is rated 719th in Bosnia and Herzegovina.

    So all the sciforums members that usually rant here are potentially household names. (or not) So according to a wikitravel entry:

    Zdravo. (ZDRAH-voh) or Merhaba (MEHR-hah bah)
     
  11. Syzygys As a mother, I am telling you Valued Senior Member

    Messages:
    12,671
    Speaking of banned list, only real members should be listed, who actually posted something other then spam....
     
  12. Stryder Keeper of "good" ideas. Valued Senior Member

    Messages:
    13,105
    That could be easily done, It would just require a members "Group" to alter based upon specific stat's. For instance If 0-20 posts, New Member group. New member group can then have specific settings rigged like "Not appearing on the Online" section of the forum, not allowing links to be inserted, not allowing PM's etc.

    It might however be seen as Draconian by some.
     
  13. Gustav Banned Banned

    Messages:
    12,575
    onholiFieheni
    Registering

    11:04 AM Styponoussy
    Registering

    11:05 AM theresawoog
    Registering

    11:06 AM carlavaom
    Registering

    11:06 AM RAMONLYUQ
    Registering

    10:59 AM Endumeveime
    Registering

    10:37 AM alotbaple
    Registering

    10:48 AM objeskillense
    Registering

    11:05 AM VALERIEHAAG
    Registering

    11:02 AM BusinessFunding
    Registering

    10:44 AM Dupexobefub
    Registering

    11:00 AM VatoaxotteCab
    Registering

    10:38 AM SwaxiaBip
    Registering

    11:06 AM Inciniped
    Registering


    kill them all
     
  14. Gustav Banned Banned

    Messages:
    12,575
    Habsnoca
    Registering

    04:53 PM SAMANTHAHAED
    Registering

    04:59 PM SharadPrasad
    Registering

    04:56 PM ugg ttyu
    Registering

    05:03 PM traceybiuk
    Registering

    04:56 PM Acwkowk
    Registering

    04:54 PM BENJAMINVEUH
    Registering

    04:49 PM daniarraymerr
    Registering

    05:03 PM 07NHholly
    Registering

    05:03 PM Teawlestswolf
    Registering

    05:05 PM emizgrierly
    Registering

    04:54 PM melindavuit
    Registering

    04:54 PM SHERRYBYYR
    Registering

    05:02 PM rogerqeyl
    Registering

    05:02 PM babeeldetty
    Registering

    04:59 PM LucilleWYOC
    Registering

    05:17 PM ruPerdoncD
    Registering

    04:57 PM Slepexize
    Registering

    05:18 PM BERNARDPYYF
    Registering

    05:10 PM tinnitus01
    Registering

    05:02 PM TaibreEnrib
    Registering

    04:52 PM prseofshbqwe
    Registering


    slit their throats!
     
  15. Gustav Banned Banned

    Messages:
    12,575
    gee
    come back spammers
    we miss you
     
  16. Randwolf Ignorance killed the cat Valued Senior Member

    Messages:
    4,201
    This is the second time I've mentioned this suggestion, and now that it has been confirmed that the ban list is created real time, it seems to make even more sense. (At least to me).

    Modify the "WHERE" part of the SQL statement to list only those records in the "banned" table where the word "spam" is not included in the ban reason. If you want to get fancy, use regex. Either way, someone with access to VBulletin's source should be able to make this change in a matter of minutes, with little to no danger of adverse, unintended consequences.

    :shrug:
     
  17. John99 Banned Banned

    Messages:
    22,046
    Why do you want to see who was banned last year? Sure it may be interesting at the moment but as time goes by. plus most likely the only record they have of spammers.
     
  18. Randwolf Ignorance killed the cat Valued Senior Member

    Messages:
    4,201
    John, the point here is to eliminate the faux users, created expressly for the purpose of spamming, from appearing on the ban list. This is not the same as eliminating the record from the database. Do you even understand the difference between a maintaining a record and displaying / reporting it?

    The more apropos question would be "John, why do you want to see all those who are banned for spamming?" Hmmm?
     
  19. Dywyddyr Penguinaciously duckalicious. Valued Senior Member

    Messages:
    19,252
    Well, back when I was a mod (before the FBI found me) I checked suspect IP addresses on the Ban List for previously-banned spammers.
    It's a quick way of checking: if they're already listed (regardless of name) then they got banned before they posted.
     
  20. John99 Banned Banned

    Messages:
    22,046
    That is THE record of banned users. I doubt there is another. Sure they can delete the user but then that user would no longer be banned and their name would not be on the list. A bit counterproductive dont you think, Rand?
     
  21. Randwolf Ignorance killed the cat Valued Senior Member

    Messages:
    4,201
    Even better. The query that the Mods use would access the entire table, but the report (display) for general users would be limited to those banned for reasons other than spamming.

    It may not be a perfect solution, but it would take next to no extra processing ticks and still leave the records intact for other purposes. Am I missing something?
     
  22. Randwolf Ignorance killed the cat Valued Senior Member

    Messages:
    4,201
    Geez,John. For the record, once again, I am not talking about altering, adding to, or subtracting from the table in which banned records are kept. I am simply advocating changing the SQL query which displays a given subset of those records. This seems to be a concept which you entirely fail to grasp, although for some reason that doesn't surprise me.

    Unless you are totally familiar with DB's, records, fields, reports / displays and the SQL behind creating such, including the differences therein, you are totally unqualified to offer responses on this topic. Hush now...
     
  23. Dywyddyr Penguinaciously duckalicious. Valued Senior Member

    Messages:
    19,252
    Possibly. As far as I was aware (and I'm quite willing to admit to ignorance on this) the Ban List - as seen by everyone - was the only resource I had.
    Maybe there is (or could be) a full list for mod use/ limited for others, but if there already is I haven't seen/ used it.
     

Share This Page