ok i think i fixed it
in my register.php
i had this
$DB_site->query("INSERT INTO user (userid,username,password,email,".$newstylefield." parentemail,coppauser,homepage ,icq,aim,yahoo,signature,adminemail,showemail,invi sible,usertitle,joindate,cooki euser,daysprune,lastvisit,lastactivity,usergroupid ,timezoneoffset,emailnotificat ion,receivepm,emailonpm,options,birthday,maxposts, startofweek,ipaddress,pmpopup, referrerid,nosessionhash,country) VALUES (NULL,'".addslashes(htmlspecialchars($username))." ','".addslashes($password)."', '".addslashes(htmlspecialchars($email))."',".$news tyleval."'".addslashes(htmlspe cialchars($parentemail))."','$coppauser','".addsla shes(htmlspecialchars($homepag e))."','".addslashes(htmlspecialchars($icq))."','" .addslashes(htmlspecialchars($ aim))."','".addslashes(htmlspecialchars($yahoo))." ','".addslashes($signature)."' ,'$adminemail','$showemail','$invisible','".addsla shes($usertitle)."','".time(). "','$cookieuser','".addslashes($prunedays)."','".t ime()."','".time()."','$newuse rgroupid','".addslashes($timezoneoffset)."','$emai lnotification','$receivepm','$ emailonpm','$options','".addslashes($birthday)."', '".addslashes($umaxposts)."',' ".addslashes($startofweek)."','".addslashes($ipadd ress)."','$pmpopup','".addslas hes($testreferrerid['userid'])."','$nosessionhash','".addslashes($country)."',' $gender')",);
and i replaced it so it looks like this
$DB_site->query("INSERT INTO user (userid,username,password,email,".$newstylefield." parentemail,coppauser,homepage ,icq,aim,yahoo,signature,adminemail,showemail,invi sible,usertitle,joindate,cooki euser,daysprune,lastvisit,lastactivity,usergroupid ,timezoneoffset,emailnotificat ion,receivepm,emailonpm,options,birthday,maxposts, startofweek,ipaddress,pmpopup, referrerid,nosessionhash,country) VALUES (NULL,'".addslashes(htmlspecialchars($username))." ','".addslashes($password)."', '".addslashes(htmlspecialchars($email))."',".$news tyleval."'".addslashes(htmlspe cialchars($parentemail))."','$coppauser','".addsla shes(htmlspecialchars($homepag e))."','".addslashes(htmlspecialchars($icq))."','" .addslashes(htmlspecialchars($ aim))."','".addslashes(htmlspecialchars($yahoo))." ','".addslashes($signature)."' ,'$adminemail','$showemail','$invisible','".addsla shes($usertitle)."','".time(). "','$cookieuser','".addslashes($prunedays)."','".t ime()."','".time()."','$newuse rgroupid','".addslashes($timezoneoffset)."','$emai lnotification','$receivepm','$ emailonpm','$options','".addslashes($birthday)."', '".addslashes($umaxposts)."',' ".addslashes($startofweek)."','".addslashes($ipadd ress)."','$pmpopup','".addslas hes($testreferrerid['userid'])."','$nosessionhash','$gender')",'".addslashes($c ountry)."');
and that seemed to work......but does anyone see any errors in there??
|