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 tmhall

Article column, subcat index.

Try overwriting the article_level2_post template with this:

<tr align="center">
	<td class="alt2" width="1%">
<if condition="!empty($category['statusicon'])">
<img src="$stylevar[imgdir_statusicon]/forum_$category[statusicon].gif" alt="" border="0" />
</if>
</td>
	<td class="alt1Active" align="$stylevar[left]" id="f$category[categoryid]">
		<div>
			<a href="article.php?$session[sessionurl]c=$category[categoryid]"><strong>$category[title]</strong></a>
		</div>
		<div class="smallfont">$category[description]</div>
<if condition="$category[subforums]"><div class="smallfont" style="margin-top:$stylevar[cellpadding]px"><strong>$vbphrase[subforums]</strong>: $category[subforums]</div></if>
	</td>
	<td class="alt2" nowrap="nowrap">$category[articlecount]</td>
	<td class="alt1" nowrap>$lastcommentby</td>
	<td class="alt2" nowrap>$lastarticleby</td>
</tr>
$childcategorybits

[DaveLogic]

Originally Posted by Breaker

fixed permissions problems (overriding of permissions appeared in wrong groups)

but now i get a database error when trying to view a category

I have the same permission problem...How exactly did you remedy this as I can find no permission options in AdminCP??

[John]

Originally Posted by DaveLogic

I have the same permission problem...How exactly did you remedy this as I can find no permission options in AdminCP??

I presume you've followed the instructions, and saved usergroup settings and vBulletin options?

[DaveLogic]

Originally Posted by John

I presume you've followed the instructions, and saved usergroup settings and vBulletin options?

My apologies ...I hadn't but like the person before me, after completing that part I now receive this error:

Database error in vBulletin 3.0.1:

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

[zetetic]

Originally Posted by John

Try overwriting the article_level2_post template with this:

Oops, I think it was my fault. I'm not using the default names for the post icons.

Sorry.

[John]

Originally Posted by DaveLogic

My apologies ...I hadn't but like the person before me, after completing that part I now receive this error:

Database error in vBulletin 3.0.1:

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

Which file is the error coming from? (I.e. the name of the file mentioned in the query error.)

[DaveLogic]

Originally Posted by John

Which file is the error coming from? (I.e. the name of the file mentioned in the query error.)

Date: Monday 07th of June 2004 01:57:31 PM
Script: http://localhost/forums/article.php?c=2
Referer: http://localhost/forums/article.php
Username: Dave_Logic
IP Address: 127.0.0.1

[John]

Originally Posted by DaveLogic

Date: Monday 07th of June 2004 01:57:31 PM
Script: http://localhost/forums/article.php?c=2
Referer: http://localhost/forums/article.php
Username: Dave_Logic
IP Address: 127.0.0.1

I actually had the exact same error during testing, and then found that I had to save vBulletin Options to fix the problem.

But of course that can't be it, because you followed the instructions - right?

[DaveLogic]

Originally Posted by John

I actually had the exact same error during testing, and then found that I had to save vBulletin Options to fix the problem.

But of course that can't be it, because you followed the instructions - right?

Ok...I admit..missed that bit out aswell..Everything seems to be working fine now..thanks for your time...the install button has been clicked..

[Okiewan]

Originally Posted by John

vBulletin version?

3.01