Revision history for RichardBerg
Revision [23316]
Last edited on 2016-05-20 07:38:47 by RichardBerg [Replaces old-style internal links with new pipe-split links.]Additions:
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 ;-)
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:
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/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:
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.
Deletions:
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:
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.
Revision [19460]
Edited on 2008-01-28 00:16:18 by RichardBerg [Modified links pointing to docs server]No Differences
Revision [17896]
Edited on 2008-01-05 01:36:50 by RichardBerg [Modified links pointing to docs server]Additions:
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.
----
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.
----
Deletions:
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
----
Additions:
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
----
CategoryUsers
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
----
CategoryUsers
Deletions:
Additions:
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
Deletions:
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
----
CategoryUsers
Revision [5090]
Edited on 2005-01-24 14:00:46 by JavaWoman [turning Jsnx's comment into inline comment (and minor edit) :)]Additions:
&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
Deletions:
Additions:
- 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 default values. -- JsnX
Additions:
~&See also WikkaSpamFighting where I've now gathered all spam-related issues. --JavaWoman
Revision [5045]
Edited on 2005-01-24 10:08:24 by RichardBerg [adding reference to WikkaSpamFighting]Additions:
DeleteSpam
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.
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.
Additions:
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)
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.
- 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)
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.
