[TxMt] Linking commands updated

[Allan Odgaard]

On 11. Mar 2007, at 13:24, Brett Terpstra wrote:

> This is an updated version of the Yahoo bundle, renamed and  
> packaged to include the two Wikipedia commands revised to use link  
> builder templates.  I revised the templates one more time to allow  
> for insertion as snippets with just the title being set up for  
> immediate editing.  I changed all of the bundled commands to Insert  
> as Snippet.

Great, thanks! I am going to add this bundle to the repository and  
set you up with an account, let me know if you have a preferred  
username for svn.

> I included the simplest version of my modified google lucky linking  
> command that grabs the title of the retrieved link, I can't  
> remember how you guys felt about that, so do what you will with it.

I think adding the title is good -- one problem with the command  
though is, that response.to_hash['location'] returns an array (of  
URLs), not a string. I’ll just add ‘.first’, but want to ensure you  
see the same behavior.

> [...]
> My most useful (to me) blog linking commands require my related  
> post xmlrpc Wordpress plugin, but if there's any interest, they  
> allow for searching of your posts by selected text or input box,  
> linking selected text to related posts on your blog, etc.  Those  
> commands haven't been updated for the link builder yet, but will be  
> if it's added to the default distro.
>
> http://blog.circlesixdesign.com/download/relatedposts-rpc/

I think this sounds useful -- though of course should go into the  
Blogging bundle. Not sure how Brad feels about adding commands for  
not just specific blog systems, but specific plug-ins for specific  
blog systems ;)

That said, I had a few problems with the command. Initially it gave  
me an error from WordPress, because the SQL sent did not have a limit  
argument (i.e. it did specify LIMIT, but no numeric value for it) --  
I took the SQL expression (from the error) and ran that (with a LIMIT  
of 5) and then got: Can't find FULLTEXT index matching the column  
list. Do I need to maybe update the db schema/run some SQL magic to  
get such index?