抓一尾蟲在屁股癢，一些亂筆記

最近試著要大量修改內容


UPDATE `field_data_body` SET `body_value`=REPLACE(`body_value`, 'http://i.imgur.com/', '/sites/default/files/imgur/');
UPDATE `field_revision_body` SET `body_value`=REPLACE(`body_value`, 'http://i.imgur.com/', '/sites/default/files/imgur/');
UPDATE `block_custom` SET `body`=REPLACE(`body`, 'http://i.imgur.com/', '/sites/default/files/imgur/');

UPDATE `views_display` SET `display_options`=REPLACE(`display_options`, 'http://i.imgur.com/', '/sites/default/files/imgur/');

不過記錄在longblob的內容，置換完後LINK會壞掉
UPDATE `locales_source` SET `source`=REPLACE(`source`, 'http://i.imgur.com/', '/sites/default/files/imgur/');
UPDATE `metatag` SET `data`=REPLACE(`data`, 'http://i.imgur.com/', '/sites/default/files/imgur/');

不要去搞longblob及views相關的內容，網站的內容會壞掉

data longblob
locales_source

UPDATE 'field_data_body'
SET 'body_value' = REPLACE('body_value', 'http://i.imgur.com/', '/sites/default/files/imgur/')
WHERE 'field_data_body' LIKE '%http://i.imgur.com/%'


UPDATE your_table
SET your_field = REPLACE(your_field, 'articles/updates/', 'articles/news/')
WHERE your_field LIKE '%articles/updates/%'

UPDATE field_data_body
SET body_value = REPLACE(body_value, 'http://i.imgur.com/', '/sites/default/files/imgur/')

UPDATE field_revision_body
SET body_value = REPLACE(body_value, 'http://i.imgur.com/', '/sites/default/files/imgur/')

UPDATE block_custom
SET body = REPLACE(body, 'http://i.imgur.com/', '/sites/default/files/imgur/')

UPDATE views_display
SET display_options = REPLACE(display_options, 'http://i.imgur.com/', '/sites/default/files/imgur/')

UPDATE locales_source
SET source = REPLACE(source, 'http://i.imgur.com/', '/sites/default/files/imgur/')

UPDATE metatag
SET data = REPLACE(data, 'http://i.imgur.com/', '/sites/default/files/imgur/')

select replace(slogen, 'bananas', 'apples') from tcountriesnew where slogen like '%bananas%';

select replace(field_data_body, 'http://i.imgur.com/', '/sites/default/files/imgur/) from field_data_body where field_data like '%http://i.imgur.com/%';

平台
https://www.drupal.org/project/wetkit

RWD模擬
http://www.responsinator.com/

單一頁跳menu的作法
https://www.youtube.com/watch?v=EcQFafF0qFA

https://www.drupal.org/project/scroll_to_destination_anchors