@@ -18,123 +18,123 @@ discard block |
||
18 | 18 | */ |
19 | 19 | class SmartobjectCategory extends SmartSeoObject |
20 | 20 | { |
21 | - public $_categoryPath; |
|
22 | - |
|
23 | - /** |
|
24 | - * SmartobjectCategory constructor. |
|
25 | - */ |
|
26 | - public function __construct() |
|
27 | - { |
|
28 | - $this->initVar('categoryid', XOBJ_DTYPE_INT, '', true); |
|
29 | - $this->initVar('parentid', XOBJ_DTYPE_INT, '', false, null, '', false, _CO_SOBJECT_CATEGORY_PARENTID, _CO_SOBJECT_CATEGORY_PARENTID_DSC); |
|
30 | - $this->initVar('name', XOBJ_DTYPE_TXTBOX, '', false, null, '', false, _CO_SOBJECT_CATEGORY_NAME, _CO_SOBJECT_CATEGORY_NAME_DSC); |
|
31 | - $this->initVar('description', XOBJ_DTYPE_TXTAREA, '', false, null, '', false, _CO_SOBJECT_CATEGORY_DESCRIPTION, _CO_SOBJECT_CATEGORY_DESCRIPTION_DSC); |
|
32 | - $this->initVar('image', XOBJ_DTYPE_TXTBOX, '', false, null, '', false, _CO_SOBJECT_CATEGORY_IMAGE, _CO_SOBJECT_CATEGORY_IMAGE_DSC); |
|
33 | - |
|
34 | - $this->initCommonVar('doxcode'); |
|
35 | - |
|
36 | - $this->setControl('image', array('name' => 'image')); |
|
37 | - $this->setControl('parentid', array('name' => 'parentcategory')); |
|
38 | - $this->setControl('description', array( |
|
39 | - 'name' => 'textarea', |
|
40 | - 'itemHandler' => false, |
|
41 | - 'method' => false, |
|
42 | - 'module' => false, |
|
43 | - 'form_editor' => 'default' |
|
44 | - )); |
|
45 | - |
|
46 | - // call parent constructor to get SEO fields initiated |
|
47 | - parent::__construct(); |
|
48 | - } |
|
49 | - |
|
50 | - /** |
|
51 | - * returns a specific variable for the object in a proper format |
|
52 | - * |
|
53 | - * @access public |
|
54 | - * @param string $key key of the object's variable to be returned |
|
55 | - * @param string $format format to use for the output |
|
56 | - * @return mixed formatted value of the variable |
|
57 | - */ |
|
58 | - public function getVar($key, $format = 's') |
|
59 | - { |
|
60 | - if ($format === 's' && in_array($key, array('description', 'image'))) { |
|
61 | - // return call_user_func(array($this, $key)); |
|
62 | - return $this->{$key}(); |
|
63 | - } |
|
64 | - |
|
65 | - return parent::getVar($key, $format); |
|
66 | - } |
|
67 | - |
|
68 | - /** |
|
69 | - * @return string |
|
70 | - */ |
|
71 | - public function description() |
|
72 | - { |
|
73 | - return $this->getValueFor('description', false); |
|
74 | - } |
|
75 | - |
|
76 | - /** |
|
77 | - * @return bool|mixed |
|
78 | - */ |
|
79 | - public function image() |
|
80 | - { |
|
81 | - $ret = $this->getVar('image', 'e'); |
|
82 | - if ($ret == '-1') { |
|
83 | - return false; |
|
84 | - } else { |
|
85 | - return $ret; |
|
86 | - } |
|
87 | - } |
|
88 | - |
|
89 | - /** |
|
90 | - * @return array |
|
91 | - */ |
|
92 | - public function toArray() |
|
93 | - { |
|
94 | - $this->setVar('doxcode', true); |
|
95 | - global $myts; |
|
96 | - $objectArray = parent::toArray(); |
|
97 | - if ($objectArray['image']) { |
|
98 | - $objectArray['image'] = $this->getImageDir() . $objectArray['image']; |
|
99 | - } |
|
100 | - |
|
101 | - return $objectArray; |
|
102 | - } |
|
103 | - |
|
104 | - /** |
|
105 | - * Create the complete path of a category |
|
106 | - * |
|
107 | - * @todo this could be improved as it uses multiple queries |
|
108 | - * @param bool $withAllLink make all name clickable |
|
109 | - * @param bool $currentCategory |
|
110 | - * @return string complete path (breadcrumb) |
|
111 | - */ |
|
112 | - public function getCategoryPath($withAllLink = true, $currentCategory = false) |
|
113 | - { |
|
114 | - require_once SMARTOBJECT_ROOT_PATH . 'class/smartobjectcontroller.php'; |
|
115 | - $controller = new SmartObjectController($this->handler); |
|
116 | - |
|
117 | - if (!$this->_categoryPath) { |
|
118 | - if ($withAllLink && !$currentCategory) { |
|
119 | - $ret = $controller->getItemLink($this); |
|
120 | - } else { |
|
121 | - $currentCategory = false; |
|
122 | - $ret = $this->getVar('name'); |
|
123 | - } |
|
124 | - $parentid = $this->getVar('parentid'); |
|
125 | - if ($parentid != 0) { |
|
126 | - $parentObj = $this->handler->get($parentid); |
|
127 | - if ($parentObj->isNew()) { |
|
128 | - exit; |
|
129 | - } |
|
130 | - $parentid = $parentObj->getVar('parentid'); |
|
131 | - $ret = $parentObj->getCategoryPath($withAllLink, $currentCategory) . ' > ' . $ret; |
|
132 | - } |
|
133 | - $this->_categoryPath = $ret; |
|
134 | - } |
|
135 | - |
|
136 | - return $this->_categoryPath; |
|
137 | - } |
|
21 | + public $_categoryPath; |
|
22 | + |
|
23 | + /** |
|
24 | + * SmartobjectCategory constructor. |
|
25 | + */ |
|
26 | + public function __construct() |
|
27 | + { |
|
28 | + $this->initVar('categoryid', XOBJ_DTYPE_INT, '', true); |
|
29 | + $this->initVar('parentid', XOBJ_DTYPE_INT, '', false, null, '', false, _CO_SOBJECT_CATEGORY_PARENTID, _CO_SOBJECT_CATEGORY_PARENTID_DSC); |
|
30 | + $this->initVar('name', XOBJ_DTYPE_TXTBOX, '', false, null, '', false, _CO_SOBJECT_CATEGORY_NAME, _CO_SOBJECT_CATEGORY_NAME_DSC); |
|
31 | + $this->initVar('description', XOBJ_DTYPE_TXTAREA, '', false, null, '', false, _CO_SOBJECT_CATEGORY_DESCRIPTION, _CO_SOBJECT_CATEGORY_DESCRIPTION_DSC); |
|
32 | + $this->initVar('image', XOBJ_DTYPE_TXTBOX, '', false, null, '', false, _CO_SOBJECT_CATEGORY_IMAGE, _CO_SOBJECT_CATEGORY_IMAGE_DSC); |
|
33 | + |
|
34 | + $this->initCommonVar('doxcode'); |
|
35 | + |
|
36 | + $this->setControl('image', array('name' => 'image')); |
|
37 | + $this->setControl('parentid', array('name' => 'parentcategory')); |
|
38 | + $this->setControl('description', array( |
|
39 | + 'name' => 'textarea', |
|
40 | + 'itemHandler' => false, |
|
41 | + 'method' => false, |
|
42 | + 'module' => false, |
|
43 | + 'form_editor' => 'default' |
|
44 | + )); |
|
45 | + |
|
46 | + // call parent constructor to get SEO fields initiated |
|
47 | + parent::__construct(); |
|
48 | + } |
|
49 | + |
|
50 | + /** |
|
51 | + * returns a specific variable for the object in a proper format |
|
52 | + * |
|
53 | + * @access public |
|
54 | + * @param string $key key of the object's variable to be returned |
|
55 | + * @param string $format format to use for the output |
|
56 | + * @return mixed formatted value of the variable |
|
57 | + */ |
|
58 | + public function getVar($key, $format = 's') |
|
59 | + { |
|
60 | + if ($format === 's' && in_array($key, array('description', 'image'))) { |
|
61 | + // return call_user_func(array($this, $key)); |
|
62 | + return $this->{$key}(); |
|
63 | + } |
|
64 | + |
|
65 | + return parent::getVar($key, $format); |
|
66 | + } |
|
67 | + |
|
68 | + /** |
|
69 | + * @return string |
|
70 | + */ |
|
71 | + public function description() |
|
72 | + { |
|
73 | + return $this->getValueFor('description', false); |
|
74 | + } |
|
75 | + |
|
76 | + /** |
|
77 | + * @return bool|mixed |
|
78 | + */ |
|
79 | + public function image() |
|
80 | + { |
|
81 | + $ret = $this->getVar('image', 'e'); |
|
82 | + if ($ret == '-1') { |
|
83 | + return false; |
|
84 | + } else { |
|
85 | + return $ret; |
|
86 | + } |
|
87 | + } |
|
88 | + |
|
89 | + /** |
|
90 | + * @return array |
|
91 | + */ |
|
92 | + public function toArray() |
|
93 | + { |
|
94 | + $this->setVar('doxcode', true); |
|
95 | + global $myts; |
|
96 | + $objectArray = parent::toArray(); |
|
97 | + if ($objectArray['image']) { |
|
98 | + $objectArray['image'] = $this->getImageDir() . $objectArray['image']; |
|
99 | + } |
|
100 | + |
|
101 | + return $objectArray; |
|
102 | + } |
|
103 | + |
|
104 | + /** |
|
105 | + * Create the complete path of a category |
|
106 | + * |
|
107 | + * @todo this could be improved as it uses multiple queries |
|
108 | + * @param bool $withAllLink make all name clickable |
|
109 | + * @param bool $currentCategory |
|
110 | + * @return string complete path (breadcrumb) |
|
111 | + */ |
|
112 | + public function getCategoryPath($withAllLink = true, $currentCategory = false) |
|
113 | + { |
|
114 | + require_once SMARTOBJECT_ROOT_PATH . 'class/smartobjectcontroller.php'; |
|
115 | + $controller = new SmartObjectController($this->handler); |
|
116 | + |
|
117 | + if (!$this->_categoryPath) { |
|
118 | + if ($withAllLink && !$currentCategory) { |
|
119 | + $ret = $controller->getItemLink($this); |
|
120 | + } else { |
|
121 | + $currentCategory = false; |
|
122 | + $ret = $this->getVar('name'); |
|
123 | + } |
|
124 | + $parentid = $this->getVar('parentid'); |
|
125 | + if ($parentid != 0) { |
|
126 | + $parentObj = $this->handler->get($parentid); |
|
127 | + if ($parentObj->isNew()) { |
|
128 | + exit; |
|
129 | + } |
|
130 | + $parentid = $parentObj->getVar('parentid'); |
|
131 | + $ret = $parentObj->getCategoryPath($withAllLink, $currentCategory) . ' > ' . $ret; |
|
132 | + } |
|
133 | + $this->_categoryPath = $ret; |
|
134 | + } |
|
135 | + |
|
136 | + return $this->_categoryPath; |
|
137 | + } |
|
138 | 138 | } |
139 | 139 | |
140 | 140 | /** |
@@ -142,91 +142,91 @@ discard block |
||
142 | 142 | */ |
143 | 143 | class SmartobjectCategoryHandler extends SmartPersistableObjectHandler |
144 | 144 | { |
145 | - public $allCategoriesObj = false; |
|
146 | - public $_allCategoriesId = false; |
|
147 | - |
|
148 | - /** |
|
149 | - * SmartobjectCategoryHandler constructor. |
|
150 | - * @param XoopsDatabase $db |
|
151 | - * @param $modulename |
|
152 | - */ |
|
153 | - public function __construct(XoopsDatabase $db, $modulename) |
|
154 | - { |
|
155 | - parent::__construct($db, 'category', 'categoryid', 'name', 'description', $modulename); |
|
156 | - } |
|
157 | - |
|
158 | - /** |
|
159 | - * @param int $parentid |
|
160 | - * @param bool $perm_name |
|
161 | - * @param string $sort |
|
162 | - * @param string $order |
|
163 | - * @return array|bool |
|
164 | - */ |
|
165 | - public function getAllCategoriesArray($parentid = 0, $perm_name = false, $sort = 'parentid', $order = 'ASC') |
|
166 | - { |
|
167 | - if (!$this->allCategoriesObj) { |
|
168 | - $criteria = new CriteriaCompo(); |
|
169 | - $criteria->setSort($sort); |
|
170 | - $criteria->setOrder($order); |
|
171 | - global $xoopsUser; |
|
172 | - $userIsAdmin = is_object($xoopsUser) && $xoopsUser->isAdmin(); |
|
173 | - |
|
174 | - if ($perm_name && !$userIsAdmin) { |
|
175 | - if (!$this->setGrantedObjectsCriteria($criteria, $perm_name)) { |
|
176 | - return false; |
|
177 | - } |
|
178 | - } |
|
179 | - |
|
180 | - $this->allCategoriesObj = $this->getObjects($criteria, 'parentid'); |
|
181 | - } |
|
182 | - |
|
183 | - $ret = array(); |
|
184 | - if (isset($this->allCategoriesObj[$parentid])) { |
|
185 | - foreach ($this->allCategoriesObj[$parentid] as $categoryid => $categoryObj) { |
|
186 | - $ret[$categoryid]['self'] = $categoryObj->toArray(); |
|
187 | - if (isset($this->allCategoriesObj[$categoryid])) { |
|
188 | - $ret[$categoryid]['sub'] = $this->getAllCategoriesArray($categoryid); |
|
189 | - $ret[$categoryid]['subcatscount'] = count($ret[$categoryid]['sub']); |
|
190 | - } |
|
191 | - } |
|
192 | - } |
|
193 | - |
|
194 | - return $ret; |
|
195 | - } |
|
196 | - |
|
197 | - /** |
|
198 | - * @param $parentid |
|
199 | - * @param bool $asString |
|
200 | - * @return array|string |
|
201 | - */ |
|
202 | - public function getParentIds($parentid, $asString = true) |
|
203 | - { |
|
204 | - if (!$this->allCategoriesId) { |
|
205 | - $ret = array(); |
|
206 | - $sql = 'SELECT categoryid, parentid FROM ' . $this->table . ' AS ' . $this->_itemname . ' ORDER BY parentid'; |
|
207 | - |
|
208 | - $result = $this->db->query($sql); |
|
209 | - |
|
210 | - if (!$result) { |
|
211 | - return $ret; |
|
212 | - } |
|
213 | - |
|
214 | - while ($myrow = $this->db->fetchArray($result)) { |
|
215 | - $this->allCategoriesId[$myrow['categoryid']] = $myrow['parentid']; |
|
216 | - } |
|
217 | - } |
|
218 | - |
|
219 | - $retArray = array($parentid); |
|
220 | - while ($parentid != 0) { |
|
221 | - $parentid = $this->allCategoriesId[$parentid]; |
|
222 | - if ($parentid != 0) { |
|
223 | - $retArray[] = $parentid; |
|
224 | - } |
|
225 | - } |
|
226 | - if ($asString) { |
|
227 | - return implode(', ', $retArray); |
|
228 | - } else { |
|
229 | - return $retArray; |
|
230 | - } |
|
231 | - } |
|
145 | + public $allCategoriesObj = false; |
|
146 | + public $_allCategoriesId = false; |
|
147 | + |
|
148 | + /** |
|
149 | + * SmartobjectCategoryHandler constructor. |
|
150 | + * @param XoopsDatabase $db |
|
151 | + * @param $modulename |
|
152 | + */ |
|
153 | + public function __construct(XoopsDatabase $db, $modulename) |
|
154 | + { |
|
155 | + parent::__construct($db, 'category', 'categoryid', 'name', 'description', $modulename); |
|
156 | + } |
|
157 | + |
|
158 | + /** |
|
159 | + * @param int $parentid |
|
160 | + * @param bool $perm_name |
|
161 | + * @param string $sort |
|
162 | + * @param string $order |
|
163 | + * @return array|bool |
|
164 | + */ |
|
165 | + public function getAllCategoriesArray($parentid = 0, $perm_name = false, $sort = 'parentid', $order = 'ASC') |
|
166 | + { |
|
167 | + if (!$this->allCategoriesObj) { |
|
168 | + $criteria = new CriteriaCompo(); |
|
169 | + $criteria->setSort($sort); |
|
170 | + $criteria->setOrder($order); |
|
171 | + global $xoopsUser; |
|
172 | + $userIsAdmin = is_object($xoopsUser) && $xoopsUser->isAdmin(); |
|
173 | + |
|
174 | + if ($perm_name && !$userIsAdmin) { |
|
175 | + if (!$this->setGrantedObjectsCriteria($criteria, $perm_name)) { |
|
176 | + return false; |
|
177 | + } |
|
178 | + } |
|
179 | + |
|
180 | + $this->allCategoriesObj = $this->getObjects($criteria, 'parentid'); |
|
181 | + } |
|
182 | + |
|
183 | + $ret = array(); |
|
184 | + if (isset($this->allCategoriesObj[$parentid])) { |
|
185 | + foreach ($this->allCategoriesObj[$parentid] as $categoryid => $categoryObj) { |
|
186 | + $ret[$categoryid]['self'] = $categoryObj->toArray(); |
|
187 | + if (isset($this->allCategoriesObj[$categoryid])) { |
|
188 | + $ret[$categoryid]['sub'] = $this->getAllCategoriesArray($categoryid); |
|
189 | + $ret[$categoryid]['subcatscount'] = count($ret[$categoryid]['sub']); |
|
190 | + } |
|
191 | + } |
|
192 | + } |
|
193 | + |
|
194 | + return $ret; |
|
195 | + } |
|
196 | + |
|
197 | + /** |
|
198 | + * @param $parentid |
|
199 | + * @param bool $asString |
|
200 | + * @return array|string |
|
201 | + */ |
|
202 | + public function getParentIds($parentid, $asString = true) |
|
203 | + { |
|
204 | + if (!$this->allCategoriesId) { |
|
205 | + $ret = array(); |
|
206 | + $sql = 'SELECT categoryid, parentid FROM ' . $this->table . ' AS ' . $this->_itemname . ' ORDER BY parentid'; |
|
207 | + |
|
208 | + $result = $this->db->query($sql); |
|
209 | + |
|
210 | + if (!$result) { |
|
211 | + return $ret; |
|
212 | + } |
|
213 | + |
|
214 | + while ($myrow = $this->db->fetchArray($result)) { |
|
215 | + $this->allCategoriesId[$myrow['categoryid']] = $myrow['parentid']; |
|
216 | + } |
|
217 | + } |
|
218 | + |
|
219 | + $retArray = array($parentid); |
|
220 | + while ($parentid != 0) { |
|
221 | + $parentid = $this->allCategoriesId[$parentid]; |
|
222 | + if ($parentid != 0) { |
|
223 | + $retArray[] = $parentid; |
|
224 | + } |
|
225 | + } |
|
226 | + if ($asString) { |
|
227 | + return implode(', ', $retArray); |
|
228 | + } else { |
|
229 | + return $retArray; |
|
230 | + } |
|
231 | + } |
|
232 | 232 | } |
@@ -11,7 +11,7 @@ discard block |
||
11 | 11 | */ |
12 | 12 | |
13 | 13 | // defined('XOOPS_ROOT_PATH') || exit('XOOPS root path not defined'); |
14 | -require_once XOOPS_ROOT_PATH . '/modules/smartobject/class/smartseoobject.php'; |
|
14 | +require_once XOOPS_ROOT_PATH.'/modules/smartobject/class/smartseoobject.php'; |
|
15 | 15 | |
16 | 16 | /** |
17 | 17 | * Class SmartobjectCategory |
@@ -95,7 +95,7 @@ discard block |
||
95 | 95 | global $myts; |
96 | 96 | $objectArray = parent::toArray(); |
97 | 97 | if ($objectArray['image']) { |
98 | - $objectArray['image'] = $this->getImageDir() . $objectArray['image']; |
|
98 | + $objectArray['image'] = $this->getImageDir().$objectArray['image']; |
|
99 | 99 | } |
100 | 100 | |
101 | 101 | return $objectArray; |
@@ -111,7 +111,7 @@ discard block |
||
111 | 111 | */ |
112 | 112 | public function getCategoryPath($withAllLink = true, $currentCategory = false) |
113 | 113 | { |
114 | - require_once SMARTOBJECT_ROOT_PATH . 'class/smartobjectcontroller.php'; |
|
114 | + require_once SMARTOBJECT_ROOT_PATH.'class/smartobjectcontroller.php'; |
|
115 | 115 | $controller = new SmartObjectController($this->handler); |
116 | 116 | |
117 | 117 | if (!$this->_categoryPath) { |
@@ -128,7 +128,7 @@ discard block |
||
128 | 128 | exit; |
129 | 129 | } |
130 | 130 | $parentid = $parentObj->getVar('parentid'); |
131 | - $ret = $parentObj->getCategoryPath($withAllLink, $currentCategory) . ' > ' . $ret; |
|
131 | + $ret = $parentObj->getCategoryPath($withAllLink, $currentCategory).' > '.$ret; |
|
132 | 132 | } |
133 | 133 | $this->_categoryPath = $ret; |
134 | 134 | } |
@@ -203,7 +203,7 @@ discard block |
||
203 | 203 | { |
204 | 204 | if (!$this->allCategoriesId) { |
205 | 205 | $ret = array(); |
206 | - $sql = 'SELECT categoryid, parentid FROM ' . $this->table . ' AS ' . $this->_itemname . ' ORDER BY parentid'; |
|
206 | + $sql = 'SELECT categoryid, parentid FROM '.$this->table.' AS '.$this->_itemname.' ORDER BY parentid'; |
|
207 | 207 | |
208 | 208 | $result = $this->db->query($sql); |
209 | 209 |
@@ -22,157 +22,157 @@ |
||
22 | 22 | */ |
23 | 23 | class SmartObjectTreeTable extends SmartObjectTable |
24 | 24 | { |
25 | - /** |
|
26 | - * SmartObjectTreeTable constructor. |
|
27 | - * @param SmartPersistableObjectHandler $objectHandler |
|
28 | - * @param bool $criteria |
|
29 | - * @param array $actions |
|
30 | - * @param bool $userSide |
|
31 | - */ |
|
32 | - public function __construct( |
|
33 | - SmartPersistableObjectHandler $objectHandler, |
|
34 | - $criteria = false, |
|
35 | - $actions = array('edit', 'delete'), |
|
36 | - $userSide = false |
|
37 | - ) { |
|
38 | - $this->SmartObjectTable($objectHandler, $criteria, $actions, $userSide); |
|
39 | - $this->_isTree = true; |
|
40 | - } |
|
41 | - |
|
42 | - /** |
|
43 | - * Get children objects given a specific parentid |
|
44 | - * |
|
45 | - * @var int $parentid id of the parent which children we want to retreive |
|
46 | - * @return array of SmartObject |
|
47 | - */ |
|
48 | - public function getChildrenOf($parentid = 0) |
|
49 | - { |
|
50 | - return isset($this->_objects[$parentid]) ? $this->_objects[$parentid] : false; |
|
51 | - } |
|
52 | - |
|
53 | - /** |
|
54 | - * @param $object |
|
55 | - * @param int $level |
|
56 | - */ |
|
57 | - public function createTableRow($object, $level = 0) |
|
58 | - { |
|
59 | - $aObject = array(); |
|
60 | - |
|
61 | - $i = 0; |
|
62 | - |
|
63 | - $aColumns = array(); |
|
64 | - $doWeHaveActions = false; |
|
65 | - |
|
66 | - foreach ($this->_columns as $column) { |
|
67 | - $aColumn = array(); |
|
68 | - |
|
69 | - if ($i == 0) { |
|
70 | - $class = 'head'; |
|
71 | - } elseif ($i % 2 == 0) { |
|
72 | - $class = 'even'; |
|
73 | - } else { |
|
74 | - $class = 'odd'; |
|
75 | - } |
|
76 | - |
|
77 | - if ($column->_customMethodForValue && method_exists($object, $column->_customMethodForValue)) { |
|
78 | - $method = $column->_customMethodForValue; |
|
79 | - $value = $object->$method(); |
|
80 | - } else { |
|
81 | - /** |
|
82 | - * If the column is the identifier, then put a link on it |
|
83 | - */ |
|
84 | - if ($column->getKeyName() == $this->_objectHandler->identifierName) { |
|
85 | - $value = $object->getItemLink(); |
|
86 | - } else { |
|
87 | - $value = $object->getVar($column->getKeyName()); |
|
88 | - } |
|
89 | - } |
|
90 | - |
|
91 | - $space = ''; |
|
92 | - if ($column->getKeyName() == $this->_objectHandler->identifierName) { |
|
93 | - for ($i = 0; $i < $level; ++$i) { |
|
94 | - $space .= '--'; |
|
95 | - } |
|
96 | - } |
|
97 | - |
|
98 | - if ($space !== '') { |
|
99 | - $space .= ' '; |
|
100 | - } |
|
101 | - |
|
102 | - $aColumn['value'] = $space . $value; |
|
103 | - $aColumn['class'] = $class; |
|
104 | - $aColumn['width'] = $column->getWidth(); |
|
105 | - $aColumn['align'] = $column->getAlign(); |
|
106 | - $aColumn['key'] = $column->getKeyName(); |
|
107 | - |
|
108 | - $aColumns[] = $aColumn; |
|
109 | - ++$i; |
|
110 | - } |
|
111 | - |
|
112 | - $aObject['columns'] = $aColumns; |
|
113 | - |
|
114 | - $class = $class === 'even' ? 'odd' : 'even'; |
|
115 | - $aObject['class'] = $class; |
|
116 | - |
|
117 | - $actions = array(); |
|
118 | - |
|
119 | - // Adding the custom actions if any |
|
120 | - foreach ($this->_custom_actions as $action) { |
|
121 | - if (method_exists($object, $action)) { |
|
122 | - $actions[] = $object->$action(); |
|
123 | - } |
|
124 | - } |
|
125 | - |
|
126 | - require_once SMARTOBJECT_ROOT_PATH . 'class/smartobjectcontroller.php'; |
|
127 | - $controller = new SmartObjectController($this->_objectHandler); |
|
128 | - |
|
129 | - if (in_array('edit', $this->_actions)) { |
|
130 | - $actions[] = $controller->getEditItemLink($object, false, true); |
|
131 | - } |
|
132 | - if (in_array('delete', $this->_actions)) { |
|
133 | - $actions[] = $controller->getDeleteItemLink($object, false, true); |
|
134 | - } |
|
135 | - $aObject['actions'] = $actions; |
|
136 | - |
|
137 | - $this->_tpl->assign('smartobject_actions_column_width', count($actions) * 30); |
|
138 | - $aObject['id'] = $object->id(); |
|
139 | - $this->_aObjects[] = $aObject; |
|
140 | - |
|
141 | - $childrenObjects = $this->getChildrenOf($object->id()); |
|
142 | - |
|
143 | - $this->_hasActions = $this->_hasActions ? true : count($actions) > 0; |
|
144 | - |
|
145 | - if ($childrenObjects) { |
|
146 | - ++$level; |
|
147 | - foreach ($childrenObjects as $subObject) { |
|
148 | - $this->createTableRow($subObject, $level); |
|
149 | - } |
|
150 | - } |
|
151 | - } |
|
152 | - |
|
153 | - public function createTableRows() |
|
154 | - { |
|
155 | - $this->_aObjects = array(); |
|
156 | - |
|
157 | - if (count($this->_objects) > 0) { |
|
158 | - foreach ($this->getChildrenOf() as $object) { |
|
159 | - $this->createTableRow($object); |
|
160 | - } |
|
161 | - |
|
162 | - $this->_tpl->assign('smartobject_objects', $this->_aObjects); |
|
163 | - } else { |
|
164 | - $colspan = count($this->_columns) + 1; |
|
165 | - $this->_tpl->assign('smartobject_colspan', $colspan); |
|
166 | - } |
|
167 | - } |
|
168 | - |
|
169 | - /** |
|
170 | - * @return mixed |
|
171 | - */ |
|
172 | - public function fetchObjects() |
|
173 | - { |
|
174 | - $ret = $this->_objectHandler->getObjects($this->_criteria, 'parentid'); |
|
175 | - |
|
176 | - return $ret; |
|
177 | - } |
|
25 | + /** |
|
26 | + * SmartObjectTreeTable constructor. |
|
27 | + * @param SmartPersistableObjectHandler $objectHandler |
|
28 | + * @param bool $criteria |
|
29 | + * @param array $actions |
|
30 | + * @param bool $userSide |
|
31 | + */ |
|
32 | + public function __construct( |
|
33 | + SmartPersistableObjectHandler $objectHandler, |
|
34 | + $criteria = false, |
|
35 | + $actions = array('edit', 'delete'), |
|
36 | + $userSide = false |
|
37 | + ) { |
|
38 | + $this->SmartObjectTable($objectHandler, $criteria, $actions, $userSide); |
|
39 | + $this->_isTree = true; |
|
40 | + } |
|
41 | + |
|
42 | + /** |
|
43 | + * Get children objects given a specific parentid |
|
44 | + * |
|
45 | + * @var int $parentid id of the parent which children we want to retreive |
|
46 | + * @return array of SmartObject |
|
47 | + */ |
|
48 | + public function getChildrenOf($parentid = 0) |
|
49 | + { |
|
50 | + return isset($this->_objects[$parentid]) ? $this->_objects[$parentid] : false; |
|
51 | + } |
|
52 | + |
|
53 | + /** |
|
54 | + * @param $object |
|
55 | + * @param int $level |
|
56 | + */ |
|
57 | + public function createTableRow($object, $level = 0) |
|
58 | + { |
|
59 | + $aObject = array(); |
|
60 | + |
|
61 | + $i = 0; |
|
62 | + |
|
63 | + $aColumns = array(); |
|
64 | + $doWeHaveActions = false; |
|
65 | + |
|
66 | + foreach ($this->_columns as $column) { |
|
67 | + $aColumn = array(); |
|
68 | + |
|
69 | + if ($i == 0) { |
|
70 | + $class = 'head'; |
|
71 | + } elseif ($i % 2 == 0) { |
|
72 | + $class = 'even'; |
|
73 | + } else { |
|
74 | + $class = 'odd'; |
|
75 | + } |
|
76 | + |
|
77 | + if ($column->_customMethodForValue && method_exists($object, $column->_customMethodForValue)) { |
|
78 | + $method = $column->_customMethodForValue; |
|
79 | + $value = $object->$method(); |
|
80 | + } else { |
|
81 | + /** |
|
82 | + * If the column is the identifier, then put a link on it |
|
83 | + */ |
|
84 | + if ($column->getKeyName() == $this->_objectHandler->identifierName) { |
|
85 | + $value = $object->getItemLink(); |
|
86 | + } else { |
|
87 | + $value = $object->getVar($column->getKeyName()); |
|
88 | + } |
|
89 | + } |
|
90 | + |
|
91 | + $space = ''; |
|
92 | + if ($column->getKeyName() == $this->_objectHandler->identifierName) { |
|
93 | + for ($i = 0; $i < $level; ++$i) { |
|
94 | + $space .= '--'; |
|
95 | + } |
|
96 | + } |
|
97 | + |
|
98 | + if ($space !== '') { |
|
99 | + $space .= ' '; |
|
100 | + } |
|
101 | + |
|
102 | + $aColumn['value'] = $space . $value; |
|
103 | + $aColumn['class'] = $class; |
|
104 | + $aColumn['width'] = $column->getWidth(); |
|
105 | + $aColumn['align'] = $column->getAlign(); |
|
106 | + $aColumn['key'] = $column->getKeyName(); |
|
107 | + |
|
108 | + $aColumns[] = $aColumn; |
|
109 | + ++$i; |
|
110 | + } |
|
111 | + |
|
112 | + $aObject['columns'] = $aColumns; |
|
113 | + |
|
114 | + $class = $class === 'even' ? 'odd' : 'even'; |
|
115 | + $aObject['class'] = $class; |
|
116 | + |
|
117 | + $actions = array(); |
|
118 | + |
|
119 | + // Adding the custom actions if any |
|
120 | + foreach ($this->_custom_actions as $action) { |
|
121 | + if (method_exists($object, $action)) { |
|
122 | + $actions[] = $object->$action(); |
|
123 | + } |
|
124 | + } |
|
125 | + |
|
126 | + require_once SMARTOBJECT_ROOT_PATH . 'class/smartobjectcontroller.php'; |
|
127 | + $controller = new SmartObjectController($this->_objectHandler); |
|
128 | + |
|
129 | + if (in_array('edit', $this->_actions)) { |
|
130 | + $actions[] = $controller->getEditItemLink($object, false, true); |
|
131 | + } |
|
132 | + if (in_array('delete', $this->_actions)) { |
|
133 | + $actions[] = $controller->getDeleteItemLink($object, false, true); |
|
134 | + } |
|
135 | + $aObject['actions'] = $actions; |
|
136 | + |
|
137 | + $this->_tpl->assign('smartobject_actions_column_width', count($actions) * 30); |
|
138 | + $aObject['id'] = $object->id(); |
|
139 | + $this->_aObjects[] = $aObject; |
|
140 | + |
|
141 | + $childrenObjects = $this->getChildrenOf($object->id()); |
|
142 | + |
|
143 | + $this->_hasActions = $this->_hasActions ? true : count($actions) > 0; |
|
144 | + |
|
145 | + if ($childrenObjects) { |
|
146 | + ++$level; |
|
147 | + foreach ($childrenObjects as $subObject) { |
|
148 | + $this->createTableRow($subObject, $level); |
|
149 | + } |
|
150 | + } |
|
151 | + } |
|
152 | + |
|
153 | + public function createTableRows() |
|
154 | + { |
|
155 | + $this->_aObjects = array(); |
|
156 | + |
|
157 | + if (count($this->_objects) > 0) { |
|
158 | + foreach ($this->getChildrenOf() as $object) { |
|
159 | + $this->createTableRow($object); |
|
160 | + } |
|
161 | + |
|
162 | + $this->_tpl->assign('smartobject_objects', $this->_aObjects); |
|
163 | + } else { |
|
164 | + $colspan = count($this->_columns) + 1; |
|
165 | + $this->_tpl->assign('smartobject_colspan', $colspan); |
|
166 | + } |
|
167 | + } |
|
168 | + |
|
169 | + /** |
|
170 | + * @return mixed |
|
171 | + */ |
|
172 | + public function fetchObjects() |
|
173 | + { |
|
174 | + $ret = $this->_objectHandler->getObjects($this->_criteria, 'parentid'); |
|
175 | + |
|
176 | + return $ret; |
|
177 | + } |
|
178 | 178 | } |
@@ -9,7 +9,7 @@ discard block |
||
9 | 9 | * @subpackage SmartObjectTable |
10 | 10 | */ |
11 | 11 | |
12 | -require_once SMARTOBJECT_ROOT_PATH . 'class/smartobjecttable.php'; |
|
12 | +require_once SMARTOBJECT_ROOT_PATH.'class/smartobjecttable.php'; |
|
13 | 13 | |
14 | 14 | /** |
15 | 15 | * SmartObjectTreeTable class |
@@ -99,7 +99,7 @@ discard block |
||
99 | 99 | $space .= ' '; |
100 | 100 | } |
101 | 101 | |
102 | - $aColumn['value'] = $space . $value; |
|
102 | + $aColumn['value'] = $space.$value; |
|
103 | 103 | $aColumn['class'] = $class; |
104 | 104 | $aColumn['width'] = $column->getWidth(); |
105 | 105 | $aColumn['align'] = $column->getAlign(); |
@@ -123,7 +123,7 @@ discard block |
||
123 | 123 | } |
124 | 124 | } |
125 | 125 | |
126 | - require_once SMARTOBJECT_ROOT_PATH . 'class/smartobjectcontroller.php'; |
|
126 | + require_once SMARTOBJECT_ROOT_PATH.'class/smartobjectcontroller.php'; |
|
127 | 127 | $controller = new SmartObjectController($this->_objectHandler); |
128 | 128 | |
129 | 129 | if (in_array('edit', $this->_actions)) { |
@@ -18,7 +18,7 @@ discard block |
||
18 | 18 | */ |
19 | 19 | // defined('XOOPS_ROOT_PATH') || exit('XOOPS root path not defined'); |
20 | 20 | if (!defined('SMARTOBJECT_ROOT_PATH')) { |
21 | - require_once XOOPS_ROOT_PATH . '/modules/smartobject/include/common.php'; |
|
21 | + require_once XOOPS_ROOT_PATH . '/modules/smartobject/include/common.php'; |
|
22 | 22 | } |
23 | 23 | /** |
24 | 24 | * Include the language constants for the SmartObjectDBUpdater |
@@ -26,7 +26,7 @@ discard block |
||
26 | 26 | global $xoopsConfig; |
27 | 27 | $common_file = SMARTOBJECT_ROOT_PATH . 'language/' . $xoopsConfig['language'] . '/smartdbupdater.php'; |
28 | 28 | if (!file_exists($common_file)) { |
29 | - $common_file = SMARTOBJECT_ROOT_PATH . 'language/english/smartdbupdater.php'; |
|
29 | + $common_file = SMARTOBJECT_ROOT_PATH . 'language/english/smartdbupdater.php'; |
|
30 | 30 | } |
31 | 31 | include $common_file; |
32 | 32 | |
@@ -35,503 +35,503 @@ discard block |
||
35 | 35 | */ |
36 | 36 | class SmartDbTable |
37 | 37 | { |
38 | - /** |
|
39 | - * @var string $_name name of the table |
|
40 | - */ |
|
41 | - public $_name; |
|
42 | - /** |
|
43 | - * @var string $_structure structure of the table |
|
44 | - */ |
|
45 | - public $_structure; |
|
46 | - |
|
47 | - /** |
|
48 | - * @var array $_data containing valued of each records to be added |
|
49 | - */ |
|
50 | - public $_data; |
|
51 | - |
|
52 | - /** |
|
53 | - * @var array $_alteredFields containing fields to be altered |
|
54 | - */ |
|
55 | - public $_alteredFields; |
|
56 | - |
|
57 | - /** |
|
58 | - * @var array $_newFields containing new fields to be added |
|
59 | - */ |
|
60 | - public $_newFields; |
|
61 | - |
|
62 | - /** |
|
63 | - * @var array $_droppedFields containing fields to be dropped |
|
64 | - */ |
|
65 | - public $_droppedFields; |
|
66 | - |
|
67 | - /** |
|
68 | - * @var array $_flagForDrop flag table to drop it |
|
69 | - */ |
|
70 | - public $_flagForDrop = false; |
|
71 | - |
|
72 | - /** |
|
73 | - * @var array $_updatedFields containing fields which values will be updated |
|
74 | - */ |
|
75 | - public $_updatedFields; |
|
76 | - |
|
77 | - /** |
|
78 | - * @var array $_updatedFields containing fields which values will be updated |
|
79 | - */ //felix |
|
80 | - public $_updatedWhere; |
|
81 | - |
|
82 | - public $_existingFieldsArray = false; |
|
83 | - |
|
84 | - /** |
|
85 | - * Constructor |
|
86 | - * |
|
87 | - * @param string $name name of the table |
|
88 | - * |
|
89 | - */ |
|
90 | - public function __construct($name) |
|
91 | - { |
|
92 | - $this->_name = $name; |
|
93 | - $this->_data = array(); |
|
94 | - } |
|
95 | - |
|
96 | - /** |
|
97 | - * Return the table name, prefixed with site table prefix |
|
98 | - * |
|
99 | - * @return string table name |
|
100 | - * |
|
101 | - */ |
|
102 | - public function name() |
|
103 | - { |
|
104 | - global $xoopsDB; |
|
105 | - |
|
106 | - return $xoopsDB->prefix($this->_name); |
|
107 | - } |
|
108 | - |
|
109 | - /** |
|
110 | - * Checks if the table already exists in the database |
|
111 | - * |
|
112 | - * @return bool TRUE if it exists, FALSE if not |
|
113 | - * |
|
114 | - */ |
|
115 | - public function exists() |
|
116 | - { |
|
117 | - return smart_TableExists($this->_name); |
|
118 | - } |
|
119 | - |
|
120 | - /** |
|
121 | - * @return mixed |
|
122 | - */ |
|
123 | - public function getExistingFieldsArray() |
|
124 | - { |
|
125 | - global $xoopsDB; |
|
126 | - $result = $xoopsDB->query('SHOW COLUMNS FROM ' . $this->name()); |
|
127 | - while ($existing_field = $xoopsDB->fetchArray($result)) { |
|
128 | - $fields[$existing_field['Field']] = $existing_field['Type']; |
|
129 | - if ($existing_field['Null'] !== 'YES') { |
|
130 | - $fields[$existing_field['Field']] .= ' NOT NULL'; |
|
131 | - } |
|
132 | - if ($existing_field['Extra']) { |
|
133 | - $fields[$existing_field['Field']] .= ' ' . $existing_field['Extra']; |
|
134 | - } |
|
135 | - if (!($existing_field['Default'] === null) |
|
136 | - && ($existing_field['Default'] |
|
137 | - || $existing_field['Default'] === '' |
|
138 | - || $existing_field['Default'] == 0)) { |
|
139 | - $fields[$existing_field['Field']] .= " default '" . $existing_field['Default'] . "'"; |
|
140 | - } |
|
141 | - } |
|
142 | - |
|
143 | - return $fields; |
|
144 | - } |
|
145 | - |
|
146 | - /** |
|
147 | - * @param $field |
|
148 | - * @return bool |
|
149 | - */ |
|
150 | - public function fieldExists($field) |
|
151 | - { |
|
152 | - $existingFields = $this->getExistingFieldsArray(); |
|
153 | - |
|
154 | - return isset($existingFields[$field]); |
|
155 | - } |
|
156 | - |
|
157 | - /** |
|
158 | - * Set the table structure |
|
159 | - * |
|
160 | - * Example: |
|
161 | - * |
|
162 | - * $table->setStructure("`transactionid` int(11) NOT NULL auto_increment, |
|
163 | - * `date` int(11) NOT NULL default '0', |
|
164 | - * `status` int(1) NOT NULL default '-1', |
|
165 | - * `itemid` int(11) NOT NULL default '0', |
|
166 | - * `uid` int(11) NOT NULL default '0', |
|
167 | - * `price` float NOT NULL default '0', |
|
168 | - * `currency` varchar(100) NOT NULL default '', |
|
169 | - * PRIMARY KEY (`transactionid`)"); |
|
170 | - * |
|
171 | - * @param string $structure table structure |
|
172 | - * |
|
173 | - */ |
|
174 | - public function setStructure($structure) |
|
175 | - { |
|
176 | - $this->_structure = $structure; |
|
177 | - } |
|
178 | - |
|
179 | - /** |
|
180 | - * Return the table structure |
|
181 | - * |
|
182 | - * @return string table structure |
|
183 | - * |
|
184 | - */ |
|
185 | - public function getStructure() |
|
186 | - { |
|
187 | - return sprintf($this->_structure, $this->name()); |
|
188 | - } |
|
189 | - |
|
190 | - /** |
|
191 | - * Add values of a record to be added |
|
192 | - * |
|
193 | - * @param string $data values of a record |
|
194 | - * |
|
195 | - */ |
|
196 | - public function setData($data) |
|
197 | - { |
|
198 | - $this->_data[] = $data; |
|
199 | - } |
|
200 | - |
|
201 | - /** |
|
202 | - * Get the data array |
|
203 | - * |
|
204 | - * @return array containing the records values to be added |
|
205 | - * |
|
206 | - */ |
|
207 | - public function getData() |
|
208 | - { |
|
209 | - return $this->_data; |
|
210 | - } |
|
211 | - |
|
212 | - /** |
|
213 | - * Use to insert data in a table |
|
214 | - * |
|
215 | - * @return bool true if success, false if an error occured |
|
216 | - * |
|
217 | - */ |
|
218 | - public function addData() |
|
219 | - { |
|
220 | - global $xoopsDB; |
|
221 | - foreach ($this->getData() as $data) { |
|
222 | - $query = sprintf('INSERT INTO %s VALUES (%s)', $this->name(), $data); |
|
223 | - $ret = $xoopsDB->query($query); |
|
224 | - if (!$ret) { |
|
225 | - echo ' ' . sprintf(_SDU_MSG_ADD_DATA_ERR, $this->name()) . '<br>'; |
|
226 | - } else { |
|
227 | - echo ' ' . sprintf(_SDU_MSG_ADD_DATA, $this->name()) . '<br>'; |
|
228 | - } |
|
229 | - } |
|
230 | - |
|
231 | - return $ret; |
|
232 | - } |
|
233 | - |
|
234 | - /** |
|
235 | - * Add a field to be added |
|
236 | - * |
|
237 | - * @param string $name name of the field |
|
238 | - * @param string $properties properties of the field |
|
239 | - * @param bool $newname |
|
240 | - * @param bool $showerror |
|
241 | - */ |
|
242 | - public function addAlteredField($name, $properties, $newname = false, $showerror = true) |
|
243 | - { |
|
244 | - $field['name'] = $name; |
|
245 | - $field['properties'] = $properties; |
|
246 | - $field['showerror'] = $showerror; |
|
247 | - $field['newname'] = $newname; |
|
248 | - $this->_alteredFields[] = $field; |
|
249 | - } |
|
250 | - /** |
|
251 | - * Invert values 0 to 1 and 1 to 0 |
|
252 | - * |
|
253 | - * @param string $name name of the field |
|
254 | - * @param $newValue |
|
255 | - * @param $oldValue |
|
256 | - * @internal param string $old old propertie |
|
257 | - * @internal param string $new new propertie |
|
258 | - */ //felix |
|
259 | - public function addUpdatedWhere($name, $newValue, $oldValue) |
|
260 | - { |
|
261 | - $field['name'] = $name; |
|
262 | - $field['value'] = $newValue; |
|
263 | - $field['where'] = $oldValue; |
|
264 | - $this->_updatedWhere[] = $field; |
|
265 | - } |
|
266 | - |
|
267 | - /** |
|
268 | - * Add new field of a record to be added |
|
269 | - * |
|
270 | - * @param string $name name of the field |
|
271 | - * @param string $properties properties of the field |
|
272 | - * |
|
273 | - */ |
|
274 | - public function addNewField($name, $properties) |
|
275 | - { |
|
276 | - $field['name'] = $name; |
|
277 | - $field['properties'] = $properties; |
|
278 | - $this->_newFields[] = $field; |
|
279 | - } |
|
280 | - |
|
281 | - /** |
|
282 | - * Get fields that need to be altered |
|
283 | - * |
|
284 | - * @return array fields that need to be altered |
|
285 | - * |
|
286 | - */ |
|
287 | - public function getAlteredFields() |
|
288 | - { |
|
289 | - return $this->_alteredFields; |
|
290 | - } |
|
291 | - |
|
292 | - /** |
|
293 | - * Add field for which the value will be updated |
|
294 | - * |
|
295 | - * @param string $name name of the field |
|
296 | - * @param string $value value to be set |
|
297 | - * |
|
298 | - */ |
|
299 | - public function addUpdatedField($name, $value) |
|
300 | - { |
|
301 | - $field['name'] = $name; |
|
302 | - $field['value'] = $value; |
|
303 | - $this->_updatedFields[] = $field; |
|
304 | - } |
|
305 | - |
|
306 | - /** |
|
307 | - * Get new fields to be added |
|
308 | - * |
|
309 | - * @return array fields to be added |
|
310 | - * |
|
311 | - */ |
|
312 | - public function getNewFields() |
|
313 | - { |
|
314 | - return $this->_newFields; |
|
315 | - } |
|
316 | - |
|
317 | - /** |
|
318 | - * Get fields which values need to be updated |
|
319 | - * |
|
320 | - * @return array fields which values need to be updated |
|
321 | - * |
|
322 | - */ |
|
323 | - public function getUpdatedFields() |
|
324 | - { |
|
325 | - return $this->_updatedFields; |
|
326 | - } |
|
327 | - /** |
|
328 | - * Get fields which values need to be updated |
|
329 | - * |
|
330 | - * @return array fields which values need to be updated |
|
331 | - * |
|
332 | - */ //felix |
|
333 | - public function getUpdatedWhere() |
|
334 | - { |
|
335 | - return $this->_updatedWhere; |
|
336 | - } |
|
337 | - |
|
338 | - /** |
|
339 | - * Add values of a record to be added |
|
340 | - * |
|
341 | - * @param string $name name of the field |
|
342 | - * |
|
343 | - */ |
|
344 | - public function addDroppedField($name) |
|
345 | - { |
|
346 | - $this->_droppedFields[] = $name; |
|
347 | - } |
|
348 | - |
|
349 | - /** |
|
350 | - * Get fields that need to be dropped |
|
351 | - * |
|
352 | - * @return array fields that need to be dropped |
|
353 | - * |
|
354 | - */ |
|
355 | - public function getDroppedFields() |
|
356 | - { |
|
357 | - return $this->_droppedFields; |
|
358 | - } |
|
359 | - |
|
360 | - /** |
|
361 | - * Set the flag to drop the table |
|
362 | - * |
|
363 | - */ |
|
364 | - public function setFlagForDrop() |
|
365 | - { |
|
366 | - $this->_flagForDrop = true; |
|
367 | - } |
|
368 | - |
|
369 | - /** |
|
370 | - * Use to create a table |
|
371 | - * |
|
372 | - * @return bool true if success, false if an error occured |
|
373 | - * |
|
374 | - */ |
|
375 | - public function createTable() |
|
376 | - { |
|
377 | - global $xoopsDB; |
|
378 | - $query = $this->getStructure(); |
|
379 | - $query = 'CREATE TABLE `' . $this->name() . '` (' . $query . ") ENGINE=MyISAM COMMENT='The SmartFactory <www.smartfactory.ca>'"; |
|
380 | - //xoops_debug($query); |
|
381 | - $ret = $xoopsDB->query($query); |
|
382 | - if (!$ret) { |
|
383 | - echo ' ' . sprintf(_SDU_MSG_CREATE_TABLE_ERR, $this->name()) . ' (' . $xoopsDB->error() . ')<br>'; |
|
384 | - } else { |
|
385 | - echo ' ' . sprintf(_SDU_MSG_CREATE_TABLE, $this->name()) . '<br>'; |
|
386 | - } |
|
387 | - |
|
388 | - return $ret; |
|
389 | - } |
|
390 | - |
|
391 | - /** |
|
392 | - * Use to drop a table |
|
393 | - * |
|
394 | - * @return bool true if success, false if an error occured |
|
395 | - * |
|
396 | - */ |
|
397 | - public function dropTable() |
|
398 | - { |
|
399 | - global $xoopsDB; |
|
400 | - $query = sprintf('DROP TABLE %s', $this->name()); |
|
401 | - $ret = $xoopsDB->query($query); |
|
402 | - if (!$ret) { |
|
403 | - echo ' ' . sprintf(_SDU_MSG_DROP_TABLE_ERR, $this->name()) . ' (' . $xoopsDB->error() . ')<br>'; |
|
404 | - |
|
405 | - return false; |
|
406 | - } else { |
|
407 | - echo ' ' . sprintf(_SDU_MSG_DROP_TABLE, $this->name()) . '<br>'; |
|
408 | - |
|
409 | - return true; |
|
410 | - } |
|
411 | - } |
|
412 | - |
|
413 | - /** |
|
414 | - * Use to alter a table |
|
415 | - * |
|
416 | - * @return bool true if success, false if an error occured |
|
417 | - * |
|
418 | - */ |
|
419 | - public function alterTable() |
|
420 | - { |
|
421 | - global $xoopsDB; |
|
422 | - $ret = true; |
|
423 | - |
|
424 | - foreach ($this->getAlteredFields() as $alteredField) { |
|
425 | - if (!$alteredField['newname']) { |
|
426 | - $alteredField['newname'] = $alteredField['name']; |
|
427 | - } |
|
428 | - |
|
429 | - $query = sprintf('ALTER TABLE `%s` CHANGE `%s` `%s` %s', $this->name(), $alteredField['name'], $alteredField['newname'], $alteredField['properties']); |
|
430 | - $ret = $ret && $xoopsDB->query($query); |
|
431 | - if ($alteredField['showerror']) { |
|
432 | - if (!$ret) { |
|
433 | - echo ' ' . sprintf(_SDU_MSG_CHGFIELD_ERR, $alteredField['name'], $this->name()) . ' (' . $xoopsDB->error() . ')<br>'; |
|
434 | - } else { |
|
435 | - echo ' ' . sprintf(_SDU_MSG_CHGFIELD, $alteredField['name'], $this->name()) . '<br>'; |
|
436 | - } |
|
437 | - } |
|
438 | - } |
|
439 | - |
|
440 | - return $ret; |
|
441 | - } |
|
442 | - |
|
443 | - /** |
|
444 | - * Use to add new fileds in the table |
|
445 | - * |
|
446 | - * @return bool true if success, false if an error occured |
|
447 | - * |
|
448 | - */ |
|
449 | - public function addNewFields() |
|
450 | - { |
|
451 | - global $xoopsDB; |
|
452 | - $ret = true; |
|
453 | - foreach ($this->getNewFields() as $newField) { |
|
454 | - $query = sprintf('ALTER TABLE `%s` ADD `%s` %s', $this->name(), $newField['name'], $newField['properties']); |
|
455 | - //echo $query; |
|
456 | - $ret = $ret && $xoopsDB->query($query); |
|
457 | - if (!$ret) { |
|
458 | - echo ' ' . sprintf(_SDU_MSG_NEWFIELD_ERR, $newField['name'], $this->name()) . '<br>'; |
|
459 | - } else { |
|
460 | - echo ' ' . sprintf(_SDU_MSG_NEWFIELD, $newField['name'], $this->name()) . '<br>'; |
|
461 | - } |
|
462 | - } |
|
463 | - |
|
464 | - return $ret; |
|
465 | - } |
|
466 | - |
|
467 | - /** |
|
468 | - * Use to update fields values |
|
469 | - * |
|
470 | - * @return bool true if success, false if an error occured |
|
471 | - * |
|
472 | - */ |
|
473 | - public function updateFieldsValues() |
|
474 | - { |
|
475 | - global $xoopsDB; |
|
476 | - $ret = true; |
|
477 | - foreach ($this->getUpdatedFields() as $updatedField) { |
|
478 | - $query = sprintf('UPDATE %s SET %s = %s', $this->name(), $updatedField['name'], $updatedField['value']); |
|
479 | - $ret = $ret && $xoopsDB->query($query); |
|
480 | - if (!$ret) { |
|
481 | - echo ' ' . sprintf(_SDU_MSG_UPDATE_TABLE_ERR, $this->name()) . ' (' . $xoopsDB->error() . ')<br>'; |
|
482 | - } else { |
|
483 | - echo ' ' . sprintf(_SDU_MSG_UPDATE_TABLE, $this->name()) . '<br>'; |
|
484 | - } |
|
485 | - } |
|
486 | - |
|
487 | - return $ret; |
|
488 | - } |
|
489 | - /** |
|
490 | - * Use to update fields values |
|
491 | - * |
|
492 | - * @return bool true if success, false if an error occured |
|
493 | - * |
|
494 | - */ //felix |
|
495 | - public function updateWhereValues() |
|
496 | - { |
|
497 | - global $xoopsDB; |
|
498 | - $ret = true; |
|
499 | - foreach ($this->getUpdatedWhere() as $updatedWhere) { |
|
500 | - $query = sprintf('UPDATE %s SET %s = %s WHERE %s %s', $this->name(), $updatedWhere['name'], $updatedWhere['value'], $updatedWhere['name'], $updatedWhere['where']); |
|
501 | - //echo $query."<br>"; |
|
502 | - $ret = $ret && $xoopsDB->query($query); |
|
503 | - if (!$ret) { |
|
504 | - echo ' ' . sprintf(_SDU_MSG_UPDATE_TABLE_ERR, $this->name()) . ' (' . $xoopsDB->error() . ')<br>'; |
|
505 | - } else { |
|
506 | - echo ' ' . sprintf(_SDU_MSG_UPDATE_TABLE, $this->name()) . '<br>'; |
|
507 | - } |
|
508 | - } |
|
509 | - |
|
510 | - return $ret; |
|
511 | - } |
|
512 | - |
|
513 | - /** |
|
514 | - * Use to drop fields |
|
515 | - * |
|
516 | - * @return bool true if success, false if an error occured |
|
517 | - * |
|
518 | - */ |
|
519 | - public function dropFields() |
|
520 | - { |
|
521 | - global $xoopsDB; |
|
522 | - $ret = true; |
|
523 | - foreach ($this->getDroppedFields() as $droppedField) { |
|
524 | - $query = sprintf('ALTER TABLE %s DROP %s', $this->name(), $droppedField); |
|
525 | - $ret = $ret && $xoopsDB->query($query); |
|
526 | - if (!$ret) { |
|
527 | - echo ' ' . sprintf(_SDU_MSG_DROPFIELD_ERR, $droppedField, $this->name()) . ' (' . $xoopsDB->error() . ')<br>'; |
|
528 | - } else { |
|
529 | - echo ' ' . sprintf(_SDU_MSG_DROPFIELD, $droppedField, $this->name()) . '<br>'; |
|
530 | - } |
|
531 | - } |
|
532 | - |
|
533 | - return $ret; |
|
534 | - } |
|
38 | + /** |
|
39 | + * @var string $_name name of the table |
|
40 | + */ |
|
41 | + public $_name; |
|
42 | + /** |
|
43 | + * @var string $_structure structure of the table |
|
44 | + */ |
|
45 | + public $_structure; |
|
46 | + |
|
47 | + /** |
|
48 | + * @var array $_data containing valued of each records to be added |
|
49 | + */ |
|
50 | + public $_data; |
|
51 | + |
|
52 | + /** |
|
53 | + * @var array $_alteredFields containing fields to be altered |
|
54 | + */ |
|
55 | + public $_alteredFields; |
|
56 | + |
|
57 | + /** |
|
58 | + * @var array $_newFields containing new fields to be added |
|
59 | + */ |
|
60 | + public $_newFields; |
|
61 | + |
|
62 | + /** |
|
63 | + * @var array $_droppedFields containing fields to be dropped |
|
64 | + */ |
|
65 | + public $_droppedFields; |
|
66 | + |
|
67 | + /** |
|
68 | + * @var array $_flagForDrop flag table to drop it |
|
69 | + */ |
|
70 | + public $_flagForDrop = false; |
|
71 | + |
|
72 | + /** |
|
73 | + * @var array $_updatedFields containing fields which values will be updated |
|
74 | + */ |
|
75 | + public $_updatedFields; |
|
76 | + |
|
77 | + /** |
|
78 | + * @var array $_updatedFields containing fields which values will be updated |
|
79 | + */ //felix |
|
80 | + public $_updatedWhere; |
|
81 | + |
|
82 | + public $_existingFieldsArray = false; |
|
83 | + |
|
84 | + /** |
|
85 | + * Constructor |
|
86 | + * |
|
87 | + * @param string $name name of the table |
|
88 | + * |
|
89 | + */ |
|
90 | + public function __construct($name) |
|
91 | + { |
|
92 | + $this->_name = $name; |
|
93 | + $this->_data = array(); |
|
94 | + } |
|
95 | + |
|
96 | + /** |
|
97 | + * Return the table name, prefixed with site table prefix |
|
98 | + * |
|
99 | + * @return string table name |
|
100 | + * |
|
101 | + */ |
|
102 | + public function name() |
|
103 | + { |
|
104 | + global $xoopsDB; |
|
105 | + |
|
106 | + return $xoopsDB->prefix($this->_name); |
|
107 | + } |
|
108 | + |
|
109 | + /** |
|
110 | + * Checks if the table already exists in the database |
|
111 | + * |
|
112 | + * @return bool TRUE if it exists, FALSE if not |
|
113 | + * |
|
114 | + */ |
|
115 | + public function exists() |
|
116 | + { |
|
117 | + return smart_TableExists($this->_name); |
|
118 | + } |
|
119 | + |
|
120 | + /** |
|
121 | + * @return mixed |
|
122 | + */ |
|
123 | + public function getExistingFieldsArray() |
|
124 | + { |
|
125 | + global $xoopsDB; |
|
126 | + $result = $xoopsDB->query('SHOW COLUMNS FROM ' . $this->name()); |
|
127 | + while ($existing_field = $xoopsDB->fetchArray($result)) { |
|
128 | + $fields[$existing_field['Field']] = $existing_field['Type']; |
|
129 | + if ($existing_field['Null'] !== 'YES') { |
|
130 | + $fields[$existing_field['Field']] .= ' NOT NULL'; |
|
131 | + } |
|
132 | + if ($existing_field['Extra']) { |
|
133 | + $fields[$existing_field['Field']] .= ' ' . $existing_field['Extra']; |
|
134 | + } |
|
135 | + if (!($existing_field['Default'] === null) |
|
136 | + && ($existing_field['Default'] |
|
137 | + || $existing_field['Default'] === '' |
|
138 | + || $existing_field['Default'] == 0)) { |
|
139 | + $fields[$existing_field['Field']] .= " default '" . $existing_field['Default'] . "'"; |
|
140 | + } |
|
141 | + } |
|
142 | + |
|
143 | + return $fields; |
|
144 | + } |
|
145 | + |
|
146 | + /** |
|
147 | + * @param $field |
|
148 | + * @return bool |
|
149 | + */ |
|
150 | + public function fieldExists($field) |
|
151 | + { |
|
152 | + $existingFields = $this->getExistingFieldsArray(); |
|
153 | + |
|
154 | + return isset($existingFields[$field]); |
|
155 | + } |
|
156 | + |
|
157 | + /** |
|
158 | + * Set the table structure |
|
159 | + * |
|
160 | + * Example: |
|
161 | + * |
|
162 | + * $table->setStructure("`transactionid` int(11) NOT NULL auto_increment, |
|
163 | + * `date` int(11) NOT NULL default '0', |
|
164 | + * `status` int(1) NOT NULL default '-1', |
|
165 | + * `itemid` int(11) NOT NULL default '0', |
|
166 | + * `uid` int(11) NOT NULL default '0', |
|
167 | + * `price` float NOT NULL default '0', |
|
168 | + * `currency` varchar(100) NOT NULL default '', |
|
169 | + * PRIMARY KEY (`transactionid`)"); |
|
170 | + * |
|
171 | + * @param string $structure table structure |
|
172 | + * |
|
173 | + */ |
|
174 | + public function setStructure($structure) |
|
175 | + { |
|
176 | + $this->_structure = $structure; |
|
177 | + } |
|
178 | + |
|
179 | + /** |
|
180 | + * Return the table structure |
|
181 | + * |
|
182 | + * @return string table structure |
|
183 | + * |
|
184 | + */ |
|
185 | + public function getStructure() |
|
186 | + { |
|
187 | + return sprintf($this->_structure, $this->name()); |
|
188 | + } |
|
189 | + |
|
190 | + /** |
|
191 | + * Add values of a record to be added |
|
192 | + * |
|
193 | + * @param string $data values of a record |
|
194 | + * |
|
195 | + */ |
|
196 | + public function setData($data) |
|
197 | + { |
|
198 | + $this->_data[] = $data; |
|
199 | + } |
|
200 | + |
|
201 | + /** |
|
202 | + * Get the data array |
|
203 | + * |
|
204 | + * @return array containing the records values to be added |
|
205 | + * |
|
206 | + */ |
|
207 | + public function getData() |
|
208 | + { |
|
209 | + return $this->_data; |
|
210 | + } |
|
211 | + |
|
212 | + /** |
|
213 | + * Use to insert data in a table |
|
214 | + * |
|
215 | + * @return bool true if success, false if an error occured |
|
216 | + * |
|
217 | + */ |
|
218 | + public function addData() |
|
219 | + { |
|
220 | + global $xoopsDB; |
|
221 | + foreach ($this->getData() as $data) { |
|
222 | + $query = sprintf('INSERT INTO %s VALUES (%s)', $this->name(), $data); |
|
223 | + $ret = $xoopsDB->query($query); |
|
224 | + if (!$ret) { |
|
225 | + echo ' ' . sprintf(_SDU_MSG_ADD_DATA_ERR, $this->name()) . '<br>'; |
|
226 | + } else { |
|
227 | + echo ' ' . sprintf(_SDU_MSG_ADD_DATA, $this->name()) . '<br>'; |
|
228 | + } |
|
229 | + } |
|
230 | + |
|
231 | + return $ret; |
|
232 | + } |
|
233 | + |
|
234 | + /** |
|
235 | + * Add a field to be added |
|
236 | + * |
|
237 | + * @param string $name name of the field |
|
238 | + * @param string $properties properties of the field |
|
239 | + * @param bool $newname |
|
240 | + * @param bool $showerror |
|
241 | + */ |
|
242 | + public function addAlteredField($name, $properties, $newname = false, $showerror = true) |
|
243 | + { |
|
244 | + $field['name'] = $name; |
|
245 | + $field['properties'] = $properties; |
|
246 | + $field['showerror'] = $showerror; |
|
247 | + $field['newname'] = $newname; |
|
248 | + $this->_alteredFields[] = $field; |
|
249 | + } |
|
250 | + /** |
|
251 | + * Invert values 0 to 1 and 1 to 0 |
|
252 | + * |
|
253 | + * @param string $name name of the field |
|
254 | + * @param $newValue |
|
255 | + * @param $oldValue |
|
256 | + * @internal param string $old old propertie |
|
257 | + * @internal param string $new new propertie |
|
258 | + */ //felix |
|
259 | + public function addUpdatedWhere($name, $newValue, $oldValue) |
|
260 | + { |
|
261 | + $field['name'] = $name; |
|
262 | + $field['value'] = $newValue; |
|
263 | + $field['where'] = $oldValue; |
|
264 | + $this->_updatedWhere[] = $field; |
|
265 | + } |
|
266 | + |
|
267 | + /** |
|
268 | + * Add new field of a record to be added |
|
269 | + * |
|
270 | + * @param string $name name of the field |
|
271 | + * @param string $properties properties of the field |
|
272 | + * |
|
273 | + */ |
|
274 | + public function addNewField($name, $properties) |
|
275 | + { |
|
276 | + $field['name'] = $name; |
|
277 | + $field['properties'] = $properties; |
|
278 | + $this->_newFields[] = $field; |
|
279 | + } |
|
280 | + |
|
281 | + /** |
|
282 | + * Get fields that need to be altered |
|
283 | + * |
|
284 | + * @return array fields that need to be altered |
|
285 | + * |
|
286 | + */ |
|
287 | + public function getAlteredFields() |
|
288 | + { |
|
289 | + return $this->_alteredFields; |
|
290 | + } |
|
291 | + |
|
292 | + /** |
|
293 | + * Add field for which the value will be updated |
|
294 | + * |
|
295 | + * @param string $name name of the field |
|
296 | + * @param string $value value to be set |
|
297 | + * |
|
298 | + */ |
|
299 | + public function addUpdatedField($name, $value) |
|
300 | + { |
|
301 | + $field['name'] = $name; |
|
302 | + $field['value'] = $value; |
|
303 | + $this->_updatedFields[] = $field; |
|
304 | + } |
|
305 | + |
|
306 | + /** |
|
307 | + * Get new fields to be added |
|
308 | + * |
|
309 | + * @return array fields to be added |
|
310 | + * |
|
311 | + */ |
|
312 | + public function getNewFields() |
|
313 | + { |
|
314 | + return $this->_newFields; |
|
315 | + } |
|
316 | + |
|
317 | + /** |
|
318 | + * Get fields which values need to be updated |
|
319 | + * |
|
320 | + * @return array fields which values need to be updated |
|
321 | + * |
|
322 | + */ |
|
323 | + public function getUpdatedFields() |
|
324 | + { |
|
325 | + return $this->_updatedFields; |
|
326 | + } |
|
327 | + /** |
|
328 | + * Get fields which values need to be updated |
|
329 | + * |
|
330 | + * @return array fields which values need to be updated |
|
331 | + * |
|
332 | + */ //felix |
|
333 | + public function getUpdatedWhere() |
|
334 | + { |
|
335 | + return $this->_updatedWhere; |
|
336 | + } |
|
337 | + |
|
338 | + /** |
|
339 | + * Add values of a record to be added |
|
340 | + * |
|
341 | + * @param string $name name of the field |
|
342 | + * |
|
343 | + */ |
|
344 | + public function addDroppedField($name) |
|
345 | + { |
|
346 | + $this->_droppedFields[] = $name; |
|
347 | + } |
|
348 | + |
|
349 | + /** |
|
350 | + * Get fields that need to be dropped |
|
351 | + * |
|
352 | + * @return array fields that need to be dropped |
|
353 | + * |
|
354 | + */ |
|
355 | + public function getDroppedFields() |
|
356 | + { |
|
357 | + return $this->_droppedFields; |
|
358 | + } |
|
359 | + |
|
360 | + /** |
|
361 | + * Set the flag to drop the table |
|
362 | + * |
|
363 | + */ |
|
364 | + public function setFlagForDrop() |
|
365 | + { |
|
366 | + $this->_flagForDrop = true; |
|
367 | + } |
|
368 | + |
|
369 | + /** |
|
370 | + * Use to create a table |
|
371 | + * |
|
372 | + * @return bool true if success, false if an error occured |
|
373 | + * |
|
374 | + */ |
|
375 | + public function createTable() |
|
376 | + { |
|
377 | + global $xoopsDB; |
|
378 | + $query = $this->getStructure(); |
|
379 | + $query = 'CREATE TABLE `' . $this->name() . '` (' . $query . ") ENGINE=MyISAM COMMENT='The SmartFactory <www.smartfactory.ca>'"; |
|
380 | + //xoops_debug($query); |
|
381 | + $ret = $xoopsDB->query($query); |
|
382 | + if (!$ret) { |
|
383 | + echo ' ' . sprintf(_SDU_MSG_CREATE_TABLE_ERR, $this->name()) . ' (' . $xoopsDB->error() . ')<br>'; |
|
384 | + } else { |
|
385 | + echo ' ' . sprintf(_SDU_MSG_CREATE_TABLE, $this->name()) . '<br>'; |
|
386 | + } |
|
387 | + |
|
388 | + return $ret; |
|
389 | + } |
|
390 | + |
|
391 | + /** |
|
392 | + * Use to drop a table |
|
393 | + * |
|
394 | + * @return bool true if success, false if an error occured |
|
395 | + * |
|
396 | + */ |
|
397 | + public function dropTable() |
|
398 | + { |
|
399 | + global $xoopsDB; |
|
400 | + $query = sprintf('DROP TABLE %s', $this->name()); |
|
401 | + $ret = $xoopsDB->query($query); |
|
402 | + if (!$ret) { |
|
403 | + echo ' ' . sprintf(_SDU_MSG_DROP_TABLE_ERR, $this->name()) . ' (' . $xoopsDB->error() . ')<br>'; |
|
404 | + |
|
405 | + return false; |
|
406 | + } else { |
|
407 | + echo ' ' . sprintf(_SDU_MSG_DROP_TABLE, $this->name()) . '<br>'; |
|
408 | + |
|
409 | + return true; |
|
410 | + } |
|
411 | + } |
|
412 | + |
|
413 | + /** |
|
414 | + * Use to alter a table |
|
415 | + * |
|
416 | + * @return bool true if success, false if an error occured |
|
417 | + * |
|
418 | + */ |
|
419 | + public function alterTable() |
|
420 | + { |
|
421 | + global $xoopsDB; |
|
422 | + $ret = true; |
|
423 | + |
|
424 | + foreach ($this->getAlteredFields() as $alteredField) { |
|
425 | + if (!$alteredField['newname']) { |
|
426 | + $alteredField['newname'] = $alteredField['name']; |
|
427 | + } |
|
428 | + |
|
429 | + $query = sprintf('ALTER TABLE `%s` CHANGE `%s` `%s` %s', $this->name(), $alteredField['name'], $alteredField['newname'], $alteredField['properties']); |
|
430 | + $ret = $ret && $xoopsDB->query($query); |
|
431 | + if ($alteredField['showerror']) { |
|
432 | + if (!$ret) { |
|
433 | + echo ' ' . sprintf(_SDU_MSG_CHGFIELD_ERR, $alteredField['name'], $this->name()) . ' (' . $xoopsDB->error() . ')<br>'; |
|
434 | + } else { |
|
435 | + echo ' ' . sprintf(_SDU_MSG_CHGFIELD, $alteredField['name'], $this->name()) . '<br>'; |
|
436 | + } |
|
437 | + } |
|
438 | + } |
|
439 | + |
|
440 | + return $ret; |
|
441 | + } |
|
442 | + |
|
443 | + /** |
|
444 | + * Use to add new fileds in the table |
|
445 | + * |
|
446 | + * @return bool true if success, false if an error occured |
|
447 | + * |
|
448 | + */ |
|
449 | + public function addNewFields() |
|
450 | + { |
|
451 | + global $xoopsDB; |
|
452 | + $ret = true; |
|
453 | + foreach ($this->getNewFields() as $newField) { |
|
454 | + $query = sprintf('ALTER TABLE `%s` ADD `%s` %s', $this->name(), $newField['name'], $newField['properties']); |
|
455 | + //echo $query; |
|
456 | + $ret = $ret && $xoopsDB->query($query); |
|
457 | + if (!$ret) { |
|
458 | + echo ' ' . sprintf(_SDU_MSG_NEWFIELD_ERR, $newField['name'], $this->name()) . '<br>'; |
|
459 | + } else { |
|
460 | + echo ' ' . sprintf(_SDU_MSG_NEWFIELD, $newField['name'], $this->name()) . '<br>'; |
|
461 | + } |
|
462 | + } |
|
463 | + |
|
464 | + return $ret; |
|
465 | + } |
|
466 | + |
|
467 | + /** |
|
468 | + * Use to update fields values |
|
469 | + * |
|
470 | + * @return bool true if success, false if an error occured |
|
471 | + * |
|
472 | + */ |
|
473 | + public function updateFieldsValues() |
|
474 | + { |
|
475 | + global $xoopsDB; |
|
476 | + $ret = true; |
|
477 | + foreach ($this->getUpdatedFields() as $updatedField) { |
|
478 | + $query = sprintf('UPDATE %s SET %s = %s', $this->name(), $updatedField['name'], $updatedField['value']); |
|
479 | + $ret = $ret && $xoopsDB->query($query); |
|
480 | + if (!$ret) { |
|
481 | + echo ' ' . sprintf(_SDU_MSG_UPDATE_TABLE_ERR, $this->name()) . ' (' . $xoopsDB->error() . ')<br>'; |
|
482 | + } else { |
|
483 | + echo ' ' . sprintf(_SDU_MSG_UPDATE_TABLE, $this->name()) . '<br>'; |
|
484 | + } |
|
485 | + } |
|
486 | + |
|
487 | + return $ret; |
|
488 | + } |
|
489 | + /** |
|
490 | + * Use to update fields values |
|
491 | + * |
|
492 | + * @return bool true if success, false if an error occured |
|
493 | + * |
|
494 | + */ //felix |
|
495 | + public function updateWhereValues() |
|
496 | + { |
|
497 | + global $xoopsDB; |
|
498 | + $ret = true; |
|
499 | + foreach ($this->getUpdatedWhere() as $updatedWhere) { |
|
500 | + $query = sprintf('UPDATE %s SET %s = %s WHERE %s %s', $this->name(), $updatedWhere['name'], $updatedWhere['value'], $updatedWhere['name'], $updatedWhere['where']); |
|
501 | + //echo $query."<br>"; |
|
502 | + $ret = $ret && $xoopsDB->query($query); |
|
503 | + if (!$ret) { |
|
504 | + echo ' ' . sprintf(_SDU_MSG_UPDATE_TABLE_ERR, $this->name()) . ' (' . $xoopsDB->error() . ')<br>'; |
|
505 | + } else { |
|
506 | + echo ' ' . sprintf(_SDU_MSG_UPDATE_TABLE, $this->name()) . '<br>'; |
|
507 | + } |
|
508 | + } |
|
509 | + |
|
510 | + return $ret; |
|
511 | + } |
|
512 | + |
|
513 | + /** |
|
514 | + * Use to drop fields |
|
515 | + * |
|
516 | + * @return bool true if success, false if an error occured |
|
517 | + * |
|
518 | + */ |
|
519 | + public function dropFields() |
|
520 | + { |
|
521 | + global $xoopsDB; |
|
522 | + $ret = true; |
|
523 | + foreach ($this->getDroppedFields() as $droppedField) { |
|
524 | + $query = sprintf('ALTER TABLE %s DROP %s', $this->name(), $droppedField); |
|
525 | + $ret = $ret && $xoopsDB->query($query); |
|
526 | + if (!$ret) { |
|
527 | + echo ' ' . sprintf(_SDU_MSG_DROPFIELD_ERR, $droppedField, $this->name()) . ' (' . $xoopsDB->error() . ')<br>'; |
|
528 | + } else { |
|
529 | + echo ' ' . sprintf(_SDU_MSG_DROPFIELD, $droppedField, $this->name()) . '<br>'; |
|
530 | + } |
|
531 | + } |
|
532 | + |
|
533 | + return $ret; |
|
534 | + } |
|
535 | 535 | } |
536 | 536 | |
537 | 537 | /** |
@@ -545,328 +545,328 @@ discard block |
||
545 | 545 | */ |
546 | 546 | class SmartobjectDbupdater |
547 | 547 | { |
548 | - public $_dbTypesArray; |
|
549 | - |
|
550 | - /** |
|
551 | - * SmartobjectDbupdater constructor. |
|
552 | - */ |
|
553 | - public function __construct() |
|
554 | - { |
|
555 | - $this->_dbTypesArray[XOBJ_DTYPE_TXTBOX] = 'varchar(255)'; |
|
556 | - $this->_dbTypesArray[XOBJ_DTYPE_TXTAREA] = 'text'; |
|
557 | - $this->_dbTypesArray[XOBJ_DTYPE_INT] = 'int(11)'; |
|
558 | - $this->_dbTypesArray[XOBJ_DTYPE_URL] = 'varchar(255)'; |
|
559 | - $this->_dbTypesArray[XOBJ_DTYPE_EMAIL] = 'varchar(255)'; |
|
560 | - $this->_dbTypesArray[XOBJ_DTYPE_ARRAY] = 'text'; |
|
561 | - $this->_dbTypesArray[XOBJ_DTYPE_OTHER] = 'text'; |
|
562 | - $this->_dbTypesArray[XOBJ_DTYPE_SOURCE] = 'text'; |
|
563 | - $this->_dbTypesArray[XOBJ_DTYPE_STIME] = 'int(11)'; |
|
564 | - $this->_dbTypesArray[XOBJ_DTYPE_MTIME] = 'int(11)'; |
|
565 | - $this->_dbTypesArray[XOBJ_DTYPE_LTIME] = 'int(11)'; |
|
566 | - $this->_dbTypesArray[XOBJ_DTYPE_SIMPLE_ARRAY] = 'text'; |
|
567 | - $this->_dbTypesArray[XOBJ_DTYPE_CURRENCY] = 'text'; |
|
568 | - $this->_dbTypesArray[XOBJ_DTYPE_FLOAT] = 'float'; |
|
569 | - $this->_dbTypesArray[XOBJ_DTYPE_TIME_ONLY] = 'int(11)'; |
|
570 | - $this->_dbTypesArray[XOBJ_DTYPE_URLLINK] = 'int(11)'; |
|
571 | - $this->_dbTypesArray[XOBJ_DTYPE_FILE] = 'int(11)'; |
|
572 | - $this->_dbTypesArray[XOBJ_DTYPE_IMAGE] = 'varchar(255)'; |
|
573 | - } |
|
574 | - |
|
575 | - /** |
|
576 | - * Use to execute a general query |
|
577 | - * |
|
578 | - * @param string $query query that will be executed |
|
579 | - * @param string $goodmsg message displayed on success |
|
580 | - * @param string $badmsg message displayed on error |
|
581 | - * |
|
582 | - * @return bool true if success, false if an error occured |
|
583 | - * |
|
584 | - */ |
|
585 | - public function runQuery($query, $goodmsg, $badmsg) |
|
586 | - { |
|
587 | - global $xoopsDB; |
|
588 | - $ret = $xoopsDB->query($query); |
|
589 | - if (!$ret) { |
|
590 | - echo " $badmsg<br>"; |
|
591 | - |
|
592 | - return false; |
|
593 | - } else { |
|
594 | - echo " $goodmsg<br>"; |
|
595 | - |
|
596 | - return true; |
|
597 | - } |
|
598 | - } |
|
599 | - |
|
600 | - /** |
|
601 | - * Use to rename a table |
|
602 | - * |
|
603 | - * @param string $from name of the table to rename |
|
604 | - * @param string $to new name of the renamed table |
|
605 | - * |
|
606 | - * @return bool true if success, false if an error occured |
|
607 | - */ |
|
608 | - public function renameTable($from, $to) |
|
609 | - { |
|
610 | - global $xoopsDB; |
|
611 | - $from = $xoopsDB->prefix($from); |
|
612 | - $to = $xoopsDB->prefix($to); |
|
613 | - $query = sprintf('ALTER TABLE %s RENAME %s', $from, $to); |
|
614 | - $ret = $xoopsDB->query($query); |
|
615 | - if (!$ret) { |
|
616 | - echo ' ' . sprintf(_SDU_MSG_RENAME_TABLE_ERR, $from) . '<br>'; |
|
617 | - |
|
618 | - return false; |
|
619 | - } else { |
|
620 | - echo ' ' . sprintf(_SDU_MSG_RENAME_TABLE, $from, $to) . '<br>'; |
|
621 | - |
|
622 | - return true; |
|
623 | - } |
|
624 | - } |
|
625 | - |
|
626 | - /** |
|
627 | - * Use to update a table |
|
628 | - * |
|
629 | - * @param object $table {@link SmartDbTable} that will be updated |
|
630 | - * |
|
631 | - * @see SmartDbTable |
|
632 | - * |
|
633 | - * @return bool true if success, false if an error occured |
|
634 | - */ |
|
635 | - public function updateTable($table) |
|
636 | - { |
|
637 | - global $xoopsDB; |
|
638 | - $ret = true; |
|
639 | - // If table has a structure, create the table |
|
640 | - if ($table->getStructure()) { |
|
641 | - $ret = $table->createTable() && $ret; |
|
642 | - } |
|
643 | - // If table is flag for drop, drop it |
|
644 | - if ($table->_flagForDrop) { |
|
645 | - $ret = $table->dropTable() && $ret; |
|
646 | - } |
|
647 | - // If table has data, insert it |
|
648 | - if ($table->getData()) { |
|
649 | - $ret = $table->addData() && $ret; |
|
650 | - } |
|
651 | - // If table has new fields to be added, add them |
|
652 | - if ($table->getNewFields()) { |
|
653 | - $ret = $table->addNewFields() && $ret; |
|
654 | - } |
|
655 | - // If table has altered field, alter the table |
|
656 | - if ($table->getAlteredFields()) { |
|
657 | - $ret = $table->alterTable() && $ret; |
|
658 | - } |
|
659 | - // If table has updated field values, update the table |
|
660 | - if ($table->getUpdatedFields()) { |
|
661 | - $ret = $table->updateFieldsValues($table) && $ret; |
|
662 | - } |
|
663 | - // If table has dropped field, alter the table |
|
664 | - if ($table->getDroppedFields()) { |
|
665 | - $ret = $table->dropFields($table) && $ret; |
|
666 | - } |
|
667 | - //felix |
|
668 | - // If table has updated field values, update the table |
|
669 | - if ($table->getUpdatedWhere()) { |
|
670 | - $ret = $table->UpdateWhereValues($table) && $ret; |
|
671 | - } |
|
672 | - |
|
673 | - return $ret; |
|
674 | - } |
|
675 | - |
|
676 | - /** |
|
677 | - * @param $module |
|
678 | - * @param $item |
|
679 | - */ |
|
680 | - public function automaticUpgrade($module, $item) |
|
681 | - { |
|
682 | - if (is_array($item)) { |
|
683 | - foreach ($item as $v) { |
|
684 | - $this->upgradeObjectItem($module, $v); |
|
685 | - } |
|
686 | - } else { |
|
687 | - $this->upgradeObjectItem($module, $item); |
|
688 | - } |
|
689 | - } |
|
690 | - |
|
691 | - /** |
|
692 | - * @param $var |
|
693 | - * @return string |
|
694 | - */ |
|
695 | - public function getFieldTypeFromVar($var) |
|
696 | - { |
|
697 | - $ret = isset($this->_dbTypesArray[$var['data_type']]) ? $this->_dbTypesArray[$var['data_type']] : 'text'; |
|
698 | - |
|
699 | - return $ret; |
|
700 | - } |
|
701 | - |
|
702 | - /** |
|
703 | - * @param $var |
|
704 | - * @param bool $key |
|
705 | - * @return string |
|
706 | - */ |
|
707 | - public function getFieldDefaultFromVar($var, $key = false) |
|
708 | - { |
|
709 | - if ($var['value']) { |
|
710 | - return $var['value']; |
|
711 | - } else { |
|
712 | - if (in_array($var['data_type'], array( |
|
713 | - XOBJ_DTYPE_INT, |
|
714 | - XOBJ_DTYPE_STIME, |
|
715 | - XOBJ_DTYPE_MTIME, |
|
716 | - XOBJ_DTYPE_LTIME, |
|
717 | - XOBJ_DTYPE_TIME_ONLY, |
|
718 | - XOBJ_DTYPE_URLLINK, |
|
719 | - XOBJ_DTYPE_FILE |
|
720 | - ))) { |
|
721 | - return '0'; |
|
722 | - } else { |
|
723 | - return ''; |
|
724 | - } |
|
725 | - } |
|
726 | - } |
|
727 | - |
|
728 | - /** |
|
729 | - * @param $module |
|
730 | - * @param $item |
|
731 | - * @return bool |
|
732 | - */ |
|
733 | - public function upgradeObjectItem($module, $item) |
|
734 | - { |
|
735 | - $moduleHandler = xoops_getModuleHandler($item, $module); |
|
736 | - if (!$moduleHandler) { |
|
737 | - return false; |
|
738 | - } |
|
739 | - |
|
740 | - $table = new SmartDbTable($module . '_' . $item); |
|
741 | - $object = $moduleHandler->create(); |
|
742 | - $objectVars = $object->getVars(); |
|
743 | - |
|
744 | - if (!$table->exists()) { |
|
745 | - // table was never created, let's do it |
|
746 | - $structure = ''; |
|
747 | - foreach ($objectVars as $key => $var) { |
|
748 | - if ($var['persistent']) { |
|
749 | - $type = $this->getFieldTypeFromVar($var); |
|
750 | - if ($key == $moduleHandler->keyName) { |
|
751 | - $extra = 'auto_increment'; |
|
752 | - } else { |
|
753 | - $default = $this->getFieldDefaultFromVar($var); |
|
754 | - $extra = "default '$default' |
|
548 | + public $_dbTypesArray; |
|
549 | + |
|
550 | + /** |
|
551 | + * SmartobjectDbupdater constructor. |
|
552 | + */ |
|
553 | + public function __construct() |
|
554 | + { |
|
555 | + $this->_dbTypesArray[XOBJ_DTYPE_TXTBOX] = 'varchar(255)'; |
|
556 | + $this->_dbTypesArray[XOBJ_DTYPE_TXTAREA] = 'text'; |
|
557 | + $this->_dbTypesArray[XOBJ_DTYPE_INT] = 'int(11)'; |
|
558 | + $this->_dbTypesArray[XOBJ_DTYPE_URL] = 'varchar(255)'; |
|
559 | + $this->_dbTypesArray[XOBJ_DTYPE_EMAIL] = 'varchar(255)'; |
|
560 | + $this->_dbTypesArray[XOBJ_DTYPE_ARRAY] = 'text'; |
|
561 | + $this->_dbTypesArray[XOBJ_DTYPE_OTHER] = 'text'; |
|
562 | + $this->_dbTypesArray[XOBJ_DTYPE_SOURCE] = 'text'; |
|
563 | + $this->_dbTypesArray[XOBJ_DTYPE_STIME] = 'int(11)'; |
|
564 | + $this->_dbTypesArray[XOBJ_DTYPE_MTIME] = 'int(11)'; |
|
565 | + $this->_dbTypesArray[XOBJ_DTYPE_LTIME] = 'int(11)'; |
|
566 | + $this->_dbTypesArray[XOBJ_DTYPE_SIMPLE_ARRAY] = 'text'; |
|
567 | + $this->_dbTypesArray[XOBJ_DTYPE_CURRENCY] = 'text'; |
|
568 | + $this->_dbTypesArray[XOBJ_DTYPE_FLOAT] = 'float'; |
|
569 | + $this->_dbTypesArray[XOBJ_DTYPE_TIME_ONLY] = 'int(11)'; |
|
570 | + $this->_dbTypesArray[XOBJ_DTYPE_URLLINK] = 'int(11)'; |
|
571 | + $this->_dbTypesArray[XOBJ_DTYPE_FILE] = 'int(11)'; |
|
572 | + $this->_dbTypesArray[XOBJ_DTYPE_IMAGE] = 'varchar(255)'; |
|
573 | + } |
|
574 | + |
|
575 | + /** |
|
576 | + * Use to execute a general query |
|
577 | + * |
|
578 | + * @param string $query query that will be executed |
|
579 | + * @param string $goodmsg message displayed on success |
|
580 | + * @param string $badmsg message displayed on error |
|
581 | + * |
|
582 | + * @return bool true if success, false if an error occured |
|
583 | + * |
|
584 | + */ |
|
585 | + public function runQuery($query, $goodmsg, $badmsg) |
|
586 | + { |
|
587 | + global $xoopsDB; |
|
588 | + $ret = $xoopsDB->query($query); |
|
589 | + if (!$ret) { |
|
590 | + echo " $badmsg<br>"; |
|
591 | + |
|
592 | + return false; |
|
593 | + } else { |
|
594 | + echo " $goodmsg<br>"; |
|
595 | + |
|
596 | + return true; |
|
597 | + } |
|
598 | + } |
|
599 | + |
|
600 | + /** |
|
601 | + * Use to rename a table |
|
602 | + * |
|
603 | + * @param string $from name of the table to rename |
|
604 | + * @param string $to new name of the renamed table |
|
605 | + * |
|
606 | + * @return bool true if success, false if an error occured |
|
607 | + */ |
|
608 | + public function renameTable($from, $to) |
|
609 | + { |
|
610 | + global $xoopsDB; |
|
611 | + $from = $xoopsDB->prefix($from); |
|
612 | + $to = $xoopsDB->prefix($to); |
|
613 | + $query = sprintf('ALTER TABLE %s RENAME %s', $from, $to); |
|
614 | + $ret = $xoopsDB->query($query); |
|
615 | + if (!$ret) { |
|
616 | + echo ' ' . sprintf(_SDU_MSG_RENAME_TABLE_ERR, $from) . '<br>'; |
|
617 | + |
|
618 | + return false; |
|
619 | + } else { |
|
620 | + echo ' ' . sprintf(_SDU_MSG_RENAME_TABLE, $from, $to) . '<br>'; |
|
621 | + |
|
622 | + return true; |
|
623 | + } |
|
624 | + } |
|
625 | + |
|
626 | + /** |
|
627 | + * Use to update a table |
|
628 | + * |
|
629 | + * @param object $table {@link SmartDbTable} that will be updated |
|
630 | + * |
|
631 | + * @see SmartDbTable |
|
632 | + * |
|
633 | + * @return bool true if success, false if an error occured |
|
634 | + */ |
|
635 | + public function updateTable($table) |
|
636 | + { |
|
637 | + global $xoopsDB; |
|
638 | + $ret = true; |
|
639 | + // If table has a structure, create the table |
|
640 | + if ($table->getStructure()) { |
|
641 | + $ret = $table->createTable() && $ret; |
|
642 | + } |
|
643 | + // If table is flag for drop, drop it |
|
644 | + if ($table->_flagForDrop) { |
|
645 | + $ret = $table->dropTable() && $ret; |
|
646 | + } |
|
647 | + // If table has data, insert it |
|
648 | + if ($table->getData()) { |
|
649 | + $ret = $table->addData() && $ret; |
|
650 | + } |
|
651 | + // If table has new fields to be added, add them |
|
652 | + if ($table->getNewFields()) { |
|
653 | + $ret = $table->addNewFields() && $ret; |
|
654 | + } |
|
655 | + // If table has altered field, alter the table |
|
656 | + if ($table->getAlteredFields()) { |
|
657 | + $ret = $table->alterTable() && $ret; |
|
658 | + } |
|
659 | + // If table has updated field values, update the table |
|
660 | + if ($table->getUpdatedFields()) { |
|
661 | + $ret = $table->updateFieldsValues($table) && $ret; |
|
662 | + } |
|
663 | + // If table has dropped field, alter the table |
|
664 | + if ($table->getDroppedFields()) { |
|
665 | + $ret = $table->dropFields($table) && $ret; |
|
666 | + } |
|
667 | + //felix |
|
668 | + // If table has updated field values, update the table |
|
669 | + if ($table->getUpdatedWhere()) { |
|
670 | + $ret = $table->UpdateWhereValues($table) && $ret; |
|
671 | + } |
|
672 | + |
|
673 | + return $ret; |
|
674 | + } |
|
675 | + |
|
676 | + /** |
|
677 | + * @param $module |
|
678 | + * @param $item |
|
679 | + */ |
|
680 | + public function automaticUpgrade($module, $item) |
|
681 | + { |
|
682 | + if (is_array($item)) { |
|
683 | + foreach ($item as $v) { |
|
684 | + $this->upgradeObjectItem($module, $v); |
|
685 | + } |
|
686 | + } else { |
|
687 | + $this->upgradeObjectItem($module, $item); |
|
688 | + } |
|
689 | + } |
|
690 | + |
|
691 | + /** |
|
692 | + * @param $var |
|
693 | + * @return string |
|
694 | + */ |
|
695 | + public function getFieldTypeFromVar($var) |
|
696 | + { |
|
697 | + $ret = isset($this->_dbTypesArray[$var['data_type']]) ? $this->_dbTypesArray[$var['data_type']] : 'text'; |
|
698 | + |
|
699 | + return $ret; |
|
700 | + } |
|
701 | + |
|
702 | + /** |
|
703 | + * @param $var |
|
704 | + * @param bool $key |
|
705 | + * @return string |
|
706 | + */ |
|
707 | + public function getFieldDefaultFromVar($var, $key = false) |
|
708 | + { |
|
709 | + if ($var['value']) { |
|
710 | + return $var['value']; |
|
711 | + } else { |
|
712 | + if (in_array($var['data_type'], array( |
|
713 | + XOBJ_DTYPE_INT, |
|
714 | + XOBJ_DTYPE_STIME, |
|
715 | + XOBJ_DTYPE_MTIME, |
|
716 | + XOBJ_DTYPE_LTIME, |
|
717 | + XOBJ_DTYPE_TIME_ONLY, |
|
718 | + XOBJ_DTYPE_URLLINK, |
|
719 | + XOBJ_DTYPE_FILE |
|
720 | + ))) { |
|
721 | + return '0'; |
|
722 | + } else { |
|
723 | + return ''; |
|
724 | + } |
|
725 | + } |
|
726 | + } |
|
727 | + |
|
728 | + /** |
|
729 | + * @param $module |
|
730 | + * @param $item |
|
731 | + * @return bool |
|
732 | + */ |
|
733 | + public function upgradeObjectItem($module, $item) |
|
734 | + { |
|
735 | + $moduleHandler = xoops_getModuleHandler($item, $module); |
|
736 | + if (!$moduleHandler) { |
|
737 | + return false; |
|
738 | + } |
|
739 | + |
|
740 | + $table = new SmartDbTable($module . '_' . $item); |
|
741 | + $object = $moduleHandler->create(); |
|
742 | + $objectVars = $object->getVars(); |
|
743 | + |
|
744 | + if (!$table->exists()) { |
|
745 | + // table was never created, let's do it |
|
746 | + $structure = ''; |
|
747 | + foreach ($objectVars as $key => $var) { |
|
748 | + if ($var['persistent']) { |
|
749 | + $type = $this->getFieldTypeFromVar($var); |
|
750 | + if ($key == $moduleHandler->keyName) { |
|
751 | + $extra = 'auto_increment'; |
|
752 | + } else { |
|
753 | + $default = $this->getFieldDefaultFromVar($var); |
|
754 | + $extra = "default '$default' |
|
755 | 755 | "; |
756 | - } |
|
757 | - $structure .= "`$key` $type not null $extra, |
|
756 | + } |
|
757 | + $structure .= "`$key` $type not null $extra, |
|
758 | 758 | "; |
759 | - } |
|
760 | - } |
|
761 | - $structure .= 'PRIMARY KEY (`' . $moduleHandler->keyName . '`) |
|
759 | + } |
|
760 | + } |
|
761 | + $structure .= 'PRIMARY KEY (`' . $moduleHandler->keyName . '`) |
|
762 | 762 | '; |
763 | - $table->setStructure($structure); |
|
764 | - if (!$this->updateTable($table)) { |
|
765 | - /** |
|
766 | - * @todo trap the errors |
|
767 | - */ |
|
768 | - } |
|
769 | - } else { |
|
770 | - $existingFieldsArray = $table->getExistingFieldsArray(); |
|
771 | - foreach ($objectVars as $key => $var) { |
|
772 | - if ($var['persistent']) { |
|
773 | - if (!isset($existingFieldsArray[$key])) { |
|
774 | - // the fiels does not exist, let's create it |
|
775 | - $type = $this->getFieldTypeFromVar($var); |
|
776 | - $default = $this->getFieldDefaultFromVar($var); |
|
777 | - $table->addNewField($key, "$type not null default '$default'"); |
|
778 | - } else { |
|
779 | - // if field already exists, let's check if the definition is correct |
|
780 | - $definition = strtolower($existingFieldsArray[$key]); |
|
781 | - $type = $this->getFieldTypeFromVar($var); |
|
782 | - if ($key == $moduleHandler->keyName) { |
|
783 | - $extra = 'auto_increment'; |
|
784 | - } else { |
|
785 | - $default = $this->getFieldDefaultFromVar($var, $key); |
|
786 | - $extra = "default '$default'"; |
|
787 | - } |
|
788 | - $actual_definition = "$type not null $extra"; |
|
789 | - if ($definition != $actual_definition) { |
|
790 | - $table->addAlteredField($key, $actual_definition); |
|
791 | - } |
|
792 | - } |
|
793 | - } |
|
794 | - } |
|
795 | - |
|
796 | - // check to see if there are some unused fields left in the table |
|
797 | - foreach ($existingFieldsArray as $key => $v) { |
|
798 | - if (!isset($objectVars[$key]) || !$objectVars[$key]['persistent']) { |
|
799 | - $table->addDroppedField($key); |
|
800 | - } |
|
801 | - } |
|
802 | - |
|
803 | - if (!$this->updateTable($table)) { |
|
804 | - /** |
|
805 | - * @todo trap the errors |
|
806 | - */ |
|
807 | - } |
|
808 | - } |
|
809 | - } |
|
810 | - |
|
811 | - /** |
|
812 | - * @param $module |
|
813 | - * @return bool |
|
814 | - */ |
|
815 | - public function moduleUpgrade(XoopsModule $module) |
|
816 | - { |
|
817 | - $dirname = $module->getVar('dirname'); |
|
818 | - |
|
819 | - ob_start(); |
|
820 | - |
|
821 | - $table = new SmartDbTable($dirname . '_meta'); |
|
822 | - if (!$table->exists()) { |
|
823 | - $table->setStructure(" |
|
763 | + $table->setStructure($structure); |
|
764 | + if (!$this->updateTable($table)) { |
|
765 | + /** |
|
766 | + * @todo trap the errors |
|
767 | + */ |
|
768 | + } |
|
769 | + } else { |
|
770 | + $existingFieldsArray = $table->getExistingFieldsArray(); |
|
771 | + foreach ($objectVars as $key => $var) { |
|
772 | + if ($var['persistent']) { |
|
773 | + if (!isset($existingFieldsArray[$key])) { |
|
774 | + // the fiels does not exist, let's create it |
|
775 | + $type = $this->getFieldTypeFromVar($var); |
|
776 | + $default = $this->getFieldDefaultFromVar($var); |
|
777 | + $table->addNewField($key, "$type not null default '$default'"); |
|
778 | + } else { |
|
779 | + // if field already exists, let's check if the definition is correct |
|
780 | + $definition = strtolower($existingFieldsArray[$key]); |
|
781 | + $type = $this->getFieldTypeFromVar($var); |
|
782 | + if ($key == $moduleHandler->keyName) { |
|
783 | + $extra = 'auto_increment'; |
|
784 | + } else { |
|
785 | + $default = $this->getFieldDefaultFromVar($var, $key); |
|
786 | + $extra = "default '$default'"; |
|
787 | + } |
|
788 | + $actual_definition = "$type not null $extra"; |
|
789 | + if ($definition != $actual_definition) { |
|
790 | + $table->addAlteredField($key, $actual_definition); |
|
791 | + } |
|
792 | + } |
|
793 | + } |
|
794 | + } |
|
795 | + |
|
796 | + // check to see if there are some unused fields left in the table |
|
797 | + foreach ($existingFieldsArray as $key => $v) { |
|
798 | + if (!isset($objectVars[$key]) || !$objectVars[$key]['persistent']) { |
|
799 | + $table->addDroppedField($key); |
|
800 | + } |
|
801 | + } |
|
802 | + |
|
803 | + if (!$this->updateTable($table)) { |
|
804 | + /** |
|
805 | + * @todo trap the errors |
|
806 | + */ |
|
807 | + } |
|
808 | + } |
|
809 | + } |
|
810 | + |
|
811 | + /** |
|
812 | + * @param $module |
|
813 | + * @return bool |
|
814 | + */ |
|
815 | + public function moduleUpgrade(XoopsModule $module) |
|
816 | + { |
|
817 | + $dirname = $module->getVar('dirname'); |
|
818 | + |
|
819 | + ob_start(); |
|
820 | + |
|
821 | + $table = new SmartDbTable($dirname . '_meta'); |
|
822 | + if (!$table->exists()) { |
|
823 | + $table->setStructure(" |
|
824 | 824 | `metakey` varchar(50) NOT NULL default '', |
825 | 825 | `metavalue` varchar(255) NOT NULL default '', |
826 | 826 | PRIMARY KEY (`metakey`)"); |
827 | - $table->setData("'version',0"); |
|
828 | - if (!$this->updateTable($table)) { |
|
829 | - /** |
|
830 | - * @todo trap the errors |
|
831 | - */ |
|
832 | - } |
|
833 | - } |
|
834 | - |
|
835 | - $dbVersion = smart_GetMeta('version', $dirname); |
|
836 | - if (!$dbVersion) { |
|
837 | - $dbVersion = 0; |
|
838 | - } |
|
839 | - $newDbVersion = constant(strtoupper($dirname . '_db_version')) ?: 0; |
|
840 | - echo 'Database version: ' . $dbVersion . '<br>'; |
|
841 | - echo 'New database version: ' . $newDbVersion . '<br>'; |
|
842 | - |
|
843 | - if ($newDbVersion > $dbVersion) { |
|
844 | - for ($i = $dbVersion + 1; $i <= $newDbVersion; ++$i) { |
|
845 | - $upgrade_function = $dirname . '_db_upgrade_' . $i; |
|
846 | - if (function_exists($upgrade_function)) { |
|
847 | - $upgrade_function(); |
|
848 | - } |
|
849 | - } |
|
850 | - } |
|
851 | - |
|
852 | - echo '<code>' . _SDU_UPDATE_UPDATING_DATABASE . '<br>'; |
|
853 | - |
|
854 | - // if there is a function to execute for this DB version, let's do it |
|
855 | - //$function_ |
|
856 | - |
|
857 | - $module_info = smart_getModuleInfo($dirname); |
|
858 | - $this->automaticUpgrade($dirname, $module_info->modinfo['object_items']); |
|
859 | - |
|
860 | - echo '</code>'; |
|
861 | - |
|
862 | - $feedback = ob_get_clean(); |
|
863 | - if (method_exists($module, 'setMessage')) { |
|
864 | - $module->setMessage($feedback); |
|
865 | - } else { |
|
866 | - echo $feedback; |
|
867 | - } |
|
868 | - smart_SetMeta('version', $newDbVersion, $dirname); //Set meta version to current |
|
869 | - |
|
870 | - return true; |
|
871 | - } |
|
827 | + $table->setData("'version',0"); |
|
828 | + if (!$this->updateTable($table)) { |
|
829 | + /** |
|
830 | + * @todo trap the errors |
|
831 | + */ |
|
832 | + } |
|
833 | + } |
|
834 | + |
|
835 | + $dbVersion = smart_GetMeta('version', $dirname); |
|
836 | + if (!$dbVersion) { |
|
837 | + $dbVersion = 0; |
|
838 | + } |
|
839 | + $newDbVersion = constant(strtoupper($dirname . '_db_version')) ?: 0; |
|
840 | + echo 'Database version: ' . $dbVersion . '<br>'; |
|
841 | + echo 'New database version: ' . $newDbVersion . '<br>'; |
|
842 | + |
|
843 | + if ($newDbVersion > $dbVersion) { |
|
844 | + for ($i = $dbVersion + 1; $i <= $newDbVersion; ++$i) { |
|
845 | + $upgrade_function = $dirname . '_db_upgrade_' . $i; |
|
846 | + if (function_exists($upgrade_function)) { |
|
847 | + $upgrade_function(); |
|
848 | + } |
|
849 | + } |
|
850 | + } |
|
851 | + |
|
852 | + echo '<code>' . _SDU_UPDATE_UPDATING_DATABASE . '<br>'; |
|
853 | + |
|
854 | + // if there is a function to execute for this DB version, let's do it |
|
855 | + //$function_ |
|
856 | + |
|
857 | + $module_info = smart_getModuleInfo($dirname); |
|
858 | + $this->automaticUpgrade($dirname, $module_info->modinfo['object_items']); |
|
859 | + |
|
860 | + echo '</code>'; |
|
861 | + |
|
862 | + $feedback = ob_get_clean(); |
|
863 | + if (method_exists($module, 'setMessage')) { |
|
864 | + $module->setMessage($feedback); |
|
865 | + } else { |
|
866 | + echo $feedback; |
|
867 | + } |
|
868 | + smart_SetMeta('version', $newDbVersion, $dirname); //Set meta version to current |
|
869 | + |
|
870 | + return true; |
|
871 | + } |
|
872 | 872 | } |
@@ -18,15 +18,15 @@ discard block |
||
18 | 18 | */ |
19 | 19 | // defined('XOOPS_ROOT_PATH') || exit('XOOPS root path not defined'); |
20 | 20 | if (!defined('SMARTOBJECT_ROOT_PATH')) { |
21 | - require_once XOOPS_ROOT_PATH . '/modules/smartobject/include/common.php'; |
|
21 | + require_once XOOPS_ROOT_PATH.'/modules/smartobject/include/common.php'; |
|
22 | 22 | } |
23 | 23 | /** |
24 | 24 | * Include the language constants for the SmartObjectDBUpdater |
25 | 25 | */ |
26 | 26 | global $xoopsConfig; |
27 | -$common_file = SMARTOBJECT_ROOT_PATH . 'language/' . $xoopsConfig['language'] . '/smartdbupdater.php'; |
|
27 | +$common_file = SMARTOBJECT_ROOT_PATH.'language/'.$xoopsConfig['language'].'/smartdbupdater.php'; |
|
28 | 28 | if (!file_exists($common_file)) { |
29 | - $common_file = SMARTOBJECT_ROOT_PATH . 'language/english/smartdbupdater.php'; |
|
29 | + $common_file = SMARTOBJECT_ROOT_PATH.'language/english/smartdbupdater.php'; |
|
30 | 30 | } |
31 | 31 | include $common_file; |
32 | 32 | |
@@ -123,20 +123,20 @@ discard block |
||
123 | 123 | public function getExistingFieldsArray() |
124 | 124 | { |
125 | 125 | global $xoopsDB; |
126 | - $result = $xoopsDB->query('SHOW COLUMNS FROM ' . $this->name()); |
|
126 | + $result = $xoopsDB->query('SHOW COLUMNS FROM '.$this->name()); |
|
127 | 127 | while ($existing_field = $xoopsDB->fetchArray($result)) { |
128 | 128 | $fields[$existing_field['Field']] = $existing_field['Type']; |
129 | 129 | if ($existing_field['Null'] !== 'YES') { |
130 | 130 | $fields[$existing_field['Field']] .= ' NOT NULL'; |
131 | 131 | } |
132 | 132 | if ($existing_field['Extra']) { |
133 | - $fields[$existing_field['Field']] .= ' ' . $existing_field['Extra']; |
|
133 | + $fields[$existing_field['Field']] .= ' '.$existing_field['Extra']; |
|
134 | 134 | } |
135 | 135 | if (!($existing_field['Default'] === null) |
136 | 136 | && ($existing_field['Default'] |
137 | 137 | || $existing_field['Default'] === '' |
138 | 138 | || $existing_field['Default'] == 0)) { |
139 | - $fields[$existing_field['Field']] .= " default '" . $existing_field['Default'] . "'"; |
|
139 | + $fields[$existing_field['Field']] .= " default '".$existing_field['Default']."'"; |
|
140 | 140 | } |
141 | 141 | } |
142 | 142 | |
@@ -222,9 +222,9 @@ discard block |
||
222 | 222 | $query = sprintf('INSERT INTO %s VALUES (%s)', $this->name(), $data); |
223 | 223 | $ret = $xoopsDB->query($query); |
224 | 224 | if (!$ret) { |
225 | - echo ' ' . sprintf(_SDU_MSG_ADD_DATA_ERR, $this->name()) . '<br>'; |
|
225 | + echo ' '.sprintf(_SDU_MSG_ADD_DATA_ERR, $this->name()).'<br>'; |
|
226 | 226 | } else { |
227 | - echo ' ' . sprintf(_SDU_MSG_ADD_DATA, $this->name()) . '<br>'; |
|
227 | + echo ' '.sprintf(_SDU_MSG_ADD_DATA, $this->name()).'<br>'; |
|
228 | 228 | } |
229 | 229 | } |
230 | 230 | |
@@ -376,13 +376,13 @@ discard block |
||
376 | 376 | { |
377 | 377 | global $xoopsDB; |
378 | 378 | $query = $this->getStructure(); |
379 | - $query = 'CREATE TABLE `' . $this->name() . '` (' . $query . ") ENGINE=MyISAM COMMENT='The SmartFactory <www.smartfactory.ca>'"; |
|
379 | + $query = 'CREATE TABLE `'.$this->name().'` ('.$query.") ENGINE=MyISAM COMMENT='The SmartFactory <www.smartfactory.ca>'"; |
|
380 | 380 | //xoops_debug($query); |
381 | 381 | $ret = $xoopsDB->query($query); |
382 | 382 | if (!$ret) { |
383 | - echo ' ' . sprintf(_SDU_MSG_CREATE_TABLE_ERR, $this->name()) . ' (' . $xoopsDB->error() . ')<br>'; |
|
383 | + echo ' '.sprintf(_SDU_MSG_CREATE_TABLE_ERR, $this->name()).' ('.$xoopsDB->error().')<br>'; |
|
384 | 384 | } else { |
385 | - echo ' ' . sprintf(_SDU_MSG_CREATE_TABLE, $this->name()) . '<br>'; |
|
385 | + echo ' '.sprintf(_SDU_MSG_CREATE_TABLE, $this->name()).'<br>'; |
|
386 | 386 | } |
387 | 387 | |
388 | 388 | return $ret; |
@@ -400,11 +400,11 @@ discard block |
||
400 | 400 | $query = sprintf('DROP TABLE %s', $this->name()); |
401 | 401 | $ret = $xoopsDB->query($query); |
402 | 402 | if (!$ret) { |
403 | - echo ' ' . sprintf(_SDU_MSG_DROP_TABLE_ERR, $this->name()) . ' (' . $xoopsDB->error() . ')<br>'; |
|
403 | + echo ' '.sprintf(_SDU_MSG_DROP_TABLE_ERR, $this->name()).' ('.$xoopsDB->error().')<br>'; |
|
404 | 404 | |
405 | 405 | return false; |
406 | 406 | } else { |
407 | - echo ' ' . sprintf(_SDU_MSG_DROP_TABLE, $this->name()) . '<br>'; |
|
407 | + echo ' '.sprintf(_SDU_MSG_DROP_TABLE, $this->name()).'<br>'; |
|
408 | 408 | |
409 | 409 | return true; |
410 | 410 | } |
@@ -430,9 +430,9 @@ discard block |
||
430 | 430 | $ret = $ret && $xoopsDB->query($query); |
431 | 431 | if ($alteredField['showerror']) { |
432 | 432 | if (!$ret) { |
433 | - echo ' ' . sprintf(_SDU_MSG_CHGFIELD_ERR, $alteredField['name'], $this->name()) . ' (' . $xoopsDB->error() . ')<br>'; |
|
433 | + echo ' '.sprintf(_SDU_MSG_CHGFIELD_ERR, $alteredField['name'], $this->name()).' ('.$xoopsDB->error().')<br>'; |
|
434 | 434 | } else { |
435 | - echo ' ' . sprintf(_SDU_MSG_CHGFIELD, $alteredField['name'], $this->name()) . '<br>'; |
|
435 | + echo ' '.sprintf(_SDU_MSG_CHGFIELD, $alteredField['name'], $this->name()).'<br>'; |
|
436 | 436 | } |
437 | 437 | } |
438 | 438 | } |
@@ -455,9 +455,9 @@ discard block |
||
455 | 455 | //echo $query; |
456 | 456 | $ret = $ret && $xoopsDB->query($query); |
457 | 457 | if (!$ret) { |
458 | - echo ' ' . sprintf(_SDU_MSG_NEWFIELD_ERR, $newField['name'], $this->name()) . '<br>'; |
|
458 | + echo ' '.sprintf(_SDU_MSG_NEWFIELD_ERR, $newField['name'], $this->name()).'<br>'; |
|
459 | 459 | } else { |
460 | - echo ' ' . sprintf(_SDU_MSG_NEWFIELD, $newField['name'], $this->name()) . '<br>'; |
|
460 | + echo ' '.sprintf(_SDU_MSG_NEWFIELD, $newField['name'], $this->name()).'<br>'; |
|
461 | 461 | } |
462 | 462 | } |
463 | 463 | |
@@ -478,9 +478,9 @@ discard block |
||
478 | 478 | $query = sprintf('UPDATE %s SET %s = %s', $this->name(), $updatedField['name'], $updatedField['value']); |
479 | 479 | $ret = $ret && $xoopsDB->query($query); |
480 | 480 | if (!$ret) { |
481 | - echo ' ' . sprintf(_SDU_MSG_UPDATE_TABLE_ERR, $this->name()) . ' (' . $xoopsDB->error() . ')<br>'; |
|
481 | + echo ' '.sprintf(_SDU_MSG_UPDATE_TABLE_ERR, $this->name()).' ('.$xoopsDB->error().')<br>'; |
|
482 | 482 | } else { |
483 | - echo ' ' . sprintf(_SDU_MSG_UPDATE_TABLE, $this->name()) . '<br>'; |
|
483 | + echo ' '.sprintf(_SDU_MSG_UPDATE_TABLE, $this->name()).'<br>'; |
|
484 | 484 | } |
485 | 485 | } |
486 | 486 | |
@@ -501,9 +501,9 @@ discard block |
||
501 | 501 | //echo $query."<br>"; |
502 | 502 | $ret = $ret && $xoopsDB->query($query); |
503 | 503 | if (!$ret) { |
504 | - echo ' ' . sprintf(_SDU_MSG_UPDATE_TABLE_ERR, $this->name()) . ' (' . $xoopsDB->error() . ')<br>'; |
|
504 | + echo ' '.sprintf(_SDU_MSG_UPDATE_TABLE_ERR, $this->name()).' ('.$xoopsDB->error().')<br>'; |
|
505 | 505 | } else { |
506 | - echo ' ' . sprintf(_SDU_MSG_UPDATE_TABLE, $this->name()) . '<br>'; |
|
506 | + echo ' '.sprintf(_SDU_MSG_UPDATE_TABLE, $this->name()).'<br>'; |
|
507 | 507 | } |
508 | 508 | } |
509 | 509 | |
@@ -524,9 +524,9 @@ discard block |
||
524 | 524 | $query = sprintf('ALTER TABLE %s DROP %s', $this->name(), $droppedField); |
525 | 525 | $ret = $ret && $xoopsDB->query($query); |
526 | 526 | if (!$ret) { |
527 | - echo ' ' . sprintf(_SDU_MSG_DROPFIELD_ERR, $droppedField, $this->name()) . ' (' . $xoopsDB->error() . ')<br>'; |
|
527 | + echo ' '.sprintf(_SDU_MSG_DROPFIELD_ERR, $droppedField, $this->name()).' ('.$xoopsDB->error().')<br>'; |
|
528 | 528 | } else { |
529 | - echo ' ' . sprintf(_SDU_MSG_DROPFIELD, $droppedField, $this->name()) . '<br>'; |
|
529 | + echo ' '.sprintf(_SDU_MSG_DROPFIELD, $droppedField, $this->name()).'<br>'; |
|
530 | 530 | } |
531 | 531 | } |
532 | 532 | |
@@ -613,11 +613,11 @@ discard block |
||
613 | 613 | $query = sprintf('ALTER TABLE %s RENAME %s', $from, $to); |
614 | 614 | $ret = $xoopsDB->query($query); |
615 | 615 | if (!$ret) { |
616 | - echo ' ' . sprintf(_SDU_MSG_RENAME_TABLE_ERR, $from) . '<br>'; |
|
616 | + echo ' '.sprintf(_SDU_MSG_RENAME_TABLE_ERR, $from).'<br>'; |
|
617 | 617 | |
618 | 618 | return false; |
619 | 619 | } else { |
620 | - echo ' ' . sprintf(_SDU_MSG_RENAME_TABLE, $from, $to) . '<br>'; |
|
620 | + echo ' '.sprintf(_SDU_MSG_RENAME_TABLE, $from, $to).'<br>'; |
|
621 | 621 | |
622 | 622 | return true; |
623 | 623 | } |
@@ -737,7 +737,7 @@ discard block |
||
737 | 737 | return false; |
738 | 738 | } |
739 | 739 | |
740 | - $table = new SmartDbTable($module . '_' . $item); |
|
740 | + $table = new SmartDbTable($module.'_'.$item); |
|
741 | 741 | $object = $moduleHandler->create(); |
742 | 742 | $objectVars = $object->getVars(); |
743 | 743 | |
@@ -758,7 +758,7 @@ discard block |
||
758 | 758 | "; |
759 | 759 | } |
760 | 760 | } |
761 | - $structure .= 'PRIMARY KEY (`' . $moduleHandler->keyName . '`) |
|
761 | + $structure .= 'PRIMARY KEY (`'.$moduleHandler->keyName.'`) |
|
762 | 762 | '; |
763 | 763 | $table->setStructure($structure); |
764 | 764 | if (!$this->updateTable($table)) { |
@@ -818,7 +818,7 @@ discard block |
||
818 | 818 | |
819 | 819 | ob_start(); |
820 | 820 | |
821 | - $table = new SmartDbTable($dirname . '_meta'); |
|
821 | + $table = new SmartDbTable($dirname.'_meta'); |
|
822 | 822 | if (!$table->exists()) { |
823 | 823 | $table->setStructure(" |
824 | 824 | `metakey` varchar(50) NOT NULL default '', |
@@ -836,20 +836,20 @@ discard block |
||
836 | 836 | if (!$dbVersion) { |
837 | 837 | $dbVersion = 0; |
838 | 838 | } |
839 | - $newDbVersion = constant(strtoupper($dirname . '_db_version')) ?: 0; |
|
840 | - echo 'Database version: ' . $dbVersion . '<br>'; |
|
841 | - echo 'New database version: ' . $newDbVersion . '<br>'; |
|
839 | + $newDbVersion = constant(strtoupper($dirname.'_db_version')) ?: 0; |
|
840 | + echo 'Database version: '.$dbVersion.'<br>'; |
|
841 | + echo 'New database version: '.$newDbVersion.'<br>'; |
|
842 | 842 | |
843 | 843 | if ($newDbVersion > $dbVersion) { |
844 | 844 | for ($i = $dbVersion + 1; $i <= $newDbVersion; ++$i) { |
845 | - $upgrade_function = $dirname . '_db_upgrade_' . $i; |
|
845 | + $upgrade_function = $dirname.'_db_upgrade_'.$i; |
|
846 | 846 | if (function_exists($upgrade_function)) { |
847 | 847 | $upgrade_function(); |
848 | 848 | } |
849 | 849 | } |
850 | 850 | } |
851 | 851 | |
852 | - echo '<code>' . _SDU_UPDATE_UPDATING_DATABASE . '<br>'; |
|
852 | + echo '<code>'._SDU_UPDATE_UPDATING_DATABASE.'<br>'; |
|
853 | 853 | |
854 | 854 | // if there is a function to execute for this DB version, let's do it |
855 | 855 | //$function_ |
@@ -19,165 +19,165 @@ |
||
19 | 19 | */ |
20 | 20 | class SmartobjectAbout |
21 | 21 | { |
22 | - public $_lang_aboutTitle; |
|
23 | - public $_lang_author_info; |
|
24 | - public $_lang_developer_lead; |
|
25 | - public $_lang_developer_contributor; |
|
26 | - public $_lang_developer_website; |
|
27 | - public $_lang_developer_email; |
|
28 | - public $_lang_developer_credits; |
|
29 | - public $_lang_module_info; |
|
30 | - public $_lang_module_status; |
|
31 | - public $_lang_module_release_date; |
|
32 | - public $_lang_module_demo; |
|
33 | - public $_lang_module_support; |
|
34 | - public $_lang_module_bug; |
|
35 | - public $_lang_module_submit_bug; |
|
36 | - public $_lang_module_feature; |
|
37 | - public $_lang_module_submit_feature; |
|
38 | - public $_lang_module_disclaimer; |
|
39 | - public $_lang_author_word; |
|
40 | - public $_lang_version_history; |
|
41 | - public $_lang_by; |
|
42 | - public $_tpl; |
|
43 | - |
|
44 | - /** |
|
45 | - * SmartobjectAbout constructor. |
|
46 | - * @param string $aboutTitle |
|
47 | - */ |
|
48 | - public function __construct($aboutTitle = 'About') |
|
49 | - { |
|
50 | - global $xoopsModule, $xoopsConfig; |
|
51 | - |
|
52 | - $fileName = XOOPS_ROOT_PATH . '/modules/' . $xoopsModule->getVar('dirname') . '/language/' . $xoopsConfig['language'] . '/modinfo.php'; |
|
53 | - if (file_exists($fileName)) { |
|
54 | - require_once $fileName; |
|
55 | - } else { |
|
56 | - require_once XOOPS_ROOT_PATH . '/modules/' . $xoopsModule->getVar('dirname') . '/language/english/modinfo.php'; |
|
57 | - } |
|
58 | - $this->_aboutTitle = $aboutTitle; |
|
59 | - |
|
60 | - $this->_lang_developer_contributor = _CO_SOBJECT_DEVELOPER_CONTRIBUTOR; |
|
61 | - $this->_lang_developer_website = _CO_SOBJECT_DEVELOPER_WEBSITE; |
|
62 | - $this->_lang_developer_email = _CO_SOBJECT_DEVELOPER_EMAIL; |
|
63 | - $this->_lang_developer_credits = _CO_SOBJECT_DEVELOPER_CREDITS; |
|
64 | - $this->_lang_module_info = _CO_SOBJECT_MODULE_INFO; |
|
65 | - $this->_lang_module_status = _CO_SOBJECT_MODULE_STATUS; |
|
66 | - $this->_lang_module_release_date = _CO_SOBJECT_MODULE_RELEASE_DATE; |
|
67 | - $this->_lang_module_demo = _CO_SOBJECT_MODULE_DEMO; |
|
68 | - $this->_lang_module_support = _CO_SOBJECT_MODULE_SUPPORT; |
|
69 | - $this->_lang_module_bug = _CO_SOBJECT_MODULE_BUG; |
|
70 | - $this->_lang_module_submit_bug = _CO_SOBJECT_MODULE_SUBMIT_BUG; |
|
71 | - $this->_lang_module_feature = _CO_SOBJECT_MODULE_FEATURE; |
|
72 | - $this->_lang_module_submit_feature = _CO_SOBJECT_MODULE_SUBMIT_FEATURE; |
|
73 | - $this->_lang_module_disclaimer = _CO_SOBJECT_MODULE_DISCLAIMER; |
|
74 | - $this->_lang_author_word = _CO_SOBJECT_AUTHOR_WORD; |
|
75 | - $this->_lang_version_history = _CO_SOBJECT_VERSION_HISTORY; |
|
76 | - } |
|
77 | - |
|
78 | - /** |
|
79 | - * @param $value |
|
80 | - * @return mixed |
|
81 | - */ |
|
82 | - public function sanitize($value) |
|
83 | - { |
|
84 | - $myts = MyTextSanitizer::getInstance(); |
|
85 | - |
|
86 | - return $myts->displayTarea($value, 1); |
|
87 | - } |
|
88 | - |
|
89 | - public function render() |
|
90 | - { |
|
91 | - /** |
|
92 | - * @todo move the output to a template |
|
93 | - * @todo make the output XHTML compliant |
|
94 | - */ |
|
95 | - |
|
96 | - $myts = MyTextSanitizer::getInstance(); |
|
97 | - |
|
98 | - global $xoopsModule; |
|
99 | - |
|
100 | - smart_xoops_cp_header(); |
|
101 | - |
|
102 | - /** @var XoopsModuleHandler $moduleHandler */ |
|
103 | - $moduleHandler = xoops_getHandler('module'); |
|
104 | - $versioninfo = $moduleHandler->get($xoopsModule->getVar('mid')); |
|
105 | - |
|
106 | - //smart_adminMenu(-1, $this->_aboutTitle . " " . $versioninfo->getInfo('name')); |
|
107 | - |
|
108 | - require_once XOOPS_ROOT_PATH . '/class/template.php'; |
|
109 | - |
|
110 | - // --- |
|
111 | - // 2012-01-01 PHP 5.3: Assigning the return value of new by reference is now deprecated. |
|
112 | - // $this->_tpl = new XoopsTpl(); |
|
113 | - $this->_tpl = new XoopsTpl(); |
|
114 | - // --- |
|
115 | - |
|
116 | - $this->_tpl->assign('module_url', XOOPS_URL . '/modules/' . $xoopsModule->getVar('dirname') . '/'); |
|
117 | - $this->_tpl->assign('module_image', $versioninfo->getInfo('image')); |
|
118 | - $this->_tpl->assign('module_name', $versioninfo->getInfo('name')); |
|
119 | - $this->_tpl->assign('module_version', $versioninfo->getInfo('version')); |
|
120 | - $this->_tpl->assign('module_status_version', $versioninfo->getInfo('status_version')); |
|
121 | - |
|
122 | - // Left headings... |
|
123 | - if ($versioninfo->getInfo('author_realname') !== '') { |
|
124 | - $author_name = $versioninfo->getInfo('author') . ' (' . $versioninfo->getInfo('author_realname') . ')'; |
|
125 | - } else { |
|
126 | - $author_name = $versioninfo->getInfo('author'); |
|
127 | - } |
|
128 | - $this->_tpl->assign('module_author_name', $author_name); |
|
129 | - |
|
130 | - $this->_tpl->assign('module_license', $versioninfo->getInfo('license')); |
|
131 | - |
|
132 | - $this->_tpl->assign('module_credits', $versioninfo->getInfo('credits')); |
|
133 | - |
|
134 | - // Developers Information |
|
135 | - $this->_tpl->assign('module_developer_lead', $versioninfo->getInfo('developer_lead')); |
|
136 | - $this->_tpl->assign('module_developer_contributor', $versioninfo->getInfo('developer_contributor')); |
|
137 | - $this->_tpl->assign('module_developer_website_url', $versioninfo->getInfo('developer_website_url')); |
|
138 | - $this->_tpl->assign('module_developer_website_name', $versioninfo->getInfo('developer_website_name')); |
|
139 | - $this->_tpl->assign('module_developer_email', $versioninfo->getInfo('developer_email')); |
|
140 | - |
|
141 | - $people = $versioninfo->getInfo('people'); |
|
142 | - if ($people) { |
|
143 | - $this->_tpl->assign('module_people_developers', isset($people['developers']) ? array_map(array($this, 'sanitize'), $people['developers']) : false); |
|
144 | - $this->_tpl->assign('module_people_testers', isset($people['testers']) ? array_map(array($this, 'sanitize'), $people['testers']) : false); |
|
145 | - $this->_tpl->assign('module_people_translators', isset($people['translators']) ? array_map(array($this, 'sanitize'), $people['translators']) : false); |
|
146 | - $this->_tpl->assign('module_people_documenters', isset($people['documenters']) ? array_map(array($this, 'sanitize'), $people['documenters']) : false); |
|
147 | - $this->_tpl->assign('module_people_other', isset($people['other']) ? array_map(array($this, 'sanitize'), $people['other']) : false); |
|
148 | - } |
|
149 | - //$this->_tpl->assign('module_developers', $versioninfo->getInfo('developer_email')); |
|
150 | - |
|
151 | - // Module Development information |
|
152 | - $this->_tpl->assign('module_date', $versioninfo->getInfo('date')); |
|
153 | - $this->_tpl->assign('module_status', $versioninfo->getInfo('status')); |
|
154 | - $this->_tpl->assign('module_demo_site_url', $versioninfo->getInfo('demo_site_url')); |
|
155 | - $this->_tpl->assign('module_demo_site_name', $versioninfo->getInfo('demo_site_name')); |
|
156 | - $this->_tpl->assign('module_support_site_url', $versioninfo->getInfo('support_site_url')); |
|
157 | - $this->_tpl->assign('module_support_site_name', $versioninfo->getInfo('support_site_name')); |
|
158 | - $this->_tpl->assign('module_submit_bug', $versioninfo->getInfo('submit_bug')); |
|
159 | - $this->_tpl->assign('module_submit_feature', $versioninfo->getInfo('submit_feature')); |
|
160 | - |
|
161 | - // Warning |
|
162 | - $this->_tpl->assign('module_warning', $this->sanitize($versioninfo->getInfo('warning'))); |
|
163 | - |
|
164 | - // Author's note |
|
165 | - $this->_tpl->assign('module_author_word', $versioninfo->getInfo('author_word')); |
|
166 | - |
|
167 | - // For changelog thanks to 3Dev |
|
168 | - global $xoopsModule; |
|
169 | - $filename = XOOPS_ROOT_PATH . '/modules/' . $xoopsModule->getVar('dirname') . '/changelog.txt'; |
|
170 | - if (is_file($filename)) { |
|
171 | - $filesize = filesize($filename); |
|
172 | - $handle = fopen($filename, 'r'); |
|
173 | - $this->_tpl->assign('module_version_history', $myts->displayTarea(fread($handle, $filesize), true)); |
|
174 | - fclose($handle); |
|
175 | - } |
|
176 | - |
|
177 | - $this->_tpl->display('db:smartobject_about.tpl'); |
|
178 | - |
|
179 | - smart_modFooter(); |
|
180 | - |
|
181 | - xoops_cp_footer(); |
|
182 | - } |
|
22 | + public $_lang_aboutTitle; |
|
23 | + public $_lang_author_info; |
|
24 | + public $_lang_developer_lead; |
|
25 | + public $_lang_developer_contributor; |
|
26 | + public $_lang_developer_website; |
|
27 | + public $_lang_developer_email; |
|
28 | + public $_lang_developer_credits; |
|
29 | + public $_lang_module_info; |
|
30 | + public $_lang_module_status; |
|
31 | + public $_lang_module_release_date; |
|
32 | + public $_lang_module_demo; |
|
33 | + public $_lang_module_support; |
|
34 | + public $_lang_module_bug; |
|
35 | + public $_lang_module_submit_bug; |
|
36 | + public $_lang_module_feature; |
|
37 | + public $_lang_module_submit_feature; |
|
38 | + public $_lang_module_disclaimer; |
|
39 | + public $_lang_author_word; |
|
40 | + public $_lang_version_history; |
|
41 | + public $_lang_by; |
|
42 | + public $_tpl; |
|
43 | + |
|
44 | + /** |
|
45 | + * SmartobjectAbout constructor. |
|
46 | + * @param string $aboutTitle |
|
47 | + */ |
|
48 | + public function __construct($aboutTitle = 'About') |
|
49 | + { |
|
50 | + global $xoopsModule, $xoopsConfig; |
|
51 | + |
|
52 | + $fileName = XOOPS_ROOT_PATH . '/modules/' . $xoopsModule->getVar('dirname') . '/language/' . $xoopsConfig['language'] . '/modinfo.php'; |
|
53 | + if (file_exists($fileName)) { |
|
54 | + require_once $fileName; |
|
55 | + } else { |
|
56 | + require_once XOOPS_ROOT_PATH . '/modules/' . $xoopsModule->getVar('dirname') . '/language/english/modinfo.php'; |
|
57 | + } |
|
58 | + $this->_aboutTitle = $aboutTitle; |
|
59 | + |
|
60 | + $this->_lang_developer_contributor = _CO_SOBJECT_DEVELOPER_CONTRIBUTOR; |
|
61 | + $this->_lang_developer_website = _CO_SOBJECT_DEVELOPER_WEBSITE; |
|
62 | + $this->_lang_developer_email = _CO_SOBJECT_DEVELOPER_EMAIL; |
|
63 | + $this->_lang_developer_credits = _CO_SOBJECT_DEVELOPER_CREDITS; |
|
64 | + $this->_lang_module_info = _CO_SOBJECT_MODULE_INFO; |
|
65 | + $this->_lang_module_status = _CO_SOBJECT_MODULE_STATUS; |
|
66 | + $this->_lang_module_release_date = _CO_SOBJECT_MODULE_RELEASE_DATE; |
|
67 | + $this->_lang_module_demo = _CO_SOBJECT_MODULE_DEMO; |
|
68 | + $this->_lang_module_support = _CO_SOBJECT_MODULE_SUPPORT; |
|
69 | + $this->_lang_module_bug = _CO_SOBJECT_MODULE_BUG; |
|
70 | + $this->_lang_module_submit_bug = _CO_SOBJECT_MODULE_SUBMIT_BUG; |
|
71 | + $this->_lang_module_feature = _CO_SOBJECT_MODULE_FEATURE; |
|
72 | + $this->_lang_module_submit_feature = _CO_SOBJECT_MODULE_SUBMIT_FEATURE; |
|
73 | + $this->_lang_module_disclaimer = _CO_SOBJECT_MODULE_DISCLAIMER; |
|
74 | + $this->_lang_author_word = _CO_SOBJECT_AUTHOR_WORD; |
|
75 | + $this->_lang_version_history = _CO_SOBJECT_VERSION_HISTORY; |
|
76 | + } |
|
77 | + |
|
78 | + /** |
|
79 | + * @param $value |
|
80 | + * @return mixed |
|
81 | + */ |
|
82 | + public function sanitize($value) |
|
83 | + { |
|
84 | + $myts = MyTextSanitizer::getInstance(); |
|
85 | + |
|
86 | + return $myts->displayTarea($value, 1); |
|
87 | + } |
|
88 | + |
|
89 | + public function render() |
|
90 | + { |
|
91 | + /** |
|
92 | + * @todo move the output to a template |
|
93 | + * @todo make the output XHTML compliant |
|
94 | + */ |
|
95 | + |
|
96 | + $myts = MyTextSanitizer::getInstance(); |
|
97 | + |
|
98 | + global $xoopsModule; |
|
99 | + |
|
100 | + smart_xoops_cp_header(); |
|
101 | + |
|
102 | + /** @var XoopsModuleHandler $moduleHandler */ |
|
103 | + $moduleHandler = xoops_getHandler('module'); |
|
104 | + $versioninfo = $moduleHandler->get($xoopsModule->getVar('mid')); |
|
105 | + |
|
106 | + //smart_adminMenu(-1, $this->_aboutTitle . " " . $versioninfo->getInfo('name')); |
|
107 | + |
|
108 | + require_once XOOPS_ROOT_PATH . '/class/template.php'; |
|
109 | + |
|
110 | + // --- |
|
111 | + // 2012-01-01 PHP 5.3: Assigning the return value of new by reference is now deprecated. |
|
112 | + // $this->_tpl = new XoopsTpl(); |
|
113 | + $this->_tpl = new XoopsTpl(); |
|
114 | + // --- |
|
115 | + |
|
116 | + $this->_tpl->assign('module_url', XOOPS_URL . '/modules/' . $xoopsModule->getVar('dirname') . '/'); |
|
117 | + $this->_tpl->assign('module_image', $versioninfo->getInfo('image')); |
|
118 | + $this->_tpl->assign('module_name', $versioninfo->getInfo('name')); |
|
119 | + $this->_tpl->assign('module_version', $versioninfo->getInfo('version')); |
|
120 | + $this->_tpl->assign('module_status_version', $versioninfo->getInfo('status_version')); |
|
121 | + |
|
122 | + // Left headings... |
|
123 | + if ($versioninfo->getInfo('author_realname') !== '') { |
|
124 | + $author_name = $versioninfo->getInfo('author') . ' (' . $versioninfo->getInfo('author_realname') . ')'; |
|
125 | + } else { |
|
126 | + $author_name = $versioninfo->getInfo('author'); |
|
127 | + } |
|
128 | + $this->_tpl->assign('module_author_name', $author_name); |
|
129 | + |
|
130 | + $this->_tpl->assign('module_license', $versioninfo->getInfo('license')); |
|
131 | + |
|
132 | + $this->_tpl->assign('module_credits', $versioninfo->getInfo('credits')); |
|
133 | + |
|
134 | + // Developers Information |
|
135 | + $this->_tpl->assign('module_developer_lead', $versioninfo->getInfo('developer_lead')); |
|
136 | + $this->_tpl->assign('module_developer_contributor', $versioninfo->getInfo('developer_contributor')); |
|
137 | + $this->_tpl->assign('module_developer_website_url', $versioninfo->getInfo('developer_website_url')); |
|
138 | + $this->_tpl->assign('module_developer_website_name', $versioninfo->getInfo('developer_website_name')); |
|
139 | + $this->_tpl->assign('module_developer_email', $versioninfo->getInfo('developer_email')); |
|
140 | + |
|
141 | + $people = $versioninfo->getInfo('people'); |
|
142 | + if ($people) { |
|
143 | + $this->_tpl->assign('module_people_developers', isset($people['developers']) ? array_map(array($this, 'sanitize'), $people['developers']) : false); |
|
144 | + $this->_tpl->assign('module_people_testers', isset($people['testers']) ? array_map(array($this, 'sanitize'), $people['testers']) : false); |
|
145 | + $this->_tpl->assign('module_people_translators', isset($people['translators']) ? array_map(array($this, 'sanitize'), $people['translators']) : false); |
|
146 | + $this->_tpl->assign('module_people_documenters', isset($people['documenters']) ? array_map(array($this, 'sanitize'), $people['documenters']) : false); |
|
147 | + $this->_tpl->assign('module_people_other', isset($people['other']) ? array_map(array($this, 'sanitize'), $people['other']) : false); |
|
148 | + } |
|
149 | + //$this->_tpl->assign('module_developers', $versioninfo->getInfo('developer_email')); |
|
150 | + |
|
151 | + // Module Development information |
|
152 | + $this->_tpl->assign('module_date', $versioninfo->getInfo('date')); |
|
153 | + $this->_tpl->assign('module_status', $versioninfo->getInfo('status')); |
|
154 | + $this->_tpl->assign('module_demo_site_url', $versioninfo->getInfo('demo_site_url')); |
|
155 | + $this->_tpl->assign('module_demo_site_name', $versioninfo->getInfo('demo_site_name')); |
|
156 | + $this->_tpl->assign('module_support_site_url', $versioninfo->getInfo('support_site_url')); |
|
157 | + $this->_tpl->assign('module_support_site_name', $versioninfo->getInfo('support_site_name')); |
|
158 | + $this->_tpl->assign('module_submit_bug', $versioninfo->getInfo('submit_bug')); |
|
159 | + $this->_tpl->assign('module_submit_feature', $versioninfo->getInfo('submit_feature')); |
|
160 | + |
|
161 | + // Warning |
|
162 | + $this->_tpl->assign('module_warning', $this->sanitize($versioninfo->getInfo('warning'))); |
|
163 | + |
|
164 | + // Author's note |
|
165 | + $this->_tpl->assign('module_author_word', $versioninfo->getInfo('author_word')); |
|
166 | + |
|
167 | + // For changelog thanks to 3Dev |
|
168 | + global $xoopsModule; |
|
169 | + $filename = XOOPS_ROOT_PATH . '/modules/' . $xoopsModule->getVar('dirname') . '/changelog.txt'; |
|
170 | + if (is_file($filename)) { |
|
171 | + $filesize = filesize($filename); |
|
172 | + $handle = fopen($filename, 'r'); |
|
173 | + $this->_tpl->assign('module_version_history', $myts->displayTarea(fread($handle, $filesize), true)); |
|
174 | + fclose($handle); |
|
175 | + } |
|
176 | + |
|
177 | + $this->_tpl->display('db:smartobject_about.tpl'); |
|
178 | + |
|
179 | + smart_modFooter(); |
|
180 | + |
|
181 | + xoops_cp_footer(); |
|
182 | + } |
|
183 | 183 | } |
@@ -49,11 +49,11 @@ discard block |
||
49 | 49 | { |
50 | 50 | global $xoopsModule, $xoopsConfig; |
51 | 51 | |
52 | - $fileName = XOOPS_ROOT_PATH . '/modules/' . $xoopsModule->getVar('dirname') . '/language/' . $xoopsConfig['language'] . '/modinfo.php'; |
|
52 | + $fileName = XOOPS_ROOT_PATH.'/modules/'.$xoopsModule->getVar('dirname').'/language/'.$xoopsConfig['language'].'/modinfo.php'; |
|
53 | 53 | if (file_exists($fileName)) { |
54 | 54 | require_once $fileName; |
55 | 55 | } else { |
56 | - require_once XOOPS_ROOT_PATH . '/modules/' . $xoopsModule->getVar('dirname') . '/language/english/modinfo.php'; |
|
56 | + require_once XOOPS_ROOT_PATH.'/modules/'.$xoopsModule->getVar('dirname').'/language/english/modinfo.php'; |
|
57 | 57 | } |
58 | 58 | $this->_aboutTitle = $aboutTitle; |
59 | 59 | |
@@ -105,7 +105,7 @@ discard block |
||
105 | 105 | |
106 | 106 | //smart_adminMenu(-1, $this->_aboutTitle . " " . $versioninfo->getInfo('name')); |
107 | 107 | |
108 | - require_once XOOPS_ROOT_PATH . '/class/template.php'; |
|
108 | + require_once XOOPS_ROOT_PATH.'/class/template.php'; |
|
109 | 109 | |
110 | 110 | // --- |
111 | 111 | // 2012-01-01 PHP 5.3: Assigning the return value of new by reference is now deprecated. |
@@ -113,7 +113,7 @@ discard block |
||
113 | 113 | $this->_tpl = new XoopsTpl(); |
114 | 114 | // --- |
115 | 115 | |
116 | - $this->_tpl->assign('module_url', XOOPS_URL . '/modules/' . $xoopsModule->getVar('dirname') . '/'); |
|
116 | + $this->_tpl->assign('module_url', XOOPS_URL.'/modules/'.$xoopsModule->getVar('dirname').'/'); |
|
117 | 117 | $this->_tpl->assign('module_image', $versioninfo->getInfo('image')); |
118 | 118 | $this->_tpl->assign('module_name', $versioninfo->getInfo('name')); |
119 | 119 | $this->_tpl->assign('module_version', $versioninfo->getInfo('version')); |
@@ -121,7 +121,7 @@ discard block |
||
121 | 121 | |
122 | 122 | // Left headings... |
123 | 123 | if ($versioninfo->getInfo('author_realname') !== '') { |
124 | - $author_name = $versioninfo->getInfo('author') . ' (' . $versioninfo->getInfo('author_realname') . ')'; |
|
124 | + $author_name = $versioninfo->getInfo('author').' ('.$versioninfo->getInfo('author_realname').')'; |
|
125 | 125 | } else { |
126 | 126 | $author_name = $versioninfo->getInfo('author'); |
127 | 127 | } |
@@ -166,7 +166,7 @@ discard block |
||
166 | 166 | |
167 | 167 | // For changelog thanks to 3Dev |
168 | 168 | global $xoopsModule; |
169 | - $filename = XOOPS_ROOT_PATH . '/modules/' . $xoopsModule->getVar('dirname') . '/changelog.txt'; |
|
169 | + $filename = XOOPS_ROOT_PATH.'/modules/'.$xoopsModule->getVar('dirname').'/changelog.txt'; |
|
170 | 170 | if (is_file($filename)) { |
171 | 171 | $filesize = filesize($filename); |
172 | 172 | $handle = fopen($filename, 'r'); |
@@ -35,19 +35,19 @@ discard block |
||
35 | 35 | */ |
36 | 36 | class SmartobjectTag extends SmartMlObject |
37 | 37 | { |
38 | - /** |
|
39 | - * SmartobjectTag constructor. |
|
40 | - */ |
|
41 | - public function __construct() |
|
42 | - { |
|
43 | - $this->initVar('tagid', XOBJ_DTYPE_INT, '', true); |
|
44 | - $this->initVar('name', XOBJ_DTYPE_TXTBOX, '', true, 255, '', false, _CO_SOBJECT_TAG_TAGID_CAPTION, _CO_SOBJECT_TAG_TAGID_DSC, true); |
|
45 | - $this->initVar('description', XOBJ_DTYPE_TXTAREA, '', true, null, '', false, _CO_SOBJECT_TAG_DESCRIPTION_CAPTION, _CO_SOBJECT_TAG_DESCRIPTION_DSC); |
|
46 | - $this->initVar('value', XOBJ_DTYPE_TXTAREA, '', true, null, '', true, _CO_SOBJECT_TAG_VALUE_CAPTION, _CO_SOBJECT_TAG_VALUE_DSC); |
|
38 | + /** |
|
39 | + * SmartobjectTag constructor. |
|
40 | + */ |
|
41 | + public function __construct() |
|
42 | + { |
|
43 | + $this->initVar('tagid', XOBJ_DTYPE_INT, '', true); |
|
44 | + $this->initVar('name', XOBJ_DTYPE_TXTBOX, '', true, 255, '', false, _CO_SOBJECT_TAG_TAGID_CAPTION, _CO_SOBJECT_TAG_TAGID_DSC, true); |
|
45 | + $this->initVar('description', XOBJ_DTYPE_TXTAREA, '', true, null, '', false, _CO_SOBJECT_TAG_DESCRIPTION_CAPTION, _CO_SOBJECT_TAG_DESCRIPTION_DSC); |
|
46 | + $this->initVar('value', XOBJ_DTYPE_TXTAREA, '', true, null, '', true, _CO_SOBJECT_TAG_VALUE_CAPTION, _CO_SOBJECT_TAG_VALUE_DSC); |
|
47 | 47 | |
48 | - // call parent constructor to get Multilanguage field initiated |
|
49 | - $this->SmartMlObject(); |
|
50 | - } |
|
48 | + // call parent constructor to get Multilanguage field initiated |
|
49 | + $this->SmartMlObject(); |
|
50 | + } |
|
51 | 51 | } |
52 | 52 | |
53 | 53 | /** |
@@ -55,27 +55,27 @@ discard block |
||
55 | 55 | */ |
56 | 56 | class SmartobjectTagHandler extends SmartPersistableMlObjectHandler |
57 | 57 | { |
58 | - /** |
|
59 | - * SmartobjectTagHandler constructor. |
|
60 | - * @param XoopsDatabase $db |
|
61 | - */ |
|
62 | - public function __construct(XoopsDatabase $db) |
|
63 | - { |
|
64 | - parent::__construct($db, 'tag', 'tagid', 'name', 'description', 'smartobject'); |
|
65 | - } |
|
58 | + /** |
|
59 | + * SmartobjectTagHandler constructor. |
|
60 | + * @param XoopsDatabase $db |
|
61 | + */ |
|
62 | + public function __construct(XoopsDatabase $db) |
|
63 | + { |
|
64 | + parent::__construct($db, 'tag', 'tagid', 'name', 'description', 'smartobject'); |
|
65 | + } |
|
66 | 66 | |
67 | - /** |
|
68 | - * @return mixed |
|
69 | - */ |
|
70 | - public function getLanguages() |
|
71 | - { |
|
72 | - require_once XOOPS_ROOT_PATH . '/class/xoopslists.php'; |
|
73 | - $aLanguages = XoopsLists::getLangList(); |
|
74 | - $ret['default'] = _CO_SOBJECT_ALL; |
|
75 | - foreach ($aLanguages as $lang) { |
|
76 | - $ret[$lang] = $lang; |
|
77 | - } |
|
67 | + /** |
|
68 | + * @return mixed |
|
69 | + */ |
|
70 | + public function getLanguages() |
|
71 | + { |
|
72 | + require_once XOOPS_ROOT_PATH . '/class/xoopslists.php'; |
|
73 | + $aLanguages = XoopsLists::getLangList(); |
|
74 | + $ret['default'] = _CO_SOBJECT_ALL; |
|
75 | + foreach ($aLanguages as $lang) { |
|
76 | + $ret[$lang] = $lang; |
|
77 | + } |
|
78 | 78 | |
79 | - return $ret; |
|
80 | - } |
|
79 | + return $ret; |
|
80 | + } |
|
81 | 81 | } |
@@ -28,7 +28,7 @@ discard block |
||
28 | 28 | // -------------------------------------------------------------------------// |
29 | 29 | |
30 | 30 | // defined('XOOPS_ROOT_PATH') || exit('XOOPS root path not defined'); |
31 | -require_once XOOPS_ROOT_PATH . '/modules/smartobject/class/smartmlobject.php'; |
|
31 | +require_once XOOPS_ROOT_PATH.'/modules/smartobject/class/smartmlobject.php'; |
|
32 | 32 | |
33 | 33 | /** |
34 | 34 | * Class SmartobjectTag |
@@ -69,7 +69,7 @@ discard block |
||
69 | 69 | */ |
70 | 70 | public function getLanguages() |
71 | 71 | { |
72 | - require_once XOOPS_ROOT_PATH . '/class/xoopslists.php'; |
|
72 | + require_once XOOPS_ROOT_PATH.'/class/xoopslists.php'; |
|
73 | 73 | $aLanguages = XoopsLists::getLangList(); |
74 | 74 | $ret['default'] = _CO_SOBJECT_ALL; |
75 | 75 | foreach ($aLanguages as $lang) { |
@@ -5,68 +5,68 @@ discard block |
||
5 | 5 | */ |
6 | 6 | class SmartPlugin |
7 | 7 | { |
8 | - public $_infoArray; |
|
9 | - |
|
10 | - /** |
|
11 | - * SmartPlugin constructor. |
|
12 | - * @param $array |
|
13 | - */ |
|
14 | - public function __construct($array) |
|
15 | - { |
|
16 | - $this->_infoArray = $array; |
|
17 | - } |
|
18 | - |
|
19 | - /** |
|
20 | - * @param $item |
|
21 | - * @return bool |
|
22 | - */ |
|
23 | - public function getItemInfo($item) |
|
24 | - { |
|
25 | - if (isset($this->_infoArray['items'][$item])) { |
|
26 | - return $this->_infoArray['items'][$item]; |
|
27 | - } else { |
|
28 | - return false; |
|
29 | - } |
|
30 | - } |
|
31 | - |
|
32 | - /** |
|
33 | - * @return mixed |
|
34 | - */ |
|
35 | - public function getItemList() |
|
36 | - { |
|
37 | - $itemsArray = $this->_infoArray['items']; |
|
38 | - foreach ($itemsArray as $k => $v) { |
|
39 | - $ret[$k] = $v['caption']; |
|
40 | - } |
|
41 | - |
|
42 | - return $ret; |
|
43 | - } |
|
44 | - |
|
45 | - /** |
|
46 | - * @return bool|int|string |
|
47 | - */ |
|
48 | - public function getItem() |
|
49 | - { |
|
50 | - $ret = false; |
|
51 | - foreach ($this->_infoArray['items'] as $k => $v) { |
|
52 | - $search_str = str_replace('%u', '', $v['url']); |
|
53 | - if (strpos($_SERVER['PHP_SELF'] . '?' . $_SERVER['QUERY_STRING'], $search_str) > 0) { |
|
54 | - $ret = $k; |
|
55 | - break; |
|
56 | - } |
|
57 | - } |
|
58 | - |
|
59 | - return $ret; |
|
60 | - } |
|
61 | - |
|
62 | - /** |
|
63 | - * @param $item |
|
64 | - * @return mixed |
|
65 | - */ |
|
66 | - public function getItemIdForItem($item) |
|
67 | - { |
|
68 | - return $_REQUEST[$this->_infoArray['items'][$item]['request']]; |
|
69 | - } |
|
8 | + public $_infoArray; |
|
9 | + |
|
10 | + /** |
|
11 | + * SmartPlugin constructor. |
|
12 | + * @param $array |
|
13 | + */ |
|
14 | + public function __construct($array) |
|
15 | + { |
|
16 | + $this->_infoArray = $array; |
|
17 | + } |
|
18 | + |
|
19 | + /** |
|
20 | + * @param $item |
|
21 | + * @return bool |
|
22 | + */ |
|
23 | + public function getItemInfo($item) |
|
24 | + { |
|
25 | + if (isset($this->_infoArray['items'][$item])) { |
|
26 | + return $this->_infoArray['items'][$item]; |
|
27 | + } else { |
|
28 | + return false; |
|
29 | + } |
|
30 | + } |
|
31 | + |
|
32 | + /** |
|
33 | + * @return mixed |
|
34 | + */ |
|
35 | + public function getItemList() |
|
36 | + { |
|
37 | + $itemsArray = $this->_infoArray['items']; |
|
38 | + foreach ($itemsArray as $k => $v) { |
|
39 | + $ret[$k] = $v['caption']; |
|
40 | + } |
|
41 | + |
|
42 | + return $ret; |
|
43 | + } |
|
44 | + |
|
45 | + /** |
|
46 | + * @return bool|int|string |
|
47 | + */ |
|
48 | + public function getItem() |
|
49 | + { |
|
50 | + $ret = false; |
|
51 | + foreach ($this->_infoArray['items'] as $k => $v) { |
|
52 | + $search_str = str_replace('%u', '', $v['url']); |
|
53 | + if (strpos($_SERVER['PHP_SELF'] . '?' . $_SERVER['QUERY_STRING'], $search_str) > 0) { |
|
54 | + $ret = $k; |
|
55 | + break; |
|
56 | + } |
|
57 | + } |
|
58 | + |
|
59 | + return $ret; |
|
60 | + } |
|
61 | + |
|
62 | + /** |
|
63 | + * @param $item |
|
64 | + * @return mixed |
|
65 | + */ |
|
66 | + public function getItemIdForItem($item) |
|
67 | + { |
|
68 | + return $_REQUEST[$this->_infoArray['items'][$item]['request']]; |
|
69 | + } |
|
70 | 70 | } |
71 | 71 | |
72 | 72 | /** |
@@ -74,57 +74,57 @@ discard block |
||
74 | 74 | */ |
75 | 75 | class SmartPluginHandler |
76 | 76 | { |
77 | - public $pluginPatterns = false; |
|
78 | - |
|
79 | - /** |
|
80 | - * @param $dirname |
|
81 | - * @return bool|SmartPlugin |
|
82 | - */ |
|
83 | - public function getPlugin($dirname) |
|
84 | - { |
|
85 | - $pluginName = SMARTOBJECT_ROOT_PATH . 'plugins/' . $dirname . '.php'; |
|
86 | - if (file_exists($pluginName)) { |
|
87 | - require_once $pluginName; |
|
88 | - $function = 'smartobject_plugin_' . $dirname; |
|
89 | - if (function_exists($function)) { |
|
90 | - $array = $function(); |
|
91 | - $ret = new SmartPlugin($array); |
|
92 | - |
|
93 | - return $ret; |
|
94 | - } |
|
95 | - } |
|
96 | - |
|
97 | - return false; |
|
98 | - } |
|
99 | - |
|
100 | - /** |
|
101 | - * @return array |
|
102 | - */ |
|
103 | - public function getPluginsArray() |
|
104 | - { |
|
105 | - require_once XOOPS_ROOT_PATH . '/class/xoopslists.php'; |
|
106 | - |
|
107 | - $moduleHandler = xoops_getHandler('module'); |
|
108 | - $criteria = new CriteriaCompo(); |
|
109 | - $criteria->add(new Criteria('isactive', 1)); |
|
110 | - $tempModulesObj = $moduleHandler->getObjects($criteria); |
|
111 | - $modulesObj = array(); |
|
112 | - foreach ($tempModulesObj as $moduleObj) { |
|
113 | - $modulesObj[$moduleObj->getVar('dirname')] = $moduleObj; |
|
114 | - } |
|
115 | - |
|
116 | - $aFiles = XoopsLists::getFileListAsArray(SMARTOBJECT_ROOT_PATH . 'plugins/'); |
|
117 | - $ret = array(); |
|
118 | - foreach ($aFiles as $file) { |
|
119 | - if (substr($file, strlen($file) - 4, 4) === '.php') { |
|
120 | - $pluginName = str_replace('.php', '', $file); |
|
121 | - $module_xoops_version_file = XOOPS_ROOT_PATH . "/modules/$pluginName/xoops_version.php"; |
|
122 | - if (file_exists($module_xoops_version_file) && isset($modulesObj[$pluginName])) { |
|
123 | - $ret[$pluginName] = $modulesObj[$pluginName]->getVar('name'); |
|
124 | - } |
|
125 | - } |
|
126 | - } |
|
127 | - |
|
128 | - return $ret; |
|
129 | - } |
|
77 | + public $pluginPatterns = false; |
|
78 | + |
|
79 | + /** |
|
80 | + * @param $dirname |
|
81 | + * @return bool|SmartPlugin |
|
82 | + */ |
|
83 | + public function getPlugin($dirname) |
|
84 | + { |
|
85 | + $pluginName = SMARTOBJECT_ROOT_PATH . 'plugins/' . $dirname . '.php'; |
|
86 | + if (file_exists($pluginName)) { |
|
87 | + require_once $pluginName; |
|
88 | + $function = 'smartobject_plugin_' . $dirname; |
|
89 | + if (function_exists($function)) { |
|
90 | + $array = $function(); |
|
91 | + $ret = new SmartPlugin($array); |
|
92 | + |
|
93 | + return $ret; |
|
94 | + } |
|
95 | + } |
|
96 | + |
|
97 | + return false; |
|
98 | + } |
|
99 | + |
|
100 | + /** |
|
101 | + * @return array |
|
102 | + */ |
|
103 | + public function getPluginsArray() |
|
104 | + { |
|
105 | + require_once XOOPS_ROOT_PATH . '/class/xoopslists.php'; |
|
106 | + |
|
107 | + $moduleHandler = xoops_getHandler('module'); |
|
108 | + $criteria = new CriteriaCompo(); |
|
109 | + $criteria->add(new Criteria('isactive', 1)); |
|
110 | + $tempModulesObj = $moduleHandler->getObjects($criteria); |
|
111 | + $modulesObj = array(); |
|
112 | + foreach ($tempModulesObj as $moduleObj) { |
|
113 | + $modulesObj[$moduleObj->getVar('dirname')] = $moduleObj; |
|
114 | + } |
|
115 | + |
|
116 | + $aFiles = XoopsLists::getFileListAsArray(SMARTOBJECT_ROOT_PATH . 'plugins/'); |
|
117 | + $ret = array(); |
|
118 | + foreach ($aFiles as $file) { |
|
119 | + if (substr($file, strlen($file) - 4, 4) === '.php') { |
|
120 | + $pluginName = str_replace('.php', '', $file); |
|
121 | + $module_xoops_version_file = XOOPS_ROOT_PATH . "/modules/$pluginName/xoops_version.php"; |
|
122 | + if (file_exists($module_xoops_version_file) && isset($modulesObj[$pluginName])) { |
|
123 | + $ret[$pluginName] = $modulesObj[$pluginName]->getVar('name'); |
|
124 | + } |
|
125 | + } |
|
126 | + } |
|
127 | + |
|
128 | + return $ret; |
|
129 | + } |
|
130 | 130 | } |
@@ -50,7 +50,7 @@ discard block |
||
50 | 50 | $ret = false; |
51 | 51 | foreach ($this->_infoArray['items'] as $k => $v) { |
52 | 52 | $search_str = str_replace('%u', '', $v['url']); |
53 | - if (strpos($_SERVER['PHP_SELF'] . '?' . $_SERVER['QUERY_STRING'], $search_str) > 0) { |
|
53 | + if (strpos($_SERVER['PHP_SELF'].'?'.$_SERVER['QUERY_STRING'], $search_str) > 0) { |
|
54 | 54 | $ret = $k; |
55 | 55 | break; |
56 | 56 | } |
@@ -82,10 +82,10 @@ discard block |
||
82 | 82 | */ |
83 | 83 | public function getPlugin($dirname) |
84 | 84 | { |
85 | - $pluginName = SMARTOBJECT_ROOT_PATH . 'plugins/' . $dirname . '.php'; |
|
85 | + $pluginName = SMARTOBJECT_ROOT_PATH.'plugins/'.$dirname.'.php'; |
|
86 | 86 | if (file_exists($pluginName)) { |
87 | 87 | require_once $pluginName; |
88 | - $function = 'smartobject_plugin_' . $dirname; |
|
88 | + $function = 'smartobject_plugin_'.$dirname; |
|
89 | 89 | if (function_exists($function)) { |
90 | 90 | $array = $function(); |
91 | 91 | $ret = new SmartPlugin($array); |
@@ -102,7 +102,7 @@ discard block |
||
102 | 102 | */ |
103 | 103 | public function getPluginsArray() |
104 | 104 | { |
105 | - require_once XOOPS_ROOT_PATH . '/class/xoopslists.php'; |
|
105 | + require_once XOOPS_ROOT_PATH.'/class/xoopslists.php'; |
|
106 | 106 | |
107 | 107 | $moduleHandler = xoops_getHandler('module'); |
108 | 108 | $criteria = new CriteriaCompo(); |
@@ -113,12 +113,12 @@ discard block |
||
113 | 113 | $modulesObj[$moduleObj->getVar('dirname')] = $moduleObj; |
114 | 114 | } |
115 | 115 | |
116 | - $aFiles = XoopsLists::getFileListAsArray(SMARTOBJECT_ROOT_PATH . 'plugins/'); |
|
116 | + $aFiles = XoopsLists::getFileListAsArray(SMARTOBJECT_ROOT_PATH.'plugins/'); |
|
117 | 117 | $ret = array(); |
118 | 118 | foreach ($aFiles as $file) { |
119 | 119 | if (substr($file, strlen($file) - 4, 4) === '.php') { |
120 | 120 | $pluginName = str_replace('.php', '', $file); |
121 | - $module_xoops_version_file = XOOPS_ROOT_PATH . "/modules/$pluginName/xoops_version.php"; |
|
121 | + $module_xoops_version_file = XOOPS_ROOT_PATH."/modules/$pluginName/xoops_version.php"; |
|
122 | 122 | if (file_exists($module_xoops_version_file) && isset($modulesObj[$pluginName])) { |
123 | 123 | $ret[$pluginName] = $modulesObj[$pluginName]->getVar('name'); |
124 | 124 | } |
@@ -29,8 +29,8 @@ discard block |
||
29 | 29 | |
30 | 30 | // defined('XOOPS_ROOT_PATH') || exit('XOOPS root path not defined'); |
31 | 31 | |
32 | -require_once XOOPS_ROOT_PATH . '/modules/smartobject/class/smartobject.php'; |
|
33 | -require_once XOOPS_ROOT_PATH . '/modules/smartobject/class/smartplugins.php'; |
|
32 | +require_once XOOPS_ROOT_PATH.'/modules/smartobject/class/smartobject.php'; |
|
33 | +require_once XOOPS_ROOT_PATH.'/modules/smartobject/class/smartplugins.php'; |
|
34 | 34 | |
35 | 35 | /** |
36 | 36 | * Class SmartobjectRating |
@@ -124,14 +124,14 @@ discard block |
||
124 | 124 | */ |
125 | 125 | public function getItemValue() |
126 | 126 | { |
127 | - $moduleUrl = XOOPS_URL . '/modules/' . $this->getVar('dirname', 'n') . '/'; |
|
127 | + $moduleUrl = XOOPS_URL.'/modules/'.$this->getVar('dirname', 'n').'/'; |
|
128 | 128 | $plugin = $this->getModulePlugin(); |
129 | 129 | $pluginItemInfo = $plugin->getItemInfo($this->getVar('item')); |
130 | 130 | if (!$pluginItemInfo) { |
131 | 131 | return ''; |
132 | 132 | } |
133 | 133 | $itemPath = sprintf($pluginItemInfo['url'], $this->getVar('itemid')); |
134 | - $ret = '<a href="' . $moduleUrl . $itemPath . '">' . $pluginItemInfo['caption'] . '</a>'; |
|
134 | + $ret = '<a href="'.$moduleUrl.$itemPath.'">'.$pluginItemInfo['caption'].'</a>'; |
|
135 | 135 | |
136 | 136 | return $ret; |
137 | 137 | } |
@@ -174,7 +174,7 @@ discard block |
||
174 | 174 | public function __construct(XoopsDatabase $db) |
175 | 175 | { |
176 | 176 | parent::__construct($db, 'rating', 'ratingid', 'rate', '', 'smartobject'); |
177 | - $this->generalSQL = 'SELECT * FROM ' . $this->table . ' AS ' . $this->_itemname . ' INNER JOIN ' . $this->db->prefix('users') . ' AS user ON ' . $this->_itemname . '.uid=user.uid'; |
|
177 | + $this->generalSQL = 'SELECT * FROM '.$this->table.' AS '.$this->_itemname.' INNER JOIN '.$this->db->prefix('users').' AS user ON '.$this->_itemname.'.uid=user.uid'; |
|
178 | 178 | |
179 | 179 | $this->_rateOptions[1] = 1; |
180 | 180 | $this->_rateOptions[2] = 2; |
@@ -217,7 +217,7 @@ discard block |
||
217 | 217 | */ |
218 | 218 | public function getRatingAverageByItemId($itemid, $dirname, $item) |
219 | 219 | { |
220 | - $sql = 'SELECT AVG(rate), COUNT(ratingid) FROM ' . $this->table . " WHERE itemid=$itemid AND dirname='$dirname' AND item='$item' GROUP BY itemid"; |
|
220 | + $sql = 'SELECT AVG(rate), COUNT(ratingid) FROM '.$this->table." WHERE itemid=$itemid AND dirname='$dirname' AND item='$item' GROUP BY itemid"; |
|
221 | 221 | $result = $this->db->query($sql); |
222 | 222 | if (!$result) { |
223 | 223 | return 0; |
@@ -10,66 +10,66 @@ |
||
10 | 10 | |
11 | 11 | class SmartAddTo |
12 | 12 | { |
13 | - public $_layout; |
|
14 | - public $_method; |
|
13 | + public $_layout; |
|
14 | + public $_method; |
|
15 | 15 | |
16 | - /** |
|
17 | - * Constructor of SmartAddTo |
|
18 | - * |
|
19 | - * @param int $layout 0=Horizontal 1 row, 1=Horizontal 2 rows, 2=Vertical with icons, 3=Vertical no icons |
|
20 | - * @param int $method 0=directpage, 1=popup |
|
21 | - */ |
|
22 | - public function __construct($layout = 0, $method = 1) |
|
23 | - { |
|
24 | - $layout = (int)$layout; |
|
25 | - if ($layout < 0 || $layout > 3) { |
|
26 | - $layout = 0; |
|
27 | - } |
|
28 | - $this->_layout = $layout; |
|
16 | + /** |
|
17 | + * Constructor of SmartAddTo |
|
18 | + * |
|
19 | + * @param int $layout 0=Horizontal 1 row, 1=Horizontal 2 rows, 2=Vertical with icons, 3=Vertical no icons |
|
20 | + * @param int $method 0=directpage, 1=popup |
|
21 | + */ |
|
22 | + public function __construct($layout = 0, $method = 1) |
|
23 | + { |
|
24 | + $layout = (int)$layout; |
|
25 | + if ($layout < 0 || $layout > 3) { |
|
26 | + $layout = 0; |
|
27 | + } |
|
28 | + $this->_layout = $layout; |
|
29 | 29 | |
30 | - $method = (int)$method; |
|
31 | - if ($method < 0 || $method > 1) { |
|
32 | - $method = 1; |
|
33 | - } |
|
34 | - $this->_method = $method; |
|
35 | - } |
|
30 | + $method = (int)$method; |
|
31 | + if ($method < 0 || $method > 1) { |
|
32 | + $method = 1; |
|
33 | + } |
|
34 | + $this->_method = $method; |
|
35 | + } |
|
36 | 36 | |
37 | - /** |
|
38 | - * @param bool $fetchOnly |
|
39 | - * @return mixed|string|void |
|
40 | - */ |
|
41 | - public function render($fetchOnly = false) |
|
42 | - { |
|
43 | - global $xoTheme, $xoopsTpl; |
|
37 | + /** |
|
38 | + * @param bool $fetchOnly |
|
39 | + * @return mixed|string|void |
|
40 | + */ |
|
41 | + public function render($fetchOnly = false) |
|
42 | + { |
|
43 | + global $xoTheme, $xoopsTpl; |
|
44 | 44 | |
45 | - $xoTheme->addStylesheet(SMARTOBJECT_URL . 'include/addto/addto.css'); |
|
45 | + $xoTheme->addStylesheet(SMARTOBJECT_URL . 'include/addto/addto.css'); |
|
46 | 46 | |
47 | - $xoopsTpl->assign('smartobject_addto_method', $this->_method); |
|
48 | - $xoopsTpl->assign('smartobject_addto_layout', $this->_layout); |
|
47 | + $xoopsTpl->assign('smartobject_addto_method', $this->_method); |
|
48 | + $xoopsTpl->assign('smartobject_addto_layout', $this->_layout); |
|
49 | 49 | |
50 | - $xoopsTpl->assign('smartobject_addto_url', SMARTOBJECT_URL . 'include/addto/'); |
|
50 | + $xoopsTpl->assign('smartobject_addto_url', SMARTOBJECT_URL . 'include/addto/'); |
|
51 | 51 | |
52 | - if ($fetchOnly) { |
|
53 | - return $xoopsTpl->fetch('db:smartobject_addto.tpl'); |
|
54 | - } else { |
|
55 | - $xoopsTpl->display('db:smartobject_addto.tpl'); |
|
56 | - } |
|
57 | - } |
|
52 | + if ($fetchOnly) { |
|
53 | + return $xoopsTpl->fetch('db:smartobject_addto.tpl'); |
|
54 | + } else { |
|
55 | + $xoopsTpl->display('db:smartobject_addto.tpl'); |
|
56 | + } |
|
57 | + } |
|
58 | 58 | |
59 | - /** |
|
60 | - * @return array |
|
61 | - */ |
|
62 | - public function renderForBlock() |
|
63 | - { |
|
64 | - global $xoTheme; |
|
59 | + /** |
|
60 | + * @return array |
|
61 | + */ |
|
62 | + public function renderForBlock() |
|
63 | + { |
|
64 | + global $xoTheme; |
|
65 | 65 | |
66 | - $xoTheme->addStylesheet(SMARTOBJECT_URL . 'include/addto/addto.css'); |
|
66 | + $xoTheme->addStylesheet(SMARTOBJECT_URL . 'include/addto/addto.css'); |
|
67 | 67 | |
68 | - $block = array(); |
|
69 | - $block['smartobject_addto_method'] = $this->_method; |
|
70 | - $block['smartobject_addto_layout'] = $this->_layout; |
|
71 | - $block['smartobject_addto_url'] = SMARTOBJECT_URL . 'include/addto/'; |
|
68 | + $block = array(); |
|
69 | + $block['smartobject_addto_method'] = $this->_method; |
|
70 | + $block['smartobject_addto_layout'] = $this->_layout; |
|
71 | + $block['smartobject_addto_url'] = SMARTOBJECT_URL . 'include/addto/'; |
|
72 | 72 | |
73 | - return $block; |
|
74 | - } |
|
73 | + return $block; |
|
74 | + } |
|
75 | 75 | } |
@@ -5,149 +5,149 @@ |
||
5 | 5 | */ |
6 | 6 | class SmartObjectUtility extends XoopsObject |
7 | 7 | { |
8 | - /** |
|
9 | - * Function responsible for checking if a directory exists, we can also write in and create an index.html file |
|
10 | - * |
|
11 | - * @param string $folder The full path of the directory to check |
|
12 | - * |
|
13 | - * @return void |
|
14 | - */ |
|
15 | - public static function createFolder($folder) |
|
16 | - { |
|
17 | - // try { |
|
18 | - // if (!mkdir($folder) && !is_dir($folder)) { |
|
19 | - // throw new \RuntimeException(sprintf('Unable to create the %s directory', $folder)); |
|
20 | - // } else { |
|
21 | - // file_put_contents($folder . '/index.html', '<script>history.go(-1);</script>'); |
|
22 | - // } |
|
23 | - // } |
|
24 | - // catch (Exception $e) { |
|
25 | - // echo 'Caught exception: ', $e->getMessage(), "\n", '<br>'; |
|
26 | - // } |
|
27 | - try { |
|
28 | - if (!file_exists($folder)) { |
|
29 | - if (!mkdir($folder) && !is_dir($folder)) { |
|
30 | - throw new \RuntimeException(sprintf('Unable to create the %s directory', $folder)); |
|
31 | - } else { |
|
32 | - file_put_contents($folder . '/index.html', '<script>history.go(-1);</script>'); |
|
33 | - } |
|
34 | - } |
|
35 | - } catch (Exception $e) { |
|
36 | - echo 'Caught exception: ', $e->getMessage(), "\n", '<br>'; |
|
37 | - } |
|
38 | - } |
|
8 | + /** |
|
9 | + * Function responsible for checking if a directory exists, we can also write in and create an index.html file |
|
10 | + * |
|
11 | + * @param string $folder The full path of the directory to check |
|
12 | + * |
|
13 | + * @return void |
|
14 | + */ |
|
15 | + public static function createFolder($folder) |
|
16 | + { |
|
17 | + // try { |
|
18 | + // if (!mkdir($folder) && !is_dir($folder)) { |
|
19 | + // throw new \RuntimeException(sprintf('Unable to create the %s directory', $folder)); |
|
20 | + // } else { |
|
21 | + // file_put_contents($folder . '/index.html', '<script>history.go(-1);</script>'); |
|
22 | + // } |
|
23 | + // } |
|
24 | + // catch (Exception $e) { |
|
25 | + // echo 'Caught exception: ', $e->getMessage(), "\n", '<br>'; |
|
26 | + // } |
|
27 | + try { |
|
28 | + if (!file_exists($folder)) { |
|
29 | + if (!mkdir($folder) && !is_dir($folder)) { |
|
30 | + throw new \RuntimeException(sprintf('Unable to create the %s directory', $folder)); |
|
31 | + } else { |
|
32 | + file_put_contents($folder . '/index.html', '<script>history.go(-1);</script>'); |
|
33 | + } |
|
34 | + } |
|
35 | + } catch (Exception $e) { |
|
36 | + echo 'Caught exception: ', $e->getMessage(), "\n", '<br>'; |
|
37 | + } |
|
38 | + } |
|
39 | 39 | |
40 | - /** |
|
41 | - * @param $file |
|
42 | - * @param $folder |
|
43 | - * @return bool |
|
44 | - */ |
|
45 | - public static function copyFile($file, $folder) |
|
46 | - { |
|
47 | - return copy($file, $folder); |
|
48 | - // try { |
|
49 | - // if (!is_dir($folder)) { |
|
50 | - // throw new \RuntimeException(sprintf('Unable to copy file as: %s ', $folder)); |
|
51 | - // } else { |
|
52 | - // return copy($file, $folder); |
|
53 | - // } |
|
54 | - // } catch (Exception $e) { |
|
55 | - // echo 'Caught exception: ', $e->getMessage(), "\n", "<br>"; |
|
56 | - // } |
|
57 | - // return false; |
|
58 | - } |
|
40 | + /** |
|
41 | + * @param $file |
|
42 | + * @param $folder |
|
43 | + * @return bool |
|
44 | + */ |
|
45 | + public static function copyFile($file, $folder) |
|
46 | + { |
|
47 | + return copy($file, $folder); |
|
48 | + // try { |
|
49 | + // if (!is_dir($folder)) { |
|
50 | + // throw new \RuntimeException(sprintf('Unable to copy file as: %s ', $folder)); |
|
51 | + // } else { |
|
52 | + // return copy($file, $folder); |
|
53 | + // } |
|
54 | + // } catch (Exception $e) { |
|
55 | + // echo 'Caught exception: ', $e->getMessage(), "\n", "<br>"; |
|
56 | + // } |
|
57 | + // return false; |
|
58 | + } |
|
59 | 59 | |
60 | - /** |
|
61 | - * @param $src |
|
62 | - * @param $dst |
|
63 | - */ |
|
64 | - public static function recurseCopy($src, $dst) |
|
65 | - { |
|
66 | - $dir = opendir($src); |
|
67 | - // @mkdir($dst); |
|
68 | - while (false !== ($file = readdir($dir))) { |
|
69 | - if (($file !== '.') && ($file !== '..')) { |
|
70 | - if (is_dir($src . '/' . $file)) { |
|
71 | - self::recurseCopy($src . '/' . $file, $dst . '/' . $file); |
|
72 | - } else { |
|
73 | - copy($src . '/' . $file, $dst . '/' . $file); |
|
74 | - } |
|
75 | - } |
|
76 | - } |
|
77 | - closedir($dir); |
|
78 | - } |
|
60 | + /** |
|
61 | + * @param $src |
|
62 | + * @param $dst |
|
63 | + */ |
|
64 | + public static function recurseCopy($src, $dst) |
|
65 | + { |
|
66 | + $dir = opendir($src); |
|
67 | + // @mkdir($dst); |
|
68 | + while (false !== ($file = readdir($dir))) { |
|
69 | + if (($file !== '.') && ($file !== '..')) { |
|
70 | + if (is_dir($src . '/' . $file)) { |
|
71 | + self::recurseCopy($src . '/' . $file, $dst . '/' . $file); |
|
72 | + } else { |
|
73 | + copy($src . '/' . $file, $dst . '/' . $file); |
|
74 | + } |
|
75 | + } |
|
76 | + } |
|
77 | + closedir($dir); |
|
78 | + } |
|
79 | 79 | |
80 | - /** |
|
81 | - * |
|
82 | - * Verifies XOOPS version meets minimum requirements for this module |
|
83 | - * @static |
|
84 | - * @param XoopsModule $module |
|
85 | - * |
|
86 | - * @param null|string $requiredVer |
|
87 | - * @return bool true if meets requirements, false if not |
|
88 | - */ |
|
89 | - public static function checkVerXoops(XoopsModule $module = null, $requiredVer = null) |
|
90 | - { |
|
91 | - $moduleDirName = basename(dirname(__DIR__)); |
|
92 | - if (null === $module) { |
|
93 | - $module = XoopsModule::getByDirname($moduleDirName); |
|
94 | - } |
|
95 | - xoops_loadLanguage('admin', $moduleDirName); |
|
96 | - //check for minimum XOOPS version |
|
97 | - $currentVer = substr(XOOPS_VERSION, 6); // get the numeric part of string |
|
98 | - $currArray = explode('.', $currentVer); |
|
99 | - if (null === $requiredVer) { |
|
100 | - $requiredVer = '' . $module->getInfo('min_xoops'); //making sure it's a string |
|
101 | - } |
|
102 | - $reqArray = explode('.', $requiredVer); |
|
103 | - $success = true; |
|
104 | - foreach ($reqArray as $k => $v) { |
|
105 | - if (isset($currArray[$k])) { |
|
106 | - if ($currArray[$k] > $v) { |
|
107 | - break; |
|
108 | - } elseif ($currArray[$k] == $v) { |
|
109 | - continue; |
|
110 | - } else { |
|
111 | - $success = false; |
|
112 | - break; |
|
113 | - } |
|
114 | - } else { |
|
115 | - if ((int)$v > 0) { // handles versions like x.x.x.0_RC2 |
|
116 | - $success = false; |
|
117 | - break; |
|
118 | - } |
|
119 | - } |
|
120 | - } |
|
80 | + /** |
|
81 | + * |
|
82 | + * Verifies XOOPS version meets minimum requirements for this module |
|
83 | + * @static |
|
84 | + * @param XoopsModule $module |
|
85 | + * |
|
86 | + * @param null|string $requiredVer |
|
87 | + * @return bool true if meets requirements, false if not |
|
88 | + */ |
|
89 | + public static function checkVerXoops(XoopsModule $module = null, $requiredVer = null) |
|
90 | + { |
|
91 | + $moduleDirName = basename(dirname(__DIR__)); |
|
92 | + if (null === $module) { |
|
93 | + $module = XoopsModule::getByDirname($moduleDirName); |
|
94 | + } |
|
95 | + xoops_loadLanguage('admin', $moduleDirName); |
|
96 | + //check for minimum XOOPS version |
|
97 | + $currentVer = substr(XOOPS_VERSION, 6); // get the numeric part of string |
|
98 | + $currArray = explode('.', $currentVer); |
|
99 | + if (null === $requiredVer) { |
|
100 | + $requiredVer = '' . $module->getInfo('min_xoops'); //making sure it's a string |
|
101 | + } |
|
102 | + $reqArray = explode('.', $requiredVer); |
|
103 | + $success = true; |
|
104 | + foreach ($reqArray as $k => $v) { |
|
105 | + if (isset($currArray[$k])) { |
|
106 | + if ($currArray[$k] > $v) { |
|
107 | + break; |
|
108 | + } elseif ($currArray[$k] == $v) { |
|
109 | + continue; |
|
110 | + } else { |
|
111 | + $success = false; |
|
112 | + break; |
|
113 | + } |
|
114 | + } else { |
|
115 | + if ((int)$v > 0) { // handles versions like x.x.x.0_RC2 |
|
116 | + $success = false; |
|
117 | + break; |
|
118 | + } |
|
119 | + } |
|
120 | + } |
|
121 | 121 | |
122 | - if (!$success) { |
|
123 | - $module->setErrors(sprintf(_AM_XXXXX_ERROR_BAD_XOOPS, $requiredVer, $currentVer)); |
|
124 | - } |
|
122 | + if (!$success) { |
|
123 | + $module->setErrors(sprintf(_AM_XXXXX_ERROR_BAD_XOOPS, $requiredVer, $currentVer)); |
|
124 | + } |
|
125 | 125 | |
126 | - return $success; |
|
127 | - } |
|
126 | + return $success; |
|
127 | + } |
|
128 | 128 | |
129 | - /** |
|
130 | - * |
|
131 | - * Verifies PHP version meets minimum requirements for this module |
|
132 | - * @static |
|
133 | - * @param XoopsModule $module |
|
134 | - * |
|
135 | - * @return bool true if meets requirements, false if not |
|
136 | - */ |
|
137 | - public static function checkVerPhp(XoopsModule $module) |
|
138 | - { |
|
139 | - xoops_loadLanguage('admin', $module->dirname()); |
|
140 | - // check for minimum PHP version |
|
141 | - $success = true; |
|
142 | - $verNum = PHP_VERSION; |
|
143 | - $reqVer = $module->getInfo('min_php'); |
|
144 | - if (false !== $reqVer && '' !== $reqVer) { |
|
145 | - if (version_compare($verNum, $reqVer, '<')) { |
|
146 | - $module->setErrors(sprintf(_AM_XXXXX_ERROR_BAD_PHP, $reqVer, $verNum)); |
|
147 | - $success = false; |
|
148 | - } |
|
149 | - } |
|
129 | + /** |
|
130 | + * |
|
131 | + * Verifies PHP version meets minimum requirements for this module |
|
132 | + * @static |
|
133 | + * @param XoopsModule $module |
|
134 | + * |
|
135 | + * @return bool true if meets requirements, false if not |
|
136 | + */ |
|
137 | + public static function checkVerPhp(XoopsModule $module) |
|
138 | + { |
|
139 | + xoops_loadLanguage('admin', $module->dirname()); |
|
140 | + // check for minimum PHP version |
|
141 | + $success = true; |
|
142 | + $verNum = PHP_VERSION; |
|
143 | + $reqVer = $module->getInfo('min_php'); |
|
144 | + if (false !== $reqVer && '' !== $reqVer) { |
|
145 | + if (version_compare($verNum, $reqVer, '<')) { |
|
146 | + $module->setErrors(sprintf(_AM_XXXXX_ERROR_BAD_PHP, $reqVer, $verNum)); |
|
147 | + $success = false; |
|
148 | + } |
|
149 | + } |
|
150 | 150 | |
151 | - return $success; |
|
152 | - } |
|
151 | + return $success; |
|
152 | + } |
|
153 | 153 | } |
@@ -29,7 +29,7 @@ discard block |
||
29 | 29 | if (!mkdir($folder) && !is_dir($folder)) { |
30 | 30 | throw new \RuntimeException(sprintf('Unable to create the %s directory', $folder)); |
31 | 31 | } else { |
32 | - file_put_contents($folder . '/index.html', '<script>history.go(-1);</script>'); |
|
32 | + file_put_contents($folder.'/index.html', '<script>history.go(-1);</script>'); |
|
33 | 33 | } |
34 | 34 | } |
35 | 35 | } catch (Exception $e) { |
@@ -67,10 +67,10 @@ discard block |
||
67 | 67 | // @mkdir($dst); |
68 | 68 | while (false !== ($file = readdir($dir))) { |
69 | 69 | if (($file !== '.') && ($file !== '..')) { |
70 | - if (is_dir($src . '/' . $file)) { |
|
71 | - self::recurseCopy($src . '/' . $file, $dst . '/' . $file); |
|
70 | + if (is_dir($src.'/'.$file)) { |
|
71 | + self::recurseCopy($src.'/'.$file, $dst.'/'.$file); |
|
72 | 72 | } else { |
73 | - copy($src . '/' . $file, $dst . '/' . $file); |
|
73 | + copy($src.'/'.$file, $dst.'/'.$file); |
|
74 | 74 | } |
75 | 75 | } |
76 | 76 | } |
@@ -97,7 +97,7 @@ discard block |
||
97 | 97 | $currentVer = substr(XOOPS_VERSION, 6); // get the numeric part of string |
98 | 98 | $currArray = explode('.', $currentVer); |
99 | 99 | if (null === $requiredVer) { |
100 | - $requiredVer = '' . $module->getInfo('min_xoops'); //making sure it's a string |
|
100 | + $requiredVer = ''.$module->getInfo('min_xoops'); //making sure it's a string |
|
101 | 101 | } |
102 | 102 | $reqArray = explode('.', $requiredVer); |
103 | 103 | $success = true; |
@@ -112,7 +112,7 @@ discard block |
||
112 | 112 | break; |
113 | 113 | } |
114 | 114 | } else { |
115 | - if ((int)$v > 0) { // handles versions like x.x.x.0_RC2 |
|
115 | + if ((int) $v > 0) { // handles versions like x.x.x.0_RC2 |
|
116 | 116 | $success = false; |
117 | 117 | break; |
118 | 118 | } |