X-Git-Url: https://delta.frontaccounting.com/gitweb/?a=blobdiff_plain;ds=sidebyside;f=gl%2Fmanage%2Fgl_account_types.php;h=27141d53d326f8f423c64a77079cdc8276cddf93;hb=2a42ffb56ef6651b8a136cd89271e65d397d7677;hp=b4ca18665f55ce9ea2d70438c53a0c7292333228;hpb=56631aa65f39f4f2471f1e31350f5b6c912cabbf;p=fa-stable.git diff --git a/gl/manage/gl_account_types.php b/gl/manage/gl_account_types.php index b4ca1866..27141d53 100644 --- a/gl/manage/gl_account_types.php +++ b/gl/manage/gl_account_types.php @@ -77,8 +77,10 @@ function can_delete($selected_id) { if ($selected_id == -1) return false; + $type = db_escape($selected_id); + $sql= "SELECT COUNT(*) FROM ".TB_PREF."chart_master - WHERE account_type=$selected_id"; + WHERE account_type=$type"; $result = db_query($sql, "could not query chart master"); $myrow = db_fetch_row($result); if ($myrow[0] > 0) @@ -88,7 +90,7 @@ function can_delete($selected_id) } $sql= "SELECT COUNT(*) FROM ".TB_PREF."chart_types - WHERE parent=$selected_id"; + WHERE parent=$type"; $result = db_query($sql, "could not query chart types"); $myrow = db_fetch_row($result); if ($myrow[0] > 0) @@ -109,7 +111,7 @@ if ($Mode == 'Delete') if (can_delete($selected_id)) { delete_account_type($selected_id); - display_notification(_('Selected currency has been deleted')); + display_notification(_('Selected account group has been deleted')); } $Mode = 'RESET'; }