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.

[dnoyeb2002]

Great Mod!

Just one question, if someone would be willing to help me. . .

I am looking to order the articles in order of title, as opposed to id # . . . could someone possibly help me figure out where I would need the ORDER BY title ASC line to go please . . . thanks!

Thanks In Advance

[JustAskJulie]

Originally Posted by Qwest

Anyone figured out how to get this hack to allow adsense code in the articles?

I want to allow my users to ad adsense ads to the article aor have it auto submit ads in the article body.

While I don't know if you could add the code into the actual article body (ie. allow the user who submitted the article to add the code), you could add the code to the template and it would show up on every article.

For that matter, what type of code does Adsense use? is it not just HTML? If so, then you should be able to just allow HTML in the articles and then users could submit the code if they chose to.

[bendigo-tech]

Originally Posted by JustAskJulie

For that matter, what type of code does Adsense use? is it not just HTML? If so, then you should be able to just allow HTML in the articles and then users could submit the code if they chose to.

Seems to me like you have just answered your own question.

[smdani]

Good hack, but it is very buggy and standalone is not a good idea. I unistall and wait for next release. THANKS A LOT!!!!

Some Bugs found:
- If you [ Feature This Article ] you can not undo.
- When I attach an image I can only see a X where image must be loaded
Thumbnails work fine on my forum. The article thumbnails are not working.
- I have just see at your articles site that someone hacked your articles system, maybe there is a way of editing articles without permissions
- Last user who made a comment isnt linked to his profile (linkvalue is empty
- Questionmarks wont be parsed (it shows the HTML-Code instead)
- When editing an article, if you preview the changes and then save it, it saves the original. When you click preview, it enters the original text in the textbox.

Some suggestions for the future
- set permissions on each category
- vbulletin Search system index articles - Integrated with vBulletin Search
- Guests can write comments
- Printable Version for Articles
- New Articles Shown in Bold
- Ability to Move Articles to Different Categories
- Listing in Who's Online
* Viewing Article
* Article Title (with link to specific article)
- External Javascript feed to show last articles anywhere on the website
- A "Byline" field to be displayed next to the article. Too often I will upload an article but it was actually written by somebody else.
- integrate this into the forum itself, so that articles automatically become threads and comments are replies

[intrigue]

hey i cant seem to find the place where to post new articles and also is the featured article hack a seperate thing?
.matt

[Pitman]

Originally Posted by smdani

- I have just see at your articles site that someone hacked your articles system, maybe there is a way of editing articles without permissions

In article.php, Search For:

	$article = $DB_site->query_first("
	SELECT article.*, articlepost.postbody AS content, article.articlehash FROM " . TABLE_PREFIX . "article AS article
	INNER JOIN " . TABLE_PREFIX . "articlepost AS articlepost ON(articlepost.postid = article.firstpostid)
	WHERE article.articleid=$articleid");

Just after it, add this:

	if ($article['articleuserid'] !== $bbuserinfo['userid'])
	{
		if (!($permissions['articlepermissions'] & CANEDOTHART))
		{
			print_no_permission();
		}
	}
	else
	{
		if (!($permissions['articlepermissions'] & CANEDOWNART))
		{
			print_no_permission();
		}
	}

That should fix it

[SilentK]

I am having some trouble getting this to work.

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

What am I missing? I thought I got everything.

[smdani]

Thnaks a lot Pitman! Now works like a charm.
Do you know how can i unfeatured and article, and how can I let guests write comments?
Really thanks!!!
smdani

[Pitman]

Originally Posted by smdani

Thnaks a lot Pitman! Now works like a charm.
Do you know how can i unfeatured and article, and how can I let guests write comments?
Really thanks!!!
smdani

Well, the only way to unfeature an article is to feature another one. If you don't want any article to be featured, ever, you can just remove the HTML from the templates.

As for the guests to be able to post comments, there are permissions for that, but they don't work. I never noticed that, but if I get time to figure it out, I'll let you know.

[Pitman]

It was only showing the comment parts of an article to users with a userid and then taking permissions into account. This should fix it:

In the template article_display, Search for AND Remove:

<if condition="$bbuserinfo['userid'] != 0">

Search for:

<div class="vbmenu_popup" id="articletools_menu" style="display:none">

Above it, you should see:

</if></if>

Replace that with:

</if>

Then save the template