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
}
