how can change the order of language flags? in 1.5.6

[matteosalvati]

i want change the order of flags in languages block.

 

i want IT language in first position

 

Can help me?

[CartExpert.net]

Hi.

 

You either set up position changing (like it is for products, categories etc.) or you add a number prefix to the language, order them by name and strip the prefix.

 

Regards.

Robin.

The CartExpert Team

[matteosalvati]

is not possible order languages by name

[CartExpert.net]

It is possible to order them by name, you need to change the SQL query in loadLanguage().

 

Regards.

Robin.

The CartExpert Team

[matteosalvati]

excuse me but i'm not php expert , where is?

[CartExpert.net]

It is in 'classes/Language.php'. You'll need to override the class.

 

Regards.

Robin.

The CartExpert Team

[vekia]

there is an sql query:

		$sql = 'SELECT l.*, ls.`id_shop`
				FROM `'._DB_PREFIX_.'lang` l
				LEFT JOIN `'._DB_PREFIX_.'lang_shop` ls ON (l.id_lang = ls.id_lang)';

it's necessary to add there ORDER BY clause,

something like:

		$sql = 'SELECT l.*, ls.`id_shop`
				FROM `'._DB_PREFIX_.'lang` l
				LEFT JOIN `'._DB_PREFIX_.'lang_shop` ls ON (l.id_lang = ls.id_lang) 
                ORDER BY l.name DESC
                ';

[matteosalvati]

is possible to reverse the order?  without renaming

because i don't like "1. italian"

 

the original order is EN FR IT, would be sufficient to reverse the order to: IT FR EN.

 

which rule can be used?

[matteosalvati]

if add "ORDER BY l.name DESC;" rule, the site don't work

[CartExpert.net]

Post the function.

 

Regards.

Robin.

The CartExpert Team

[matteosalvati]

public static function loadLanguages()

{

self::$_LANGUAGES = array();

 

$sql = 'SELECT l.*, ls.`id_shop`

FROM `'._DB_PREFIX_.'lang` l

LEFT JOIN `'._DB_PREFIX_.'lang_shop` ls ON (l.id_lang = ls.id_lang)';

ORDER BY l.name DESC;

 

$result = Db::getInstance()->executeS($sql);

foreach ($result as $row)

{

if (!isset(self::$_LANGUAGES[(int)$row['id_lang']]))

self::$_LANGUAGES[(int)$row['id_lang']] = $row;

self::$_LANGUAGES[(int)$row['id_lang']]['shops'][(int)$row['id_shop']] = true;

}

}

[vekia]

compare my code with yours  you missed one important thing, you pasted order by clause outside the query.

[matteosalvati]

well, now work! i ordered by id_lang and now is the order that i want!

 

 

public static function loadLanguages()

{

self::$_LANGUAGES = array();

 

$sql = 'SELECT l.*, ls.`id_shop`

FROM `'._DB_PREFIX_.'lang` l

LEFT JOIN `' . _DB_PREFIX_ . 'lang_shop` ls ON (l.id_lang = ls.id_lang)

ORDER BY l.id_lang DESC' ;

 

$result = Db::getInstance()->executeS($sql);

foreach ($result as $row)

{

if (!isset(self::$_LANGUAGES[(int)$row['id_lang']]))

self::$_LANGUAGES[(int)$row['id_lang']] = $row;

self::$_LANGUAGES[(int)$row['id_lang']]['shops'][(int)$row['id_shop']] = true;

}

}

 

more thanks

[matteosalvati]

a question, is possible order by "language_code"?

 

adding line: ORDER BY l.language_code DESC

 

i could add a number prefix in language code and order that, 

so I will not have to change the name.

 

is correct?

[vekia]

sure you can, just use:

ORDER BY l.language_code DESC;

[matteosalvati]

i can't modify name of language_code.

 

I solved it differently, I added a column in the DB to called "ID_order", I assigned values corresponding to the order language. 

and after I added line 

 

ORDER BY l.ID_order ASC;

 

Is correct? or adding a column could be a problem?

[CartExpert.net]

Not as such, but every time you add a language you will need to set that value. Only if you've set it not to be NULL.

 

Regards.

Robin.

The CartExpert Team

Edited February 10, 2014 by CartExpert.net (see edit history)

[matteosalvati]

you're right. i can set in descending order, so when I add other languages, this will always be in last position because will have 0 as value

[vekia]

in my opinion it's enough, this solution will work,

in fact, you probably don't add new language everyday so chaning value of order field in back office will not be a problem

[CartExpert.net]

Yes, that's right

 

Regards.

Robin.

The CartExpert Team

[vvalen1977]

hi, i tried change the query, but doesn't work, try cleaning the cache of prestashop, and the browser but not success.

 

My query is correct:

 

$sql = 'SELECT l.*, ls.`id_shop, l.name`

FROM `'._DB_PREFIX_.'lang` l

LEFT JOIN `'._DB_PREFIX_.'lang_shop` ls ON (l.id_lang = ls.id_lang) ORDER BY l.name';

 

But doesn't work, i tried to run this query directly in MYSQL and it worked, but in the PHP of prestashop don't worked.

 

Can help me?

[matteosalvati]

This work:

 

$sql = 'SELECT l.*, ls.`id_shop`
                FROM `'._DB_PREFIX_.'lang` l
                LEFT JOIN `'._DB_PREFIX_.'lang_shop` ls ON (l.id_lang = ls.id_lang)
ORDER BY l.name DESC
';

 

 

 

maybe you forgot DESC or ASC?

 

 

 

[vvalen1977]

Thanks Matteos

 

In MySQL if you not write nothing for default is ASC, anyway indicating ASC or DESC does not work, and order always by id_lang

 

=(

[vekia]

the question is: where you changed it?

and in addition, you use default theme? 

a lot of things depend on this

[vvalen1977]

1) i changed this in: classes/Language.php

2) I am not using the default theme, but the query only existed in root directory, in my theme directory does not exist.

 

=)

[vekia]

so i bet that your theme displays languages based on different queries, or even on different module.

are you 100% sure that your theme uses default block languages block? and that .tpl file of this addon uses the same code as original one?

[vvalen1977]

Wow!.... in the "classes" directory, there was another "classes", on each of them was a "Language.php" file. 

 

The change had to do in "classes/classes/Language.php". 

 

It works! thanks =)