Mysql create table longtext jobs
...requirements: php 5.3 procedural style programming **NO frameworks** ##test enviroment: You must have your own test environment. ##mysql structure: table 1 name: table whatsapp_messages columns: id insertdate direction (inbound message or outbound message) and all other relevant fields returned by the API to retrieve messages table 2 name: i am unsure if a second table is needed, but you may design it, if its required and appropriate ##Script #1: This one will run from a crontab and populate the whatsapp_messages table with the results of an API call to retrieve all inbound messages Make this script insert a new row into the whatsapp_messages table when there are new records. If the api returns an error message, trigger an ...
...requirements: php 5.3 procedural style programming **NO frameworks** ##test enviroment: You must have your own test environment. ##mysql structure: table 1 name: table facebook_messages columns: id insertdate direction (inbound message or outbound message) and all other relevant fields returned by the API to retrieve messages table 2 name: i am unsure if a second table is needed, but you may design it, if its required and appropriate ##Script #1: This one will run from a crontab and populate the facebook_messages table with the results of an API call to retrieve all inbound messages Make this script insert a new row into the facebook_messages table when there are new records. If the api returns an error message, trigger an ...
Fix WordPress Multisite Code for Setting Default Posts Per Page in Admin for Specific Roles Description: We need a developer to debug and fix a custom WordPress code snippet for a multisite environment. The goal is to enforce a default of 100 posts per page in the admin table for a specific custom post type (infracciones), but only for users with the fleet_manager and fleet_manager_admin roles. The current implementation is not working as expected, and the issue may involve hooks, multisite configuration, or role detection. Applicants should have expertise in WordPress, multisite setups, custom post types, and admin customizations. Here is the code: Budget: 10usd Provide the fix and I will award directly and release funds.
Create a fine line image Saint Lucia di siracusa
I need a project in PHP that utilizes an Automatic Number Plate Recognition (ANPR) system. The system should be able to read the license plates of vehicles (Cars, Trucks, and Motorcycles) coming to an indoor checkpoint and entering them into a MySQL table. The data to be stored along with the license plate number includes the entry time. The ideal candidate for this project should have: - Proficiency in PHP and MySQL - Experience with ANPR systems - Knowledge of vehicle types recognition - Ability to create a user-friendly interface for system monitoring Please include examples of previous similar work in your bid.
Task in 3 steps: 1. Analyse the wallets in the first tab 2. Use bitquery (I can give you an API token if you dont have one or cant get one), or use any other service like the polyscan API, or use a script to analyse the chosen wallets. 3. Deliver a dataset as presented in the second and third tabs of the spreadsheet provided
hi. (I have already created a new Telegram channel for the Temu website.). I need a Telegram bot, that posts every day and every 10 minutes in a Telegram channel a new messages. The bot search for specific category on the Temu website. The bot Copy Temu Affiliate Link and get notified with a message: 1. The product name In Hebrew (Not too many words). 2. The original price - IL. 3. The discount. 4. Positive feedback percentage %. 5. The product image (1 image). 6. The product video (If it exists). 7. The short Temu Affiliate link. 8. At the beginning of each line, there should be an appropriate emoji. 9. possible to run this on my PC or run it on a remote server. 10. In the application, I want to have access to change product categories. Skills Required -- It doesn't matte...
I'm looking for a skilled developer to help me create some code for embedding OpenAI into my platform. The AI will interface with an SQL database table and respond to user inquiries. Key Aspects: - Users will be asking a mix of general information and specific data points. - OpenAI should provide predominantly textual responses. Ideal Skills: - Proficiency in and SQL is essential. - Prior experience working with OpenAI integration is highly desirable. - Skills in interpreting and understanding user queries to optimize AI responses will be an advantage. Please provide examples of similar projects you've worked on. Looking forward to your bids!
I'm in need of a Heidi MySQL script that can help me with data analysis. The data is in a magento database. The script should be capable of extracting specific data in a specified format the magento database Key requirements: - Must have access to own magento database - Understand magento data structure - It should be able to extract specific data in a specific format. Ideal skills and experience: - Proficient in Heidi MySQL with a strong background in writing complex scripts. - Familiar with data formatting and able to ensure the data is presented in a clear and usable way.
NO LOGO STOCK NO SHUTTER STOCK NO ENVATO OR ANY Need have 3 proposal Delivery in .ai
I'm looking for a skilled professional to help me set up a system that stores data from an API into a MySQL database on a daily basis. The data can be stored either on my local machine (using Anydesk) or on a cloud server (DigitalOcean). If you opt for the cloud server, you will need to assist me in setting up a server on DigitalOcean. Once the data storage system is up and running, I would also need assistance with performing some queries on the database. Ideal Skills: - Proficiency in MySQL - Experience with API data storage - Knowledge of setting up and managing servers on DigitalOcean - Familiarity with Anydesk for remote access Please note, I would like the data to be stored hourly, twice a day or daily depending on your suggestions.
Event listing work on our event ticket resale platform. Minimal knowledge of wordpress and excellent knowledge of sporting events
I'm in urgent need of a proficient developer who can create a WooCommerce plugin for me, discounting all my products by 20% for Black Friday. The discount needs to apply automatically to all items in the store. Key Requirements: - The plugin should allow setting start and end dates for the discount. - It should display both original and discounted prices. Ideal Skills: - WooCommerce plugin development - PHP - WordPress - JavaScript - MySQL Please note that this is a time-sensitive task. The sooner I can get this implemented, the better. Thank you! This is a $20 budget please don't write me if you are going to ask more
I have an existing MySQL installation on my Linux server that needs to be started. I need a professional who is experienced with Linux Server and MySQL to help me with this task. Server Details: OS: Ubuntu 22.04 MySQL Service: Failing to start consistently. Symptoms: The MySQL service is stuck in an "activating (start)" state for extended periods, then eventually fails with the error: vbnet Copy code Job for failed because the control process exited with error code. The error log shows no process-related errors but indicates the service is unable to initialize fully. Available disk space was checked, and temporary files, logs, and cache were cleaned, but the issue persists. Troubleshooting Steps Taken: Attempted restarting and killing all MySQL...
I need a fast-working, self-sufficient programmer with strong expertise in WordPress and WooCommerce. Key skills include PHP, MySQL and JavaScript. While I haven't pinpointed specific areas of customization yet, I have an existing plugin that requires modification. Ideal skills and experience for the job include: - Deep understanding of WooCommerce and WordPress - Proficient in PHP, MySQL, and JavaScript - Experience with customizing WooCommerce plugins - Ability to work quickly with minimal supervision - Prior experience with WordPress plugin development and customization - Proficiency in using Git for version control - Experience with third-party API integration this work is for 3 hours only no payment after 3 hours, complete or not if not complete no payment full ...
I have /bar/lib/MySQL folder with 3 subfolders corresponding to 3 WordPress databases and I need to deploy them into a new server. I don't have access to WordPress admin because the server is down. I need the SQL dump file of those db so I can import them. I'm not sure but I think there are both myisam and innodb databases. I have urgency.
Seeking a talented videographer to craft a compelling promotional video akin to [link]. Key requirements: high-definition visuals, engaging narrative, and professional editing. Must align with our brand’s vision and be optimized for Amazon. Deliverables include final video plus drafts for approval.
I'm looking for a professional who can convert a Word document into a fillable PDF for internal use. The PDF will require: - Text fields: There will be parts of the document that need to be filled in with text. - Checkboxes: Some sections of the document will need to be ticked off. No calculations or automatic data population are needed in the PDF, just straightforward fillable sections. Ideal candidates for this task should have a strong background in PDF creation and editing, with a keen attention to detail to ensure all fields are accurately represented from the original Word document.
...trips, communicate with passengers, and provide real-time location tracking. Passenger App (Android and iOS): Allows users to request trips, view trip details, make payments, communicate with captains, and track the boat in real-time. Specifications 1. Backend (Web Administrative Interface) Technologies: PHP and MySQL. Access URL: Main Functionalities: User Management: Super Administrator: Full access to manage the platform. Create Other Users: Ability to create users with specific roles and permissions. Boat and Captain Management: Onboarding of New Boats and Captains: Collect necessary documentation according to Costa Rican legislation: Captain's identity document. Police certificate. Captain's license. Captain's photo. Boat registration (f...
More details: What style of silhouette do you envision for the logo? Abstract What is the subject of the silhouette? Person What emotion or vibe should the silhouette convey? Elegance mystery sexy
I'm seeking a proficient JavaScript (Node.js) backend developer to create a budget calculator. The project will involve: - Interacting with Databases: The budget calculator will require a seamless connection and data handling with SQL databases, specifically MySQL. - Integrating with APIs: The tool will also need to communicate with various APIs, which may involve retrieving data or sending requests. - Integrate data validation to ensure user inputs meet required standards. - Set up comprehensive error handling and logging mechanisms. The ideal candidate for this project should have extensive experience with Node.js and SQL databases, along with a solid understanding of API interaction. If you are skilled in these areas and can deliver a robust backend for this budget ...
I need a professional developer to convert my entire CorePHP application to Laravel. This project also involves integrating with my existing MySQL database. Key Requirements: - Full migration from CorePHP to Laravel - MySQL database integration Ideal Skills: - Proficient in CorePHP and Laravel - Strong understanding of MySQL - Experience with full application migrations
Create a reef safe icon based on our previous work together
...existing websites. - troubleshoot and resolve technical issues promptly. - Implement security updates and patches to ensure website security. Required Skills and Experience: In-depth knowledge of WordPress and its core functionalities. Expert proficiency in Elementor page builder. Solid understanding of eCommerce and its extensions. Experience with HTML, CSS, and JavaScript. Familiarity with PHP and MySQL. Strong understanding of SEO principles and best practices. Ability to work independently and as part of a team. Excellent communication and problem-solving skills. Experience with Amazon affiliate programs and link tracking. Knowledge of popular e-commerce plugins and tools. How to Apply: Please submit your resume, portfolio showcasing your previous work, and hourly rate ex...
I have a website developed on the Laravel framework that is currently hosted on a localhost using XAMPP. I need to expose it to the internet from our in-house servers instead of using a CDN like Cloudflare or port forwarding. The website uses a MySQL database. Key requirements: - Implement advanced security measures including the installation and configuration of a firewall. - Provision for handling high traffic. We anticipate significant traffic, so scalability options are essential. - The user authentication system is already set up to use Google login and two-factor authentication. - Implement SSL certificate for securing data transmission between the server and clients. - Implement measures to protect against Distributed Denial of Service (DDOS) attacks. - Set up comprehensi...
I need a designer to create detailed 2D drawing for furniture placement in the living/entertainment area (15'-5" x 29'-4") . This is crucial for interior design planning. Furniture to be included in the renderings: - couch - tv on stand - 2 egg chairs - kitchen island - desk with chair - small dining table with 2 chairs - small bookcase Ideal candidates for this project should have extensive experience in interior design. Proficiency in relevant software and a keen eye for spatial planning and aesthetics are essential. Please attach similar work that you have done before. The designs should follow a modern style/theme. The renderings should be photo-realistic with high attention to detail and textures.
...organizations to a meaningful community event. Responsibilities: Conduct targeted outreach to secure sponsorships by January 2025. Promote vendor table registrations, ensuring completion by the end of January. Develop and execute digital marketing campaigns to promote event attendance until March 2025. Collaborate with local organizations and community groups to maximize participation. Create and distribute promotional materials, including social media posts, emails, and flyers. Track outreach efforts and provide bi-weekly updates on progress. Deliverables and Milestones: Sponsorships Secured: Confirm at least 5 sponsors by January 2025. Vendor Table Reservations: Secure a minimum of 20 vendor registrations by January 31, 2025. Event Attendance Growth: Maintain con...
INSTRUCIONS ON THE ATTACHED FILE | INSTRUÇÕES NO ARQUIVO EM ANEXO Objective: Create a “JUCATALES” logo using the writing of “DUCKTALES” as a base, as similar as possible to the original logo, imitating the same font, colors and shadow. Conclusion: High quality PNG and JPEG files, without background. Objetivo: Criar um logotipo “JUCATALES” usando como base a escrita de “DUCKTALES”, da maneira mais parecida possível com o logotipo original, imitando mesma font, mesmas cores e com sombra. Entrega: Arquivos PNG e JPEG de alta qualidade, sem fundo.
I'm in need of an experienced web scraper who can extract data from the Market Chameleon page: Requirements: - Scrape the table data from the page, with hyperlinks and titles included. - title and hyperlink and details like timestamp etc for N and E respectively - Include the data source URL in the output. The output should be in either CSV or Excel format. Ideal candidates for this project should have: - Proven experience in web scraping. - Excellent data handling skills. - Familiarity with stock market data is a plus. Please note that the third question regarding data organization was not specified by me, so there is some flexibility in how the data is presented.
I'm in need of a Classic-styled Android UI for Google Sheets. This interface should neatly display various pivot table results in list format and include a couple of search boxes for easy navigation. Key Features: - Display of pivot table results in list form - User-friendly search boxes - All designed in a classic style Ideal Skills: - Proficient in Android UI/UX design - Experienced with Google Sheets and pivot tables - Able to design in a classic style
Hello We're looking for a Spanish speaking person that can upload and write products to our woocommerce website Only people with experience in woocommerce are interviewed! We pay 1.50 USD per uploaded product with unique descriptions and all the uploaded fotos renamed also we have some other tasks. Start asap. Thank you !
Adjust Kindle Version by removing additional cover page and make any necessary revisions for optimal Kindle viewing and selling and create and publish paperback and hardcover version of kids book
Hello We're looking for a Spanish speaking person that can upload and write products to our woocommerce website Only people with experience in woocommerce are interviewed! We pay 1.50 USD per uploaded product with unique descriptions and all the uploaded fotos renamed also we have some other tasks. Start asap. Thank you !
I'm looking for a seasoned developer to create a comprehensive membership and points system within my Perfex CRM. The main focus of this module will be managing subscriptions. Key features: - A subscription management system that handles different types of memberships (primarily paid, with potential for tiered memberships in the future) - A points system that rewards loyalty levels based on customer engagement and allows for redemption of points for rewards Ideal skills for this job include extensive experience with Perfex CRM, proficiency in PHP and MySQL, and a solid understanding of membership and loyalty systems. The successful freelancer will be able to deliver a user-friendly, efficient, and scalable module.
I'm looking for a professional who can create a comprehensive construction work schedule in Excel for a high-end three-storey villa of 350m2, built with an RC frame and brick slip cladding system. The schedule should include: - Task names and deadlines - Resource allocation - Progress tracking I prefer a simple table format for the work schedule. Ideal candidates for this project should have extensive experience in project management and Excel, with a strong understanding of construction schedules. Please include examples of similar past projects in your bid.
I'm in need of a professional who can create an optimized cutting table for my aluminium extrusions. I'm involved in construction and want to minimize waste during cutting. Key requirements: - The cutting table should optimize cutting as per requirements, without predefined patterns - Experience in working with construction materials is a plus - Understanding of minimization strategies to reduce wastage - Able to deliver a practical and easy to use cutting template I want this project to save me time and resources, so I need someone who can really understand the intricacies of this task.
I'm in need of a professional and modern sales proposal builder. This proposal should include: - A section dedicated to client information - A comprehensive pricing table - Clearly outlined terms and conditions - Detailed capabilities of our Employee Benefit Plan The design style should be sleek and contemporary, yet maintaining a professional tone throughout. Ideal candidates will have experience in sales proposal creation, with a strong understanding of modern design principles. A background in insurance would be a plus.
...the respective id's in the PPT template should be replaced with the mapped values. This is to allow our clients to create an automated report as the ID's should remain constant across analysis runs. I asked ChatGPT to design such a program and it's in the right direction - The idea would be to start with a basic command-line utility and, if we work well together, I would ask you to add features to this utility as additional small paid projects. The basic version would need to be able to: - update a text field within PPT with a provided value in the data file - update a table within the PPT with the provided table data in the data file - update a line chart within the PPT with the provided line chart data in the data file - user
...Cordova(Android&IOS). I want to add a new feature that allows admins to create and manage travel packages consisting of multiple destinations, which users can browse and book directly through the app. Additionally, I want to integrate a hotel admin panel where hotel admins can also view and book Multiple packages for their guests. Required Customizations: 1. Database Updates: o Add a new table to store travel packages, including fields for:  Package name, destinations (multiple locations), price, duration, and status. o Modify the bookings table to link bookings to a package if applicable. o Add a hotel-specific column in the bookings table to track bookings made by hotel admins. 2. Admin Panel Modifications (for General Admins): o Create a form ...
...provided. Database Model: Student Table Name (from Google account) Email (from Google account) Questions Table Question ID Question Text Choice A, B, C, D, E (multiple choice options) Correct Answer Learning Objective ID List (one Question ID can reference multiple Learning Objective IDs) Textbook Sections Has Image (True/False) Image URL Learning Objectives Table Learning Objective ID Title Summary Textbook Page References Exams Table Exam ID List of Learning Objective IDs (10-15 per exam) Exam Questions Table (cross reference between Exam and Questions table) Exam ID Question ID Condition (1, 2 or 3) Exam Students Table (cross reference between Exams and Students) Exam ID Student ID Transcript (BLOB) Exam Question Students Table...
I'm looking for an automation solution that takes responses from my Microsoft Office registration forms and sends them to my email in PDF format. Key Requirements: - The PDF should include all responses from the forms. - The response...standardized layout format in the PDF. This automation will run daily. Use a standard subject line for the email. The automation should send the emails with the PDF attachments to my Microsoft Outlook inbox. The email should use a custom subject line of my choosing. The automation tool to be used is Microsoft Power Automate. Format the responses in the PDF using a table format. The responses should be displayed in a multi-column table format in the PDF. Please organize the responses by date in the PDF. Each PDF file should be named based...
I am looking for a skilled designer or 3D artist to create a high-resolution, realistic image of a modern, luxurious interior space. The design should include: A soft, textured carpet as the centerpiece. Bright natural light streaming through large windows. Neutral-toned furniture (sofas, armchairs, wooden coffee tables). Indoor greenery (plants and trees) to enhance the ambiance. Elegant signage in the background with placeholder text. A cozy, minimalist, and inviting aesthetic. The final image should be polished, visually appealing, and suitable for use in marketing or branding materials. Please share samples of similar work in your portfolio. Thank you!
I have a MySQL database containing a simple SQL table with 5 columns (reqs, date, product, bids, reference) and 200k results. I need some queries that can help me analyze this data. Specifically, I need queries that can identify: - Products with 0 bids that are present on at least 7 different dates - Products with 1 to 10 bids that are present on at least 10 different dates and have a total of more than 10000 reqs Additionally, I would appreciate tips for optimizing the queries or the database. Ideal skills and experience for this job include: - Proficiency in SQL, specifically MySQL - Experience with data analysis and query optimization - Ability to provide practical tips for database optimization
Project Overview: We are seeking an experienced Web and Mobile App Developer (or team) to build a user registration platform for our innovative startup. The project includes developing a responsive website and mobile applications for Android and...Strong data encryption for sensitive details. • Admin panel for managing users and viewing analytics. Developer Requirements: • Expertise in web development (HTML, CSS, JavaScript, React, or similar frameworks). • Experience with mobile app development (Flutter, React Native, or native development). • Knowledge of NFC/RFID and QR code implementation. • Experience with database management (MySQL, MongoDB, etc.). • Familiarity with DigiLocker API integration (preferred). • Strong understanding of ...
I'm seeking a professional to develop a similar application to Petpooja's restaurant management system. The project should encompass all the features of Petpooja, with specific emphasis on: Key Functionalities: - Table reservation - Inventory management - Billing and invoice generation - All other features of Petpooja Primary Focus: - Detailed analytics and reporting: The system should provide comprehensive insights about the restaurant's operations, sales, customer behaviors, and inventory usage. Analytics and Reports Needed: - Sales reports: Understanding revenue streams and peak sales times. - Customer behavior analytics: Insights on customer preferences and buying patterns. - Inventory usage reports: Tracking inventory consumption and forecasting needs. Ideal...
I am seeking a professional with extensive experience in WooCommerce and SQL. Key Tasks: - Bulk price updates for WooCommerce products. - Modifying an existing SQL table to update product prices on our site Ideal Skills and Experience: - Proficient in PHP and SQL. - Prior experience with WooCommerce product pricing. - Strong troubleshooting and problem-solving skills.
...setting up containers for a Plesk environment with MySQL as the database. Your role will include optimizing the deployment for smooth and efficient operation, ensuring scalability and security. Key Responsibilities: Set up and configure Docker containers for a MERN stack application. Integrate Plesk as the control panel and configure MySQL as the database. Optimize deployment for performance, scalability, and security. Provide clear documentation for the setup and deployment process. Essential Skills: Strong experience with Docker and container orchestration. Proficiency in deploying and managing MERN stack applications (MongoDB, , React, Node.js). Familiarity with Plesk control panel and its integration with Docker. Knowledge of MySQL setup and configuration in ...
...skilled Android developer to create an app that uses a SQL Lite database and replicates with an online MySQL database. The app will primarily focus on user authentication through email and password login, with a key function being the data management of registration records. We are providind the database scructure (attached) which is similar with My SQL database also with screenshot of the different screen of the application. Key Features: - Data entry and retrieval focused on transaction records - Efficient synchronization between SQL Lite and MySQL - Google map - Geo Mapping Trips: Integrate a geo-mapping feature. - Enable offline data entry and retrieval with later synchronization. - Implement push notifications for important updates and alerts. - Create...
