v3 Articles 1.0.1 - [vB 3.0.1]

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.

[Guy G]

i wanna get the Articles and comments to list in the Quick stats at the admin cp.
for example:

New Posts Today 56    New Threads Today 32     Unique Members Today 12

add a line under that to add

New Articles Today xx    New Comments Today xx     Articls awating Approvel XX

Also, has anyone managed to fix the article count?
i made a test article, and i cant delete it in the usual way... so i went and deleted it through PhpMyAdmin, but it still shows under the category i made it although when i press its not even there...

And another thing is... if i post GIF animations on articles they dont 'animate', they are frozen... only when pressing it they show up.

buggy system...

[pingme]

I am getting following error

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT * FROM vb3_article 

WHERE categoryid=1 AND (articleuserid=1 OR open IN (0,1)) ORDER BY dateline DESC 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 2

mysql error number: 1064

Please help, I need article system on my site

[dookie]

I get the same error.
Doesn´t work in 3.0.3. *uninstall*

[Guy G]

im running it on vb 3.0.3.

there is one really annoying bug....
on the articles it shows wrong count on them if i had test articles.
if i did a test article\comment and than deleted it from the database it will still show that there is a nigger count of articles. same for comments.
annoying indeed, anyone managed 2 fix it?

[pingme]

Originally Posted by dookie

I get the same error.
Doesn?t work in 3.0.3. *uninstall*

I found few people using it on this thread. dont know how they are not facing any issues

[Paul M]

Originally Posted by dookie

I get the same error.
Doesn?t work in 3.0.3. *uninstall*

Yes it does.

[dookie]

I forgot to save the vbulletin options. Works.

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

[Paul M]

Have you added $articlecontent in to your forumhome template ?

[deathemperor]

Originally Posted by dookie

I forgot to save the vbulletin options. Works.

and someone still want to say that this has something like a very BIGGY issue.

they should have known that John asked them to save the V3article options 1st before it CAN work...