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(); }