Create a blacklist:

Much is being spotted on spotweb. Unfortunately, there is sometimes some spam. With this php script you can create a blacklist.

In your web dir create a .php file.

In my case reportcount.php

my_mysqlserver","db_username","db_password"); mysql_select_db("db_name", $con); // SEARCH ALL ID WITH 3 OR MORE REPORTS AND FILTER DOUBLE ID'S . $result = mysql_query("SELECT DISTINCT `spotterid` FROM spots WHERE reportcount > 3"); while ($row = mysql_fetch_array($result)) { $last = end($row); $num = mysql_num_fields($result) ; for($i = 0; $i < $num; $i++){ fwrite($fh, $row[$i]); if ($row[$i] != $last) fwrite($fh, ", "); echo $row["spotterid"]. "
"; } fwrite($fh, "\n"); } fclose($fh); Change the red text to your own settings. Wen running sudo php reportcount.php list.txt wil be generated. In your Spotweb database table whitelist_url change the default url to your own. in my case https://domain.nl/list.txt run a sudo php retreve.php and check if there are spotterid’s added. “Finished updating blacklist. Added 2, removed 0, skipped 2 of 252 lines.” Download Spotweb here: [Click](https://github.com/spotweb/spotweb) Spotweb is a decentralized usenet community based on the [Spotnet](https://github.com/spotnet/spotnet/wiki) protocol. Spotweb requires an operational webserver with PHP5 installed, it uses either an MySQL or an PostgreSQL database to store it’s contents in. ## [](https://github.com/spotweb/spotweb#features)Features Spotweb is one of the most-featured Spotnet clients currently available, featuring among other things: - Fast - Customizable filter system from within the system - Posting of comments and spots - Showing and filtering on new spots since the last view - Watchlist - Easy to download multiple files - Runs on NAS devices like Synology and qnap - Rating of spots - Integration with [Sick beard](http://www.sickbeard.com/) and [CouchPotato](http://couchpotatoapp.com/) as a ‘newznab’ provider - Platform independent (reported to work on Linux, *BSD and Windows) - Both central as user-specific blacklist support built-in - Spam reporting - Easy layout customization by providing custom CSS - Boxcar/Growl/Notify My Android/Notify/Prowl and Twitter integration (*) - Spot statistics on your system - Sabnzbd and nzbget(*) integration - Multi-language (*) - Multiple-user ready (*) - Opensource and open development model (*) (*) Unique feature among all known Spotnet clients