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.

[zetetic]

There seems to be a 5000 character limit on articles. Does anyone know if this is adjustable?

[flstreetscene]

I get this error during installation;

Database error in vBulletin 3.0.3:

Invalid SQL: INSERT INTO phrase (phraseid, languageid, varname, text, phrasetypeid) VALUES (NULL, '0', 'setting_commentsperpage_title', 'Comments Per Page', '5000')
mysql error: Duplicate entry 'setting_commentsperpage_title-0-5000' for key 2

mysql error number: 1062

What exactly do I need to delete / drop from my database for a clean installation?

[hitmanuk2k]

i have had a go at doing this myself but couldnt find what i had to remove in article.php. basically if you go to http://forum.pesinsight.com/article.php?a=1.... i want to get rid of the catagory background image (in the row with the article title)... because as you can see it messes it up. but i dont want to have to change my forum style because its fine elsewhere. so if i just wanted to remove it from the articles? how would i? i managed to get rid of the avatar myself but couldnt do the bg.

[hitmanuk2k]

Originally Posted by pjdaley

same here

i also would like a hack to show the latest articles on non-vb page, maybe the last 10 (like you can do with the latest threads hack on non-vb page). i would be willing to pay a small amount if someone could do this.

[.:.NetStartz.:.]

Same problem here...

Originally Posted by JimpsEd

Database error in vBulletin 3.0.3:

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

Date: Friday 23rd of July 2004 06:34:37 PM
Script: http://forum.ugamer.net/article.php?c=2
Referer: http://forum.ugamer.net/article.php
Username: Sardukar
IP Address: 81.6.241.167


new install

[Brinkley]

Hello,

I´m waiting for a Bugfixed Version for vB 3.0.3 , Hack removed

To many Probs :disappointed: :disappointed: :disappointed:

Greets

[Henry-RS]

Originally Posted by Brinkley

Hello,

I?m waiting for a Bugfixed Version for vB 3.0.3 , Hack removed

To many Probs :disappointed: :disappointed: :disappointed:

Greets

Ditto.

[Lonny]

when I go to forum/article.php

I get a blank page

why is that?

[Lonny]

oh yea I'm running 3.0.0

any chances that the problem is there? what should I do now?

[MindTrix]

make sure the templates have been added to each style