Thank-o-matic to Elkarte Likes

Topic: Thank-o-matic to Elkarte Likes (Read 8531 times) previous topic - next topic

0 Members and 1 Guest are viewing this topic.

Thank-o-matic to Elkarte Likes

October 28, 2014, 07:13:37 pm

Hello,

is there any way to convert the "Thank you" from SMF mod Thank-o-matic to Elkarte likes?

Thank you in advance

Re: Thank-o-matic to Elkarte Likes

Reply #1 – October 29, 2014, 04:12:47 am

Do you mean the data in the database?

Re: Thank-o-matic to Elkarte Likes

Reply #2 – October 29, 2014, 07:21:56 am

Yep

Re: Thank-o-matic to Elkarte Likes

Reply #3 – October 30, 2014, 12:25:40 pm

The mod should be that one:
http://www.smfpersonal.net/mods/thankomatic-t3284.0.html

After a quick look at the mod install, it should be possible and not too difficult.
I think it could even be added directly to the importer as an optional step

Memo while I have the file open, the table is:
{db_prefix}thank_you_post
and contains the following fields:
id_thx_post
id_msg
id_topic
id_board
id_member
member_name
thx_time

The query to add to the importer may look something like:

Code: [Select]

SELECT th.id_member, th.id_msg, m.id_member AS id_poster, th.thx_time
FROM {$from_prefix}thank_you_post AS th
LEFT JOIN {$from_prefix}topics AS t ON (th.id_topic = t.id_topic)
LEFT JOIN {$from_prefix}messages AS m ON (th.id_first_msg = m.id_msg)

Then there is to recount all the likes per topic and per member.
@Spuds does the forum maintenance recount likes too?

Re: Thank-o-matic to Elkarte Likes

Reply #4 – October 30, 2014, 02:32:21 pm

I don't recall there being any, maybe a good thing to add to 1.02 or should that be 1.1? I'd guess for us topic counts could get messed up, like a split to new topic thing. Given/received, not sure how to validate that really, well received we can, not sure on given.

You would have to check the imported table for message_id's that were topic first message_id's and increment the topic table with the counts.

The member one, hummm, I'd guess the given is just the total of each id_member count in that table, the received would be the count of id_msg in that table on a per id_member basis (so all messages posted by member x). Thats a guess since I have not looked at the mod.

Re: Thank-o-matic to Elkarte Likes

Reply #5 – October 30, 2014, 06:31:02 pm

I didn't check deeply, but I think you are right.

Re: Thank-o-matic to Elkarte Likes

Reply #6 – November 18, 2014, 05:12:30 am

I know you guys have a lot of things to do, but are athere any news on this? thank you

Re: Thank-o-matic to Elkarte Likes

Reply #7 – November 19, 2014, 09:23:38 am

I have not been able to look into that one yet, sorry.

Re: Thank-o-matic to Elkarte Likes

Reply #8 – November 25, 2014, 09:27:49 am

https://github.com/emanuele45/openimporter/compare/likes
This should do the trick for the thank-o-matic/thank you mod.

emanuele should find in the meantime also the other like mods available in order to add importers as well.

Re: Thank-o-matic to Elkarte Likes

Reply #9 – November 25, 2014, 09:32:14 am

Jorin thinks emanuele should have a life!

You're a workaholic depending ElkArte! Please do not exaggerate!

Re: Thank-o-matic to Elkarte Likes

Reply #10 – November 25, 2014, 09:35:46 am

emanuele feels the same... from time to time.

Re: Thank-o-matic to Elkarte Likes

Reply #11 – November 25, 2014, 09:51:10 am

I can't belive what I'am seeing. I cannot test it now, but I'll try it soon.

Thank you Emanuele for your help!

Re: Thank-o-matic to Elkarte Likes

Reply #12 – November 25, 2014, 10:36:57 am

Quote from: emanuele – November 25, 2014, 09:27:49 amhttps://github.com/emanuele45/openimporter/compare/likes
This should do the trick for the thank-o-matic/thank you mod.

emanuele should find in the meantime also the other like mods available in order to add importers as well.

Whats the best way to do a mod to addon during the import (something that is not in the core)

For example the googlemap one, so if an SMF site thats being imported has that data, and the new site has installed the mod?

Re: Thank-o-matic to Elkarte Likes

Reply #13 – November 25, 2014, 10:50:17 am

At the moment OI doesn't have any way to detect if a table in the "destination" database exists.
It could (and probably should) be added, then you can add as much stuff as you want to any importer: detects if the tables (source/destination) exist and if so process the data.

Re: Thank-o-matic to Elkarte Likes

Reply #14 – November 25, 2014, 10:59:00 am

I tried the importer and all "thank you" are correctly imported into likes.

Is there a way to re-count the likes? I searched into Maintenance but I could not find it. All profiles have 0 likes given/received