Post Admin name

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.

What are you trying to accomplish?

Looks like he wants to add

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

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

Quote:

---

$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. :wink2:

Quote:

---

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. :wink2:

---

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.

I thought ... it was already like that. :blink:

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

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

Ok, let's try this out:

Quote:

---

$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. :thumbsup:

Then, lower, change this block:

Quote:

---

$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.

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?

Quote:

---

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. :wink2: