"); exit; } require("../inc/apodhead.php"); include("../inc/curetext.php"); if(isset($_POST['newsignup']) && $_POST['newsignup']=="yes"){ //========================================================== //=== ADD NEW SIGNUP ======================================= //========================================================== require("../inc/db.php"); $db = mysql_connect($dbserver,$dbuser,$dbpw); mysql_select_db($dbname,$db); //---------------------------------------------------------- //---- TEST PASSWORD --------------------------------------- //---------------------------------------------------------- if(strlen($_POST['pw'])<5){ print(boxhead('Password Error',1,"90%"). '
Password must be at least 5 characters

'. boxfoot()); mysql_close($db); exit; } if($_POST['pw']!=$_POST['pw2']){ print(boxhead('Password Error',1,"90%"). '
Passwords do not match

'. boxfoot()); mysql_close($db); exit; } //---------------------------------------------------------- //---- TEST USERNAME --------------------------------------- //---------------------------------------------------------- $login_name=cureText($_POST['username']); if($login_name!=trim($_POST['username'])){ print(boxhead('Username Error',1,"90%"). '
Your Username contains invalid characters, please use alphanumeric characters only.

'. boxfoot()); mysql_close($db); exit; } $login_pw=cureText($_POST['pw']); if($login_pw!=trim($_POST['pw'])){ print(boxhead('Password Error',1,"90%"). '
Your Password contains invalid characters, please use alphanumeric characters only.

'. boxfoot()); mysql_close($db); exit; } //---------------------------------------------------------- //---- TEST USERNAME --------------------------------------- //---------------------------------------------------------- $result=mysql_query("select member_id from ap_members where username='".$login_name."'",$db); if( ($rs=mysql_fetch_array($result)) ){ $member_id=$rs['member_id']; } mysql_free_result($result); if(isset($member_id)){ print(boxhead('Username Already Exist',1,"90%"). '
'.$_POST['username'].' already exist.

'. boxfoot()); mysql_close($db); exit; } //---------------------------------------------------------- //---- TEST EMAIL ------------------------------------------ //---------------------------------------------------------- $result=mysql_query("select member_id from ap_members where status=1 and email='".$_POST['email']."'",$db); if( ($rs=mysql_fetch_array($result)) ){ $member_id=$rs['member_id']; } mysql_free_result($result); if(isset($member_id)){ print(boxhead('Email Already Exist',1,"90%"). '
'.$_POST['email'].' already exist.

[back] [forgot password]

'. boxfoot()); mysql_close($db); exit; } //---------------------------------------------------------- //---- INSERT NEW MEMBER ----------------------------------- //---------------------------------------------------------- $member_id=1; $result=mysql_query("select (max(member_id)+1) as new_id from ap_members",$db); if( ($rs=mysql_fetch_array($result)) ){ $member_id=$rs['new_id']; } mysql_free_result($result); mysql_query("insert into ap_members (status,member_id,email,email_first,email_type,username,pw,access_type,created_dt,created_ip,dob,gender,state_id,country_id) values(". "1". ",".$member_id. ",'".trim($_POST['email'])."'". ",'".trim($_POST['email'])."'". ",0". ",'".trim($login_name)."'". ",'".$_POST['pw']."'". ",".$_POST['author']. ",now()". ",'".$HTTP_SERVER_VARS['REMOTE_ADDR']."'". ",'".$_POST['dob']."'". ",".$_POST['gender']. ",'".$_POST['states']."'". ",'".$_POST['country']."'". ")",$db); mysql_query("insert into log_login(member_id,dt,ip) values('".$member_id."',now(),'".$HTTP_SERVER_VARS['REMOTE_ADDR']."')",$db); print(boxhead('New Member',1,"90%"). '
Thank you

'.$_POST['username'].' has been created.

'. boxfoot()); //========================================================== mysql_close($db); //========================================================== //=== DISPLAY SIGNUP ======================================= //========================================================== } else{ //print($_POST['newsignup']); ?>

Members Sign Up  Username  Password  Password Comfirm  Email  Do you write or make Java,  Flash or Shockwave games? Yes   No  Gender Male   Female  Age Range Age Range Below 13'); print('13-17'); print('18-22'); print('23-29'); print('30-39'); print('40-49'); print('50-59'); print('60+'); ?>  Country United StatesAfghanistanAlbaniaAlgeriaAmerican SamoaAndorraAngolaAnguillaAntarcticaAntigua and BarbudaArgentinaArmeniaArubaAustraliaAustriaAzerbaijanBahamasBahrainBangladeshBarbadosBelarusBelgiumBelizeBeninBermudaBhutanBoliviaBosnia and HerzegowinaBotswanaBouvet IslandBrazilBritish Indian Ocean TerritoryBrunei DarussalamBulgariaBurkina FasoBurundiCambodiaCameroonCanadaCape VerdeCayman IslandsCentral African RepublicChadChileChinaChristmas IslandCocos (Keeling) IslandsColombiaComorosCongoCook IslandsCosta RicaCote D'ivoireCroatiaCubaCyprusCzech RepublicDenmarkDjiboutiDominicaDominican RepublicEast TimorEcuadorEgyptEl SalvadorEquatorial GuineaEritreaEstoniaEthiopiaFalkland Islands (Malvinas) Faroe IslandsFijiFinlandFranceFrench GuianaFrench PolynesiaFrench Southern TerritoriesGabonGambiaGeorgiaGermanyGhanaGibraltarGreeceGreenlandGrenadaGuadeloupeGuamGuatemalaGuineaGuinea-BissauGuyanaHaitiHeard and Mc Donald IslandsHoly See (Vatican City State)HondurasHong KongHungaryIcelandIndiaIndonesiaIranIraqIrelandIsraelItalyJamaicaJapanJordanKazakhstanKenyaKiribatiKoreaKoreaKuwaitKyrgyzstanLao People's Democratic RepublicLatviaLebanonLesothoLiberiaLibyan Arab JamahiriyaLiechtensteinLithuaniaLuxembourgMacauMacedoniaMadagascarMalawiMalaysiaMaldivesMaliMaltaMarshall IslandsMartiniqueMauritaniaMauritiusMayotteMexicoMoldovaMonacoMongoliaMontserratMoroccoMozambiqueMyanmarNamibiaNauruNepalNetherlandsNetherlands AntillesNew CaledoniaNew ZealandNicaraguaNigerNigeriaNiueNorfolk IslandNorthern Mariana IslandsNorwayOmanPakistanPalauPanamaPapua New GuineaParaguayPeruPhilippinesPitcairnPolandPortugalPuerto RicoQatarReunionRomaniaRussian FederationRwandaSaint Kitts and NevisSaint LuciaSaint Vincent and The GrenadinesSamoaSan MarinoSao Tome and PrincipeSaudi ArabiaSenegalSeychellesSierra LeoneSingaporeSlovakiaSloveniaSolomon IslandsSomaliaSouth AfricaSouth Georgia and The South Sandwich IslandsSpainSri LankaSt. HelenaSt. Pierre and MiquelonSudanSurinameSvalbard and Jan Mayen IslandsSwazilandSwedenSwitzerlandSyrian Arab RepublicTaiwanTajikistanTanzaniaThailandTogoTokelauTongaTrinidad and TobagoTunisiaTurkeyTurkmenistanTurks and Caicos IslandsTuvaluUgandaUkraineUnited Arab EmiratesUnited KingdomUruguayUzbekistanVanuatuVenezuelaViet NamVirgin Islands (British)Virgin Islands (U.S.)Wallis and Futuna IslandsWestern SaharaYemenYugoslaviaZaireZambiaZimbabwe  State Not ApplicableAlabamaAlaskaArizonaArkansasCaliforniaColoradoConnecticutDelawareDistrict of ColumbiaFloridaGeorgiaHawaiiIdahoIllinoisIndianaIowaKansasKentuckyLouisianaMaineMarylandMassachusettsMichiganMinnesotaMississippiMissouriMontanaNebraskaNevadaNew HampshireNew JerseyNew MexicoNew YorkNorth CarolinaNorth DakotaOhioOklahomaOregonPennsylvaniaRhode IslandSouth CarolinaSouth DakotaTennesseeTexasUtahVermontVirginiaWashingtonWest VirginiaWisconsinWyoming NOTE: your verification password will be email to you.