/[dtapublic]/to_be_filed/webprojs/fboprime/sw/phplib/usrsx.inc
ViewVC logotype

Contents of /to_be_filed/webprojs/fboprime/sw/phplib/usrsx.inc

Parent Directory Parent Directory | Revision Log Revision Log


Revision 31 - (show annotations) (download)
Sat Oct 8 18:44:20 2016 UTC (7 years, 5 months ago) by dashley
File size: 84122 byte(s)
Initial commit.
1 <?php
2 //$Header: /home/dashley/cvsrep/e3ft_gpl01/e3ft_gpl01/webprojs/fboprime/sw/phplib/usrsx.inc,v 1.12 2006/11/05 21:23:55 dashley Exp $
3 //--------------------------------------------------------------------------------------------------------------
4 //usrsx.inc--FboPrime Database usrs Table Manipulation Functions (Not Scheduler Critical)
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 //Copyright 2006 David T. Ashley
22 //-------------------------------------------------------------------------------------------------
23 //This source code and any program in which it is compiled/used is provided under the GNU GENERAL
24 //PUBLIC LICENSE, Version 3, full license text below.
25 //-------------------------------------------------------------------------------------------------
26 // GNU GENERAL PUBLIC LICENSE
27 // Version 3, 29 June 2007
28 //
29 // Copyright (C) 2007 Free Software Foundation, Inc. <http://fsf.org/>
30 // Everyone is permitted to copy and distribute verbatim copies
31 // of this license document, but changing it is not allowed.
32 //
33 // Preamble
34 //
35 // The GNU General Public License is a free, copyleft license for
36 //software and other kinds of works.
37 //
38 // The licenses for most software and other practical works are designed
39 //to take away your freedom to share and change the works. By contrast,
40 //the GNU General Public License is intended to guarantee your freedom to
41 //share and change all versions of a program--to make sure it remains free
42 //software for all its users. We, the Free Software Foundation, use the
43 //GNU General Public License for most of our software; it applies also to
44 //any other work released this way by its authors. You can apply it to
45 //your programs, too.
46 //
47 // When we speak of free software, we are referring to freedom, not
48 //price. Our General Public Licenses are designed to make sure that you
49 //have the freedom to distribute copies of free software (and charge for
50 //them if you wish), that you receive source code or can get it if you
51 //want it, that you can change the software or use pieces of it in new
52 //free programs, and that you know you can do these things.
53 //
54 // To protect your rights, we need to prevent others from denying you
55 //these rights or asking you to surrender the rights. Therefore, you have
56 //certain responsibilities if you distribute copies of the software, or if
57 //you modify it: responsibilities to respect the freedom of others.
58 //
59 // For example, if you distribute copies of such a program, whether
60 //gratis or for a fee, you must pass on to the recipients the same
61 //freedoms that you received. You must make sure that they, too, receive
62 //or can get the source code. And you must show them these terms so they
63 //know their rights.
64 //
65 // Developers that use the GNU GPL protect your rights with two steps:
66 //(1) assert copyright on the software, and (2) offer you this License
67 //giving you legal permission to copy, distribute and/or modify it.
68 //
69 // For the developers' and authors' protection, the GPL clearly explains
70 //that there is no warranty for this free software. For both users' and
71 //authors' sake, the GPL requires that modified versions be marked as
72 //changed, so that their problems will not be attributed erroneously to
73 //authors of previous versions.
74 //
75 // Some devices are designed to deny users access to install or run
76 //modified versions of the software inside them, although the manufacturer
77 //can do so. This is fundamentally incompatible with the aim of
78 //protecting users' freedom to change the software. The systematic
79 //pattern of such abuse occurs in the area of products for individuals to
80 //use, which is precisely where it is most unacceptable. Therefore, we
81 //have designed this version of the GPL to prohibit the practice for those
82 //products. If such problems arise substantially in other domains, we
83 //stand ready to extend this provision to those domains in future versions
84 //of the GPL, as needed to protect the freedom of users.
85 //
86 // Finally, every program is threatened constantly by software patents.
87 //States should not allow patents to restrict development and use of
88 //software on general-purpose computers, but in those that do, we wish to
89 //avoid the special danger that patents applied to a free program could
90 //make it effectively proprietary. To prevent this, the GPL assures that
91 //patents cannot be used to render the program non-free.
92 //
93 // The precise terms and conditions for copying, distribution and
94 //modification follow.
95 //
96 // TERMS AND CONDITIONS
97 //
98 // 0. Definitions.
99 //
100 // "This License" refers to version 3 of the GNU General Public License.
101 //
102 // "Copyright" also means copyright-like laws that apply to other kinds of
103 //works, such as semiconductor masks.
104 //
105 // "The Program" refers to any copyrightable work licensed under this
106 //License. Each licensee is addressed as "you". "Licensees" and
107 //"recipients" may be individuals or organizations.
108 //
109 // To "modify" a work means to copy from or adapt all or part of the work
110 //in a fashion requiring copyright permission, other than the making of an
111 //exact copy. The resulting work is called a "modified version" of the
112 //earlier work or a work "based on" the earlier work.
113 //
114 // A "covered work" means either the unmodified Program or a work based
115 //on the Program.
116 //
117 // To "propagate" a work means to do anything with it that, without
118 //permission, would make you directly or secondarily liable for
119 //infringement under applicable copyright law, except executing it on a
120 //computer or modifying a private copy. Propagation includes copying,
121 //distribution (with or without modification), making available to the
122 //public, and in some countries other activities as well.
123 //
124 // To "convey" a work means any kind of propagation that enables other
125 //parties to make or receive copies. Mere interaction with a user through
126 //a computer network, with no transfer of a copy, is not conveying.
127 //
128 // An interactive user interface displays "Appropriate Legal Notices"
129 //to the extent that it includes a convenient and prominently visible
130 //feature that (1) displays an appropriate copyright notice, and (2)
131 //tells the user that there is no warranty for the work (except to the
132 //extent that warranties are provided), that licensees may convey the
133 //work under this License, and how to view a copy of this License. If
134 //the interface presents a list of user commands or options, such as a
135 //menu, a prominent item in the list meets this criterion.
136 //
137 // 1. Source Code.
138 //
139 // The "source code" for a work means the preferred form of the work
140 //for making modifications to it. "Object code" means any non-source
141 //form of a work.
142 //
143 // A "Standard Interface" means an interface that either is an official
144 //standard defined by a recognized standards body, or, in the case of
145 //interfaces specified for a particular programming language, one that
146 //is widely used among developers working in that language.
147 //
148 // The "System Libraries" of an executable work include anything, other
149 //than the work as a whole, that (a) is included in the normal form of
150 //packaging a Major Component, but which is not part of that Major
151 //Component, and (b) serves only to enable use of the work with that
152 //Major Component, or to implement a Standard Interface for which an
153 //implementation is available to the public in source code form. A
154 //"Major Component", in this context, means a major essential component
155 //(kernel, window system, and so on) of the specific operating system
156 //(if any) on which the executable work runs, or a compiler used to
157 //produce the work, or an object code interpreter used to run it.
158 //
159 // The "Corresponding Source" for a work in object code form means all
160 //the source code needed to generate, install, and (for an executable
161 //work) run the object code and to modify the work, including scripts to
162 //control those activities. However, it does not include the work's
163 //System Libraries, or general-purpose tools or generally available free
164 //programs which are used unmodified in performing those activities but
165 //which are not part of the work. For example, Corresponding Source
166 //includes interface definition files associated with source files for
167 //the work, and the source code for shared libraries and dynamically
168 //linked subprograms that the work is specifically designed to require,
169 //such as by intimate data communication or control flow between those
170 //subprograms and other parts of the work.
171 //
172 // The Corresponding Source need not include anything that users
173 //can regenerate automatically from other parts of the Corresponding
174 //Source.
175 //
176 // The Corresponding Source for a work in source code form is that
177 //same work.
178 //
179 // 2. Basic Permissions.
180 //
181 // All rights granted under this License are granted for the term of
182 //copyright on the Program, and are irrevocable provided the stated
183 //conditions are met. This License explicitly affirms your unlimited
184 //permission to run the unmodified Program. The output from running a
185 //covered work is covered by this License only if the output, given its
186 //content, constitutes a covered work. This License acknowledges your
187 //rights of fair use or other equivalent, as provided by copyright law.
188 //
189 // You may make, run and propagate covered works that you do not
190 //convey, without conditions so long as your license otherwise remains
191 //in force. You may convey covered works to others for the sole purpose
192 //of having them make modifications exclusively for you, or provide you
193 //with facilities for running those works, provided that you comply with
194 //the terms of this License in conveying all material for which you do
195 //not control copyright. Those thus making or running the covered works
196 //for you must do so exclusively on your behalf, under your direction
197 //and control, on terms that prohibit them from making any copies of
198 //your copyrighted material outside their relationship with you.
199 //
200 // Conveying under any other circumstances is permitted solely under
201 //the conditions stated below. Sublicensing is not allowed; section 10
202 //makes it unnecessary.
203 //
204 // 3. Protecting Users' Legal Rights From Anti-Circumvention Law.
205 //
206 // No covered work shall be deemed part of an effective technological
207 //measure under any applicable law fulfilling obligations under article
208 //11 of the WIPO copyright treaty adopted on 20 December 1996, or
209 //similar laws prohibiting or restricting circumvention of such
210 //measures.
211 //
212 // When you convey a covered work, you waive any legal power to forbid
213 //circumvention of technological measures to the extent such circumvention
214 //is effected by exercising rights under this License with respect to
215 //the covered work, and you disclaim any intention to limit operation or
216 //modification of the work as a means of enforcing, against the work's
217 //users, your or third parties' legal rights to forbid circumvention of
218 //technological measures.
219 //
220 // 4. Conveying Verbatim Copies.
221 //
222 // You may convey verbatim copies of the Program's source code as you
223 //receive it, in any medium, provided that you conspicuously and
224 //appropriately publish on each copy an appropriate copyright notice;
225 //keep intact all notices stating that this License and any
226 //non-permissive terms added in accord with section 7 apply to the code;
227 //keep intact all notices of the absence of any warranty; and give all
228 //recipients a copy of this License along with the Program.
229 //
230 // You may charge any price or no price for each copy that you convey,
231 //and you may offer support or warranty protection for a fee.
232 //
233 // 5. Conveying Modified Source Versions.
234 //
235 // You may convey a work based on the Program, or the modifications to
236 //produce it from the Program, in the form of source code under the
237 //terms of section 4, provided that you also meet all of these conditions:
238 //
239 // a) The work must carry prominent notices stating that you modified
240 // it, and giving a relevant date.
241 //
242 // b) The work must carry prominent notices stating that it is
243 // released under this License and any conditions added under section
244 // 7. This requirement modifies the requirement in section 4 to
245 // "keep intact all notices".
246 //
247 // c) You must license the entire work, as a whole, under this
248 // License to anyone who comes into possession of a copy. This
249 // License will therefore apply, along with any applicable section 7
250 // additional terms, to the whole of the work, and all its parts,
251 // regardless of how they are packaged. This License gives no
252 // permission to license the work in any other way, but it does not
253 // invalidate such permission if you have separately received it.
254 //
255 // d) If the work has interactive user interfaces, each must display
256 // Appropriate Legal Notices; however, if the Program has interactive
257 // interfaces that do not display Appropriate Legal Notices, your
258 // work need not make them do so.
259 //
260 // A compilation of a covered work with other separate and independent
261 //works, which are not by their nature extensions of the covered work,
262 //and which are not combined with it such as to form a larger program,
263 //in or on a volume of a storage or distribution medium, is called an
264 //"aggregate" if the compilation and its resulting copyright are not
265 //used to limit the access or legal rights of the compilation's users
266 //beyond what the individual works permit. Inclusion of a covered work
267 //in an aggregate does not cause this License to apply to the other
268 //parts of the aggregate.
269 //
270 // 6. Conveying Non-Source Forms.
271 //
272 // You may convey a covered work in object code form under the terms
273 //of sections 4 and 5, provided that you also convey the
274 //machine-readable Corresponding Source under the terms of this License,
275 //in one of these ways:
276 //
277 // a) Convey the object code in, or embodied in, a physical product
278 // (including a physical distribution medium), accompanied by the
279 // Corresponding Source fixed on a durable physical medium
280 // customarily used for software interchange.
281 //
282 // b) Convey the object code in, or embodied in, a physical product
283 // (including a physical distribution medium), accompanied by a
284 // written offer, valid for at least three years and valid for as
285 // long as you offer spare parts or customer support for that product
286 // model, to give anyone who possesses the object code either (1) a
287 // copy of the Corresponding Source for all the software in the
288 // product that is covered by this License, on a durable physical
289 // medium customarily used for software interchange, for a price no
290 // more than your reasonable cost of physically performing this
291 // conveying of source, or (2) access to copy the
292 // Corresponding Source from a network server at no charge.
293 //
294 // c) Convey individual copies of the object code with a copy of the
295 // written offer to provide the Corresponding Source. This
296 // alternative is allowed only occasionally and noncommercially, and
297 // only if you received the object code with such an offer, in accord
298 // with subsection 6b.
299 //
300 // d) Convey the object code by offering access from a designated
301 // place (gratis or for a charge), and offer equivalent access to the
302 // Corresponding Source in the same way through the same place at no
303 // further charge. You need not require recipients to copy the
304 // Corresponding Source along with the object code. If the place to
305 // copy the object code is a network server, the Corresponding Source
306 // may be on a different server (operated by you or a third party)
307 // that supports equivalent copying facilities, provided you maintain
308 // clear directions next to the object code saying where to find the
309 // Corresponding Source. Regardless of what server hosts the
310 // Corresponding Source, you remain obligated to ensure that it is
311 // available for as long as needed to satisfy these requirements.
312 //
313 // e) Convey the object code using peer-to-peer transmission, provided
314 // you inform other peers where the object code and Corresponding
315 // Source of the work are being offered to the general public at no
316 // charge under subsection 6d.
317 //
318 // A separable portion of the object code, whose source code is excluded
319 //from the Corresponding Source as a System Library, need not be
320 //included in conveying the object code work.
321 //
322 // A "User Product" is either (1) a "consumer product", which means any
323 //tangible personal property which is normally used for personal, family,
324 //or household purposes, or (2) anything designed or sold for incorporation
325 //into a dwelling. In determining whether a product is a consumer product,
326 //doubtful cases shall be resolved in favor of coverage. For a particular
327 //product received by a particular user, "normally used" refers to a
328 //typical or common use of that class of product, regardless of the status
329 //of the particular user or of the way in which the particular user
330 //actually uses, or expects or is expected to use, the product. A product
331 //is a consumer product regardless of whether the product has substantial
332 //commercial, industrial or non-consumer uses, unless such uses represent
333 //the only significant mode of use of the product.
334 //
335 // "Installation Information" for a User Product means any methods,
336 //procedures, authorization keys, or other information required to install
337 //and execute modified versions of a covered work in that User Product from
338 //a modified version of its Corresponding Source. The information must
339 //suffice to ensure that the continued functioning of the modified object
340 //code is in no case prevented or interfered with solely because
341 //modification has been made.
342 //
343 // If you convey an object code work under this section in, or with, or
344 //specifically for use in, a User Product, and the conveying occurs as
345 //part of a transaction in which the right of possession and use of the
346 //User Product is transferred to the recipient in perpetuity or for a
347 //fixed term (regardless of how the transaction is characterized), the
348 //Corresponding Source conveyed under this section must be accompanied
349 //by the Installation Information. But this requirement does not apply
350 //if neither you nor any third party retains the ability to install
351 //modified object code on the User Product (for example, the work has
352 //been installed in ROM).
353 //
354 // The requirement to provide Installation Information does not include a
355 //requirement to continue to provide support service, warranty, or updates
356 //for a work that has been modified or installed by the recipient, or for
357 //the User Product in which it has been modified or installed. Access to a
358 //network may be denied when the modification itself materially and
359 //adversely affects the operation of the network or violates the rules and
360 //protocols for communication across the network.
361 //
362 // Corresponding Source conveyed, and Installation Information provided,
363 //in accord with this section must be in a format that is publicly
364 //documented (and with an implementation available to the public in
365 //source code form), and must require no special password or key for
366 //unpacking, reading or copying.
367 //
368 // 7. Additional Terms.
369 //
370 // "Additional permissions" are terms that supplement the terms of this
371 //License by making exceptions from one or more of its conditions.
372 //Additional permissions that are applicable to the entire Program shall
373 //be treated as though they were included in this License, to the extent
374 //that they are valid under applicable law. If additional permissions
375 //apply only to part of the Program, that part may be used separately
376 //under those permissions, but the entire Program remains governed by
377 //this License without regard to the additional permissions.
378 //
379 // When you convey a copy of a covered work, you may at your option
380 //remove any additional permissions from that copy, or from any part of
381 //it. (Additional permissions may be written to require their own
382 //removal in certain cases when you modify the work.) You may place
383 //additional permissions on material, added by you to a covered work,
384 //for which you have or can give appropriate copyright permission.
385 //
386 // Notwithstanding any other provision of this License, for material you
387 //add to a covered work, you may (if authorized by the copyright holders of
388 //that material) supplement the terms of this License with terms:
389 //
390 // a) Disclaiming warranty or limiting liability differently from the
391 // terms of sections 15 and 16 of this License; or
392 //
393 // b) Requiring preservation of specified reasonable legal notices or
394 // author attributions in that material or in the Appropriate Legal
395 // Notices displayed by works containing it; or
396 //
397 // c) Prohibiting misrepresentation of the origin of that material, or
398 // requiring that modified versions of such material be marked in
399 // reasonable ways as different from the original version; or
400 //
401 // d) Limiting the use for publicity purposes of names of licensors or
402 // authors of the material; or
403 //
404 // e) Declining to grant rights under trademark law for use of some
405 // trade names, trademarks, or service marks; or
406 //
407 // f) Requiring indemnification of licensors and authors of that
408 // material by anyone who conveys the material (or modified versions of
409 // it) with contractual assumptions of liability to the recipient, for
410 // any liability that these contractual assumptions directly impose on
411 // those licensors and authors.
412 //
413 // All other non-permissive additional terms are considered "further
414 //restrictions" within the meaning of section 10. If the Program as you
415 //received it, or any part of it, contains a notice stating that it is
416 //governed by this License along with a term that is a further
417 //restriction, you may remove that term. If a license document contains
418 //a further restriction but permits relicensing or conveying under this
419 //License, you may add to a covered work material governed by the terms
420 //of that license document, provided that the further restriction does
421 //not survive such relicensing or conveying.
422 //
423 // If you add terms to a covered work in accord with this section, you
424 //must place, in the relevant source files, a statement of the
425 //additional terms that apply to those files, or a notice indicating
426 //where to find the applicable terms.
427 //
428 // Additional terms, permissive or non-permissive, may be stated in the
429 //form of a separately written license, or stated as exceptions;
430 //the above requirements apply either way.
431 //
432 // 8. Termination.
433 //
434 // You may not propagate or modify a covered work except as expressly
435 //provided under this License. Any attempt otherwise to propagate or
436 //modify it is void, and will automatically terminate your rights under
437 //this License (including any patent licenses granted under the third
438 //paragraph of section 11).
439 //
440 // However, if you cease all violation of this License, then your
441 //license from a particular copyright holder is reinstated (a)
442 //provisionally, unless and until the copyright holder explicitly and
443 //finally terminates your license, and (b) permanently, if the copyright
444 //holder fails to notify you of the violation by some reasonable means
445 //prior to 60 days after the cessation.
446 //
447 // Moreover, your license from a particular copyright holder is
448 //reinstated permanently if the copyright holder notifies you of the
449 //violation by some reasonable means, this is the first time you have
450 //received notice of violation of this License (for any work) from that
451 //copyright holder, and you cure the violation prior to 30 days after
452 //your receipt of the notice.
453 //
454 // Termination of your rights under this section does not terminate the
455 //licenses of parties who have received copies or rights from you under
456 //this License. If your rights have been terminated and not permanently
457 //reinstated, you do not qualify to receive new licenses for the same
458 //material under section 10.
459 //
460 // 9. Acceptance Not Required for Having Copies.
461 //
462 // You are not required to accept this License in order to receive or
463 //run a copy of the Program. Ancillary propagation of a covered work
464 //occurring solely as a consequence of using peer-to-peer transmission
465 //to receive a copy likewise does not require acceptance. However,
466 //nothing other than this License grants you permission to propagate or
467 //modify any covered work. These actions infringe copyright if you do
468 //not accept this License. Therefore, by modifying or propagating a
469 //covered work, you indicate your acceptance of this License to do so.
470 //
471 // 10. Automatic Licensing of Downstream Recipients.
472 //
473 // Each time you convey a covered work, the recipient automatically
474 //receives a license from the original licensors, to run, modify and
475 //propagate that work, subject to this License. You are not responsible
476 //for enforcing compliance by third parties with this License.
477 //
478 // An "entity transaction" is a transaction transferring control of an
479 //organization, or substantially all assets of one, or subdividing an
480 //organization, or merging organizations. If propagation of a covered
481 //work results from an entity transaction, each party to that
482 //transaction who receives a copy of the work also receives whatever
483 //licenses to the work the party's predecessor in interest had or could
484 //give under the previous paragraph, plus a right to possession of the
485 //Corresponding Source of the work from the predecessor in interest, if
486 //the predecessor has it or can get it with reasonable efforts.
487 //
488 // You may not impose any further restrictions on the exercise of the
489 //rights granted or affirmed under this License. For example, you may
490 //not impose a license fee, royalty, or other charge for exercise of
491 //rights granted under this License, and you may not initiate litigation
492 //(including a cross-claim or counterclaim in a lawsuit) alleging that
493 //any patent claim is infringed by making, using, selling, offering for
494 //sale, or importing the Program or any portion of it.
495 //
496 // 11. Patents.
497 //
498 // A "contributor" is a copyright holder who authorizes use under this
499 //License of the Program or a work on which the Program is based. The
500 //work thus licensed is called the contributor's "contributor version".
501 //
502 // A contributor's "essential patent claims" are all patent claims
503 //owned or controlled by the contributor, whether already acquired or
504 //hereafter acquired, that would be infringed by some manner, permitted
505 //by this License, of making, using, or selling its contributor version,
506 //but do not include claims that would be infringed only as a
507 //consequence of further modification of the contributor version. For
508 //purposes of this definition, "control" includes the right to grant
509 //patent sublicenses in a manner consistent with the requirements of
510 //this License.
511 //
512 // Each contributor grants you a non-exclusive, worldwide, royalty-free
513 //patent license under the contributor's essential patent claims, to
514 //make, use, sell, offer for sale, import and otherwise run, modify and
515 //propagate the contents of its contributor version.
516 //
517 // In the following three paragraphs, a "patent license" is any express
518 //agreement or commitment, however denominated, not to enforce a patent
519 //(such as an express permission to practice a patent or covenant not to
520 //sue for patent infringement). To "grant" such a patent license to a
521 //party means to make such an agreement or commitment not to enforce a
522 //patent against the party.
523 //
524 // If you convey a covered work, knowingly relying on a patent license,
525 //and the Corresponding Source of the work is not available for anyone
526 //to copy, free of charge and under the terms of this License, through a
527 //publicly available network server or other readily accessible means,
528 //then you must either (1) cause the Corresponding Source to be so
529 //available, or (2) arrange to deprive yourself of the benefit of the
530 //patent license for this particular work, or (3) arrange, in a manner
531 //consistent with the requirements of this License, to extend the patent
532 //license to downstream recipients. "Knowingly relying" means you have
533 //actual knowledge that, but for the patent license, your conveying the
534 //covered work in a country, or your recipient's use of the covered work
535 //in a country, would infringe one or more identifiable patents in that
536 //country that you have reason to believe are valid.
537 //
538 // If, pursuant to or in connection with a single transaction or
539 //arrangement, you convey, or propagate by procuring conveyance of, a
540 //covered work, and grant a patent license to some of the parties
541 //receiving the covered work authorizing them to use, propagate, modify
542 //or convey a specific copy of the covered work, then the patent license
543 //you grant is automatically extended to all recipients of the covered
544 //work and works based on it.
545 //
546 // A patent license is "discriminatory" if it does not include within
547 //the scope of its coverage, prohibits the exercise of, or is
548 //conditioned on the non-exercise of one or more of the rights that are
549 //specifically granted under this License. You may not convey a covered
550 //work if you are a party to an arrangement with a third party that is
551 //in the business of distributing software, under which you make payment
552 //to the third party based on the extent of your activity of conveying
553 //the work, and under which the third party grants, to any of the
554 //parties who would receive the covered work from you, a discriminatory
555 //patent license (a) in connection with copies of the covered work
556 //conveyed by you (or copies made from those copies), or (b) primarily
557 //for and in connection with specific products or compilations that
558 //contain the covered work, unless you entered into that arrangement,
559 //or that patent license was granted, prior to 28 March 2007.
560 //
561 // Nothing in this License shall be construed as excluding or limiting
562 //any implied license or other defenses to infringement that may
563 //otherwise be available to you under applicable patent law.
564 //
565 // 12. No Surrender of Others' Freedom.
566 //
567 // If conditions are imposed on you (whether by court order, agreement or
568 //otherwise) that contradict the conditions of this License, they do not
569 //excuse you from the conditions of this License. If you cannot convey a
570 //covered work so as to satisfy simultaneously your obligations under this
571 //License and any other pertinent obligations, then as a consequence you may
572 //not convey it at all. For example, if you agree to terms that obligate you
573 //to collect a royalty for further conveying from those to whom you convey
574 //the Program, the only way you could satisfy both those terms and this
575 //License would be to refrain entirely from conveying the Program.
576 //
577 // 13. Use with the GNU Affero General Public License.
578 //
579 // Notwithstanding any other provision of this License, you have
580 //permission to link or combine any covered work with a work licensed
581 //under version 3 of the GNU Affero General Public License into a single
582 //combined work, and to convey the resulting work. The terms of this
583 //License will continue to apply to the part which is the covered work,
584 //but the special requirements of the GNU Affero General Public License,
585 //section 13, concerning interaction through a network will apply to the
586 //combination as such.
587 //
588 // 14. Revised Versions of this License.
589 //
590 // The Free Software Foundation may publish revised and/or new versions of
591 //the GNU General Public License from time to time. Such new versions will
592 //be similar in spirit to the present version, but may differ in detail to
593 //address new problems or concerns.
594 //
595 // Each version is given a distinguishing version number. If the
596 //Program specifies that a certain numbered version of the GNU General
597 //Public License "or any later version" applies to it, you have the
598 //option of following the terms and conditions either of that numbered
599 //version or of any later version published by the Free Software
600 //Foundation. If the Program does not specify a version number of the
601 //GNU General Public License, you may choose any version ever published
602 //by the Free Software Foundation.
603 //
604 // If the Program specifies that a proxy can decide which future
605 //versions of the GNU General Public License can be used, that proxy's
606 //public statement of acceptance of a version permanently authorizes you
607 //to choose that version for the Program.
608 //
609 // Later license versions may give you additional or different
610 //permissions. However, no additional obligations are imposed on any
611 //author or copyright holder as a result of your choosing to follow a
612 //later version.
613 //
614 // 15. Disclaimer of Warranty.
615 //
616 // THERE IS NO WARRANTY FOR THE PROGRAM, TO THE EXTENT PERMITTED BY
617 //APPLICABLE LAW. EXCEPT WHEN OTHERWISE STATED IN WRITING THE COPYRIGHT
618 //HOLDERS AND/OR OTHER PARTIES PROVIDE THE PROGRAM "AS IS" WITHOUT WARRANTY
619 //OF ANY KIND, EITHER EXPRESSED OR IMPLIED, INCLUDING, BUT NOT LIMITED TO,
620 //THE IMPLIED WARRANTIES OF MERCHANTABILITY AND FITNESS FOR A PARTICULAR
621 //PURPOSE. THE ENTIRE RISK AS TO THE QUALITY AND PERFORMANCE OF THE PROGRAM
622 //IS WITH YOU. SHOULD THE PROGRAM PROVE DEFECTIVE, YOU ASSUME THE COST OF
623 //ALL NECESSARY SERVICING, REPAIR OR CORRECTION.
624 //
625 // 16. Limitation of Liability.
626 //
627 // IN NO EVENT UNLESS REQUIRED BY APPLICABLE LAW OR AGREED TO IN WRITING
628 //WILL ANY COPYRIGHT HOLDER, OR ANY OTHER PARTY WHO MODIFIES AND/OR CONVEYS
629 //THE PROGRAM AS PERMITTED ABOVE, BE LIABLE TO YOU FOR DAMAGES, INCLUDING ANY
630 //GENERAL, SPECIAL, INCIDENTAL OR CONSEQUENTIAL DAMAGES ARISING OUT OF THE
631 //USE OR INABILITY TO USE THE PROGRAM (INCLUDING BUT NOT LIMITED TO LOSS OF
632 //DATA OR DATA BEING RENDERED INACCURATE OR LOSSES SUSTAINED BY YOU OR THIRD
633 //PARTIES OR A FAILURE OF THE PROGRAM TO OPERATE WITH ANY OTHER PROGRAMS),
634 //EVEN IF SUCH HOLDER OR OTHER PARTY HAS BEEN ADVISED OF THE POSSIBILITY OF
635 //SUCH DAMAGES.
636 //
637 // 17. Interpretation of Sections 15 and 16.
638 //
639 // If the disclaimer of warranty and limitation of liability provided
640 //above cannot be given local legal effect according to their terms,
641 //reviewing courts shall apply local law that most closely approximates
642 //an absolute waiver of all civil liability in connection with the
643 //Program, unless a warranty or assumption of liability accompanies a
644 //copy of the Program in return for a fee.
645 //
646 // END OF TERMS AND CONDITIONS
647 //
648 // How to Apply These Terms to Your New Programs
649 //
650 // If you develop a new program, and you want it to be of the greatest
651 //possible use to the public, the best way to achieve this is to make it
652 //free software which everyone can redistribute and change under these terms.
653 //
654 // To do so, attach the following notices to the program. It is safest
655 //to attach them to the start of each source file to most effectively
656 //state the exclusion of warranty; and each file should have at least
657 //the "copyright" line and a pointer to where the full notice is found.
658 //
659 // <one line to give the program's name and a brief idea of what it does.>
660 // Copyright (C) <year> <name of author>
661 //
662 // This program is free software: you can redistribute it and/or modify
663 // it under the terms of the GNU General Public License as published by
664 // the Free Software Foundation, either version 3 of the License, or
665 // (at your option) any later version.
666 //
667 // This program is distributed in the hope that it will be useful,
668 // but WITHOUT ANY WARRANTY; without even the implied warranty of
669 // MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
670 // GNU General Public License for more details.
671 //
672 // You should have received a copy of the GNU General Public License
673 // along with this program. If not, see <http://www.gnu.org/licenses/>.
674 //
675 //Also add information on how to contact you by electronic and paper mail.
676 //
677 // If the program does terminal interaction, make it output a short
678 //notice like this when it starts in an interactive mode:
679 //
680 // <program> Copyright (C) <year> <name of author>
681 // This program comes with ABSOLUTELY NO WARRANTY; for details type `show w'.
682 // This is free software, and you are welcome to redistribute it
683 // under certain conditions; type `show c' for details.
684 //
685 //The hypothetical commands `show w' and `show c' should show the appropriate
686 //parts of the General Public License. Of course, your program's commands
687 //might be different; for a GUI interface, you would use an "about box".
688 //
689 // You should also get your employer (if you work as a programmer) or school,
690 //if any, to sign a "copyright disclaimer" for the program, if necessary.
691 //For more information on this, and how to apply and follow the GNU GPL, see
692 //<http://www.gnu.org/licenses/>.
693 //
694 // The GNU General Public License does not permit incorporating your program
695 //into proprietary programs. If your program is a subroutine library, you
696 //may consider it more useful to permit linking proprietary applications with
697 //the library. If this is what you want to do, use the GNU Lesser General
698 //Public License instead of this License. But first, please read
699 //<http://www.gnu.org/philosophy/why-not-lgpl.html>.
700 //-------------------------------------------------------------------------------------------------
701 //********************************************************************************
702 //Contains functions related to [operations on] the usrs table of the database that
703 //aren't necessary for the operation of the dayview scheduler.
704 //--------------------------------------------------------------------------------------------------------------
705 //
706 require_once("config.inc");
707 require_once("dbx.inc");
708 require_once("global.inc");
709 require_once("sguid.inc");
710 require_once("usrs.inc");
711 //
712 //--------------------------------------------------------------------------------------------------------------
713 //Retrieves key information about active users, ordered by:
714 // a)Last name.
715 // b)First name.
716 // c)Middle Initial.
717 // d)Database index (the decisive tie breaker).
718 //
719 //This information is displayed on the active users list page.
720 //
721 //Although there is some minor risk of memory exhaustion, it is too slow to grab only the indices
722 //and then yank the info as the table is generated.
723 //
724 //Returns FALSE if no records.
725 //
726 function USRS_get_info_users_active_a()
727 {
728 global $GLOBAL_dbhandle;
729
730 //Form the query string.
731 $query_string = "SELECT idx,fname,lname,mname,userid,mostrecentlogin,acctexpdate,schedalonerscs FROM usrs WHERE status=\""
732 .
733 USRS_STATUS_ACTIVE
734 .
735 "\" ORDER BY lname ASC, fname ASC, mname ASC, idx ASC";
736
737 //Execute the query.
738 $result = mysql_query($query_string, $GLOBAL_dbhandle);
739
740 if ($result === FALSE)
741 {
742 //Unknown query failure. Return FALSE to the caller. No need to free,
743 //as this is not a result.
744 $rv = FALSE;
745 }
746 else
747 {
748 //Figure out how many rows in the result.
749 $nrows = mysql_num_rows($result);
750
751 if ($nrows == 0)
752 {
753 //No rows in the result. The query failed to give us a record, but still
754 //we need to free the result set.
755
756 //Free the result.
757 mysql_free_result($result);
758
759 //The caller gets FALSE. No records.
760 $rv = FALSE;
761 }
762 else
763 {
764 //We have at least one record. Grab the indices.
765 //
766 for ($i=0; $i<$nrows; $i++)
767 {
768 $temp = mysql_fetch_assoc($result);
769 $rv[$i] = $temp;
770 }
771
772 //Free the result.
773 mysql_free_result($result);
774 }
775
776 //Return the value to the caller.
777 return($rv);
778 }
779 }
780 //
781 //--------------------------------------------------------------------------------------------------------------
782 //Retrieves key information about inactive users, ordered by:
783 // a)Last name.
784 // b)First name.
785 // c)Middle Initial.
786 // d)Database index (the decisive tie breaker).
787 //
788 //This information is displayed on the inactive users list page.
789 //
790 //Although there is some minor risk of memory exhaustion, it is too slow to grab only the indices
791 //and then yank the info as the table is generated.
792 //
793 //Returns FALSE if no records.
794 //
795 function USRS_get_info_users_inactive_a()
796 {
797 global $GLOBAL_dbhandle;
798
799 //Form the query string.
800 $query_string = "SELECT idx,fname,lname,mname,userid,mostrecentlogin,acctexpdate,schedalonerscs FROM usrs WHERE status=\""
801 .
802 USRS_STATUS_INACTIVE
803 .
804 "\" ORDER BY lname ASC, fname ASC, mname ASC, idx ASC";
805
806 //Execute the query.
807 $result = mysql_query($query_string, $GLOBAL_dbhandle);
808
809 if ($result === FALSE)
810 {
811 //Unknown query failure. Return FALSE to the caller. No need to free,
812 //as this is not a result.
813 $rv = FALSE;
814 }
815 else
816 {
817 //Figure out how many rows in the result.
818 $nrows = mysql_num_rows($result);
819
820 if ($nrows == 0)
821 {
822 //No rows in the result. The query failed to give us a record, but still
823 //we need to free the result set.
824
825 //Free the result.
826 mysql_free_result($result);
827
828 //The caller gets FALSE. No records.
829 $rv = FALSE;
830 }
831 else
832 {
833 //We have at least one record. Grab the indices.
834 //
835 for ($i=0; $i<$nrows; $i++)
836 {
837 $temp = mysql_fetch_assoc($result);
838 $rv[$i] = $temp;
839 }
840
841 //Free the result.
842 mysql_free_result($result);
843 }
844
845 //Return the value to the caller.
846 return($rv);
847 }
848 }
849 //
850 //--------------------------------------------------------------------------------------------------------------
851 //Retrieves key information about all users, and populates an array indexed by the database index with this
852 //information. If there are no users, FALSE is returned.
853 //
854 function USRS_get_info_users_all_a()
855 {
856 global $GLOBAL_dbhandle;
857
858 //Form the query string.
859 $query_string = "SELECT idx,fname,mname,lname FROM usrs";
860
861 //Execute the query.
862 $result = mysql_query($query_string, $GLOBAL_dbhandle);
863
864 if ($result === FALSE)
865 {
866 //Unknown query failure. Return FALSE to the caller. No need to free,
867 //as this is not a result.
868 $rv = FALSE;
869 }
870 else
871 {
872 //Figure out how many rows in the result.
873 $nrows = mysql_num_rows($result);
874
875 if ($nrows == 0)
876 {
877 //No rows in the result. The query failed to give us a record, but still
878 //we need to free the result set.
879
880 //Free the result.
881 mysql_free_result($result);
882
883 //The caller gets FALSE. No records.
884 $rv = FALSE;
885 }
886 else
887 {
888 //We have at least one record. Grab the indices.
889 //
890 for ($i=0; $i<$nrows; $i++)
891 {
892 $temp = mysql_fetch_assoc($result);
893 $rv[$temp["idx"]] = $temp;
894 }
895
896 //Free the result.
897 mysql_free_result($result);
898 }
899
900 //Return the value to the caller.
901 return($rv);
902 }
903 }
904 //
905 //--------------------------------------------------------------------------------------------------------------
906 //Given a user's first name, middle name or intitial, and last name, forms a name
907 //string. This is used for the users lists.
908 //
909 function USRS_display_name_string($fname_in, $mname_in, $lname_in)
910 {
911 $fnl = strlen($fname_in);
912 $mnl = strlen($mname_in);
913 $lnl = strlen($lname_in);
914
915 if (!$lnl)
916 {
917 //This is a no-no.
918 return("UNKNOWN USER");
919 }
920 else if ($lnl && !$fnl)
921 {
922 return($lname_in);
923 }
924 else
925 {
926 if ($mnl)
927 {
928 return($lname_in . ", " . $fname_in . " " . SubStr($mname_in, 0, 1) . ".");
929 }
930 else
931 {
932 return($lname_in . ", " . $fname_in);
933 }
934 }
935 }
936 //--------------------------------------------------------------------------------------------------------------
937 //Stuffs the pwhash field of a usrs record by index. There is
938 //no result code. The temporary password is destroyed at the same time.
939 //
940 //This operation is considered exempt from the modification SGUID checks--the password
941 //is a separate matter and not part of the normal field edits.
942 //
943 function USRS_pwhash_stuff($idx_in, $pwhash_in)
944 {
945 global $GLOBAL_dbhandle;
946
947 //Set the password hash with a single SQL statement.
948 $query_string = "UPDATE usrs SET pwhash=\"" . $pwhash_in . "\", lostpwhash=\"\", lostpwgentime=\"\" WHERE idx=\"" . $idx_in . "\"";
949
950 //Run the query. We don't much care whether it fails or succeeds (nothing to be done, anyway).
951 mysql_query($query_string, $GLOBAL_dbhandle);
952 }
953 //
954 //--------------------------------------------------------------------------------------------------------------
955 //Description
956 // Adds or modifies a USRS record. Certain parameters specify what is expected.
957 //
958 //Inputs
959 // action_in
960 // Enumerated type. Possibilities are:
961 // "A" : Add new.
962 // "M" : Modify existing.
963 //
964 // rec_in
965 // The data about the record to add or modify, as an associative array.
966 //
967 // Adding a record:
968 // a)The index must be absent (it is assigned automatically by the database).
969 // b)The userid must be included and must be globally unique, otherwise an error will be
970 // returned and the record won't be added.
971 // c)Fields out of range or defective will be corrected, and warnings will be returned.
972 // The record will, however, be added if possible.
973 // c)All fields not present in the associative array will be assigned default values.
974 // d)The creation/modification SGUID is handled automatically and may not be included in the
975 // associative array.
976 //
977 // Modifying a record:
978 // a)The record is specified by either index or userid. If both are specified, they must
979 // correspond to an existing record and must be consistent.
980 // b)Fields not included in the associative array are not touched.
981 // c)The creation/modification SGUID is handled automatically. If this field is included
982 // in the associative array, it means to check this against what is in the database
983 // and error out on editing collision if the value doesn't match what is in the database.
984 //
985 //Outputs
986 // result_code_out
987 // Adding a record:
988 // 0 if the operation failed, or the index if it succeeded.
989 // Modifying an existing record.
990 // 0 if the operation failed or 1 if it succeeds.
991 //
992 // errors_out
993 // If any errors resulted, an associative array of integers specifying the errors per the defined
994 // constants, or FALSE otherwise.
995 //
996 // warnings_out
997 // If any warnings resulted, an associative array of integers specifying the warnings per the
998 // defined constants, or FALSE otherwise.
999 //
1000 //Database Locking
1001 // Locking is performed per the recursive method described in the documentation. If, for example,
1002 // the client wishes to call this function from within a larger critical section, as long as the
1003 // client uses the recursive locking method, everything will operate correctly.
1004 //
1005 function USRS_record_add_modify($action_in, $rec_in, &$result_code_out, &$errors_out, &$warnings_out)
1006 {
1007 global $GLOBAL_dbhandle;
1008 global $GLOBAL_dblocked;
1009 global $CONFIG_FBO_USER_CATEGORIES;
1010
1011 //Variable remembers if are terminating the function (i.e. something fatal has been
1012 //encountered).
1013 $in_termination_sequence = FALSE;
1014
1015 //Error array and warnings array start at element 0.
1016 //
1017 $e_array_idx = 0;
1018 $w_array_idx = 0;
1019
1020 //Take a look at the action. It must be one of the two valid codes, "A" or "M".
1021 //
1022 if (!$in_termination_sequence)
1023 {
1024 if (($action_in != "A") && ($action_in != "M"))
1025 {
1026 $errors_out_local[$e_array_idx] = USRS_ERROR_ACTION_PAR_ILLEGAL;
1027 $e_array_idx++;
1028 $in_termination_sequence = TRUE;
1029 }
1030 }
1031
1032 //Take a look at the index. If it is present, it must be a positive integer or the
1033 //string equivalent of a positive integer.
1034 //
1035 if (!$in_termination_sequence)
1036 {
1037 if (isset($rec_in["idx"]))
1038 {
1039 if (DB_table_index_short_validity_check_zna($rec_in["idx"]))
1040 {
1041 //The variable is logically an integer, and the function said it was
1042 //in the valid range. If it is an integer, leave it alone, otherwise
1043 //convert it to an integer.
1044 //
1045 if (!is_int($rec_in["idx"]))
1046 {
1047 $rec_in["idx"] = intval($rec_in["idx"]);
1048 }
1049 }
1050 else
1051 {
1052 //The value isn't an integer and can't be converted to an integer.
1053 //Error out.
1054 $errors_out_local[$e_array_idx] = USRS_ERROR_IDX_ILLEGAL;
1055 $e_array_idx++;
1056 $in_termination_sequence = TRUE;
1057 }
1058 }
1059 }
1060
1061 //Take a look at the userid. If that is present, it has to be sane.
1062 //
1063 if (!$in_termination_sequence)
1064 {
1065 if (isset($rec_in["userid"]))
1066 {
1067 //Canonically, the userid has to be all lower-case and can't
1068 //contain any extra padding. If it ain't a string, it will
1069 //be flagged as an error a few lines down by the membership test
1070 //function.
1071 //
1072 if (is_string($rec_in["userid"]))
1073 {
1074 $rec_in["userid"] = StrToLower(Trim($rec_in["userid"]));
1075 }
1076
1077 if (USRS_userid_membership_test($rec_in["userid"]) === TRUE)
1078 {
1079 //The userid is fine.
1080 //
1081 }
1082 else
1083 {
1084 //The userid is illegal.
1085 //
1086 $errors_out_local[$e_array_idx] = USRS_ERROR_USERID_ILLEGAL;
1087 $e_array_idx++;
1088 $in_termination_sequence = TRUE;
1089 }
1090 }
1091 }
1092
1093 //-----------------------------------------------------------
1094 //TODO: Add code to confine and error-trap the other fields.
1095 //-----------------------------------------------------------
1096
1097 if (!$in_termination_sequence)
1098 {
1099 //Lock the database using the recursive critical section method (discussed in the
1100 //manual). This is necessary because the test for presence and the insert have to
1101 //be combined atomically.
1102 $db_was_locked = $GLOBAL_dblocked;
1103 if (! $GLOBAL_dblocked)
1104 {
1105 DB_db_lock();
1106 $GLOBAL_dblocked = TRUE;
1107 }
1108
1109 if ($action_in == "A")
1110 {
1111 if (isset($rec_in["idx"]))
1112 {
1113 //This is an error because the index is assigned automatically--it isn't
1114 //allowed to specify it.
1115 //
1116 $errors_out_local[$e_array_idx] = USRS_ERROR_IDX_ON_ADD;
1117 $e_array_idx++;
1118 $in_termination_sequence = TRUE;
1119 }
1120 else if (!isset($rec_in["userid"]))
1121 {
1122 //The userid has to be present on an add. Note that it is checked
1123 //for validity if it is present above.
1124 //
1125 $errors_out_local[$e_array_idx] = USRS_ERROR_NO_USERID_ON_ADD;
1126 $e_array_idx++;
1127 $in_termination_sequence = TRUE;
1128 }
1129 else if (USRS_userid_idx_map($rec_in["userid"]) !== FALSE)
1130 {
1131 //The userid already exists ... illegal.
1132 //
1133 $errors_out_local[$e_array_idx] = USRS_ERROR_DUP_USERID_ON_ADD;
1134 $e_array_idx++;
1135 $in_termination_sequence = TRUE;
1136 }
1137 }
1138 else //action is modify
1139 {
1140 //If the index is present, try to get the record with the passed
1141 //index. If not present, error.
1142 //
1143 if (isset($rec_in["idx"]))
1144 {
1145 $modify_rec = USRS_retrieve_by_userid($rec_in["idx"]);
1146
1147 if ($modify_rec === FALSE)
1148 {
1149 //Rec with that idx does not exist.
1150 //
1151 $errors_out_local[$e_array_idx] = USRS_ERROR_MOD_REC_NOT_PRESENT;
1152 $e_array_idx++;
1153 $in_termination_sequence = TRUE;
1154 }
1155 else //Record was found by index.
1156 {
1157 //Check to be sure userid, if it exists, is consistent.
1158 if (isset($rec_in["userid"]))
1159 {
1160 if ($rec_in["userid"] != $modify_rec["userid"])
1161 {
1162 //On modification, index and userid do not match.
1163 //
1164 $errors_out_local[$e_array_idx] = USRS_ERROR_MOD_IDX_USERID_INCONSISTENT;
1165 $e_array_idx++;
1166 $in_termination_sequence = TRUE;
1167 }
1168 }
1169 }
1170 }
1171 else if (isset($rec_in["userid"]))
1172 {
1173 //The userid was specified, but not the idx. Check to be sure that record exists,
1174 //if not, error out, if so, keep track of the index.
1175 //
1176 $modify_rec = USRS_userid_idx_map($rec_in["userid"]);
1177
1178 if ($modify_rec === FALSE)
1179 {
1180 //The userid does not exist. Can't identify this record to modify.
1181 //Error out.
1182 //
1183 $errors_out_local[$e_array_idx] = USRS_ERROR_MOD_REC_NOT_PRESENT;
1184 $e_array_idx++;
1185 $in_termination_sequence = TRUE;
1186 }
1187 else
1188 {
1189 //The record corresponding to the userid does exist. Stuff the
1190 //index to save us time later.
1191 //
1192 $rec_in["idx"] = $modify_rec["idx"];
1193 }
1194 }
1195 else
1196 {
1197 //There isn't enough information to identify the record to modify (no idx,
1198 //no userid). Have to error out.
1199 //
1200 $errors_out_local[$e_array_idx] = USRS_ERROR_MOD_REC_NOT_PRESENT;
1201 $e_array_idx++;
1202 $in_termination_sequence = TRUE;
1203 }
1204 }
1205
1206 //If the command is to modify, look for an editing collision.
1207 //
1208 if (!$in_termination_sequence)
1209 {
1210 if ($action_in == "M")
1211 {
1212 if ($rec_in["crmodsguid"] != $modify_rec["crmodsguid"])
1213 {
1214 $errors_out_local[$e_array_idx] = USRS_ERROR_EDITING_COLLISION;
1215 $e_array_idx++;
1216 $in_termination_sequence = TRUE;
1217 }
1218 }
1219 }
1220
1221 //Form the query strings. There are two different types, depending on whether
1222 //we are adding or modifying a record.
1223 //
1224 //For adding, the string will be of the form:
1225 // INSERT INTO usrs SET fn1=val1, fn2=val2, etc.
1226 //
1227 //For modifying, the string will be of the form:
1228 // UPDATE usrs SET fn1=val1, fn2=val2, etc. WHERE idx=val.
1229 //
1230 if (!$in_termination_sequence)
1231 {
1232 //Obtain an SGUID to for the create/modification stamp.
1233 //
1234 $crmodsguid = SGUID_sguid();
1235
1236 if ($action_in == "A")
1237 {
1238 //Add
1239 //
1240 $query_string = "INSERT INTO usrs SET status=\"";
1241 //
1242 //-----------------------------------------------------------------------------------------
1243 //status
1244 //-----------------------------------------------------------------------------------------
1245 if (isset($rec_in["status"]))
1246 {
1247 $query_string .= mysql_real_escape_string((string)$rec_in["status"], $GLOBAL_dbhandle);
1248 }
1249 else
1250 {
1251 $query_string .= mysql_real_escape_string((string)USRS_STATUS_ACTIVE, $GLOBAL_dbhandle);
1252 }
1253 $query_string .= "\", seclvl=\"";
1254 //
1255 //-----------------------------------------------------------------------------------------
1256 //seclvl
1257 //-----------------------------------------------------------------------------------------
1258 if (isset($rec_in["seclvl"]))
1259 {
1260 $query_string .= mysql_real_escape_string((string)$rec_in["seclvl"], $GLOBAL_dbhandle);
1261 }
1262 else
1263 {
1264 //Expression below gets last entry from the lookup table.
1265 //
1266 $query_string .= mysql_real_escape_string((string)($CONFIG_FBO_USER_CATEGORIES[count($CONFIG_FBO_USER_CATEGORIES) - 4]),
1267 $GLOBAL_dbhandle);
1268 }
1269 $query_string .= "\", userid=\"";
1270 //
1271 //-----------------------------------------------------------------------------------------
1272 //userid (this field is mandatory)
1273 //-----------------------------------------------------------------------------------------
1274 $query_string .= mysql_real_escape_string((string)$rec_in["userid"], $GLOBAL_dbhandle);
1275 $query_string .= "\", role=\"";
1276 //
1277 //-----------------------------------------------------------------------------------------
1278 //role
1279 //-----------------------------------------------------------------------------------------
1280 if (isset($rec_in["role"]))
1281 {
1282 $query_string .= mysql_real_escape_string((string)$rec_in["role"], $GLOBAL_dbhandle);
1283 }
1284 else
1285 {
1286 $query_string .= mysql_real_escape_string((string)USRS_ROLE_CUSTNONPILOT, $GLOBAL_dbhandle);
1287 }
1288 $query_string .= "\", perm=\"";
1289 //
1290 //-----------------------------------------------------------------------------------------
1291 //perm
1292 //-----------------------------------------------------------------------------------------
1293 if (isset($rec_in["perm"]))
1294 {
1295 $query_string .= mysql_real_escape_string($rec_in["perm"], $GLOBAL_dbhandle);
1296 }
1297 else
1298 {
1299 $query_string .= mysql_real_escape_string("", $GLOBAL_dbhandle);
1300 }
1301 $query_string .= "\", sex=\"";
1302 //
1303 //-----------------------------------------------------------------------------------------
1304 //sex
1305 //-----------------------------------------------------------------------------------------
1306 if (isset($rec_in["sex"]))
1307 {
1308 $query_string .= mysql_real_escape_string((string)$rec_in["sex"], $GLOBAL_dbhandle);
1309 }
1310 else
1311 {
1312 $query_string .= mysql_real_escape_string((string)USRS_SEX_UNSPECIFIED, $GLOBAL_dbhandle);
1313 }
1314 $query_string .= "\", title=\"";
1315 //
1316 //-----------------------------------------------------------------------------------------
1317 //title
1318 //-----------------------------------------------------------------------------------------
1319 if (isset($rec_in["title"]))
1320 {
1321 $query_string .= mysql_real_escape_string((string)$rec_in["title"], $GLOBAL_dbhandle);
1322 }
1323 else
1324 {
1325 //Empty string.
1326 }
1327 $query_string .= "\", fname=\"";
1328 //
1329 //-----------------------------------------------------------------------------------------
1330 //fname
1331 //-----------------------------------------------------------------------------------------
1332 if (isset($rec_in["fname"]))
1333 {
1334 $query_string .= mysql_real_escape_string((string)$rec_in["fname"], $GLOBAL_dbhandle);
1335 }
1336 else
1337 {
1338 //Empty string.
1339 }
1340 $query_string .= "\", mname=\"";
1341 //
1342 //-----------------------------------------------------------------------------------------
1343 //mname
1344 //-----------------------------------------------------------------------------------------
1345 if (isset($rec_in["mname"]))
1346 {
1347 $query_string .= mysql_real_escape_string((string)$rec_in["mname"], $GLOBAL_dbhandle);
1348 }
1349 else
1350 {
1351 //Empty string.
1352 }
1353 $query_string .= "\", lname=\"";
1354 //
1355 //-----------------------------------------------------------------------------------------
1356 //lname
1357 //-----------------------------------------------------------------------------------------
1358 if (isset($rec_in["lname"]))
1359 {
1360 $query_string .= mysql_real_escape_string((string)$rec_in["lname"], $GLOBAL_dbhandle);
1361 }
1362 else
1363 {
1364 //Empty string.
1365 }
1366 $query_string .= "\", suffix=\"";
1367 //
1368 //-----------------------------------------------------------------------------------------
1369 //suffix
1370 //-----------------------------------------------------------------------------------------
1371 if (isset($rec_in["suffix"]))
1372 {
1373 $query_string .= mysql_real_escape_string((string)$rec_in["suffix"], $GLOBAL_dbhandle);
1374 }
1375 else
1376 {
1377 //Empty string.
1378 }
1379 $query_string .= "\", adl1=\"";
1380 //
1381 //-----------------------------------------------------------------------------------------
1382 //adl1
1383 //-----------------------------------------------------------------------------------------
1384 if (isset($rec_in["adl1"]))
1385 {
1386 $query_string .= mysql_real_escape_string((string)$rec_in["adl1"], $GLOBAL_dbhandle);
1387 }
1388 else
1389 {
1390 //Empty string.
1391 }
1392 $query_string .= "\", adl2=\"";
1393 //
1394 //-----------------------------------------------------------------------------------------
1395 //adl2
1396 //-----------------------------------------------------------------------------------------
1397 if (isset($rec_in["adl1"]))
1398 {
1399 $query_string .= mysql_real_escape_string((string)$rec_in["adl2"], $GLOBAL_dbhandle);
1400 }
1401 else
1402 {
1403 //Empty string.
1404 }
1405 $query_string .= "\", city=\"";
1406 //
1407 //-----------------------------------------------------------------------------------------
1408 //city
1409 //-----------------------------------------------------------------------------------------
1410 if (isset($rec_in["city"]))
1411 {
1412 $query_string .= mysql_real_escape_string((string)$rec_in["city"], $GLOBAL_dbhandle);
1413 }
1414 else
1415 {
1416 //Empty string.
1417 }
1418 $query_string .= "\", stateprovince=\"";
1419 //
1420 //-----------------------------------------------------------------------------------------
1421 //stateprovince
1422 //-----------------------------------------------------------------------------------------
1423 if (isset($rec_in["stateprovince"]))
1424 {
1425 $query_string .= mysql_real_escape_string((string)$rec_in["stateprovince"], $GLOBAL_dbhandle);
1426 }
1427 else
1428 {
1429 //Empty string.
1430 }
1431 $query_string .= "\", zippostalcode=\"";
1432 //
1433 //-----------------------------------------------------------------------------------------
1434 //zippostalcode
1435 //-----------------------------------------------------------------------------------------
1436 if (isset($rec_in["zippostalcode"]))
1437 {
1438 $query_string .= mysql_real_escape_string((string)$rec_in["zippostalcode"], $GLOBAL_dbhandle);
1439 }
1440 else
1441 {
1442 //Empty string.
1443 }
1444 $query_string .= "\", country=\"";
1445 //
1446 //-----------------------------------------------------------------------------------------
1447 //country
1448 //-----------------------------------------------------------------------------------------
1449 if (isset($rec_in["country"]))
1450 {
1451 $query_string .= mysql_real_escape_string((string)$rec_in["country"], $GLOBAL_dbhandle);
1452 }
1453 else
1454 {
1455 //Empty string.
1456 }
1457 $query_string .= "\", pwhash=\"";
1458 //
1459 //-----------------------------------------------------------------------------------------
1460 //pwhash
1461 //-----------------------------------------------------------------------------------------
1462 if (isset($rec_in["pwhash"]))
1463 {
1464 $query_string .= mysql_real_escape_string((string)$rec_in["pwhash"], $GLOBAL_dbhandle);
1465 }
1466 else
1467 {
1468 //Empty string.
1469 }
1470 $query_string .= "\", lostpwhash=\"";
1471 //
1472 //-----------------------------------------------------------------------------------------
1473 //lostpwhash
1474 //-----------------------------------------------------------------------------------------
1475 if (isset($rec_in["lostpwhash"]))
1476 {
1477 $query_string .= mysql_real_escape_string((string)$rec_in["lostpwhash"], $GLOBAL_dbhandle);
1478 }
1479 else
1480 {
1481 //Empty string.
1482 }
1483 $query_string .= "\", lostpwgentime=\"";
1484 //
1485 //-----------------------------------------------------------------------------------------
1486 //lostpwgentime
1487 //-----------------------------------------------------------------------------------------
1488 if (isset($rec_in["lostpwgentime"]))
1489 {
1490 $query_string .= mysql_real_escape_string((string)$rec_in["lostpwgentime"], $GLOBAL_dbhandle);
1491 }
1492 else
1493 {
1494 //Empty string.
1495 }
1496 $query_string .= "\", ratings=\"";
1497 //
1498 //-----------------------------------------------------------------------------------------
1499 //ratings
1500 //-----------------------------------------------------------------------------------------
1501 if (isset($rec_in["ratings"]))
1502 {
1503 $query_string .= mysql_real_escape_string((string)$rec_in["ratings"], $GLOBAL_dbhandle);
1504 }
1505 else
1506 {
1507 //Empty string.
1508 }
1509 $query_string .= "\", bfrlicexpdate=\"";
1510 //
1511 //-----------------------------------------------------------------------------------------
1512 //bfrlicexpdate
1513 //-----------------------------------------------------------------------------------------
1514 if (isset($rec_in["bfrlicexpdate"]))
1515 {
1516 $query_string .= mysql_real_escape_string((string)$rec_in["bfrlicexpdate"], $GLOBAL_dbhandle);
1517 }
1518 else
1519 {
1520 //Empty string.
1521 }
1522 $query_string .= "\", medexpdate=\"";
1523 //
1524 //-----------------------------------------------------------------------------------------
1525 //medexpdate
1526 //-----------------------------------------------------------------------------------------
1527 if (isset($rec_in["medexpdate"]))
1528 {
1529 $query_string .= mysql_real_escape_string((string)$rec_in["medexpdate"], $GLOBAL_dbhandle);
1530 }
1531 else
1532 {
1533 //Empty string.
1534 }
1535 $query_string .= "\", restrictions=\"";
1536 //
1537 //-----------------------------------------------------------------------------------------
1538 //restrictions
1539 //-----------------------------------------------------------------------------------------
1540 if (isset($rec_in["restrictions"]))
1541 {
1542 $query_string .= mysql_real_escape_string((string)$rec_in["restrictions"], $GLOBAL_dbhandle);
1543 }
1544 else
1545 {
1546 //Empty string.
1547 }
1548 $query_string .= "\", dayphone=\"";
1549 //
1550 //-----------------------------------------------------------------------------------------
1551 //dayphone
1552 //-----------------------------------------------------------------------------------------
1553 if (isset($rec_in["dayphone"]))
1554 {
1555 $query_string .= mysql_real_escape_string((string)$rec_in["dayphone"], $GLOBAL_dbhandle);
1556 }
1557 else
1558 {
1559 //Empty string.
1560 }
1561 $query_string .= "\", eveningphone=\"";
1562 //
1563 //-----------------------------------------------------------------------------------------
1564 //eveningphone
1565 //-----------------------------------------------------------------------------------------
1566 if (isset($rec_in["eveningphone"]))
1567 {
1568 $query_string .= mysql_real_escape_string((string)$rec_in["eveningphone"], $GLOBAL_dbhandle);
1569 }
1570 else
1571 {
1572 //Empty string.
1573 }
1574 $query_string .= "\", em1=\"";
1575 //
1576 //-----------------------------------------------------------------------------------------
1577 //em1
1578 //-----------------------------------------------------------------------------------------
1579 if (isset($rec_in["em1"]))
1580 {
1581 $query_string .= mysql_real_escape_string((string)$rec_in["em1"], $GLOBAL_dbhandle);
1582 }
1583 else
1584 {
1585 //Empty string.
1586 }
1587 $query_string .= "\", em2=\"";
1588 //
1589 //-----------------------------------------------------------------------------------------
1590 //em2
1591 //-----------------------------------------------------------------------------------------
1592 if (isset($rec_in["em2"]))
1593 {
1594 $query_string .= mysql_real_escape_string((string)$rec_in["em2"], $GLOBAL_dbhandle);
1595 }
1596 else
1597 {
1598 //Empty string.
1599 }
1600 $query_string .= "\", acctexpdate=\"";
1601 //
1602 //-----------------------------------------------------------------------------------------
1603 //acctexpdate
1604 //-----------------------------------------------------------------------------------------
1605 if (isset($rec_in["acctexpdate"]))
1606 {
1607 $query_string .= mysql_real_escape_string((string)$rec_in["acctexpdate"], $GLOBAL_dbhandle);
1608 }
1609 else
1610 {
1611 //Empty string.
1612 }
1613 $query_string .= "\", mostrecentlogin=\"";
1614 //
1615 //-----------------------------------------------------------------------------------------
1616 //mostrecentlogin
1617 //-----------------------------------------------------------------------------------------
1618 if (isset($rec_in["mostrecentlogin"]))
1619 {
1620 $query_string .= mysql_real_escape_string((string)$rec_in["mostrecentlogin"], $GLOBAL_dbhandle);
1621 }
1622 else
1623 {
1624 //Empty string.
1625 }
1626 $query_string .= "\", schedalonerscs=\"";
1627 //
1628 //-----------------------------------------------------------------------------------------
1629 //schedalonerscs
1630 //-----------------------------------------------------------------------------------------
1631 if (isset($rec_in["schedalonerscs"]))
1632 {
1633 $query_string .= mysql_real_escape_string((string)$rec_in["schedalonerscs"], $GLOBAL_dbhandle);
1634 }
1635 else
1636 {
1637 //Empty string.
1638 }
1639 $query_string .= "\", fboremarks=\"";
1640 //
1641 //-----------------------------------------------------------------------------------------
1642 //fboremarks
1643 //-----------------------------------------------------------------------------------------
1644 if (isset($rec_in["fboremarks"]))
1645 {
1646 $query_string .= mysql_real_escape_string((string)$rec_in["fboremarks"], $GLOBAL_dbhandle);
1647 }
1648 else
1649 {
1650 //Empty string.
1651 }
1652 $query_string .= "\", userremarks=\"";
1653 //
1654 //-----------------------------------------------------------------------------------------
1655 //userremarks
1656 //-----------------------------------------------------------------------------------------
1657 if (isset($rec_in["userremarks"]))
1658 {
1659 $query_string .= mysql_real_escape_string((string)$rec_in["userremarks"], $GLOBAL_dbhandle);
1660 }
1661 else
1662 {
1663 //Empty string.
1664 }
1665 $query_string .= "\"";
1666 //
1667 //echo $query_string;
1668
1669 //Execute the query to insert the record.
1670 $result = mysql_query($query_string, $GLOBAL_dbhandle);
1671 //
1672 //If the insert failed, our caller gets FALSE.
1673 if ($result == FALSE)
1674 {
1675 $result_code_out = -1;
1676 }
1677 else
1678 {
1679 //The insert was successful. Figure out the index that was assigned.
1680 $result = mysql_query("SELECT LAST_INSERT_ID()");
1681
1682 //If we have a failure, the caller gets FALSE, otherwise the caller gets the
1683 //index.
1684 if ($result === FALSE)
1685 {
1686 $result_code_out = -1;
1687 }
1688 else
1689 {
1690 //Pick apart the result.
1691 $row = mysql_fetch_array($result, MYSQL_NUM);
1692
1693 //Extract the integer.
1694 $result_code_out = $row[0];
1695
1696 //Free the result memory.
1697 mysql_free_result($result);
1698 }
1699 }
1700 }
1701 else
1702 {
1703 //Modify
1704 //
1705 }
1706 }
1707
1708 //Unlock the database (if it was locked) using the recursive critical section
1709 //method.
1710 if (! $db_was_locked)
1711 {
1712 DB_db_unlock();
1713 $GLOBAL_dblocked = FALSE;
1714 }
1715 } //if not in termination sequence.
1716
1717 //-----------------------------------------------------------
1718 //Clean up the output parameters to go back to the caller.
1719 //
1720 if ($in_termination_sequence)
1721 {
1722 $result_code_out = 0;
1723 }
1724 else if ($result_code_out == -1)
1725 {
1726 //Something went wrong with the query. Return 0 as the
1727 //error code.
1728 $result_code_out = 0;
1729 }
1730 else
1731 {
1732 //The result code contains the index of what was added.
1733 }
1734
1735 if (isset($errors_out_local))
1736 {
1737 $errors_out = $errors_out_local;
1738 }
1739 else
1740 {
1741 $errors_out = FALSE;
1742 }
1743
1744 if (isset($warnings_out_local))
1745 {
1746 $warnings_out = $warnings_out_local;
1747 }
1748 else
1749 {
1750 $warnings_out = FALSE;
1751 }
1752 }
1753 //
1754 //--------------------------------------------------------------------------------------------------------------
1755 //E-mails a user by index (meaning sends the e-mail to each of the contact addresses).
1756 //
1757 //Input parameters:
1758 // a)Idx: index of user in the database.
1759 // b)Subject: the subject of the e-mail.
1760 // c)Message: an array of lines containing the body.
1761 //
1762 //Output parameters:
1763 // a)The number of e-mails actually injected (depends on what is in the database).
1764 //
1765 //A notice about automatically-generated e-mail is automatically appended to the e-mail.
1766 //
1767 function USRS_em_notify($idx_in, $subj_in, $msg_in)
1768 {
1769 global $GLOBAL_stime_year;
1770 global $GLOBAL_stime_month;
1771 global $GLOBAL_stime_day;
1772 global $GLOBAL_stime_hour;
1773 global $GLOBAL_stime_minute;
1774 global $GLOBAL_stime_dow;
1775
1776 $rv = 0;
1777
1778 //Form a footer string that explains the origin of the e-mail.
1779 $footer_text = CONFIG_fbo_automail_footer_text();
1780 //Standard footer.
1781
1782 $footer_split = wordwrap($footer_text, CONFIG_FBO_AUTOMAIL_LINELENGTH, "\n");
1783 $footer_array = explode("\n", $footer_split);
1784
1785 //Trim any empty lines from the end of the array. In the actual e-mail, at least
1786 //as viewed using Outlook, there seem to be two empty lines at the end.
1787 //This hasn't cured it. Trivial issue, but may eventually want to figure
1788 //it out.
1789 //
1790 $n = count($footer_array);
1791 if (($n-1) >= 0)
1792 {
1793 if (strlen($footer_array[$n-1]) == 0)
1794 unset($footer_array[$n-1]);
1795 }
1796 if (($n-2) >= 0)
1797 {
1798 if (strlen($footer_array[$n-2]) == 0)
1799 unset($footer_array[$n-2]);
1800 }
1801
1802 $userinfo = USRS_retrieve_by_idx($idx_in);
1803
1804 if ($userinfo !== FALSE)
1805 {
1806 //Form up the message txt block.
1807 //
1808 $msgtext = "";
1809 for ($i=0; $i<count($msg_in); $i++)
1810 {
1811 $msgtext .= $msg_in[$i];
1812 $msgtext .= "\n";
1813 }
1814
1815 for ($i=0; $i<count($footer_array); $i++)
1816 {
1817 $msgtext .= $footer_array[$i];
1818 if ($i < (count($footer_array) - 1))
1819 $msgtext .= "\n";
1820 }
1821
1822 //Form and send the mail to em1.
1823 if (strlen($userinfo["em1"]))
1824 {
1825 mail(
1826 $userinfo["em1"],
1827 $subj_in,
1828 $msgtext,
1829 "From: " . CONFIG_FBO_AUTOMAIL_FROM . "\r\n" . "Reply-To: " . CONFIG_FBO_AUTOMAIL_FROM
1830 );
1831
1832 $rv++;
1833 }
1834
1835 //Form and send the mail to em2.
1836 if (strlen($userinfo["em2"]))
1837 {
1838 mail(
1839 $userinfo["em2"],
1840 $subj_in,
1841 $msgtext,
1842 "From: " . CONFIG_FBO_AUTOMAIL_FROM . "\r\n" . "Reply-To: " . CONFIG_FBO_AUTOMAIL_FROM
1843 );
1844
1845 $rv++;
1846 }
1847 }
1848
1849 return($rv);
1850 }
1851 //
1852 //--------------------------------------------------------------------------------------------------------------
1853 //Retrieves an array containing the indices of all flight instructors in the resources
1854 //table that are online, or FALSE if none exist.
1855 //
1856 function USRS_get_user_online_idxs()
1857 {
1858 global $GLOBAL_dbhandle;
1859
1860 //Form the query string.
1861 $query_string = "SELECT idx FROM usrs WHERE status=\""
1862 .
1863 mysql_real_escape_string((string)USRS_STATUS_ACTIVE, $GLOBAL_dbhandle)
1864 .
1865 "\"";
1866
1867 //Execute the query.
1868 $result = mysql_query($query_string, $GLOBAL_dbhandle);
1869
1870 if ($result === FALSE)
1871 {
1872 //Unknown query failure. Return FALSE to the caller. No need to free,
1873 //as this is not a result.
1874 $rv = FALSE;
1875 }
1876 else
1877 {
1878 //Figure out how many rows in the result.
1879 $nrows = mysql_num_rows($result);
1880
1881 if ($nrows == 0)
1882 {
1883 //No rows in the result. The query failed to give us a record, but still
1884 //we need to free the result set.
1885
1886 //Free the result.
1887 mysql_free_result($result);
1888
1889 //The caller gets FALSE. No records.
1890 $rv = FALSE;
1891 }
1892 else
1893 {
1894 //We have at least one record. Grab the indices.
1895 //
1896 for ($i=0; $i<$nrows; $i++)
1897 {
1898 $temp = mysql_fetch_assoc($result);
1899 $rv[$i] = $temp["idx"];
1900 }
1901
1902 //Free the result.
1903 mysql_free_result($result);
1904 }
1905
1906 //Return the value to the caller.
1907 return($rv);
1908 }
1909 }
1910 //
1911 //--------------------------------------------------------------------------------------------------------------
1912
1913 //--------------------------------------------------------------------------------------------------------------
1914 //End of $RCSfile: usrsx.inc,v $.
1915 //--------------------------------------------------------------------------------------------------------------
1916 ?>

dashley@gmail.com
ViewVC Help
Powered by ViewVC 1.1.25