LinkBack URL
About LinkBacks
Idea: Avoid Duplicate Video Threads?
K so..i was browsing the video section when i saw another thread about the american soldiers shooting those guys..Collateral Murder/ when this idea came to me:
What if an admin (the baconator) or ownage created a database table where youtube etc video links would be stored (only when a new thread-1st post) and after the user hit the Submit Button you would query that table to check for duplicates, echo an error message and prevent the user from creating a duplicate thread?
This is a great idea, if it can be done.
Originally Posted by SheepShank
hmm.. would be useful if possible..
but what if there's 2 youtube videos uploaded by 2 different people..?
There will be only one table containing the youtube links. It doesn't matter how many ppl and/or how many links the users will post. All links will be checked (only when a new thread is made) with the ones in the table. If a link exists in the post and in the table (duplicate) it will be removed from the user's post. If a link does not exist the table (original) it will be added in the table (for future searching) and successfully posted.
I don't know how editable is the code in Vbullettin forums but i think that it is possible, if not sure.
(there's a small possible future problem if that table list gets long with the server's processing time but there are solutions for that too.I doubt we will ever encounter it though..)
Last edited by George; 04-06-2010 at 05:04 PM.
do you know how to do this..?
i cant imagine ownage knowing how to do it really, or atleast he would need some help
its a great idea if it can be done, would definately reduce the amount of useless threads being made
I think purdy means when there's two of the same videos but were uploaded by two different people on Youtube.
kid cudi, lupe fiasco, wiz khalifa. <3
R.I.P Armani
Yes i can do it. Not right now though cuz i'm very busy with college projects.
Someone which is familiar with the vbulletin system and a basic knowledge of php and sql can do it much faster.
Ohhhh yeah you're right that wouldn't work in that case..maybe if their Titles contained same words something could be done but not very reliable.
Last edited by George; 04-06-2010 at 05:10 PM. Reason: Automerged Doublepost
Seems like a lot of work, and a lot of custom coding, if its even possible.
What I have seen on another forum is when you create a new topic, it displays a mini list of topics with similar titles, so you can check to make sure it hasn't already been covered.
2009 OwnagePranks Most Annoying Poster
2009 OwnagePranks Most Talkative Poster
2009 OwnagePranks Most Active Poster
2009 OwnagePranks Biggest Forum Spammer
That's more realistic
OwnagePranks VIP
Try it out for only $2.47 using coupon code "078"
http://members.ownagepranks.com
Valid for new VIP members only
-------
I suppose one way to do it would be to somehow parse each thread for the particular youtube ID. I'm not sure if you can implement vB's search function like that though.
2009 OwnagePranks Most Annoying Poster
2009 OwnagePranks Most Talkative Poster
2009 OwnagePranks Most Active Poster
2009 OwnagePranks Biggest Forum Spammer
ownage can use his md5 hash decoder to get this done.
Yeah! Them niggas getting scurred! Wurrd?
All that talk was just a whole bunch of verb
Pussy ass nigga got a whole bunch a nerve
I have em putin' your picture on a bunch of shirts
It is possible.
But will cost $658.92 to complete.
meh, nothing ever gets done.
/disappoint
Is this even that big of an issue? It takes like 3 steps to delete a duplicate thread anyways.
2009 OwnagePranks Most Annoying Poster
2009 OwnagePranks Most Talkative Poster
2009 OwnagePranks Most Active Poster
2009 OwnagePranks Biggest Forum Spammer
No it's not. Kind of annoying though when you get into a thread and discover the same content.
(ever got tired of the "OLD" posts?)
I have a feeling this might slow loading times down a little bit because really, this check would have to be performed on every post, to see if a youtube link has been posted that is. My knowledge of VB is very minimal though and SQL is not one of my stronger points so I feel this might be a little bit over my head. I know some sites use link checker bots to determine whether rapidshare links are still active so a tweak in this code might be more reasonable. Could maybe be implemented in a language other than VB?
2009 OwnagePrank's Most Respected Poster Award
2009 OwnagePrank's Most Knowledgeable Poster Award
2009 OwnagePrank's Best Avatar Award
Sig courtesy of Razz; Love courtesy of Alexx.
Don't vbulletin forums run php too?
It's not a good idea to perform this check in every post, only when someone first creates a thread. In both cases though, the time delay won't be noticeable...(will probably take +0.01-0.05ms to perform the query. (Assuming a database $connection variable is already active,otherwise +1~second)). I can write the code in php and the sql part (already written a sample one) but someone else will have to find and edit the specific .php file that gets called after a new thread is posted.
Last edited by George; 04-08-2010 at 06:31 PM.
It sounds completely reasonable if you have the template written. I'll keep looking to figure out what the file is called but it doesn't seem to come up when I do searches. I'll ask one of my friends over the weekend who has done some VB work.
Even if Ownage doesn't want this I'm sure you could market it to VB as an add on.
2009 OwnagePrank's Most Respected Poster Award
2009 OwnagePrank's Most Knowledgeable Poster Award
2009 OwnagePrank's Best Avatar Award
Sig courtesy of Razz; Love courtesy of Alexx.
I think the suggestion of related threads seems more related. If the server recognizes another thread with similar keywords in the title/op body then it will stop it from being posted, suggest this/these thread(s) and ask 'Are You Sure?' and 'Are You Really Sure?' and 'Are You Really Really Sure?' just like Windows Vista! Wait...
Posting Permissions
