Оптимизировать нагрузку сайта на VPS сервер

It is necessary to connect the application form on the landing page to keycrm. I will provide all necessary access. Please write how much time and cost this task will take.

A program needs to be developed for Windows that allows connecting a jailbroken iPhone via USB cable and controlling it from a computer. Main functionality: Connecting the iPhone via USB. The program should quickly recognize the connected iPhone and operate through the cable to minimize delays and lags. Screen mirroring of the iPhone to the computer. (The phone's screen should be displayed on the computer in real-time) Controlling the phone using the mouse. The user should be able to click, swipe, scroll, and control the iPhone screen using the mouse from the computer. Text input from the computer. There should be a shared clipboard between the computer and the iPhone. File transfer from the computer to the iPhone. A function for uploading files from the computer to the phone's memory or to specific folders/apps needs to be added. Stable operation. The program should run smoothly, without significant delays, freezes, or connection drops. Compatibility: support for jailbroken iPhone, rootless jailbreak, iOS 16.7.12, connection via USB.

The project already exists and it works - the task is to solve the issue of Facebook restrictions when the number of posts per hour exceeds 3-4 (from 7 AM to 12 AM), client accounts are restricted by Facebook. Website - https://buzzpost.co.il/ Also, look for loopholes in the logic and in the project itself and fix them; again, the logic and the project are already working, but there are likely loopholes. The main task is to solve the problem with Facebook posting restrictions.

It is necessary to improve the existing macro. The macro itself might be simple; I don't know because it was passed to me by a former employee. The macro is used to create specifications. Since I work in retail, for each operation with the supplier, specifically for deliveries, we create specifications. However, it does not replace all the fields that are needed. I am providing the macro and the file that uses the macro. I have highlighted in yellow what needs to be done by the macro.

Project Goal Develop a system that allows managing a large number of TikTok and Instagram accounts and automatically posting relevant comments under selected videos using AI. Main Functionality1. Account Management It is necessary to implement the ability to connect accounts: TikTok Instagram For each account, store: login password cookies/session account status last activity date assigned proxyRequirements Support for 100 to 1000 accounts. Ability for bulk account import. Account validity check. Status display: active requires authorization blocked temporary restriction2. Proxy Management A proxy is assigned for each account. Requirements: HTTP HTTPS SOCKS5 Settings: 1 account = 1 proxy 2 accounts = 1 proxy custom mode Display: IP country speed status3. Content Search The system should search for videos by:TikTok hashtags keywords video link author's accountInstagram Reels hashtags profiles Filters: number of views publication date language country4. AI Comment Generation Module Integration: OpenAI API Claude API Gemini API Ability to choose a model.Comment Generation Parameters: comment length language style Styles: friendly interested expert provocative flirty custom prompt Example: Video: prediction for the Real - Barcelona match Comment: Interesting thought, but I think the total looks more promising here.5. Anti-Spam Logic To ensure comments are unique. Functions: random emojis different sentence structures text variability different posting delays Parameters: delay between comments delay between accounts6. Scheduler Ability to create a campaign. Campaign settings: account list hashtag list comment limit time interval Example: 100 accounts Search by: sportsbetting football prediction Each account: up to 10 comments per day7. Statistics Display: comments published errors blocked accounts number of replies number of likes on comments Graphs: day week month8. Interface Web Dashboard. Sections:Dashboard active accounts active campaigns statisticsAccounts account list import exportProxies proxy managementCampaigns create campaigns start stopAI Settings prompt settings model settingsLogs all system actionsTechnology Stack Backend: Python FastAPI Database: PostgreSQL Queues: Redis Automation: Playwright Frontend: React AI: OpenAI APIPerformance Minimum requirements: 100 accounts simultaneously Preferred: up to 1000 accounts