mostrar itens adicionais de uma tabela

[arroutban]

Galera, seguinte, baixei esse script (http://www.bosdev.com/bosclassifieds/), e to fazendo vários testes.

o que eu queria era que na página index.php, na lista de classificados, aparecesse também junto com o titulo, a descrição e

o preço os campos ad_optional_1, ad_optional_2 e ad_optional_3 da tabela bclass_ads (que são campos adicionais relacionados

a tabela bclass_categories: category_optional_1, category_optional_2, category_optional_3).

No arquivo classified.php ele mostra os 3 campos adicionais.

tabela bclass_ads:

ad_id

ad_status 1

ad_user_id 1

ad_category 1

ad_date_begin

ad_date_end

ad_type

ad_title

ad_description

ad_image1

ad_image2

ad_image3

ad_image4

ad_image5

ad_options

ad_optional_1 980

ad_optional_2 São Paulo

ad_optional_3 Santana

ad_optional_4

ad_optional_5

ad_price

ad_condition

ad_views

tabela bclass_categories:

category_id

category_order 1

category_parent

category_title Alugar

category_desc

category_img

category_ad_types 1

category_optional_1 Referência nº

category_optional_2 Cidade

category_optional_3 Bairro

category_optional_4

category_optional_5

category_price_sale

category_price_want

category_price_job

category_price_service

category_price_notice

_______________________________________________________________________________

_______________________________________________________________________________

index.php

<?php

//Connect to database & get functions loaded

include("connect.php");

include("functions.php");

//Set globals

global $SystemOptions,$cat_id;

$result = query("SELECT * FROM {$class_prefix}system",$class_link);

$SystemOptions = mysql_fetch_array($result);

//Check for spider-friendly URL

if(isset($PATH_INFO) && $SystemOptions['spider'] == 1) {

$parts = explode('/', substr($PATH_INFO,1));

for($i=0; $i < count($parts); $i++){

if($i % 2 == 0){ $$parts[$i] = $parts[$i+1];}

}

}

//Set language

include("{$SystemOptions['main_path']}languages/{$SystemOptions['language']}.php");

//Check for expired ads

expireAds();

//Set some defaults and do some protection

if($cat_id == "") {

$cat_id = 0;

$title_extra = $Languages['nav']['home'];

}

else {

$cat_id = protect($cat_id);

$result = query("SELECT category_title FROM {$class_prefix}categories WHERE

category_id=$cat_id",$class_link);

list($cat_title) = mysql_fetch_row($result);

$title_extra = stripslashes($cat_title);

}

if($pg == "") { $pg = 1; }

include("header.php");

$ads_counter = 0;

$imgs = array();

$ads = array();

$result = query("SELECT ad_id,ad_date_begin,ad_date_end,ad_type,ad_title,ad_description,ad_image1,ad_options,ad_price FROM

{$class_prefix}ads WHERE ad_status=1 AND ad_category=$cat_id $sort_text",$class_link);

while(list($ad_id,$ad_date_begin,$ad_date_end,$ad_type,$ad_title,$ad_description,$ad_image1,$ad_options,$ad_price) =

mysql_fetch_row($result)) {

$ad_title = stripslashes($ad_title);

$ad_description = stripslashes($ad_description);

if(strlen($ad_description) >= 50) { $ad_description = substr($ad_description,0,50)."..."; }

if($ad_image1 != "") {

if($SystemOptions['spider'] == 1) { $imgs[$ads_counter] = "<a

href=\"{$SystemOptions['main_url']}classified.php/ad/$ad_id\"><img

src=\"{$SystemOptions['main_url']}images/ads/{$ad_id}_1_thumb.jpg\" border=\"2\" class=\"ad_thumb\"></a>"; }

else { $imgs[$ads_counter] = "<a href=\"{$SystemOptions['main_url']}classified.php?ad=$ad_id\"><img

src=\"{$SystemOptions['main_url']}images/ads/{$ad_id}_1_thumb.jpg\" border=\"2\" class=\"ad_thumb\"></a>"; }

}

if($ad_price == "0.00") { $ad_price = $Languages['index']['bestoffer']; }

else { $ad_price = formatPrice($ad_price); }

switch($ad_type) {

case 1:

$type = "<b>{$Languages['index']['forsale']}</b>";

$price = "<br><span

style=\"font-weight:bold;\">{$Languages['index']['price_sale']}</span>$ad_price&nbsp;&nbsp;";

break;

case 2:

$type = "<b>{$Languages['index']['wanted']}</b>";

$price = "<br><span

style=\"font-weight:bold;\">{$Languages['index']['price_want']}</span>$ad_price&nbsp;&nbsp;";

break;

case 4:

$type = "<b>{$Languages['index']['job']}</b>";

$price = "";

break;

case 8:

$type = "<b>{$Languages['index']['service']}</b>";

$price = "";

break;

case 16:

$type = "<b>{$Languages['index']['notice']}</b>";

$price = "";

break;

}

$date = formatDate($ad_date_begin);

if($SystemOptions['spider'] == 1) { $ads[$ads_counter] = "{$type} <a

href=\"{$SystemOptions['main_url']}classified.php/ad/$ad_id\" class=\"ad_link\"><span

style=\"font-weight:bold;\">$ad_title</span></a><br>$ad_description<br>{$price}"; }

else { $ads[$ads_counter] = "{$type} <a href=\"{$SystemOptions['main_url']}classified.php?ad=$ad_id\"

class=\"ad_link\"><span style=\"font-weight:bold;\">$ad_title</span></a><br>$ad_description<br>{$price}"; }

if($ad_options != 0) {

$back = ""; $back_e = ""; $bold = ""; $bold_e = ""; $italic = ""; $italic_e = "";

if(($ad_options & 8) != 0) { $back = "<div class=\"background_1\">"; $back_e = "</div>"; }

if(($ad_options & 16) != 0) { $back = "<div class=\"background_2\">"; $back_e = "</div>"; }

if(($ad_options & 32) != 0) { $back = "<div class=\"background_3\">"; $back_e = "</div>"; }

if(($ad_options & 64) != 0) { $back = "<div class=\"background_4\">"; $back_e = "</div>"; }

if(($ad_options & 2) != 0) { $bold = "<span style=\"font-weight:bold;\">"; $bold_e = "</span>"; }

if(($ad_options & 4) != 0) { $italic = "<span style=\"font-style:italic;\">"; $italic_e = "</span>"; }

$ads[$ads_counter] = "{$back}<span

class=\"ad_text\">{$bold}{$italic}{$ads[$ads_counter]}{$italic_e}{$bold_e}</span>{$back_e}";

}

$ads_counter++;

}

if($ads_counter != 0) {

echo $sort_table;

echo "<table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"3\" class=\"menu_bar\"><tr><td

class=\"menu_bar_text\">{$Languages['index']['results']}</td></tr></table>";

echo "<table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"5\">";

for($i=(($pg*6)-6); $i<=(($pg*6)-1); $i++) {

if($ads[$i] == "") { continue; }

echo "<tr>";

if($imgs[$i] != "") {

echo " <td valign=\"top\" width=\"50\" class=\"ad\">$imgs[$i]</td>";

echo " <td valign=\"top\" class=\"ad\"><span class=\"ad_text\">$ads[$i]</span></td>";

}

else {

echo " <td valign=\"top\" class=\"ad\" colspan=\"2\"><span

class=\"ad_text\">$ads[$i]</span></td>";

}

echo "</tr>";

}

echo "</table>";

if($ads_counter > 6) {

echo "<table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"5\">";

echo "<tr><td align=\"right\" class=\"category_text\">{$Languages['index']['gotopage']} ";

$pages = ceil($ads_counter/6);

for($i=1; $i<=$pages; $i++) {

if($pg == $i) { echo "{$i}&nbsp;"; }

else {

if($SystemOptions['spider'] == 1) { echo "<a

href=\"{$SystemOptions['main_url']}index.php/cat_id/$cat_id/pg/$i/sort/$sort/sort_dir/$sort_dir\">{$i}</a>&nbsp;"; }

else { echo "<a

href=\"{$SystemOptions['main_url']}index.php?cat_id=$cat_id&pg=$i&sort=$sort&sort_dir=$sort_dir\">{$i}</a>&nbsp;"; }

}

}

echo "</td></tr></table>";

}

}

if($ads_counter == 0 && $cat_id != 0 && $category_counter == 0) { echo "<br><br><div class=\"ad_text\"

align=\"center\">{$Languages['index']['noads']}</div><br><br>"; }

?>

_______________________________________________________________________________

_______________________________________________________________________________

classified.php

<?php

//Connect to database & get functions loaded

include("connect.php");

include("functions.php");

//Set globals

global $SystemOptions,$cat_id;

$result = query("SELECT * FROM {$class_prefix}system",$class_link);

$SystemOptions = mysql_fetch_array($result);

//Check for spider-friendly URL

if(isset($PATH_INFO) && $SystemOptions['spider'] == 1) {

$parts = explode('/', substr($PATH_INFO,1));

for($i=0; $i < count($parts); $i++){

if($i % 2 == 0){ $$parts[$i] = $parts[$i+1];}

}

}

//Set language

include("{$SystemOptions['main_path']}languages/{$SystemOptions['language']}.php");

//Get ad data

$ad = protect($ad);

$result = query("SELECT

a.ad_status,a.ad_user_id,a.ad_category,a.ad_date_begin,a.ad_date_end,a.ad_type,a.ad_title,a.ad_description,a.ad_image1,a.ad_

image2,a.ad_image3,a.ad_image4,a.ad_image5,a.ad_options,a.ad_optional_1,a.ad_optional_2,a.ad_optional_3,a.ad_optional_4,a.ad

_optional_5,a.ad_price,a.ad_condition,a.ad_views,c.category_optional_1,c.category_optional_2,c.category_optional_3,c.categor

y_optional_4,c.category_optional_5,u.user_name FROM {$class_prefix}ads a LEFT JOIN {$class_prefix}categories c ON

a.ad_category=c.category_id LEFT JOIN {$class_prefix}users u ON a.ad_user_id=u.user_id WHERE ad_id=$ad",$class_link);

list($ad_status,$ad_user_id,$cat_id,$ad_date_begin,$ad_date_end,$ad_type,$ad_title,$ad_description,$ad_image1,$ad_image2,$ad

_image3,$ad_image4,$ad_image5,$ad_options,$ad_optional_1,$ad_optional_2,$ad_optional_3,$ad_optional_4,$ad_optional_5,$ad_pri

ce,$ad_condition,$ad_views,$category_optional_1,$category_optional_2,$category_optional_3,$category_optional_4,$category_opt

ional_5,$username) = mysql_fetch_row($result);

//Display header

include("header.php");

//Add viewer to statistics

recordUser("a",$ad);

$ad_views++;

$now = time();

if($ad_status != 1 || ($now > strtotime($ad_date_end) && $ad_date_end != "0000-00-00")) { echo "<span

class=\"ad_text\"><br>{$Languages['classified']['sorry']}<br><br></span>"; }

else {

$ad_title = stripslashes($ad_title);

$ad_description = toHtml($ad_description);

$ad_optional_1 = stripslashes($ad_optional_1);

$ad_optional_2 = stripslashes($ad_optional_2);

$ad_optional_3 = stripslashes($ad_optional_3);

$ad_optional_4 = stripslashes($ad_optional_4);

$ad_optional_5 = stripslashes($ad_optional_5);

$category_optional_1 = stripslashes($category_optional_1);

$category_optional_2 = stripslashes($category_optional_2);

$category_optional_3 = stripslashes($category_optional_3);

$category_optional_4 = stripslashes($category_optional_4);

$category_optional_5 = stripslashes($category_optional_5);

$username = stripslashes($username);

$ad_date_begin = formatDate($ad_date_begin);

if($ad_date_end != "0000-00-00") {

$ad_date_end = formatDate($ad_date_end);

$end_date = "<b>{$Languages['classified']['ends']}:</b> $ad_date_end<br>";

}

if($ad_price == "0.00") { $ad_price = $Languages['classified']['bestoffer']; }

else { $ad_price = formatPrice($ad_price); }

switch($ad_type) {

case 1:

$type = $Languages['classified']['forsale'];

$pricetype = $Languages['classified']['asking'];

$condtype = $Languages['classified']['condition'];

break;

case 2:

$type = $Languages['classified']['wanted'];

$pricetype = $Languages['classified']['offering'];

$condtype = $Languages['classified']['desired_condition'];

break;

case 4:

$type = $Languages['classified']['job'];

break;

case 8:

$type = $Languages['classified']['service'];

break;

case 16:

$type = $Languages['classified']['notice'];

break;

}

$ad_condition = $Languages['classified']["cond".$ad_condition];

if($category_optional_1 != "") { $optional_line .= "<b>$category_optional_1:</b> $ad_optional_1<br>"; }

if($category_optional_2 != "") { $optional_line .= "<b>$category_optional_2:</b> $ad_optional_2<br>"; }

if($category_optional_3 != "") { $optional_line .= "<b>$category_optional_3:</b> $ad_optional_3<br>"; }

if($category_optional_4 != "") { $optional_line .= "<b>$category_optional_4:</b> $ad_optional_4<br>"; }

if($category_optional_5 != "") { $optional_line .= "<b>$category_optional_5:</b> $ad_optional_5<br>"; }

if($optional != "") { $optional_line .= "<br>"; }

if($_COOKIE['bc_userID'] != "" && authenticate($_COOKIE['bc_userID'])) {}

elseif($_COOKIE['bc_userID'] == $ad_user_id) {}

else { $admin_bar = ""; }

$imgs = 0;

if($ad_image1 != "") { $imgs++; }

if($ad_image2 != "") { $imgs++; }

if($ad_image3 != "") { $imgs++; }

if($ad_image4 != "") { $imgs++; }

if($ad_image5 != "") { $imgs++; }

if($imgs != 0) {

$image_layout = "<table width=\"100%\" border=\"0\" cellspacing=\"1\" cellpadding=\"3\">";

$image_layout .= "<tr>";

$image_layout .= "<td width=\"75%\" valign=\"center\"><img

src=\"{$SystemOptions['main_url']}images/ads/$ad_image1\" name=\"mainPicture\"

width=\"{$SystemOptions['max_size']}\"></td>";

$image_layout .= "<td width=\"25%\" valign=\"center\">";

if($ad_image1 != "") { $image_layout .= "<a

href=\"java script:update('{$SystemOptions['main_url']}images/ads/$ad_image1');\"><img

src=\"{$SystemOptions['main_url']}images/ads/{$ad}_1_thumb.jpg\" width=\"80\"></a><br><br>"; }

if($ad_image2 != "") { $image_layout .= "<a

href=\"java script:update('{$SystemOptions['main_url']}images/ads/$ad_image2');\"><img

src=\"{$SystemOptions['main_url']}images/ads/{$ad}_2_thumb.jpg\" width=\"80\"></a><br><br>"; }

if($ad_image3 != "") { $image_layout .= "<a

href=\"java script:update('{$SystemOptions['main_url']}images/ads/$ad_image3');\"><img

src=\"{$SystemOptions['main_url']}images/ads/{$ad}_3_thumb.jpg\" width=\"80\"></a><br>"; }

if($ad_image4 != "") { $image_layout .= "<a

href=\"java script:update('{$SystemOptions['main_url']}images/ads/$ad_image4');\"><img

src=\"{$SystemOptions['main_url']}images/ads/{$ad}_4_thumb.jpg\" width=\"80\"></a><br>"; }

if($ad_image5 != "") { $image_layout .= "<a

href=\"java script:update('{$SystemOptions['main_url']}images/ads/$ad_image5');\"><img

src=\"{$SystemOptions['main_url']}images/ads/{$ad}_5_thumb.jpg\" width=\"80\"></a><br>"; }

$image_layout .= "</td></tr></table>";

}

if($ad_type == 1 || $ad_type == 2) {

$price_line = "<b>$pricetype:</b> $ad_price<br>";

$condition_line = "<b>$condtype:</b> $ad_condition<br>";

}

echo<<<ENDPRINT

<script language=JavaScript">

<!--

function update(url){

document['mainPicture].src=url;

return;

}

//-->

</script>

<br>

$admin_bar

<table width="100%" border="0" cellspacing="1" cellpadding="3">

<tr>

<td class="ad_text" width="50%" valign="top">

<b>$type $ad_title</b><br>

<hr>

$price_line

$optional_line

<hr>

<b>{$Languages['classified']['description']}:</b><br>

$ad_description<br><br>

<a href="java script:history.go(-1)">voltar</a>

</td>

<td class="ad_text" width="50%" valign="top">

$image_layout<br />

</td>

</tr>

</table>

ENDPRINT;

}

?>

__________________________________________________________________________________

__________________________________________________________________________________