XoopsModules25x / efqdirectory

     * @param int $itemid listing id

     * @return bool|int

     */

    public function getCountByLink($itemid)

    {

        $ret = 0;

        $now = time();

        $sql = 'SELECT count(*) FROM ' . $this->db->prefix($module->getVar('dirname', 'n') . '_coupon') . ' WHERE itemid=' . (int)$itemid . ' AND publish < ' . $now . ' AND (expire = 0 OR expire > ' . $now . ')';

        if (!$result = $this->db->query($sql)) {

            return false;

        }

        list($ret) = $this->db->fetchRow($result);

        return $ret;

    }

    /**

     * get {@link Coupon} object with listing info

    *

    * @return

    */

    public function getCountByLink($itemid = 0)

    {

        $ret = 0;

        $now = time();

        $sql = 'SELECT count(*) FROM ' . $this->db->prefix($module->getVar('dirname', 'n') . '_coupon') . ' WHERE itemid=' . $itemid . ' AND publish < ' . $now . ' AND (expire = 0 OR expire > ' . $now . ')';

        //echo $sql;

        if (!$result = $this->db->query($sql)) {

            return false;

        }

        list($ret) = $this->db->fetchRow($result);

        return $ret;

    }

    public function getByItem($itemid = 0)

    {