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.

[John]

Originally Posted by Randall Rath

I use the table prefix option with my vBulletin installation.
I mention that because while the admincp's article.php file uses TABLE_PREFIX for the new table queries, the installer doesn't, and the forum's article.php file uses a mix of both.
You can imagine what the end result is.

Expect a full bug fix tomorrow.

[Randall Rath]

Originally Posted by John

Expect a full bug fix tomorrow.

No rush for me, I'm fixing it as I go, I just thought it might save you some headaches if I told you about it early on.

[corsacrazy]

one small bug found, when in the edit article page the links to the already attached images point to attachment.php rather than article one there fore it results in an invalid attachment id message error, also how do i edit captions for pics ? or is that in next version?

[Synicide]

Awesome! This will be a great compliment my forum's new magazine.

[undrgrndgam3r]

Database error in vBulletin 3.0.0:

Invalid SQL: SELECT * FROM article
WHERE categoryid=12 AND (articleuserid=141 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

Date: Monday 07th of June 2004 07:41:55 PM
Script: http://govgaming.com/article.php?c=12
Referer:
Username: Gamer4Life
IP Address: 205.188.116.210

???? how i fix this

[WebMasterAJ]

First and foremost, thank you for releasing this AWESOME hack!

Anyway, just curious, is it possible to have a different style for the article hack? That would be awesome! Please let me know...

Thank you for your time and energy...

Sincerely,
Andrew Tatum

[Randall Rath]

Hey John, on line 767,

SELECT article.*, articlepost.postbody AS content, article.articlehash FROM article

*ignoring the table prefix thing*
Did you mean,

SELECT article.*, articlepost.postbody AS content, article.articlehash FROM article AS article

[Mone']

Great hack john !

[zetetic]

Thanks again for all your hard work on this great hack, John. A couple other things:

My custom BBcode for float doesn't seem to work and images don't show up in preview.

[John]

Originally Posted by undrgrndgam3r

Database error in vBulletin 3.0.0:

Invalid SQL: SELECT * FROM article
WHERE categoryid=12 AND (articleuserid=141 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

Date: Monday 07th of June 2004 07:41:55 PM
Script: http://govgaming.com/article.php?c=12
Referer:
Username: Gamer4Life
IP Address: 205.188.116.210

???? how i fix this

Try following the instructions properly.