sub auth_valid_session {
# -----------------------------------------------------------------------------
# This functions checks to see if the session is valid, and returns the
# username.
#
my $args = shift;
my $session_id = $IN->param('s') || $IN->cookie($CFG->{user_cookie_prefix} . 's') || return;
my $session;
unless ($session = GT::Session::SQL->new({
_debug => $CFG->{debug_level},
tb => $DB->table('Sessions'),
session_id => $session_id,
expires => $CFG->{user_session_length},
session_data => { sessions => $CFG->{user_sessions}, d => scalar($IN->param('d')) },
})) { # Possibly an expired session
GT::Session::SQL->new({
tb => $DB->table('Sessions'),
expires => $CFG->{user_session_length}
})->cleanup; # Clear out old sessions
return;
}

return $session->{info}->{session_user_id};
}

my $link = mysql_connect('localhost', 'user', 'pass');
if (!$link) {
die('not able to connect: ' . mysql_error());
}
my $session_id = $_COOKIE['s'];
my $session;
my $result = mysql_query("select * from glinks_Sessions where session_id like '$session_id'");
if (!$result) {
die "not able to connect: " . mysql_error();
exit;
}
if (mysql_num_rows($result) == 1) {
while ($row = mysql_fetch_assoc($result)) {
$USER = $row;
}
}

my $result = mysql_query("select * from glinks_Sessions where session_id = '$session_id'");

// get time from when they first logged in + x hours * 60 * 60 (so in seconds)
$expiry_time = $row['session_date'] + ($row['session_expire'] * 60 * 60);

if ($expiry_time < time()) {
// they are NOT logged in any more (session has expired)
} else {
// they are logged in
}

<?php
$link = mysql_connect('localhost', 'user', 'pass');
$db_selected = mysql_select_db('database', $link);
if (!$link) {
die('not able to connect: ' . mysql_error());
}
$session_id = $_COOKIE['s'] ? $_COOKIE['s'] : '';
if ($session_id) {
$result = mysql_query("select * from glinks_Sessions where session_id = '$session_id'");
if (mysql_num_rows($result) == 1) {
while ($row = mysql_fetch_assoc($result)) {
$session = $row;
$expiry_time = $row['session_date'] + ($row['session_expires'] * 60 * 60);
}
}
}
if ($session AND $expiry_time > time()) {
$result = mysql_query("select * from glinks_Users where Username = '$session[session_user_id]'");
if (mysql_num_rows($result) == 1) {
while ($row = mysql_fetch_assoc($result)) {
$USER = $row;
}
}
}

echo "$USER[Username] ";//test
?>