shipworks plugin

[delia]

I am working redoing the shipworks one file plugin. This file comes from Osc as just a drop in file into admin that the computer based shipworks program accesses.

I have converted osc contributions before but this has a new twist to it. In order to access the database I've included code/files but then run up against the illegal access problem. As Osc has no inbuilt admin/session management, they have made no allowances for this in the shipworks plugin.

I can't access the file any other way than directly accessing it on the web. The shipworks program only gives a generic error when encountering any problems. They have assured me that nothing in their program is cart specific so only the shipworks.php file needs changing.

So how in the world do I add in the admin/sessions management (I'm assuming it's like the cart itself) to that lone file?

[kobra]

I think that what you need is this in the other mod file:

require('includes/application_top.php');

[delia]

Okay that did solve that problem but created another. Back to shipworks tech help. Thanks! (that was a duh - should have thought of that myself!)

[delia]

well, that's a no go for sure. This requires specific output and cannot include any extraneous html. So I need to pick up only the database functions.

the oscommerce version only has these includes:

require('includes/configure.php');
require(DIR_WS_INCLUDES . 'database_tables.php');
require(DIR_WS_CLASSES . 'order.php');
require(DIR_WS_FUNCTIONS . 'database.php');
require(DIR_WS_FUNCTIONS . 'general.php');

I've changed to include the database_tables.php in the catalog/includes directory, but am I not right in assuming that I still need the db connection stuff that comes from the query_factory file?

[delia]

To continue - the reason it looks this way is because this line:

$configuration_query = $db->Execute('select configuration_key as cfgKey, configuration_value as cfgValue from ' . TABLE_CONFIGURATION);

gets this error message:
Call to a member function Execute() on a non-object

[tmdelia]

Any luck on porting this over? Any ETA of when it might be ready?

I'm willing to share in the development costs for porting this mod to ZC, and I know there are other Zenners out there that would be interested too.

[yellow1912]

Assuming that you call this inside a function, you have to declare $db as global:
global $db;

To continue - the reason it looks this way is because this line:

$configuration_query = $db->Execute('select configuration_key as cfgKey, configuration_value as cfgValue from ' . TABLE_CONFIGURATION);

gets this error message:
Call to a member function Execute() on a non-object

[delia]

Hi, Guys!

My client didn't want to spend much money to do this but I did start converting it to straight php without the zen functions in order to bypass the problems. He's paying only $50 since I thought it would be a easy conversion. Ha! And he's willing to go a little more money. Until I get done, I don't know how much more it will cost.

TMDelia - you want to send me a private message?

[delia]

so I changed the config stuff to:

global $db;

// Define all config values
$configuration_query = $db->Execute('select configuration_key as cfgKey, configuration_value as cfgValue from ' . TABLE_CONFIGURATION);

while (!$configuration_query->EOF)
{

define($configuration->fields['cfgKey'], $configuration->fields['cfgValue']);
$configuration_query->MoveNext();

}

I get no errors and no data which may not be due to this but to something that comes after. Can someone tell me if the code above should work?

[thomasw98]

What does this mod actually do? I can not find any description in the downloads sections either...