mlapl1

Thank you Peter. You are so kind. Actually I am using it in what I hope will be a language learning website. Because of the way the learning tools are constructed and WP and the learning management system I am using are constructed I am not able to pull students’ scores and other information easily out of the WP database and display them. WP Data Access goes a long way toward solving that problem especially with its ability to incorporate sql queries and also javascript (I think- I have not looked in detail). I will happily review the information that you sent me on variables. I know it will be really helpful.

Best to you
Andrew

Thank you so much Peter. That’s exactly what I was looking for. Are there any more $$ variables available from inside WP Data Access?

Cheersw
Andrew

Hello Ben

I did go through all of the plugins and there was a problem with one called something like one-click starter templates or something like that. I removed it and all is ok now. I should have done this before alerting you but it seemed to be a problem specific to the kadence plugin (but was not).

Thanks again for your prompt response
Andrew

Hello Oliver

I sent you an email at the address on your personal website
Cheers
Andrew

The admin role already had all the roles included… ??

Hello Oliver

Just went through a ‘troubleshooting’ exercise. No good results.
For what it’s worth, I am using PHP7.3.19 and MariaDB10.3
I will try the user role plugin again.

Cheers
Andrew

Hello Oliver
Well… I found the httpd logs – no php errors that I can see… I think I know what that would look like. I may try disabling some/all of the plugins and see if that makes a difference.

On a different note, what I would really like is the ability for the students to access all or part of the stored information. Is this possible? Is there maybe a shortcode that can be embedded in a page??? Otherwise, maybe a different front-end for the data may be needed.

Thanks once again – I will keep you informed.
Andrew

Hello Oliver
I am running a VPS so will have access to the logs – it’s a new install so I am not familiar with where the logs are. I guess I will discover it. Thank you for your suggestions. Yes I forgot about phpinfo. Will look now. I did install user role editor but I have not yet tried to change things. I guess I would have to change the admin role but, as you say, admin should access all.

Thank you and back to you soon.
Andrw

Hello Oliver,

Sorry did not see your name last time. I understand the rules etc. I just don’t understand where and how to use them, that is how to insert them into the operations. I will try to find the relevant logs. That should help as you say. Otherwise, I can just read the database itself directly through some kind of frontend in order to do something with it.

Thanks again for your help
Andrew

Hello Otacke

Thanks for your response. I have read the readme file again but confess to feeling a bit lost (see below for the bits I dod not understand).

For what it’s worth, I can see the plugin’s settings. I have not yet looked at the PHP error log etc. I will do that soon. But can you please explain briefly the following?

Thank you very much
Andrew

### Capabilities
Some capabilities can be set for WordPress user roles in order to specify who
should be allowed to do what:

– _manage_h5pxapikatchu_options_: Capability to change the plugin’s options
– _view_h5pxapikatchu_results_: Capability to view results of content types that have been created by current user and that were stored by H5PxAPIkachu
– _view_others_h5pxapikatchu_results_: Capability to view results of all content types that were stored by H5PxAPIkachu
– _download_h5pxapikatchu_results_: Capability to download the results stored by H5PxAPIkachu and accessible to current user
– _delete_h5pxapikatchu_results_: Capability to delete ALL data stored by H5PxAPIkachu

### Hooks and filters
H5PxAPIkachu provides some hooks and filters that developers can use to customize the behavior or to use H5PxAPIkachu as the basis of their own plugin.

#### Hooks
– _h5pxapikatchu_on_activation_: Triggered on activation of H5PxAPIkachu
– _h5pxapikatchu_on_deactivation_: Triggered on deactivation of H5PxAPIkachu
– _h5pxapikatchu_on_uninstall_: Triggered on uninstall of H5PxAPIkachu
– _h5pxapikatchu_insert_data_: Triggered when data are supposed to be inserted into the database
– _h5pxapikatchu_insert_data_pre_database_: Triggered right before data will be inserted into the database
– _h5pxapikatchu_delete_data_: Triggered when data are supposed to be deleted from the database

#### Filters
– _h5pxapikatchu_insert_data_actor_: Allows to filter/retrieve the xAPI actor object when it is supposed to be inserted into the database
– _h5pxapikatchu_insert_data_verb_: Allows to filter/retrieve the xAPI verb object when it is supposed to be inserted into the database
– _h5pxapikatchu_insert_data_object_: Allows to filter/retrieve the xAPI object object when it is supposed to be inserted into the database
– _h5pxapikatchu_insert_data_result_: Allows to filter/retrieve the xAPI result object when it is supposed to be inserted into the database
– _h5pxapikatchu_insert_data_xapi_: Allows to filter/retrieve the complete xAPI statement string when it is supposed to be inserted into the database

Thank you so much for the reply. Closing this thread is fine. I will send you a link and admin access by email.

Best
Andrew

Thank you @joyously and @bcworkz. I have investigated the API a bit but got a bit confused as I was not quite sure how to code it (at least the docs did not give me the information I thought I needed). I did not use wp_localize although I had heard about it.
I solved it in the end by connecting from JS to a php file that ran wp_get_current_user function and then reading the response into JS variables. It’s not very elegant or very fast but it works pretty well. I will keep looking for a better solution like the ones you suggested.

Thanks once again
Andrew

Thank you so much @macmanx . I keep forgetting about plugin conflicts in wp. I will try your solution.

@bcworkz – Thank you so much and sorry for my late reply.

I agree entirely about the security – that’s why I mentioned authorized access only.

Thank you for the suggestion of a custom shortcode. Although I do code in PHP and JS, I am hardly an expert and know nothing about the internal workings of WP.

My problem is that I want to run some lessons written with authoring systems such as Lectora or Articulate. I need to upload them and protect them from unauthorized access. LMS plugins currently available either do not allow uploads in a simple way and offer very poor security (especially if you can guess the URL of the file you want). So basically a student would click on a link in WP and would be taken to a fike that would run a lesson. Issues of record-keeping etc would be dealt with by the lesson code, not WP. While there are dedicated LMS systems, there are good reasons for using WP too, especially for appearance and monetization. It may be possible to write a new LMS structure meeting the requirements but WP offers many facilities that are constantly revised and updated, making it a better choice.

Anyway, thanks so much for your help – I will try and followup somehow or just give up and look at other options.
Andrew

Tried php 5.6.39 (FastCGI served by Apache). No change. Nothing seems to work. Sorry, I have run out of time. May try again later. Thanks for the help.