CMS Made Simple Forums

b0n3m4n wrote: I'm sorry but I'm going on vacation tomorrow, so I'll be away for at least 2 weeks. When I come back I might find the time to commit the code but better not count on it. I'd be glad to help, but knowing me I'll simply forget.

Let's continue from here 2 weeks from now

------------------------------------------------------------------------
r336 | elijahlofgren | 2007-12-22 00:11:18 -0600 (Sat, 22 Dec 2007) | 6 lines

Fix bug: "[#1524] Reordering is broken" Reported here: http://dev.cmsmadesimple.org/forum/mess ... sg_id=1378 and partially fixed here: http://forum.cmsmadesimple.org/index.ph ... 040.0.html
A big thanks to Cerno for tracking down the source of this problem and supplying a partial fix!
Note: In order to make reordering work after upgrading, you must first unlist all Albums from
their categories (uncheck all "Category Listings:" for each Album) and *then* add the Albums back into the categories. This
will make the Albums be listed in the categories correctly so that they can be reordered properly.

------------------------------------------------------------------------

Thanks Cerno for your help in fixing this bug! 

Roland wrote: Having the same problem, I manually corrected the table cms_module_album_category_listings with phpMyAdmin
for already existing albums (in one category).... then it worked.

Field: listing_number to 0,1,2,3,...
(without the patch this field was not set correctly when album was created/added to the category)

Gregor wrote: Hello,

I update the two php-files as mentioned. I realy would like to sort the shown albums by Album-id. The way it is sorted by now, does not show logical to me. I expect, based on the following tag, the newest album shown first

Code: Select all

{cms_module module="album" lang="nl_NL" sortdesc="true"}

Changing true to false does not help.
http://www.uisge-beatha.eu/index.php?page=fotoalbum

Any help on this one is gretly appreciated!

Thanks for your time,
Gregor

{cms_module module="album" lang="nl_NL" sortdesc="true"}

   
rijen beginnend bij
in modus en herhaal kopregels na cellen
 
Sorteren op sleutel:
Volledige teksten album_id album_name album_number thumbnail_path comment column_number row_number template
Wijzigen Verwijderen 1 Koop 12 /Koop/thumb_Nikon 025.jpg NULL 5 4 Thickbox-with-next-prev-links
Wijzigen Verwijderen 3 Zeilen met Rob 7 /Zeilen met Rob/thumb_P1000860.JPG NULL 5 4 Thickbox-with-next-prev-links
Wijzigen Verwijderen 4 Voorbereiding 11 /voorbereiding/thumb_Buitenkant.jpg NULL 5 3 Thickbox-with-next-prev-links
Wijzigen Verwijderen 5 Workum naar Amsterdam 10 /Workum_Amsterdam/thumb_Haven_Enkhuizen.jpg NULL 5 3 Thickbox-with-next-prev-links
Wijzigen Verwijderen 6 Amsterdam naar Hellevoetsluis 9 /Amsterdam_Hellevoetsluis/thumb_Genaker_hijsen.jpg NULL 5 3 Thickbox-with-next-prev-links
Wijzigen Verwijderen 7 Hellevoetsluis naar Herkingen 8 /Hellevoetsluis_Herkingen/thumb_Gaan_we_of nog_nie... NULL 5 3 Thickbox-with-next-prev-links
Wijzigen Verwijderen 8 Setup Genaker 6 /Setup_Genaker/thumb_Setup_Genaker6.jpg NULL 5 3 Thickbox-with-next-prev-links
Wijzigen Verwijderen 9 Richting winterberging 5 /Winter2006/thumb_Winter2006_15.jpg   5 3 Thickbox-with-next-prev-links
Wijzigen Verwijderen 10 Boiler 4 /Winter2006/Boiler/thumb_boiler-1.jpg ... weggewerkt, of toch niet....
5 3 Thickbox-with-next-prev-links
Wijzigen Verwijderen 13 Herkingen-Ramsgate 3 /Ramsgate/thumb_Herkingen-Ramsgate14.jpg NULL 5 0 Thickbox-with-next-prev-links
Wijzigen Verwijderen 14 Zeilweekendje Grevelingen Zierikzee 2 /Zeilen_met_mafv/thumb_Zeilweekend_01sept07_41.jpg Het was een bewogen weekend 5 0 Thickbox-with-next-prev-links
Wijzigen Verwijderen 15 Clubwedstrijd sept.2007 1 /Clubwedstrijd/thumb_wedstrijd0709-4.jpg NULL 5 0 Thickbox-with-next-prev-links
Wijzigen Verwijderen 18 Zeilen in de Hagel 13 /Hagel_Schaken/thumb_Hagel en leren schaken-1.jpg NULL 5 0 Thickbox-with-next-prev-links
Met geselecteerd: Selecteer alles / Deselecteer alles Met geselecteerd: Veranderen Verwijderen Exporteer

function GetAlbums ($ids=false, $sortdesc=false, $category_id=false)
{
	global $gCms;
	$db = $this->GetDb();
	$config = $gCms->config;
	
	if ($category_id == false)
	{
		if ($ids===false || $ids=='')
		{
			$query = 'SELECT * FROM '.cms_db_prefix().'module_album_albums ORDER BY album_id';
			// was album_number
		}
		else
		{
			$query = 'SELECT * FROM '.cms_db_prefix().'module_album_albums WHERE album_id IN ('.$ids.') ORDER BY album_id';
			// was album_number
		}
	}
	else
	{