petervnv
Forum Replies Created
-
OK, my question boils down to this.
I need 2 custom fields for registration that the user neither sees nor inputs anything. (alt_id and alt_pass)
alt_id must be an integer between 1000 amd 9999, alt_pass is a random 8 character password.
Now I have created a table in wp named alt_table where I created columns alt_id and alt_pass and have already populated them.What I would like to figure out how to do, is have RPR update the (initially blank I presume since they’re hidden from the registering user) user_meta fields alt_id and alt_pass with the values already existing in the alt_table.
Is this possible? I’ve been looking into RPR sourcecode but I’m getting overwhelmed.
Conceptually I think that somewhere in rpr_activate.php or rpr_signup.php, it should be possible to run a mysql query like $wpdb->get_var(“SELECT alt_pass FROM alt_table WHERE user_id = ‘current user or whatever’ “) and do the same to grab alt_id, then use those values to run update_user_meta once the account has been activated.
Is my thinking correct or am I way off base here?
Any help or pointers much appreciated.
Thanks and Happy New Year
Forum: Plugins
In reply to: [Connect Matomo - Analytics Dashboard for WordPress] Tracking doesn't workYeah, I know. Separate things.
Thanks for your help with the plugin.
Cheers
Forum: Plugins
In reply to: [Connect Matomo - Analytics Dashboard for WordPress] Tracking doesn't workHi,
Disabling caching indeed fixed the wp error message on the plugin.
Now I still have the remaining problem that piwik appears to not work for me at all. I think it’s a compatibility issue between my (super) recent version of MySQL and what piwik expects.
Forum: Plugins
In reply to: [Connect Matomo - Analytics Dashboard for WordPress] Tracking doesn't workI see the following error message when I run system check:
Error:
Try #1: LOAD DATA INFILE : SQLSTATE[28000]: Invalid authorization specification: 1045 Access denied for user ‘piwik’@’localhost’ (using password: YES)[28000],
Try #2: LOAD DATA LOCAL INFILE : SQLSTATE[42000]: Syntax error or access violation: 1148 The used command is not allowed with this MySQL version[42000]I’m using MySQL version 5.5.33 and PHP 5.5.7 on Debian Wheezy. Pretty sure the password is OK but I will recheck
Forum: Plugins
In reply to: [Connect Matomo - Analytics Dashboard for WordPress] Tracking doesn't workI have the same problem. Using WP 3.8
When I add the API key and click save, I get the message:
An error occured: Please check URL and auth token. You need at least view access to one site.Now I’m pretty sure my url and api key are correct. I enabled auto-config and I see there are two blogs (I only have one) with the exact same name in my Piwik dashboard, but both show 0 traffic.
Answering (partially) my own question, I see that RPR stores custom fields in wp_usermeta table.
Is it possible for RPR to grab data from my own custom field, even if it’s in wp_users table, and insert that data into the new user welcome email?
Or, alternatively, I could use another plugin to fire off a custom welcome email after the RPR one has been sent.
Unfortunately this seems to cause a conflict in RPR because it is already hooked into wp_new_user_notification. Any help or ideas on how to get this done?