[Alfa1]

Originally Posted by Antivirus

There's a macro application that some members are using in tandem with this mod, it's a few pages back.

Thanks!

Originally Posted by Devices

I am no PHP expert, my PHP knowledge is very basic but this is what I did.

In ezbounce.php on line 46 look for

$vbulletin->input->clean_gpc('r', 'u', TYPE_UINT);

Change it to

$vbulletin->input->clean_gpc('r', 'u', TYPE_STR);

Then on line 51 look for

WHERE userid = " . $vbulletin->GPC['u'] . "

Change it to

WHERE email = " . $vbulletin->GPC['u'] . "

Now the URL will except your users email instead of their userid.

You just need to use

http://yourdomain.com/forum/admincp/ezbounce.php?u=(USERS@EMAIL)

To process the user, replacing (USER@EMAIL) with your actual users email address.

This gives me errors:

PHP Code:

Database error in vBulletin 3.7.1:

Invalid SQL:

            SELECT * FROM vb_user
    WHERE email = user@hotmail.com;

MySQL Error   : You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near '@hotmail.com' at line 2
Error Number  : 1064
Request Date  : Sunday, July 13th 2008 @ 09:58:03 PM
Error Date    : Sunday, July 13th 2008 @ 09:58:03 PM
Script        : http://www.mysite/forum/admincp/ezbounce.php?u=user@hotmail.com
Referrer      : 
IP Address    : xx.xx.xx.xx
Username      : Alfa1
Classname     : vB_Database
MySQL Version : 5.0.45 


I am using vb 3.7.1 PL2