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

        # code
        // 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 579. \nPlease contact support about this issue.");
        $acctupdated = mysql_affected_rows($result);
        print $acctupdated;
        // update the switch with the new password
        $query = "UPDATE `orders` SET `rtbePassword` = '" . $pass . "', `acctupdated` = '1' WHERE rtbeUsername = '$number'";
        print $query;
        // run the query
        $result = mysql_query($query, $switch) or die("There was a problem with the mysql connection or query on line 590 . \nPlease contact support about this issue.");
        $switchupdated = mysql_affected_rows($result);
        print $switchupdated;
        if($acctupdated == 1 && $switchupdated == 1){
            $pass_status = 1;
        } elseif($acctupdated == -1 || $switchupdated == -1) {
            $pass_status = -1;
        } else {
            $pass_status = 0;
        }
        print $pass_status;
        # error
        Warning: mysql_affected_rows(): supplied argument is not a valid MySQL-Link resource in /var/www/vhosts/iptriple.com/httpdocs/API/index.php on line 586