OpencachingDeutschland / oc-server3

                $sql_select[] = '`caches`.`cache_id` `cache_id`';

                $sql_from = '`caches`';

                $sql_where[] = '`user_id`=\'' . sql_escape($options['ownerid']) . '\'';

            } else {

                $sql_select[] = '`caches`.`cache_id` `cache_id`';

                $sql_from = '`caches`';

                $sql_innerjoin[] = '`user` ON `caches`.`user_id`=`user`.`user_id`';

                $sql_where[] = '`user`.`username`=\'' . sql_escape($options['owner']) . '\'';

            }

        } elseif (($options['searchtype'] == 'byplz') || ($options['searchtype'] == 'byort')) {

            $locid = $options['locid'];

                }

                $sql_where[] = '`cache_logs`.`type` IN (' . $idNumbers . ')';

            }

        } elseif ($options['searchtype'] == 'bycacheid') {

            $sql_select[] = '`caches`.`cache_id` `cache_id`';

            $sql_from = '`caches`';

            $sql_where[] = '`caches`.`cache_id`=\'' . sql_escape($options['cacheid']) . '\'';

        } elseif ($options['searchtype'] == 'bywp') {

            $sql_select[] = '`caches`.`cache_id` `cache_id`';

            $sql_from = '`caches`';

            $sql_where[] = '`caches`.`wp_oc`=\'' . sql_escape($options['wp']) . '\'';

        if (!isset($options['adm2'])) {

            $options['adm2'] = '';

        }

        if ($options['adm2'] != '') {

            $sql_innerjoin[] = '`cache_location` ON `cache_location`.`cache_id`=`caches`.`cache_id`';

            $sql_where[] = '`cache_location`.`code2`=\'' . sql_escape($options['adm2']) . '\'';

        }

        if ($options['cachetype'] != '') {

            $types = explode(';', $options['cachetype']);

        if ($options['terrainmax'] != 0) {

            $sql_where[] = '`caches`.`terrain`<=\'' . sql_escape($options['terrainmax']) . '\'';

        }

        if ($options['recommendationmin'] > 0) {

            $sql_innerjoin[] = '`stat_caches` ON `caches`.`cache_id`=`stat_caches`.`cache_id`';

            $sql_where[] = '`stat_caches`.`toprating`>=\'' . sql_escape($options['recommendationmin']) . '\'';

        }

        if (isset($options['cache_attribs']) && count($options['cache_attribs']) > 0) {

            foreach ($options['cache_attribs'] as $attr) {