[gopherhockey]

Hey, we're getting closer... at least to solving my gateway, but not the original problem.

I get the following error, however, when using the code you suggested. (all posts from the NNTP gateway are posted under userid "Guest"):



Invalid SQL: SELECT count(*) AS posts FROM post WHERE dateline > '1047312216' AND username!=Guest
mysql error: Unknown column 'Guest' in 'where clause'

Original line:

$getnewpost=$DB_site->query_first("SELECT count(*) AS posts FROM post WHERE dateline > '$bbuserinfo[lastvisit]'");

Updated code that gives error:

 $getnewpost=$DB_site->query_first("SELECT count(*) AS posts FROM post WHERE dateline > '$bbuserinfo[lastvisit]' AND username!=Guest");

Is Guest perhaps not a real username, at least in the way other usernames are treated? I'll try another (real) userid, I think it is pretty clear how to do that in the gateway code.