All pastes #401303 Raw Edit

CBTC

public php v1 · immutable
·published 2007-03-19 07:24 UTC
rendered paste body
require_once(form.db.php');    switch($_POST['gamechoice']){        case 'BattleField 2':                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, bf2Q1, bf2Q2, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$bf2favkit', '$bf2favvehicle', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")                    or die (mysql_error());                if(!$sql){                 print("<script> window.location.href =     \"index.php?e=There was an error entering your message. Please Try Again.\" </script>");                exit();                }                    print("<script> window.location.href =     \"thankyou.html\" </script>");                        exit();                break;            case 'BattleField 2142':                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, bf2142Q1, bf2142Q2, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$bf2142favkit', '$bf2142favvehicle', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")                    or die (mysql_error());                if(!$sql){                 print("<script> window.location.href =     \"index.php?e=There was an error entering your message. Please Try Again.\" </script>");                exit();                }                    print("<script> window.location.href =     \"thankyou.html\" </script>");                        exit();                            break;            case 'Armed Assault':                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, armAQ1, armAQ2, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$armafavkit', '$armafavvehicle', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")                    or die (mysql_error());                if(!$sql){                 print("<script> window.location.href =     \"index.php?e=There was an error entering your message. Please Try Again.\" </script>");                exit();                }                    print("<script> window.location.href =     \"thankyou.html\" </script>");                        exit();                            break;            case 'UT 2004':                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, ut2004Q1, ut2004Q2, ut2004Q3, ut2004Q4, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$ut2004gamename', '$ut2004favweapon', '$ut2004favvehicle', '$ut2004favmap', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")                    or die (mysql_error());                if(!$sql){                 print("<script> window.location.href =     \"index.php?e=There was an error entering your message. Please Try Again.\" </script>");                exit();                }                    print("<script> window.location.href =     \"thankyou.html\" </script>");                        exit();                            break;            case 'ET - Quake Wars':                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, etQWarsQ1, etQWarsQ2, etQWarsQ3, etQWarsQ4, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$etQWarsFavClass', '$etQWarsFavWeapon', '$etQWarsFavVehicle', '$etQWarsFavDepoly', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")                    or die (mysql_error());                if(!$sql){                 print("<script> window.location.href =     \"index.php?e=There was an error entering your message. Please Try Again.\" </script>");                exit();                }                    print("<script> window.location.href =     \"thankyou.html\" </script>");                        exit();                            break;                                   case 'Counter Strike':                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, csQ1, csQ2, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$csfavkit', '$csfavmap', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")                    or die (mysql_error());                if(!$sql){                 print("<script> window.location.href =     \"index.php?e=There was an error entering your message. Please Try Again.\" </script>");                exit();                }                    print("<script> window.location.href =     \"thankyou.html\" </script>");                        exit();                            break;            case 'Counter Strike Source':                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, cssQ1, cssQ2, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$cssfavkit', '$cssfavmap', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")                    or die (mysql_error());                if(!$sql){                 print("<script> window.location.href =     \"index.php?e=There was an error entering your message. Please Try Again.\" </script>");                exit();                }                    print("<script> window.location.href =     \"thankyou.html\" </script>");                        exit();                            break;                         case 'Day Of Defeat':                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, dodQ1, dodQ2, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$dodfavkit', '$dodfavmap', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")                    or die (mysql_error());                if(!$sql){                 print("<script> window.location.href =     \"index.php?e=There was an error entering your message. Please Try Again.\" </script>");                exit();                }                    print("<script> window.location.href =     \"thankyou.html\" </script>");                        exit();                            break;            case 'Day Of Defeat Source':                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, dodsQ1, dodsQ2, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$dodsfavkit', '$dodsfavmap', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")                    or die (mysql_error());                if(!$sql){                 print("<script> window.location.href =     \"index.phpl?e=There was an error entering your message. Please Try Again.\" </script>");                exit();                }                    print("<script> window.location.href =     \"thankyou.html\" </script>");                        exit();                            break;            case 'Team Fortress 2':                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, teamF2Q1, teamF2Q2, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$tf2favclass', '$tf2favmap', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")                    or die (mysql_error());                if(!$sql){                 print("<script> window.location.href =     \"index.phpl?e=There was an error entering your message. Please Try Again.\" </script>");                exit();                }                    print("<script> window.location.href =     \"thankyou.html\" </script>");                        exit();                            break;                       case 'Guild Wars':                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, gwQ1, gwQ2, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$gwfavclass', '$gwtype', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")                    or die (mysql_error());                if(!$sql){                 print("<script> window.location.href =     \"index.php?e=There was an error entering your message. Please Try Again.\" </script>");                exit();                }                    print("<script> window.location.href =     \"thankyou.html\" </script>");                        exit();               break;            case 'World of Warcraft':                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, wowQ1, wowQ2, wowQ3, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$wowclass', '$wowgpt', '$wowprof', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")                    or die (mysql_error());                if(!$sql){                 print("<script> window.location.href =     \"index.php?e=There was an error entering your message. Please Try Again.\" </script>");                exit();                }                    print("<script> window.location.href =     \"thankyou.html\" </script>");                        exit();               break;            case 'Second Life':                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, slQ1, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$slgamename', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")                    or die (mysql_error());                if(!$sql){                 print("<script> window.location.href =     \"index.php?e=There was an error entering your message. Please Try Again.\" </script>");                exit();                }                    print("<script> window.location.href =     \"thankyou.html\" </script>");                        exit();                            break;            case 'Silent Hunter III':                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, sHunter3Q1, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$shIIIgamename', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")                    or die (mysql_error());                if(!$sql){                 print("<script> window.location.href =     \"index.php?e=There was an error entering your message. Please Try Again.\" </script>");                exit();                }                    print("<script> window.location.href =     \"thankyou.html\" </script>");                        exit();                            break;             case 'HellGate London':                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, hGateLQ1, hGateLQ2, hGateLQ3, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$hGateLgamename', '$hGateLclass', '$hGateLweapon', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")                    or die (mysql_error());                if(!$sql){                 print("<script> window.location.href =     \"index.php?e=There was an error entering your message. Please Try Again.\" </script>");                exit();                }                    print("<script> window.location.href =     \"thankyou.html\" </script>");                        exit();                            break;            case 'Age Of Empires III':                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, aoeIIIQ1, aoeIIIQ2, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$aoeIIIgamename', '$aoeIIIFavCiv', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")                    or die (mysql_error());                if(!$sql){                 print("<script> window.location.href =     \"index.php?e=There was an error entering your message. Please Try Again.\" </script>");                exit();                }                    print("<script> window.location.href =     \"thankyou.html\" </script>");                        exit();                            break;            case 'Falcon 4.0 Allied Force':                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, falcon4AFQ1, falcon4AFQ2, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$falcon4AFgamename', '$falcon4AFFavJet', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")                    or die (mysql_error());                if(!$sql){                 print("<script> window.location.href =     \"index.php?e=There was an error entering your message. Please Try Again.\" </script>");                exit();                }                    print("<script> window.location.href =     \"thankyou.html\" </script>");                        exit();                            break;            case 'XBCONNECT':                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, xbConnectQ1, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$xbconnectname', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")                    or die (mysql_error());                if(!$sql){                 print("<script> window.location.href =     \"index.php?e=There was an error entering your message. Please Try Again.\" </script>");                exit();                }                    print("<script> window.location.href =     \"thankyou.html\" </script>");                        exit();                            break;            case 'XBOX LIVE':                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, xBoxLiveQ1, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$xboxlivename', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")                    or die (mysql_error());                if(!$sql){                 print("<script> window.location.href =     \"index.php?e=There was an error entering your message. Please Try Again.\" </script>");                exit();                }                    print("<script> window.location.href =     \"thankyou.html\" </script>");                        exit();                            break;            case 'OTHER':                $sql = mysql_query("INSERT INTO Applicant (firstname, lastname, street, aptnum, porrot, postalzip, dob, gender, country, city, provstate, phonenumber, email, gamechoice, gamename, timeplayed, oGameQ1, referredby, exadvert1, exadvert2, previousclan, currentclan, whichclangame, previousadmin, admindetails, howtousets, willingtousets, notwillingtousets, willingtotravel, whatothergames, rateyourself, premium, donatedetails, describeyourself, personalskillshelp, formfeedback, answeredall, agreedterms, agreedprivacy, IPRECORDED, ISPRECORDED, IPISPALLOWRECORD, anniversarydate)                VALUES ('$firstname', '$lastname', '$street', '$aptnum', '$porrot', '$postalzip', '$dob', '$gender', '$country', '$city', '$provstate', '$phonenumber', '$email', '$gamechoice', '$gamename', '$timeplayed', '$othergame', '$referredby', '$exadvert1', '$exadvert2', '$previousclan', '$currentclan', '$whichclangame', '$previousadmin', '$admindetails', '$howtousets', '$willingtousets', '$notwillingtousets', '$willingtotravel', '$whatothergames', '$rateyourself', '$premium', '$donatedetails', '$describeyourself', '$personalskillshelp', '$formfeedback', '$answeredall', '$agreedterms', '$agreedprivacy', '$ip', '$isp', '$ipisprecorded', DATE_ADD(NOW(), INTERVAL 1 YEAR))")                    or die (mysql_error());                if(!$sql){                 print("<script> window.location.href =     \"index.php?e=There was an error entering your message. Please Try Again.\" </script>");                exit();                }                    print("<script> window.location.href =     \"thankyou.html\" </script>");                        exit();                            break;              // This concludes the switch function, and the data should now be added to the database            }