Mass E-mail by Location Hack Help

[kevinsdh]

Back in 2001 a hack was written about allowing the admin to send mass e-mails by location. I installed it on my 2.2.2 version and it doesn't work. I get a MySQL error as follows:


Database error in vBulletin Control Panel 2.2.2:

Invalid SQL: SELECT userid,usergroupid,username,email,joindate FROM user,userfield WHERE user.userid=userfield.userid AND 1=1 AND adminemail=1 ORDER BY userid DESC LIMIT 0,500
mysql error: Column: 'userid' in field list is ambiguous

mysql error number: 1052



Here is the link to the required code changes and the template changes. Note the template stuff is working. Also, I realize the sequence in one of the steps is wrong - "replace this with this (it was backwards)", I put this in the proper order and did exactly what was otherwise indicated. It is the second part of the request on that page.

https://vborg.vbsupport.ru/showthread.php?s=&threadid=32554&highlight=location+mass+email


Thanks for the help!

[Admin]

Ohh my code. :) Replace:
SELECT userid,usergroupid,username,email,joindate FROM
with:
SELECT user.userid,usergroupid,username,email,joindate FROM

[kevinsdh]

Thanks! Works like a charm! :D