{New_Listings} Smarty Plugin - adding city and state

[LittleRascal +]

Has anyone been able to add the city and state to the new_listing plugin, I went into the smarty plugin hoping that I could just add to highlited code below, but no such luck! If anyone could help me out, that would be much appreciated..not sure if their is more stuff I need to add to the plugin

The file is located in your /includes/classes/smarty/plugins/function.new_listings.php

Thanks,


$sSQL="SELECT p.id, p.owner, p.title, p.featured, p.section, p.description, p.price, p.dateadded, p.expiration, p.pHighlighted, p.pBold, u.state, u.city, u.country FROM ".PREFIX."products AS p LEFT JOIN ".PREFIX."users AS u ON p.owner = u.id WHERE p.expiration > NOW() AND p.display = 'Y' ORDER BY p.dateadded DESC LIMIT ".$number;
$result=$db->query($sSQL);
$i=0;
while($row=$result->fetch())
{
$tmp = array(
'id' => $row['id'],
'title'=> $row['title'],
'city'=> $row['city'],
'state'=> $row['state'],
'dateadded'=>$row['dateadded'],
'price'=> FormatCurrency($row['price']),
);
$loop[$i++] = $tmp;

[seymourjames +]

And how are you defining output in that function?

[LittleRascal +]

I don't really know to much about programming, not sure by what you mean in your question. I thought the new listing plugin in would be able to use the city and state.


ok i think after looking at the code...i see what you mean by output file...

[seymourjames +]

so you have added stuff which looks correct but where you have the output lines in that function have you made any changes? Otherwise how can it display the information.

[LittleRascal +]

Originally Posted by LittleRascal

I don't really know to much about programming, not sure by what you mean in your question. I thought the new listing plugin in would be able to use the city and state.


ok i think after looking at the code...i see what you mean by output file...

I got it to work now....

<?php
/**
* smarty_function_new_listings
*
* This function is useful for generating a vertical table of new listings.
*
* All source code & content (c) Copyright 2006, 68 Classifieds
* unless specifically noted otherwise.
*
* @package 68classifieds
* @author Eric Barnes
* @copyright 68 Classifieds
* @link 68 Classifieds - PHP Classifieds Script
* @$Revision: 1.3 $
* @Updated: $Date: 2006/05/26 13:14:08 $
*/
function smarty_function_new_listings($params, &$smarty)
{
global $db;

$table_attr = 'border="1"';
$tr_attr = '';
$td_attr = '';
$number=4;
$trailpad = ' ';
$img_break = '<br />';
$date_format = '%B %e, %Y %I:%M %p';

foreach ($params as $_key=>$_value)
{
switch ($_key)
{
case 'number':
$$_key = (int)$_value;
break;

case 'table_attr':
case 'img_break':
case 'date_format':
$$_key = (string)$_value;
break;

case 'tr_attr':
case 'td_attr':
$$_key = $_value;
break;
}
}

$sSQL="SELECT p.id, p.owner, p.title, p.featured, p.section, p.description, p.price, p.dateadded, p.expiration, p.pHighlighted, p.pBold, u.state, u.city, u.country FROM ".PREFIX."products AS p LEFT JOIN ".PREFIX."users AS u ON p.owner = u.id WHERE p.expiration > NOW() AND p.display = 'Y' ORDER BY p.dateadded DESC LIMIT ".$number;
$result=$db->query($sSQL);
$i=0;
while($row=$result->fetch())
{
$tmp = array(
'id' => $row['id'],
'title'=> $row['title'],
'city'=> $row['city'],
'state'=> $row['state'],
'price'=> FormatCurrency($row['price']),
'dateadded'=>$row['dateadded'],

);
$loop[$i++] = $tmp;
}
$loop_count = count($loop)-1;

$output = "<table " . $table_attr.">\n";
for ($x = 0; $x<= $loop_count; $x++)
{
//opening tr
$output .= "<tr" . smarty_function_html_table_cycle_newlistings('tr', $tr_attr, $c) . ">\n";
//opening td
$output .= "<td" . smarty_function_html_table_cycle_newlistings('td', $td_attr, $c) . ">\n";
//title
if(defined('SEO'))
{
$listing_title=$loop[$x][title];
$listing_title=str_replace(' ', '_', $listing_title);
$listing_title=preg_replace('/\W/e', '', $listing_title);
$output.="<a href='listing/".$loop[$x][id]."/".$listing_title.".html'>".$loop[$x][title]."</a>";
}
else
{
$output.="<a href='viewlisting.php?view=". $loop[$x][id] ."'>".$loop[$x][title]."</a>";
}
$output.="</td>\n";
$output .= "<td" . smarty_function_html_table_cycle_newlistings('td', $td_attr, $c) . ">\n";
//price
$output.=$loop[$x][price];
$output.="</td>\n";
$output .= "<td" . smarty_function_html_table_cycle_newlistings('td', $td_attr, $c) . ">\n";
//date
$output.=$loop[$x][city];
$output.="</td>\n";
$output .= "<td" . smarty_function_html_table_cycle_newlistings('td', $td_attr, $c) . ">\n";
$output.=$loop[$x][state];
$output.="</td>\n";
$output .= "<td" . smarty_function_html_table_cycle_newlistings('td', $td_attr, $c) . ">\n";
//$output.=smarty_modifier_date_format($loop[$x][dateadded], $date_format);
//closing td
$output.="</td>\n";
$output .= "</tr>\n";
}
$output .= "</table>\n";

return $output;
}

function smarty_function_html_table_cycle_newlistings($name , $var, $no)
{
if(!is_array($var))
{
$ret = $var;
}
else
{
$ret = $var[$no % count($var)];
}
return ($ret) ? ' '.$ret : '';
}
?>