Results 1 to 10 of 10
  1. #1
    Join Date
    Dec 2006
    Posts
    163
    Plugin Contributions
    1

    Default 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

  2. #2
    Join Date
    Dec 2006
    Posts
    163
    Plugin Contributions
    1

    Default Re: Help with MySQL

    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

  3. #3
    Join Date
    Aug 2005
    Location
    Arizona
    Posts
    27,755
    Plugin Contributions
    9

    Default Re: Help with MySQL

    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
    Zen-Venom Get Bitten

  4. #4
    Join Date
    Dec 2006
    Posts
    163
    Plugin Contributions
    1

    Default Re: Help with MySQL

    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.

  5. #5
    Join Date
    Dec 2006
    Posts
    163
    Plugin Contributions
    1

    Default Re: Help with MySQL

    Code:
         $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
    Code:
         $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.

  6. #6
    Join Date
    Dec 2006
    Posts
    163
    Plugin Contributions
    1

    Default Re: Help with MySQL - porting moneybookers mod from other site

    Help, Wimper.

  7. #7
    Join Date
    Dec 2006
    Posts
    163
    Plugin Contributions
    1

    Default Re: Help with MySQL - porting moneybookers mod from other site

    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

  8. #8
    Join Date
    Apr 2004
    Location
    UK
    Posts
    5,821
    Plugin Contributions
    2

    Default Re: Help with MySQL - porting moneybookers mod from other site

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

  9. #9
    Join Date
    Jan 2007
    Posts
    92
    Plugin Contributions
    2

    Default Re: Help with MySQL - porting moneybookers mod from other site

    Quote Originally Posted by Dayo View Post
    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

  10. #10
    Join Date
    Jan 2007
    Posts
    92
    Plugin Contributions
    2

    Default Re: Help with MySQL - porting moneybookers mod from other site

    Just got the old Moneybookers module moved the files to the new places and it's working fine on 1.3.7
    MoneyBookers.zip

 

 

Similar Threads

  1. Replies: 6
    Last Post: 13 Nov 2014, 09:17 PM
  2. v151 Porting OsC mod
    By delia in forum General Questions
    Replies: 7
    Last Post: 19 Jun 2013, 05:31 PM
  3. Problems porting OSC Merchant Partners Mod
    By dbltoe in forum Built-in Shipping and Payment Modules
    Replies: 1
    Last Post: 15 May 2008, 07:33 PM
  4. Other than PayPal ? Moneybookers?
    By Francis-Axel in forum Basic Configuration
    Replies: 2
    Last Post: 26 Mar 2008, 11:37 AM
  5. OSC mod porting - more help please - another code problem
    By strelitzia in forum Contribution-Writing Guidelines
    Replies: 0
    Last Post: 31 Oct 2007, 07:34 PM

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
disjunctive-egg