<?
/*
 * $Rev: 448 $
 * $Author: judd $
 * $Date: 2006-11-16 12:55:47 -0800 (Thu, 16 Nov 2006) $
 * $HeadURL: http://svn.searchsystems.net/ss/www.searchsystems.net/trunk/system/lib/db.php $
 * $Id: db.php 448 2006-11-16 20:55:47Z judd $
 */
// +---------------------------------------------------------------------------+
// | This file is part of SSAF.                                                |
// | Copyright 2005 Search Systems. All rights reserved.                       |
// |                                                                           |
// | Author: Darryl Koster <dkoster@searchsystems.net>                         |
// +---------------------------------------------------------------------------+
// | This file makes the connection to the databases.                          |
// +---------------------------------------------------------------------------+

if (!isset($intConn)) {
	$intConn = pg_connect("host=207.178.201.201 user=ss password=ssdb dbname=ss") or die("Could not connect to database!");
}

?>
<?
/*
+--------------------------------------------------+
| PARSE_QUERY (str Search, int Type,               |
|              ary SearchFields)                   |
+--------------------------------------------------+
| Returns a SQL select statement on any outcome    |
+--------------------------------------------------+
*/
function parse_query($strSearch = "", $intType = 1, $arySearchFields = array()) {
    if (trim($strSearch) == "") return "";
    $strSearch = trim($strSearch);

    // Basic search
    if ($intType == 1 || $intType == 2) {

        // Match any/all keywords
        if ($intType == 2) {
            $strDelimiter = ") OR (";
        } else {
            $strDelimiter = ") AND (";
        }

        // Replace multiple spaces with 1 space
        $strSearch = preg_replace("/\s{1,}/", " ", $strSearch);

        // Explode string by space
        $aryWords = explode(" ", $strSearch);
        $arySearchedWords = array();

        // Build query
        for ($i = 0; $i < sizeof($aryWords); $i++) {
            $aryWords[$i] = addslashes($aryWords[$i]);
            if (check_word_count($arySearchedWords, $aryWords[$i]) < 1) {
                $arySearchedWords[] = $aryWords[$i];
                for ($x = 0; $x < sizeof($arySearchFields); $x++) {                	

			//error_log("search: i=$i, x=$x");

                    if (isset($arySearch[$i])) {
                        $arySearch[$i] .= " OR UPPER({$arySearchFields[$x]}) LIKE UPPER('% {$aryWords[$i]}%')";
                        $arySearch[$i] .= " OR UPPER({$arySearchFields[$x]}) LIKE UPPER('{$aryWords[$i]}%')";
                    } else {
                        $arySearch[$i] = " UPPER({$arySearchFields[$x]}) LIKE UPPER('% {$aryWords[$i]}%')";
                        $arySearch[$i] .= " OR UPPER({$arySearchFields[$x]}) LIKE UPPER('{$aryWords[$i]}%')";
                    }
/*
                	error_log("search: arySearch=" . print_r($arySearch, true));
                	error_log("search: arySearchedWords=" . print_r($arySearchedWords, true));
                	error_log("search: arySearchFields=" . print_r($arySearchFields, true));
                	error_log("search: aryWords=" . print_r($aryWords, true));                	
*/
                }
            }
        }

        // Return
        if (sizeof($arySearch) > 1) {
            return "(" . implode($strDelimiter, $arySearch) . ")";
        } else {
            return "(" . $arySearch[0] . ")";
        }

    } else {

        // Match exact phrase
        $strSearch = addslashes($strSearch);

        // Build query
        for ($i = 0; $i < sizeof($arySearchFields); $i++) {
            $arySearch[$i] = "UPPER({$arySearchFields[$i]}) LIKE UPPER('%{$strSearch}%')";
        }

        // Return
        if (sizeof($arySearch) > 1) {
            return "(" . implode(" OR ", $arySearch) . ")";
        } else {
            return $arySearch[0];
        }
    }
}

/*
+--------------------------------------------------+
| PARSE_ADVANCED_QUERY (str AnyWords, str AllWords |
|                       str ExactPhrase,           |
|                       str WithoutWords           |
|                       ary SearchFields)          |
+--------------------------------------------------+
| Returns a SQL select statement on any outcome    |
+--------------------------------------------------+
*/
function parse_advanced_query($strAnyWords = "", $strAllWords = "",
                              $strExactPhrase = "", $strWithoutWords = "",
                              $arySearchFields = array()) {

    // Advanced search
    $strAnyWords = trim($strAnyWords);
    $strAllWords = trim($strAllWords);
    $strExactPhrase = trim($strExactPhrase);
    $strWithoutWords = trim($strWithoutWords);

    // Build ANY words query
    if ($strAnyWords != "") {
        // Replace multiple spaces with 1 space
        $strAnyWords = preg_replace("/\s{1,}/", " ", $strAnyWords);

        // Explode string by space
        $aryAnyWords = explode(" ", $strAnyWords);

        for ($i = 0; $i < sizeof($aryAnyWords); $i++) {
            $aryAnyWords[$i] = addslashes($aryAnyWords[$i]);
            for ($x = 0; $x < sizeof($arySearchFields); $x++) {
                if (isset($aryAnyWordsSearch[$i])) {
                    $aryAnyWordsSearch[$i] .= " OR UPPER({$arySearchFields[$x]}) LIKE UPPER('% {$aryAnyWords[$i]}%')";
                    $aryAnyWordsSearch[$i] .= " OR UPPER({$arySearchFields[$x]}) LIKE UPPER('{$aryAnyWords[$i]}%')";
                } else {
                    $aryAnyWordsSearch[$i] .= " UPPER({$arySearchFields[$x]}) LIKE UPPER('% {$aryAnyWords[$i]}%')";
                    $aryAnyWordsSearch[$i] .= " OR UPPER({$arySearchFields[$x]}) LIKE UPPER('{$aryAnyWords[$i]}%')";
                }
            }
        }

        if (isset($aryAnyWordsSearch)) {
            if (sizeof($aryAnyWordsSearch) > 1) {
                $strQuery[] = "(" . implode(") OR (", $aryAnyWordsSearch) . ")";
            } else {
                $strQuery[] = "{$aryAnyWordsSearch[0]}";
            }
        }
    }

    // Build ALL words query
    if ($strAllWords != "") {
        // Replace multiple spaces with 1 space
        $strAllWords = preg_replace("/\s{1,}/", " ", $strAllWords);

        // Explode string by space
        $aryAllWords = explode(" ", $strAllWords);

        for ($i = 0; $i < sizeof($aryAllWords); $i++) {
            $aryAllWords[$i] = addslashes($aryAllWords[$i]);
            for ($x = 0; $x < sizeof($arySearchFields); $x++) {
                if (isset($aryAllWordsSearch[$i])) {
                    $aryAllWordsSearch[$i] .= " OR UPPER({$arySearchFields[$x]}) LIKE UPPER('% {$aryAllWords[$i]}%')";
                    $aryAllWordsSearch[$i] .= " OR UPPER({$arySearchFields[$x]}) LIKE UPPER('{$aryAllWords[$i]}%')";
                } else {
                    $aryAllWordsSearch[$i] .= " UPPER({$arySearchFields[$x]}) LIKE UPPER('% {$aryAllWords[$i]}%')";
                    $aryAllWordsSearch[$i] .= " OR UPPER({$arySearchFields[$x]}) LIKE UPPER('{$aryAllWords[$i]}%')";
                }
            }
        }

        if (isset($aryAllWordsSearch)) {
            if (sizeof($aryAllWordsSearch) > 1) {
                $strQuery[] = "(" . implode(") AND (", $aryAllWordsSearch) . ")";
            } else {
                $strQuery[] = "{$aryAllWordsSearch[0]}";
            }
        }
    }

    // Build WITHOUT words query
    if ($strWithoutWords != "") {
        // Replace multiple spaces with 1 space
        $strWithoutWords = preg_replace("/\s{1,}/", " ", $strWithoutWords);

        // Explode string by space
        $aryWithoutWords = explode(" ", $strWithoutWords);
        for ($i = 0; $i < sizeof($aryWithoutWords); $i++) {
            $aryWithoutWords[$i] = addslashes($aryWithoutWords[$i]);
            for ($x = 0; $x < sizeof($arySearchFields); $x++) {
                if (isset($aryWithoutWordsSearch[$i])) {
                    $aryWithoutWordsSearch[$i] .= " AND UPPER({$arySearchFields[$x]}) NOT LIKE UPPER('% {$aryWithoutWords[$i]}%')";
                    $aryWithoutWordsSearch[$i] .= " AND UPPER({$arySearchFields[$x]}) NOT LIKE UPPER('{$aryWithoutWords[$i]}%')";
                } else {
                    $aryWithoutWordsSearch[$i] .= " UPPER({$arySearchFields[$x]}) NOT LIKE UPPER('% {$aryWithoutWords[$i]}%')";
                    $aryWithoutWordsSearch[$i] .= " AND UPPER({$arySearchFields[$x]}) NOT LIKE UPPER('{$aryWithoutWords[$i]}%')";
                }
            }
        }

        if (isset($aryWithoutWordsSearch)) {
            if (sizeof($aryWithoutWordsSearch) > 1) {
                $strQuery[] = "(" . implode(") AND (", $aryWithoutWordsSearch) . ")";
            } else {
                $strQuery[] = "{$aryWithoutWordsSearch[0]}";
            }
        }
    }

    // Build EXACT PHRASE query
    if ($strExactPhrase != "") {
        for ($i = 0; $i < sizeof($arySearchFields); $i++) {
            if (isset($strExactPhraseSearch)) {
                $aryExactPhraseSearch[$i] .= " OR UPPER({$arySearchFields[$i]}) LIKE UPPER('% {$strExactPhrase}%')";
                $aryExactPhraseSearch[$i] .= " OR UPPER({$arySearchFields[$i]}) LIKE UPPER('{$strExactPhrase}%')";
            } else {
                $aryExactPhraseSearch[$i] .= " UPPER({$arySearchFields[$i]}) LIKE UPPER('% {$strExactPhrase}%')";
                $aryExactPhraseSearch[$i] .= " OR UPPER({$arySearchFields[$i]}) LIKE UPPER('{$strExactPhrase}%')";
            }
        }

        if (isset($aryExactPhraseSearch)) {
            if (sizeof($aryExactPhraseSearch) > 1) {
                $strQuery[] = implode(" OR ", $aryExactPhraseSearch);
            } else {
                $strQuery[] = $aryExactPhraseSearch[0];
            }
        }
    }

    if (isset($strQuery)) {
        if (sizeof($strQuery) > 1) {
            return "(" . implode(") AND (", $strQuery) . ")";
        } else {
            return $strQuery[0];
        }
    }

    return "";
}

/*
+--------------------------------------------------+
| CHECK_WORD_COUNT (ary Words, str Word)           |
+--------------------------------------------------+
| Returns the number of times the word occures in  |
| the array                                        |
+--------------------------------------------------+
*/
function check_word_count ($aryWords = array(), $strWord = "") {
    $count = 0;
    for ($i = 0; $i < sizeof($aryWords); $i++) {
        if (strtolower($aryWords[$i]) == strtolower($strWord)) $count++;
    }
    return $count;
}

/*
+--------------------------------------------------+
| GET_PATH (int node)                              |
+--------------------------------------------------+
| Returns a full path to the node on success and   |
| false on failure                                 |
+--------------------------------------------------+
*/
function get_path ($intConn = 0, $intNode = 0) {
    if ($intNode == 0) {
        return false;
    } else if (!preg_match("/^[0-9]+$/", $intNode)) {
        return false;
    }

    if (!($aryRow = get_node_info($intConn, $intNode))) return false;

    $strPath = "<a href=\"list.php?nid=$aryRow[node_id]\" target=\"_top\">$aryRow[name]</a>";
    $intNode = $aryRow["parent_id"];

    while (1) {
        if ($intNode > 1) {
            if (!($aryRow = get_node_info($intConn, $intNode))) break;
            $strPath = "<a href=\"list.php?nid=$aryRow[node_id]\">$aryRow[name]</a> / {$strPath}";
            $intNode = $aryRow["parent_id"];
        } else {
            break;
        }
    }

    return $strPath;
}

/*
+--------------------------------------------------+
| GET_NODE_INFO (int node)                         |
+--------------------------------------------------+
| Returns a result set that contains the node and  |
| name on success and false on failure             |
+--------------------------------------------------+
*/
function get_node_info ($intConn = 0, $intNode = 0) {
    $strExec = "SELECT node_id, parent_id, name
                FROM nodes
                WHERE node_id = $intNode";
    $intQuery = pg_exec($intConn, $strExec);
    if (pg_numrows($intQuery) > 0) return pg_fetch_array($intQuery, 0);
    return false;
}

/*
+--------------------------------------------------+
| GET_PAGE_NUMS (int page, int limit, int pages)   |
+--------------------------------------------------+
| Returns an array containing the start and ending |
| points                                           |
+--------------------------------------------------+
| 1 = Forward                                      |
| 2 = Backward                                     |
+--------------------------------------------------+
*/
function get_page_nums ($intPage = 1, $intLimit = 1, $intTotalPages) {
    $tmpArray = explode(".", $intTotalPages);
    $intTotalPages = $tmpArray[0];

    // Figure out the direction to work from
    if ($intPage > 5) {
        if ($intPage + 5 < $intTotalPages) {
            $intDir = 1;
            $intStart = $intPage - 5;
        } else {
            $intDir = 2;
            $intEnd = $intTotalPages;
        }
    } else {
        $intDir = 1;
        $intStart = 1;
    }

    if ($intDir == 1) {
        $intEnd = $intStart;
        // Fordward
        for ($i = $intStart; $i < $intStart + 10; $i++) {
            if ($i < $intTotalPages) {
                $intEnd++;
            } else {
                break;
            }
        }
        return array($intStart, $intEnd);

    } else {
        // Backward
        $intStart = $intEnd;

        // Forward
        for ($i = $intEnd; $i >= $intEnd - 10; $i--) {
            if ($i > 1) {
                $intStart--;
            } else {
                break;
            }
        }
        return array($intStart, $intEnd);
    }
}

/*
+--------------------------------------------------+
| GET_PATH (int node)                              |
+--------------------------------------------------+
| Returns a full path to the node on success and   |
| false on failure                                 |
+--------------------------------------------------+
*/
function get_search_path ($intConn = 0, $intNode = 0) {
    if ($intNode == 0) {
        return false;
    } else if (!preg_match("/^[0-9]+$/", $intNode)) {
        return false;
    }

    if (!($aryRow = get_node_info($intConn, $intNode))) return false;

    $strPath = $aryRow['name'];
    $intNode = $aryRow["parent_id"];
    $nid = $aryRow['node_id'];

    for ($i = 0; true; $i++) {
        if ($intNode > 1) {
            if (!($aryRow = get_node_info($intConn, $intNode))) break;
            $strPath = $aryRow['name'] . ' / ' . $strPath;
            $intNode = $aryRow["parent_id"];
        } else {
            break;
        }
    }

    $strPath = "<a href=\"list.php?nid=$nid\">$strPath</a>"; 
    return $strPath;
}

/*
+--------------------------------------------------+
| GET_PATH (int node)                              |
+--------------------------------------------------+
| Returns a full path to the node on success and   |
| false on failure                                 |
+--------------------------------------------------+
*/
function get_clean_path ($intConn = 0, $intNode = 0) {
    if ($intNode == 0) {
        return false;
    } else if (!preg_match("/^[0-9]+$/", $intNode)) {
        return false;
    }

    if (!($aryRow = get_node_info($intConn, $intNode))) return false;

    $strPath = $aryRow['name'];
    $intNode = $aryRow["parent_id"];
    $nid = $aryRow['node_id'];

    for ($i = 0; true; $i++) {       
        if ($intNode > 1) {
            if (!($aryRow = get_node_info($intConn, $intNode))) break;
            $strPath = $aryRow['name'] . ' / ' . $strPath;
            $intNode = $aryRow["parent_id"];
        } else {
            break;
        }
    }

    return $strPath;
}

?>


<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
  <head>
    <meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
    <title>Access Your Account | SearchSystems.net</title>
    <meta name="title" content="SearchSystems.net Criminal Records, Bankruptcies, Judgments and Tax Liens"/>
    <meta name="description" content="SearchSystems.net Criminal and Offender Records, Bankruptcies, Judgments and Tax Liens, federal, court, civil, bankruptcy, public"/>
    <meta name="keywords" content="criminal, offender, bankruptcies, tax, liens, judgments, federal, property, court, civil, bankruptcy, public, records, national, social security, documents, suit, action, certificates, lawsuits, information, real, estate, state, florida, california, michigan"/>
    <meta name="rating" content="GENERAL"/>

    <meta name="classification" content="Search"/>
    <meta name="copyright" content="SearchSystems.net"/>
    <meta name="distribution" content="GLOBAL"/>
    <meta name="Author" content="SearchSystems.net"/>
    <meta http-equiv="content-language" content="en" />
    <link href="/css/common-login.css" rel="stylesheet" type="text/css" media="screen" />
  </head>
  
<body>
  <div class="bodywrap">

    <center>
      <div id="owrap">
        
        <!--// masthead begins //-->
                <div id="masthead">
            <div id="logo"><img src="/images/common/updated-logo.png" alt="SearchSystems.net" /></div>
        </div>        <!--// masthead ends //-->
        
        <!--// main content area begins //-->
        <table cellpadding="0" cellspacing="0" border="0" width="950" id="maintable">

          <tr valign="top">
            
            <!--// column one begins //--> 
            <td id="colone" align="left">
              <div class="wrap">
                <div class="innerwrap">

                        <!--// content begins //-->
                        <div id="error">
    </div>

<div id="formwrapper">

    <p class="note"><span class="req"><strong>*</strong></span> Required Fields </p>

    <h1>Member Login</h1>

    <p>Log in here to SearchSystems.net for access to criminal records, bankruptcies, judgments, and tax lien databases, as well as our public records directory.</p>

    <form method="post" action="login-new.php">

        <ul>
            <li><label for="username"><span class="req"><strong>*</strong></span> Username:</label> <input class="formfield" id="username" name="username" type="text" tabindex="1" size="25" maxlength="25" value=""/> <a href="https://members.searchsystems.net/retrieve_username_step1.php">Username Help</a></li>

            
            <li><label for="password"><span class="req"><strong>*</strong></span> Password:</label> <input class="formfield" id="password" name="password" type="password" tabindex="2" size="25" maxlength="25" value=""/> <a href="https://members.searchsystems.net/reset_password_step1.php">Password Help</a></li>

<input type="hidden" name="linkid" value=""/>
<input type="hidden" name="nid" value=""/>

            <li><label>&nbsp; </label> <input type="submit" tabindex="3" value="Login"/></li>

            <li>
<? foreach ($errors as $param => $error) { ?>
                <font color='#FF0000'><br/></font>
<? } ?>            
			</li>
        </ul>
    </form>
    
    <p>If you don't have a username and password yet <a href="https://www.searchsystems.net/springapp/funnel/signup.do">become a member</a>.</p>

    <p>Members have a subscription issued by SearchSystems.net. No other website or service may offer a SearchSystems.net membership.</p>
    </div>
                        <!--// content ends //-->

                </div>
              </div>
            </td>
            <!--// column one ends //--> 

            <!--// column two begins //-->

            <td id="coltwo" align="left">
                <div class="wrap">

                    <!--// menu begins //-->
                    <div id="options">
    <a href="https://www.searchsystems.net/springapp/funnel/signup.do"><img src="/images/common/not-a-member.png" width="262" height="84" /></a>
</div>

<div id="photo"><img src="/images/common/ss-logo-orig.png" alt="SearchSystems.net" width="261" height="177" /></div>

<!-- BEGIN TESTIMONIAL -->
<div id="testimonials"><p>

One of the "Fifty most useful web sites on the Internet"</p>
<p class="credit">
- PCWorld Magazine, February 2003
</p></div><!-- END TESTIMONIAL -->                    <!--// menu ends //-->

                </div>
            </td>
            <!--// column two ends //--> 

        </tr>
    </table>
    <!--// main content area ends //-->

  </div>

    <!--// mastfoot begins //-->
        <div id="footer">
        <div class="wrap">
            <!--// security icons begin //-->
            <ul class="security">
                <li><a href="https://www.bbb.org/online/consumer/cks.aspx?ID=10404141025041762" target="_blank" title="Better Business Bureau"><img src="/images/common/footer-logo-bb.gif" alt="Better Business Bureau" /></a></li>
                <li><a onclick="window.open('https://www.thawte.com/cgi/server/certdetails.exe?referer=https://www.searchsystems.net/', 'Thawte', 'width=500, height=500')" href="#" title="Thawte"><img src="/images/common/footer-logo-thawte.gif" alt="Thawte" /></a></li>

            </ul>
            <!--// security icons end //-->

            <!--// primary footer links //-->
            <ul class="primary">
                <li>Copyright &copy; 2003-2008 Pacific Information Resources, Inc. All rights reserved.</li>
            </ul>
            <!--// primary footer links ends //-->

            <!--// secondary (lesser) footer links begin //--> 
            <ul class="secondary">
                <li><a href="webmaster.php" target="_blank" title="Contact Us">Contact Us</a> | </li>
                <li><a href="privacy.php" target="_blank" title="Privacy Policy">Privacy Policy</a> | </li>
                <li><a href="disclaimer.php" target="_blank" title="Disclaimer">Disclaimer</a></li>

            </ul>
            <!--// secondary footer ends //-->
        </div>
    </div>    <!--// mastfoot ends //-->

    </center>
  </div>
</body>
</html>