Wiki source for RichardBerg


Show raw source

Hi, I'm Richard Berg. While I'm using (stuck with?) 'Tavi for my [[http://www.avisynth.org | biggest wiki-site]], I use Wikka for my personal site. I post on far too many internet forums, so you might recognize me from one of the websites on my [[http://richardberg.net/FavoriteLinksCondensed | bookmarks]]. If not, I'm just that random guy who contributes a snippet of code now & then and complains a lot ;-)

Local pages I'm interested in:
WikkaTables
ImportUBB
DeleteSpam

email: arsmod@rb.net [spell out the domain]

1/22/05 - Spam help! I have apparently been attacked by an army of [[http://www.richardberg.net/RecentChanges | spam bots]]. Has this happened to anyone else? For now, I am asking for your help with:
- a SQL command that will delete all of these edits
- a SQL command that will change all of my ACLs to '+' for writing and commenting (I've modified the config file but that only affects new pages AFAIK)
&A small clarification: setting the ACL defaults in the config file applies to all existing pages -- that you have **not** set ACLs on. In other words, if you have not set any page ACLs, and then you change the default values, all pages will use the new default values. -- JsnX

Whatever script they used (on multiple machines, no less) could certainly be used against any Wakka-like site with minimal modifications, so something has to be done...I will do what I can to help you guys combat future attacks as well as implement the new [[http://www.google.com/googleblog/2005/01/preventing-comment-spam.html | HTML attribute]] you've probably all heard about.

1/23/05 - with much quick assistance, the immediate threat is gone :) The DeleteSpam tool that was graciously ported over has real potential...I'll see if I have the ability or time to make it more widely useful.
~&See also WikkaSpamFighting where I've now gathered all spam-related issues. --JavaWoman

1/05/08 - hi again. I was hit by a veritable flood of spam recently, much worse than before. I installed the experimental 1.1.6.4 branch in hopes of using the new AdminPages tool, but found it would only revert the most recent attack on each given page. Plus, it was really slow ;-) Since I had hundreds of pages that had each been hit dozens of times, I decided to just purge things at a database level. With some help, I put together these SQL scripts:
%%
-- delete most recent edits
DELETE FROM `wakka_pages`
WHERE `ID` > 4000

-- cleanup: set Latest flag back where needed
UPDATE `wakka_pages` a INNER JOIN (SELECT max(`ID`) as `ID`
FROM `wakka_pages`
GROUP BY `tag`) b
ON a.ID = b.ID
SET a.latest = 'Y'
%%

You'll need to adjust the ID # of the most recent edits, and probably your table prefix too. Hope someone finds these useful.

----
CategoryUsers
Valid XHTML :: Valid CSS: :: Powered by WikkaWiki