I did it... almost.
I'm making my site double language.
Why almost?
I did only for category names and changing language brings back to the home page.
Those are my steps:
MySQL> ALTER TABLE categories ADD name_XX varchar(100) NOT NULL;
rename snews.php snews_EN.php
copy snews_EN.php snews_XX.php
adding XX language variable to snews_XX.php
editing snews_XX.php, changing several "name" into "name_XX".
starting index.php with:
if (!isset($_SESSION['langx']) && !$_GET['lang'])
{$_SESSION['langx']="EN";
include('snews_EN.php');}
else{ if($_GET['lang'])
$_SESSION['langx']=$_GET['lang'];
include('snews_'.$_SESSION['langx'].'.php');}?>
and adding:
xxx EngYou can see here:
http://prosperi.ath.cx (it's often offline)
The only things that change are the language variable (already provided by snews) and the category names (that I inserted in the right side).
I'm going to complete my work in few days, writing a guide.
Leonardo
UPDATE:
I ended to update my web site (often offline because it is in my laptop that I switch off during the night GMT + 1). Those are all the mysql query to update the db:
ALTER TABLE categories ADD name_xx varchar(100) NOT NULL;
ALTER TABLE categories ADD description_xx varchar(255) NOT NULL;
ALTER TABLE articles ADD title_xx varchar(100) default NULL;
ALTER TABLE articles ADD text_xx longtext;
I'll publish a guide as soon as possible.
