exec("INSERT INTO `$dbname`.`csrf_token` (`token`,`timestamp`,`sessionid`) VALUES ('$csrf_token','".time()."','".session_id()."')") === false) { $err_msg = print_r($mysqlcon->errorInfo(), true); $err_lvl = 3; } if (($db_csrf = $mysqlcon->query("SELECT * FROM `$dbname`.`csrf_token` WHERE `sessionid`='".session_id()."'")->fetchALL(PDO::FETCH_UNIQUE|PDO::FETCH_ASSOC)) === false) { $err_msg = print_r($mysqlcon->errorInfo(), true); $err_lvl = 3; } $lastseentime = time() - 2592000; if(isset($_POST['showlastseen']) && $_POST['showlastseen'] != NULL) { $_SESSION[$rspathhex.'showlastseen'] = strtotime($_POST['showlastseen']); $lastseentime = strtotime($_POST['showlastseen']); } $filter = " WHERE `lastseen`>='{$lastseentime}'"; if(($user_arr = $mysqlcon->query("SELECT `uuid`,`cldbid`,`name`,`lastseen`,`count`,`idle` FROM `$dbname`.`user` {$filter} ORDER BY `name` ASC")->fetchAll(PDO::FETCH_ASSOC|PDO::FETCH_UNIQUE)) === false) { $err_msg = "DB Error1: ".print_r($mysqlcon->errorInfo(), true); $err_lvl = 3; } if (isset($_POST['confirm']) && isset($db_csrf[$_POST['csrf_token']])) { $timestamp = time(); if($mysqlcon->exec("INSERT INTO `$dbname`.`admin_mrgclient` (`uuid_source`,`uuid_target`,`timestamp`) VALUES ('{$_POST['user_source']}','{$_POST['user_target']}','{$timestamp}');") === false) { $err_msg = $lang['isntwidbmsg'].print_r($mysqlcon->errorInfo(), true); $err_lvl = 3; } elseif($mysqlcon->exec("UPDATE `$dbname`.`job_check` SET `timestamp`=1 WHERE `job_name`='reload_trigger'; ") === false) { $err_msg = $lang['isntwidbmsg'].print_r($mysqlcon->errorInfo(), true); $err_lvl = 3; } elseif(isset($_POST['delete_user']) && $mysqlcon->exec("INSERT INTO `$dbname`.`admin_addtime` (`uuid`,`timestamp`,`timecount`) VALUES ('{$_POST['user_source']}', '4273093200', '0');") === false) { $err_msg = $lang['isntwidbmsg'].print_r($mysqlcon->errorInfo(), true); $err_lvl = 3; } else { $err_msg = sprintf($lang['wihladm506'], $user_arr[$_POST['user_source']]['name'], $_POST['user_source'], $user_arr[$_POST['user_source']]['cldbid'], $user_arr[$_POST['user_target']]['name'], $_POST['user_target'], $user_arr[$_POST['user_target']]['cldbid']); $err_lvl = NULL; } } elseif(isset($_POST['update']) && $_POST['user_source'] == NULL && $_POST['user_target'] == NULL && isset($db_csrf[$_POST['csrf_token']])) { $err_msg = $lang['errselusr']; $err_lvl = 3; } elseif(isset($_POST['update']) && $_POST['user_source'] == $_POST['user_target'] && isset($db_csrf[$_POST['csrf_token']])) { $err_msg = "Please choose two different user!"; $err_lvl = 3; } elseif(isset($_POST['update']) && isset($db_csrf[$_POST['csrf_token']])) { $err_msg = ''.$lang['wihladm505'].'

'; $online_time = (new DateTime("@0"))->diff(new DateTime("@".round($user_arr[$_POST['user_source']]['count'])))->format($cfg['default_date_format']); $idle_time = (new DateTime("@0"))->diff(new DateTime("@".round($user_arr[$_POST['user_source']]['idle'])))->format($cfg['default_date_format']); $active_time = (new DateTime("@0"))->diff(new DateTime("@".(round($user_arr[$_POST['user_source']]['count'])-round($user_arr[$_POST['user_source']]['idle']))))->format($cfg['default_date_format']); if(isset($_POST['delete_user'])) { $del = ''.$lang['yes'].''; } else { $del = $lang['no']; } $err_msg .= ''.$lang['wihladm502'].':
'.sprintf("%s (UUID: %s; DBID: %s)",$user_arr[$_POST['user_source']]['name'],$_POST['user_source'],$user_arr[$_POST['user_source']]['cldbid']).' - '; $err_msg .= sprintf(''.$lang['delmark'].': %s',$del); $err_msg .= '
- '.$lang['listseen'].' '.date('Y-m-d H:i:s',$user_arr[$_POST['user_source']]['lastseen']).'
- '.$lang['listsumo'].': '.$online_time.'
- '.$lang['listsumi'].': '.$idle_time.'
- '.$lang['listsuma'].': '.$active_time; $err_msg .= '

↓'.$lang['wihladm504'].'↓

'; $online_time = (new DateTime("@0"))->diff(new DateTime("@".round($user_arr[$_POST['user_target']]['count'])))->format($cfg['default_date_format']); $idle_time = (new DateTime("@0"))->diff(new DateTime("@".round($user_arr[$_POST['user_target']]['idle'])))->format($cfg['default_date_format']); $active_time = (new DateTime("@0"))->diff(new DateTime("@".(round($user_arr[$_POST['user_target']]['count'])-round($user_arr[$_POST['user_target']]['idle']))))->format($cfg['default_date_format']); $err_msg .= ''.$lang['wihladm503'].':
'.sprintf("%s (UUID: %s; DBID: %s)",$user_arr[$_POST['user_target']]['name'],$_POST['user_target'],$user_arr[$_POST['user_target']]['cldbid']).'
- '.$lang['listseen'].' '.date('Y-m-d H:i:s',$user_arr[$_POST['user_target']]['lastseen']).'
- '.$lang['listsumo'].': '.$online_time.'
- '.$lang['listsumi'].': '.$idle_time.'
- '.$lang['listsuma'].': '.$active_time; $err_msg .= '

'; $err_lvl = 1; } elseif(isset($_POST['update'])) { echo '

',$lang['errcsrf'],'

'; rem_session_ts3(); exit; } ?>

↓↓