Help on one of my free directories - too many submission

Thank you for all suggestion. Indeed, I figured out this command:

it solves my prob...However I don't suggest this killer way to any of you

 

Here are some of mine

delete from `PLD_LINK` where `STATUS` like '%http%'

PHP:

delete from `PLD_LINK` where `STATUS` like '%penis%'

PHP:

delete from `PLD_LINK` where `STATUS` like '%viagra%'

PHP:

 

delete from `PLD_LINK` where `STATUS` = 1

is the correct way. because, for example, if you had more than 10 different types of STATUS, it would have wiped out all of your teens. So be thankful you dont hahaha.

and you wont have to even worry about that anymore

 

Does this mean you'll be dumping all your pending submissions?

 

That is correct, unless a case clause is used for something on a date timeline.

 

I did use

and it works. (deleted all pending links)

In fact, I was inspired by your thread " http://forums.digitalpoint.com/showthread.php?t=182395&page=4&highlight=dirmania

delete from `PLD_LINK` where `URL` like '%dirmania.org%'

 

Woow that's a lot of links i review evry day submissions to not lost track ...

Regards

 

Ya i have a similar problem. I tried setting it to 20 cent, then the traffic dropped from 80+ a day to maybe like 7 hits a day. It's horrible!

 

If the submissions are done automatically, you can just select to install a strange font (like font of casper ), update your config file to use that font! (phpld2 was allowing that. I have a free niche PR6 phpld2 directory utilizing that method and i am only getting 2-3 unrelated submissions per week) That is it. I dont believe those bots can dechiper all those fonts. I got image processing course, it is not easy.

 

Use a CAPTCHA

 

I explained in my post why it's not in the best of interests to use it like that.
I will further help explain to help give you a more detailed explanation

Let us say that you have 20 status types:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20

ok, based on your query, and lets say for arguments sake you only wanted to delete status type 1

using query term of: like '%1%'
would leave you with
2
3
4
5
6
7
8
9
20

with that query, you just erased 1, 11, 12, 13, 14, 15, 16, 17, 18 ,19 status types. Follow?

So anything that has a '1' in it would have been removed. (not a good practice)

The dirmania.org was sufficient, because domains are like fingerprints, and there is only 1 of each.

if you had a dirmania .com .net .org .us . info
using: like '%dirmania%' would erase all of them, but using: like '%dirmania.org%' would only erase the .org leaving the .com .net .us & .info intact.

 

Thank you, an0n, I got it.

 

I can't remember where I saw it, it may have been on DirectorySpy, but someone has released an anti-spam script of some sort that is supposed to dramatically cut down on spam submissions. I don't have a clue how, as I am not a programmer, but I'll try to dig it up. Oh, yeah, and it was for PHPLD, so if you're not using that directory script then I guess this is a moot point.

 

Open phpmyadmin in 2 windows so you can switch back in forth.

In one window, sort your table of listings by ip address. This will give you a big list of individuals that have submitted.

Scroll down and find the ip addresses that have large numbers of listings. These are some of your spammers.

In the 2nd window open phpmyadmin and click the sql tab. type this

delete from `table_name` where `ip_address` = "paste_ip_address_here" AND `status` = 0

This will not do away with all the spam but the people who submitted dozens of sites will be gone. This should at least cut your queue in half in just under 30 minutes of work. Also status = 0 should mean "all pending links". Leave this off if you want to do away with all of the sites that are already listed in your directory.

Please forgive my ignorance about the table and field names of PHPld, I have never used it before. I roll my own:>

 

This has me thinking because I have had to pretty much shut down all my free directories except one. If I don't check it every day it's a pain to clean. I have conflicting thoughts about this because I really like offering something free for visitors.

 

If you run free general directories, then for sure it will get a lot submissions.
Try niche, you'll get less submissions.

To reduce submissions on general directory, perhaps it would be better to start as paid from beginning.