A Series Of SQL Queries:
DELETE content FROM content,metadata WHERE content.version=metadata.version and content.name=metadata.node and metadata_type='comment' and metadata_value='Some grammatical corrections'
DELETE node FROM node,metadata WHERE node.version=metadata.version and node.name=metadata.node and metadata_type='comment' and metadata_value='Some grammatical corrections'
DELETE metadata FROM metadata,metadata as metadata2 WHERE metadata.version=metadata2.version and metadata.node=metadata2.node and metadata2.metadata_type='comment' and metadata2.metadata_value='Some grammatical corrections'
This, for me, seems to have deleted the "Some grammatical corrections"
spam I just got on the Open Guide to Boston. Someone more experienced
with SQL taking a look at these would be much appreciated.
Of course, it's probably better to do this via $wiki->fetch_node,
delete_node, etc. but I've never been one for doing things the right way
-- I prefer the quick way.
MyOpenguidr even? ;-)
nice logo, Earle.
Knowledge Media Institute
The Open University
Milton Keynes, UK
From: openguides-dev-bounces(a)openguides.org on behalf of Adam Auden
Sent: Mon 4/10/2006 6:30 AM
To: OpenGuides software developers' list
Subject: Re: [OGDev] Two Point Oh
On 4/10/06, Earle Martin <openguides(a)downlode.org> wrote:
> I couldn't resist.
Openguidr perhaps? :)
Adam Auden - UNIX Metal Geek
OpenGuides-Dev mailing list - OpenGuides-Dev(a)openguides.org
JibberJim, in #swhack, was wondering how easy it would be to create a
guide that aggregated all the locations with decent wifi into one place.
(seeAlso blog entry on same topic.)
OpenGuides is a good software solution to this, given a few tweaks:
Specifically, tweaking the fields such that there is a city (state in
some cases) and country metadata field.
After that, an aggregator would need to be built, to allow for moving
the data that already exists in some categories on other guides (wifi,
free wifi) into the 'wifi' guide.
Implementation details are being handwaved here, in part because I'm not
the biggest master of the code -- what do other people think about this?
I think ivorw has the best knowledge of a mirroring process, I know how
to add additional metadata fields (although I'm not convinced I know the
*best* way to do it, just *a* way), and I'm sure that 'we' as the
OpenGuides team would be willing to participate in adminiship of such a
This would also be a good oppourtunity to test our aggregation ability
for the purposes of building an interface at OpenGuides.org that allows
people to search worldwide for something, rather than just in each
guide, something that I think has been discussed before.
Anyone else interested in this project?
Boston uses a dropdown to allow you to select from existing
categories/locales. I do this via a CGI::Wiki::Plugin module (attached:
summariser.pm) and some changes to wiki.cgi (also attached, although
that patch has some cruft.) The categories are then iterated in the
I'm not sure what the best way to do this is, but I'd like to see it
pulled into the core, because more than one person has asked for it, and
it'll be one less thing for me to maintain on my own.
What's a better way to do this? Anyone have any suggestions?
The Boston Guide has a few macros that aren't in the general
distribution. The most interesting of these is a macro to create links
to Flickr images from [[Image:FlickrID]] links.
It requires some mucking with configuration to set up a flickr key and
flickr secret -- these come from Flickr when you sign up for an API key.
The diff between svn and boston's OpenGuides::Utils are attached. These
are things that I will attempt to eventually clean up and get into the
main tree, but right now they're just hacks, and may cause problems. No
warranty or support, etc. etc., but if you want help getting something
working, you can reply on-list or privately and I'll try and help you
out. (Might even motivate me to clean up my code.)