Verify User Email Addresses

[Gary King]

VERIFY USER EMAIL ADDRESSES

DON'T FORGET TO CLICK ON THE INSTALL BUTTON (https://vborg.vbsupport.ru/misc.php?s=&action=install&threadid=54450) TO RECEIVE UPDATES MADE TO THIS HACK, AND THANKS FOR INSTALLING THIS! :)

What does this hack do?

verifies the email addresses of all your users and checks for invalid or non-existant email addresses
displays a list of the users who have an invalid or non-existant email address
How do I install this?

Simply read the instructions in the attached file.

Why would I install this?

this hack is extremely useful for finding which member(s) are using bogus (fake) email addresses in their accounts
this is good if you want to be able to send out newsletters, etc. to all your members, and so you can make sure that they are using valid email addresses

Bugs, Suggestions, Comments

Got something to say about this particular hack? Then don't hesitate to reply back to this thread, and once I've read your post, I'll post a reply to your particular bug, suggestion, or comment.

Screenshots
admin cp nav panel (https://vborg.vbsupport.ru/attachment.php?s=&postid=410003)
begin process page (https://vborg.vbsupport.ru/attachment.php?s=&postid=410004)
users have been verified (https://vborg.vbsupport.ru/attachment.php?s=&postid=410005)

*NOTE*

This hack will only check the email domain of the users' email addresses, since it is not really possible to verify each and every email address. If you would like to actually check every one of your users' email addresses, then you'll have to send an email out to them, and see which ones bounce.


DOWNLOAD

This version of this hack only displays the users that have invalid email addresses. Use this for quickly checking which users have invalid/non-existent/no email addresses, instead of version below.
Download instructions-invalid.txt now! (https://vborg.vbsupport.ru/attachment.php?s=&postid=411080)

This version of this hack is the same as the above, but it will display ... valid or ... INVALID when checking your members. It's a good idea to use this if you're not sure if the hack locks up after processing a large number of users (so basically, use this version if you have a large number of users).
Download instructions-all.txt now! (https://vborg.vbsupport.ru/attachment.php?s=&postid=411079)

[Gary King]

admin cp nav panel

[Gary King]

begin process page

[Gary King]

Users have been verified, displaying users with invalid email addresses.

[assassingod]

Nicely done, Gary W :)

[Oblivion Knight]

Very useful, and installed at Umbrella Online :)

Great work!

[Gary King]

Thanks for the comments guys :)

[Lifeman]

Good Idea Garry W. Thanks :).

[Skyline_GT]

nice
will install it asap

[tkeil69575]

nice hack - tina klicks install :)

[Talisman]

Hey, this is great, Gary. Thanks.

[OmaniMan]

Great Bro ... I Installed It

[alkatraz]

great idea!

[Gary King]

Nice to see a lot of people installing this useful hack :)

[Tungsten]

Does this hack require Sendmail?

[Gary King]

Today at 10:11 PM Tungsten said this in Post #15 (https://vborg.vbsupport.ru/showthread.php?postid=410133#post410133)
Does this hack require Sendmail?

Nope ;)

[Smoothie]

how long does this process take? I clicked the begin process 10 minutes ago and its still chuggin away....

[monstergamer]

Yesterday at 09:34 PM alkatraz said this in Post #13 (https://vborg.vbsupport.ru/showthread.php?postid=410116#post410116)
great idea! also clicks install

[gmarik]

Fine, fine ...

[squawell]

useful hack

/me clicked install....

[D7MeEe]

thanx

nice hack

[Oblivion Knight]

Today at 03:58 AM Smoothie said this in Post #17 (https://vborg.vbsupport.ru/showthread.php?postid=410144#post410144)
how long does this process take? I clicked the begin process 10 minutes ago and its still chuggin away....

It depends how many users you have on your forums..
Mine took about 25 seconds with a 512k connection, and I have 176 active members and 253 in total.

[Gary King]

Yesterday at 10:58 PM Smoothie said this in Post #17 (https://vborg.vbsupport.ru/showthread.php?postid=410144#post410144)
how long does this process take? I clicked the begin process 10 minutes ago and its still chuggin away....

Just leave it and wait until it finishes; anyways, it shouldn't take TOO long, although I haven't yet tested it myself on a fairly large board yet.

[Velocd]

I've done similar to this, but instead applied it to the 'user prune' page, so you can mass erase those users if need be.

It's funny to see how many users under 'waiting for email verification' have invalid emails. :p

To do as I've done, just find in admin/user.php:
echo "<tr class='".getrowbg()."' align='center'>
<td><font size='1'><b>ID</b></font></td>
<td><font size='1'><b>Username</b></font></td>
<td><font size='1'><b>Email</b></font></td>
<td><font size='1'><b>Posts</b></font></td>
<td><font size='1'><b>Last Visit</b></font></td>
<td><font size='1'><b>Join Date</b></font></td>
<td><input type='checkbox' name='allbox' onclick='CheckAll()' title='select/deselect all' checked></td>
</tr>\n";
while ($user = $DB_site->fetch_array($users)) {

And below it place:
list($username, $maildomain) = split("@", $user['email']);
if (!checkdnsrr($maildomain, "MX"))
{
$user[email] .= "</a> <font color=\"red\">[<b>invalid email</b>]</font>";
}

It would also make sense to apply this MX lookup to the registration page, to kill the problem at the root.

[Gary King]

It would also make sense to apply this MX lookup to the registration page, to kill the problem at the root.

Well, then you might as well just enable the email verification upon registration ;)

[Smoothie]

Just leave it and wait until it finishes; anyways, it shouldn't take TOO long, although I haven't yet tested it myself on a fairly large board yet.
cable connection, with 4000 users, it was still not done after 20 minutes.

[wolfe]

nice hack d00d :D i just updated and changed code and install on my vB 3.0.0 look :D

[wolfe]

and

[Kriek]

Today at 01:25 PM Smoothie said this in Post #26 (https://vborg.vbsupport.ru/showthread.php?postid=410398#post410398)
cable connection, with 4000 users, it was still not done after 20 minutes.

Same here, additionally got a Action canceled page after twenty-five minutes.

[Gary King]

Today at 06:38 PM wolfe said this in Post #27 (https://vborg.vbsupport.ru/showthread.php?postid=410512#post410512)
nice hack d00d :D i just updated and changed code and install on my vB 3.0.0 look :D

Nice looking modifications you made there :)

[Smoothie]

Had to uninstall hack, not working properly on my site.

[wolfe]

Yesterday at 12:42 AM Gary W said this in Post #30 (https://vborg.vbsupport.ru/showthread.php?postid=410535#post410535)
Nice looking modifications you made there :)

thanx :D

d00d i got a suggestion why not make it like when you update counters.

for example

Proccessing user: Wolfe... VALID
Proccessing user: Gary W... VALID
Proccessing user: testuser... NOT VALIED


etc so it shows it doing each member @ a time would give benift to people knowing it has not locked up :D

if you need help with the code i will help you out.

[Gary King]

Today at 11:26 AM wolfe said this in Post #32 (https://vborg.vbsupport.ru/showthread.php?postid=411063#post411063)
thanx :D

d00d i got a suggestion why not make it like when you update counters.

for example

Proccessing user: Wolfe... VALID
Proccessing user: Gary W... VALID
Proccessing user: testuser... NOT VALIED


etc so it shows it doing each member @ a time would give benift to people knowing it has not locked up :D

if you need help with the code i will help you out.

Done. Check the first post in this thread for details :)

[Gary King]

This version of this hack is the same, but it will display ... valid or ... INVALID when checking your members. It's a good idea to use this if you're not sure if the hack locks up after processing a large number of users (so basically, use this version if you have a large number of users).

[Gary King]

This version of this hack only displays the users that have invalid email addresses. Use this for quickly checking which users have invalid/non-existent/no email addresses, instead of version above this post.

[wolfe]

nice one :D

just gonna change this to work with my vB3.0 :D

[wolfe]

d00d add a perpage to the varification like i have here

[wolfe]

and this is what it looks like when its done 10 of all the your members

[Gary King]

Today at 06:00 PM wolfe said this in Post #37 (https://vborg.vbsupport.ru/showthread.php?postid=411175#post411175)
d00d add a perpage to the varification like i have here

Could you attach what you currently have and I'll credit you with the modification :)

[Kriek]

Both versions were equally unsuccessful, DNS Error perchance?

[Gary King]

Today at 07:54 PM Kriek said this in Post #40 (https://vborg.vbsupport.ru/showthread.php?postid=411210#post411210)
Both versions were equally unsuccessful, DNS Error perchance?

Did you get any errors, if so, what did they say? If you didn't get any errors, or if that isn't the problem, then please be a little more specific.

[wolfe]

d00d i aint using vB 2.X.X so you need to test this out but all seems right ;)

[Kriek]

Today at 07:58 PM Gary W said this in Post #41 (https://vborg.vbsupport.ru/showthread.php?postid=411212#post411212)
Did you get any errors, if so, what did they say? If you didn't get any errors, or if that isn't the problem, then please be a little more specific.

Action Canceled or The page cannot be displayed

[Gary King]

Today at 09:42 PM Kriek said this in Post #43 (https://vborg.vbsupport.ru/showthread.php?postid=411232#post411232)


A 404 should not result from this hack. When exactly do you get this?

[Gary King]

Today at 08:59 PM wolfe said this in Post #42 (https://vborg.vbsupport.ru/showthread.php?postid=411224#post411224)
d00d i aint using vB 2.X.X so you need to test this out but all seems right ;)

Thanks I'll check it out and tweak it a little :)

[Kriek]

Today at 09:47 PM Gary W said this in Post #44 (https://vborg.vbsupport.ru/showthread.php?postid=411233#post411233)
A 404 should not result from this hack. When exactly do you get this?

First time was twenty-five minutes after submission
Second and third time was after about ten minutes.

[wolfe]

Today at 02:50 AM Kriek said this in Post #46 (https://vborg.vbsupport.ru/showthread.php?postid=411235#post411235)
First time was twenty-five minutes after submission
Second and third time was after about ten minutes.


try the new instructions file i uploaded it should make it 10 perpage so it will not cut out

[GunsNetwork]

PHP Fatal error: Call to undefined function: checkdnsrr() in D:\WebSites\GunsNet\WebRoot\forums\admin\email.php on line 396

This is the error I get. Using 2.3.0 and it points to this line.

if (!checkdnsrr($mailDomain, "MX"))

so what is my problem?

BowHunt

[Gary King]

Today at 10:56 PM bowhunt said this in Post #48 (https://vborg.vbsupport.ru/showthread.php?postid=411244#post411244)
PHP Fatal error: Call to undefined function: checkdnsrr() in D:\WebSites\GunsNet\WebRoot\forums\admin\email.php on line 396



This is the error I get. Using 2.3.0 and it points to this line.

if (!checkdnsrr($mailDomain, "MX"))

so what is my problem?


BowHunt

It would be best for your vBulletin if you ran it on a Linux/Unix instead of Windows, like what you are doing now, it looks like.

You can't use this hack on that particular OS you are using when you got that error, sorry.

[Kriek]

Yesterday at 09:56 PM wolfe said this in Post #47 (https://vborg.vbsupport.ru/showthread.php?postid=411236#post411236)
try the new instructions file i uploaded it should make it 10 perpage so it will not cut out
Wolfe, results in the following error upon submission.

Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/gforums/public_html/admin/db_mysql.php on line 191

[wolfe]

heres the fix in email.php find



if ($DB_site->num_rows($users)) {



and replace with



if ($DB_site->num_rows($verifyemail)) {



that should sort it out

[lalo landa]

there's some way to do this check user by user?...

like in edit user options (check e-mail)

And, add something like we check a box in the list of users to do a mass move or prune ??

this add on will be greate.. but the hack it's cool too!!!

Thnxs! (install!!!)

[Kriek]

Wolfe, thanks! Works like a charm aside from the Do next page not working.

[wolfe]

errmmm not sure d00d will take another look @ the code annd gt back 2 u

[Kriek]

/me shows appreciation

[Floris]

This is some original thinking here. I like that. GOod work.
I have installed this and run this on a site with 4000 members just to see how many would show up. And only 10 users had some none existent domain. One had: i@m.god :D

[Capt PPRuNe]

Sorry, but until someone can verify that this will not ground a vB board with over 60,000 members there is no way I'm going to try it. Even if it only took 10 minutes for 4,000 members that works out to at least 2.5 hours for my board.

I already have a hack installed that just does the verification during registration. What you have here is just something that finds old registrations with false email addresses. You might as well just run your 'find registrations awaiting email confirmation' on anything over a week old for example and then delete those. There is also a script that automatically deletes unverified email addresses which are over 10 days old after sending reminders on day 3, 5, and 8 to verify.

Nope, not going to install this one because anything that is going to make the server work hard for a few hours is not on. No doubt good for much smaller membership boards.

Hope you take the above as useful criticism as some hacks really do not take into account the requrements of boards with larger membership levels.

[wolfe]

i am working on fixing this hack so it proccesses then like the update counters does and perpage aswell so it will be alot better for bigger boards :D

[Skyline_GT]

hm..
When I press Begin process
it takes forever to load..
I wait for 4 mins..
i have abouy 6000 members,

[Skyline_GT]

I got this error
Warning: mysql_num_rows(): supplied argument is not a valid MySQL result resource in /home/gamerzon/public_html/forum/admin/db_mysql.php on line 190

[cyberbeggar]

Exactly what I need, I am sick of people registering at my site with fake emails!