I have almost 200 embedded you tube videos on a site that the client would now like to change to not be resizable. I know there must be a way to do this within the database (find and replace?) but I'm not sure how. I can do it in Wordpress, so it must be doable in Drupal!
Thanks for you help!
Jessica Hannan 815-545-5541 http://www.HaloDigitalDesign.com Join us on Facebook!! http://www.facebook.com/halodigitaldesign
It depends on how you are storing them. If they are embedded directly in the node body, then not without a custom module. If they are in a field, where just the link is stored, you can do something like this:
UPDATE {table} SET {field_name} = concat ({field_name}, '?fs=1') {optional where clause such as WHERE {fieldname} LIKE '%youtube.com%'
For the body method you would actually have to do a custom module using a regular expression to search and replace for the URL, since all YouTube urls end with the video ID (or query params). The problem there is that MySQL doesn't support regular expression search and replace, just plain text with the REPLACE() function.
Jamie Holly http://www.intoxination.net http://www.hollyit.net
On 5/14/2012 11:00 AM, Jessica Hannan - Halo Digital Design wrote:
I have almost 200 embedded you tube videos on a site that the client would now like to change to not be resizable. I know there must be a way to do this within the database (find and replace?) but I'm not sure how. I can do it in Wordpress, so it must be doable in Drupal!
Thanks for you help!
Jessica Hannan 815-545-5541 http://www.HaloDigitalDesign.com Join us on Facebook!! http://www.facebook.com/halodigitaldesign
I've never done this, but how about creating a MySQL dump and then using regular expression S&R on the dump file?
Warren
On May 14, 2012, at 9:58 AM, Jamie Holly wrote:
It depends on how you are storing them. If they are embedded directly in the node body, then not without a custom module. If they are in a field, where just the link is stored, you can do something like this:
UPDATE {table} SET {field_name} = concat ({field_name}, '?fs=1') {optional where clause such as WHERE {fieldname} LIKE '%youtube.com%'
For the body method you would actually have to do a custom module using a regular expression to search and replace for the URL, since all YouTube urls end with the video ID (or query params). The problem there is that MySQL doesn't support regular expression search and replace, just plain text with the REPLACE() function.
Jamie Holly http://www.intoxination.net http://www.hollyit.net
On 5/14/2012 11:00 AM, Jessica Hannan - Halo Digital Design wrote:
I have almost 200 embedded you tube videos on a site that the client would now like to change to not be resizable. I know there must be a way to do this within the database (find and replace?) but I'm not sure how. I can do it in Wordpress, so it must be doable in Drupal!
Thanks for you help!
Jessica Hannan 815-545-5541 http://www.HaloDigitalDesign.com Join us on Facebook!! http://www.facebook.com/halodigitaldesign
-- [ Drupal support list | http://lists.drupal.org/ ]
-
Jamie Holly -
Jessica Hannan - Halo Digital Design -
Warren Keuffel