Since there are going to be more than one post (lesson) per user, your code would be more like this: <?php if ( is_user_logged_in() ) { $user_ID = get_current_user_id(); $post_ID = get_the_ID(); $viewed = get_user_meta( $user_ID, ‘viewed_lesson_tracking’, true); if(empty($viewed)){ $viewed = array(); } $viewed[] = $post_ID add_user_meta( $user_ID, ‘viewed_lesson_tracking’, $viewed ); // tracks that user … Read more
The second one is revision. It means the changes that you made, but didn’t save. WordPress saves that as revision post. There might be more than one revision post if you make more changes without updating the post. You don’t need to worry about that. It’s all in background and won’t affect you in any … Read more
there are two possible injection vectors, server side and client side server side – Just don’t write your own SQL and use the more high level DB access APIs, in your case probably update_option. If you must to access the DB at lower level make sure the API use wpdb::prepare while generating the SQL, which … Read more
Steven, I think you are looking for the save_post action, you should create the function you want to use and use the add_action function. You can find the data from the custom fields in the $_POST array. You don’t have to worry about the “other content”, at least if with that you are referring to … Read more
I think you will require to custom develop some part of it but most of it can be done with Contact Form 7 plugin. You can create forms with upload fields very easily in Contact Form 7. And you can make it visible for loggenin users only like this. <?php if ( is_user_logged_in() ) { … Read more
Ditto Otto – Q: “What is your suggestion on running a large database?” A: Don’t do it on shared hosting. Shared hosts have CPU limits, so any queries run on a database that large will be slow or time out. Shared hosts also have database size limits, so your database with 500K posts may be … Read more
By default, wordpress get_results return a numerically array of objects, so to use echo to print your data yo should do something like; foreach($myrows as $line){ echo $line->question; }
In this case, I would suggest a server specifically for the database – a DB server. Server A & B could interact with it, and chances are, it would ease some of the tension and performance related issues with Server A.
Normally WordPress does not allow you to delete ‘super admin’ through its dashboard, all other users can be deleted. But in your case I think, its some one who deleted all users from the table directly by accessing your WordPress database via phpmyadmin or so. Even if there is no users in the site, the … Read more
WordPress already has both user and post meta data tables, and associated API for handling the data. Storing an array of post IDs for each user in user meta sounds like it would work for your application.