<?php


include("mainfile.php");


global $db, $prefix;





//Change to your name


$yourname = "Your_Name";





$sql = "SELECT * FROM $prefix"._blocked." ORDER BY id ASC limit 0,10000"; 


    $result = $db->sql_query($sql); 


    while ($row = $db->sql_fetchrow($result)) { 


    $ip = $row['ip_from']; 


    $date = $row['date'];


    $info = $row['info'];


    $banned = $row['banned'];


    if ($banned =="") { $banned = "Anonymous"; }  


    $ip_add = long2ip(-(4294967296-$ip));


 


$db->sql_query("INSERT INTO ".$prefix."_nsnst_ips VALUES ('$ip_add', '1', '$banned', 'Added by $yourname', '$date', '$info', '0', '', 'none', 'none', '$ip_add', 'unknown', 'none')");


}


?>

<?php


require_once("mainfile.php");


$index = 1;


//Change to your name 


$yourname = "Your_Name";


 


switch($op) {





    default:


    include ("header.php");


    Opentable();


    echo "<table align='center' border='0' cellpadding='5' cellspacing='0'>\n";


    echo "<form action='".$_SERVER['PHP_SELF']."' method='post'>\n";


    echo "<tr><td>This script will not install the Sentinel&trade;. You must install that prior to running this script.</td></tr>\n";


    echo "<tr><td>This script will move your Banned IP's from the Protector to the Sentinel&trade;. There is also an option to move the IP's and remove the Protector tables.</td></tr>\n";


    echo "<tr><td><b>Please make a backup of your database before using this script. When your done DELETE it off of your server.</b></td></tr>\n";


    echo "<tr><td><select name='op'>\n";


    echo "<option value=''>Transfer Options</option>\n";


    echo "<option value='transfer'>Transfer IP's</option>\n";


    echo "<option value='transferdelete'>Transfer IP's and REMOVE Protector tables.</option>\n";


    echo "</select><input type='submit' value='Transfer'></td></tr>\n";


    echo "</form>";


    echo "</table>\n";


    CloseTable();


    include("footer.php");


    break;





case "transfer":


    include("header.php");


    global $db, $prefix, $user_prefix, $yourname;


    OpenTable(); 


$sql = "SELECT * FROM $prefix"._blocked." ORDER BY id ASC limit 0,10000"; 


    $result = $db->sql_query($sql); 


    while ($row = $db->sql_fetchrow($result)) { 


    $ip = $row['ip_from']; 


    $date = $row['date']; 


    $info = $row['info']; 


    $banned = $row['banned']; 


    if ($banned =="") { $banned = "Anonymous"; }  


    $ip_add = long2ip(-(4294967296-$ip)); 


  


$db->sql_query("INSERT INTO ".$prefix."_nsnst_ips VALUES ('$ip_add', '1', '$banned', 'Added by $yourname', '$date', '$info', '0', '', 'none', 'none', '$ip_add', 'unknown', 'none')");


     echo "<br />Done!<br />";


}


    CloseTable();


    include("footer.php");


    break;








case "transferdelete":


    include("header.php");


    global $db, $prefix, $user_prefix, $yourname;


    OpenTable();


    $sql = "SELECT * FROM $prefix"._blocked." ORDER BY id ASC limit 0,10000"; 


    $result = $db->sql_query($sql); 


    while ($row = $db->sql_fetchrow($result)) { 


    $ip = $row['ip_from']; 


    $date = $row['date']; 


    $info = $row['info']; 


    $banned = $row['banned']; 


    if ($banned =="") { $banned = "Anonymous"; }  


    $ip_add = long2ip(-(4294967296-$ip)); 


  


    $db->sql_query("INSERT INTO ".$prefix."_nsnst_ips VALUES ('$ip_add', '1', '$banned', 'Added by $yourname', '$date', '$info', '0', '', 'none', 'none', '$ip_add', 'unknown', 'none')");





    //Taken From Protector 


    $db->sql_query("ALTER TABLE ".$prefix."_authors DROP radminblocker");


    $db->sql_query("ALTER TABLE ".$user_prefix."_users DROP last_seen_blocker");


    $db->sql_query("DROP TABLE ".$prefix."_blocked, ".$prefix."_blocked_hammer, ".$prefix."_blocked_iplist, ".$prefix."_blocked_notes, ".$prefix."_blocked_protected, ".$prefix."_blocked_settings, ".$prefix."_blocked_pagetracker, ".$prefix."_blocked_config, ".$prefix."_blocked_robot, ".$prefix."_blocked_promod, ".$prefix."_blocked_promodip, ".$prefix."_blocked_agent, ".$prefix."_blocked_iptoc, ".$prefix."_blocked_ref, ".$prefix."_blocked_denymod");


     echo "<br />Done!<br />";


}


    CloseTable();


    include("footer.php");


    break;


}


?>