36 lines
976 B
PHP
36 lines
976 B
PHP
<?php
|
|
function generateSimpleId() {
|
|
// Generates a random 4-digit number with a prefix
|
|
return 'U' . str_pad(random_int(0, 9999), 4, '0', STR_PAD_LEFT);
|
|
}
|
|
|
|
function generateUltraId() {
|
|
// Generates a more complex, unique ID using random bytes for better uniqueness
|
|
return 'ULTRA-' . strtoupper(bin2hex(random_bytes(3))) . '-' . strtoupper(bin2hex(random_bytes(3)));
|
|
}
|
|
|
|
// Function to redirect and exit
|
|
function redirect($url) {
|
|
header('Location: ' . $url);
|
|
exit();
|
|
}
|
|
|
|
function get_user_by_id($user_id) {
|
|
$pdo = db();
|
|
$stmt = $pdo->prepare("SELECT * FROM users WHERE id = ?");
|
|
$stmt->execute([$user_id]);
|
|
return $stmt->fetch(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
function get_user_servers($user_id) {
|
|
$pdo = db();
|
|
$stmt = $pdo->prepare("
|
|
SELECT s.* FROM servers s
|
|
JOIN server_members sm ON s.id = sm.server_id
|
|
WHERE sm.user_id = ?
|
|
");
|
|
$stmt->execute([$user_id]);
|
|
return $stmt->fetchAll(PDO::FETCH_ASSOC);
|
|
}
|
|
|
|
?>
|