1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21

        $pass     = md5($data['password']);
        $username = $data['username'];
        
        // sanitize the variables...
        $pass     = mysql_real_escape_string($pass, $iptriple);
        $username = mysql_real_escape_string($username, $iptriple);


        // update the AB account with the new password
        $query = "UPDATE `ab_account` SET `password` = '". $pass . "' WHERE username = '" . $username ."'";
        print $query;

        // run the query    
        $result = mysql_query($query, $iptriple) or die("There was a problem with the mysql connection or query on line 571. \nPlease contact support about this issue.");
        echo mysql_affected_rows();
        // update the switch with the new password
        $query = "UPDATE `orders` SET `column` = '" . $pass . "' WHERE (username) IN ('$username')";

        // run the query
        mysql_query($query, $switch) or die("There was a problem with the mysql connection or query. \nPlease contact support about this issue.");