Web script not working

[Heifnir]

Hi,

I'm trying to make a condition where players under level 15 can't login, but can't figure it out. This is the current script I'm working on :

 Spoiler

$toonlevel = ('select MAX(Level) as toonlevel FROM [PS_GameData].[dbo].[Chars] as c
left join(select UserUID from PS_UserData.dbo.Users_Master) as um ON c.UserUID = um.UserUID
where UserID = ?');
if ($toonlevel <= 15)
{
header('Refresh:1; url =
echo "<script>alert('You need atleast one level 15 char to login !');</script>";
exit();
}
else
{
$_SESSION['UserUID'] = $uid;
$_SESSION['AdmLvl'] = $row[3];
exit();
}

[Heifnir]

Originally Posted by Cups

You should be preparing the query, executing it, and then setting toonlevel to the result. At the moment, you are setting the value of toonlevel to the query string.

I tried this :

 Spoiler

$toonlevel = $dbh->prepare('select MAX(Level) as toonlevel FROM [PS_GameData].[dbo].[Chars] as c
left join(select UserUID from PS_UserData.dbo.Users_Master) as um ON c.UserUID = um.UserUID
where UserID = ?');
$dbh->execute();
$result = $dbh->fetchAll(PDO::FETCH_COLUMN, 0);
if ($toonlevel <= 15);
{
header('Refresh:1; url =
echo "<script>alert('You need atleast one level 15 char to login !');</script>";
exit();
}
else
{
$_SESSION['UserUID'] = $uid;
$_SESSION['AdmLvl'] = $row[3];
exit();
}

Still not working.

 Spoiler

$sth = $dbh->prepare('select MAX(Level) as toonlevel FROM [PS_GameData].[dbo].[Chars] as c
left join(select UserUID from PS_UserData.dbo.Users_Master) as um ON c.UserUID = um.UserUID
where UserID = ?');
$sth->execute();
$result=$sth->fetch();
echo $result['toonlevel'];
if (toonlevel <= 15)
{
header('Refresh:1; url =
echo "<script>alert('You need atleast one level 15 char to login !');</script>";
exit();
}
else
{
$_SESSION['UserUID'] = $uid;
$_SESSION['AdmLvl'] = $row[3];
exit();
}