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.

[Qwest]

Originally Posted by Zorobz

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT articlepost.*, article.categoryid FROM vb3_articlepost
									  INNER JOIN vb3_article AS article ON (article.articleid = articlepost.articleid)
									  WHERE articlepost.postid=17
mysql error: Unknown table 'articlepost'

mysql error number: 1051

getting error when trying to edit a comment... any ideas pleasE?

same error here

[TCB]

Of course John doesn't owe us anything, but it's a real shame that he hasn't at least updated the script for 3.0.3 usage

[Paul M]

Originally Posted by Zorobz

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT articlepost.*, article.categoryid FROM vb3_articlepost
									  INNER JOIN vb3_article AS article ON (article.articleid = articlepost.articleid)
									  WHERE articlepost.postid=17
mysql error: Unknown table 'articlepost'

mysql error number: 1051

getting error when trying to edit a comment... any ideas pleasE?

Originally Posted by Qwest

same error here

It's an error in the script. Find the following code in the article.php (line 680 ish)

PHP Code:

    // get comment
    $comment = $DB_site->query_first("SELECT articlepost.*, article.categoryid FROM " . TABLE_PREFIX . "articlepost
                                      INNER JOIN " . TABLE_PREFIX . "article AS article ON (article.articleid = articlepost.articleid)
                                      WHERE articlepost.postid=$id"); 


and replace it with this ;

PHP Code:

    // get comment
    $comment = $DB_site->query_first("SELECT articlepost.*, article.categoryid FROM " . TABLE_PREFIX . "articlepost as articlepost
                                      INNER JOIN " . TABLE_PREFIX . "article AS article ON (article.articleid = articlepost.articleid)
                                      WHERE articlepost.postid=$id"); 


[deathemperor]

Originally Posted by KTBleeding

Awesome!

One problem though. I can't find this at all:

FIND IN article_display:
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
<if condition="(($article['articleuserid'] == $bbuserinfo['userid']) AND ($permissions['articlepermissions'] & CANEDOWNART)) OR (($article['articleuserid'] != $bbuserinfo['userid']) AND ($permissions['articlepermissions'] & CANEDOTHART))">
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

This is the closest one to it I could find:

<if condition="(($article['articleuserid'] == $bbuserinfo['userid']) AND ($permissions['articlepermissions'] & CANEDOWNART)) OR ($permissions['articlepermissions'] & CANEDOTHART)

Is that the one you're talking about?

PS: Thanks for updating us with a more secure script.

oh sorry, that was my bad (find and replace is opposite) since you know I was very furious knowing John could do such a careless job like this. attachment updated.

PHP Code:

FIND IN article_display:
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
<if condition="(($article['articleuserid'] == $bbuserinfo['userid']) AND ($permissions['articlepermissions'] & CANEDOWNART)) OR ($permissions['articlepermissions'] & CANEDOTHART)">
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@

REPLACE WITH:
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@
<if condition="(($article['articleuserid'] == $bbuserinfo['userid']) AND ($permissions['articlepermissions'] & CANEDOWNART)) OR (($article['articleuserid'] != $bbuserinfo['userid']) AND ($permissions['articlepermissions'] & CANEDOTHART))">
@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@@ 


@TCB: No, John didn't even make it work correctly with vb3 not to mention vb3.0.3

[KTBleeding]

There we go. All fixed.
Once again, thanks for these updates.

[Guy G]

ok this is annoying... nothing is working well.
can anyone be kind enough and upload a correct article.php and other files that needed editing? it would be alot botter i must say...

Parse error: parse error, unexpected $ in public_html/forum/article.php on line 1300

thats the last line in there.... no $ there as well

[lanc3lot]

Has anyone find a way, that u can make the whole script can upload more than one image per time?
Like vb does, with multiple upload boxes

[KTBleeding]

Originally Posted by lanc3lot

Has anyone find a way, that u can make the whole script can upload more than one image per time?
Like vb does, with multiple upload boxes

The script does this by default.

[deathemperor]

Originally Posted by Zorobz

ok this is annoying... nothing is working well.
can anyone be kind enough and upload a correct article.php and other files that needed editing? it would be alot botter i must say...

Vb.org doesn't allow people to upload php source file that is edited and it's wise to know what others are telling you what to do instead of doing it thoughtlessly.

[PAINTBALLM]

I have this installed and running the way I want it at http://www.pbmessage.com for the "reviews" link. Is there any way of indexing all articles in search engines. Currently, the link is not search engine friendly.