MySQL : protection longueurs catégories

Alkarex · Alkarex · commit 94c5f41f6d66 · 2013-11-11T22:27:11.000+01:00
diff --git a/app/models/Category.php b/app/models/Category.php
@@ -95,8 +95,8 @@ public function addCategory ($valuesTmp) {
 
 		$values = array (
 			$valuesTmp['id'],
-			$valuesTmp['name'],
-			$valuesTmp['color'],
+			substr($valuesTmp['name'], 0, 255),
+			substr($valuesTmp['color'], 0, 7),
 		);
 
 		if ($stm && $stm->execute ($values)) {
diff --git a/public/install.php b/public/install.php
@@ -13,7 +13,7 @@
 define ('SQL_REQ_CAT', 'CREATE TABLE IF NOT EXISTS `%scategory` (
   `id` char(6) NOT NULL,
   `name` varchar(255) NOT NULL,
-  `color` varchar(7) NOT NULL,
+  `color` char(7) NOT NULL,
   PRIMARY KEY (`id`),
   INDEX (`name`)
 );');
@@ -26,7 +26,7 @@
   `website` varchar(255) NOT NULL,
   `description` varchar(1023) NOT NULL,
   `lastUpdate` int(11) NOT NULL,
-  `priority` tinyint NOT NULL DEFAULT \'10\',
+  `priority` tinyint(2) NOT NULL DEFAULT \'10\',
   `pathEntries` varchar(511) DEFAULT NULL,
   `httpAuth` varchar(511) DEFAULT NULL,
   `error` boolean NOT NULL DEFAULT \'0\',
