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.

[trackpads]

Is it possible to run two article systems on the same board?

[AlfonsoC]

Hi....

Need a complete description of tables used by v3 articles 1.0.1... seems that something went wrong in the installation and some tables weren't created okay. So I cannot uninstall or install another time.

So, anyone can put the layout of the tables associated with v3 articles, please.

[Host Directory]

I couldn't wait for the new version - so i installed and everything works fine. Great hack but can anyone tell me what code i might need to change to do the following?

I would like to be able to place announcements in the articles section so that i request my users to write the articles and offer them link backs, ect.

I would also like to sticky some articles ( like sticky thread ) that are popular.

Anyone know how to do that? I think it would make this hack complete.

[MissKalunji]

anyone would be able to write a script for me? to show up the article in a non vb page

if yes please e-mail me : jamaican_dymes69@hotmail.com
Or send me a pm

I willing to pay!! i need it :nervous:


Thank u ppl

[Host Directory]

Yeah i wanted to be able to add it to a non vbpage also. They could put a option for admins to send the article to a non vbpage but it would have to be able to write the article into a menu system on another page. So it created a new link on a non vbpage - leading to the article on a non vb page.

I guess that would take a bit of coding.

[AlfonsoC]

After various days of battling with this hack. After trying to search more information about the table schema used by it, after sending several e-mails to the creator, after posting a request for information here (read my previous post to this) and today asking another time support for the creator (and willing to pay for this).

Got extremely p*ssed with this rogue hack and decided to get rid of it COMPLETELY of my system until a future version who solves the fails and cleans everything and deficiencies.

To get rid of v3 from your database you need to follow this simple steps:

0. MAKE A BACKUP OF YOUR DB! It's vital to recover it if anything goes wrong. This steps are done by me, but everything can fail and send your Forums DB to h*ll... Give yourself a second chance to get completely cleaned.

1. I assume that you tried to uninstall it via the install.php script provided by the programmer of the hack. If not, do it and follow next steps to get a completely clean system another time.

2. Connect to your database (check with your provider if your database is on a remote server), this is my case, so you need to issue from a shell of your account this command: mysql -h databasehost -D databasename -p -u yourusername

3. Issue this command on the mysql client: drop table articles ; repeat this command (drop table) with the next tables: articleattachment, articlecategory, articlepost, articlerating. This deletes phisically those tables from your database, note that at the end of each drop table <table name> you need to end that line with ; and double check the table name...

4. Next command is very delicate, so check ten times if needed before hitting enter, because will do surgery with a table who is vital for your forums and only you want to remove a column on a table, not restoring the database and start another time from step 2.
On the mysql client you need to issue this command to remove the column added by the installer: alter table usergroup drop column articlepermissions ; (Note the ; at the end of the sentence).
Depending of the table size (small.... very small unless you run thousands of different groups) mysql client can wait for some time to return the control.

5. You've done it!. Probably you will have some more little bits from v3 articles on you DB (watch on phrase manager & template manager). But at least you've cleaned manually your DB (who the install script doesn't do giving the excuse of 'keeping' the content... wth! I want to get rid of everything!) and if you from time to time find anything you can safely remove it with complete peace of mind (will do, at least for this version).

6. Follow the install directions another time, but deleting what you added in the past (do some backups of the files before applying surgery - copy them to filename.php.original for example).

7. Remove the files you added.

8. Last but not least, click Uninstall on this thread if you previously clicked Install.

Edit:

If you followed those steps in the order I've told you, seems to be 99% uninstalled, just found little bits hanging on the DB. So... since Uninstall doesnt work as intended, you need to thank the autor to do manually. Additions to the uninstall procedure.

Fire a shell session and connect to your mysql database (just follow another time step 2 on the procedure).

Do a simple query like this: select * from settinggroup where grouptitle="v3_articles" ;

MySQL will surely return you a row as a result. In this case, fire this command: DELETE FROM `settinggroup` WHERE `grouptitle` = 'v3_articles' LIMIT 1 ;

Revised all my tables and didn't found more things related to v3 articles on my system, so if you want/need it... following those simple steps will give you a 99.99999999(pure period)% system.

[Host Directory]

Sorry it didnt work out for you AlfonsoC. I installed this hack on my board and had no problems with it.

Its working fine for me.

[TCB]

Originally Posted by Host Directory

Sorry it didnt work out for you AlfonsoC. I installed this hack on my board and had no problems with it.

Its working fine for me.

What vb version are you running? 3.0.1 ?

[Host Directory]

TCB i am running vb3.0.

[Zachariah]

Originally Posted by AlfonsoC

Hi....

Need a complete description of tables used by v3 articles 1.0.1... seems that something went wrong in the installation and some tables weren't created okay. So I cannot uninstall or install another time.

So, anyone can put the layout of the tables associated with v3 articles, please.

Take apart the install files or XML imported files in the hack.