Title: Change website or CDN URL
Last modified: June 11, 2018

---

# Change website or CDN URL

 *  Resolved [nicolaottomano](https://wordpress.org/support/users/nicolaottomano/)
 * (@nicolaottomano)
 * [7 years, 11 months ago](https://wordpress.org/support/topic/move-website/)
 * Dear [@averta_support](https://wordpress.org/support/users/averta_support/),
   
   I’m an user of the free version of the plugin.
 * I need to move lot of images from one CDN to another.
    I found your answer here,
   in which you say to search and replace values: [https://wordpress.org/support/topic/change-some-layers-url/#post-9728194](https://wordpress.org/support/topic/change-some-layers-url/#post-9728194)
 * I tried to search the name of the original CDN but I did not find it in master
   slider tables.
    So I looked into the **params** field of **wp_masterslider_sliders**
   table and fount that it is encoded in base64.
 * Is there any way to bulk replace the images URLs?
 * Best regards
 * Nicola
    -  This topic was modified 7 years, 11 months ago by [nicolaottomano](https://wordpress.org/support/users/nicolaottomano/).
    -  This topic was modified 7 years, 11 months ago by [nicolaottomano](https://wordpress.org/support/users/nicolaottomano/).

Viewing 3 replies - 1 through 3 (of 3 total)

 *  Plugin Contributor [averta support](https://wordpress.org/support/users/averta_support/)
 * (@averta_support)
 * [7 years, 11 months ago](https://wordpress.org/support/topic/move-website/#post-10389799)
 * Dear Nicola,
 * Thank you for choosing Master Slider.
 * On the pro version, you can do that simply. Just go to Settings. There is an 
   option there, named search and replace.
    But on Master Slider Free, you need 
   to write a code to open base64, search and replace that.
 * If you need any further information, please let me know.
 * Best,
 *  Thread Starter [nicolaottomano](https://wordpress.org/support/users/nicolaottomano/)
 * (@nicolaottomano)
 * [7 years, 11 months ago](https://wordpress.org/support/topic/move-website/#post-10390110)
 * Dear [@averta_support](https://wordpress.org/support/users/averta_support/),
   
   yes I created a PHP routine. I post it here for the benefit of anyone who needs
   it in the future.
 * It prints the UPDATE statements that could be then run in a MySQL client.
 *     ```
       <?php
       $servername = "MYSQL_SERVER";
       $username = "USERNAME";
       $password = "PASSWORD";
       $dbname = "DB_NAME";
   
       // Create connection
       $conn = new mysqli($servername, $username, $password, $dbname);
       // Check connection
       if ($conn->connect_error) {
           die("Connection failed: " . $conn->connect_error);
       }
   
       $sql = "SELECT <code>ID</code>, <code>params</code> FROM <code>wp_masterslider_sliders</code>";
       $result = $conn->query($sql);
   
       $sqlupdate = "<br>";
   
       if ($result->num_rows > 0) {
           // output data of each row
           while($row = $result->fetch_assoc()) {	
       		$sqlupdate .= "UPDATE wp_masterslider_sliders SET params = '" . base64_encode(str_replace("OLD_ADDRESS", "NEW_ADDRESS", base64_decode($row["params"]))) . "' WHERE ID = " . $row["ID"] . ";<br>";
           }
   
       	echo $sqlupdate;
       } else {
           echo "0 results";
       }
       $conn->close();
       ?> 
       ```
   
 * Best,
 * Nicola
 *  Plugin Contributor [averta support](https://wordpress.org/support/users/averta_support/)
 * (@averta_support)
 * [7 years, 11 months ago](https://wordpress.org/support/topic/move-website/#post-10394205)
 * Hi again [@nicolaottomano](https://wordpress.org/support/users/nicolaottomano/),
 * A thousand thanks for updating your ticket and provide other users with your 
   useful information.
 * If you are satisfied with Master Slider and our services, please take a moment
   and give it a review. We would greatly appreciate it.
 * [Rate Us](https://wordpress.org/support/plugin/master-slider/reviews/#new-post)
 * Have a nice time.
 * Best,


Viewing 3 replies - 1 through 3 (of 3 total)

The topic ‘Change website or CDN URL’ is closed to new replies.

 * ![](https://ps.w.org/master-slider/assets/icon-256x256.png?rev=1638064)
 * [Master Slider - Responsive Touch Slider](https://wordpress.org/plugins/master-slider/)
 * [Frequently Asked Questions](https://wordpress.org/plugins/master-slider/#faq)
 * [Support Threads](https://wordpress.org/support/plugin/master-slider/)
 * [Active Topics](https://wordpress.org/support/plugin/master-slider/active/)
 * [Unresolved Topics](https://wordpress.org/support/plugin/master-slider/unresolved/)
 * [Reviews](https://wordpress.org/support/plugin/master-slider/reviews/)

 * 3 replies
 * 2 participants
 * Last reply from: [averta support](https://wordpress.org/support/users/averta_support/)
 * Last activity: [7 years, 11 months ago](https://wordpress.org/support/topic/move-website/#post-10394205)
 * Status: resolved