Mysql stored procedure in out example punët

me interesan programadores de golang arduino php mysql node.js c++

See attachment. hfghjhgfghjhgfdsdgklkjhgfghjklknvbnmnbvcvbnm,.mnbvertyuytrertrghjugfdghjkjhgfdgkjhgfdfgjkjhg

...a new video is uploaded. Automatically play the newly uploaded video immediately after receiving the notification, using the configured streaming method (Direct Streaming or WebRTC). Audio Recording: If a user wants to speak, they can click the "Speak Now" button to: Pause video streaming. Open the microphone and start recording audio. Once recording is stopped, the audio file is uploaded and stored on the file server. Playback Resumption: After successfully storing the audio recording, check for any new videos uploaded via SignalR. If new videos are available, start streaming them immediately (using the configured method). Full-Cycle Functionality: Ensure the entire workflow—video streaming, audio recording, and new video notifications—works seamlessly. ...

I'm in need of a professional who can create a web-based data entry tool for a MySQL database. This tool will handle mixed data types: text and numerical. The primary functions of the tool will be to facilitate data input and conduct validation checks. See attached file for specifics. Key Requirements: - Proficiency in MySQL database management - Experienced in web-based application development - Prior work on data entry and validation tools - Understanding of both text and numerical data processing Please include examples of similar projects you've completed in your proposal. Thank you.

Hi Moufi K., We just noticed that you posted a project for "Development of a Virtual Employee (AI) for Building and Modifying Systems in Laravel, PHP, and MySQL" (https://www.freelancer.com/projects/php/Development-Virtual-Employee-for/details)

I'm seeking a proficient Python developer with substantial experience in web scraping, specifically in image extraction. - Data Type: The primary focus of this project is scraping images from various online sources. - Sources: The specific sites for scraping can be discussed and will be determined based on your expertise and suggestions. - Output Format: The images will need to be stored in a manner that can be discussed further, depending on the scale of the project. Ideal freelancer should have: - Proficiency in Python and web scraping libraries such as BeautifulSoup and Scrapy. - Previous experience in image scraping. - Ability to suggest optimal sources for image scraping. - Good communication skills for discussing project details and u...

...smooth integrations, and error handling. Key Requirements: // Expertise in WordPress and WooCommerce development. // Familiarity with Ultimate Affiliate Pro or similar affiliate marketing plugins. // Strong skills in PHP, MySQL, and WordPress plugin customization. // Ability to handle custom logic and conditional workflows. // Experience with dashboard UI customization. Additional Details: Specific details about the business model and affiliate structure will be shared after signing a Non-Disclosure Agreement (NDA). This project involves implementing both standard features and customizations to match unique business requirements. Desired Skills: // Proven experience with multi-tier affiliate systems. // Proficiency in PHP and WordPress hooks/filters. // C...

...panel. 3. Blog Page: A blog section where I can add, edit, and delete posts dynamically using an admin panel. The blog should support categories, tags, and a search function. Key Features Required: • Fully responsive design (desktop, tablet, and mobile). • Admin panel/dashboard for managing content (blog posts, contact form submissions, etc.). • Backend development with database integration (MySQL or similar). • Framework/Platform: [Specify your preferred framework, e.g., Laravel, Django, Node.js, or WordPress if dynamic features can be achieved]. • Basic SEO optimization for pages and blog posts. • Clean, maintainable, and well-documented code. Deliverables: • A complete dynamic website with admin panel access. • Source code and...

Purpose: Build a single-user web-based tool for personal property management, allowing the owner to track properties, units, tenants, rent payments, and maintenance requests. Key Goal: Have a minimal but complete system that you (the owner) can log into and manage all your property-related data—without the complexities of a multi-tenant or SaaS platform (that may come in a future phase). 2. Scope 1. Single-User Authentication • A single admin login (username/password). • Basic session or JWT-based security. 2. Property & Unit Management • Create, read, update, delete (CRUD) properties. • Each property has multiple units, also managed via CRUD operations. • Track status of units (occupied, vacant, under maintenance). 3. Tenant & Lease...

I need a MySQL stored procedure that calculates both the Exponential Moving Average (EMA) and the Simple Moving Average (SMA) for stock prices. Key Requirements: - The stored procedure should execute daily. - It should process stock prices data. Ideal Skills: - Proficiency in MySQL. - Experience in writing stored procedures. - Strong understanding of stock price data. - Familiarity with EMA and SMA calculations. The successful freelancer will have the opportunity to work on this project regularly as I need this procedure to run daily.

I need help configuring New Relic on my Linux server. The New Relic PHP agent is already installed, but I need help with monitoring MySQL and Apache. Key monitoring tasks: - MySQL: Performance metrics, Query analysis, Error tracking - Apache: General health and performance - Php performance data, average response time, max execution time in peaks, peaks of memory usage and how much memory is used then. - response data from third party applications monitored. Ideal candidates for this project should have extensive experience with New Relic, Linux servers, PHP, MySQL, and Apache. The ability to analyze and interpret performance data is essential.

I need a professional who can help synchronize my MySQL database with my Telegram mini app. This will allow my webapp users to validate their earnings accurately. Key Requirements: - Database Synchronization: You will be responsible for ensuring seamless communication between my MySQL database and the Telegram mini app. - MySQL Proficiency: A deep understanding of MySQL is crucial, as this is the platform currently in use. - Data Validation: The primary focus will be on validating users' reward points. Ideal Skills: Webapp: php Laravel backend, frontend Vue.js Tailwind CSS php frontend react - Expertise in Database Management - Proficient in MySQL - Experienced in working with Telegram Bots - Strong understanding o...

I must do a web application in wordpress. It must have a landing page stile, the payment of service, so creation of account, login and payment. It must have a form plugin to do questionnaire. At th eend of the questionnaire the AI must show a report baed on answers. The web must have a form plugin jotform) The job to do: make the landing pages with information of service, add the buy page of service and method of payment (you can use woocommerce); add jotform; integrate the questionnaire of jotform and the answer with AI to create the authomatic report. The questions of jotform and the answer of jotform must be saved inside my mysql database. So it is necessary create a plugin to create the tables and save the answer ad a plugin or code to to comunicate with an AI the plugi...

...public-facing platform where buyers can search for vendors, explore services, and engage in transactions securely. Key Features Service Listings Detailed service/product pages with descriptions, pricing, and availability. Quote Requests A system for buyers to request quotes and negotiate terms with vendors. Order Management Tools for tracking orders, payments, and project milestones. Communication Tools Built-in messaging and document-sharing between buyers and vendors. Reporting & Analytics Dashboards for both vendors and administrators to track performance metrics. Feature Planning Below are the core features to be defined in detail: User Roles Buyers (Research organizations, universities, laboratories): Sign up / Sign in Profile creation Service brow...

...name, department, position, contact information, etc.). Employee ID generation and profile picture upload. 2. Attendance Tracking: Daily attendance logging with check-in and check-out times. Monthly attendance reports and summaries. Integration with biometric systems (if feasible). 3. Leave Management: Employee leave request submission and approval workflow. Leave balance tracking and history for each employee. 4. Salary Slip Generation: Automated salary slip generation based on attendance and leave data. Options for HR to review and edit salary components (e.g., bonuses, deductions, etc.). Downloadable and printable salary slips in PDF format. 5. Employee Performance: Performance evaluation forms and ratings. Performance tracking dashboard for managers. Yearly/quar...

I'm looking for a Python expert who can help analyze our customer data. - The primary goal of this project is to derive insights from our customer data to drive business decisions. - The data is stored in databases, so experience with SQL and database management is a plus. - A strong background in data analysis and Python is essential for this project. Please include your relevant experience and examples of similar projects you've completed in your proposal.

Ju lutemi Regjistrohuni ose Identifikohuni për të parë të dhënat.

...develop this MVP from the ground up. You will be collaborating with our team to create a polished, functional product within a specified timeframe. Scope of Work Core Features: 1. User Platform: - Search and filter options based on location, category, and availability. - Booking and checkout system with guest and registered user options. - User account management (sign-up/sign-in). 2. Service Provider Platform: - Provider onboarding process with tools to list services, set schedules, and manage availability. - Dashboard for providers to view bookings, manage customers, and track payments. 3. Payment Integration: - Secure online payment gateway integration. - Offline payment approval process for providers. 4. Admin and Analytics:...

More details: What type of information do you want to delete? Personal Information How is the personal information stored on the webpage? Text entries Do you have proper authorization to delete this information? No This information needs to be deleted for reputation management. The webpage is a review site. I've already contacted the website administrator to request the removal of the information.

We are migrat...migrating data from our current ERP system (that is stored in an SQL database) to Microsoft Dynamics Business Central Cloud. The source database structures is different than Business Central. We have been able to reverse engineer both the databases and create ERD models and DDL scripts. Also we know how to create Dynamics APIs and use AL to interact with Dynamics. We are looking some consulting advice on how best migrate the data into dynamics. For example looking for ideas how to best table and field match, what software tools to use, best proccess etc for this ETL project. Please describe any experience you have with ETL/migrating data between different systems. Please add the word DYMANICS123 to the start of your proposal so we can weed out...

...user inputs in natural language. Continuous learning to improve over time based on user preferences. Development Scope: Backend: Frameworks like Node.js, PHP (Laravel), or Python. Frontend: Modern technologies like React.js, Vue.js, or others. Database management: MySQL, MongoDB, or equivalent. User Interaction: A user-friendly interface (web and mobile) where users can input tasks. Clear communication of progress and outputs. Deployment Automation: Ability to deploy finished systems to platforms like Heroku, Vercel, or custom servers. Visual Diagram: (Adjuntar un esquema como el que ya tienes donde se explique cómo interactuarán los componentes: React → Node.js Server → OpenAI, con las flechas y las tareas definidas). Proposal Requirements: Ple...

...help me connect my Node.js server to a MySQL database in a Kubernetes environment. The connection should utilize a connection pool. - Connection Type: The connection between the Node.js server and MySQL should be established using a connection pool. This means that multiple connections can be reused, improving the efficiency of data handling. - MySQL Operations: The majority of operations will be writing data to the database. Therefore, experience in optimizing write operations in MySQL will be beneficial. - Kubernetes Service: The Node.js server will be exposed using the ClusterIP service. Familiarity with this service and its configuration is crucial. Ideal candidates for this project should have: - Proven experience with Node.js and ...

...looking to hire an experienced OpenAI developer to help us build a custom content writing tool that will tailor its outputs to the specific writing styles of multiple clients. This tool will use OpenAI's language models (such as GPT-4) to generate content that is in line with the unique writing preferences and tone of each client. The goal is to create a system where, before generating content, users can select a client, and the tool will adjust its writing approach based on predefined client-specific parameters stored in a database. In addition, the tool should be able to learn and adapt its writing style over time by analyzing submitted content, allowing it to better understand and mimic each client’s voice. Since this is my first time using AI...

I need to install a page on my website, in PHP 8, where I can select an XLSX file and insert some data directly into the Mysql database. On this import page, in addition to inserting the xlsx file, I also add text to explain what it is about. (example in the link ) I tried doing something like the video above, but it didn't work. Database and rows: INSERT INTO Tablegroup (idgrupo, idplataforma, idpais, idestado, idcidade, idempresa, idusuario, idusuario_indicador, ididioma, membros, group_id, titulo, url, status, categoria, datacadgrupo) VALUES (NULL, '1', '2', '70', '0', '1', '7', '7', '1', '12312', NULL, 'Teste Delete', '', '1'...

...and drop documents and forms in addition to menu navigation importing. Ensure we do not lose this capability by employing too new version of OS or SuiteCRM software. Add capabilities: Email send/receive (standard for SuiteCRM send/receive capabilities) Currently, I cannot login to backend using admin username and pass. I see it there in the mySQL databases; I just can’t get it to login. I belive someone may have tinkered with the file. I would like to configure the databases to live on an additional server storage drive, not the same drive used for the website itself. It uses a Esxi virtualized VM. This way, the size of the website databases can expand without worrying about disk size. Once the install is complete, I will go through the CRM to add in...

...screen. - Users will log in using a personal number and password, both entered into text boxes. The password will be concealed with an asterisk. - The app will include a button to submit the login details, labelled "Anmelden". - There will be a copyright notice at the bottom of the screen, aligned to the right and in a font size smaller than 16. CSS: Background: #000 Font Color #fff Button Color: orange Authentication: - The app will utilize an NFC system for authentication, along with a clear username and password scheme. - Users will authenticate using a text-based password or NFC. Database: - The app will need to connect to a remote MySQL database. Ideal Skills: - Proficient in Android app development. - Experience with NFC technology. - Kno...

...nl/en/ . The website will be in English only. IT will have the same structure and text (We will edit the text later ourselves). The website will have two dynamic functionalities: 1. The website will include inventory page like this one, the system will have the following functionality: 1. Inventory system that will allow to add/remove or edit vehicles, upload photos, reorder and change other information on the page. Every vehicle that will be added will display a similar webpage: . Images will be stored under a folder in the web server. 2. Contact us box at the end of every page under the inventory 3. Select 3 vehicles in the inventory as newly added

...Option to attach multiple files to each manuscript (e.g., Word documents, PDFs, images, or transcription files). Each manuscript should have a unique identifier. Search and Filtering Search manuscripts by name, tags, or categories. Advanced filtering capabilities to refine results (e.g., filter by date, author, or multiple tags/categories). Support for partial matching and auto-complete suggestions in the search bar. File Management Users can upload files associated with manuscripts. File versioning: Allow multiple versions of related files for each manuscript, with the option to mark a version as "primary." Admins can delete outdated or irrelevant files. Provide previews of uploaded files (e.g., thumbnail for images, text preview for documents). User Management (Ad...

need to update a custom MySql CRM , with fixes at contact dashboard and create a new Pipeline Dashboard using database contacts. please check carefully the doc attached. regards

...lake house programming Experience in implementing at least 2 end-to-end data warehouse / data lake projects Experience in implementing at least 1 Azure Data warehouse / lake house project end-to-end Converted business requirements to concept / technical specification Worked along with source system experts in finalizing ETL and analytics design Support data modeler developer in design and development of ETLs Creation of activity plan as per the agreed concept with timelines Technical Expertise: Strong experience with Microsoft Azure components, including Azure Data Factory, Azure Synapse, Azure SQL Database, Azure Key Vault, MS Fabric, Azure DevOps (ADO), and Virtual Networks (VNets). Expertise in Medallion Architecture for Lakehouses and data modeling...

I must do a web application in wordpress. It must have a landing page stile, the payment of service, so creation of account, login and payment. It must have a form plugin to do questionnaire. At th eend of the questionnaire the AI must show a report baed on answers. The web must have a form plugin jotform) The job to do: make the landing pages with information of service, add the buy page of service and method of payment (you can use woocommerce); add jotform; integrate the questionnaire of jotform and the answer with AI to create the authomatic report. The questions of jotform and the answer of jotform must be saved inside my mysql database. So it is necessary create a plugin to create the tables and save the answer ad a plugin or code to to comunicate with an AI the plugi...

I'm in need of a seasoned full stack developer specialized in Laravel and Vue for creating a custom web application with a primary focus on data analytics and reporting. Key Responsibilities: - Develop a robust custom web application - Implement user management features - Integrate data analytics and reporting functionalities - Ensure seamless integration with various data sources Ideal Skills: - Proficiency in Laravel and Vue - Extensive experience in REST API development - Strong background in data analytics and reporting - Skilled in working with databases (e.g., MySQL, MongoDB) and APIs (e.g., REST, GraphQL) The project will involve integrating with multiple data sources, including databases and APIs. Experience with external da...

I must do a web application in wordpress. It must have a landing page stile, the payment of service, so creation of account, login and payment. It must have a form plugin to do questionnaire. At th eend of the questionnaire the AI must show a report baed on answers. The web must have a form plugin jotform) The job to do: make the landing pages with information of service, add the buy page of service and method of payment (you can use woocommerce); add jotform; integrate the questionnaire of jotform and the answer with AI to create the authomatic report. The questions of jotform and the answer of jotform must be saved inside my mysql database. So it is necessary create a plugin to create the tables and save the answer ad a plugin or code to to comunicate with an AI the plugi...

I need a VFX expert to recreate a car jumping out of the screen, similar to my reference video. This is intended for social media content, so it needs to be engaging and shareable. NEED: Blender files, rendered video donot need the arrow falling effects. only car. 1235 is the footage to be used. at 29.9fps budget is 40$ fixed Key Requirements: - Ability to create realistic visual effects - Experience with video compositing - Ability to replicate a specific reference video The ideal freelancer for this project would have a strong portfolio in VFX, particularly with realistic effects, and experience creating content for social media. Please be prepared to discuss and showcase your relevant work.

I'm looking for a seasoned backend developer skilled in , PostgreSQL, MySQL and SQL to collaborate with my frontend developer on a application. Your main task will be working on custom backend services. Experience in building and managing databases is crucial, as is the ability to seamlessly integrate with third-party APIs. Ideal Skills: - Proficient in - Experienced with PostgreSQL, MySQL and SQL - Able to develop custom backend services - Familiar with integrating third-party APIs - Great team player for collaborating with frontend developer

Im looking to update a MySql database used for CRM I need to fix some funytions on what I have and add a new PIPELINE dashboard please chec documentation, is very clear

I'm in need of a talented and experienced app developer with a strong background in healthcare applications. The project involves creating desktop and mobile apps compatible with both iOS and Android platforms. Key Features: - Appointment Booking System: The app should facilitate easy scheduling of appointments. - Patient Records Management: A secure and efficient system for managing patient records is crucial. - In-app Messaging: The app should include a secure and user-friendly messaging system for communication between patients and healthcare providers. Security Requirements: Given the sensitive nature of healthcare data, the applications must incorporate high-level security features: - Data Encryption: All data transmitted and stored should be encryp...

I'm seeking a skilled data scraper to extract stock prices from Yahoo Finance. The data should cover both the NYSE and NASDAQ. Key Responsibilities: - Scrape real-time and h...stock prices from Yahoo Finance. The data should cover both the NYSE and NASDAQ. Key Responsibilities: - Scrape real-time and historical stock prices from Yahoo Finance. - Implement data scraping in a way that it can be run periodically. - Store the scraped data into a MySQL database using "INSERT ON DUPLICATE KEY UPDATE" to handle potential duplicates. Ideal Skills: - Proven experience in web scraping, particularly finance data. - Strong knowledge in MySQL and data management. - Familiarity with Yahoo Finance and stock market data. Please bid if you can provide...

I need a skilled developer to create a few modules based on existing HTML/PHP code. The modules should facilit...No Access - User Module: - Similar to the Roles & Permissions module, but with user-specific data - A table displaying users with columns for NO, USERNAME, EMAIL, ROLES, DATE CREATED, and ACTION - Manual role assignment for each user Ideal Skills & Experience: - Proficient in HTML/PHP code and MYSQL - Experience with role and permission management systems - Strong understanding of User Interface design - Ability to work with pre-existing code and design Please note that the 'Action' column in the tables should have buttons for Edit and Delete, but the specific user actions to track have not been defined yet. The developer wil...

I'm seeking a talented programmer to develop an algorithm capable of filtering all 5000 stocks in the Indian market and various cryptocurrencies based on specific technical indicators. This project focuses on key metrics: 'Volume' and 'Value per Minute'. Key Requirements: - Proficiency in algorithm development and stock market analysis - Experience with programming languages such as Python, R, or similar - Familiarity with technical indicators, particularly 'Volume' and 'Value per Minute' - Understanding of the Indian stock market and cryptocurrency landscape Your task will be to build a robust algorithm that can efficiently sift through vast data sets, providing insights and filtering stocks and crypto according to the specified...

I'm in need of a service that can provide an image, a definition, and an example sentence for a significant number of words (more than 100). This is for the American Language Course, which is a book used to teach English to international military students. These words will be provided by me in sections. I have attached an PowerPoint example for section 7.1. Key Requirements: - Ability to source or create suitable images for each word. Any type of image is acceptable (stock images, custom illustrations, etc.) just as long as it appropriately represents the word. Preferably realistic. ChatGPT works. - Strong understanding of language to craft clear, concise definitions and example sentences. - Creativity and resourcefulness in finding or crea...

...site needs to be developed with: - React.js for the frontend - Node.js for the backend - MySQL as the database Incorporate cutting-edge technologies such as , TypeScript, RESTful APIs, GraphQL, and JWT-based authentication to ensure a modern, scalable, and secure solution. Key Features of the Website: - User registration, login, and subscription plans based on different tiers. - Advanced carbon calculation mechanisms influenced by distance-based methods and EF databases. - Data visualization primarily using pie charts and report generation capabilities. - An intuitive admin panel for overseeing emission factors and user data. The ideal candidate for this project should have: - Proficient expertise in the stated technologies. - A track record of delivering responsive, ef...

I'm seeking a skilled commercial architectural drafter to assist with creating detailed floor plans for a beauty salon design. Deliverables: - Comprehensive floor plans tailored for beauty salon Ideal Skills: - Proficiency in architectural drafting - Experience in designing for retail spaces - Ability to create precise and detailed floor plans

I'm looking for a design for a portable LED makeup light. Key details: - Power: The light will need to operate on AC 110/220V. - Design: It should be portable and practical for makeup application. - Usage: The light will primarily be used indoors. - Brightne...will need to operate on AC 110/220V. - Design: It should be portable and practical for makeup application. - Usage: The light will primarily be used indoors. - Brightness Lumens 400-1400 - 5000-6500k - Adjustable Brightness - CRI 95+ Ideal skills for this project would include experience in lighting design, knowledge of AC power systems, and an understanding of makeup application needs. This will be a portable device. Each strip adhere to a mirror using suction cups. The device will be folded stored in...

...exam papers in both PDF and DOC formats into a structured CSV file. The exam papers consist of multiple subjects and contain different types of questions, including multiple-choice questions (MCQs) and fill-in-the-blank questions. Detailed Requirements: - Exam Paper Structure: - Section 1: 20 multiple-choice questions (MCQs) with one correct answer. - Section 2: 5 fill-in-the-blank questions with solutions. - Desired CSV Format: - The CSV should have the following columns: question_type, question, option1, option2, option3, option4, solution, correct_option. - Image Handling: - For questions with images, I need the image URLs included in the CSV. - Storage: - All cropped images need to be stored in an S3 bucket. Ideal Skill...

I am seeking a proficient developer to create a high-quality mobile application that will digitize the CSS process. This application will be pivotal in facilitating real-time secure data collection, automatically geo-tagging surveys, and incorporating tamper-proof features to prevent data manipulation. Key Features: - Dynamic questionnaire customization for different locations - Automated report generation in Excel and PDF formats - Utilization of AI/ML tools to flag potential falsifications, ensuring high data integrity - Post-deployment scalability to incorporate new survey categories - Seamless integration capabilities The app should be compatible with both iOS and Android platforms. Although the specific users of the app have not been defined yet, it should be intuiti...

I need a seasoned programmer with expertise in Python and MySQL to convert a segment of my existing PHP Telegram bot code into Python. Specific Requirements: - The primary focus is on translating the broadcast functionality. - The bot should be capable of sending broadcasts based on user-specified times. - Ideally, the freelancer should be able to understand Hindi as the bot is designed for Hindi speakers. Skills & Experience: - Proficient in Python and MySQL. - Prior experience with Telegram bot development. - Able to understand and translate PHP code to Python. - Understanding of Hindi is a plus.

I am looking to develop an advanced AI-powered virtual assistant that will act as a virtual employee, specializing in the creation and modification of complete systems and applications. This assistant should function as a professional developer with the following main capabilities: System and Application Development: Automated development of complete systems using technologies such as Laravel, PHP, and MySQL. Front-end interface generation using modern technologies like HTML, CSS, and JavaScript. Modification and Maintenance: Ability to perform advanced modifications to existing systems with high efficiency and professionalism. Adapt to specific requirements based on business needs. Key Features of the Assistant: Continuous learning capability: The AI should improve its p...

...should focus primarily on the system's usability and ease of access. Key areas to highlight in your design include: - User interface and controls: The design should clearly illustrate how a user would interact with the system. - Loading and unloading process: Visuals should depict how bicycles are stored and retrieved. - Accessibility for all user types: The system should be designed with inclusivity in mind. The overall visual style should be 'modern and sleek'. You might also want to consider how to balance this with clear, easy-to-understand visuals that communicate the accessibility and usability of the system. Ideal candidates will have a strong background in graphic design, with experience in creating user-focused designs. Fa...

I'm looking for a seasoned web developer to creat...Catalog: The site needs to showcase a variety of products in an organized and user-friendly manner. - Shopping Cart: A seamless shopping cart experience is crucial, allowing users to effortlessly add, remove and modify their selections. - Payment Gateway Integration: The site should be integrated with reliable and secure payment gateways to facilitate smooth transactions. Ideal Skills: - Extensive experience in custom E-commerce website development. - Proficiency in relevant web development languages and technologies. - Familiarity with secure payment gateway integrations. - Ability to create a user-friendly product catalog and shopping cart. I also need a separate site that can hold profiles linked to NFC car...