Using PHP-Nuke 7.5, with Site Visitors updated for 7.5, I get the following error above the block:
Code:
Unknown column 'time' in 'where clause'
Here's the relevant code from the block:
Code:
// Set Nuke session table
$past = time()-900;
sql_query( "DELETE FROM $prefix"._users." WHERE time < '$past'", $dbi);
$result = sql_query( "SELECT time FROM $prefix"._session." WHERE uname='$username'", $dbi );
Any idea how to fix this?
Edit: I should note the block appears to work OK, other than this error.
// Set Nuke session table
$past = time()-900;
sql_query( "DELETE FROM $prefix"._users." WHERE time < '$past'", $dbi);
$result = sql_query( "SELECT time FROM $prefix"._session." WHERE uname='$username'", $dbi );
$ctime = time();
if ( $row = sql_fetch_array( $result , $dbi ) )
{
sql_query( "UPDATE $prefix"._session." SET uname='$username', time='$ctime', host_addr='$ip', guest='$guest' WHERE uname='$username'", $dbi );
}
else
{
sql_query( "INSERT INTO $prefix"._session." (uname, time, host_addr, guest) VALUES ('$username', '$ctime', '$ip', '$guest')" , $dbi );
}
// Determine last registered user
$result = sql_query( "select username from $prefix"._users." order by user_id DESC limit 0,1", $dbi );
list( $lastuser ) = sql_fetch_row( $result, $dbi );
// Amount of registered users
$numrows = sql_num_rows( sql_query( "select user_id from $prefix"._users." where username != 'Anonymous'", $dbi ) );
// Amount of registered users online
$result2 = sql_query( "SELECT uname, guest FROM $prefix"._session." where guest=0", $dbi );
$member_online_num = sql_num_rows( $result2 );
// Assemble the online registered users
$who_online_now = "";
$i = 1;
while ( $session = sql_fetch_array( $result2, $dbi ) )
{
if ( isset($session["guest"]) and $session["guest"] == 0 )
{
// Determine Location for Flag image
$FlagResult = sql_query( "select user_from from ".$prefix."_users where username='$session[uname]'", $dbi );
$FlagInfo = sql_fetch_array( $FlagResult, $dbi );
// Display all information
if (is_user($user) )
{
// Determine how many READ Messages and how many UNREAD Messages
$result = sql_query( "select user_id from $prefix"._users." where username='$username'", $dbi);
list( $user_id ) = sql_fetch_row( $result, $dbi );
$result2 = sql_query( "select privmsgs_type from $prefix"._bbprivmsgs." where privmsgs_to_userid='$user_id' AND (privmsgs_type='1' or privmsgs_type='5' and privmsgs_from_userid='user_id')", $dbi );
$MesUnread = sql_num_rows( $result2 );
$result3 = sql_query( "select privmsgs_type from $prefix"._bbprivmsgs." where privmsgs_to_userid='$user_id' AND privmsgs_type='0'", $dbi );
$MesRead = sql_num_rows( $result3 );
if ( is_user( $user ) )
{
// Show only registered online users to users who logged in
$content .= "<B>Who's Online:</B><br>$who_online $who_online_now";
}
else
{
// Show guests how to register
$content .= "Don't have an account yet? <a href=\"modules.php?name=Your_Account&op=new_user\">Click here to create one</a>.";
}
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
