From c6f36f01c83cf435bbc338443a357f81c49cbbca Mon Sep 17 00:00:00 2001 From: Marius Cramer <m.cramer@pixcept.de> Date: Wed, 20 Nov 2013 09:21:47 -0500 Subject: [PATCH] Implemented FS#2531 - switch from a reseller to a client --- interface/web/login/lib/lang/pt_login_as.lng | 0 interface/web/client/templates/resellers_list.htm | 2 interface/web/login/lib/lang/ja_login_as.lng | 0 interface/web/login/lib/lang/it_login_as.lng | 0 interface/web/login/lib/lang/ar_login_as.lng | 0 interface/web/login/index.php | 50 ++++++++++++++++++++++--- interface/web/login/logout.php | 7 ++- interface/web/login/lib/lang/pl_login_as.lng | 0 interface/web/login/lib/lang/hr_login_as.lng | 0 interface/web/login/lib/lang/br_login_as.lng | 0 interface/web/login/lib/lang/ru_login_as.lng | 0 interface/web/login/lib/lang/nl_login_as.lng | 0 interface/web/login/lib/lang/id_login_as.lng | 0 interface/web/login/lib/lang/fr_login_as.lng | 0 interface/web/login/lib/lang/bg_login_as.lng | 0 interface/web/login/lib/lang/se_login_as.lng | 0 interface/web/login/login_as.php | 25 ++++++++++-- interface/web/login/lib/lang/sk_login_as.lng | 0 interface/web/login/lib/lang/el_login_as.lng | 0 interface/web/client/templates/clients_list.htm | 4 + interface/web/login/lib/lang/hu_login_as.lng | 0 interface/web/login/lib/lang/tr_login_as.lng | 0 interface/web/login/lib/lang/cz_login_as.lng | 0 interface/web/login/lib/lang/de_login_as.lng | 0 interface/web/login/lib/lang/en_login_as.lng | 0 interface/web/login/lib/lang/fi_login_as.lng | 0 interface/web/login/lib/lang/ro_login_as.lng | 0 interface/web/login/lib/lang/es_login_as.lng | 0 28 files changed, 72 insertions(+), 16 deletions(-) diff --git a/interface/web/client/templates/clients_list.htm b/interface/web/client/templates/clients_list.htm index 8f33ace..820e27c 100644 --- a/interface/web/client/templates/clients_list.htm +++ b/interface/web/client/templates/clients_list.htm @@ -52,7 +52,9 @@ <td class="tbl_col_country"><a href="#" onclick="loadContent('client/client_edit.php?id={tmpl_var name='id'}');"><div class="country-{tmpl_var name="countryiso"}" style="float:left"></div>{tmpl_var name="country"}</a></td> <td class="tbl_col_buttons"> <tmpl_if name="is_admin"> - <a class="button icons16 icoLoginAs" href="javascript: loadContent('admin/login_as.php?cid={tmpl_var name='id'}');"><span>{tmpl_var name='login_as_txt'}</span></a> + <a class="button icons16 icoLoginAs" href="javascript: loadContent('login/login_as.php?cid={tmpl_var name='id'}');"><span>{tmpl_var name='login_as_txt'}</span></a> + <tmpl_elseif name="is_reseller"> + <a class="button icons16 icoLoginAs" href="javascript: loadContent('login/login_as.php?cid={tmpl_var name='id'}');"><span>{tmpl_var name='login_as_txt'}</span></a> </tmpl_if> <a class="button icons16 icoDelete" href="javascript: del_record('client/client_del.php?id={tmpl_var name='id'}&phpsessid={tmpl_var name='phpsessid'}','{tmpl_var name='delete_confirmation'}');"><span>{tmpl_var name='delete_txt'}</span></a> </td> diff --git a/interface/web/client/templates/resellers_list.htm b/interface/web/client/templates/resellers_list.htm index 66cb06a..5074497 100644 --- a/interface/web/client/templates/resellers_list.htm +++ b/interface/web/client/templates/resellers_list.htm @@ -51,7 +51,7 @@ <td class="tbl_col_city"><a href="#" onclick="loadContent('client/reseller_edit.php?id={tmpl_var name='id'}');">{tmpl_var name="city"}</a></td> <td class="tbl_col_country"><a href="#" onclick="loadContent('client/reseller_edit.php?id={tmpl_var name='id'}');"><div class="country-{tmpl_var name="countryiso"}" style="float:left"></div>{tmpl_var name="country"}</a></td> <td class="tbl_col_buttons"> - <a class="button icons16 icoLoginAs" href="javascript: loadContent('admin/login_as.php?cid={tmpl_var name='id'}');"><span>{tmpl_var name='login_as_txt'}</span></a> + <a class="button icons16 icoLoginAs" href="javascript: loadContent('login/login_as.php?cid={tmpl_var name='id'}');"><span>{tmpl_var name='login_as_txt'}</span></a> <a class="button icons16 icoDelete" href="javascript: del_record('client/reseller_del.php?id={tmpl_var name='id'}&phpsessid={tmpl_var name='phpsessid'}','{tmpl_var name='delete_confirmation'}');"><span>{tmpl_var name='delete_txt'}</span></a> </td> </tr> diff --git a/interface/web/login/index.php b/interface/web/login/index.php index 950c692..c9c412c 100644 --- a/interface/web/login/index.php +++ b/interface/web/login/index.php @@ -85,21 +85,59 @@ */ if (isset($_SESSION['s']['user']) && $_SESSION['s']['user']['active'] == 1){ /* - * only the admin can "login as" so if the user is NOT a admin, we + * only the admin or reseller can "login as" so if the user is NOT an admin or reseller, we * open the startpage (after killing the old session), so the user * is logout and has to start again! */ - if ($_SESSION['s']['user']['typ'] != 'admin') { + if ($_SESSION['s']['user']['typ'] != 'admin' && !$app->auth->has_clients($_SESSION['s']['user']['userid'])) { /* - * The actual user is NOT a admin, but maybe the admin - * has logged in as "normal" user bevore... + * The actual user is NOT a admin or reseller, but maybe he + * has logged in as "normal" user before... */ - if (isset($_SESSION['s_old'])&& ($_SESSION['s_old']['user']['typ'] == 'admin')){ - /* The "old" user is admin, so everything is ok */ + + if (isset($_SESSION['s_old'])&& ($_SESSION['s_old']['user']['typ'] == 'admin' || $app->auth->has_clients($_SESSION['s_old']['user']['userid']))){ + /* The "old" user is admin or reseller, so everything is ok + * if he is reseller, we need to check if he logs in to one of his clients + */ + if($_SESSION['s_old']['user']['typ'] != 'admin') { + + /* this is the one currently logged in (normal user) */ + $old_client_group_id = $app->functions->intval($_SESSION["s"]["user"]["default_group"]); + $old_client = $app->db->queryOneRecord("SELECT client.client_id, client.parent_client_id FROM sys_group, client WHERE sys_group.client_id = client.client_id and sys_group.groupid = $old_client_group_id"); + + /* this is the reseller, that shall be re-logged in */ + $sql = "SELECT * FROM sys_user WHERE USERNAME = '$username' and PASSWORT = '". $passwort. "'"; + $tmp = $app->db->queryOneRecord($sql); + $client_group_id = $app->functions->intval($tmp['default_group']); + $tmp_client = $app->db->queryOneRecord("SELECT client.client_id FROM sys_group, client WHERE sys_group.client_id = client.client_id and sys_group.groupid = $client_group_id"); + + if(!$tmp_client || $old_client["parent_client_id"] != $tmp_client["client_id"] || $tmp["default_group"] != $_SESSION["s_old"]["user"]["default_group"] ) { + die("You don't have the right to 'login as' this user!"); + } + unset($old_client); + unset($tmp_client); + unset($tmp); + } } else { die("You don't have the right to 'login as'!"); } + } elseif($_SESSION['s']['user']['typ'] != 'admin') { + /* a reseller wants to 'login as', we need to check if he is allowed to */ + $res_client_group_id = $app->functions->intval($_SESSION["s"]["user"]["default_group"]); + $res_client = $app->db->queryOneRecord("SELECT client.client_id FROM sys_group, client WHERE sys_group.client_id = client.client_id and sys_group.groupid = $res_client_group_id"); + + /* this is the user the reseller wants to 'login as' */ + $sql = "SELECT * FROM sys_user WHERE USERNAME = '$username' and PASSWORT = '". $passwort. "'"; + $tmp = $app->db->queryOneRecord($sql); + $tmp_client = $app->db->queryOneRecord("SELECT client.client_id, client.parent_client_id FROM sys_group, client WHERE sys_group.client_id = client.client_id and sys_group.groupid = " . $app->functions->intval($tmp["default_group"])); + + if(!$tmp || $tmp_client["parent_client_id"] != $res_client["client_id"]) { + die("You don't have the right to login as this user!"); + } + unset($res_client); + unset($tmp); + unset($tmp_client); } $loginAs = true; } diff --git a/interface/web/admin/lib/lang/ar_login_as.lng b/interface/web/login/lib/lang/ar_login_as.lng similarity index 100% rename from interface/web/admin/lib/lang/ar_login_as.lng rename to interface/web/login/lib/lang/ar_login_as.lng diff --git a/interface/web/admin/lib/lang/bg_login_as.lng b/interface/web/login/lib/lang/bg_login_as.lng similarity index 100% rename from interface/web/admin/lib/lang/bg_login_as.lng rename to interface/web/login/lib/lang/bg_login_as.lng diff --git a/interface/web/admin/lib/lang/br_login_as.lng b/interface/web/login/lib/lang/br_login_as.lng similarity index 100% rename from interface/web/admin/lib/lang/br_login_as.lng rename to interface/web/login/lib/lang/br_login_as.lng diff --git a/interface/web/admin/lib/lang/cz_login_as.lng b/interface/web/login/lib/lang/cz_login_as.lng similarity index 100% rename from interface/web/admin/lib/lang/cz_login_as.lng rename to interface/web/login/lib/lang/cz_login_as.lng diff --git a/interface/web/admin/lib/lang/de_login_as.lng b/interface/web/login/lib/lang/de_login_as.lng similarity index 100% rename from interface/web/admin/lib/lang/de_login_as.lng rename to interface/web/login/lib/lang/de_login_as.lng diff --git a/interface/web/admin/lib/lang/el_login_as.lng b/interface/web/login/lib/lang/el_login_as.lng similarity index 100% rename from interface/web/admin/lib/lang/el_login_as.lng rename to interface/web/login/lib/lang/el_login_as.lng diff --git a/interface/web/admin/lib/lang/en_login_as.lng b/interface/web/login/lib/lang/en_login_as.lng similarity index 100% rename from interface/web/admin/lib/lang/en_login_as.lng rename to interface/web/login/lib/lang/en_login_as.lng diff --git a/interface/web/admin/lib/lang/es_login_as.lng b/interface/web/login/lib/lang/es_login_as.lng similarity index 100% rename from interface/web/admin/lib/lang/es_login_as.lng rename to interface/web/login/lib/lang/es_login_as.lng diff --git a/interface/web/admin/lib/lang/fi_login_as.lng b/interface/web/login/lib/lang/fi_login_as.lng similarity index 100% rename from interface/web/admin/lib/lang/fi_login_as.lng rename to interface/web/login/lib/lang/fi_login_as.lng diff --git a/interface/web/admin/lib/lang/fr_login_as.lng b/interface/web/login/lib/lang/fr_login_as.lng similarity index 100% rename from interface/web/admin/lib/lang/fr_login_as.lng rename to interface/web/login/lib/lang/fr_login_as.lng diff --git a/interface/web/admin/lib/lang/hr_login_as.lng b/interface/web/login/lib/lang/hr_login_as.lng similarity index 100% rename from interface/web/admin/lib/lang/hr_login_as.lng rename to interface/web/login/lib/lang/hr_login_as.lng diff --git a/interface/web/admin/lib/lang/hu_login_as.lng b/interface/web/login/lib/lang/hu_login_as.lng similarity index 100% rename from interface/web/admin/lib/lang/hu_login_as.lng rename to interface/web/login/lib/lang/hu_login_as.lng diff --git a/interface/web/admin/lib/lang/id_login_as.lng b/interface/web/login/lib/lang/id_login_as.lng similarity index 100% rename from interface/web/admin/lib/lang/id_login_as.lng rename to interface/web/login/lib/lang/id_login_as.lng diff --git a/interface/web/admin/lib/lang/it_login_as.lng b/interface/web/login/lib/lang/it_login_as.lng similarity index 100% rename from interface/web/admin/lib/lang/it_login_as.lng rename to interface/web/login/lib/lang/it_login_as.lng diff --git a/interface/web/admin/lib/lang/ja_login_as.lng b/interface/web/login/lib/lang/ja_login_as.lng similarity index 100% rename from interface/web/admin/lib/lang/ja_login_as.lng rename to interface/web/login/lib/lang/ja_login_as.lng diff --git a/interface/web/admin/lib/lang/nl_login_as.lng b/interface/web/login/lib/lang/nl_login_as.lng similarity index 100% rename from interface/web/admin/lib/lang/nl_login_as.lng rename to interface/web/login/lib/lang/nl_login_as.lng diff --git a/interface/web/admin/lib/lang/pl_login_as.lng b/interface/web/login/lib/lang/pl_login_as.lng similarity index 100% rename from interface/web/admin/lib/lang/pl_login_as.lng rename to interface/web/login/lib/lang/pl_login_as.lng diff --git a/interface/web/admin/lib/lang/pt_login_as.lng b/interface/web/login/lib/lang/pt_login_as.lng similarity index 100% rename from interface/web/admin/lib/lang/pt_login_as.lng rename to interface/web/login/lib/lang/pt_login_as.lng diff --git a/interface/web/admin/lib/lang/ro_login_as.lng b/interface/web/login/lib/lang/ro_login_as.lng similarity index 100% rename from interface/web/admin/lib/lang/ro_login_as.lng rename to interface/web/login/lib/lang/ro_login_as.lng diff --git a/interface/web/admin/lib/lang/ru_login_as.lng b/interface/web/login/lib/lang/ru_login_as.lng similarity index 100% rename from interface/web/admin/lib/lang/ru_login_as.lng rename to interface/web/login/lib/lang/ru_login_as.lng diff --git a/interface/web/admin/lib/lang/se_login_as.lng b/interface/web/login/lib/lang/se_login_as.lng similarity index 100% rename from interface/web/admin/lib/lang/se_login_as.lng rename to interface/web/login/lib/lang/se_login_as.lng diff --git a/interface/web/admin/lib/lang/sk_login_as.lng b/interface/web/login/lib/lang/sk_login_as.lng similarity index 100% rename from interface/web/admin/lib/lang/sk_login_as.lng rename to interface/web/login/lib/lang/sk_login_as.lng diff --git a/interface/web/admin/lib/lang/tr_login_as.lng b/interface/web/login/lib/lang/tr_login_as.lng similarity index 100% rename from interface/web/admin/lib/lang/tr_login_as.lng rename to interface/web/login/lib/lang/tr_login_as.lng diff --git a/interface/web/admin/login_as.php b/interface/web/login/login_as.php similarity index 75% rename from interface/web/admin/login_as.php rename to interface/web/login/login_as.php index 3d0fbf8..ed2dc9e 100644 --- a/interface/web/admin/login_as.php +++ b/interface/web/login/login_as.php @@ -31,11 +31,13 @@ require_once '../../lib/config.inc.php'; require_once '../../lib/app.inc.php'; -/* Check permissions for module */ -$app->auth->check_module_permissions('admin'); +/* check if the user is logged in */ +if(!isset($_SESSION['s']['user'])) { + die ("You have to be logged in to login as other user!"); +} -/* for security reasons ONLY the admin can login as other user */ -if ($_SESSION["s"]["user"]["typ"] != 'admin') { +/* for security reasons ONLY the admin or a reseller can login as other user */ +if ($_SESSION["s"]["user"]["typ"] != 'admin' && !$app->auth->has_clients($_SESSION['s']['user']['userid'])) { die ("You don't have the right to login as other user!"); } @@ -45,13 +47,26 @@ } if(isset($_GET['id'])) { + if($_SESSION["s"]["user"]["typ"] != 'admin') { + die ("You don't have the right to login as system user!"); + } $userId = $app->functions->intval($_GET['id']); $backlink = 'admin/users_list.php'; } else { $client_id = $app->functions->intval($_GET['cid']); - $tmp_client = $app->db->queryOneRecord("SELECT username FROM client WHERE client_id = $client_id"); + $tmp_client = $app->db->queryOneRecord("SELECT username, parent_client_id FROM client WHERE client_id = $client_id"); $tmp_sys_user = $app->db->queryOneRecord("SELECT userid FROM sys_user WHERE username = '".$app->db->quote($tmp_client['username'])."'"); $userId = $app->functions->intval($tmp_sys_user['userid']); + /* check if this client belongs to reseller that tries to log in, if we are not admin */ + if($_SESSION["s"]["user"]["typ"] != 'admin') { + $client_group_id = $app->functions->intval($_SESSION["s"]["user"]["default_group"]); + $client = $app->db->queryOneRecord("SELECT client.client_id FROM sys_group, client WHERE sys_group.client_id = client.client_id and sys_group.groupid = $client_group_id"); + if(!$client || $tmp_client["parent_client_id"] != $client["client_id"]) { + die("You don't have the right to login as this user!"); + } + unset($client); + } + unset($tmp_client); unset($tmp_sys_user); $backlink = 'client/client_list.php'; diff --git a/interface/web/login/logout.php b/interface/web/login/logout.php index b2b1ac2..5e79629 100644 --- a/interface/web/login/logout.php +++ b/interface/web/login/logout.php @@ -40,11 +40,12 @@ * if the admin is logged in as client, then ask, if the admin want't to * "re-login" as admin again */ -if ((isset($_SESSION['s_old']) && ($_SESSION['s_old']['user']['typ'] == 'admin')) && +if ((isset($_SESSION['s_old']) && ($_SESSION['s_old']['user']['typ'] == 'admin' || $app->auth->has_clients($_SESSION['s_old']['user']['userid']))) && (!$forceLogout)){ + $utype = ($_SESSION['s_old']['user']['typ'] == 'admin' ? 'admin' : 'reseller'); echo ' <br /> <br /> <br /> <br /> - Do you want to re-login as admin or log out?<br /> + Do you want to re-login as ' . $utype . ' or log out?<br /> <div style="visibility:hidden"> <input type="text" name="username" value="' . $_SESSION['s_old']['user']['username'] . '" /> <input type="password" name="passwort" value="' . $_SESSION['s_old']['user']['passwort'] .'" /> @@ -52,7 +53,7 @@ <input type="hidden" name="s_mod" value="login" /> <input type="hidden" name="s_pg" value="index" /> <div class="wf_actions buttons"> - <button class="positive iconstxt icoPositive" type="button" value="Yes, re-login as Admin" onclick="submitLoginForm(' . "'pageForm'" . ');"><span>Yes, re-login as Admin</span></button> + <button class="positive iconstxt icoPositive" type="button" value="Yes, re-login as ' . $utype . '" onclick="submitLoginForm(' . "'pageForm'" . ');"><span>Yes, re-login as ' . $utype . '</span></button> <button class="negative iconstxt icoNegative" type="button" value="No, logout" onclick="loadContent('. "'login/logout.php?l=1'" . ');"><span>No, logout</span></button> </div> '; -- Gitblit v1.9.1