[MOD] TiltViewer for 4images

[Sun Zaza]

Ok then. the problen is sure by (ORDER BY RAND())

[janwinter]

Hey schaut Euch an, wie ich es auf meiner Seite gemacht habe!!!

http://www.profilfotografie.de/bilderband/index.php und dann in die Detailansicht, super mit Eurer Vorlage

Liebe Grüße aus Hamburg Jan

[RoadDogg]

Wo, das ist ja ein nettes Spielzeug!

Danke dir!

Schön wäre es natürlich noch, wenn man es von jeder einzelnen Kategorie aus für dieselbige aufrufen könnte... 

[mawenzi]

@RoadDogg

... und auch das lässt sich realisieren ...
... werde das mal im ersten Post als Erweiterung hinzufügen ...

[RoadDogg]

WOW!

Und eine Suchwortverknüpfung? wie: search.php?search_keywords=Nacht

 

P.S. Denke auch ans "Schlafengehen"...

[iPEI]

I put some html tag in image description, like <a></a> coz i wanna link to another details.php. Then... TiltViewer can't loading the content.

Bugs?

[mawenzi]

@iPEI
... Bugs? ... please read the Using Instructions of TiltViewer ... here ...

5. description is the description text. To include HTML formatting you need to wrap your description in a CDATA tag like this:

Code: [Select]

<description><![CDATA[This is a HTML text description.
Supported tags are <b>bold</b>, <u>underline</u>,
<i>italics</i>, linebreaks<br>and
<font color="#ff0000" size="60">font tags</font>.
Hyperlinks are not supported.]]></description>


[iPEI]

uupss... i miss that one.. thank you, guru

[Alessio]

Ok then. the problen is sure by (ORDER BY RAND())

Any solution?

[mawenzi]

Any solution?

... and what is your problem ... ?

[Alessio]

Any solution?

... and what is your problem ... ?

Hi Mawenzy,
if I use the code

Code: [Select]

WHERE i.image_active = 1 AND i.cat_id = 98 AND i.cat_id IN (".get_auth_cat_sql("auth_viewcat").")
        ORDER BY RAND()
        ";

some images loads twice.

[mawenzi]

... you don't use "LIMIT" in the query ... ?
... the "LIMIT" must be a multiple of the image settings of TiltViewer in viewer.html (columns x rows) ...
... if no, I think this caused that some images loads twice ...

[Alessio]

... you don't use "LIMIT" in the query ... ?
... the "LIMIT" must be a multiple of the image settings of TiltViewer in viewer.html (columns x rows) ...
... if no, I think this caused that some images loads twice ...

So the code could be

Code: [Select]

WHERE i.image_active = 1 AND i.cat_id = 98 AND i.cat_id IN (".get_auth_cat_sql("auth_viewcat").")
        ORDER BY RAND()
        LIMIT 0, 36
        ";

but I don't understand what number I have to insert.

[mawenzi]

... in your case ... "LIMIT 0, 36" ...

- 0   : the randomly selected images starts with Nr. 1 ...
- 36 : max. randomly selected images ...

... the "LIMIT" must be a multiple of the image settings of TiltViewer in viewer.html (columns x rows) ...

- you want to show 2sites of TiltViewer ? so ... 36 : 2 = 18 ...
- you want to show 3rows in TiltViewer (settings in viewer.html) ? so ... 18 : 3 = 6 ...  settings in viewer.html for columns must be 6 ...

so, now its time for your example in your TiltViewer ...

[Alessio]

I don't know if there's something wrong in my tiltviewer.php but images are still loading twice.

In "best photos" category I have 66 images, settings for viewer.html are 5rows and 5columns.
I have already tryed to put in LIMIT this numbers: 0, 66 - 0, 25 - 0, 75 - 0, 150.