Could use some help modifying createaccount.php for VTiger integration

[bob_p]

OK, I have an interesting dilemma. I would be more than happy to share this if it works, and I'll do the legwork, but I need some help figuring it out.

I have the VTiger Leads component integrated with ZC, allowing me to gather information into our CRM system from the site, but we are left with two instances of accounts, one in Vtiger and one in ZC. I would like to use the ZC to insert and maintain accounts in VTiger, and aside from the obvious problem of leads becoming contacts, I would rather have everything in one place.

The logic behind this is when the account is created, the create account action generates a lead in VTiger. The "activate" flag on the ZC account (I need to find the specific field) will set the table name for the account update when they modify their account. Here's the pseudo-process:

1) Visitor creates account in ZC. The createaccount.php file, once modified, will insert their information in the Leads database in VTiger.
2) The sales monkey will contact the person, and validate their account. Once verified, they will convert the Lead into a Contact in VTiger, and activate their ZC account.
3) If the user edits their account, and they are not activated, then the update is run against the VTiger lead table. If they ARE activated, the update is run against the VTiger Contact table.

From lines 292 to 305, here is the code where the SQL statement is built and run, either updating or inserting the account:

   $sql = "update " . TABLE_CUSTOMERS . "
              set customers_default_address_id = '" . (int)$address_id . "'
              where customers_id = '" . (int)$_SESSION['customer_id'] . "'";

    $db->Execute($sql);

    $sql = "insert into " . TABLE_CUSTOMERS_INFO . "
                          (customers_info_id, customers_info_number_of_logons,
                           customers_info_date_account_created)
              values ('" . (int)$_SESSION['customer_id'] . "', '0', now())";

    $db->Execute($sql);

I don't see anything in the code on this page that checks to see whether it should do an update or an insert, am I missing something? I see it would be pretty easy to add an additional SQL query to insert into VTiger or update, I just want to make sure that I have this right :)

Any help is appreciated, and like I said, if I get this working, I would be more than happy to share it.

Thanks,

Bob

[bob_p]

-Bump- Anyone?

[yellow1912]

Instead of modifying zc core code, you may want to have a look at this:
http://www.zen-cart.com/wiki/index.p..._API_Tutorials

[bob_p]

Thanks. I looked at this pile of docs, and while I did not mention it above, this is going to be done via an override, and not the core files themselves :) Thanks though for the warning, it is a lesson I learned the hard way in other areas I have been tinkering with :)

Still need help on this, I was not able to find the right place to make these changes....

I would be more than willing to share the fruits of this labor, to help others who are using Zen-Cart and VTiger :)

Thanks!

Bob

[maartenvonz]

Did you ever get this sorted?

Vtiger have now brought out their vtwsclib library (http://forge.vtiger.com/frs/download...wsclib-1.4.pdf ) so I presume some of the code included can now just be added to the Zen Cart code.

Is anybody wanting to work on this with me, and possibly create a public contribution?