{"id":345,"date":"2016-08-14T20:29:13","date_gmt":"2016-08-14T18:29:13","guid":{"rendered":"\/wordpress\/?p=345"},"modified":"2016-08-14T20:34:10","modified_gmt":"2016-08-14T18:34:10","slug":"changer-les-urls-des-liens-dans-les-articles-wordpress","status":"publish","type":"post","link":"https:\/\/mrtaz.net\/wordpress\/2016\/08\/14\/changer-les-urls-des-liens-dans-les-articles-wordpress\/","title":{"rendered":"Changer les urls des liens dans les articles WordPress"},"content":{"rendered":"

set @oldurl='http:\/\/oldurl\/';
\nset @newurl='http:\/\/newurl\/';<\/p>\n

UPDATE wp_options SET option_value = replace(option_value, @oldurl, @newurl) WHERE option_name = 'home' OR option_name = 'siteurl';<\/p>\n

UPDATE wp_posts SET guid = replace(guid, @oldurl,@newurl);<\/p>\n

UPDATE wp_posts SET post_content = replace(post_content, @oldurl, @newurl);<\/p>\n

UPDATE wp_postmeta SET meta_value = replace(meta_value,@oldurl,@newurl);<\/code><\/p>\n","protected":false},"excerpt":{"rendered":"

set @oldurl=’http:\/\/oldurl\/’; set @newurl=’http:\/\/newurl\/’; UPDATE wp_options SET option_value = replace(option_value, @oldurl, @newurl) WHERE option_name = ‘home’ OR option_name = ‘siteurl’; UPDATE wp_posts SET guid = replace(guid, @oldurl,@newurl); UPDATE wp_posts SET post_content = replace(post_content, @oldurl, @newurl); UPDATE wp_postmeta SET meta_value = replace(meta_value,@oldurl,@newurl);<\/p>\n","protected":false},"author":3,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_newsletter_access":"","_jetpack_dont_email_post_to_subs":false,"_jetpack_newsletter_tier_id":0,"_jetpack_memberships_contains_paywalled_content":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[7,9],"tags":[],"class_list":["post-345","post","type-post","status-publish","format-standard","hentry","category-la-vie-la-vraie","category-linux-world"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_shortlink":"https:\/\/wp.me\/p7qSCz-5z","jetpack-related-posts":[{"id":183,"url":"https:\/\/mrtaz.net\/wordpress\/2010\/12\/26\/tourner-ses-photos-sans-les-modifier-binairement\/","url_meta":{"origin":345,"position":0},"title":"Tourner ses photos sans les modifier binairement!","author":"MrTAZ","date":"26\/12\/2010","format":false,"excerpt":"Pour tourner des photos sans les modifier binairement parlant... Sous Linux... exiv2 -M \"set Exif.Image.Orientation Short 6\" `Le nom de la photo...` ou exiv2 -M \"set Exif.Image.Orientation Short 8\" `Le nom de la photo...` on peut bien sur les tourner en masse avec des eregs genre DSCF000[0-9].jpg GJ!","rel":"","context":"Dans "Linux world"","block_context":{"text":"Linux world","link":"https:\/\/mrtaz.net\/wordpress\/category\/linux-world\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":242,"url":"https:\/\/mrtaz.net\/wordpress\/2012\/10\/27\/probleme-windows-update\/","url_meta":{"origin":345,"position":1},"title":"Probl\u00e8me Windows Update ?!","author":"MrTAZ","date":"27\/10\/2012","format":false,"excerpt":"\u00a0 winupdatefix","rel":"","context":"Dans "La vie, la vraie..."","block_context":{"text":"La vie, la vraie...","link":"https:\/\/mrtaz.net\/wordpress\/category\/la-vie-la-vraie\/"},"img":{"alt_text":"","src":"\/wordpress\/wp-content\/uploads\/2012\/10\/WinUpdateFix.png","width":350,"height":200,"srcset":"\/wordpress\/wp-content\/uploads\/2012\/10\/WinUpdateFix.png 1x, \/wordpress\/wp-content\/uploads\/2012\/10\/WinUpdateFix.png 1.5x"},"classes":[]},{"id":205,"url":"https:\/\/mrtaz.net\/wordpress\/2011\/11\/16\/dyndns-ovh-sur-synology-dsm-3-2\/","url_meta":{"origin":345,"position":2},"title":"DynDNS Ovh sur Synology DSM 3.2","author":"MrTAZ","date":"16\/11\/2011","format":false,"excerpt":"Et oui, un d\u00e9tail qui m'avait \u00e9chapp\u00e9 lors de mon changement de provider internet... J'avais tellement l'habitude de l'ip fix chez free que j'en avais oubli\u00e9 que chez d'autres il n'y en avait pas! Bon, je m'\u00e9tais r\u00e9sign\u00e9 \u00e0 ne plus avoir d'ipv6 mais l'ip dynamic me g\u00e8ne un peu\u2026","rel":"","context":"Dans "Linux world"","block_context":{"text":"Linux world","link":"https:\/\/mrtaz.net\/wordpress\/category\/linux-world\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":156,"url":"https:\/\/mrtaz.net\/wordpress\/2008\/02\/11\/167-buffer-overflow-sur-des-applications-windows-16bit\/","url_meta":{"origin":345,"position":3},"title":"Buffer Overflow sur des applications Windows 16bit","author":"MrTAZ","date":"11\/02\/2008","format":false,"excerpt":"Si vous avez d\u00e9j\u00e0 rencontr\u00e9 des erreurs du genre \"Protection fault\" etc etc... Cela est du \u00e0 un \"Buffer Overflow\" sur une variable environment. V\u00e9rifier que votre PATH ne d\u00e9passe pas les 126 caract\u00e8res! Si tel est le cas, vous pouvez toujours outrepasser le probl\u00e8me en modifiant le PATH pour\u2026","rel":"","context":"Dans "La vie, la vraie..."","block_context":{"text":"La vie, la vraie...","link":"https:\/\/mrtaz.net\/wordpress\/category\/la-vie-la-vraie\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":185,"url":"https:\/\/mrtaz.net\/wordpress\/2008\/01\/22\/163-freeplug-freebox-hd-1ere-box-integrant-le-courant-porteur-en-ligne-cpl-sans-surcout\/","url_meta":{"origin":345,"position":4},"title":"Freeplug : Freebox HD, 1\u00e8re Box int\u00e9grant le courant porteur en ligne (CPL) sans surco\u00fbt.","author":"MrTAZ","date":"22\/01\/2008","format":false,"excerpt":"Fid\u00e8le \u00e0 sa strat\u00e9gie d\u2019offrir toujours plus de services pour un prix inchang\u00e9 (29,99 euros\/mois), Free propose d\u00e9sormais Freeplug. Cette innovation incluse dans l\u2019offre Freebox permet de b\u00e9n\u00e9ficier en standard du courant porteur en ligne (CPL) pour relier entre elles les deux parties de la Freebox HD.","rel":"","context":"Dans "News"","block_context":{"text":"News","link":"https:\/\/mrtaz.net\/wordpress\/category\/news\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]},{"id":132,"url":"https:\/\/mrtaz.net\/wordpress\/2007\/01\/30\/138-la-reponse\/","url_meta":{"origin":345,"position":5},"title":"La r\u00e9ponse…","author":"MrTAZ","date":"30\/01\/2007","format":false,"excerpt":"Lyon, le 30 janvier 2007 Madame, Monsieur, J\u2019ai bien pris note de votre p\u00e9tition relative \u00e0 la r\u00e9forme du Compte de soutien \u00e0 l\u2019Industrie des Programmes Audiovisuels (COSIP), cr\u00e9\u00e9 en 1986 et r\u00e9glement\u00e9 par les d\u00e9crets n\u00b0 95-110 du 2 f\u00e9vrier 1995 et 98-35 du 14 janvier 1998 modifi\u00e9s en\u2026","rel":"","context":"Dans "La vie, la vraie..."","block_context":{"text":"La vie, la vraie...","link":"https:\/\/mrtaz.net\/wordpress\/category\/la-vie-la-vraie\/"},"img":{"alt_text":"","src":"","width":0,"height":0},"classes":[]}],"jetpack_likes_enabled":true,"_links":{"self":[{"href":"https:\/\/mrtaz.net\/wordpress\/wp-json\/wp\/v2\/posts\/345","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/mrtaz.net\/wordpress\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mrtaz.net\/wordpress\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mrtaz.net\/wordpress\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/mrtaz.net\/wordpress\/wp-json\/wp\/v2\/comments?post=345"}],"version-history":[{"count":1,"href":"https:\/\/mrtaz.net\/wordpress\/wp-json\/wp\/v2\/posts\/345\/revisions"}],"predecessor-version":[{"id":347,"href":"https:\/\/mrtaz.net\/wordpress\/wp-json\/wp\/v2\/posts\/345\/revisions\/347"}],"wp:attachment":[{"href":"https:\/\/mrtaz.net\/wordpress\/wp-json\/wp\/v2\/media?parent=345"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mrtaz.net\/wordpress\/wp-json\/wp\/v2\/categories?post=345"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mrtaz.net\/wordpress\/wp-json\/wp\/v2\/tags?post=345"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}