ListMailPRO Email Marketing Software Forums

ListMailPRO Email Marketing Software Forums => General Help & How-To => Topic started by: sanj on March 04, 2007, 03:57:55 am

Title: spam
Post by: 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

Title: spam
Post by: DW 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

Title: spam
Post by: sanj 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

Title: spam
Post by: DW 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