Jump to content

Community

Fernando Pinheiro

+Clients
  • Content Count

    8
  • Joined

  • Last visited

About Fernando Pinheiro

  • Rank
    New Member

Recent Profile Visitors

250 profile views
  1. 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.
  2. 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.
  3. 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!
×
×
  • Create New...