This project does not seem to handle request data directly as such no vulnerable execution paths were found.
include
, or for example
via PHP's auto-loading mechanism.
1 | <?php declare(strict_types=1); |
||
2 | |||
3 | namespace XoopsModules\Suico; |
||
4 | |||
5 | /* |
||
6 | You may not change or alter any portion of this comment or credits |
||
7 | of supporting developers from this source code or any supporting source code |
||
8 | which is considered copyrighted (c) material of the original comment or credit authors. |
||
9 | |||
10 | This program is distributed in the hope that it will be useful, |
||
11 | but WITHOUT ANY WARRANTY; without even the implied warranty of |
||
12 | MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. |
||
13 | */ |
||
14 | |||
15 | use CriteriaElement; |
||
16 | use Xmf\Request; |
||
17 | use XoopsDatabase; |
||
18 | use XoopsFormButton; |
||
19 | use XoopsFormFile; |
||
20 | use XoopsFormHidden; |
||
21 | use XoopsFormLabel; |
||
22 | use XoopsFormText; |
||
23 | use XoopsMediaUploader; |
||
24 | use XoopsObject; |
||
25 | use XoopsPersistableObjectHandler; |
||
26 | use XoopsThemeForm; |
||
27 | |||
28 | /** |
||
29 | * @category Module |
||
30 | * @copyright {@link https://xoops.org/ XOOPS Project} |
||
31 | * @license GNU GPL 2.0 or later (https://www.gnu.org/licenses/gpl-2.0.html) |
||
32 | * @author Marcello Brandão aka Suico, Mamba, LioMJ <https://xoops.org> |
||
33 | */ |
||
34 | |||
35 | /** |
||
36 | * Includes of form objects and uploader |
||
37 | */ |
||
38 | require_once XOOPS_ROOT_PATH . '/class/uploader.php'; |
||
39 | require_once XOOPS_ROOT_PATH . '/kernel/object.php'; |
||
40 | require_once XOOPS_ROOT_PATH . '/class/xoopsformloader.php'; |
||
41 | |||
42 | /** |
||
43 | * suico_imageshandler class. |
||
44 | * This class provides simple mechanism for Image object and generate forms for inclusion etc |
||
45 | */ |
||
46 | class ImageHandler extends XoopsPersistableObjectHandler |
||
47 | { |
||
48 | public Helper $helper; |
||
49 | public $isAdmin; |
||
50 | |||
51 | /** |
||
52 | * Constructor |
||
53 | * @param \XoopsDatabase|null $xoopsDatabase |
||
54 | * @param \XoopsModules\Suico\Helper|null $helper |
||
55 | */ |
||
56 | public function __construct( |
||
57 | ?XoopsDatabase $xoopsDatabase = null, |
||
58 | $helper = null |
||
59 | ) { |
||
60 | /** @var \XoopsModules\Suico\Helper $this- >helper */ |
||
61 | if (null === $helper) { |
||
62 | $this->helper = Helper::getInstance(); |
||
63 | } else { |
||
64 | $this->helper = $helper; |
||
65 | } |
||
66 | $this->isAdmin = $this->helper->isUserAdmin(); |
||
67 | parent::__construct($xoopsDatabase, 'suico_images', Image::class, 'image_id', 'title', 'caption'); |
||
68 | } |
||
69 | |||
70 | /** |
||
71 | * create a new Groups |
||
72 | * |
||
73 | * @param bool $isNew flag the new objects as "new"? |
||
74 | * @return \XoopsObject Groups |
||
75 | */ |
||
76 | public function create( |
||
77 | $isNew = true |
||
78 | ) { |
||
79 | $obj = parent::create($isNew); |
||
80 | // if ($isNew) { |
||
81 | // $obj->setDefaultPermissions(); |
||
82 | // } |
||
83 | if ($isNew) { |
||
84 | $obj->setNew(); |
||
85 | } else { |
||
86 | $obj->unsetNew(); |
||
87 | } |
||
88 | $obj->helper = $this->helper; |
||
89 | |||
90 | return $obj; |
||
91 | } |
||
92 | |||
93 | /** |
||
94 | * retrieve a Image |
||
95 | * |
||
96 | * @param int|null $id of the Image |
||
97 | * @param null $fields |
||
98 | * @return false|\XoopsModules\Suico\Image reference to the {@link Image} object, FALSE if failed |
||
99 | */ |
||
100 | public function get2( |
||
101 | $id = null, |
||
102 | $fields = null |
||
103 | ) { |
||
104 | $sql = 'SELECT * FROM ' . $this->db->prefix('suico_images') . ' WHERE image_id=' . $id; |
||
105 | if (!$result = $this->db->query($sql)) { |
||
106 | return false; |
||
107 | } |
||
108 | $numrows = $this->db->getRowsNum($result); |
||
109 | if (1 === $numrows) { |
||
110 | $image = new Image(); |
||
111 | $image->assignVars($this->db->fetchArray($result)); |
||
112 | |||
113 | return $image; |
||
114 | } |
||
115 | |||
116 | return false; |
||
117 | } |
||
118 | |||
119 | /** |
||
120 | * insert a new Image in the database |
||
121 | * |
||
122 | * @param \XoopsObject $object reference to the {@link Image} object |
||
123 | * @param bool $force |
||
124 | * @return bool FALSE if failed, TRUE if already present and unchanged or successful |
||
125 | */ |
||
126 | public function insert2( |
||
127 | XoopsObject $object, |
||
128 | $force = false |
||
129 | ) { |
||
130 | global $xoopsConfig; |
||
131 | if (!$object instanceof Image) { |
||
132 | return false; |
||
133 | } |
||
134 | if (!$object->isDirty()) { |
||
135 | return true; |
||
136 | } |
||
137 | if (!$object->cleanVars()) { |
||
138 | return false; |
||
139 | } |
||
140 | $image_id = ''; |
||
141 | foreach ($object->cleanVars as $k => $v) { |
||
142 | ${$k} = $v; |
||
143 | } |
||
144 | // $now = 'date_add(now(), interval ' . $xoopsConfig['server_TZ'] . ' hour)'; |
||
145 | if ($object->isNew()) { |
||
146 | // ajout/modification d'un Image |
||
147 | $object = new Image(); |
||
148 | $format = 'INSERT INTO %s (image_id, title, caption, date_created, date_updated, uid_owner, filename, private)'; |
||
149 | $format .= 'VALUES (%u, %s, %s, %s, %s, %s, %s, 0)'; |
||
150 | $sql = \sprintf( |
||
151 | $format, |
||
152 | $this->db->prefix('suico_images'), |
||
153 | $image_id, |
||
154 | $this->db->quoteString($title), |
||
0 ignored issues
–
show
Comprehensibility
Best Practice
introduced
by
![]() |
|||
155 | $this->db->quoteString($caption), |
||
0 ignored issues
–
show
Comprehensibility
Best Practice
introduced
by
|
|||
156 | \time(), //$now, |
||
157 | \time(), //$now, |
||
158 | $this->db->quoteString($uid_owner), |
||
0 ignored issues
–
show
Comprehensibility
Best Practice
introduced
by
|
|||
159 | $this->db->quoteString($filename) |
||
0 ignored issues
–
show
Comprehensibility
Best Practice
introduced
by
|
|||
160 | ); |
||
161 | $force = true; |
||
162 | } else { |
||
163 | $format = 'UPDATE %s SET '; |
||
164 | $format .= 'image_id=%u, title=%s, caption=%s, date_created=%s, date_updated=%s, uid_owner=%s, filename=%s, private=%s'; |
||
165 | $format .= ' WHERE image_id = %u'; |
||
166 | $sql = \sprintf( |
||
167 | $format, |
||
168 | $this->db->prefix('suico_images'), |
||
169 | $image_id, |
||
170 | $this->db->quoteString($title), |
||
171 | $this->db->quoteString($caption), |
||
172 | $object->getVar('date_created'), // $now, |
||
173 | $object->getVar('date_updated'), // $now, |
||
174 | $this->db->quoteString($uid_owner), |
||
175 | $this->db->quoteString($filename), |
||
176 | $this->db->quoteString($private), |
||
0 ignored issues
–
show
Comprehensibility
Best Practice
introduced
by
|
|||
177 | $image_id |
||
178 | ); |
||
179 | } |
||
180 | if ($force) { |
||
181 | $result = $this->db->queryF($sql); |
||
182 | } else { |
||
183 | $result = $this->db->query($sql); |
||
184 | } |
||
185 | if (!$result) { |
||
186 | return false; |
||
187 | } |
||
188 | if (empty($image_id)) { |
||
189 | $image_id = $this->db->getInsertId(); |
||
190 | } |
||
191 | $object->assignVar('image_id', $image_id); |
||
192 | |||
193 | return true; |
||
194 | } |
||
195 | |||
196 | /** |
||
197 | * delete a Image from the database |
||
198 | * |
||
199 | * @param \XoopsObject $object reference to the Image to delete |
||
200 | * @param bool $force |
||
201 | * @return bool FALSE if failed. |
||
202 | */ |
||
203 | public function delete( |
||
204 | XoopsObject $object, |
||
205 | $force = false |
||
206 | ) { |
||
207 | if (!$object instanceof Image) { |
||
208 | return false; |
||
209 | } |
||
210 | $sql = \sprintf( |
||
211 | 'DELETE FROM %s WHERE image_id = %u', |
||
212 | $this->db->prefix('suico_images'), |
||
213 | (int)$object->getVar('image_id') |
||
214 | ); |
||
215 | if ($force) { |
||
216 | $result = $this->db->queryF($sql); |
||
217 | } else { |
||
218 | $result = $this->db->query($sql); |
||
219 | } |
||
220 | if (!$result) { |
||
221 | return false; |
||
222 | } |
||
223 | |||
224 | return true; |
||
225 | } |
||
226 | |||
227 | /** |
||
228 | * retrieve suico_imagess from the database |
||
229 | * |
||
230 | * @param \CriteriaElement|\CriteriaCompo|null $criteria {@link \CriteriaElement} conditions to be met |
||
231 | * @param bool $id_as_key use the UID as key for the array? |
||
232 | * @param bool $as_object |
||
233 | * @return array array of {@link Image} objects |
||
234 | */ |
||
235 | public function &getObjects( |
||
236 | ?CriteriaElement $criteria = null, |
||
237 | $id_as_key = false, |
||
238 | $as_object = true |
||
239 | ) { |
||
240 | $ret = []; |
||
241 | $start = 0; |
||
242 | $limit = 0; |
||
243 | $sql = 'SELECT * FROM ' . $this->db->prefix('suico_images'); |
||
244 | if (isset($criteria) && is_subclass_of($criteria, 'CriteriaElement')) { |
||
245 | $sql .= ' ' . $criteria->renderWhere(); |
||
246 | if ('' !== $criteria->getSort()) { |
||
247 | $sql .= ' ORDER BY ' . $criteria->getSort() . ' ' . $criteria->getOrder(); |
||
248 | } |
||
249 | $limit = $criteria->getLimit(); |
||
250 | $start = $criteria->getStart(); |
||
251 | } |
||
252 | $result = $this->db->query($sql, $limit, $start); |
||
253 | if (!$result) { |
||
254 | return $ret; |
||
255 | } |
||
256 | while (false !== ($myrow = $this->db->fetchArray($result))) { |
||
257 | $image = new Image(); |
||
258 | $image->assignVars($myrow); |
||
259 | if ($id_as_key) { |
||
260 | $ret[$myrow['image_id']] = &$image; |
||
261 | } else { |
||
262 | $ret[] = &$image; |
||
263 | } |
||
264 | unset($image); |
||
265 | } |
||
266 | |||
267 | return $ret; |
||
268 | } |
||
269 | |||
270 | /** |
||
271 | * count suico_imagess matching a condition |
||
272 | * |
||
273 | * @param \CriteriaElement|\CriteriaCompo|null $criteria {@link \CriteriaElement} to match |
||
274 | * @return int count of suico_imagess |
||
275 | */ |
||
276 | public function getCount( |
||
277 | ?CriteriaElement $criteria = null |
||
278 | ) { |
||
279 | $sql = 'SELECT COUNT(*) FROM ' . $this->db->prefix('suico_images'); |
||
280 | if (isset($criteria) && is_subclass_of($criteria, 'CriteriaElement')) { |
||
281 | $sql .= ' ' . $criteria->renderWhere(); |
||
282 | } |
||
283 | $result = $this->db->query($sql); |
||
284 | if (!$result) { |
||
285 | return 0; |
||
286 | } |
||
287 | [$count] = $this->db->fetchRow($result); |
||
288 | |||
289 | return (int)$count; |
||
290 | } |
||
291 | |||
292 | /** |
||
293 | * delete suico_imagess matching a set of conditions |
||
294 | * |
||
295 | * @param \CriteriaElement|\CriteriaCompo|null $criteria {@link \CriteriaElement} |
||
296 | * @param bool $force |
||
297 | * @param bool $asObject |
||
298 | * @return bool FALSE if deletion failed |
||
299 | */ |
||
300 | public function deleteAll( |
||
301 | ?CriteriaElement $criteria = null, |
||
302 | $force = true, |
||
303 | $asObject = false |
||
304 | ) { |
||
305 | $sql = 'DELETE FROM ' . $this->db->prefix('suico_images'); |
||
306 | if (isset($criteria) && is_subclass_of($criteria, 'CriteriaElement')) { |
||
307 | $sql .= ' ' . $criteria->renderWhere(); |
||
308 | } |
||
309 | if (!$result = $this->db->query($sql)) { |
||
310 | return false; |
||
311 | } |
||
312 | |||
313 | return true; |
||
314 | } |
||
315 | |||
316 | /** |
||
317 | * Render a form to send pictures |
||
318 | * |
||
319 | * @param int $maxbytes the maximum size of a picture |
||
320 | * @param \XoopsTpl $xoopsTpl the one in which the form will be rendered |
||
321 | * @return bool TRUE |
||
322 | * |
||
323 | * obs: Some functions wont work on php 4 so edit lines down under acording to your version |
||
324 | */ |
||
325 | public function renderFormSubmit( |
||
326 | $maxbytes, |
||
327 | $xoopsTpl |
||
328 | ) { |
||
329 | $form = new XoopsThemeForm(\_MD_SUICO_SUBMIT_PIC_TITLE, 'form_picture', 'submitImage.php', 'post', true); |
||
330 | $field_url = new XoopsFormFile(\_MD_SUICO_SELECT_PHOTO, 'sel_photo', 2000000); |
||
331 | $field_title = new XoopsFormText(\_MD_SUICO_PHOTOTITLE, 'title', 35, 55); |
||
332 | $field_caption = new XoopsFormText(\_MD_SUICO_CAPTION, 'caption', 35, 55); |
||
333 | $form->setExtra('enctype="multipart/form-data"'); |
||
334 | $buttonSend = new XoopsFormButton('', 'submit_button', \_MD_SUICO_UPLOADPICTURE, 'submit'); |
||
335 | $field_warning = new XoopsFormLabel(\sprintf(\_MD_SUICO_YOU_CAN_UPLOAD, $maxbytes / 1024)); |
||
336 | $form->addElement($field_warning); |
||
337 | $form->addElement($field_url, true); |
||
338 | $form->addElement($field_title); |
||
339 | $form->addElement($field_caption); |
||
340 | $form->addElement($buttonSend); |
||
341 | $form->assign($xoopsTpl); //If your server is php 5 |
||
342 | |||
343 | return true; |
||
344 | } |
||
345 | |||
346 | /** |
||
347 | * Render a form to edit the description of the pictures |
||
348 | * |
||
349 | * @param $title |
||
350 | * @param string $caption The description of the picture |
||
351 | * @param int $image_id the id of the image in database |
||
352 | * @param string $filename the url to the thumb of the image so it can be displayed |
||
353 | * @return bool TRUE |
||
354 | */ |
||
355 | public function renderFormEdit( |
||
356 | $title, |
||
357 | $caption, |
||
358 | $image_id, |
||
359 | $filename |
||
360 | ) { |
||
361 | $form = new XoopsThemeForm(\_MD_SUICO_EDIT_PICTURE, 'form_picture', 'editpicture.php', 'post', true); |
||
362 | $field_title = new XoopsFormText($title, 'title', 35, 55); |
||
363 | $field_caption = new XoopsFormText($caption, 'caption', 35, 55); |
||
364 | $form->setExtra('enctype="multipart/form-data"'); |
||
365 | $buttonSend = new XoopsFormButton('', 'submit_button', \_MD_SUICO_SUBMIT, 'submit'); |
||
366 | $field_warning = new XoopsFormLabel("<img src='" . $filename . "' alt='thumb'>"); |
||
367 | $field_image_id = new XoopsFormHidden('image_id', $image_id); |
||
368 | $field_marker = new XoopsFormHidden('marker', 1); |
||
369 | $form->addElement($field_warning); |
||
370 | $form->addElement($field_title); |
||
371 | $form->addElement($field_caption); |
||
372 | $form->addElement($field_image_id); |
||
373 | $form->addElement($field_marker); |
||
374 | $form->addElement($buttonSend); |
||
375 | $form->display(); |
||
376 | |||
377 | return true; |
||
378 | } |
||
379 | |||
380 | /** |
||
381 | * Upload the file and Save into database |
||
382 | * |
||
383 | * @param string $title A litle title of the file |
||
384 | * @param string $caption A litle description of the file |
||
385 | * @param string $pathUpload The path to where the file should be uploaded |
||
386 | * @param int $thumbwidth the width in pixels that the thumbnail will have |
||
387 | * @param int $thumbheight the height in pixels that the thumbnail will have |
||
388 | * @param int $pictwidth the width in pixels that the pic will have |
||
389 | * @param int $pictheight the height in pixels that the pic will have |
||
390 | * @param int $maxfilebytes the maximum size a file can have to be uploaded in bytes |
||
391 | * @param int $maxfilewidth the maximum width in pixels that a pic can have |
||
392 | * @param int $maxfileheight the maximum height in pixels that a pic can have |
||
393 | * @return bool FALSE if upload fails or database fails |
||
394 | */ |
||
395 | public function receivePicture( |
||
396 | $title, |
||
397 | $caption, |
||
398 | $pathUpload, |
||
399 | $thumbwidth, |
||
400 | $thumbheight, |
||
401 | $pictwidth, |
||
402 | $pictheight, |
||
403 | $maxfilebytes, |
||
404 | $maxfilewidth, |
||
405 | $maxfileheight |
||
406 | ) { |
||
407 | global $xoopsUser, $xoopsDB; |
||
408 | //search logged user id |
||
409 | $uid = $xoopsUser->getVar('uid'); |
||
410 | //create a hash so it does not erase another file |
||
411 | //$hash1 = date(); |
||
412 | //$hash = substr($hash1,0,4); |
||
413 | // mimetypes and settings put this in admin part later |
||
414 | $allowed_mimetypes = Helper::getInstance()->getConfig( |
||
415 | 'mimetypes' |
||
416 | ); |
||
417 | $maxfilesize = $maxfilebytes; |
||
418 | // $uploadDir = \XOOPS_UPLOAD_PATH . '/suico/images/'; |
||
419 | // create the object to upload |
||
420 | $uploader = new XoopsMediaUploader( |
||
421 | $pathUpload, |
||
422 | $allowed_mimetypes, |
||
423 | $maxfilesize, |
||
424 | $maxfilewidth, |
||
425 | $maxfileheight |
||
426 | ); |
||
427 | // fetch the media |
||
428 | if ($uploader->fetchMedia(Request::getArray('xoops_upload_file', '', 'POST')[0])) { |
||
429 | //lets create a name for it |
||
430 | $uploader->setPrefix('pic_' . $uid . '_'); |
||
431 | //now let s upload the file |
||
432 | if (!$uploader->upload()) { |
||
433 | // if there are errors lets return them |
||
434 | echo '<div style="color:#FF0000; background-color:#FFEAF4; border-color:#FF0000; border-width:thick; border-style:solid; text-align:center"><p>' . $uploader->getErrors() . '</p></div>'; |
||
435 | |||
436 | return false; |
||
437 | } |
||
438 | // now let s create a new object picture and set its variables |
||
439 | $picture = $this->create(); |
||
440 | $filename = $uploader->getSavedFileName(); |
||
441 | $picture->setVar('filename', $filename); |
||
442 | $picture->setVar('title', $title); |
||
443 | $picture->setVar('caption', $caption); |
||
444 | $picture->setVar('date_created', \time()); |
||
445 | $picture->setVar('date_updated', \time()); |
||
446 | $picture->setVar('private', 0); |
||
447 | $uid = $xoopsUser->getVar('uid'); |
||
448 | $picture->setVar('uid_owner', $uid); |
||
449 | $this->insert($picture); |
||
450 | $saved_destination = $uploader->getSavedDestination(); |
||
451 | //print_r($_FILES); |
||
452 | //$this->resizeImage($saved_destination,false, $thumbwidth, $thumbheight, $pictwidth, $pictheight,$pathUpload); |
||
453 | //$this->resizeImage($saved_destination,true, $thumbwidth, $thumbheight, $pictwidth, $pictheight,$pathUpload); |
||
454 | $this->resizeImage( |
||
455 | $saved_destination, |
||
456 | $thumbwidth, |
||
457 | $thumbheight, |
||
458 | $pictwidth, |
||
459 | $pictheight, |
||
460 | $pathUpload |
||
461 | ); |
||
462 | } else { |
||
463 | echo '<div style="color:#FF0000; background-color:#FFEAF4; border-color:#FF0000; border-width:thick; border-style:solid; text-align:center"><p>' . $uploader->getErrors() . '</p></div>'; |
||
464 | |||
465 | return false; |
||
466 | } |
||
467 | |||
468 | return true; |
||
469 | } |
||
470 | |||
471 | /** |
||
472 | * Resize a picture and save it to $pathUpload |
||
473 | * |
||
474 | * @param string $img the path to the file |
||
475 | * @param int $thumbwidth the width in pixels that the thumbnail will have |
||
476 | * @param int $thumbheight the height in pixels that the thumbnail will have |
||
477 | * @param int $pictwidth the width in pixels that the pic will have |
||
478 | * @param int $pictheight the height in pixels that the pic will have |
||
479 | * @param string $pathUpload The path to where the files should be saved after resizing |
||
480 | */ |
||
481 | public function resizeImage( |
||
482 | $img, |
||
483 | $thumbwidth, |
||
484 | $thumbheight, |
||
485 | $pictwidth, |
||
486 | $pictheight, |
||
487 | $pathUpload |
||
488 | ): void { |
||
489 | $img2 = $img; |
||
490 | $path = \pathinfo($img); |
||
491 | $img = \imagecreatefromjpeg($img); |
||
492 | $xratio = $thumbwidth / \imagesx($img); |
||
493 | $yratio = $thumbheight / \imagesy($img); |
||
494 | if ($xratio < 1 || $yratio < 1) { |
||
495 | if ($xratio < $yratio) { |
||
496 | $resized = \imagecreatetruecolor($thumbwidth, (int)\floor(\imagesy($img) * $xratio)); |
||
497 | } else { |
||
498 | $resized = \imagecreatetruecolor((int)\floor(\imagesx($img) * $yratio), $thumbheight); |
||
499 | } |
||
500 | \imagecopyresampled( |
||
501 | $resized, |
||
502 | $img, |
||
503 | 0, |
||
504 | 0, |
||
505 | 0, |
||
506 | 0, |
||
507 | \imagesx($resized) + 1, |
||
508 | \imagesy($resized) + 1, |
||
509 | \imagesx($img), |
||
510 | \imagesy($img) |
||
511 | ); |
||
512 | \imagejpeg($resized, $pathUpload . '/thumb_' . $path['basename']); |
||
513 | \imagedestroy($resized); |
||
514 | } else { |
||
515 | \imagejpeg($img, $pathUpload . '/thumb_' . $path['basename']); |
||
516 | } |
||
517 | \imagedestroy($img); |
||
518 | $path2 = \pathinfo($img2); |
||
519 | $img2 = \imagecreatefromjpeg($img2); |
||
520 | $xratio2 = $pictwidth / \imagesx($img2); |
||
521 | $yratio2 = $pictheight / \imagesy($img2); |
||
522 | if ($xratio2 < 1 || $yratio2 < 1) { |
||
523 | if ($xratio2 < $yratio2) { |
||
524 | $resized2 = \imagecreatetruecolor($pictwidth, (int)\floor(\imagesy($img2) * $xratio2)); |
||
525 | } else { |
||
526 | $resized2 = \imagecreatetruecolor((int)\floor(\imagesx($img2) * $yratio2), $pictheight); |
||
527 | } |
||
528 | \imagecopyresampled( |
||
529 | $resized2, |
||
530 | $img2, |
||
531 | 0, |
||
532 | 0, |
||
533 | 0, |
||
534 | 0, |
||
535 | \imagesx($resized2) + 1, |
||
536 | \imagesy($resized2) + 1, |
||
537 | \imagesx($img2), |
||
538 | \imagesy($img2) |
||
539 | ); |
||
540 | \imagejpeg($resized2, $pathUpload . '/resized_' . $path2['basename']); |
||
541 | \imagedestroy($resized2); |
||
542 | } else { |
||
543 | \imagejpeg($img2, $pathUpload . '/resized_' . $path2['basename']); |
||
544 | } |
||
545 | \imagedestroy($img2); |
||
546 | } |
||
547 | |||
548 | /** |
||
549 | * @param $limit |
||
550 | * @return array |
||
551 | */ |
||
552 | public function getLastPictures($limit) |
||
553 | { |
||
554 | $ret = []; |
||
555 | $sql = 'SELECT uname, t.uid_owner, t.filename FROM ' . $this->db->prefix( |
||
556 | 'suico_images' |
||
557 | ) . ' AS t, ' . $this->db->prefix( |
||
558 | 'users' |
||
559 | ); |
||
560 | $sql .= ' WHERE uid_owner = uid AND private=0 ORDER BY image_id DESC'; |
||
561 | $result = $this->db->query($sql, $limit, 0); |
||
562 | $vetor = []; |
||
563 | $i = 0; |
||
564 | while (false !== ($myrow = $this->db->fetchArray($result))) { |
||
565 | $vetor[$i]['uid_owner'] = $myrow['uid_owner']; |
||
566 | $vetor[$i]['uname'] = $myrow['uname']; |
||
567 | $vetor[$i]['img_filename'] = $myrow['filename']; |
||
568 | $i++; |
||
569 | } |
||
570 | |||
571 | return $vetor; |
||
572 | } |
||
573 | |||
574 | /** |
||
575 | * @param $limit |
||
576 | * @return array |
||
577 | */ |
||
578 | public function getLastPicturesForBlock($limit) |
||
579 | { |
||
580 | global $xoopsUser, $xoopsDB; |
||
581 | if (\is_object($xoopsUser)) { |
||
582 | $uid = $xoopsUser->getVar('uid'); |
||
583 | } |
||
584 | |||
585 | $controller = new PhotosController($xoopsDB, $xoopsUser); |
||
586 | |||
587 | $isUser = $controller->isUser; |
||
588 | $isAnonymous = $controller->isAnonym; |
||
589 | |||
590 | if (1 == $isAnonymous) { |
||
591 | $sql = 'SELECT uname, t.uid_owner, t.filename, t.title, t.caption, t.date_created, t.date_updated FROM ' . $this->db->prefix('suico_images') . ' AS t'; |
||
592 | $sql .= ' INNER JOIN ' . $this->db->prefix('users') . ' u ON t.uid_owner=u.uid'; |
||
593 | $sql .= ' INNER JOIN ' . $this->db->prefix('suico_configs') . ' c on t.uid_owner=c.config_uid'; |
||
594 | $sql .= ' WHERE private=0 AND c.pictures < 2 '; |
||
595 | $sql .= ' ORDER BY image_id DESC'; |
||
596 | } |
||
597 | if (1 == $isUser) { |
||
598 | $sql0 = 'SELECT f.friend2_uid FROM ' . $this->db->prefix('suico_friendships') . ' AS f'; |
||
599 | $sql0 .= ' WHERE f.friend1_uid = ' . $uid; |
||
0 ignored issues
–
show
Comprehensibility
Best Practice
introduced
by
|
|||
600 | $sql = 'SELECT uname, t.uid_owner, t.filename, t.title, t.caption, t.date_created, t.date_updated FROM ' . $this->db->prefix('suico_images') . ' AS t'; |
||
601 | $sql .= ' INNER JOIN ' . $this->db->prefix('users') . ' u ON t.uid_owner=u.uid'; |
||
602 | $sql .= ' INNER JOIN ' . $this->db->prefix('suico_configs') . ' c on t.uid_owner=c.config_uid'; |
||
603 | $sql .= ' WHERE (private=0 AND c.pictures < 3 )'; //all pictures visible to members |
||
604 | $sql .= ' OR ( private=0 AND c.pictures = 3 AND c.config_uid IN ( ' . $sql0 . ')) '; //pictures visible to friends |
||
605 | $sql .= ' OR ( c.config_uid = ' . $uid . ' ) '; //my private pictures |
||
606 | $sql .= ' ORDER BY image_id DESC'; |
||
607 | } |
||
608 | |||
609 | $result = $this->db->query($sql, $limit, 0); |
||
0 ignored issues
–
show
Comprehensibility
Best Practice
introduced
by
|
|||
610 | |||
611 | $vetor = []; |
||
612 | $i = 0; |
||
613 | while (false !== ($myrow = $this->db->fetchArray($result))) { |
||
614 | $vetor[$i]['uid_owner'] = $myrow['uid_owner']; |
||
615 | $vetor[$i]['uname'] = $myrow['uname']; |
||
616 | $vetor[$i]['img_filename'] = $myrow['filename']; |
||
617 | $vetor[$i]['title'] = $myrow['title']; |
||
618 | $vetor[$i]['caption'] = $myrow['caption']; |
||
619 | $vetor[$i]['date_created'] = \formatTimestamp($myrow['date_created']); |
||
620 | $vetor[$i]['date_updated'] = \formatTimestamp($myrow['date_updated']); |
||
621 | $i++; |
||
622 | } |
||
623 | |||
624 | return $vetor; |
||
625 | } |
||
626 | |||
627 | /** |
||
628 | * Resize a picture and save it to $pathUpload |
||
629 | * |
||
630 | * @param string $img the path to the file |
||
631 | * @param $width |
||
632 | * @param $height |
||
633 | * @param string $pathUpload The path to where the files should be saved after resizing |
||
634 | */ |
||
635 | public function makeAvatar( |
||
636 | $img, |
||
637 | $width, |
||
638 | $height, |
||
639 | $pathUpload |
||
640 | ): void { |
||
641 | $img2 = $img; |
||
642 | $path = \pathinfo($img); |
||
643 | $img = \imagecreatefromjpeg($img); |
||
644 | $xratio = $thumbwidth / \imagesx($img); |
||
0 ignored issues
–
show
Comprehensibility
Best Practice
introduced
by
|
|||
645 | $yratio = $thumbheight / \imagesy($img); |
||
0 ignored issues
–
show
Comprehensibility
Best Practice
introduced
by
|
|||
646 | if ($xratio < 1 || $yratio < 1) { |
||
647 | if ($xratio < $yratio) { |
||
648 | $resized = \imagecreatetruecolor($thumbwidth, (int)\floor(\imagesy($img) * $xratio)); |
||
649 | } else { |
||
650 | $resized = \imagecreatetruecolor((int)\floor(\imagesx($img) * $yratio), $thumbheight); |
||
651 | } |
||
652 | \imagecopyresampled( |
||
653 | $resized, |
||
654 | $img, |
||
655 | 0, |
||
656 | 0, |
||
657 | 0, |
||
658 | 0, |
||
659 | \imagesx($resized) + 1, |
||
660 | \imagesy($resized) + 1, |
||
661 | \imagesx($img), |
||
662 | \imagesy($img) |
||
663 | ); |
||
664 | \imagejpeg($resized, $pathUpload . '/thumb_' . $path['basename']); |
||
665 | \imagedestroy($resized); |
||
666 | } else { |
||
667 | \imagejpeg($img, $pathUpload . '/thumb_' . $path['basename']); |
||
668 | } |
||
669 | \imagedestroy($img); |
||
670 | $path2 = \pathinfo($img2); |
||
671 | $img2 = \imagecreatefromjpeg($img2); |
||
672 | $xratio2 = $pictwidth / \imagesx($img2); |
||
0 ignored issues
–
show
Comprehensibility
Best Practice
introduced
by
|
|||
673 | $yratio2 = $pictheight / \imagesy($img2); |
||
0 ignored issues
–
show
Comprehensibility
Best Practice
introduced
by
|
|||
674 | if ($xratio2 < 1 || $yratio2 < 1) { |
||
675 | if ($xratio2 < $yratio2) { |
||
676 | $resized2 = \imagecreatetruecolor($pictwidth, (int)\floor(\imagesy($img2) * $xratio2)); |
||
677 | } else { |
||
678 | $resized2 = \imagecreatetruecolor((int)\floor(\imagesx($img2) * $yratio2), $pictheight); |
||
679 | } |
||
680 | \imagecopyresampled( |
||
681 | $resized2, |
||
682 | $img2, |
||
683 | 0, |
||
684 | 0, |
||
685 | 0, |
||
686 | 0, |
||
687 | \imagesx($resized2) + 1, |
||
688 | \imagesy($resized2) + 1, |
||
689 | \imagesx($img2), |
||
690 | \imagesy($img2) |
||
691 | ); |
||
692 | \imagejpeg($resized2, $pathUpload . '/resized_' . $path2['basename']); |
||
693 | \imagedestroy($resized2); |
||
694 | } else { |
||
695 | \imagejpeg($img2, $pathUpload . '/resized_' . $path2['basename']); |
||
696 | } |
||
697 | \imagedestroy($img2); |
||
698 | } |
||
699 | } |
||
700 |