A lot of stuff went in today... epic hacking day!

• Been getting hit with a lot of spam lately - added a new table "recentcomments", which stores a snapshot of recent comments - this'll help block spammers who are using the same IP addresses who've bypassed the TypePad spam filter and are hitting multiple sites. An initial few will get through, but the filter should catch them after that. I'll have to see how it works in practice. 
  • Added a new administrative CP function - ban spam IP address. Instead of hardcoding the spam IPs into the code, it's now stored in database. Every night, it's written to a PHP file so the array can be read quicker.
    
  • When a spammer's IP is detected, the hit log archives are also cleaned up.
    
• Category deletions are a bit cleaner now in the way they move entries. 
• Usericon deletions are cleaner - they will explicitly unassign iconid values on deletion.
  
• Default usericions are now stored as a part of the user table as well as in the usericon table - this optimizes a bunch of queries.
  
• Usernames can now be 32 characters long (fixes issues where the un-maxlengthed "change username" screen caused usernames to seem "lost", when they were simply truncated.
  
• Updated the UI of the "Content pages" in the control panel to include the privacy level
• Comments from guests which do not contain URLs are not linked.
  
• Default gravatar image has been replaced with a blank image (looks less obnoxious).
  
• Updated control panel's secondary nav to no longer use images, but text. (For future localization, as well as cutting out ~25K of CSS and ~40K of images)
• Moved the "Gallery" tab under "Extras". (Part of a future plan to bring more attention to the friends network, rather than the content)
• Added interests - searchable keywords to help bring users together.
  
• Added user directory - find users by gender, location, interests, and activity. The "friends" view will be collapsed into this view in the near future (default view of directory is already your friends' activities).
  
• Adding more places in code which updates the user's "last updated" status.
  
• Added "Delete Entry" into both under "Entry Tools" when viewing a single entry, as well as when you're editing a single entry.