Thank you TheOracle,
now the code for the new.php outside of 4imaes looks like this (see below)
I'm getting no error anymore, but the image_name still prints out somthing like Wasser[english]water ???
Multilang Imagenames and and Multilang Description on my whole 4images page is O.K.
But the random image an the newest on homepage are still not working.
What else can I do?
Thanks
Matthias
<?php
// PATH to your 4images Gallery / PFAD zu Ihrer 4images Gallerie
define('SCRIPT_URL', 'http://www.gpaed.de/bildergalerie/');
define('ROOT_PATH', '/www/htdocs/******/bildergalerie/');
include(ROOT_PATH.'config.php');
include(ROOT_PATH.'includes/db_mysql.php');
include(ROOT_PATH.'includes/constants.php');
include(ROOT_PATH.'includes/functions.php');
$site_db = new Db($db_host, $db_user, $db_password, $db_name);
$sql = "SELECT a.image_id, a.cat_id, a.image_name, a.image_active, a.image_thumb_file, a.image_hits
FROM ".IMAGES_TABLE." a, ".CATEGORIES_TABLE." b
WHERE a.image_active=1
AND a.cat_id = b.cat_id
AND b.auth_viewcat=".AUTH_ALL."
AND b.auth_viewimage=".AUTH_ALL."
ORDER BY image_date DESC
LIMIT 3";
$result = $site_db->query($sql);
while ($row = $site_db->fetch_array($result)) {
$image_id = $row['image_id'];
$cat_id = $row['cat_id'];
$image_name = multilang($row['image_name']);
$image_hits = $row['image_hits'];
$thumb_src = (is_remote($row['image_thumb_file'])) ? $row['image_thumb_file'] : SCRIPT_URL.THUMB_DIR."/".$cat_id."/".$row['image_thumb_file'];
echo "<a href=\"".SCRIPT_URL."details.php?image_id=$image_id\" target=_parent><img src=\"".$thumb_src."\" border=\"0\"></a>\n";
echo "<br><b>$image_name</b><br>\n";
echo "Hits: $image_hits<br><br>\n";
}
?>