How can I list all pads in etherpad-lite

Question

I found this: https://github.com/ether/etherpad-lite/wiki/How-to-list-all-pads

But I really cannot figure how to use it. Do I have to modify my templates/index.html and add that piece of code? Where? Thank you!

Remington

Answer 1

There are some plugins for that:

• small-list
• list_pads
• padlist

GitHub:

• padlister
• pad-lister

For me personally, small-list was the best choice as I had some problems with the others.

Kermitkermy

Answer 2

I struggled to make it work too, so I contacted Rob - the guy who coded the script. He says that it might be obsolete for the latest version of etherpad-lite.

Hotheaded

Answer 3

Login in etherpad admin, Then go the Plugin Manager and choose/search "list_pads" from Available Plugins And Press install button.

enter image description here Or Through Command line Command is "npm install ep_list_pads"

Wieche

Answer 4

I've tested plugins but did not managed to get the full list of pads sorted by last modified date in one bunch.

The more efficient way I found until now is this SQL query:

SELECT DISTINCT 
    allpads.pad_id, 
    allpads.last_modified 
    FROM 
    (
        SELECT 
            SUBSTRING(store.key, 5, LOCATE(':', store.key, 5) - 5) AS pad_id, 
            FROM_UNIXTIME(SUBSTRING_INDEX(SUBSTRING_INDEX(store.value, '"timestamp":', -1), ',', 1)/1000) AS last_modified
        FROM
            store
        WHERE
            1
            AND store.key LIKE "pad:%"
            AND store.value LIKE '%"timestamp"%'
    ) as allpads
GROUP BY allpads.pad_id
ORDER BY allpads.last_modified DESC;

Cancan