\n";} else { $Turing_code = $_REQUEST["Turing"]; if ( CheckCaptcha($Turing_code) !=1 ) { $errorsAndAlerts .= "The characters you entered do not match those displayed. Please try again.

\n";} } } ?> 'common_information', 'where' => whereRecordNumberInUrl(1), 'limit' => '1', )); $common_informationRecord = @$common_informationRecords[0]; // get first record list($horizontal_menu_entriesRecords, $horizontal_menu_entriesMetaData) = getRecords(array( 'tableName' => 'horizontal_menu_entries', )); list($vertical_menu_entriesRecords, $vertical_menu_entriesMetaData) = getRecords(array( 'tableName' => 'vertical_menu_entries', )); list($footer_menu_entriesRecords, $footer_menu_entriesMetaData) = getRecords(array( 'tableName' => 'footer_menu_entries', )); // load records list($subscriber_level_valuesRecords, $subscriber_level_valuesMetaData) = getRecords(array( 'tableName' => 'subscriber_level_values', 'where' => whereRecordNumberInUrl(1), 'limit' => '1', )); $subscriber_level_valuesRecord = @$subscriber_level_valuesRecords[0]; // get first record ?> CLICK HERE to continue, or LOG OUT."; $showSignupForm = false; } // process form if (@$_REQUEST['save']) { // error checking if (!@$_REQUEST['first_name']) { $errorsAndAlerts .= "You must enter your first name!
\n"; } if (!@$_REQUEST['last_name']) { $errorsAndAlerts .= "You must enter your last name!
\n"; } if (!@$_REQUEST['email']) { $errorsAndAlerts .= "You must enter your email!
\n"; } else if(!isValidEmail(@$_REQUEST['email'])) { $errorsAndAlerts .= "Please enter a valid email (example: user@example.com)
\n"; } if (!@$_REQUEST['username']) { $errorsAndAlerts .= "You must choose a username!
\n"; } // check for duplicate usernames and emails if (!$errorsAndAlerts) { $count = mysql_select_count_from('accounts', "`username` = '".mysql_escape(@$_REQUEST['username'])."'"); if ($count > 0 && @$_REQUEST['username']) { $errorsAndAlerts .= "That username is already in use, please choose another!
\n"; } $count = mysql_select_count_from('accounts', "'".mysql_escape($_REQUEST['email'])."' IN (email, username)"); if ($count > 0) { $errorsAndAlerts .= "That email is already in use, please choose another!
\n"; } } // turn off strict mysql error checking for: STRICT_ALL_TABLES mysqlStrictMode(false); // disable Mysql strict errors for when a field isn't defined below (can be caused when fields are added later) // add user if (!$errorsAndAlerts) { // generate password $password = substr(md5(uniqid(rand(), true)), 15); // example output: c5560251ef0b3eef9 if (@$SETTINGS['advanced']['encryptPasswords']) { $passwordHash = getPasswordDigest($password); } else { $passwordHash = $password; } @$_REQUEST['first_name']=ucwords(@$_REQUEST['first_name']); @$_REQUEST['middle_initial']=strtoupper(@$_REQUEST['middle_initial']); @$_REQUEST['last_name']=ucfirst(@$_REQUEST['last_name']); @$_REQUEST['city']=ucwords(@$_REQUEST['city']); @$_REQUEST['state']=strtoupper(@$_REQUEST['state']); mysql_query("INSERT INTO `{$TABLE_PREFIX}accounts` SET organization = '".mysql_escape( $_REQUEST['organization'] )."', first_name = '".mysql_escape( $_REQUEST['first_name'] )."', middle_initial = '".mysql_escape( $_REQUEST['middle_initial'] )."', last_name = '".mysql_escape( $_REQUEST['last_name'] )."', email = '".mysql_escape( $_REQUEST['email'] )."', web_site = '".mysql_escape( $_REQUEST['web_site'] )."', facebook = '".mysql_escape( $_REQUEST['facebook'] )."', flickr = '".mysql_escape( $_REQUEST['flickr'] )."', linkedin = '".mysql_escape( $_REQUEST['linkedin'] )."', twitter = '".mysql_escape( $_REQUEST['twitter'] )."', blog = '".mysql_escape( $_REQUEST['blog'] )."', other_social_networking_site_name = '".mysql_escape( $_REQUEST['other_social_networking_site_name'] )."', other_social_networking_site_url = '".mysql_escape( $_REQUEST['other_social_networking_site_url'] )."', username = '".mysql_escape( $_REQUEST['username'] )."', password = '".mysql_escape( $passwordHash )."', street_address = '".mysql_escape( $_REQUEST['street_address'] )."', city = '".mysql_escape( $_REQUEST['city'] )."', state = '".mysql_escape( $_REQUEST['state'] )."', zip = '".mysql_escape( $_REQUEST['zip'] )."', day_phone = '".mysql_escape( $_REQUEST['day_phone'] )."', evening_phone = '".mysql_escape( $_REQUEST['evening_phone'] )."', cell_phone = '".mysql_escape( $_REQUEST['cell_phone'] )."', AllowedFolders = 'platinum', hidden = '0', disabled = '0', approved = '0', isAdmin = '0', expiresDate = (NOW() + INTERVAL 30 DAY), no_renewal = '0', neverExpires = '1', createdDate = NOW(), updatedDate = NOW(), createdByUserNum = '0', updatedByUserNum = '0'") or die("MySQL Error Creating Record:
\n". htmlspecialchars(mysql_error()) . "\n"); $userNum = mysql_insert_id(); // create accesslist entry // replace '_sample' with the table you want the user to access // replace '6' with the access level they should have: 0=none, 6=author, 9=editor // replace '1' with the max listings they are allowed mysql_query("INSERT INTO `{$TABLE_PREFIX}_accesslist` (userNum, tableName, accessLevel, maxRecords, randomSaveId) VALUES ($userNum, 'all', '1', NULL, '1234567890'), ($userNum, 'quick_start_guide_menu', '9', 1, '1234567890'), ($userNum, 'master_subscription_pages', '6', '$records_allowed', '1234567890'), ($userNum, 'master_event_titles', '6', '$records_allowed', '1234567890'), ($userNum, 'master_event_sub_category_titles', '6', '$records_allowed', '1234567890'), ($userNum, 'custom_branding', '6', 1, '1234567890'), ($userNum, 'email_signup', '6', NULL, '1234567890'), ($userNum, '_sample', '6', 1, '1234567890')") or die("MySQL Error Creating Access List:
\n". htmlspecialchars(mysql_error()) . "\n"); // send message $emailTemplate = "emails/user-new-signup.php"; $emailHeaders = emailTemplate_load(array( 'template' => websiteLogin_pluginDir() . "/$emailTemplate", 'subject' => '', // set in template 'from' => '', // set in template 'to' => $_REQUEST['email'], 'placeholders' => array( 'username' => array_key_exists('username', $_REQUEST) ? $_REQUEST['username'] : $_REQUEST['email'], // if using email as username then show that instead 'password' => $password, 'loginUrl' => "http://" . $_SERVER['HTTP_HOST'] . $GLOBALS['WEBSITE_LOGIN_LOGIN_FORM_URL'], ), )); $mailErrors = sendMessage($emailHeaders); if ($mailErrors) { die("Mail Error: $errors"); } // show thanks $errorsAndAlerts = "Thanks, We've created an account for you and emailed you your password.

\n"; $errorsAndAlerts .= "If you don't receive an email from us within a few minutes check your spam filter for messages from {$emailHeaders['from']}

\n"; $errorsAndAlerts .= "Click here to login."; $_REQUEST = array(); // clear form values $showSignupForm = false; } } ?> QART Guide - Platinum Subscription Signup


| |


             

QART GUIDE PLATINUM SUBSCRIPTION
SIGNUP FORM


Please fill out the form below and click on the submit button.

Your subscription request will be reviewed by our subscription committee and you'll receive a confirmation e-mail with your temporary password and login instructions.

Got Questions?   CLICK HERE TO CONTACT US

* = Required Field  
Organization Name (Optional) 
First Name *
Middle Initial (Optional) 
Last Name *
Street Address *
City *
State *
Zip Code *
Day Phone *
Evening Phone (Optional)
Cell Phone (Optional)
 
Email *
 
Choose a temporary Username *
 
OPTIONAL INFORMATION

Web Site URL

Blog

Facebook URL

Flickr URL

Linkedin URL

Twitter URL

Other Social Networking Site Name

Other Social Networking Site URL
   
CAPTCHA Image Verification
To help prevent spam, please type the characters in the image into the blank box before you click on submit.

 WHAT'S CAPTCHA?

CLICK TO CHANGE THE CHARACTERS DISPLAYED




By submitting this form you agree to abide by all the terms and conditions of a subscription to QART Guide.
CLICK HERE TO READ OUR TERMS

| |