[Bug 2906] New: AppDB-Search is incomplete

[Wine Bugs]

http://bugs.winehq.org/show_bug.cgi?id=2906

Summary: AppDB-Search is incomplete
           Product: WineHQ Apps Database
           Version: unspecified
          Platform: All
               URL: http://appdb.winehq.org/
        OS/Version: All
            Status: NEW
          Severity: normal
          Priority: P2
         Component: website-bugs
        AssignedTo: [e-mail]
        ReportedBy: [e-mail]

While working at a rewrite of winetools (scriptable), I had a look at the AppDB,
found 2 bugs (Searching and noApps) and see Room for some improvements.
#####
The Bug in the Search-Function:

"http://appdb.winehq.org", enter "borland.com" and press "Search" : 0 match

(Not all fields in the appdb are used for "Search".)

"http://appdb.winehq.org", enter "borland" and press "Search" : 2 matches
a) 1292: "Borland C++"
b)   42: "Delphi"

Match a) has only VersionID=1722 (BCC Version 5.02), but the comments are about
the free commandline tools (BCC 5.5)

The Search-Function did not find:
c)  169: "C++Builder"

VersionID's for Match c):
c_1)  288: "5.0"
c_2) 1538: "5.5.1"
c_3) 1423: "6.0"

Another Example for similar Names, but in different categories.
1969: Games/"Need for Speed II"
1394: Games/Simulation Games/"Need for Speed III: Hot Pursuit"
1696: Games/Simulation Games/"Need for Speed Underground"
2040: Games/Sports Games/"Need for Speed Porsche Unleased"
2062: Games/Sports Games/"Need for Speed Underground II"

###
Another Bug is "noApps"
Example for Main/Games: noApps is "9"

What about "noApps" from every Sub-Category?
Add them, and noApps for Main/Games is >400.

##########
More Ideas for Improvements 
- Sort the Applications by Name in every Category

The only Entry for "Browse Apps" is "by Category". 
What about:
- Show Applications by Name
- Show Applications by Vendor (Author / Company)
- Show Applications by Votes
- Show Applications by URL

Above entries for: The complete AppDB, The actual (Sub-)Category

To keep the Menu "AppDB" small, please realize the extra DB-Entries as
additional categories:
Main/
     All Applications by Name/
     All Applications by Vendor/
     ....
     subcategory_1/
     subcategory_2/
     ....

Main/Games/
          All Games by Name/
          All Games by Vendor/
          ....
          subcategory_1/
          ....

--
By by ...
      ... Detlef