Hi, my user/registration is getting hammered by spammers and I am trying to use the dr_watchdog table in phpMyAdmin to find out the worst offenders.

The question I have is this; which setting within the table is best for finding out the worst spammers: Primary descending, Type descending, UID descending, or Severity descending?

(I assume descending is based on the latest timestamp?)

If you know which is best, can you tell me why it is the best?

Thanks

Comments

nevets’s picture

It may be easier to work from the Drupal interface under reports, but either way I would filter the type by 'user' (or it may be 'users') and look for entries that mention registration. (The question of descending is field specific, most (all) sql field types can be sort ascending or descending)