Hi,
I have an installed working system built with phprunner2, using mysql4 and php4, that has been working well for some time.
I am in the process of installing a new server and decided to upgrade to mysql5/php5 and start using phprunner3.11.
But...I am encountering some problems with php coded events with 3.11. For example:
I used the following code in a "before record update" event on an edit of a record in a "user" table to check if the user or Admin had changed a password. If changed it is supposed to MD5 encrypt the new value.
// If the password has changed then md5 encode it...
if (strcmp("'".$data["Password"]."'",$values["Password"])!=0)
{
$values["Password"]="md5(".$values["Password"].")";
}
The password field is Varchar, length 32.
This worked fine under phprunner2 but has stopped working with phprunner 3.11 and mysql5/php5. It seems to always update the password, even if it has not changed. And instead of MD5 encrpyting, it saves the value as "md5(whateverthepasswordwas)". For example if the password was "fred" then what is stored is literally "md5(fred)".
Hints on ho to get around this would be appreciated.
Giles