"proof-of-concept" Revolution Online Open Dictionary at revcoders.org

Josh Mellicker josh at dvcreators.net
Fri Nov 2 12:55:36 EDT 2007

Hi Andre,

I was working with a name approach, but terms like:


and so on were NOT URL friendly! And causing problems getting to  
pages in a browser. (I thought about renaming these "dollar sign",  
"at symbol", etc, but that's too weird)

So last night I switched to a number based page name...

You are right, with .htaccess we could write lines of rewrite rules  
that would translate, that would be nice, for now I have a simple  
lookup table that you can get this way:

     put "SELECT post_title, ID from wp_posts WHERE post_type =  
'post' ORDER BY post_title" into tSQL
     put send2db(tSQL) into tData
     replace "rowstart!|" with empty in tData

With the 'send2db' handler you're good to go.

This returns a list of term name & "|" & post number...

On Nov 2, 2007, at 9:18 AM, Andre Garzia wrote:

> Hello Devin et al,
> To make this work well with Rev is fairly easy if we take a simple
> approach. I don't know what WIKI  Josh is using but if he could have a
> unique URL to retrieve an HTML page for the comments for a given
> keyword then we could simply make a little RevBrowser window to
> display it.
> I was thinking about something like:
> revcoders.org/wiki/vScroll/comments   --> returns an HTML with the
> comments for vScroll.
> Also I've noticed that on revcoders.org the pages are named with
> numbers, like 384.xml, is there a way to change that? It makes harder
> to cross link stuff from outside the wiki. If this can't be changed
> from inside wordpress, then, one can write a simple CGI and some
> entries in .htaccess file to make those smart URLs work, I have done
> this kind of work before.
> Cheers
> andre
> On 11/2/07, Devin Asay <devin_asay at byu.edu> wrote:
>> Great work, Josh!
>> But we seem to have two competing (and very similar) efforts going
>> on. There is Björnke's very nice BvG Docu stack that was recently
>> patched by Andre to allow web notes to be posted and displayed in the
>> stack. See <http://andregarzia.com/docuwebnotes.html>. I've been
>> using Andre's patched version, and it's really quite slick.
>> Would there be a way to combine the best of both worlds, to let
>> Björnke/Andre's project work with your online database, Josh?
>> Björnke's stack, being older, is farther along than yours, and that
>> would free you up to concentrate on the web/backend pieces.
>> Devin
> -- 
> http://www.andregarzia.com All We Do Is Code.
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> Please visit this url to subscribe, unsubscribe and manage your  
> subscription preferences:
> http://lists.runrev.com/mailman/listinfo/use-revolution

More information about the Use-livecode mailing list