Double new members! Please help

I am getting new members who register showing up twice, I am wondering what might be causing this, the latest hacks I installed are the new stats one and the flag one... here are a couple of pics of what's going on for you to see, any ideas of what might be wrong?

[Massiel]

Here is another shot....

[Admin]

Open register.php, and make sure you only have ONE LINE that STARTS with:

$DB_site->query("INSERT INTO user (userid

If you have two, remove the SHORTER one.

[Massiel]

Can you check please? I see that one has avatar and the other one has country, how do I incorporate both? I am scared I might leave out something I am not supposed to, like a " or something.... I copied the whole query in text file, could you take a look?

File here

[Admin]

Try this:

PHP Code:

  $DB_site->query("INSERT INTO user (userid,username,password,email,".$newstylefield."parentemail,coppauser,homepage,icq,aim,yahoo,signature,adminemail,showemail,invisible,usertitle,joindate,cookieuser,daysprune,lastvisit,lastactivity,usergroupid,timezoneoffset,emailnotification,receivepm,emailonpm,options,birthday,maxposts,startofweek,ipaddress,pmpopup,referrerid,nosessionhash,country,avatarid) VALUES (NULL,'".addslashes(htmlspecialchars($username))."','".addslashes($password)."','".addslashes(htmlspecialchars($email))."',".$newstyleval."'".addslashes(htmlspecialchars($parentemail))."','$coppauser','".addslashes(htmlspecialchars($homepage))."','".addslashes(htmlspecialchars($icq))."','".addslashes(htmlspecialchars($aim))."','".addslashes(htmlspecialchars($yahoo))."','".addslashes($signature)."','$adminemail','$showemail','$invisible','".addslashes($usertitle)."','".time()."','$cookieuser','".addslashes($prunedays)."','".time()."','".time()."','$newusergroupid','".addslashes($timezoneoffset)."','$emailnotification','$receivepm','$emailonpm','$options','".addslashes($birthday)."','".addslashes($umaxposts)."','".addslashes($startofweek)."','".addslashes($ipaddress)."','$pmpopup','".addslashes($testreferrerid['userid'])."','$nosessionhash','".addslashes($country)."','$avatarid')"); 


[Massiel]

Thank you for your help Firefly! It's very much appreciated!