[seoyo]

Hi, I'm creating an application that will reside on the same server as our vBulletin install. It will allow people to create threads from outside the vBulletin system using a different interface.

I've tailed the MySQL logs to see what's going on in MySQL when a new thread is created, and have now as a result established everything necessary to make a new thread and post from outside. The only question I have left is about the posthash table in a standard vBulletin install.

Although the userid, threadid, postid and dateline columns in this table are self explanatory, I do not know how the dupehash is generated. Can anyone shed some light on this?

Also, this is the only line I could fine in the source that showed how the hash is generated. Is this correct (the $dupehash value is what is eventually inserted into the dupehash table in the dupehash column)?

$dupehash = md5($forumid . $this->fetch_field('title') . $this->fetch_field('pagetext', 'post') . $userid . $type);