ucast.upm.edu.my ~ Shell I

Editing file /var/www/replace.php (0644)

<?php
// Database Connection

// we connect to localhost at port 3307
$link = mysql_connect('localhost', 'root', 'test!@#', true);
if (!$link) {
    die('Could not connect: ' . mysql_error());
}
print_r($link);
echo 'Connected successfully\n';

$db=mysql_select_db("i3direct");
if (!$db) {
    echo 'Could not select database\n';
    exit;
}

$sql    = 'SELECT * FROM fieldlanguagesvalues';
$result = mysql_query($sql, $link);

if (!$result) {
    echo "DB Error, could not query the database\n\n";
    echo 'MySQL Error: ' . mysql_error();
    exit;
}

print_r($result);

while ($row = mysql_fetch_assoc($result)) {
        $r=str_replace("OpenMeetings", "i3Direct", $row['value']);
        $r=str_replace("code.google.com/p/openmeetings/", "www.tunesu.com", $r);
        $r=str_replace("Http://groups.google.com/group/openmeetings-user", "http://www.tunesu.com", $r);
        $r=str_replace("http://groups.google.com/group/openmeetings-user", "http://www.tunesu.com", $r);
        $r=str_replace("groups.google.com/group/openmeetings-user", "http://www.tunesu.com", $r);

$id=$row['fieldlanguagesvalues_id'];
    //$p_fullname= $r;
    $sql    = "UPDATE fieldlanguagesvalues SET value=\"$r\" WHERE fieldlanguagesvalues_id=$id;";
    echo $sql."<br>";
        mysql_query($sql, $link);

}
mysql_close();