Downloaded contribution productlist by catagorie

[grandmasterjack]

Downloaded contribution productlist by catagorie and don't have a clue how to install it or how to edit it, any ideas?

There is a topic on this but I can't find installation instructions

 

<?php

 

/* Changes made by NEOVITA http://neovita.com.pl

- canged the code to create full featured infobox

- created variables for easy customizing the box

- corrected mysql query

 

See the comments where editing may be needed

*/

 

// calculate category path

if (isset($HTTP_GET_VARS['cPath'])) {

$cPath = $HTTP_GET_VARS['cPath'];

} elseif (isset($HTTP_GET_VARS['products_id']) && !isset($HTTP_GET_VARS['manufacturers_id'])) {

$cPath = tep_get_product_path($HTTP_GET_VARS['products_id']);

} else {

$cPath = '';

}

 

if (tep_not_null($cPath)) {

$cPath_array = tep_parse_category_path($cPath);

$cPath = implode('_', $cPath_array);

$current_category_id = $cPath_array[(sizeof($cPath_array)-1)];

} else {

$current_category_id = 0;

}

 

//edit following variables to match what you want to show

$limit = '100'; //limit number of products shownon the list

$width = '30'; //product image width in pixels

$height = ''; //product image height in pixels

 

 

//get info from database

//here you don't need to change enything

$result = mysql_query("

SELECT distinct

pd.products_id,

pd.products_name,

p.products_image,

p2c.categories_id,

p2c.products_id

FROM

products_description pd,

products p,

products_to_categories p2c

WHERE

p2c.products_id = pd.products_id AND

p.products_id = pd.products_id AND

p2c.categories_id = ".$cPath."

ORDER BY pd.products_name DESC

LIMIT ".$limit."

")

or die(mysql_error());

// end take info from database

?>

 

<tr>

<td>

<?php

$info_box_contents = array();

$info_box_contents[] = array('text' => 'Lista produktów'); //edit infobox heading as you want

new infoBoxHeading($info_box_contents, true, true);

 

 

// Print out the contents of each row

$info_box_contents = array();

while($row = mysql_fetch_array( $result )) {

 

$info_box_contents[] = array('text' =>

//you can edit the following html to match your needs

'<table>

<tr>

<td>

<img src="'.DIR_WS_IMAGES.'/'.$row["products_image"].'" border="0" width="'.$width.'" height="'.$height.'">

</td>

<td>

<a " href="product_info.php?products_id='.$row["products_id"].'">'.$row['products_name'].'</a>

</td>

</tr>

</table>'

);

}

 

//View All link

//you can edit html as you want

$info_box_contents[] = array('text' =>

'<div align="center" style="text-align:left;">

<a href="index.php?cPath='.$cPath.'">

</a>

</div>'

);

 

new infoBox($info_box_contents);

?>

</td>

</tr>

 

Please keep it simple for this poor layman.

Jack

[grandmasterjack]

please someone must know :(

[lindsayanng]

a link to the actual contribution would help..

 

also, was there no txt file in there?

[lindsayanng]

found it.. you downloaded an incomplete package.. read the descriptions.. the complete package WITH MANUAL is on V .2

[grandmasterjack]

found it.. you downloaded an incomplete package.. read the descriptions.. the complete package WITH MANUAL is on V .2

 

Lindsay this is the link you gave me and I don't see any V.2 here I downloaded the fist one 18th april 2008

More Category Boxes 1.0

Jack

[grandmasterjack]

Lindsay this is the link you gave me and I don't see any V.2 here I downloaded the fist one 18th april 2008

More Category Boxes 1.0

Jack

I also checked this and there is nothing there

Support for this contribution

[lindsayanng]

you said "product list by categories" and this is the contribution i pulled up:

Product List by Categories

 

You didnt says second category box

 

For that one, just download the first package and there is your COMPLETE package WITH instructions.> You should ALWAYS download the last full package and then the fixes as needed. people clutter upt he contributions with too much crap