function loadUser($loginname = "") { dbg("Loading User"); if (!Sql_Table_exists("user")) return; initialiseUserSession(); if (!$loginname) { if ($_SESSION["userloggedin"] != "" && $_SESSION["username"] != "") { $loginname = $_SESSION["username"]; } else { return ""; } } $att_req = Sql_Query(sprintf('select attribute.id, %s.name,%s.type, %s.value,%s.tablename from %s,%s,%s where %s.userid = %s.id and %s.email = "%s" and %s.id = %s.attributeid', "attribute", "attribute", "user_attribute", "attribute", "user", "user_attribute", "attribute", "user_attribute", "user", "user", $loginname, "attribute", "user_attribute" )); while ($att = Sql_fetch_array($att_req)) { # if (!defined($_SESSION["userdata"]["attribute".$att["id"]])) { $_SESSION["userdata"]["attribute".$att["id"]] = array( "name" => $att["name"], "value" => $att["value"], "type" => $att["type"], "attid" => $att["id"] ); switch ($att["type"]) { case "textline": case "hidden": $_SESSION["userdata"]["attribute".$att["id"]]["displayvalue"] = $att["value"]; break; case "creditcardno": $_SESSION["userdata"]["attribute".$att["id"]]["displayvalue"] = obscureCreditCard($att["value"]); break; case "select": $_SESSION["userdata"]["attribute".$att["id"]]["displayvalue"] = AttributeValue($att["tablename"],$att["value"]); break; } # } } $d_req = Sql_Fetch_Array_Query("select * from user where email = \"$loginname\""); $_SESSION["userid"] = $d_req["id"]; foreach (array("email","disabled","confirmed","htmlemail","uniqid") as $field) { # if (!defined($_SESSION["userdata"][$field])) { $_SESSION["userdata"][$field] = array( "name" => $field, "value" => $d_req[$field], "type" => "static", "displayvalue" => $d_req[$field] ); # } } dbg("done loading user"); $_SESSION["groups"] = userGroups($loginname); return 1; }
if (is_array($value)) { $values = array(); foreach ($value as $val) { array_push($values,sprintf('%0'.$checkboxgroup_storesize.'d',$val)); } $value = join(",",$values); } if ($replace) { Sql_query(sprintf('replace into %s (attributeid,userid,value) values("%s","%s","%s")', $tables["user_attribute"],$attribute["id"],$userid,$value)); if ($attribute["type"] != "hidden") { $datachange .= strip_tags($attribute["name"]) . " = "; if ($attribute["type"] == "checkbox") $datachange .= $value?$strYes:$strNo; elseif ($attribute["type"] != "textline" && $attribute["type"] != "textarea") $datachange .= AttributeValue($attribute["tablename"],$value); else $datachange .= stripslashes($value); $datachange .= "\n"; } } } } $message = ereg_replace('\[LISTS\]', $lists, getUserConfig("updatemessage",$userid)); $message = ereg_replace('\[USERDATA\]', $datachange, $message); if ($emailchanged) { $newaddressmessage = ereg_replace('\[CONFIRMATIONINFO\]', getUserConfig("emailchanged_text",$userid), $message); $oldaddressmessage = ereg_replace('\[CONFIRMATIONINFO\]', getUserConfig("emailchanged_text_oldaddress",$userid), $message); } else { $message = ereg_replace('\[CONFIRMATIONINFO\]', "", $message);
function loadUser($loginname = '') { if (!Sql_Table_exists('user')) { return; } initialiseUserSession(); if (!$loginname) { if ($_SESSION['userloggedin'] != '' && $_SESSION['username'] != '') { $loginname = $_SESSION['username']; } else { return ''; } } $att_req = Sql_Query(sprintf('select attribute.id, %s.name,%s.type, %s.value,%s.tablename from %s,%s,%s where %s.userid = %s.id and %s.email = "%s" and %s.id = %s.attributeid', 'attribute', 'attribute', 'user_attribute', 'attribute', 'user', 'user_attribute', 'attribute', 'user_attribute', 'user', 'user', addslashes($loginname), 'attribute', 'user_attribute')); while ($att = Sql_fetch_array($att_req)) { # if (!defined($_SESSION["userdata"]["attribute".$att["id"]])) { $_SESSION['userdata']['attribute' . $att['id']] = array('name' => $att['name'], 'value' => $att['value'], 'type' => $att['type'], 'attid' => $att['id'], 'displayvalue' => $att['value']); switch ($att['type']) { case 'textline': case 'hidden': $_SESSION['userdata']['attribute' . $att['id']]['displayvalue'] = $att['value']; break; case 'creditcardno': $_SESSION['userdata']['attribute' . $att['id']]['displayvalue'] = obscureCreditCard($att['value']); break; case 'select': $_SESSION['userdata']['attribute' . $att['id']]['displayvalue'] = AttributeValue($att['tablename'], $att['value']); break; case 'date': $_SESSION['userdata']['attribute' . $att['id']]['displayvalue'] = formatDate($att['value']); break; } # } } $d_req = Sql_Fetch_Array_Query("select * from user where email = \"{$loginname}\""); $_SESSION['userid'] = $d_req['id']; foreach (array('email', 'disabled', 'confirmed', 'htmlemail', 'uniqid', 'password', 'foreignkey') as $field) { # if (!defined($_SESSION["userdata"][$field])) { $_SESSION['userdata'][$field] = array('name' => $field, 'value' => $d_req[$field], 'type' => 'static', 'displayvalue' => $d_req[$field]); # } } $_SESSION['usergroups'] = userGroups($loginname); if (is_array($GLOBALS['config']['usergreeting'])) { $_SESSION['usergreeting'] = ''; foreach ($GLOBALS['config']['usergreeting'] as $att) { $_SESSION['usergreeting'] .= $_SESSION['userdata'][$att]['displayvalue'] . ' '; } $_SESSION['usergreeting'] = rtrim($_SESSION['usergreeting']); } dbg('done loading user'); return 1; }
array_push($values, sprintf('%0' . $checkboxgroup_storesize . 'd', $val)); } $value = implode(',', $values); } elseif ($attribute['type'] != 'textarea') { if (preg_match("/(.*)\n/U", $value, $regs)) { $value = $regs[1]; } } if ($replace) { Sql_query(sprintf('replace into %s (attributeid,userid,value) values("%s","%s","%s")', $GLOBALS['tables']['user_attribute'], $attribute['id'], $userid, $value)); if ($attribute['type'] != 'hidden') { $datachange .= strip_tags($attribute['name']) . ' : '; if ($attribute['type'] == 'checkbox') { $datachange .= $value ? $strYes : $strNo; } elseif ($attribute['type'] != 'date' && $attribute['type'] != 'textline' && $attribute['type'] != 'textarea') { $datachange .= AttributeValue($attribute['tablename'], $value); } else { $datachange .= stripslashes($value); } $datachange .= "\n"; } } } } $current_data = Sql_Fetch_Array_Query(sprintf('select * from %s where id = %d', $GLOBALS['tables']['user'], $userid)); $current_data = array_merge($current_data, getUserAttributeValues('', $userid)); foreach ($current_data as $key => $val) { if (!is_numeric($key)) { if ($old_data[$key] != $val && $key != 'password' && $key != 'modified') { $information_changed = 1; $history_entry .= "{$key} = {$val}\n*changed* from {$old_data[$key]}\n";
?> &type=view">Export</a> - <form action="<?php echo $_SERVER['PHP_SELF']; ?> " name="drop_<?php echo $view; ?> " method="post" style="display: inline;"> <input type="hidden" name="drop_view" value="<?php echo $view; ?> "></form> <a href="javascript:void(0)" onclick="if (confirm('DROP VIEW <?php echo AttributeValue($view_enq); ?> ?')) document.forms['drop_<?php echo $view; ?> '].submit();">Drop</a> </td> </tr> <?php } ?> </table> </div> <?php }