[@wythagy Participant 16 years, 2 months ago]

Any ideas anyone?

[@wythagy Participant 16 years, 3 months ago]

I’ve been there all day lol!

[@wythagy Participant 16 years, 3 months ago]

my logic in my $sql statement above was that I want to return a table where all those cases are true, and then count the rows where there are more than 1 instance of the same user_id, meaning it matched both arguments…however, the code I wrote above didn’t work this way…perhaps I’m just writing it wrong?

[@wythagy Participant 16 years, 3 months ago]

@r-a-y I’ve actually already tried that exact SQL query (it seems to make logical sense at first glance) but it doesn’t work because the “AND” statement is trying to make 2 different rows with different values match…which, obviously they don’t. They share a common user_id, but not field_id or value…thus being the problem.

[@wythagy Participant 16 years, 3 months ago]

@r-a-y Actually the problem is that the data is on the SAME table…not a different one…if it were different tables this would be easier

[@wythagy Participant 16 years, 3 months ago]

Since I’m being ignored, I’ll try adding more info…

bp_xprofile_data table:

id | field_id | userd_id | value

---

1 | 2 | 30 | General
2 | 3 | 30 | Female
3 | 4 | 30 | Los Angeles
4 | 2 | 32 | Premium
5 | 3 | 32 | Female
6 | 4 | 32 | Boston
7 | 2 | 35 | General
8 | 3 | 35 | Male
9 | 4 | 35 | New York

What I want to do is search for all user_id’s that are “Male” and “General”, meaning I need to query where (field_id=2 and value=’General’) AND where (field_id=3 and value=’Male’).

Here is what I have and it doesn’t work:

$sql = “SELECT user_id FROM bp_xprofile_data WHERE value IN(‘General’,’Male’) HAVING COUNT(user_id) > 1”

This returns a value of “30”, corresponding to the first user in the table, however the first user is “Female”….not “Male” – when the search query SHOULD return user_id “35”.

so….one last time, I’m really trying here people….any help?

[@wythagy Participant 16 years, 3 months ago]

A tip or URL leading me in the right direction would be more than enough!

[@wythagy Participant 16 years, 3 months ago]

Anything, anyone?

[@wythagy Participant 17 years, 6 months ago]

BuddyPress requires a WordPress Mu install, so no matter what, it can’t be a 1 step process (thus ruling out the 1-click install). Even if they could do it, BuddyPress lacks the history of successful version releases, support networks, and popularity that WordPress, Drupal, and ZenCart offer.

[@wythagy Participant 17 years, 6 months ago]

I wouldn’t think it would be too hard…obviously you’ll have to set up your own plugin/widget/page to put it on, but take a look in mu-plugins>bp-wire.php and the bp-wire folder which control all of that on a member’s page.

[@wythagy Participant 17 years, 6 months ago]

@Josh9989

I think one of the reasons there is a separate Member’s theme folder/CSS is because it is such a unique thing (ie. it’s not typical WordPress), whereas the blogs and site itself can use any old theme (with some exceptions).

The only thing that you really have to pay attention to is how you display the three columns that the member’s section is displayed in by default. By simply editing those widths, how they “float”, and other basic CSS attributes, you can easily change how they fit within the page and you can easily match your blog theme.

Hope that helps…

[@wythagy Participant 17 years, 6 months ago]

I don’t think there is Mawjoud, but you can use any simple text editor for something like a simple CSS file. There are also lots of free text editors like TextWrangler that are good for code editing (nice and color coordinated)

[@wythagy Participant 17 years, 6 months ago]

I’m sure someone has got to have some helpful input?

[@wythagy Participant 17 years, 6 months ago]

I’m not quite sure what you are asking…judging by your thread title you’ll need this function:

bp_core_get_username( $uid )

and then you can just call the profile fields accordingly…

[@wythagy Participant 17 years, 6 months ago]

I’m a Media Temple fan – in my opinion it has some of the best control panel features available, and it’s GridServer(gs) is fantastic for a shared server. It is also very easy to upgrade from a (gs) to any of their higher hosting plans.

I’ve been using MT for about 4 or 5 years now and I’ve never had an issue. They are a little pricey, but I think you get what you pay for and more.

My $0.02

[@wythagy Participant 17 years, 6 months ago]

Okay that is weird – I don’t know why that would be showing up, or even HOW that would be showing up!! I’m thinking it’s gotta have something to do with you being in Italy (i’m assuming)? I’m in the US, so I’ve never even heard of Alice lol!

[@wythagy Participant 17 years, 6 months ago]

Sgrunt, are you sure you are using IE7? I just tried with IE7 on my computer and couldn’t seem to get the same issue.

Thank you for the feedback though anyway!

[@wythagy Participant 17 years, 6 months ago]

Thanks, I use Firefox and Safari, so i’ll have to check the IE7 deal…I thought I checked it before on IE7 and I didn’t remember any issues.

What is the “Alice” header?

[@wythagy Participant 17 years, 6 months ago]

I would LOVE to start getting some feedback on the site I am currently creating (still in beta) called Modelrific™. It is a modeling and photography community.

http://www.modelrific.com

username: test

password: test

(You’ll need these just to see the page, as I have it server-side protected)

You can log in to the actual site using:

username: testuser2

password: testuser2

Please let me know what you think!

[@wythagy Participant 17 years, 6 months ago]

Okay weird, this time I edited the values of the height’s and width’s of the bp-core-avatars.php file and it worked fine…I give up on trying to understand these things…I’m either a little retarded or things choose to work only when they know I’ve tried everything and I’ve given up and asked someone on the forum…

[@wythagy Participant 17 years, 6 months ago]

Yea I looked there and it seems like it takes the variables straight from the bp-core-avatars.php script, so it doesn’t look like I can change any values per se. Like I said, what is weird is that the draggable cropper is showing up as the right rectangular 2:3 ratio shape…it’s just not saving properly (I can tell it is just saving a 1:1 ratio square and stretching it into the 2:3 ratio rectangle).

[@wythagy Participant 17 years, 6 months ago]

I\’m assuming it is something in here that I need to change in addition to the avatar size values, I just haven\’t yet figured it out…

// Perform v1 crop

$v1_dest = apply_filters( ‘bp_avatar_v1_dest’, dirname($source) . ‘/’ . preg_replace(‘!(\.[^.]+)?$!’, $v1_filename . ‘$1’, basename($source), 1), $source );

if ( $from_signup )

$v1_out = wp_crop_image( $source, $v1_x1, $v1_y1, $v1_w, $v1_h, CORE_AVATAR_V1_W, CORE_AVATAR_V1_H, false, $v1_dest );

else

$v1_out = wp_crop_image( $source, ($v1_x1 * $multi), ($v1_y1 * $multi), ($v1_w * $multi), ($v1_h * $multi), CORE_AVATAR_V1_W, CORE_AVATAR_V1_H, false, $v1_dest );

// Perform v2 crop

if ( CORE_AVATAR_V2_W !== false && CORE_AVATAR_V2_H !== false ) {

$v2_dest = apply_filters( ‘bp_avatar_v2_dest’, dirname($source) . ‘/’ . preg_replace(‘!(\.[^.]+)?$!’, $v2_filename . ‘$1’, basename($source), 1), $source );

if ( $from_signup )

$v2_out = wp_crop_image( $source, $v2_x1, $v2_y1, $v2_w, $v2_h, CORE_AVATAR_V2_W, CORE_AVATAR_V2_H, false, $v2_dest );

else

$v2_out = wp_crop_image( $source, ($v2_x1 * $multi), ($v2_y1 * $multi), ($v2_w * $multi), ($v2_h * $multi), CORE_AVATAR_V2_W, CORE_AVATAR_V2_H, false, $v2_dest );

}

[@wythagy Participant 17 years, 6 months ago]

Okay I’m officially retarded and have been up way too long…

all I had to do was replace the link using the $user variable they already provided…I didn’t need an ID# after all…

For what it’s worth though if anyone would like to know, I now have WP-Forum working very smoothly along with BuddyPress (again…not within group forums, only as a site wide forum).

[@wythagy Participant 17 years, 6 months ago]

By the way, just so you know what I am trying to do, there is a function within WP-Forums that calls a profile link using the variable $link:

$link = "<a hre f='".$this->base_url."profile&amp;id=$user_id'

title='".__("View profile", "wpforum")."'>$user</a>";

I need to be able to change the content after the \”href\” in the $link variable so that the $user_id forwards to a the equivalent BuddyPress profile.

[@wythagy Participant 17 years, 6 months ago]

Okay so I just tried installing the absolute latest Trunk of BBPress with BuddyPress RC1, but when I try to activate the buddypress-enable.php file it says:

Plugin file does not exist.

Back to Modelrific Forums.