[libreoffice-website] Listing of all blog subdomains we have

2019-11-15 Thread William Gathoye
Hello everyone, The title says it all. Would it be possible to get a list of all WordPress blogs we are currently using for our multi site configuration? I have noted this: * English: https://blog.documentfoundation.org/ * French: https://fr.blog.documentfoundation.org/ * German: https://d

[libreoffice-website] Re: Listing of all blog subdomains we have

2019-11-15 Thread William Gathoye
As another request, would it be possible to give me the number of articles we have published on each WordPress sub-instance we have? Regards, -- William Gathoye -- To unsubscribe e-mail to: website+unsubscr...@global.libreoffice.org Problems? https://www.libreoffice.org/get-help/mailing-list

Re: [libreoffice-website] Listing of all blog subdomains we have

2019-11-15 Thread Guilhem Moulin
Hi wget, On Fri, 15 Nov 2019 at 12:48:38 +0100, William Gathoye wrote: > The title says it all. Would it be possible to get a list of all > WordPress blogs we are currently using for our multi site configuration? > […] > SELECT domain FROM wp_blogs WHERE public = 1 AND archived = 0 AND delete

Re: [libreoffice-website] Re: Listing of all blog subdomains we have

2019-11-15 Thread Guilhem Moulin
On Fri, 15 Nov 2019 at 12:54:06 +0100, William Gathoye wrote: > As another request, would it be possible to give me the number of > articles we have published on each WordPress sub-instance we have? ‘SELECT COUNT(*) FROM ${PREFIX}_posts WHERE post_type = 'post' AND post_status = 'publish';’ gives

Re: [libreoffice-website] Listing of all blog subdomains we have

2019-11-15 Thread William Gathoye
Hi Guilhem, Thanks a lot this greatly help. I didn't pay attention the same TLS certificate was being used. Indeed, I should have used that trick instead of annoying you with this :D For the number of articles, this would have been harder without your help though and I didn't want to scrape HTML l

Re: [libreoffice-website] Cooperation with other FOSS projects for Weblate migration

2019-11-15 Thread William Gathoye
On 12/11/2019 13:09, sophi wrote: > We are already in contact and cooperating, Jean-Baptiste in on the l10n > list and we are working together. As we are both on migrating period, we > are currently more in investigating phase than cooperation phase. Our > aim is to have a workshop all together at

Re: [libreoffice-website] Banner for switching languages on the LibreOffice website

2019-11-15 Thread William Gathoye
+1 for the idea of having simply a link leading to the NLC page. Listing languages on that bar is * not working nicely on mobile devices, especially portrait mode (like already specified) * some users may complain "with is language X appearing before that one" Just my two cents. Regards,

Re: [libreoffice-website] Banner for switching languages on the LibreOffice website

2019-11-15 Thread Mike Saunders
On 15/11/2019 15:45, William Gathoye wrote: > > +1 for the idea of having simply a link leading to the NLC page. Do you mean, some text like "Click here to view this site in other languages?" I'm not sure if that's the best approach -- it's just some more generic text on the page that visitors' ey

Re: [libreoffice-website] Banner for switching languages on the LibreOffice website

2019-11-15 Thread William Gathoye
On 15/11/2019 16:24, Mike Saunders wrote: > > Do you mean, some text like "Click here to view this site in other > languages?" I'm not sure if that's the best approach -- it's just some > more generic text on the page that visitors' eyes may skip over. Not really. More like what Apple does in thi

Re: [libreoffice-website] Banner for switching languages on the LibreOffice website

2019-11-15 Thread Mike Saunders
On 15/11/2019 17:20, William Gathoye wrote: > > I visit libreoffice.org and I have an user-agent with "fr", the banner > will be displayed and *in French* it will be displayed: > > "Your computer is defined in French, would you like to switch to the > French website? [DROP DOWN MENU]   [CONTINUE

Re: [libreoffice-website] Banner for switching languages on the LibreOffice website

2019-11-15 Thread Martin Srebotnjak
Sorry, guys & dolls, did anyone ask what the l10n teams want? Will getting four or five other languages into that bar really help anyone? In 2019 the browsers can, if the users do not surf anonymously, detect what country the click comes from, so why not redirecting the user to that language or s