Re: Arabizing Arabeyes website (Todo)

["Ahmad Twaijry" <msx at hush dot com>]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1



On Sun, 02 Nov 2003 21:10:08 -0800 Youcef Rabah Rahal <yrrahal42 at hotmail dot com>
wrote:
>Salam,
>
>>From: "Ahmad Twaijry"
>>Subject: Re: Arabizing Arabeyes website (Todo)
>>Date: Sun,  2 Nov 2003 14:35:13 -0800
>>
>>Even if I use gettext I must do some change in the SQL statment
>in php
>>files
>
>Well, of course. But this should be done somewhere in the beginning
>(when
>the language is chosen) so that the correct tables are used for
>queries.
>That way you will change minimially the PHP queries inside the code.
>
>The Arabic tables should be the exact copy of those in english.
>In fact
>maybe this could even be done without the need for new tables. Simply
>adding
>rows: like row1_en, row1_ar, row2_en, row2_fr? etc etc. If the corresponding
>>
>row does not exist, the website should display the default row (English?).


MySQL is the best :) You don't need to make columns for each language
(you mean columns right ?)  You just have to add one column for all the
languages , for example :

Before :

CREATE TABLE `example` (
`ID` INT UNSIGNED NOT NULL ,
`Name` VARCHAR( 40 ) NOT NULL ,
`Description` TEXT NOT NULL
);


After :

CREATE TABLE `example` (
`ID` INT UNSIGNED NOT NULL ,
`Name` VARCHAR( 40 ) NOT NULL ,
`Description` TEXT NOT NULL ,
`Language` ENUM( 'en', 'ar', 'fr', 'de' ) NOT NULL
)

>
>This translation effort is not really complicated but should be
>done and
>thought delicately. I highly suggest that you go step by step :-
>) Also, it
>sounds to me that many people are working at the code now (which
>is a very
>good thing). Don't we need a bit of organization and plan however
>?
>
>>anyway can you give me any URL that talk about gettext and php
>?
>
>Well, google is your friend here (as usual :-)
>  http://www.google.com/search?hl=en&ie=UTF-8&oe=UTF-8&q=gettext
>
>Salam,
>
>Youcef.
>
>_________________________________________________________________
>MSN Search, le moteur de recherche qui pense comme vous !
>http://search.msn.fr/
>
>_______________________________________________
>Admin mailing list
>Admin at arabeyes dot org
>http://lists.arabeyes.org/mailman/listinfo/admin
>
>
- --------------------
http://eShop.4-SMS.Com
http://Mozilla.4-SMS.Com
- -*- If Linux doesn't have the solution, you have the wrong problem -*-
-----BEGIN PGP SIGNATURE-----
Note: This signature can be verified at https://www.hushtools.com/verify
Version: Hush 2.3

wkYEARECAAYFAj+njSAACgkQIIFs5Sdd9ZidygCcCgi1SCVa0qJ5rETvA+q1novBuNMA
oIqTSdxSewqtPx6aCdJzY2gnhT+i
=nukD
-----END PGP SIGNATURE-----