Suggestion for the "Manage Listings" page

[Success]

I have a suggestion for the "Manage Listings" page in admin.

Show the category field.

This is because a problem that classifieds sites often face is that users put ads in all sorts of wrong categories.

Having the category field on Manage Listings will enable admin to see, from one glance, which categories the latest ads are being posted to.

What SQL query can we add to listings.php to do this?

[Eric Barnes +]

You can add this manually. Open the kernel/Listings.php and locate this around line 387:

$row['l_Status_Text']=$this->getStatusByValue($row['display']);

Just below it add:

$row['l_category']=$this->getCategoryNameById($row['section']);