// 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();