From f2615a08f14396ec7209aa55e8f9b6e0e32a365a Mon Sep 17 00:00:00 2001
From: Nicolas Boisselier <nicolas.boisselier@gmail.com>
Date: Mon, 4 Dec 2017 23:25:48 +0000
Subject: [PATCH] lib/db/shell.php

---
 lib/php/db/shell.php | 12 +++++++-----
 1 file changed, 7 insertions(+), 5 deletions(-)

diff --git a/lib/php/db/shell.php b/lib/php/db/shell.php
index 0f517375..517dadf0 100755
--- a/lib/php/db/shell.php
+++ b/lib/php/db/shell.php
@@ -15,7 +15,7 @@ Db::pdef('format','human');
 $Db = null;
 $Table = null;
 
-$no_reset_params = [
+$NO_RESET_PARAMS = [
   'db',
   'table',
   'format',
@@ -48,7 +48,7 @@ action,a=[ls,reset]
   # Status
   if ($line == 'status' or $line == 's') {
     $line = str_repeat('-',20)."\n";
-    print_r(DB::p());
+    print_r(Db::p());
     continue;
   }
 
@@ -67,7 +67,7 @@ action,a=[ls,reset]
 }
 
 function db_shell_action($k,$v) {
-  global $DB_CONFS, $Db, $Table;
+  global $DB_CONFS, $Db, $Table, $NO_RESET_PARAMS;
   Db::pset($k,$v);
   $changed = [];
   Db::pinit($changed);
@@ -79,7 +79,7 @@ function db_shell_action($k,$v) {
 
       if ($v == 'reset') {
         $keep = [];
-        foreach (Db::p() as $k => $v) { if (in_array($k,$no_reset_params)) $keep[$k] = $v; }
+        foreach (Db::p() as $k => $v) { if (in_array($k,$NO_RESET_PARAMS)) $keep[$k] = $v; }
         $_REQUEST = [];
         $_POST = [];
         foreach ($keep as $k => $v) { Db::pset($k,$v); }
@@ -89,6 +89,7 @@ function db_shell_action($k,$v) {
 
       #bye($Db::p());
       if (Db::p('debug') == 'shell') {
+        #debug(['action'=>$v,Db::p()]);
         debug(Db::p());
         break;
       }
@@ -101,6 +102,7 @@ function db_shell_action($k,$v) {
         echo "!Database is missing, use db= or try help\n";
         break;
       }
+
       $Db->action($Db->p('action'),$Table);
       break;
 
@@ -120,7 +122,7 @@ function db_shell_action($k,$v) {
       break;
 
     case 'format':
-      if (isset($Db)) $DB->format = $v;
+      if (isset($Db)) $Db->format = $v;
       break;
 
     default:
-- 
2.47.3