[tmatrix]

Wish to thank you greatly for this information. It has done an incredible amount in my understanding of the db and how vB works under the hood.

I'm working on getting certain notifications from vBulletin into another site, so users could be aware, then have a suitable link to follow.

I was looking at the groupmessage table, trying to link it to the social group's owner. Linking discussionid to the discussion table, which then provides a groupid. Linking to the socialgroup table where I can get the creatoruserid (moderator/owner of group). Yeah! But.. I saw in both of those tables (discussion and socialgroup) there is a column "modereration", along with visible and deleted. How are these columns used in the discussion and socialgroup tables. I attempted to do the math for some various groups, it does not add up.

Thank you again,
Cheers
Murias