Email New Account Notification - setup question

Hi csdesign

Thanks for posting!  

Hopefully the plugin's author will see this post but in the meantime, I suspect that the variables mentioned are set in the plugin file itself. If you open the script in a text editor, you'll see the following:

$GLOBALS['GL_ENA_LINK_NAME'] = 'email account activated';  // the link name in the list
$GLOBALS['GL_ENA_MEMBER_LOGIN_LINK'] = 'http://www.yoursite.com'; // membership link used in email
$GLOBALS['GL_ENA_MEMBER_LOGIN_LINK_TEXT'] = 'Your Member Site Text'; // membership link text used in email

That's what I think you are looking for. Does that make sense? Have a look and let me know any questions.

Thanks!

Hi Tina

Thanks for the update!

Had a look through your code and I have an idea of what's happening.  First though, you are on the right track with changing firstName to fullname; that was definitely a problem.  The new error you are getting is related to the extra single quote after the num = '35' part:

'FROM cms_accounts WHERE num = '35''

You can see the extra single quote there. To track this down, I found in the plugin where that SQL query is created:

 $query  = "SELECT firstName, email, lastName FROM {$TABLE_PREFIX}".mysql_escape($_gl_ena_tableName)." WHERE num = '" .mysql_escape($_gl_ena_recordNum). "'";

Which lets us know that the "35" in your example is coming from "$_gl_ena_recordNum". Looking further up in the code, that variable is set with:

$_gl_ena_recordNum = (int)@$_GET['gl_ena_recordNum'];

Which is grabbing the value from the URL of the page you are on when you trigger the plugin. I am wondering if you could post up what you see after the admin.php script on the page you trigger the script from? Does anything there seem out of place?

If this doesn't get us anywhere, I think it might be time to try and contact the deveveloper of the plugin. Our site has them listed as: Graphic Lingoes: http://www.graphiclingoes.com/

Let me know what you think. Thanks!