Viewing 3 replies - 1 through 3 (of 3 total)
  • Plugin Contributor averta support

    (@averta_support)

    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

    (@nicolaottomano)

    Dear @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

    (@averta_support)

    Hi again @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

    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.