3 function add_user($user_id, $real_name, $password, $phone, $email, $full_access, $language)
5 $sql = "INSERT INTO ".TB_PREF."users (user_id, real_name, password, phone, email, full_access, language)
6 VALUES ('$user_id', '$real_name', '" . $password ."', '$phone', '$email', $full_access, '$language')";
8 db_query($sql, "could not add user for $user_id");
11 //-----------------------------------------------------------------------------------------------
13 function update_user_password($user_id, $password)
15 $sql = "UPDATE ".TB_PREF."users SET password='" . $password . "'
16 WHERE user_id = '$user_id'";
18 db_query($sql, "could not update user password for $user_id");
21 //-----------------------------------------------------------------------------------------------
23 function update_user($user_id, $real_name, $phone, $email, $full_access, $language)
25 $sql = "UPDATE ".TB_PREF."users SET real_name='$real_name', phone='$phone',
27 full_access=$full_access,
29 WHERE user_id = '$user_id'";
31 db_query($sql, "could not update user for $user_id");
34 //-----------------------------------------------------------------------------------------------
36 function update_user_display_prefs($user_id, $price_dec, $qty_dec, $exrate_dec, $percent_dec, $showgl,
37 $showcodes, $date_format, $date_sep, $tho_sep, $dec_sep, $theme, $pagesize)
39 $sql = "UPDATE ".TB_PREF."users SET
40 prices_dec=$price_dec,
42 rates_dec=$exrate_dec,
43 percent_dec=$percent_dec,
45 show_codes=$showcodes,
46 date_format=$date_format,
52 WHERE user_id = '$user_id'";
54 db_query($sql, "could not update user display prefs for $user_id");
57 //-----------------------------------------------------------------------------------------------
62 $sql = "SELECT * FROM ".TB_PREF."users";
64 return db_query($sql, "could not get users");
67 //-----------------------------------------------------------------------------------------------
69 function get_user($user_id)
71 $sql = "SELECT * FROM ".TB_PREF."users WHERE user_id = '$user_id'";
73 $result = db_query($sql, "could not get user for $user_id");
75 return db_fetch($result);
78 //-----------------------------------------------------------------------------------------------
80 function delete_user($user_id)
82 $sql="DELETE FROM ".TB_PREF."users WHERE user_id='$user_id'";
84 db_query($sql, "could not delete user $user_id");
87 //-----------------------------------------------------------------------------------------------
89 function get_user_for_login($user_id, $password)
91 set_global_connection();
93 $sql = "SELECT * FROM ".TB_PREF."users WHERE user_id = '$user_id' AND password='$password'";
95 return db_query($sql, "could not get validate user login for $user_id");
98 //-----------------------------------------------------------------------------------------------
100 function update_user_visitdate($user_id)
102 $sql = "UPDATE ".TB_PREF."users SET last_visit_date='". date("Y-m-d H:i:s") ."'
103 WHERE user_id='$user_id'";
105 db_query($sql, "could not update last visit date for user $user_id");
108 //-----------------------------------------------------------------------------------------------