vbArticles v0.4 -- For your repository of Articles/Tutorials/FAQs etc.

UPDATES
version 0.4 is out

- Now allows for basic VBCODE input.
- Fixed somemore bugs.


Background
Required a section on my site to display articles/tutorials
No such hack in the Hacks Database
Decided to try my hand at it

ACKNOWLEDGEMENTS
This hack uses a lot of code from Arunan Sridharan's vB Links Directory v2.0
I use that hack too and was inspired to code something around that
A big thank-you must go out to him for coding the Links Directory in the first place (I merely modified much of the code to suit my needs for this hack)

Appreciation also goes out to Kars10 for aiding me in this hack
He coded the portion in version 0.3 on number of articles count as well as article hits count
He also suggested several template changes which have been incoporated into version 0.3
A great big special shout out to TheComputerGuy, 97cobracpe, dontpanic for stamping out the bugs with your fixes. Thanks guys


WHATS IT DO ?
This hack allows you to have a database of articles/tutorials etc on your site/forums.

FEATURES

AdminCP
Installer script

Admin options

View Categories
Edit Categories
Add Categories ( category name, category icon, category order, category description )
Delete Categories
Add new article ( title, description, author, date, content )
Edit article
Delete article
View ALL articles in database
Option in vB options to turn validation of articles on/off
Fully template based as to how you wish to display the articles,categories and main article home page.
Addition of articles accepts basic VBcodes

Member options

View Categories
Browse Categories
View articles
Submit new article
Submission of articles accepts basic VBcodes


INSTALLATION & UPGRADING
This Hack should work on ALL 2.2.x versions and v2.3.0
Please read the install_readme.txt file in the package for fresh installation instructions
IMPT: If you installed a previous version pls read the upgrade_readme.txt file carefully for upgrade instructions

HACK DOWNLOAD

Version 0.4 of this hack can be downloaded here

ADD-ONS
i) Add-on for vbHome
ii) Add-on for ForumHome
iii) Add-on to enable only registered members to be able to view the article section


DEMO SITES
http://www.runaked.com/forums/articles.php ( running v0.4 ) - TheComputerGuy's site

http://www.mcseworld.com/forums/infocenter.php ( running v0.3 ) - dontpanic's site


Feel free to submit your sites if u installed this hack so it can be listed as another live demo site

SUPPORT
I cannot promise any support on this as i am pretty new to this but I will try my best.
If you are using this hack , pls click the INSTALL button
to be kept in the loop of any bug reports, add-ons and hack version updates.

Thanks everyone

[cindyd]

OK, I got it fixed.

[cindyd]

OK, I went to edit an article and got this error message:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /public_html/forum/admin/vbArticlesadmin.php on line 234

I already did the changes the dontpanic had listed on page previous pages.

if ($action=="editarticle") {
$sql = "SELECT * FROM vbArticles_content WHERE artid=$artid";
$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);
$artid=$myrow["artid"];
$title=$myrow["title"];
$byline=$myrow["byline"]; ----> this is line 234
$author=$myrow["author"];
$date=$myrow["date"];
$content=$myrow["content"];

[cindyd]

Does anyone know how to fix the above error?

[cindyd]

I really like the idea behind this hack, but I cannot edit or delete anything.

Also, I would like to make this area of my forums accessible to paid members only, how would that be accomplished?

Is this hack still being worked on?

If so, could a link be added in the vew article area, there is no way to get back to the Article home page as it is right now.

[cinq]

cindy, i visited your site and can access the articles section alright.

You have no link in view article to get back to the Main Articles Home page is because you editted your templates to take it out.
Please check the viewarticle template again.
It should have navi at the top just below your vb header.

Also do you mean in your admincp , you are unable to delete and edit articles ? This shouldnt be the case if you installed correctly.

Finally, for your paid members, did you place them in a special usergroup? If so, you can allow viewing access only to them by simple change of code in articles.php ( pretty much similiar to the code changes highlighted previously in this thread )

[cindyd]

Yesterday at 10:24 PM cinq said this in Post #165

You have no link in view article to get back to the Main Articles Home page is because you editted your templates to take it out.
Please check the viewarticle template again.
It should have navi at the top just below your vb header.

OK, I will recheck that.....I see what I deleted and I would like to put the links at the bottom of the page, like in the Links hack. I guess I can figure that out from the Links hack.

Also do you mean in your admincp , you are unable to delete and edit articles ? This shouldnt be the case if you installed correctly.

Yes, see my error message a couple of posts above. You must have seen all the duplicate articles when you went to the site, I can't edit or delete in the Amin CP.

Finally, for your paid members, did you place them in a special usergroup? If so, you can allow viewing access only to them by simple change of code in articles.php ( pretty much similiar to the code changes highlighted previously in this thread ) [/B]

Yes, I found that earlier tonight, thanks.

So all I need is to get the editing and deleting fixed and I'll be very happy!

Here is the error from when I try to edit or delete:
OK, I went to edit an article and got this error message:

Warning: mysql_fetch_array(): supplied argument is not a valid MySQL result resource in /public_html/forum/admin/vbArticlesadmin.php on line 234




I already did the changes the dontpanic had listed on page previous pages.

if ($action=="editarticle") {
$sql = "SELECT * FROM vbArticles_content WHERE artid=$artid";
$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);
$artid=$myrow["artid"];
$title=$myrow["title"];
$byline=$myrow["byline"]; ----> this is line 234
$author=$myrow["author"];
$date=$myrow["date"];
$content=$myrow["content"];

[cinq]

Today at 01:06 PM cindyd said this in Post #166

PHP Code:


if ($action=="editarticle") {
$sql = "SELECT * FROM vbArticles_content WHERE artid=$artid";
$result = mysql_query($sql);
$myrow = mysql_fetch_array($result);
$artid=$myrow["artid"];
$title=$myrow["title"];
$byline=$myrow["byline"]; ----> this is line 234
$author=$myrow["author"];
$date=$myrow["date"];
$content=$myrow["content"]; 


Doesnt look like any error there in line 234. Hmm,deletion never had any problems, while an editting problem/s got nicked previously.
Any others facing the same problem ?
Jus went thru the code, seems in order ( then again, i might be missing something , pretty new to this too )

[cindyd]

Cinq: I have gone over the installation again and that error remains. When I delete an article, I am told in the CP that it has been successful, but it really doesn't delete anything.

When I try to edit I get that error message and all the input boxes are blank.

[Solice]

First off, thank you for making this wonderful hack cinq... i was wondering though... is there a way to setup permissions for posting articles? so that I could have some categories for users to post in and others for staff...

[cinq]

Solice, that's currently not planned and may not be too.
Do not have much free time on my hands right now