Support forum
7:30 pm
someone could give an explanation or example of how to trigger in mysql in messagein to see which was the last message sent in messageLog with the same number
Hello Luã,
I am sorry that I cannot give a good answer to this question. I am not a database expert and I have very little experience in writing database triggers.
Regards, Henk
1:21 pm
could you give an example of how to make this trigger because I tried here but I could not
The SMS system does not have a reliable way to identify that a received message is a reply to a previously sent message. Diafaan SMS Server therefore cannot reliably match the UserId that you have included in the outgoing message to reply message.
The Email Connector and the Web Connector do have a way to recognize a reply to a specific message but this is not 100% reliable and it will sometimes match the reply to the wrong user. This feature is not built-in to the SQL Connector but if your database supports triggers, you can add a trigger to the MessageIn table that looks up the last message in the MessageLog table with the same number, extract the UserId from the record and add the UserId to the received message in the MessageIn table.
Regards, Henk
Most Users Ever Online: 529
Currently Online:
8 Guest(s)
Currently Browsing this Page:
1 Guest(s)
Top Posters:
Member Stats:
Guest Posters: 672
Members: 0
Moderators: 0
Admins: 1
Forum Stats:
Groups: 2
Forums: 3
Topics: 1141
Posts: 3899
Newest Members:
, Henk HelmantelAdministrators: Henk Helmantel: 1488