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.

[Xenon]

well, hard mods will be able to solve those "spammers" ^^

[Boofo]

Stefan, is there a way to have this go by the user's timezone time instead of the server time? I noticed a user doubler-posted the other day and the time was 2 hours behind the actual double-post (the server is set at PST and I am in CST).

[Xenon]

as posts are stored in server timezone as well as the timenow variable which is used for the hack, it's not possible.

Or better, wouldn't make sense, because if you would base it on usetimezone, then it would be possible that one user can post every minute while the other must have to wait nearly a whole day until...

[Boofo]

Originally Posted by Xenon

as posts are stored in server timezone as well as the timenow variable which is used for the hack, it's not possible.

Or better, wouldn't make sense, because if you would base it on usetimezone, then it would be possible that one user can post every minute while the other must have to wait nearly a whole day until...

But shouldn't it at least be ahead of the post time itself? This was almost 2 hours before the actual post time of the message.

[Xenon]

i think either you or me is confused now.

everything has to be based on TIMENOW as that's the value stored in the DB, and used by the phpscript.

so the hack works absolutelly correct.

if you get wierd behaviours, that could mean, that you have another hack, which manipulates the times or, a slight server problem with different times on different servers..

[gilbert]

Great hack!

[leeman]

Originally Posted by Xenon

well, hard mods will be able to solve those "spammers" ^^

Well since i don't (sorry enough) have mods online 24/7 ....

Could you please do the code change or look at it if it's not too much trouble.

[alqadir]

If one wanted to incorporate checking of the title to validate double posting, how do you compare the title from the last post to the new post.

I want to prevent users from posting two books of the same title (the book title is part of the post title).

Thanks

[Xenon]

the value is stored in $post[title]

@leeman: sorry, i'm very very busy and cannot help you right now.

[AZone]

Great hack, thank you!
By the way, does this hack update New Posts list when someone is doubleposting?

[Xenon]

just if $do_bump is set to true

[cinq]

Let's say a user makes a post and maxs out the number of attachments.
WHat happens when within the very short interval ( which considers the next post a double post ) , he posts again with an attachment.

Can this handle that ?

[alqadir]

hello all,
I have tried to install this hack but I get the following error:
Database error in vBulletin 3.0.3:

Invalid SQL: 
						SELECT postid, pagetext, post.title, post.userid
						FROM post AS post
						LEFT JOIN deletionlog AS deletionlog ON(deletionlog.primaryid = post.postid AND type = 'post')
						WHERE threadid = 
							AND dateline > 1103982928
							AND visible = 1 AND deletionlog.primaryid IS NULL
						ORDER BY dateline DESC
						LIMIT 1
			
mysql error: You have an error in your SQL syntax.  Check the manual that corresponds to your MySQL server version for the right syntax to use near 'AND dateline > 1103982928
							AND visible = 1 AND deletionl

mysql error number: 1064

Can someone out their please help me out! thanks

[Xenon]

@cinq: actually the attachmentpart is the only little bug which is still there

you can add more attachments then allowed with the doublepost, as the avoidance would have produced too much queries....

@alquadir: the $threadinfo varialbe seems to be empty, you have either placed the code at the wrong place, or you have another hack, which is buggy
nothing i can solve.

[cinq]

Originally Posted by Xenon

@cinq: actually the attachmentpart is the only little bug which is still there

you can add more attachments then allowed with the doublepost, as the avoidance would have produced too much queries....

So in this hack, it doesnt cater for that, and the post with new attachments will just be a new post, correct ?

If so, that's fine with me