<?
// let's get the adodb included
// refer to the php include path in the apache virtualhost block for this domain
//require('adodb.inc.php'); This one does not use ADODB

// this file is basically just a 2nd abstraction layer that I'm gonna put on top of the ADODB layer
// ADODB formats the results of the queries satisfactorily, but I don't like how it deals with the input
// this way, we can just include a hash or associative array into the argument of the query function
// and the actual query string will be automatically created. This saves us alot of hassle not having to deal
// with accidental SQL syntax errors and whatnot. There's prolly some way to plug something like this
// right into ADODB, but I didn't feel like digging though all the files to figure out how. This method was
// quick, and can't be too much slower than a better one. Enjoy!
class DB
{
    /*## Database Variables ##*/
    /*## ------------------ ##*/
    var $DBhost = "127.0.0.1";
    var $DBuser = "family";
    var $DBpass = "dr!v3r";
    var $DBname = "vmem";
    var $DBtype = "mysql";
    var $DBdebug = false;
    /*## ------------------ ##*/
    /*## DON'T CHANGE BELOW ##*/
    
    var $totalQueries = 0;

    function __construct()
    {
        //## Connect to Server ##
//        if($this->DBdebug) $this->ADODB->debug = true;
        $this->dbh = mysql_connect($this->DBhost, $this->DBuser, $this->DBpass);
        mysql_select_db($this->DBname, $this->dbh);
        $this->dbgtxt = '';
    }

    function __destruct()
    {
        mysql_close($this->dbh);
    }

    function simpleQuery ($table,$fields = "",$where = "", $extra = "")
    {

        if($where) $where = "WHERE ".$where;

        if ($fields == "*" || $fields == ""){
            $fieldsArray = $this->getFields($table);
            $fields = '`' .implode("`,`",$fieldsArray). '`';
        }

        $query = "SELECT $fields FROM $table $where $extra";
        $this->dbgtxt .= $query."\n";
        $dh = mysql_query($query, $this->dbh);
        $data = array();
        if(is_resource($dh)){
            while($datal = mysql_fetch_assoc($dh)){
                $data[] = $datal;
            }
            mysql_free_result($dh);
        }
        $this->totalQueries++;

        // let's make sure that we have data to return, or else return false
        if(count($data) > 0) {
            return $data;
        } else {
            return false;
        }
    }

    function dbWrite($table,$pairs,$where = "")
    {
        if($where) $where = "WHERE ".$where;

        $nPairs = count($pairs);
        for ($i=0;$i<$nPairs;$i++)
        {
            $keys .= "`".key($pairs)."`";
            $values .= "'".$this->escape($pairs[key($pairs)])."'";
            if ($i<($nPairs -1)) { $keys .= ","; $values .= ","; }
            next($pairs);
        }

        $query = "INSERT INTO $table ($keys) VALUES ($values) $where";
        $this->dbgtxt .= $query."\n";
        mysql_query($query,$this->dbh);
        $this->totalQueries++;
        return mysql_insert_id($this->dbh);
    }

    function dbBatchWrite($table,$arrs,$where = "")
    {
        if($where) $where = "WHERE ".$where;

        $numr = count($arrs);
        $i=0;
        foreach($arrs as $pairs){
            if($i==0){
                $i++;
                $keys = "`".implode('`,`',array_keys($pairs))."`";
                $values = "(";
            }else{
                $values.=",(";
            }
            foreach($keys as $aky){
                $values .= "'".$pairs[$aky]."'";
            }
            $values.=")";
        }

        $query = "INSERT INTO $table ($keys) VALUES $values $where";
        $this->dbgtxt .= $query."\n";
        mysql_query($query,$this->dbh);
        $this->totalQueries++;
        return mysql_insert_id($this->dbh);
    }

    function dbReplace($table,$pairs,$where = "")
    {
        if($where) $where = "WHERE ".$where;

        $nPairs = count($pairs);
        for ($i=0;$i<$nPairs;$i++)
        {
            $keys .= "`".key($pairs)."`";
            $values .= "'".$pairs[key($pairs)]."'";
            if ($i<($nPairs -1)) { $keys .= ","; $values .= ","; }
            next($pairs);
        }

        $query = "REPLACE INTO $table ($keys) VALUES ($values) $where";
        $this->dbgtxt .= $query."\n";
        mysql_query($query,$this->dbh);
        $this->totalQueries++;
        return mysql_insert_id($this->dbh);
    }

    // this function does a INSERT... SELECT - it also works a lil bit differently than the other funcs
    //function dbInsertSelect($insTable,$insFields,$selTable,$selFields,$selWhere,$selExtra)
    function dbInsertSelect($data)
    {
        if($data['selWhere']) $data['selWhere'] = "WHERE ".$data['selWhere'];

        if ($data['insFields'] == "*" || $data['insFields'] == ""){
            $data['insFieldsArray'] = $this->getFields($data['insTable']);
            $data['insFields'] = implode(",",$data['insFieldsArray']);
        }

        if ($data['selFields'] == "*" || $data['selFields'] == ""){
            $data['selFieldsArray'] = $this->getFields($data['selTable']);
            $data['selFields'] = implode(",",$data['selFieldsArray']);
        }

        $query = "INSERT INTO ".$data['insTable']." (".$data['insFields'].") SELECT ".$data['selFields']." FROM ".$data['selTable']." ".$data['selWhere']." ".$data['selExtra'];
        $this->dbgtxt .= $query."\n";
        mysql_query($query,$this->dbh);
        $this->totalQueries++;
        $ar = mysql_affected_rows($this->dbh);
        if($ar >= 1) return $ar;
        else return false;
    }

    function dbUpdate($table,$pairs,$where,$type)
    {
        if($where) $where = "WHERE ".$where;

        // let's check to see whether or not the pairs var is an array
        if(is_array($pairs)) {
            $nPairs = count($pairs);
            for ($i=0;$i<$nPairs;$i++)
            {
                if(!$type) $update .= "`".key($pairs)."`='".$this->escape($pairs[key($pairs)])."'";
                else $update .= "`".key($pairs)."`=".$this->DB->escape($pairs[key($pairs)]);
                if ($i<($nPairs -1)) $update .= ",";
                next($pairs);
            }
        } else $update = $pairs;

        $query = "UPDATE $table SET $update $where";
        $this->dbgtxt .= $query."\n";
        mysql_query($query,$this->dbh);
        $this->totalQueries++;
        $ar = mysql_affected_rows($this->dbh);
        if($ar >= 1) return $ar;
        else return false;
    }

    function delete($table,$where, $extra = "")
    {
        $query = "DELETE FROM $table WHERE $where $extra";
        $this->dbgtxt .= $query."\n";
        mysql_query($query,$this->dbh);
        $this->totalQueries++;
        $ar = mysql_affected_rows($this->dbh);
        if($ar >= 1) return $ar;
        else return false;
    }

    function getFields($ftable)
    {
        $fquery = "SHOW COLUMNS FROM $ftable";
        $this->dbgtxt .= $fquery."\n";
        $fdh = mysql_query($fquery,$this->dbh);
        $retfields = array();
        while($fdt = mysql_fetch_assoc($fdh)){
            $retfields[] = $fdt['Field'];
        }
        mysql_free_result($fdh);
        $this->dbgtxt .= "SHOW COLUMNS returned : ".implode(',',$retfields)."\n";
        return $retfields;
    }
    
    function escape($ips)
    {
        return mysql_real_escape_string($ips,$this->dbh);
    }
}

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html><head>

     

    <title>VCARS - Meeting Location</title><meta name="description" content="The Ventura County Amateur Radio Society is dedicated to public education and service related to amateur radio.">

    <meta name="keywords" content="VCARS, amateur radio, ARRL, ham radio">

    <style>

        .mnu {font-family:Arial; font-size:20px; color:#0033FF}

    </style></head>
<body bgcolor="#cccccc">

<script language="javascript">

    if (top !=self)

    top.location=self.location;

    var ff = (navigator.userAgent.indexOf("Firefox") != -1);

    if(ff){
        HTMLElement.prototype.click = function() {
            if(this.onClick){
                this.onClick();
            }
            document.location.href=this.href;
        }
    }

    function mOvr(src){
        src.style.cursor = 'pointer';
        src.bkgc = src.bgColor;
        src.bgColor = "#999999";
    }

    function mOut(src){
        src.style.cursor = 'default';
        src.bgColor = src.bkgc;
    }

    function mClk(src){
        if(src.tagName=='TD'){
            if(ff){
                var coll = src.childNodes;
                if (coll != null)
                {
                    for (i=0; i<coll.length; i++)
                    {
                        if(coll.item(i).tagName == "A")
                        {
                            coll.item(i).click();
                        }
                    }
                }
            }else{
                src.children.tags('A')[0].click();
            }
        }
    }
</script>

<center><table cellspacing="0">

                <tbody><tr bgcolor="#666666" valign="middle">

                  <td onmouseover="mOvr(this);" onmouseout="mOut(this);" onclick="mClk(this);" align="center" nowrap="nowrap" valign="middle"><a href="/"><font color="#ffff33" face="Arial Black" size="6">V</font><font color="#ffff33" face="Arial Black" size="6">entura</font></a>

                     <a href="/"><font color="#ffff33" face="Arial Black" size="6">C</font><font color="#ffff33" face="Arial Black" size="6">ounty </font></a><br>

                     <a href="/"><font color="#ffff33" face="Arial Black" size="6">A</font><font color="#ffff33" face="Arial Black" size="6">mateur</font></a>

                     <a href="/"><font color="#ffff33" face="Arial Black" size="6">R</font><font color="#ffff33" face="Arial Black" size="6">adio</font></a>

                     <a href="/"><font color="#ffff33" face="Arial Black" size="6">S</font><font color="#ffff33" face="Arial Black" size="6">ociety</font></a></td>

                    <td align="center">

             <table bgcolor="#ccccff" border="1" bordercolor="#666666" cellspacing="0">

<tbody><tr>   <td onmouseover="mOvr(this);" onmouseout="mOut(this);" onclick="mClk(this);" class="mnu" align="center" nowrap="nowrap" valign="middle"><a href="/meeting.php" class="mnu">Meeting Info</a></td>

   <td onmouseover="mOvr(this);" onmouseout="mOut(this);" onclick="mClk(this);" class="mnu" align="center" nowrap="nowrap" valign="middle"><a href="/Tech.html" class="mnu">Technical Projects</a></td>

</tr>

<tr>   <td onmouseover="mOvr(this);" onmouseout="mOut(this);" onclick="mClk(this);" class="mnu" align="center" nowrap="nowrap" valign="middle"><a href="/memlist.php" class="mnu">Member List</a></td>

   <td onmouseover="mOvr(this);" onmouseout="mOut(this);" onclick="mClk(this);" class="mnu" align="center" nowrap="nowrap" valign="middle"><a href="/weak.html" class="mnu">Weak Signal</a></td>

</tr>

<tr>   <td onmouseover="mOvr(this);" onmouseout="mOut(this);" onclick="mClk(this);" class="mnu" align="center" nowrap="nowrap" valign="middle"><a href="/event/" class="mnu">Event Pictures</a></td>

   <td onmouseover="mOvr(this);" onmouseout="mOut(this);" onclick="mClk(this);" class="mnu" align="center" nowrap="nowrap" valign="middle"><a href="/Links" class="mnu">Links</a></td>

</tr>

<tr>   <td onmouseover="mOvr(this);" onmouseout="mOut(this);" onclick="mClk(this);" class="mnu" align="center" nowrap="nowrap" valign="middle"><a href="/tools.html" class="mnu">Tools</a></td>

   <td onmouseover="mOvr(this);" onmouseout="mOut(this);" onclick="mClk(this);" class="mnu" align="center" nowrap="nowrap" valign="middle"><a href="/members" class="mnu">Members Only</a></td>

</tr>

            </tbody></table>

                    </td>

                    </tr></tbody></table><br>

    <table>

        <tbody><tr valign="middle">

          <td align="center" valign="middle"><font color="#ff9933"><b><font color="#ff3300" size="+3">MEETING LOCATION AND TIME</font></b></font></td>

        </tr>

        <tr>

          <td align="center" valign="middle">

             <table>

                <tbody><tr>

                  <td>&nbsp;</td>

                  <td><iframe marginheight="0" marginwidth="0" src="http://maps.google.com/maps?f=q&amp;source=s_q&amp;hl=en&amp;geocode=&amp;q=Moorpark+Chamber+of+Commerce+office&amp;aq=&amp;sll=34.187556,-118.889912&amp;sspn=0.225494,0.349846&amp;t=m&amp;ie=UTF8&amp;hq=Moorpark+Chamber+of+Commerce+office&amp;hnear=&amp;ll=34.285229,-118.881932&amp;spn=0.225205,0.349846&amp;z=12&amp;iwloc=A&amp;cid=2098454889890417424&amp;output=embed" frameborder="0" height="350" scrolling="no" width="425"></iframe><br><small><a href="http://maps.google.com/maps?f=q&amp;source=embed&amp;hl=en&amp;geocode=&amp;q=Moorpark+Chamber+of+Commerce+office&amp;aq=&amp;sll=34.187556,-118.889912&amp;sspn=0.225494,0.349846&amp;t=m&amp;ie=UTF8&amp;hq=Moorpark+Chamber+of+Commerce+office&amp;hnear=&amp;ll=34.285229,-118.881932&amp;spn=0.225205,0.349846&amp;z=12&amp;iwloc=A&amp;cid=2098454889890417424" style="color: rgb(0, 0, 255); text-align: left;">View Larger Map</a></small>

                </td></tr>

             </tbody></table></td>

        </tr>

        <tr>
            </tr><tr><td colspan="3" align="center"><b>Get Directions from Google</b></td></tr>
            <tr><td align="center"><table><tbody><tr><td align="center">This month's meeting will be held in the meeting room at:<br><br>

            <table><tbody><tr><td nowrap="nowrap"><strong>Moorpark Chamber of Commerce office</strong><br>

            18 East High Street <br>

            Moorpark, CA 93021</td></tr></tbody></table></td><td>&nbsp;&nbsp;&nbsp;&nbsp;</td>

            </tr></tbody></table></td>

        </tr>

        <tr><td>Directions:<br>
From Oxnard/Ventura/Los Angeles on US101 to the 23 north: Get off at
off ramp 20A, West Los Angeles Ave and turn left onto East Los
Angeles&nbsp;&nbsp;&nbsp;go 1.2 miles<br>
From Simi Valley take CA-118 West to off ramp 18B, West Los Angeles Ave
and turn right onto East Los Angeles Ave&nbsp;&nbsp;&nbsp;go 1.2 miles<br>
Turn right onto MoorPark Ave.&nbsp;&nbsp;go 1.4 miles<br>
Parking entrance first right after the railroad tracks.
        </td></tr>

        <tr valign="middle">

          <td align="left" valign="middle">Meeting time:<br> 7:30 PM on the <b>Third Monday </b> of every month.<br>The next meeting date is <span style="font-weight: bold;">