Fernando Pinheiro

My users keep asking for a Telegram group to have a quick chat but I'm afraid that could reduce the forums participation plus not necessarily registered members would be there. Also, if users discuss in a Telegram group for instance, we lose the opportunity to have those specific questions posted in forums and have it available forever in a organized way. How do I fix this? Any ideas? I know I can setup a chat on forums, but that's not what they want. They want to use their phones instead. I'm inclined to create such group, but still afraid of the consequences.

Around 70% of my users access my website using mobile and this number only increases. A mobile app that could notify the user about new content is now needed IMHO. Forums simply can't compete with Telegram groups or Slack channels, or Discord app for instance.

Hi, I just needed that and did: mysql> SELECT tid,title,start_date,topic_firstpost,topic_open_time FROM forums_topics; +-----+-----------------------------------------------+------------+-----------------+-----------------+ | tid | title | start_date | topic_firstpost | topic_open_time | +-----+-----------------------------------------------+------------+-----------------+-----------------+ | 2 | Ghost pela rede | 1198202400 | 2 | 1198202400 | | 3 | Extensões perigosas no Windows | 1502090855 | 3 | 0 | | 4 | Sniffing com o Wireshark | 1502090955 | 4 | 0 | | 5 | Remoção manual de vírus | 1502091174 | 5 | 0 | | 6 | Controle de dispositivos com a porta paralela | 1502091209 | 6 | 0 | | 7 | Mascarando o endereço MAC da placa de rede | 1502091249 | 7 | 0 | +-----+-----------------------------------------------+------------+-----------------+-----------------+ 6 rows in set (0.00 sec) mysql> UPDATE forums_topics SET start_date=1198202400 WHERE tid=3; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> UPDATE forums_posts SET post_date=1198202400 WHERE pid=3; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> UPDATE forums_topics SET start_date=UNIX_TIMESTAMP('2008-01-02') WHERE tid=4; Query OK, 1 row affected (0.00 sec) Rows matched: 1 Changed: 1 Warnings: 0 mysql> SELECT tid,title,start_date,topic_firstpost,topic_open_time FROM forums_topics; +-----+-----------------------------------------------+------------+-----------------+-----------------+ | tid | title | start_date | topic_firstpost | topic_open_time | +-----+-----------------------------------------------+------------+-----------------+-----------------+ | 2 | Ghost pela rede | 1198202400 | 2 | 0 | | 3 | Extensões perigosas no Windows | 1198202400 | 3 | 0 | | 4 | Sniffing com o Wireshark | 1199250000 | 4 | 0 | | 5 | Remoção manual de vírus | 1502091174 | 5 | 0 | | 6 | Controle de dispositivos com a porta paralela | 1502091209 | 6 | 0 | | 7 | Mascarando o endereço MAC da placa de rede | 1502091249 | 7 | 0 | +-----+-----------------------------------------------+------------+-----------------+-----------------+ 6 rows in set (0.00 sec) mysql> UPDATE forums_posts SET post_date=UNIX_TIMESTAMP('2008-01-02') WHERE pid=4; But you should check your table name (maybe you've used a prefix?) try the following MySQL commands on console: use <your_db_name> show tables; And if you find any interesting table (forums_topics in my case), you can describe that: mysql> describe forums_topics; +----------------------+----------------------+------+-----+---------+----------------+ | Field | Type | Null | Key | Default | Extra | +----------------------+----------------------+------+-----+---------+----------------+ | tid | int(10) | NO | PRI | NULL | auto_increment | | title | varchar(255) | NO | | | | | state | varchar(8) | YES | | NULL | | | posts | int(10) | YES | | NULL | | | starter_id | bigint(20) unsigned | NO | MUL | 0 | | | start_date | int(10) | YES | MUL | NULL | | | last_poster_id | bigint(20) unsigned | NO | | 0 | | | last_post | int(10) | NO | | 0 | | | starter_name | varchar(255) | YES | | NULL | | | last_poster_name | varchar(255) | YES | | NULL | | | poll_state | varchar(8) | YES | | NULL | | | last_vote | int(10) | YES | | NULL | | | views | int(10) | YES | | 0 | | | forum_id | smallint(5) | NO | MUL | 0 | | | approved | tinyint(1) | NO | MUL | 0 | | | author_mode | tinyint(1) | YES | | NULL | | | pinned | tinyint(1) | YES | | NULL | | | moved_to | varchar(64) | YES | | NULL | | | topic_firstpost | int(10) | NO | MUL | 0 | | | topic_queuedposts | int(10) | NO | | 0 | | | topic_open_time | int(10) | NO | | 0 | | | topic_close_time | int(10) | NO | | 0 | | | topic_rating_total | smallint(5) unsigned | NO | | 0 | | | topic_rating_hits | smallint(5) unsigned | NO | | 0 | | | title_seo | varchar(255) | NO | | | | | moved_on | int(11) | NO | MUL | 0 | | | topic_archive_status | int(1) | NO | MUL | 0 | | | last_real_post | int(10) | NO | | 0 | | | topic_answered_pid | int(10) | NO | | 0 | | | popular_time | int(10) | YES | MUL | NULL | | | featured | tinyint(1) unsigned | YES | MUL | 0 | | | question_rating | int(10) | YES | | NULL | | | topic_hiddenposts | int(10) unsigned | YES | | NULL | | | topic_meta_data | bit(1) | NO | | b'0' | | +----------------------+----------------------+------+-----+---------+----------------+ 34 rows in set (0.00 sec) Good luck!