Files
Testing/include/class_field.php

1344 lines
67 KiB
PHP
Raw Permalink Normal View History

2026-11-17 16:15:01 -05:00
<?php
/* $Id: class_field.php 159 2009-04-11 01:18:28Z john $ */
// THIS CLASS CONTAINS FIELD-RELATED METHODS.
// IT IS USED DURING THE CREATION, MODIFICATION AND DELETION OF FIELDS
// METHODS IN THIS CLASS:
// se_field()
// cat_list()
// field_list()
// field_get()
// field_save()
// field_delete()
// cat_delete()
// cat_modify()
class se_field {
// INITIALIZE VARIABLES
var $is_error; // DETERMINES WHETHER THERE IS AN ERROR OR NOT, CONTAINS RELEVANT ERROR CODE
var $type; // CONTAINS THE FIELD TYPE (PROFILE, PLUGIN-RELATED, ETC)
var $value_info; // CONTAINS THE VALUE INFO OF THE SPECIFIC OBJECT
var $cats; // CONTAINS ARRAY OF FIELD CATEGORIES WITH CORRESPONDING FIELD ARRAYS
var $subcats; // CONTAINS ARRAY OF FIELD SUB-CATEGORIES WITH CORRESPONDING FIELD ARRAYS
var $fields; // CONTAINS ARRAY OF FIELDS FROM CAT SPECIFIED
var $fields_new; // CONTAINS ARRAY OF NEW (UNSAVED) FIELD VALUES
var $field_query; // CONTAINS A PARTIAL DATABASE QUERY TO SAVE/RETRIEVE FIELD VALUES
var $field_values; // CONTAINS AN ARRAY OF FORMATTED FIELD VALUES (USED FOR GLOBAL META DESCRIPTIONS)
var $fields_all; // CONTAINS ARRAY OF FIELDS FROM ALL LOOPED CATS
var $url_string; // CONTAINS VARIOUS PARTIAL URL STRINGS (SITUATION DEPENDENT)
var $field_special; // CONTAINS VALUES FOR SPECIAL FIELDS
// THIS METHOD SETS INITIAL VARS (SUCH AS FIELD TYPE)
// INPUT: $type REPRESENTING THE TYPE OF FIELD (PROFILE, PLUGIN-RELATED, ETC)
// $value_info (OPTIONAL) REPRESENTING THE VALUE INFO FOR THE GIVEN TYPE
// OUTPUT:
function __construct($type, $value_info = "") {
$this->type = $type;
$this->value_info = $value_info;
} // END se_field() METHOD
// THIS METHOD LOOPS AND/OR VALIDATES FIELD INPUT AND CREATES A PARTIAL QUERY TO UPDATE VALUE TABLE
// INPUT: $validate (OPTIONAL) REPRESENTING A BOOLEAN THAT DETERMINES WHETHER TO VALIDATE POST VARS OR NOT
// $format (OPTIONAL) REPRESENTING A BOOLEAN THAT DETERMINES WHETHER TO CREATE FORMATTED FIELD VALUES
// $search (OPTIONAL) REPRESENTING WHETHER TO CREATE A SEARCH QUERY OR NOT
// $cat_where (OPTIONAL) REPRESENTING A WHERE CLAUSE FOR THE CATEGORY QUERY
// $subcat_where (OPTIONAL) REPRESENTING A WHERE CLAUSE FOR THE SUBCATEGORY QUERY
// $field_where (OPTIONAL) REPRESENTING A WHERE CLAUSE FOR THE FIELD QUERY
// OUTPUT:
function cat_list($validate = 0, $format = 0, $search = 0, $cat_where = "", $subcat_where = "", $field_where = "") {
global $database, $datetime, $setting;
// SET CATEGORY VARIABLES
$this->fields_all = Array();
$cat_query = "SELECT ".$this->type."cat_id AS cat_id, ".$this->type."cat_title AS cat_title, ".$this->type."cat_order AS cat_order, ".$this->type."cat_signup AS cat_signup FROM se_".$this->type."cats WHERE ".$this->type."cat_dependency='0'";
if($cat_where != "") { $cat_query .= " AND ($cat_where)"; }
$cat_query .= " ORDER BY ".$this->type."cat_order";
$cats = $database->database_query($cat_query);
// LOOP THROUGH CATS
while($cat_info = $database->database_fetch_assoc($cats)) {
// GET LIST OF FIELDS
$cat_fields = "";
$new_field_where = $this->type."field_".$this->type."cat_id='".$cat_info["cat_id"]."'";
if($field_where != "") { $new_field_where .= " AND ($field_where)"; }
$this->field_list($validate, $format, $search, $new_field_where);
$cat_fields = $this->fields;
// GET DEPENDENT CATS
$this->subcats = array();
$subcat_query = "SELECT ".$this->type."cat_id AS cat_id, ".$this->type."cat_title AS cat_title, ".$this->type."cat_order AS cat_order FROM se_".$this->type."cats WHERE ".$this->type."cat_dependency='".$cat_info["cat_id"]."'"; if($subcat_where != "") { $subcat_query .= " AND ($subcat_where)"; } $subcat_query .= " ORDER BY ".$this->type."cat_order";
$subcats = $database->database_query($subcat_query);
// LOOP THROUGH SUBCATS
while($subcat_info = $database->database_fetch_assoc($subcats)) {
// GET LIST OF FIELDS
$new_field_where = $this->type."field_".$this->type."cat_id='".$subcat_info["cat_id"]."'";
if($field_where != "") { $new_field_where .= " AND ($field_where)"; }
$this->field_list($validate, $format, $search, $new_field_where);
// SET CAT ARRAY
if($format == 0 || ($format == 1 && count($this->fields) != 0)) {
SE_Language::_preload($subcat_info["cat_title"]);
$this->subcats[] = Array('subcat_id' => $subcat_info["cat_id"],
'subcat_title' => $subcat_info["cat_title"],
'subcat_order' => $subcat_info["cat_order"],
'subcat_signup' => $subcat_info["cat_signup"],
'fields' => $this->fields);
}
}
// SET CAT ARRAY
SE_Language::_preload($cat_info["cat_title"]);
$this->cats[] = Array('cat_id' => $cat_info["cat_id"],
'cat_title' => $cat_info["cat_title"],
'cat_order' => $cat_info["cat_order"],
'cat_signup' => $cat_info["cat_signup"],
'fields' => $cat_fields,
'subcats' => $this->subcats);
}
} // END cat_list() METHOD
// THIS METHOD LOOPS AND/OR VALIDATES FIELD INPUT AND CREATES A PARTIAL QUERY TO UPDATE VALUE TABLE
// INPUT: $validate (OPTIONAL) REPRESENTING A BOOLEAN THAT DETERMINES WHETHER TO VALIDATE POST VARS OR NOT
// $format (OPTIONAL) REPRESENTING A BOOLEAN THAT DETERMINES WHETHER TO CREATE FORMATTED FIELD VALUES
// $search (OPTIONAL) REPRESENTING WHETHER TO CREATE A SEARCH QUERY OR NOT
// $field_where (OPTIONAL) REPRESENTING A WHERE CLAUSE FOR THE FIELD QUERY
// OUTPUT:
function field_list($validate = 0, $format = 0, $search = 0, $field_where = "") {
global $database, $datetime, $setting;
// GET NON DEPENDENT FIELDS IN CAT IF NECESSARY
$field_count = 0;
$this->fields = Array();
$field_query = "SELECT ".$this->type."field_id AS field_id, ".$this->type."field_order AS field_order, ".$this->type."field_title AS field_title, ".$this->type."field_desc AS field_desc, ".$this->type."field_signup AS field_signup, ".$this->type."field_error AS field_error, ".$this->type."field_type AS field_type, ".$this->type."field_style AS field_style, ".$this->type."field_maxlength AS field_maxlength, ".$this->type."field_link AS field_link, ".$this->type."field_options AS field_options, ".$this->type."field_required AS field_required, ".$this->type."field_regex AS field_regex, ".$this->type."field_special AS field_special, ".$this->type."field_html AS field_html, ".$this->type."field_search AS field_search, ".$this->type."field_display AS field_display FROM se_".$this->type."fields WHERE ".$this->type."field_dependency='0'"; if($field_where != "") { $field_query .= " AND ($field_where)"; } $field_query .= " ORDER BY ".$this->type."field_order";
$fields = $database->database_query($field_query);
while($field_info = $database->database_fetch_assoc($fields)) {
// SET FIELD VARS
$is_field_error = 0;
$field_value = "";
$field_value_formatted = "";
$field_value_min = "";
$field_value_max = "";
$field_options = Array();
// FIELD TYPE SWITCH
switch($field_info["field_type"]) {
case 1: // TEXT FIELD
case 2: // TEXTAREA
// VALIDATE POSTED FIELD VALUE
if($validate == 1) {
// RETRIEVE POSTED FIELD VALUE AND FILTER FOR ADMIN-SPECIFIED HTML TAGS
$var = "field_".$field_info["field_id"];
$_POST["field_41"]=str_replace("/", "", $_POST["field_41"]);
$_POST["field_33"]=str_replace("/", "", $_POST["field_33"]);
$_POST["field_34"]=str_replace("/", "", $_POST["field_34"]);
$_POST["field_35"]=str_replace("/", "", $_POST["field_35"]);
$_POST["field_36"]=str_replace("/", "", $_POST["field_36"]);
$_POST["field_37"]=str_replace("/", "", $_POST["field_37"]);
$_POST["field_38"]=str_replace("/", "", $_POST["field_38"]);
$_POST["field_39"]=str_replace("/", "", $_POST["field_39"]);
$_POST["field_53"]=str_replace("/", "", $_POST["field_53"]);
$_POST["field_54"]=str_replace("/", "", $_POST["field_54"]);
$_POST["field_55"]=str_replace("/", "", $_POST["field_55"]);
if($field_info["field_id"]==41||$field_info["field_id"]==33||$field_info["field_id"]==34||$field_info["field_id"]==35||$field_info["field_id"]==36||$field_info["field_id"]==37||$field_info["field_id"]==38||$field_info["field_id"]==39||$field_info["field_id"]==53||$field_info["field_id"]==54||$field_info["field_id"]==55){
$field_value = security(cleanHTML($_POST[$var], $field_info["field_html"]));
}
else{
$field_value = security(cleanHTML(censor($_POST[$var]), $field_info["field_html"]));
}
if($field_info["field_type"] == 2) { $field_value = str_replace("\r\n", "<br>", $field_value); }
// CHECK FOR REQUIRED
if($field_info["field_required"] != 0 && trim($field_value) == "") {
$this->is_error = 96;
$is_field_error = 1;
}
// RUN PREG MATCH (ONLY FOR TEXT FIELDS)
if($field_info["field_regex"] != "" && trim($field_value) != "") {
if(!preg_match($field_info["field_regex"], $field_value)) {
$this->is_error = 97;
$is_field_error = 1;
}
}
// UPDATE SAVE VALUE QUERY
if($this->field_query != "") { $this->field_query .= ", "; }
if($field_info["field_special"] == 2 || $field_info["field_special"] == 3) { $field_value = ucwords($field_value); }
$this->field_query .= $this->type."value_{$field_info["field_id"]}='$field_value'";
// CREATE A SEARCH QUERY FROM POSTED FIELD VALUE
} elseif($search == 1) {
if($field_info["field_search"] == 2) {
$var1 = "field_".$field_info["field_id"]."_min";
if(isset($_POST[$var1])) { $field_value_min = $_POST[$var1]; } elseif(isset($_GET[$var1])) { $field_value_min = $_GET[$var1]; } else { $field_value_min = ""; }
$var2 = "field_".$field_info["field_id"]."_max";
if(isset($_POST[$var2])) { $field_value_max = $_POST[$var2]; } elseif(isset($_GET[$var2])) { $field_value_max = $_GET[$var2]; } else { $field_value_max = ""; }
if($field_value_min != "") {
if($this->field_query != "") { $this->field_query .= " AND "; }
$this->field_query .= $this->type."value_{$field_info["field_id"]} >= $field_value_min";
$this->url_string .= $var1."=".urlencode($field_value_min)."&";
}
if($field_value_max != "") {
if($this->field_query != "") { $this->field_query .= " AND "; }
$this->field_query .= $this->type."value_{$field_info["field_id"]} <= $field_value_max";
$this->url_string .= $var2."=".urlencode($field_value_max)."&";
}
} elseif($field_info["field_search"] == 1) {
$var = "field_".$field_info["field_id"];
if(isset($_POST[$var])) { $field_value = $_POST[$var]; } elseif(isset($_GET[$var])) { $field_value = $_GET[$var]; } else { $field_value = ""; }
if($field_value != "") {
if($this->field_query != "") { $this->field_query .= " AND "; }
$this->field_query .= $this->type."value_{$field_info["field_id"]} LIKE '%$field_value%'";
$this->url_string .= $var."=".urlencode($field_value)."&";
}
} else {
$field_value = "";
}
// DO NOT VALIDATE FIELD VALUE AND DON'T CREATE SEARCH VALUE
} else {
// RETRIEVE DATABASE FIELD VALUE
if($this->value_info != "") {
$value_column = $this->type."value_".$field_info["field_id"];
$field_value = $this->value_info[$value_column];
}
}
// FORMAT VALUE FOR DISPLAY
if($format == 1 && $field_info["field_display"] != 0) {
// LINK BROWSABLE FIELD VALUES IF NECESSARY
if($field_info["field_display"] == 2) {
$br_exploded_field_values = explode("<br>", trim($field_value));
$exploded_field_values = Array();
foreach($br_exploded_field_values as $key => $value) {
$comma_exploded_field_values = explode(",", trim($value));
array_walk($comma_exploded_field_values, 'link_field_values', Array($field_info["field_id"], "", $field_info["field_link"], $field_info["field_display"]));
$exploded_field_values[$key] = implode(", ", $comma_exploded_field_values);
}
$field_value_formatted = implode("<br>", $exploded_field_values);
// MAKE SURE TO LINK FIELDS WITH A LINK TAG
} else {
$exploded_field_values = Array(trim($field_value));
array_walk($exploded_field_values, 'link_field_values', Array($field_info["field_id"], "", $field_info["field_link"], $field_info["field_display"]));
$field_value_formatted = implode("", $exploded_field_values);
}
// DECODE TO MAKE HTML TAGS FOR FIELDS VALID
$field_value_formatted = htmlspecialchars_decode($field_value_formatted, ENT_QUOTES);
// FORMAT VALUE FOR FORM
} else {
if($field_info["field_type"] == 1) {
$options = unserialize($field_info["field_options"]);
if(is_array($options)){
for($i=0,$max=count($options);$i<$max;$i++) {
(new SE_Language())->_preload_multi($options[$i]["label"]);
//SE_Language::_preload_multi($options[$i][label]);
SE_Language::load();
$field_options[] = Array('label'=>SE_Language::_get($options[$i]["label"]));
}
}
}
if($field_info["field_type"] == 2) { $field_value = str_replace("<br>", "\r\n", $field_value); }
}
break;
case 3: // SELECT BOX
case 4: // RADIO BUTTON
// VALIDATE POSTED FIELD
if($validate == 1) {
// RETRIEVE POSTED FIELD VALUE
$var = "field_".$field_info["field_id"];
$field_value = censor($_POST[$var]);
// CHECK FOR REQUIRED
if($field_info["field_required"] != 0 && ($field_value == "-1" || $field_value == "")) {
$this->is_error = 96;
$is_field_error = 1;
}
// UPDATE SAVE VALUE QUERY
if($this->field_query != "") { $this->field_query .= ", "; }
$this->field_query .= $this->type."value_{$field_info["field_id"]}='$field_value'";
// CREATE A SEARCH QUERY FROM POSTED FIELD VALUE
} elseif($search == 1) {
if($field_info["field_search"] == 2) {
$var1 = "field_".$field_info["field_id"]."_min";
if(isset($_POST[$var1])) { $field_value_min = $_POST[$var1]; } elseif(isset($_GET[$var1])) { $field_value_min = $_GET[$var1]; } else { $field_value_min = ""; }
$var2 = "field_".$field_info["field_id"]."_max";
if(isset($_POST[$var2])) { $field_value_max = $_POST[$var2]; } elseif(isset($_GET[$var2])) { $field_value_max = $_GET[$var2]; } else { $field_value_max = ""; }
if($field_value_min != "" && $field_value_min != "-1") {
if($this->field_query != "") { $this->field_query .= " AND "; }
$this->field_query .= $this->type."value_{$field_info["field_id"]} >= $field_value_min";
$this->url_string .= $var1."=".urlencode($field_value_min)."&";
}
if($field_value_max != "" && $field_value_max != "-1") {
if($this->field_query != "") { $this->field_query .= " AND "; }
$this->field_query .= $this->type."value_{$field_info["field_id"]} <= $field_value_max";
$this->url_string .= $var2."=".urlencode($field_value_max)."&";
}
} elseif($field_info["field_search"] == 1) {
$var = "field_".$field_info["field_id"];
if(isset($_POST[$var])) { $field_value = $_POST[$var]; } elseif(isset($_GET[$var])) { $field_value = $_GET[$var]; } else { $field_value = ""; }
if($field_value != "-1" && $field_value != "") {
if($this->field_query != "") { $this->field_query .= " AND "; }
$this->field_query .= $this->type."value_{$field_info["field_id"]}='$field_value'";
$this->url_string .= $var."=".urlencode($field_value)."&";
}
} else {
$field_value = "";
}
// DO NOT VALIDATE FIELD VALUE AND DON'T CREATE SEARCH VALUE
} else {
// RETRIEVE DATABASE FIELD VALUE
if($this->value_info != "") {
$value_column = $this->type."value_".$field_info["field_id"];
$field_value = $this->value_info[$value_column];
}
}
// LOOP OVER FIELD OPTIONS
$options = unserialize($field_info["field_options"]);
if(is_array($options)){
for($i=0,$max=count($options);$i<$max;$i++) {
$dep_field_info = array();
$dep_field_value = "";
$dep_field_options = array();
// OPTION HAS DEPENDENCY
if($options[$i]["dependency"] == "1") {
$dep_field_query = "SELECT ".$this->type."field_id AS field_id, ".$this->type."field_type AS field_type, ".$this->type."field_title AS field_title, ".$this->type."field_style AS field_style, ".$this->type."field_options AS field_options, ".$this->type."field_maxlength AS field_maxlength, ".$this->type."field_link AS field_link, ".$this->type."field_required AS field_required, ".$this->type."field_regex AS field_regex, ".$this->type."field_display AS field_display FROM se_".$this->type."fields WHERE ".$this->type."field_id='".$options[$i]["dependent_id"]."' AND ".$this->type."field_dependency='{$field_info["field_id"]}'";
$dep_field = $database->database_query($dep_field_query);
if($database->database_num_rows($dep_field) != "1") {
$options[$i]["dependency"] = 0;
} else {
$dep_field_info = $database->database_fetch_assoc($dep_field);
// VALIDATE POSTED FIELD VALUE
if($validate == 1) {
// OPTION SELECTED
if($field_value == $options[$i]["value"]) {
$dep_var = "field_".$dep_field_info["field_id"];
$dep_field_value = censor($_POST[$dep_var]);
// DEP FIELD TYPE
switch($dep_field_info["field_type"]) {
// TEXT FIELD
case "1":
// CHECK FOR REQUIRED
if($dep_field_info["field_required"] != 0 && trim($dep_field_value) == "") {
$this->is_error = 96;
$is_field_error = 1;
}
// RUN PREG MATCH
if($dep_field_info["field_regex"] != "" && trim($dep_field_value) != "") {
if(!preg_match($dep_field_info["field_regex"], $dep_field_value)) {
$this->is_error = 97;
$is_field_error = 1;
}
}
break;
// SELECT BOX
case "3":
// CHECK FOR REQUIRED
if( $dep_field_info['field_required'] != 0 && ($dep_field_value == "-1" || $dep_field_value == "") )
{
$this->is_error = 96;
$is_field_error = 1;
}
break;
}
// OPTION NOT SELECTED
} else {
$dep_field_value = "";
}
// UPDATE SAVE VALUE QUERY
if($this->field_query != "") { $this->field_query .= ", "; }
$this->field_query .= $this->type."value_{$dep_field_info["field_id"]}='$dep_field_value'";
// DO NOT VALIDATE POSTED FIELD VALUE
} else {
// RETRIEVE DATABASE FIELD VALUE
if($this->value_info != "") {
$value_column = $this->type."value_".$dep_field_info["field_id"];
$dep_field_value = $this->value_info[$value_column];
}
}
// RETRIEVE DEP FIELD OPTIONS
$dep_options = unserialize($dep_field_info["field_options"]);
if(is_array($dep_options)){
for($i2=0,$max2=count($dep_options);$i2<$max2;$i2++) {
SE_Language::_preload($dep_options[$i2]["label"]);
$dep_field_options[] = Array('value' => $dep_options[$i2]["value"],
'label' => $dep_options[$i2]["label"]);
if($dep_options[$i2]["value"] == $dep_field_value) { $dep_field_value_formatted = $dep_options[$i2]["label"]; }
}
}
}
}
// FORMAT VALUE FOR DISPLAY IF OPTION IS SELECTED
if($format == 1 && $field_value == $options[$i]["value"] && $field_info["field_display"] != 0) {
SE_Language::_preload_multi($dep_field_info["field_title"], $options[$i]["label"]);
SE_Language::load();
$field_value_formatted = SE_Language::_get($options[$i]["label"]);
// LINK FIELD VALUES IF NECESSARY
if($field_info["field_display"] == 2) {
link_field_values($field_value_formatted, "", Array($field_info["field_id"], $options[$i]["value"], "", $field_info["field_display"]));
}
// ADD DEPENDENT VALUE TO FIELD VALUE
if($dep_field_value != "" && $dep_field_info["field_display"] != 0) {
if($dep_field_info["field_type"] == 3) { $dep_field_value_formatted = SE_Language::_get($dep_field_value_formatted); } else { $dep_field_value_formatted = $dep_field_value; }
link_field_values($dep_field_value_formatted, "", Array($dep_field_info["field_id"], $dep_field_value, $dep_field_info["field_link"], $dep_field_info["field_display"]));
$field_value_formatted .= "</span></td></tr><tr><td><span class='key'>".SE_Language::_get($dep_field_info["field_title"]).":</span></td><td><span class='key'>".$dep_field_value_formatted;
}
}
// SET OPTIONS ARRAY
SE_Language::_preload_multi($dep_field_info["field_title"], $options[$i]["label"]);
$field_options[] = Array('value' => $options[$i]["value"],
'label' => $options[$i]["label"],
'dependency' => $options[$i]["dependency"],
'dep_field_id' => $dep_field_info["field_id"],
'dep_field_title' => $dep_field_info["field_title"],
'dep_field_type' => $dep_field_info["field_type"],
'dep_field_required' => $dep_field_info["field_required"],
'dep_field_maxlength' => $dep_field_info["field_maxlength"],
'dep_field_options' => $dep_field_options,
'dep_field_style' => $dep_field_info["field_style"],
'dep_field_value' => $dep_field_value,
'dep_field_error' => $dep_field_error);
}
}
break;
case 5: // DATE FIELD
// SET MONTH, DAY, AND YEAR FORMAT FROM SETTINGS
switch($setting["setting_dateformat"]) {
case "n/j/Y": case "n.j.Y": case "n-j-Y": $month_format = "n"; $day_format = "j"; $year_format = "Y"; $date_order = "mdy"; break;
case "Y/n/j": case "Ynj": $month_format = "n"; $day_format = "j"; $year_format = "Y"; $date_order = "ymd"; break;
case "Y-n-d": $month_format = "n"; $day_format = "d"; $year_format = "Y"; $date_order = "ymd"; break;
case "Y-m-d": $month_format = "m"; $day_format = "d"; $year_format = "Y"; $date_order = "ymd"; break;
case "j/n/Y": case "j.n.Y": $month_format = "n"; $day_format = "j"; $year_format = "Y"; $date_order = "dmy"; break;
case "M. j, Y": $month_format = "M"; $day_format = "j"; $year_format = "Y"; $date_order = "mdy"; break;
case "F j, Y": case "l, F j, Y": $month_format = "F"; $day_format = "j"; $year_format = "Y"; $date_order = "mdy"; break;
case "j F Y": case "D j F Y": case "l j F Y": $month_format = "F"; $day_format = "j"; $year_format = "Y"; $date_order = "dmy"; break;
case "D-j-M-Y": case "D j M Y": case "j-M-Y": $month_format = "M"; $day_format = "j"; $year_format = "Y"; $date_order = "dmy"; break;
case "Y-M-j": $month_format = "M"; $day_format = "j"; $year_format = "Y"; $date_order = "ymd"; break;
}
// VALIDATE POSTED VALUE
if($validate == 1) {
// RETRIEVE POSTED FIELD VALUE
$var1 = "field_".$field_info["field_id"]."_1";
$var2 = "field_".$field_info["field_id"]."_2";
$var3 = "field_".$field_info["field_id"]."_3";
$field_1 = $_POST[$var1];
$field_2 = $_POST[$var2];
$field_3 = $_POST[$var3];
// ORDER DATE VALUES PROPERLY
switch($date_order) {
case "mdy": $month = $field_1; $day = $field_2; $year = $field_3; break;
case "ymd": $year = $field_1; $month = $field_2; $day = $field_3; break;
case "dmy": $day = $field_1; $month = $field_2; $year = $field_3; break;
}
// CONSTRUCT FIELD VALUE
$field_value = str_pad($year, 4, '0', STR_PAD_LEFT)."-".str_pad($month, 2, '0', STR_PAD_LEFT).'-'.str_pad($day, 2, '0', STR_PAD_LEFT);
// CHECK FOR REQUIRED
if( $field_info['field_required'] && ($month == "00" || $day == "00" || $year == "00") )
{
$this->is_error = 96;
$is_field_error = 1;
}
// rgh : 2010-11-16
// check for date out of range
if ( $field_info['field_title'] == '500376' ) {
// this should be birthday
$bdaycheck = mktime( 0, 0, 0, $month, $day, $year );
$now=time();
if ( $now-$bdaycheck < (18*365.25*24*3600 ) ){
$this->is_error = 11010856;
$is_field_error = 1;
}
}
// UPDATE SAVE VALUE QUERY
if($this->field_query != "") { $this->field_query .= ", "; }
$this->field_query .= $this->type."value_{$field_info["field_id"]}='$field_value'";
// CREATE A SEARCH QUERY FROM POSTED FIELD VALUE
} elseif($search == 1) {
// DATE IS A BIRTHDAY
if($field_info["field_special"] == 1) {
// RESET DATE ORDER SO MONTH IS LAST
$date_order = "mdy";
// RETRIEVE MIN/MAX YEARS
$var3_min = "field_".$field_info["field_id"]."_3_min";
$var3_max = "field_".$field_info["field_id"]."_3_max";
if(isset($_POST[$var3_min])) { $field_3_min = $_POST[$var3_min]; } elseif(isset($_GET[$var3_min])) { $field_3_min = $_GET[$var3_min]; } else { $field_3_min = ""; }
if(isset($_POST[$var3_max])) { $field_3_max = $_POST[$var3_max]; } elseif(isset($_GET[$var3_max])) { $field_3_max = $_GET[$var3_max]; } else { $field_3_max = ""; }
$this->url_string .= $var3_min."=".urlencode($field_3_min)."&";
$this->url_string .= $var3_max."=".urlencode($field_3_max)."&";
// CONSTRUCT SEARCH VALUES (MIN YEAR)
// IMPORTANT NOTE - BECAUSE IT DISPLAYS THE AGE (NOT THE YEAR) TO THE SEARCHER, THIS ACTUALLY CORRESPONDS TO THE MINIMUM AGE (MAXIMUM YEAR)
$field_value_min = str_pad($field_3_min, 4, '0', STR_PAD_LEFT);
if($field_value_min != "0000") {
if($this->field_query != "") { $this->field_query .= " AND "; }
$this->field_query .= $this->type."value_{$field_info["field_id"]}<='$field_value_min-".date('m', time())."-".date('d', time())."'";
}
// CONSTRUCT SEARCH VALUES (MAX YEAR)
// IMPORTANT NOTE - BECAUSE IT DISPLAYS THE AGE (NOT THE YEAR) TO THE SEARCHER, THIS ACTUALLY CORRESPONDS TO THE MAXIMUM AGE (MINIMUM YEAR)
$field_value_max = str_pad($field_3_max, 4, '0', STR_PAD_LEFT);
if($field_value_max != "0000") {
if($this->field_query != "") { $this->field_query .= " AND "; }
$this->field_query .= $this->type."value_{$field_info["field_id"]}>=DATE_ADD('".($field_value_max-1)."-".date('m', time())."-".date('d', time())."', INTERVAL 1 DAY)";
}
// EXCLUDE USERS WHO HAVE NOT ENTERED A BIRTH YEAR
if($field_value_min != "0000" || $field_value_max != "0000") {
if($this->field_query != "") { $this->field_query .= " AND "; }
$this->field_query .= "YEAR(".$this->type."value_{$field_info["field_id"]})<>'0000'";
}
// DATE IS NOT A BIRTHDAY
} else {
// RETRIEVE VALUES
$var1 = "field_".$field_info["field_id"]."_1";
$var2 = "field_".$field_info["field_id"]."_2";
$var3 = "field_".$field_info["field_id"]."_3";
if(isset($_POST[$var1])) { $field_1 = $_POST[$var1]; } elseif(isset($_GET[$var1])) { $field_1 = $_GET[$var1]; } else { $field_1 = ""; }
if(isset($_POST[$var2])) { $field_2 = $_POST[$var2]; } elseif(isset($_GET[$var2])) { $field_2 = $_GET[$var2]; } else { $field_2 = ""; }
if(isset($_POST[$var3])) { $field_3 = $_POST[$var3]; } elseif(isset($_GET[$var3])) { $field_3 = $_GET[$var3]; } else { $field_3 = ""; }
$this->url_string .= $var1."=".urlencode($field_1)."&";
$this->url_string .= $var2."=".urlencode($field_2)."&";
$this->url_string .= $var3."=".urlencode($field_3)."&";
// ORDER DATE VALUES PROPERLY
switch($date_order) {
case "mdy": $month = str_pad($field_1, 2, '0', STR_PAD_LEFT); $day = str_pad($field_2, 2, '0', STR_PAD_LEFT); $year = str_pad($field_3, 4, '0', STR_PAD_LEFT); break;
case "ymd": $year = str_pad($field_1, 4, '0', STR_PAD_LEFT); $month = str_pad($field_2, 2, '0', STR_PAD_LEFT); $day = str_pad($field_3, 2, '0', STR_PAD_LEFT); break;
case "dmy": $day = str_pad($field_1, 2, '0', STR_PAD_LEFT); $month = str_pad($field_2, 2, '0', STR_PAD_LEFT); $year = str_pad($field_3, 4, '0', STR_PAD_LEFT); break;
}
// CONSTRUCT FIELD VALUE
$field_value = $year."-".$month.'-'.$day;
if($month != "00") {
if($this->field_query != "") { $this->field_query .= " AND "; }
$this->field_query .= "MONTH(".$this->type."value_{$field_info["field_id"]})='$month'";
}
if($day != "00") {
if($this->field_query != "") { $this->field_query .= " AND "; }
$this->field_query .= "DAY(".$this->type."value_{$field_info["field_id"]})='$day'";
}
if($year != "0000") {
if($this->field_query != "") { $this->field_query .= " AND "; }
$this->field_query .= "YEAR(".$this->type."value_{$field_info["field_id"]})='$year'";
}
}
// DO NOT VALIDATE FIELD VALUE AND DON'T CREATE SEARCH VALUE
} else {
// RETRIEVE DATABASE FIELD VALUE
if($this->value_info != "") {
$value_column = $this->type."value_".$field_info["field_id"];
$field_value = $this->value_info[$value_column];
} else {
$field_value = "0000-00-00";
}
}
$year = substr($field_value, 0, 4);
$month = substr($field_value, 5, 2);
$day = substr($field_value, 8, 2);
// FORMAT VALUE FOR DISPLAY
if($format == 1 && $field_info["field_display"] != 0) {
if($field_value != "0000-00-00") {
if($year == "0000") { $year = ""; }
if($month == "00") { $month = ""; } else { $month = $datetime->cdate("F", mktime(0, 0, 0, $month, 1, 1990)); }
if($day == "00") { $day = ""; } else { $day = $datetime->cdate("$day_format", mktime(0, 0, 0, 1, $day, 1990)); }
if($field_info['field_title'] == '500376'){
if($field_where=="profilefield_profilecat_id='3'")
{
global $owner;
if($owner->profile_info["profilevalue_26"]==1)
{
switch($date_order) {
case "mdy": $field_value_formatted = "$month $day"; break;
case "ymd": $field_value_formatted = "$month $day"; break;
case "dmy": $field_value_formatted = "$day $month"; break;
}
}else
{
//if(SE_DEBUG){
switch($date_order) {
case "mdy": $field_value_formatted = "$month $day"; break;
case "ymd": $field_value_formatted = "$month $day"; break;
case "dmy": $field_value_formatted = "$day $month"; break;
}
/*
}else{
switch($date_order) {
case "mdy": $field_value_formatted = "$month $day $year"; break;
case "ymd": $field_value_formatted = "$year $month $day"; break;
case "dmy": $field_value_formatted = "$day $month $year"; break;
}
}*/
}
}}else{switch($date_order) {
case "mdy": $field_value_formatted = "$month $day $year"; break;
case "ymd": $field_value_formatted = "$year $month $day"; break;
case "dmy": $field_value_formatted = "$day $month $year"; break;
} }
if($field_info["field_display"] == 2) {
//if($_SERVER['REMOTE_ADDR']=="73.180.162.90"){
if($owner->profile_info["profilevalue_26"]==1)
{
$a=explode("-", $field_value);
$field_value="0000-".$a[1]."-".$a[2];
}
//}
link_field_values($field_value_formatted, "", Array($field_info["field_id"], $field_value, "", $field_info["field_display"])); }
}
// FORMAT VALUE FOR FORM
} else {
// GET LANGUAGE VARS
SE_Language::_preload_multi(579, 580, 581);
// CONSTRUCT MONTH ARRAY
$month_array = Array();
$month_array[0] = Array('name' => "579", 'value' => "0", 'selected' => "");
for($m=1;$m<=12;$m++) {
if($month == $m) { $selected = " SELECTED"; } else { $selected = ""; }
$month_array[$m] = Array('name' => $datetime->cdate("$month_format", mktime(0, 0, 0, $m, 1, 1990)),
'value' => $m,
'selected' => $selected);
}
// CONSTRUCT DAY ARRAY
$day_array = Array();
$day_array[0] = Array('name' => "580", 'value' => "0", 'selected' => "");
for($d=1;$d<=31;$d++) {
if($day == $d) { $selected = " SELECTED"; } else { $selected = ""; }
$day_array[$d] = Array('name' => $datetime->cdate("$day_format", mktime(0, 0, 0, 1, $d, 1990)),
'value' => $d,
'selected' => $selected);
}
// CONSTRUCT YEAR ARRAY
$year_array = Array();
$year_count = 1;
$current_year = $datetime->cdate("Y", time());
$year_array[0] = Array('name' => "581", 'value' => "0", 'selected' => "");
for($y=$current_year;$y>=1920;$y--) {
if($year == $y) { $selected = " SELECTED"; } else { $selected = ""; }
$year_array[$year_count] = Array('name' => $y,
'value' => $y,
'selected' => $selected);
$year_count++;
}
// ORDER DATE ARRAYS PROPERLY
switch($date_order) {
case "mdy": $date_array1 = $month_array; $date_array2 = $day_array; $date_array3 = $year_array; break;
case "ymd": $date_array1 = $year_array; $date_array2 = $month_array; $date_array3 = $day_array; break;
case "dmy": $date_array1 = $day_array; $date_array2 = $month_array; $date_array3 = $year_array; break;
}
}
break;
case 6: // CHECKBOXES
// VALIDATE POSTED FIELD
if($validate == 1) {
// RETRIEVE POSTED FIELD VALUE
$var = "field_".$field_info["field_id"];
$field_value = $_POST[$var];
// CHECK FOR REQUIRED
if($field_info["field_required"] != 0 && count($field_value) == 0) {
$this->is_error = 96;
$is_field_error = 1;
}
// UPDATE SAVE VALUE QUERY
if($this->field_query != "") { $this->field_query .= ", "; }
if(is_array($field_value)){
$this->field_query .= $this->type."value_{$field_info["field_id"]}='".implode(",", $field_value)."'";
}else{$this->field_query .= $this->type."value_{$field_info["field_id"]}='".$field_value."'";
}
// CREATE A SEARCH QUERY FROM POSTED FIELD VALUE
} elseif($search == 1) {
$var = "field_".$field_info["field_id"];
if(isset($_POST[$var])) { $field_value = $_POST[$var]; } elseif(isset($_GET[$var])) { $field_value = $_GET[$var]; } else { $field_value = ""; }
if(is_array($field_value) && count($field_value) != 0 && $field_value != "") {
for($o=0;$o<count($field_value);$o++) {
if($this->field_query != "") { $this->field_query .= " AND "; }
$this->field_query .= "FIND_IN_SET('".$field_value[$o]."', ".$this->type."value_{$field_info["field_id"]})";
$this->url_string .= $var."[]=".urlencode($field_value[$o])."&";
}
}
// DO NOT VALIDATE FIELD VALUE AND DON'T CREATE SEARCH VALUE
} else {
// RETRIEVE DATABASE FIELD VALUE
if($this->value_info != "") {
$value_column = $this->type."value_".$field_info["field_id"];
$field_value = explode(",", $this->value_info[$value_column]);
}
}
// LOOP OVER FIELD OPTIONS
$options = unserialize($field_info["field_options"]);
for($i=0,$max=count($options);$i<$max;$i++) {
$dep_field_info = array();
$dep_field_value = "";
$dep_field_options = "";
// OPTION HAS DEPENDENCY
if($options[$i]["dependency"] == "1") {
$dep_field_query = "SELECT ".$this->type."field_id AS field_id, ".$this->type."field_type AS field_type, ".$this->type."field_title AS field_title, ".$this->type."field_style AS field_style, ".$this->type."field_options AS field_options, ".$this->type."field_maxlength AS field_maxlength, ".$this->type."field_link AS field_link, ".$this->type."field_required AS field_required, ".$this->type."field_regex AS field_regex, ".$this->type."field_display AS field_display FROM se_".$this->type."fields WHERE ".$this->type."field_id='".$options[$i]["dependent_id"]."' AND ".$this->type."field_dependency='{$field_info["field_id"]}'";
$dep_field = $database->database_query($dep_field_query);
if($database->database_num_rows($dep_field) != "1") {
$options[$i]["dependency"] = 0;
} else {
$dep_field_info = $database->database_fetch_assoc($dep_field);
// VALIDATE POSTED FIELD VALUE
if($validate == 1) {
// OPTION SELECTED
if(in_array($options[$i]["value"], $field_value)) {
$dep_var = "field_".$dep_field_info["field_id"];
$dep_field_value = censor($_POST[$dep_var]);
// DEP FIELD TYPE
switch($dep_field_info["field_type"]) {
// TEXT FIELD
case "1":
// CHECK FOR REQUIRED
if($dep_field_info["field_required"] != 0 && trim($dep_field_value) == "") {
$this->is_error = 96;
$is_field_error = 1;
}
// RUN PREG MATCH
if($dep_field_info["field_regex"] != "" && trim($dep_field_value) != "") {
if(!preg_match($dep_field_info["field_regex"], $dep_field_value)) {
$this->is_error = 97;
$is_field_error = 1;
}
}
break;
// SELECT BOX
case "3":
// CHECK FOR REQUIRED
if( $dep_field_info['field_required'] != 0 && ($dep_field_value == "-1" || $dep_field_value == "") )
{
$this->is_error = 96;
$is_field_error = 1;
}
break;
}
// OPTION NOT SELECTED
} else {
$dep_field_value = "";
}
// UPDATE SAVE VALUE QUERY
if($this->field_query != "") { $this->field_query .= ", "; }
$this->field_query .= $this->type."value_{$dep_field_info["field_id"]}='$dep_field_value'";
// DO NOT VALIDATE POSTED FIELD VALUE
} else {
// RETRIEVE DATABASE FIELD VALUE
if($this->value_info != "") {
$value_column = $this->type."value_".$dep_field_info["field_id"];
$dep_field_value = $this->value_info[$value_column];
}
}
// RETRIEVE DEP FIELD OPTIONS
$dep_options = unserialize($dep_field_info["field_options"]);
for($i2=0,$max2=count($dep_options);$i2<$max2;$i2++) {
SE_Language::_preload($dep_options[$i2]["label"]);
$dep_field_options[] = Array('value' => $dep_options[$i2]["value"],
'label' => $dep_options[$i2][label]);
if($dep_options[$i2][value] == $dep_field_value) { $dep_field_value_formatted = $dep_options[$i2]["label"]; }
}
}
}
// FORMAT VALUE FOR DISPLAY IF OPTION IS SELECTED
if((is_array($field_value) && $format == 1 && in_array($options[$i]["value"], $field_value)) && $field_info["field_display"] != 0) {
SE_Language::_preload_multi($dep_field_info["field_title"], $options[$i]["label"]);
SE_Language::load();
$formatted_prelim = SE_Language::_get($options[$i]["label"]);
// LINK FIELD VALUES IF NECESSARY
if($field_info["field_display"] == 2) {
link_field_values($formatted_prelim, "", Array($field_info["field_id"], $options[$i]["value"], "", $field_info["field_display"]));
}
// ADD DEPENDENT VALUE TO FIELD VALUE
if($dep_field_value != "" && $dep_field_info["field_display"] != 0) {
if($dep_field_info["field_type"] == 3) { $dep_field_value_formatted = SE_Language::_get($dep_field_value_formatted); } else { $dep_field_value_formatted = $dep_field_value; }
link_field_values($dep_field_value_formatted, "", Array($dep_field_info["field_id"], $dep_field_value, $dep_field_info["field_link"], $dep_field_info["field_display"]));
$field_value_formatted .= " ".SE_Language::_get($dep_field_info["field_title"])." ".$dep_field_value_formatted;
}
if(trim($field_value_formatted) != "") { $field_value_formatted .= ", "; }
$field_value_formatted .= $formatted_prelim;
}
if(!isset($dep_field_info["field_title"])){$dep_field_info["field_title"]="";}
// SET OPTIONS ARRAY
SE_Language::_preload_multi(
$dep_field_info["field_title"],
$options[$i]["label"]);
$field_options[] = Array('value' => $options[$i]["value"],
'label' => $options[$i]["label"],
'dependency' => $options[$i]["dependency"],
'dep_field_id' => $dep_field_info["field_id"],
'dep_field_title' => $dep_field_info["field_title"],
'dep_field_type' => $dep_field_info["field_type"],
'dep_field_required' => $dep_field_info["field_required"],
'dep_field_maxlength' => $dep_field_info["field_maxlength"],
'dep_field_options' => $dep_field_options,
'dep_field_style' => $dep_field_info["field_style"],
'dep_field_value' => $dep_field_value,
'dep_field_error' => $dep_field_error);
}
break;
default:
}
// SET FIELD ERROR IF ERROR OCCURRED
if($is_field_error == 1) { $field_error = $field_info["field_error"]; } else { $field_error = 0; }
// SET FIELD VALUE ARRAY FOR LATER USE
// FIX THIS FOR CHECKBOXES (USED FOR SUBNETS?)
$this->fields_new[$this->type."value_".$field_info["field_id"]] = $field_value;
// SET SPECIAL FIELDS, IF NECESSARY
if($field_info["field_special"] != 0) { $this->field_special[$field_info["field_special"]] = $field_value; }
// SAVE FORMATTED FIELD VALUE IN ARRAY
if($field_value_formatted != "") { $this->field_values[] = $field_value_formatted; }
// SET FIELD ARRAY AND INCREMENT FIELD COUNT
if(($format == 0 && $search == 0) || ($format == 1 && $field_value_formatted != "") || ($search == 1 && $field_info["field_search"] != 0)) {
SE_Language::_preload_multi($field_info["field_title"], $field_info["field_desc"], $field_info["field_error"]);
$this->fields[] =
$this->fields_all[] = Array('field_id' => $field_info["field_id"],
'field_title' => $field_info["field_title"],
'field_desc' => $field_info["field_desc"],
'field_type' => $field_info["field_type"],
'field_required' => $field_info["field_required"],
'field_style' => $field_info["field_style"],
'field_maxlength' => $field_info["field_maxlength"],
'field_special' => $field_info["field_special"],
'field_signup' => $field_info["field_signup"],
'field_search' => $field_info["field_search"],
'field_options' => $field_options,
'field_value' => $field_value,
'field_value_formatted' => $field_value_formatted,
'field_value_min' => $field_value_min,
'field_value_max' => $field_value_max,
'field_error' => $field_error,
'date_array1' => $date_array1,
'date_array2' => $date_array2,
'date_array3' => $date_array3);
$field_count++;
}
}
} // END field_list() METHOD
// THIS METHOD RETRIEVES FIELD INFO ABOUT A FIELD AND RETURNS IT AS AN ASSOCIATIVE ARRAY
// INPUT: $field_id REPRESENTING THE FIELD'S ID
// OUTPUT: AN ASSOCIATIVE ARRAY CONTAINING THE FIELD INFORMATION (WITHOUT TYPE PREFIX)
function field_get($field_id) {
global $database;
$field_info = $database->database_fetch_assoc($database->database_query("SELECT ".$this->type."field_id AS field_id, ".$this->type."field_".$this->type."cat_id AS field_cat_id, ".$this->type."field_order AS field_order, ".$this->type."field_dependency AS field_dependency, ".$this->type."field_title AS field_title, ".$this->type."field_desc AS field_desc, ".$this->type."field_error AS field_error, ".$this->type."field_type AS field_type, ".$this->type."field_style AS field_style, ".$this->type."field_maxlength AS field_maxlength, ".$this->type."field_link AS field_link, ".$this->type."field_options AS field_options, ".$this->type."field_required AS field_required, ".$this->type."field_regex AS field_regex, ".$this->type."field_special AS field_special, ".$this->type."field_search AS field_search, ".$this->type."field_display AS field_display, ".$this->type."field_html AS field_html FROM se_".$this->type."fields WHERE ".$this->type."field_id='$field_id'"));
// PULL OPTIONS INTO NEW ARRAY
$new_field_options = "";
$field_options = unserialize($field_info["field_options"]);
if(is_array($field_options)){
$cnt1=count($field_options);
}else{
$cnt1=1;
}
for($i=0;$i<$cnt1;$i++) {
SE_Language::_preload_multi($field_options[$i]["label"]);
SE_Language::load();
$field_options[$i]["label"] = (new SE_Language())->_get($field_options[$i]["label"]);
if($field_options[$i]["dependency"] == 1) {
$dep_field = $database->database_query("SELECT ".$this->type."field_id AS field_id, ".$this->type."field_title AS field_title FROM se_".$this->type."fields WHERE ".$this->type."field_id='".$field_options[$i]["dependent_id"]."'");
if($database->database_num_rows($dep_field) != "1") {
$field_options[$i]["dependency"] = 0;
} else {
$field_options[$i]["dependency"] = 1;
$dep_field_info = $database->database_fetch_assoc($dep_field);
SE_Language::_preload_multi($dep_field_info["field_title"]);
SE_Language::load();
$dep_field_info["field_title"] = SE_Language::_get($dep_field_info["field_title"]);
$field_options[$i]["dependent_label"] = $dep_field_info["field_title"];
}
}
}
// LOAD FIELD TITLE
SE_Language::_preload_multi($field_info["field_title"], $field_info["field_desc"], $field_info["field_error"]);
SE_Language::load();
$field_info["field_title"] = SE_Language::_get($field_info["field_title"]);
$field_info["field_desc"] = SE_Language::_get($field_info["field_desc"]);
$field_info["field_error"] = SE_Language::_get($field_info["field_error"]);
$field_info["field_options_detailed"] = $field_options;
return $field_info;
} // END field_get() METHOD
// THIS METHOD SAVES FIELD DATA
// INPUT: $field_info REPRESENTING AN ARRAY CONTAINING THE FIELD INFO TO SAVE
// OUTPUT:
function field_save($field_info) {
global $database;
$old_field_query = $database->database_query("SELECT ".$this->type."field_id AS field_id, ".$this->type."field_".$this->type."cat_id AS field_cat_id, ".$this->type."field_dependency AS field_dependency, ".$this->type."field_order AS field_order, ".$this->type."field_title AS field_title, ".$this->type."field_desc AS field_desc, ".$this->type."field_error AS field_error, ".$this->type."field_options AS field_options, ".$this->type."field_special AS field_special FROM se_".$this->type."fields WHERE ".$this->type."field_id='{$field_info["field_id"]}'");
if($database->database_num_rows($old_field_query) != 0) {
$old_field_info = $database->database_fetch_assoc($old_field_query);
} else {
$old_field_info = array();
$old_field_info["field_dependency"] = 0;
}
if($old_field_info["field_dependency"] != 0) { $field_info["field_type"] = ($field_info["field_type"] == 3) ? 3: 1; $field_info["field_cat_id"] = $old_field_info["field_cat_id"]; }
// FIELD TYPE IS TEXT FIELD
if($field_info["field_type"] == "1") {
$column_type = "varchar(250)";
$column_default = "default ''";
$field_info["field_html"] = str_replace("&gt;", "", str_replace("&lt;", "", str_replace(" ", "", $field_info["field_html"])));
$suggestions = explode("\r\n", $field_info["field_suggestions"]);
for($i=0;$i<count($suggestions);$i++) {
if(trim($suggestions[$i]) != "") {
$options[] = Array('value'=>$i, 'label'=>$suggestions[$i], 'dependency'=>'0', 'dependent_label'=>'', 'dependent_id'=>'');
}
}
// FIELD TYPE IS TEXTAREA
} elseif($field_info["field_type"] == "2") {
$column_type = "text";
$column_default = "";
$field_info["field_html"] = str_replace("&gt;", "", str_replace("&lt;", "", str_replace(" ", "", $field_info["field_html"])));
// FIELD TYPE IS SELECT BOX OR RADIO BUTTONS
} elseif($field_info["field_type"] == "3" || $field_info["field_type"] == "4" || $field_info["field_type"] == "6") {
$field_info["field_html"] = "";
for($i=0;$i<count($field_info["field_options"]);$i++) {
if(trim($field_info["field_options"][$i]["value"]) != "" && trim($field_info["field_options"][$i]["label"]) != "") {
$set_values[] = $field_info["field_options"][$i]["value"];
$options[] = $field_info["field_options"][$i];
if(preg_match("/^[0-9]+$/", $field_info["field_options"][$i]["value"]) === FALSE) {
$this->is_error = 146; break; }
} elseif($field_info["field_options"][$i]["dependent_id"] != "") {
$dependent_ids[] = $field_info["field_options"][$i]["dependent_id"];
}
}
if( !empty($set_values) && $field_info["field_type"] == "6" ) {
$column_type = "set('".implode("', '", $set_values)."')";
$column_default = "";
} else {
$column_type = "int(2)";
$column_default = "default '-1'";
}
// IF NO OPTIONS HAVE BEEN SPECIFIED
if(is_array($options) && count($options) == 0) { $this->is_error = 143; }
// FIELD TYPE IS DATE FIELD
} elseif($field_info["field_type"] == "5") {
$box5_display = "block";
$column_type = "date";
$column_default = "default '0000-00-00'";
$field_info["field_html"] = "";
// FIELD TYPE NOT SPECIFIED
} else {
$this->is_error = 85;
}
// FIELD TITLE IS EMPTY
if(trim($field_info["field_title"]) == "" && $old_field_info["field_dependency"] == 0) { $this->is_error = 94; }
// NO ERROR
if($this->is_error == 0) {
// OLD FIELD (SAVE)
if($database->database_num_rows($old_field_query)) {
if($old_field_info["field_cat_id"] != $field_info["field_cat_id"]) {
$field_order_info = $database->database_fetch_assoc($database->database_query("SELECT max(".$this->type."field_order) as f_order FROM se_".$this->type."fields WHERE ".$this->type."field_dependency='0' AND ".$this->type."field_".$this->type."cat_id='{$field_info["field_cat_id"]}'"));
$field_info["field_order"] = $field_order_info["f_order"]+1;
} else {
$field_info["field_order"] = $old_field_info["field_order"];
}
(new SE_Language())->edit($old_field_info["field_title"], $field_info["field_title"]);
//SE_Language::edit($old_field_info["field_title"], $field_info["field_title"]);
(new SE_Language())->edit($old_field_info["field_desc"], $field_info["field_desc"]);
//SE_Language::edit($old_field_info["field_desc"], $field_info["field_desc"]);
(new SE_Language())->edit($old_field_info["field_error"], $field_info["field_error"]);
//SE_Language::edit($old_field_info["field_error"], $field_info["field_error"]);
$database->database_query("UPDATE se_".$this->type."fields SET ".$this->type."field_".$this->type."cat_id='{$field_info["field_cat_id"]}', ".$this->type."field_order='{$field_info["field_order"]}', ".$this->type."field_type='{$field_info["field_type"]}', ".$this->type."field_style='{$field_info["field_style"]}', ".$this->type."field_maxlength='{$field_info["field_maxlength"]}', ".$this->type."field_link='{$field_info["field_link"]}', ".$this->type."field_required='{$field_info["field_required"]}', ".$this->type."field_regex='{$field_info["field_regex"]}', ".$this->type."field_html='{$field_info["field_html"]}', ".$this->type."field_search='{$field_info["field_search"]}', ".$this->type."field_display='{$field_info["field_display"]}', ".$this->type."field_special='{$field_info["field_special"]}' WHERE ".$this->type."field_id='{$field_info["field_id"]}'");
$column_name = $this->type."value_".$field_info["field_id"];
$database->database_query("ALTER TABLE se_".$this->type."values MODIFY $column_name $column_type $column_default");
// ENSURE FIRST DISPLAY NAME GETS CLEARED IF NECESSARY
if($this->type == "profile" && $old_field_info["field_special"] == 2 && $field_info["field_special"] != 2) {
$database->database_query("UPDATE se_users SET user_fname='' WHERE user_fname<>''");
// ENSURE LAST DISPLAY NAME GETS CLEARED IF NECESSARY
} elseif($this->type == "profile" && $old_field_info["field_special"] == 3 && $field_info["field_special"] != 3) {
$database->database_query("UPDATE se_users SET user_lname='' WHERE user_lname<>''");
}
// GET OLD LABEL LANGUAGE VARS
$old_field_options = unserialize($old_field_info["field_options"]);
if(is_array($old_field_options)){$cnt2=count($old_field_options);}
else{$cnt2=1;}
for($o=0;$o<$cnt2;$o++) { $old_language_ids[$old_field_options[$o]["value"]] = $old_field_options[$o]["label"]; }
// EDIT DEPENDENT FIELDS
if(is_array($options)){$cnt3=count($options);}
else{$cnt3=1;}
for($d=0;$d<$cnt3;$d++) {
if($old_language_ids[$options[$d]["value"]] != "") {
$options[$d]["label"] = (new SE_Language())->edit($old_language_ids[$options[$d]["value"]], $options[$d]["label"]);
//SE_Language::edit($old_language_ids[$options[$d]["value"]], $options[$d]["label"]);
unset($old_language_ids[$options[$d]["value"]]);
} else {
$options[$d]["label"] = (new SE_Language())->edit(0, $options[$d]["label"], NULL, LANGUAGE_INDEX_FIELDS);
//SE_Language::edit(0, $options[$d]["label"], NULL, LANGUAGE_INDEX_FIELDS);
}
$dep_field = $database->database_query("SELECT ".$this->type."field_id AS field_id, ".$this->type."field_title AS field_title FROM se_".$this->type."fields WHERE ".$this->type."field_id='".$options[$d]["dependent_id"]."'");
if($database->database_num_rows($dep_field) == "1") {
$dep_field_info = $database->database_fetch_assoc($dep_field);
if($options[$d][dependency] == "1") {
SE_Language::edit($dep_field_info["field_title"], $options[$d]["dependent_label"]);
$database->database_query("UPDATE se_".$this->type."fields SET ".$this->type."field_".$this->type."cat_id='{$field_info["field_cat_id"]}' WHERE ".$this->type."field_id='{$dep_field_info["field_id"]}'");
} else {
$database->database_query("DELETE FROM se_".$this->type."fields, se_languagevars USING se_".$this->type."fields JOIN se_languagevars ON se_".$this->type."fields.".$this->type."field_title=se_languagevars.languagevar_id WHERE ".$this->type."field_id='{$dep_field_info["field_id"]}'");
$column_name = $this->type."value_".$dep_field_info["field_id"];
$database->database_query("ALTER TABLE se_".$this->type."values DROP COLUMN $column_name");
}
} else {
if($options[$d]["dependency"] == "1") {
$dep_languagevar_id = (new SE_Language())->edit(0, $options[$d]["dependent_label"], NULL, LANGUAGE_INDEX_FIELDS);//SE_Language::edit(0, $options[$d]["dependent_label"], NULL, LANGUAGE_INDEX_FIELDS);
$database->database_query("INSERT INTO se_".$this->type."fields (".$this->type."field_".$this->type."cat_id, ".$this->type."field_title, ".$this->type."field_order, ".$this->type."field_type, ".$this->type."field_style, ".$this->type."field_dependency, ".$this->type."field_maxlength, ".$this->type."field_link, ".$this->type."field_options, ".$this->type."field_required, ".$this->type."field_regex) VALUES ('{$field_info["field_cat_id"]}', '".$dep_languagevar_id."', '0', '1', '', '{$field_info["field_id"]}', '100', '', '', '0', '')");
$dep_field_id = $database->database_insert_id();
$options[$d]["dependent_id"] = $dep_field_id;
$column_name = $this->type."value_".$dep_field_id;
$database->database_query("ALTER TABLE se_".$this->type."values ADD $column_name varchar(250) NOT NULL");
}
}
}
// DELETE OLD DEPENDENT FIELDS
if(is_array($dependent_ids)){$cnt5=count($dependent_ids);}
else{$cnt5=1;}
for($d=0;$d<$cnt5;$d++) {
$database->database_query("DELETE FROM se_".$this->type."fields, se_languagevars USING se_".$this->type."fields JOIN se_languagevars ON se_".$this->type."fields.".$this->type."field_title=se_languagevars.languagevar_id WHERE ".$this->type."field_id='$dependent_ids[$d]'");
$column_name = $this->type."value_".$dependent_ids[$d];
$database->database_query("ALTER TABLE se_".$this->type."values DROP COLUMN $column_name");
}
// DELETE OLD LANGUAGE VARS
if( !empty($old_language_ids) && is_array($old_language_ids) )
$database->database_query("DELETE FROM se_languagevars WHERE languagevar_id IN('".join("', '", $old_language_ids)."')");
// INSERT OPTIONS
$field_info["field_options"] = $options;
$database->database_query("UPDATE se_".$this->type."fields SET ".$this->type."field_options='".serialize($options)."' WHERE ".$this->type."field_id='{$field_info["field_id"]}'");
// NEW FIELD (ADD)
} else {
$field_order_info = $database->database_fetch_assoc($database->database_query("SELECT max(".$this->type."field_order) as f_order FROM se_".$this->type."fields WHERE ".$this->type."field_dependency='0' AND ".$this->type."field_".$this->type."cat_id='{$field_info["field_cat_id"]}'"));
$field_order = $field_order_info["f_order"]+1;
//$field_info["field_title_id"] = SE_Language::edit(0, $field_info["field_title"], NULL, LANGUAGE_INDEX_FIELDS);
$field_info["field_title_id"] =(new SE_Language)->edit(0, $field_info["field_title"], NULL, LANGUAGE_INDEX_FIELDS);
$field_info["field_desc_id"] = (new SE_Language)->edit(0, $field_info["field_desc"], NULL, LANGUAGE_INDEX_FIELDS);
$field_info["field_error_id"] =(new SE_Language)->edit(0, $field_info["field_error"], NULL, LANGUAGE_INDEX_FIELDS);
$database->database_query("INSERT INTO se_".$this->type."fields (".$this->type."field_".$this->type."cat_id, ".$this->type."field_title, ".$this->type."field_desc, ".$this->type."field_error, ".$this->type."field_order, ".$this->type."field_type, ".$this->type."field_style, ".$this->type."field_dependency, ".$this->type."field_maxlength, ".$this->type."field_link, ".$this->type."field_required, ".$this->type."field_regex, ".$this->type."field_html, ".$this->type."field_search, ".$this->type."field_display, ".$this->type."field_special) VALUES ('{$field_info["field_cat_id"]}', '{$field_info["field_title_id"]}', '{$field_info["field_desc_id"]}', '{$field_info["field_error_id"]}', '$field_order', '{$field_info["field_type"]}', '{$field_info["field_style"]}', '0', '{$field_info["field_maxlength"]}', '{$field_info["field_link"]}', '{$field_info["field_required"]}', '{$field_info["field_regex"]}', '{$field_info["field_html"]}', '{$field_info["field_search"]}', '{$field_info["field_display"]}', '{$field_info["field_special"]}')");
$field_info["field_id"] = $database->database_insert_id();
$column_name = $this->type."value_".$field_info["field_id"];
$database->database_query("ALTER TABLE se_".$this->type."values ADD $column_name $column_type NOT NULL $column_default");
// ADD DEPENDENT FIELDS
$field_options = "";
if(is_array($options)){
for($d=0;$d<count($options);$d++) {
$label_languagevar_id =
(new SE_Language)->edit(0, $options[$d]["label"], NULL, LANGUAGE_INDEX_FIELDS);
//SE_Language::edit(0, $options[$d]["label"], NULL, LANGUAGE_INDEX_FIELDS);
$options[$d]["label"] = $label_languagevar_id;
if($options[$d]["dependency"] == "1") {
$dep_languagevar_id =
(new SE_Language)->edit(0, $options[$d]["dependent_label"], NULL, LANGUAGE_INDEX_FIELDS);
// SE_Language::edit(0, $options[$d]["dependent_label"], NULL, LANGUAGE_INDEX_FIELDS);
$database->database_query("INSERT INTO se_".$this->type."fields (".$this->type."field_".$this->type."cat_id, ".$this->type."field_title, ".$this->type."field_order, ".$this->type."field_type, ".$this->type."field_style, ".$this->type."field_dependency, ".$this->type."field_maxlength, ".$this->type."field_link, ".$this->type."field_options, ".$this->type."field_required, ".$this->type."field_regex) VALUES ('{$field_info["field_cat_id"]}', '".$dep_languagevar_id."', '$d', '1', '', '{$field_info["field_id"]}', '100', '', '', '0', '')");
$dep_field_id = $database->database_insert_id();
$options[$d][dependent_id] = $dep_field_id;
$column_name = $this->type."value_".$dep_field_id;
$database->database_query("ALTER TABLE se_".$this->type."values ADD $column_name varchar(250) NOT NULL");
}
}}
// INSERT OPTIONS
$field_info["field_options"] = $options;
$database->database_query("UPDATE se_".$this->type."fields SET ".$this->type."field_options='".serialize($options)."' WHERE ".$this->type."field_id='{$field_info["field_id"]}'");
}
}
return $field_info;
} // END field_save() METHOD
// THIS METHOD DELETES A FIELD AND ITS DEPENDENT FIELDS
// INPUT: $field_id REPRESENTING THE FIELD'S ID
// OUTPUT:
function field_delete($field_id) {
global $database;
// DELETE ALL FIELD COLUMNS
$fields = $database->database_query("SELECT ".$this->type."field_id AS field_id, ".$this->type."field_title AS field_title, ".$this->type."field_desc AS field_desc, ".$this->type."field_error AS field_error, ".$this->type."field_options AS field_options FROM se_".$this->type."fields WHERE ".$this->type."field_id='$field_id' OR ".$this->type."field_dependency='$field_id'");
while($field = $database->database_fetch_assoc($fields)) {
$languagevars_delete[] = $field["field_title"];
$languagevars_delete[] = $field["field_desc"];
$languagevars_delete[] = $field["field_error"];
// DELETE OPTION LABELS
$field_options = unserialize($field["field_options"]);
for($i=0;$i<count($field_options);$i++) { if($field_options[$i]["label"] != "") { $languagevars_delete[] = $field_options[$i]["label"]; }}
$column = $this->type."value_".$field["field_id"];
$database->database_query("ALTER TABLE se_".$this->type."values DROP COLUMN $column");
}
// DELETE ALL FIELDS
$database->database_query("DELETE FROM se_languagevars WHERE languagevar_id IN(".implode(",", $languagevars_delete).")");
$database->database_query("DELETE FROM se_".$this->type."fields WHERE ".$this->type."field_id='$field_id' OR ".$this->type."field_dependency='$field_id'");
} // END field_delete() METHOD
// THIS METHOD DELETES A CATEGORY AND ITS SUBCATEGORIES/FIELDS
// INPUT: $cat_id REPRESENTING THE CATEGORY ID OF THE CATEGORY TO DELETE
// OUTPUT:
function cat_delete($cat_id) {
global $database;
$fields = $database->database_query("SELECT ".$this->type."field_id AS field_id, ".$this->type."field_title AS field_title, ".$this->type."field_desc AS field_desc, ".$this->type."field_error AS field_error FROM se_".$this->type."fields LEFT JOIN se_".$this->type."cats ON se_".$this->type."fields.".$this->type."field_".$this->type."cat_id=se_".$this->type."cats.".$this->type."cat_id WHERE se_".$this->type."cats.".$this->type."cat_id='$cat_id' OR se_".$this->type."cats.".$this->type."cat_dependency='$cat_id'");
while($field = $database->database_fetch_assoc($fields)) {
$column = $this->type."value_".$field["field_id"];
$database->database_query("ALTER TABLE se_".$this->type."values DROP COLUMN $column");
$database->database_query("DELETE FROM se_languagevars WHERE languagevar_id='{$field["field_title"]}' OR languagevar_id='{$field["field_desc"]}' OR languagevar_id='{$field["field_error"]}'");
}
$database->database_query("DELETE FROM se_languagevars USING se_".$this->type."cats JOIN se_languagevars ON se_".$this->type."cats.".$this->type."cat_title=se_languagevars.languagevar_id WHERE se_".$this->type."cats.".$this->type."cat_id='$cat_id' OR se_".$this->type."cats.".$this->type."cat_dependency='$cat_id'");
$database->database_query("DELETE FROM se_".$this->type."fields, se_".$this->type."cats USING se_".$this->type."cats LEFT JOIN se_".$this->type."fields ON se_".$this->type."fields.".$this->type."field_".$this->type."cat_id=se_".$this->type."cats.".$this->type."cat_id WHERE se_".$this->type."cats.".$this->type."cat_id='$cat_id' OR se_".$this->type."cats.".$this->type."cat_dependency='$cat_id'");
} // END cat_delete() METHOD
// THIS METHOD ADDS/EDIT A CATEGORY
// INPUT: $cat_id REPRESENTING THE CATEGORY ID OF THE CATEGORY TO ADD/EDIT
// OUTPUT: RETURNS THE CATEGORY ID
function cat_modify($cat_id, $cat_title, $cat_dependency) {
global $database;
// NEW CATEGORY
if($cat_id == "new") {
$cat_order = $database->database_fetch_assoc($database->database_query("SELECT max(".$this->type."cat_order) AS cat_order FROM se_".$this->type."cats WHERE ".$this->type."cat_dependency='$cat_dependency'"));
$cat_order = $cat_order["cat_order"]+1;
//$cat_title = SE_Language::edit(0, $cat_title, NULL, LANGUAGE_INDEX_FIELDS);
$cat_title = (new SE_Language())->edit(0, $cat_title, NULL, LANGUAGE_INDEX_FIELDS);
$database->database_query("INSERT INTO se_".$this->type."cats (".$this->type."cat_dependency, ".$this->type."cat_title, ".$this->type."cat_order) VALUES ('$cat_dependency', '$cat_title', '$cat_order')");
$newcat_id = $database->database_insert_id();
// EDIT CATEGORY
} else {
$cat_info = $database->database_fetch_assoc($database->database_query("SELECT ".$this->type."cat_title AS cat_title FROM se_".$this->type."cats WHERE ".$this->type."cat_id='$cat_id'"));
//SE_Language::edit($cat_info["cat_title"], $cat_title);
$cat_title = (new SE_Language())->edit($cat_info["cat_title"], $cat_title);
$newcat_id = $cat_id;
}
return $newcat_id;
} // END cat_modify() METHOD
}