Piwigo.org

willy · 2011-02-20 16:27:17

My problem: Pictures from a web camera is fed into my server- they all start
with "camera" and are numbered 1-2048. I want them to be displayed 1 - 2 ..
2048 .. and to to that, I need a numeric sort (-n). Alfanumeric sort gives 1
- 10 - 1000 -1001 ,,,
Please help ..

P@t · 2011-02-20 16:57:49

Edit your local config file (with LocalFiles Editor plugin) and insert:

$conf['order_by'] = ' ORDER BY LENGTH(file), file ASC';
$conf['order_by_inside_category'] = $conf['order_by'];

willy · 2011-02-20 19:48:13

Thanks!! Works like a dream :)

plg · 2011-02-20 22:12:25

P@t wrote:
ORDER BY LENGTH(file), file ASC

Very smart!

NewbieX · 2014-10-29 12:05:39

Is this correct for more latest piwigo, such as 2.7.1 ?

$conf['order_by_custom'] = ' ORDER BY LENGTH(file), file ASC';
$conf['order_by_inside_category'] = $conf['order_by'];

Piwigo.org

Announcement

#1 2011-02-20 16:27:17

[resolved] numeric filesort

#2 2011-02-20 16:57:49

Re: [resolved] numeric filesort

#3 2011-02-20 19:48:13

Re: [resolved] numeric filesort

#4 2011-02-20 22:12:25

Re: [resolved] numeric filesort

P@t wrote:

#5 2014-10-29 12:05:39

Re: [resolved] numeric filesort

Board footer