{"action":"opened","issue":{"url":"https://api.github.com/repos/dsoares/Roundcube-Plugin-Lastlogin/issues/1","repository_url":"https://api.github.com/repos/dsoares/Roundcube-Plugin-Lastlogin","labels_url":"https://api.github.com/repos/dsoares/Roundcube-Plugin-Lastlogin/issues/1/labels{/name}","comments_url":"https://api.github.com/repos/dsoares/Roundcube-Plugin-Lastlogin/issues/1/comments","events_url":"https://api.github.com/repos/dsoares/Roundcube-Plugin-Lastlogin/issues/1/events","html_url":"https://github.com/dsoares/Roundcube-Plugin-Lastlogin/issues/1","id":154248514,"number":1,"title":"uncompatible and not protable, (not postgresql or sqlite due close mysql querys)","user":{"login":"mckaygerhard","id":1571724,"avatar_url":"https://avatars.githubusercontent.com/u/1571724?v=3","gravatar_id":"","url":"https://api.github.com/users/mckaygerhard","html_url":"https://github.com/mckaygerhard","followers_url":"https://api.github.com/users/mckaygerhard/followers","following_url":"https://api.github.com/users/mckaygerhard/following{/other_user}","gists_url":"https://api.github.com/users/mckaygerhard/gists{/gist_id}","starred_url":"https://api.github.com/users/mckaygerhard/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/mckaygerhard/subscriptions","organizations_url":"https://api.github.com/users/mckaygerhard/orgs","repos_url":"https://api.github.com/users/mckaygerhard/repos","events_url":"https://api.github.com/users/mckaygerhard/events{/privacy}","received_events_url":"https://api.github.com/users/mckaygerhard/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":0,"created_at":"2016-05-11T13:50:01Z","updated_at":"2016-05-11T13:50:01Z","closed_at":null,"body":"in the functions \"lasst_log\" and \"write_log\" does not use query with the RC api\r\n\r\nand in any way the query are not SQL standar so this plugins that its a great feature does not are usefully wuith real DBMS like oracle, postgresql or sybase using odbc or pgpsql drivers\r\n\r\n- i made yesterday some fine tune and table creation are not necesary if used a own made log file, that made more portable and better using egrep and shell scripts (roundcube have many shell scripts in bin directory)\r\n-  **the id are innecesary in insert, due are autogenerated**\r\n-  but using portability, the insert query can be modified, and the table creation for sqlite and postgres/oracle are easy..\r\n-  the last_log function use a xtrange query i dont understand:\r\nUNIX_TIMESTAMP(timestamp) ?????\r\nreal_ip:ip ???\r\nin unix timestamp are always same (BSD, linux, Mac), guindows system must use posix or fuck'up so dont care! \r\n- and the return value \r\n$rows[] = $res;\r\nare php 5.4+ so must be changed to complaint php 5.3 \r\narray_push($rows, $res)\r\n\r\n]I can made some pull request to fixed that important topis"}}