Searching downloads by Author

blith · Client Joined: Jul 18, 2003 Posts: 977

It does not seem to work. Can a field be added to search by author? I think this would be a good addition to the downloads module...

blith · Client Joined: Jul 18, 2003 Posts: 977

please delete I explained better in next post. Thanks

blith · Client Joined: Jul 18, 2003 Posts: 977

In downloads index find

Code:

$result = $db->sql_query("SELECT lid, cid, title, url, description, date, hits, downloadratingsummary, totalvotes, totalcomments, filesize, version, homepage FROM ".$prefix."_downloads_downloads WHERE title LIKE '%$query%' OR description LIKE '%$query%' ORDER BY $orderby LIMIT $min,$downloadsresults");

and add

Code:

name,

after

Code:

date,

and then add

Code:

OR name LIKE '%$query%'

after

Code:

OR description LIKE '%$query%'

then find

Code:

$fullcountresult = $db->sql_query("SELECT lid, title, description, date, hits, downloadratingsummary, totalvotes, totalcomments FROM ".$prefix."_downloads_downloads WHERE title LIKE '%$query%' OR description LIKE '%$query%' OR name LIKE '%$query%' ");

and add

Code:

OR name LIKE '%$query%'

after

Code:

OR description LIKE '%$query%'

SmackDaddy · Posted: Thu Jun 10, 2004 3:15 pm

Does this work for articles too? I am finding that when I look at a news article written by someone.....and click "read more by" that author, I get a search page, but when I try and search, it always sends me to that empty search page over and over no matter which options I choose..... Sad

blith · Client Joined: Jul 18, 2003 Posts: 977

I am not sure. If you could find those same lines in the articles module then I am sure it would.