Major Additions - Content Pages for vB 4.0

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.

[ccampo]

Originally Posted by Junkie

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/ad...=productimport
Referrer : http://www.mydomain.com.com/testforu...?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]

Originally Posted by rammieone

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]

Originally Posted by ccampo

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]

Originally Posted by Junkie

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. 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]

Originally Posted by mandingo

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.