public function setEmailResoluton($time)
{
$log_model = new Admin_ajax();
if ($_POST['hdnid']) {
$log_model->addLog("UPDATE", "su_email_resolution", 'email_resolution_imap', "Performed UPDATE Operation");
$res = Yii::app()->db->createCommand('UPDATE `su_email_resolution` SET email_resolution_imap="' . $_POST['email_resolution_imap'] . '", email_resolution_email="' . $_POST['email_resolution_email'] . '",email_resolution_password="******" WHERE email_resolution_id=' . $_POST['hdnid'])->execute();
return $res;
} else {
$insertemail = 'INSERT INTO `su_email_resolution` (email_resolution_imap,email_resolution_email,email_resolution_password,email_resolution_ts) VALUES ("' . $_POST['email_resolution_imap'] . '","' . $_POST['email_resolution_email'] . '","' . $_POST['email_resolution_password'] . '","' . date("Y-m-d H:i:s") . '")';
$id = Yii::app()->db->createCommand($insertemail)->execute();
$log_model = new Admin_ajax();
$log_model->addLog("INSERT", "su_email_resolution", $id, "Performed INSERT Operation");
return $id;
}
}
public function set_password($password, $id)
{
$sql = 'UPDATE users set user_password = "******" WHERE user_id = ' . $id;
$log_model = new Admin_ajax();
$log_model->addLog("Update", 'users', $id, "Performed Update Operation");
return Yii::app()->db->createCommand($sql)->execute();
}
