Skip to:
Content
Pages
Categories
Search
Top
Bottom

Special characters in title on my RSS feed

Published on June 8th, 2016 by natinho68

Hi,

I have an issue with the encoding in my topic title.

I don’t know how to fix the special characters like รฉ,รจ,”, etc (I’m french so it’s very important).

My rss feed is : http://www.fieci-cfecgc.org/forumfieci/feed

I don’t understand, because in my main feed, special characters in title are displayed good… (http://www.fieci-cfecgc.org/feed

Thanks for help ๐Ÿ™‚

How to enable swearing in Forums?

Published on June 8th, 2016 by saddiiope

Hello all,

I am trying to run a music forum, and it appears that whenever people swear, it says “Error: your reply cannot be created at this time”

All I see on these support pages are people trying to add filters for swearing, I’m trying to do the opposite.

How can I make it so there are no verbal restrictions when posting in the forums?

Thank you

Blocking edit user profile link for non admin/keymaster

Published on June 8th, 2016 by khunmax

I have my site configured with a login/out link in the primary menu (BAW login/logout menu) with the admin bar hidden using (hide admin bar from non admins). BBpress participants can click on there user name to visit their profile. The problem is that every level of user, including participants, can see and access the edit link in all other profiles including the Admin/keymaster.

How can I remove a participants access to the edit page of other users profiles?

Thanks very much for any assistance you can offer.

Kind Regards

Max

How do I make my forum title unique?

Published on June 7th, 2016 by tian94

Hi guys my website has a forum called. “Characters and creatures”, at the moment when I post the short code to display the forum the default is “Forum” how can I get it to grab what the forum category is use that as the name instead. Thanks!

http://postimg.org/image/xa5mh7z9d/

Images won’t embed / edit the edit log

Published on June 7th, 2016 by ms52390

I have two brief questions:

Seen here: Example
My images wont embed using the img button in the editor. If the code looks like: <img src="http://www.rcgroups.com/forums/showatt.php?attachmentid=9064638">
It only works in FireFox, but not in Safari and Chrome (didn’t try IE).

Second question:
Is there a way to (via code changes I assume) to change how the edit log shows for a post? If you look in the above example, the log is ridiculously long. Is there a way to not show previous edit datetimes and by what user?

Increase font size of subforum titles

Published on June 7th, 2016 by craigg5

On my forum page that shows all of my forum categories, underneath the main categories my subcategory forums show in parentheses along with the topics and post numbers, but the font is small and kind of hard to see. How do I increase the size of the subcategory font text? Thanks.

topic’s page don’t show any header

Published on June 7th, 2016 by 123plm

Hi,
In my topics pages, there are no header (like : Viewing 4 replies – 1 through 4 (of 4 total))
And replies are not shown either, just one and then at the bottom there are a line for each reply with date, author and id, click on the id will not open the reply just go to answer’s form.
I don’t understand how to change that to have usual topic page.
I’m using WP 4.5.2 and BBPress 2.5.9, the theme is Newsmag from mythemeshop.
Topic page : http://www.regroupementpplocal.com/topic/les-medias-parlent-de-nous/
Thanks for your help
P

[TUTORIAL] Convert phpBB links after import

Published on June 6th, 2016 by Schoelje

[Warning]: DO NOT DO THIS ON A PRODUCTION DATABASE!
My apologies for the caps, but this is really important ๐Ÿ˜‰

[Assumptions]: Debian/Ubuntu developmachine with phpMyAdmin.

[Note]: Obviously I haven’t tested all Apache/MySql versions. This was done on SolydK (Debian Jessie). It is also not perfect. So, if somebody can improve on the code. Please, let me know.

After you’ve setup a development machine, imported the phpBB data and checked that everything is working fine, you still need to convert the phpBB internal links like “viewtopic.php?p=####” or “viewtopic.php?t=####” to the slugs that are being used by bbPress.

Let’s start!

1) First you’ll need to install and compile lib_mysqludf_preg.
Create a bash file install_preg.sh with this content:

#!/bin/bash
apt-get update
apt-get install libpcre3-dev libmysqlclient-dev build-essential libmysqld-dev libpcre3-dev
wget https://github.com/mysqludf/lib_mysqludf_preg/archive/testing.zip
unzip testing.zip
cd lib_mysqludf_preg-testing
./configure
make  install
make MYSQL="mysql -p" installdb
service mysql restart

Make it executable:
chmod +x install_preg.sh

And run it:
./install_preg.sh

2) Install the stored procedures.
In phpMyAdmin, select the database and the SQL tab.
Paste the following codes separately, creating three stored procedures on your database:

DELIMITER $$
CREATE PROCEDURE sp_cleanup_replies()
BEGIN
  -- declare cursor for reply url change
  DECLARE reply_cursor CURSOR FOR 
  SELECT DISTINCT old_post_id, REPLACE(<code>xkcom_posts</code>.<code>guid</code>, 'http://yoursite.com', '') AS new_url
  FROM (SELECT CAST(CONVERT(PREG_CAPTURE('/#p([0-9]+)/i', <code>post_content</code>, 1) USING UTF8) AS UNSIGNED) AS old_post_id FROM <code>xkcom_posts</code>) AS t1
  INNER JOIN <code>xkcom_postmeta</code> ON <code>xkcom_postmeta</code>.<code>meta_value</code> = old_post_id
  INNER JOIN <code>xkcom_posts</code> ON <code>xkcom_posts</code>.<code>ID</code> = <code>xkcom_postmeta</code>.<code>post_id</code>
  WHERE <code>xkcom_postmeta</code>.<code>meta_key</code> = '_bbp_old_reply_id'
  AND old_post_id IS NOT NULL
  ORDER BY old_post_id DESC;
  
  SELECT 'sp_cleanup_replies: START';
  
  -- Change posts
  OPEN reply_cursor;
  BEGIN
    DECLARE old_reply_id MEDIUMINT;
    DECLARE new_url VARCHAR(255);
    DECLARE search_string VARCHAR(255);
    DECLARE done INT DEFAULT FALSE;
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

    read_loop: LOOP
      FETCH reply_cursor INTO old_reply_id, new_url;
      IF done THEN
	LEAVE read_loop;
      END IF;
      
      SET search_string = CONCAT('|[a-z0-9\.\-:\/&=\?\+]+#p', old_reply_id, '|i');
      SELECT CONCAT('sp_cleanup_replies: replace ', search_string, CONCAT(' with ', new_url));
      
      -- Uncomment the following line if you want to test the regexp
      -- SELECT CONVERT(PREG_REPLACE(search_string, new_url, <code>post_content</code>) USING UTF8) FROM <code>xkcom_posts</code> WHERE INSTR(<code>post_content</code>, CONCAT('#p', old_reply_id)) > 0; LEAVE read_loop;
      
      UPDATE <code>xkcom_posts</code> SET <code>post_content</code>= CONVERT(PREG_REPLACE(search_string, new_url, <code>post_content</code>) USING UTF8) WHERE INSTR(<code>post_content</code>, CONCAT('#p', old_reply_id)) > 0;
    
    END LOOP;
  END;
  CLOSE reply_cursor;
  
  SELECT 'sp_cleanup_replies: DONE';
  
END$$
DELIMITER ;
DELIMITER $$
CREATE PROCEDURE sp_cleanup_topics()
BEGIN 
  -- declare cursor for topic url change
  DECLARE topic_cursor CURSOR FOR 
  SELECT DISTINCT old_topic_id, REPLACE(<code>xkcom_posts</code>.<code>guid</code>, 'http://yoursite.com', '') AS new_url
  FROM (SELECT CAST(CONVERT(PREG_CAPTURE('/t=([0-9]+)/i', <code>post_content</code>, 1) USING UTF8) AS UNSIGNED) AS old_topic_id FROM <code>xkcom_posts</code>) AS t1
  INNER JOIN <code>xkcom_postmeta</code> ON <code>xkcom_postmeta</code>.<code>meta_value</code> = old_topic_id
  INNER JOIN <code>xkcom_posts</code> ON <code>xkcom_posts</code>.<code>ID</code> = <code>xkcom_postmeta</code>.<code>post_id</code>
  WHERE <code>xkcom_postmeta</code>.<code>meta_key</code> = '_bbp_old_topic_id'
  AND old_topic_id IS NOT NULL
  ORDER BY old_topic_id DESC;
  
  SELECT 'sp_cleanup_topics: START';
  
  -- Change topics
  OPEN topic_cursor;
  BEGIN
    DECLARE old_topic_id MEDIUMINT;
    DECLARE new_url VARCHAR(255);
    DECLARE search_string VARCHAR(255);
    DECLARE done INT DEFAULT FALSE;
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

    read_loop: LOOP
      FETCH topic_cursor INTO old_topic_id, new_url;
      IF done THEN
	LEAVE read_loop;
      END IF;
      
      SET search_string = CONCAT('|[a-z0-9\.\-:\/&=\?\+]+t=', old_topic_id, '|i');
      SELECT CONCAT('sp_cleanup_topics: replace ', search_string, CONCAT(' with ', new_url));
      
      -- Uncomment the following line if you want to test the regexp
      -- SELECT CONVERT(PREG_REPLACE(search_string, new_url, <code>post_content</code>) USING UTF8) FROM <code>xkcom_posts</code> WHERE INSTR(<code>post_content</code>, CONCAT('t=', old_topic_id)) > 0; LEAVE read_loop;
      
      UPDATE <code>xkcom_posts</code> SET <code>post_content</code>= CONVERT(PREG_REPLACE(search_string, new_url, <code>post_content</code>) USING UTF8) WHERE INSTR(<code>post_content</code>, CONCAT('t=', old_topic_id)) > 0;

    END LOOP;
  END;
  CLOSE topic_cursor;
  
  SELECT 'sp_cleanup_topics: DONE';
  
END$$
DELIMITER ;
DELIMITER $$
CREATE PROCEDURE sp_cleanup_missing()
BEGIN
  -- declare cursor for reply url change
  DECLARE missing_cursor CURSOR FOR 
  SELECT DISTINCT old_post_id
  FROM (SELECT CAST(CONVERT(PREG_CAPTURE('|/&[a-z0-9=\+]+#p([0-9]+)|i', <code>post_content</code>, 1) USING UTF8) AS UNSIGNED) AS old_post_id FROM <code>xkcom_posts</code>) AS t1
  WHERE old_post_id IS NOT NULL
  ORDER BY old_post_id DESC;
  
  SELECT 'sp_cleanup_missing: START';
  
  -- Change posts
  OPEN missing_cursor;
  BEGIN
    DECLARE missing_reply_id MEDIUMINT;
    DECLARE search_string VARCHAR(255);
    DECLARE done INT DEFAULT FALSE;
    DECLARE CONTINUE HANDLER FOR NOT FOUND SET done = TRUE;

    read_loop: LOOP
      FETCH missing_cursor INTO missing_reply_id;
      IF done THEN
	LEAVE read_loop;
      END IF;
      
      SET search_string = CONCAT('|[a-z0-9&=\+]+#p', missing_reply_id, '|i');
      SELECT CONCAT('sp_cleanup_missing: remove ', search_string);
      
      -- Uncomment the following line if you want to test the regexp
      -- SELECT CONVERT(PREG_REPLACE(search_string, '#', <code>post_content</code>) USING UTF8) FROM <code>xkcom_posts</code> WHERE INSTR(<code>post_content</code>, CONCAT('#p', missing_reply_id)) > 0; LEAVE read_loop;
      
      UPDATE <code>xkcom_posts</code> SET <code>post_content</code>= CONVERT(PREG_REPLACE(search_string, '#', <code>post_content</code>) USING UTF8) WHERE INSTR(<code>post_content</code>, CONCAT('#p', missing_reply_id)) > 0;
    
    END LOOP;
  END;
  CLOSE missing_cursor;
  
  SELECT 'sp_cleanup_missing: DONE';
  
END$$
DELIMITER ;

3) Run the stored procedures from terminal.
It is important that you check some example posts with links that need to change. First the post links like “viewtopic.php?some_parameters#p#####”, then topic links like “viewtopic.php?some_parameters&t=#####” and lastly the links to missing posts are removed.

mysql -u root -p -e 'CALL sp_cleanup_replies()' my_database

mysql -u root -p -e 'CALL sp_cleanup_topics()' my_database

mysql -u root -p -e 'CALL sp_cleanup_missing()' my_database

Now, check your posts and when you’re happy you can drop the stored procedures:

DROP PROCEDURE IF EXISTS sp_cleanup_replies;
DROP PROCEDURE IF EXISTS sp_cleanup_topics;
DROP PROCEDURE IF EXISTS sp_cleanup_missing;

Mod note: edited and changed dev site from contributer to yoursite.com

No Header

Published on June 6th, 2016 by 123plm

HI,
Sorry but I couldn’t find how to start a topic.
I’ve got an error in my BBpress forum, when topic’s page shows, there is no header (with number of replies etc) and one can’t see or access to all replies, only the first 2.
I don’t know how to set this up, could you help me ?
Thanks
the topic’s page : http://www.regroupementpplocal.com/topic/les-medias-parlent-de-nous/

Auto promote user to another group when X posts reached

Published on June 6th, 2016 by akira010203

Hello,

Do you know a plugin that can auto promote a forum user to another group when he reach like 10 posts and/or 30 days since registration ?

Thanks for you awnser!

Skip to toolbar