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.")