Returned Error: Unknown column 'lastaction' in 'where clause'MySQL Query Error: SELECT guests.* FROM guests WHERE guests.lastaction > 1119791522
Returned Error: Unknown column 'guests.lastaction' in 'where clause'MySQL Query Error: UPDATE stats SET value='1', date='1119791582' WHERE name='members_max_ever'
Returned Error: Unknown column 'name' in 'where clause'MySQL Query Error: UPDATE stats SET value='1', date='1119791582' WHERE name='users_max_ever'
Returned Error: Unknown column 'name' in 'where clause'
I get this on this code
Code: Select all
//=============================
// Now get Guests, Members & Staff online:
//=============================
$User->online_guests = guests_online();
$User->online_members = members_online();
$User->online_staff = grab_online_staff();
// Max online ever only returns if there are guests/members online, check if it returned:
$query = $Db->query("SELECT * FROM stats");
while($a = $Db->fetch_array( $query )){
$Vars->stats["{$a['name']}"] = $a['value'];
$Vars->stats["{$a['name']}_date"] = $a['date'];
}
$Vars->stats['guests_online'] = $Db->num_rows($User->online_guests);
$Vars->stats['members_online'] = $Db->num_rows($User->online_members);
$Vars->stats['users_online'] = $Vars->stats['members_online']+$Vars->stats['guests_online'];
if($Vars->stats['guests_online'] > $Vars->stats['guests_max_ever']){
$Db->query("UPDATE stats SET value='{$Vars->stats['guests_online']}', date='".time()."' WHERE name='guests_max_ever'");
$Vars->stats['guests_max_ever'] = $Vars->stats['guests_online'];
$Vars->stats['guests_max_ever_date'] = time();
}
if($Vars->stats['members_online'] > $Vars->stats['members_max_ever']){
$Db->query("UPDATE stats SET value='{$Vars->stats['members_online']}', date='".time()."' WHERE name='members_max_ever'");
$Vars->stats['members_max_ever'] = $Vars->stats['members_online'];
$Vars->stats['members_max_ever_date'] = time();
}
if($Vars->stats['users_online'] > $Vars->stats['users_max_ever']){
$Db->query("UPDATE stats SET value='{$Vars->stats['users_online']}', date='".time()."' WHERE name='users_max_ever'");
$Vars->stats['users_max_ever'] = $Vars->stats['users_online'];
$Vars->stats['users_max_ever_date'] = time();
}
#echo $Vars->stats['members_max_ever']."(members), ".$Vars->stats['guests_max_ever']."(guests)";
}