spamreports

spamreports — Global. Stores content marked as spam by users when they delete it, for administrator review. A reported comment, user-to-user message, or community entry is copied into this table, by the LJ::mark_comment_as_spam, LJ::mark_as_spam, or LJ::mark_entry_as_spam function, respectively. The admin tool (/admin/spamreports.bml hinging on siteadmin:spamreports priv) allows spam report viewing: top 10 reported IPs, top 10 reported users (and showing if someone has received a spam warning before), last 10 reports, reports in last 1 hour, 6 hours, and 24 hours; the page supports sorting by open/closed. The 'spamreport_notification' hook exists for optionally notifying people about spamming. A maintenance task cleans out data older than 90 days. Please see also the tempanonips table.

spamreports

Column name Type Null Default Description
srid mediumint unsigned auto_increment    
reporttime int unsigned   0  
posttime int unsigned   0  
state enum('open','closed')   open  
ip varchar(15) YES  
journalid int unsigned   0  
posterid int unsigned   0  
report_type enum('entry','comment','message')   comment  
subject varchar(255) YES  
body blob    
Key name Type Column(s)
PRIMARY PRIMARY
ip INDEX
posterid INDEX
reporttime INDEX