SELECT UserId
FROM userlogins
WHERE UserLogin IS NOT NULL
AND UserLogin = '#login_name#'
AND UserWebId IS NOT NULL
SELECT UserId
FROM userlogins
WHERE useremail IS NOT NULL
AND useremail = '#email#'
AND UserStatusCD IS NOT NULL
AND (UserStatusCD = 'R')
INSERT INTO userlogins
(UserFirstName, UserLastName, UserType, UserFairName,
UserStreet, UserCtryId, UserProvId, UserCityName, UserPostalCode,
UserPhone,
UserEmail, UserLogin, UserPassword, UserVerifyQuestion, UserVerifyAnswer,
UserCreatedOn, UserStatusCd)
VALUES ('#first_name#', '#last_name#', '#user_type#', '#fair_name#',
'#street#', '#countryid#', '#provinceId#', '#city#', '#postal_code#',
'#phone#',
'#email#', '#login_name#', '#password_value#' ,
#Verify#, '#VerifyAnswer#',
#NOW()#, 'R');
SELECT UserId, UserType
FROM userlogins
WHERE userLogin IS NOT NULL
AND userLogin = '#login_name#'
Hello #login_name#,
Welcome to Craft Fairs and Shows and thank you for registering. To add listings to the
the website, login at: http://CraftFairsAndShows.com/Add-Listing.php
after logging in you will see a link in the menu to "Add a Listing". Please note,
all submissions are reviewed before they will appear in the live directory.
Normally this process takes up to 24 hours. We will send you an email when your
listing is live.
Please save your log-in information in a safe place.
Username: #login_name#
Password: #password_value#
Thank you for registering!
Membership Registration
Registering and adding a Craft Show, Farmer's
Market, Festival or other event is free
of charge and only takes a couple minutes. Your listing will
also be displayed on our Buy Local Website, www.BuyLocalThinkGlobal.com
Don't forget to add a link to your website!
Setting up links on other sites to point to your website is critical
to your online marketing strategy. You need links from reputable websites
that have been up and running for a while and have a good Google PageRank.
Please Note: Information entered
in the Member's Registration Form below will not be displayed on your
listing. After you complete the following form, you will be presented
with an Add Listing form on the following page where
you can enter your listing information to display online.
SELECT
states_provinces.provid,
states_provinces.prov_name,
states_provinces.state,
states_provinces.prov_url
FROM
states_provinces
WHERE states_provinces.provid IS NOT NULL
AND (states_provinces.provid > '0')
ORDER BY
states_provinces.prov_name
