City in Ads

In the block of all the ads of the main page of ads I would like that the city appeared.

I have achieved this by adding these lines in the files:

In BxAdsSearchUnit.php

Line 228 add--->$sAdCiudad = db_value("SELECT `City` FROM `bx_ads_main` WHERE `ID` = '$iAdID' LIMIT 1");

Line 273 add--->'ad_ciudad' => $sAdCiudad,

In Unit_ads.html Add---> __ad_ciudad__

With this it works fine, but I have to do a mysql query for each ad. Is there no variable already defined for city without having to make a new query?

In BxAdsSearchUnit.php at line 22, Find :

'ownFields' => array('ID', 'IDProfile', 'IDClassifiedsSubs', 'DateTime', 'LifeTime', 'Subject', 'EntryUri', 'Message', 'CustomFieldValue1', 'CustomFieldValue2', 'Media', 'Tags', 'Status', 'Rate', 'RateCount', 'CommentsCount'),

Thank you very much.

One more thing.

In the block that shows the image the search filters appear.

But in the block of all ads do not appear those filters. Could they be added to the block of all ads?

Solved