Prevent Doubleposting

When a User posts into a thread where he already has the lastpost, no new post will be added. The lastpost of him will be edited and the new text is put after his first message, attachments will be added to the old post as well.
This will be done until the old post is older than 1 hour (you can change this timespan yourself)
by changing $do_bump in the script, you can define wether the post's time will be altered or not.

Enjoy, and don't forget to click install

Notice: If you have installed the Proxy ip to real ip conversion or Proxy Detector v3.1 Hack, then you should probably take a look at this post.

[NTLDR]

I've just got round to installing this one and I love it, such a simple idea, yet so usefull. Something I should have added to my board along time ago

[Xenon]

thx, lee, in vb2 it was even less to hack, so simple
i use it since a long time now

@PET: you can decide yourself weather it will bump a thread or not.
also you can define a timespan when it's regarded as a real new post or as a dp (the standart is 3600 seconds)

[Weasel]

Xenon your new version introduces some more table_prefix bugs that cause MySQL errors. The problem is that you have to use the AS clause to create an alias so you can use things like post.whatever in the rest of the query without having to put table_prefix all over the place. Here's an example:

PHP Code:

SELECT postid, pagetext, post.userid 
FROM " . TABLE_PREFIX . "post AS post 


You only need to do this on the SELECT query.

[Xenon]

some more?
i just forgot to add the AS on one line...

damn thing, i hate that table prefix in vb3, just a new trap to fall into when writing up instructions

[achtungbaby]

Excellent hack, very clean not to mention ridiculously quick to install.

[Hoffi]

Good Job. Will Install it later.

[Boofo]

Is there a way to disable this for Admins?

[Xenon]

you just have to edit the condition:

PHP Code:

        if ($type != 'thread' AND $doublepost = $DB_site->query_first("
            SELECT postid, pagetext, post.userid 
            FROM " . TABLE_PREFIX . "post AS post
            LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
            WHERE threadid = $threadinfo[threadid]
                AND dateline > " . (TIMENOW - 3600) . "
                AND visible = 1 AND deletionlog.primaryid IS NULL
            ORDER BY dateline DESC 
            LIMIT 1
        ") AND $doublepost['userid'] == $bbuserinfo['userid']) 


and change for example into:

PHP Code:

        if ($type != 'thread' AND $bbuserinfo['usergroupid'] != 6 AND $doublepost = $DB_site->query_first("
            SELECT postid, pagetext, post.userid 
            FROM " . TABLE_PREFIX . "post AS post
            LEFT JOIN " . TABLE_PREFIX . "deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
            WHERE threadid = $threadinfo[threadid]
                AND dateline > " . (TIMENOW - 3600) . "
                AND visible = 1 AND deletionlog.primaryid IS NULL
            ORDER BY dateline DESC 
            LIMIT 1
        ") AND $doublepost['userid'] == $bbuserinfo['userid']) 


[Boofo]

Aha, thank you very much. I was thinking it was in there somewhere but I wasn't sure how to edit it.

[Xenon]

np, you're welcome as always