Code Duplication    Length = 53-54 lines in 2 locations

viewcats.php 1 location

@@ 364-416 (lines=53) @@
361
                $a_item['sold'] = _ADSLIGHT_RESERVEDMEMBER;
362
            }
363
364
            if ($xoopsModuleConfig['active_thumbscats'] > 0) {
365
                $a_item['no_photo'] = '<a href="'
366
                                      . XOOPS_URL
367
                                      . '/modules/adslight/viewads.php?lid='
368
                                      . $lid
369
                                      . '"><img class="thumb" src="'
370
                                      . XOOPS_URL
371
                                      . '/modules/adslight/assets/images/nophoto.jpg" align="left" width="100px" alt="'
372
                                      . $title
373
                                      . '" /></a>';
374
375
                $updir   = $xoopsModuleConfig['adslight_link_upload'];
376
                $sql     = 'SELECT cod_img, lid, uid_owner, url FROM '
377
                           . $xoopsDB->prefix('adslight_pictures')
378
                           . ' WHERE  uid_owner='
379
                           . $xoopsDB->escape($usid)
380
                           . ' AND lid='
381
                           . $xoopsDB->escape($lid)
382
                           . ' ORDER BY date_added ASC limit 1';
383
                $resultp = $xoopsDB->query($sql);
384
385
                while (list($cod_img, $pic_lid, $uid_owner, $url) = $xoopsDB->fetchRow($resultp)) {
386
                    if ($photo) {
387
                        $a_item['photo'] = '<a href="'
388
                                           . XOOPS_URL
389
                                           . '/modules/adslight/viewads.php?lid='
390
                                           . $lid
391
                                           . '"><img class="thumb" src="'
392
                                           . $updir
393
                                           . '/thumbs/thumb_'
394
                                           . $url
395
                                           . '" align="left" width="100px" alt="'
396
                                           . $title
397
                                           . '" /></a>';
398
                    }
399
                }
400
            } else {
401
                $a_item['no_photo'] = '<p><img src="' . XOOPS_URL . '/modules/adslight/assets/images/camera_nophoto.png" align="left" width="24" alt="' . $title . '" /></p>';
402
                $updir              = $xoopsModuleConfig['adslight_link_upload'];
403
                $sql                = 'SELECT cod_img, lid, uid_owner, url FROM '
404
                                      . $xoopsDB->prefix('adslight_pictures')
405
                                      . ' WHERE  uid_owner='
406
                                      . $xoopsDB->escape($usid)
407
                                      . ' AND lid='
408
                                      . $xoopsDB->escape($lid)
409
                                      . ' ORDER BY date_added ASC limit 1';
410
                $resultp            = $xoopsDB->query($sql);
411
                while (list($cod_img, $pic_lid, $uid_owner, $url) = $xoopsDB->fetchRow($resultp)) {
412
                    if ($photo) {
413
                        $a_item['photo'] = '<p><img src="' . XOOPS_URL . '/modules/adslight/assets/images/camera_photo.png" align="left" width="24" alt="' . $title . '" /></p>';
414
                    }
415
                }
416
            }
417
418
            $a_item['hits'] = $hits;
419
            ++$rank;

index.php 1 location

@@ 308-361 (lines=54) @@
305
                    $a_item['sold'] = _ADSLIGHT_RESERVEDMEMBER;
306
                }
307
308
                if ($xoopsModuleConfig['active_thumbsindex'] > 0) {
309
                    $a_item['no_photo'] = '<a href="'
310
                                          . XOOPS_URL
311
                                          . '/modules/adslight/viewads.php?lid='
312
                                          . $lid
313
                                          . '"><img class="thumb" src="'
314
                                          . XOOPS_URL
315
                                          . '/modules/adslight/assets/images/nophoto.jpg" align="left" width="100px" alt="'
316
                                          . $title
317
                                          . '" /></a>';
318
319
                    $updir   = $xoopsModuleConfig['adslight_link_upload'];
320
                    $sql     = 'SELECT cod_img, lid, uid_owner, url FROM '
321
                               . $xoopsDB->prefix('adslight_pictures')
322
                               . ' WHERE  uid_owner='
323
                               . $xoopsDB->escape($usid)
324
                               . ' AND lid='
325
                               . $xoopsDB->escape($lid)
326
                               . ' ORDER BY date_added ASC limit 1';
327
                    $resultp = $xoopsDB->query($sql);
328
329
                    while (list($cod_img, $pic_lid, $uid_owner, $url) = $xoopsDB->fetchRow($resultp)) {
330
                        if ($photo) {
331
                            $a_item['photo'] = '<a href="'
332
                                               . XOOPS_URL
333
                                               . '/modules/adslight/viewads.php?lid='
334
                                               . $lid
335
                                               . '"><img class="thumb" src="'
336
                                               . $updir
337
                                               . '/thumbs/thumb_'
338
                                               . $url
339
                                               . '" align="left" width="100px" alt="'
340
                                               . $title
341
                                               . '" /></a>';
342
                        }
343
                    }
344
                } else {
345
                    $a_item['no_photo'] = '<img src="' . XOOPS_URL . '/modules/adslight/assets/images/camera_nophoto.png" align="left" width="24" alt="' . $title . '" />';
346
                    $updir              = $xoopsModuleConfig['adslight_link_upload'];
347
                    $sql                = 'SELECT cod_img, lid, uid_owner, url FROM '
348
                                          . $xoopsDB->prefix('adslight_pictures')
349
                                          . ' WHERE  uid_owner='
350
                                          . $xoopsDB->escape($usid)
351
                                          . ' AND lid='
352
                                          . $xoopsDB->escape($lid)
353
                                          . ' ORDER BY date_added ASC limit 1';
354
                    $resultp            = $xoopsDB->query($sql);
355
356
                    while (list($cod_img, $pic_lid, $uid_owner, $url) = $xoopsDB->fetchRow($resultp)) {
357
                        if ($photo) {
358
                            $a_item['photo'] = '<img src="' . XOOPS_URL . '/modules/adslight/assets/images/camera_photo.png" align="left" width="24" alt="' . $title . '" />';
359
                        }
360
                    }
361
                }
362
                $a_item['hits'] = $hits;
363
                ++$rank;
364
                $xoopsTpl->append('items', $a_item);