Search Results for 'code'
-
Search Results
-
Please excuse the length of this post. It seeks information regarding functionality and best practice.
FUNCTIONALITY
I have developed my own functionality plugin for BBpress and would be very grateful if some one could provide me with the functions snippets for the following features:
1. Creating a header and footer for each individual forum in the index list (ala Style kit template option)
2. Removing the vertical bar that appears to the left of the sub-forum list when the following code is used:
#bbpress-forums .bbp-forums-list li {display: list-item !important;}3. Removing the commas that appear in the vertical list of the subforums. This looks odd and ugly. My links are style in orange and then at the end of each subforum there is a black comma. Can this comma be removed or can it be styled with css so that its color is the same as the subforum links? If it can be styled what is its unique selector?
4. The BBP toolkit has an option to remove all of the blue and yellow alert/info boxes. What is the snippet for this function?
5. The BBp toolkit has an option to only add css to BBP pages. What is the snippet for this function and is it necessary(or a possible conflict) if I chose to run WP minify?
BEST PRACTICE
This is the first site I have developed with a forum. What is the best practice regarding admin forum content, forum rules is a relevant example. Should I create a forum dedicated to my admin topics (included form rules), or rather, should I just create topics for admin content and make them super sticky (which I understand means they will appear at the top of every forum)Again my humble apologies for the length of this post. And, as always, thanks very much for anyone render their valuable assistance.
Kind Regards
Max
With Robin’s valuable assistance I now have a created new topic link at the top of each of my forums.
However one forum is for my use solely and only contains locked topics such as forum rules.
1. Is there a snippet of code that I can add to my functionality plugin that allows me to selectively remove the create new topic link from atop a specific forum?
2. And,or, can the create new topic link just be hidden using CSS visibility:hidden, and if so what is the link’s unique selector?
Thanks in advance for any assistance provided.
Kind Regards
Max
There were features in both the BBp Style Pack and BBpress Toolkit that I desired.
Unfortunately when ever I installed both plugins, my site became buggy. There is a conflict between the two it would seem.
So I bit the bullet and created my own functionality plugin and used it and WP Custom CSS to create each of the features and styling I desired from the Style Pack and the Toolkit.
There are just three features that I couldn’t find any documentation for:
1. Changing the header label Freshness to other wording, and
2. Creating a “create new topic” link.I am aware that the first of these features is also included in Robins other plugin called Latest Post (or something like that) however that plugin also includes another feature that I do not require (as I have coded my own)
And so my request. Can someone please provide me with:
1. a function snippet to change freshness to other wording
2. a function snippet to add a “create new topic” link at the top of a forumThanks in advance for any assistance.
Kind Regards
Max
Topic: login page problem
So, really, I have a two-part question. First, I’d like to add some new roles. I’ve read and looked all over the place without any real answer. I know what codes to use per the documentation. That said, I’m not sure which file to place them in and that’s the part I can’t find definitive answers on. If someone could direct me which directory and file to add it to that’d be great. I already know not to do it to the BBpress core files.
Also, is there a way to assign specific moderators to specific boards. Say a user is a moderator, but I don’t want them to moderate all boards, just specific boards. Is that possible?
Topic: phpbb Import Question
I’m trying to import a phpbb forum with about 50,000 posts into a local dev site.
It continually stalls at “Converting topics (4900-4999)”
I’m trying to follow the instructions here:
which say to make a copy of the db and drop all records except within the offending range and try the import again to isolate the problematic row.Should I go into phpbb_topics or phpbb_topics_posted to try and look for the offending problem?
Once I have the right table, do I then delete the first 4899 rows that appear in the db?
I’m using the latest WordPress and have tried both bbpress 2.5.9 and 2.6alpha.
Thanks for any help you can give me.
Hi you guys,
I’m in the process of importing a rather large vBulletin board. It has around 50’000 topics and more than 3 million posts.
And I’ve got this one question: does bbPress write out or somehowe save topics, which it couldn’t import? So I can get a glimpse at the problem at hand why a certain vBulletin thread has not been imported?
A little more background: I’ve done a few test imports, and so far bbPress is doing a terrific job. To keep import time manageable, I modified the vBulletin converter from bbPress to skip replies, which I import with some more complex SQL queries after the bbPress importer has created users and topics.
Nearly all of my 20’000 users and 50’000 topics get imported, but some vBulletin threads do not shop up with the
meta_keynamed_bbp_old_topic_id. I really tried to spot a pattern there, but had no luck. So I’m hoping there’s a way to gather some more information directly from the bbPress import.I’m running bbPress 2.5.9 and WordPress 4.5.2
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!
[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 restartMake it executable:
chmod +x install_preg.shAnd run it:
./install_preg.sh2) 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_databasemysql -u root -p -e 'CALL sp_cleanup_topics()' my_databasemysql -u root -p -e 'CALL sp_cleanup_missing()' my_databaseNow, 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