Nadskap2

<center>
<h1>ArcEmu to MaNGOS Accounts Converter!</h1>
<form method="post"><table width="500px">
<tr><td>
MySQL Hostname:
</td><td>
<input type="text" name="myhost" />
</td></tr>
<tr><td>
MySQL Username:
</td><td>
<input type="text" name="myuser" />
</td></tr>
<tr><td>
MySQL Password:
</td><td>
<input type="text" name="mypass" />
</td></tr>
<tr><td>
ArcEmu Logon Database:
</td><td>
<input type="text" name="myarc" />
</td></tr>
<tr><td>
MaNGOS Realmd Database:
</td><td>
<input type="text" name="mymang" />
</td></tr>
</table>
<input type="submit" name="submit" value="Convert" />
</form>
<?php
*/
Made by Nadskap2
*/
if(isset($_POST['submit'])) {
    $my_host = $_POST['myhost'];
    $my_user = $_POST['myuser'];
    $my_pass = $_POST['mypass'];
    $my_arc = $_POST['myarc'];
    $my_mang = $_POST['mymang'];
    $con = @mysql_connect($my_host, $my_user, $my_pass);
    $dbcon = @mysql_select_db($my_arc, $con);
    if(!$con || !$dbcon) {
        echo "Unable to Connect to ArcEmu Database.";
    }
    else {
        $arcselect = @mysql_query("SELECT * FROM accounts");
        while($arc=@mysql_fetch_array($arcselect)) {
            $arcuser = $arc['login'];
            $arcpass = $arc['password'];
            $arcflag = $arc['gm'];
            $arcexpa = $arc['flags'];
            $arcadmi = array("az", "a", "3");
            $mangadm = "3";
            $mangfla = @str_replace($arcadmi, $mangadm, $arcflag);
            $arcexpi = array("0", "8", "24");
            $mangexp = array("0", "1", "2");
            $expansi = @str_replace($arcexpi, $mangexp, $arcexpa);
            $passwrd = sha1($arcpass);
            $con1 = @mysql_connect($my_host, $my_user, $my_pass);
            $dbcon1 = @mysql_select_db($my_mang, $con1);
            if(!$con1 || !$dbcon1) {
                echo "Unable to Connect to MaNGOS Database";
            }
            else {
                $insertquery = @mysql_query("REPLACE INTO account SET username = '$arcuser', sha_pass_hash = '$passwrd', gmlevel = '$mangfla', expansion = '$expansi'");
            }
        }
                        if(!$insertquery) {
                    echo "There was an error converting your account(s).";
                }
                else {
                echo "Converted " . mysql_num_rows($arcselect) . " accounts into MaNGOS and inserted into your MaNGOS Database";
                }
    }
}
?>
</center>