The Arcive of Official vBulletin Modifications Site.

About Developer · **Released**: 06-13-2003

UPDATES
version 0.4 is out

- Now allows for basic VBCODE input.
- Fixed somemore bugs.

Background
Required a section on my site to display articles/tutorials
No such hack in the Hacks Database
Decided to try my hand at it

ACKNOWLEDGEMENTS
This hack uses a lot of code from Arunan Sridharan's vB Links Directory v2.0
I use that hack too and was inspired to code something around that
A big thank-you must go out to him for coding the Links Directory in the first place (I merely modified much of the code to suit my needs for this hack)

Appreciation also goes out to Kars10 for aiding me in this hack
He coded the portion in version 0.3 on number of articles count as well as article hits count
He also suggested several template changes which have been incoporated into version 0.3
A great big special shout out to TheComputerGuy, 97cobracpe, dontpanic for stamping out the bugs with your fixes. Thanks guys

WHATS IT DO ?
This hack allows you to have a database of articles/tutorials etc on your site/forums.

FEATURES

AdminCP
Installer script

Admin options

View Categories
Edit Categories
Add Categories ( category name, category icon, category order, category description )
Delete Categories
Add new article ( title, description, author, date, content )
Edit article
Delete article
View ALL articles in database
Option in vB options to turn validation of articles on/off
Fully template based as to how you wish to display the articles,categories and main article home page.
Addition of articles accepts basic VBcodes

Member options

View Categories
Browse Categories
View articles
Submit new article
Submission of articles accepts basic VBcodes

INSTALLATION & UPGRADING
This Hack should work on ALL 2.2.x versions and v2.3.0
Please read the install_readme.txt file in the package for fresh installation instructions
IMPT: If you installed a previous version pls read the upgrade_readme.txt file carefully for upgrade instructions

HACK DOWNLOAD

Version 0.4 of this hack can be downloaded here

ADD-ONS
i) Add-on for vbHome
ii) Add-on for ForumHome
iii) Add-on to enable only registered members to be able to view the article section

DEMO SITES
http://www.runaked.com/forums/articles.php ( running v0.4 ) - TheComputerGuy's site

http://www.mcseworld.com/forums/infocenter.php ( running v0.3 ) - dontpanic's site

Feel free to submit your sites if u installed this hack so it can be listed as another live demo site

SUPPORT
I cannot promise any support on this as i am pretty new to this but I will try my best.
If you are using this hack , pls click the INSTALL button
to be kept in the loop of any bug reports, add-ons and hack version updates.

Thanks everyone

dontpanic · #**132** 07-12-2003, 01:27 AM

Quote:

Today at 10:12 PM cinq said this in Post #130
Updated the hack with fixes from post 126 and 127.

Thanks a million, dontpanic for pointing them out and providing the fixes

As for post 128, without the change, your users cannot submit HTML content ?

You mean post 129?

Before that fix, you could submit HTML from the public page (articles.php?action=addarticle) all you wanted...you just lost the formatting when saved. That fix preserves HTML so that when you go to validate it later, its still good.

I have it all tweaked out and running like a champ right now at MCSE World. I am going to also be integrating an HTML editor into the submission page as well...unforunately that's a commerical product, so I won't be releasing that mod to your hack. :tired:

Thanks again!

cinq · #**133** 07-12-2003, 01:55 AM

Right, will throw that in as well , thanks for the clarification

HTML editor ? That sounds interesting, where can more info about it be found ? ( ie. purchased from ? )

You have integrated this hack into your infocenter really nicely.
Will put your site up as another live demo , hope you do not mind

cinq · #**134** 07-12-2003, 02:03 AM

Ok updated the hack download.

For those who installed it prior to 12-07-2003 ( today ) , please refer to posts 126, 127, 129 for fixes.

dontpanic · #**135** 07-12-2003, 02:03 AM

Thanks for all your hard work on this, I couldn't have gotten this far without!

As for adding the site as a live demo, please do...I'll never turn away more traffic.

As for the HTML editor, I'm working with htmlEditbox 2.0. Haven't had the chance to start integrating it, but I'll let you know how it goes.

dontpanic · #**136** 07-12-2003, 02:05 AM

Sorry, just found this one. This affects editing categories from within the CP.

In vbArticlesadmin.php, find:

PHP Code:


			
// ############################# Edit Category #########################

if ($action=="editcat") {

$sql = "SELECT * FROM vbArticles_cat WHERE artcatid=$artcatid";

Replace it with:

PHP Code:


			
// ############################# Edit Category #########################

if ($action=="editcat") {

$sql = "SELECT * FROM vbArticles_cat WHERE artcatid=$catid";

I am really putting this hack through it's paces. Thanks again!

cinq · #**137** 07-12-2003, 02:06 AM

I was actually glancing through this hack here

Wonder if it can somehow be integrated.

cinq · #**138** 07-12-2003, 02:10 AM

And what does post 135 change ?

dontpanic · #**139** 07-12-2003, 02:22 AM

Quote:

Today at 11:10 PM cinq said this in Post #137
And what does post 135 change ?

Sorry, sometimes I forget to explain it all.

If you went to edit a category from within your AdminCP, you would get a fetch error. This corrects that.

As for that WYSIWYG editor...dunno, I didn't even see that when I looked earlier...but that's how it always is! If that can be integrated, and it's free, so much the better! :rambo:

Russ_T · #**140** 07-12-2003, 03:28 PM

cinq - Just to say thanks for giving me the hack and it installed fine.

One little change I made in index.php in /forum/admin I changed

Quote:

makenavselect("vbArticles","<br>");

for

Quote:

makenavselect("vbArticles");

as the gap was too big for me.

The edit page also says Byline and not Description

I get the error like others when editing and removing wont work for me either?

Quote:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /home/www/zclubnieW/forum/admin/vbArticlesadmin.php on line 234

A couple ideas that might have already been mentioned,

Is it possible to turn on full URL usage for the category image incase we don't want an image from the images folder?

Maybe an e-mail this article to a friend feature one day?

E-mail to the validater saying "New article to validate" with corresponding email option?

Thanks for the hack though, very good stuff, I like! If you would like me to help out or implement something for you just say.

Thanks again!

I'm a happy bunny now, look at http://www.zclub.net/forum/articles....rticle&artid=2

I'm now busy trying to chase down my vbArticlesadmin.php 234 error

Russ_T · #**141** 07-12-2003, 04:16 PM

Ok found it

in vbArticlesadmin.php

Quote:

$result = $DB_site->query("SELECT * FROM vbArticles_content WHERE Categoryid=$catid");
if ($myrow = $DB_site->num_rows($result)) {
while ($myrow=$DB_site->fetch_array($result)) {
$hasattach=1;
$articleid=$myrow["artid"];

should be

Quote:

$result = $DB_site->query("SELECT * FROM vbArticles_content WHERE Categoryid=$catid");
if ($myrow = $DB_site->num_rows($result)) {
while ($myrow=$DB_site->fetch_array($result)) {
$hasattach=1;
$artid=$myrow["artid"];

Last line changes as the $artid reference is used... not $articleid...

I haven't checked that fixes it but I'm sure it will.

Cheers

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.06967 seconds Memory Usage 2,325KB Queries Executed 27 (?)
More Information
Template Usage: (1)SHOWTHREAD (1)ad_footer_end (1)ad_footer_start (1)ad_header_end (1)ad_header_logo (1)ad_navbar_below (1)ad_showthread_beforeqr (2)bbcode_php (7)bbcode_quote (1)footer (1)forumjump (1)forumrules (1)gobutton (1)header (1)headinclude (1)modsystem_post (1)navbar (6)navbar_link (120)option (1)pagenav (1)pagenav_curpage (4)pagenav_pagelink (2)pagenav_pagelinkrel (11)post_thanks_box (11)post_thanks_button (1)post_thanks_javascript (1)post_thanks_navbar_search (11)post_thanks_postbit_info (10)postbit (11)postbit_onlinestatus (11)postbit_wrapper (1)spacer_close (1)spacer_open (1)tagbit_wrapper Phrase Groups Available: global inlinemod postbit posting reputationlevel showthread	Included Files: ./showthread.php ./global.php ./includes/init.php ./includes/class_core.php ./includes/config.php ./includes/functions.php ./includes/class_hook.php ./includes/modsystem_functions.php ./includes/functions_bigthree.php ./includes/class_postbit.php ./includes/class_bbcode.php ./includes/functions_reputation.php ./includes/functions_post_thanks.php Hooks Called: init_startup init_startup_session_setup_start init_startup_session_setup_complete cache_permissions fetch_postinfo_query fetch_postinfo fetch_threadinfo_query fetch_threadinfo fetch_foruminfo style_fetch cache_templates global_start parse_templates global_setup_complete showthread_start showthread_getinfo forumjump showthread_post_start showthread_query_postids showthread_query bbcode_fetch_tags bbcode_create showthread_postbit_create postbit_factory postbit_display_start post_thanks_function_post_thanks_off_start post_thanks_function_post_thanks_off_end post_thanks_function_fetch_thanks_start post_thanks_function_fetch_thanks_end post_thanks_function_thanked_already_start post_thanks_function_thanked_already_end fetch_musername postbit_imicons bbcode_parse_start bbcode_parse_complete_precache bbcode_parse_complete postbit_display_complete post_thanks_function_can_thank_this_post_start pagenav_page pagenav_complete tag_fetchbit_complete forumrules navbits navbits_complete showthread_complete
Messages:

The Arcive of Official vBulletin Modifications Site.

It is not a VB3 engine, just a parsed copy!