vb.org Archive - 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

Code:

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

useractivation.activationid

After add

Code:

, userfield.field12

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

Code:

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

Code:

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

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

Code:

, '$gameversion'

Your line 163 should look something like this:

Code:

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

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

Code:

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

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

Code:

$user['field12']),

Your line 164 should look like this:

Code:

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!

Quote:

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

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.01080 seconds Memory Usage 1,731KB Queries Executed 10 (?)
More Information
Template Usage: (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (9)bbcode_code_printable (3)bbcode_quote_printable (1)footer (1)gobutton (1)header (1)headinclude (6)option (1)post_thanks_navbar_search (1)printthread (7)printthreadbit (1)spacer_close (1)spacer_open Phrase Groups Available: global postbit showthread	Included Files: ./printthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/class_bbcode_alt.php ./includes/class_bbcode.php ./includes/functions_bigthree.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete printthread_start bbcode_fetch_tags bbcode_create bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete printthread_post printthread_complete
Messages: