BuddyPress.org

You can import anything you want into a mysql table. The catch is that tables relate to each other. The profile fields you see are composed of three tables that interrelate. We’ve got profile groups, fields and field data. Groups are composed of Fields and Fields have Data. They are all linked to each other.

What is the source data you are working with?

When will this be fixed officially? Commenting out the add_filter removes all the auto linking functions. I only want one section without auto linking.

User generated profile fields! I’d like if this feature is built in or by a plugin. However at this moment, wpmu admin is the only person who can add/delete profile fields.

Not sure egerrits. Don’t know what the context is. Are you sure that is what is happening there? If those are single quotes in this chunk of code then $meta[‘field_{$custom_field_id}’] = ‘Hello World’; then that won’t work. The resolve as string operation ‘{}’ doesn’t work in single quoted strings. Only double quoted strings.

Never mind the question about date format. We don\’t get a choice. I need to know if the data is getting saved and not being displayed or just not getting saved. Can you take a look at the bp_xprofile_data table and see if there is anything in there for that date field?

The bp_xprofile_data table looks like this: id, field_id, user_id, value, last_updated. The field_id is basically the sequence you entered the fields in the backend. Starting at 1, you can prob count down the list and guess at the field_id. If you’ve done alot of arranging things with deletes and adds it might not be that simple.

field_id comes from another bp table called bp_xprofile_fields. If you browse that table with phpmyadmin you’ll see your date field. Whatever you called it will be in the ‘name’ column. The field_id you are looking for is the ‘id’ column in that table. Match that up with the field_id in the bp_xprofile_data table and tell me what that row says for that field_id.

You should have a number like: 1210392000 in the ‘value’ column. That’s a linux time number. What’s in that spot for your date field? Matter of fact, try changing and saving the profile data and then go look at the tables. What does phpmyadmin say for that row in the table?

All the fields are sanitized as long as you are using the correct template tags and functions.

User fields are sanitized if you are using the standard BuddyPress template tags or function calls.

If you haven\’t altered any of the profile filtering mechanisms then the js will get removed. It gets filtered out by the standard wp filters which get run on the profile fields. The profile fields don\’t show up in the wp backend. If you have a user trying to insert js into a profile field I would delete that user. Now.

What version of bp are you running? I see all sorts of filtering going on in trunk.

bp-xprofile-filters.php

@ Manoj

thanks for answering me on your site… I\’ll move my issues to this thread

while the \”Full Name\” field cannot be changed, I was able to change it by duplicating the url to change a different field…

example:

when you edit any of the xprofile fields, the url shows somwthing like this:

http://mysite.com/wp-admin/?edit=profile_pageID=2

i just changed the \”2\” to a \”1\” and hit refresh…that allowed me to change the \”Full Name\” field to \”first name\”

my install is very customized, so I simpley can\’t \”roll back\” to a fresh install…

I will try changing the profile name back to \”Full Name\” and see if that works….

(more to follow)

@ theBigK

it doesnt look like you can add any additional information currently, however this plugin isn\’t super-complex, so you could probably add the functionality to add more user data by adjusting the PHP code (not sure how though)

you may also be able to export your SQL file in a | \”pipe\” delimited fashion

something like this:

\’

SELECT * FROM TABLE

ORDER BY ID INTO OUTFILE \’out.file\’

FIELDS TERMINATED BY \’|\’;

\’

I dont know much about this, but google it and Im sure you\’ll find something

1. congrats on the members

2. I don’t believe it has been done yet.

Depending on your mysql abilities, you may find it easier to just write a quick and dirty php file with a mysql connect to show members. The overhead that wordpress and buddypress would add to this process wouldn’t be worth the minimal gains of the buddypress functions.

But if you don’t know much mysql, then you may be forced to do it inside of an admin plugin.

Here are a few quick and dirty sql lines to get you started:

find all users:

find all users, and show full name (from profile fields)

Thanks for the effort…please create a plugin for it. Also is it a ebay widget,so if can one get lastFM widget?

thank you

I’ll try to set a little plugin or something later, but for the moment you can follow this method, it’s the Fishbowl81’s code adapted for ebay editor kit:

Edit your bp-xprofile-filters.php by placing the following code after the custom buddypress filters:

function bp_profile_ebay_display( $field_value "", $field_type = "", $field_id = "" ) {

{ // clean up input

return "<script language='JavaScript' src='http://lapi.ebay.com/ws/eBayISAPI.dll?EKServer&ai=lwa%7Bfwvw%7Esa%7Cwsyw%60&bdrcolor=CCCCCC&cid=0&eksize=1&encode=UTF-8&endcolor=FF0000&endtime=n&fbgcolor=FFFFFF&fntcolor=000000&fs=0&hdrcolor=FFFFFF&hdrimage=1&hdrsrch=n&img=y&lnkcolor=75179C&logo=3&num=5&numbid=n&paypal=n&popup=n&prvd=9&r0=4&shipcost=n&si=".addslashes($field_value)."&sid=BP&siteid=0&sort=MetaEndSort&sortby=endtime&sortdir=asc&srchdesc=n&tbgcolor=FFFFFF&tlecolor=FFFFFF&tlefs=0&tlfcolor=000000&toolid=10004&track=5336248810&watchcat=63850&width=350'></script>";

}

}

function bp_profile_ebay_groups( $group_name "") {

if($group_name == "My Ebay listings"){

remove_filter( 'bp_the_profile_field_value', 'xprofile_filter_link_profile_data', 2);

add_filter( 'bp_the_profile_field_value', 'bp_profile_ebay_display', 2, 3);

}else{

add_filter( 'bp_the_profile_field_value', 'xprofile_filter_link_profile_data', 2, 3);

remove_filter( 'bp_the_profile_field_value', 'bp_profile_ebay_display', 2);

}

return $group_name;

}

add_filter( 'bp_the_profile_group_name', 'bp_profile_ebay_groups', 10, 1 );

Also it depend of your css code but it can be useful to put this in your member theme’s stylesheet (base or your custom stylesheet).

Then create a profile field group named “My Ebay listings” and a profile field like ebay username and you’re done!

@keston, I like your ebay plugin. Can you share it?

@keston, I like your ebay plugin. Can you share it?

It did the same thing to me.I fixed that by deleting bp-music.php and puting the code directly in bp-xprofile-filters.php.I don’t know if it’s a good issue but it’s currently working, thanks Fishbowl81.

I’ve also adapted the code to display user’s ebay listings: http://lesitedelasneaker.com/bp/users/members/admin/profile

(Sorry for my english)

quick question:

I uploaded the BP-music.php file to the mu-plugins folder

and the styles/css for the entire site went crazy

…almost like the “remove filter” removed everything from everything…

I had not yet created a group called “Audio Details” when i uploaded the file…

is that why it didn’t work?

it pulls from your text a keyword and gets the player from amazon

one more hint plz…. can you give an example of what would be entered into the profile field…. does it have to be a music file?

so, http://mywebsite.com/mysong.mp3 ?

I’m confused as to where the audio file is located/uploaded/pulled from….

does the user upload a file? or simpley enter a link to an audio file? or enter artist names/song name and it’s pulled from amazon?

(thanks)

Actually it’s pretty easy to see what profile fields are called in the DB – Check the wp_bp_xprofile_fields table and you’ll have an ID associated with each field which you should be able to use to call them.