Jim R

Thanks blondishnet.

RVoodoo, I couldn’t get Register Plus to work for 2.8.5. I wonder if I missed something. Just install and use? I was working pretty late on it. Once I got Theme My Login installed, it worked as I wanted it for my users, so I gave a *golf clap* and went to bed.

Using Theme My Login I haven’t had any spam since using it. I know it’s just been a couple of days, but I usually get one signup a day.

Thanks…very clean and simple for the user. The question is now, how has it worked with spam?

https://hoosierhoopsrepot.com

Uhm…yeah….it worked. I forgot to activate it. ??

The more I looked at it, the more the code made sense. I get stuck with all the variables. I was thinking of digging in tomorrow and making a function, and it dawned on me that I had not activated it. I was trying to figure out how the plugin worked since I didn’t a-c-t-i-v-a-t-e it…DOH!!!

Pretty cool. Pretty impressive. Thanks!

Edited this entry.

I created the file and saved it in the plugins folder. It’s not Updating my custom table with the Tag ID in the appropriate row.

And it’s just going to work? I don’t have to call the function or include the file anywhere? ??

You can use regular MySQL functions inside WP, at least through PHP. I’m using them in a couple of places, just standard Select commands. I was able to do it with my custom table in its own database, but that did create conflicts with some widgets. Moving the table to my WP database eliminated those conflicts.

Which file are you calling or putting that function?

Where are you defining which table to Update? I’ve been testing the on the backup one. I’d need to change it eventually.

I just want this to work:

mysql_select_db("jwrbloom_wpHHR");

 $wp_tagID = get_query_var('tag_id');
 $wp_slug = get_query_var('tag');

$query ="UPDATE wp_playerRank-backup SET wpID = '$wp_tagID' WHERE wpSlug = '$wp_slug'";

When an Author, presumably me most of the time, Posts, there will be Tags attached to that Post. For each Tag, I want it to find the matching ‘tag’ (Slug) in my custom table and Set the wpID column in that row with the same ‘tag_id’.

I need to know where to put that or even a function. I probably need a foreach loop now that I think about it. I didn’t when I applied the Update query directly in my table to retrofit the wpSlug data retrofitting Slugs to my previously created 449 rows of data.

All that does is just confuse me right now. I don’t really need to learn the kitchen sink right now, just basics for my need. The rest can come later, as I apply what I’ve learned.

So I create a function…assuming it’s the query above I posted. At the end of it I add:

add_action('publish_post', 'name_of_function');

Is that right?

And why can’t I just use a regular query in the correct location?

Yes, that is the only additional query, and I moved my custom table into the WP database. It was causing conflicts with the widgets. I’m assuming you think the code I have should work, at least the syntax looks good. Right?

Am I in the correct file too, post.php?

So are you saying that if I “add action” to publish_post, anything within that function is executed when I publish a post?

I’m not making heads or tails of what to do with it. FWIW, I am putting the code in a separate PHP file and just inserting it, or at least that was my intention. To me that seems no different than creating a function then calling for that function to be executed.

I’m just trying to Get two pieces of Tag data and Updating my custom table. I have no clue where to put it, even if I were to understand the API information you linked enough.

Using logic based on what I read, when I publish a Post, it triggers things to happen, including Inserting Tag information. I want it to also Update a column in my custom table where I already have hundreds of a rows of player data.

It didn’t work.

One question should be, where do I put it? Right now it’s toward the end of…

wp-admin/includes/post.php