R
E
S
O
U
R
C
E
S
       Home      Products & Services      Contact Us      Links


WebHatchers will design & develop your site for you.
_______________________

Website Menu Heaven: menus, buttons, etc.
_______________________

Send us your questions.
_______________________

site search by freefind
_______________________

HOME
SEO, Google, Privacy
   and Anonymity
Browser Insanity
JavaScript
Popups and Tooltips
Free Website Search
HTML Form Creator
Animation
Buttons and Menus
Counters
Captchas
Image Uploading
CSS and HTML
PHP
AJAX
XPATH
Website Poll
IM and Texting
Databases—MySQL
   or Not MySQL
Personal Status Boards
Content Management
   Systems
Article Content
   Management Systems
Website Directory
   CMS Systems
Photo Gallery CMS
Forum CMS
Blog CMS
Customer Records
   Management CMS
Address Book CMS
Private Messaging CMS
Chat Room CMS
JavaScript Charts
   and Graphs




Free Personal Status Boards (PSB™)

Free Standard Free PSB

Free PSB Pro Version

Free Social PSB

Free Social PSB Plus (with Email)

Free Business PSB

Free Business PSB Plus (with Email)

PSB demo

Social PSB demo

Business PSB demo

So what's all this PSB stuff about?

Chart comparing business status boards

PSB hosting diagram

PSB Licence Agreement



Copyright © 2002 -
MCS Investments, Inc. sitemap

PSBs, social networking, social evolution, microcommunities, personal status boards
PSBs, social networking, business personal status boards
website design, ecommerce solutions
website menus, buttons, image rotators
Ez-Architect, home design software
the magic carpet and the cement wall, children's adventure book
the squirrel valley railroad, model railroad videos, model train dvds
the deep rock railroad, model railroad videos, model train dvds

Customer Form — We Manually Search for Your Key If You Lost Your Key During the Week You Ordered

The scripts in the two link groups below are Customer Apps for Dealing with Product Keys and Email Addresses, and Administrator Apps for Dealing with Customer Records.

In our ecommerce world, products are sold by many different methods. Amongst these are getting out demos in various ways and when people try them, some of them are very pleased and they buy what's called a key. This unlocks the full feature set of the product when they enter it. There is a need to give the product users limited access to perform a few functions such as changing their emails, retrieving their keys from our database when they misplace them, etc. There is also a need for administrative functions to manage customer records. One needs to sort them, edit them, delete them, add them, view them, search them, register to be an administrator, login as administrator, etc.

If an ecommerce company does not have any of the applications below, it is forced to perform them the 20th century ways—by hand. This means paying for people to answer phones, write emails, keep paper files of customers, etc. The 21st century way is to let software perform these tasks, let websites and videos explain the product features, and let ecommerce close the sale and send the product.

Feel free to use these free Customer Records Management scripts in your business. Note: we know they work well for us (they are well tested), but we assume no liability for how they work in your situation. Similarly, we added lots of security measures such as extensive input filtering, but we make no claims and assume no liability for how securely they work in your situation.

The best security measure to take when using the administrative part of a system like this (meaning the Administrator Apps for Dealing with Customer Records, not the Customer Apps for Dealing with Product Keys and Email Addresses in which category the script below resides) is do not have any links ANYWHERE that link to the URLs of any of the admin files on the server, so neither hackers nor Google finds them. Then use the admin CMS yourself but do not even let your momma use it. Don't even save the link to the admin login as a Favorite, just to be secure. Just stick the login username and password in Roboform and make them impossible to guess. Then use Roboform to logon. The script below, and the other Customer Apps, are included online and linked to as part of the product web pages that make life easier for everyone. Their security is mainly handled via extreme input filtering. The Admin Apps are hidden, unlinked to, and well protected with security measures, password hashes and salts, etc.

This script is called lost-their-key-before-Monday.html


Customer Apps for Dealing with Product Keys and Email Addresses

Administrator Apps for Dealing with Customer Records

The form action in Customer Form — We Manually Search for Your Key If You Lost Your Key During the Week You Ordered is the script: lost-their-key-before-Monday.php. That script processes the data which the user enters in the form on this page. Note that in order to get a product key emailed to them, the users must enter not only the email address, but also their other data. The PHP script will filter the data that gets entered. The "before Monday" stuff is because we enter into the MySQL db new user data like keys every Monday from accumulated orders over the week. You may do it daily if you wish. But if you do it less than weekly, users that use the various user forms about getting keys or changing email addresses will have problems and will create difficulties for the administrator.

If a user is not sure of the email address that was used when the product key was purchased, the user may try several emails, separated by commas. The user will see this when entering email addresses: MAKE SURE THE FIRST ONE IS YOUR CURRENT EMAIL ADDRESS. The first one will be used as the response email for sending a key.

In the script below, the user is prompted for a lot of data. The more he inputs, the better the chance the people searching the database for his record will strike paydirt.

The reason the key for the product will not be conveniently displayed on the screen, but instead emailed to the user's email address is safety. Just because someone knows the email address of a person who he knows owns the Product does not mean we wish to show a key to him onscreen. By emailing it to what we know is a legitimate email address of a legitimate customer, no harm is done if he gets his key again even though he did not request it.

This script is called lost-their-key-before-Monday.html


THE NAVIGATION SCRIPT HAS BEEN OMITTED, AS IT WAS SPECIFIC TO A SPECIFIC COMPANY AND NOT USEFUL TO THIS SCRIPT FOR GENERAL PURPOSES. IF YOU NEED TO LEARN ABOUT NAVIGATION SCRIPTS, SEARCH OUR SITE AND OTHERS.

<center><div style='margin:170px 0 0 170px'><h1><b>We Manually Search for Your Key if you lost your key during the week you ordered</b></h1></div></center>

<DIV style="position:absolute; top:270px; left:200px; width:750px;">
<P>I have been unable to find my product key.<BR>
Please re-send the key you sent.<BR>
Here is what I know:<BR><BR></P>

<form method="post" action="lost-their-key-before-Monday.php">
<TBODY>
<TR>
<TD align=middle colSpan=2><FONT color=red>*</FONT> Indicates Required fields.<BR><BR>
</TD></TR>
<tr><td align=middle colSpan=2>Do not use any accent characters or punctuation when entering your name [grave, accent, umlaut, tilde] or Mr. Ms. Sr. Jr. or other prefixes or suffixes.<BR></td></tr>
<TR><TD align=right><FONT color=red>*</FONT> <span style='color:red'>First Name</span>: </TD>
<TD><INPUT maxLength=30 name=First size=30><BR><BR></TD></TR>
<TR><TD align=right><FONT color=red>*</FONT> <span style='color:red'>Last Name</span>: </TD>
<TD><INPUT maxLength=30 name=Last size=30><BR><BR></TD></TR>
<tr><td align=middle colSpan=2>Business name. Don't include Inc or Ltd, etc.<BR></td></tr>
<TR><TD colspan=2>Business name: <INPUT maxLength=99 name=bizname size=99><BR><BR></TD></tr>
<TR><TD colspan=2><FONT color=red>*</FONT>What is your current <span style='color:red'>email address</span> and what email address did you use when you ordered? If you're not sure, you may enter more than one email address. Separate them with commas, please. MAKE SURE THE FIRST ONE IS YOUR CURRENT EMAIL ADDRESS.<BR></TD></tr>
<TR><TD colspan=2>Email: <INPUT maxLength=255 name=email size=99><BR><BR></TD></tr>
<TR><TD colspan=2>Phone number on your order: <INPUT maxLength=20 name=phone size=20><BR><BR></TD></tr>
<TR><TD colspan=2>Street: <INPUT maxLength=30 name=street size=30><BR><BR></TD></tr>
<TR><TD colspan=2>City: <INPUT maxLength=35 name=city size=35><BR><BR></TD></tr>
<tr><td colspan=2>State:<BR> <select name="state" size='4'>
<option value="AL">Alabama</option>
<option value="AK">Alaska</option>
<option value="AZ">Arizona</option>
<option value="AR">Arkansas</option>
<option value="CA">California</option>
<option value="CO">Colorado</option>
<option value="CT">Connecticut</option>
<option value="DE">Delaware</option>
<option value="DC">District of Columbia</option>
<option value="FL">Florida</option>
<option value="GA">Georgia</option>
<option value="HI">Hawaii</option>
<option value="ID">Idaho</option>
<option value="IL">Illinois</option>
<option value="IN">Indiana</option>
<option value="IA">Iowa</option>
<option value="KS">Kansas</option>
<option value="KY">Kentucky</option>
<option value="LA">Louisiana</option>
<option value="ME">Maine</option>
<option value="MD">Maryland</option>
<option value="MA">Massachusetts</option>
<option value="MI">Michigan</option>
<option value="MN">Minnesota</option>
<option value="MS">Mississippi</option>
<option value="MO">Missouri</option>
<option value="MT">Montana</option>
<option value="NE">Nebraska</option>
<option value="NV">Nevada</option>
<option value="NH">New Hampshire</option>
<option value="NJ">New Jersey</option>
<option value="NM">New Mexico</option>
<option value="NY">New York</option>
<option value="NC">North Carolina</option>
<option value="ND">North Dakota</option>
<option value="OH">Ohio</option>
<option value="OK">Oklahoma</option>
<option value="OR">Oregon</option>
<option value="PA">Pennsylvania</option>
<option value="RI">Rhode Island</option>
<option value="SC">South Carolina</option>
<option value="SD">South Dakota</option>
<option value="TN">Tennessee</option>
<option value="TX">Texas</option>
<option value="UT">Utah</option>
<option value="VT">Vermont</option>
<option value="VA">Virginia</option>
<option value="WA">Washington</option>
<option value="WV">West Virginia</option>
<option value="WI">Wisconsin</option>
<option value="WY">Wyoming</option>
</select><BR><BR></td></tr>
<TR><TD colspan=2>Zip code: <INPUT maxLength=5 name=zip size=5><BR><BR></TD></tr>
<TR><TD colspan=2>Order number: <INPUT maxLength=30 name=ordernumber size=30><BR><BR></TD></tr>
<TR><TD colspan=2><FONT color=red>*</FONT><span style='color:red'>Approximate date</span> I ordered the program (look at the date of your install directory and dates on your earliest product files for some hints)<BR></TD></tr>
<TR><TD colspan=2>Date: <INPUT maxLength=20 name=date size=20><BR><BR></TD></tr>
<TR><TD><BR><INPUT name="submit" type=submit value=" Submit Form "><BR><BR></TD>
<TD><BR><INPUT name="reset" type=reset value=" Reset and Start Over "><BR><BR></TD></TR></TBODY></TABLE></FORM>
</DIV>