Jump to content

Trovare i topic più visti

  •
najaru
najaru
in 3.x

Featured Replies

Per poter avere una statistica dei topic più visti in un determinato periodo è necessario lanciare una query nel mysql, tipo quella seguente. Ovviamente è necessario cambiare le date a seconda del periodo interessato

SELECT t.tid, t.title, COUNT(*) AS topic_postsFROM ibf_posts pLEFT JOIN ibf_topics t ON (t.tid=p.topic_id)WHERE FROM_UNIXTIME(p.post_date) BETWEEN '2010-01-01' AND '2010-01-31'GROUP BY t.tidORDER BY topic_posts DESC

Edited by Skillman_92

    • Like 1

    Create an account or sign in to comment
    Go to topic listing

    Recently Browsing 0

    • No registered users viewing this page.

    Important Information

    We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue. to insert a cookie message.

    Account

    Navigation

    Search

    Configure browser push notifications
    Chrome (Android)
    1. Tap the lock icon next to the address bar.
    2. Tap Permissions → Notifications.
    3. Adjust your preference.
    Chrome (Desktop)
    1. Click the padlock icon in the address bar.
    2. Select Site settings.
    3. Find Notifications and adjust your preference.