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,
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
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,
