Oh, whoops. To actually get the messages, you would want:
FROM msgtrack, msgs, auth_vb
WHERE gmail_userid = msgtrack_userid AND
msgtrack_mid = msgs_mid AND
msgtrack_status = 'New' AND
msgtrack_fid = 1 AND
vb_user = 'YOURVBUSERNAME'This would give you all the new messages in the users inbox.
Cheers,
Alex
--
Gossamer Threads Inc.
Code:
SELECT * FROM msgtrack, msgs, auth_vb
WHERE gmail_userid = msgtrack_userid AND
msgtrack_mid = msgs_mid AND
msgtrack_status = 'New' AND
msgtrack_fid = 1 AND
vb_user = 'YOURVBUSERNAME'
Cheers,
Alex
--
Gossamer Threads Inc.