Skip to content

Instantly share code, notes, and snippets.

@igal

igal/gist:944934

Created April 27, 2011 18:59
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save igal/944934 to your computer and use it in GitHub Desktop.
Save igal/944934 to your computer and use it in GitHub Desktop.
Download ZIP
Etherpad: find the URL for a page if you can only remember some of its contents
Raw
gistfile1.md

Etherpad: find the URL for a page if you can only remember some of its contents

  1. Connect to the Etherpad database, the credentials are in a file like src/etherpad/trunk/etherpad/etc/etherpad.localdev-default.properties

  2. Execute SQL similar to that below, replacing Phantom Chicken with your search term:

     SELECT DISTINCT(m.ID) FROM `PAD_REVMETA_META` AS m LEFT JOIN
   (`PAD_REVMETA_TEXT` AS t) ON (m.NUMID = t.NUMID) WHERE t.DATA 
   LIKE '%Phantom Chicken%';

  3. Use the IDs shown to compose a URL, e.g. if ID is omgkittens and your Etherpad server is at etherpad.mysite.com, then your URL is http://etherpad.mysite.com/omgkittens.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment