[SOLVED] Send email on visit

Hi

I would like to send an email to the user who is visited by another one.
I thought using CB Auto Action but there is no trigger on visit.
How can I do that simply ?

Thank you.

I really really suggest you don't do this. You'll be spamming people with emails. Your domain will be forever blacklisted by mail servers and all your emails will go to spam folder. At any rate yes it's doable with CB Auto Actions and its Email action on the before or after profile display triggers.

Thank you. You're right but i will do this on 'unique' case (only the first time user visits another one)

To do that, I create a query field cb_visitors with this query :

SELECT profile_id FROM `jsor_comprofiler_views` AS v WHERE v.`viewer_id` = [id]
I've tried also SELECT profile_id FROM `jsor_comprofiler_views` AS v WHERE v.`viewer_id` = '[user_id]'


Then, in CB AutoAction this condition :

[cb_visitors] Does Not Contain [cb:userdata field="user_id" user="#displayed" /]


Unfortunitly It doesn't work.

Can you help me on my error ?

thank you.

Your query is just checking that the profile user has viewed themselves. You need to check if the viewing user has viewed the displayed user. Substitutions by default are always for the displayed user when used in a CB Query Field. To get the user id of the viewing user you need to use [cb:userdata field="user_id" user="#me" /]. When acting on the profile display triggers with User set to Automatic your subscriptions in that action will also target the displayed user and not the viewing user so your substitutions need to use user="#me" to get viewing user profile data.

I have no problem with the 'action'.
(I would like to send email (the action) before profile display (the trigger), only if it is the first time that the viewer visit the profile)

So, i try a new cb query cb_visitors :

( SELECT  COUNT(*) FROM `#__comprofiler_views` AS v WHERE v.`profile_id`= '[cb:userdata field="user_id" user="#displayed" /]' AND v.`viewer_id` = '[cb:userdata field="user_id" user="#me" /]')

This, return 0 if no visit between the viewer and the profile, and return 1 if already a visit between us (this seems to work)


and in the CB AutoAction CONDITIONS :

[cb:userdata field="cb_visitors" user="#displayed" /] equal 0
and it doesn't work.

So I try to understand the reason, I put on my email these data :
[cb:userdata field="cb_visitors" user="#me" /]
[cb:userdata field="cb_visitors" user="#displayed" /]
[cb:userfield field="cb_visitors" user="#me" /]
[cb:userfield field="cb_visitors" user="#displayed" /]
[cb_visitors]
With trigger BeforeProfileDisplay All are equal to 0 and with trigger AfterProfileDisplay All are equal to 1.
How to test (condition) the good value (real result of the query) ?