Author Topic: spam (Read 1566 times)

sanj · « **on:** March 04, 2007, 03:57:55 am »

hi,
I'm having a lot of problems wiht automatic submission software.

could anyone give me apiece of code that i can add to my submission form that prevent the form from submitting if fname = lname.

Basically i get a lot entries in my database with the exact same entries for first name and last name and some made up email.

thanks
sanj

DW · « **Reply #1 on:** March 04, 2007, 08:57:09 am »

Hi SanJ,

Check out this post:

http://listmailpro.com/forum/index.php?topic=1203.0

You can do what you want with the following code:

Code: [Select]

if($fname==$lname) exit;
Regards

sanj · « **Reply #2 on:** March 05, 2007, 06:20:52 am »

hi Dean,

My database is now full of rubbish email that have been posted by autobots.

how can i remove them without having to do it manually one by one

thanks

DW · « **Reply #3 on:** March 05, 2007, 02:20:04 pm »

If all signups, as you mentioned, have the same fname and lname you could run a custom query with a tool like PhpMyAdmin, commonly accessible from your hosting control panel:

SQL:

Code: [Select]

DELETE FROM lm_users WHERE fname != '' AND fname = lname;

Regards