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

Originally Posted by CoZmicShReddeR

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:

Attachment 115216

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

Attachment 115217

L.R.

[ccampo]

Originally Posted by Leica.Robbiani

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

Attachment 115216

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

Attachment 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=...ontentpages&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.