View Single Post
Old 10-18-2013, 03:23 PM   #20
Fedaykin
Ring of Famer
 

Join Date: Nov 2006
Posts: 4,879

Adopt-a-Bronco:
None
Default

Quote:
Originally Posted by Blueflame View Post
Linked pics will require reviewing post history and/or editing/deleting images whenever we run across them.

update post set post_contents = regexp_replace( post_contents, '/^(https:\/\/)?([\da-z\.-]+)\.([a-z\.]{2,6})([\/\w \.-]*)*\/?jpg$/ ', '{whacked girlie pic}' );

Or something similar depending on how the embeds are encoded in the db



Oh yeah.. requires Oracle, heh. YMMV with whatever db is being used =P
Fedaykin is offline   Reply With Quote