Dragonfly CMS v9 ⇒ Downloads Pro ⇒ Reset Top 5 Downloads ⇒ Community Forums ⇒ CPG Dragonfly™ CMS
Forum Index Modules & Blocks Downloads Pro

Reset Top 5 Downloads Reply to topic


I've deleted a load of downloads. Is there an easy way to reset the top 5 downloads or do I need to clear out the stats table for downloads and start again?

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):


1. Create backup
2. then try:
DELETE FROM cms_downloads_broken WHERE download_id NOT IN (SELECT download_id FROM cms_downloads_downloads); DELETE FROM cms_downloads_history WHERE download_id NOT IN (SELECT download_id FROM cms_downloads_downloads); DELETE FROM cms_downloads_mirrors WHERE download_id NOT IN (SELECT download_id FROM cms_downloads_downloads); DELETE FROM cms_downloads_ratings WHERE download_id NOT IN (SELECT download_id FROM cms_downloads_downloads); DELETE FROM cms_downloads_screenshots WHERE download_id NOT IN (SELECT download_id FROM cms_downloads_downloads); DELETE FROM cms_downloads_stats WHERE download_id NOT IN (SELECT download_id FROM cms_downloads_downloads);

Server specs (Server OS / Apache / MySQL / PHP / DragonflyCMS):
Fedora 25 / Apache 2.4.27 / MariaDB 10.1.26 / PHP 7.1.10 / Mercurial

All times are UTC


Jump to: