[solved] Not writing system time in DB while using send from file feature

playSMS Help
1

while checking system and DB time, the time is OK, but while checking in table ‘playsms_featureSendfromfile’ using feature send from file, found that GMT+0 Zone time is written, can someone help on this.
I have checked the function core_get_datetime() is taking GMT time, do i need some code changes for taking system time?

Playsms system time
Fri Aug 5 08:52:43 NPT 2016

Kannel System time
Fri Aug 5 08:55:20 NPT 2016

MysqlDB time
| now() |
±--------------------+
| 2016-08-05 08:55:28 |
±--------------------+

./var/www/html/playsms/plugin/feature/sendfromfile/sendfromfile.php

$db_query .= “VALUES (’$uid’,’$sid’,’” . core_get_datetime() . “’,’$sms_to’,’” . addslashes($sms_msg) . “’,’$sms_username’)”;

2

yes, all time in db should be in GMT+0

anton

3

Ok, that means this is not an issue?

4

yes, thats not an issue

playSMS saves time in GMT+0 and display it correctly, if not than thats the bug

core_display_datetime() will display the time correctly in web

anton

5

Thank you Anton for great help, it is cleared now