Alright, perhaps I have gone totally insane now...
After getting my CPGNuke 8.2a up and running and after playing around with it for some time, I have this weird idea to make it completely bilingual.
You see, I need a site that speaks both german and english - no problem with CPGNuke. I can install the german language version (which I did, and even improve it because some characters showed up weird) give a dropdown to choose the language, and the site descriptions will change - I have already implemented that.
I can write articles and so on and give them either the option to be "english" or "german", and they will only show up if either language is chosen (if I have translated correctly . All up, running, wonderful and constantly getting more at: www.espe-design.de/nuke/index.php .
All great, so far, but...

A problem I have are:

the category titles;
the category descriptions;
the album titles;
the album descriptions;
the picture titles and
the picture descriptions.

(the comments do not matter - they can be either in english or german)

They appear the same in both languages, even if they would need to be different.

I do not know much about PHP and SQL, but I have thought about it and came to this workaround:

- for each corresponding table (these would be cms_cpg_albums, cms_cpg_categories and cms_cpg_pictures) I create two new rows in phpmyadmin:
title_e and description_e (for pictures, it would be caption_e; "e" would indicate that this would have to be the english version), having the same attributes that the "normal" versions of these rows have.
This would give the database the possibility to take more descriptions and differ between them, but still have them attributed to one category / picture / row.
This should work, I am sure.

But here is my problem:
As I have said, I do not know much about php. Ao I have almost no idea as to where I would have to put what (or rather, copy and add an "_e") so that I could use these additional database rows on the site, omplemented in the gallery, so that if the user chooses "german" as a language he/she would see the german titles & descriptions and when choosing "english" the english counterparts.
Basically, I need to be able to see both descriptions when I edit; which should not be too difficult nor confusing to anyone else (I will be the only one editing the content of the gallery).
But how do I "tell" the site that title_e and description / caption_e should only be used in the english version? Which templates do I have to modify, and where?
If anyone could tell me how to edit one template, I am quite certain that I can figure out how to edit the others as well; but of course I would need to know *which* templates *lol*.

I think that this project could not only be interesting to me, but perhaps also for future versions of cpgnuke - I am sure that I am not the only one who would like to have a *completely* bilangual PHPNuke...

So... hints, tips, ideas anyone...?

Thanks a lot in advance

plit the _pictures and _albums table by adding a new table which contains the description, title, etc.
That way you can have 650 languages for 1 image

however for selecting the correct field you need to compare it against $currentlang which contains english/german etc.

modules/coppermine/themes/default/album_admin_menu.inc
modules/coppermine/db_input.php
modules/coppermine/albmgr.php
modules/coppermine/catmgr.php

DJMaze wrote:

plit the _pictures and _albums table by adding a new table which contains the description, title, etc. That way you can have 650 languages for 1 image

Nah, that's not quite what I need... I do not speak or write 650 languages either, so how would I fill text into these descriptions...?

Just to clarify what I need / want, there are some pictures:

This is how my cms_cpg_albums table looks like now:



You will clearly see the two extra rows I have added which end with an _e.

Now what I *first* want to fill this table is something like this (this is a collague; this does not exist yet):

For editing an album, for example:



You see?

Now what do I have to change / insert *where* to make the editing site of an album (a category, a picture) to look like above?

Next step would be...

Quote::

however for selecting the correct field you need to compare it against $currentlang which contains english/german etc. modules/coppermine/themes/default/album_admin_menu.inc modules/coppermine/db_input.php modules/coppermine/albmgr.php modules/coppermine/catmgr.php

and it would be *great* if anyone could give me an example how I do that. One example would probably be enough; I am learning quite fast...

Thank you!

Does nobody have any hints for me ?
I thought that perhaps my question would have been more appropriate in the Coppermine Forum - perhaps one of the Mods can move it there?
I would so like to make these changes, but need a little starting help
In exchange, I could deliver a complete correction of the german language file, which is quite buggy....

Quote::

In exchange, I could deliver a complete correction of the german language file, which is quite buggy....

can't help you with your problem, but shouldn't you help this community with the german translation then if its buggy?
I'm doing it with the dutch one.

Alright,

<ironic>thanks a lot for the help</ironic>, by now I (almost) got it done to modify at least the "modifying" pages (albmgr, catmgr, editpics, editonepic) to let me enter a german and english description for title and description / caption of the picture, album or category in question. It does not look "beautiful", but it at least works; it does not have to be beautiful, as I am probably the only one who will ever look at the gallery this way.
I just say "learning by doing" and "excessive uploading, renaming and deleting" while doing said learning by doing.

What's still missing, however, is that if the user (that also means: non-registered users!) switches the language (as I have said, only two options available - either german or english), the coordinating fields in the database tables have to be changed from [nameofdatabasefield] to [nameofdatabasefield_e]; or more, the "_e" has to be taken away because standard language is set to english, and this is what the _e means.
This should *only* be visible on the albums, categories, picture pages, but *not* on the pages which are generated to modify the aforementioned, of course...

Is there a function that I can place perhaps in the header which would do that *without* touching the page whenever albmgr, catmgr, editpics or editonepic are involved? I am thinking about something like the "smiley replacer", which works in the boards...

Help, this time, anyone?

KokkieBlanda wrote:

Quote:: In exchange, I could deliver a complete correction of the german language file, which is quite buggy.... can't help you with your problem, but shouldn't you help this community with the german translation then if its buggy?

A day after your posting cpgnuke.de published a quite good and complete version of the language files, so...

Anyway, you're speaking of "help the community". Interesting.
To help *each other* is, as the phrase says, an *exchange* of help.
In my humble opinion it should not mean "ask for help, and you shall be asked for help in return instead of getting *any* replies".

But that's perhaps just me and my silly little opinion how the world should work...

Hello seven,

Quote::

You see, I need a site that speaks both german and english - no problem with CPGNuke. ... I can write articles and so on and give them either the option to be "english" or "german", and they will only show up if either language is chosen (if I have translated correctly . All up, running, wonderful and constantly getting more at: www.espe-design.de/nuke/index.php .

I need this same capability in Japanese and wanted to look at your German site as a reference, but when I try your link I get a user name/password box immediately, and so cannot access your site. If it is o.k. with you that I look at it, can you send me a PM with instructions on how to access it?

Thanks!