Jump to content

Community

Fernando Pinheiro

+Clients
  • Content Count

    11
  • Joined

  • Last visited

About Fernando Pinheiro

  • Rank
    New Member

Contact Methods

Recent Profile Visitors

388 profile views
  1. From what I understand from this answer, the plugin shows reading time for Pages (database entries) by default, right? I just bought but it only worked on forums in my case. Can you help? Thanks, Fernando
  2. 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.
  3. 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.
  4. 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...

Important Information

We use technologies, such as cookies, to customise content and advertising, to provide social media features and to analyse traffic to the site. We also share information about your use of our site with our trusted social media, advertising and analytics partners. See more about cookies and our Privacy Policy