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
}
