MrAddy

Thanks Angelo,

So if I paid for the premium, what I have outlined above will be included. Admin can add users, as bookings, and that user is then sent an email for the event ?

Thanks

Addy

It is happening, here is the function in full

function updateUserWPID($post) {

	global $current_user;

	$post['user_id'] = $current_user->user_email;

	$post['u_id'] = $current_user->id;

	//add_option('testval', $post);

	return $post;
}
add_action('db-before_submit_signup', 'updateUserWPID', 10);

All I am doing is adding the user id, and email, and I thought when the $post is returned with the details already existing, it would just overwrite them. But instead it does nothing ?

I have managed to do this part of the function by using the following code:

<div class="wrap <?php echo $this->wrap_class ?>">

        <?php while ($this->have_groups()) : $this->the_group(); ?>
            <h2><?php //echo $this->group->name ?></h2>

            <table class="section" id="<?php echo Participants_Db::$css_prefix . $this->group->name ?>">

                <?php while ($this->have_fields()) : $this->the_field() ?>

                    <?php if($this->group->name == "main") { ?>
                    <tr class="<?php echo Participants_Db::$css_prefix . $this->field->name . ' ' . $empty_class ?>">

                        <td width="40%"
                            class="<?php echo $this->field->name . ' ' . $empty_class ?>"><?php $this->field->print_label() ?></td>

                        <td width="40%" name="<?php echo $this->field->name ?>"
                            class="<?php echo $this->field->name . '_input' ?>"><?php $this->field->print_value() ?></td>

                        <td width="20%">
                            <div class="<?php echo $this->field->name ?>_edit">
                                <a id="edit" href="" name="<?php echo $this->field->name ?>">Edit</a>
                            </div>
                            <div class="edit <?php echo $this->field->name ?>_save">
                                <a type="submit" id="save" href="" name="<?php echo $this->field->name ?>">Save</a>
                            </div>
                        </td>
                    </tr>
                <?php } ?>
                <?php endwhile; // end of the fields loop ?>
            </table>
        <?php endwhile; // end of the groups loop ?>

</div>

If you also notice, I have added the ability to update a field without having to refresh the page using jQuery. Here is the function for this:

jQuery(document).on('click', '#edit', function (e) {
        e.preventDefault();
        var box = "." + jQuery(this).attr('name') + "_input";

        console.log(box);
        jQuery(box).attr('contenteditable', true);

        jQuery("div." + jQuery(this).attr('name') + "_save").removeClass("edit");
        jQuery("div." + jQuery(this).attr('name') + "_edit").addClass("edit");
        jQuery(box).focus();
    });

    jQuery(document).on('click', '#save', function (e) {
        e.preventDefault();
        var box = "." + jQuery(this).attr('name') + "_input";
        var newVal = jQuery(box).text();
        var column = jQuery(box).attr('name');
        jQuery(box).attr('contenteditable', false);
        jQuery("div." + jQuery(this).attr('name') + "_edit").removeClass("edit");
        jQuery("div." + jQuery(this).attr('name') + "_save").addClass("edit");
        //console.log('VALUE: ' + newVal + ' - And Column to update: ' + column);
        jQuery.ajax({
            url: '/wp-content/themes/dt-the7/functions/sql_functions.php',
            type : 'POST',
            data : 'action=pdb_update&pdb=<?php echo $record->id ?>&col=' + jQuery(this).attr('name') + '&val=' + newVal,
            success: function(res) {

               // console.log(res);
            }
        })
    });

This Ajax call is made to another file which handles the saving of the field. This is what is looks like:

include ('../../../../wp-load.php');
global $wpdb;

$action = $_POST['action'];

switch ($action) {

    case "pdb_update":
        $wpdb->update("xwdi_participants_database", array($_POST['col'] => $_POST['val']), array("id" => $_POST['pdb']));
        echo $res;
        break;
}

Hope it helps others 🙂

Is this possible ? When the button is clicked it goes to WP to redirect, so i would need to catch it in mid flow. Looking at Participants-database.php where you ‘process the form’, line 2273. action is action=update so not sure how i would add anything else to that and have it make sense for the server?

Currently the only thing I have done is

$redirect = $post_input['action'] == 'insert' ? $post_data['thanks_page'] : self::add_uri_conjunction($post_data['thanks_page']) . 'action=update' . $_SESSION['tempServiceLevel'];

So I saved the new part in Session during the custom signup. But i agree using it this way is not ideal. So I could either add to the WP pluggable.php and the core wp_redirect function or leave it as it is. So not sure whats best ?