OpencachingDeutschland / oc-server3

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

        }

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

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

            if (count($types) < sql_value_slave("SELECT COUNT(*) FROM `cache_type`", 0)) {

                $countTypes = count($types);

                for ($i = 0; $i < $countTypes; $i++) {

                    $types[$i] = "'" . sql_escape($types[$i]) . "'";

                }

                $sql_where[] = '`caches`.`type` IN (' . implode(',', $types) . ')';

            }

        }

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

            $sizes = explode(';', $options['cachesize']);

            }

        }

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

            $sizes = explode(';', $options['cachesize']);

            if (count($sizes) < sql_value_slave('SELECT COUNT(*) FROM `cache_size`', 0)) {

                $countSizes = count($sizes);

                for ($i = 0; $i < $countSizes; $i++) {

                    $sizes[$i] = "'" . sql_escape($sizes[$i]) . "'";

                }

                $sql_where[] = '`caches`.`size` IN (' . implode(',', $sizes) . ')';

            }

        }

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

            $sql_where[] = '`caches`.`difficulty`>=\'' . sql_escape($options['difficultymin']) . '\'';