1. Home
  2. Community
  3. General Questions
  4. Article count in admin >> review >> category list

This website can use cookies to improve the user experience

This website can use cookies to improve the user experience and to provide certain services and functions to users. Cookies contain small amounts of information (such as login information and user preferences) and will be stored on your device.

Enable All Cookies Privacy Policy

Article count in admin >> review >> category list

General Questions 916 This topic was started by ,


avatar
capslock 0
From: -
Article count in admin >> review >> category list

Is possible to have Article count in admin >> review >> category list?
I need to know how many articles are in each category.

Notice

This topic is archived. New comments cannot be posted and votes cannot be cast.

Responses to this topic

1 Re: Article count in admin >> review >> category list
avatar
OP 0
From: -
Article count in admin >> review >> category list

Perfect !!!
1 Re: Article count in admin >> review >> category list
avatar
Administrator
1340
From: Vienna, Austria
Article count in admin >> review >> category list

Here a modification. Open mod_review.php and find:

        $result = DBQuery("SELECT reviewcat_id, reviewcat_name FROM esselbach_st_reviewcat WHERE reviewcat_parent = '0' ORDER BY reviewcat_id");

                                                                                                                                              

        while (list($category_id, $category_title) = mysql_fetch_row($result))                                                                

        {

and add:

$query = DBQuery("SELECT COUNT(review_id) FROM esselbach_st_review WHERE review_page='1' AND review_category = '$category_id'");

list($reviews) = mysql_fetch_row($query);

Then replace below:

TblMiddle("$category_id", "$category_title", "reviewcat&opts=editcat-$category_id", "reviewcat&opts=deletecat-$category_id");

with:

TblMiddle("$category_id", "$category_title ($reviews reviews)", "reviewcat&opts=editcat-$category_id", "reviewcat&opts=deletecat-$category_id");

Notice

This topic is archived. New comments cannot be posted and votes cannot be cast.