
11-30-2003, 11:19 PM
|
 |
|
|
Join Date: Jul 2002
Location: Ontario, Canada
Posts: 11,440
Благодарил(а): 0 раз(а)
Поблагодарили:
0 раз(а) в 0 сообщениях
|
|
Quote:
Originally Posted by jarvis
I have a question about the $getnewposts routine and am not enough of a coder to get past my self-inflicted mySQL errors.
Anyways, I mirror some Usenet groups on our fourms and would like to have the getnewposts routine in myvbindex not count these posts during the welcome tasks.
PHP Code:
$getnewposts=$DB_site->query_first("SELECT count(*) AS count FROM post WHERE dateline>='$bbuserinfo[lastvisit]'");
I would think that I should be able to add a WHERE forumid!=XX somewhere in that statement, but have not been able to get that to work.
Any suggestions? Thanks for the awesome hack, as I've continued to use it for almost a year now (and have hacked it up a bit myself for graphics  )
Thanks again!!
|
try searching for it, i belive its been done before
|