From 37595945b02d6e45cfe1d524245a983615383944 Mon Sep 17 00:00:00 2001 From: Thomas Mudrunka Date: Sun, 29 Jul 2012 01:28:32 +0200 Subject: [PATCH] GUI pro locky --- assistants/lock.inc.php | 33 +++++++++++++++++++++++++++++++++ index.php | 2 +- 2 files changed, 34 insertions(+), 1 deletion(-) create mode 100644 assistants/lock.inc.php diff --git a/assistants/lock.inc.php b/assistants/lock.inc.php new file mode 100644 index 0000000..c042ee9 --- /dev/null +++ b/assistants/lock.inc.php @@ -0,0 +1,33 @@ +db->safe_query_fetch("SELECT * FROM `lock`;"); + if(empty($result)) { + echo 'Not locked...'; + $user=$this->db->auth->get_user_id(); + $username=$this->db->auth->get_username_by_id($user); + echo $this->html->form("$URL/2", 'POST', array( + array('reason',$username,'textarea',false,'autofocus','reason:'), + array('lock','lock','submit') + )); + } else { + echo $this->html->render_item_table($result); + echo $this->html->form("$URL/2", 'POST', array( + array('unlock','unlock','submit') + )); + } + + break; + case 2: + if(isset($_POST['lock'])) { + $lock = $this->db->quote($_POST['reason']); + $this->db->safe_query("INSERT INTO `lock` (lock_name) VALUES ($lock);"); + $this->post_redirect_get("$URL_INTERNAL/1", T('Lock set')); + } + if(isset($_POST['unlock'])) { + $this->db->safe_query("TRUNCATE TABLE `lock`;"); + $this->post_redirect_get("$URL_INTERNAL/1", T('Lock unset')); + } + $this->post_redirect_get("$URL_INTERNAL/1","Lock: No value passed!", true); + break; +} diff --git a/index.php b/index.php index 7467bbf..439ffae 100755 --- a/index.php +++ b/index.php @@ -743,7 +743,7 @@ class Sklad_DB extends PDO { function get_columns($class,$disable_cols=array()) { //TODO: Not sure if compatible with non-MySQL DBs $class = $this->escape($class); - $sql = "SHOW COLUMNS FROM $class;"; + $sql = "SHOW COLUMNS FROM `$class`;"; $columns = $this->safe_query_fetch($sql); /*foreach($columns as $colk => $col) foreach($col as $key => $val) { if(in_array($col['Field'],$disable_cols)) $columns[$colk]['Extra']='auto_increment'; -- 2.30.2