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	<?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	?>