Post Admin name

**ink** · 6 Jun 2006, 09:49 AM

Hi

How do I change the following code to post the actual 'admin_name' from the admin table into the 'sent_fistname' field in the coupon_email_track table?

I think this is the code to alter in the relevent file:

$db->Execute("insert into " . TABLE_COUPON_EMAIL_TRACK . "
(coupon_id, customer_id_sent, sent_firstname, emailed_to, date_sent)
values ('" . $insert_id ."', '0', 'Admin',
'" . $mail['customers_email_address'] . "', now() )");

Thanks.

**Kim** · 7 Jun 2006, 02:30 AM

What are you trying to accomplish?

**Merlinpa1969** · 7 Jun 2006, 02:35 AM

Looks like he wants to add

this coupon was sent curtesy of ( admin real name here )

**TheOracle** · 7 Jun 2006, 04:30 AM

The following bolded statement is the one you need to modify from your quote above:

$db->Execute("insert into " . TABLE_COUPON_EMAIL_TRACK . "
(coupon_id, customer_id_sent, sent_firstname, emailed_to, date_sent)
values ('" . $insert_id ."', '0', 'Admin',
'" . $mail['customers_email_address'] . "', now() )");

it should be changed into the existent string that actually gathers the sender's firstname.

**ink** · 7 Jun 2006, 12:36 PM

Originally Posted by TheOracle

The following bolded statement is the one you need to modify from your quote above:

it should be changed into the existent string that actually gathers the sender's firstname.

I totally agree, what I want to substitute it with is, the detail of whatever the admin user who is logged in at the time is.

For example, say John who works for us, is logged in to the admin backend of the store sends a credit to a customer, it would show him as the sender on the report.

Hope you follow if not please feel free to let me know.

**TheOracle** · 7 Jun 2006, 01:53 PM

I thought ... it was already like that.

I'd sure be happy to make this modification. I will post the results shortly (if no one else post it before I do).

**Merlinpa1969** · 7 Jun 2006, 01:54 PM

this is only hindered by the fact that unless you use your employees real names for usernames it could look rather funny.

**TheOracle** · 7 Jun 2006, 02:13 PM

Ok, let's try this out:

$db->Execute("insert into " . TABLE_COUPON_EMAIL_TRACK . "
(coupon_id, customer_id_sent, sent_firstname, emailed_to, date_sent)
values ('" . $insert_id ."', '0', 'Admin',
'" . $mail->fields['customers_email_address'] . "', now() )");

change to:

Code:

$db->Execute("insert into " . TABLE_COUPON_EMAIL_TRACK . "
                    (coupon_id, customer_id_sent, sent_firstname, emailed_to, date_sent)
                    values ('" . $insert_id ."', '0', '".$from."',
                            '" . $mail->fields['customers_email_address'] . "', now() )");

After applying these modifications, it should show the current admin's email as result.

Then, lower, change this block:

$insert_query = $db->Execute("insert into " . TABLE_COUPON_EMAIL_TRACK . "
(coupon_id, customer_id_sent, sent_firstname, emailed_to, date_sent)
values ('" . $insert_id ."', '0', 'Admin',
'" . $_POST['email_to'] . "', now() )");

to read:

Code:

$insert_query = $db->Execute("insert into " . TABLE_COUPON_EMAIL_TRACK . "
                                    (coupon_id, customer_id_sent, sent_firstname, emailed_to, date_sent)
                                    values ('" . $insert_id ."', '0', '".$from."',
                                            '" . $_POST['email_to'] . "', now() )");

Note: Backup your file first.

**ink** · 7 Jun 2006, 03:29 PM

Really appreciate your help Guys - I'm toatally lost on this one!

Unfortunately '$this' is not holding the required info. Are you sure that that is the variable holding the admin logged in users identity?

**TheOracle** · 7 Jun 2006, 04:10 PM

Unfortunately '$this' is not holding the required info. Are you sure that that is the variable holding the admin logged in users identity?

Unfortunitely, I cannot find any results on this topic where I mentionned anything about '$this'. I can only find: '$from'. Perhaps you saw another word when reading my last post.