Content Pages for vB 4.0

[ccampo]

Content pages is the result of a need for a module that would handle normal TEXT, HTML and/or PHP pages within vBulletin, this need came after an old web site I was helping to administer switched from phpBB and phpNuke to vBulletin, after the migration lots of content pages were not migrated and there was not an easy way to achieve that either and these content pages were needed as they contain valuable information for the club. I searched for a similar mod that can handle this kind of information but couldn?t find any that would fit the needs of that site, so I decided to create my own and share it as freeware so everybody can benefit from it.

The power of this MOD lays in the fact that it can accept PHP, HTML and/or TEXT as the content for the page, so the use of this MOD is almost unlimited with almost no restriction.

Before adding your pages, please make sure they work as expected on a simple PHP, HTML or TEXT page without any error, making sure all tags are properly closed, and that the page do not contain tags which may affect your overall vBulletin style. You may apply any local style, though, but make sure those new css styles will not interfere with the original vBulletin styles.

Once the page has been tested as a basic php, html or text page you can just add a content page and paste the php/html/text code into the content of the new page, the same apply to the signature of the page which can also be a php, html or text code and it is appended to the content page at the end before rendering the page, the content and the signature are considered to be from the same type.

Features:
- Manage Content Pages
- PHP, HTML and TEXT pages supported
- Navtab plugin
- vB4.0.x compatible

Take a look at the contentpages-v1.0.0.pdf document included in the zip file for full description, installation and upgrade instructions.

I hope you like it.

Demo at :
http://www.o-r-c-a.com/forum/contpages.php

Latest version:
1.1.0 production

If you find bugs please let me know, I cannot dedicate to it 100%, but I can assure you I?ll find the time to fix any problem found, also if there?s any enhancement you think will be useful please also let me know and I?ll see what can I do to include it in a newer release.
This is my first vBulletin MOD, I?ve just started a couple of months ago when the club I am a member of acquired a vB 4.0 license, and prior to that I had no experience on this software, only as a user, not even moderator, on other forums.

Please remember to click "Mark as Installed" if you use this modification.
Also feel free to nominate this modification for the MOTM, and/or use the donate link provided (Support Developer).

Thanks to Dr.osamA for the Arabic translation.

[djbaxter]

I'd like to have a look at this, but...

Download Now

No Files Uploaded.

[ccampo]

I'd like to have a look at this, but...

You're too quick, zip file has been uploaded.
This is my first vB MOD, so I'm just learning where to put things.
I'll attach some screenshots once I figure out where to upload them.

[ProFifaLeagues]

Would this install fine on 4.0 as well?

[djbaxter]

Would this install fine on 4.0 as well?

Thread title: Content Pages for vB 4.0

So I'm going to guess "yes". :)

[ProFifaLeagues]

Thread title: Content Pages for vB 4.0

So I'm going to guess "yes". :)

But it also states vB Version: 4.0.2 :)

[NFLfbJunkie]

I'm getting a database error when importing the product

Database error in vBulletin 4.0.2:

Invalid SQL:
CREATE VIEW `ffbg_cp_cats` (cp_catsid, title) AS
SELECT `cid`, `title` FROM `vb_contentpages_categories`;

MySQL Error : CREATE VIEW command denied to user 'database_username'@'localhost' for table 'ffbg_cp_cats'
Error Number : 1142
Request Date : Saturday, March 27th 2010 @ 08:47:01 PM
Error Date : Saturday, March 27th 2010 @ 08:47:01 PM
Script : http://www.mydomain.com/testforum/admincp/plugin.php?do=productimport
Referrer : http://www.mydomain.com.com/testforum/admincp/plugin.php?do=productadd
IP Address : my.ip.address
Username : my_username
Classname : vB_Database
MySQL Version : 5.0.90-community

[NFLfbJunkie]

Where exactly do I add - GRANT CREATE VIEW ON *.* TO 'database_username'@'localhost'? Is this something I have to do in phpMyAdmin? I have all of the database privileges (select, insert, update, delete, index, create temporary tables, create, alter, drop, lock tables, references and create routine) set to on

[ccampo]

I noticed from your demo site that the content pages stretch the original width of the forum pages. Can this be fixed?

Yes, it can be fixed, in fact, it is now, you can see it for yourself in the same demo site. It was a problem with the template.
I'll release a fix once more problems are reported so I can fix them together and create a new version.

[ccampo]

I'm getting a database error when importing the product

Database error in vBulletin 4.0.2:

Invalid SQL:
CREATE VIEW `ffbg_cp_cats` (cp_catsid, title) AS
SELECT `cid`, `title` FROM `vb_contentpages_categories`;

MySQL Error : CREATE VIEW command denied to user 'database_username'@'localhost' for table 'ffbg_cp_cats'
Error Number : 1142
Request Date : Saturday, March 27th 2010 @ 08:47:01 PM
Error Date : Saturday, March 27th 2010 @ 08:47:01 PM
Script : http://www.mydomain.com/testforum/admincp/plugin.php?do=productimport
Referrer : http://www.mydomain.com.com/testforum/admincp/plugin.php?do=productadd
IP Address : my.ip.address
Username : my_username
Classname : vB_Database
MySQL Version : 5.0.90-community


Some web hosting providers revoke the "create view" privileges from users.
Talk to your web hosting providers and see if they can fix that for you.

Otherwise you can do that yourself, you just need to give your MySQL user the GRANT privilege like so.

GRANT CREATE VIEW ON *.* TO 'database_username'@'localhost' ;

You will need to be logged on as root or the main database user to do this.

[ccampo]

Where exactly do I add - GRANT CREATE VIEW ON *.* TO 'database_username'@'localhost'? Is this something I have to do in phpMyAdmin? I have all of the database privileges (select, insert, update, delete, index, create temporary tables, create, alter, drop, lock tables, references and create routine) set to on

See my reply above, here's again :
You will need to be logged on as root or the main database user to do this.

or talk to your host provider, they should be able to help you.

[ccampo]

Would this install fine on 4.0 as well?

I've tested this on 4.0.1, 4.0.2, 4.0.2 PL4 and it works in all of them, it should also work on the very base 4.0 version that was released.

[NFLfbJunkie]

How did you fix the page width problem?

[NFLfbJunkie]

I noticed from your demo site that the content pages stretch the original width of the forum pages. Can this be fixed?

[ProFifaLeagues]

I've tested this on 4.0.1, 4.0.2, 4.0.2 PL4 and it works in all of them, it should also work on the very base 4.0 version that was released.


Many thanks

[ccampo]

How did you fix the page width problem?
Fix was uploaded, you can download it again, it was a problem with the template.

[NFLfbJunkie]

Since I can not get your MOD to work, and wish I could, I installed another pages MOD (https://vborg.vbsupport.ru/showthread.php?t=232207). But this one has the same problem that yours initially did - the pages stretching across the entire page. I posted this in the MOD's thread, but still haven't gotten a response. Can you tell me what the fix was for your MOD so I can see if it possibly might apply to this one. Thanks.

[mandingo]

uhhh. So after getting the root database privileges changed I get this error now instead.
Database error in vBulletin 4.0.2:

Invalid SQL:
CREATE VIEW `cp_cats` (cp_catsid, title) AS
SELECT `cid`, `title` FROM `vb_contentpages_categories`;

MySQL Error : Table '*****.vb_contentpages_categories' doesn't exist
Error Number : 1146
Request Date : Sunday, March 28th 2010 @ 04:31:24 PM
Error Date : Sunday, March 28th 2010 @ 04:31:25 PM
Script : http://mysite/admincp/plugin.php?do=productimport
Referrer : http://mysite/admincp/plugin.php?do=productadd
IP Address : 75.172.232.60
Username : yez
Classname : vB_Database
MySQL Version : 5.1.30

[ccampo]

I've found a big security hole when displaying php content pages so I've removed that feature from this mod, displaying php code also affects the look and feel of the vBulletin's style of the site and forum so for now, no php support, I've uploaded a new beta version 0.8.0 so please download and use that one instead.

[ccampo]

uhhh. So after getting the root database privileges changed I get this error now instead.

That's weird, that error would only happen if the xml file was modified in some way to execute the SQL commands in some other order, the error means that the needed table to create the view doesn't exist, and that cannot be possible because that table is created right before creating the view, unless that create table also failed?.

I'd suggest you to deinstall "Content Pages" products, then use phpMyAdmin to make sure tables vb_contentpages and vb_contentpages_categories do not exist, otherwise drop them and then import the new 0.8.0 xml file again.

good luck.

[ccampo]

Since I can not get your MOD to work, and wish I could, I installed another pages MOD (https://vborg.vbsupport.ru/showthread.php?t=232207). But this one has the same problem that yours initially did - the pages stretching across the entire page. I posted this in the MOD's thread, but still haven't gotten a response. Can you tell me what the fix was for your MOD so I can see if it possibly might apply to this one. Thanks.
My fix will not work for his mod.
The fix will have to come from him, because it requires changing the template and the php code as well, an easy workaround would be to modify just the template, I haven't tested that though, but here it is :

look for :
<link rel="stylesheet" type="text/css" href="clientscript/reset-fonts-bf.css" />

and change it to:
<vb:if condition="$pl['phpsupport']">
<link rel="stylesheet" type="text/css" href="clientscript/reset-fonts-bf.css" />
</vb:if>

[ccampo]

One new version was released v0.9.0, this one now supports PHP content pages.
Beware that if you have already installed the previous v0.8.0 version you'll need to upgrade the product, the instructions are included in the contentpages-v0.9.0.pdf document included in the zip file.
But here they are too:
1. Take an export of the TABLE_PREFIX.contentpages and TABLE_PREFIX.contentpages_categories tables, using phpMyAdmin is the easiest way.
2. Uninstall old “Content Pages” product from vB Administrator Control Panel
3. Install new “Content Pages” version 0.9.0 product from vB Administrator Control Panel
4. Import the TABLE_PREFIX.contentpages and TABLE_PREFIX.contentpages_categories tables that were exported on step 1.

[Storyteller69]

Database error in vBulletin 4.0.2:

Invalid SQL:
CREATE VIEW `cp_cats` (cp_catsid, title) AS
SELECT `cid`, `title` FROM `vb_contentpages_categories`;

MySQL Error : Table '*****.vb_contentpages_categories' doesn't exist
Error Number : 1146
Request Date : Sunday, March 28th 2010 @ 04:31:24 PM
Error Date : Sunday, March 28th 2010 @ 04:31:25 PM
Script : http://mysite/admincp/plugin.php?do=productimport
Referrer : http://mysite/admincp/plugin.php?do=productadd
IP Address : 75.172.232.60
Username : yez
Classname : vB_Database
MySQL Version : 5.1.30
I get the same error when i try to install version 0.9.0 the first time with this Stack Trace:
#0 vB_Database->halt() called in [path]/includes/class_core.php on line 421
#1 vB_Database->execute_query() called in [path]/includes/class_core.php on line 439
#2 vB_Database->query_write() called in [path]/includes/adminfunctions_plugin.php(450) : eval()'d code on line 12
#3 run_queries() called in [path]/includes/adminfunctions_plugin.php(450) : eval()'d code on line 50
#4 eval() called in [path]/includes/adminfunctions_plugin.php on line 450
#5 install_product() called in [path]/admincp/plugin.php on line 1714

The tables where created but with "my" prefix vb_3 and not only vb_. On a local-testforum without a table-prefix i get the same error. Can the "wrong" prefix be the reason for the error?

[Miras]

there's a bug inside the xml

search for
$SQL[] = "CREATE VIEW `" . TABLE_PREFIX . "cp_cats` (cp_catsid, title) AS
SELECT `cid`, `title` FROM `vb_contentpages_categories`";

replace with
$SQL[] = "CREATE VIEW `" . TABLE_PREFIX . "cp_cats` (cp_catsid, title) AS
SELECT `cid`, `title` FROM `" . TABLE_PREFIX . "contentpages_categories`";

[ccampo]

there's a bug inside the xml


Thanks a lot Miras, new zip file with the fix was uploaded.

[Storyteller69]

Also thanks from me Miras, works now! :up:

[abdicar]

hello bro, when do you think this will be ready for production forums?

[ccampo]

hello bro, when do you think this will be ready for production forums?

Even though this MOD still has the BETA label in it I think it is ready for production, I'll give one more week for others to test it and report problems (if found) before I remove the beta label and create the first production version.

I've done lots of tests, but I'm sure I haven't tested everything that's why I need your help finding bugs or problems.

[mandingo]

Thanks a lot Miras, new zip file with the fix was uploaded.

Will try again.

[Skreech94]

I'm getting this error when I click Add page

Database error in vBulletin 4.0.2:

Invalid SQL:
SELECT title, cp_catsid FROM cp_cats ORDER BY title;

MySQL Error : Table 'mydatabase_consoledge.cp_cats' doesn't exist
Error Number : 1146
Request Date : Monday, March 29th 2010 @ 11:10:55 PM
Error Date : Monday, March 29th 2010 @ 11:10:55 PM
Script : http://unlockedgamer.com/admincp/contentpages_admin.php?do=addpage
Referrer : http://unlockedgamer.com/admincp/index.php?do=nav
IP Address : My IP
Username : Username
Classname : vB_Database
MySQL Version : 5.1.30

[ccampo]

I'm getting this error when I click Add page

Database error in vBulletin 4.0.2:

Invalid SQL:
SELECT title, cp_catsid FROM cp_cats ORDER BY title;

MySQL Error : Table 'mydatabase_consoledge.cp_cats' doesn't exist
Error Number : 1146
Request Date : Monday, March 29th 2010 @ 11:10:55 PM
Error Date : Monday, March 29th 2010 @ 11:10:55 PM
Script : http://unlockedgamer.com/admincp/contentpages_admin.php?do=addpage
Referrer : http://unlockedgamer.com/admincp/index.php?do=nav
IP Address : My IP
Username : Username
Classname : vB_Database
MySQL Version : 5.1.30

The problem is that the cp_cats view was not created during the product import and your database user probably do not have privilege for creating that either, the view is needed to retrieve the available categories. Adding and editing a page needs that view to make sure a page has a valid category.
But there are good news, on Saturday April 3rd. I'll release the production version of content pages and the use of that view will not be needed anymore since I changed it to use a pre-populated array of categories instead of the view.

[ccampo]

First official production version was released 1.0.0 and it is now ready to be downloaded.
All reported problems have been fixed.
Enjoy it.

[CoZmicShReddeR]

Just download this got "XML Error: EntityRef: expecting ';' at Line 8" when I tried to install it...

[ccampo]

Just download this got "XML Error: EntityRef: expecting ';' at Line 8" when I tried to install it...

There was a missing & in the versioncheck line, fixed, download it again.

[Leica.Robbiani]

Hi,

got "XML Error: EntityRef: expecting ';' at Line 8" when I tried to install it...
Just delete the line <versioncheckurl> in the product-xml file or change it to <versioncheckurl />...

But the site is looking a little bit strange in Internet Explorer:

115216

The right display of the page should be like this one in Firefox:

115217

L.R.

[ccampo]

But the site is looking a little bit strange in Internet Explorer:

115216

The right display of the page should be like this one in Firefox:

115217

L.R.

I was not able to reproduce your exact problem, however I fixed some MSIE related css style problems which might be able to help you.

I've just uploaded a new 1.0.1 version, unzip and upload all php files again to your host and import the xml file, let me know if that fixes the problem.

[KeystoneAirsoft]

Hi all,

Downloaded both the 1.0.0 and the 1.0.1 versions and tried to install this. I am getting this error message when tryng to add Category:

Database error in vBulletin 4.0.2:

Invalid SQL:
SELECT c.cid, c.title, c.icon, c.description, count(p.pid) AS pagecount
FROM contentpages AS p
LEFT JOIN contentpages_categories AS c ON c.cid = p.cid WHERE 1
GROUP BY c.cid, c.title, c.icon;

MySQL Error : Table 'mytable.contentpages' doesn't exist
Error Number : 1146
Request Date : Saturday, April 10th 2010 @ 03:24:11 PM
Error Date : Saturday, April 10th 2010 @ 03:24:12 PM
Script :
Referrer :
IP Address : xxx.xxx.xxx.xxx
Username :
Classname : vB_Database
MySQL Version : 5.0.90-community

After looking in my phpmyadmin I did not find the 2 tables it is supposed to create upon uploading the xml file. The database user has full access to database.


I have tried to uninstall mod and get this error message:

Database error in vBulletin 4.0.2:

Invalid SQL:
DROP TABLE `contentpages`;

MySQL Error : Unknown table 'contentpages'
Error Number : 1051
Request Date : Saturday, April 10th 2010 @ 03:50:18 PM
Error Date : Saturday, April 10th 2010 @ 03:50:18 PM
Script : http://mysite/admincp/plugin.php?do=productkill
Referrer : http://mysite/admincp/plugin.php?do=productdelete&productid=contentpages&s=
IP Address : xxx.xxx.xxx.xxx
Username :
Classname : vB_Database
MySQL Version : 5.0.90-community


Any help or suggestion would be appreciated. Thanks in advance.

[ccampo]

There was a problem with the file_exists php function and some file existence verification was failing and was aborting the rest of installation steps.
the xml was fixed and i removed that verification.
I also uploaded a sql script to create those tables manually using phpmyadmin so you can use the MOD.
Just run the SQL script to manually create the tables and use the MOD, or uninstall it and then install it again using the latest zip file.

[ccampo]

Here's the script.

[firefoxextreme]

Excellent mod thanks, click installed now.

[dietpepsi]

Great mod. I've been waiting for this type of mod to be released, as I have 700+ pages I want to use with it.

That said, any chance that we'll see support for sub-categories?

[MooseMoney]

This mod is not working for me.


Database error in vBulletin 4.0.2:

Invalid SQL:
SELECT * FROM contentpages_categories ORDER BY title DESC LIMIT 0,100;

MySQL Error : Table 'weizterfishvbforum.contentpages_categories' doesn't exist
Error Number : 1146
Request Date : Monday, April 12th 2010 @ 03:43:19 PM
Error Date : Monday, April 12th 2010 @ 03:43:19 PM
Script : http://www.XXXXXXXX.com/forum/admincp/contentpages_admin.php?do=categories
Referrer : http://www.XXXXXXXX.com/forum/admincp/index.php?do=nav
IP Address : xxx.xxx.xxx.xxx
Username : xxxxxxxxxxx
Classname : vB_Database
MySQL Version : 5.0.88-userstats-log

I can't uninstall the mod either! I get another error message when I try uninstall! What now???

Database error in vBulletin 4.0.2:

Invalid SQL:
DROP TABLE `contentpages`;

MySQL Error : Unknown table 'contentpages'
Error Number : 1051
Request Date : Monday, April 12th 2010 @ 03:46:45 PM
Error Date : Monday, April 12th 2010 @ 03:46:46 PM
Script : http://www.XXXXXXXXX.com/forum/admincp/plugin.php?do=productkill
Referrer : http://www.XXXXXXXXX.com/forum/admincp/plugin.php?do=productdelete&productid=contentpages&s=
IP Address : xxx.xxx.xxx.xxx
Username : xxxxxxxxxx
Classname : vB_Database
MySQL Version : 5.0.88-userstats-log

[ccampo]

This mod is not working for me.

I can't uninstall the mod either! I get another error message when I try uninstall! What now???

use the script I provided 3 posts above "cp.txt" , modify it to meet your own vB tables prefix, that script will create the tables needed to use the mod.

If you download the zip file again the script to create the tables will not fail and the installation will succeed.

[NFLfbJunkie]

I finally have this working. Great MOD. One problem. I created an HTML document with some lists, but when I paste the code in to an HTML document, the list formatting is lost.

[MooseMoney]

use the script I provided 3 posts above "cp.txt" , modify it to meet your own vB tables prefix, that script will create the tables needed to use the mod.

If you download the zip file again the script to create the tables will not fail and the installation will succeed.

What am I suppose to do with "cp.txt"?
Please explain slowly and carefully as I am a noob!

[ccampo]

What am I suppose to do with "cp.txt"?
Please explain slowly and carefully as I am a noob!

That's just a plain text file with the SQL commands to create the tables, change the table names to match your own table PREFIX and then run those SQL commands on your MySQL database, use phpMyAdmin or similar to run those sentences.

[MooseMoney]

That's just a plain text file with the SQL commands to create the tables, change the table names to match your own table PREFIX and then run those SQL commands on your MySQL database, use phpMyAdmin or similar to run those sentences.

Thank you.
I struggled initially but seem to get it right in the end.

[Crow]

I'm interested in this mod, but I have a few questions if you don't mind?

1.) Will bb codes work on these pages?
2.) What about WOL locations, do they work?

[ccampo]

I'm interested in this mod, but I have a few questions if you don't mind?

1.) Will bb codes work on these pages?
2.) What about WOL locations, do they work?

1.) No
2.) No

These are just normal php, html or Text pages which are displayed just like any page on a browser, for bb codes you can just use the equivalent html tag instead.

[Timberwolf]

I have uploaded/imported successfully to the point of getting a tab up and have renamed it. Then when I click on it I get an error message with nothing found for the url.

http://www.seekeroftheway.com/forums/contpages.php

Could you please explain how to use this. I can't find where to create/save files to. If I want more than 1 page under the tab - is that possible?

If only one page allowed, then I assume I can link to other documents.

Please advise where to save and how to save my file (page).

Thanks

[ccampo]

I do not think the MOD was installed correctly, please de-install it and then reinstall it again.
.
In any case to create pages you have to go to the AdminCP and select "Content Pages" option, once there, click on the "Add page" option, fill in the blanks by just copying/pasting the PHP, HTML or Text page itself into the field and then save it, and that's it.

[Dr.osamA]

thanxxx ccampo

installed + 5 Stars + translated to Arabic

plzz bro be nice and add translation to 1st post

[pcalloway]

The mod doesn't work on my forum - there's no place to add pages or categories.

[AURFSCAN]

works perfect .. thankyou

[ccampo]

thanxxx ccampo

installed + 5 Stars + translated to Arabic

plzz bro be nice and add translation to 1st post

Thank you, the zip file is now available for download from the first page.

[ccampo]

The mod doesn't work on my forum - there's no place to add pages or categories.

Once the MOD is successfully installed go to the AdminCP and look for Content Pages, it should be almost at the bottom, there are options for changing the settings, add categories and pages.

[vikris]

Same problem here:

Not Found

The requested URL /upload/contpages.php was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

I'm not seeing the option to add a page in the admin cp.

Help?

Thanks!

P.S. Using VB Suite 4.0.4 PL1

[ccampo]

Same problem here:

Not Found

The requested URL /upload/contpages.php was not found on this server.

Additionally, a 404 Not Found error was encountered while trying to use an ErrorDocument to handle the request.

I'm not seeing the option to add a page in the admin cp.

Help?

Thanks!

P.S. Using VB Suite 4.0.4 PL1

There's a vB configuration problem on your site, there's no such "/upload/contpages.php" it should be "contpages.php" without the "/upload" I have no idea where that filename came from.

Where exactly are you seeing that message ? from the NabVar?

If the MOD was installed correctly these are some the links from AdminCP:
http://www.yourdomain.com/<vbforumroot>/admincp/contentpages_admin.php?do=addcat
http://www.yourdomain.com/<vbforumroot>/admincp/contentpages_admin.php?do=addpage
http://www.yourdomain.com/<vbforumroot>/admincp/contentpages_admin.php


Front page:
http://www.yourdomain.com/<vbforumroot>/contpages.php

just change www.yourdomain.com and <vbforumroot> to match your site.

That might give you some ideas where the configuration problem is coming from in your site.

[cs28702]

Does this work on the latest version of vbulletin? If not, is there another mod that allows easy creation of new pages?

[aryung]

Works Great and smooth
i want to auto start a thread in a chosen board the Thread title will be treated as Link and will redirect user to content page

how i can do this please

[ccampo]

Works Great and smooth
i want to auto start a thread in a chosen board the Thread title will be treated as Link and will redirect user to content page

how i can do this please

All you need to know is the page id of the page you want to link:
http://<yourdomain.com>/forum/contpages.php?do=showpage&pid=XX

just change the XX for the id (number) of your desired page.

Now, how to link the name of a thread to be a link of another page? You probably need a plugin to do that.

[DAMINK]

Can i ask what the difference between 1.0 and 1.1 is please?

[JanesOos]

This plugin needs a WYSIWYG editor.