<?php


$con = mysql_connect("74.91.113.22", "root", "aftermath12"); // Change this line to your information.



if (!$con) { die('a'); }



mysql_select_db("perp"); // Change this line to your database



$steamid = $_GET['steamid'];



$q = mysql_query("SELECT * FROM `members_pending` WHERE `steamid`='" . $steamid ."' LIMIT 1");



if (!$q){ die('b'); }



while ($row = mysql_fetch_assoc($q)){

        $regOptions = array(

                'username' => "'" . $row['username'] . "'",

                'email' => "'notavailable@gmail.com'",

                'password' => '\'' . sha1(strtolower($row['username']) . $row['password']) . '\'',

                'passworddate' => time(),

                'usergroupid' => 2,

                'displaygroupid' => 0,

                'styleid' => 0,

                'memberIP' => "'$row[ipaddress]'",

                'memberIP2' => "'$row[ipaddress]'",

                'showvbcode' => 2,

                'showbirthday' => 2,

                'usertitle' => "'Registered User'",

                'customtitle' => 0,

                'joindate' => 6,

                'daysprune' => 0,

                'lastpost' => 0,

                'lastpostid' => 0,

                'posts' => 0,

                'reputation' => 10,

                'reputationlevelid' => 1,

                'pmpopup' => 0,

                'avatarid' => 0,

                'avatarrevision' => 0,

                'profilepicrevision' => 0,

                'sigpicrevision' => 0,

                'options' => 11552855,

                'birthday_search' => "'0000-00-00'",

                'maxposts' => -1,

                'startofweek' => 1,

                'referrerid' => 0,

                'languageid' => 0,

                'emailstamp' => 0,

                'showblogcss' => 1,

                'autosubscribe' => -1,

                'logintype' => "'vb'",

                'steamid' => "'$row[steamid]'",

        );





        mysql_query("

                INSERT INTO forum_user

                        (" . implode(', ', array_keys($regOptions)) . ")

                VALUES (" . implode(', ', $regOptions) . ')');



        echo mysql_error();



        mysql_query("DELETE FROM `members_pending` WHERE `steamid`='" . $steamid . "' LIMIT 1");



        die('s');

}



die('c');





?>