<?php
error_reporting(E_ALL ^ E_NOTICE ^ E_WARNING);
$include_dir = "./include";
$admin_dir = "../admin";
$template_dir = "../templates";
$settings_dir = "../settings";
$language_dir = "../languages";
$image_dir = "./images";
$prefix = '';
define("_SECURE",1); // define secure constant
require_once("$settings_dir/database.php");
include ("commonfuncs.php");
$media_id = trim(substr ($_GET['media_id'], 0, 6));
$db = trim(substr ($_GET['db'], 0, 1));
$prefix = trim(substr ($_GET['prefix'], 0, 20));
// if requested by Search-form, overwrite default db number
if ($db > 0 && $db <= 5) {
$dbu_act = $db;
}
// if requested by Search-form, overwrite default table prefix
if ($prefix != 0 ) {
$mysql_table_prefix = $prefix;
}
// get active database
if ($dbu_act == '1') {
$db_con = db1_connect() ;
$success = @mysql_select_db ($database1, $db_con);
$mysql_table_prefix = $mysql_table_prefix1;
}
if ($dbu_act == '2') {
$db_con = db2_connect() ;
$success = @mysql_select_db ($database2, $db_con);
$mysql_table_prefix = $mysql_table_prefix2;
}
if ($dbu_act == '3') {
$db_con = db3_connect() ;
$success = @mysql_select_db ($database3, $db_con);
$mysql_table_prefix = $mysql_table_prefix3;
}
if ($dbu_act == '4') {
$db_con = db4_connect() ;
$success = @mysql_select_db ($database4, $db_con);
$mysql_table_prefix = $mysql_table_prefix4;
}
if ($dbu_act == '5') {
$db_con = db5_connect() ;
$success = @mysql_select_db ($database5, $db_con);
$mysql_table_prefix = $mysql_table_prefix5;
}
// if requested by Search-form, overwrite default table prefix
if ($prefix) {
$mysql_table_prefix = $prefix;
}
$plus_nr = '';
@include "".$settings_dir."/db".$dbu_act."/conf_".$mysql_table_prefix.".php";
if (!$plus_nr) {
include "/admin/settings/backup/Sphider-plus_default-configuration.php";
}
if ($debug == '0') {
if (function_exists("ini_set")) {
ini_set("display_errors", "0");
}
error_reporting(0); // suppress PHP messages
}
require_once ("$language_dir/en-language.php");
if ($auto_lng == 1) { // if enabled in Admin settings get country code of calling client
if ( isset ( $_SERVER['HTTP_ACCEPT_LANGUAGE'] ) ) {
$cc = substr( htmlspecialchars($_SERVER['HTTP_ACCEPT_LANGUAGE']), 0, 2);
$handle = @fopen ("$language_dir/$cc-language.php","r");
if ($handle) {
$language = $cc; // if available set language to users slang
}
else {
include "$language_dir/$language-language.php";
}
@fclose($handle);
}
else {
include "$language_dir/$language-language.php";
}
}
require_once ("$language_dir/$language-language.php");
echo "<?xml version=\"1.0\" encoding=\"UTF-8\"?>
<!DOCTYPE html PUBLIC \"-//W3C//DTD XHTML 1.0 Transitional//EN\" \"http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd\">
<html xmlns='http://www.w3.org/1999/xhtml' xml:lang='en' lang='en'>
<head>
<meta http-equiv='Content-Type' content='text/html; charset=utf-8' />
<title>$mytitle. Media Info</title>
<link rel='stylesheet' type='text/css' href='$template_dir/$template/adminstyle.css' />
<script type='text/javascript' src='dbase.js'></script>
</head>
<body style='width:800px'>
<a name=\"head\"></a>
<div id='main'>
<h1 class='cntr sml'>Sphider-plus v. $plus_nr</h1>
";
// Get all information about current media object
$res=mysql_query("select * from ".$mysql_table_prefix."media where media_id like '$media_id'");
if ($debug > '0') echo mysql_error();
$num_rows = mysql_num_rows($res);
if ($num_rows <> '1') { // Nothing valid found
echo " <br />
<br />
<div class='cntr tblhead warnadmin' >
No ID3 / EXIF info found for this media object
</div>
";
footer();
echo " </body>
</html>
";
die('');
}
$media_info = mysql_fetch_row($res) ;
$medianame = str_replace("%20", ' ', substr($media_info[3], strrpos($media_info[3], '/')+1));
$id3 = array();
$id3_array = explode("<br />",$media_info[12]); // separate ID3 and EXIF data
$class = "evrow";
echo " <div class='panel cntr' style='width:450px'>
<p class='headline cntr sml'>Media Info (ID3 + EXIF) ".$sph_messages['for'].":</p><p class='headline cntr'>$medianame</p>
";
if ($media_info[12][0] == '') { // No ID3 tag indexed for this object
echo "
<br /><br />
<div class='cntr tblhead warn sml' >
<br />".$sph_messages['noEXIF']."
<br /><br />
</div>
<br>
<form class='left'>
<input type='submit' value='".$sph_messages['closewin']."' 'title='Return' onclick='window.close()'>
</form>
</body>
</html>
";
die('');
}
echo " <a class='navdown' href='#bottom' title='Jump to Page Bottom'>Down</a>
<table width='100%'>
<tr>
<td class='tblhead sml'>Section</td>
<td class='tblhead sml'>Name</td>
<td class='tblhead sml'>Value</td>
</tr>
";
foreach ($id3_array as $data) {
preg_match_all("/(.*?)>>(.*?);;(.*?)$/si", $data, $tags, PREG_SET_ORDER);
foreach ($tags as $meta ) {
if ($class =="evrow")
$class = "odrow";
else
$class = "evrow";
echo " <tr class='$class left sml'>
<td>$meta[1]</td>
<td> $meta[2]</td>
<td> $meta[3]</td>
</tr>
";
}
}
echo " </table>
<a class='navup' href='#head' title='Jump to Page Top'>Top</a>
<br />
<form class='left' action=''>
<input type='submit' value='".$sph_messages['closewin']."' title='Return' onclick='window.close()' />
</form>
</div>
</div>
<a name=\"bottom\"></a>
<p class='stats'><a href='http://www.sphider-plus.eu' title='Link: Visit Sphider-plus site in new window' target='rel'>Visit <img class='mid' src='images/sphider-plus-logo.gif' alt='Visit Sphider site in new window' height='39' width='42' /> Sphider-plus</a></p>
<br />
</body>
</html>
";
?>