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.

[Ghostsuit]

Never know could be in the new version thats soon to be released, just have to wait and see

[cosmin]

--

post reference 1: https://vborg.vbsupport.ru/showpost....&postcount=304

post reference 2: https://vborg.vbsupport.ru/showpost....&postcount=313

--

i am having this same problem. i went through the install.php file and everythign was fine til i clicked on the default 'Main Sub-Category' link from /forumroot/article.php .... then it took me to the error message:

Database error in vBulletin 3.0.3:

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

...i uninstalled v3articles, and manually deleted all additions to the DB, and REINSTALLED, yet still the same issue

... any help?

[blueuniverse]

It would probs be best to wait for the new version.

[Ghostsuit]

Originally Posted by blueuniverse

It would probs be best to wait for the new version.

Thats what I'm doing...though it's so tempting

[cosmin]

--
i see.

i noticed at their website the new v3Articles forums... but it didnt give me access. wasnt sure if it is a paid hack. anyway. this thread is subscribed, will check back soon!

thanks for your input.

[Ted S]

I've spoken with John and while I am confident that vba will be a GREAT hack don't expect a ton of feature additions (although I'd be there are a few). Just plan for a solid, well working hack which is exactly what most of us need. Bells and whissles come down the road and for a free system I'm already amazed...

[Neutral Singh]

Thanks for this great mod... installation was with out even a single hitch but then I am having following problem in vBulletin 3.0.3 while runing article.php. Is this hack compatible with this version. ? Thanks in advance.

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT * FROM article
WHERE categoryid=2 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

[yowen]

I have tried to create a word count for my articles, a word count that would show up under the rating, but I cant get it to work. Do any of you guys know of a way to get this done? I tried the search but couldnt find a way.

[SamirDarji]

Originally Posted by cosmin

--

post reference 1: https://vborg.vbsupport.ru/showpost....&postcount=304

post reference 2: https://vborg.vbsupport.ru/showpost....&postcount=313

--

i am having this same problem. i went through the install.php file and everythign was fine til i clicked on the default 'Main Sub-Category' link from /forumroot/article.php .... then it took me to the error message:

Database error in vBulletin 3.0.3:

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

...i uninstalled v3articles, and manually deleted all additions to the DB, and REINSTALLED, yet still the same issue

... any help?

Strange. I'm running it on 3.0.3 and the installer worked fine. What version of MySQL are you running?

[Mickie D]

i cant seem to find the 3.0.3 version has it been released yet ?

and is there a fix to the no image's if the new vb articles ahs not been released yet ?

Regards
Mick