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.

[Zacharicus]

Love it, BUT, IMG tag doesn't work although it's turned on in the permissions of each category.

[Spinball]

v3articles.com and v3arcade are gone, this hack isn't supported particularly well here by the author and v3articles is supposed to be better.
Time to uninstall, I think.

[j_86]

v3Articles has been unsupported for months and months, it has only recently relied on small updates from community members here and there to fix security flaws etc.

[Paul M]

Originally Posted by Spinball

v3articles.com and v3arcade are gone, this hack isn't supported particularly well here by the author and v3articles is supposed to be better.
Time to uninstall, I think.

If someone has no articles system installed then I would agree that this is probably not the one to pick anymore, but if you already have it installed and working then why remove it just for the sake of it, aren't you just creating yourself work transferring to another system (or losing all your articles) ?

I am keeping an eye on the other article systems, but only one currently allows user submissions (like this one) - and at the moment, this system does the job we want it to do, so I see no reason to change.

[Spinball]

Originally Posted by Paul M

I see no reason to change.

I have been frustrated with the inability to search the Articles using the standard search system. And administrating them has been unweidly.
I've picked the Geek system since it allows you to import the v3articles.
And it sensibly stores the articles in the main database tables.
A no brainer, ten, really, considering our position.
Thanks, guys.

[steadicamop]

I've managed to install this no problems, but when I try to access the category, I get this database error:

Database error in vBulletin 3.0.5:

Invalid SQL: SELECT * FROM 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

Date: Tuesday 19th of April 2005 08:45:19 PM
Script: http://www.steadiforum.com/article.php?c=1
Referer: http://www.steadiforum.com/article.php?
Username: Jason
IP Address: 82.43.xxx.xx

Anyone have any ideas?

I tried going to www.v3articles.com but it doesn't resolve.

Thanx, looks like a wonderful hack, just what I need, just need it to work now

Jason

[Paul M]

Originally Posted by JasonWilliams

I've managed to install this no problems, but when I try to access the category, I get this database error:

Database error in vBulletin 3.0.5:

Invalid SQL: SELECT * FROM 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

Date: Tuesday 19th of April 2005 08:45:19 PM
Script: http://www.steadiforum.com/article.php?c=1
Referer: http://www.steadiforum.com/article.php?
Username: Jason
IP Address: 82.43.xxx.xx

Anyone have any ideas?

At a guess, you did not follow the bit of the instructions that tell you to go into the v3article options - and save them.

[steadicamop]

That might be the issue .. I've uninstalled it for the time being, will reinstall it and see if that's the issue ... thanx!

Jason

[RichieBoy67]

I have tried all of the article systems and I believe this one, by far is the most stable and the one with the fewest install problems....

This one is also actually an article system with an article.php page.... Not just basically another forum like another article hack ( no offence intended ) ...


If you guys are having problems just go in and manually edit your database and reinstall or what ever....

PHP Code:

MySQL server version for the right syntax to use near '' at line 2 


That right there tells you that you made a mystake in your editing.......

Here is a tip and I know there are many here smarter than me but this just might help you... When editing your templates... First thing- Create a folder and save all of them in it... Then if you have to start over you can!!

Create another folder - A work folder for the templates you are going to edit. Use a good program like WYNSYNTAX . If you have to remove some of your edits you can just click undo...... Worst case you still have the back up folder.... just start over...

Hope I helped in some small way........ I think this is a great hack and I thank John for it....

[steadicamop]

Originally Posted by Paul M

At a guess, you did not follow the bit of the instructions that tell you to go into the v3article options - and save them.

Hehe yeah you're right, sorry my goof for not reading the instructions properly ... it works fine now

Looking forward to using this excellent hack .. looks wonderful