1010  * zone_count

  1011  * Does a select query to count how many zones we have in the database

  1012  *

  1013  * @todo: see whether or not it is possible to add the records

  1014  * @param $userid integer The userid of the current user

  1015  * @return integer the number of zones

  1016  */

  1017 

  1018 function zone_count($userid=true, $letterstart=all) {

  1019         global $db;

  1020         if((!level(5) || !$userid) && !level(10) && !level(5))

  1021         {

  1022                 $add = " AND zones.owner=".$_SESSION["userid"];

  1023         }

  1024         else

  1025         {

  1026                 $add = "";

  1027         }

  1028 

  1029         if ($letterstart!=all && $letterstart!=1) {

  1030            $add .=" AND domains.name LIKE '".$letterstart."%' ";

  1031         } elseif ($letterstart==1) {

  1032            $add .=" AND substring(domains.name,1,1) REGEXP '^[[:digit:]]'";

  1033         }

  1034 

  1035         $query = 'SELECT count(distinct zones.domain_id) as zone_count FROM zones, domains WHERE zones.domain_id = domains.id '.$add;

  1036         $numRows = $db->queryOne($query);

  1037         return $numRows;

  1038 }

  1039 

  1040 /*