Administrative and Maintenance Tools - Use User Profile Fields in AdminCP Emails

This is a very quick mod. This is my first release, so I appologize if I've missed any normal verbage or protocols.

I tried to make this simple, but I'm not the best at explaining things. Let me know if you have any questions and I'll do my best to help you out.

This was requested here:
https://vborg.vbsupport.ru/showthread.php?t=150947

This mod will allow you to insert your custom User Profile Fields into emails sent via AdminCP. I have not tested it, but this might work for other mods that use the email.php script in admincp.

See below for the modification. You can also download the attached txt file if you wish.


** This mod requires that you edit a core file. If you upgrade, you will need to re-edit the file. **


In the following examples, I have created a field, field12, that holds 'Game Version'. This mod works best for text fields and single drop-down lists.

Step 1: Noting Your Fields
Go to your User Profile Fields and make note of which fields you want to use in your emails. Also make note of the field Name, seen to the left of Display Order (i.e. field12).


Step 2: Editing File
Open admin/email.php - make a backup just in case!


Step 3: Pulling fields from database
Around line 130, find

SELECT user.userid, user.usergroupid, user.username, user.email, user.joindate,
useractivation.activationid

After add

, userfield.field12

Add additional ones if you have multiple fields you want to use in your emails.
Your lines should look something like this:

SELECT user.userid, user.usergroupid, user.username, user.email, user.joindate,
useractivation.activationid, userfield.field12

Step 4: Naming the Variables
In this step you will name the variables that you use in your email. Just like $username inserts the member's username, you will want to choose something easy to remember and short. I've chosen $gameversion.

Around line 163, find

array('$email', '$username', '$userid'),

After '$userid' add the variable you want to use, including the dollar sign.

, '$gameversion'

Your line 163 should look something like this:

array('$email', '$username', '$userid', '$gameversion'),

Step 5: Linking field and variable
Around line 164, find

array($user['email'], $user['username'], $user['userid']),

After $user['userid'] add in $user['X'] where X is the field's name.

$user['field12']),

Your line 164 should look like this:

array($user['email'], $user['username'], $user['userid'], $user['field12']),

Step 6: Testing
You DID make a backup copy, right? Good! Now, save and upload the email.php file, and send an email to yourself via AdminCP using your spiffy new variable!

Hello $username,
Your game version is $gameversion - time to upgrade!

[edenx]

Will be great if this was done via plugins...

[Elenna]

Sorry, I don't know how to do that

[gsmlover4u]

Originally Posted by edenx

Will be great if this was done via plugins...

agree with you...................

[WhaLberg]

This is a great idea.

[Elenna]

Originally Posted by gsmlover4u

agree with you...................

Feel free to take a stab at it Thus far no one has released anything like this, so it would be most appreciated if you could either help me with the plugin, or be happy with what I've released.

[Elenna]

This mod still works for 3.7, although I haven't figured out how to add it to that section

If you have upgraded and use this mod, please remember to re-edit your files!