Resetting hits, visits, votes and reviews.

You can use the following SQL queries to reset Unique Pageviews, Website Clicks, Votes and Reviews. This is useful when you gathered these data during development phase and wish to reset it before deploying your directory to a live site:

// Reset Unique Pageviews
UPDATE jos_mt_links SET link_hits = 0;

// Reset Website Clicks
UPDATE jos_mt_links SET link_visited = 0;

// Reset Votes
UPDATE jos_mt_links SET link_votes = 0, link_rating = 0;
DELETE FROM jos_mt_log WHERE log_type = 'vote';

// Reset Reviews
TRUNCATE TABLE jos_mt_reviews;
DELETE FROM jos_mt_log WHERE log_type IN ('review','replyreview','votereview');
Was this article helpful?