Order pictures alphabetically Options

[tommie]

Hi,

Is it possible to change the order in which the pictures are shown in the gallery??

In which file is that info/data stored so I can manually change it?

[CharlyG]

yes !
look in display.php
order is by date
if you wish a classification alphabetically, replaces "date" by "title".
ex. :

CODE

$statement = "SELECT pid, file_name, ROUND(file_size/1024) AS fsize, file_type, title, keywords, DATE_FORMAT(date, '%M %e, %Y') AS d, pic_width, pic_height, keywords, approved, category, counter FROM {$config['table_prefix']}pictures WHERE category='$searchquery' AND approved='1' ORDER BY date DESC";

change :

CODE

$statement = "SELECT pid, file_name, ROUND(file_size/1024) AS fsize, file_type, title, keywords, DATE_FORMAT(date, '%M %e, %Y') AS d, pic_width, pic_height, keywords, approved, category, counter FROM {$config['table_prefix']}pictures WHERE category='$searchquery' AND approved='1' ORDER BY title DESC";

if it is well what you seek to do....

[tommie]

Thanks, but if I have uploaded a lot op pictures, and I want to add 1 picture somewhere in the middle of a gallery, how do I do that? Where does Zenith Picture Gallery store the upload dates?

[usr.c]

Hi tommie,

As CharlyG pointed out, dates are stored in the table 'pictures' in a column of type 'datetime'. If you want to display the result differently then all you can do is sort on a different column. If you want to insert a picture somewhere in the middle of a category, then you can change its date in 'pictures'.

[tommie]

Tnx!
Well I think you kinda noticed... I'm a newbie with scripts...

So the dates are in a table in mysql? How do I edit that? And with what kind of program? Please explain...

[usr.c]

I'm sure your host provides some way to edit your databases. Otherwise, give phpMyAdmin a try: http://www.phpmyadmin.net/home_page/

[usr.c]

In v0.9.4, look in functions/f_global.php for

CODE

$statement .= "cid=category  AND {$config['table_prefix']}categories.cshow=1 ORDER BY date DESC LIMIT {$config['lastadded_perpage']}";

and replace it with

CODE

$statement .= "cid=category  AND {$config['table_prefix']}categories.cshow=1 ORDER BY date DESC, title DESC LIMIT {$config['lastadded_perpage']}";

Then look in display.php for

CODE

$statement .= "ORDER BY date DESC, pid DESC";

and replace it with

CODE

$statement .= "ORDER BY title ASC, pid DESC";

Then for

CODE

$statement .= "ORDER BY date DESC";

and replace it with

CODE

$statement .= "ORDER BY title ASC";

That's it.

[Dennis Evertse]

Is it possible to make this dynamic?

That visitor can choose between ordering by date and by title?

[usr.c]

Yep, it's possible

[Dennis Evertse]

Is it hard to do/explane?

[usr.c]

I can't promise a date, but as soon as I get some free time I'll go through all the feature requests including this one and post the mod for them if no one has already done that.

[Dennis Evertse]

I have a Better Idea,

in the CP, there is a permissions tag under the categories. you can choose there if you want to show the categories to all.

I would love to be able to choose form there if you want the categories Ordered by Date or by name.

I'm asking a lot of mod's, my apologies , but this is the one I need the most so please can somebody help me?

[Usher]

I think I've got what you're looking for here. I have created a mod that will allow you to select the default sort field (and second field) from the admincp. See the attached file for what was changed. I would recommend first sort order by Picture Title to achieve alphabetical arrangement. Note that you can also sort by number of views, so popular files show up first.

Cheers!

~Usher

Attached File(s)

 Sort_type_mod.txt ( 7.51K ) Number of downloads: 78

 

[Dennis Evertse]

Thank You very Much, But how does this work?

Do I need to add the things witch are written between add en end add??

[Usher]

That is correct, you should read the txt file as follows:
diff statement (old file) (new file) <- Get what file you need to edit from here
Lines leading into change
...
+ Add the code that follows the plus signs
...
Lines following the change

Next file to change
-------------------------

Use the lines leading up to the change as words to search for in the text file, so that you put the new code in the correct locations, and make sure that you put the code in exactly as it appears.
I would recommend backing up both your database and the files that will change before making these changes, just as a precaution.

Good luck!

I'm going to see if I can find a good way to have the end user able to sort.....might not get to it today though.