Set timestamp in created_at field when a new client record is created to fi...

tbrehm

2009-09-17 b488b5d101854508651f8a045006b4b9b8272afa

Set timestamp in created_at field when a new client record is created to fix
FS#880 - field created_at in table clients 

 install/sql/ispconfig3.sql

@@ -103,7 +103,7 @@
  `usertheme` varchar(32) NOT NULL default 'default',
  `template_master` int(11) unsigned NOT NULL default '0',
  `template_additional` varchar(255) NOT NULL default '',
  `created_at` datetime default NULL,
  `created_at` bigint(20) DEFAULT NULL,
  PRIMARY KEY  (`client_id`)
) ENGINE=MyISAM AUTO_INCREMENT=1;


 interface/web/client/client_edit.php

@@ -161,6 +161,8 @@
            $app->db->query("UPDATE client SET parent_client_id = ".intval($_SESSION['s']['user']['client_id'])." WHERE client_id = ".$this->id);

        }



        $app->db->query("UPDATE client SET created_at = ".time()." WHERE client_id = ".$this->id);

        /* If there is a client-template, process it */

        applyClientTemplates($this->id);