Все разобрался
Добавлял состояние вывод
state_title, но аналогично и для
body_title (типа автомобиля)
в autobb.php в
function listMessages( $category=0 ) {
Находим
$query = "SELECT a.*, a.mileage*(1 + a.mileage_unit*0.609) as metric_mileage, a.mileage*(1 - (1 - a.mileage_unit)*0.3785) as english_mileage,"
."\n p.id as photo_id, count(p.id) as photo_count, v.itemid as vendor_itemid, v.title as vendortitle, m.itemid as model_itemid, m.title as modeltitle, c.title as colortitle, c.cod_color as cod_color,"
."\n cur.sign as currency_sign, a.price*cur.rate as price_in_rur, DATE_FORMAT(a.modifyDate, '%a, %d %b %Y %T GMT') as rfcDate";
$query .= ", ct.title as city_title, r.title as region_title";
Добавляем (заменяем)
s.title as state_title, b.title as body_title,
получаем:
$query = "SELECT a.*, s.title as state_title, b.title as body_title, a.mileage*(1 + a.mileage_unit*0.609) as metric_mileage, a.mileage*(1 - (1 - a.mileage_unit)*0.3785) as english_mileage,"
."\n p.id as photo_id, count(p.id) as photo_count, v.itemid as vendor_itemid, v.title as vendortitle, m.itemid as model_itemid, m.title as modeltitle, c.title as colortitle, c.cod_color as cod_color,"
."\n cur.sign as currency_sign, a.price*cur.rate as price_in_rur, DATE_FORMAT(a.modifyDate, '%a, %d %b %Y %T GMT') as rfcDate";
$query .= ", ct.title as city_title, r.title as region_title";
Далее чуть ниже идет
$query .= "\n FROM #__autobb_messages AS a"
."\n LEFT JOIN #__autobb_photos AS p"
."\n ON a.id=p.msgid"
."\n LEFT JOIN #__autobb_vendors AS v"
."\n ON a.vendor=v.id"
."\n LEFT JOIN #__autobb_models AS m"
."\n ON a.model=m.id"
."\n LEFT JOIN #__autobb_colors AS c"
."\n ON a.color=c.id"
."\n LEFT JOIN #__autobb_currency AS cur"
."\n ON a.currency=cur.id";
Добавляем
."\n LEFT JOIN #__autobb_bodies as b"
."\n ON b.id=a.bodytype"
."\n LEFT JOIN #__autobb_states as s"
."\n ON s.id=a.state"
$query .= "\n FROM #__autobb_messages AS a"
."\n LEFT JOIN #__autobb_photos AS p"
."\n ON a.id=p.msgid"
."\n LEFT JOIN #__autobb_vendors AS v"
."\n ON a.vendor=v.id"
."\n LEFT JOIN #__autobb_bodies as b"
."\n ON b.id=a.bodytype"
."\n LEFT JOIN #__autobb_states as s"
."\n ON s.id=a.state"
."\n LEFT JOIN #__autobb_models AS m"
."\n ON a.model=m.id"
."\n LEFT JOIN #__autobb_colors AS c"
."\n ON a.color=c.id"
."\n LEFT JOIN #__autobb_currency AS cur"
."\n ON a.currency=cur.id";
После чего, сохраняем и переходим в
autobb.html.phpЗдесь находим форму вывода объявлений в таблице
Я бы предложил поменять состояние в колонке "Марка и Модель", а вы может добавить и свою колонку (что бы можно было сортировать).
<td class="title"><a title="<?php echo $row->vendortitle; ?>" href="<?php echo $link;?>"<?php echo ($row->sticked?' class="sticked"':' class="unsticked"');?>><?php echo $row->vendortitle.' '.$row->modeltitle.' '.$row->modification; ?> </a></td>
Заменяем на то, что хотим получить, я хотел
state_title, но изменения произведенные в
autobb.php позволяют добавить и
body_title:
<?php echo $row->vendortitle.' '.$row->modeltitle.' '.$row->modification; ?></a><br><center><?php echo $row->state_title; ?></center></td>
17.04.2015, 14:06:21