X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=admin%2Fdb%2Fusers_db.inc;h=5200f2c99933bb0d104270218ff587d7bac652b7;hb=c4eae7a18f0eb824e6eda7be2ba6fa820e9e58c9;hp=13e36ec7255823458d2094074aca6c39dde5f137;hpb=f00216978947d0fd076550f1969430265a270ce7;p=fa-stable.git diff --git a/admin/db/users_db.inc b/admin/db/users_db.inc index 13e36ec7..5200f2c9 100644 --- a/admin/db/users_db.inc +++ b/admin/db/users_db.inc @@ -1,11 +1,24 @@ . +***********************************************************************/ + +function add_user($user_id, $real_name, $password, $phone, $email, $full_access, + $language, $profile, $rep_popup, $pos) { - $sql = "INSERT INTO ".TB_PREF."users (user_id, real_name, password, phone, email, full_access, language) + $sql = "INSERT INTO ".TB_PREF."users (user_id, real_name, password" + .", phone, email, full_access, language, pos, print_profile, rep_popup) VALUES (".db_escape($user_id).", ".db_escape($real_name).", ".db_escape($password) .",".db_escape($phone).", - ".db_escape($email).", $full_access, ".db_escape($language).")"; + ".db_escape($email).", $full_access, ".db_escape($language).", + $pos,".db_escape($profile).",$rep_popup)"; db_query($sql, "could not add user for $user_id"); } @@ -22,22 +35,27 @@ function update_user_password($user_id, $password) //----------------------------------------------------------------------------------------------- -function update_user($user_id, $real_name, $phone, $email, $full_access, $language) +function update_user($user_id, $real_name, $phone, $email, $full_access, + $language, $profile, $rep_popup, $pos) { $sql = "UPDATE ".TB_PREF."users SET real_name=".db_escape($real_name). ", phone=".db_escape($phone).", email=".db_escape($email).", full_access=$full_access, - language=".db_escape($language)." + language=".db_escape($language).", + print_profile=".db_escape($profile).", + rep_popup=$rep_popup, + pos=$pos WHERE user_id = ".db_escape($user_id); - db_query($sql, "could not update user for $user_id"); } //----------------------------------------------------------------------------------------------- -function update_user_display_prefs($user_id, $price_dec, $qty_dec, $exrate_dec, $percent_dec, $showgl, - $showcodes, $date_format, $date_sep, $tho_sep, $dec_sep, $theme, $pagesize) +function update_user_display_prefs($user_id, $price_dec, $qty_dec, $exrate_dec, + $percent_dec, $showgl, $showcodes, $date_format, $date_sep, $tho_sep, + $dec_sep, $theme, $pagesize, $show_hints, $profile, $rep_popup, $query_size, + $graphic_links, $lang) { $sql = "UPDATE ".TB_PREF."users SET prices_dec=".db_escape($price_dec).", @@ -51,7 +69,13 @@ function update_user_display_prefs($user_id, $price_dec, $qty_dec, $exrate_dec, tho_sep=".db_escape($tho_sep).", dec_sep=".db_escape($dec_sep).", theme=".db_escape($theme).", - page_size=".db_escape($pagesize)." + page_size=".db_escape($pagesize).", + show_hints=$show_hints, + print_profile=".db_escape($profile).", + rep_popup=$rep_popup, + query_size=$query_size, + graphic_links=$graphic_links, + language=".db_escape($lang)." WHERE user_id = ".db_escape($user_id); db_query($sql, "could not update user display prefs for $user_id");