m (moved Karma - How do I reset karma totals to zero? to Karma - How do I reset karma totals to zero: Bot: Moved page) |
Oldiesmann (talk | contribs) 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 18: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:
The following applies only to version 1.x |
UPDATE prefix_members SET karmaGood = 0, karmaBad = 0;
The following applies only to version 2.x |
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_.