[Stephen Edgar]

Firstly I only included the fields Robin had supplied, I do not have a copy of Snitz to test either. So I commented out but didn’t remove any of the code so that it would stand out and you could update any of these as needed which you have done.

The forum ‘counts’ I think you may have incorrect in your post above:
* _bbp_topic_count – The number of topics that are ‘publicly’ visible
* _bbp_reply_count – The number of replies that are ‘publicly’ visible
* _bbp_total_topic_count – The total number of topics (includes topics that are are unapproved or hidden)
* _bbp_total_reply_count – The total number of replies (includes replies that are are unapproved or hidden)

A clearer explanation of each of these would be helpful and also are each of these fields in the FORUM_FORUM database table:
* F_TOPICS
* F_COUNT
* T_COUNT
* P_COUNT

The topic ‘counts’ is the same:
* _bbp_reply_count – The number of replies that are ‘publicly’ visible
* _bbp_total_reply_count – The total number of replies (includes replies that are are unapproved or hidden)

A clearer explanation of T_REPLIES would be helpful and is this fields in the FORUM_TOPICS database table?

Whilst you answer those I’ll add Topic Author IP, Stickies and Member Status 🙂

[gianjj]

I forgot this, I’m migrating from Snitz Forums 2000 Version 3.4.06 🙂
Can find this information on Table: FORUM_CONFIG_NEW

[Stephen Edgar]

Here is our ‘Official’ stance on the ‘Unread’ feature/functionality:

https://bbpress.trac.wordpress.org/ticket/1937

The primary issue is performance, we have not seen a plugin that will work well for larger sites, if we implement this as a feature it must work for everyone who uses bbPress.

I just updated the list of ‘Unread’ type plugins I know of here:

Feature Plugins Tracking

[gianjj]

Member status
1 = Active
0 = No Active

		// User status.
		$this->field_map[] = array(
			'from_tablename' => 'FORUM_MEMBERS',
			'from_fieldname' => 'M_STATUS',
			'to_type'        => 'user',
			'to_fieldname'   => 'user_status'
		);

[gianjj]

Stiky Status
1 = Stycky
0 = No Sticky

		// Sticky status (Stored in postmeta))
		$this->field_map[] = array(
			'from_tablename'  => 'FORUM_TOPICS',
			'from_fieldname'  => 'T_STICKY',
			'to_type'         => 'topic',
			'to_fieldname'    => '_bbp_old_sticky_status',
			'callback_method' => 'callback_sticky_status'
		);

[gianjj]

really many thanks for your help….

On first look I see comments block of topic and reply count not supported in snitz… but is a mistake….. (is it ?)

		// Forum topic count (Stored in postmeta)
		$this->field_map[] = array(
			'from_tablename' => 'FORUM_FORUM',
			'from_fieldname' => 'F_TOPICS',
			'to_type'        => 'forum',
			'to_fieldname'   => '_bbp_topic_count'
		);
 
		// Forum reply count (Stored in postmeta)
		$this->field_map[] = array(
			'from_tablename' => 'FORUM_FORUM',
			'from_fieldname' => 'F_COUNT',
			'to_type'        => 'forum',
			'to_fieldname'   => '_bbp_reply_count'
		);
 
		// Forum total topic count (Stored in postmeta)
		$this->field_map[] = array(
			'from_tablename' => 'FORUM_TOTALS',
			'from_fieldname' => 'T_COUNT',
			'to_type'        => 'forum',
			'to_fieldname'   => '_bbp_total_topic_count'
		);
 
		// Forum total reply count (Stored in postmeta)
		$this->field_map[] = array(
			'from_tablename' => 'FORUM_TOTALS',
			'from_fieldname' => 'P_COUNT',
			'to_type'        => 'forum',
			'to_fieldname'   => '_bbp_total_reply_count'
		);

And I’m Not sure what the difference is from this two information….. but there is a total replies per topic

		// Topic reply count (Stored in postmeta)
		$this->field_map[] = array(
			'from_tablename'  => 'FORUM_TOPICS',
			'from_fieldname'  => 'T_REPLIES',
			'to_type'         => 'topic',
			'to_fieldname'    => '_bbp_reply_count',
			'callback_method' => 'callback_topic_reply_count'
		);
 
		// Topic total reply count (Stored in postmeta)
		$this->field_map[] = array(
			'from_tablename'  => 'FORUM_TOPICS',
			'from_fieldname'  => 'T_REPLIES',
			'to_type'         => 'topic',
			'to_fieldname'    => '_bbp_total_reply_count',
			'callback_method' => 'callback_topic_reply_count'
		);

There is also this 🙂

		// Topic author ip (Stored in postmeta)
		$this->field_map[] = array(
			'from_tablename'  => 'FORUM_TOPICS',
			'from_fieldname'  => 'T_IP',
			'to_type'         => 'topic',
			'to_fieldname'    => '_bbp_author_ip'
		);

This one is for replies

FORUM_REPLY > R_IP

tnks
J

[Stephen Edgar]

1) An easy WYSIWYG editor in bbpress for normal users(frontend).

You can enable the TinyMCE Visual Editor with instructions shown here:

Enable Visual Editor

2) With an image “upload” feature, but is not working like an attachment like “GD bbPress Attachments”.

I’m only aware of the “GD bbPress Attachments” plugin that offers this for bbPress, you should be asking in their support forums for any issues relating to why this plugin doesn’t work for you.

3) All the uploaded images will be separated by folder(user name or individual name for an user).

bbPress does NOT support attachments or media uploads ‘out of the box’
I would also suggest you also contact the “GD bbPress Attachments” support forum to request any enhancements you would like to see in the plugin.

[Stephen Edgar]

Set WP_DEBUG to false define('WP_DEBUG', false); in your wp-config.php file, this is a known issue.

More info on this:

https://bbpress.trac.wordpress.org/ticket/2309 https://core.trac.wordpress.org/ticket/24169

[Stephen Edgar]

If you only have a few forums you could design a page with each forum title and below each forum title use the following shortcode [bbp-single-forum id=$forum_id]

e.g.

My Forums Page

My First Forum
[bbp-single-forum id=123]
My Second Forum
[bbp-single-forum id=456]
My Third Forum
[bbp-single-forum id=789]

[Stephen Edgar]

bbPress doesn’t actually support the use of signatures ‘out of the box’.

What we can do though is still import that data and store it in the wp_usermeta table, then if you do add a plugin that supports signatures in bbPress you can then copy that data (Using phpMyAdmin for example) from your imported database to however that plugin supports signatures.

Simply add this field map:

// User Signature (Stored in usermeta)
$this->field_map[] = array(
	'from_tablename'  => 'FORUM_MEMBERS',
	'from_fieldname'  => 'M_SIG',
	'to_type'         => 'user',
	'to_fieldname'    => '_bbp_snitz_user_sig'
);

Thus once you (if you do) add a plugin to support signatures to can then query against the _bbp_snitz_user_sig field directly with MySQL and update your user profile fields.

I just added the above to the Gist also, you can see the changes via the ‘revisions’ link.

[gianjj]

Ok STEPHEN, tomorrow I’ll try to config a new SNITZ.PHP with all information and run it!
(hope will be my friend hihihihi)

Actually the only doubt is where store the signature, Snitz stored in
FORUM_MEMBERS > M_SIG

And ….I think can be more helpful indicate which fieldname are required in bbp …may be ther is but I didn’t find it

Tnks
Bye J

[Stephen Edgar]

And just because I could and it was quick and easy, here is a copy of the Snitz.php based on the latest Example.php with Robin’s fields mappings.

https://gist.github.com/ntwb/2f057071dd05f9758570

You can also compare the revisions (Seeing the changes made from the source Example.php)
https://gist.github.com/ntwb/2f057071dd05f9758570/revisions

[Stephen Edgar]

One more thing, when making a custom importer always base it of the Example.php importer, I keep that updated with examples and any other changes I make for bbPress.

The latest (updated 3 days ago) is here:
https://bbpress.trac.wordpress.org/browser/trunk/src/includes/admin/converters/Example.php

As Robin points out, you just delete/remove the sections or fields that are not applicable to your import e.g. ‘tags’ or if your database doesn’t include the ‘counts’ for topics in forums then remove that part in the forum section.

[Stephen Edgar]

Cool, I just edited a couple of the posts above to wrap some code in ‘code’ tags to make things a little clearer 🙂

[Robin W]

ok, the answer is somewhere in this function

function bbp_title( $title = '', $sep = '»', $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 !

[JBBoY]

Hahaha It’s better easy, but the hard doesn’t scares me! Yeah it would be great to know your idea, because I’m completely lost.
You’re right about forum categories, I didn’t realise.

I’ve tried with a code from this site who shows the last topics of all forums in a different table, but not the last (4?,5?,6?… variable who control the number ) topics in the same table. And not each topic under his Forum. 🙂

[Robin W]

I think I understand

go into dashboard>settings>forums and change the slugs for forum root and single forum root. that will change the url

If you want to change the breadcrumb, then see

Layout and functionality – Examples you can use

you can also set

‘home_text’ , ‘root_text’ and ‘current_text’

using this code

If that’s not what you are after – come back !

[Robin W]

@blankstage – not a bad description of what css does. css (cascade style sheets) changes the way the information is displayed – for instance font sizes, colours, where stuff appears, backgrounds. So the core code decides what is displayed, and css how !

some themes allow you to alter css, some don’t, but you can use a plugin such as ‘simple css’ to add css code without needing to access the backend.

[Robin W]

@nirgalo

Thanks for your comments, I have not been ignoring you, I have been running a training course all today.

It’s great that you plan to improve an existing plugin, this is exactly what community software is all about, and I really hope that you will share it when done to help others :-).

I would hasten to add I have nothing to do with bbPress, I just help out on the forum, and have written a few bbPress plugins, so views are my own!

There’s lots I’d like to see in a core bbPress or as well maintained plugins, but someone has to write the stuff, and as it’s free no-one gets paid to do so. Where there is perceived demand, then hopefully the core guys will add it.

Read/unread is a popular feature on many forums, I don’t use it on my own as it’s not relevant, but I do take advantage of other forum sites that do, and you could easily argue that it should be core, but then of course it would only be the way that the bbPress guys want it to work, which could be either of the plugins that you don’t like !

Of course ones person’s standard is another’s stifling of innovation, and that community software can grow organically is both an argument for it, and an annoyance with it 🙂

Anyway, I would love to see a read/unread plugin along the lines you propose, so if you’re the man to code it, and then share with us, you’ll be very welcome here ! necessity is the mother of invention.

@blankstage – hey thanks for your comments- they cheered me up after a long day !

[gianjj]

Opss REPLACE the CODE TAG with ‘

[gianjj]

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

[gianjj]

Example of DATE formatted with functionaly made for MSSQL Server

---------------------
--- 10 TOPIC POST from FORUM_TOPICS
---------------------
SELECT TOP (10) 

	substring(T_LAST_POST, 1,4)+  '-' + substring(T_LAST_POST, 5,2)+ '-'+
	substring(T_LAST_POST, 7,2)+  ' ' + substring(T_LAST_POST, 9,2)+ ':'+ 
	substring(T_LAST_POST, 11,2)+ ':' + substring(T_LAST_POST, 13,2)
	AS T_LAST_POST_FORMATTED, 

	substring(T_DATE, 1,4)+  '-' + substring(T_DATE, 5,2)+ '-'+
	substring(T_DATE, 7,2)+  ' ' + substring(T_DATE, 9,2)+ ':'+ 
	substring(T_DATE, 11,2)+ ':' + substring(T_DATE, 13,2)
	AS T_DATE_FORMATTED,
	*
FROM FORUM_TOPICS

---------------------
--- 10 TOPIC REPLY from FORUM_REPLY
---------------------

SELECT TOP (10) 
	substring(R_DATE, 1,4)+  '-' + substring(R_DATE, 5,2)+ '-'+
	substring(R_DATE, 7,2)+  ' ' + substring(R_DATE, 9,2)+ ':'+ 
	substring(R_DATE, 11,2)+ ':' + substring(R_DATE, 13,2)
	AS R_DATE_FORMATTED,
	*
FROM FORUM_REPLY

---------------------
--- 10 USER from FORUM_MEMBERS
---------------------
SELECT TOP (10)  
	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)
	AS M_DATE_FORMATTED,                      
	*
FROM FORUM_MEMBERS

[Brent Brooks]

I use a theme and drop in CSS in an ePanel. So far it seems to be working. CSS confuses me but I think it is the code that creates the forum and the makers have made it so when you do it it does not destroy the core of the code – but one can alter it and delete it later and it all returns to normal…

[JBBoY]

Thanks a lot for your response 🙂

I have seen in “Step by step guide to setting up a bbPress forum – Part 1”

Step by step guide to setting up a bbPress forum – Part 1

The way I want my forum looks like. Is this screenshot from previous versions and now there isn’t an easy way to do this ? I just want the topics (better last 4 topics of each forum) under the name of the forum wich they belong. The only solution is hardcoding? I don’t know where to start. Which file should I edit to change the forum structure? :S

Thanks a lot for all.

[nirgalo]

@robin-w – thanks for pointing out bbPress Mark as read plugin. I have checked it but for the reason mentioned above (not using the same db keys), it is not compatible with bbPress Unread posts plugin. So what I’ll do it make a custom version of bbPress Unread posts plugin whose code is simple and easily fixable and get along with this. Again, the read/unread state of posts really needs to be standardised by bbPress to prevent these incompatibilites between plugins.