Skip to content

Instantly share code, notes, and snippets.

@xurizaemon

xurizaemon/civicrm-cached-sql.sql

Created March 17, 2013 01:16
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 xurizaemon/5179119 to your computer and use it in GitHub Desktop.
Save xurizaemon/5179119 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
civicrm-cached-sql.sql
select id,
substring(data,locate('credit_card_number',data)+26,16) as cc_number, -- crude unserialize
created_date
from civicrm_cache
where path like '%contribute%'
and data like '%credit_card_number%'
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment