$language[MSG5]"; include("administration/db_params.php"); $sql = "SELECT profile_id FROM $tab_profile WHERE name ='Guest';"; $con = mb_db_connect(); $res = mb_db_execute($con,$sql); if(mb_db_fetch_row($res)){ $guest_profile_id = mb_db_result($res,0,"profile_id"); } mb_db_free_result($res); $sql = "SELECT container.container_id, container.abstract FROM container "; $sql .= "INNER JOIN container_profile ON container.container_id = container_profile.container_id "; $sql .= "WHERE container_profile.profile_id = '".$guest_profile_id."' "; $sql .= "ORDER BY abstract"; $res = mb_db_execute($con,$sql); $counter = 0; while(mb_db_fetch_row($res)){ echo "

"; echo "".mb_db_result($res,$counter,"abstract").""; echo ""; echo ""; echo ""; echo ""; echo "

"; $counter++; } mb_db_free_result($res); echo "

$language[MSG6]

"; $dir_handle = opendir('language/'); while ($file = readdir ($dir_handle)) { if ($file != "." && $file != "..") { $path = "language/". $file; $basename = basename($path,".txt"); if($basename != $lingo){ echo "".$basename." | "; } } } closedir($dir_handle); ?>