franpena

Hi Xnau,

First of all, in Participants Database – Settings – Signup Form Settings – Signup Response Email, I have the text (here I substitute sensitive information with XXX):

<p>Thank you, [first_name], for signing up with XXX.</p><p>You may consult your registration information and upload the payment receipt by visiting this private link at any time: <a href="[record_link]">[record_link]</a>.</p>

Then, the registered user receive an email with the text:

<p>Thank you, XXX, for signing up with XXX.</p>
<p>You may consult your registration information and upload the payment =
receipt by visiting this private link at any time: <a =
href=3D"https://www.XXX/?page_id=3D461&pid=3DTZ=
270">https://www.XXX/?page_id=3D461&pid=3DTZ270=
</a>.</p>

In case the WordPress editor changed the previous text, I tell you that in href appears the HTML code of ampersand, that is, &_#_0_3_8_; (removing the underscores).

My guess is that his email reader is configured to interpret the email as plain text but I have no proofs of that, since I have no access to his computer. Only 3 users in 80 reported this problem.

Anyway, I wanted to know if somebody else have the same issue, but I believe that I am alone here ??

Best,
Fran

Sorry, I have realized that in text of my message both links seem to be the same. The second link should appear like this (removing the underscores):

www.<myweb>/?page_id=460_&_#_0_3_8_;_pid=TZ271

When I paste this link in the browser’s address bar, I get “No record found”; the same problem that the user reports.

Thanks,
Fran

Hi bobbysmith007,

I have copied the new code you sent me in functions.php and still nothing appears in the DB Table Editor. I have not created an id column in Event Registrations by myself. Is such column created adding some other code to functions.php?

Sorry if my question is very basic, but I really would like to understand the steps to start working with the plugin.

Thanks again.

Hi, I have the same problem than clarckedesign. I have included in functions.php the code you provide in README:

if(function_exists('add_db_table_editor')){
  add_db_table_editor('title=Employees&table=employees');
  add_db_table_editor(array(
    'title'=>'Event Registrations',
    'table'=>'event_registrations',
    'sql'=>'SELECT * FROM event_registrations ORDER BY date_entered DESC'
  ));
}

Does your answer mean that something related to id_column must be added to the previous code? What else?

Thanks.

Thanks Xnau. As usual, your hints are very clever.

Only to complete the thread, I inform to all that the way I implemented Xnau’s advise was:

1. To edit pdb_record_bootstrap.php (I prefer this template instead of pdb_record_default.php, but it is not important).

2. To insert after the line <label><?php $this->field->print_label()?></label> the following code:

<?php if ($this->field->name <> "proof") $this->field->readonly = 1; ?>

Thanks,
Fran

Just to complete the answer to my own question, I have been able to add two variables from the Signup page, and show the result in the Thanks page, following these instructions:

1. Copy the file wp-content/plugins/participants-database/templates/pdb-thanks-default.php to wp-content/themes/[your_used_theme]/templates, where [your_used_theme] stands for the name of your used theme (create the folder if it does not exist).

2. Edit this file from WordPress, i.e., go to Appearance – Editor – pdb-thanks-default.php

3. Include the following lines inside the main <div>:

<?php
   $total = $this->record->[group]->fields->[var1]->value + $this->record->[group]->fields->[var2]->value;
   echo "<p>The total amount you have to pay is ".$total."€.</p>";
  ?>

where [group], [var1] and [var2] stand for, respectively, a group and two variables in the Participants Database list.