// database settings

$db_host = "localhost";

$db_user = "adatbázisfelhasználónév";

$db_pass = "jelszó";

$db_name = "adatbázisneve";

$db_prefix = "fusion58Hh8_";

define("DB_PREFIX", "fusion58Hh8_");

define("COOKIE_PREFIX", "fusion5ny7p_");

--

-- Adatbázis: adatbázisomneve

--



-- --------------------------------------------------------



--

-- Tábla szerkezet: fusion58Hh8_admin

--



CREATE TABLE IF NOT EXISTS fusion58Hh8_admin (

 admin_id mediumint(8) unsigned NOT NULL AUTO_INCREMENT,

 admin_rights char(4) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '',

 admin_image varchar(50) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '',

 admin_title varchar(50) COLLATE utf8_hungarian_ci NOT NULL DEFAULT '',

 admin_link varchar(100) COLLATE utf8_hungarian_ci NOT NULL DEFAULT 'reserved',

 admin_page tinyint(1) unsigned NOT NULL DEFAULT '1',

 PRIMARY KEY (admin_id)

) ENGINE=MyISAM DEFAULT CHARSET=utf8 COLLATE=utf8_hungarian_ci AUTO_INCREMENT=83 ;



--

-- A tábla adatainak kiíratása fusion58Hh8_admin

--

<IfModule mod_setenvifno.c>



SetEnvIfNoCase Referer doobu.com spammer=yes

SetEnvIfNoCase Referer viagra spammer=yes

SetEnvIfNoCase Referer hivizag spammer=yes

SetEnvIfNoCase Referer wotlabs.net spammer=yes

SetEnvIfNoCase Referer jewels spammer=yes

SetEnvIfNoCase Referer blessbug spammer=yes

SetEnvIfNoCase User-Agent "^libwww-perl*" spammer=yes



   SetEnvIfNoCase ^User-Agent$ .*(craftbot|download|extract|stripper|sucker|ninja|clshttp|webspider|leacher|collector|grabber|webpictures) HTTP_SAFE_BADBOT

   SetEnvIfNoCase ^User-Agent$ .*(libwww-perl|aesop_com_spiderman) HTTP_SAFE_BADBOT

 SetEnvIfNoCase ^User-Agent$ .*(almaden|Anarchie|ASPSeek|attach|autoemailspider|BackWeb|Bandit|BatchFTP|BlackWidow|Bot mailto:craftbot@yahoo.com|Buddy|bumblebee|CherryPicker|ChinaClaw|CICC|Collector|Copier|Crescent|Custo|DA|DIIbot|DISCo|DISCo Pump|Download Demon|Download Wonder|Downloader|Drip|DSurf15a|eCatch|EasyDL/2.99|EirGrabber|EmailCollector|EmailSiphon|EmailWolf|Express WebPictures|ExtractorPro|EyeNetIE|FileHound|FlashGet|GetRight|GetSmart|GetWeb!|gigabaz|Go!Zilla|Go!Zilla|Go-Ahead-Got-It|gotit|Grabber|GrabNet|Grafula|grub-client|HMView|HTTrack|httpdown|ia_archiver|Image Stripper|Image Sucker|Indy*Library|InterGET|InternetLinkagent|Internet Ninja|InternetSeer.com|Iria|JBH*agent|JetCar|JOC Web Spider|JustView|larbin|LeechFTP|LexiBot|lftp|Link*Sleuth|likse|Link|LinkWalker|Mag-Net|Magnet|Mass Downloader|Memo|Microsoft.URL|MIDown tool|Mirror|Mister PiX|Mozilla.*Indy|Mozilla.*NEWT|Mozilla*MSIECrawler|MS FrontPage*|MSFrontPage|MSIECrawler|MSProxy|Navroad|NearSite|NetAnts|NetMechanic|NetSpider|Net Vampire|NetZIP|NICErsPRO|Ninja|Octopus|Offline Explorer|Offline Navigator|Openfind|PageGrabber|Papa Foto|pavuk|pcBrowser|Ping|PingALink|Pockey|psbot|Pump|QRVA|RealDownload|Reaper|Recorder|ReGet|Scooter|Seeker|Siphon|sitecheck.internetseer.com|SiteSnagger|SlySearch|SmartDownload|Snake|SpaceBison|sproose|Stripper|Sucker|SuperBot|SuperHTTP|Surfbot|Szukacz|tAkeOut|Teleport Pro|URLSpiderPro|Vacuum|VoidEYE|Web Image Collector|Web Sucker|WebAuto|[Ww]eb[Bb]andit|webcollage|WebCopier|Web Downloader|WebEMailExtrac.*|WebFetch|WebGo IS|WebHook|WebLeacher|WebMiner|WebMirror|WebReaper|WebSauger|Website|Website eXtractor|Website Quester|Webster|WebStripper|ebWhacker|WebZIP|Wget|Whacker|Widow|WWWOFFLE|x-Tractor|Xaldon WebSpider|Xenu|Zeus.*Webster|Zeus) HTTP_SAFE_BADBOT

   Deny from env=HTTP_SAFE_BADBOT

</IfModule>

# -------------------------------------------------------

# Free IP2Location Firewall List by Country - [b]China[/b]

# Source: https://www.ip2location.com/free/visitor-blocker

# Last Generated: 16 Jun 2024 20:31:14 GMT

# [Important] Please update this list every month

# -------------------------------------------------------



order allow,deny

allow from all

deny from 1.0.1.0/24

deny from 1.0.2.0/23

stb.

stb.

) TYPE=MyISAM;";

) ENGINE=MyISAM DEFAULT CHARSET=UTF8 COLLATE=utf8_unicode_ci";

if (isset($_POST['save'])) {



   $filtergenre = '';

   for ($a=0; $a<count($_POST['filtergenre']); $a++) {

      $filtergenre .= '.';

      $filtergenre .= $_POST['filtergenre'][$a];

   }



   if (dbcount("(tmp_id)", DB_PREFIX."fusion_pdp_genres_tmp", "tmp_user_id='".$userdata['user_id']."'")) {

      $update = dbquery("UPDATE ".DB_PREFIX."fusion_pdp_genres_tmp SET tmp_genres_id = '".$filtergenre."' WHERE tmp_user_id = '".$userdata['user_id']."' ");

   } else {

      $insert = dbquery("INSERT INTO ".DB_PREFIX."fusion_pdp_genres_tmp (tmp_user_id, tmp_genres_id) VALUES ('".$userdata['user_id']."','".$filtergenre."') ");

   }



}

$result = dbarray(dbquery("SELECT tmp_genres_id FROM ".DB_PREFIX."fusion_pdp_genres_tmp WHERE tmp_user_id = '".$userdata['user_id']."' "));

   $user_groups = strpos($result['tmp_genres_id'], ".") == 0 ? substr($result['tmp_genres_id'], 1) : $result['tmp_genres_id'];

   $user_groups = explode(".", $user_groups);



   $rmufaj = dbquery("SELECT * FROM ".DB_PREFIX."fusion_pdp_genres ORDER BY genre_name");

   $counter = 0; $r = 0; $k = 0;

   while ($mufaj = dbarray($rmufaj)) {



      if ($counter != 0 && ($counter % 5 == 0)) { echo "</tr><tr>"; }



      if (in_array($mufaj['genre_id'], $user_groups)) {

         $checked = "checked='checked'";

      } else {

         $checked = "";

      }

      echo "<td width='20%' height='18'>&nbsp;<input type='checkbox' name='filtergenre[]' value='".$mufaj['genre_id']."' ".$checked." /> ".$mufaj['genre_name']."</td>";

      $counter++; $k++;



   }

          $rmufaj = dbquery("SELECT * FROM fusion_pdp_genres ORDER BY genre_name");

          $counter = 0; $r = 0; $k = 1;

          while ($mufaj = dbarray($rmufaj)) {

          if ($counter != 0 && ($counter % 5 == 0)) { echo "</tr>n<tr>n"; }



            $checked = "";

            echo "<td width='20%' height='18'>&nbsp;<input type='checkbox' name='filtergenre[]' value='".$mufaj['genre_id']."' ".$checked." /> ".$mufaj['genre_name']."</td>";

          $counter++; $k++;



          }