MLP - The Multi-Lingual Publishing Pack

tye · 2011-08-25 13:21:29

For the first time I have to look into this plugin seriously and wanted to check that I have the correct versions installed. – Sorry – it confused me :(

I’ve got

txp:4.4.1
l10n · 4.3.0.12

Is that right?

redbot · 2011-08-25 13:40:54

tye wrote:

Is that right?

Ok!

YannigR · 2011-08-25 19:33:41

I am having problems with the main page of my website. This is a site that used to be working well when it was monolingual. The default language is English and when I access the main page it works (ie it access article 17. ) (see http://www.grafito-words.com or http://www.grafito-words.com/en) When it is another language (either through the url http://www.grafito-words.com/fr or accessing it with a French / Spanish browser) I don’t get the main content of my page. This is what output the main content:

<txp:if_individual_article> 
                 <txp:article form ="static_article" />
 <txp:else /> 
                <txp:article id="17" form ="static_article" />
 </txp:if_individual_article>

I thought that this was pretty standard but my google fu is not quite good enough to find somebody who had the same issue. I can see why this is problematic (id = “17” refers to an article in English) but i can’t think of a way to go round this. I suspect that I am missing something fairly obvious.

Any suggestion?

els · 2011-08-25 19:35:59

Yes, I think someone did this before. Give me a moment and I’ll try and find the post.

johnstephens · 2011-08-25 19:45:17

You could use smd_query to get content from the l10n_txp_en_us table. You can even output the content using Textpattern’s article tags by using the populate="article" attribute in smd_query.

Trying to get English content from the textpattern table does not work.

els · 2011-08-25 19:45:25

YannigR, here is a similar question, and it was solved by using smd_query and something like the first block of code here.

Can you figure it out from there? If not, let me know :)

Edit: ah, johnstephens can tell you all about it ;)

Last edited by els (2011-08-25 19:47:10)

johnstephens · 2011-08-25 19:50:12

At a glance, it looks like the l10n_txp_en_us table uses the same article IDs as the textpattern table, so this might work:

<txp:smd_query
	populate="article"
	column="*,
	     unix_timestamp(Posted) as uPosted,
	     unix_timestamp(LastMod) as uLastMod,
	     unix_timestamp(Expires) as uExpires"
	table="l10n_txp_en_us"
	where="ID = '17'"><txp:output_form form="static_article"/></txp:smd_query>

Edit: Removed limit attribute from the smd_query tag, since you should have only one match. I copied it rather hastily from my own implementation, which was an article list.

Last edited by johnstephens (2011-08-25 19:55:42)

YannigR · 2011-08-25 19:50:56

That is an impressively quick reply, thank you!

I am going to look into it and will let you know how I get on.

johnstephens · 2011-08-25 19:53:03

I just saw the code Els posted, and it reminded me of a proviso: The table you query depends on what regional variation of English you’re using as the default. I’m in the US, so mine is l10n_txp_en_us, but yours might be l10n_txp_en_gb or something else. Hope this helps!

els · 2011-08-25 19:57:37

John, now that I see your code again, I have a question for you. Why is this part needed:

	     unix_timestamp(Posted) as uPosted,
	     unix_timestamp(LastMod) as uLastMod,
	     unix_timestamp(Expires) as uExpires"

All the times I have used smd_query I’ve never added this. What does it do?

johnstephens · 2011-08-25 20:04:42

I think it’s a vestige of using smd_query to query the textpattern table, and I guess it might not be needed when querying the l10n_lang tables— but it doesn’t seem to hurt. If memory serves, querying the textpattern table without those items causes problems, accompanied by error messages when looking at the site in debug mode.

els · 2011-08-25 20:08:00

Thank you, John. That might explain why I’ve never needed it, I realise now that I only use the plugin to query the l10n_lang tables.

Textpattern CMS

Textpattern CMS support forum

#1849 2011-08-25 13:21:29

Re: MLP - The Multi-Lingual Publishing Pack

#1850 2011-08-25 13:40:54

Re: MLP - The Multi-Lingual Publishing Pack

#1851 2011-08-25 19:33:41

Re: MLP - The Multi-Lingual Publishing Pack

#1852 2011-08-25 19:35:59

Re: MLP - The Multi-Lingual Publishing Pack

#1853 2011-08-25 19:45:17

Re: MLP - The Multi-Lingual Publishing Pack

#1854 2011-08-25 19:45:25

Re: MLP - The Multi-Lingual Publishing Pack

#1855 2011-08-25 19:50:12

Re: MLP - The Multi-Lingual Publishing Pack

#1856 2011-08-25 19:50:56

Re: MLP - The Multi-Lingual Publishing Pack

#1857 2011-08-25 19:53:03

Re: MLP - The Multi-Lingual Publishing Pack

#1858 2011-08-25 19:57:37

Re: MLP - The Multi-Lingual Publishing Pack

#1859 2011-08-25 20:04:42

Re: MLP - The Multi-Lingual Publishing Pack

#1860 2011-08-25 20:08:00

Re: MLP - The Multi-Lingual Publishing Pack

Board footer