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.

[Paul M]

Originally Posted by khaleel

I get

Database error in vBulletin 3.0.6:

Invalid SQL: SELECT * FROM vb3_article
WHERE categoryid=2 AND (articleuserid=671 OR open=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

Date: Wednesday 04th of May 2005 11:31:21 AM
Script: http://www.death-eater.net/forum/article.php?c=2
Referer: http://www.death-eater.net/forum/article.php
Username: kaz
IP Address: 217.43.232.153

Read the instructions properly and follow them.

(See post #957 in this topic).

[kenwen]

And when i try to set the permissions in admincp for guests being able to view comments the page does a weird scroll jump to another segment and leaves the option unselected? :ermm:

Any advice? Cheers

[CC-Master]

Sounds interessting, but the demo site seems to be down. Are there any other demo sites available or an alternative managing articles with websites running vb3?

[Paul M]

Well we aren't a demo site - but you are welcome to look at our articles section.

[JustAskJulie]

Originally Posted by TheMusicMan

Can I ask what this means as I had to modify the code to allow Moderators to be able to Moderate Articles and any comments submitted about them...? Did I get it wrong?

I thought only Admins could moderate submitted articles in the stock vBarticles code.

What about a Super Mod with Admin privs? It seems that the articles bit shows up in their admin panel but when they try to moderate are told they don't have permission. How can I get around this without making them a full out moderator?

[RCSwap]

I have recently instelled this hack and it's not bad. The only problem I have is that the layout is a little cluttered (at least on my board it is). Anyways, which file and where in the file can I make the following changes:

1. Remove the "Post a Comment section". I don't need my members posting any comments on product reviews or how-to sections.

2. Remove the "Media" box that is around the images and then move the images so that they are above the "Rate this article" part.

Other then that the hack looks good. It's nice and simple for what is need and was a breeze to instal.

[FleaBag]

This may be old news but I just took a look through the database fields and found this in almost every article...

I don't put enough security on my site, so i get hacked like this.

[acid]

Thanks acid! Lol...

[Paul M]

That's why a security fix was released (by me) in late December.

[FleaBag]

Aye I know dude, I was just never too sure what had happened originally. Not knocking the hack, please don't think I was.

[Paul M]

Originally Posted by FleaBag

Aye I know dude, I was just never too sure what had happened originally. Not knocking the hack, please don't think I was.

Makes no odds to me, it's not my hack - I just released an update that I had applied to my version. I was just making sure you were aware of it.