程序是： 首先 第一步： 随机抽取5个phome_ecms_news里面的id和classid 第二步： 读取phome_ecms_news的id和classid，作为函数使用 第3步： 插入phome_enewspl_1新的内容到数据库 例子：$sql = "insert into phome_enewspl_1(plid, pubid, username, sayip, saytime,id,checked,classid,zcnum, fdnum, userid,isgood,saytext,eipport) values (NULL, '1000310000019701', '', '', unix_timestamp(), '$id', '0', '$classid', '50', '1', '0', '0', '评论内容', '48010')"; 第四步： 更新phome_ecms_news的字段plnum+1并且对应第一步读取的id值 例子：UPDATE phome_ecms_news SET plnum =plnum+1 WHERE id = 20488;
Hi Sunny， 我有个mysql数据库，速度需要提高，你有兴趣和时间帮忙吗？ 这个数据库有两个表的数据量在1千万左右，另外一个在1百万，并不是很大，也做了index，但是不清楚什么原因某些query还是很慢（超过2秒）。 谢谢！ 崔旭
Jie, 我有个mysql数据库，速度需要提高，你有兴趣和时间帮忙吗？ 这个数据库有两个表的数据量在1千万左右，另外一个在1百万，并不是很大，也做了index，但是不清楚什么原因某些query还是很慢（超过2秒）。 谢谢！ 崔旭
...card management system , a need to develop alternatives to achieve full functionality. Features include : And existing interfaces hotel room sales management system ( call each webservice form , with the other engineers do ) ; Membership card classification management , distribution , auditing , enable, payment and other packaging ; Corresponding financial statements , business reports ; Query function ; ( Detailed function menu , see Annex photo ) Claim: We had a similar successful projects ; Autonomously communicate with customers , to explore the details of the demand ; Hotels need to travel to the customer site commissioning and implementation of the ( secondary cities in Sichuan Province ) ; Familiar with business processes better ; Please clearly state y...
...charge recharge based procedures, similar to VPNExpress , The implementation of user registration, recharge (Alipay & Paypal), VPN account settings, password changes. The user account, close to expiration reminder, enterprise information submitted invoices, invoice mailing address submitted. The OpenVPN function to read, including account surplus time, monthly bandwidth query, history of bandwidth usage information. The interface is succinct, professional, similar to Bootstrap. We have a billing system Hostbill, so if you can develop Hostbill Api, you can not have the development of Web. 一个OpenVPN收费程序, iOS & Andarid & Website(或者使用Hostbill账单系统) 基于OpenVPN的收费充值程序, 类似VPNExpress , 实现用户注册,充值(Alipay & Paypal),VPN帐号设置,密码变更. 用户帐户, 有接近到期提醒,
..."Product details" of the input file 1 are present in column A of the VAT output file and we have a value in column B. If there are lines that are not present or do not have a value, you must report them in the VAT control output file report (attached). 4- Starting from input file 1 (attached), look for the lines of column D "product details" in column A of the newly created VAT output file and insert the respective value present in column B of the file in column K of the example output file (attached). VAT output. 5- Starting from the output file just created, create a new file such as the VAT corresponding file (attached) in which in column A "DATE" there are the dates present in column A of the "Input 1" file (only 1 line per date). In co...
...way when people will say something in order to be able to record it and I can't see the future, which meant that I couldn't catch a lot of funny sentences and couldn't replay them. There is another function in the "Sound Deck" plugin, i.e. a button with which I can clip and save the last 15 seconds, but I cannot replay the sound directly but first have to create another button where I can then insert the sound and Only then can I play it in-game. The fact that 15 second clips are the minimum is also really poorly done, because a sentence from a teammate lasts 2-5 seconds and not 15. Now about the plugin that I need, as you can probably imagine, I would like a plugin with the function of being able to clip the last 2, 5 or 10 seconds (it would be best if ...
...annual leave, business trip, public holiday, overtime" Excel Automation: - I need the Excel sheet to have automated functions: * Conditional formatting for visual tracking: Changes in cell color or font based on the progress percentage, to quickly see if a project is on target. * Data validation for entry consistency: Ensuring that data is entered correctly, preventing errors. *Eligible to insert in google sheets with same formatting The ideal freelancer for this project should have: - Proficiency in Excel formulas and functions for tracking project progress. - Experience in creating automated Excel sheets using conditional formatting and data validation. - Attention to detail to ensure the accuracy and functionality of the sheet. - Good communication skills to unders...
I need to scrape data from a web...a website. I'm stuck with an error. I used improtxml to scrape data from a class in a website I know. However, the fact that this website has classes has a problem: . While on page 1 there will be that text data, but on many pages, that text data is not there and it is accidentally pushed up to insert the class data below into the previous class data. To make it easier to imagine, there will be 4 rows. I will need to get a fix for each row into the google sheet. However, there are pages where I insert the link and there will be no row 3 or row 2 and then row number 4 will be inserted into row number 3, making the data incorrect. I need improxml to automatically check the syntax, if it is correct, it will be filled in and if it is wrong,...
I need a full WordPress website for my bed and breakfast. 6 PAGES 1 - home page 2 - first apartment page 3 - second apartment page 4 - third apartment page 5 - booking form 6 - contact page Insert icon with link to Facebook page on the site Visitor statistics FURTHERMORE I need an excellent positioning of the B&B on Google My site might look something like this: I will provide all text and images for the site. I await your quote, don't be generic otherwise I will reject your offer. If you have already made similar sites I would like to see them. Thank you.
I need a full WordPress website for my bed and breakfast. 6 PAGES 1 - home page 2 - first apartment page 3 - second apartment page 4 - third apartment page 5 - booking form 6 - contact page Insert icon with link to Facebook page on the site Visitor statistics FURTHERMORE I need an excellent positioning of the B&B on Google My site might look something like this: I will provide all text and images for the site. I await your quote, don't be generic otherwise I will reject your offer. If you have already made similar sites I would like to see them. Thank you.
I'm looking for a skilled photo editor who can remove the existing date from a picture and insert a new one, as well as incorporate a text or logo to the image. Key Requirements: - **Date Replacement**: You'll need to completely remove the old date from the picture and add a new one in its place. - **Text or Logo Placement**: The text or logo should be elegantly placed on the image, in a manner that doesn't overshadow the main subject. Ideal Freelancer: - Proficient in photo editing software like Adobe Photoshop or GIMP. - Experienced in working with image manipulation and text overlay. - Attention to detail to ensure a seamless blend of the new date and the existing image.
...packet, four cups of water, and 1-4 pounds of cubed chuck roast, or meat of your choice, to a slow cooker or instant pot. Instant Pot - Set to Pressure Cook, on High, for two hours, then natural release for 15 minutes. Slow Cooker - Cook on low heat, covered, for 8 hours. Optional: Add the juice of 2 limes to the liquid mixture. Sear the beef before adding to mixture. Empty, wash, and dry the insert of the pressure cooker. Add 1/4 cup avocado oil to the pressure cooker and heat on the highest Sauté setting for 5 minutes. Add half the beef and sear until browned on a few sides, 8 to 10 minutes. Transfer to a plate. Repeat searing the remaining beef. " - Allergy Info - packed in a factory that handles nuts, peanuts and sesame....
I would need a script written in nodejs where a USB NFC reader (specifically the ACR122U or the ACR125U) wait for a NTAG424 DNA tag. Once an NFC tag is tapped write a URL data into the tag as well as encryption keys. Make sure the URL contains query parameters which are mirrored uid, counter, and cmac that are all encrypted. Part of this is to write a nodejs script to validate the above parameters from the URL and decrypt the uid/counter (or some Rust that can do the same)
...bugs and security vulnerabilities in the current project. Ensure the new version adheres to the latest security standards. API Integration: Connect the backend with the frontend using APIs. The APIs should be well-documented, secure, and efficient, allowing seamless communication between the backend and frontend. Requirements: Proven experience with CodeIgniter 3 and 4. Strong knowledge of SQL query optimization. Expertise in identifying and fixing bugs and security issues. Experience with API development and integration. Ability to work with the existing database structure without alterations. Good communication skills and ability to provide regular updates. Deliverables: Fully upgraded CodeIgniter 4 project with all features and functionalities working as expected. Optimize...
looks like you're encountering a MySQL error related to an incorrect DATETIME value in your query. This error typically occurs when the format of the date and time being used in the query does not match the expected format in MySQL, or when an empty string is being used where a datetime value is resolve this issue, you should first check the format of the 'date_scheduled' values in your 'banners' table to ensure they are in the correct DATETIME format. You might also need to modify your query to handle cases where 'date_scheduled' might be empty or incorrectly you're not sure how to proceed or need further assistance with checking or adjusting your database, you can manage and review your MySQL databases and their tables from S...
I'm in need of a proficient expert who can assist me with running queries on DuckDB using data originating from Amazon S3. This task primarily involves: - Interacting with semi-structured data such as XML and JSON - Processing a substantial data volume ranging from 1GB to 1TB The ideal freelancer should have the following capabilities: - Deep understanding and experience with DuckDB and Amazon S3 - Strong skills in handling and querying semi-structured data - Experience in managing and processing large volumes of data Please note: it's critical that the freelancer have experience with managing these sorts of tasks previously and has a solid understanding of large volume data manipulation.
I am in need of a comprehensive essay on autonomous vehicles that is 12-15 pages long. The essay should be written in APA style with proper academic citation and references. The essay should include a clear introduction...introduction, body, and conclusion. Additionally, I would appreciate if there could be some graphical content inserted where relevant. Ideal skills and experience for this job would include: - Proficiency in academic writing and research - Strong understanding of APA citation style - Prior experience writing about technological subjects, especially in the automotive industry - Ability to create and insert graphical content in an essay - Meeting a tight deadline of 1 week for the completion of the essay. Please include a sample of your previous academic writing if...
I require a proficient graphic designer for a minimalist packaging design of a beauty product. This project involves creating an aesthetically appealing and clean design that embodies simplicity and modernism. Key Elements: - Include the Company Logo - Incorporate Nutritional information - Insert Barcode on the package. Ideal candidate: - A good designer, experience doesn’t matter - Has a good understanding of beauty product branding - Keen attention to detail - Ability to create engaging and aesthetic designs.
I need a skilled Wordpress professional to update and arrange my blog posts on my Elementor site. The updates include text editing, adding and replacing images, and adjusting the layout. Key Tasks: - Update 4 blog posts: The main task is to rewrite some of the content and add or replace images where necessary. This update should be done meticulously to maintain the quality and consis...and Wordpress proficiency: You must have a good understanding of Elementor and Wordpress to carry out the necessary updates and arrangements. The project is of top priority and needs to be completed ASAP. I'm looking for someone who can work efficiently, collaborate with me well, and ensure the tasks are completed to a high standard. You need to extract images from pdf's You need to upload and ...
I need a solution that can automatically insert page numbers onto every A4 page in my document at the bottom. Key Requirements: - The system should work with A4 format. - It should be able to insert these page numbers automatically and consistently on every page. - The page numbers should be placed at the bottom of each page. Ideal Freelancer: - Experience working with PDF manipulation and automation. - Proficient in software that can perform automatic page numbering. - Attention to detail in maintaining consistency in design and positioning of the page numbers.
I'm in need of someone with strong experience in PostgreSQL for some critical tasks. - The ideal candidate should be well-versed in PostgreSQL, with a background in both database administration ...be well-versed in PostgreSQL, with a background in both database administration and development. - You must be able to handle complex issues that may arise with the database and be capable of performance tuning when necessary. - I expect you to understand the nuances of PostgreSQL and be able to provide solutions to potential problems with the database. - Any experience with data migration, query optimization and database design will be a plus. Please make sure to include your past work and experience with PostgreSQL in your application. Your detailed project proposals are high...
I need a professional with strong skills in image modification to alter an existing image for me. Here are the details: - Presently, the image is in a 3/4 side view, but I want to change it to a direct side view. - The adjustment in angle should be less than 45 degrees. - No background or object removal, or image retouching is requ...details: - Presently, the image is in a 3/4 side view, but I want to change it to a direct side view. - The adjustment in angle should be less than 45 degrees. - No background or object removal, or image retouching is required; Just the angle change. Steps are: 1. The base picture is image # 1 2. The section i need recreated is highlighted in image # 2 3. Once this image angle is changed you can insert it in image # 4 4. Image # 4 shows how it s...
i have one php script which used to load in a few seconds now takes 4 minutes not sure why it suddenly lags need optimised - the mysql query hittin some bottleneck somewhere by looks of it
I'm looking...an existing machine learning model into a Discord bot. The bot should cater to three main functionalities - sending daily race predictions, responding to user queries about race outcomes, and providing real-time race updates. Key Requirements: - Integrate an existing machine learning model into a Discord bot - Implement a feature to send daily race predictions on a specific channel - Develop a query system that effectively responds to user queries about race outcomes - Enable the bot to provide real-time race updates Your Skills: - Proficiency in machine learning model integration with Discord bots - Experience in developing chatbots, particularly for Discord - Knowledge of horse racing and related terminologies - Ability to create an efficient and responsive r...
...availability and pricing. Selection and Confirmation: Upon receiving responses, the logistician selects the best courier based on price and availability. The logistician fills out an order form in Excel, converts it to PDF, and sends it to the chosen courier to confirm the shipment. Automate File Transfer Based on Client and Project: Implement a system that automatically transfers the transport query from one file to another in the local drive based on the client and the current project folders. Project Goals: Automate Courier Selection: Develop a way to automatically select suitable couriers from the database based on predefined criteria (distance, size, location). Automate Communication: Automate the process of contacting couriers via Outlook, including sending inquiry emai...
I'm in need of a PHP page that helps our agents to send ...logins he can see a list of all the products with quantity bigger than 2. On each raw we want to put a simple dropdown menu where the agent can chose the quantity to order. The default value will be 0 quantity. The maximum quantity must be the quantity in stock -2 We would like to see the total amount of the order. And at the end or at the beginning of the form we want some input fields to insert the data of the company that will purchase: - Company name - Address - City - Postal code - Vat number - SDI number - phone number - person to contact - email address - payment method And at the end a Send order push button The action will be just to send an email to an email address and to update the quantity of the prod...
...Windows platform. Ideal Skills & Experience: - Proficiency in Desktop Application Development - Strong MySQL and Database Monitoring Skills - Experience with WYSIWYG Template Management - Previous experience in PDF generation applications - Knowledge of Windows Application Development Additional Notes: a. application will need to determine which template to use based on a query b. Must be able to create, edit templates in an easy wysiwyg way. c. naming convention based on db record. d. Ability to add an option password to the PDF required. e. The resulting PDF must be stored in up to 2 locations (one maybe a unc path with username and password required) f. must be able to use multipl...
...adept content writer who can craft compelling, informative content that not only engages but also promotes a product/service to a diverse audience. The ideal candidate should be able to transition seamlessly between the following: - Informative: The content should be detailed, well-researched, and clearly explain complex concepts to a general audience. - Promotional: The writer should be able to insert persuasive language and calls to action that encourage readers to engage with our product/service. - Industry-specific: An understanding of the industry is crucial. The content should be tailored to professionals in the field, providing them with valuable insights and information. - Academic: Additionally, the writer should also be able to create content that is suitable for stude...
I came across a minor issue on my website on Digital ocean cloud server. Refer the below error information. I need someone who can fix me immediately in an hour. Error 500 PleskExceptionDatabase DB query failed: SQLSTATE[HY000] [2002] Connection refused
...the content should be informative, engaging and able to simplify complex topics for an informed readership. Key job requirements: - Proven experience in creating engaging and educational blog content - Ability to write in a moderately technical style - Understanding of SEO best practices to drive organic traffic - Strong research skills to ensure factual accuracy - Familiarity with the topic of [Insert Topic Here] would be a great advantage, but not mandatory. Ideal candidates should also be able to work within a given time frame and provide high-quality, original content....
I'm looking for a video editor to enhance 5 educational videos (around 2-4 minutes per video). You can quote me per minute of adding in the text + the cost to add in the branding on each video. The primary goal is to insert key branding elements throughout the videos. These include: - My company's logo - A watermark - A small banner featuring the company branding at the bottom throughout the videos In addition, I would like the editor to incorporate subtitles at the bottom of the videos. The subtitles should be clear, easy to read, and complement the educational content. We will have the videos transcribed, will need you to match it up to the sound. The videos are in Spanish and English. This is important, as you will need to understand Spanish to know where to align ...
...on the side of the vehicle occupant seat. Example: When the execution of the main action plan displayed on the first display is completed, the action plan to be executed earliest among the secondary action plans displayed on the second display can be advanced as the main action plan, and its display can be displayed on the first display. Example: If the vehicle occupant performs an operation to insert any action plan while the vehicle is driving autonomously, that arbitrary action plan can be inserted and displayed as either the main action plan or the secondary action plan. <<NOTICE>> The target car brands in this search are limited to US, European, Chinese, and South Korean brands. <Requirements for Payment> ・Submit documentary evidence that clearly states th...
I am experiencing slow query processing and management issues with large tables in my MySQL database, primarily storing transaction data. I am seeking a DBA specialist to diagnose and resolve these bottlenecks and improve the overall performance of the system. Ideal Skills and Experience: - Proven experience in MySQL database administration and optimization - Knowledge of query execution plans and optimization techniques - Proficiency in managing databases with 10-50 tables - Experience in handling databases primarily housing transaction data Tasks include: - Investigating and diagnosing slow query performance - Optimizing handling of large tables - Implementing necessary changes to enhance overall database performance.
The aim of the project is to create a nodeJS program that will retrieve an xls file from an email inbox in order to geocode the addresses present in the file via the Google Maps API and insert the geographic coordinates into an SQL table. You can follow these steps: 1. Retrieve the xls file from the mailbox - cron every hour 2. Normalize the xls file for integration into a MySQL table 3. Configure access to SQL database from JavaScript. 4. Insert data into table via SQL query 5. Retrieve addresses to be geocoded from the SQL table. 6. Use Google Maps API to geocode each address. 7. Insert the geographical coordinates (latitude and longitude) in the SQL table. Each line in the xls file corresponds to a delivery. The file has 15 columns. The column names are,...
I'm seeking a skilled Wordpress developer who has extensive experience with Advanced Custom Fields (ACF) and Avada. You'll be required to customize Avada's real-estate theme by following specific instructions. Key tasks include: - Replacing text labels on the listing cards with icons. This requires a good eye for design and layout....should have some labels replaced by icons, similar to the ones that are at the single post page. Description 2 The contents: "text description", "add to calendar", "open house scheadule", "map coordenates" even "Show more" that are now all in one single text box should be splitted so that users insert them separatly like print screen 2 of other page contents.
..."International Chinese Education Demand Monitoring, Prediction and Countermeasures Research based on Big Data", and create a website that can query the real-time popularity of Chinese learning language in all countries, the following is a website layout and function plan: ### Web Site name: Global Chinese Learning monitoring platform ### Website Layout: 1. * * Home page * * -Top navigation bar: contains the site name, search box, and user login / registration options. -Global map: 1. Identify the popularity of Chinese learning in different colors.2, Click each country, can feedback heat data, etc., you can jump to the second plate 2. * * National heat query * * -List of countries: arranged alphabetically for user search. -Search function: enter the name of the c...
I need an adept SQL developer proficient in crafting SQL queries for various tables within our database. The task entails generating four queries, each encompassing approximately 20 conditions that must be met. Utilizing ChatGPT, could you assist in devising these queries?
...hues of the desert at sunset. This card should feature elements that evoke a warm, golden ambiance, perhaps using textures or imagery that suggest sand or the sunset. We expect a theme that includes a light watercolor background which reflects the elements and the meaning of the product, along with a message that embodies the ideas of the product and the brand itself. In a book let bracelet card insert ( holder ) We're looking for someone with a strong portfolio in branding and packaging design, especially within the accessories field. If you have the creativity and skills to bring fresh ideas and elegant solutions, please send us your portfolio. Let’s create something amazing together! This project involves Arabic-inspired products. Based in Kuwait ?? Thanks Plz ...
Hello everyone. I need a query for prestashop version 1.7.8.10. I need to run 2 times a day a check script on products that have quantity 0. When I have quantity 0, I need to disable the product. I need a script that performs this operation 2 times a day.
I am looking for Website for B2B and B2C. Data will be reflect to the Admin portal from both B2B and B2C pages. Need to create 5 pages for Website B2B Page Tasks Need to create Query request form on B2B Need to create registration form on B2B Need to create Inventory management page on B2B B2C Pages Need to create registration page using whatsapp, social media and phone Customer can search for the desired result which will be based on the B2B inventory management page In the result page our recommendation will be listed at the top Need to create app for B2B and B2C for android/IOS
...a OneDrive folder. The OneDrive folder will have subfolders for each month containing our company’s purchasing and selling invoices. The GPT should be capable of answering questions related to these invoices. For example: "Sum all subtotals of invoices in folder April2024invoices." Integration with Excel: From within Excel, I want to be able to call the custom GPT "GPT-Invoices" by writing a query in a cell. For example, in cell A1, I should be able to write: =GPT-Invoices("sum all Subtotal values of invoices of April 2024"). The output answer should be returned in the same cell (A1). Deliverables: A fully functional GPT-Invoices model that can analyze invoices from OneDrive folders and answer queries as described. A VBA (or other appropriat...
...development environment (macOS), I consistently encounter a captcha challenge when running the script in a Docker container. Even after modifying the script to run in non-headless mode (using xvfb-run), the captcha persists, preventing successful login. Therefore, I am seeking your expertise to adjust my login script in a way that prevents the captcha from appearing after the initial login step (insert CPF), specifically considering execution within a Docker container....
The indicator name is Custom XABCD Validation and Backtesting Tool (open source), but for the purpose of completing the search, it would be useful for me to be able to insert multiple values within the same field, for example in AB/XA I could enter multiple values at the same time (5/6), as well as in BC/AC, and so on, in so that the indicator is activated as soon as a combination of those values matches.
I search anharmonic indicators that can find custom harmonics, i've also find one that its okay and i have collected interesting information on non-traditional harmonics: they have an impressive win rate! The indicator name is Custom XABCD Validation and Backtesting Tool (open source), but for the purpose of completing the search, it would be useful for me to be able to insert multiple values within the same field, for example in AB/XA I could enter multiple values at the same time (5/6), as well as in BC/AC, and so on, in so that the indicator is activated as soon as a combination of those values matches. having already a code base, I believe that for a pinescript developer it is a piece of cake! if anyone have the time to give me a hand, I will gladly share with you all the r...
I'm looking for a skilled developer to update...controllers in my Laravel backend for my React Native application. Specifically, I need help with a single task to start, and if that goes well will task additional items thereafter: 1. Laravel Backend has a 'ProviderController' which sends 'Provider' results to app based on distance within radius. There is a 'Mobile Only' option that when checked is not limiting results to within that radius. The query is a bit messy, but is likely where the change needs to be made (see attached). App is published to TestFlight already and should not need to modify React Native source to address this, but can provide if needed. Ideally looking for a developer who can fix this bug fairly quickly, then will have on...
...give you access to the source site if needed, but you then ideally will be able to make sense of the setup and put things in place as intended to achieve this functionality without recreating the wheel. As an example, there is a Styles page for which a screenshot of the hero section is attached, showing Portfolio Items as well as Artists related to that style. The Artists are shown via a Query Builder query that uses a "Grandchild/Grandparent" relation, looking at the Portfolio Items related to the style, then checking the Artist that is related to those. So, the setup has no need to associate Artists to Styles, since Artists are Related to Portfolio Items that themselves are Related to Styles. This may sound complex, but you need not understand it from this&md...
I'm seeking a skilled data architect for providing consultation and recommendations on a Statement of Work (SOW) that involves data warehousing, ad hoc reporting, complex SQL format...recommendations on the SOW for data warehousing - Offering expertise on ad hoc reporting and complex SQL formation - Helping to streamline data storage and improve decision-making - Ensuring the architecture can support monthly data integrations Ideal candidates should have: - Proven experience as a data architect - Expertise in data warehousing and ad hoc reporting - Strong SQL skills, including complex query formation - Familiarity with streamlining and enhancing data storage - Experience in supporting monthly data integrations Your insights and guidance in this project are crucial for our lon...
...give you access to the source site if needed, but you then ideally will be able to make sense of the setup and put things in place as intended to achieve this functionality without recreating the wheel. As an example, there is a Styles page for which a screenshot of the hero section is attached, showing Portfolio Items as well as Artists related to that style. The Artists are shown via a Query Builder query that uses a "Grandchild/Grandparent" relation, looking at the Portfolio Items related to the style, then checking the Artist that is related to those. So, the setup has no need to associate Artists to Styles, since Artists are Related to Portfolio Items that themselves are Related to Styles. This may sound complex, but you need not understand it from this&md...
