Resource icon

Unmaintained Prune all likes (queries)

Compatible XF 1.x versions
  1. 1.0
  2. 1.1
  3. 1.2
  4. 1.3
  5. 1.4
Description: an example of SQL-queries to prune all likes.

Before you perform any action with the database, don't forget to backup!

Queries are executed sequentially:
PHP:
DELETE FROM xf_liked_content;
PHP:
UPDATE xf_user AS u
SET like_count = (
   SELECT COUNT(*)
   FROM xf_liked_content AS lc...
You do not have permission to view the full content of this resource. Log in or register now.
  • Like
Reactions: sinucello
Author
GliX
Views
155
First release
Last update
Rating
0.00 star(s) 0 ratings

More resources from GliX

Top