Need Member Karma Table info for phpmyadmin (semi-urgent)

[Andrew Evenstar]

I'm such a freaking noob... I just meant to empty out the karma stats for all users... but I mistakenly executed: :drop" on the karmaGood & KarmaBad tables, which made my site unavailable.

I re-created the tables, but can someone tell me the exact values I need to enter for them?



Also... can someone tell me how to correctly remove all the karma points (negative & positive) from all members?

Thanks.

[Jade Elizabeth]

Hey . 

The official install says this for the two rows you broke so make sure yours reflect that :

Code Select Expand

  karmaBad smallint(5) unsigned NOT NULL default '0',
  karmaGood smallint(5) unsigned NOT NULL default '0',

I think this should work out for you to change the karma of everyone .

Code Select Expand

UPDATE `smf_members` SET `karmaGood` = 0

And

Code Select Expand

UPDATE `smf_members` SET `karmaBad` = 0


but if you already deleted the two fields and then put them back they should be empty. Maybe run the recount all totals maintenance?

[Andrew Evenstar]

Wow, thank you so much.. you're awesome.

[Jade Elizabeth]

Lol thanks!

Glad I helped you out . Karma's something I use a lot. I use this query on my own forums when I add karma for competitions (you can use it to subtract too lol):

2.x:

Code Select Expand

UPDATE `smf_members` SET `karma_good` = (`karma_good` + '100') WHERE `id_member` IN (1,2,3)

1.x:

Code Select Expand

UPDATE `smf_members` SET `karmaGood` = (`karmaGood` + '100') WHERE `ID_MEMBER` IN (1,2,3)