<?php  defined('C5_EXECUTE') or die("Access Denied."); ?>
 
<?php  if (isset($error)) { ?>
   <?php echo $error?><br/><br/>
<?php  } ?>
 
<form action="<?php echo $this->url( $resultTargetURL )?>" method="get" class="ccm-search-block-form">
 
   <?php  if( strlen($title)>0){ ?><h3><?php echo $title?></h3><?php  } ?>
 
   <?php  if(strlen($query)==0){ ?>
   <input name="search_paths[]" type="hidden" value="<?php echo htmlentities($baseSearchPath, ENT_COMPAT, APP_CHARSET) ?>" />
   <?php  } else if (is_array($_REQUEST['search_paths'])) { 
      foreach($_REQUEST['search_paths'] as $search_path){ ?>
         <input name="search_paths[]" type="hidden" value="<?php echo htmlentities($search_path, ENT_COMPAT, APP_CHARSET) ?>" />
   <?php   }
   } ?>
 
   <input name="query" type="text" value="<?php echo htmlentities($query, ENT_COMPAT, APP_CHARSET)?>" class="ccm-search-block-text" />
 
   <input name="submit" type="submit" value="<?php echo $buttonText?>" class="ccm-search-block-submit" />
 
<?php  
$tt = Loader::helper('text');
if ($do_search) {
   if(count($results)==0){ ?>
      <h4 style="margin-top:32px"><?php echo t('There were no results found. Please try another keyword or phrase.')?></h4>   
   <?php  }else{ ?>
      <div id="searchResults">
      <?php  foreach($results as $r) { 
         $currentPageBody = $this->controller->highlightedExtendedMarkup($r->getBodyContent(), $query);?>
         <div class="searchResult">
            <h3><a href="<?php echo $r->getPath()?>"><?php echo $r->getName()?></a></h3>
            <p>
               <?php  if ($r->getDescription()) { ?>
                  <?php   echo $this->controller->highlightedMarkup($tt->shortText($r->getDescription()),$query)?><br/>
               <?php  } ?>
               <?php  echo $currentPageBody; ?>
               <a href="<?php   echo $r->getPath(); ?>" class="pageLink"><?php   echo $this->controller->highlightedMarkup($r->getPath(),$query)?></a>
            </p>
         </div>
      <?php     }//foreach search result ?>
 
      <?php
      $hostname_conDBASE = "localhost";
      $database_conDBASE = "track";
      $username_conDBASE = "root";
      $password_conDBASE = "";
 
      $conDBASE = mysql_pconnect($hostname_conDBASE, $username_conDBASE, $password_conDBASE) or trigger_error(mysql_error(),E_USER_ERROR); 
 
 
      if (!function_exists("GetSQLValueString")) {
function GetSQLValueString($theValue, $theType, $theDefinedValue = "", $theNotDefinedValue = "") 
{
  if (PHP_VERSION < 6) {
    $theValue = get_magic_quotes_gpc() ? stripslashes($theValue) : $theValue;
  }
 
  $theValue = function_exists("mysql_real_escape_string") ? mysql_real_escape_string($theValue) : mysql_escape_string($theValue);
 
  switch ($theType) {
    case "text":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;    
    case "long":
    case "int":
      $theValue = ($theValue != "") ? intval($theValue) : "NULL";
      break;
    case "double":
      $theValue = ($theValue != "") ? doubleval($theValue) : "NULL";
      break;
    case "date":
      $theValue = ($theValue != "") ? "'" . $theValue . "'" : "NULL";
      break;
    case "defined":
      $theValue = ($theValue != "") ? $theDefinedValue : $theNotDefinedValue;
      break;
  }
  return $theValue;
}
}
      $colname_simple = "-1";
      if (isset($_GET['query'])) {
      $colname_simple = $_GET['query'];
      }
      mysql_select_db($database_conDBASE, $conDBASE);
      $query_simple = sprintf("SELECT * FROM users WHERE user_fullname LIKE %s", GetSQLValueString("%" . $colname_simple . "%", "text"));
      $simple = mysql_query($query_simple, $conDBASE) or die(mysql_error());
      $row_simple = mysql_fetch_assoc($simple);
      $totalRows_simple = mysql_num_rows($simple);
 
      ?>
 
      <table border="0" cellpadding="4" cellspacing="0">
  <tr>
    <td>user_name</td>
    <td>user_fullname</td>
  </tr>
  <?php do { ?>
    <tr>
      <td><?php echo $row_simple['user_name']; ?></td>
      <td><?php echo $row_simple['user_fullname']; ?></td>
    </tr>
    <?php } while ($row_simple = mysql_fetch_assoc($simple)); ?>
</table>
 
<?php
mysql_free_result($simple);
?>
      </div>
 
      <?php 
      if($paginator && strlen($paginator->getPages())>0){ ?>   
      <div class="ccm-pagination">   
          <span class="ccm-page-left"><?php echo $paginator->getPrevious()?></span>
          <?php echo $paginator->getPages()?>
          <span class="ccm-page-right"><?php echo $paginator->getNext()?></span>
      </div>   
      <?php  } ?>
 
   <?php             
   } //results found
} 
?>
 
</form>