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

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.

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]

Originally Posted by mandingo

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]

Originally Posted by Miras

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]

Originally Posted by abdicar

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]

Originally Posted by ccampo

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/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