Change "Thanks" into Rep Points - Can it be done?

[Zylantex]

I am considering changing from a "Thanks" based merit system to the standard Reputation points system.

The thing is, I don't want users to loose their current perceived status.
Is there any way to translate thanks into rep points to start users off with their current standing?

[Lynne]

If I recall, the thanks mod has it's own tables. So you would need to write a query to transfer all those 'points' to 'rep' points and also transfer any other necessary information from the thanks table to the reputation table. You are going to have to get a good understanding of his tables. So, I'd suggest getting into your database and seeing what is what in the Thanks tables and then doing the same in the Reputation tables.

[Zylantex]

Thanks Lynnne. We started work on that last night but we are not MYSQL experts by any means. We have managed to fill all fields except one. We can't figure out how to do it.

This is what we have so far using a temporary reputation table named rep_final. Once we have the last bit. transferring the records from rep_final to the permanent reputation table is straight forward.

INSERT INTO rep_final (whoadded, dateline, postid)
  SELECT userid, date, postid       
  FROM post_thanks;
UPDATE rep_final SET reputation = "1";
UPDATE rep_final SET reason = "Thanked Post";

The final field userid is obtained by reading the field postid in table post_thanks then finding the postid record in table posts and selecting the field userid from that record. This value should the be written as the userid field in rep_final.

I don't know how to write that query. If anyone could help me with it would be really great. Thanks.

--------------- Added 25 Mar 2011 at 15:15 ---------------

We figured it out finally. We also found out how to restore an emptied table from a backup, but that is another story. :erm:

If anybody is interested this is the final code. Please don't be tempted to do this unless you have some basic experience.

First we turned off the Post Thanks hack and the Reputation System via the AdminCP. Next using phpAdmin we emptied the reputation table. Then we ran this code.

INSERT INTO reputation (whoadded, dateline, postid)
SELECT userid, date, postid       
FROM post_thanks;

UPDATE reputation SET reputation = "1";

UPDATE reputation SET reason = "Thanked Post";

UPDATE reputation, post
SET reputation.userid = post.userid
WHERE post.postid = reputation.postid;

When it was finished we turned the Rep system back on and ran the update reputation counter in the AdminCP->Maintenance. Job done.


Thanks again for your help Lynne.

[Lynne]

Glad you got that sorted.