osCommerce (Page 3 of 3)

Yes something was wrong. I'm using this for Zen Cart and I had to modify some of the add_to_order fields (around line 495).

So now it works great! Except one thing - I would like the date to reflect the actual date of the order. Right now, you have it coded as:

$cart->document_date = TODAY();
$cart->due_date = TODAY();

I tried to get the date from the Zen Cart database with:

$sql = "SELECT DATE(date_purchased) FROM orders WHERE orders_id = $oID";
$result = mysql_query($sql, $osc);
$date_purchased = mysql_fetch_assoc($result);
mysql_free_result($result);   

And then using:

$cart->document_date = $date_purchased;
$cart->due_date = $date_purchased;

but this doesn't work.

Isn't there an elegant way to get the actual order date?

Yes I can do that, but I am not a programmer, and there are several shortcomings to this - the biggest being that if your items are priced by attributes, and attributes are weights, your imported orders may not accurately reflect the change in inventory.

If your products are priced by item, this will work great as I have it now. Where do I upload it?

hi guys

I have used this before in the earlier version.

I am trying to get this working in FA 2.3 RC3 and am running into troubles. It is getting as far as creating the new data table but then it never finds the table again so the Update MySql Button is never displayed.

I have narrowed it down to this bit of code which sets $found = 1 if it appears in the show tables list returned by SHOW TABLES.

$sql = "SHOW TABLES";
$result = db_query($sql, "could not show tables");
$found = 0;
while (($row = db_fetch_row($result))) {
    if ($row[0] == TB_PREF."oscommerce") $found = 1;
}

I have confirmed it is not formatting the table name correctly in a multi company situation as if I ask it to look for a hard coded "0_oscommerce", it works.

So how do you return a string with the company number prepended to the table name?

Yes, in 2.3RC3 changes were made related to TB_PREF. Now  TB_PREF is set to '&TB_PREF&'   pattern which is superseded by right preffix just in db_query(). This was necessary to enable right upgrade on multi-database installations (where).

Also I'm not sure about the right place for function definitions in extension file. Probably the better one would be below all include() lines.

Janusz