Checking for duplicate URL in add form

[linksor.com]

Hi,

My directories are going to be a huge ones and I need a modification which checks during submitting a page if the URL exists in database 9or after pressing SUBMIT button).

Is there any ideas howto ?

Checking for dupliacte content via ACP is going to be difficult because I must check by ID which URL must be deleted. I prefer to make it automated.

[FSGDAG]

I've also wanted this... I get a TON of duplicate submissions all the time and have to remember to constantly use the "Find Duplicate Link". If it could be done at the time that the user was adding the URL, it would be much better and efficent

[inspireme]

didnt test this. Load up add.php, around line 230ish

 // check to see if already exists 
 strtolower ($url);
 $query    = "select * from idx_link where url LIKE %$url%";
    $result   = $dbConn->Execute($query);
    $duplicated = $result->Fields("url");

if ($duplicated){
 $error_msg = ("Im sorry we already have your URL listed.");
 }
 
    elseif (empty($title))
      $error_msg = $msg["10101"];

notice the if for checking to see if title is empty needs to be altered to "elseif"

NOT TESTED, just to get you started...

[dody]

I've updated indexu svn.
http://nicecoder.com/svn/index.php?act=changeset&id=559

In simple way, use this code

    elseif ($dbConn->Lookup("link_id", "idx_link", "url = '$url'"))
      $error_msg = 'Im sorry we already have your URL listed.';

[linksor.com]

Doesnt work on IU 5.3.0

[dody]

it should work.
i just checked that 5.3 can understand $dbConn->Lookup

any error msg do you get?
and where do you put the codes? Try below these lines:

elseif (empty($url) || $url == 'http://')
$error_msg = $msg["10102"];

[Bruceper]

IndexU should really reject submissions at the time of submission if it's a duplicate. Users should be sent off to the modify page if it already exists.

[esm]

I've updated indexu svn.
http://nicecoder.com/svn/index.php?act=changeset&id=559

In simple way, use this code

    elseif ($dbConn->Lookup("link_id", "idx_link", "url = '$url'"))
      $error_msg = 'Im sorry we already have your URL listed.';

hmmmmm....I don't think the following would be considered duplicates but all point to the exact same page.

http://cnn.com
http://cnn.com/
http://www.cnn.com
http://www.cnn.com/
http://cnn.com/index.html
http://www.cnn.com/index.html

.

[linksor.com]

I have added many times one site on Linksor.com and it always's been accepted

I have placed all necessary codes as dody described.

I dont get any error - just a page about successful submitting

edit: I will test it on another my dir.

[dody]

Thanks esm, it mean that only top level domains are accepted?

[esm]

Thanks esm, it mean that only top level domains are accepted?

aren't they all top-level domain urls...???



.

[dody]

i mean no deep link url?

[Antony]

The duplicate are working without problem...
But have a problem with the ajax cat.... uNDER IE ONLY FIREFOX WORK WELL
I made svn updated site...

http://www.toutou-chien.com

Antony

[linksor.com]

I have tested this on my all directories with no luck. Seems that th eproblem is somewhere else not in PHP code. May be in collation of database ?

BTW found another issue: when I want to check duplicate links via ACP it doesn;t show me all duplicated links: the URL with the ending SLASH "/" is not the same as the link withoud slahs.

http://www.domain.com is not the same as http://www.domain.com/

[CEC]

I know this is an old thread ... but does any of this duplicate link check at the point of adding work in version 1.21?