← All changes | src/Setup/Update/DatabaseUpdate4.php +40 -13 2.3.17 → 2.1.11 View file →

		@@ -1,33 +1,60 @@
1	1	<?php
2		-
3		-declare(strict_types=1);
4		-
	2	+/**
	3	+ * DatabaseUpdate4.php
	4	+ *
	5	+ * The DatabaseUpdate4 class file.
	6	+ *
	7	+ * PHP versions 5
	8	+ *
	9	+ * @author Alexander Schneider <[email protected]>
	10	+ * @copyright 2008-2017 Alexander Schneider
	11	+ * @license http://www.gnu.org/licenses/gpl-2.0.html GNU General Public License, version 2
	12	+ * @version SVN: $id$
	13	+ * @link http://wordpress.org/extend/plugins/user-access-manager/
	14	+ */
5	15	namespace UserAccessManager\Setup\Update;
6	16
7	17	use UserAccessManager\Object\ObjectHandler;
8	18	use UserAccessManager\Setup\Database\DatabaseUpdate;
9	19
	20	+/**
	21	+ * Class DatabaseUpdate4
	22	+ *
	23	+ * @package UserAccessManager\Setup\Update
	24	+ */
10	25	class DatabaseUpdate4 extends DatabaseUpdate
11	26	{
12		- public function getVersion(): string
	27	+ /**
	28	+ * Returns the version.
	29	+ *
	30	+ * @return string
	31	+ */
	32	+ public function getVersion()
13	33	{
14		- return '1.4.1';
	34	+ return '1.4';
15	35	}
16	36
17		- public function update(): bool
	37	+ /**
	38	+ * Executes the update.
	39	+ *
	40	+ * @return bool
	41	+ */
	42	+ public function update()
18	43	{
	44	+ $success = true;
	45	+
19	46	$dbAccessGroupToObject = $this->database->getUserGroupToObjectTable();
20	47	$alterQuery = "ALTER TABLE {$dbAccessGroupToObject}
21	48	ADD general_object_type VARCHAR(64) NOT NULL AFTER object_id";
22	49
23		- $success = $this->database->query($alterQuery) !== false;
	50	+ $success = $success && $this->database->query($alterQuery) !== false;
24	51
25	52	// Update post entries
26	53	$generalPostType = ObjectHandler::GENERAL_POST_OBJECT_TYPE;
27	54
28	55	$query = "UPDATE {$dbAccessGroupToObject}
29		- SET general_object_type = '$generalPostType'
	56	+ SET general_object_type = '{$generalPostType}'
30	57	WHERE object_type IN ('post', 'page', 'attachment')";
31	58
32	59	$success = $success && $this->database->query($query) !== false;
33	60
		@@ -34,9 +61,9 @@
34	61	// Update role entries
35	62	$generalRoleType = ObjectHandler::GENERAL_ROLE_OBJECT_TYPE;
36	63
37	64	$query = "UPDATE {$dbAccessGroupToObject}
38		- SET general_object_type = '$generalRoleType'
	65	+ SET general_object_type = '{$generalRoleType}'
39	66	WHERE object_type = 'role'";
40	67
41	68	$success = $success && $this->database->query($query) !== false;
42	69
		@@ -43,9 +70,9 @@
43	70	// Update user entries
44	71	$generalUserType = ObjectHandler::GENERAL_USER_OBJECT_TYPE;
45	72
46	73	$query = "UPDATE {$dbAccessGroupToObject}
47		- SET general_object_type = '$generalUserType'
	74	+ SET general_object_type = '{$generalUserType}'
48	75	WHERE object_type = 'user'";
49	76
50	77	$success = $success && $this->database->query($query) !== false;
51	78
		@@ -52,18 +79,18 @@
52	79	// Update term entries
53	80	$generalTermType = ObjectHandler::GENERAL_TERM_OBJECT_TYPE;
54	81
55	82	$query = "UPDATE {$dbAccessGroupToObject}
56		- SET general_object_type = '$generalTermType'
	83	+ SET general_object_type = '{$generalTermType}'
57	84	WHERE object_type = 'term'";
58	85
59	86	$success = $success && $this->database->query($query) !== false;
60	87
61		- $query = "UPDATE $dbAccessGroupToObject AS gto
	88	+ $query = "UPDATE {$dbAccessGroupToObject} AS gto
62	89	LEFT JOIN {$this->database->getTermTaxonomyTable()} AS tt
63	90	ON gto.object_id = tt.term_id
64	91	SET gto.object_type = tt.taxonomy
65		- WHERE gto.general_object_type = '$generalTermType'";
	92	+ WHERE gto.general_object_type = '{$generalTermType}'";
66	93
67	94	return $success && $this->database->query($query) !== false;
68	95	}
69	96	}