public function __construct($query)
{
include_once 'database.php';
include_once 'functions.php';
include_once '../includes/configure.php';
include_once '../includes/database_tables.php';
include_once '../includes/functions/database.php';
tep_db_connect() or die('Unable to connect to database');
$this->query = $query;
$this->object_list = executeSQLtoArray($this->query);
tep_db_close();
}
function sendMessageToAdmin($message, $is_error_message, $exit = false)
{
global $SP_NECKERMANN_CATUPLOAD_ADD_SUPERVISORS;
$subject = 'NM.DE CAT UPLOAD ' . ($is_error_message ? 'ERROR' : 'SUCCESS');
$color = $is_error_message ? 'red' : 'green';
$message = '<div style="color:' . $color . ';">Messages on ' . date("d.m.Y H:i:s") . ' : <br/><br/>' . $message . '</div>';
//SEND EMAIL TO NM.DE CAT UPLOAD DEBUGGER
tep_mail(EMAIL_NAME_DEBUGR, EMAIL_ADDRESS_DEBUGR, $subject, $message, FROM_EMAIL_NAME, FROM_EMAIL_ADDRESS, false);
//SEND EMAIL TO NM.DE CAT UPLOAD ADDITIONAL SUPERVISORS
foreach ($SP_NECKERMANN_CATUPLOAD_ADD_SUPERVISORS as $supervisor_name => $supervisor_email) {
tep_mail($supervisor_name, $supervisor_email, $subject, $message, FROM_EMAIL_NAME, FROM_EMAIL_ADDRESS, false);
}
echo $message;
if ($exit) {
tep_db_close();
exit;
}
}
$check_result = tep_db_fetch_array($check_query);
$catalog_id = $check_result['jng_sp_catalog_id'];
$active_status = $check_result['active_status'];
} else {
$copy_counter++;
$cat_ids = $class_jc->addProduct($new_sp_id, $c['products_id']);
$catalog_id = $cat_ids[0];
$active_status = '0';
}
$sda = array();
if(array_key_exists($c['navigation'], $navtrans)) {
if($active_status=='0') {
$class_jc->activateProduct($catalog_id);
$active_counter++;
}
$sda['navigation'] = $navtrans[$c['navigation']];
}
$sda['status_price'] = '1';
//$sda['navigation3'] = 'female';
$class_jc->updateField($catalog_id, $sda);
$update_counter++;
}
echo "$update_counter Products is updated.";
echo '<br />';
echo "$copy_counter Products is copied.";
echo '<br />';
echo "$active_counter Products is activated.";
*/
tep_db_close();
function tep_exit()
{
tep_session_close();
tep_db_close();
die;
}
/**
* Links a product with a base category variation
*/
function createLinkToProduct($option, $value, $productId)
{
tep_db_connect() or die('Unable to connect to database');
$sql_array = array('options_id' => $option, 'options_values_id' => $value, 'products_id' => $productId);
tep_db_perform(TABLE_PRODUCTS_ATTRIBUTES, $sql_array);
tep_db_close();
}
<td> </td> <td> </td> <td> </td> </tr> <tr> <td class="no">7</td> <td>Quality</td> <td>Quality of all elements</td> <td class="no">100% Good</td> <td> </td> <td> </td> <td> </td> </tr> <tr> <td class="no">8</td> <td>Quality</td> <td>Quality of all beading/closing</td> <td class="no">100% Good</td> <td> </td> <td> </td> <td> </td> </tr> </table> </div> <div> </div> <? } ?> </div> </body> </html> <?php tep_db_close(); ?>
