XCtM Module 1 API Validate

Your API access needs to be validated so you don't suffer from unauthorizied lookups. 

This is a very simple SQL table matching lookup. 
My guess is you will have a Random vNarChar

TABLE Users

[ID] [int] NOT NULL,
[SiteTrack] [nvarchar](10) NOT NULL,
[Domain] [nvarchar](75) NULL,
[Email] [nvarchar](75) NULL,
[Name] [nvarchar](75) NULL,
[Subject] [nvarchar](100) NULL,
[APIKey] [nvarchar](10) NOT NULL,
[Notification] [int] NULL

The Function or Code that uses this table is called APIValidate()

The Site Track is a short alpha name for your website which identifies you from others.

The Domain is only reference used in Emails.

The Email, Name and Subject are for notification emails.

The APIKey is a simple random alphanumeric combination.

The Notification is just an on/off 1 or 0 if you require email notifications. At times the flow was so high I shut down the email notification and made an RSS Feed stream the reports to a static page.

The code looks like this.