Java-Gaming.org    
Featured games (79)
games approved by the League of Dukes
Games in Showcase (475)
Games in Android Showcase (106)
games submitted by our members
Games in WIP (530)
games currently in development
News: Read the Java Gaming Resources, or peek at the official Java tutorials
 
    Home     Help   Search   Login   Register   
Pages: [1]
  ignore  |  Print  
  Spam accounts  (Read 1527 times)
0 Members and 1 Guest are viewing this topic.
Offline ryanm

Senior Member


Projects: 1
Exp: 15 years


Used to be bleb


« Posted 2010-12-17 02:24:13 »

 So now that we've got access to the database, I take it the 24000-odd no post accounts will have some attention directed at them? There might be a handful of dedicated lurkers among them, but I can only imagine the vast majority are signature/profile link spam.
I say delete 'em all, perhaps sparing those who have no links and have been active recently.

Similarly, all banned accounts could just be deleted and the ban list cleared. I can only think of two instances of non-spam bans:
  • persistent "java-sucks/stop-infringing-my-freedom-of-speech" irritant uj
  • that certifiably unhinged champion-of-deaf-children/java3D-VRML-loader-advocate/topless-pingpong-enthusiast flavin guy
and I don't think they'll be back anytime soon.

In addition, it'd be handy if mods could just delete spammers as they appear. They typically do their dirty business once and never return anyway, so there's not much point banning them.

Of course, riven is probably way ahead of me here, and he's been stockpiling tactical-yield SQL statements for months now...
Offline Riven
« League of Dukes »

JGO Overlord


Medals: 742
Projects: 4
Exp: 16 years


Hand over your head.


« Reply #1 - Posted 2010-12-17 02:29:43 »

Well, it's true that I have SQL queries, but they are certainly not one liners. Deleting records from a database is easy, but you only need one odd foreign key pointing to oblivion and you might potentially take the whole forum down.

I'm very hesitant to 'drop the dead weight', and will probably do it somewhere in the next few days. Putting the forum in maintenance mode, making a backup, unleashing the queries, and hit F5 to see whether everything still works Smiley

Hi, appreciate more people! Σ ♥ = ¾
Learn how to award medals... and work your way up the social rankings
Offline Nate

JGO Kernel


Medals: 145
Projects: 4
Exp: 14 years


Esoteric Software


« Reply #2 - Posted 2010-12-17 02:59:01 »

OT: I keep wanting to post to the suggestion threads, but they are all locked. Sad

Games published by our own members! Check 'em out!
Legends of Yore - The Casual Retro Roguelike
Offline Riven
« League of Dukes »

JGO Overlord


Medals: 742
Projects: 4
Exp: 16 years


Hand over your head.


« Reply #3 - Posted 2010-12-17 03:10:23 »

OT: I keep wanting to post to the suggestion threads, but they are all locked. Sad

Fair point. I'm now 'flagging' topics with a prefix in the title.

Hi, appreciate more people! Σ ♥ = ¾
Learn how to award medals... and work your way up the social rankings
Pages: [1]
  ignore  |  Print  
 
 
You cannot reply to this message, because it is very, very old.

 

Add your game by posting it in the WIP section,
or publish it in Showcase.

The first screenshot will be displayed as a thumbnail.

ctomni231 (34 views)
2014-07-18 06:55:21

Zero Volt (30 views)
2014-07-17 23:47:54

danieldean (25 views)
2014-07-17 23:41:23

MustardPeter (27 views)
2014-07-16 23:30:00

Cero (42 views)
2014-07-16 00:42:17

Riven (44 views)
2014-07-14 18:02:53

OpenGLShaders (33 views)
2014-07-14 16:23:47

Riven (34 views)
2014-07-14 11:51:35

quew8 (30 views)
2014-07-13 13:57:52

SHC (66 views)
2014-07-12 17:50:04
HotSpot Options
by dleskov
2014-07-08 03:59:08

Java and Game Development Tutorials
by SwordsMiner
2014-06-14 00:58:24

Java and Game Development Tutorials
by SwordsMiner
2014-06-14 00:47:22

How do I start Java Game Development?
by ra4king
2014-05-17 11:13:37

HotSpot Options
by Roquen
2014-05-15 09:59:54

HotSpot Options
by Roquen
2014-05-06 15:03:10

Escape Analysis
by Roquen
2014-04-29 22:16:43

Experimental Toys
by Roquen
2014-04-28 13:24:22
java-gaming.org is not responsible for the content posted by its members, including references to external websites, and other references that may or may not have a relation with our primarily gaming and game production oriented community. inquiries and complaints can be sent via email to the info‑account of the company managing the website of java‑gaming.org
Powered by MySQL Powered by PHP Powered by SMF 1.1.18 | SMF © 2013, Simple Machines | Managed by Enhanced Four Valid XHTML 1.0! Valid CSS!