Order pictures alphabetically Options

[Dennis Evertse]

SuperB

It's a great mod, but not exact what I'm looking for. It would be even better if this Mod could be adjusted so that it is possible to choose a way of sorting for every category.

But that's much work i think....




OR, an extra sorting option:

Being able to sort on the "new" label (see this tread: http://cyberiapc.com/forums/index.php?show...amp;#entry46809 )

I would like to have the pictures with the new label on top followed by the remaining pictures sorted by date.


I'll try, maybe i can get it to work, but i do not think so..

This post has been edited by Dennis Evertse: Apr 23 2008, 07:52 PM

[Usher]

SuperB

It's a great mod, but not exact what I'm looking for. It would be even better if this Mod could be adjusted so that it is possible to choose a way of sorting for every category.

But that's much work i think....
OR, an extra sorting option:

Being able to sort on the "new" label (see this tread: http://cyberiapc.com/forums/index.php?show...amp;#entry46809 )

I would like to have the pictures with the new label on top followed by the remaining pictures sorted by date.
I'll try, maybe i can get it to work, but i do not think so..

Don't quite get what you mean by "so that it is possible to choose a way of sorting for every category". If you mean every time you look at a page you can choose the sort type, I'm going to see if that's possible, otherwise could you please specify?

As far as the 'new' label.....that shouldn't be hard, i'll see what i can do.

~Usher

[Usher]

Don't quite get what you mean by "so that it is possible to choose a way of sorting for every category". If you mean every time you look at a page you can choose the sort type, I'm going to see if that's possible, otherwise could you please specify?

As far as the 'new' label.....that shouldn't be hard, i'll see what i can do.

~Usher

For the 'New' label, i'm pretty sure looking through the code that that is a after SQL lookup check, and the sorting is currently being done on the SQL query, so if we can find a way to bubble up the new pictures, there may be a way. Or we could add a 'new pic' to the DB, but that wouldn't work too well.

[Usher]

Made a correction to my changes, my sort change overlooked one thing. When you have a picture open and click the next/previous links, it would go to the wrong picture. So I modified the pic_details.php to match.
Here is the newest version:

Attached File(s)

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

 

[Dennis Evertse]

Don't quite get what you mean by "so that it is possible to choose a way of sorting for every category". If you mean every time you look at a page you can choose the sort type, I'm going to see if that's possible, otherwise could you please specify?

As far as the 'new' label.....that shouldn't be hard, i'll see what i can do.

~Usher

My photoalbum looks like this:

Trucks:
- Scania
- Volvo
- Daf
- Mercedes
- .....
- .....

Cranes
Others
Machines
Heavy Haulage:
- Scania
- Volvo
- Daf
- ...
- ...

My idea is that you can choose from the ADMIN CP, which folders of the album are sorted by name, and which are sorted by date added.

For example:

I want Cranes to be sorted by title, but I want Trucks -> scania, volvo and daf to be sorted by date added..(newest on top).(A newest on top features would be great on it own, with this i mean that the photo's form the latest update are on top, and the rest is sorted by title)( http://cyberiapc.com/forums/index.php?showtopic=10657 )

Im hope you understand what I mean

I'm going to instal you new version right now

This post has been edited by Dennis Evertse: Apr 29 2008, 03:15 PM

[Dennis Evertse]

Double post..

This post has been edited by Dennis Evertse: Apr 29 2008, 11:05 AM

[Usher]

Hey Dennis,
This doesn't sound unreasonable as far as being possible. Basically we'd have to do some major changes that would include adding in a new table for your sorting orders, and probably add a new config page to update sort orders.
It would take me a while to take care of this for you, so if anyone wants to jump in and create this quickly, go ahead and post here, otherwise i think i could have something whipped up by next week. Only problem is that I'm not a very good php programmer yet, so I would not doubt that my fix will potentially have bugs.

I'll keep ya posted.

~Usher

[Usher]

Alright, whipped something basic up, gonna need someone with more experience in the zenith code to get you a nice GUI to change your sort orders (could be done easily using the admincp i think) You will have to create a new table in your database, of the convention <prefix>category_sort_orders. (so for me: zenith_category_sort_orders) and give it an int(6) index of 'cid', and 4 varchar values named 'sort_1', 'sort_1_order', 'sort_2', 'sort_2_order'. Then for each folder you want specific rules in, you'll have to create a new entry, with the matching cid from the categories table, and appropriate entries in the sort fields.
Valid entries are:
for sort_1 and sort_2:
pid, file_name, file_size, title, date, pic_width, pic_height, keywords (don't know if that'll work), ip, submitter, counter, rating
for sort_1_order and sort_2_order
DESC, ASC

Note that it may very well be case sensitive, i don't know.

Good luck, and please, if someone could help me finish this up, I'm tired, and won't work on this for the rest of the week.

~Usher

Attached File(s)

 Sort_type_mod_part_2.txt ( 2.42K ) Number of downloads: 73

 

[Dennis Evertse]

Isn't there anybody who can help me accept Usher (who has already done a great job )

[usr.c]

Thanks, Usher, for your work on the mod so far.

Dennis, I'll try my best to finish it up during the coming week.

[Dennis Evertse]

Any progress yet??

[usr.c]

Sorry for not keeping my promise. I'm probably not going to be able to work on this in the time being since I'm really tied up at work. Our main product is being released in less than a month so things are a bit hectic right now.

[Dennis Evertse]

No Problem,

I'm a patience man

[Dennis Evertse]

Still tied up at work?

[mefsteda73]

hi

it is not easy to order correctly the item in the menu because you have split by table and by view. So first there are the table items, then the view ones. More over, i cant place-out chart items as i want....

Thanks