bleedblue07

the global $wpdb; worked. So that’s all good now. For now I’m going to continue php on posts and pages. If I ever understand your code, maybe I’ll try to figure out how plugins work another time.

So is the post_id a built name that wordpress recognizes or could we have named that anything like “penguin”?

I will need to be able to limit getting points to one time for anything. So not just when someone lands on a page or post. So for example, if they click a submit button on that page it’s 15 points, maybe a like button on the same page for 5 points, then just for going to that page (since maybe it’s a new article I want people to read) they get 10 points, etc.

Now that I figured out how to insert something in general, I’m just trying to break down your code a little at a time and figure out what it’s going to do.

I’ve had a little time to do some research but am still having trouble. Before I tried to get the code you posted above to work I just wanted to to be able to insert anything to any table. Yet somehow that isn’t working either.

I found a site that explains $wpdb and I copied a code from there exactly except changed the user_id from 1 to 4. This is the code:

$wpdb->insert($wpdb->usermeta, array(“user_id” => 4, “meta_key” => “awesome_factor”, “meta_value” => 10), array(“%d”, %s”, “%d”));
?>

This is the error:
Parse error: syntax error, unexpected ‘%’, expecting ‘)’ in /homepages/8/d195441424/htdocs/test/wp-content/plugins/allow-php-in-posts-and-pages/allowphp.php(373) : eval()’d code on line 1

I’m trying to google the errors I get first but I can’t seem to figure it out. Any ideas?

Also I couldn’t find anything on this part of your code VALUES (“.$user_id.”, “.$post_id.”, “.$points.”) Why do you have . inside the ” “?

You mentioned to create my own table and store the points against the user ID and post ID. What does that mean to store against the user ID? How do I do that?

I set up a new table exactly (hopefully) the same as the usermeta table. I’m also not sure how to add things to that table like we did before with add_user_meta. I tried that with my mine: add_userpoints hoping that it would add to my userpoints table but it did not.

I posted my follow up before I realized you responded. You’re too quick haha.

I’ll take a look at it for sure. I’m still pretty novice at this stuff so it’ll take me a bit to understand. Will your way work for things like submit buttons or clicking links? Or will that just work for pages.

Awesome!!!! That works! Thanks very much for your help. I’m gonna press my luck and ask you another question. How would I limit someone to getting points just 1 time. For example, to get this thing working I have it set up so a user gets 20 points for going to a certain page, say the homepage. I don’t want them getting 20 points for that every time, just the first time. Or say 5 points if they vote on something. I don’t want them casting 10 votes and getting 50 points, just the 1. Any ideas of how to go about doing this? Where to start?

An example would be: What percentage of people like the color blue? Then when you submit your answer, a progress bar show you the average of all the answers say 72%.