The Arcive of Official vBulletin Modifications Site.

v3 Articles 1.0.1 - [vB 3.0.1] · **Released**: 06-06-2004

v3 Articles 1.0.1

By John Warwick, Web Development Freelancer (john@eovieinteractive.com)
Fully tested and working on vBulletin 3.0.1.
Part of www.v3arcade.com

Important Security Fix - Please download v3 Articles 1.0.2.zip
---
If you are upgrading, please read Security Fix Upgrade.txt
If you are installing for the first time, read Instructions.txt

INTRODUCTION
v3 Articles was originally written for the fine people at www.DodgeTalk.com, for use with their vBulletin forum. The purpose of this add-on is to provide a place in vBulletin for articles (e.g. news, reviews, editorials) similar to that of the thread interface - but with a more content-oriented approach.

Features:
- Usergroup based permissions
- Full editing/deletion/moderation system
- Article attachments
- Article ratings
- Comments system
- "Featured Article" system, give great articles top exposure
- Introduction and category description text
- Smilies and icons
- Full BBCODE/WYSIWYG support
- Attachment captions
- Full page navigation for articles and comments
- Comment dupe checking
- Status icons
- View users' ratings in their comments

Alternatively, check the screenshots!

I've tried to make the installation as quick and painless as possible. Enjoy!

WORKING DEMO
You can see a working demo of v3 Articles at www.v3articles.com. (Part of the v3 Arcade website.)

MANY THANKS
- Ron Wilson, of DodgeTalk.com
- Everyone on v3Arcade.com who donated to keep the server running

SUPPORT
Support can be found in the v3 Articles thread on vBulletin.org, and shortly on v3arcade.com. (I'll set up a priority support system.) As always, I'll happily give support for real problems. However, a lot of the time people ask questions about things which have already been answered hundreds of times. If you have a problem caused by not reading through the instructions or checking through the support thread, I can't guarantee a response.

DONATIONS
v3 Articles is free, but my server isn't! Any donations are hugely appreciated in order to help me keep my v3 sites running. (PayPal: john@eovie.com). Many thanks to those who donate!
If you're looking for someone to install v3 Articles for you, email me at john@eovieinteractive.com.

PLEASE CLICK INSTALL
Needless to say, if you install this please click the "Install" button. Thanks.

Paul M · #**842** 01-04-2005, 11:57 AM

It's really not that hard to follow;

If you had 1.0.1 installed before the security patch was issued you can either apply the fixes as detailed in the fix document, or you can download v1.0.2 and just replace the article.php. If you are installing from scratch then just download 1.0.2 - this has the security fixes aplied to it already.

There are more patches & addons in the vb3 addon's forum that you can apply if you wish.

GoTTi · #**843** 01-04-2005, 03:38 PM

what about the attachment file and all the other files in the zip??

should i just upload that and overwrite the thing and run the upgrade.php?

GoTTi · #**844** 01-04-2005, 05:13 PM

is there a way to have things posted in the articles section to be shown on the forum category it belongs to? instead of it just having 2 -'s in it.

mello_mike · #**845** 01-04-2005, 09:26 PM

Quote:

Originally Posted by TRStealth

Hi,

I'm trying to get the 'Featured Article' thing to show up on the index page, but I'm having trouble.

I got the featured_article template to show, but the actual featured article won't.

I've added the following to the index.php page:

PHP Code:


			
$globaltemplates = array(

    'FORUMHOME',

    'forumhome_event',

    'forumhome_forumbit_level1_nopost',

    'forumhome_forumbit_level1_post',

    'forumhome_forumbit_level2_nopost',

    'forumhome_forumbit_level2_post',

    'forumhome_lastpostby',

    'forumhome_loggedinuser',

    'forumhome_moderator',

    'forumhome_pmloggedin',

    'forumhome_subforumbit_nopost',

    'forumhome_subforumbit_post',

    'forumhome_subforumseparator_nopost',

    'forumhome_subforumseparator_post',

    'article_featured'

);

then

PHP Code:


			
require_once('./includes/functions_articles.php');

And finally

PHP Code:


			
// ### Start Articles



        $featuredarticle = unserialize($datastore['featuredarticle']);

        if ($featuredarticle['id'])

        {

            $feature = $DB_site->query_first("SELECT article.*, articlepost.*, articlecategory.options AS options FROM " . TABLE_PREFIX . "article AS article

            INNER JOIN " . TABLE_PREFIX . "articlepost AS articlepost ON (articlepost.postid = article.firstpostid)

            INNER JOIN " . TABLE_PREFIX . "articlecategory AS articlecategory ON (articlecategory.categoryid = article.categoryid)

            WHERE article.articleid=$featuredarticle[id]");

        }

        if (!empty($feature['title']))

        {

        

            // do html

            if ($feature['options'] & 256)

            {

                $dohtml = 1;

            }

            

            if ($feature['options'] & 512)

            {

                $dosmilies = 1;

            }

            

            // get an attachment, if there's one with a thumnail

            $attachment = $DB_site->query_first("SELECT attachmentid FROM " . TABLE_PREFIX . "articleattachment WHERE articleid=$featuredarticle[id] AND thumbnail_dateline>1 ORDER BY RAND() LIMIT 0,1");

            if (!empty($attachment['attachmentid']))

            {

                $GLOBALS['isattachment'] = true;

            }            

            

            require_once('./includes/functions_bbcodeparse.php');

            $feature['postbody'] = truncate_text($feature['postbody'], $vboptions['featuredlength'], 1);

            $feature['postbody'] = parse_bbcode2($feature['postbody'], $dohtml, 0, $dosmilies, 1);

    

            eval('$articlecontent .= "' . fetch_template('article_featured') . '";');

        }

        

// ### End Articles





// ### ALL DONE! SPIT OUT THE HTML AND LET'S GET OUTA HERE... ###

eval('$articlecontent .= "' . fetch_template('article_featured') . '";');

eval('$navbar = "' . fetch_template('navbar') . '";');

eval('print_output("' . fetch_template('FORUMHOME') . '");');

However, this only displays the template, like I said. It doesn't show the featured article.

Hey I figured out how to add the featured article to the Forum Home...

You basically do everything you just did... plus

add $articlecontent to your FORUMHOME template

also in your index.php file

change

PHP Code:


			
$specialtemplates = array(

    'userstats',

    'birthdaycache',

    'maxloggedin',

    'iconcache',

    'eventcache',

    'mailqueue'

to

PHP Code:


			
$specialtemplates = array(

    'userstats',

    'birthdaycache',

    'maxloggedin',

    'iconcache',

    'eventcache',

    'mailqueue',

    'featuredarticle'

);

Now whenever you feature an article it will also show on the Forum home... hope that helps.

mello_mike · #**846** 01-04-2005, 09:33 PM

OH I Just noticed something.. there's a change that have to be made in order to get the featured article from showing up twice on the forum home.

in your Index.php file Change

PHP Code:


			
// ### ALL DONE! SPIT OUT THE HTML AND LET'S GET OUTA HERE... ###

eval('$articlecontent .= "' . fetch_template('article_featured') . '";');

eval('$navbar = "' . fetch_template('navbar') . '";');

eval('print_output("' . fetch_template('FORUMHOME') . '");');

to

PHP Code:


			
// ### ALL DONE! SPIT OUT THE HTML AND LET'S GET OUTA HERE... ###

eval('$navbar = "' . fetch_template('navbar') . '";');

eval('print_output("' . fetch_template('FORUMHOME') . '");');

GoTTi · #**847** 01-04-2005, 11:08 PM

.........

nathanaus · #**848** 01-05-2005, 10:49 AM

This is going to sound dumb - please don't laugh.

i installed this script/hack. Uhhh how do I actually write an article? In the forum proper you have buttons "new thread" in this hack I see no means in which to write an article.

I visited the vb3articles.com site, and again (as a guest user) saw no ability to write an article. I then registered on that site, and couldn't get back to the article page - because as a registered user I didn't have permission to view the article page, logging out though I did have permission. So as a registered user I couldn't see if there was a new article button or soething there to allow me to actually write the article.

What did I miss there?

Also (I'm new to VB) why are there a whole other set of "add ons" fo this? Has development on this stopped and moved to someone else?

SoloX · #**849** 01-06-2005, 01:08 AM

I have installed the latest security patch as given out.
I have set the moderate articles on, If I go to the Article category, the article does not appear, but it does appear in the categories list under the 'latest article' column and people can view it (without us approving it first).

How can I make so that the un-approved articles dont appear at all anywhere in the system?

Thanks

Paul M · #**850** 01-06-2005, 01:24 AM

Quote:

Originally Posted by SoloX

I have installed the latest security patch as given out.
I have set the moderate articles on, If I go to the Article category, the article does not appear, but it does appear in the categories list under the 'latest article' column and people can view it (without us approving it first).

How can I make so that the un-approved articles dont appear at all anywhere in the system?

Thanks

The fact people can view unapproved articles is another bug I fixed when I first installed and tested our version. The fact that they appear in the list at all is a more complicated problem to fix and I didn't bother fixing for us - since people could no longer view the article anyway.

I'm off to bed now so I'll dig the first fix out for you tomorrow.

dina · #**851** 01-06-2005, 01:38 PM

Something weird is going on with this mod. I just upgraded to 3.0.4 and just reinstalled the mod in the files and it worked fine. Then suddently today I got this e-mail:

Quote:

Database error in vBulletin 3.0.4:

Invalid SQL:
SELECT * FROM articlepost
WHERE type=2 AND articleid=5 AND valid=1
ORDER BY postdateline ASC
LIMIT 0,

mysql error: You have an error in your SQL syntax. Check the manual that corresponds to your MySQL server version for the right syntax to use near '' at line 4

I try entering the articles and get the same error again. Before this happened I could view every article and even see the "preview" of one of the articles on top of the page.
Now I can't even view the settings for the articles in vBulletin Options (can view the other settings in admincp though).

I've tried running the install script again, but of course it fails when it tries to add new tables, because the tables are already there.

I don't want to remove the tables from the database and reinstall completely, as I'll lose over a hundred articles.

And yes, I have checked the file changes at least 10 times.

X vBulletin 3.8.12 by vBS Debug Information
Page Generation 0.08199 seconds Memory Usage 2,349KB Queries Executed 25 (?)
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 (7)bbcode_php (3)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 (3)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_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!