VB + Gossamer Mail integration

[pcmania]

Hello all,

I need a hack that integrates VB with Gossamer Mail. I would like to be able to show New E-mails in Gossamer Mail in the User Contorl Pannel of VBulletin. This way users can see their VBulletin PMs along with their Gossamer Mail E-mails!

I asked Alex at Gossamer Threads and he gave me this SQL 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'

This would give you all the new messages in the users inbox of Gossamer Mail.

Now what is the PHP code that we have to insert in VB?

Any Ideas?

Thanks in advance,

PCMANIA

[Michael]

Dude,

Its a simple SQL query.

$query="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' ";

$result = mysql_query($query);

while($resource=mysql_fetch_object($result)){
print $resource->whatever;
}

[pcmania]

Hi Michael,

And thanks for the reply, could you please explain what I should do with this query? Where should I insert it?

Thanks,

PCMANIA

[chrispadfield]

well you should put it in usercp.php but it is a bit more complicated than that, you need to create some custom templates and to gettemplate() based around the query.

You need probably 1 template for the basis of the section on emails and another for each email, call it email_bit

then loop through, generating email_bit.

If it was you, i would look at the code for the subscribed threads, or private messages and compare it to that. You have the SQL query (the hardest bit) already.

[pcmania]

I would really appreciate it if someone could do this for me. I am willing to pay for it. Please e-mail me and let me know how much your would charge for this!

My e-mail is peyman@atigana.com

Thanks,
PCMANIA

[kevinsdh]

I am also interested in this!

kevin@duckcentral.com