06-09-2020, 12:24 PM
(This post was last modified: 06-09-2020, 12:26 PM by theclansmen.)
(03-09-2020, 10:55 PM)VisiGod Wrote: I've added a new sorting for audio and video (date and version). It will sort first by date (old to new) and if you have equal dates then sort by version (a to z). Is this what you were looking for?
Sorry mate, can you remove what you've added for this version issue?
i've done the updates on my current database : removing v. from all boots and leaving only INTEGER in the field (no more string) then i've altered the table to make this filed INT instead of VARCHAR.
and success, the bootlegs are ordered by DATE and VERSION (like 1,2,3,4,5,6,7,8,9,10,11,12...) and null if there is no version setted, just like i wanted.
it is possible to update the database the same way? maybe change the version field in the admin to make it a SELECT kind of field from 1 to 30 for example with null selected by default.