Skip to content

Instantly share code, notes, and snippets.

@kaibosh
kaibosh / recat-tv.sql
Created July 16, 2017 22:12
recategorise shows that end up in movies cats based on episode string
update releases set categories_id = 5020 where searchname like '%s0_e__%' and categories_id = 2010 and passwordstatus = 0;
update releases set categories_id = 5020 where searchname like '%s1_e__%' and categories_id = 2010 and passwordstatus = 0;
update releases set categories_id = 5020 where searchname like '%s2_e__%' and categories_id = 2010 and passwordstatus = 0;
update releases set categories_id = 5030 where searchname like '%s0_e__%' and categories_id = 2030 and passwordstatus = 0;
update releases set categories_id = 5030 where searchname like '%s1_e__%' and categories_id = 2030 and passwordstatus = 0;
update releases set categories_id = 5030 where searchname like '%s2_e__%' and categories_id = 2030 and passwordstatus = 0;
update releases set categories_id = 5040 where searchname like '%s0_e__%' and categories_id = 2040 and passwordstatus = 0;
update releases set categories_id = 5040 where searchname like '%s1_e__%' and categories_id = 2040 and passwordstatus = 0;
update releases set categories_id = 5040
@kaibosh
kaibosh / helper-new.sh
Last active February 7, 2017 10:19
helper.sh with showsleep
#!/bin/sh
if [ -e "nZEDbBase.php" ]
then
export NZEDB_ROOT="$(pwd)"
else
export NZEDB_ROOT="$(php ../../../../../nZEDbBase.php)"
fi
export NZEDB_PATH="${NZEDB_ROOT}/misc/update"
@kaibosh
kaibosh / php-yenc-fedora.txt
Last active January 20, 2017 09:59
php-yenc for fedora - compile howto
dnf groupinstall "Development Tools" "C Development Tools and Libraries"
dnf install gcc re2c php-devel pcre-devel
mkdir tmpdir # where ever you like
cd tmpdir
git clone https://github.com/phalcon/zephir
cd zephir
./install -c # calls sudo
zephir help # tests zephir install
cd .. # leave zephir dir
@kaibosh
kaibosh / New-ReadMe.md
Last active January 11, 2017 23:03
new readme paragraph

Usenet is a data river currently flowing at around 25TB per day. nZEDb leverages advanced data mining techniques to peer into this vast amount of data and locate possible items of interest. Similar to the way a fisherman would use sonar to locate fish.

It does this by collecting usenet headers and temporarily storing them in a database until they can be collated into releases. It provides a web-based front-end providing search, browse, and programmable (API) functionality.

This project is a fork of the open source usenet indexer newznab plus: https://github.com/anth0/nnplus

nZEDb improves upon the original design, implementing several new features including:

Optional multi-threaded processing (header retrieval, release creation, post-processing etc)

Advanced search features (name, subject, category, post-date etc)

@kaibosh
kaibosh / CouchPotato-tuning-test.txt
Created January 11, 2017 18:06
CouchPotato tuning for fast CPUs
# CouchPotato Tuning - slow down provider calls when using fast CPUs
# stop CP
vi CouchPotatoServer/couchpotato/core/_base/downloader/main.py
# http_time_between_calls = 3
rm CouchPotatoServer/couchpotato/core/_base/downloader/main.pyc
vi CouchPotatoServer/couchpotato/core/media/_base/providers/nzb/newznab.py
# http_time_between_calls = 3 # Seconds