php_library/fboprime/dbx.inc

<?php
//$Header: /hl/cvsroots/gpl01/gpl01/webprojs/fboprime/sw/phplib/dbx.inc,v 1.3 2006/07/16 01:56:55 dashley Exp $
//--------------------------------------------------------------------------------------------------------------
//dbx.inc--FboPrime Database Functions Not Required in the Day View Scheduler
//Copyright (C) 2006  David T. Ashley
//
//This program is free software; you can redistribute it and/or
//modify it under the terms of the GNU General Public License
//as published by the Free Software Foundation; either version 2
//of the License, or (at your option) any later version.
//
//This program is distributed in the hope that it will be useful,
//but WITHOUT ANY WARRANTY; without even the implied warranty of
//MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
//GNU General Public License for more details.
//
//You should have received a copy of the GNU General Public License
//along with this program; if not, write to the Free Software
//Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA  02110-1301, USA.
//********************************************************************************
//This contains constants and functions used to operate on the MySQL database
//as a whole.
//--------------------------------------------------------------------------------------------------------------
require_once("db.inc");
require_once("usrs.inc");
//
//--------------------------------------------------------------------------------------------------------------
//Gathers the group of database statistics necessary for the statistics page.  The database is
//locked for the operation to ensure consistency of the results returned.
//
//An associative array is returned with the following elements (all integers).
//    loge                       : Number of elements in loge table.
//    logemaxidx                 : Maximum index from the loge table.
//    resv                       : Number of elements in resv table.
//    rscs                       : Number of elements in resources table.
//    sess                       : Number of elements in sess table.
//    usrs                       : Number of elements in usrs table.
//    usrsactive                 : Active users.
//    usrsinactive               : Inactive users.
//    usrsmale                   : Male users, both active and inactive.
//    usrsfemale                 : Female users, both active and inactive.
//    usrssexunspecifed          : Users with gender unspecified.
//    usrsmaleactive             : Male users, active.
//    usrsmaleinactive           : Male users, inactive.
//    usrsfemaleactive           : Female users, active.
//    usrsfemaleinactive         : Female users, inactive.
//    usrssexunspecifiedactive   : Users with gender unspecified, active.
//    usrssexunspecifiedinactive : Users with gender unspecified, inactive.
//
function DB_stats_statspage_01()
   {
   global $GLOBAL_dblocked;
   global $GLOBAL_dbhandle;

   //Lock the database to ensure consistent snapshot statistics.
   $db_was_locked = $GLOBAL_dblocked;
   if (! $GLOBAL_dblocked)
      {
      DB_db_lock();
      $GLOBAL_dblocked = TRUE;
      }

   //-----------------------------------------------
   //loge
   //
   $query_string = "SELECT COUNT(*) FROM loge";

   $result = mysql_query($query_string, $GLOBAL_dbhandle);

   if ($result === FALSE)
      {
      //Unknown query failure.  Return 0.
      $rv["loge"] = 0;
      }
   else
      {
      if (mysql_num_rows($result) > 0)
         {
         $row = mysql_fetch_array($result, MYSQL_NUM);
         $rv["loge"] = $row[0];
         }
      else
         {
         //Unexplained why this query would return no rows.
         $rv["loge"] = 0;
         }

      mysql_free_result($result);
      }

   //-----------------------------------------------
   //logemaxidx
   //
   $query_string = "SELECT MAX(idx) FROM loge";

   $result = mysql_query($query_string, $GLOBAL_dbhandle);

   if ($result === FALSE)
      {
      //Unknown query failure.  Return 0.
      $rv["logemaxidx"] = 0;
      }
   else
      {
      if (mysql_num_rows($result) > 0)
         {
         $row = mysql_fetch_array($result, MYSQL_NUM);
         $rv["logemaxidx"] = $row[0];
         }
      else
         {
         //Unexplained why this query would return no rows.
         $rv["logemaxidx"] = 0;
         }

      mysql_free_result($result);
      }

   //-----------------------------------------------
   //resv
   //
   $query_string = "SELECT COUNT(*) FROM resv";

   $result = mysql_query($query_string, $GLOBAL_dbhandle);

   if ($result === FALSE)
      {
      //Unknown query failure.  Return 0.
      $rv["resv"] = 0;
      }
   else
      {
      if (mysql_num_rows($result) > 0)
         {
         $row = mysql_fetch_array($result, MYSQL_NUM);
         $rv["resv"] = $row[0];
         }
      else
         {
         //Unexplained why this query would return no rows.
         $rv["resv"] = 0;
         }

      mysql_free_result($result);
      }

   //-----------------------------------------------
   //rscs
   //
   $query_string = "SELECT COUNT(*) FROM rscs";

   $result = mysql_query($query_string, $GLOBAL_dbhandle);

   if ($result === FALSE)
      {
      //Unknown query failure.  Return 0.
      $rv["rscs"] = 0;
      }
   else
      {
      if (mysql_num_rows($result) > 0)
         {
         $row = mysql_fetch_array($result, MYSQL_NUM);
         $rv["rscs"] = $row[0];
         }
      else
         {
         //Unexplained why this query would return no rows.
         $rv["rscs"] = 0;
         }

      mysql_free_result($result);
      }

   //-----------------------------------------------
   //sess
   //
   $query_string = "SELECT COUNT(*) FROM sess";

   $result = mysql_query($query_string, $GLOBAL_dbhandle);

   if ($result === FALSE)
      {
      //Unknown query failure.  Return 0.
      $rv["sess"] = 0;
      }
   else
      {
      if (mysql_num_rows($result) > 0)
         {
         $row = mysql_fetch_array($result, MYSQL_NUM);
         $rv["sess"] = $row[0];
         }
      else
         {
         //Unexplained why this query would return no rows.
         $rv["sess"] = 0;
         }

      mysql_free_result($result);
      }

   //-----------------------------------------------
   //usrs
   //
   $query_string = "SELECT COUNT(*) FROM usrs";

   $result = mysql_query($query_string, $GLOBAL_dbhandle);

   if ($result === FALSE)
      {
      //Unknown query failure.  Return 0.
      $rv["usrs"] = 0;
      }
   else
      {
      if (mysql_num_rows($result) > 0)
         {
         $row = mysql_fetch_array($result, MYSQL_NUM);
         $rv["usrs"] = $row[0];
         }
      else
         {
         //Unexplained why this query would return no rows.
         $rv["usrs"] = 0;
         }

      mysql_free_result($result);
      }

   //-----------------------------------------------
   //usrsactive
   //
   $query_string = "SELECT COUNT(*) FROM usrs WHERE status=\"" . (string)USRS_STATUS_ACTIVE  . "\"";

   $result = mysql_query($query_string, $GLOBAL_dbhandle);

   if ($result === FALSE)
      {
      //Unknown query failure.  Return 0.
      $rv["usrsactive"] = 0;
      }
   else
      {
      if (mysql_num_rows($result) > 0)
         {
         $row = mysql_fetch_array($result, MYSQL_NUM);
         $rv["usrsactive"] = $row[0];
         }
      else
         {
         //Unexplained why this query would return no rows.
         $rv["usrsactive"] = 0;
         }

      mysql_free_result($result);
      }

   //-----------------------------------------------
   //usrsinactive
   //
   $query_string = "SELECT COUNT(*) FROM usrs WHERE status=\"" . (string)USRS_STATUS_INACTIVE  . "\"";

   $result = mysql_query($query_string, $GLOBAL_dbhandle);

   if ($result === FALSE)
      {
      //Unknown query failure.  Return 0.
      $rv["usrsinactive"] = 0;
      }
   else
      {
      if (mysql_num_rows($result) > 0)
         {
         $row = mysql_fetch_array($result, MYSQL_NUM);
         $rv["usrsinactive"] = $row[0];
         }
      else
         {
         //Unexplained why this query would return no rows.
         $rv["usrsinactive"] = 0;
         }

      mysql_free_result($result);
      }

   //-----------------------------------------------
   //usrsmale
   //
   $query_string = "SELECT COUNT(*) FROM usrs WHERE sex=\"" . (string)USRS_SEX_MALE  . "\"";

   $result = mysql_query($query_string, $GLOBAL_dbhandle);

   if ($result === FALSE)
      {
      //Unknown query failure.  Return 0.
      $rv["usrsmale"] = 0;
      }
   else
      {
      if (mysql_num_rows($result) > 0)
         {
         $row = mysql_fetch_array($result, MYSQL_NUM);
         $rv["usrsmale"] = $row[0];
         }
      else
         {
         //Unexplained why this query would return no rows.
         $rv["usrsmale"] = 0;
         }

      mysql_free_result($result);
      }

   //-----------------------------------------------
   //usrsfemale
   //
   $query_string = "SELECT COUNT(*) FROM usrs WHERE sex=\"" . (string)USRS_SEX_FEMALE  . "\"";

   $result = mysql_query($query_string, $GLOBAL_dbhandle);

   if ($result === FALSE)
      {
      //Unknown query failure.  Return 0.
      $rv["usrsfemale"] = 0;
      }
   else
      {
      if (mysql_num_rows($result) > 0)
         {
         $row = mysql_fetch_array($result, MYSQL_NUM);
         $rv["usrsfemale"] = $row[0];
         }
      else
         {
         //Unexplained why this query would return no rows.
         $rv["usrsfemale"] = 0;
         }

      mysql_free_result($result);
      }

   //-----------------------------------------------
   //usrssexunspecified
   //
   $query_string = "SELECT COUNT(*) FROM usrs WHERE sex=\"" . (string)USRS_SEX_UNSPECIFIED  . "\"";

   $result = mysql_query($query_string, $GLOBAL_dbhandle);

   if ($result === FALSE)
      {
      //Unknown query failure.  Return 0.
      $rv["usrssecunspecified"] = 0;
      }
   else
      {
      if (mysql_num_rows($result) > 0)
         {
         $row = mysql_fetch_array($result, MYSQL_NUM);
         $rv["usrssexunspecified"] = $row[0];
         }
      else
         {
         //Unexplained why this query would return no rows.
         $rv["usrssexunspecified"] = 0;
         }

      mysql_free_result($result);
      }

   //-----------------------------------------------
   //usrsmaleactive
   //
   $query_string = "SELECT COUNT(*) FROM usrs WHERE sex=\"" . (string)USRS_SEX_MALE  
                   . "\" AND status=\"" . (string)USRS_STATUS_ACTIVE . "\"";

   $result = mysql_query($query_string, $GLOBAL_dbhandle);

   if ($result === FALSE)
      {
      //Unknown query failure.  Return 0.
      $rv["usrsmaleactive"] = 0;
      }
   else
      {
      if (mysql_num_rows($result) > 0)
         {
         $row = mysql_fetch_array($result, MYSQL_NUM);
         $rv["usrsmaleactive"] = $row[0];
         }
      else
         {
         //Unexplained why this query would return no rows.
         $rv["usrsmaleactive"] = 0;
         }

      mysql_free_result($result);
      }

   //-----------------------------------------------
   //usrsfemaleactive
   //
   $query_string = "SELECT COUNT(*) FROM usrs WHERE sex=\"" . (string)USRS_SEX_FEMALE  
                   . "\" AND status=\"" . (string)USRS_STATUS_ACTIVE . "\"";

   $result = mysql_query($query_string, $GLOBAL_dbhandle);

   if ($result === FALSE)
      {
      //Unknown query failure.  Return 0.
      $rv["usrsfemaleactive"] = 0;
      }
   else
      {
      if (mysql_num_rows($result) > 0)
         {
         $row = mysql_fetch_array($result, MYSQL_NUM);
         $rv["usrsfemaleactive"] = $row[0];
         }
      else
         {
         //Unexplained why this query would return no rows.
         $rv["usrsfemaleactive"] = 0;
         }

      mysql_free_result($result);
      }

   //-----------------------------------------------
   //usrssexunspecifiedactive
   //
   $query_string = "SELECT COUNT(*) FROM usrs WHERE sex=\"" . (string)USRS_SEX_UNSPECIFIED  
                   . "\" AND status=\"" . (string)USRS_STATUS_ACTIVE . "\"";

   $result = mysql_query($query_string, $GLOBAL_dbhandle);

   if ($result === FALSE)
      {
      //Unknown query failure.  Return 0.
      $rv["usrssexunspecifiedactive"] = 0;
      }
   else
      {
      if (mysql_num_rows($result) > 0)
         {
         $row = mysql_fetch_array($result, MYSQL_NUM);
         $rv["usrssexunspecifiedactive"] = $row[0];
         }
      else
         {
         //Unexplained why this query would return no rows.
         $rv["usrssexunspecifiedactive"] = 0;
         }

      mysql_free_result($result);
      }

   //-----------------------------------------------
   //usrsmaleinactive
   //
   $query_string = "SELECT COUNT(*) FROM usrs WHERE sex=\"" . (string)USRS_SEX_MALE  
                   . "\" AND status=\"" . (string)USRS_STATUS_INACTIVE . "\"";

   $result = mysql_query($query_string, $GLOBAL_dbhandle);

   if ($result === FALSE)
      {
      //Unknown query failure.  Return 0.
      $rv["usrsmaleinactive"] = 0;
      }
   else
      {
      if (mysql_num_rows($result) > 0)
         {
         $row = mysql_fetch_array($result, MYSQL_NUM);
         $rv["usrsmaleinactive"] = $row[0];
         }
      else
         {
         //Unexplained why this query would return no rows.
         $rv["usrsmaleinactive"] = 0;
         }

      mysql_free_result($result);
      }

   //-----------------------------------------------
   //usrsfemaleinactive
   //
   $query_string = "SELECT COUNT(*) FROM usrs WHERE sex=\"" . (string)USRS_SEX_FEMALE  
                   . "\" AND status=\"" . (string)USRS_STATUS_INACTIVE . "\"";

   $result = mysql_query($query_string, $GLOBAL_dbhandle);

   if ($result === FALSE)
      {
      //Unknown query failure.  Return 0.
      $rv["usrsfemaleinactive"] = 0;
      }
   else
      {
      if (mysql_num_rows($result) > 0)
         {
         $row = mysql_fetch_array($result, MYSQL_NUM);
         $rv["usrsfemaleinactive"] = $row[0];
         }
      else
         {
         //Unexplained why this query would return no rows.
         $rv["usrsfemaleinactive"] = 0;
         }

      mysql_free_result($result);
      }

   //-----------------------------------------------
   //usrssexunspecifiedinactive
   //
   $query_string = "SELECT COUNT(*) FROM usrs WHERE sex=\"" . (string)USRS_SEX_UNSPECIFIED  
                   . "\" AND status=\"" . (string)USRS_STATUS_INACTIVE . "\"";

   $result = mysql_query($query_string, $GLOBAL_dbhandle);

   if ($result === FALSE)
      {
      //Unknown query failure.  Return 0.
      $rv["usrssexunspecifiedinactive"] = 0;
      }
   else
      {
      if (mysql_num_rows($result) > 0)
         {
         $row = mysql_fetch_array($result, MYSQL_NUM);
         $rv["usrssexunspecifiedinactive"] = $row[0];
         }
      else
         {
         //Unexplained why this query would return no rows.
         $rv["usrssexunspecifiedinactive"] = 0;
         }

      mysql_free_result($result);
      }

   //-----------------------------------------------
   //Unlock the database.
   //
   if (! $db_was_locked)
      {
      DB_db_unlock();
      $GLOBAL_dblocked = FALSE;
      }

   //Return the return value.
   return($rv);
   }
//--------------------------------------------------------------------------------------------------------------
//Parses an input argument to be sure it is a suitable short index for a table.  "zna" = Zero is not allowed.
//  This means it must be either:
//  a)A positive integer.
//  b)A string representing a positive integer <= (2^32 - 1).
//
//Returns TRUE if valid or FALSE if not.
//
function DB_table_index_short_validity_check_zna($idx_in)
   {
   if (is_int($idx_in))
      {
      if ($idx_in > 0)
         {
         return(TRUE);
         }
      else
         {
         return(FALSE);
         }
      }
   else if (is_string($idx_in))
      {
      $temp = intval($idx_in);

      if ($temp === FALSE)
         {
         return(FALSE);
         }
      else if ($temp > 0)
         {
         return(TRUE);
         }
      else
         {
         return(FALSE);
         }
      }
   else
      {
      //Unknown type.
      return(FALSE);
      }
   }
//--------------------------------------------------------------------------------------------------------------
//End of $RCSfile: dbx.inc,v $.
//--------------------------------------------------------------------------------------------------------------
?>
1	dashley	35	<?php
2			//$Header: /hl/cvsroots/gpl01/gpl01/webprojs/fboprime/sw/phplib/dbx.inc,v 1.3 2006/07/16 01:56:55 dashley Exp $
3			//--------------------------------------------------------------------------------------------------------------
4			//dbx.inc--FboPrime Database Functions Not Required in the Day View Scheduler
5			//Copyright (C) 2006 David T. Ashley
6			//
7			//This program is free software; you can redistribute it and/or
8			//modify it under the terms of the GNU General Public License
9			//as published by the Free Software Foundation; either version 2
10			//of the License, or (at your option) any later version.
11			//
12			//This program is distributed in the hope that it will be useful,
13			//but WITHOUT ANY WARRANTY; without even the implied warranty of
14			//MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
15			//GNU General Public License for more details.
16			//
17			//You should have received a copy of the GNU General Public License
18			//along with this program; if not, write to the Free Software
19			//Foundation, Inc., 51 Franklin Street, Fifth Floor, Boston, MA 02110-1301, USA.
20			//********************************************************************************
21			//This contains constants and functions used to operate on the MySQL database
22			//as a whole.
23			//--------------------------------------------------------------------------------------------------------------
24			require_once("db.inc");
25			require_once("usrs.inc");
26			//
27			//--------------------------------------------------------------------------------------------------------------
28			//Gathers the group of database statistics necessary for the statistics page. The database is
29			//locked for the operation to ensure consistency of the results returned.
30			//
31			//An associative array is returned with the following elements (all integers).
32			// loge : Number of elements in loge table.
33			// logemaxidx : Maximum index from the loge table.
34			// resv : Number of elements in resv table.
35			// rscs : Number of elements in resources table.
36			// sess : Number of elements in sess table.
37			// usrs : Number of elements in usrs table.
38			// usrsactive : Active users.
39			// usrsinactive : Inactive users.
40			// usrsmale : Male users, both active and inactive.
41			// usrsfemale : Female users, both active and inactive.
42			// usrssexunspecifed : Users with gender unspecified.
43			// usrsmaleactive : Male users, active.
44			// usrsmaleinactive : Male users, inactive.
45			// usrsfemaleactive : Female users, active.
46			// usrsfemaleinactive : Female users, inactive.
47			// usrssexunspecifiedactive : Users with gender unspecified, active.
48			// usrssexunspecifiedinactive : Users with gender unspecified, inactive.
49			//
50			function DB_stats_statspage_01()
51			{
52			global $GLOBAL_dblocked;
53			global $GLOBAL_dbhandle;
54
55			//Lock the database to ensure consistent snapshot statistics.
56			$db_was_locked = $GLOBAL_dblocked;
57			if (! $GLOBAL_dblocked)
58			{
59			DB_db_lock();
60			$GLOBAL_dblocked = TRUE;
61			}
62
63			//-----------------------------------------------
64			//loge
65			//
66			$query_string = "SELECT COUNT(*) FROM loge";
67
68			$result = mysql_query($query_string, $GLOBAL_dbhandle);
69
70			if ($result === FALSE)
71			{
72			//Unknown query failure. Return 0.
73			$rv["loge"] = 0;
74			}
75			else
76			{
77			if (mysql_num_rows($result) > 0)
78			{
79			$row = mysql_fetch_array($result, MYSQL_NUM);
80			$rv["loge"] = $row[0];
81			}
82			else
83			{
84			//Unexplained why this query would return no rows.
85			$rv["loge"] = 0;
86			}
87
88			mysql_free_result($result);
89			}
90
91			//-----------------------------------------------
92			//logemaxidx
93			//
94			$query_string = "SELECT MAX(idx) FROM loge";
95
96			$result = mysql_query($query_string, $GLOBAL_dbhandle);
97
98			if ($result === FALSE)
99			{
100			//Unknown query failure. Return 0.
101			$rv["logemaxidx"] = 0;
102			}
103			else
104			{
105			if (mysql_num_rows($result) > 0)
106			{
107			$row = mysql_fetch_array($result, MYSQL_NUM);
108			$rv["logemaxidx"] = $row[0];
109			}
110			else
111			{
112			//Unexplained why this query would return no rows.
113			$rv["logemaxidx"] = 0;
114			}
115
116			mysql_free_result($result);
117			}
118
119			//-----------------------------------------------
120			//resv
121			//
122			$query_string = "SELECT COUNT(*) FROM resv";
123
124			$result = mysql_query($query_string, $GLOBAL_dbhandle);
125
126			if ($result === FALSE)
127			{
128			//Unknown query failure. Return 0.
129			$rv["resv"] = 0;
130			}
131			else
132			{
133			if (mysql_num_rows($result) > 0)
134			{
135			$row = mysql_fetch_array($result, MYSQL_NUM);
136			$rv["resv"] = $row[0];
137			}
138			else
139			{
140			//Unexplained why this query would return no rows.
141			$rv["resv"] = 0;
142			}
143
144			mysql_free_result($result);
145			}
146
147			//-----------------------------------------------
148			//rscs
149			//
150			$query_string = "SELECT COUNT(*) FROM rscs";
151
152			$result = mysql_query($query_string, $GLOBAL_dbhandle);
153
154			if ($result === FALSE)
155			{
156			//Unknown query failure. Return 0.
157			$rv["rscs"] = 0;
158			}
159			else
160			{
161			if (mysql_num_rows($result) > 0)
162			{
163			$row = mysql_fetch_array($result, MYSQL_NUM);
164			$rv["rscs"] = $row[0];
165			}
166			else
167			{
168			//Unexplained why this query would return no rows.
169			$rv["rscs"] = 0;
170			}
171
172			mysql_free_result($result);
173			}
174
175			//-----------------------------------------------
176			//sess
177			//
178			$query_string = "SELECT COUNT(*) FROM sess";
179
180			$result = mysql_query($query_string, $GLOBAL_dbhandle);
181
182			if ($result === FALSE)
183			{
184			//Unknown query failure. Return 0.
185			$rv["sess"] = 0;
186			}
187			else
188			{
189			if (mysql_num_rows($result) > 0)
190			{
191			$row = mysql_fetch_array($result, MYSQL_NUM);
192			$rv["sess"] = $row[0];
193			}
194			else
195			{
196			//Unexplained why this query would return no rows.
197			$rv["sess"] = 0;
198			}
199
200			mysql_free_result($result);
201			}
202
203			//-----------------------------------------------
204			//usrs
205			//
206			$query_string = "SELECT COUNT(*) FROM usrs";
207
208			$result = mysql_query($query_string, $GLOBAL_dbhandle);
209
210			if ($result === FALSE)
211			{
212			//Unknown query failure. Return 0.
213			$rv["usrs"] = 0;
214			}
215			else
216			{
217			if (mysql_num_rows($result) > 0)
218			{
219			$row = mysql_fetch_array($result, MYSQL_NUM);
220			$rv["usrs"] = $row[0];
221			}
222			else
223			{
224			//Unexplained why this query would return no rows.
225			$rv["usrs"] = 0;
226			}
227
228			mysql_free_result($result);
229			}
230
231			//-----------------------------------------------
232			//usrsactive
233			//
234			$query_string = "SELECT COUNT(*) FROM usrs WHERE status=\"" . (string)USRS_STATUS_ACTIVE . "\"";
235
236			$result = mysql_query($query_string, $GLOBAL_dbhandle);
237
238			if ($result === FALSE)
239			{
240			//Unknown query failure. Return 0.
241			$rv["usrsactive"] = 0;
242			}
243			else
244			{
245			if (mysql_num_rows($result) > 0)
246			{
247			$row = mysql_fetch_array($result, MYSQL_NUM);
248			$rv["usrsactive"] = $row[0];
249			}
250			else
251			{
252			//Unexplained why this query would return no rows.
253			$rv["usrsactive"] = 0;
254			}
255
256			mysql_free_result($result);
257			}
258
259			//-----------------------------------------------
260			//usrsinactive
261			//
262			$query_string = "SELECT COUNT(*) FROM usrs WHERE status=\"" . (string)USRS_STATUS_INACTIVE . "\"";
263
264			$result = mysql_query($query_string, $GLOBAL_dbhandle);
265
266			if ($result === FALSE)
267			{
268			//Unknown query failure. Return 0.
269			$rv["usrsinactive"] = 0;
270			}
271			else
272			{
273			if (mysql_num_rows($result) > 0)
274			{
275			$row = mysql_fetch_array($result, MYSQL_NUM);
276			$rv["usrsinactive"] = $row[0];
277			}
278			else
279			{
280			//Unexplained why this query would return no rows.
281			$rv["usrsinactive"] = 0;
282			}
283
284			mysql_free_result($result);
285			}
286
287			//-----------------------------------------------
288			//usrsmale
289			//
290			$query_string = "SELECT COUNT(*) FROM usrs WHERE sex=\"" . (string)USRS_SEX_MALE . "\"";
291
292			$result = mysql_query($query_string, $GLOBAL_dbhandle);
293
294			if ($result === FALSE)
295			{
296			//Unknown query failure. Return 0.
297			$rv["usrsmale"] = 0;
298			}
299			else
300			{
301			if (mysql_num_rows($result) > 0)
302			{
303			$row = mysql_fetch_array($result, MYSQL_NUM);
304			$rv["usrsmale"] = $row[0];
305			}
306			else
307			{
308			//Unexplained why this query would return no rows.
309			$rv["usrsmale"] = 0;
310			}
311
312			mysql_free_result($result);
313			}
314
315			//-----------------------------------------------
316			//usrsfemale
317			//
318			$query_string = "SELECT COUNT(*) FROM usrs WHERE sex=\"" . (string)USRS_SEX_FEMALE . "\"";
319
320			$result = mysql_query($query_string, $GLOBAL_dbhandle);
321
322			if ($result === FALSE)
323			{
324			//Unknown query failure. Return 0.
325			$rv["usrsfemale"] = 0;
326			}
327			else
328			{
329			if (mysql_num_rows($result) > 0)
330			{
331			$row = mysql_fetch_array($result, MYSQL_NUM);
332			$rv["usrsfemale"] = $row[0];
333			}
334			else
335			{
336			//Unexplained why this query would return no rows.
337			$rv["usrsfemale"] = 0;
338			}
339
340			mysql_free_result($result);
341			}
342
343			//-----------------------------------------------
344			//usrssexunspecified
345			//
346			$query_string = "SELECT COUNT(*) FROM usrs WHERE sex=\"" . (string)USRS_SEX_UNSPECIFIED . "\"";
347
348			$result = mysql_query($query_string, $GLOBAL_dbhandle);
349
350			if ($result === FALSE)
351			{
352			//Unknown query failure. Return 0.
353			$rv["usrssecunspecified"] = 0;
354			}
355			else
356			{
357			if (mysql_num_rows($result) > 0)
358			{
359			$row = mysql_fetch_array($result, MYSQL_NUM);
360			$rv["usrssexunspecified"] = $row[0];
361			}
362			else
363			{
364			//Unexplained why this query would return no rows.
365			$rv["usrssexunspecified"] = 0;
366			}
367
368			mysql_free_result($result);
369			}
370
371			//-----------------------------------------------
372			//usrsmaleactive
373			//
374			$query_string = "SELECT COUNT(*) FROM usrs WHERE sex=\"" . (string)USRS_SEX_MALE
375			. "\" AND status=\"" . (string)USRS_STATUS_ACTIVE . "\"";
376
377			$result = mysql_query($query_string, $GLOBAL_dbhandle);
378
379			if ($result === FALSE)
380			{
381			//Unknown query failure. Return 0.
382			$rv["usrsmaleactive"] = 0;
383			}
384			else
385			{
386			if (mysql_num_rows($result) > 0)
387			{
388			$row = mysql_fetch_array($result, MYSQL_NUM);
389			$rv["usrsmaleactive"] = $row[0];
390			}
391			else
392			{
393			//Unexplained why this query would return no rows.
394			$rv["usrsmaleactive"] = 0;
395			}
396
397			mysql_free_result($result);
398			}
399
400			//-----------------------------------------------
401			//usrsfemaleactive
402			//
403			$query_string = "SELECT COUNT(*) FROM usrs WHERE sex=\"" . (string)USRS_SEX_FEMALE
404			. "\" AND status=\"" . (string)USRS_STATUS_ACTIVE . "\"";
405
406			$result = mysql_query($query_string, $GLOBAL_dbhandle);
407
408			if ($result === FALSE)
409			{
410			//Unknown query failure. Return 0.
411			$rv["usrsfemaleactive"] = 0;
412			}
413			else
414			{
415			if (mysql_num_rows($result) > 0)
416			{
417			$row = mysql_fetch_array($result, MYSQL_NUM);
418			$rv["usrsfemaleactive"] = $row[0];
419			}
420			else
421			{
422			//Unexplained why this query would return no rows.
423			$rv["usrsfemaleactive"] = 0;
424			}
425
426			mysql_free_result($result);
427			}
428
429			//-----------------------------------------------
430			//usrssexunspecifiedactive
431			//
432			$query_string = "SELECT COUNT(*) FROM usrs WHERE sex=\"" . (string)USRS_SEX_UNSPECIFIED
433			. "\" AND status=\"" . (string)USRS_STATUS_ACTIVE . "\"";
434
435			$result = mysql_query($query_string, $GLOBAL_dbhandle);
436
437			if ($result === FALSE)
438			{
439			//Unknown query failure. Return 0.
440			$rv["usrssexunspecifiedactive"] = 0;
441			}
442			else
443			{
444			if (mysql_num_rows($result) > 0)
445			{
446			$row = mysql_fetch_array($result, MYSQL_NUM);
447			$rv["usrssexunspecifiedactive"] = $row[0];
448			}
449			else
450			{
451			//Unexplained why this query would return no rows.
452			$rv["usrssexunspecifiedactive"] = 0;
453			}
454
455			mysql_free_result($result);
456			}
457
458			//-----------------------------------------------
459			//usrsmaleinactive
460			//
461			$query_string = "SELECT COUNT(*) FROM usrs WHERE sex=\"" . (string)USRS_SEX_MALE
462			. "\" AND status=\"" . (string)USRS_STATUS_INACTIVE . "\"";
463
464			$result = mysql_query($query_string, $GLOBAL_dbhandle);
465
466			if ($result === FALSE)
467			{
468			//Unknown query failure. Return 0.
469			$rv["usrsmaleinactive"] = 0;
470			}
471			else
472			{
473			if (mysql_num_rows($result) > 0)
474			{
475			$row = mysql_fetch_array($result, MYSQL_NUM);
476			$rv["usrsmaleinactive"] = $row[0];
477			}
478			else
479			{
480			//Unexplained why this query would return no rows.
481			$rv["usrsmaleinactive"] = 0;
482			}
483
484			mysql_free_result($result);
485			}
486
487			//-----------------------------------------------
488			//usrsfemaleinactive
489			//
490			$query_string = "SELECT COUNT(*) FROM usrs WHERE sex=\"" . (string)USRS_SEX_FEMALE
491			. "\" AND status=\"" . (string)USRS_STATUS_INACTIVE . "\"";
492
493			$result = mysql_query($query_string, $GLOBAL_dbhandle);
494
495			if ($result === FALSE)
496			{
497			//Unknown query failure. Return 0.
498			$rv["usrsfemaleinactive"] = 0;
499			}
500			else
501			{
502			if (mysql_num_rows($result) > 0)
503			{
504			$row = mysql_fetch_array($result, MYSQL_NUM);
505			$rv["usrsfemaleinactive"] = $row[0];
506			}
507			else
508			{
509			//Unexplained why this query would return no rows.
510			$rv["usrsfemaleinactive"] = 0;
511			}
512
513			mysql_free_result($result);
514			}
515
516			//-----------------------------------------------
517			//usrssexunspecifiedinactive
518			//
519			$query_string = "SELECT COUNT(*) FROM usrs WHERE sex=\"" . (string)USRS_SEX_UNSPECIFIED
520			. "\" AND status=\"" . (string)USRS_STATUS_INACTIVE . "\"";
521
522			$result = mysql_query($query_string, $GLOBAL_dbhandle);
523
524			if ($result === FALSE)
525			{
526			//Unknown query failure. Return 0.
527			$rv["usrssexunspecifiedinactive"] = 0;
528			}
529			else
530			{
531			if (mysql_num_rows($result) > 0)
532			{
533			$row = mysql_fetch_array($result, MYSQL_NUM);
534			$rv["usrssexunspecifiedinactive"] = $row[0];
535			}
536			else
537			{
538			//Unexplained why this query would return no rows.
539			$rv["usrssexunspecifiedinactive"] = 0;
540			}
541
542			mysql_free_result($result);
543			}
544
545			//-----------------------------------------------
546			//Unlock the database.
547			//
548			if (! $db_was_locked)
549			{
550			DB_db_unlock();
551			$GLOBAL_dblocked = FALSE;
552			}
553
554			//Return the return value.
555			return($rv);
556			}
557			//--------------------------------------------------------------------------------------------------------------
558			//Parses an input argument to be sure it is a suitable short index for a table. "zna" = Zero is not allowed.
559			// This means it must be either:
560			// a)A positive integer.
561			// b)A string representing a positive integer <= (2^32 - 1).
562			//
563			//Returns TRUE if valid or FALSE if not.
564			//
565			function DB_table_index_short_validity_check_zna($idx_in)
566			{
567			if (is_int($idx_in))
568			{
569			if ($idx_in > 0)
570			{
571			return(TRUE);
572			}
573			else
574			{
575			return(FALSE);
576			}
577			}
578			else if (is_string($idx_in))
579			{
580			$temp = intval($idx_in);
581
582			if ($temp === FALSE)
583			{
584			return(FALSE);
585			}
586			else if ($temp > 0)
587			{
588			return(TRUE);
589			}
590			else
591			{
592			return(FALSE);
593			}
594			}
595			else
596			{
597			//Unknown type.
598			return(FALSE);
599			}
600			}
601			//--------------------------------------------------------------------------------------------------------------
602			//End of $RCSfile: dbx.inc,v $.
603			//--------------------------------------------------------------------------------------------------------------
604			?>