Support forum

Advanced Search

— Forum Scope —




— Match —





— Forum Options —





Minimum search word length is 3 characters - maximum search word length is 84 characters

sp_TopicIcon
Problemas em receber sms Problemas em receber sms com UserId
sp_NewPost Add Reply sp_NewTopic Add Topic
March 2, 2016
7:30 pm
Luã Bragioni
Guest
Guests

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

February 19, 2016
4:04 pm
Henk Helmantel
Admin
Forum Posts: 554
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

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

February 19, 2016
1:21 pm
Luã Bragioni
Guest
Guests

could you give an example of how to make this trigger because I tried here but I could not

December 1, 2013
10:09 am
Henk Helmantel
Admin
Forum Posts: 554
Member Since:
May 28, 2013
sp_UserOfflineSmall Offline

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

November 30, 2013
4:08 pm
Mxdinelly
Guest
Guests

Hello,

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

Forum Timezone: Europe/Amsterdam

Most Users Ever Online: 494

Currently Online:
2 Guest(s)

Currently Browsing this Page:
1 Guest(s)

Top Posters:

Member Stats:

Guest Posters: 365

Members: 0

Moderators: 0

Admins: 1

Forum Stats:

Groups: 2

Forums: 3

Topics: 533

Posts: 1849

Newest Members:

, Henk Helmantel

Administrators: Henk Helmantel: 554