<?php require_once('Connections/connBanners.php'); ?>
<?php require_once('Connections/connLVWData.php'); ?>
<?php

$mainGrid = 0;
$RowStart = 0;
$RowEnd = 0;
$numberColumns = 4;
$numberRows = 80;
$mainGrid = $numberColumns * $numberRows;


mysql_select_db($database_connBanners, $connBanners);
$query_rsBanners = "SELECT * FROM tblBanners WHERE BannerType = 'Long' and BannerActive = 'Enabled' ORDER BY Rand() LIMIT 1";
$rsBanners = mysql_query($query_rsBanners, $connBanners) or die(mysql_error());
$row_rsBanners = mysql_fetch_assoc($rsBanners);
$totalRows_rsBanners = mysql_num_rows($rsBanners);

mysql_select_db($database_connLVWData, $connLVWData);
$query_rsImageRotate = "SELECT * FROM tblLVWRotate ORDER BY Rand()";
$rsImageRotate = mysql_query($query_rsImageRotate, $connLVWData) or die(mysql_error());
$row_rsImageRotate = mysql_fetch_assoc($rsImageRotate);
$totalRows_rsImageRotate = mysql_num_rows($rsImageRotate);

mysql_select_db($database_connLVWData, $connLVWData);
$query_rsCategories = "SELECT * FROM tblCategories ORDER BY CatName ASC";
$rsCategories = mysql_query($query_rsCategories, $connLVWData) or die(mysql_error());
$row_rsCategories = mysql_fetch_assoc($rsCategories);
$totalRows_rsCategories = mysql_num_rows($rsCategories);

mysql_select_db($database_connBanners, $connBanners);
$query_rsSideBanner = "SELECT bannerID, bannerImage, bannerLink FROM tblBanners WHERE BannerType = 'Tall' ORDER BY Rand()";
$rsSideBanner = mysql_query($query_rsSideBanner, $connBanners) or die(mysql_error());
$row_rsSideBanner = mysql_fetch_assoc($rsSideBanner);
$totalRows_rsSideBanner = mysql_num_rows($rsSideBanner);

mysql_select_db($database_connBanners, $connBanners);
$query_rsSideBannerTwo = "SELECT bannerID, bannerImage, bannerLink FROM tblBanners WHERE BannerType = 'Tall' ORDER BY Rand()";
$rsSideBannerTwo = mysql_query($query_rsSideBannerTwo, $connBanners) or die(mysql_error());
$row_rsSideBannerTwo = mysql_fetch_assoc($rsSideBannerTwo);
$totalRows_rsSideBannerTwo = mysql_num_rows($rsSideBannerTwo);

// *** Hits Counter ***
$urlparam = "Hits";
$ckrs = "rsBanners"; //used for identification
if (!isset($HTTP_SERVER_VARS["QUERY_STRING"])) {
  $HitLink = $HTTP_SERVER_VARS["PHP_SELF"] . "?" . $urlparam . "=";
} else {
  $HitLink = $HTTP_SERVER_VARS["PHP_SELF"] . "?" . $HTTP_SERVER_VARS["QUERY_STRING"] . "&" . $urlparam . "=";
}
if (isset($HTTP_GET_VARS[$urlparam])) {
  $tableName = "tblBanners";
  $fieldName = "bannerID";
  $hitsfield = "BannerHits";
  $urlfield = "bannerLink";
  // Get the Hits number and update it.
  $rsCon = "connBanners";
  $IdSource = "select * from " .  $tableName . " where " . $fieldName . " = " . $HTTP_GET_VARS[$urlparam] . "";
  $rsId = mysql_query($IdSource, $$rsCon) or die(mysql_error());
  $row_rsId = mysql_fetch_assoc($rsId);
  $hiturl = $row_rsId[$urlfield];
  $next = $row_rsId[$hitsfield] + 1;
  $upd = "update " . $tableName . " set " . $hitsfield . " = " . $next . " where " . $fieldName . " = " . $HTTP_GET_VARS[$urlparam] . "";
  $rsId = mysql_query($upd, $$rsCon) or die(mysql_error());
  $rsId = null;
  header("Location: " . $hiturl);
}
// FELIXONE 2002/2003 - SB by Felice Di Stefano - www.felixone.it

// *** Hits Counter ***
$urlparam1 = "HitsTwo";
$ckrs = "rsSideBanner"; //used for identification
if (!isset($HTTP_SERVER_VARS["QUERY_STRING"])) {
  $HitLink1 = $HTTP_SERVER_VARS["PHP_SELF"] . "?" . $urlparam1 . "=";
} else {
  $HitLink1 = $HTTP_SERVER_VARS["PHP_SELF"] . "?" . $HTTP_SERVER_VARS["QUERY_STRING"] . "&" . $urlparam1 . "=";
}
if (isset($HTTP_GET_VARS[$urlparam1])) {
  $tableName = "tblBanners";
  $fieldName = "bannerID";
  $hitsfield = "BannerHits";
  $urlfield = "bannerLink";
  // Get the Hits number and update it.
  $rsCon = "connBanners";
  $IdSource = "select * from " .  $tableName . " where " . $fieldName . " = " . $HTTP_GET_VARS[$urlparam1] . "";
  $rsId = mysql_query($IdSource, $$rsCon) or die(mysql_error());
  $row_rsId = mysql_fetch_assoc($rsId);
  $hiturl = $row_rsId[$urlfield];
  $next = $row_rsId[$hitsfield] + 1;
  $upd = "update " . $tableName . " set " . $hitsfield . " = " . $next . " where " . $fieldName . " = " . $HTTP_GET_VARS[$urlparam1] . "";
  $rsId = mysql_query($upd, $$rsCon) or die(mysql_error());
  $rsId = null;
  header("Location: " . $hiturl);
}
// FELIXONE 2002/2003 - SB by Felice Di Stefano - www.felixone.it

// *** Hits Counter ***
$urlparam2 = "HitsThree";
$ckrs = "rsSideBannerTwo"; //used for identification
if (!isset($HTTP_SERVER_VARS["QUERY_STRING"])) {
  $HitLink2 = $HTTP_SERVER_VARS["PHP_SELF"] . "?" . $urlparam2 . "=";
} else {
  $HitLink2 = $HTTP_SERVER_VARS["PHP_SELF"] . "?" . $HTTP_SERVER_VARS["QUERY_STRING"] . "&" . $urlparam2 . "=";
}
if (isset($HTTP_GET_VARS[$urlparam2])) {
  $tableName = "tblBanners";
  $fieldName = "bannerID";
  $hitsfield = "BannerHits";
  $urlfield = "bannerLink";
  // Get the Hits number and update it.
  $rsCon = "connBanners";
  $IdSource = "select * from " .  $tableName . " where " . $fieldName . " = " . $HTTP_GET_VARS[$urlparam2] . "";
  $rsId = mysql_query($IdSource, $$rsCon) or die(mysql_error());
  $row_rsId = mysql_fetch_assoc($rsId);
  $hiturl = $row_rsId[$urlfield];
  $next = $row_rsId[$hitsfield] + 1;
  $upd = "update " . $tableName . " set " . $hitsfield . " = " . $next . " where " . $fieldName . " = " . $HTTP_GET_VARS[$urlparam2] . "";
  $rsId = mysql_query($upd, $$rsCon) or die(mysql_error());
  $rsId = null;
  header("Location: " . $hiturl);
}
// FELIXONE 2002/2003 - SB by Felice Di Stefano - www.felixone.it
?>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2 FINAL//EN">

<html>

<HEAD>
<TITLE>Las Vegas Web Sites - The premier directory of Las Vegas business website on the web!</TITLE>
<script language="JavaScript">
<!--


function MM_preloadImages() { //v3.0
  var d=document; if(d.images){ if(!d.MM_p) d.MM_p=new Array();
    var i,j=d.MM_p.length,a=MM_preloadImages.arguments; for(i=0; i<a.length; i++)
    if (a[i].indexOf("#")!=0){ d.MM_p[j]=new Image; d.MM_p[j++].src=a[i];}}
}
//-->
</script>
<META HTTP-EQUIV="Content-Type" CONTENT="text/html; charset=iso-8859-1">
<LINK HREF="style.css" REL="stylesheet" TYPE="text/css">
</HEAD>

<BODY bgcolor="#FFFFFF" TEXT="#000000" LEFTMARGIN=0 TOPMARGIN=0 MARGINWIDTH=0 MARGINHEIGHT=0>
<TABLE WIDTH="100%" BORDER="0" CELLSPACING="0" CELLPADDING="0">
  <TR>
    <TD WIDTH="24" BGCOLOR="#0C476C"><IMG SRC="images/x.gif" WIDTH="22" HEIGHT="33"></TD>
    <TD WIDTH="104" ROWSPAN="2"><IMG SRC="images/<?php echo $row_rsImageRotate['ImageAddress']; ?>" ALT="Las Vegas Websites" WIDTH="104" HEIGHT="103"></TD>
    <TD WIDTH="110" ALIGN="CENTER" BGCOLOR="#0C476C"><IMG SRC="images/x.gif" WIDTH="110" HEIGHT="33"></TD>
    <TD ALIGN="RIGHT" VALIGN="TOP" CLASS="farCell"><A HREF="http://www.americandirectory.com/"><IMG SRC="images/06.gif" ALT="Powered By American Directory.com" WIDTH="235" HEIGHT="19" BORDER="0"></A></TD>
  </TR>
  <TR>
    <TD WIDTH="24" BGCOLOR="#0C476C"><IMG SRC="images/x.gif" WIDTH="22" HEIGHT="70"></TD>
    <TD WIDTH="110" ALIGN="CENTER" BACKGROUND="images/04.gif"><IMG SRC="images/05.gif" ALT="Las Vegas Websites" WIDTH="104" HEIGHT="54"></TD>
    <TD ALIGN="CENTER" VALIGN="MIDDLE" BACKGROUND="images/04.gif"></A><a href="http://www.ferraroslasvegas.com"><img src="../ferraros.gif" width="400" height="50" border="0"></a></TD>
  </TR>
  <TR>
    <TD BGCOLOR="#0C476C"><IMG SRC="images/x.gif" WIDTH="22" HEIGHT="5"></TD>
    <TD COLSPAN="3" BACKGROUND="images/16.gif"><IMG SRC="images/x.gif" WIDTH="22" HEIGHT="5"></TD>
  </TR>
</TABLE>
<TABLE WIDTH="100%" BORDER="0" CELLSPACING="0" CELLPADDING="0">
  <TR>
    <TD WIDTH="22" BGCOLOR="#0c476c"><IMG SRC="images/x.gif" WIDTH="22" HEIGHT="33"></TD>
    <TD VALIGN="TOP" CLASS="paddedCell">
        <TABLE WIDTH="600" BORDER="0" ALIGN="CENTER" CELLPADDING="0" CELLSPACING="0">
        <TR>
          <TD><P CLASS="textType1">Las Vegas Websites, a partner of <A HREF="http://www.americandirectory.com/">American Directory.com</A>, is the premier directory of Las Vegas business web sites. </P>
            <P CLASS="textType1">Las Vegas Websites is now accepting submissions for listings and banners. If you are interested in being a part of our fast growing directory, please go to our <A HREF="addsite.php">submission form</A>.</P></TD>
          <TD><IMG SRC="images/x.gif" WIDTH="20" HEIGHT="20"></TD>
          <TD><IMG SRC="images/01.jpg" WIDTH="125" HEIGHT="151"></TD>
        </TR>
      </TABLE>
      <BR>
      <TABLE WIDTH="600" BORDER="0" ALIGN="CENTER" CELLPADDING="0" CELLSPACING="0">
					
        <TR>
          <TD><IMG SRC="images/18.gif" WIDTH="247" HEIGHT="29"></TD>
        </TR>
        <TR>
						
          <TD CLASS="hpBorderedPadded">
<TABLE WIDTH="550" BORDER="0" ALIGN="CENTER" CELLPADDING="0" CELLSPACING="0">
              <TR VALIGN="TOP">
                <TD WIDTH="33%"><UL>
                    <LI CLASS="homepageLinks"><A HREF="acc.php">Accounting</A></LI>
                    <LI CLASS="homepageLinks"><A HREF="aa.php">Advertising Agencies</A></LI>
                    <LI CLASS="homepageLinks"><A HREF="air.php">Airlines</A></LI>
                    <LI CLASS="homepageLinks"><A HREF="app.php">Apparel</A></LI>
                    <LI CLASS="homepageLinks"><A HREF="arc.php">Architects</A></LI>
                    <LI CLASS="homepageLinks"><A HREF="aso.php">Associations</A></LI>
                    <LI CLASS="homepageLinks"><A HREF="att.php">Attorneys</A></LI>
                    <LI CLASS="homepageLinks"><A HREF="aut.php">Automobiles</A></LI>
                    <LI CLASS="homepageLinks"><A HREF="ban.php">Banks &amp; Finance</A></LI>
                    <LI CLASS="homepageLinks"><a href="bea.php">Beauty</a></LI>
                    <LI CLASS="homepageLinks"><a href="book.php">Books</a></LI>
                    <LI CLASS="homepageLinks"><A HREF="busserv.php">Business Services</A></LI>
                    <LI CLASS="homepageLinks"><a href="cater.php">Catering</a></LI>
                    <LI CLASS="homepageLinks"><a href="char.php">Charitable Organizations</a></LI>
                    <LI CLASS="homepageLinks"><a href="chir.php">Chiropractors</a></LI>
                    <LI CLASS="homepageLinks"><a href="church.php">Churches</a></LI>
                    <LI CLASS="homepageLinks"><a href="comp.php">Computers</a></LI>
                    <LI CLASS="homepageLinks"><A HREF="const.php">Construction</A></LI>
                    <LI CLASS="homepageLinks"><A HREF="cont.php">Contractors</A></LI>
                  </UL></TD>
                <TD><IMG SRC="images/x.gif" WIDTH="20" HEIGHT="20"></TD>
                <TD WIDTH="33%"><UL>
                    <LI CLASS="homepageLinks"><A HREF="db.php">Databases</A></LI>
                    <LI CLASS="homepageLinks"><A HREF="dent.php">Dentistry</A></LI>
                    <LI CLASS="homepageLinks"><A HREF="edu.php">Education</A></LI>
                    <LI CLASS="homepageLinks"><a href="ele.php">Electronics</a></LI>
                    <LI CLASS="homepageLinks"><a href="ent.php">Entertainment</a></LI>
                    <LI CLASS="homepageLinks"><A HREF="events.php">Event Management</A></LI>
                    <LI CLASS="homepageLinks"><a href="flow.php">Flowers</a></LI>
                    <LI CLASS="homepageLinks"><a href="coins.php">Gold &amp; Silver Coins</a></LI>
                    <LI CLASS="homepageLinks"><a href="gol.php">Golf</a></LI>
                    <LI CLASS="homepageLinks"><a href="gov.php">Government</a></LI>
                    <LI CLASS="homepageLinks"><a href="health.php">Health</a></LI>
                    <LI CLASS="homepageLinks"><a href="hob.php">Hobbies</a></LI>
                    <LI CLASS="homepageLinks"><a href="homeacc.php">Home Accessories</a></LI>
                    <LI CLASS="homepageLinks"><A HREF="homebui.php">Home Builders</A></LI>
                    <LI CLASS="homepageLinks"><a href="hospitals.php">Hospitals</a></LI>
                    <LI CLASS="homepageLinks"><a href="hotel.php">Hotel &amp; Casinos</a></LI>
                    <LI CLASS="homepageLinks"><A HREF="ins.php">Insurance</A></LI>
                    <LI CLASS="homepageLinks"><a href="jewelry.php">Jewelry</a></LI>
                    <LI CLASS="homepageLinks"><A HREF="land.php">Landscaping</A></LI>
                    <LI CLASS="homepageLinks"><A HREF="mag.php">Magazines</A></LI>
                  </UL></TD>
                <TD><IMG SRC="images/x.gif" WIDTH="20" HEIGHT="20"></TD>
                <TD WIDTH="33%"><UL>
                    <LI CLASS="homepageLinks"><a href="med.php">Medical Resources</a></LI>
                    <LI CLASS="homepageLinks"><A HREF="mort.php">Mortgages</A></LI>
                    <LI CLASS="homepageLinks"><a href="music.php">Music</a></LI>
                    <LI CLASS="homepageLinks"><a href="new.php">Newcomers</a></LI>
                    <LI CLASS="homepageLinks"><a href="pain.php">Pain Management</a></LI>
                    <LI CLASS="homepageLinks"><a href="pawn.php">Pawn Shops</a></LI>
                    <LI CLASS="homepageLinks"><a href="photo.php">Photography</a></LI>
                    <LI CLASS="homepageLinks"><A HREF="real.php">Real Estate</A></LI>
                    <LI CLASS="homepageLinks"><a href="rec.php">Recreation</a></LI>
                    <LI CLASS="homepageLinks"><a href="showtickets.php">Show Tickets</a></LI>
                    <LI CLASS="homepageLinks"><a href="shows.php">Shows</a></LI>
                    <LI CLASS="homepageLinks"><a href="spevents.php">Special Events</a></LI>
                    <LI CLASS="homepageLinks"><a href="sports.php">Sports</a></LI>
                    <LI CLASS="homepageLinks"><a href="thea.php">Theatres</a></LI>
                    <LI CLASS="homepageLinks"><a href="tours.php">Tours</a></LI>
                    <LI CLASS="homepageLinks"><A HREF="trav.php">Travel</A></LI>
                    <LI CLASS="homepageLinks"><a href="vide.php">Video Games</a></LI>
                    <LI CLASS="homepageLinks"><a href="wed.php">Weddings</a></LI>
                    <LI CLASS="homepageLinks"><a href="weight.php">Weight Loss</a></LI>
                    <LI CLASS="homepageLinks"><A HREF="youth.php">Youth Organizations</A></LI>
                  </UL></TD>
              </TR>
            </TABLE></TD>
        </TR>
        
      </TABLE></TD>
    <TD WIDTH="140" VALIGN="TOP" CLASS="paddedCell"><P><A HREF="<?php echo $HitLink1 . $row_rsSideBanner["bannerID"] ?>"><IMG SRC="http://www.lasvegasdirectory.com/lvdbanners/<?php echo $row_rsSideBanner['bannerImage']; ?>" ALT="Banner Advertisement" WIDTH="120" HEIGHT="200" BORDER="0"></A></P>
      <P><A HREF="<?php echo $HitLink2 . $row_rsSideBannerTwo["bannerID"] ?>"><IMG SRC="http://www.lasvegasdirectory.com/lvdbanners/<?php echo $row_rsSideBannerTwo['bannerImage']; ?>" ALT="Banner Advertisment" WIDTH="120" HEIGHT="200" BORDER="0"></A></P></TD>
  </TR>
  <TR>
    <TD BGCOLOR="#0c476c">&nbsp;</TD>
    <TD COLSPAN="2" CLASS="paddedCell"><P ALIGN="CENTER" CLASS="textType2">
        &copy; 2003 Las Vegas Websites.com | Site Design &amp; Hosting by <A HREF="http://www.americandirectory.com/">American Directory.com</A></P></TD>
  </TR>
</TABLE>
</BODY>
</HTML>
<?php
mysql_free_result($rsBanners);

mysql_free_result($rsImageRotate);

mysql_free_result($rsCategories);

mysql_free_result($rsSideBanner);

mysql_free_result($rsSideBannerTwo);
?>