Adding a new parameter values list and use it

babynus wrote:

And how add an icone in the menu ?
I have created iconCountry16.png, iconCountry22.png and iconCountry32.png in view/css/images, but noting appears…

Update /css/projectorIcon.css

.iconCountry32 { background-image: url(images/iconCountry32.png);  background-repeat: no-repeat; width: 32px; height: 32px; }
.iconCountry22 { background-image: url(images/iconCountry22.png);  background-repeat: no-repeat; width: 22px; height: 22px; }
.iconCountry16 { background-image: url(images/iconCountry16.png);  background-repeat: no-repeat; width: 16px; height: 16px; }

babynus wrote:

there as many lines per country as number of languages used. At now, two :
Country code 'de' is for Germany, but with two lines (id, code, lang, name) :
121 de en Germany
122 de fr Allemagne
i.e. country is identified by code, not by line id.
In future, there could be added also, p.e.
487 de de Deutchland
503 de nl Duitsland
733 de es Alemania
999 de gr Γερµανία
etc.

You complicated much too much, and will have to code correct list.
Just single list with translatable name would be easier : just have to define field $_isTranslatable in the class

CREATE TABLE IF NOT EXISTS `currency` (
  `id` int(12) unsigned NOT NULL AUTO_INCREMENT,
  `code` varchar(3) DEFAULT NULL,
  `name` varchar(32) DEFAULT NULL,
  `idle` int(1) unsigned DEFAULT '0',
  PRIMARY KEY (`id`),
  KEY `currencyCode` (`code`)
) ENGINE=InnoDB  DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;

INSERT INTO `currency` VALUES(1, 'EUR', 'Euro', 0);
INSERT INTO `currency` VALUES(2, 'USD', 'US Dollars', 0);
INSERT INTO `currency` VALUES(3, 'AUD', 'Australian Dollar', 0);
INSERT INTO `currency` VALUES(4, 'CAD', 'Canadian Dollar', 0);
INSERT INTO `currency` VALUES(5, 'CHF', 'Swiss Franc', 0);
INSERT INTO `currency` VALUES(6, 'GBP', 'British Pounds', 0);
INSERT INTO `currency` VALUES(7, 'JPY', 'Japanese Yen', 0);
INSERT INTO `currency` VALUES(8, 'SEK', 'Swedish Krona', 0);

ALTER TABLE client ADD currency int(12) unsigned DEFAULT '0' ;

public $idCurrency;

babynus wrote:

… but still nothing, even after close/reopne session.
(no error in data, pictures OK, all checked)

Seems correct.
No idea why it does not work.

babynus wrote:

Where are the translations, then ? Must fill lang.js files ?

Yes

babynus wrote:

What values list table would be a good sample ?

Profile

babynus wrote:

Something is wrong, but models viewed seem similar… WTF ?

db field should be named idCurrency, not currency.

Jean-Luc wrote:

babynus wrote:

… but still nothing, even after close/reopne session.
(no error in data, pictures OK, all checked)

Seems correct.
No idea why it does not work.

Oops…
Too bad, but not blocking, so to be in-depth examinated later.

Jean-Luc wrote:

babynus wrote:

What values list table would be a good sample ?

Profile

OK. Have a look.
Not $_isTranslatable, but $_isNameTranslatable, no? Or $_isXxxxTranslatable?
I think I will first test with 'currency' table.