Double new members! Please help

[Massiel]

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 (http://www.dietsupporters.com/upload/register.zip)

[Admin]

Try this:
$DB_site->query("INSERT INTO user (userid,username,password,email,".$newstylefield."parentemail,coppauser,homepage,icq,aim,yahoo,signa ture,adminemail,showemail,invisible,usertitle,join date,cookieuser,daysprune,lastvisit,lastactivity,u sergroupid,timezoneoffset,emailnotification,receiv epm,emailonpm,options,birthday,maxposts,startofwee k,ipaddress,pmpopup,referrerid,nosessionhash,count ry,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! :)