By Eddie593 on Sunday, 31 August 2014
Replies 10
Likes 0
Views 876
Votes 0
How can we monitor the conversations between members on the site??
If that's the case, you can view all the messages via that query I gave. I believe easysocial won't approve this even if requested due to privacy and trust issues. If you need something custom coded, I can help you with that.
Ken
·
Monday, 01 September 2014 07:40
·
0 Likes
·
0 Votes
·
0 Comments
·
As of this moment, there's no way to view it via admin (as I'm aware of) but you can run this query in your database


SELECT
#_social_conversations_participants.id,
#_social_conversations_participants.conversation_id,
#_social_conversations_participants.user_id,
#_social_conversations_participants.state,
#_social_conversations_message.id,
#_social_conversations_message.conversation_id,
#_social_conversations_message.type,
#_social_conversations_message.message,
#_social_conversations_message.created,
#_social_conversations_message.created_by
FROM
#_social_conversations_message
INNER JOIN #_social_conversations_participants ON #_social_conversations_participants.conversation_id = #_social_conversations_message.conversation_id

Ken
·
Sunday, 31 August 2014 02:33
·
0 Likes
·
0 Votes
·
0 Comments
·
Hello Eddie,

As posted above, there is no way to monitor conversations within members and to be honest, I don't think it's a good idea to do that? What about their privacy?
·
Sunday, 31 August 2014 14:34
·
0 Likes
·
0 Votes
·
0 Comments
·
Yes, privacy is a big issue here, that's why it's called private message.
Ken
·
Sunday, 31 August 2014 15:52
·
0 Likes
·
0 Votes
·
0 Comments
·
Yeah I wouldn't use your site if I know that you are reading my private messages Heck, I don't know what I would do if Skype is reading all our messages, haha.
·
Sunday, 31 August 2014 22:41
·
0 Likes
·
0 Votes
·
0 Comments
·
Thats weird i thought i had answered already. I understand totally the issue of privacy. The thing is that on our website we have an acceptable use policy. This policy is there to protect our users from all kinds of situations, including soliciting, giving out contact info of the platform, spamming or even scams. We need to make sure our users are working in a safe environment. And we have to be able to detect malicious behaviour, many websites work like that. Such as Homeaway, Flipkey, airbnb etc etc. Maybe you can implement a filter for words that are not allowed? And an alert if thats happening?

Our users are aware they are in a controlled website and they agree to that.
·
Monday, 01 September 2014 07:16
·
0 Likes
·
0 Votes
·
0 Comments
·
Awesome thanks Ken, i will try the query and maybe you can contact me about how to custom code that for us? Theres a few more things we might need
·
Monday, 01 September 2014 07:47
·
0 Likes
·
0 Votes
·
0 Comments
·
Please feel free to contact me via email at hacksider@gmail.com . Just to inform this will be a custom application and is not supported by stackideas (as per mark usually say). You will get support on our side instead, warm regards!
Ken
·
Monday, 01 September 2014 08:03
·
0 Likes
·
0 Votes
·
0 Comments
·
Thanks Ken and Mark for the great help. Ken i will drop you an email now.
·
Monday, 01 September 2014 09:06
·
0 Likes
·
0 Votes
·
0 Comments
·
No problem Eddie
·
Monday, 01 September 2014 11:05
·
0 Likes
·
0 Votes
·
0 Comments
·
View Full Post