// iii 030813 added: File uploading: save uploaded files with unique file names
$real_ids = $_POST['id'];
if ($_GET['number_of_uploads'] > 0) {
require DIR_WS_CLASSES . 'upload.php';
for ($i = 1, $n = $_GET['number_of_uploads']; $i <= $n; $i++) {
if (zen_not_null($_FILES['id']['tmp_name'][TEXT_PREFIX . $_POST[UPLOAD_PREFIX . $i]]) and $_FILES['id']['tmp_name'][TEXT_PREFIX . $_POST[UPLOAD_PREFIX . $i]] != 'none') {
$products_options_file = new upload('id');
$products_options_file->set_destination(DIR_FS_UPLOADS);
if ($products_options_file->parse(TEXT_PREFIX . $_POST[UPLOAD_PREFIX . $i])) {
$products_image_extention = substr($products_options_file->filename, strrpos($products_options_file->filename, '.'));
if ($_SESSION['customer_id']) {
$db->Execute("insert into " . TABLE_FILES_UPLOADED . " (sesskey, customers_id, files_uploaded_name) values('" . zen_session_id() . "', '" . $_SESSION['customer_id'] . "', '" . zen_db_input($products_options_file->filename) . "')");
} else {
$db->Execute("insert into " . TABLE_FILES_UPLOADED . " (sesskey, files_uploaded_name) values('" . zen_session_id() . "', '" . zen_db_input($products_options_file->filename) . "')");
}
$insert_id = $db->Insert_ID();
$real_ids[TEXT_PREFIX . $_POST[UPLOAD_PREFIX . $i]] = $insert_id . ". " . $products_options_file->filename;
$products_options_file->set_filename("{$insert_id}" . $products_image_extention);
if (!$products_options_file->save()) {
break 2;
}
} else {
break 2;
}
} else {
// No file uploaded -- use previous value
$real_ids[TEXT_PREFIX . $_POST[UPLOAD_PREFIX . $i]] = $_POST[TEXT_PREFIX . UPLOAD_PREFIX . $i];
}
}
}
$_SESSION['cart']->add_cart($_POST['products_id'], $_SESSION['cart']->get_quantity(zen_get_uprid($_POST['products_id'], $real_ids)) + $new_qty, $real_ids);
$sql = "insert into " . TABLE_CUSTOMERS_INFO . "\r\n (customers_info_id, customers_info_number_of_logons,\r\n customers_info_date_account_created)\r\n values ('" . (int) $_SESSION['customer_id'] . "', '0', now())";
$db->Execute($sql);
// Do phpBB stuff here
// use separate db connection with details from phpBB config file
if ($sniffer->phpBB['installed'] == true) {
// require($sniffer->phpBB['phpbb_path'] . 'config.php');
$db_phpbb = new queryFactory();
$db_phpbb->connect($sniffer->phpBB['dbhost'], $sniffer->phpBB['dbuser'], $sniffer->phpBB['dbpasswd'], $sniffer->phpBB['dbname'], USE_PCONNECT, false);
$sql = "select max(user_id) as total from " . $sniffer->phpBB['users_table'];
$phpbb_users = $db_phpbb->Execute($sql);
$user_id = $phpbb_users->fields['total'] + 1;
$sql = "insert into " . $sniffer->phpBB['users_table'] . "\r\n (user_id, username, user_password, user_email, user_regdate)\r\n values\r\n ('" . (int) $user_id . "', '" . $nick . "', '" . md5($_POST['password']) . "', '" . $email_address . "', '" . time() . "')";
$db_phpbb->Execute($sql);
$sql = "INSERT INTO " . $sniffer->phpBB['groups_table'] . " (group_name, group_description, group_single_user, group_moderator)\r\n\t\t\t\tVALUES ('', 'Personal User', 1, 0)";
$db_phpbb->Execute($sql);
$group_id = $db_phpbb->Insert_ID();
$sql = "INSERT INTO " . $sniffer->phpBB['user_group_table'] . " (user_id, group_id, user_pending)\r\n\t\t\t\tVALUES ({$user_id}, {$group_id}, 0)";
$db_phpbb->Execute($sql);
$db->connect(DB_SERVER, DB_SERVER_USERNAME, DB_SERVER_PASSWORD, DB_DATABASE, USE_PCONNECT, false);
}
// End phppBB stuff
if (SESSION_RECREATE == 'True') {
zen_session_recreate();
}
$_SESSION['customer_first_name'] = $firstname;
$_SESSION['customer_default_address_id'] = $address_id;
$_SESSION['customer_country_id'] = $country;
$_SESSION['customer_zone_id'] = $zone_id;
$_SESSION['customers_authorization'] = $customers_authorization;
// restore cart contents
$_SESSION['cart']->restore_contents();
