<?php
        $SteamID = $_GET["steamid"];
        if (!$SteamID or $SteamID == "")
        {
                die("404 Invalid SteamID");
        }
        $connection = mysql_connect("localhost", "net_net", "5873sc");
        mysql_select_db("net_smf", $connection);
        $query = mysql_query("SELECT * FROM `smf_members` WHERE `steamid`='$SteamID'");
        $query2 = mysql_query("SELECT * FROM `smf_members_pending` WHERE `steamid`='$SteamID'");
        $row = mysql_fetch_array($query2);
        $query3 = mysql_query("SELECT * FROM `smf_members`");
        $TotalMembers = 0;
        while ($row2 = mysql_fetch_array($query3)) {
                $TotalMembers = $row2["ID_MEMBER"];
        }
        if (!$row)
        {
                die("404 SteamID Not Found");
        }
        else
        {
                $ID_NUMBER = $TotalMembers + 1;
                $UserName = $row["username"];
                $RealName = $row["nickname"];
                $Password = mysql_real_escape_string(sha1(strtolower($UserName) . $row['password']));
                $PassSalt = mysql_real_escape_string(substr(md5(mt_rand()), 0, 4));
                $Rank = $row["rank"];
                $IPAddress = $row["ip"];
                $curTime = time();
                if (mysql_num_rows($query) == 0)
                {
                        mysql_query("INSERT INTO `smf_members` VALUES ($ID_NUMBER,'$SteamID','$UserName',$curTime,0,$Rank,'',0,'$RealName',0,0,'','','','$Password','newmember@firelinegaming.co.cc','',0,'0001-01-01','','','','','','','',0,1,'','',0,'',1,0,0,'',1,1,0,2,'$IPAddress','$IPAddress','','',5,1,'',3,'','',4,0,'$PassSalt',0,1,'','')") or die(mysql_error());
                        mysql_query("DELETE FROM `smf_members_pending` WHERE `steamid`='$SteamID'") or die(mysql_error());
                        mysql_query("UPDATE `smf_settings` SET `value`='$ID_NUMBER' WHERE `variable`='totalMembers'") or die(mysql_error());
                        mysql_query("UPDATE `smf_settings` SET `value`='$ID_NUMBER' WHERE `variable`='latestMember'") or die(mysql_error());
                        echo "s";
                }
                else
                {
                        die("403 User Already Exists");
                }
        }
?>