Help with MySQL - porting moneybookers mod from other site

I am in the process of attempting to port the updated MoneyBookers module from osCommerce to ZC as Paypal is not a viable option for some of us outside certain regions of the world.

The current MB Module works ok but is basic and doesn't take full advantage of the features MB offers. The latest work done on the OSC version can fully interact with MB and I want to implement this.

I have followed the guidelines in the Wiki for porting OSC modules but need help on one point...how to insert an SQL file into an existing database.

Any pointers on merging two sql files? I think I should be able to copy the new SQL into an exported SQL file of the original db and then reimport the whole lot. Is this correct?

Thanks

OK I managed to figure that one out but broken something.

The section on the right hand side under /modules/payment where you install a payment module has disapeared.

Any clues where the relevant code etc can be accessed?

Thanks

The section on the right hand side under /modules/payment where you install a payment module has disapeared.
Well if you have not changed the admin files I would suspect that you have altered the DB table that contains this information.

You stated that you managed to figure out something but did not elaborate on what it was that you did or changed...

Care to detail what you have done and to what table

Thanks for the response.

It was to do with the /includes/modules/payment. I got it back. Just need to install the MB files one by one to determine where the conflict is.

     $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('MBookers Return URL', 'MODULE_PAYMENT_MBOOKERS_IPN_RETURN_URL','".zen_catalog_href_link(FILENAME_CHECKOUT_PROCESS, '', 'SSL',false)."', '', '6', '99','".zen_catalog_href_link(FILENAME_CHECKOUT_PROCESS, '', 'SSL',false)."', now())");

I have got the piece of code from the PayPal Module (From paypal.php under Function Install) but need some help on the correct syntax for what I want to do.

Basically, I want to store the link generated by ".zen_catalog_href_link(FILENAME_CHECKOUT_PROCESS, '', 'SSL',false)" in the MODULE_PAYMENT_MBOOKERS_IPN_RETURN_URL MySQL Key but do not want it to show up as an option for editing under the module install.

A similar one is

     $db->Execute("insert into " . TABLE_CONFIGURATION . " (configuration_title, configuration_key, configuration_value, configuration_description, configuration_group_id, sort_order, set_function, date_added) values ('Link to MBookers', 'MODULE_PAYMENT_MBOOKERS_HANDLER', 'www.mbookers.com', 'Link to MBookers Payment Processing', '6', '73', '', now())");

Here I just want to store the MBookers link so users do not need to enter it themselves. After editing the PayPal file, there is a text box for input which I don't need.

Any help appreciated. Thanks

PS Just realised that this thread perhaps should be in a different part of the forum. :bangin:

Help, Wimper.

OK. After getting no answers, I have struggled through and largely completed the exercise.

The new module works and does interact with the moneybookers site.

I am waitng for them to set up a test account with virtual money so I can put it through its paces. Also Moneybookers might be in touch about becoming a partner.

One question though is how do I make it available for others after completion?

Cheers

You can submit your new payment mod, for download at
http://www.zen-cart.com/index.php?main_page=index&cPath=40

Dayo:

OK. After getting no answers, I have struggled through and largely completed the exercise.

The new module works and does interact with the moneybookers site.

I am waitng for them to set up a test account with virtual money so I can put it through its paces. Also Moneybookers might be in touch about becoming a partner.

One question though is how do I make it available for others after completion?

Cheers
Can you email me a copy or post a file on here I would like to try it on my site you can my email address on www.bgstores.biz
Thanks

Just got the old Moneybookers module moved the files to the new places and it's working fine on 1.3.7
Attachment #1836