Piwigo.org

dummer-esel · 2017-05-16 00:07:33

Hello/Hi/Greetings,

I have a request to improve the search:

Currently, all photos are being displayed which can lead to a big mess if you have more than 2.000 photos (but a good album/category structure).

If I search for a word, I'd like to show only galleries in the results.
For example, look in names of the album "path" and also tags, but only display the album (including thumbnail and description) and maybe the path to the album (in case there are more sub-categories).

This would be an awesome feature. For now, I have the search function deactivated because it's useless with this quantity of photoes.

Piwigo version: 2.9.0
PHP version: any
MySQL version: any

Thanks!

dummer-esel · 2017-08-29 21:09:50

still a big wish on my list... maybe someone has a solution to this? :-)

executive · 2017-08-31 05:43:19

Should be possible with a simple SQL query. Just need someone with the time to do it.

dummer-esel · 2017-09-03 01:38:52

Like what? And where should I put the SQL query?
If you can give me an example, then I can maybe experiment with it... :-)

executive · 2017-09-03 05:39:40

That's all I can tell you without diving into the code. If I start deciphering the code then I might as well do it myself. :)

dummer-esel · 2017-09-03 11:42:08

And how do you know then that it's possible with a simple SQL query?

executive · 2017-09-03 20:43:57

You just want me to figure this out for you, don't ya? ;)

Last edited by executive (2017-09-03 20:45:30)

dummer-esel · 2017-09-03 20:44:50

That would be awesome! :-D

executive · 2017-09-03 20:49:42

But you need this function, not me. Logic suggests that you should invest the time. Do you have programming experience?

dummer-esel · 2018-09-24 12:03:35

executive wrote:
Do you have programming experience?

I have some basics in SQL and PHP... but have never done anything with Piwigo.

In the mysql database I created a query that returns the categories (albums) that have the word 'africa' in the name, plus afterwards the categories that have this word in the comments:

SELECT * FROM `850dS_categories` WHERE name LIKE '%africa%' UNION SELECT * FROM `850dS_categories` WHERE comment LIKE '%africa%'

Now, I guess it would be possible to get all the information to build this standard category box (with image, description, link, ...), however I hope that there already is some kind of funcion/template/?? within Piwigo?

And how can I add a search box and show these results in my gallery?

executive · 2018-09-26 05:40:06

Smartalbum extension

dummer-esel · 2018-09-26 15:04:04

executive wrote:
Smartalbum extension

I can't see how this extension solves the problem...?

executive · 2018-09-27 05:07:16

It allows you to create albums based on custom filters.

I thought it's what you meant by "show the results in my gallery". Sorry if I'm wrong.

Piwigo.org

Announcement

#1 2017-05-16 00:07:33

Search albums only

#2 2017-08-29 21:09:50

Re: Search albums only

#3 2017-08-31 05:43:19

Re: Search albums only

#4 2017-09-03 01:38:52

Re: Search albums only

#5 2017-09-03 05:39:40

Re: Search albums only

#6 2017-09-03 11:42:08

Re: Search albums only

#7 2017-09-03 20:43:57

Re: Search albums only

#8 2017-09-03 20:44:50

Re: Search albums only

#9 2017-09-03 20:49:42

Re: Search albums only

#10 2018-09-24 12:03:35

Re: Search albums only

executive wrote:

#11 2018-09-26 05:40:06

Re: Search albums only

#12 2018-09-26 15:04:04

Re: Search albums only

executive wrote:

#13 2018-09-27 05:07:16

Re: Search albums only

Board footer