Minor rewrites to brackets, admin welcome page rewritten to use GET_TOTAL_DATA()

[mailer.git] / inc / extensions / ext-booking.php

diff --git a/inc/extensions/ext-booking.php b/inc/extensions/ext-booking.php
index c438f0700435a1a79b3ce8872e0f813c79b80284..d940e27ae7cbb2754e7d67f6dd18d9be921fb060 100644 (file)
--- a/inc/extensions/ext-booking.php
+++ b/inc/extensions/ext-booking.php
@@ -56,11 +56,11 @@ case "register": // Do stuff when installation is running (modules.php?module=ad
        // Drop/create table for user bookings
        $SQLs[] = "DROP TABLE IF EXISTS `"._MYSQL_PREFIX."_user_book`";
        $SQLs[] = "CREATE TABLE `"._MYSQL_PREFIX."_user_book`(
-`id` BIGINT(20) NOT NULL AUTO_INCREMENT,
+`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 `userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 `subject` VARCHAR(255) NOT NULL DEFAULT 'missing',
 `mode` ENUM('add','sub') NOT NULL DEFAULT 'add',
-`points` DOUBLE(20,5) UNSIGNED NOT NULL DEFAULT 0.0000,
+`points` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.0000,
 INDEX (`userid`),
 PRIMARY KEY(`id`)
 ) TYPE=MyISAM COMMENT='Member points booking table'";
@@ -86,7 +86,7 @@ case "activate": // Do stuff when admin activates this extension
 
 case "deactivate": // Do stuff when admin deactivates this extension
        // SQL commands to run
-       $SQLs[] = "UPDATE `"._MYSQL_PREFIX."_member_menu` SET locked='Y' WHERE what='booking' LIMIT 1";
+       $SQLs[] = "UPDATE `"._MYSQL_PREFIX."_member_menu` SET visible='N', locked='Y' WHERE what='booking' LIMIT 1";
        break;
 
 case "update": // Update an extension