def cleanOldReleases(): query = "DELETE FROM `pi_releases` WHERE `added_at` < DATE_SUB(NOW(), INTERVAL " + autocleaner_expire + ")" res = vh.SQL(query) if res: return True else: return False
def deleteReleaseById(idno): query = "DELETE FROM `pi_releases` WHERE `id`='" + idno + "' LIMIT 1" res = vh.SQL(query) if res: return True else: return False
def getCategoriesList(): query = "SELECT `name` FROM `pi_rel_categories`" res, rows = vh.SQL(query) if res: return rows else: return None
def getReleaseDownloader(idno): query = "SELECT `added_by` FROM `pi_releases` WHERE `id`=" + idno + " LIMIT 1" res, rows = vh.SQL(query) if res: if rows != None: return rows[0] else: return None
def addRelease(cat, text, nick): query = "INSERT INTO `pi_releases` (`category`, `text`, `added_by`) VALUES ('" + cat[ 0] + "','" + text + "','" + nick + "')" res = vh.SQL(query) if res: return True else: return False
def getReleasesByCategory(cat): query = "SELECT `id`, `added_at`,`text`,`added_by` FROM `pi_releases` WHERE `category`='" + cat[ 0] + "' ORDER BY `added_at`" res, rows = vh.SQL(query) if res: return rows else: return None
def initSetupCheck(): report('Running init check.') query = "SHOW TABLES LIKE 'pi_rel_categories'" res, rows = vh.SQL(query) if res: if rows == None: report("Release categories table not found. Creating default one.") query = """CREATE TABLE `pi_rel_categories` ( `id` int(11) NOT NULL AUTO_INCREMENT, `name` varchar(20) NOT NULL, PRIMARY KEY (`id`) )""" res = vh.SQL(query) if res: query = """INSERT INTO `pi_rel_categories` (`name`) VALUES ('MOVIES'), ('SERIES'), ('MUSIC'), ('GAMES'), ('APPS'), ('OTHERS')""" res = vh.SQL(query) if res: report("Categories table created.") else: report("Categories table found.") query = "SHOW TABLES LIKE 'pi_releases'" res, rows = vh.SQL(query) if res: if rows == None: report("Releases table not found. Creating default one.") query = """CREATE TABLE `pi_releases` ( `id` int(11) NOT NULL AUTO_INCREMENT, `added_at` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP, `category` varchar(20) NOT NULL, `text` text, `added_by` varchar(100) DEFAULT NULL, PRIMARY KEY (`id`) )""" res = vh.SQL(query) if res: report("Releases table created.") else: report("Releases table found.") report("Loaded successfully. Type +relhelp for help.")