Skip to:
Content
Pages
Categories
Search
Top
Bottom

Search Results for '+.+default+.+'

Viewing 25 results - 3,101 through 3,125 (of 6,813 total)
  • Author
    Search Results
  • #146984
    flipdamusic
    Participant

    Hi,
    i have the challenge to show the latest topics for the role members in the topic index view. I’m new to bbpress so i’ve to learn a lot.

    I’m using buddypress with sidewide and group forums. Each group has one forum.
    When I’m using a site and shortcode [bbp-topic-index] only all topics from the sidewide forums are shown. What I’ve learned is that this is a default behavior – i hope i’m not wrong 🙂

    Now I want to show all latest topics / posts for all members belonging to their group / group forum – optimal on the latest topic page. The users are members (bbpress) and abonnents (WordPress).
    How do i accomplish that ?

    #146941
    Nathan
    Participant

    Hi Christian,
    The code I ended up using was not my original idea. I didn’t hook into a new user creation. What this does is inverts the subscribe list. It turns it into an unsubscribe list. So any user should be subscribed to any new forum by default. Let me know if something is not working for you, and I’ll see what I can do!

    – Nathan

    #146903
    lagrou
    Participant

    Something odd about those “replies to replies”. I had assumed they would be there by default, but couldn’t see them…

    I’ve added some ‘replies to replies’ to my test WPS forum before converting it… In bbPress, in the backend they are not displayed in the list of replies, although I do see ‘hidden’ replies in the count that I cannot access to. In the frontend, the forum topic does not show those replies, nor do the counters. However!! When dumping wp_posts table WHERE post_type = ‘reply’, they are there, so they were converted ok, it’s just that they don’t show. I did set bbPress threated replies 2 levels deep before conversion. Any advice…?

    As far as groups forum topics, I would add ‘AND symposium_topics.topic_group = 0 ‘ to the ‘from_expression’ of both the topic ID and Reply ID sections to get rid of those posts. Cleaner until v2.

    #146901
    Robin W
    Moderator

    I think you need to eliminate conflicts for instance maybe the access plugin is conflicting

    try

    Plugins

    Deactivate all but bbpress and see if this fixes. if it does, re-enable one at a time to see which is causing the error.

    Themes

    If plugins don’t pinpoint the problem, switch to a default theme such as twentytwelve, and see if this fixes.

    #146900
    Robin W
    Moderator

    Just taken a good look at form_reply_move.php and that calls a function that uses the bbp_has_topics with a ‘post__not_in’ parameter. My function uses a ‘post__in’ parameter, and wp-Query can’t handle both in one query, hense why it falls over.

    I’m already in trouble with my wife for still typing this, but try copying

    wp-content/bbpress/templates/default/bbpress/form_reply_move.php to a folder called bbpress within the root of your theme – ie wp-content/your-theme-name/bbpress/form_reply_move.php

    this will create a copy that is used instead of the default

    try

    changing

    line 45

    <?php if ( bbp_has_topics( array( 'show_stickies' => false, 'post_parent' => bbp_get_reply_forum_id( bbp_get_reply_id() ), 'post__not_in' => array( bbp_get_reply_topic_id( bbp_get_reply_id() ) ) ) ) ) : ?>
    
    

    to

    <?php //if ( bbp_has_topics( array( 'show_stickies' => false, 'post_parent' => bbp_get_reply_forum_id( bbp_get_reply_id() ), 'post__not_in' => array( bbp_get_reply_topic_id( bbp_get_reply_id() ) ) ) ) ) : ?>
    

    and line 63

    from

    <?php endif; ?>

    to

    <?php //endif; ?>

    This just takes that argument out and see how it runs then

    If that works, then I can play with what is needed – think I know, but am out of the door….now !!!

    #146820
    Stephen Edgar
    Keymaster

    It is not a bug, we removed the default behaviour to have both editors enabled by default in 2.3.1, switching between editor types would more often than not change the content of the users topics or replies.

    Now that TinyMCE v4 has shipped with WordPress v3.9.x once we have a few more architectural fixes in bbPress we can take another look, it is far from a small bug, quite complex to be honest.

    #146812
    Mycelus
    Participant

    Hey guys. So Ive been wondering this for a long time, and I just dont understand. Why is bbPress’ editor so bad? Everything uses lame tags and is very primitive. WordPress already has color and bold and italic and linking and everything integrated, so why doesn’t bbPress add this?

    No one can actually tell me that bbPress is meant to be this way? Is there something stopping the devs from just importing the full editor over…?

    Very curious…

    demonboy
    Participant

    I have added this code to my functions.php file

    function mycustom_breadcrumb_options() {
    	// Home - default = true
    	$args['include_home']    = false;
    	// Forum root - default = true
    	$args['include_root']    = true;
    	// Current - default = true
    	$args['include_current'] = false;
    
    	return $args;
    }
    
    add_filter('bbp_before_get_breadcrumb_parse_args', 'mycustom_breadcrumb_options' );

    … but that last argument only works for the original post, which returns something like this:

    Forums › Assignment Submissions ›

    On the replies underneath it includes the current location, something like this:

    Forums › Assignment Submissions › Assignment 24: 1st 24 hours in Crown Point, Tobago

    You can see this in action here.

    How do I remove that last part in the replies?

    #146788
    Robin W
    Moderator

    It could be a theme or plugin issue

    Plugins

    Deactivate all but bbpress and see if this fixes. if it does, re-enable one at a time to see which is causing the error.

    Themes

    If plugins don’t pinpoint the problem, switch to a default theme such as twentytwelve, and see if this fixes.

    #146784
    dugfunny
    Participant

    Using this code I have made it to where only updates and rtmedia posts show up on my activity stream

    /**
     * Activity Stream Default Updates
     */
    function make_swa_show_notice_only( $retval ) {	
    	
    	 if ( bp_is_page( 'activity' ) ) {
    		$retval['action'] = 'activity_update, rtmedia_update';					
    	 }
    	
    	return $retval;
    	
    }
    
    add_filter( 'bp_after_has_activities_parse_args', 'make_swa_show_notice_only' );

    I would like bbpress forum posts to show up on my wall as well. What would i put next to

    ‘activity_update, rtmedia_update’

    in my code to make that happen? Thanks!

    demonboy
    Participant

    Going nuts, here. I’m using an Avada child theme and I’m fairly au fait with CSS and getting under the bonnet with PHP (commenting stuff out etc), though I’ve not done much aside from a few CSS changes.

    My forum home has the sidebar on the left. The problem is when I click into a forum, (so the URL is http://www.lizcleere.com/forums/forum/assignments/, for example), the sidebar now jumps to the right. Same when I click into a topic.

    What isn’t explained very well is the use of the additional slugs. ‘Topic’ is set as the slug ‘topic’, so surely it stands to reason that I create a ‘topic’ page, format it how I want the ‘topic’ section to appear, and save it with the name ‘topic’. I’ve tried that and it doesn’t work.

    I’ve also tried disabling the WP Tweaks plugin, removing the inactive widgets, logging out, logging back in, reactivating etc etc. Nothing.

    I then took a copy of Avada’s single.php and renamed it forum.php and made it a template. I’ve called that template up on my Forum page and the sidebar appears on the left, as intended. (Actually, it’s the Blog sidebar, even though I’ve set it to BBPress sidebar, but that’s another story.)

    Why do ‘forum’ and ‘topic’ not inherit the properties I set on the forums page (i.e. default layout (not 100% width or full page or anything like that), sidebar on left, using the forum template page)? I feel like I’m missing something really obvious…

    #146754
    Robin W
    Moderator

    probably a conflict

    Plugins

    Deactivate all but bbpress and see if this fixes. if it does, re-enable one at a time to see which is causing the error.

    Themes

    If plugins don’t pinpoint the problem, switch to a default theme such as twentytwelve, and see if this fixes.

    czentnar
    Participant

    function custom_bbp_has_replies() {
    $args[‘order’] = ‘DESC’; // ‘ASC’ (Ascending, Default), ‘DESC’ (Descending)
    return $args;
    }
    add_filter(‘bbp_before_has_replies_parse_args’, ‘custom_bbp_has_replies’ );

    Thank you for the great solution, @netweb!
    However, as I changed the query, the post IDs got messed up (this appears when I click on the ID starting with “#” in the top right corner of the post). Also, after submitting a new post, bbPress jumps to the last page in that topic, despite the fact that the order has already been changed and the latest reply is on the first page (this could be a result of the messed ID’s, I think).

    #146695
    Robin W
    Moderator

    ok, could be lots of things, presume you’ve referred back to your developer?

    and presume this is a new installation of bbpress, so has never worked?

    I’d start by trying :

    Plugins

    Deactivate all but bbpress and see if this fixes. if it does, re-enable one at a time to see which is causing the error.

    Themes

    If plugins don’t pinpoint the problem, switch to a default theme such as twentytwelve, and see if this fixes.

    #146665
    Nathan
    Participant

    So, after DAYS of working on this I finally have a solution. I have not done a lot of testing, but this has worked so far.

    Basically what is happening is that for forums (not replies) the logic is inverted. This means that users are subscribed to a forum unless they unsubscribe (ie. are added to the DB).

    Just add this to your theme’s function.php and it should work.

    I hope this helps someone, because it has taken a LOT of work!

    add_filter( 'bbp_get_user_subscribe_link', 'invert_get_user_subscribe_link', 10, 4 ); //invert forum subscription
    add_filter( 'bbp_is_user_subscribed_to_forum', 'invert_is_user_subscribed_to_forum', 10, 4 ); //invert forum subscription
    add_filter( 'bbp_get_forum_subscribers', 'invert_get_forum_subscribers' ); //invert forum subscription
    add_filter( 'bbp_is_user_subscribed', 'invert_is_user_subscribed', 10, 4 ); //invert forum subscription
    
    function invert_is_user_subscribed($retval, $user_id, $object_id, $subscribed_ids) {
    	if (get_post_type( $object_id ) == bbp_get_forum_post_type())
    		return !$retval;
    	else	
    		return $retval;
    }
    
    function strContains($needle, $haystack) {
    	if (strpos($haystack, $needle) !== false) {
    		return true;
    	} else {
    		return false;
    	}
    }
    
    function invert_get_user_subscribe_link ($html, $r, $user_id, $topic_id) {
    	if (strContains( "bbp_unsubscribe", $html )) {
    		$html = str_replace("bbp_unsubscribe", "bbp_subscribe", $html);
    	} else {
    		$html = str_replace("bbp_subscribe", "bbp_unsubscribe", $html);
    	}
    	return $html;
    }
    
    function invert_get_forum_subscribers( $users ) {
    	$args = array('fields' => 'id');
    	$all_users = get_users($args);
    	$send_to_users    = array_diff($all_users, $users);
    	return $send_to_users;
    }
    
    function invert_is_user_subscribed_to_forum( $retval, $user_id, $forum_id, $subscribed_ids ) {
    	return !$retval;
    }
    

    I also include make users “subscribed” to anything they write by default. All they have to do is uncheck the box. The following code is also added to function.php.

    add_action('bbp_theme_after_topic_form_subscriptions', 'subscribed_by_default'); //default subscribe
    add_action('bbp_theme_after_reply_form_subscription', 'subscribed_by_default'); //default subscribe
    
    function subscribed_by_default() 
    	echo '<script type="text/javascript">jQuery("#bbp_topic_subscription").prop("checked","checked");</script>';
    }
    #146662
    dryan1144
    Participant

    Out of the box, bbpress shows topics from a particular forum when you are on that forum’s archive page. Makes sense. If that forum has a sub-forum, it will link to those sub-forums, but it won’t show the actual topics from that sub-forum.

    I’m trying to modify the default bbpress loop on a forum page (loop-topics.php) to include the sub-forum topics.

    Here’s an explanation:

    Forum A
    Sub-forum A1
    Sub-forum A2
    Forum B
    Sub-forum B1
    Sub-forum B2
    So when viewing Forum A’s archive page, I’d like to show topics from Forum A, sub-forum A1 and sub-forum A2.

    The code needs to be dynamic in order to work with whatever parent forum archive a user is on.

    You can pass wp_query args into bb_has_topics(), but I can only only come up with code that shows topics from one forum – not multiple forums.

    To better explain what I’m working with, here’s an example of a loop that grabs topics from the parent forum:

    
    <?php
    
    $parents = get_post_ancestors( $post->ID );
    
    $id = ($parents) ? $parents[count($parents)-1]: $post->ID;
    
    $parent = get_page( $id );
    
    ?>
    
    <?php $bbp_loop_args = array('post_parent' => $parent->ID, 'post_type' => 'topic'); ?>
    
    <?php if ( bbp_has_topics($bbp_loop_args) ) : ?>
    
        <?php while ( bbp_topics() ) : bbp_the_topic(); ?>
    
            <?php bbp_get_template_part( 'loop', 'single-topic' ); ?>
    
        <?php endwhile; ?>
    
    <?php endif;?>
    

    Any ideas on how this can be achieved?

    oyegigi
    Participant

    So I am wondering how I can modify the default forum role based on the user site role? So let’s say under settings > Forums I have set the default role as Participant. This is great since most of my users will be contributors and I want them to be participants.

    However, I will have editors as well. When these users are created I want their forum role to be automatically set to Moderator rather than Participant. Is there a way I can change the default forum role based on that users’ site role?

    #146590
    Robin W
    Moderator

    ‘I have the theme setup running on two domains, the one i use for testing, the funny thing is when posting on that site, the first post of the thread is shown.’

    This would tend to suggest that something is different or not set the same. Are both on remote servers, or is one on a local PC running wamp or mamp?

    Not showing a topic is a common symptom, but with many different causes, so there is no one solution.

    There are a number of things you can try.

    Resetting permalinks – sometimes fixes – in your WordPress Administration Screens navigate to Settings > Permalinks, select a different permalink structure and save. Then select your preferred permalink structure and save again.

    Repair Forums – Dashboard>tools>forums>repair forum and run one at a time.

    Plugins

    Deactivate all but bbpress and see if this fixes. if it does, re-enable one at a time to see which is causing the error.

    Themes

    If plugins don’t pinpoint the problem, switch to a default theme such as twentytwelve, and see if this fixes.

    #146585
    lagrou
    Participant

    First, not sure what’s the best way to proceed with updates at GitHub. Could you create a pull request, shall I fork your own repo or create a new branch, or simply update my own master ?

    if I understand correctly is that I could choose the ‘Sun Dreesses’ forum to be the default forum selected when clicking ‘New Toipic’ from the WPS forums hopme page it will default to showing the ‘Sun Dresses’ forum as the destination for my topic unless I select another forum?

    Yes, the form will default to that category in its dropdown list of categories. It’s of little use, and as you stress, we can ignore this. I was only clarifying forum vs. categories in WPS, and why we can drop callback_forum_type() in your update of the converter / importer.

    I haven’t tried the WPS groups but I will create one and see what we can (or cannot) do with them.

    I considered that the content could at least be imported, then the admin would do whatever he wants to with that content. But maybe the groups ownership and membership will be impossible to mimick at bbPress level solely, so it’s better to avoid importing rather than making public content that was private to begin with…?

    I’m adding a Users section to your own version of the converter module (based on other converters available). If we want to import user-related settings, like forums/topics subscriptions and favorites, is this possible ? WPS uses usermeta, and I would assume bbPress does so…?

    Your last comment about attachements and avatars is well noted, I’ll check what could be done outside of bbPress.

    #146508
    yeahman45
    Participant

    is there a reason why visual editor is disabled by default? ( not stable? ).

    Is there a quote plugin that is compatible with the visual editor? the one with GD bbpress works only with the non-visual editor

    #146500
    Bard
    Participant

    Hi Stephen,
    Thank you for the reply, due to the GD press attachment uploads files after clicking on submit, it will never work like WYSIWYG editor, and as a support plugin they will follow bbpress rules.

    I guess I will need another plugin which allows user box by account id and stocks personal images. This may work with the default TinyMCE by inserting uploaded images.

    #146499
    hamsterdj
    Participant

    I’m having the same problem here. When user enters nickname and email address to register, they get redirected to the “default_site_domain/wp-signup.php“, where they have to re-enter everything. It’s very confusing for users wanting to participate on forums to say the least.

    This situation also creates a problem for when a site with forum uses different language than the default site, as mentioned here.

    Can one of the bbPress developers please give us some pointers, or at least tell us that this is not a common problem and we’ll have to figure out why this is happening on our own? We love bbPress and we’re hoping now to get some love back. 🙂

    @jeffacubed Have you made any progress with this matter? I’m still researching…

    Oh, and I’m running WordPress 3.9 Multisite, bbPress 2.5.3.

    #146468
    Robin W
    Moderator

    ok, the answer is somewhere in this function

    function bbp_title( $title = '', $sep = '&raquo;', $seplocation = '' ) {
    
    	// Title array
    	$new_title = array();
    
    	/** Archives **************************************************************/
    
    	// Forum Archive
    	if ( bbp_is_forum_archive() ) {
    		$new_title['text'] = bbp_get_forum_archive_title();
    
    	// Topic Archive
    	} elseif ( bbp_is_topic_archive() ) {
    		$new_title['text'] = bbp_get_topic_archive_title();
    
    	/** Edit ******************************************************************/
    
    	// Forum edit page
    	} elseif ( bbp_is_forum_edit() ) {
    		$new_title['text']   = bbp_get_forum_title();
    		$new_title['format'] = esc_attr__( 'Forum Edit: %s', 'bbpress' );
    
    	// Topic edit page
    	} elseif ( bbp_is_topic_edit() ) {
    		$new_title['text']   = bbp_get_topic_title();
    		$new_title['format'] = esc_attr__( 'Topic Edit: %s', 'bbpress' );
    
    	// Reply edit page
    	} elseif ( bbp_is_reply_edit() ) {
    		$new_title['text']   = bbp_get_reply_title();
    		$new_title['format'] = esc_attr__( 'Reply Edit: %s', 'bbpress' );
    
    	// Topic tag edit page
    	} elseif ( bbp_is_topic_tag_edit() ) {
    		$new_title['text']   = bbp_get_topic_tag_name();
    		$new_title['format'] = esc_attr__( 'Topic Tag Edit: %s', 'bbpress' );
    
    	/** Singles ***************************************************************/
    
    	// Forum page
    	} elseif ( bbp_is_single_forum() ) {
    		$new_title['text']   = bbp_get_forum_title();
    		$new_title['format'] = esc_attr__( 'Forum: %s', 'bbpress' );
    
    	// Topic page
    	} elseif ( bbp_is_single_topic() ) {
    		$new_title['text']   = bbp_get_topic_title();
    		$new_title['format'] = esc_attr__( 'Topic: %s', 'bbpress' );
    
    	// Replies
    	} elseif ( bbp_is_single_reply() ) {
    		$new_title['text']   = bbp_get_reply_title();
    
    	// Topic tag page
    	} elseif ( bbp_is_topic_tag() || get_query_var( 'bbp_topic_tag' ) ) {
    		$new_title['text']   = bbp_get_topic_tag_name();
    		$new_title['format'] = esc_attr__( 'Topic Tag: %s', 'bbpress' );
    
    	/** Users *****************************************************************/
    
    	// Profile page
    	} elseif ( bbp_is_single_user() ) {
    
    		// User is viewing their own profile
    		if ( bbp_is_user_home() ) {
    			$new_title['text'] = esc_attr_x( 'Your', 'User viewing his/her own profile', 'bbpress' );
    
    		// User is viewing someone else's profile (so use their display name)
    		} else {
    			$new_title['text'] = sprintf( esc_attr_x( "%s's", 'User viewing another users profile', 'bbpress' ), get_userdata( bbp_get_user_id() )->display_name );
    		}
    
    		// User topics created
    		if ( bbp_is_single_user_topics() ) {
    			$new_title['format'] = esc_attr__( "%s Topics",        'bbpress' );
    
    		// User rueplies created
    		} elseif ( bbp_is_single_user_replies() ) {
    			$new_title['format'] = esc_attr__( "%s Replies",       'bbpress' );
    
    		// User favorites
    		} elseif ( bbp_is_favorites() ) {
    			$new_title['format'] = esc_attr__( "%s Favorites",     'bbpress' );
    
    		// User subscriptions
    		} elseif ( bbp_is_subscriptions() ) {
    			$new_title['format'] = esc_attr__( "%s Subscriptions", 'bbpress' );
    
    		// User "home"
    		} else {
    			$new_title['format'] = esc_attr__( "%s Profile",       'bbpress' );
    		}
    
    	// Profile edit page
    	} elseif ( bbp_is_single_user_edit() ) {
    
    		// Current user
    		if ( bbp_is_user_home_edit() ) {
    			$new_title['text']   = esc_attr__( 'Edit Your Profile', 'bbpress' );
    
    		// Other user
    		} else {
    			$new_title['text']   = get_userdata( bbp_get_user_id() )->display_name;
    			$new_title['format'] = esc_attr__( "Edit %s's Profile", 'bbpress' );
    		}
    
    	/** Views *****************************************************************/
    
    	// Views
    	} elseif ( bbp_is_single_view() ) {
    		$new_title['text']   = bbp_get_view_title();
    		$new_title['format'] = esc_attr__( 'View: %s', 'bbpress' );
    
    	/** Search ****************************************************************/
    
    	// Search
    	} elseif ( bbp_is_search() ) {
    		$new_title['text'] = bbp_get_search_title();
    	}
    
    	// This filter is deprecated. Use 'bbp_before_title_parse_args' instead.
    	$new_title = apply_filters( 'bbp_raw_title_array', $new_title );
    
    	// Set title array defaults
    	$new_title = bbp_parse_args( $new_title, array(
    		'text'   => $title,
    		'format' => '%s'
    	), 'title' );
    
    	// Get the formatted raw title
    	$new_title = sprintf( $new_title['format'], $new_title['text'] );
    
    	// Filter the raw title
    	$new_title = apply_filters( 'bbp_raw_title', $new_title, $sep, $seplocation );
    
    	// Compare new title with original title
    	if ( $new_title === $title )
    		return $title;
    
    	// Temporary separator, for accurate flipping, if necessary
    	$t_sep  = '%WP_TITILE_SEP%';
    	$prefix = '';
    
    	if ( !empty( $new_title ) )
    		$prefix = " $sep ";
    
    	// sep on right, so reverse the order
    	if ( 'right' === $seplocation ) {
    		$new_title_array = array_reverse( explode( $t_sep, $new_title ) );
    		$new_title       = implode( " $sep ", $new_title_array ) . $prefix;
    
    	// sep on left, do not reverse
    	} else {
    		$new_title_array = explode( $t_sep, $new_title );
    		$new_title       = $prefix . implode( " $sep ", $new_title_array );
    	}
    
    	// Filter and return
    	return apply_filters( 'bbp_title', $new_title, $sep, $seplocation );
    }
    

    a filter such as

    function amend_title () {
    	if ( bbp_is_single_forum() ) {
    		$new_title['text']   = 'YA book forum' ;
    		$new_title['format'] = esc_attr__( 'YA book Forum', 'bbpress' );
    		}
     return $new_title;
    }
    add_filter('bbp_before_title_parse_args', 'amend_title' );
    

    should sort it but doesn’t, and I’m too tired to work out why 🙂

    Over to you !

    #146460
    Robin W
    Moderator

    hmm, I’d check for a conflict first

    Plugins

    Deactivate all but bbpress and see if this fixes. if it does, re-enable one at a time to see which is causing the error.

    Themes

    If plugins don’t pinpoint the problem, switch to a default theme such as twentytwelve, and see if this fixes.

    Then I’d re-download the software in case this was an issue

    come back if that doesn’t work

    #146448
    gianjj
    Participant

    This script launched in QUERY ANALYZER of MsSQL server will generate a list of SQL to import in MySQL ; remember to select “Result in a File”

    Alla this script will not take effect on your database, but will help you to pre-generate all SQL to move your data….
    TEST IT BEFORE MOVE ALL DATA YOU ARE THE ONLY ONE RESPONSABLE OF YOURS WORK 😛

    
    
    --------------------------------
    --- Will Generate a List of INSERT INTO query
    --- Formatted for MySQL table: wp_users
    --- JUST ONE MEMEBR
    --------------------------------
    Select TOP 1
    'INSERT INTO ''wp_users''(''ID'', ''user_login'', ''user_pass'', ''user_nickname'', ''user_email'', 
    ''user_url'', ''user_registred'', ''user_activation_key'', ''user_status'', ''display_name'') 
     VALUES ('+CAST(MEMBER_ID as nvarchar(10))+', '''+M_NAME+''', ''REMEMBER_TO_REST_ALL_PASSWORD'', '''+M_NAME+''','''+M_EMAIL+'''
     , '''+M_HOMEPAGE+''', '''+M_NAME+''', '''+
     	substring(M_DATE, 1,4)+  '-' + substring(M_DATE, 5,2)+ '-'+
    	substring(M_DATE, 7,2)+  ' ' + substring(M_DATE, 9,2)+ ':'+ 
    	substring(M_DATE, 11,2)+ ':' + substring(M_DATE, 13,2)
     +''','''',''0'','''+M_NAME+'''
     );'
    from dbo.FORUM_MEMBERS order by MEMBER_ID asc
    
    --------------------------------
    --- Will Generate a List of INSERT INTO query
    --- Formatted for MySQL table: wp_usermeta
    --- JUST ONE MEMEBR
    --------------------------------
    Select TOP 1
    'INSERT INTO ''wp_usermeta''(''user_id'', ''meta_key'', ''meta_value'') VALUES ('+CAST(MEMBER_ID as nvarchar(10))+', ''first_name'', '''+M_FIRSTNAME+''');',
    'INSERT INTO ''wp_usermeta''(''user_id'', ''meta_key'', ''meta_value'') VALUES ('+CAST(MEMBER_ID as nvarchar(10))+', ''last_name'', '''+M_LASTNAME+''');', 
    'INSERT INTO ''wp_usermeta''(''user_id'', ''meta_key'', ''meta_value'') VALUES ('+CAST(MEMBER_ID as nvarchar(10))+', ''nickname'','''+M_NAME+''');',
    'INSERT INTO ''wp_usermeta''(''user_id'', ''meta_key'', ''meta_value'') VALUES ('+CAST(MEMBER_ID as nvarchar(10))+', ''description'', '''');',  
    'INSERT INTO ''wp_usermeta''(''user_id'', ''meta_key'', ''meta_value'') VALUES ('+CAST(MEMBER_ID as nvarchar(10))+', ''rich_editing'', ''true'');',  
    'INSERT INTO ''wp_usermeta''(''user_id'', ''meta_key'', ''meta_value'') VALUES ('+CAST(MEMBER_ID as nvarchar(10))+', ''comment_shortcuts'', ''false'');', 
    'INSERT INTO ''wp_usermeta''(''user_id'', ''meta_key'', ''meta_value'') VALUES ('+CAST(MEMBER_ID as nvarchar(10))+', ''admin_color'', ''fresh'' );', 
    'INSERT INTO ''wp_usermeta''(''user_id'', ''meta_key'', ''meta_value'') VALUES ('+CAST(MEMBER_ID as nvarchar(10))+', ''use_ssl'', ''0'');',  
    'INSERT INTO ''wp_usermeta''(''user_id'', ''meta_key'', ''meta_value'') VALUES ('+CAST(MEMBER_ID as nvarchar(10))+', ''show_admin_bar_front'', ''true'');',  
    'INSERT INTO ''wp_usermeta''(''user_id'', ''meta_key'', ''meta_value'') VALUES ('+CAST(MEMBER_ID as nvarchar(10))+', ''wp_capabilities'', ''a:1:{s:10:"subscriber";b:1;}'');',  
    'INSERT INTO ''wp_usermeta''(''user_id'', ''meta_key'', ''meta_value'') VALUES ('+CAST(MEMBER_ID as nvarchar(10))+', ''wp_user_level'', ''0'');',  
    'INSERT INTO ''wp_usermeta''(''user_id'', ''meta_key'', ''meta_value'') VALUES ('+CAST(MEMBER_ID as nvarchar(10))+', ''dismissed_wp_pointers'', ''wp330_toolbar,wp330_saving_widgets,wp340_choose_image_from_library,wp340_customize_current_theme_link,wp350_media,wp360_revisions,wp360_locks'');',  
    'INSERT INTO ''wp_usermeta''(''user_id'', ''meta_key'', ''meta_value'') VALUES ('+CAST(MEMBER_ID as nvarchar(10))+', ''default_password_nag'', ''1'');'  
    from dbo.FORUM_MEMBERS order by MEMBER_ID asc
    
Viewing 25 results - 3,101 through 3,125 (of 6,813 total)
Skip to toolbar