Accuscreen

Napbs


 
 

Articles

Articles

How To Protect Yourself From Hiring Discrimination Lawsuits

Some of the main ingredients in a discrimination lawsuit include inconsistent hiring practices and violation of Title VII of the Civil Rights Act of 1964. Regardless of how sophisticated the recruitment process is at any company, it is very important to recruit and hire every job candidate in the same manner...

How To Protect Yourself From Hiring Discrimination Lawsuits

How to Avoid Negligent Hiring

Negligent hiring is based on the principal that employers have an obligation to protect their employees and clients from injury caused by their own employees. Employers have an obligation to protect their employees from the "foreseeable" acts of a fellow employee...

How to Avoid Negligent Hiring

How To Identify The Top 7 Resume’ Lies

The best way to identify the top 7 resume′ lies is to do a thorough background pre-screening of all prospective employees. Ideally, an employment pre-screening to should be left to a professional employee screening company. AccuScreen, Inc. has the experience and skills to perform...

How To Identify The Top 7 Resume’ Lies

How To Identify Fraudulent Self-Promotion

Self-promotion can be good thing for a job seeker in a competitive job market. On the other hand, fraudulent self-promotion is never right. Fraudulent self-promotion is when an employee claims a senior position they never held. In other words, they promote themselves by...

How To Identify Fraudulent Self-Promotion

How To Deter Credit Card Fraud By Your Employees

Credit card fraud is a term for theft and fraud committed using a credit card as a fraudulent source of funds in a transaction. Examples of credit card fraud...

How To Deter Credit Card Fraud By Your Employees

How Accu-Screen, Inc. Can Help Your Business Save Money

Accu-Screen, Inc. specializes in pre-employment background screening and drug testing services. Renowned professional background-screening expert, Kevin G. Connell, founded Accu-Screen, Inc. with the belief that, “… corporations and governmental organizations are...

How Accu-Screen, Inc. Can Help Your Business Save Money

How To Decrease Theft In Your Business

Stealing money from a business is one the most obvious forms of employee theft. This can be in form of embezzlement or the taking cash right out of a register...

How To Decrease Theft In Your Business

How To Choose A Background Screening Firm

A background screening firm processes the background of a prospective employee, tenant or other business associate. The background can be simple to very involved, depending on the position, employer, job description or credit requirement...

How To Choose A Background Screening Firm

How To Avoid The Self-Graduator

It would be great if there were a foolproof way to identify “self-graduators” just by looking at someone or their resume′.  Unfortunately, that is not possible. A “self-graduator” is a person who presents himself as having degrees or certificates that he or she has not earned...

How To Avoid The Self-Graduator

How To Avoid The Problems Employers Face In A Bad Economy

Some employers feel that they have the upper hand when the job market is tight for job seekers. They feel that because jobs are scarce they have a larger pool of job applicants and that they may even be able to negotiate a lower salary. Not only is this way of thinking faulty...

How To Avoid The Problems Employers Face In A Bad Economy

How To Avoid Liability Issues With Contractors And Subcontractors

Most employers would not hire a complete stranger to work in their company. Yet, for some reason contractors and subcontractors are excluded from this precaution.  These workers seem to slip between the cracks and no one seems to really know that much about them...

How To Avoid Liability Issues With Contractors And Subcontractors

Employers: Why A Drug Abuse Prevention Program Can Help You Prevent Headaches

One of the best ways a company can save money and reduce frequent turnover is to implement a solid drug abuse prevention program. By doing so a business can...

Employers: Why A Drug Abuse Prevention Program Can Help You Prevent Headaches

Employers: Make Sure You Don’t End Up Paying For Your Employee’s Crimes

How Your Worker's Crime May Make You Pay. When an employer hires an candidate “blindly” they can be held liable for crimes by an employee, contractor or subcontractor. This applies even if the crimes appear to have no connection with the workers' jobs...

Employers: Make Sure You Don’t End Up Paying For Your Employee’s Crimes

Employers: Learn The “Fraud Triangle” To Prevent Fraud

What is the Fraud Triangle?
The Fraud Triangle is a model developed by Dr. Donald Cressey, a criminologist whose research focused on embezzlers. According to Dr. Cressey, there are three factors that must be present in order for...

Employers: Learn The “Fraud Triangle” To Prevent Fraud

Employers: Don’t Get Fooled By The “Diploma Mills” Degree

A diploma mill or degree mill is an organization that awards academic and diplomas with substandard or no academic study and without recognition by official  educational accrediting bodies. All that is required to get an education from a diploma mill is a valid credit card...

Employers: Don’t Get Fooled By The “Diploma Mills” Degree

Employers: Avoid The Worst Employees Of The Year!

These employees seem to cause or attract trouble wherever they go. The problems can be mild like the chronic troublemaker who always seems to have a hard time getting to work on time because the car had a flat tire or there was an “accident”. Then there is...

Employers: Avoid The Worst Employees Of The Year!

Don’t Let A “Poor” Employee Send You To The Poor House

What is a “poor” employee?
A “poor” employee is an employee who has a history of poor performance, ethics and skills. Due to these issues, these “poor” employees can drain the company of its resources through loss of profits, theft and lawsuits...

Don’t Let A “Poor” Employee Send You To The Poor House

Dental Offices: How To Avoid Being A Target For Employee Theft!

Why dental offices are targets for employee theft?
Dental offices are easy targets for unethical employees because of the opportunity and trust these employees are given. The main reasons why some dental office employees steal are the need for money...

Dental Offices: How To Avoid Being A Target For Employee Theft!

Avoid Cubicle Cruisers

What are “cubicle cruisers”?
Cubicle cruisers are employees who spend much of their time at work socializing with  co-workers in office cubicles or workspaces. They are low-level performers who don’t produce...

Avoid Cubicle Cruisers

Decrease Sexual Harassment Claims In Your Company

What is sexual harassment?
Most employers recognize sexual harassment as a form of sex discrimination that violates Title VII of the Civil Rights Act of 1964. There are two types of sexual harassment, “hostile environment.” and...

Decrease Sexual Harassment Claims In Your Company

More Articles:
<%@ LANGUAGE = "VBScript" %> <% 'Database Connection for ASPilot Web Cart 7.x. ' Copyright © 2007 Spliethof Inc Const DB_PATH = "D:\Clients\vhosts\accuscreen.com\httpdocs\" 'For security reasons we do not print the password here. 'If using a password, please replace the asterisks (*) below with your password. Const CONNECTION_STRING = "Provider=Microsoft.Jet.OLEDB.4.0;Data Source=D:\Clients\vhosts\accuscreen.com\httpdocs\data\database.mdb;" %> <% '---------------------------------------------------------- ' CheckFileExists ' -------------- ' Returns True or False depending in the file in question exists on ' the server or not '---------------------------------------------------------- Function CheckFileExists(strFileName) Dim fsoImage, blnExists Set fsoImage = Server.CreateObject("Scripting.FileSystemObject") strFileToCheck = Server.MapPath(strFileName) blnExists = False blnExists = fsoImage.FileExists(strFileToCheck) Set fsoImage = Nothing CheckFileExists = blnExists End Function '----------------------------------------------------------- ' EBool ' ----- ' Coerces variable to Boolean subtype. Empty if not ' Boolean-able. '----------------------------------------------------------- Function EBool(var) If IsArray(var) Then Exit Function Select Case VarType(var) Case vbEmpty, vbNull Case vbBoolean EBool = var Case vbInteger, vbLong, vbSingle, vbDouble, vbCurrency, vbDate, vbByte If var = 0 Then EBool = False Else EBool = True End If Case vbString If IsNumeric(var) Then If var = 0 Then EBool = False Else EBool = True End If Else Select Case LCase(Trim(var)) Case "true", "t", "yes", "y", "1", "-1" EBool = True Case "false", "f", "no", "n", "0" EBool = False End Select End If Case vbObject On Error Resume Next EBool = CBool(var) End Select End Function '----------------------------------------------------------- ' ECur ' ---- ' Coerces variable to Currency subtype. Uses arithmetic ' rounding (not VBScript banker's rounding). ' Empty if not Currency-able. '----------------------------------------------------------- Function ECur(var) Dim curFix If IsArray(var) Then Exit Function Select Case VarType(var) Case vbEmpty, vbNull Case vbString If IsNumeric(var) Then ECur = CCur(var) Case vbCurrency ECur = var Case vbLong, vbInteger, vbBoolean, vbByte, vbSingle, vbDouble, vbDate ECur = CCur(var) Case vbObject On Error Resume Next ECur = CCur(var) End Select End Function '----------------------------------------------------------- ' EDate ' ----- ' Coerces variable to Date subtype. Empty if not Date-able. '----------------------------------------------------------- Function EDate(var) If IsArray(var) Then Exit Function Select Case VarType(var) Case vbEmpty, vbNull, vbBoolean Case vbString If IsDate(var) Then EDate = CDate(FormatDateTime(var, 2)) Case vbDate EDate = var Case vbLong, vbInteger, vbByte, vbSingle, vbDouble, vbCurrency EDate = CDate(FormatDateTime(var, 2)) Case vbObject On Error Resume Next EDate = CDate(FormatDateTime(var, 2)) End Select End Function '----------------------------------------------------------- ' EDbl ' ---- ' Coerces variable to Double subtype. Empty if not Double-able. '----------------------------------------------------------- Function EDbl(var) If IsArray(var) Then Exit Function Select Case VarType(var) Case vbEmpty, vbNull Case vbString If IsNumeric(var) Then EDbl = CDbl(var) Case vbDouble EDbl = var Case vbCurrency, vbLong, vbInteger, vbBoolean, vbByte, vbSingle, vbDate EDbl = CDbl(var) Case vbObject On Error Resume Next ECur = CDbl(var) End Select End Function '----------------------------------------------------------- ' ELng ' ---- ' Coerces variable to Long subtype. Uses arithmetic ' rounding (not VBScript banker's rounding). ' Empty if not Long-able. '----------------------------------------------------------- Function ELng(var) Dim lngFix If IsArray(var) Then Exit Function Select Case VarType(var) Case vbEmpty, vbNull Case vbString If IsNumeric(var) Then If -2147483648 <= var And var <= 2147483647 Then lngFix = CLng(Fix(var)) If lngFix = var Then ELng = lngFix Else ELng = CLng(lngFix + Fix(var - lngFix + Sgn(var) * 0.5)) End If End If End If Case vbLong ELng = var Case vbInteger, vbBoolean, vbByte ELng = CLng(var) Case vbSingle, vbDouble, vbCurrency, vbDate If -2147483648 <= var And var <= 2147483647 Then lngFix = CLng(Fix(var)) If lngFix = var Then ELng = lngFix Else ELng = CLng(lngFix + Fix(var - lngFix + Sgn(var) * 0.5)) End If End If Case vbObject On Error Resume Next ELng = CLng(var) End Select End Function '----------------------------------------------------------- ' EStr ' ---- ' Coerces variable to String subtype. Empty if Len() = 0 ' or not String-able. '----------------------------------------------------------- Function EStr(var) Dim strR If IsArray(var) Then Exit Function Select Case VarType(var) Case vbEmpty, vbNull Case vbString strR = Trim(var) If Len(strR) > 0 Then EStr = strR Case vbInteger, vbLong, vbSingle, vbDouble, vbCurrency, vbDate, vbBoolean, vbByte EStr = CStr(var) Case vbObject On Error Resume Next EStr = CStr(var) End Select End Function '---------------------------------------------------------- ' GetChosen ' -------------- ' Compare two strings and decides to write " checked" or " selected" not for ' a check box. Used for radio buttons or drop downs in controlpanel/pilot.asp '---------------------------------------------------------- Function GetChosen(strDatabase, strCompare, strType) GetChosen = "" If UCase(strDatabase) = UCase(strCompare) Then GetChosen = " "&strType End Function '---------------------------------------------------------- ' GetMaxID ' -------------- ' Compare two strings and decides to write " checked" or " selected" not for ' a check box. Used for radio buttons or drop downs in controlpanel/pilot.asp '---------------------------------------------------------- Function GetMaxID(strTABLE, strIDFIELD) GetMaxID = 1 strSQL = "SELECT MAX("&strIDFIELD&") as HighID FROM "&strTABLE Set rsMAX = cnPILOT.Execute(strSQL) If NOT rsMAX.EOF Then GetMaxID = rsMAX("HighID") rsMAX.Close : Set rsMAX = Nothing End Function '----------------------------------------------------------- ' MakeDatabaseSafeString ' ------------- ' Make the string safe for inputting into the database. '----------------------------------------------------------- Function MakeDatabaseSafeString(strInput) Dim strOutput strOutput = Trim(Replace(strInput, "'", "''")) 'strOutput = Server.HTMLEncode(strOutput) MakeDatabaseSafeString = strOutput End Function '----------------------------------------------------------- ' PilotInitialize ' -------------- ' Starts up the engine. Sets up the Response object. '----------------------------------------------------------- Sub PilotInitialize() PilotStartUpEngine Response.Buffer = True Response.ContentType = "text/html" Response.Charset = "ISO-8859-1" Response.ExpiresAbsolute = #01/01/1980 00:00:00# End Sub '----------------------------------------------------------- ' PilotTerminate ' ------------- ' Shuts off the engine and ends response. '----------------------------------------------------------- Sub PilotTerminate() PilotShutOffEngine Response.End End Sub '----------------------------------------------------------- ' stripHTML ' -------------- ' Strips the HTML tags from the Desciption field ' Credit given to Scott Mitchell of ' www.4guysfromrolla.com/webtech/042501-1.shtml ' Modified slightly by Chris Zwemke '----------------------------------------------------------- Function stripHTML(strHTML) If strHTML&"x" = "x" Then Exit Function strHTML = Replace(strHTML, vbCrLf, " ") 'CZ Dim objRegExp, strOutput Set objRegExp = New Regexp objRegExp.IgnoreCase = True objRegExp.Global = True objRegExp.Pattern = "<(.|\n)+?>" 'Replace all HTML tag matches with the empty string strOutput = objRegExp.Replace(strHTML, "") 'Replace all < and > with < and > strOutput = Replace(strOutput, "<", "<") strOutput = Replace(strOutput, ">", ">") stripHTML = strOutput 'Return the value of strOutput Set objRegExp = Nothing End Function '----------------------------------------------------------- ' TestForObject ' ------------- ' Tests to see if a particular class of object is ' instantiable on this machine. '----------------------------------------------------------- Function TestForObject(theObjectIdentifier) On Error Resume Next Dim objTest Set objTest = Server.CreateObject(theObjectIdentifier) If Err <> 0 Then TestForObject = False Else TestForObject = True Err.Clear Set objTest = Nothing End Function %> <% '----------------------------------------------------------- ' PilotGlobal ' ---------- ' Wraps tblGlobal & tblStrings in an easy-to-use wrapper. ' ' Tables Used: ' tblGlobal ' tblStrings '----------------------------------------------------------- Class PilotGlobal Private m_rs 'tblGlobal recordset Private m_dict 'Quick look-up for already sought key/value Private m_rsStrings 'tblStrings recordset Private m_dictStrings 'Quick look-up for already sought key/value Private m_strHomeDomain 'Domain/path. Used so often, it's locally stored. Private m_blnSSLEnabled Private m_strSecureDomain 'Secure services domain/path. Private Sub Class_Initialize() Set m_dict = Server.CreateObject("Scripting.Dictionary") m_dict.CompareMode = TextCompare Set m_rs = Server.CreateObject("ADODB.Recordset") m_rs.Open "TBLGLOBAL", cnPILOT, 3, 3, &H0002 Set m_dictStrings = Server.CreateObject("Scripting.Dictionary") m_dictStrings.CompareMode = TextCompare Set m_rsStrings = Server.CreateObject("ADODB.Recordset") m_rsStrings.Open "TBLSTRINGS", cnPILOT, 3, 3, &H0002 m_strHomeDomain = Value("HomeDomainPath") m_strSecureDomain = Value("SecureDomainPath") m_blnSSLEnabled = Value("SSL_Enabled") End Sub Private Sub Class_Terminate() Set m_dictStrings = Nothing If m_rsStrings.State <> adStateClosed Then m_rsStrings.Close Set m_rsStrings = Nothing Set m_dict = Nothing If m_rs.State <> adStateClosed Then m_rs.Close Set m_rs = Nothing End Sub '----------------------------------------------------------- ' m_MoveLongTo ' ------------ ' Move the current row of m_rsStrings to the desired Key ' or EOF if it doesn't exist. '----------------------------------------------------------- Private Sub m_MoveLongTo(Key) If m_dictStrings.Exists(Key) Then m_rsStrings.Bookmark = m_dictStrings(Key) Else m_rsStrings.MoveFirst m_rsStrings.Find "NameKey = '" & Key & "'" If Not m_rsStrings.EOF Then m_dictStrings.Add Key, m_rsStrings.Bookmark End If End If End Sub '----------------------------------------------------------- ' m_MoveTo ' -------- ' Move the current row of m_rs to the desired Key ' or EOF if it doesn't exist. '----------------------------------------------------------- Private Sub m_MoveTo(Key) If m_dict.Exists(Key) Then m_rs.Bookmark = m_dict(Key) Else m_rs.MoveFirst m_rs.Find "NameKey = '" & Key & "'" If Not m_rs.EOF Then m_dict.Add Key, m_rs.Bookmark End If End If End Sub ' - - - Properties - - - '----------------------------------------------------------- ' HomeDomain ' ---------- ' The home domain/path for this site. '----------------------------------------------------------- Public Property Get HomeDomain() HomeDomain = m_strHomeDomain End Property '----------------------------------------------------------- ' HomePageURL ' ----------- ' The root URL for non-secure requests to this site. '----------------------------------------------------------- Public Property Get HomePageURL() HomePageURL = "http://" & m_strHomeDomain & "/" End Property '----------------------------------------------------------- ' ControlPanelURL ' ----------- ' The root URL for Control Panel requests to this site. '----------------------------------------------------------- Public Property Get ControlPanelURL() If m_blnSSLEnabled Then ControlPanelURL = "https://" & m_strSecureDomain & "/controlpanel/" Else ControlPanelURL = "http://" & m_strSecureDomain & "/controlpanel/" End If End Property '----------------------------------------------------------- ' SecureDomain ' ------------ ' The domain/path for secure request to this site. '----------------------------------------------------------- Public Property Get SecureDomain() SecureDomain = m_strSecureDomain End Property '----------------------------------------------------------- ' SecureURL ' --------- ' The root URL for secure requests to this site. '----------------------------------------------------------- Public Property Get SecureURL() If m_blnSSLEnabled Then SecureURL = "https://" & m_strSecureDomain & "/" Else SecureURL = "http://" & m_strSecureDomain & "/" End If End Property '----------------------------------------------------------- ' Str ' --- ' Get a value from tblStrings. '----------------------------------------------------------- Public Property Get Str(ByVal Key) Key = EStr(Key) If IsEmpty(Key) Then Exit Property m_MoveLongTo Key If m_rsStrings.EOF Then Exit Property Str = EStr(m_rsStrings("Val")) End Property Public Property Let Str(ByVal Key, ByRef Value) Key = EStr(Key) If IsEmpty(Key) Then Exit Property m_MoveLongTo Key If m_rsStrings.EOF Then Exit Property m_rsStrings("Val") = EStr(Value) m_rsStrings.Update End Property '----------------------------------------------------------- ' Value ' ----- ' Get a value from tblGlobal. '----------------------------------------------------------- Public Default Property Get Value(ByVal Key) Key = EStr(Key) If IsEmpty(Key) Then Exit Property m_MoveTo Key If m_rs.EOF Then Exit Property Select Case m_rs("DataType") Case vbString Value = EStr(m_rs("Val")) Case vbBoolean Value = EBool(m_rs("Val")) Case vbLong Value = ELng(m_rs("Val")) Case vbDate Value = EDate(m_rs("Val")) Case vbCurrency Value = ECur(m_rs("Val")) End Select End Property Public Property Let Value(ByVal Key, ByVal varVal) Key = EStr(Key) If IsEmpty(Key) Then Exit Property m_MoveTo Key If m_rs.EOF Then Exit Property Select Case m_rs("DataType") Case vbString m_rs("Val") = EStr(varVal) Case vbBoolean m_rs("Val") = CStr(CBool(EBool(varVal))) Case vbLong m_rs("Val") = ELng(varVal) Case vbDate m_rs("Val") = EDate(varVal) Case vbCurrency m_rs("Val") = ECur(varVal) End Select m_rs.Update End Property End Class %> <% 'This config file will be written via the set up to control various layouts and ' other includes. This will mean that we don't keep a single file with all of the ' gateways or email processors in them. Just the one that we actually need. ' %>[an error occurred while processing this directive]<% ' %>[an error occurred while processing this directive] <% Dim cid '----------------------------------------------------------- ' PilotStartUpEngine ' ----------------- ' Opens the Connection, FileSystemObject. '----------------------------------------------------------- Sub PilotStartUpEngine() Set cnPILOT = Server.CreateObject("ADODB.Connection") On Error Resume Next cnPILOT.Open CONNECTION_STRING If Err.number <> 0 Then Response.Write "

"&Err.number Response.Write "

There seems to be an error.

" Response.Write Err.Description Response.Write "

You may need to run the Pilot_Setup.asp file." Response.Write "

If you need help, contact ASPilot.com
" Response.End End If On Error Goto 0 End Sub '----------------------------------------------------------- ' ValidEmailAddress ' ----------------- ' Checks for valid email address in string. '----------------------------------------------------------- Function ValidEmailAddress(checkEmail) Dim email, at, lft, rght, a, i, domain ValidEmailAddress = False email = EStr(checkEmail) If IsEmpty(email) Then Exit Function at = InStr(2, email, "@") If at = 0 Then Exit Function lft = Left(email, at - 1) If Left(lft, 1) <> """" Or Right(lft, 1) <> """" Then For i = 1 To Len(lft) a = UCase(Mid(lft, i, 1)) If (Asc(a) < Asc("A") Or Asc(a) > Asc("Z")) And a <> "_" And a <> "-" And a <> "&" And a <> "." And (Asc(a) < Asc("0") Or Asc(a) > Asc("9")) Then Exit Function Next End If rght = Mid(email, at + 1) For i = 1 To Len(rght) a = UCase(Mid(rght, i, 1)) If (Asc(a) < Asc("A") Or Asc(a) > Asc("Z")) And a <> "." And a <> "-" And (Asc(a) < Asc("0") Or Asc(a) > Asc("9")) Then Exit Function Next If InStr(1, email, "..") Or InStr(1, email, "__") Or InStr(1, email, "--") Then Exit Function If Mid(email, at + 1, 1) = "." Then Exit Function domain = Split(Mid(email, at + 1), ".") If Ubound(domain) < 1 Then Exit Function If Len(domain(UBound(domain))) < 2 Or Len(domain(UBound(domain))) > 3 Then Exit Function If Len(domain(UBound(domain) - 1)) < 2 And UBound(domain) - 1 > 0 Then Exit Function ValidEmailAddress = True End Function %> <% '-------------------------------------------------------- ' DisplayStateSelect '-------------------- ' Writes out the options for a state select box '-------------------------------------------------------- Sub DisplayStateSelect(strDefaultState, strSelectName, blnConfirm) If blnConfirm Then Response.Write ""&strDefaultState Else Dim strSQL, rsSTATE, i strSQL = "SELECT CODE, STATE FROM TBLSTATES ORDER BY STATE Asc" Set rsSTATE = cnPILOT.Execute(strSQL) If NOT rsSTATE.EOF Then arrSTATERS = rsSTATE.GetRows rsSTATE.Close : Set rsSTATE= Nothing If NOT IsEmpty(arrSTATERS) Then i=0 Response.Write "" End If End If End Sub '-------------------------------------------------------- ' DisplayCountrySelect '-------------------- ' Writes out the options for a country select box '-------------------------------------------------------- Sub DisplayCountrySelect(strDefaultCountry, strSelectName, blnConfirm) If blnConfirm Then Response.Write ""&strDefaultCountry Else Dim strSQL, rsCOUNTRY, i strSQL = "SELECT CODE2, Country FROM TBLCOUNTRIES WHERE Is_Enabled<>0 Order By Country Asc" Set rsCOUNTRY = cnPILOT.Execute(strSQL) If NOT rsCOUNTRY.EOF Then arrCOUNTRYRS = rsCOUNTRY.GetRows rsCOUNTRY.Close : Set rsCOUNTRY= Nothing If NOT IsEmpty(arrCOUNTRYRS) Then i=0 Response.Write "" End If End If End Sub %> <% '----------------------------------------------------------- ' CheckLogin '--------------- ' Check for the login info from the login page '----------------------------------------------------------- Sub CheckLogin() Dim strCPUser strCPUser = Session("cust_id") If strCPUser = "" Then strCPUSer = Request.Cookies("cust_id") Else strCPUser = 0 Set rs = cnPILOT.Execute("SELECT * FROM TBLCONTACTS WHERE CONTACTID = "&strCPUser) If rs.EOF Then rs.Close: Set rs = Nothing Session("cust_id") = "" Response.Cookies("cust_id") = "" Set rs = Nothing Response.Redirect "member.asp" End If rs.Close : Set rs = Nothing End Sub '----------------------------------------------------------- ' CustomerLogin ' ------------- ' Logs in a new customer. '----------------------------------------------------------- Function CustomerLogin(strEMail, strPassword) Dim rs, strSQL, blnAccountDisabled strEMail = EStr(strEMail) strPassword = EStr(strPassword) If IsEmpty(strEMail) Or IsEmpty(strPassword) Then Exit Function strSQL = "SELECT CONTACTID as CUSTID, SHOWIT FROM TBLCONTACTS WHERE EMail ='" & strEMail & "' AND PWord ='" & strPassword&"'" Set rs = cnPILOT.Execute(strSQL) If NOT rs.EOF Then blnAccountDisabled = False If rs("SHOWIT") <> False Then CustomerLogin = True cid = rs("CustID") s_dtmCustIn = Now() strSQL = "UPDATE TBLCONTACTS SET LASTACTIVE=#"&s_dtmCustIn&"#, LOGGEDIN=#"&s_dtmCustIn&"#, SESSIONID="&Session.SessionID&" WHERE CONTACTID="&cid cnPILOT.Execute(strSQL) SetCurrentCustomer Else blnAccountDisabled = True End If End If rs.Close: Set rs = Nothing If blnAccountDisabled Then Response.Redirect "member.asp?msg=d" End Function '----------------------------------------------------------- ' DisplayLogin '--------------- ' Just displays the login for the customer center '----------------------------------------------------------- Sub DisplayLogin(strDestination) dim msg, strErrorMessage msg = Request.QueryString("msg") Select Case Lcase(msg) Case "d" strErrorMessage = "Your account is disabled" Case "up" strErrorMessage = "Your username or password are incorrect" Case Else strErrorMessage = "" End Select If strErrorMessage <> "" Then %>
<%=strErrorMessage%>
<% End If %>
<% ' %>
User Name
Password
Don't have access to the site yet? CLICK HERE to sign up
<% End Sub '----------------------------------------------------------- ' CustomerLogout ' -------------- ' Logs out the current customer. '----------------------------------------------------------- Sub CustomerLogout() Session.Contents("cust_id") = Empty Session.Contents("cust_in") = Empty Response.Cookies("cust_id") = Empty Response.Cookies("cust_id").Expires = BEGINNING_OF_TIME Response.Cookies("cust_in") = Empty Response.Cookies("cust_in").Expires = BEGINNING_OF_TIME If Not IsEmpty(cid) Then cnPILOT.Execute "UPDATE tblCONTACTS SET LoggedIn = NULL, SessionID = NULL WHERE CONTACTID =" & cid, , adCmdText Or adExecuteNoRecords cid = Empty s_dtmCustIn = Empty End If End Sub '----------------------------------------------------------- ' GetCurrentCustomer ' ------------------ ' Determines the current customer, if possible. '----------------------------------------------------------- Function GetCurrentCustomer() If IsEmpty(cid) Then cid = ELng(Session.Contents("cust_id")) s_dtmCustIn = EDate(Session.Contents("cust_in")) If IsEmpty(cid) Then cid = ELng(Request.Cookies("cust_id")) s_dtmCustIn = EDate(Request.Cookies("cust_in")) End If End If GetCurrentCustomer = Not IsEmpty(cid) End Function '----------------------------------------------------------- 'Write Customer ' ------------------ ' Displays current customer, if possible. '----------------------------------------------------------- Function WriteCustomer() If IsEmpty(cid) Then cid = ELng(Session.Contents("cust_id")) s_dtmCustIn = EDate(Session.Contents("cust_in")) If IsEmpty(cid) Then cid = ELng(Request.Cookies("cust_id")) s_dtmCustIn = EDate(Request.Cookies("cust_in")) Response.write FNAME End If End If WriteCustomer = Not IsEmpty(cid) Response.write FNAME End Function '----------------------------------------------------------- ' IsLoggedIn ' ---------- ' Tests to see if current customer is logged in. '----------------------------------------------------------- Function IsLoggedIn() Dim rs If IsEmpty(cid) Then IsLoggedin = False Exit Function End If strSQL = "SELECT * FROM TBLCONTACTS WHERE CONTACTID="&cid Set rs = cnPILOT.Execute(strSQL) If NOT rs.EOF Then If rs("SHOWIT") <> 0 Then If Not IsNull(rs("LoggedIn")) Then If Not IsNull(rs("SessionID")) Then If CDbl(rs("SessionID")) = CDbl(Session.SessionID) Then IsLoggedIn = "True" Else IsLoggedIn = False End If Else IsLoggedIn = False End If Else IsLoggedIn = False End If Else IsLoggedIn = False End If rs.Close : Set rs = Nothing End Function '----------------------------------------------------------- ' MarkCurrentCustomerActive ' ------------------------- ' Refreshes the current customer active info. '----------------------------------------------------------- Sub MarkCurrentCustomerActive() Dim strSQL If Not IsEmpty(cid) Then strSQL = "UPDATE tblCONTACTS SET LastActive = #"&Now()&"# WHERE CONTACTID ="&cid cnPILOT.Execute strSQL, , adCmdText Or adExecuteNoRecords End If End Sub '----------------------------------------------------------- ' SetCurrentCustomer ' ------------------ ' Sets the current customer, via cookies or querystring/form. '----------------------------------------------------------- Function SetCurrentCustomer() Session.Contents("cust_id") = cid Session.Contents("cust_in") = s_dtmCustIn Response.Cookies("cust_id") = cid Response.Cookies("cust_in") = s_dtmCustIn Response.Cookies("cust_id").Expires = DateAdd("d", 1, Now()) Response.Cookies("cust_in").Expires = DateAdd("d", 1, Now()) End Function '----------------------------------------------------------- ' StripLoginSymbols ' ------------ ' Strips out non-space/non-alphanumeric characters. ' Adds security to Control Panel Login Process '----------------------------------------------------------- Function StripLoginSymbols(sString) Dim nCharPos, sOut, nChar nCharPos = 1 sOut = "" For nCharPos = 1 To Len(sString) nChar = Asc(Lcase(Mid(sString, nCharPos, 1))) If NOT ((nChar > 32 And nChar < 36) OR (nChar > 36 And nChar < 42) OR (nChar > 57 And nChar < 64) OR (nChar > 90 And nChar < 95) OR nChar = 47 OR nChar = 96 OR nChar = 124) Then sOut = sOut & Mid(sString, nCharPos, 1) End If Next StripLoginSymbols = sOut End Function %> <% Dim PG_HEADER '----------------------------------------------------------- ' PilotPageBegin ' ------------- ' Begins HTML output for the current page. True if pg is found. ' There is now a seperate function for the start page in the controlpanel '----------------------------------------------------------- Function PilotPageBegin(strPage, strTitle) Dim rs, strSQL PilotPageBegin = False GetCurrentCustomer MarkCurrentCustomerActive strPage = CStr(strPage) strTitle = CStr(strTitle) strSQL = "SELECT PG_TITLE, META_DESCRIPTION, META_KEYWORDS, META_AUTHOR, PG_HEADER, REQUIRE_ACCT FROM TBLPAGES WHERE PG='"&strPAGE&"'" Set rs = cnPILOT.Execute(strSQL) If NOT rs.EOF Then arrPG = rs.GetRows rs.Close : Set rs = Nothing If NOT IsEmpty(arrPG) Then PG_HEADER = arrPG(4,0) Response.Write "" & vbCrLF Response.Write "" & vbCrLf Response.Write "" & vbCrLf If strTitle <> "" Then Response.Write""& strTitle & "" & vbCrLf Else Response.Write""& arrPG(0,0) & "" & vbCrLf End If Response.Write "" & vbCrLf Response.Write "" & vbCrLf Response.Write "" & vbCrLf Response.Write "" & vbCrLf Response.Write "" & vbCrLf Response.Write "" & vbCrLf Response.Write "" & vbCrLf Response.Write "" & vbCrLf ' Call LoadJavaScript(strPage) Response.Write "" & vbCrLf Response.Write "" & vbCrLf 'Response.Write "" & vbCrLf %> <% Response.Write "" & vbCrLf %> <% 'Response.Write "" & VbCrLf PilotPageBegin = True If arrPG(5,0) Then 'If require login If NOT IsLoggedIn() Then Call TemplateBeforePC Call DisplayLogin("default.asp?pg="&strPage) Call TemplateAfterPC Response.End End If End If 'If is logged in End If End Function '----------------------------------------------------------- ' ShowNavBar ' ---------- ' Shows the navigational form at the bottom of all rs results pages. Go to page 2, 3, etc. '----------------------------------------------------------- Function ShowNavBar(page, style, mypage, maxcount) If mypage + 1 > maxcount Then nextPg = 1 Else nextPg = mypage + 1 If mypage -1 < 1 Then previousPg = maxcount Else previousPg = mypage - 1 Response.Write "" If style = "norm" Then If previousPg <> maxcount Then Response.Write "" For i = 1 to maxcount Response.Write " "&i&" " Next If nextPg <> 1 Then Response.Write "" End If Response.Write "" End Function %> <% '------------------------------------------------------------------------------------- ' DisplayFooterMenu ' ---------------- ' write out a footer links as determined in the pages editor. Pass the ' LINE_BREAK_AT so you can prevent blowing up your tables. '------------------------------------------------------------------------------------- Sub DisplayFooterMenu(LINE_BREAK_AT) Dim rs, arrMenuTitle, intLinkCount, i, mnu Set rs = cnPILOT.Execute("SELECT PG, PG_TITLE, MENU_TITLE FROM TBLPAGES WHERE FOOTER_MENU_ITEM <> 0 ORDER BY MENU_TITLE ASC;") If Not rs.EOF Then arrMenuTitle = rs.GetRows rs.Close intLinkCount=0 For i = 0 To UBound(arrMenuTitle, 2) intLinkCount=intLinkCount+1 If arrMenuTitle(2, i)&"" <> "" Then mnu = ""&arrMenuTitle(2, i)&"" Else mnu = arrMenuTitle(1, i) Response.Write " "&mnu&" " If intLinkCount = LINE_BREAK_AT Then Response.Write "
" intLinkCount=0 End If Next End If Set rs = Nothing End Sub '------------------------------------------------------------------------------------- ' DisplayMainMenu ' ---------------- ' write out a list of the pages from the pages editor. '------------------------------------------------------------------------------------- Sub DisplayMainMenu() Dim rs, arrMenuTitle, i, mnu Set rs = cnPILOT.Execute("SELECT PG, PG_TITLE, MENU_TITLE FROM TBLPAGES WHERE MAIN_MENU_ITEM = True ORDER BY MENU_TITLE ASC;") If Not rs.EOF Then arrMenuTitle = rs.GetRows rs.Close For i = 0 To UBound(arrMenuTitle, 2) If arrMenuTitle(2, i)&"" <> "" Then mnu = ""&arrMenuTitle(2, i)&"" Else mnu = arrMenuTitle(1, i) Response.Write ""&mnu&"
"&VbCrLf Next End If Set rs=Nothing End Sub '------------------------------------------------------------------------------------- ' DisplayNewsShorts ' ---------------- ' Displays the specified number of news shorts from TBLNEWS in a table '------------------------------------------------------------------------------------- Sub DisplayNewsShorts(intNumOfShorts) Response.Write "" Response.Write "" Response.Write "
Latest Logs
" Set rs = Server.CreateObject("ADODB.RecordSet") 'rs.CursorLocation = 0' adUseClient rs.Open "SELECT * FROM TBLNEWS ORDER BY THEDATE DESC", cnPILOT, 3 If Not rs.EOF Then rs.MoveFirst rs.PageSize = intNumOfShorts maxcount = cint(rs.PageCount) howmanyrecs = 0 While Not rs.EOF And howmanyrecs < rs.pagesize Response.Write""&Left(rs("THEDATE"),10)&"
"&rs("TAGLINE")&"...

" rs.MoveNext howmanyrecs = howmanyrecs + 1 Wend Else Response.Write"No News Found!" End If rs.Close : Set rs = Nothing Response.Write"
" End Sub Sub DisplaySpecificProducts (ProductID) Dim rs, LinkCount, i, j Set rs = OpenReadOnlyRS("SELECT ITEMID, ITEMNAME, IMG, DESCRIP FROM tblInventory WHERE ITEMID="&ProductID) If rs.EOF Then Exit Sub Response.Write"

" If Trim(rs("IMG")&"X") = "X" Then thmnl = "" Else thmnl = "" Response.Write"" Response.Write"
"&thmnl&"
"&rs("ITEMNAME")&"

"&Excerpt(rs("DESCRIP"), 100, 100)&"
" rs.Close Set rs = Nothing End Sub Sub DisplayRandomProducts (ProductCount) Dim rs, LinkCount, i, j Set rs = OpenReadOnlyRS("SELECT ITEMID, ITEMNAME, IMG, DESCRIP FROM tblInventory WHERE ONSALE <> 1 AND SHOWIT <> 0") If rs.EOF Then Exit Sub ItemCount = ProductCount If ItemCount > rs.RecordCount Then ItemCount = rs.RecordCount ReDim Items(ItemCount - 1) Randomize Timer For i = 0 To UBound(Items) Do Items(i) = CLng(Rnd * rs.RecordCount - 1) For j = 0 To i - 1 If Items(i) = Items(j) Then items(i) = -1 Next If Response.IsClientConnected = False Then Response.End Loop While Items(i) = -1 Next Response.Write"

" For i = 0 To UBound(Items) rs.MoveFirst rs.Move Items(i) If Trim(rs("IMG")&"X") = "X" Then thmnl = "" Else thmnl = "" Response.Write"" Next Response.Write"
"&thmnl&"
"&rs("ITEMNAME")&"

"&Excerpt(rs("DESCRIP"), 100, 100)&"
" rs.Close Set rs = Nothing End Sub Sub DisplayRandomOnSaleProducts (ProductCount) Dim rs, LinkCount, i, j Set rs = OpenReadOnlyRS("SELECT ITEMID, ITEMNAME, DESCRIP, IMG_SMALL, SHOWIT FROM tblInventory WHERE ONSALE <> 0 AND SHOWIT <> 0") If rs.EOF Then Exit Sub ItemCount = ProductCount If ItemCount > rs.RecordCount Then ItemCount = rs.RecordCount ReDim Items(ItemCount - 1) Randomize Timer For i = 0 To UBound(Items) Do Items(i) = CLng(Rnd * rs.RecordCount - 1) For j = 0 To i - 1 If Items(i) = Items(j) Then items(i) = -1 Next If Response.IsClientConnected = False Then Response.End Loop While Items(i) = -1 Next Response.Write"

" For i = 0 To UBound(Items) rs.MoveFirst rs.Move Items(i) If Trim(rs("IMG_SMALL")&"X") = "X" Then thmnl = "" Else thmnl = "" Response.Write"" Next Response.Write"
"&thmnl&"
"&rs("ITEMNAME")&"

"&Excerpt(rs("DESCRIP"), 100, 100)&"
" rs.Close Set rs = Nothing End Sub Sub DisplayNewProducts (ProductCount) Dim rs, LinkCount, i, j Set rs = OpenReadOnlyRS("SELECT tinv.ITEMID, ITEMNAME, DESCRIP, IMG FROM tblInventory tinv, TBLInventoryGroups tig WHERE tinv.ITEMID=tig.ITEMID AND tig.GROUPID=190 AND SHOWIT <> 0 ORDER BY LAST_MODIFIED desc") If rs.EOF Then Exit Sub ItemCount = ProductCount If ItemCount > rs.RecordCount Then ItemCount = rs.RecordCount ReDim Items(ItemCount - 1) Randomize Timer For i = 0 To UBound(Items) Do Items(i) = CLng(Rnd * rs.RecordCount - 1) For j = 0 To i - 1 If Items(i) = Items(j) Then items(i) = -1 Next If Response.IsClientConnected = False Then Response.End Loop While Items(i) = -1 Next Response.Write"

" For i = 0 To UBound(Items) rs.MoveFirst rs.Move Items(i) If Trim(rs("IMG")&"X") = "X" Then thmnl = "" Else thmnl = "" Response.Write"" Next Response.Write"
"&thmnl&"
"&rs("ITEMNAME")&"

"&Excerpt(rs("DESCRIP"), 100, 100)&"
" rs.Close Set rs = Nothing End Sub %> <% '----------------------------------------------------------- ' ASPilot.com - Pilot Cart News Room ' ------------------------------ ' Copyright © 2004 Spliethof Inc ' ' This file lists all the products in the site will full links and ' descriptions. If you submit this page to the search engines, then ' your entire catalog will be indexed. Dim cnPILOT Dim strSQL, specific, mode, grp Dim rsU, rs Dim mypage, strWrittenBy, strEMAIL, rsPageSize, intRecCount, rsPageCount, strGroupname pg = "articles" PilotInitialize 'If Not PilotPageBegin(pg, "articles") Then Response.Redirect "default.asp" specific = Request.QueryString("specific") grp = Request.QueryString("grp") mypage = Request.QueryString("pgNUM") If NOT IsNumeric(mypage) OR mypage = "" Then mypage = 1 mypage = Cint(mypage) If grp = "" AND specific="" Then strSQL = "SELECT AGID, AGNAME FROM TBLARTICLES_GROUPS" Set rs = cnPILOT.Execute(strSQL) If NOT rs.EOF Then arrRS = rs.GetRows rs.Close : Set rs = Nothing If NOT IsEmpty(arrRS) Then i=0 %>

All Articles

<% Do Until i > UBound(arrRS, 2) intAGID = arrRS(0,i) strAGNAME = arrRS(1,i) i=i+1 %> <%=strAGNAME%>
<% Loop End If ElseIf specific = "" Then If mypage = "" Then mypage = 1 strSQL = "SELECT ta.AID, ta.ATHEDATE, ta.ATAGLINE, tag.AGNAME FROM TBLARTICLES ta, TBLARTICLES_GROUPS tag WHERE ta.AGROUPID=tag.AGID " If grp <> "all" Then strSQL = strSQL & " AND ta.AGROUPID="&grp strSQL = strSQL & " ORDER BY ATHEDATE DESC" Set rs = cnPILOT.execute(strSQL) If Not rs.EOF Then arrRS = rs.GetRows rs.Close : Set rs = Nothing If NOT IsEmpty(arrRS) Then 'i=0 intRecCount = UBound(arrRS,2) 'this articles.asp file is set to show 10 articles per page. 'change this number to whatever you like: rsPageSize = 10 rsPageCount = intRecCount \ rsPageSize maxcount = Cint(rsPageCount) howmanyrecs = 0 i = (mypage * rsPageSize)-rsPageSize strGroupname = arrRS(3,0) if grp = "all" Then strGroupName = "All" %>

<%=strGroupname%> more...

<% While i <= intRecCount And howmanyrecs < rsPageSize rsAID = arrRS(0,i) rsATHEDATE = arrRS(1,i) rsATAGLINE = arrRS(2,i) rsAGNAME = arrRS(3,i) 'here is where we display the news articles in order by date descending. 'modify this to look any way you want: %> <%=rsATHEDATE%>
<%=rsATAGLINE%>
Read more...

<% howmanyrecs = howmanyrecs + 1 i=i+1 Wend 'Response.Write "
Back
" Else Response.Write "Sorry, no Articles were found." End If If maxcount > 1 Then If mypage-1 > 0 Then Response.Write "Prev" For i = 1 To maxcount strI = i If CStr(mypage) = CStr(i) Then strI = ""&i&"" Response.Write " "&strI&" " Next If mypage+1 <= maxcount Then Response.Write "Next" End If Else Set rs = cnPILOT.Execute("SELECT AID, ATAGLINE, AHEADER, ARTICLE, AWRITTENBY, AEMAIL, ATHEDATE FROM TBLARTICLES WHERE AID = "&specific&"") If NOT rs.EOF Then arrRS = rs.GetRows rs.Close : Set rs = Nothing If NOT IsEmpty(arrRS) Then strWrittenBy = arrRS(4,0) strEMAIL = arrRS(5,0) 'Show the contact information in best possible format If Trim("X"&strWrittenBy) = "X" And Trim("X"&strEMAIL) = "X" Then writtenBy = "" ElseIf Trim("X"&strWrittenBy) <> "X" And Trim("X"&strEMAIL) = "X" Then writtenBy = "
Written By: "&rs("WRITTENBY")&"" ElseIf Trim("X"&strWrittenBy) <> "X" And Trim("X"&strEMAIL) <> "X" Then writtenBy = "
Written By: "&strWrittenBy&"" Else writtenBy = "
Written By: "&strEMAIL&"" End If Response.Write "

"&Left(arrRS(6,0),10)&"

" Response.Write ""&arrRS(1,0)&"
" Response.Write ""&arrRS(2,0)&"
" Response.Write arrRS(3,0) &"
" %> <%If writtenBy <> "" Then Response.Write writtenBy &"

"%>
List All Articles
<% 'End If ' Not Empty End If End If cnPILOT.Close : Set cnPILOT = Nothing %>

 




To Receive the Complimentary White Paper on  "Resume Lying",
enter your  information below
Contact Information
First Name *
Last Name *
Email *
Other Information
     
What types of services do you use now?

We will never share your information with anyone.
We dislike spam as much as you do!
* =Required Field

 

Home | About Us | Articles | More Articles | Contact Us | News | Newsletter | Privacy Policy | Search | Training | ©2008-2009 Accu-Screen, Inc., All Rights Reserved
5303 S. MacDill Ave. Tampa, Florida 33611, Phone: 800-689-2228.