XoopsModules25x / efqdirectory

                    $votestring = sprintf(_MD_NUMVOTES, $votes);

                }

                if ($xoopsModuleConfig['showdatafieldsincat'] == '1') {

                    $xoopsTpl->assign('showdatafieldsincat', true);

                    $sql         = 'SELECT DISTINCT t.dtypeid, t.title, t.section, t.icon, f.typeid, f.fieldtype, f.ext, t.options, t.custom, d.itemid, d.value, d.customtitle ';

                    $sql         .= 'FROM '

                                    . $xoopsDB->prefix($module->getVar('dirname', 'n') . '_item_x_cat')

                                    . ' ic, '

                                    . $xoopsDB->prefix($module->getVar('dirname', 'n') . '_dtypes_x_cat')

                                    . ' xc, '

                                    . $xoopsDB->prefix($module->getVar('dirname', 'n') . '_fieldtypes')

                                    . ' f, '

                                    . $xoopsDB->prefix($module->getVar('dirname', 'n') . '_dtypes')

                                    . ' t ';

                    $sql         .= 'LEFT JOIN ' . $xoopsDB->prefix($module->getVar('dirname', 'n') . '_data') . ' d ON (t.dtypeid=d.dtypeid AND d.itemid=' . $itemid . ') ';

                    $sql         .= "WHERE ic.cid=xc.cid AND ic.active='1' AND xc.dtypeid=t.dtypeid AND t.fieldtypeid=f.typeid AND t.activeyn='1' AND ic.itemid=" . $itemid . ' ORDER BY t.seq ASC';

                    $data_result = $xoopsDB->query($sql) or $eh->show('0013');

                    $numrows     = $xoopsDB->getRowsNum($data_result);

                    if ($numrows > 0) {

                        $xoopsTpl->assign('datatypes', true);

                    }

                    $sections = array();

                    while (list($dtypeid, $title, $section, $icon, $ftypeid, $fieldtype, $ext, $options, $custom, $ditemid, $value, $customtitle) = $xoopsDB->fetchRow($data_result)) {

                        $fieldvalue = $datafieldmanager->getFieldValue($fieldtype, $options, $value);

                        if ($icon != '') {

                            $iconurl = "<img src=\"uploads/$icon\">";

                        } else {

                            $iconurl = '';

                        }

                        if ($custom != '0' && $customtitle != '') {

                            $title = $customtitle;

                        }

                        if ($section == '0' or '1') {

                            $sections[] = array('icon' => $iconurl, 'label' => $title, 'value' => $fieldvalue, 'fieldtype' => $fieldtype);

                        }

                    }

                }

                $couponHandler = new efqCouponHandler();

                $coupons       = $couponHandler->getCountByLink($itemid);

                        $votestring = sprintf(_MD_NUMVOTES, $votes);

                    }

                    if ($xoopsModuleConfig['showdatafieldsincat'] == '1') {

                        $xoopsTpl->assign('showdatafieldsincat', true);

                        $sql         = 'SELECT DISTINCT t.dtypeid, t.title, t.section, t.icon, f.typeid, f.fieldtype, f.ext, t.options, t.custom, d.itemid, d.value, d.customtitle ';

                        $sql         .= 'FROM '

                                        . $xoopsDB->prefix($module->getVar('dirname', 'n') . '_item_x_cat')

                                        . ' ic, '

                                        . $xoopsDB->prefix($module->getVar('dirname', 'n') . '_dtypes_x_cat')

                                        . ' xc, '

                                        . $xoopsDB->prefix($module->getVar('dirname', 'n') . '_fieldtypes')

                                        . ' f, '

                                        . $xoopsDB->prefix($module->getVar('dirname', 'n') . '_dtypes')

                                        . ' t ';

                        $sql         .= 'LEFT JOIN ' . $xoopsDB->prefix($module->getVar('dirname', 'n') . '_data') . ' d ON (t.dtypeid=d.dtypeid AND d.itemid=' . $itemid . ') ';

                        $sql         .= "WHERE ic.cid=xc.cid AND ic.active='1' AND xc.dtypeid=t.dtypeid AND t.fieldtypeid=f.typeid AND t.activeyn='1' AND ic.itemid=" . $itemid . ' ORDER BY t.seq ASC';

                        $data_result = $xoopsDB->query($sql) or $eh->show('0013');

                        $numrows     = $xoopsDB->getRowsNum($data_result);

                        if ($numrows > 0) {

                            $xoopsTpl->assign('datatypes', true);

                        }

                        $sections = array();

                        while (list($dtypeid, $title, $section, $icon, $ftypeid, $fieldtype, $ext, $options, $custom, $ditemid, $value, $customtitle) = $xoopsDB->fetchRow($data_result)) {

                            $fieldvalue = $datafieldmanager->getFieldValue($fieldtype, $options, $value);

                            if ($icon != '') {

                                $iconurl = "<img src=\"uploads/$icon\">";

                            } else {

                                $iconurl = '';

                            }

                            if ($custom != '0' && $customtitle != '') {

                                $title = $customtitle;

                            }

                            if ($section == '1' or '1') {

                                $sections[] = array('icon' => $iconurl, 'label' => $title, 'value' => $fieldvalue, 'fieldtype' => $fieldtype);

                            }

                        }

                    }

                    $path = $efqtree->getPathFromId($get_catid, 'title');

                    $path = substr($path, 1);