Save to another table
- activha
- ONLINE
-
Platinum Member
- Posts: 2275
- Thanks: 113
- Karma: 13
1 year 8 months ago - 1 year 8 months ago #330202
by activha
Save to another table was created by activha
Hello
I have a question concerning CB Autoaction and CB activity
As you advised some months ago we use this code in an anautoaction to save data in CB activity :
The code works fine but we would like to save the data si_company_id to another table than #_comprofiler_plugin_activity for our needs, say the table #__activations in the field company_number
The issue is that whatever php code we insert in the above auto action in a new line, this code does not save the data.
we tried in a new php line :or
But both codes do nothing nor return any error.
Is there a specific way with CB autoaction to save to another table ?
I have a question concerning CB Autoaction and CB activity
As you advised some months ago we use this code in an anautoaction to save data in CB activity :
//todo find group for any activation
//default cat to pro 0 group 55 and event to negopack 26 group 26
$v_cat = $user->cb_activ_cats != 0 ? $user->cb_activ_cats : 0;
$v_event = $user->cb_marketevents > 0 ? $user->cb_marketevents : 26;
$v_group = $v_event != 26 ? 56 : 55;
$variables['var3']->params()->set( 'activ', htmlspecialchars($input->getString( 'activ' )) );
$locationId = '1';
$locationPlace = htmlspecialchars($input->getString( 'si_place' ));
$lat = htmlspecialchars($input->getString( 'si_lat' ));
$long = htmlspecialchars($input->getString( 'si_long' ));
$locationAddress = $lat . ',' . $long;
$newLocation = array('id' => $locationId,'place' => ( $locationId ? $locationPlace : '' ),'address' => ( $locationId ? $locationAddress : '' ));
$variables['var3']->params()->set( 'location', $newLocation );
$variables['var3']->params()->set( 'data-company-id', htmlspecialchars($input->getString( 'si_company_id' )) );
$variables['var3']->params()->set( 'category', $v_cat );
$variables['var3']->params()->set( 'event',$v_event);
$variables['var3']->set( 'asset', 'activha.group.' . $v_group . '.event.' . $v_event . '.activation.[var3_user_id]' );The code works fine but we would like to save the data si_company_id to another table than #_comprofiler_plugin_activity for our needs, say the table #__activations in the field company_number
The issue is that whatever php code we insert in the above auto action in a new line, this code does not save the data.
we tried in a new php line :
$company_number = 'test';
$enrich_company = 'test';
$values = array($db->quote($company_number),$db->quote($enrich_company) );
$query->insert($db->quoteName('#__activations'));
$query->columns($db->quoteName($columns));
$query->values(implode(',', $values));
$db->setQuery($query);
$db->execute();$si_company_id = 'test';
$enrich_datas = 'test';
$query = "INSERT INTO #__activations(company_number, enrich_company) VALUES(\"".$db->quote($si_company_id)."\",\"".$db->quote($enrich_datas)."\")";
$db->setQuery( $query);
$db->Query();But both codes do nothing nor return any error.
Is there a specific way with CB autoaction to save to another table ?
Last edit: 1 year 8 months ago by activha.
Please Log in to join the conversation.
krileon
Team Member- ONLINE
- Posts: 68504
- Thanks: 9083
- Karma: 1434
1 year 8 months ago #330203
by krileon
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Replied by krileon on topic Save to another table
I cannot help you with custom coding. There is nothing specific in CB Auto Actions to prevent saving to external databases. Most likely your code is not valid if it's not running. You're calling $db, but it's not defined anywhere in your code. Same with $query.
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Please Log in to join the conversation.
- activha
- ONLINE
-
Platinum Member
- Posts: 2275
- Thanks: 113
- Karma: 13
1 year 8 months ago #330204
by activha
Replied by activha on topic Save to another table
yes of course we defined it but no results :
This code is standard to joomla so what did we miss with CB ?
$db = JFactory::getDBO();
$si_company_id = 'test';
$enrich_datas = 'test';
$query = "SELECT `company_number` FROM #__activations where `company_number` = ".$si_company_id;
$db->setQuery( $query );
$resultRow = $db->loadResult();
if (!$resultRow) {
$query = "INSERT INTO #__activations(`company_number`, `enrich_company`) VALUES(\"".$db->quote($si_company_id)."\",\"".$db->quote($enrich_datas)."\")";
$db->setQuery( $query);
$db->Query();
else {
$query = "UPDATE #__activations SET `enrich_company` = \"".$db->quote($enrich_datas)."\" where `company_number` =\"".$db->quote($si_company_id)."\" ";
$db->setQuery( $query);
$db->Query();
}This code is standard to joomla so what did we miss with CB ?
Please Log in to join the conversation.
- krileon
- Team Member
- ONLINE
- Posts: 68504
- Thanks: 9083
- Karma: 1434
1 year 8 months ago #330205
by krileon
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Replied by krileon on topic Save to another table
Again, nothing in CB is going to prevent it from running. Be sure your code is completely functional before running it through CB Auto Actions. You can also try turning on debug mode, but it's only going to catch top level fatal errors as it's not meant to debug your custom code. I would start by making sure your queries work by testing them manually in phpmyadmin.
It seams like you can also replace your custom PHP with a Query action and just directly doing your query there by consolidating your INSERT/UPDATE if statement into an ON DUPLICATE query as described below.
dev.mysql.com/doc/refman/5.7/en/insert-on-duplicate.html
It seams like you can also replace your custom PHP with a Query action and just directly doing your query there by consolidating your INSERT/UPDATE if statement into an ON DUPLICATE query as described below.
dev.mysql.com/doc/refman/5.7/en/insert-on-duplicate.html
Kyle (Krileon)
Community Builder Team Member
Before posting on forums: Read FAQ thoroughly + Read our Documentation + Search the forums
CB links: Documentation - Localization - CB Quickstart - CB Paid Subscriptions - Add-Ons - Forge
--
If you are a Professional, Developer, or CB Paid Subscriptions subscriber and have a support issue please always post in your respective support forums for best results!
--
If I've missed your support post with a delay of 3 days or greater and are a Professional, Developer, or CBSubs subscriber please send me a private message with your thread and will reply when possible!
--
Please note I am available Monday - Friday from 8:00 AM CST to 4:00 PM CST. I am away on weekends (Saturday and Sunday) and if I've missed your post on or before a weekend after business hours please wait for the next following business day (Monday) and will get to your issue as soon as possible, thank you.
--
My role here is to provide guidance and assistance. I cannot provide custom code for each custom requirement. Please do not inquire me about custom development.
Please Log in to join the conversation.
Moderators: beat, nant, krileon
Time to create page: 0.190 seconds
-
You are here:
- Home
- Forums
- Support and Presales
- Developer Members Support
- Save to another table