X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;f=admin%2Fdb%2Fusers_db.inc;h=5200f2c99933bb0d104270218ff587d7bac652b7;hb=c4eae7a18f0eb824e6eda7be2ba6fa820e9e58c9;hp=32f7c88c55a3a566b01123916327f45d80193361;hpb=7d9150f4f6ba547f19c789abb7a506bbd4c2bdf4;p=fa-stable.git diff --git a/admin/db/users_db.inc b/admin/db/users_db.inc index 32f7c88c..5200f2c9 100644 --- a/admin/db/users_db.inc +++ b/admin/db/users_db.inc @@ -1,13 +1,24 @@ . +***********************************************************************/ function add_user($user_id, $real_name, $password, $phone, $email, $full_access, - $language, $profile, $rep_popup) + $language, $profile, $rep_popup, $pos) { - $sql = "INSERT INTO ".TB_PREF."users (user_id, real_name, password, phone, email, full_access, language, print_profile) + $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($profile).", rep_popup=$rep_popup)"; + $pos,".db_escape($profile).",$rep_popup)"; db_query($sql, "could not add user for $user_id"); } @@ -25,7 +36,7 @@ function update_user_password($user_id, $password) //----------------------------------------------------------------------------------------------- function update_user($user_id, $real_name, $phone, $email, $full_access, - $language, $profile, $rep_popup) + $language, $profile, $rep_popup, $pos) { $sql = "UPDATE ".TB_PREF."users SET real_name=".db_escape($real_name). ", phone=".db_escape($phone).", @@ -33,7 +44,8 @@ function update_user($user_id, $real_name, $phone, $email, $full_access, full_access=$full_access, language=".db_escape($language).", print_profile=".db_escape($profile).", - rep_popup=$rep_popup + rep_popup=$rep_popup, + pos=$pos WHERE user_id = ".db_escape($user_id); db_query($sql, "could not update user for $user_id"); } @@ -42,7 +54,8 @@ function update_user($user_id, $real_name, $phone, $email, $full_access, 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) + $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).", @@ -59,7 +72,10 @@ function update_user_display_prefs($user_id, $price_dec, $qty_dec, $exrate_dec, page_size=".db_escape($pagesize).", show_hints=$show_hints, print_profile=".db_escape($profile).", - rep_popup=$rep_popup + 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");