vave
Полезный
- Регистрация
- 22 Июн 2007
- Сообщения
- 467
- Реакции
- 16
- Автор темы
- #1
Как убрать удаление HTML из полей (SE3)
Хотел бы добавлять HTML код в поля SE3, например в поле профиля, где Имя и Фамилия,
profilevalue_2 и profilevalue_3
в базе вроде бы всё выставил верно для внесения HTML кода в бд
но где то работает код который убирает все лишние HTML символы, оставляя чистый текст.
вот код первого файла
а вот второго
Хотел бы добавлять HTML код в поля SE3, например в поле профиля, где Имя и Фамилия,
profilevalue_2 и profilevalue_3
в базе вроде бы всё выставил верно для внесения HTML кода в бд
но где то работает код который убирает все лишние HTML символы, оставляя чистый текст.
вот код первого файла
PHP:
<?php
/* $Id: class_field.php 159 2009-04-11 01:18:28Z Lemance $ */
// 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 se_field($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 = "";
$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];
$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]);
for($i=0,$max=count($options);$i<$max;$i++) {
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]);
for($i=0,$max=count($options);$i<$max;$i++) {
$dep_field_info = "";
$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($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]);
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 .= " ".SE_Language::_get($dep_field_info[field_title])." ".$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;
}
// 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)); }
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) { 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 .= ", "; }
$this->field_query .= $this->type."value_$field_info[field_id]='".implode(",", $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(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 = "";
$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($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;
}
// 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;
}
// 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]);
for($i=0;$i<count($field_options);$i++) {
SE_Language::_preload_multi($field_options[$i][label]);
SE_Language::load();
$field_options[$i][label] = 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 = ""; $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(">", "", str_replace("<", "", 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(">", "", str_replace("<", "", 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(ereg("^[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(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];
}
SE_Language::edit($old_field_info[field_title], $field_info[field_title]);
SE_Language::edit($old_field_info[field_desc], $field_info[field_desc]);
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]);
for($o=0;$o<count($old_field_options);$o++) { $old_language_ids[$old_field_options[$o][value]] = $old_field_options[$o][label]; }
// EDIT DEPENDENT FIELDS
for($d=0;$d<count($options);$d++) {
if($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] = 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 = 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
for($d=0;$d<count($dependent_ids);$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_desc_id] = SE_Language::edit(0, $field_info[field_desc], NULL, LANGUAGE_INDEX_FIELDS);
$field_info[field_error_id] = 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 = "";
for($d=0;$d<count($options);$d++) {
$label_languagevar_id = 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 = 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);
$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);
$newcat_id = $cat_id;
}
return $newcat_id;
} // END cat_modify() METHOD
}
?>а вот второго
PHP:
<?php
/* $Id: functions_general.php 207 2009-08-07 01:54:51Z Lemance $ */
// THIS FILE CONTAINS GENERAL FUNCTIONS
// FUNCTIONS IN THIS FILE:
// cheader()
// make_page()
// bumplog()
// randomcode()
// is_email_address()
// str_ireplace()
// htmlspecialchars_decode()
// str_split()
// security()
// select_subnet()
// link_field_values()
// censor()
// dirsize()
// user_privacy_levels()
// search_profile()
// getmicrotime()
// cleanHTML()
// chopHTML()
// choptext()
// chunkHTML_split()
// strlen_utf8()
// mb_unserialize()
// online_users()
// site_statistics()
// recent_signups()
// recent_logins()
// popular_users()
// site_news()
// friends_birthdays()
// get_simple_cookie_domain()
// THIS FUNCTION CHANGES LOCATION HEADER TO REDIRECT FOR IIS PRIOR TO SETTING COOKIES
// INPUT: $url REPRESENTING THE URL TO REDIRECT TO
// OUTPUT:
function cheader($url)
{
if( ereg("Microsoft", $_SERVER['SERVER_SOFTWARE']) )
{
header("Refresh: 0; URL=$url");
}
else
{
header("Location: $url");
}
exit();
}
// END cheader() FUNCTION
// THIS FUNCTION RETURNS APPROPRIATE PAGE VARIABLES
// INPUT: $total_items REPRESENTING THE TOTAL NUMBER OF ITEMS
// $items_per_page REPRESENTING THE NUMBER OF ITEMS PER PAGE
// $p REPRESENTING THE CURRENT PAGE
// OUTPUT: AN ARRAY CONTAINING THE STARTING ITEM, THE PAGE, AND THE MAX PAGE
function make_page($total_items, $items_per_page, $p)
{
if( !$items_per_page ) $items_per_page = 1;
$maxpage = ceil($total_items / $items_per_page);
if( $maxpage <= 0 ) $maxpage = 1;
$p = ( ($p > $maxpage) ? $maxpage : ( ($p < 1) ? 1 : $p ) );
$start = ($p - 1) * $items_per_page;
return array($start, $p, $maxpage);
}
// END make_page() FUNCTION
// THIS FUNCTION BUMPS LOGIN LOG
// INPUT:
// OUTPUT:
function bumplog()
{
global $database;
$log_entries = $database->database_num_rows($database->database_query("SELECT login_id FROM se_logins"));
if( $log_entries > 1000 )
{
$oldest_log = $database->database_fetch_assoc($database->database_query("SELECT login_id FROM se_logins ORDER BY login_id ASC LIMIT 0,1"));
$database->database_query("DELETE FROM se_logins WHERE login_id='{$oldest_log['login_id']}'");
bumplog();
}
}
// END bumplog() FUNCTION
// THIS FUNCTION RETURNS A RANDOM CODE OF DEFAULT LENGTH 8
// INPUT: $len (OPTIONAL) REPRESENTING THE LENGTH OF THE RANDOM STRING
// OUTPUT: A RANDOM ALPHANUMERIC STRING
function randomcode($len=8)
{
$code = NULL;
for( $i=0; $i<$len; $i++ )
{
$char = chr(rand(48,122));
while( !ereg("[a-zA-Z0-9]", $char) )
{
if( $char == $lchar ) continue;
$char = chr(rand(48,90));
}
$pass .= $char;
$lchar = $char;
}
return $pass;
}
// END randomcode() FUNCTION
// THIS FUNCTION CHECKS IF PROVIDED STRING IS AN EMAIL ADDRESS
// INPUT: $email REPRESENTING THE EMAIL ADDRESS TO CHECK
// OUTPUT: TRUE/FALSE DEPENDING ON WHETHER THE EMAIL ADDRESS IS VALIDLY CONSTRUCTED
function is_email_address($email)
{
$regexp = "/^[a-z0-9]+([a-z0-9_\+\\.-]+)*@([a-z0-9]+([\.-][a-z0-9]+)*)+\\.[a-z]{2,}$/i";
return (bool) preg_match($regexp, $email);
}
// END is_email_address() FUNCTION
// THIS FUNCTION SETS STR_IREPLACE IF FUNCTION DOESN'T EXIST
// INPUT: $search REPRESENTING THE STRING TO SEARCH FOR
// $replace REPRESENTING THE STRING TO REPLACE IT WITH
// $subject REPRESENTING THE STRING WITHIN WHICH TO SEARCH
// OUTPUT: RETURNS A STRING IN WHICH ONE STRING HAS BEEN CASE-INSENSITIVELY REPLACED BY ANOTHER
if( !function_exists('str_ireplace') )
{
function str_ireplace($search, $replace, $subject)
{
$search = preg_quote($search, "/");
return preg_replace("/".$search."/i", $replace, $subject);
}
}
// END str_ireplace() FUNCTION
// THIS FUNCTION SETS HTMLSPECIALCHARS_DECODE IF FUNCTION DOESN'T EXIST
// INPUT: $text REPRESENTING THE TEXT TO DECODE
// $ent_quotes (OPTIONAL) REPRESENTING WHETHER TO REPLACE DOUBLE QUOTES, ETC
// OUTPUT: A STRING WITH HTML CHARACTERS DECODED
if( !function_exists('htmlspecialchars_decode') )
{
function htmlspecialchars_decode($text, $ent_quotes = ENT_COMPAT)
{
if( $ent_quotes === ENT_QUOTES ) $text = str_replace(""", "\"", $text);
if( $ent_quotes !== ENT_NOQUOTES ) $text = str_replace("'", "'", $text);
$text = str_replace("<", "<", $text);
$text = str_replace(">", ">", $text);
$text = str_replace("&", "&", $text);
return $text;
}
}
// END htmlspecialchars() FUNCTION
// THIS FUNCTION SETS STR_SPLIT IF FUNCTION DOESN'T EXIST
// INPUT: $string REPRESENTING THE STRING TO SPLIT
// $split_length (OPTIONAL) REPRESENTING WHERE TO CUT THE STRING
// OUTPUT: AN ARRAY OF STRINGS
if( !function_exists('str_split') )
{
function str_split($string, $split_length = 1)
{
$count = strlen($string);
if($split_length < 1)
{
return false;
}
elseif($split_length > $count)
{
return array($string);
}
else
{
$num = (int)ceil($count/$split_length);
$ret = array();
for($i=0;$i<$num;$i++)
{
$ret[] = substr($string,$i*$split_length,$split_length);
}
return $ret;
}
}
}
// END str_split() FUNCTION
// THIS FUNCTION STRIPSLASHES AND ENCODES HTML ENTITIES FOR SECURITY PURPOSES
// INPUT: $value REPRESENTING A STRING OR ARRAY TO CLEAN
// OUTPUT: THE ARRAY OR STRING WITH HTML CHARACTERS ENCODED
function security($value)
{
if( is_array($value) )
{
$value = array_map('security', $value);
}
else
{
if( !get_magic_quotes_gpc() )
{
$value = htmlspecialchars($value, ENT_QUOTES, 'UTF-8');
}
else
{
$value = htmlspecialchars(stripslashes($value), ENT_QUOTES, 'UTF-8');
}
$value = str_replace("\\", "\\\\", $value);
}
return $value;
}
// END security() FUNCTION
// THIS FUNCTION LINKS FIELD VALUES
// INPUT: $field_value REPRESENTING THE VALUE TO LINK
// $key (NEEDED TO USE ARRAY WALK)
// $additional REPRESENTING THE ADDITIONAL PARAMETERS
// OUTPUT:
function link_field_values(&$field_value, $key, $additional)
{
global $url;
$field_id = $additional[0];
$field_browse = $additional[1];
$field_link = $additional[2];
$field_display = $additional[3];
$field_value = trim($field_value);
if( !trim($field_link) && $field_display == 2 )
{
if( !$field_browse ) $field_browse = urlencode(htmlspecialchars_decode($field_value, ENT_QUOTES));
$browse_url = $url->url_base."search_advanced.php?task=browse&field_id={$field_id}&field_value={$field_browse}";
if( $field_value ) $field_value = "<a href='{$browse_url}'>{$field_value}</a>";
}
elseif( trim($field_link) && $field_value )
{
if( preg_match('/^www([.]?[a-zA-Z0-9_\/-])*/', $field_value) ) $field_link = "http://".$field_value;
$link_to = str_replace("[field_value]", $field_value, $field_link);
$field_value = "<a href='{$link_to}' target='_blank'>{$field_value}</a>";
}
}
// END link_field_values() FUNCTION
// THIS FUNCTION CENSORS WORDS FROM A STRING
// INPUT: $field_value REPRESENTING THE VALUE TO CENSOR
// OUTPUT: THE VALUE WITH BANNED WORDS CENSORED
function censor($field_value)
{
global $setting;
$censored_array = explode(",", trim($setting['setting_banned_words']));
foreach($censored_array as $key => $value)
{
$replace_value = str_pad("", strlen(trim($value)), "*");
$field_value = str_ireplace(trim($value), $replace_value, $field_value);
}
return $field_value;
}
// END censor() FUNCTION
// THIS FUNCTION RETURNS THE SIZE OF A DIRECTORY
// INPUT: $dirname REPRESENTING THE PATH TO A DIRECTORY
// OUTPUT: THE SIZE OF ALL THE FILES WITHIN THE DIRECTORY
function dirsize($dirname)
{
if( !is_dir($dirname) || !is_readable($dirname) )
return false;
$dirname_stack[] = $dirname;
$size = 0;
do {
$dirname = array_shift($dirname_stack);
$handle = opendir($dirname);
while(false !== ($file = readdir($handle)))
{
if($file != '.' && $file != '..' && is_readable($dirname . DIRECTORY_SEPARATOR . $file))
{
if(is_dir($dirname . DIRECTORY_SEPARATOR . $file))
{
$dirname_stack[] = $dirname . DIRECTORY_SEPARATOR . $file;
}
$size += filesize($dirname . DIRECTORY_SEPARATOR . $file);
}
}
closedir($handle);
} while( count($dirname_stack) > 0 );
return $size;
}
// END dirsize() FUNCTION
// THIS FUNCTION RETURNS TEXT CORRESPONDING TO THE GIVEN USER PRIVACY LEVEL
// INPUT: $privacy_level REPRESENTING THE LEVEL OF USER PRIVACY
// OUTPUT: A STRING EXPLAINING THE GIVEN PRIVACY SETTING
function user_privacy_levels($privacy_level)
{
global $functions_general;
switch($privacy_level)
{
case 63: $privacy = 323; break;
case 31: $privacy = 324; break;
case 15: $privacy = 325; break;
case 7: $privacy = 326; break;
case 3: $privacy = 327; break;
case 1: $privacy = 328; break;
case 0: $privacy = 329; break;
default: $privacy = ""; break;
}
return $privacy;
}
// END user_privacy_levels() FUNCTION
// THIS FUNCTION SEARCHES THROUGH PROFILE INFORMATION
// INPUT:
// OUTPUT:
function search_profile()
{
global $database, $url, $results_per_page, $p, $search_text, $t, $search_objects, $results, $total_results;
// GET FIELDS
$fields = $database->database_query("
SELECT
profilefield_id AS field_id,
profilefield_type AS field_type,
profilefield_options AS field_options
FROM
se_profilefields
WHERE
profilefield_type<>'5' &&
(profilefield_dependency<>'0' OR (profilefield_dependency='0' AND profilefield_display<>'0'))
");
$profile_query = "se_users.user_username LIKE '%{$search_text}%' OR CONCAT(se_users.user_fname, ' ', se_users.user_lname) LIKE '%{$search_text}%'";
// LOOP OVER FIELDS
while($field_info = $database->database_fetch_assoc($fields))
{
// TEXT FIELD OR TEXTAREA
if( $field_info['field_type'] == 1 || $field_info['field_type'] == 2 )
{
if( $profile_query ) $profile_query .= " OR ";
$profile_query .= "`se_profilevalues`.`profilevalue_{$field_info['field_id']}` LIKE '%{$search_text}%'";
}
// RADIO OR SELECT BOX
elseif($field_info[field_type] == 3 || $field_info[field_type] == 4)
{
$options = unserialize($field_info['field_options']);
$langids = Array();
$cases = Array();
for($i=0,$max=count($options);$i<$max;$i++)
{
$cases[] = "WHEN languagevar_id='{$options[$i]['label']}' THEN {$options[$i]['value']}";
$langids[] = $options[$i][label];
}
if(count($cases) != 0)
{
if( $profile_query ) $profile_query .= " OR ";
$profile_query .= "`se_profilevalues`.`profilevalue_{$field_info['field_id']}` IN (SELECT CASE ".implode(" ", $cases)." END AS value FROM se_languagevars WHERE languagevar_id IN (".implode(", ", $langids).") AND languagevar_value LIKE '%{$search_text}%')";
}
}
// CHECKBOX
elseif($field_info[field_type] == 6)
{
$options = unserialize($field_info['field_options']);
$langids = Array();
$cases = Array();
for($i=0,$max=count($options);$i<$max;$i++)
{
$cases[] = "WHEN languagevar_id='{$options[$i]['label']}' THEN ".(pow(2, $i));
$langids[] = $options[$i][label];
}
if(count($cases) != 0)
{
if( $profile_query ) $profile_query .= " OR ";
$profile_query .= "`se_profilevalues`.`profilevalue_{$field_info['field_id']}` & (SELECT sum(CASE ".implode(" ", $cases)." END) AS value FROM se_languagevars WHERE languagevar_id IN (".implode(", ", $langids).") AND languagevar_value LIKE '%{$search_text}%')";
}
}
}
// CONSTRUCT QUERY
$profile_query = "
SELECT
se_users.user_id,
se_users.user_username,
se_users.user_fname,
se_users.user_lname,
se_users.user_photo
FROM
se_profilevalues
LEFT JOIN
se_users
ON se_profilevalues.profilevalue_user_id=se_users.user_id
LEFT JOIN
se_levels
ON se_levels.level_id=se_users.user_level_id
WHERE
se_users.user_verified='1' AND
se_users.user_enabled='1' AND
(se_users.user_search='1' OR se_levels.level_profile_search='0') AND
($profile_query)
";
// GET TOTAL PROFILES
$total_profiles = $database->database_num_rows($database->database_query($profile_query." LIMIT 201"));
// IF NOT TOTAL ONLY
if($t == "0")
{
// MAKE PROFILE PAGES
$start = ($p - 1) * $results_per_page;
$limit = $results_per_page+1;
// SEARCH PROFILES
$online_users_array = online_users();
$profiles = $database->database_query($profile_query." ORDER BY se_users.user_id DESC LIMIT $start, $limit");
while($profile_info = $database->database_fetch_assoc($profiles))
{
// CREATE AN OBJECT FOR USER
$profile = new se_user();
$profile->user_info['user_id'] = $profile_info['user_id'];
$profile->user_info['user_username'] = $profile_info['user_username'];
$profile->user_info['user_fname'] = $profile_info['user_fname'];
$profile->user_info['user_lname'] = $profile_info['user_lname'];
$profile->user_info['user_photo'] = $profile_info['user_photo'];
$profile->user_displayname();
// DETERMINE IF USER IS ONLINE
$is_online = (bool) in_array($profile_info['user_username'], $online_users_array[0]);
$results[] = Array(
'result_url' => $url->url_create('profile', $profile_info['user_username']),
'result_icon' => $profile->user_photo('./images/nophoto.gif', TRUE),
'result_name' => 509,
'result_name_1' => $profile->user_displayname,
'result_desc' => '',
'result_online' => $is_online
);
}
// SET TOTAL RESULTS
$total_results = $total_profiles;
}
// SET ARRAY VALUES
SE_Language::_preload_multi(509, 1072);
if($total_profiles > 200) { $total_profiles = "200+"; }
$search_objects[] = Array(
'search_type' => '0',
'search_lang' => 1072,
'search_total' => $total_profiles
);
}
// END search_profile() FUNCTION
// THIS FUNCTION RETURNS TIME IN SECONDS WITH MICROSECONDS
// INPUT:
// OUTPUT: RETURNS THE TIME IN SECONDS WITH MICROSECONDS
function getmicrotime()
{
list($usec, $sec) = explode(" ",microtime());
return ((float)$usec + (float)$sec);
}
// END getmicrotime() FUNCTION
// THIS FUNCTION CLEANS HTML TAGS FROM TEXT
// INPUT: $text REPRESENTING THE STRING TO CLEAN
// $allowable_tags REPRESENTING THE ALLOWABLE HTML TAGS (AS A COMMA-DELIMITED STRING)
// $forbidden_attr (OPTIONAL) REPRESENTING AND ARRAY OF ANY ADDITIONAL FORBIDDEN ATTRIBUTES (SUCH AS A STYLE TAG)
// OUTPUT: THE CLEANED TEXT
function cleanHTML($text, $allowable_tags, $forbidden_attr = "")
{
// INCLUDE FILTER CLASS
if( !class_exists("InputFilter") )
require(SE_ROOT."/include/class_inputfilter.php");
// INSTANTIATE INPUT FILTER CLASS WITH APPROPRIATE TAGS
$xssFilter = new InputFilter(explode(",", str_replace(" ", "", $allowable_tags)), "", 0, 1, 1);
// ADD NECESSARY BLACKLIST ITEMS
for($i=0;$i<count($forbidden_attr);$i++)
{
$xssFilter->attrBlacklist[] = $forbidden_attr[$i];
}
// RETURN PROCESSED TEXT
return $xssFilter->process($text);
}
// END cleanHTML() FUNCTION
// THIS FUNCTION TRIMS A GIVEN STRING PRESERVING HTML
// INPUT: $string REPRESENTING THE STRING TO SHORTEN
// $start REPRESENTING THE CHARACTER TO START WITH
// $length REPRESENTING THE LENGTH OF THE STRING TO RETURN
// OUTPUT: THE CLEANED TEXT
function chopHTML($string, $start, $length=false)
{
$pattern = '/(\[\w+[^\]]*?\]|\[\/\w+\]|<\w+[^>]*?>|<\/\w+>)/i';
$clean = preg_replace($pattern, chr(1), $string);
if(!$length)
$str = substr($clean, $start);
else {
$str = substr($clean, $start, $length);
$str = substr($clean, $start, $length + substr_count($str, chr(1)));
}
$pattern = str_replace(chr(1),'(.*?)',preg_quote($str));
if(preg_match('/'.$pattern.'/is', $string, $matched))
return $matched[0];
return $string;
}
// END chopHTML() FUNCTION
// THIS FUNCTION CHOPS A GIVEN STRING AND INSERTS A STRING AT THE END OF EACH CHOP
// INPUT: $string REPRESENTING THE STRING TO CHOP
// $length REPRESENTING THE LENGTH OF EACH SEGMENT
// $insert_char REPRESENTING THE STRING TO INSERT AT THE END OF EACH SEGMENT
function choptext($string, $length=32, $insert_char=' ')
{
return preg_replace("!(?:^|\s)([\w\!\?\.]{" . $length . ",})(?:\s|$)!e",'chunk_split("\\1",' . $length . ',"' . $insert_char. '")',$string);
}
// END choptext() FUNCTION
// THIS FUNCTION CHOPS A GIVEN STRING AND INSERTS A STRING AT THE END OF EACH CHOP (PRESERVING HTML ENTITIES)
// INPUT: $html REPRESENTING THE STRING TO CHOP
// $size REPRESENTING THE LENGTH OF EACH SEGMENT
// $delim REPRESENTING THE STRING TO INSERT AT THE END OF EACH SEGMENT
function chunkHTML_split($html, $size, $delim)
{
$pos=0;
for($i=0;$i<strlen($html);$i++)
{
if($pos >= $size && !$unsafe)
{
$out .= $delim;
$unsafe = 0;
$pos = 0;
}
$c = substr($html,$i,1);
if($c == "&")
$unsafe = 1;
elseif($c == ";")
$unsafe = 0;
$out .= $c;
$pos++;
}
return $out;
}
// END chunkHTML_split
// THIS FUNCTION RETURNS THE LENGTH OF A STRING, ACCOUNTING FOR UTF8 CHARS
// INPUT: $str REPRESENTING THE STRING
// OUTPUT: THE LENGTH OF THE STRING
function strlen_utf8($str)
{
$i = 0;
$count = 0;
$len = strlen($str);
while($i < $len)
{
$chr = ord ($str[$i]);
$count++;
$i++;
if($i >= $len)
break;
if($chr & 0x80)
{
$chr <<= 1;
while ($chr & 0x80)
{
$i++;
$chr <<= 1;
}
}
}
return $count;
}
// END strlen_utf8() FUNCTION
// THIS FUNCTION MAKES UTF8 CHARS WORK IN SERIALIZE BY BASICALLY IGNORING THE STRING LENGTH PARAM
// INPUT: $str REPRESENTING THE SERIALIZED STRING
// OUTPUT: THE UNSERIALIZED DATA
function mb_unserialize($serial_str)
{
$out = preg_replace('!s:(\d+):"(.*?)";!se', "'s:'.strlen('$2').':\"$2\";'", $serial_str );
return unserialize($out);
}
// END mb_unserialize() FUNCTION
// THIS FUNCTION RETURNS AN ARRAY CONTAINING THE USERNAMES OF ONLINE USERS
// INPUT:
// OUTPUT: AN ARRAY OF USERNAMES FOR USERS CURRENTLY ACTIVE IN THE SYSTEM
function online_users()
{
global $database;
$online_array = NULL;
// CACHING
$cache_object = SECache::getInstance('serial');
if( is_object($cache_object) )
{
$online_array = $cache_object->get('online_users');
}
if( !is_array($online_array) )
{
$total_visitors = 0;
$onlineusers_array = array();
$onlineusers_usernames = array();
$online_time = time() - (10 * 60);
$sql = "SELECT visitor_user_id AS user_id, visitor_user_username AS user_username, visitor_user_displayname AS user_displayname FROM se_visitors WHERE visitor_invisible=0 && visitor_lastactive>'{$online_time}' ORDER BY visitor_lastactive DESC LIMIT 2000";
$resource = $database->database_query($sql);
while( $online_user_info = $database->database_fetch_assoc($resource) )
{
// THIS IS A USER
if( !empty($online_user_info['user_id']) )
{
if( in_array($online_user_info['user_username'], $onlineusers_usernames) ) continue;
$online_user = new se_user();
$online_user->user_info['user_id'] = $online_user_info['user_id'];
$online_user->user_info['user_username'] = $online_user_info['user_username'];
$online_user->user_info['user_displayname'] = $online_user_info['user_displayname'];
$online_user->user_displayname = $online_user_info['user_displayname'];
$onlineusers_array[] = $online_user;
$onlineusers_usernames[] = $online_user->user_info['user_username'];
}
// THIS IS A VISITOR
else
{
$total_visitors++;
}
}
$online_array = array($onlineusers_array, $total_visitors, $onlineusers_usernames);
// CACHE
if( is_object($cache_object) )
{
$cache_object->store($online_array, 'online_users');
}
}
return $online_array;
}
// END online_users() FUNCTION
// THIS FUNCTION RETURNS AN ARRAY CONTAINING SITE STATISTICS
// INPUT:
// OUTPUT: AN ARRAY OF STATISTICS
function site_statistics()
{
global $setting, $database, $database_name;
$statistics = NULL;
// CACHING
$cache_object = SECache::getInstance('serial');
if( is_object($cache_object) )
{
$statistics = $cache_object->get('site_statistics');
}
// RETRIEVAL
//if( !is_array($statistics) || empty($statistics) )
if( !is_array($statistics) )
{
$statistics = array();
// Get default stats
$total_members = $database->database_fetch_assoc($database->database_query("SELECT count(*) AS total_members FROM se_users"));
$statistics['members'] = array(
'title' => 661,
'stat' => (int) ( isset($total_members['total_members']) ? $total_members['total_members'] : 0 )
);
if( $setting['setting_connection_allow'] )
{
$total_friends = $database->database_fetch_assoc($database->database_query("SELECT count(*) AS total_friends FROM se_friends WHERE friend_status='1'"));
$statistics['friends'] = array(
'title' => 662,
'stat' => (int) ( isset($total_friends['total_friends']) ? $total_friends['total_friends'] : 0 )
);
}
$total_comments = 0;
$comment_tables = $database->database_query("SHOW TABLES FROM `{$database_name}` LIKE 'se_%comments'");
while($table_info = $database->database_fetch_array($comment_tables))
{
$comment_type = strrev(substr(strrev(substr($table_info[0], 3)), 8));
$table_comments = $database->database_fetch_assoc($database->database_query("SELECT count(*) AS total_comments FROM `se_{$comment_type}comments`"));
$total_comments += $table_comments['total_comments'];
}
$statistics['comments'] = array(
'title' => 663,
'stat' => (int) $total_comments
);
/*
$total_media = 0;
$media_tables = $database->database_query("SHOW TABLES FROM `{$database_name}` LIKE 'se_%media'");
while($table_info = $database->database_fetch_array($media_tables))
{
$comment_type = strrev(substr(strrev(substr($table_info[0], 3)), 8));
$table_media = $database->database_fetch_assoc($database->database_query("SELECT count(*) AS total_media FROM se_{$comment_type}media"));
$total_media += $total_media['total_media'];
}
$statistics['media'] = array(
'title' => 663, // TODO
'stat' => (int) $total_media
);
*/
/*
$total_mediatags = 0;
$mediatag_tables = $database->database_query("SHOW TABLES FROM `{$database_name}` LIKE 'se_%mediatags'");
while($table_info = $database->database_fetch_array($media_tables))
{
$comment_type = strrev(substr(strrev(substr($table_info[0], 3)), 8));
$table_mediatags = $database->database_fetch_assoc($database->database_query("SELECT count(*) AS total_mediatags FROM se_{$comment_type}mediatags"));
$total_mediatags += $total_mediatags['total_mediatags'];
}
$statistics['mediatags'] = array(
'title' => 663, // TODO
'stat' => (int) $total_mediatags
);
*/
// CALL HOOK
// COMMENT OUT THIS NEXT LINE IF YOU ONLY WANT THE BASIC STATISTICS
($hook = SE_Hook::exists('se_site_statistics')) ? SE_Hook::call($hook, array('statistics' => &$statistics)) : NULL;
// CACHE
if( is_object($cache_object) )
{
$cache_object->store($statistics, 'site_statistics');
}
}
// Load language
foreach( $statistics as $stat )
{
SE_Language::_preload($stat['title']);
}
return $statistics;
}
// END site_statistics() FUNCTION
// THIS FUNCTION RETURNS AN ARRAY CONTAINING THE USERS THAT RECENTLY SIGNED UP
// INPUT:
// OUTPUT:
function recent_signups()
{
global $setting, $database;
$signups = NULL;
// CACHING
$cache_object = SECache::getInstance('serial');
if( is_object($cache_object) )
{
$signups = $cache_object->get('recent_signups');
}
// RETRIEVAL
//if( !is_array($signups) || empty($signups) )
if( !is_array($signups) )
{
$sql = "SELECT user_id, user_username, user_fname, user_lname, user_photo FROM se_users WHERE user_verified='1' AND user_enabled='1' AND user_search='1' AND user_photo<>'' ORDER BY user_signupdate DESC LIMIT 20";
$resource = $database->database_query($sql);
$signups = array();
while( $user_info = $database->database_fetch_assoc($resource) )
{
$signup_user = new se_user();
$signup_user->user_info['user_id'] = $user_info['user_id'];
$signup_user->user_info['user_username'] = $user_info['user_username'];
$signup_user->user_info['user_photo'] = $user_info['user_photo'];
$signup_user->user_info['user_fname'] = $user_info['user_fname'];
$signup_user->user_info['user_lname'] = $user_info['user_lname'];
$signup_user->user_displayname();
$signups[] =& $signup_user;
unset($signup_user);
}
// CACHE
if( is_object($cache_object) )
{
$cache_object->store($signups, 'recent_signups');
}
}
return $signups;
}
// END recent_signups() FUNCTION
// THIS FUNCTION RETURNS AN ARRAY CONTAINING THE MOST RECENTLY LOGGED IN USERS
// INPUT:
// OUTPUT:
function recent_logins()
{
global $setting, $database;
$logins = NULL;
// CACHING
$cache_object = SECache::getInstance('serial');
if( is_object($cache_object) )
{
$logins = $cache_object->get('recent_logins');
}
// RETRIEVAL
//if( !is_array($logins) || empty($logins) )
if( !is_array($logins) )
{
$sql = "SELECT user_id, user_username, user_fname, user_lname, user_photo FROM se_users WHERE user_photo<>'' AND user_search='1' ORDER BY user_lastlogindate DESC LIMIT 20";
$resource = $database->database_query($sql);
$logins = array();
while( $user_info = $database->database_fetch_assoc($resource) )
{
$login_user = new se_user();
$login_user->user_info['user_id'] = $user_info['user_id'];
$login_user->user_info['user_username'] = $user_info['user_username'];
$login_user->user_info['user_photo'] = $user_info['user_photo'];
$login_user->user_info['user_fname'] = $user_info['user_fname'];
$login_user->user_info['user_lname'] = $user_info['user_lname'];
$login_user->user_displayname();
$logins[] =& $login_user;
unset($login_user);
}
// CACHE
if( is_object($cache_object) )
{
$cache_object->store($logins, 'recent_logins');
}
}
return $logins;
}
// END recent_logins() FUNCTION
// THIS FUNCTION RETURNS AN ARRAY CONTAINING THE MOST POPULAR USERS
// INPUT:
// OUTPUT:
function popular_users()
{
global $setting, $database;
$popular_users = NULL;
// CACHING
$cache_object = SECache::getInstance('serial');
if( is_object($cache_object) )
{
$popular_users = $cache_object->get('popular_users');
}
// RETRIEVAL
//if( !is_array($popular_users) || empty($popular_users) )
if( !is_array($popular_users) )
{
$sql = "SELECT count(se_friends.friend_user_id2) AS num_friends, se_users.user_id, se_users.user_username, se_users.user_fname, se_users.user_lname, se_users.user_photo FROM se_friends LEFT JOIN se_users ON se_friends.friend_user_id1=se_users.user_id WHERE se_friends.friend_status='1' AND se_users.user_search='1' GROUP BY se_users.user_id ORDER BY num_friends DESC LIMIT 20";
$resource = $database->database_query($sql);
$popular_users = array();
while( $user_info = $database->database_fetch_assoc($resource) )
{
$popular_user = new se_user();
$popular_user->user_info['user_id'] = $user_info['user_id'];
$popular_user->user_info['user_username'] = $user_info['user_username'];
$popular_user->user_info['user_photo'] = $user_info['user_photo'];
$popular_user->user_info['user_fname'] = $user_info['user_fname'];
$popular_user->user_info['user_lname'] = $user_info['user_lname'];
$popular_user->user_displayname();
$popular_users[] = array(
'friend' => &$popular_user,
'total_friends' => $user_info['num_friends']
);
unset($popular_user);
}
// CACHE
if( is_object($cache_object) )
{
$cache_object->store($popular_users, 'popular_users');
}
}
return $popular_users;
}
// END popular_users() FUNCTION
// THIS FUNCTION RETURNS AN ARRAY CONTAINING THE MOST POPULAR USERS
// INPUT:
// OUTPUT:
function site_news()
{
global $setting, $database;
$news = NULL;
// CACHING
$cache_object = SECache::getInstance('serial');
if( is_object($cache_object) )
{
$news = $cache_object->get('site_news');
}
// RETRIEVAL
//if( !is_array($news) || empty($news) )
if( !is_array($news) )
{
$sql = "SELECT * FROM se_announcements ORDER BY announcement_order DESC LIMIT 20";
$resource = $database->database_query($sql);
$news = array();
while( $news_info = $database->database_fetch_assoc($resource) )
{
// CONVERT SUBJECT/BODY BACK TO HTML
$news_info['announcement_body'] = htmlspecialchars_decode($news_info['announcement_body'], ENT_QUOTES);
$news_info['announcement_subject'] = htmlspecialchars_decode($news_info['announcement_subject'], ENT_QUOTES);
$news[] = $news_info;
}
// CACHE
if( is_object($cache_object) )
{
$cache_object->store($news, 'site_news');
}
}
return $news;
}
// END site_news() FUNCTION
// THIS FUNCTION RETURNS AN ARRAY CONTAINING THE USERS FRIENDS BIRTHDAYS INFO
// INPUT:
// OUTPUT:
function friends_birthdays()
{
global $setting, $database, $user;
$birthdays = NULL;
// CACHING
$cache_object = SECache::getInstance('serial');
if( is_object($cache_object) )
{
$birthdays = $cache_object->get('friends_birthdays_user_'.$user->user_info['user_id']);
}
// RETRIEVAL
//if( !is_array($birthdays) || empty($birthdays) )
if( !is_array($birthdays) )
{
$birthdays = array();
$sql = "SELECT profilefield_id, t2.profilecat_id FROM se_profilefields LEFT JOIN se_profilecats AS t1 ON se_profilefields.profilefield_profilecat_id=t1.profilecat_id LEFT JOIN se_profilecats AS t2 ON t1.profilecat_dependency=t2.profilecat_id WHERE profilefield_special='1'";
$resource = $database->database_query($sql);
if( $database->database_num_rows($resource) > 0 )
{
// CONSTRUCT QUERY
$birthdays_upcoming_query = "
SELECT
se_users.user_id,
se_users.user_username,
se_users.user_fname,
se_users.user_lname,
CASE
";
while( $birthday_field = $database->database_fetch_assoc($resource) )
{
$birthdays_upcoming_query .= " WHEN se_users.user_profilecat_id='{$birthday_field['profilecat_id']}' THEN DATE_FORMAT(CONCAT(YEAR(CURDATE()), \"-\", MONTH(se_profilevalues.`profilevalue_{$birthday_field['profilefield_id']}`), \"-\", DAY(se_profilevalues.`profilevalue_{$birthday_field['profilefield_id']}`)), '%Y-%m-%d')";
$birthdays_upcoming_where[] = "(se_users.user_profilecat_id='{$birthday_field['profilecat_id']}' AND DAY(se_profilevalues.`profilevalue_{$birthday_field['profilefield_id']}`)<>'0' AND MONTH(se_profilevalues.`profilevalue_{$birthday_field['profilefield_id']}`)<>'0' AND CURDATE() <= DATE_FORMAT(CONCAT(YEAR(CURDATE()), \"-\", MONTH(se_profilevalues.`profilevalue_{$birthday_field['profilefield_id']}`), \"-\", DAY(se_profilevalues.`profilevalue_{$birthday_field['profilefield_id']}`)), '%Y-%m-%d') AND DATE_ADD(CURDATE(), INTERVAL 7 DAY) >= DATE_FORMAT(CONCAT(YEAR(CURDATE()), \"-\", MONTH(se_profilevalues.`profilevalue_{$birthday_field['profilefield_id']}`), \"-\", DAY(se_profilevalues.`profilevalue_{$birthday_field['profilefield_id']}`)), '%Y-%m-%d'))";
}
$birthdays_upcoming_query .= " ELSE '0000-00-00' END AS birthday FROM se_friends LEFT JOIN se_users ON se_friends.friend_user_id2=se_users.user_id LEFT JOIN se_profilevalues ON se_users.user_id=se_profilevalues.profilevalue_user_id WHERE se_friends.friend_user_id1='{$user->user_info['user_id']}' AND (".implode(" OR ", $birthdays_upcoming_where).") ORDER BY birthday";
$resource = $database->database_query($birthdays_upcoming_query);
while( $birthday_info = $database->database_fetch_assoc($resource) )
{
$birthday_user = new se_user();
$birthday_user->user_info['user_id'] = $birthday_info['user_id'];
$birthday_user->user_info['user_username'] = $birthday_info['user_username'];
$birthday_user->user_info['user_fname'] = $birthday_info['user_fname'];
$birthday_user->user_info['user_lname'] = $birthday_info['user_lname'];
$birthday_user->user_displayname();
// SET BIRTHDAY
$birthday_date = mktime(0, 0, 0, substr($birthday_info['birthday'], 5, 2), substr($birthday_info['birthday'], 8, 2), 1990);
$birthdays[] = array(
'birthday_user_id' => $birthday_user->user_info['user_id'],
'birthday_user_username' => $birthday_user->user_info['user_username'],
'birthday_user_displayname' => $birthday_user->user_displayname,
'birthday_date' => $birthday_date,
'birthday_user' => &$birthday_user
);
unset($birthday_user);
}
}
// CACHE
if( is_object($cache_object) )
{
$cache_object->store($birthdays, 'friends_birthdays_user_'.$user->user_info['user_id']);
}
}
return $birthdays;
}
// END friends_birthdays() FUNCTION
function get_simple_cookie_domain($host = null)
{
// Quick config
if( defined('SE_COOKIE_DOMAIN') )
{
return SE_COOKIE_DOMAIN;
}
if( !$host )
{
$host = $_SERVER["HTTP_HOST"];
}
$host = parse_url($host);
$host = $host['path'];
$parts = explode('.', $host);
switch( TRUE )
{
// Do not use custom for these:
// IP Address
case ( preg_match('/\d{1,3}\.\d{1,3}\.\d{1,3}\.\d{1,3}/', $host) ):
// Intranet host
case ( count($parts) === 1 ):
return null;
break;
// Second level ccld
case ( strlen($parts[count($parts)-1]) == 2 && strlen($parts[count($parts)-2]) <= 3 ):
array_splice($parts, 0, count($parts) - 3);
return join('.', $parts);
break;
// tld or first-level ccld
default:
array_splice($parts, 0, count($parts) - 2);
return join('.', $parts);
}
return null;
}
?>
