function changepassword($old_password, $password) { $loguser = $_SESSION['user_id']; $ob1 = new connect(); $sql = "SELECT * FROM `users` WHERE `user_id`= '{$loguser}' AND `user_password` = '{$old_password}'"; // echo $sql; $sql = mysqli_query($ob1->dbcon(), $sql); if (mysqli_fetch_assoc($sql)) { //check old password $sql1 = "UPDATE `users` SET `user_password`='{$password}' WHERE `user_id` = '{$loguser}' "; mysqli_query($ob1->dbcon(), $sql1) or trigger_error("SQL", E_USER_ERROR); $log = new crm_log(); $log->add_log("users", $loguser, "password changed"); // add a log return "1"; } else { return "0"; } }
function deletegroup($gid) { $loguser = $_SESSION['user_id']; $ob1 = new connect(); $sql = "UPDATE `groups` SET `group_modified_by`='{$loguser}', `group_modified_time`=SYSDATE(),`deleted` = '1' WHERE `group_id` = '{$gid}' "; mysqli_query($ob1->dbcon(), $sql) or trigger_error("SQL", E_USER_ERROR); $log = new crm_log(); $log->add_log("groups", $gid, "delete"); // add a log }