<?php
function setDate($dates) {
    $date = explode(" ", $dates);
    $ymd = explode("-", $date['0']);
    $hhmmss = explode(":", $date['1']);
    $time = mktime($hhmmss['0'], $hhmmss['1'], $hhmmss['2'], $ymd['1'], $ymd['2'], $ymd['0']);
    return($time);
}

function newPass() {
    $s = array("0","1","2","3","4","5","6","7","8","9","a","b","c","d","e","f","g","h",
            "i","j","k","l","m","n","o","p","q","r","s","t","u","v","w","x","y","z");
    $max = 12;
    for( $i=0; $i<$max; $i++) {
        $pass .= $s[rand(0, count($s) -1)];
    }
    return($pass);
}

$db = new mysqli("", "", "", "");
    if ($db->connect_error) {
        echo "Fehler bei der Verbindung: " . mysqli_connect_error();
        exit();
    }

$select = "SELECT *
        FROM tlx_accounts";
$tlx = $db->query($select);
if(!$tlx) {
    echo "<strong>Der folgende fehler ist aufgetreten: </strong><br />".$mysqli->error."<br />
          <strong>Fehlernummer :</strong>".$db->errno."<br />";
} else {
    while($row = $tlx->fetch_array()) {
        $username = $db->real_escape_string($row['username']);
        $email = $db->real_escape_string($row['email']);
        $site_url = $db->real_escape_string($row['site_url']);
        $banner_url = $db->real_escape_string($row['banner_url']);
        $banner_height = $db->real_escape_string($row['banner_height']);
        $banner_width = $db->real_escape_string($row['banner_width']);
        $title = $db->real_escape_string($row['title']);
        $description = $db->real_escape_string($row['description']);
        $dates = $db->real_escape_string($row['date_added']);
        $signup = $db->real_escape_string(setDate($dates));
        $password = $db->real_escape_string(newPass());

        $accounts = "INSERT INTO 3toplist.arphp_Accounts (Username, Email, Site_URL, Banner_URL, Banner_Height, Banner_Width, Recip_URL, Title, Description, Category, Icons, Signup, Password, Confirm_ID, Status, Suspended, Locked, Last_Reset, Field_1, Field_2, Field_3, Notes, In_Weight, Out_Weight, Current_Prod, Current_In, Current_Out, Total_Prod, Total_In, Total_Out, Last_Prod, Last_Hits_In, Last_Hits_Out, Last_Sort, Last_Overall, Last_Category, Inactive, Num_Ratings, Rating_Total, Overall_Rank, Category_Rank)
                VALUES ('$username', '$email', '$site_url', '$banner_url', '$banner_height', '$banner_width', '', '$title', '$description', '', '', '$signup', '$password', '', 'Approved', '0', '0', '1296522037', '', '', '', '', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');";
        if($arphp = $db->query($accounts)) {
            echo "Anzahl der ver&auml;nderten Datens&auml;tze: ".$db->affected_rows."<br />";
        } else {
            echo $db->error;
        }

    $snapshot = "INSERT INTO 3toplist.arphp_Accounts (Username, Email, Site_URL, Banner_URL, Banner_Height, Banner_Width, Recip_URL, Title, Description, Category, Icons, Signup, Password, Confirm_ID, Status, Suspended, Locked, Last_Reset, Field_1, Field_2, Field_3, Notes, In_Weight, Out_Weight, Current_Prod, Current_In, Current_Out, Total_Prod, Total_In, Total_Out, Last_Prod, Last_Hits_In, Last_Hits_Out, Last_Sort, Last_Overall, Last_Category, Inactive, Num_Ratings, Rating_Total, Overall_Rank, Category_Rank)
                VALUES ('$username', '$email', '$site_url', '$banner_url', '$banner_height', '$banner_width', '', '$title', '$description', '', '', '$signup', '$password', '', 'Approved', '0', '0', '1296522037', '', '', '', '', '1', '1', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');";
        if($ar_php = $db->query($snapshot)) {
            echo "Anzahl der ver&auml;nderten Datens&auml;tze: ".$db->affected_rows."<br />";
        } else {
            echo $db->error;
        }

        $cheat = "INSERT INTO 3toplist.arphp_Cheats (Username, Hit_IP_Address, Hit_Cookie, Hit_Exp_Session, Hit_Proxy, Hit_Referrer, Hit_Browser, Hit_Banned_IP, Hit_No_Cookies, Rate_IP_Address, Rate_Cookie, Rate_Exp_Session, Rate_Proxy, Rate_Referrer, Rate_Browser, Rate_No_Cookies, Rate_Banned_IP)
              VALUES ('$username', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0');";
        if($arphp_cheats = $db->query($cheat)) {
            echo "Anzahl der ver&auml;nderten Datens&auml;tze: ".$db->affected_rows."<br />";
        } else {
            echo $db->error;
        }

        $message = "Empf&auml;nger: ".$email."<br />
                 Hallo ".$username.",<br />
                 mit folgenden Daten kannst du dich k&uuml;nftig einloggen:<br />
                 Login: ".$username."<br />
                 Password: ".$password."<br /><br />
                 Cheers,<br/ >drei.to Toplist Webmaster<br />";
        echo $message;
        mail($email, "Toplist Zugangsdaten", $message, "From: toplist@drei.to");

}
$tlx->close();
}
$db->close();
?>