= 1) { //include 'steamauth/userInfo.php'; /*$steamid = "steam:" . dechex($_SESSION['steamid']);*/ $query = $conn->prepare("SELECT u.steamid, firstgiven, lastgiven, department, jobtitle FROM characters JOIN users u using(userid) WHERE steamid = :steamid AND department = 'DOJ'"); $query->bindValue(':steamid', $_SESSION['steamid']); $query->execute(); $authorized = $query->fetch(PDO::FETCH_ASSOC); if(isset($authorized)) { $name = $authorized['jobtitle'] . " " . $authorized['lastgiven']; $_SESSION['name'] = $name; } } else { header('Location: index.php'); } ?>
| Username | Char ID | Name | Owes State |
|---|