Posted By

ReeceMarsland on 12/04/09


Tagged

mysql php drupal


Versions (?)

Drupal 5.x Find PHP code in database


 / Published in: MySQL
 

used to find content that uses the PHP input filter....useful for upgrading core!

  1. SELECT nid, vid FROM node_revisions WHERE FORMAT IN (SELECT FORMAT FROM filters WHERE module='filter' AND delta = 1);
  2.  
  3. SELECT cid, nid FROM comments WHERE FORMAT IN (SELECT FORMAT FROM filters WHERE module='filter' AND delta = 1);
  4.  
  5. SELECT bid, info FROM boxes WHERE FORMAT IN (SELECT FORMAT FROM filters WHERE module='filter' AND delta = 1);

Report this snippet  

You need to login to post a comment.