mambax7 / adslight

            $a_item['sold'] = '<img src="assets/images/sold.gif" align="left" alt="">';

        }

        if ('' != $myrow['photo']) {

            //            $updir = $xoopsModuleConfig["{$moduleDirName}_link_upload"];

            $sql = 'SELECT cod_img, lid, uid_owner, url FROM '

                   . $xoopsDB->prefix("{$moduleDirName}_pictures")

                   . ' WHERE uid_owner='

                   . (int)$usid

                   . " AND lid={$a_item['id']} ORDER BY date_added ASC LIMIT 1";

            //            if ('' != $myrow['photo']) {

            //                //  $updir = $GLOBALS['xoopsModuleConfig']["".$moduleDirName."_link_upload"];

            //                $sql = 'SELECT cod_img, lid, uid_owner, url FROM '

            //                       . $xoopsDB->prefix('' . $moduleDirName . '_pictures')

            //                       . ' WHERE  uid_owner=' . $xoopsDB->escape($usid)

            //                       . ' AND lid=' . $xoopsDB->escape($myrow['lid'])

            //                       . ' ORDER BY date_added ASC limit 1';

            //            }

            $resultp = $xoopsDB->query($sql);

            while (list($cod_img, $pic_lid, $uid_owner, $url) = $xoopsDB->fetchRow($resultp)) {

                $a_item['photo'] = '<a href="'

                                   . XOOPS_URL

                                   . "/modules/$moduleDirName/viewads.php?lid={$a_item['id']}\"><img class=\"thumb\" src=\""

                                   . XOOPS_URL

                                   . "/uploads/AdsLight/thumbs/thumb_{$url}\" align=\"left\" width=\"100px\" alt=\"{$title}\"></a>";

            }

        } else {

            $a_item['photo'] = '';

        }

        $a_item['link'] = '<a href="' . XOOPS_URL . "/modules/{$moduleDirName}/viewads.php?lid={$a_item['id']}\"><b>{$title}</b></a>";

        $a_item['date'] = formatTimestamp($myrow['date'], 's');

        $a_item['hits'] = $myrow['hits'];

                                               . "/modules/adslight/viewads.php?lid={$lid}\"><img class=\"thumb\" src=\"{$updir}/thumbs/thumb_{$url}\" align=\"left\" width=\"100px\" alt=\"{$title}\"></a>";

                        }

                    }

                } else {

                    $a_item['no_photo'] = "<img src=\"" . XOOPS_URL . "/modules/adslight/assets/images/camera_nophoto.png\" align=\"left\" width=\"24px\" alt=\"{$title}\">";

                    $updir              = $GLOBALS['xoopsModuleConfig']['adslight_link_upload'];

                    $sql                = 'SELECT cod_img, lid, uid_owner, url FROM '

                                          . $xoopsDB->prefix('adslight_pictures')

                                          . ' WHERE uid_owner='

                                          . (int)$usid

                                          . " AND lid={$lid} ORDER BY date_added ASC LIMIT 1";

                    $resultp            = $xoopsDB->query($sql);

                    while (list($cod_img, $pic_lid, $uid_owner, $url) = $xoopsDB->fetchRow($resultp)) {

                        if ($photo) {

                            $a_item['photo'] = "<img src=\"" . XOOPS_URL . "/modules/adslight/assets/images/camera_photo.png\" align=\"left\" width=\"24\" alt=\"{$title}\">";

                        }

                    }

                }

                $a_item['hits'] = $hits;

                ++$rank;

                $xoopsTpl->append('items', $a_item);