Hello friends, I'm making a simple multiplayer game. I have worked in this project during 7 month, and it is very important for me.
Nowadays, I am using a table in mysql where I save turns and points of each player. On their devices I have a service that is continually making visits to this table to see if it the user has turns availables ... The problem is that the battery and consumption data is very large and it is not possible. On the other hand, the app works very well.
I've been testing "Android push notification (GCM)" (https://www.b4x.com/android/forum/t...ion-gcm-framework-and-tutorial.19226/#content) and the example of Erel works perfectly and I think it could be a very good solution.
However, I have the problem that I can not making reviews in the table where the turns are inserted and sending messages from the "Messages sending tool" tool (command line) proposed Erel manually.
Could you make a trigger in mysql that when you register an insert inside the table where I keep the turns, mysql does the same work that "Messages sending tool" (app java command line) tool. It is to say, send the message in automatic way?. I could make fields in the table (mysql) for example, player id (SenderId) without any problems.
I need when I insert a new message in my notification table of mysql, it will send automatically.
At this moment, I have to use the manual tools (cmd in the comand line) to send these messages.
Is there another solution to what I propose?
Nowadays, I am using a table in mysql where I save turns and points of each player. On their devices I have a service that is continually making visits to this table to see if it the user has turns availables ... The problem is that the battery and consumption data is very large and it is not possible. On the other hand, the app works very well.
I've been testing "Android push notification (GCM)" (https://www.b4x.com/android/forum/t...ion-gcm-framework-and-tutorial.19226/#content) and the example of Erel works perfectly and I think it could be a very good solution.
However, I have the problem that I can not making reviews in the table where the turns are inserted and sending messages from the "Messages sending tool" tool (command line) proposed Erel manually.
Could you make a trigger in mysql that when you register an insert inside the table where I keep the turns, mysql does the same work that "Messages sending tool" (app java command line) tool. It is to say, send the message in automatic way?. I could make fields in the table (mysql) for example, player id (SenderId) without any problems.
I need when I insert a new message in my notification table of mysql, it will send automatically.
At this moment, I have to use the manual tools (cmd in the comand line) to send these messages.
Is there another solution to what I propose?
Last edited: