+- ZenphotoCMS Forum (https://forum.zenphoto.org)
+-- Forum: Support (https://forum.zenphoto.org/forum-1.html)
+--- Forum: General support (https://forum.zenphoto.org/forum-4.html)
+--- Thread: New tags database structure (/thread-3870.html)
New tags database structure - edasque - 2008-10-02
Now what tags are separate from the entity they're applied to and have their own table structure, what should the following query become:
$imageWhere = " AND " . prefix('images') . ".show=1 AND " .prefix('images').".tags NOT LIKE \"%no.random%\"";New tags database structure - acrylian - 2008-10-02
Would you mind to tell us where you find that query or shall we search ourselves?..:-)
New tags database structure - edasque - 2008-10-03
Well, I had modified a Random Image piece of code so that it wouldn't display photos (and albums) that are tagged with no.random. That's so I could avoid displaying any of 500 pictures I took at the baseball game. I tag albums or photos that I don't want to be selected randomly with "no.random". I guess the query has to join that other table now, sql wizardry.