appDB: Nice URLs live demo and code review

[John Klehm]

Give nice urls a whirl at:
http://appdb.klehm.net/app/"yoursearchtermhere"

Search Examples:
http://appdb.klehm.net/app/adobe
http://appdb.klehm.net/app/visual

Direct Link Examples:
http://appdb.klehm.net/app/photoshop
http://appdb.klehm.net/app/command-conquer-red-alert-2

See the nice urls being used internally:
http://appdb.klehm.net/appbrowse.php?iCatId=5


Right now as it is I have it indexing only the app family names; no
versions or vendors get any love.

There is one piece of functionality missing before this can go in and
that is to do an index of a new record upon creation.

If anyone wants to test just apply the patch set and then flip
APPDB_ENABLE_NICE_URLS_INDEXER to true and then run: runIndexer.php.
Be sure to flip enable indexer back to false before doing anything
else =P.

You also need to set allow_url_fopen = On in your php.ini.
If this is deemed to be unacceptable then we have to functionalize the
objectManager.php file so matchByVerbAndTerm can generate similar
output.  Using url fopen allows easiest integration.


After that you should be good to go to test.

Essentially less terms will work better and the matching "nice" name
depends entirely upon whatever the maintainer entered for the app
family name.

Let me know if any changes need be made otherwise ill send it in later
this week.

Regards,
John Klehm
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: 0001-htaccess-enable-rewrite-engine-and-provide-rule.patch.txt
Url: http://www.winehq.org/pipermail/wine-devel/attachments/20080407/a7c6e2da/attachment-0007.txt 
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: 0002-config.php-Add-global-switches-for-nice-urls-fu.patch.txt
Url: http://www.winehq.org/pipermail/wine-devel/attachments/20080407/a7c6e2da/attachment-0008.txt 
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: 0003-include-nice_urls.php-Util-functions-for-nice-u.patch.txt
Url: http://www.winehq.org/pipermail/wine-devel/attachments/20080407/a7c6e2da/attachment-0009.txt 
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: 0004-runIndexer.php-Script-that-indexes-existing-dat.patch.txt
Url: http://www.winehq.org/pipermail/wine-devel/attachments/20080407/a7c6e2da/attachment-0010.txt 
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: 0005-matchByVerbAndTerm.php-view-that-calls-into-the.patch.txt
Url: http://www.winehq.org/pipermail/wine-devel/attachments/20080407/a7c6e2da/attachment-0011.txt 
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: 0006-apidb.sql-Add-search-index-table.patch.txt
Url: http://www.winehq.org/pipermail/wine-devel/attachments/20080407/a7c6e2da/attachment-0012.txt 
-------------- next part --------------
An embedded and charset-unspecified text was scrubbed...
Name: 0007-include-application.php-if-nice-urls-are-on-the.patch.txt
Url: http://www.winehq.org/pipermail/wine-devel/attachments/20080407/a7c6e2da/attachment-0013.txt