htdocs/search.php ➔ outputSearchForm()

Complexity

Conditions	91
Paths	> 20000

Size

Total Lines

644

Duplication

Lines	66
Ratio	10.25 %

Importance

Changes

0

<?php
function outputSearchForm($options)
{
    global $tpl, $login, $opt;
    global $error_ort, $error_plz, $error_locidnocoords, $error_nowaypointfound;
    global $error_nocoords, $error_nofulltext, $error_fulltexttoolong;
    global $cache_attrib_jsarray_line, $cache_attrib_group, $cache_attrib_img_line1, $cache_attrib_img_line2;
    global $load_query, $show_lastsearchbutton;

    $tpl->assign('formmethod', 'get');

    $tpl->assign('logged_in', $login->logged_in());
    $tpl->assign('load_query', $load_query == false);
    $tpl->assign('show_lastsearchbutton', $show_lastsearchbutton == true);

    //sort search by (radio button + 1 checkbox)

    if (isset($options['sort'])) {
        $bBynameChecked = ($options['sort'] == 'byname');
    } else { // Ocprop
        $bBynameChecked = (!$login->logged_in());
    }
    $tpl->assign('byname_checked', $bBynameChecked);

    if (isset($options['sort'])) {
        $bBydistanceChecked = ($options['sort'] == 'bydistance');
    } else {
        $bBydistanceChecked = ($login->logged_in());
    }
    $tpl->assign('bydistance_checked', $bBydistanceChecked);

    if (isset($options['sort'])) {
        $bBycreatedChecked = ($options['sort'] == 'bycreated');
    } else {
        $bBycreatedChecked = (!$login->logged_in());
    }
    $tpl->assign('bycreated_checked', $bBycreatedChecked);

    if (isset($options['sort'])) {
        $bBylastlogChecked = ($options['sort'] == 'bylastlog');
    } else {
        $bBylastlogChecked = ($login->logged_in());
    }
    $tpl->assign('bylastlog_checked', $bBylastlogChecked);

    if (isset($options['sort'])) {
        $bBymylastlogChecked = ($options['sort'] == 'bymylastlog');
    } else {
        $bBymylastlogChecked = ($login->logged_in());
    }
    $tpl->assign('bymylastlog_checked', $bBymylastlogChecked);

    $tpl->assign('hidopt_sort', $options['sort']);

    $tpl->assign('orderRatingFirst_checked', $options['orderRatingFirst']);
    $tpl->assign('hidopt_orderRatingFirst', $options['orderRatingFirst'] ? '1' : '0');

    //hide caches... (checkboxes)

    $tpl->assign('f_userowner_checked', $login->logged_in() && ($options['f_userowner'] == 1));
    $tpl->assign('hidopt_userowner', ($options['f_userowner'] == 1) ? '1' : '0');

    $tpl->assign('f_userfound_checked', $login->logged_in() && ($options['f_userfound'] == 1));
    $tpl->assign('hidopt_userfound', ($options['f_userfound'] == 1) ? '1' : '0');

    $tpl->assign('f_ignored_checked', $login->logged_in() && ($options['f_ignored'] == 1));
    $tpl->assign('hidopt_ignored', ($options['f_ignored'] == 1) ? '1' : '0');

    $tpl->assign('f_disabled_checked', $options['f_disabled'] == 1);
    $tpl->assign('hidopt_disabled', ($options['f_disabled'] == 1) ? '1' : '0');

    // archived is called "disabled" here for backward compatibility
    $tpl->assign('f_inactive_checked', $options['f_inactive'] == 1);
    $tpl->assign('hidopt_inactive', ($options['f_inactive'] == 1) ? '1' : '0');

    $tpl->assign('f_otherPlatforms_checked', $options['f_otherPlatforms'] == 1);
    $tpl->assign('hidopt_otherPlatforms', ($options['f_otherPlatforms'] == 1) ? '1' : '0');

    $tpl->assign('f_geokrets_checked', $options['f_geokrets'] == 1);
    $tpl->assign('hidopt_geokrets', ($options['f_geokrets'] == 1) ? '1' : '0');

    if (!isset($options['country'])) {
        $options['country'] = '';
    }
    $tpl->assign('country', htmlspecialchars($options['country'], ENT_COMPAT, 'UTF-8'));

    if (!isset($options['language'])) {
        $options['language'] = '';
    }
    $tpl->assign('language', htmlspecialchars($options['language'], ENT_COMPAT, 'UTF-8'));

    if (isset($options['cachetype'])) {
        $tpl->assign('cachetype', htmlspecialchars($options['cachetype'], ENT_COMPAT, 'UTF-8'));
    } else {
        $tpl->assign('cachetype', '');
    }

    // cachename
    $tpl->assign(
        'cachename',
        isset($options['cachename']) ? htmlspecialchars($options['cachename'], ENT_COMPAT, 'UTF-8') : ''
    );
    $tpl->assign('searchtype_byname', $options['searchtype'] == 'byname');

    // distance
    $tpl->assign('distance', isset($options['distance']) ? $options['distance'] : DEFAULT_SEARCH_DISTANCE);

    if (!isset($options['unit'])) {
        $options['unit'] = DEFAULT_DISTANCE_UNIT;
    }
    $tpl->assign('sel_km', $options['unit'] == 'km');
    $tpl->assign('sel_sm', $options['unit'] == 'sm');
    $tpl->assign('sel_nm', $options['unit'] == 'nm');

    // ... from ortplz
    if (isset($options['ortplz'])) {
        $ortplz = htmlspecialchars($options['ortplz'], ENT_COMPAT, 'UTF-8');
    } elseif (isset($options['ort'])) {
        $ortplz = htmlspecialchars($options['ort'], ENT_COMPAT, 'UTF-8');
    } elseif (isset($options['plz'])) {
        $ortplz = htmlspecialchars($options['plz'], ENT_COMPAT, 'UTF-8');
    } else {
        $ortplz = '';
    }
    $tpl->assign('ortplz', $ortplz);

    // ... from waypoint
    $tpl->assign(
        'waypoint',
        isset($options['waypoint']) ? htmlspecialchars($options['waypoint'], ENT_COMPAT, 'UTF-8') : ''
    );

    // ... from coords
    if (!isset($options['lat_h'])) {
        if ($login->logged_in()) {
            $rs = sql(

The function sql() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

                "SELECT `latitude`, `longitude`
                 FROM `user`
                 WHERE `user_id`='" . sql_escape($login->userid) . "'"

The function sql_escape() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

            );
            $record = sql_fetch_array($rs);

$rs is of type object<mysqli_result>, but the function expects a resource.

The function sql_fetch_array() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

            $lon = $record['longitude'];
            $lat = $record['latitude'];
            sql_free_result($rs);

The function sql_free_result() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

            $tpl->assign('lonE_sel', $lon >= 0);
            $tpl->assign('lonW_sel', $lon < 0);
            $tpl->assign('latN_sel', $lat >= 0);
            $tpl->assign('latS_sel', $lat < 0);

            $lon_h = floor($lon);
            $lat_h = floor($lat);

            $lon_min = ($lon - $lon_h) * 60;
            $lat_min = ($lat - $lat_h) * 60;

            if ($lat < 0 && $lat_h < 0) {
                $lat_min = 60 - $lat_min;
            }
            if ($lon < 0 && $lon_h < 0) {
                $lon_min = 60 - $lon_min;
            }

            $tpl->assign('lat_min', sprintf('%02.3f', $lat_min));
            $tpl->assign('lon_min', sprintf('%02.3f', $lon_min));

            if ($lat < 0 && $lat_h < 0) {
                $lat_h = - $lat_h;
                if ($lat_min != 0) {
                    $lat_h = $lat_h - 1;
                }
            }
            if ($lon < 0 && $lon_h < 0) {
                $lon_h = - $lon_h;
                if ($lon_min != 0) {
                    $lon_h = $lon_h - 1;
                }
            }
            $tpl->assign('lat_h', $lat_h);
            $tpl->assign('lon_h', $lon_h);
        } else {
            $tpl->assign('lat_h', '00');
            $tpl->assign('lon_h', '000');
            $tpl->assign('lat_min', '00.000');
            $tpl->assign('lon_min', '00.000');
        }
    } else {
        $tpl->assign('lat_h', isset($options['lat_h']) ? $options['lat_h'] : '00');
        $tpl->assign('lon_h', isset($options['lon_h']) ? $options['lon_h'] : '000');
        $tpl->assign('lat_min', isset($options['lat_min']) ? $options['lat_min'] : '00.000');
        $tpl->assign('lon_min', isset($options['lon_min']) ? $options['lon_min'] : '00.000');

        if ($options['lonEW'] == 'W') {
            $tpl->assign('lonE_sel', '');
            $tpl->assign('lonW_sel', 'selected="selected"');
        } else {
            $tpl->assign('lonE_sel', 'selected="selected"');
            $tpl->assign('lonW_sel', '');
        }

        if ($options['latNS'] == 'S') {
            $tpl->assign('latS_sel', 'selected="selected"');
            $tpl->assign('latN_sel', '');
        } else {
            $tpl->assign('latS_sel', '');
            $tpl->assign('latN_sel', 'selected="selected"');
        }
    }

    $dfromortplz_checked = in_array($options['searchtype'], ['byplz', 'byort']);
    $dfromwaypoint_checked = ($options['searchtype'] == 'bywaypoint');
    $dfromcoords_checked = ($options['searchtype'] == 'bycoords');
    if (!$dfromortplz_checked && !$dfromwaypoint_checked && !$dfromcoords_checked) {
        $dfromcoords_checked = true; // default
    }
    $tpl->assign('dfromortplz_checked', $dfromortplz_checked);
    $tpl->assign('dfromwaypoint_checked', $dfromwaypoint_checked);
    $tpl->assign('dfromcoords_checked', $dfromcoords_checked);

    $tpl->assign('searchtype_byortplz', in_array($options['searchtype'], ['byplz', 'byort']));
    $tpl->assign('searchtype_bywaypoint', $options['searchtype'] == 'bywaypoint');
    $tpl->assign('searchtype_bycoords', $options['searchtype'] == 'bycoords');
    
    // owner
    $tpl->assign('owner', isset($options['owner']) ? htmlspecialchars($options['owner'], ENT_COMPAT, 'UTF-8') : '');
    $tpl->assign('searchtype_byowner', $options['searchtype'] == 'byowner');

    // finder
    $tpl->assign('finder', isset($options['finder']) ? htmlspecialchars($options['finder'], ENT_COMPAT, 'UTF-8') : '');
    $tpl->assign('searchtype_byfinder', $options['searchtype'] == 'byfinder');

    // country options
    $rs = sql(

The function sql() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

        "SELECT IFNULL(`sys_trans_text`.`text`, `countries`.`name`) AS `name`,
                `countries`.`short`,
                `countries`.`short`='&2' AS `selected`
         FROM `countries`
         LEFT JOIN `sys_trans`
           ON `countries`.`trans_id`=`sys_trans`.`id`
           AND `sys_trans`.`text`=`countries`.`name`
         LEFT JOIN `sys_trans_text`
           ON `sys_trans`.`id`=`sys_trans_text`.`trans_id`
           AND `sys_trans_text`.`lang`='&1'
         WHERE `countries`.`short` IN (SELECT DISTINCT `country` FROM `caches`)
         ORDER BY `name` ASC",
        $opt['template']['locale'],
        $options['country']
    );
    $tpl->assign_rs('countryoptions', $rs);
    sql_free_result($rs);

The function sql_free_result() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

    $tpl->assign('all_countries', $options['country'] == '');

    // language options
    $rs = sql(

The function sql() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

        "SELECT IFNULL(`sys_trans_text`.`text`,`languages`.`name`) AS `name`,
                `short`,
                `short`='&2' AS `selected`
         FROM `languages`
         LEFT JOIN `sys_trans`
           ON `sys_trans`.`text`=`languages`.`name`
         LEFT JOIN `sys_trans_text`
           ON `sys_trans_text`.`trans_id`=`sys_trans`.`id`
           AND `sys_trans_text`.`lang`='&1'
         ORDER BY `name`",
        $opt['template']['locale'],
        $options['language']
    );
    $tpl->assign_rs('languageoptions', $rs);
    sql_free_result($rs);

The function sql_free_result() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

    $tpl->assign('all_languages', $options['language'] == '');

    $rs = sql('SELECT `id` FROM `cache_type` ORDER BY `ordinal`');

The function sql() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

    $rCachetypes = sql_fetch_assoc_table($rs);

$rs is of type object<mysqli_result>, but the function expects a resource.

The function sql_fetch_assoc_table() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

    foreach ($rCachetypes as &$rCachetype) {
        $rCachetype['checked'] =
            ($options['cachetype'] == '')
            || (strpos(
                ';' . $options['cachetype'] . ';',
                ';' . $rCachetype['id'] . ';'
            ) !== false);
        $rCachetype['unchecked'] = !$rCachetype['checked'];
    }
    $tpl->assign('cachetypes', $rCachetypes);
    $tpl->assign('cachetype', $options['cachetype']);

    $cachesizes = [];
    $rs = sql("SELECT `id` FROM `cache_size`");

The function sql() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

    while ($r = sql_fetch_assoc($rs)) {

The function sql_fetch_assoc() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

        $cachesizes[$r['id']]['checked'] =
            (strpos(
                ';' . $options['cachesize'] . ';',
                ';' . $r['id'] . ';'
            ) !== false)
            || ($options['cachesize'] == '');
    }
    sql_free_result($rs);

The function sql_free_result() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

    $tpl->assign('cachesizes', $cachesizes);
    $tpl->assign('cachesize', $options['cachesize']);

    // difficulty + terrain
    $tpl->assign('difficultymin', $options['difficultymin']);
    $tpl->assign('difficultymax', $options['difficultymax']);
    $tpl->assign('difficulty_options', [0, 2, 3, 4, 5, 6, 7, 8, 9, 10]);
    $tpl->assign('terrainmin', $options['terrainmin']);
    $tpl->assign('terrainmax', $options['terrainmax']);
    $tpl->assign('terrain_options', [0, 2, 3, 4, 5, 6, 7, 8, 9, 10]);

    $logtypes = [];
    if (isset($options['logtype'])) {
        $logtypes = explode(',', $options['logtype']);
    }

    $rs = sql(

The function sql() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

        "SELECT `id`,
                IFNULL(`sys_trans_text`.`text`, `log_types`.`name`) AS `name`,
                `id`='&2' AS `selected`
         FROM
            (SELECT `id`,`name`,`trans_id` FROM `log_types`
             UNION
             SELECT 0, 'all', (SELECT id FROM sys_trans WHERE `text`='all')
            ) `log_types`
         LEFT JOIN `sys_trans_text`
           ON `sys_trans_text`.`trans_id`=`log_types`.`trans_id`
           AND `sys_trans_text`.`lang`='&1'
         ORDER BY `log_types`.`id` ASC",
        $opt['template']['locale'],
        $logtypes ? $logtypes[0] : 0
    );

    $tpl->assign_rs('logtype_options', $rs);
    sql_free_result($rs);

The function sql_free_result() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

    // cache-attributes
    $attributes_jsarray = '';

    $bBeginLine2 = true;
    $nPrevLineAttrCount2 = 0;
    $nLineAttrCount2 = 0;
    $attributes_img2 = '';

    /* perpare 'all attributes' */
    $rsAttrGroup = sql(

The function sql() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

        "SELECT `attribute_groups`.`id`,
                IFNULL(`sys_trans_text`.`text`, `attribute_groups`.`name`) AS `name`,
                `attribute_categories`.`color`
         FROM `attribute_groups`
         INNER JOIN `attribute_categories`
           ON `attribute_groups`.`category_id`=`attribute_categories`.`id`
         LEFT JOIN `sys_trans`
           ON `attribute_groups`.`trans_id`=`sys_trans`.`id`
           AND `sys_trans`.`text`=`attribute_groups`.`name`
         LEFT JOIN `sys_trans_text`
           ON `sys_trans`.`id`=`sys_trans_text`.`trans_id`
           AND `sys_trans_text`.`lang`='&1'
         ORDER BY `attribute_groups`.`category_id` ASC, `attribute_groups`.`id` ASC",
        $opt['template']['locale']
    );
    while ($rAttrGroup = sql_fetch_assoc($rsAttrGroup)) {

The function sql_fetch_assoc() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

        $group_line = '';

        $rs = sql(

The function sql() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

            "SELECT `cache_attrib`.`id`,
                    IFNULL(`ttname`.`text`, `cache_attrib`.`name`) AS `name`,
                    `cache_attrib`.`icon_large`,
                    `cache_attrib`.`icon_no`,
                    `cache_attrib`.`icon_undef`,
                    `cache_attrib`.`search_default`,
                    IFNULL(`ttdesc`.`text`, `cache_attrib`.`html_desc`) AS `html_desc`
             FROM `cache_attrib`
             LEFT JOIN `sys_trans` AS `tname`
               ON `cache_attrib`.`trans_id`=`tname`.`id`
               AND `cache_attrib`.`name`=`tname`.`text`
             LEFT JOIN `sys_trans_text` AS `ttname`
               ON `tname`.`id`=`ttname`.`trans_id`
               AND `ttname`.`lang`='&1'
             LEFT JOIN `sys_trans` AS `tdesc`
               ON `cache_attrib`.`html_desc_trans_id`=`tdesc`.`id`
               AND `cache_attrib`.`html_desc`=`tdesc`.`text`
             LEFT JOIN `sys_trans_text` AS `ttdesc`
               ON `tdesc`.`id`=`ttdesc`.`trans_id`
               AND `ttdesc`.`lang`='&1'
             WHERE `cache_attrib`.`group_id` = '&2'
               AND `selectable`
               AND NOT IFNULL(`cache_attrib`.`hidden`, 0)=1
             ORDER BY `cache_attrib`.`id`",
            $opt['template']['locale'],
            $rAttrGroup['id']
        );
        while ($record = sql_fetch_array($rs)) {

$rs is of type object<mysqli_result>, but the function expects a resource.

The function sql_fetch_array() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

            // icon specified
            $line = $cache_attrib_jsarray_line;
            $line = mb_ereg_replace('{id}', $record['id'], $line);

            if (!isset($options['cache_attribs'])) {
                $line = mb_ereg_replace('{state}', 0, $line);
            } else {
                if (array_search($record['id'], $options['cache_attribs']) === false) {
                    if (array_search($record['id'], $options['cache_attribs_not']) === false) {
                        $line = mb_ereg_replace('{state}', 0, $line);
                    } else {
                        $line = mb_ereg_replace('{state}', 2, $line);
                    }
                } else {
                    $line = mb_ereg_replace('{state}', 1, $line);
                }
            }

            $line = mb_ereg_replace('{text_long}', escape_javascript($record['name']), $line);
            $line = mb_ereg_replace('{icon}', $record['icon_large'], $line);
            $line = mb_ereg_replace('{icon_no}', $record['icon_no'], $line);
            $line = mb_ereg_replace('{icon_undef}', $record['icon_undef'], $line);
            $line = mb_ereg_replace('{search_default}', $record['search_default'], $line);
            if ($attributes_jsarray != '') {
                $attributes_jsarray .= ",\n";
            }
            $attributes_jsarray .= $line;

            $line = $cache_attrib_img_line1;
            $line = mb_ereg_replace('{id}', $record['id'], $line);
            $line = mb_ereg_replace('{text_long}', escape_javascript($record['name']), $line);
            if (!isset($options['cache_attribs'])) {
                $line = mb_ereg_replace('{icon}', $record['icon_undef'], $line);
            } else {
                if (array_search($record['id'], $options['cache_attribs']) === false) {
                    if (array_search($record['id'], $options['cache_attribs_not']) === false) {
                        $line = mb_ereg_replace('{icon}', $record['icon_undef'], $line);
                    } else {
                        $line = mb_ereg_replace('{icon}', $record['icon_no'], $line);
                    }
                } else {
                    $line = mb_ereg_replace('{icon}', $record['icon_large'], $line);
                }
            }

            $line = mb_ereg_replace('{html_desc}', escape_javascript($record['html_desc']), $line);
            $line = mb_ereg_replace('{name}', escape_javascript($record['name']), $line);
            $line = mb_ereg_replace('{color}', $rAttrGroup['color'], $line);

            $group_line .= $line;
            $nLineAttrCount2++;
        }
        sql_free_result($rs);

The function sql_free_result() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

        if ($group_line != '') {
            $group_img = $cache_attrib_group;
            $group_img = mb_ereg_replace('{color}', $rAttrGroup['color'], $group_img);
            $group_img = mb_ereg_replace('{attribs}', $group_line, $group_img);
            $group_img = mb_ereg_replace(
                '{name}',
                htmlspecialchars($rAttrGroup['name'], ENT_COMPAT, 'UTF-8'),
                $group_img
            );

            if ($bBeginLine2 == true) {

It seems like you are loosely comparing two booleans. Considering using the strict comparison === instead.

                $attributes_img2 .= '<div id="attribs2">';
                $bBeginLine2 = false;
            }

            $attributes_img2 .= $group_img;
            $nPrevLineAttrCount2 += $nLineAttrCount2;

            $nLineAttrCount2 = 0;
        }
    }
    sql_free_result($rsAttrGroup);

The function sql_free_result() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

    if ($bBeginLine2 == false) {

It seems like you are loosely comparing two booleans. Considering using the strict comparison === instead.

        $attributes_img2 .= '</div>';
    }

    /* prepare default attributes */
    $bBeginLine1 = true;
    $nPrevLineAttrCount1 = 0;
    $nLineAttrCount1 = 0;
    $attributes_img1 = '';

    $rsAttrGroup = sql(

The function sql() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

        "SELECT `attribute_groups`.`id`,
                IFNULL(`sys_trans_text`.`text`, `attribute_groups`.`name`) AS `name`,
                `attribute_categories`.`color`
         FROM `attribute_groups`
         INNER JOIN `attribute_categories`
           ON `attribute_groups`.`category_id`=`attribute_categories`.`id`
         LEFT JOIN `sys_trans`
           ON `attribute_groups`.`trans_id`=`sys_trans`.`id`
           AND `sys_trans`.`text`=`attribute_groups`.`name`
         LEFT JOIN `sys_trans_text`
           ON `sys_trans`.`id`=`sys_trans_text`.`trans_id`
           AND `sys_trans_text`.`lang`='&1'
         ORDER BY `attribute_groups`.`category_id` ASC,
                  `attribute_groups`.`id` ASC",
        $opt['template']['locale']
    );
    while ($rAttrGroup = sql_fetch_assoc($rsAttrGroup)) {

The function sql_fetch_assoc() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

        $group_line = '';

        $rs = sql(

The function sql() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

            "SELECT `cache_attrib`.`id`,
                    IFNULL(`ttname`.`text`, `cache_attrib`.`name`) AS `name`,
                    `cache_attrib`.`icon_large`,
                    `cache_attrib`.`icon_no`,
                    `cache_attrib`.`icon_undef`,
                    `cache_attrib`.`search_default`,
                    IFNULL(`ttdesc`.`text`, `cache_attrib`.`html_desc`) AS `html_desc`
             FROM `cache_attrib`
             LEFT JOIN `sys_trans` AS `tname`
               ON `cache_attrib`.`trans_id`=`tname`.`id`
               AND `cache_attrib`.`name`=`tname`.`text`
             LEFT JOIN `sys_trans_text` AS `ttname`
               ON `tname`.`id`=`ttname`.`trans_id`
               AND `ttname`.`lang`='&1'
             LEFT JOIN `sys_trans` AS `tdesc`
               ON `cache_attrib`.`html_desc_trans_id`=`tdesc`.`id`
               AND `cache_attrib`.`html_desc`=`tdesc`.`text`
             LEFT JOIN `sys_trans_text` AS `ttdesc`
               ON `tdesc`.`id`=`ttdesc`.`trans_id`
               AND `ttdesc`.`lang`='&1'
             WHERE `cache_attrib`.`group_id`='&2'
               AND `cache_attrib`.`search_default` = 1
               AND `selectable`
               AND NOT IFNULL(`cache_attrib`.`hidden`, 0)=1
             ORDER BY `cache_attrib`.`id`",
            $opt['template']['locale'],
            $rAttrGroup['id']
        );
        while ($record = sql_fetch_array($rs)) {

$rs is of type object<mysqli_result>, but the function expects a resource.

The function sql_fetch_array() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

            $line = $cache_attrib_img_line2;
            $line = mb_ereg_replace('{id}', $record['id'], $line);
            $line = mb_ereg_replace('{text_long}', escape_javascript($record['name']), $line);
            if (!isset($options['cache_attribs'])) {
                $line = mb_ereg_replace('{icon}', $record['icon_undef'], $line);
            } else {
                if (array_search($record['id'], $options['cache_attribs']) === false) {
                    if (array_search($record['id'], $options['cache_attribs_not']) === false) {
                        $line = mb_ereg_replace('{icon}', $record['icon_undef'], $line);
                    } else {
                        $line = mb_ereg_replace('{icon}', $record['icon_no'], $line);
                    }
                } else {
                    $line = mb_ereg_replace('{icon}', $record['icon_large'], $line);
                }
            }

            $line = mb_ereg_replace('{html_desc}', escape_javascript($record['html_desc']), $line);
            $line = mb_ereg_replace('{name}', escape_javascript($record['name']), $line);
            $line = mb_ereg_replace('{color}', $rAttrGroup['color'], $line);

            $group_line .= $line;
            $nLineAttrCount1++;
        }
        sql_free_result($rs);

The function sql_free_result() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

        if ($group_line != '') {
            $group_img = $cache_attrib_group;
            $group_img = mb_ereg_replace('{color}', $rAttrGroup['color'], $group_img);
            $group_img = mb_ereg_replace('{attribs}', $group_line, $group_img);
            $group_img = mb_ereg_replace(
                '{name}',
                htmlspecialchars($rAttrGroup['name'], ENT_COMPAT, 'UTF-8'),
                $group_img
            );

            if ($bBeginLine1 == true) {

It seems like you are loosely comparing two booleans. Considering using the strict comparison === instead.

                $attributes_img1 .= '<div id="attribs1">';
                $bBeginLine1 = false;
            }

            $attributes_img1 .= $group_img;
            $nPrevLineAttrCount1 += $nLineAttrCount1;

            $nLineAttrCount1 = 0;
        }
    }
    sql_free_result($rsAttrGroup);

The function sql_free_result() has been deprecated with message: use DBAL Conenction instead. See adminreports.php for an example implementation

    if ($bBeginLine1 == false) {

It seems like you are loosely comparing two booleans. Considering using the strict comparison === instead.

        $attributes_img1 .= '</div>';
    }

    $tpl->assign('cache_attribCat1_list', $attributes_img1);
    $tpl->assign('cache_attribCat2_list', $attributes_img2);
    $tpl->assign('attributes_jsarray', $attributes_jsarray);
    $tpl->assign('hidopt_attribs', isset($options['cache_attribs']) ? implode(';', $options['cache_attribs']) : '');
    $tpl->assign(
        'hidopt_attribs_not',
        isset($options['cache_attribs_not']) ? implode(';', $options['cache_attribs_not']) : ''
    );

    $tpl->assign('fulltext', '');
    $tpl->assign('ft_desc_checked', true);
    $tpl->assign('ft_name_checked', true);
    $tpl->assign('ft_pictures_checked', false);
    $tpl->assign('ft_logs_checked', false);

    // fulltext options
    if ($options['searchtype'] == 'byfulltext') {
        if (!isset($options['fulltext'])) {
            $options['fulltext'] = '';
        }
        $tpl->assign('fulltext', htmlspecialchars($options['fulltext'], ENT_COMPAT, 'UTF-8'));

        if (isset($options['ft_name'])) {
            $tpl->assign('ft_name_checked', $options['ft_name'] == 1);
        }

        if (isset($options['ft_desc'])) {
            $tpl->assign('ft_desc_checked', $options['ft_desc'] == 1);
        }

        if (isset($options['ft_logs'])) {
            $tpl->assign('ft_logs_checked', $options['ft_logs'] == 1);
        }

        if (isset($options['ft_pictures'])) {
            $tpl->assign('ft_pictures_checked', $options['ft_pictures'] == 1);
        }
    }
    $tpl->assign('searchtype_byfulltext', $options['searchtype'] == 'byfulltext');

    //all
    $tpl->assign('searchtype_byall', $options['searchtype'] == 'all');
    
    // error messages
    $tpl->assign('ortserror', '');
    if (isset($options['error_plz'])) {
        $tpl->assign('ortserror', $error_plz);
    } elseif (isset($options['error_ort'])) {
        $tpl->assign('ortserror', $error_ort);
    } elseif (isset($options['error_locidnocoords'])) {
        $tpl->assign('ortserror', $error_locidnocoords);
    } elseif (isset($options['error_nowaypointfound'])) {
        $tpl->assign('ortserror', $error_nowaypointfound);
    } elseif (isset($options['error_nocoords'])) {
        $tpl->assign('ortserror', $error_nocoords);
    }

    $tpl->assign('fulltexterror', '');
    if (isset($options['error_nofulltext'])) {
        $tpl->assign('fulltexterror', $error_nofulltext);
    } else {
        if (isset($options['error_fulltexttoolong'])) {
            $tpl->assign('fulltexterror', $error_fulltexttoolong);
        }
    }

    $tpl->display();
}