"Nintendo DS",
"54" => "Nintendo DSi",
"53" => "Nintendo DSi (DLC)",
"64" => "Nintendo 3DS",
"79" => "Nintendo 3DS (DLC)",
);
// If we're in generate mode
if ($gen == "1")
{
// Copied these from generate.php
$version = date("YmdHis");
$datname = $systems[$system].' Scene Releases';
$header = "
".htmlspecialchars($datname)."
".htmlspecialchars($datname)." (".$version.")
The Wizard of DATz
".$version."
".$version."
The Wizard of DATz
\n";
$footer = "";
// Make the page ready for output
ob_end_clean();
header('content-type: application/x-gzip');
header('Content-Disposition: attachment; filename="'.$datname.' ('.$version.').xml.gz"');
echo gzencode($header, 9);
// Retrieve all of the games, sorted by release date and name
$query = "SELECT * FROM releases
WHERE system=".$system."
ORDER BY released, game";
$result = mysqli_query($link, $query);
if (gettype($result) != "boolean" && mysqli_num_rows($result) > 0)
{
$roms = mysqli_fetch_all($result, MYSQLI_ASSOC);
$ext = ($system < 60 ? "nds" : "3ds");
// Now output the roms
foreach ($roms as &$rom)
{
// Check for blank CRC and MD5
$rom["crc"] = ($rom["crc"] == "0" || $rom["crc"] == "" ? "00000000" : strtolower($rom["crc"]));
$rom["md5"] = ($rom["md5"] == "0" || $rom["md5"] == "" ? "d41d8cd98f00b204e9800998ecf8427e" : strtolower($rom["md5"]));
$state = "\t\n".
"\t\t".$rom["released"]."_".$rom["game"]."\n".
"\t\t\n".
"\t\n";
echo gzencode($state, 9);
}
}
echo gzencode($footer, 9);
die();
}
// If we have a system, we will get the information for it
elseif ($system != "")
{
echo "Scene Information Log
\n";
$vals = array();
// Populate vals
if ($system == "28")
{
for ($i = 0; $i <= 6623; $i++)
{
$vals[] = str_pad($i, 4, "0", STR_PAD_LEFT);
}
for ($i = 1; $i <= 165; $i++)
{
$vals[] = "z".str_pad($i, 3, "0", STR_PAD_LEFT);
}
for ($i = 1; $i <= 3; $i++)
{
$vals[] = "xB".str_pad($i, 2, "0", STR_PAD_LEFT);
}
for ($i = 1; $i <= 197; $i++)
{
$vals[] = "x".str_pad($i, 3, "0", STR_PAD_LEFT);
}
}
elseif ($system == "54")
{
for ($i = 1; $i <= 9; $i++)
{
$vals[] = str_pad($i, 4, "0", STR_PAD_LEFT);
}
for ($i = 1; $i <= 1; $i++)
{
$vals[] = "z".str_pad($i, 3, "0", STR_PAD_LEFT);
}
}
elseif ($system == "53")
{
for ($i = 1; $i <= 393; $i++)
{
$vals[] = str_pad($i, 4, "0", STR_PAD_LEFT);
}
}
elseif ($system == "64")
{
for ($i = 0; $i <= 1552; $i++)
{
$vals[] = str_pad($i, 4, "0", STR_PAD_LEFT);
}
for ($i = 1; $i <= 11; $i++)
{
$vals[] = "z".str_pad($i, 3, "0", STR_PAD_LEFT);
}
for ($i = 1; $i <= 48; $i++)
{
$vals[] = "x".str_pad($i, 3, "0", STR_PAD_LEFT);
}
}
elseif ($system == "79")
{
for ($i = 0; $i <= 582; $i++)
{
$vals[] = str_pad($i, 4, "0", STR_PAD_LEFT);
}
for ($i = 1; $i <= 298; $i++)
{
$vals[] = "z".str_pad($i, 3, "0", STR_PAD_LEFT);
}
}
else
{
echo "No suitable system found for id ".$system."!\n\n";
}
for ($i = $start; /*$i < $start + 50 &&*/ $i < sizeof($vals); $i++)
{
$id = $vals[$i];
// Don't anger the No-Intro admins..
echo "Waiting 30 seconds...\n";
ob_flush(); flush();
sleep(30);
echo ($i.": Retrieving file information for ".$id."\n");
$filename = "http://datomatic.no-intro.org/index.php?page=show_record&s=".$system."&n=".$id;
$query = implode("", file($filename));
//$query = get_data($filename);
// If we're in an error state, break
if (strpos($query, "I am too busy for this") !== FALSE)
{
echo "\tError page found, breaking at http://datomatic.no-intro.org/index.php?page=show_record&s=".$system."&n=".$id."\n";
$start = $i;
echo "\nNext\n";
break;
}
// Get leading edge of the scene releases
$query = explode("Scene releases", $query);
if (!isset($query[1]))
{
echo "\tNo scene information found\n";
}
else
{
$query = $query[1];
// Get trailing edge of the scene releases
$query = explode("", $query);
$query = $query[0];
// Now all that's left are the scene releases
// Let's replace all of the obnoxious spaces with single ones
$query = preg_replace("/\s+/", " ", $query);
// Now all of the spaces should be fixed.
// Let's separate it by "Directory"
$query = explode("Directory:", $query);
unset($query[0]);
// Now there are little chunks of page that contain the directory
$xmlr = new XMLReader;
foreach ($query as $release)
{
$data = array();
$release = str_replace("&", "&", $release);
$enddiv = strpos($release, "");
$xmlr->XML(($enddiv !== false ? "" : "")."
| ".$release.($enddiv === false ? " |
" : ""));
// Just in case, read to the first
while($xmlr->read() && $xmlr->name !== "td");
// Skip the first; it's blank
$xmlr->next("td");
// Get the directory name
$name = trim($xmlr->readString());
$data[] = "Directory: ".$name;
// Go the next row
$xmlr->next("tr");
// Get whatever else comes out
while($xmlr->name === "tr")
{
if ($xmlr->readString() !== "")
{
$data[] = preg_replace("/\s+/", " ", trim($xmlr->readString()));
}
$xmlr->next("tr");
}
// Extract the useful bits
proc_data($data, $system);
}
}
// Make sure everything prints to screen
ob_flush(); flush();
echo "";
}
}
// If we don't have either, then show a selection screen
else
{
echo "Scene Release Info\n";
// First the import form
echo "\n";
// Then the generate form
echo "\n";
}
function proc_data($data, $system)
{
GLOBAL $roms, $link;
$directory = "";
$name = "";
$released = "";
$crc = "";
$md5 = "";
foreach ($data as $datum)
{
// Directory name
if (preg_match("/Directory: (.*)/", $datum, $point))
{
$directory = $point[1];
}
// NFO File
elseif (preg_match("/NFO File: (.*)/", $datum, $point))
{
$name = $point[1];
}
// Released
elseif (preg_match("/Released: (.*)/", $datum, $point))
{
$released = $point[1];
}
// Decrypted CRC32
elseif (preg_match("/.*CRC32: (.*)/", $datum, $point))
{
$crc = $point[1];
}
// Decrypted MD5
elseif (preg_match("/.*MD5: (.*)/", $datum, $point))
{
$md5 = $point[1];
}
}
// Check if it's in the database. If it's not, add it
$query = "SELECT id FROM releases
WHERE game='".$directory."'
AND system=".$system."
AND name='".$name."'
AND released='".$released."'
AND crc='".$crc."'
AND md5='".$md5."'";
$result = mysqli_query($link, $query);
if (gettype($result) == "boolean" || mysqli_num_rows($result) == 0)
{
$query = "INSERT INTO releases (game, system, name, released, crc, md5)
VALUES ('".$directory."', ".$system.", '".$name."', '".$released."', '".$crc."', '".$md5."')";
$result = mysqli_query($link, $query);
if (gettype($result) == "boolean" && $result)
{
echo "\tRelease ".$directory." has been added\n";
}
else
{
echo "\tRelease ".$directory." could not be added\n";
}
}
else
{
echo "\tRelease ".$directory." already exists\n";
}
}
?> |