Page MenuHomeGitPull.it
Files F13209963

No OneTemporary
Actions

Size
3 KB
Referenced Files
None
Subscribers
None

View Options

diff --git a/plugin/Audit/Audit.php b/plugin/Audit/Audit.php
index d4cbb16e1..0fe44e085 100644
--- a/plugin/Audit/Audit.php
+++ b/plugin/Audit/Audit.php
@@ -1,36 +1,45 @@
<?php
global $global;
require_once $global['systemRootPath'] . 'plugin/Plugin.abstract.php';
require_once $global['systemRootPath'] . 'plugin/Audit/Objects/AuditTable.php';
class Audit extends PluginAbstract {
public function getDescription() {
return "Save all insert, update and delete queries for audit";
}
public function getName() {
return "Audit";
}
public function getUUID() {
return "26570956-dc62-46e3-ace9-86c6e8f9c81b";
}
public function getPluginVersion() {
- return "1.0";
+ return "2.0";
}
public function getPluginMenu(){
global $global;
$filename = $global['systemRootPath'] . 'plugin/Audit/pluginMenu.html';
return file_get_contents($filename);
}
function exec($method, $class, $statement, $formats, $values, $users_id) {
$audit = new AuditTable(0);
return $audit->audit($method, $class, $statement, $formats, $values, $users_id);
}
+
+ public function updateScript() {
+ global $global;
+ //update version 2.0
+ if(AVideoPlugin::compareVersion($this->getName(), "2.0")<0){
+ sqlDal::executeFile($global['systemRootPath'] . 'plugin/Audit/install/updateV2.0.sql');
+ }
+ return true;
+ }
}
diff --git a/plugin/Audit/install/audit.mwb b/plugin/Audit/install/audit.mwb
index 61c6242c8..32b056ecd 100644
Binary files a/plugin/Audit/install/audit.mwb and b/plugin/Audit/install/audit.mwb differ
diff --git a/plugin/Audit/install/audit.mwb.bak b/plugin/Audit/install/audit.mwb.bak
index fe2c3a658..b7f72f87b 100644
Binary files a/plugin/Audit/install/audit.mwb.bak and b/plugin/Audit/install/audit.mwb.bak differ
diff --git a/plugin/Audit/install/install.sql b/plugin/Audit/install/install.sql
index 21a6e49d2..9857f45a5 100644
--- a/plugin/Audit/install/install.sql
+++ b/plugin/Audit/install/install.sql
@@ -1,20 +1,20 @@
-- MySQL Workbench Forward Engineering
CREATE TABLE IF NOT EXISTS `audit` (
`id` INT NOT NULL AUTO_INCREMENT,
`method` VARCHAR(255) NULL,
`class` VARCHAR(255) NULL,
`statement` TEXT NULL,
- `ip` VARCHAR(45) NULL,
+ `ip` VARCHAR(255) NULL,
`users_id` INT NULL,
`formats` VARCHAR(45) NULL,
`values` TEXT NULL,
`created` DATETIME NULL,
PRIMARY KEY (`id`),
INDEX `fk_audit_users_idx` (`users_id` ASC),
CONSTRAINT `fk_audit_users`
FOREIGN KEY (`users_id`)
REFERENCES `users` (`id`)
ON DELETE NO ACTION
ON UPDATE NO ACTION)
ENGINE = InnoDB;
\ No newline at end of file
diff --git a/plugin/Audit/install/updateV2.0.sql b/plugin/Audit/install/updateV2.0.sql
new file mode 100644
index 000000000..16a802b8d
--- /dev/null
+++ b/plugin/Audit/install/updateV2.0.sql
@@ -0,0 +1,2 @@
+ALTER TABLE `audit`
+CHANGE COLUMN `ip` `ip` VARCHAR(255) NULL;
\ No newline at end of file
diff --git a/plugin/Audit/pluginMenu.html b/plugin/Audit/pluginMenu.html
index 371439ce3..e58afc94c 100644
--- a/plugin/Audit/pluginMenu.html
+++ b/plugin/Audit/pluginMenu.html
@@ -1 +1 @@
-<a href="plugin/Audit/page/editor.php" class="btn btn-primary btn-sm btn-xs"><i class="fa fa-edit"></i> Check Log</a>
\ No newline at end of file
+<a href="plugin/Audit/page/editor.php" class="btn btn-primary btn-sm btn-xs btn-block"><i class="fa fa-edit"></i> Check Log</a>
\ No newline at end of file

File Metadata

Mime Type
text/x-diff
Expires
Wed, Apr 22, 15:28 (1 d, 21 h)
Storage Engine
blob
Storage Format
Raw Data
Storage Handle
1862841
Default Alt Text
(3 KB)

Event Timeline

Public contents are in Creative Commons Attribution-ShareAlike 4.0 (CC-BY-SA) or GNU Free Documentation License (at your option) unless otherwise noted. · Contact / Register