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
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.
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.
I want a help on receiving sms. Time to send sms by UserId in mysql table I provide the User ID of my system. but when the person answers the sms that id is not etched in messagein table.
how to configure it because this table has UserId field
Most Users Ever Online: 494
Currently Browsing this Page:
Guest Posters: 497
Newest Members:, Henk Helmantel
Administrators: Henk Helmantel: 934