From def084a19a19e1d5c77600c0c0967e5a8fed5b93 Mon Sep 17 00:00:00 2001 From: Horus3 Date: Mon, 21 Apr 2014 18:35:43 +0200 Subject: Now you can get a full list of FILES or DIRECTORY from class files. Also changed database layout to log every up- and download. --- www/functions/func_register.php | 4 ++-- 1 file changed, 2 insertions(+), 2 deletions(-) (limited to 'www/functions/func_register.php') diff --git a/www/functions/func_register.php b/www/functions/func_register.php index 90cbd7d..b848866 100755 --- a/www/functions/func_register.php +++ b/www/functions/func_register.php @@ -59,9 +59,9 @@ function register($db){ if($db->exec(" BEGIN TRANSACTION; - UPDATE user SET name='" . $safe_name . "', password='" . $hash_password . "', invites=5, status=1, register=(SELECT datetime()), color_folder='DEFAULT', color_file='DEFAULT' WHERE id=" . $id . "; + UPDATE user SET name='" . $safe_name . "', password='" . $hash_password . "', invites=5, status=1, register=(SELECT strftime('%s', 'now')), color_folder='DEFAULT', color_file='DEFAULT' WHERE id=" . $id . "; INSERT INTO files (id, parent, owner, name, folder, mime, size, share, size, hash) VALUES (NULL, 0, $id, '/', 'DIRECTORY', NULL, NULL, 'PUBLIC', 0, ''); - INSERT INTO log (id, user, login) VALUES (NULL, (SELECT id FROM user WHERE name='" . $safe_name. "'), (SELECT datetime())); + INSERT INTO log (id, user, login) VALUES (NULL, (SELECT id FROM user WHERE name='" . $safe_name. "'), (SELECT strftime('%s', 'now')); COMMIT;") ){ -- cgit v1.2.3