Support

November 11, 2016 at 2:01 pm

In that particular thread they were modifying the invoice template found in /event-espresso/gateways/invoice/template.php.

November 11, 2016 at 2:30 pm

You’ll need to locate the invoice template first, and that’s in wp-content/event-espresso/gateways/invoice/template.php

November 11, 2016 at 3:59 pm

You actually don’t change anything in invoice_vars.php, the file you are going to edit is template.php. The changes to make are outlined in Dean’s reply here:

https://eventespresso.com/topic/invoice-edit-to-add-a-question-company-name/#post-58301

November 11, 2016 at 4:28 pm

You’ll need to follow Dean’s directions carefully. The part where he wrote:

replace the 2 with your question id (20).

is important because that’s how you reference the Hospital or Affiliation field. If you don’t know the field ID, you can get that field by going to Event Espresso > Questions, then go to edit that field. The field ID will appear in the URL of the page where you edit that question.

November 11, 2016 at 4:56 pm

The actually variable name itself isn’t important as long as it’s unique (not already in use for something else) and it’s also important that you consistently use that name. So to keep things simple, you can use $organization_name and that will follow the code in the other thread more closely.

November 11, 2016 at 6:53 pm

Can you post the full contents of your modified template into a paste bin or a gist, then post a link to that code here? Then we can take a look at that code.

November 14, 2016 at 7:49 am

The problem is the query to pull in the custom question is commented out.

Lines 90 through 98 have:

/* $q_sql = "SELECT ea.answer, eq.question
  FROM " . EVENTS_ANSWER_TABLE . " ea
  LEFT JOIN " . EVENTS_QUESTION_TABLE . " eq ON eq.id = ea.question_id
  WHERE ea.registration_id = '".$registration_id."'";
  $q_sql .= " AND ea.question_id = '11' ";
  $q_sql .= " ORDER BY eq.sequence asc ";
  $wpdb->get_results($q_sql);

  $organization_name = $wpdb->last_result[0]->answer;//question_id = '9' */

The /* and */ are multi line comments, they comment out all of the code between them, remove those and $organization_name should be answer for question id 11.

When posting code we recommend either creating a gist here:

https://gist.github.com/

Or you can use something like pastebin:

http://pastebin.com/

Then post the URL for us to view here as MS Word (and other word processors) adds its own formatting to the code.

November 15, 2016 at 6:38 am

You actually copy the entire invoice folder over to /wp-content/uploads/espresso/gateways so your changes do not get overwritten on an update.

November 15, 2016 at 11:20 am

You’ll probably need to contact your host and ask about how to fix the file/folder permissions there.