How to reset all forum member's reputation to 0?

[RooMac]

Hi all,

I've migrated from vBulletin 4.x to IPS 4.1.13.1 and I need to do afresh start for all members (all groups). So, I need to reset the reputation levels of all users to 0. How can I do it? I can't find any option in ACP or with any third-party app in Marketplace. Somebody please guide me how to do that? If there is a need execute some MySQL query, I'm happy to do that.

P.S. IPS support said they can't tell us any such option via MySQL query since nothing in this regard has been tested by them.

Thanks,

Peter

[MDPP]

You could always do something like this in MySQL:

UPDATE `database`.`core_members` SET  `pp_reputation_points` =  '0';

This isn't a complete wipe, but it will do what you're asking.  You'll need to clear the forum cache afterwards through the Support tool. I tested it on my account and my profile said that my reputation was "0" immediately.

It may also benefit you to wipe ("truncate") the "core_reputation_index" table.

[RooMac]

@MDPP 

I executed the query from Cpanel's phpMyadmin to the forum's database. Cleared the cache from ACP and then recount "Reputations for all members".

Thanks. Works like a charm!

[RooMac]

@MDPP

Is there a way, we can reset/remove Member Titles of all members? Reason why we've revamped the forum structure and want the titles to be renewed. An SQL query will be helpful.

[MDPP]

46 minutes ago, Peter Sowerby said:

@MDPP

Is there a way, we can reset/remove Member Titles of all members? Reason why we've revamped the forum structure and want the titles to be renewed. An SQL query will be helpful.

Hm, maybe this would help?

UPDATE `database`.`core_members` SET  `member_title` = '';

 

[xtech]

Hi everyone

how can this be made for 4.2? Clean all the reputation?

Regards