<?php
// This gets the NFOs
$nfoq = mysql_query("SELECT * FROM ".$table['nfo|table']." WHERE ".$table['nfo|rls']."='$rls'");
while ($nfoentry = @mysql_fetch_array($nfoq)) {
$fn = StripFilename($nfoentry[$table['nfo|filename']]);
if ($config['gzippednfo'] == true) {
$tmpname=tempnam("", "NFOTMP");
$fh = fopen($tmpname, 'w');
fwrite($fh, $nfo['row'][$table['nfo|data']]);
fclose($fh);
$nfodata = gzfile_get_contents($tmpname);
unlink($tmpname);
} elseif ($config['mysqlgzippednfo'] == true) {
$nfodata = gzuncompress(substr($nfo['row'][$table['nfo|data']], 4));
} else {
$nfodata = $nfo['row'][$table['nfo|data']];
}
array_push($result['nfo|filename'], $fn);
array_push($result['nfo|data'], $nfodata);
$result['nfo||filename'] = $fn;
$result['nfo||data'] = $nfodata;
}
// This gets the SFVs
$sfvq = mysql_query("SELECT * FROM ".$table['sfv|table']." WHERE ".$table['sfv|rls']."='$rls'");
while ($sfventry = @mysql_fetch_array($sfvq)) {
$fn = StripFilename($sfventry[$table['sfv|filename']]);
if ($config['gzippedsfv'] == true) {
$tmpname=tempnam("", "SFVTMP");
$fh = fopen($tmpname, 'w');
fwrite($fh, $sfventry[$table['sfv|data']]);
fclose($fh);
$sfvdata = gzfile_get_contents($tmpname);
unlink($tmpname);
} elseif ($config['mysqlgzippedsfv'] == true) {
$sfvdata = gzuncompress(substr($sfventry[$table['sfv|data']], 4));
} else {
$sfvdata = $sfventry[$table['sfv|data']];
}
array_push($result['sfv|filename'], $fn);
array_push($result['sfv|data'], $sfvdata);
}
// This gets the M3Us
$m3uq = mysql_query("SELECT * FROM ".$table['m3u|table']." WHERE ".$table['m3u|rls']."='$rls'");
while ($m3uentry = @mysql_fetch_array($m3uq)) {
$fn = StripFilename($m3uentry[$table['m3u|filename']]);
if ($config['gzippedm3u'] == true) {
$tmpname=tempnam("", "m3uTMP");
$fh = fopen($tmpname, 'w');
fwrite($fh, $m3uentry[$table['m3u|data']]);
fclose($fh);
$m3udata = gzfile_get_contents($tmpname);
unlink($tmpname);
} elseif ($config['mysqlgzippedm3u'] == true) {
$m3udata = gzuncompress(substr($m3uentry[$table['m3u|data']], 4));
} else {
$m3udata = $m3uentry[$table['m3u|data']];
}
array_push($result['m3u|filename'], $fn);
array_push($result['m3u|data'], $m3udata);
}
// This gets the JPGs
$jpgq = mysql_query("SELECT * FROM ".$table['jpg|table']." WHERE ".$table['jpg|rls']."='$rls'");
while ($jpgentry = @mysql_fetch_array($jpgq)) {
$fn = StripFilename($jpgentry[$table['jpg|filename']]);
if ($config['gzippedjpg'] == true) {
$tmpname=tempnam("./", "jpgTMP");
$fh = fopen($tmpname, 'w');
fwrite($fh, $jpgentry[$table['jpg|data']]);
fclose($fh);
$jpgdata = gzfile_get_contents($tmpname);
unlink($tmpname);
} elseif ($config['mysqlgzippedjpg'] == true) {
$jpgdata = gzuncompress(substr($jpgentry[$table['jpg|data']], 4));
} else {
$jpgdata = $jpgentry[$table['jpg|data']];
}
array_push($result['jpg|filename'], $fn);
array_push($result['jpg|data'], $jpgdata);
}
// This gets the Covers
$coverq = mysql_query("SELECT * FROM ".$table['cover|table']." WHERE ".$table['cover|rls']."='$rls'");
while ($coverentry = @mysql_fetch_array($coverq)) {
$fn = StripFilename($coverentry[$table['cover|filename']]);
if ($config['gzippedcover'] == true) {
$tmpname=tempnam("./", "coverTMP");
$fh = fopen($tmpname, 'w');
fwrite($fh, $coverentry[$table['cover|data']]);
fclose($fh);
$coverdata = gzfile_get_contents($tmpname);
unlink($tmpname);
} elseif ($config['mysqlgzippedcover'] == true) {
$coverdata = gzuncompress(substr($coverentry[$table['cover|data']], 4));
} else {
$coverdata = $coverentry[$table['cover|data']];
}
array_push($result['cover|filename'], $fn);
array_push($result['cover|data'], $coverdata);
}
// This gets the Nukes
$nukeq = mysql_query("SELECT * FROM ".$table['nuke|table']." WHERE ".$table['nuke|rls']."='$rls'");
while ($nukeentry = @mysql_fetch_array($nukeq)) {
$fn = StripFilename($nukeentry[$table['nuke|filename']]);
if (!empty($fn)) {
if ($config['gzippednuke'] == true) {
$tmpname=tempnam("./", "nukeTMP");
$fh = fopen($tmpname, 'w');
fwrite($fh, $nukeentry[$table['nuke|data']]);
fclose($fh);
$nukedata = gzfile_get_contents($tmpname);
unlink($tmpname);
} elseif ($config['mysqlgzippednuke'] == true) {
$nukedata = gzuncompress(substr($nukeentry[$table['nuke|data']], 4));
} else {
$nukedata = $nukeentry[$table['nuke|data']];
}
array_push($result['nuke|filename'], $fn);
array_push($result['nuke|data'], $nukedata);
}
}