Not signed in (Sign In)

Vanilla 1.1.10 is a product of Lussumo. More Information: Documentation, Community Support.

General Support: album sort order? disable slide show?

Bottom of Page

1 to 8 of 8

  1.  
    • CommentAuthorshutterbug
    • CommentTimeJan 19th 2006
     
    This is a very neat photo gallery program. I have only two concerns.
    1- Theres a two step process to get to albums. I want to setup my gallery whree theres one collection, called gallery, then many albums within that collection. (I can just hotlink straight to albums to fix the 2 step process).
    Ive tried changing the order of albums, but they are descending alphabertically, no matter what order I set in options.
    Ive tried date submitted, and every other option, but it doenst have any effect on album order. ???
    Is this a bug or is there a way to fix this?

    2- the slide show takes a very long time to load up. Id like to disable this feature if possible.

    Any coders out there that can help with this would be a big help.
    • CommentAuthorskeeboo
    • CommentTimeJan 25th 2006
     
    There is probably another better way of doing it but I'd probably just remove the text in the code for the Slide Show link. If people can't see it, they wont click on it :) Maybe in the next verion there will be a checkbox to shut this off in the options.

    Around line 660:
    $ss_tag = "<td><a href="$ss_url">View as Slideshow</a></td>";

    Edit it so it shows as:
    $ss_tag = "<td><a href="$ss_url"></a></td>";
    • CommentAuthorspydrman
    • CommentTimeMar 2nd 2006
     
    Has the album sort ever been fixed? I've been searching the forum for an hour and trying various things with no luck at all. . .
    •  
      CommentAuthormike
    • CommentTimeMar 3rd 2006 edited
     
    There is no way to change the sort order without changing code as of now. If you want to manually change this, try altering the query which controls the album list.

    Line 489 of gallery.php

    $sql = "SELECT * FROM `".$TABLE_PREFIX."albums` WHERE `parent_id` = '$id' AND id IN ($imlist) ORDER BY `name` DESC LIMIT ".$from.",".$config["thumb_num"];

    You can replace "ORDER BY `name` DESC" with

    • ORDER BY `name` ASC (Alphabetical A - Z)
    • ORDER BY `name` DESC (Alphabetical Z - A)
    • ORDER BY `id` ASC (Date added, oldest first)
    • ORDER BY `id` DESC (Date added, newest first)



    And probably some other stuff too if you want to get creative with the SQL.

    We have already added this option to the administrative panel for the next version. It will be much easier to change, promise =)
    • CommentAuthorspydrman
    • CommentTimeMar 4th 2006
     
    Sweet -- thank you. . .

    Worked like a champ.

    Jon
  6.  
    I tired your suggestion to get mine working now i am getting this error:

    You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '0,10' at line 1

    SELECT * FROM `plogger_albums` WHERE `parent_id` = '1' AND id IN (-1,1,8,10,11,12,13,14,17) ORDER BY `name` DESC 0,10
    • CommentAuthorarchon810
    • CommentTimeMay 28th 2006
     
    it looks like your LIMIT keyword disappeared, whositwhatnow. compare your query to the one above.
    • CommentAuthorredvers
    • CommentTimeJun 11th 2007 edited
     
    Hi Mike,

    Over a year later and this still doesn't appear to be a proper option, thankfully I found this as I was wondering how to hack it myself. Any idea when we may see this as a proper option (along with, if possible, a config option for whether EXIF info is shown or not by default?) :)

    Cheers,

    Kev

1 to 8 of 8

  1.