| | |
| | | |
| | | //* Load the user profile |
| | | function loadUserProfile($client_id = 0) { |
| | | global $app,$conf; |
| | | global $app,$conf; |
| | | |
| | | $client_id = intval($client_id); |
| | | |
| | | $client_id = intval($client_id); |
| | | |
| | | if($client_id == 0) { |
| | | $this->sys_username = 'admin'; |
| | | $this->sys_userid = 1; |
| | | $this->sys_default_group = 1; |
| | | $this->sys_groups = 1; |
| | | } else { |
| | | //* load system user |
| | | $user = $app->db->queryOneRecord("SELECT * FROM sys_user WHERE sysuser_id = $client_id"); |
| | | if(empty($user["userid"])) { |
| | | $this->errorMessage .= 'No sysuser with the ID $client_id found.'; |
| | | return false; |
| | | } |
| | | $this->sys_username = $user['username']; |
| | | $this->sys_userid = $user['userid']; |
| | | $this->sys_default_group = $user['default_group']; |
| | | $this->sys_groups = $user['groups']; |
| | | } |
| | | |
| | | return true; |
| | | |
| | | } |
| | | if($client_id == 0) { |
| | | $this->sys_username = 'admin'; |
| | | $this->sys_userid = 1; |
| | | $this->sys_default_group = 1; |
| | | $this->sys_groups = 1; |
| | | $_SESSION["s"]["user"]["typ"] = 'admin'; |
| | | } else { |
| | | //* load system user - try with sysuser and before with userid (workarrond) |
| | | /* |
| | | $user = $app->db->queryOneRecord("SELECT * FROM sys_user WHERE sysuser_id = $client_id"); |
| | | if(empty($user["userid"])) { |
| | | $user = $app->db->queryOneRecord("SELECT * FROM sys_user WHERE userid = $client_id"); |
| | | if(empty($user["userid"])) { |
| | | $this->errorMessage .= "No sysuser with the ID $client_id found."; |
| | | return false; |
| | | } |
| | | }*/ |
| | | |
| | | $user = $app->db->queryOneRecord("SELECT * FROM sys_user WHERE client_id = $client_id"); |
| | | $this->sys_username = $user['username']; |
| | | $this->sys_userid = $user['userid']; |
| | | $this->sys_default_group = $user['default_group']; |
| | | $this->sys_groups = $user['groups']; |
| | | $_SESSION["s"]["user"]["typ"] = $user['typ']; |
| | | } |
| | | |
| | | return true; |
| | | } |
| | | |
| | | |
| | | /** |
| | |
| | | $new_record[$key] = stripslashes($record[$key]); |
| | | break; |
| | | |
| | | case 'DATE': |
| | | case 'DATETSTAMP': |
| | | if($record[$key] > 0) { |
| | | $new_record[$key] = date($this->dateformat,$record[$key]); |
| | | } |
| | | break; |
| | | |
| | | case 'DATE': |
| | | if($record[$key] != '' && $record[$key] != '0000-00-00') { |
| | | $tmp = explode('-',$record[$key]); |
| | | $new_record[$key] = date($this->dateformat,mktime(0, 0, 0, $tmp[1] , $tmp[2], $tmp[0])); |
| | | } |
| | | break; |
| | | |
| | |
| | | $new_record[$key] = implode($field['separator'],$record[$key]); |
| | | } |
| | | break; |
| | | case 'DATE': |
| | | case 'DATETSTAMP': |
| | | if($record[$key] > 0) { |
| | | list($tag,$monat,$jahr) = explode('.',$record[$key]); |
| | | $new_record[$key] = mktime(0,0,0,$monat,$tag,$jahr); |
| | | } else { |
| | | $new_record[$key] = 0; |
| | | } |
| | | break; |
| | | case 'DATE': |
| | | if($record[$key] != '' && $record[$key] != '0000-00-00') { |
| | | list($tag,$monat,$jahr) = explode('.',$record[$key]); |
| | | $new_record[$key] = $jahr.'-'.$monat.'-'.$tag; |
| | | //$tmp = strptime($record[$key],$this->dateformat); |
| | | //$new_record[$key] = ($tmp['tm_year']+1900).'-'.($tmp['tm_mon']+1).'-'.$tmp['tm_mday']; |
| | | } else { |
| | | $new_record[$key] = '0000-00-00'; |
| | | } |
| | | break; |
| | | case 'INTEGER': |
| | |
| | | break; |
| | | case 'CURRENCY': |
| | | $new_record[$key] = str_replace(",",".",$record[$key]); |
| | | break; |
| | | |
| | | case 'DATETIME': |
| | | if (is_array($record[$key])) |
| | | { |
| | | $filtered_values = array_map(create_function('$item','return (int)$item;'), $record[$key]); |
| | | extract($filtered_values, EXTR_PREFIX_ALL, '_dt'); |
| | | |
| | | if ($_dt_day != 0 && $_dt_month != 0 && $_dt_year != 0) { |
| | | $new_record[$key] = date( 'Y-m-d H:i:s', mktime($_dt_hour, $_dt_minute, $_dt_second, $_dt_month, $_dt_day, $_dt_year) ); |
| | | } |
| | | } |
| | | break; |
| | | } |
| | | |
| | |
| | | $sql_insert_key .= "`$key`, "; |
| | | if($field['encryption'] == 'CRYPT') { |
| | | $salt="$1$"; |
| | | $base64_alphabet='ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/'; |
| | | for ($n=0;$n<8;$n++) { |
| | | $salt.=chr(mt_rand(64,126)); |
| | | //$salt.=chr(mt_rand(64,126)); |
| | | $salt.=$base64_alphabet[mt_rand(0,63)]; |
| | | } |
| | | $salt.="$"; |
| | | // $salt = substr(md5(time()),0,2); |
| | |
| | | if($field['formtype'] == 'PASSWORD') { |
| | | if($field['encryption'] == 'CRYPT') { |
| | | $salt="$1$"; |
| | | $base64_alphabet='ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz0123456789+/'; |
| | | for ($n=0;$n<8;$n++) { |
| | | $salt.=chr(mt_rand(64,126)); |
| | | //$salt.=chr(mt_rand(64,126)); |
| | | $salt.=$base64_alphabet[mt_rand(0,63)]; |
| | | } |
| | | $salt.="$"; |
| | | // $salt = substr(md5(time()),0,2); |