2 /************************************************************************
3 * MXChange v0.2.1 Start: 07/10/2004 *
4 * =============== Last change: 07/10/2004 *
6 * -------------------------------------------------------------------- *
7 * File : register_functions.php *
8 * -------------------------------------------------------------------- *
9 * Short description : Special functions for register extension *
10 * -------------------------------------------------------------------- *
11 * Kurzbeschreibung : Spezielle Funktion fuer register-Erweiterung *
12 * -------------------------------------------------------------------- *
14 * -------------------------------------------------------------------- *
15 * Copyright (c) 2003 - 2008 by Roland Haeder *
16 * For more information visit: http://www.mxchange.org *
18 * This program is free software; you can redistribute it and/or modify *
19 * it under the terms of the GNU General Public License as published by *
20 * the Free Software Foundation; either version 2 of the License, or *
21 * (at your option) any later version. *
23 * This program is distributed in the hope that it will be useful, *
24 * but WITHOUT ANY WARRANTY; without even the implied warranty of *
25 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
26 * GNU General Public License for more details. *
28 * You should have received a copy of the GNU General Public License *
29 * along with this program; if not, write to the Free Software *
30 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, *
32 ************************************************************************/
34 // Some security stuff...
35 if (!defined('__SECURITY')) {
36 $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
41 function REGISTER_FILL_MUST_CONSTANTS()
43 $result = SQL_QUERY("SELECT field_name, field_required FROM "._MYSQL_PREFIX."_must_register ORDER BY id", __FILE__, __LINE__);
44 while(list($name, $required) = SQL_FETCHROW($result))
47 if ($required == "Y") $value = "<FONT class=\\\"guest_failed\\\"> (*)</FONT>";
48 $eval = "define('MUST_".strtoupper($name)."', \"".$value."\");";
53 SQL_FREERESULT($result);
55 // Also fill other constants
56 define('MUST_GENDER', "<FONT class=\"guest_failed\"> (*)</FONT>");
57 define('MUST_ADDY' , "<FONT class=\"guest_failed\"> (*)</FONT>");
58 define('MUST_BIRTH' , "<FONT class=\"guest_failed\"> (*)</FONT>");
59 define('MUST_MARKER', "<FONT class=\"guest_failed\"> (*)</FONT>");
62 function REGISTER_CHECK_REQUIRED_FIELDS(&$array)
65 foreach ($array as $key => $value)
67 $result = SQL_QUERY("SELECT field_required FROM "._MYSQL_PREFIX."_must_register WHERE field_name='".$key."' LIMIT 1", __FILE__, __LINE__);
68 if (SQL_NUMROWS($result) == 1)
71 list($chk) = SQL_FETCHROW($result);
72 SQL_FREERESULT($result);
74 // Check if extension country is not found (you have to enter the 2-chars long country code) or
75 // if extensions is present check if country code was selected
76 // 01 2 21 12 3 32 234 5 54 4 43 34 4 4 5 5432 2 3 3210
77 $country = ((!EXT_IS_ACTIVE("country")) || ((EXT_IS_ACTIVE("country")) && (((empty($value)) && ($key == "cntry")) || (($key == "country_code") && (!empty($value)))) && (!empty($array['country_code']))));
78 if ((empty($value)) && ($chk == "Y") && (!$country))
80 // Required field not set
89 function REGISTER_OUTPUT_REQUIRE_CHECK(&$array)
91 $result = SQL_QUERY("SELECT field_name, field_required FROM "._MYSQL_PREFIX."_must_register ORDER BY id", __FILE__, __LINE__);
92 while(list($name, $required) = SQL_FETCHROW($result))
94 if (($array[$name] == "!") && ($required == "Y"))
98 $eval = "\$OUT = REGISTER_".strtoupper($name)."_REQUIRED;";
100 OUTPUT_HTML("<STRONG><SPAN class=\"register_failed\">".$OUT."</SPAN></STRONG><br /><br />");
105 SQL_FREERESULT($result);
108 function REGISTER_ADD_CATEGORY_TABLE ($MODE, $return=false)
110 global $_POST, $_CONFIG;
113 // Guests are mostly not interested in how many members has
114 // choosen an individual category
115 $AND = "WHERE visible='Y' ";
116 // Admins are allowed to see every category...
117 if (IS_ADMIN()) $AND = "";
118 $result = SQL_QUERY("SELECT id, cat, visible FROM "._MYSQL_PREFIX."_cats ".$AND." ORDER BY sort", __FILE__, __LINE__);
119 if (SQL_NUMROWS($result) > 0)
121 // List alle visible modules (or all to the admin)
123 $OUT .= "<TABLE border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"100%\">\n";
124 while (list($id, $cat, $visible) = SQL_FETCHROW($result))
126 if (empty($_POST['cat'][$id])) $_POST['cat'][$id] = "";
127 // Prepare array for the template
136 if (($_POST['cat'][$id] == "Y") || (($_CONFIG['register_default'] == "Y") && (empty($_POST['cat'][$id])))) {
137 $content['def_y'] = " checked=\"checked\"";
139 $content['def_n'] = " checked=\"checked\"";
142 // Load template and switch color
143 $OUT .= LOAD_TEMPLATE("guest_cat_row", true, $content);
146 $OUT .= "</TABLE>\n";
149 SQL_FREERESULT($result);
153 // No categories setted up so far...
154 $OUT .= LOAD_TEMPLATE("admin_settings_saved", true, NO_CATEGORIES_VISIBLE);
159 // Return generated HTML code
164 // Output directly (default)