FreenetIS

"CREATE TABLE IF NOT EXISTS `logs` (

`id` int(11) NOT NULL AUTO_INCREMENT,

`table_name` varchar(255) COLLATE utf8_czech_ci NOT NULL,

`values` text COLLATE utf8_czech_ci NOT NULL,

`time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP,

`user` varchar(255) COLLATE utf8_czech_ci NOT NULL,

PRIMARY KEY (`id`)

) ENGINE=InnoDB DEFAULT CHARSET=utf8 COLLATE=utf8_czech_ci AUTO_INCREMENT=1;"

<?php

$upgrade_sql[364] = array(

"ALTER TABLE `members` CHANGE `urban_neighbourhood` `quarter` VARCHAR( 50 )

CHARACTER SET utf8 COLLATE utf8_czech_ci NULL DEFAULT NULL;",

"UPDATE `axo` SET `name` = 'Podvojne ucty' WHERE `axo`.`id` =96 LIMIT 1 ;",

"UPDATE `axo` SET `name` = 'Podvojne prevody' WHERE `axo`.`id` =95 LIMIT 1 ;",

"UPDATE `axo` SET `value` = 'additional_contacts' WHERE `value` = 'aditional_contacts'",

"UPDATE `axo_map` SET `value` = 'additional_contacts' WHERE `value` = 'aditional_contacts'",

"INSERT INTO `axo` (`id`, `section_value`, `value`, `order_value`, `name`, `hidden`) VALUES

(133, 'Members_Controller', 'leaving_date', 0, 'Vystupni datum', 0),

(134, 'Accounts_Controller', 'bank_transfers', 0, 'Bankovni prevody', 0),

(135, 'Accounts_Controller', 'bank_accounts', 0, 'Bankovni ucty', 0),

(136, 'Accounts_Controller', 'unidentified_transfers', 0, 'Neidentifikovane platby', 0),

(137, 'Devices_Controller', 'wireless_setting', 0, 'Bezdratove nastaveni', 0);",

"INSERT INTO `axo_map` (`acl_id`, `section_value`, `value`) VALUES

(38, 'Devices_Controller', 'wireless_setting'),

(38, 'Members_Controller', 'leaving_date'),

(38, 'Accounts_Controller', 'bank_accounts'),

(38, 'Accounts_Controller', 'bank_transfers'),

(38, 'Accounts_Controller', 'accounts'),

(38, 'Accounts_Controller', 'unidentifed_transfers'),

(47, 'Devices_Controller', 'wireless_setting'),

(49, 'Devices_Controller', 'wireless_setting'),

(51, 'Members_Controller', 'leaving_date'),

(51, 'Accounts_Controller', 'accounts'),

(51, 'Accounts_Controller', 'bank_accounts'),

(51, 'Accounts_Controller', 'bank_transfers'),

(51, 'Accounts_Controller', 'invoices'),

(51, 'Accounts_Controller', 'transfers'),

(51, 'Accounts_Controller', 'unidentifed_transfers'),

(52, 'Devices_Controller', 'wireless_setting'),

(56, 'Accounts_Controller', 'accounts'),

(56, 'Accounts_Controller', 'bank_accounts'),

(56, 'Accounts_Controller', 'bank_transfers'),

(56, 'Accounts_Controller', 'invoices'),

(56, 'Accounts_Controller', 'transfers'),

(56, 'Accounts_Controller', 'unidentifed_transfers'),

(56, 'Devices_Controller', 'wireless_setting');"

);

?>

// saving id in array

$values = array();

$values['id'] = $this->object->id;

$values = array_merge($values, $data);

// insert line to log table

self::$db->insert('logs', array('table_name' => $this->table, 'values' => print_r($values,TRUE), 'user' => $_SESSION['member_login'].' - '.$_SESSION['user_name'].' '.$_SESSION['user_surname']));