Search Results for 'code'
-
Search Results
-
Righty ho, so while I can’t test my code (on iPhone sorry), I can help shed some more light on this.
First Off: there is not (that I can see) a table called wp_capabilities. There is just a meta_key called “wp_capabilities” in the wp_usermata table. That actually makes some sense
The good news here is, that it’s a 1 to 1 relationship so easy to copy over.
// Show Database Errors
// Comment this line out when going live
$wpdb->show_errors();
// 99 times out of 100 this is overkill
// I’m just being on the safe side
//
// It checks what the current user ID is
if ( !$user_id ) {
$current_user = wp_get_current_user();
$user_id = $current_user->ID;
} else {
$user_id = (int) $user_id;
}
// Connects to the database
// Retrieves the value for this user for wp_capabilities
$user_cap = $wpdb->get_row( “SELECT meta_value FROM wp_usermeta WHERE user_id=$user_id AND meta_key=’wp_capabilities’ LIMIT 1” );
// Checks to see if the user already has a bb_capabilities
// If it does we’ll overwrite it
// If it doesn’t we’ll add a new one.
$user_cap_in_bb_meta = $wpdb->get_row( “SELECT meta_value FROM bb_usermeta WHERE user_id=$user_id AND meta_key=’bb_capabilities’ LIMIT 1” );
if ($user_cap_in_bb_meta)
{
// update bbPress database
$wpdb->query(“UPDATE bb_usermeta SET meta_value='”. $user_cap->meta_value .”‘ WHERE user_id=”. $user_id .” AND meta_key= ‘bb_capabilities’ “);
} else {
// Add a new row to the bbPress database
$wpdb->query(“INSERT INTO bb_usermeta (user_id, meta_key, meta_value) VALUES (“. $user_id .”, bb_capabilities, ‘”. $user_cap->meta_value .”‘) “);
}
// Print all Database errors
// Comment this line out when going live
$wpdb->print_error();
// Hide Database Errors
// Comment this line out when going live
$wpdb->hide_errors();
Now, the disclaimer. This rather unsurprisingly hasn’t been tested by me, and my contain (will contain) a crazy amount of typos.
What it does is relaly simple. It copies the wp_capabilities and pastes them as bb_capabilities in the bbpress table. In terms of your initial goal, firing this code once the s2M stuff is finished will achieve that goal (basically, copy and paste it on the landing/finished/thanks/congrats page).
A quick word of warning. If you’ve been using Zaerl’s plugin or anything else that utilises the “bb_capabilities” meta_key then this will overwrite it. Now as it’s overwriting it with whats in the WordPress database, it’s very unlikely to cause issues.
But if you’ve set up something funny with a bbPress Plugin then you might end up overwriting it. In theory, this shouldn’t happen because the user is registered via s2M, so that’ll be it’s first time in the bbPress database – but I’m just giving you a heads up.
I may write this, with all the failsafe functionality, into a WP/bbPress plugin if I get time in a few weeks. But I’m also a tad wary of encroaching onto ground Zaerl’s been excelling in. Good code doesn’t need my size 13s stomping all over it.
Ok mate, try this and throw me back any errors.
If you did that, I would be humbly in your debt. Though I won’t hold it against you if you don’t have the time to solve my problems
FWIW… I’ve found at least one other individual over on the s2M forum that could probably benefit from the solution. At least I know I’m not alone!
Your help is much appreciated.
Right. Of course!
Seriously, I’m afraid I’m totally lost. I understand your logic, but my lack of PHP skills are shining bright. I’m an art director that had (until now) been successful hacking at standard WP PHP, but am clearly in over my head now. “Select the whozit and insert it into the whatzit now?” 
You’ve been very kind and I’ve never been one to straight up ask for the answer to be spelled out for me. I understand if you don’t want to give up any untested/theoretical code, especially as it pertains to a 3rd party plugin. (unless your last suggestion was to code that elsewhere??) But I do find myself against a deadline and have got to continue adding content and styling or my client is gonna kill me! Believe me, I’d rather work on solving problems all day so I can learn from them.
So, I guess I’m going to have to launch this weekend (client has a conference) and just manually change bbPress user roles on new subscribers (lo-fi and lame, by me) until I have more time next week to dedicate to this solution.
Cheers bud.
<br />
<pre><code>// Line 358 if ($ccaps) /* Add custom capabilities. */
foreach (preg_split ("/[rnts;,]+/", $ccaps) as $ccap)
if (strlen ($ccap)) /* Don't add empty capabilities. */
$user->add_cap ("access_s2member_ccap_" . trim (strtolower ($ccap)));It’s the ” $user->add_cap ” That adds the capabilities to wordpress.
That said, I think the best thing to do would be to follow this:
1) Select * from wp_capabilities where User_id = User_id
2) for each ($row) insert into bb_capabilites blah blah blah
that way you don’t need to know what the s2M is doing, you just need to copy the data from wp_cap to bb_cap when you’re done
Nah that sounds good mate. It’s basically what I was suggesting here:
2) Write some custom code for the s2Member callback API (which it supports) to add a field to the bbPress database.
Basically, what you want to do is look for the bit of code in the s2M files that writes to the wp_capabilities table, and copy it on a new line with bb_capabilities.
Or if you don’t want to go hacking around (totally understandable), make your “landing page” when people finishing paying/signing up via s2M have a bit of code that copies the last row from the wp_capabilities into bb_capabilities. This method means you wouldn’t have to touch the core of WP/bbP/s2M – but would still work.
Doesn’t matter that this isn’t a core question mate, you’re helping us break a bit of new ground here, and we’re always interested in that. bbPress isn’t feature rich, so we like to know when it’s bene extended in a way we all hadn’t thought of
And you’re polite – we like that
Hi Guys, thanks for the info. It’s always good to rule things out
Basically, I’d attempt the following:
1) Log out of wordPress and clear your cookies and cache.
2) Upload and overwrite your existing files with a newly dowloaded version of bbPress
3) If that doesn’t work, set all permissions to 777 and see if it makes a difference.
4) If that doesn’t work. start again with the new files.
I know it sounds annoying, and sorry, but at this stage we’re just covering the bases.
Oh, could you also tell us what server host you’re using?
Thanks !
Plugins directory not updating: Fixed.
Seems it’s not retroactive… I mean, Zaerl’s last plugins are now listed correctly, but all other plugins did not get updated (yet): it looks like my last plugins update was a month ago!
looks like my error logs were disabled.
i guess i can drop my tables and reinstall, but i’m certain i didn’t do anything wrong during the install.
Thanks for the reply!
1. WP 2.9.2
2. Just bbPress with new install of WP… nothing else.
3. Yes, using PHP5
4. I just went through the steps in the BB install. Was going to do the rest in the bb admin, but can’t get there.
5. Not sure where to look for the error log
I doubt anyone needs to release it as a theme, it’s just a custom front page (although a good one for sure).
It just loops through Categories / Forums and then outputs the last topic and last post for each forum with it’s gravatar next to it. The code to do it yourself is already in front-page.php
( I say that without taking away from the excellent work done by lukepuuk and others on the theme )
Exit mate, If you want your bbPress to be/act different than all the others, you’ll have to change more than the CSS/Background. But realistically you don’t need much/any plugins to enable your forum to be unique while staying cool and usable
