getting recently created pads

[brainysmurf]

I was wondering if there is a way from the API or even from the mysql database directly to get a list of say 10 of the most recently-created pads.

I'm the server administrator for a school and there is a need to monitor pad creations. I also want to put links to them so that a teacher can create a pad and for the next five minutes or so it's guaranteed to be on the front page for ease of sharing.

Thanks for this tool, it rocks.

[Peter Martischka]

Unfortunately there is no api method for that at the moment. But it
would be easy to extend the pad creation process so it does save the
newpad id to a list or something

[Daniel Reeves]

Peter, could you give a hint on how to do this via the database directly?
I also need to do this.
Thanks!

--
http://dreev.es  --  search://"Daniel Reeves"
Follow the Yellow Brick Road -- http://beeminder.com

[John McLear]

Afaik there is an open issue for this.  It was something I wanted a while ago but couldn't remember why.. 

[Daniel Reeves]

thanks john, how about just a full list of all public pads?

[Daniel Reeves]

To answer my own question, my awesome friend Rob Felty wrote this for
extracting the full list of public pads, sorted by number of
revisions:

mysql -u USER -pPSW etherpad_lite -e 'select store.key from store' |
grep -Eo '^pad:[^:]+' | sed -e 's/pad://' | sort | uniq -c | sort -rn
| awk '{if ($1!="2") {print $2 }}'

We couldn't see a way to sort it by last modification time.

[John McLear]

Awesome :)