Deleting Articles in Bulk

[joebrochin]

I am making some changes to Rhino articles. I need to delete some categories and all articles in those categories, but I am not sure how to do this in bulk.
With AD, it is not allowing me to delete the category when articles are present and you can only delete articles one at a time through the admin panel.
Can someone give me a tip to make this go quicker. I would like to have the new Rhino up and running before the weekend.

Live your life like a Rhino!

[joebrochin]

OK, I have figured out how to delete the categories through MySql in the cPanel.
However I still have all the articles from those categories still showing.
I would like to delete them, can anyone give a tip on how to do this in mass?

Also, is there a software that I can run that will do a word count of all articles already in the directory and delete those under a certain amount?
I am running a filter count on all articles pending approval, but thousands made it through before I had this.

[rleeq]

OK, I have figured out how to delete the categories through MySql in the cPanel.
However I still have all the articles from those categories still showing.
I would like to delete them, can anyone give a tip on how to do this in mass?

Also, is there a software that I can run that will do a word count of all articles already in the directory and delete those under a certain amount?
I am running a filter count on all articles pending approval, but thousands made it through before I had this.

I don't know about using any software to delete articles under a certain word count but I know it can be done easily in the database .
Log into the data base and bring up the prefix_articles tables. now click the browse link at the top. First you will want to setup so all articles are showing. Notice in the "showing rows" how many articles in the database. Put that number in the "show" form box and set the "starting from record" to 0 and click show. After that loads (it might take a min. depending on the total # of articles in your db) scroll to the far right you will find a word count heading. Click on this once and it will order all articles by the word count. Now just select all of the ones under your target word count and scroll to the bottom and delete them.

Keep your database open as you will use it for the categories issue.

The issue about the categories is next. As it sounds like you've already deleted some categories, this is going to depend on whether you know the category id number of the categories you want to delete articles from. First right click the prefix_category on the left of the page and open it in a new tab (Keep the prefix_articles open.) Each category has an id number. click the id heading and order them. Now go back to prefix_articles and click the category ID and order them. The next step is obvious but I'll tell how anyway. From the prefix_categories page pick the category you want to delete articles from. go back to the prefix_articles page, select all the articles with that category id and delete them at the bottom.

I just took a look at my categories tables and it looks like category id numbers skips for the ones I deleted when I set the script up. You might be able to use this as a guide for the categories you've already deleted.


Hope this helps.

R'

[vijay]

We need to know what other programs you are running on your computer.

I did a search on Wikipedia with the phrase

Ask Toolbar

and there is no article about it. The article about the Ask.com website mentions it but does not list the programs that also supply it

I was surprised to see a list of several programs that include it.

Norton 360 - the anti-malware software by Symantec

Nero - the software that comes with many CD and DVD burners

Frostwire
____________________________________________________________________________
buy wow accounts | wow account