Calling PHP data from Oscommerce
 

Hi

Can any help me please?

I have setup Vbulletin and have the vertical navigation menu installed.

I also have a Oscommerce PHP eshop

what I want to do is call the php scripts so then run on vbullentin

Example on my oscommerce store there is a code that runs called whats_new.php and this randomlly shows products in my store..

I want to code this into my forum, so on the vertical menu I have added it randomally shows products on my store and when clicked takes users to that product on there store.


any ideas please?

this is the whats_new.php code from oscommerce.

------------
<?php
/*
$Id: whats_new.php,v 1.1 2004/06/08 14:23:19 Simon Hodgson Exp $

osCommerce, Open Source E-Commerce Solutions
http://www.oscommerce.com

Copyright (c) 2003 osCommerce

Released under the GNU General Public License
*/

if ($random_product = tep_random_select("select products_id, products_image, products_tax_class_id, products_price from " . TABLE_PRODUCTS . " where products_status = '1' order by products_date_added desc limit " . MAX_RANDOM_SELECT_NEW)) {
?>
<!-- whats_new //-->
<tr>
<td>
<?php
$random_product['products_name'] = tep_get_products_name($random_product['products_id']);
$random_product['specials_new_products_price'] = tep_get_products_special_price($random_product['products_id']);

$info_box_contents = array();
$info_box_contents[] = array('text' => BOX_HEADING_WHATS_NEW);

new infoBoxHeading($info_box_contents,false,false,tep_ href_link(FILENAME_PRODUCTS_NEW),true,'right',"inf oBoxheadingRight");

if (tep_not_null($random_product['specials_new_products_price'])) {
$whats_new_price = '<s>' . $currencies->display_price($random_product['products_price'], tep_get_tax_rate($random_product['products_tax_class_id'])) . '</s><br>';
$whats_new_price .= '<span class="productSpecialPrice">' . $currencies->display_price($random_product['specials_new_products_price'], tep_get_tax_rate($random_product['products_tax_class_id'])) . '</span>';
} else {
$whats_new_price = $currencies->display_price($random_product['products_price'], tep_get_tax_rate($random_product['products_tax_class_id']));
}

$info_box_contents = array();
$info_box_contents[] = array('align' => 'center',
'text' => '<a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $random_product['products_id']) . '">' . tep_image(DIR_WS_IMAGES . $random_product['products_image'], $random_product['products_name'], SMALL_IMAGE_WIDTH, SMALL_IMAGE_HEIGHT) . '</a><br><a href="' . tep_href_link(FILENAME_PRODUCT_INFO, 'products_id=' . $random_product['products_id']) . '">' . $random_product['products_name'] . '</a><br>' . $whats_new_price);

new infoBox($info_box_contents,false,false,true,'right ',"infoBoxContentsRight");
?>
</td>
</tr>
<!-- whats_new_eof //-->
<?php
}
?>
--------------------------------

this is the code on my menu on vbullentin that fills the navigation menu. I want to somehow get the whats_new code running in the below...


-------------
<tr>
<td class="thead">
Navigation
</td>
</tr>
<tr>
<td class="alt1">
<a href="http://www.hakmob.com/forum">Forums</a></td>
</tr>
<tr>
<td class="alt2">
<a href="http://www.hakmob.com">Shop</a></td>
</tr>
<tr>
<td class="alt1">
<a href="#">Gallery</a></td>
</tr>
<tr>
<td class="alt2">
<a href="arcade.php">Arcade</a></td>
</tr>
<tr>
<td class="alt1">
<a href="donate.php">Donate</a></td>
</tr>
-----------------------------------------------------

Would appreicate some help on this

thanks

Please/...any ideas?

I send a paypal payment to anyone who can tell me how to get it working!!

thanks

to do it you have to change the links in the include file in the oscommerce php file - to do it you would be best to duplicate the oscommerce file and then setup the includes that you need