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:

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

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:

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

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

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

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

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:

Sorry brains a bit adled from the sun today!! I meant '$from'. This is what I changed the code to with no avail:

			$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['customers_email_address'] . "', now() )");

I wonder what variable it is that holds the logged in admin users name?

try this,
not tested

$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() )");

Hi Merlin

Thanks but I had already tried that suggestion earlier. is $from the only variable that holds the elusive admin users id?

How rude - I wasn't notified by email for these last two notes. :blink:

Anyway. Here's a modification I just coded while you were waiting (untested - so make a backup of the file first).

On that same file,

find:

$id1 = create_coupon_code($mail->fields['customers_email_address']);
$insert_query = $db->Execute("insert into " . TABLE_COUPONS . "
(coupon_code, coupon_type, coupon_amount, date_created)
values ('" . $id1 . "', 'G', '" . $_POST['amount'] . "', now())");

  $insert_id = $db->Insert_ID();

  $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() )");

replace with:

$id1 = create_coupon_code($mail->fields['customers_email_address']);
      $insert_query = $db->Execute("insert into " . TABLE_COUPONS . "
                                    (coupon_code, coupon_type, coupon_amount, date_created)
                                    values ('" . $id1 . "', 'G', '" . $_POST['amount'] . "', now())");

      $insert_id = $db->Insert_ID();

      $mail_from = $db->Execute("select admin_name FROM ".TABLE_ADMIN." where admin_id = '".(int)$_SESSION['admin_id']."'");

      while (!$mail_from->EOF) {
      $sent_from = trim($mail_from->fields['admin_name']);

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

Then, a couple of lines below,

find:

$insert_query = $db->Execute("insert into " . TABLE_COUPONS . "
(coupon_code, coupon_type, coupon_amount, date_created)
values ('" . $id1 . "', 'G', '" . $_POST['amount'] . "', now())");

  $insert_id = $db->Insert_id();

  $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() )");

}

replace with:

$mail_from = $db->Execute("select admin_name FROM ".TABLE_ADMIN." where admin_id = '".(int)$_SESSION['admin_id']."'");

      while (!$mail_from->EOF) {
      $sent_from = trim($mail_from->fields['admin_name']);

      $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', '".$sent_from."',
                                            '" . $_POST['email_to'] . "', now() )");
      }

    }

Recall: Make a backup of the file, first, before you proceed. :wink2:

You've cracked it :) Thanks alot to both you and Merlin for your precious time on this

Excellent. Thanks for updating, Glad to see it worked out well for you. :thumbsup: