Run multiple mysql database queries php send xml jobs

I've got a list of company names on an Excel sheet that I need you to help me with. Here's how you can assist: - **Scraping from Multiple Platforms**: I need you to scrape email addresses, phone numbers, and any available social media accounts of these companies. You'll need to do this across Yelp, Google Maps, and TripAdvisor. - **Social Media Scraping**: In addition to the primary two platforms (Instagram and Twitter), I'll also need you to scrape Facebook accounts if available. Ideal candidates for this project should have: - **Web Scraping Experience**: A good knowledge of web scraping techniques and tools, which will ensure you can obtain accurate and reliable data. - **Data Mining Knowledge**: The ability to identify and extract the necessary data points...

I am looking for an experienced PHP developer to help me domify some software. Specifically, I need an inventory management system built from raw PHP. Key Features: - Inventory management: I need a system that can help me keep track of my inventory in real-time. This system should be able to handle multiple products and update their status as needed. Current Inventory Management: I am currently using another software to manage my inventory. However, it does not meet my needs and I am looking for a more tailored solution. Ideal Skills: - Strong proficiency in PHP - Experience with building Inventory Management Systems - Knowledge of raw PHP If you have experience in building similar systems, I would love to hear from you.

.../api/book/{page}, etc., to handle requests and return the corresponding data. Database: Setup of a database (e.g., MySQL, PostgreSQL) to store the book data. Creation of scripts to regularly update the database with new information. Automatic Data Updating: Implementation of mechanisms to collect and integrate new information from various sources (e.g., web scraping, other APIs). Ensuring that the database is regularly updated to provide current information. Required Skills: Experience in web development with modern technologies (HTML, CSS, JavaScript). Experience with web frameworks like Django, Flask, , or similar. Knowledge in API development and integration. Experience with databases and database management. Good communication skills and ...

I am in need of a skilled Java developer to create a comprehensive CRUDS (Create, Read, Update, Delete, Search) functionality for a ticket tracker application. The application should be backed by a MySQL database.

...freelancer to develop and implement a robust outgoing predictive dialer system for our call center operations. The ideal candidate will have a strong background in telephony systems, database management, and CRM integration. The dialer should support dynamic caller ID, IP whitelisting, multiple campaigns, and a minimum of 10 representatives. **Responsibilities:** - Develop an outgoing predictive dialer system that integrates with our existing telephony infrastructure. - Implement dynamic caller ID functionality. - Ensure the system supports IP whitelisting for added security. - Configure the dialer to handle multiple campaigns simultaneously. - Integrate a basic CRM to manage and search client information efficiently. - Ensure the system can support a minimum of 1...

I'm in need of a skilled programmer who is proficient in PHP and WordPress. The specific task I have on hand is integrating an API into my WordPress website. I'm looking for an individual with the right mix of expertise and experience to help me achieve this. Please make sure you have the following skills before applying: - Proficiency in PHP - Previous experience with WordPress - Experience in API integration If you think you have what it takes, please apply and provide details of your relevant experience.

I'm seeking professional help to rectify a problem with one of my programmes which is presently operational on a Windows 8.1 environment but doesn't launch on Windows 11. I'm not certain about the original coding language as I skipped that question, making it necessary for the freelancer to have adept skills in multiple languages, mainly in C++, Java, and Python. I'm also unsure about specific software or hardware dependencies that might be influencing the situation. However, the freelancer must have the expertise to identify and handle this potentiality. As for specific program functions, the user left a gap as well, so an experienced developer in generic software protocols and universal functions would be highly appreciated. However, the freelancer needs to...

I require someone experienced in Linux server management to help optimize the performance of my server. Linux Server Performance Optimization Plesk Obsidian, SQL, PHP Key Responsibilities: - Review the current server setup and performance - Identify areas for improvement - Implement solutions to optimize server performance - Fix the 2 errors. This is not a one-time setup; I may require ongoing management based on the initial optimization results. Your expertise in Linux server management is crucial to this project.

I'm seeking a talented audio engineer to mix and master my pop Hindi song. Key Project Details: - Genre: Pop - Audio Quality: The final mix and master should be in WAV format. - Vocal Tracks: There are 10 vocal tracks in the song. Skills and Experience: - Proven experience in mixing and mastering pop songs. - Experience in working with multiple vocal tracks. - Proficiency in audio editing software. - Understanding of Indian music genre preferences is a plus, but not required.

See attached detailed description of project. Ideal Skills: - Proficient in pHp 8 - Extensive experience in database integration, particularly with MySQL® - Strong problem-solving skills - Attention to detail and thorough testing - Previous experience with file processing in pHp I'm looking for a professional who can work efficiently and deliver high-quality results. If you believe you possess the necessary skills and experience for this project, I look forward to reviewing your bid.

I'm seeking a skilled web developer to update my current PHP website admin interface to utilize the Bootstrap 4 admin theme. The primary purpose of this admin section is to manage content, so I'm particularly interested in revamping the forms and input fields. Key requirements include: - Update of the existing admin interface to Bootstrap 4 admin theme - Focus on enhancing the forms and input fields - Implementation of data validation within the forms The ideal candidate for this project should have: - Proficient in PHP and Bootstrap - Prior experience in revamping website admin interfaces - Strong understanding of data validation techniques - A good eye for user-friendly design Your task will be to seamlessly integrate the Bootstrap 4 admin theme and ensure that...

We are looking for a developer experienced in working with the Solana network and trading bots, with a mandatory requirement of being knowledgeable about the Pumpfun platform. Responsibilities: Create a bot/tool to manage trading from multiple wallets on the Pumpfun platform. Enable the bot to generate multiple wallets. Configure Solana quantities to buy per wallet. Develop an auto buy and sell bot to make a project appear legitimate with many sales and buys, thereby boosting projects. Ensure speed execution on the first buys to avoid snipers. The initial buys will be made from different wallets in varying quantities, with all transactions going through simultaneously or with a few seconds' difference. Allow for auto-tipping and prioritization in fees. Enable P&L vi...

I am seeking a creative ad designer who specialises in Facebook advertising. The aim is to produce an advert which can be translated into multiple languages to target different countries. The ad is for a downloadable video course, for those whose native language is not English, teaching what to say in a job interview in English. Predominantly my market would be working professionals aged between 25 and 50 who are likely to have to attend job interviews in English. Main tasks would be : - Creating an engaging Facebook ad - zeroing in on target group of potential customers (possible later task) - designing an effective landing page for ad clicks current page (in Italian) can be found at I can

I need an email validator that validates multiple emails, preferably done in C#. As stated above, I need a system that validates whether the email exists or not. The system must be practical and easy and must have a license management system, which I can generate. I want only people who pay some plan for the system to be able to use the software.

I am seeking an experienced digital marketing professional who can effectively handle multiple areas of digital marketing. This includes: - SEO: Enhancing the visibility and ranking of my website on search engines. - SEM: Implementing strategies that increase the reach and visibility of my ads. - Social Media Marketing: Creating engaging and shareable content for various social media platforms to build strong relations with the audience and increase followers. - Blogging: Producing high-quality blog posts to engage readers and increase site traffic. - Web Editing: Tweaking and enhancing the website for a more user-friendly experience and better SEO performance. - Email Marketing: Developing and managing effective email marketing strategies to boost customer engag...

I'm seeking a professional web developer, extremely proficient in PHP and MySQL who can add and upgrades modules into our POS system. - Abilities: You should have substantial experience and demonstrated proficiency in building complex, user-friendly websites. Your PHP and MySQL skills must be exemplary. - Preferred Framework: I don't have a particular PHP framework preference. You can use the one you're comfortable with.

As a fresher-friendly employer, I'm looking for a web designer with knowledge of PHP. Your task is to craft a comprehensive online portfolio for me. Key Requirements: - The portfolio must have a user-friendly, aesthetically pleasing design. - I need a contact form integrated for potential clients to easily reach out. - An image gallery to showcase my work is essential. - A testimonials section is needed to display feedback from my clients. The site must be professionally designed, with no less than 10 pages. You're welcome to suggest additional features that could enhance the site's performance. Ideal Skills: - Proficiency in web design and development. - Strong command of PHP. - Experience in creating dynamic and appealing portfolios. - Familiarity with...

...3D designer to create a highly detailed and customizable 3D model of a chair for our e-commerce website. The model should allow users to configure various elements such as textures, chair legs, and other features in real-time on our site. Requirements: Model Specifications: A highly detailed 3D model of a chair. Different textures and materials for customization (e.g., fabric, leather, wood). Multiple chair leg options (e.g., wooden, metal, various designs). UV unwrapped and properly textured for high-quality rendering. Technical Requirements: Formats: FBX, OBJ, and any other formats compatible with web-based 3D viewers. PBR Texturing: BaseColor, Normal, Roughness, and Metalness maps. Optimization for real-time rendering (low-poly options if necessary). Ensure compatibility wit...

I've been trying to validate my YouTube channel with multiple phone numbers, but it seems impossible. The channel mainly focuses on gaming content. I'm looking to hire a freelancer to help me with this issue. Ideal Skills and Experience: - Previous experience with YouTube channel verification - Strong understanding of YouTube's verification process - Knowledge of YouTube's policies and guidelines Looking forward to your bids.

I'm looking for a skilled Shopify Public App developer to create an app for my business. The app should have the following features: - Custom Order Date Options: The ability to include unique Delivery Date options and configurations on my Shopify store. - Advanced Pickup: a customer chooses a pickup location to pick up her/his order and also uses third-pa...API for pincode verification for pincode included or excluded for the delivery As a successful freelancer, past work is crucial. Please include examples of previous Shopify Public Apps you've developed or similar projects you have completed. This will give me a better understanding of your expertise in this area. Require Technology -> Node.js -> React.js -> Javascript -> jQuery -> REST API -> MySQL...

I urgently need assistance with installing a PHP application on my dedicated Linux server. Key requirements: - Expertise in server management, particularly dedicated servers - Proficiency in PHP application deployment - Strong knowledge of Linux operating systems Please only bid if you have significant experience in this area and can start immediately. Your prompt help is highly appreciated.

I urgently need assistance with installing a PHP application on my dedicated Linux server. Key requirements: - Expertise in server management, particularly dedicated servers - Proficiency in PHP application deployment - Strong knowledge of Linux operating systems Please only bid if you have significant experience in this area and can start immediately. Your prompt help is highly appreciated.

I'm in need of a skilled UI/UX designer proficient in wireframing, prototyping, and conducting user research. You will be working in accordance with our existing brand guidelines, ensuring a seamless integration of the new designs into our brand image. This is a bit of a dual platform job as you will be designing for both desktop and mobile interfaces. Experience in designing for multiple platforms is much desired. A sharp eye for detail and ability to create user-friendly, engaging design are the key skills needed for this project.

I'm in need of a 3D artist who can create a basic product model for me. This model should be able to be viewed from different angles. Key Requirements: - The project involves product modeling, so experience in this area is essential. - The model needs to be created with basic shapes and forms. No complex detailing or textures are needed. - You must be able to generate multiple views of the model, allowing me to see it from different perspectives. Ideal Skills and Experience: - Proficiency in 3D modeling software, such as Blender, Maya, or 3ds Max. - A strong portfolio demonstrating previous experience with product modeling. - A keen eye for detail and the ability to follow design specifications accurately. - Excellent communication skills to ensure my requirements are met eff...

I'm looking for an Indian professional WordPress developer who can help me with a couple of issues on my site. Key Requirements: - Fixing a bug causing the website to load slowly. - Enhancing website speed by employing appropriate techniques. Specifics: - The main issue I ...optimizations should be applied to the homepage as a top priority, but I also require this across other pages of the site. Ideal Skills and Experience: - Proficiency in WordPress development and bug fixing. - Experience in optimizing website speed, including image and media optimization, content caching, and server response time reduction. - Proven track record of improving website performance across multiple pages, with a keen eye for detail and thorough testing. Please share your relevant experienc...

I'm seeking a skilled designer who can create a multiple business logos from WWII era vintage-styled military art combined with modern day technology. It should be crafted in color, eliciting a classic yet modern feel. If you specialize in vintage designs and or blending multiple design elements together, this project may be an excellent fit for you. Key skills required: - Expertise in vintage logo designs - Creativity in using abstract geometric shapes - Ability to work with color palettes.

I need a clean, professional Wordpress website created for my brand. It must be simplistic, user-friendly, and designed to cater to B2B customers. The primary purpose of this website is to serve as a platform for displaying multiple products from our brand. There will be no ecommerce functionality - it's more about showcasing the products than selling them. Here's what I'm looking for: - A simplistic, easy to use layout that still looks professional - A design that specifically caters to B2B customers - The ability to display a variety of products without overwhelming visitors - A responsive design that looks good on all devices - SEO-friendly structure and content Ideal Skills: - Proficiency in Wordpress and its themes - Experience in creating B2B websites - Desi...

I'm seeking a seasoned logo designer to create an iconic/symbol representation logo for my brand. Ideal Skills and Experience: - Extensive experience in logo design - Expertise in using color psychology in design Specific Requirements: - The logo should serve multiple purposes, including brand identity, marketing materials, and website use. - The color scheme is already decided, but you need to have an understanding of color matching and visual appeal. - You should be able to create a visually captivating, yet simple, iconic/symbol representation logo. - An understanding of my brand and vision is essential to create a logo that reflects our values and appeals to our target audience. In your proposal, please feature past examples of iconic logo design and demonstrate how you...

...Develop and implement comprehensive lead generation strategies using Google Ads and Facebook Ads. Conduct market research to identify target audiences and create detailed customer personas. Set clear objectives and KPIs for each campaign to measure success. Ad Creation and Management: Design, write, and test compelling ad copy and creatives tailored to various audience segments. Set up and manage multiple ad campaigns across Google Ads (Search, Display, YouTube) and Facebook Ads (Feed, Stories, Audience Network). Utilize advanced targeting techniques, including demographic, behavioral, and geographic targeting. Optimization and Analysis: Monitor and analyze campaign performance data to identify trends and insights. Perform A/B testing to continually refine ad copy, creatives, a...

...And then next, he is prompted to enter the number of wallets he want to perform the transactions from. And how much capital to include for each wallet. And the bot generates that number of wallets. He can connect his main wallet by using private key. And the bot will transfer the amount specified by the admin to all the wallets. And performs buy, sell. It should use jito bundle for performing multiple rotating transactions for buy and sell. It should perform buy, sell simultaneously. And the admin can set for how much time it should perform the transactions. And the admin have power to stop it whenever he wants to stop the bot. When the bot is about to stop. It stops all the transactions, sell the remaining coins, swap it to usdt, or usdc, and transactions all the funds from al...

...required for standardized documentation. Support in all pharmacovigilance operations associated with medical writing. Continuous self-education in all aspects associated with medical writing. Managing a team of junior medical writers. Qualifications: Previous experience of pharmacovigilance medical writing, including PBRERs, DSURs, RMPs writing. Pharmacist or MD, life science MD. Ability to manage multiple and varied tasks and prioritize workload with attention to detail. Ability to effectively train and mentor Associate Medical Writers. Advanced knowledge of English. Additional Information: PrimeVigilance prioritizes diversity, equity, and inclusion by creating an equal opportunities workplace and a human-centric environment where people of all cultural backgrounds, genders and ...

...work on a web project of mine. The project involves HTML, CSS, JavaScript, and some light database functions. The work will mainly focus on: - Implementing text input fields and dropdown menus: These are crucial elements for user interaction and data input. Your job would be to make them look and function as required. - Basic database functions: While the exact nature of these is yet to be decided, they will likely include retrieving and adding data. Your task will be to integrate these functions seamlessly into the site. Ideal skills for this project would include: - Proficiency in HTML, CSS, and JavaScript, with experience in creating user-friendly and responsive UIs. - Familiarity with basic database manipulation. - Good communication skills, as we'll need ...

I am looking for a developer who could develop a iOS IPhone app. It should do following Use a authentifcation based on a MySQL database table (for login) store that login as session that I not need each time again login. Create a connection between that MySQL and grab data and display that on app. Store that data like on cache that I can see that data also offline. I only will answer to developer who native language are English or German and who could show some iOS work.

...buy and sell signals with exceptional precision, particularly when applied to short timeframes ranging from 1 to 5 minutes. Key Requirements: - Development of a Pine Script Indicator: The main task is to design an indicator that generates both buy and sell signals. The accuracy of these signals is crucial, and they should be specifically tailored for the 1-5 mins timeframe. - Incorporation of Multiple Trading Indicators: While I do not have a specific strategy in mind, the ideal candidate should be well-versed in using a variety of indicators to create a robust and reliable tool. - Commitment to Non-Repaint Signals: It is important that the signals produced by the indicator do not repaint, ensuring that past signals remain consistent and reliable. The ideal freelancer for this ...

We have two sites on windows server that we would like to move to linux, without having to rewrite code for both sites. The current code is ASP and ASPX (vbscript) with Acess dbase. I am looking for someone that can make our ASP and ASPX pages to work on linux server with mysql dbase. We have a VPS on godaddy server, that we can host the two sites on. You are only qualified if you have done this many times before. You may not use our sites to "try" to do this after doing research, we only want experienced individuals on this.

...the local machine and can sign PDF, XML, JSON, and Text files in bulk and with the following additional features: - Bulk Signing: It should support signing multiple files at once, with no specific limit. - Predefined Output Path: Users should have the option to assign a default output path for the signed files. - PDF Signature Display: For PDF documents, the utility should display the signature as an optional feature. The goal is to have this utility developed within a month. Ideal skills for this project include: - Proficiency in programming languages suitable for file processing (e.g. Python, Java) - Experience in developing software utilities or tools - Familiarity with e-signing mechanisms and standards - Prior experience in working with PDF, XML, JSON, an...

i need my aws rds mysql connceted with retool. it gives error and i am unable to link it. i need help fast so only if you can help in this moment not in 1 h

I'm in need of an experienced PHP MySQL developer to handle data management and manipulation, database design and optimization, as well as web application development for my project. The goal is to create a robust e-commerce website with the following features: - Product listing and details - Payment gateway integration Ideal candidates should have a rich background in PHP MySQL, web application development, particularly in e-commerce platforms, and database design and optimization. Your skills in crafting systems that are user-friendly, secure, and streamlined will be essential. Emphasizing on data management and security is also paramount in this project. Let's connect if you possess these skills.

I need a skilled PHP/Bootstrap developer to make content alignment adjustments to my existing website. - Layout Changes: The project scope specifically involves tweaking the layout of my site. - Design References: You'll be maintaining the existing website theme as you make these adjustments, so you should be able to follow and work within the established design. - Mockups: I will provide you with detailed mockups of the changes I require. This will form the basis of your work, though I'm open to suggestions and improvements based on your expertise. Ideal Skills: - Proficient in PHP 5.3 - Strong experience with Bootstrap - Ability to follow existing design themes - Good understanding of website layout and content positioning This project is more about fine-tun...

We are seeking open-minded and willing participants for intimacy counselling and coachi...- Maintain open communication with the counsellor to ensure the effectiveness of the methods used. - Ensure confidentiality and a respectful approach throughout the process. Qualifications: - Must be open-minded and comfortable discussing a wide range of intimate and sexual topics. - Strong communication skills and the ability to provide constructive feedback. - Willingness to participate in multiple sessions as needed. - Must have good internet connection for Zoom Video Session. What We Offer: - Compensation for your time and participation. - Flexible scheduling to accommodate your availability. - A safe and confidential environment for all sessions. PM for more information related to thi...

I'm currently facing an issue with my MySQL replica. Although there are no errors, the data isn't being synced and the "Seconds_Behind_Master" is consistently increasing. I'm looking for a professional who can help me with this problem. I can't give you access to the server(s) but we can troubleshoot together. Key Requirements: - Expertise in MySQL command line - In-depth understanding of MySQL replication mechanisms - Experience in troubleshooting replication lag - Ability to work quickly and efficiently Max 50 euros. Thank you.

...ChatGPT or similar AI tools. -Strong knowledge of WordPress and content management systems. -Excellent research skills and the ability to generate creative content ideas. -Exceptional copywriting skills with a focus on clarity, impact, and engagement. -Familiarity with social media platforms, particularly LinkedIn, Instagram, and TikTok. -Strong organizational skills and the ability to manage multiple tasks simultaneously. -Attention to detail and commitment to delivering high-quality work. -Availability to work full-time for the next 6 months with the potential for renewal. Contract Details: -This is a 6-month fixed contract, paid monthly. -Possibility of contract renewal in 2025 based on performance. -Competitive monthly salary based on experience and qualifications. How to A...

I'm looking for a skilled Flutter developer who can ...build a multi-platform application that is set to be a long-term project. My primary goal is to have a reliable app that includes a variety of features to provide a seamless user experience. the app which we building will be used 24/7/365 non stop always on Skills & Experience: - Proficiency in Flutter development across multiple platforms (Android & iOS , Windows , Web). - Strong understanding and experience with user authentication, push notifications, and local database management. - Prior work with Firebase authentication . - Experience in hardware and IoT integration . THIS IS A LONG TERM PROJECT IS NOT A ONE TIME THING AND IT MIGHT TAKE A YEAR TO FINISH PLEASE WRITE FOR ME WHY WOULD BE THE BEST...

In my project, I'm looking to set up ActiveMQ JMS messaging for our system, focusing on synchronous ...testing of these messages. Your role will be essential in ensuring that the system works seamlessly with this tool. I will be expecting below: Create a framework to publish and subscribe messages to ActiveMQ queues Create queries to make sure data is published into the respective tables and assertions to validate Ideal skills and experiences for this role would include: - Proficient in ActiveMQ and JMS messaging - Previous experience in setting up asynchronous messaging systems - Familiar with SOAPUI and its capabilities for message testing - SQL developer for database queries and validations Please bid on this project if you're confident in your ability...

...order (done through a Rest API) and then select photos on the device and upload those to the selected order (also though a Rest API). Detailed Requirements: Setup screen where system URL and API key can be entered and then saved so subsequent uses of app doesn't require it to be reentered Ability to search and find order using order number, customer name, or company name Ability to select multiple photos and upload at once (although API call needs to be made for each file) Ability to take picture with camera right in app as well as select from gallery Full code ownership Nice to Have: Checkbox that allows deletion of photos on device after a SUCCESSFUL upload Not intending to publish this in app store as this is meant for employees at a company only. Will need help...

I am in need of an expert in Apache Camel 3.3.0 and Spring DSL for a project focused on system integration. Here's what I require: - A thorough familiarity with Apache Camel 3.3.0. - Strong proficiency in Spring DSL. - Capability to successfully integrate multiple systems. - Clear understanding of data transformation, routing, and error handling, although these are not the primary focus. The ideal candidate should have a working knowledge of the latest Apache Camel version and the utilization of Spring DSL. Any prior experience with system integration projects would be an added advantage. Looking forward to receiving bids from capable professionals.

I am looking for a writer/journalist who can produce news articles based on trending topics we provide. The ideal candidate will have experience in producing multiple stories per day on incoming news. Skills and Experience: - Strong writing skills - Knowledge of current events and ability to research and gather information - Ability to write in a neutral and unbiased manner - Experience in writing news articles - Ability to meet deadlines and produce high-quality work consistently

...Laravel-based admin panel for remote management. Responsibilities: Develop an Android application (minimum Android 8) with the following functionalities: Read incoming SMS and identify target keywords. Send identified keywords to a designated remote server. Receive and display SMS messages triggered from the admin panel. Implement a sync button to synchronize SMS data and send details to the remote server. Design and develop a secure admin panel using Laravel 10, MySQL 8, and PHP 8: User registration and management. Device registration with approval workflow. Device blocking functionality. SMS panel to send SMS commands to registered devices. Ability to set the remote server IP for each registered device. Implement user authentication with: Login ID ...

...AWS and Digital Ocean. - Design and deploy modern frontend user interfaces using the latest UI technologies. - Build secure and scalable mobile app REST APIs. - Manage databases using MySQL and NoSQL. - Use DevOps tools to monitor and scale applications. Looking For: - 3+ years of experience in software development - Experience with LAMP and MERN stacks - Knowledge of PHP, CSS, and JS and web technologies - Familiar with S3, cloud hosting, DNS, web security - Ability to use vanilla code and minimal libraries/frameworks - Can code fast and effective with simple Bootstrap and jQuery - Strong skills with MySQL and NoSQL (Firebase, MongoDB) - Good english communication skills in Slack and in meetings - Availability to work ~20hrs per week between 9AM-6PM PST - A passio...

We are looking for freelancers who could help us with a 4 week pilot in one of the grocery stores in Cincinnati area. You would be responsible for capturing data in the store with use of our iOS app. - This task will require visiting the same store on multiple days or even everyday in case you're available for 4 consecutive weeks. - work: 2-8h per day depending on your availability - Pilot start day: likely June 23rd. Before this date you would need to install the app, read the guidelines and visit the store for a few times for some app testing. - Most of the store visits would need to happen at 9AM More info to be provided in the private message Requirement: iPhone 11 or higher Store address: to be provided in a private message