[Admin]

But the query is executed!

There's a difference between this:

if ($DB_site->query_first("SELECT * FROM weather_usersettings WHERE userid=$bbuserinfo[userid]")) {

and:

if ([high]$usersettings=[/high]$DB_site->query_first("SELECT * FROM weather_usersettings WHERE userid=$bbuserinfo[userid]")) {

The first one only checks if the query returned a row, but the second one also stores what's returned in the variable.

I'm using this all the time, works great.