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)
mNo edit summary
 
(6 intermediate revisions by 2 users not shown)
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:
{{version specific|version=1.x
{{version specific|version=1.1.x
|content={{code|1=UPDATE prefix_members
}}
 
{{code|1=UPDATE smf_members
SET karmaGood = 0, karmaBad = 0;
SET karmaGood = 0, karmaBad = 0;
}}
}}
{{version specific|version=2.0.x
}}
}}


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


Replace ''prefix'' with the prefix your forum uses for its SQL tables. By default this is ''smf_''.
Replace the prefix 'smf_' with your custom prefix if not using the default.


<noinclude>[[category:FAQ]]</noinclude>
<noinclude>[[category:FAQ]]</noinclude>

Latest revision as of 09:35, 3 September 2015

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 smf_members
SET karmaGood = 0, karmaBad = 0;
UPDATE smf_members
SET karma_good = 0, karma_bad = 0;

Replace the prefix 'smf_' with your custom prefix if not using the default.



Advertisement: