All pastes #714187 Raw Edit

Meins

public text v1 · immutable
#714187 ·published 2007-09-25 23:25 UTC
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"; 
  
?>