rendered paste body<?php
//error_reporting(E_ALL);
$amx_sql_host = "localhost";
$amx_sql_user = "root";
$amx_sql_pass = "";
$amx_sql_db = "preDB";
$amx_sql_db2 = "nodb_pretmp";
echo "START";
$db = mysql_connect($amx_sql_host,$amx_sql_user,$amx_sql_pass) or die("CONNECT ERROR");
mysql_select_db($amx_sql_db,$db) or die("SELECT ERROR");
$sql = mysql_query("SELECT * FROM predb");
mysql_select_db($amx_sql_db2,$db) or die("SELECT ERROR");
while ( $fetch = mysql_fetch_array($sql) ) {
$tim = $fetch[ctime];
$sec = $fetch[section];
$rls = $fetch[rlsname];
$grp = $fetch[grp];
$nick = "unknown";
$files = $fetch[files];
$mb = $fetch[size];
$genre = "";
$nuke_reason = $fetch[nukereason];
if ($nuke_reason != "") {
$nuke = "1";
$nuke_time = "0";
$unnuke = "0";
$unnuke_time = "";
$unnuke_reason = "";
} else {
$nuke = "0";
$nuke_time = "";
$unnuke = "0";
$unnuke_time = "";
$unnuke_reason = "";
}
$query = "INSERT INTO `nodb_pretmp`.`preDB` (
`time` ,
`sec` ,
`rls` ,
`grp` ,
`nick` ,
`files` ,
`mb` ,
`genre` ,
`nuke` ,
`nuke_time` ,
`nuke_reason` ,
`unnuke` ,
`unnuke_time` ,
`unnuke_reason`
) VALUES (
'".$tim."',
'".$sec."',
'".$rls."',
'".$grp."',
'".$nick."',
'".$files."',
'".$mb."',
'".$genre."',
'".$nuke."',
'".$nuke_time."',
'".$nuke_reason."',
'".$unnuke."',
'".$unnuke_time."',
'".$unnuke_reason."'
)";
mysql_query($query);
echo ".";
}
mysql_close($db);
echo "END";
?>