[Solved]: Sort albums with swedish letters

aik_putte · September 13, 2008, 07:57:51 PM

I use swedish letters in my gallery and it works fine writing the letters and I use UTF-8 but I want to sort my albums that has swedish letters in them.
Our alphabet ends Y Z Å Ä Ö but the gallery thinks that Å and Ä comes after A and that Ö comes after O but that isn't the case, is there any way to fix that so albums that have swedish letters in them comes in the right order?

Nibbler · September 13, 2008, 09:01:09 PM

Set your database to use swedish collation (utf8_swedish_ci).

aik_putte · September 13, 2008, 09:16:07 PM

Where do I change that? In a .php-file?

Nibbler · September 13, 2008, 09:27:23 PM

Using phpmyadmin.

aik_putte · September 13, 2008, 09:41:16 PM

It didnt make any difference, do I have to do anything else?

Nibbler · September 13, 2008, 10:24:18 PM

Try changing the collation of the title field in the albums table.

aik_putte · September 13, 2008, 10:28:28 PM

That didnt help either, the album which has swedish letters moved to the beginnig instead of the end but in the Album-list where you create new albums the album is at the bottom, which is right.

Nibbler · September 13, 2008, 10:41:09 PM

The album manager is not sorted by name anyway. Post a link to your gallery.

aik_putte · September 13, 2008, 10:42:19 PM

http://www.phbuss.se/bussbilder/album/index.php?cat=3
Here you can see, Bäckströms Trafik should be last.

aik_putte · September 14, 2008, 01:10:54 PM

No other ideas?

Joachim Müller · September 14, 2008, 02:24:41 PM

As Nibbler already pointed out, albums are not being sorted alphabetically, but in the order you create them in album manager. You appear to be using a custom hack. Post a reference to the hack you used (the URL of the thread that explains the mod applied)

aik_putte · September 14, 2008, 02:32:21 PM

I dont remember which threads hack I used but this is the custom things I made in theme.php, this was to make the categorylist to three columns and moving the menu to the bottom.

Code Select

// HTML template for the category list
$template_cat_list = <<<EOT
<!-- BEGIN header -->
        <tr>
        <tr>
                <td class="tableh1" width="25%"><b>{CATEGORY}</b></td>
                <td class="tableh1" width="4%" align="center"><b>{ALBUMS}</b></td>
                <td class="tableh1" width="4%" align="center"><b>{PICTURES}</b></td>
				<td class="tableh1" width="26%"><b>{CATEGORY}</b></td>
                <td class="tableh1" width="4%" align="center"><b>{ALBUMS}</b></td>
                <td class="tableh1" width="4%" align="center"><b>{PICTURES}</b></td>
				<td class="tableh1" width="25%"><b>{CATEGORY}</b></td>
                <td class="tableh1" width="4%" align="center"><b>{ALBUMS}</b></td>
                <td class="tableh1" width="4%" align="center"><b>{PICTURES}</b></td>
        </tr>
        </tr>
<!-- END header -->
<!-- BEGIN catrow_noalb -->
                <td class="catrow_noalb" colspan="3"><table border="0"><tr><td align="left">{CAT_THUMB}</td><td align="left"><span class="catlink"><b>{CAT_TITLE}</b></span>{CAT_DESC}</td></tr></table></td>
<!-- END catrow_noalb -->
<!-- BEGIN catrow -->
                <td class="catrow" align="left"><table border="0"><tr><td>{CAT_THUMB}</td><td><span class="catlink"><b>{CAT_TITLE}</b></span>{CAT_DESC}</td></tr></table></td>
                <td class="catrow" align="center">{ALB_COUNT}</td>
                <td class="catrow" align="center">{PIC_COUNT}</td>
				
<!-- END catrow -->
<!-- BEGIN footer -->
        <tr>
                <td colspan="9" class="tableh1" align="center"><span class="statlink"><b>{STATISTICS}</b></span></td>
        </tr>
<!-- END footer -->
<!-- BEGIN spacer -->
        <img src="images/spacer.gif" width="1" height="7" border="" alt="" /><br />
<!-- END spacer -->

EOT;

function theme_display_cat_list($breadcrumb, &$cat_data, $statistics)
{
    global $template_cat_list, $lang_cat_list;
    if (count($cat_data) > 0) {
        starttable('100%');
        $template = template_extract_block($template_cat_list, 'header');
        $params = array('{CATEGORY}' => $lang_cat_list['category'],
            '{ALBUMS}' => $lang_cat_list['albums'],
            '{PICTURES}' => $lang_cat_list['pictures'],
            );
        echo template_eval($template, $params);
    }

    $template_noabl = template_extract_block($template_cat_list, 'catrow_noalb');
    $template = template_extract_block($template_cat_list, 'catrow');
	
	
    $count=0;
    $columnCount=3; 
    echo "<tr>";	
	
    foreach($cat_data as $category) {
		If ($count%$columnCount==0) {
		    echo "</tr><tr>";
		}
        $count++;
        if (count($category) == 3) {
            $params = array('{CAT_TITLE}' => $category[0],
                    '{CAT_THUMB}' => $category['cat_thumb'],
                '{CAT_DESC}' => $category[1]
                );
            echo template_eval($template_noabl, $params);
        } elseif (isset($category['cat_albums']) && ($category['cat_albums'] != '')) {
            $params = array('{CAT_TITLE}' => $category[0],
                '{CAT_THUMB}' => $category['cat_thumb'],
                '{CAT_DESC}' => $category[1],
                '{CAT_ALBUMS}' => $category['cat_albums'],
                '{ALB_COUNT}' => $category[2],
                '{PIC_COUNT}' => $category[3],
                );
            echo template_eval($template, $params);
        } else {
            $params = array('{CAT_TITLE}' => $category[0],
                '{CAT_THUMB}' => $category['cat_thumb'],
                '{CAT_DESC}' => $category[1],
                '{CAT_ALBUMS}' => '',
                '{ALB_COUNT}' => $category[2],
                '{PIC_COUNT}' => $category[3],
                );
            echo template_eval($template, $params);
        }
    }
	echo "</tr>";
    if ($statistics && count($cat_data) > 0) {
        $template = template_extract_block($template_cat_list, 'footer');
        $params = array('{STATISTICS}' => $statistics);
        echo template_eval($template, $params);
    }


    if (count($cat_data) > 0)
          endtable();
        echo template_extract_block($template_cat_list, 'spacer');
}



// Function for writing a pageheader
function pageheader($section, $meta = '')
{
    global $CONFIG, $THEME_DIR;
    global $template_header, $lang_charset, $lang_text_dir;

    $custom_header = cpg_get_custom_include($CONFIG['custom_header_path']);

        $charset = ($CONFIG['charset'] == 'language file') ? $lang_charset : $CONFIG['charset'];

    header('P3P: CP="CAO DSP COR CURa ADMa DEVa OUR IND PHY ONL UNI COM NAV INT DEM PRE"');
        header("Content-Type: text/html; charset=$charset");
    user_save_profile();

    $template_vars = array('{LANG_DIR}' => $lang_text_dir,
        '{TITLE}' => $CONFIG['gallery_name'] . ' - ' . strip_tags(bb_decode($section)),
        '{CHARSET}' => $charset,
        '{META}' => $meta,
        '{GAL_NAME}' => $CONFIG['gallery_name'],
        '{GAL_DESCRIPTION}' => $CONFIG['gallery_description'],
        '{CUSTOM_HEADER}' => $custom_header,
        );

    echo template_eval($template_header, $template_vars);
}

// Function for writing a pagefooter
function pagefooter()
{
    //global $HTTP_GET_VARS, $HTTP_POST_VARS, $HTTP_SERVER_VARS;
    global $USER, $USER_DATA, $ALBUM_SET, $CONFIG, $time_start, $query_stats, $queries;;
    global $template_footer;

    $custom_footer = cpg_get_custom_include($CONFIG['custom_footer_path']);

    if ($CONFIG['debug_mode']==1 || ($CONFIG['debug_mode']==2 && GALLERY_ADMIN_MODE)) {
    cpg_debug_output();
    }

    $template_vars = array(
        '{CUSTOM_FOOTER}' => $custom_footer,
	 '{SYS_MENU}' => theme_main_menu('sys_menu'),
        '{SUB_MENU}' => theme_main_menu('sub_menu'),
        '{ADMIN_MENU}' => theme_admin_mode_menu(),
        '{VANITY}' => (defined('THEME_IS_XHTML10_TRANSITIONAL') && $CONFIG['vanity_block']) ? theme_vanity() : '',
    );

    echo template_eval($template_footer, $template_vars);
}



?>

If they are not sorted alphabetically, can I sort the albums manually without changing the order of the categories and the images inside the albums?

aik_putte · September 15, 2008, 06:43:06 PM

Can I sort the albums manually without changing the categories and pictures?

Nibbler · September 16, 2008, 07:22:02 PM

Yeah, that's what the arrows are for in the album manager.

aik_putte · September 16, 2008, 07:54:14 PM

Quote from: Nibbler on September 16, 2008, 07:22:02 PM
Yeah, that's what the arrows are for in the album manager.

And yet nothing happens when I move them around with the arrows...
The categories was moveable but not the albums, can I change something in Settings so I can move the albums? I only find the options to move categories and thumbnails.

Nibbler · September 16, 2008, 07:56:45 PM

Do they move up and down in the interface? Do you get a javascript error message?

Post a link and test account with upload rights.

aik_putte · September 16, 2008, 07:59:54 PM

Quote from: Nibbler on September 16, 2008, 07:56:45 PM
Do they move up and down in the interface? Do you get a javascript error message?

Yes, they stay where I put them in the list but in the albumview they stay alphabetically.
I dont get any error message, only this which confirms my change.

Uppdaterar album '113' med titel 'Byberg & Nordins Busstrafik' och index '143'
Uppdaterar album '87' med titel 'Bäckströms Trafik' och index '144'

In english:
Updating album '113' with titel 'Byberg & Nordins Busstrafik' and index '143' etc.

Nibbler · September 16, 2008, 08:02:10 PM

Can you enable debug mode in config and paste the debug output you get from http://www.phbuss.se/bussbilder/album/index.php?cat=3

aik_putte · September 16, 2008, 08:04:20 PM

Do you mean this?

Code Select

Nibbler · September 16, 2008, 08:11:32 PM

Did you modify index.php? If so, upload a clean copy.

coppermine-gallery.com/forum

News:

[Solved]: Sort albums with swedish letters

aik_putte

Nibbler

aik_putte

Nibbler

aik_putte

Nibbler

aik_putte

Nibbler

aik_putte

aik_putte

Joachim Müller

aik_putte

aik_putte

Nibbler

aik_putte

Nibbler

aik_putte

Nibbler

aik_putte

Nibbler