Difference between revisions of "Karma - How do I reset karma totals to zero"

From Online Manual

Jump to: navigation, search
m (Query is slightly different for 2.0)
Line 2: Line 2:
  
 
To do so, login to your phpMyAdmin and select your forum database from the left panel and ''Query'' from the right panel. In the SQL-query box enter the following query:
 
To do so, login to your phpMyAdmin and select your forum database from the left panel and ''Query'' from the right panel. In the SQL-query box enter the following query:
{{code|1=UPDATE prefix_members
+
{{version specific|version=1.x
 +
|content={{code|1=UPDATE prefix_members
 
SET karmaGood = 0, karmaBad = 0;
 
SET karmaGood = 0, karmaBad = 0;
 +
}}
 +
}}
 +
 +
{{version specific|version=2.x
 +
|content={{code|1=UPDATE prefix_members
 +
SET karma_good = 0, karma_bad = 0;
 +
}}
 
}}
 
}}
  

Revision as of 13:06, 22 May 2013

Currently you need to run a query from phpMyAdmin to reset the karma totals on your forum.

To do so, login to your phpMyAdmin and select your forum database from the left panel and Query from the right panel. In the SQL-query box enter the following query:

UPDATE prefix_members
SET karmaGood = 0, karmaBad = 0;
UPDATE prefix_members
SET karma_good = 0, karma_bad = 0;

Replace prefix with the prefix your forum uses for its SQL tables. By default this is smf_.