Reverse the order of the albums?

[mattoz22]

Hi,

I have added around 80 albums to my gallery.... Due to the way I added them currently it losts the oldest at the top and the newest at the bottom of the page.

Is there any easy way to make the gallery reverse the order of the albums? I dont want to use the admin panel to manually change the order of over 80 albums, I simply need it to reverse the order...

?

Thanks for any help! (have searched and not found what I need)..

[mattoz22]

Nobody?

[Joachim Müller]

are those 80 albums all in one category (or no category at all)? This is overkill, I recommend giving your site some structure that makes sense, instead of just reversing chaos (as you will still get chaos no matter what). As a nice side-effect, it'll get easier to change the order in the albums manager. Post a link to your site if you want detailed recommendations. After all, post the link anyway please.
If you really need just the reverse, you could come up with a mod that reverses the order in the code that displays index.php, however I recommend running a query once that does this.

[mattoz22]

Due to the nature of the site I do only have one category....

Here it is... www.ozziness.com

I would rather put something into the code somewhere to simply reverse it, if thats somehow possible?

[Stramm]

OK, in index php find in the function list_albums()

Code Select Expand

' ORDER BY a.pos '.
and replace with

Code Select Expand

' ORDER BY a.pos DESC '.

the second occurance doesn't matter cause you don't use cats: That should do

[Abbas Ali]

As GauGau already said you have two options. First changing the query on index.php which retrieves the album data from database and second running a query/script for once which will change the positions of albums directly in the database. Both the methods are explained below.

Method 1 (Chaning query on index.php)
Edit index.php

Replace

Code Select Expand


$sql = 'SELECT a.aid, a.title, a.description, visibility, filepath, '.
           'filename, url_prefix, pwidth, pheight '.
           'FROM '.$CONFIG['TABLE_ALBUMS'].' as a '.
           'LEFT JOIN '.$CONFIG['TABLE_PICTURES'].' as p '.
           'ON a.thumb=p.pid '.
           'WHERE category='.$cat.$album_filter.
           ' ORDER BY a.pos '.
           $limit;


with

Code Select Expand


$sql = 'SELECT a.aid, a.title, a.description, visibility, filepath, '.
           'filename, url_prefix, pwidth, pheight '.
           'FROM '.$CONFIG['TABLE_ALBUMS'].' as a '.
           'LEFT JOIN '.$CONFIG['TABLE_PICTURES'].' as p '.
           'ON a.thumb=p.pid '.
           'WHERE category='.$cat.$album_filter.
           ' ORDER BY a.pos DESC '.
           $limit;


Method 2 (Changing the pos in database)
Do take a backup of albums table before running this code

Create a new script reverse.php with following code and place the script in coppermine root folder.

Code Select Expand


<?php
define('IN_COPPERMINE', true);
define('LOGOUT_PHP', true);
require('include/init.inc.php');
if (!GALLERY_ADMIN_MODE) {
  cpg_die(ERROR, $lang_errors['perm_denied'], __FILE__, __LINE__);
}
$query = "SELECT count(aid) AS count FROM {$CONFIG['TABLE_ALBUMS']}";
$result = db_query($query);
$row = mysql_fetch_assoc($result);
$albCount = $row['count'];

$query = "SELECT pos,aid, title FROM {$CONFIG['TABLE_ALBUMS']} ORDER BY pos ASC";
$result = db_query($query);
while ($row = mysql_fetch_array($result)) {
  $newPos = 100 + $albCount;
  $aid = $row['aid'];
  $sql = "UPDATE {$CONFIG['TABLE_ALBUMS']} SET pos = '$newPos' WHERE aid = '$aid'";
  $albCount--;
  $update = db_query($sql);
  if ($update) {
    echo "Album '{$row['title']}'  =>   Old pos={$row['pos']}  New pos=$newPos<br>";
  }
}
?>


After creating the script run it once. This will reverse the order of your albums. After successfully reversing the order of albums i recommend deleting the script.

NOTE:

• Apply only any one method
• Before doing any changes through the script, do take a backup of albums table
• Run the script as admin

Abbas

P.S: Stramm already posted the first solution when i was composing this message. Anyways i am still posting.

[mattoz22]

Thank you both so much for your time. Both methods worked perfectly.

I editted index.php as a quick fix but will eventually get around to doing it the proper way... and hey one day I might even use categories

[calvin123]

Hi, I tried your changes and they work perfectly, but to make it a consistent solution I would
propose that you also change the "list_cat_albums"-function and reverse the order albums
are displayed on the main-page.

I added at the end of the "sql"-string also a "ORDER BY pos DESC" - now it looks as follows:

$sql = "SELECT a.aid, a.title, a.description, visibility, filepath, " . "
           filename, url_prefix, pwidth, pheight " . "
           FROM {$CONFIG['TABLE_ALBUMS']} as a " . "
           LEFT JOIN {$CONFIG['TABLE_PICTURES']} as p
           ON thumb=pid " . "WHERE category = '$cat' ORDER BY pos DESC " . "$limit";

Greetings Stefan
P.S.
(Sorry for my bad english, but I'm a little bit out of training)