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.

[tteal]

I'm getting that same error now after upgrading to VBulletin 3.0.3 ... this was working fine in 3.0.1

Any help would be great!

Thanks!

Originally Posted by weirdpixels

Just installed on vb 3.03 but i am getting the following mysql error:

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

Date: Wednesday 04th of August 2004 01:24:03 PM
Script: http://www.weirdpixels.co.uk/forum/article.php?c=2
Referer: http://www.weirdpixels.co.uk/forum/article.php

This happens when i click on a Category or sub Category
any ideas of what could be causing this?

[bing11]

how search the artides?

[Razgo]

i also have a can't edit problem:

Database error in vBulletin 3.0.3:

Invalid SQL: SELECT articlepost.*, article.categoryid FROM vb3_articlepost
									  INNER JOIN vb3_article AS article ON (article.articleid = articlepost.articleid)
									  WHERE articlepost.postid=2
mysql error: Unknown table 'articlepost'

mysql error number: 1051

Date: Thursday 12th of August 2004 02:44:33 AM
Script: http://www.sensory-fusion.com/forum/...itcomment&id=2
Referer: http://www.sensory-fusion.com/forum/article.php?a=1
Username: Razgo
IP Address: 210.49.43.36

[Razgo]

ok i found my answer in a SQL error in the script? back in post 114 and this worked for me.

just have to figure out why thumbnails don't show as an image. thumbnails on the forum work fine.

https://vborg.vbsupport.ru/showpost....&postcount=114

[JustAskJulie]

Originally Posted by bing11

how search the artides?

I've been wondering that too.

Is this hack still being supported?

[j_86]

It isnt being supported.. the author also ignores me on MSN.

[Pitman]

Originally Posted by bing11

how search the artides?

Insert this HTML anywhere in a template within the default forums directory

	<b>Search Articles:</b><br>
	<form action="article.php" method="get">
		<input type="hidden" name="do" value="search" />
		<input type="text" class="bginput" name="keyword" size="20" />$gobutton
	</form>

To use it outside of the forums directory, hard code the bold text above.

[TTG]

How do you delete an individual article ?

[JustAskJulie]

I've just run into another problem. WHen you click the username of the person who posted the article. Instead of being taken to THEIR profile, I'm being taken to my own.

[zetetic]

Originally Posted by JustAskJulie

I've just run into another problem. WHen you click the username of the person who posted the article. Instead of being taken to THEIR profile, I'm being taken to my own.

Seems to be an issue on your end, JaJ. That doesn't happen on my site...