Advanced search  

News:

CPG Release 1.6.26
Correct PHP8.2 issues with user and language managers.
Additional fixes for PHP 8.2
Correct PHP8 error with SMF 2.0 bridge.
Correct IPTC supplimental category parsing.
Download and info HERE

Pages: [1]   Go Down

Author Topic: Auto arrange the categories by name  (Read 4571 times)

0 Members and 1 Guest are viewing this topic.

epsilon

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 95
    • http://www.cremita.com
Auto arrange the categories by name
« on: October 23, 2003, 12:08:40 am »

It will be cool that the categories will be arrange by name automatically because i have 40 categories and when i want create a new category i must up it 40 times, its too boring...
Logged

DJMaze

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Posts: 831
    • Dragonfly CMS
Auto arrange the categories by name
« Reply #1 on: October 23, 2003, 02:38:06 am »

in index.php change
Code: [Select]
$result = db_query("SELECT cid, catname, description FROM {$CONFIG['TABLE_CATEGORIES']} WHERE parent = '$parent'  ORDER BY pos");
into
Code: [Select]
$result = db_query("SELECT cid, catname, description FROM {$CONFIG['TABLE_CATEGORIES']} WHERE parent = '$parent'  ORDER BY pos, name");

didn't test this. but it should work
Logged
There are 2 kinds of users in this world: satisfied and complainers.
Why do we never hear something from the satisfied users?
http://coppermine-gallery.net/forum/index.php?topic=24315.0

epsilon

  • Coppermine regular visitor
  • **
  • Offline Offline
  • Posts: 95
    • http://www.cremita.com
No it doesent go...
« Reply #2 on: October 23, 2003, 08:27:20 pm »

When i create the new category (for example Amber) i the last, no the first by name.
Logged

DJMaze

  • VIP
  • Coppermine addict
  • ***
  • Offline Offline
  • Posts: 831
    • Dragonfly CMS
Auto arrange the categories by name
« Reply #3 on: October 27, 2003, 09:55:53 pm »

oops it must be

ORDER BY pos AND name
Logged
There are 2 kinds of users in this world: satisfied and complainers.
Why do we never hear something from the satisfied users?
http://coppermine-gallery.net/forum/index.php?topic=24315.0
Pages: [1]   Go Up
 

Page created in 0.016 seconds with 19 queries.