I have added case 9 into this document and added the appropriate entries elsewhere to make it work however i cannot get this to enter the checkboxes correctly. When i go to the form and I select checkboxes and i list the options and sav ethem, it goes into the db perfectly. The problem comes into play when you go to your profile and you start to make the selections to the options EX:
If i make options a, b, c, d, e and I choose options (tick the checkbox) a, c, e then in the db and on the users profile page those should be listed and they are not only one of them will be such as option "c". what am i doing wrong all of the pages that are edited are as follows:
lan_user_extended
http://pastebin.com/VTnRYWr8
users_extended
http://pastebin.com/kMpNLbr2
user_extended_class
http://pastebin.com/qJvhC1e3
lan_users_extended
http://pastebin.com/Zzc7j36j
<?php
/*
+ ----------------------------------------------------------------------------+
| e107 website system
|
| ©Steve Dunstan 2001-2002
| http://e107.org
| jalist@e107.org
|
| Released under the terms and conditions of the
| GNU General Public License (http://gnu.org).
|
| $Source: /cvs_backup/e107_0.7/e107_handlers/user_extended_class.php,v $
| $Revision: 11346 $
| $Date: 2010-02-17 13:56:14 -0500 (Wed, 17 Feb 2010) $
| $Author: secretr $
+----------------------------------------------------------------------------+
*/
if (!defined('e107_INIT')) { exit; }
/*
User_extended rewrite for version 0.7
this code uses two tables,
user_extended
user_extended_struct
to store its data and structural information.
*/
include_lan(e_LANGUAGEDIR.e_LANGUAGE."/lan_user_extended.php");
class e107_user_extended
{
var $user_extended_types;
var $extended_xml;
var $typeArray;
var $reserved_names;
function e107_user_extended()
{
// 1 = text
// 2 = radio
// 3 = dropdown
// 4 = db field
// 5 = textarea
// 6 = integer
// 7 = date
// 8 = language
// 9 = checkbox
$this->typeArray = array(
'text' => 1,
'radio' => 2,
'dropdown' => 3,
'db field' => 4,
'textarea' => 5,
'integer' => 6,
'date' => 7,
'language' => 8,
'checkbox' => 9
);
$this->user_extended_types = array(
1 => UE_LAN_1,
2 => UE_LAN_2,
3 => UE_LAN_3,
4 => UE_LAN_4,
5 => UE_LAN_5,
6 => UE_LAN_6,
7 => UE_LAN_7,
8 => UE_LAN_8,
9 => UE_LAN_12
);
//load array with field names from main user table, so we can disallow these
$this->reserved_names = array (
'id', 'name', 'loginname', 'customtitle', 'password',
'sess', 'email', 'signature', 'image', 'timezone', 'hideemail',
'join', 'lastvisit', 'currentvisit', 'lastpost', 'chats',
'comments', 'forums', 'ip', 'ban', 'prefs', 'new', 'viewed',
'visits', 'admin', 'login', 'class', 'perms', 'realm', 'pwchange',
'xup'
);
}
function user_extended_reserved($name)
{
return (in_array($name, $this->reserved_names));
}
// $val is whatever the user entered.
// $params is the field definition
// Return FALSE if acceptable, TRUE if fail , error message on regex fail if the message is defined
function user_extended_validate_entry($val, $params)
{
global $tp;
$parms = explode("^,^", $params['user_extended_struct_parms']);
$requiredField = $params['user_extended_struct_required'] == 1;
$regex = $tp->toText($parms[1]);
$regexfail = $tp->toText($parms[2]);
if (defined($regexfail)) { $regexfail = constant($regexfail); }
if($val == '' && $requiredField) return TRUE;
switch ($type)
{
case 7 :
if ($requiredField && ($val == '0000-00-00')) return TRUE;
break;
}
if($regex != "" && $val != "")
{
if(!preg_match($regex, $val)) return $regexfail ? $regexfail : TRUE;
}
return FALSE; // Pass by default here
}
function user_extended_get_categories($byID = TRUE)
{
$ret = array();
global $sql;
if($sql->db_Select("user_extended_struct", "*", "user_extended_struct_type = 0 ORDER BY user_extended_struct_order ASC"))
{
if($byID == TRUE)
{
while($row = $sql->db_Fetch())
{
$ret[$row['user_extended_struct_id']][] = $row;
}
}
else
{
$ret = $sql->db_getList();
}
}
return $ret;
}
// Get the definition of all fields, or those in a specific category, grouped by category ID
function user_extended_get_fields($cat = "")
{
global $sql;
$ret = array();
$more = ($cat) ? " AND user_extended_struct_parent = ".intval($cat)." " : "";
if($sql->db_Select("user_extended_struct", "*", "user_extended_struct_type > 0 {$more} ORDER BY user_extended_struct_order ASC"))
{
while($row = $sql->db_Fetch())
{
$ret[$row['user_extended_struct_parent']][] = $row;
}
}
return $ret;
}
// Get the definition of all fields, or those in a specific category, indexed by field ID
function user_extended_get_fieldList($cat = "")
{
global $sql;
$more = ($cat != '') ? " AND user_extended_struct_parent = ".intval($cat)." " : "";
if($sql->db_Select("user_extended_struct", "*", "user_extended_struct_type > 0 {$more} ORDER BY user_extended_struct_order ASC"))
{
while($row = $sql->db_Fetch())
{
$ret[$row['user_extended_struct_id']] = $row;
}
}
return $ret;
}
function user_extended_type_text($type, $default)
{
global $tp;
switch ($type)
{
case 6:
// integer,
$db_type = 'INT(11)';
break;
case 7:
// date,
$db_type = 'DATE NOT NULL';
break;
case 1:
case 2:
case 3:
case 4:
case 8:
case 9:
//text, dropdown, radio, db_field, language, checkbox
$db_type = 'VARCHAR(255)';
break;
case 5:
//textarea
$db_type = 'TEXT';
break;
}
if($type != 4 && $default != '')
{
$default_text = " DEFAULT '".$tp -> toDB($default, true)."'";
}
else
{
$default_text = '';
}
return $db_type.$default_text;
}
function user_extended_field_exist($name)
{
global $sql, $tp;
return $sql->db_Count('user_extended_struct','(*)', "WHERE user_extended_struct_name = '".$tp -> toDB($name, true)."'");
}
function user_extended_add($name, $text, $type, $parms, $values, $default, $required, $read, $write, $applicable, $order='', $parent=0)
{
global $sql, $tp;
if(is_array($name))
{
extract($name);
}
if(!is_numeric($type))
{
$type = $this->typeArray[$type];
}
if (!$this->user_extended_field_exist($name) && !$this->user_extended_reserved($name))
{
$field_info = $this->user_extended_type_text($type, $default);
if($order === '')
{
if($sql->db_Select("user_extended_struct","MAX(user_extended_struct_order) as maxorder","1"))
{
$row = $sql->db_Fetch();
if(is_numeric($row['maxorder']))
{
$order = $row['maxorder']+1;
}
}
}
$sql->db_Select_gen("ALTER TABLE #user_extended ADD user_".$tp -> toDB($name, true)." ".$field_info);
$sql->db_Insert("user_extended_struct","0,'".$tp -> toDB($name, true)."','".$tp -> toDB($text, true)."','".intval($type)."','".$tp -> toDB($parms, true)."','".$tp -> toDB($values, true)."', '".$tp -> toDB($default, true)."', '".intval($read)."', '".intval($write)."', '".intval($required)."', '0', '".intval($applicable)."', '".intval($order)."', '".intval($parent)."'");
if ($this->user_extended_field_exist($name))
{
return TRUE;
}
}
return FALSE;
}
function user_extended_modify($id, $name, $text, $type, $parms, $values, $default, $required, $read, $write, $applicable, $parent)
{
global $sql, $tp;
if ($this->user_extended_field_exist($name))
{
$field_info = $this->user_extended_type_text($type, $default);
$sql->db_Select_gen("ALTER TABLE #user_extended MODIFY user_".$tp -> toDB($name, true)." ".$field_info);
$newfield_info = "
user_extended_struct_text = '".$tp -> toDB($text, true)."',
user_extended_struct_type = '".intval($type)."',
user_extended_struct_parms = '".$tp -> toDB($parms, true)."',
user_extended_struct_values = '".$tp -> toDB($values, true)."',
user_extended_struct_default = '".$tp -> toDB($default, true)."',
user_extended_struct_required = '".intval($required)."',
user_extended_struct_read = '".intval($read)."',
user_extended_struct_write = '".intval($write)."',
user_extended_struct_applicable = '".intval($applicable)."',
user_extended_struct_parent = '".intval($parent)."'
WHERE user_extended_struct_id = '".intval($id)."'
";
return $sql->db_Update("user_extended_struct", $newfield_info);
}
}
function user_extended_remove($id, $name)
{
global $sql, $tp;
if ($this->user_extended_field_exist($name))
{
$sql->db_Select_gen("ALTER TABLE #user_extended DROP user_".$tp -> toDB($name, true));
if(is_numeric($id))
{
$sql->db_Delete("user_extended_struct", "user_extended_struct_id = '".intval($id)."' ");
}
else
{
$sql->db_Delete("user_extended_struct", "user_extended_struct_name = '".$tp -> toDB($id, true)."' ");
}
return !($this->user_extended_field_exist($name));
}
}
function user_extended_hide($struct, $curval)
{
$chk = ($curval) ? " checked='checked' " : "";
$name = "hide[user_".$struct['user_extended_struct_name']."]";
return "<input type='checkbox' {$chk} value='1' name='{$name}' /> ".UE_LAN_HIDE;
}
function user_extended_edit($struct, $curval)
{
global $cal, $tp;
if(trim($curval) == "" && $struct['user_extended_struct_default'] != "")
{
$curval = $struct['user_extended_struct_default'];
}
$choices = explode(",",$struct['user_extended_struct_values']);
foreach($choices as $k => $v)
{
$choices[$k] = str_replace("[E_COMMA]", ",", $choices[$k]);
}
$parms = explode("^,^",$struct['user_extended_struct_parms']);
$include = preg_replace("/\n/", " ", $tp->toHtml($parms[0]));
$regex = $tp->toText($parms[1]);
$regexfail = $tp->toText($parms[2]);
$fname = "ue[user_".$struct['user_extended_struct_name']."]";
if(strpos($include, 'class') === FALSE)
{
$include .= " class='tbox' ";
}
switch($struct['user_extended_struct_type'])
{
case 1: //textbox
case 6: //integer
$ret = "<input name='{$fname}' value='{$curval}' {$include} />";
return $ret;
break;
case 9: //Checkboxes
foreach($choices as $choice)
{
$choice = trim($choice);
$chk = ($curval == $choice)? " checked='checked' " : "";
$ret .= "<input {$include} type='checkbox' name='{$fname}' value='{$choice}' {$chk} /> {$choice}";
}
return $ret;
break;
case 2: //radio
foreach($choices as $choice)
{
$choice = trim($choice);
$chk = ($curval = $choice)? " checked='checked' " : "";
$ret .= "<input {$include} type='radio' name='{$fname}' value='{$choice}' {$chk} /> {$choice}";
}
return $ret;
break;
case 3: //dropdown
$ret = "<select {$include} name='{$fname}'>\n";
$ret .= "<option value=''> </option>\n"; // ensures that the user chose it.
foreach($choices as $choice)
{
$choice = trim($choice);
$sel = ($curval == $choice) ? " selected='selected' " : "";
$ret .= "<option value='{$choice}' {$sel}>{$choice}</option>\n";
}
$ret .= "</select>\n";
return $ret;
break;
case 4: //db_field
global $sql;
$order = ($choices[3]) ? "ORDER BY ".$tp -> toDB($choices[3], true) : "";
if($sql->db_Select($tp -> toDB($choices[0], true), $tp -> toDB($choices[1], true).",".$tp -> toDB($choices[2], true), "1 $order")){
$choiceList = $sql->db_getList('ALL',FALSE);
$ret = "<select {$include} name='{$fname}' >\n";
$ret .= "<option value=''> </option>\n"; // ensures that the user chose it.
foreach($choiceList as $cArray)
{
$cID = trim($cArray[$choices[1]]);
$cText = trim($cArray[$choices[2]]);
$sel = ($curval == $cID) ? " selected='selected' " : "";
$ret .= "<option value='{$cID}' {$sel}>{$cText}</option>\n";
}
$ret .= "</select>\n";
return $ret;
} else {
return "";
}
break;
case 5: //textarea
return "<textarea {$include} name='{$fname}' >{$curval}</textarea>";
break;
case 7: //date
return $cal->make_input_field(
array(
'ifFormat' => '%Y-%m-%d'
),
array(
'class' => 'tbox',
'name' => $fname,
'value' => $curval
)
);
break;
case 8: // language
require_once(e_HANDLER."file_class.php");
$fl = new e_file;
$lanlist = $fl->get_dirs(e_LANGUAGEDIR);
sort($lanlist);
$ret = "<select {$include} name='{$fname}'>\n";
$ret .= "<option value=''> </option>\n"; // ensures that the user chose it.
foreach($lanlist as $choice)
{
$choice = trim($choice);
$sel = ($curval == $choice || (!USER && $choice == e_LANGUAGE))? " selected='selected' " : "";
$ret .= "<option value='{$choice}' {$sel}>{$choice}</option>\n";
}
$ret .= "</select>\n";
break;
}
return $ret;
}
function user_extended_getStruct($orderby="user_extended_struct_order")
{
if($ueStruct = getcachedvars('ue_struct'))
{
return $ueStruct;
}
global $tp;
$ret = array();
$parms = "";
if($orderby != "")
{
$parms = "1 ORDER BY ".$tp -> toDB($orderby, true);
}
$sql_ue = new db; // Use our own db to avoid interference with other objects
if($sql_ue->db_Select('user_extended_struct','*',$parms))
{
while($row = $sql_ue->db_Fetch())
{
$ret['user_'.$row['user_extended_struct_name']] = $row;
}
}
cachevars('ue_struct',$ret);
return $ret;
}
function parse_extended_xml($contents, $no_cache = FALSE)
{
if($no_cache == FALSE && $this->extended_xml)
{
return $this->extended_xml;
}
require_once(e_HANDLER."xml_class.php");
$xml = new CXml;
if("getfile" == $contents)
{
$contents = file_get_contents(e_FILE."cache/user_extended.xml");
}
$xml->Set_XML_data($contents);
$data = $xml->obj_data->e107_extended_user_fields[0];
$ret['version'] = $data->version;
unset($info);
foreach($data->item as $item)
{
$info = array(
"name" => $item->name,
"text" => "UE_LAN_".strtoupper($item->name),
"type" => $item->type[0],
"values" => $item->values[0],
"default" => $item->default[0],
"required" => $item->required[0],
"read" => $item->read[0],
"write" => $item->write[0],
"applicable" => $item->applicable[0],
"include_text" => $item->include_text[0],
"parms" => $item->include_text[0],
"regex" => $item->regex[0]
);
if(is_array($item->default) && $item->default[0] == '')
{
$info['default'] = 0;
}
if($item->regex[0])
{
$info['parms'] .= $item->include_text[0]."^,^".$item->regex[0]."^,^LAN_UE_FAIL_".strtoupper($item->name);
}
$ret[$item->name] = $info;
}
$this->extended_xml = $ret;
return $this->extended_xml;
}
function convert_old_fields()
{
global $sql;
$preList = $this->parse_extended_xml('getfile');
$flist = array('user_aim', 'user_birthday', 'user_homepage', 'user_icq', 'user_msn', 'user_location');
foreach($flist as $f)
{
$f = substr($f, 5);
$preList[$f]['parms'] = addslashes($preList[$f]['parms']);
$this->user_extended_add($preList[$f]);
}
$sql->db_Select_gen("INSERT IGNORE INTO #user_extended (user_extended_id) SELECT user_id FROM #user ");
$qry = "
UPDATE #user_extended AS ue , #user as u SET
ue.user_aim = u.user_aim,
ue.user_birthday = u.user_birthday,
ue.user_homepage = u.user_homepage,
ue.user_icq = u.user_icq,
ue.user_msn = u.user_msn,
ue.user_location = u.user_location
WHERE ue.user_extended_id = u.user_id
";
$sql->db_Select_gen($qry);
$dlist = implode(", DROP ", $flist);
$dlist = "DROP ".$dlist;
$qry = "ALTER TABLE #user ".$dlist;
$sql->db_Select_gen($qry);
}
}
?>any help that you could give me would be appreciated. I am new to this and didnt realize that this would be such a big job, but it is something that i need, so if you could help to point me in the right direction as to how to send to and call from the database in this instance for checkboxes i would appreciate it. I have searched the net high and low and i am not fnding anything on it that is helpful.