<%@LANGUAGE="VBSCRIPT"%> <% ' FileName="Connection_ado_conn_string.htm" ' Type="ADO" ' DesigntimeType="ADO" ' HTTP="false" ' Catalog="" ' Schema="" Dim MM_directory_STRING MM_directory_STRING ="Provider=SQLOLEDB;Password=big785;Data Source=VMSSQL03\I3;Database=DB_4085;User ID=vip2498" %> <%Dim nodays if Request.Form("days")<>"" then nodays = Request.Form("days") End if If nodays="" then nodays=90 end if %> <%'Basic-UltraDev navigation letters rsFeat Dim Begin_navLetter if (CStr(Request.QueryString("nav_letter"))<>"") Then Begin_navLetter = Asc(CStr(Request.QueryString("nav_letter"))) Else Begin_navLetter = 65 End If tfm_navLetter = " ASCII(Upper(LINK_NAME)) = " & Begin_navLetter tfm_navLetter = tfm_navLetter & " ORDER BY LINK_NAME" %> <% Dim rsFeat__nav_Letter rsFeat__nav_Letter = "%" If (Request.QueryString("nav_Letter") <> "") Then rsFeat__nav_Letter = Request.QueryString("nav_Letter") End If %> <% set rsFeat = Server.CreateObject("ADODB.Recordset") rsFeat.ActiveConnection = MM_directory_STRING rsFeat.Source = "SELECT * FROM LINKS, pricing, priority WHERE LINK_EXPIRED >= getDate() AND LINK_APPROVED = 1 AND getDate() -"& nodays &"<= LINK_Date and paymentAmount = id and PID = priorityid and priorityid in (2,3) and LInk_name LIKE '" + Replace(rsFeat__nav_Letter, "'", "''") + "%' ORDER BY pid desc, LINK_Name ASC" rsFeat.CursorType = 0 rsFeat.CursorLocation = 2 rsFeat.LockType = 3 rsFeat.Open() rsFeat_numRows = 0 %> <% Dim RepeatFeat__numRows Dim RepeatFeat__index RepeatFeat__numRows = 60 RepeatFeat__index = 0 rsFeat_numRows = rsFeat_numRows + RepeatFeat__numRows %> <% Dim Repeat3__numRows Dim Repeat3__index Repeat3__numRows = 5 Repeat3__index = 0 SmallBanner_numRows = SmallBanner_numRows + Repeat3__numRows %> <% Dim RecordCounter RecordCounter = 0 %> <% Dim HLooper1__numRows HLooper1__numRows = -4 Dim HLooper1__index HLooper1__index = 0 rsSub_numRows = rsSub_numRows + HLooper1__numRows %> <% ' *** Recordset Stats, Move To Record, and Go To Record: declare stats variables ' set the record count rsFeat_total = rsFeat.RecordCount ' set the number of rows displayed on this page If (rsFeat_numRows < 0) Then rsFeat_numRows = rsFeat_total Elseif (rsFeat_numRows = 0) Then rsFeat_numRows = 1 End If ' set the first and last displayed record rsFeat_first = 1 rsFeat_last = rsFeat_first + rsFeat_numRows - 1 ' if we have the correct record count, check the other stats If (rsFeat_total <> -1) Then If (rsFeat_first > rsFeat_total) Then rsFeat_first = rsFeat_total If (rsFeat_last > rsFeat_total) Then rsFeat_last = rsFeat_total If (rsFeat_numRows > rsFeat_total) Then rsFeat_numRows = rsFeat_total End If %> <% Dim MM_paramName %> <% ' *** Recordset Stats: if we don't know the record count, manually count them If (rsFeat_total = -1) Then ' count the total records by iterating through the recordset rsFeat_total=0 While (Not rsFeat.EOF) rsFeat_total = rsFeat_total + 1 rsFeat.MoveNext Wend ' reset the cursor to the beginning If (rsFeat.CursorType > 0) Then rsFeat.MoveFirst Else rsFeat.Requery End If ' set the number of rows displayed on this page If (rsFeat_numRows < 0 Or rsFeat_numRows > rsFeat_total) Then rsFeat_numRows = rsFeat_total End If ' set the first and last displayed record rsFeat_first = 1 rsFeat_last = rsFeat_first + rsFeat_numRows - 1 If (rsFeat_first > rsFeat_total) Then rsFeat_first = rsFeat_total If (rsFeat_last > rsFeat_total) Then rsFeat_last = rsFeat_total End If %> <% ' *** Move To Record and Go To Record: declare variables Set MM_rs = rsFeat MM_rsCount = rsFeat_total MM_size = rsFeat_numRows MM_uniqueCol = "" MM_paramName = "" MM_offset = 0 MM_atTotal = false MM_paramIsDefined = false If (MM_paramName <> "") Then MM_paramIsDefined = (Request.QueryString(MM_paramName) <> "") End If %> <% ' *** Move To Record: handle 'index' or 'offset' parameter if (Not MM_paramIsDefined And MM_rsCount <> 0) then ' use index parameter if defined, otherwise use offset parameter r = Request.QueryString("index") If r = "" Then r = Request.QueryString("offset") If r <> "" Then MM_offset = Int(r) ' if we have a record count, check if we are past the end of the recordset If (MM_rsCount <> -1) Then If (MM_offset >= MM_rsCount Or MM_offset = -1) Then ' past end or move last If ((MM_rsCount Mod MM_size) > 0) Then ' last page not a full repeat region MM_offset = MM_rsCount - (MM_rsCount Mod MM_size) Else MM_offset = MM_rsCount - MM_size End If End If End If ' move the cursor to the selected record i = 0 While ((Not MM_rs.EOF) And (i < MM_offset Or MM_offset = -1)) MM_rs.MoveNext i = i + 1 Wend If (MM_rs.EOF) Then MM_offset = i ' set MM_offset to the last possible record End If %> <% ' *** Move To Record: if we dont know the record count, check the display range If (MM_rsCount = -1) Then ' walk to the end of the display range for this page i = MM_offset While (Not MM_rs.EOF And (MM_size < 0 Or i < MM_offset + MM_size)) MM_rs.MoveNext i = i + 1 Wend ' if we walked off the end of the recordset, set MM_rsCount and MM_size If (MM_rs.EOF) Then MM_rsCount = i If (MM_size < 0 Or MM_size > MM_rsCount) Then MM_size = MM_rsCount End If ' if we walked off the end, set the offset based on page size If (MM_rs.EOF And Not MM_paramIsDefined) Then If (MM_offset > MM_rsCount - MM_size Or MM_offset = -1) Then If ((MM_rsCount Mod MM_size) > 0) Then MM_offset = MM_rsCount - (MM_rsCount Mod MM_size) Else MM_offset = MM_rsCount - MM_size End If End If End If ' reset the cursor to the beginning If (MM_rs.CursorType > 0) Then MM_rs.MoveFirst Else MM_rs.Requery End If ' move the cursor to the selected record i = 0 While (Not MM_rs.EOF And i < MM_offset) MM_rs.MoveNext i = i + 1 Wend End If %> <% ' *** Move To Record: update recordset stats ' set the first and last displayed record rsFeat_first = MM_offset + 1 rsFeat_last = MM_offset + MM_size If (MM_rsCount <> -1) Then If (rsFeat_first > MM_rsCount) Then rsFeat_first = MM_rsCount If (rsFeat_last > MM_rsCount) Then rsFeat_last = MM_rsCount End If ' set the boolean used by hide region to check if we are on the last record MM_atTotal = (MM_rsCount <> -1 And MM_offset + MM_size >= MM_rsCount) %> <% ' *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters ' create the list of parameters which should not be maintained MM_removeList = "&index=" If (MM_paramName <> "") Then MM_removeList = MM_removeList & "&" & MM_paramName & "=" MM_keepURL="":MM_keepForm="":MM_keepBoth="":MM_keepNone="" ' add the URL parameters to the MM_keepURL string For Each Item In Request.QueryString NextItem = "&" & Item & "=" If (InStr(1,MM_removeList,NextItem,1) = 0) Then MM_keepURL = MM_keepURL & NextItem & Server.URLencode(Request.QueryString(Item)) End If Next ' add the Form variables to the MM_keepForm string For Each Item In Request.Form NextItem = "&" & Item & "=" If (InStr(1,MM_removeList,NextItem,1) = 0) Then MM_keepForm = MM_keepForm & NextItem & Server.URLencode(Request.Form(Item)) End If Next ' create the Form + URL string and remove the intial '&' from each of the strings MM_keepBoth = MM_keepURL & MM_keepForm if (MM_keepBoth <> "") Then MM_keepBoth = Right(MM_keepBoth, Len(MM_keepBoth) - 1) if (MM_keepURL <> "") Then MM_keepURL = Right(MM_keepURL, Len(MM_keepURL) - 1) if (MM_keepForm <> "") Then MM_keepForm = Right(MM_keepForm, Len(MM_keepForm) - 1) ' a utility function used for adding additional parameters to these strings Function MM_joinChar(firstItem) If (firstItem <> "") Then MM_joinChar = "&" Else MM_joinChar = "" End If End Function %> <% ' *** Move To Record: set the strings for the first, last, next, and previous links MM_keepMove = MM_keepBoth MM_moveParam = "index" ' if the page has a repeated region, remove 'offset' from the maintained parameters If (MM_size > 0) Then MM_moveParam = "offset" If (MM_keepMove <> "") Then params = Split(MM_keepMove, "&") MM_keepMove = "" For i = 0 To UBound(params) nextItem = Left(params(i), InStr(params(i),"=") - 1) If (StrComp(nextItem,MM_moveParam,1) <> 0) Then MM_keepMove = MM_keepMove & "&" & params(i) End If Next If (MM_keepMove <> "") Then MM_keepMove = Right(MM_keepMove, Len(MM_keepMove) - 1) End If End If End If ' set the strings for the move to links If (MM_keepMove <> "") Then MM_keepMove = MM_keepMove & "&" urlStr = Request.ServerVariables("URL") & "?" & MM_keepMove & MM_moveParam & "=" MM_moveFirst = urlStr & "0" MM_moveLast = urlStr & "-1" MM_moveNext = urlStr & Cstr(MM_offset + MM_size) prev = MM_offset - MM_size If (prev < 0) Then prev = 0 MM_movePrev = urlStr & Cstr(prev) %> <% ' *** Logout the current user. MM_Logout = CStr(Request.ServerVariables("URL")) & "?MM_Logoutnow=1" If (CStr(Request("MM_Logoutnow")) = "1") Then Session.Abandon MM_logoutRedirectPage = "default.asp" ' redirect with URL parameters (remove the "MM_Logoutnow" query param). if (MM_logoutRedirectPage = "") Then MM_logoutRedirectPage = CStr(Request.ServerVariables("URL")) If (InStr(1, UC_redirectPage, "?", vbTextCompare) = 0 And Request.QueryString <> "") Then MM_newQS = "?" For Each Item In Request.QueryString If (Item <> "MM_Logoutnow") Then If (Len(MM_newQS) > 1) Then MM_newQS = MM_newQS & "&" MM_newQS = MM_newQS & Item & "=" & Server.URLencode(Request.QueryString(Item)) End If Next if (Len(MM_newQS) > 1) Then MM_logoutRedirectPage = MM_logoutRedirectPage & MM_newQS End If Response.Redirect(MM_logoutRedirectPage) End If %> <% Dim rsUser__MMColParam rsUser__MMColParam = "xyz_" if (Session("MM_Username") <> "") then rsUser__MMColParam = Session("MM_Username") %> <% set rsUser = Server.CreateObject("ADODB.Recordset") rsUser.ActiveConnection = MM_directory_STRING rsUser.Source = "SELECT *,(SELECT COUNT(*) FROM LINKS WHERE LINK_POSTER = U_ID) AS LINK_COUNT FROM USERS WHERE U_ID = '" + Replace(rsUser__MMColParam, "'", "''") + "'" rsUser.CursorType = 0 rsUser.CursorLocation = 2 rsUser.LockType = 3 rsUser.Open() rsUser_numRows = 0 %> <% set SmallBanner = Server.CreateObject("ADODB.Recordset") SmallBanner.ActiveConnection = MM_directory_STRING SmallBanner.Source = "SELECT * FROM SMALLBANNERS WHERE FRONTPAGE =1" SmallBanner.CursorType = 3 SmallBanner.CursorLocation = 2 SmallBanner.LockType = 1 SmallBanner.Open() SmallBanner_numRows = 0 'end of codes. %> <% Dim rsKeywords Dim rsKeywords_numRows Set rsKeywords = Server.CreateObject("ADODB.Recordset") rsKeywords.ActiveConnection = MM_directory_STRING rsKeywords.Source = "SELECT SYS_TITLE, SYS_KEYWORDS, SYS_DESC FROM SETTINGS" rsKeywords.CursorType = 0 rsKeywords.CursorLocation = 2 rsKeywords.LockType = 1 rsKeywords.Open() rsKeywords_numRows = 0 %> <% FUNCTION CropSentence(strText, intLength, strTrial) Dim wsCount Dim intTempSize Dim intTotalLen Dim strTemp wsCount = 0 intTempSize = 0 intTotalLen = 0 intLength = intLength - Len(strTrial) strTemp = "" IF Len(strText) > intLength THEN arrTemp = Split(strText, " ") FOR EACH x IN arrTemp IF Len(strTemp) <= intLength THEN strTemp = strTemp & x & " " END IF NEXT CropSentence = Left(strTemp, Len(strTemp) - 1) & strTrial ELSE CropSentence = strText END IF END FUNCTION %> <% Dim Repeat8__numRows Dim Repeat8__index Repeat8__numRows = -1 Repeat8__index = 0 rsSmallBanner_numRows = rsSmallBanner_numRows + Repeat1__numRows %> <% ' *** Validate request to log in to this site. MM_LoginAction = Request.ServerVariables("URL") If Request.QueryString<>"" Then MM_LoginAction = MM_LoginAction + "?" + Request.QueryString MM_valUsername=CStr(Request.Form("Username")) If MM_valUsername <> "" Then MM_fldUserAuthorization="" MM_redirectLoginSuccess=MM_LoginAction MM_redirectLoginFailed="register.asp" MM_flag="ADODB.Recordset" set MM_rsUser = Server.CreateObject(MM_flag) MM_rsUser.ActiveConnection = MM_directory_STRING MM_rsUser.Source = "SELECT U_ID, U_PASSWORD" If MM_fldUserAuthorization <> "" Then MM_rsUser.Source = MM_rsUser.Source & "," & MM_fldUserAuthorization MM_rsUser.Source = MM_rsUser.Source & " FROM USERS WHERE U_ID='" & Replace(MM_valUsername,"'","''") &"' AND U_PASSWORD='" & Replace(Request.Form("Password"),"'","''") & "'" MM_rsUser.CursorType = 0 MM_rsUser.CursorLocation = 2 MM_rsUser.LockType = 3 MM_rsUser.Open If Not MM_rsUser.EOF Or Not MM_rsUser.BOF Then ' username and password match - this is a valid user Session("MM_Username") = MM_valUsername If (MM_fldUserAuthorization <> "") Then Session("MM_UserAuthorization") = CStr(MM_rsUser.Fields.Item(MM_fldUserAuthorization).Value) Else Session("MM_UserAuthorization") = "" End If if CStr(Request.QueryString("accessdenied")) <> "" And true Then MM_redirectLoginSuccess = Request.QueryString("accessdenied") End If MM_rsUser.Close Response.Redirect(MM_redirectLoginSuccess) End If MM_rsUser.Close Response.Redirect(MM_redirectLoginFailed) End If %> <% ' *** Go To Record and Move To Record: create strings for maintaining URL and Form parameters ' create the list of parameters which should not be maintained MM_removeList = "&index=" If (MM_paramName <> "") Then MM_removeList = MM_removeList & "&" & MM_paramName & "=" MM_keepURL="":MM_keepForm="":MM_keepBoth="":MM_keepNone="" ' add the URL parameters to the MM_keepURL string For Each Item In Request.QueryString NextItem = "&" & Item & "=" If (InStr(1,MM_removeList,NextItem,1) = 0) Then MM_keepURL = MM_keepURL & NextItem & Server.URLencode(Request.QueryString(Item)) End If Next ' add the Form variables to the MM_keepForm string For Each Item In Request.Form NextItem = "&" & Item & "=" If (InStr(1,MM_removeList,NextItem,1) = 0) Then MM_keepForm = MM_keepForm & NextItem & Server.URLencode(Request.Form(Item)) End If Next ' create the Form + URL string and remove the intial '&' from each of the strings MM_keepBoth = MM_keepURL & MM_keepForm if (MM_keepBoth <> "") Then MM_keepBoth = Right(MM_keepBoth, Len(MM_keepBoth) - 1) if (MM_keepURL <> "") Then MM_keepURL = Right(MM_keepURL, Len(MM_keepURL) - 1) if (MM_keepForm <> "") Then MM_keepForm = Right(MM_keepForm, Len(MM_keepForm) - 1) ' a utility function used for adding additional parameters to these strings Function MM_joinChar(firstItem) If (firstItem <> "") Then MM_joinChar = "&" Else MM_joinChar = "" End If End Function %> <%=(rsKeywords.Fields.Item("SYS_TITLE").Value)%> "> ">
 

  

About Us

  

Merchant directory

  

Cardholders

  

List my business

  

Solutions

 

 Get a card
   
   
Quick Search:
 
<% set rsNav = Server.CreateObject("ADODB.Recordset") rsNav.ActiveConnection = MM_directory_STRING rsNav.Source = "SELECT *,(SELECT COUNT (*) FROM LINKS,priority,pricing WHERE LINKS.CAT_ID = CATS.CAT_ID AND LINK_APPROVED=1 AND paymentAmount = id and PID = priorityid AND LINK_EXPIRED >= GETDATE()) AS LINK_COUNT FROM CATS ORDER BY CAT_NAME ASC" rsNav.CursorType = 0 rsNav.CursorLocation = 2 rsNav.LockType = 3 rsNav.Open() rsNav_numRows = 0 %> <% Dim Repeat1__numRows Dim Repeat1__index Repeat1__numRows = -1 Repeat1__index = 0 rsNav_numRows = rsNav_numRows + Repeat1__numRows %>
Categories:
<% While ((Repeat1__numRows <> 0) AND (NOT rsNav.EOF))%>
>
<% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 rsNav.MoveNext() Wend %>

 
Top Cities:
<% While ((Repeat1__numRows <> 0) AND (NOT rsNav.EOF))%> <% Repeat1__index=Repeat1__index+1 Repeat1__numRows=Repeat1__numRows-1 rsNav.MoveNext() Wend %>
 <% rsNav.Close() Set rsNav = Nothing %>
Home » New Listings

<% If rsUser.EOF And rsUser.BOF Then %> Log In <%else%> <%=(rsUser.Fields.Item("U_ID").Value)%>'s Account <%end if%>

<% If rsUser.EOF And rsUser.BOF Then %>
User Name:

Password:

Get password?
Register Now! <%else%>
  (<%=(rsUser.Fields.Item("LINK_COUNT").Value)%>)
 
 
  ...........................
 

Logout
<% End If ' end rsUser.EOF And rsUser.BOF %>

Hot Links
<% While ((Repeat8__numRows <> 0) AND (NOT SmallBanner.EOF)) %> <% Repeat8__index=Repeat8__index+1 Repeat8__numRows=Repeat8__numRows-1 SmallBanner.MoveNext() Wend %>

Advertisements

 

 
<% While ((Repeat8__numRows <> 0) AND (NOT SmallBanner.EOF)) %> <% Repeat8__index=Repeat8__index+1 Repeat8__numRows=Repeat8__numRows-1 SmallBanner.MoveNext() Wend %>

 

 
 

<% If Not rsFeat.EOF Or Not rsFeat.BOF Then %> <% End If ' end Not rsFeat.EOF Or NOT rsFeat.BOF %>
View Listings in Last :

 

&%20subid%20<%=rsFeat.Fields.Item("sub_ID").Value %>" class="box1">
All | <% delimiter = "|" Dim tfm_RegExp Set tfm_RegExp = New RegExp tfm_RegExp.Pattern = "nav_letter=\w{1}" tfm_RegExp.IgnoreCase = True For i = 65 to 90 TFM_character = Chr(i) if(TFM_character = Begin_navLetter) Then Response.Write("") if(InStr(MM_moveFirst,"nav_letter=")<> 0) Then MM_moveFirst = tfm_RegExp.Replace(MM_moveFirst,"nav_letter=" & TFM_character) Else MM_moveFirst = MM_moveFirst & "&nav_letter=" & TFM_character End If Response.Write("" + TFM_character + "") If(TFM_character = Begin_navLetter) Then Response.Write("") If(i<90)Then Response.Write(delimiter) Next %>

Records: <%=(rsFeat_first)%> to <%=(rsFeat_last)%> of <%=(rsFeat_total)%>

 
<% If Not rsFeat.EOF Or Not rsFeat.BOF Then %> <% While ((RepeatFeat__numRows <> 0) AND (NOT rsFeat.EOF)) %> <% RepeatFeat__index=RepeatFeat__index+1 RepeatFeat__numRows=RepeatFeat__numRows-1 rsFeat.MoveNext() Wend %> <% End If ' end Not rsFeat.EOF Or NOT rsFeat.BOF %>
 
 Business Name  City  State  Zip Quicklist
" class="box1"><%=(rsFeat.Fields.Item("LINK_NAME").Value)%>   <% If rsFeat.Fields.Item("LINK_DATE").Value > Date() - 30 Then %> <% End If %> <%=(rsFeat.Fields.Item("LINK_CITY").Value)%> <%=(rsFeat.Fields.Item("LINK_STATE").Value)%> <%=(rsFeat.Fields.Item("LINK_ZIP").Value)%>


<% If MM_offset <> 0 Then %> <% End If ' end MM_offset <> 0 %>
<% If MM_offset <> 0 Then %> <% End If ' end MM_offset <> 0 %>
 
<% If Not MM_atTotal Then %> <% End If ' end Not MM_atTotal %>
<% If Not MM_atTotal Then %> <% End If ' end Not MM_atTotal %>
 
<% If rsFeat.EOF And rsFeat.BOF Then %> No Records Found!
«Back <% End If ' end rsFeat.EOF And rsFeat.BOF %>

| About Us | Advertising | Services | Contact Us | Privacy Guidelines | Terms & Conditions | Merchant Agreement |Get Listed |
 

   
 

© 2007 VIP Card Network
 A Digital Communities Online, Inc.  Company. All Rights Reserved.
 Terms & Conditions  under which this service is provided to you.
Read our Privacy Guidelines. Contact us.  Website design by Digital Communities Online

 

 

The design and illustration of the VIP Cards represented on this Web site are being used as
presentation to the prospective company; no endorsement and/or agreement has been made. 
All logos and trademarks contained within these design ideas are property of their respective owners.
 
  
<% rsUser.Close() Set rsUser = Nothing %> <% rsKeywords.Close() Set rsKeywords = Nothing %> <% SmallBanner.Close() Set SmallBanner = Nothing %> <% rsFeat.Close() %>