Karma - How do I reset karma totals to zero: Difference between revisions From Online Manual

Jump to: navigation, search
m (Query is slightly different for 2.0)
No edit summary
Line 3: Line 3:
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:
{{version specific|version=1.x
{{version specific|version=1.x
|content={{code|1=UPDATE prefix_members
}}
 
{{code|1=UPDATE prefix_members
SET karmaGood = 0, karmaBad = 0;
SET karmaGood = 0, karmaBad = 0;
}}
}}
{{version specific|version=2.x
}}
}}


{{version specific|version=2.x
{{code|1=UPDATE prefix_members
|content={{code|1=UPDATE prefix_members
SET karma_good = 0, karma_bad = 0;
SET karma_good = 0, karma_bad = 0;
}}
}}
}}



Revision as of 18:09, 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_.



Advertisement: