
In Progress
Posted
Paid on delivery
I need a developer who can jump straight into the [login to view URL] code-base and tighten the connection between the site and our central PostgreSQL/MySQL database. The immediate focus is to: • Debug the login-time and redirect-time ad settings that occasionally mis-fire. • Wire up banner, video and interstitial ads so they display and track correctly. • Complete the remaining API endpoints that link the website to the central database, then write clear, developer-friendly documentation for them. • Refactor the existing Java and PHP code so the new API calls, wallet functions, recharge/payment gateway, subscription package management, CRM member tools, and illegal short-link controls run smoothly from the same backend interface. To succeed you’ll need solid PostgreSQL and MySQL skills plus fluency in both Java and PHP. I already have short-link creation, access tracking, data export and a basic member dashboard in place; your work will elevate these pieces and make daily site-to-database tasks seamless. Please outline relevant projects you have completed, note any questions about the current architecture, and suggest how you prefer to structure the hand-over for the finished API docs.
Project ID: 40691406
169 proposals
Remote project
Active 4 days ago
Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

Hello! I have reviewed your [login to view URL] API & Ads Debug project requirements. With extensive experience in Java, PHP, PostgreSQL, MySQL, and full-stack API development, I can jump straight into the [login to view URL] codebase to stabilize your ad settings, connect remaining database endpoints, and refactor your backend architecture. Proposed Technical Approach Ad Settings & Tracking Debug: Inspect and resolve redirect-time and login-time ad misfires while properly wiring up banner, video, and interstitial ad scripts for accurate display and event tracking. API Development & Documentation: Complete missing endpoints linking the web interface to your central PostgreSQL/MySQL databases and produce clean, developer-friendly documentation (structured via Postman collections or Markdown). Backend Refactoring: Unify wallet functions, payment/recharge gateways, subscription package logic, CRM member tools, and short-link controls into a single streamlined backend. Quick Questions to Clarify How are PostgreSQL and MySQL currently segregated across your Java and PHP components? Do you have a preferred format for the final API documentation handover (e.g., Swagger/OpenAPI or Markdown)? I am ready to start immediately and deliver a robust, scalable backend setup within your 7-day timeline. Let's discuss this further!
$30 USD in 7 days
2.0
2.0
169 freelancers are bidding on average $136 USD for this job

The weak point here is not just the missing endpoints, it’s the inconsistency between ad logic, redirects, and backend data flow. When login-time triggers, tracking, wallet actions, and package controls are handled across mixed Java/PHP layers without one clean contract, small misfires turn into daily operational issues. I’d start by tracing the auth/redirect flow, mapping current API coverage, and then tightening the database-facing layer so ads, payments, and member tools behave predictably. I’ve worked on API debugging, payment/recharge flows, CRM-style member areas, tracking fixes, and PHP/MySQL backend refactors where legacy logic had to be stabilized before new features could safely sit on top. PostgreSQL/MySQL sync points, redirect bugs, and event-tracking gaps are usually solvable once the current request flow and schema ownership are made clear. For handover, I’d document each endpoint with request/response examples plus dependency notes so another developer can pick it up easily. - Is the Java side a web app/backend service, or is it supporting a separate module tied into the PHP site? - Do you already have API specs/schema docs, or would the first step be reverse-mapping the current architecture from code? - Which ad providers and payment gateway are currently connected?
$250 USD in 7 days
9.4
9.4

Hi, I have extensive experience in PostgreSQL, MySQL, Java, and PHP. I will start by debugging the login-time and redirect-time ad settings, then wire up banner, video, and interstitial ads for correct display and tracking. I will complete the API endpoints, refactor the code, and ensure smooth operation of all backend functions. Let's discuss further. Regards, Sai Bhaskar
$75 USD in 2 days
7.8
7.8

Hello Greetings, After reviewing your project description, I feel confident and excited to work on this project for you. But I have some crucial questions to clarify. Please leave a message on chat so we can discuss this, and I can share my recent work similar to your requirements. Thanks for your time! I look forward to hearing from you soon. Best Regards.
$250 USD in 4 days
8.0
8.0

What you need here is less “feature coding” and more backend stabilization across several connected systems. Ad misfires at login/redirect usually point to timing, state, or data-resolution problems, and if that sits beside unfinished APIs and split Java/PHP logic, the platform becomes harder to trust every day. I’d begin with a focused audit of the current request flow, database touchpoints, and shared business rules before refactoring the API-facing layer. I’ve worked on backend fixes involving PHP applications, database-driven dashboards, event/ad tracking, subscription logic, and admin/member tools where the challenge was cleaning up what already existed without breaking live functions. With PostgreSQL/MySQL environments, the important part is making sure ownership of data and write paths is explicit before adding or finishing endpoints. For the docs, I’d keep them practical and handover-friendly rather than generic. - Are both PostgreSQL and MySQL actively used by the live site right now, or is one acting as the central source and the other as legacy support? - Which parts of the wallet/recharge/subscription flow are currently stable, and which are still showing failures?
$250 USD in 7 days
7.8
7.8

The main risk in this build is that ad delivery, redirects, wallet logic, and API/database calls are all touching the same flow, so one loose piece can create false ad triggers or broken member actions. I’d approach it by isolating the auth/redirect path first, validating how ad settings are being resolved, then standardizing the API layer that talks to PostgreSQL/MySQL before refactoring the surrounding Java and PHP code. I’ve handled mixed-codebase backend cleanup work where existing dashboards, tracking, exports, and account tools were already live but unreliable because integrations had grown unevenly over time. This kind of job usually comes down to making the backend contract cleaner, reducing duplicate logic, and documenting the final endpoints properly so future updates do not reopen the same bugs. I can structure the API handover as developer docs with endpoint purpose, params, auth rules, sample payloads, and error cases. - Is there a staging environment where login, redirects, ads, and payments can be tested safely? - Are the remaining API endpoints already partially coded, or do they still need to be designed from scratch? - For illegal short-link controls, what rules are currently being used to flag or block them?
$250 USD in 7 days
7.2
7.2

Hi, I went through your project details and understand what you're looking to achieve. I'd be interested in working with you on this. Based on the requirements you've shared, I can handle the project from start to completion while keeping the work aligned with your expectations, timeline, and desired outcome. My approach is straightforward: first, I'll make sure the requirements and expected deliverables are clear. Then I'll complete the work in structured stages, share progress along the way, incorporate your feedback, and deliver the final work after everything has been reviewed. Before we begin, I have a couple of questions about your requirements that will help me understand the scope more accurately. Feel free to message me so we can discuss the details and determine the best way to move forward. Best regards, Anum
$250 USD in 1 day
6.6
6.6

Hello!! The Earnway Art platform will be debugged and stabilized by tracing PostgreSQL/API issues, fixing broken ad-related functionality, and ensuring the existing application works reliably without disrupting completed features. * Do you already have the current source code and database access ready? * Which API or advertising issue is currently the highest priority? * Can you share the main errors or affected pages? The solution will cover PostgreSQL troubleshooting, API debugging, backend fixes, ad integration checks, database query optimization, error handling, regression testing, and deployment verification. Existing functionality will be reviewed first so fixes remain focused and safe. Relevant PostgreSQL, API integration, backend debugging, advertising, and full-stack projects have been completed before, with a practical focus on finding the root cause rather than applying temporary fixes. Let us review the current issues in chat and get the platform stable. Best regards Farhin B
$110 USD in 1 day
6.8
6.8

Hi, I'm Denis, a full-stack developer specializing in PHP and Java backends with PostgreSQL and MySQL databases. I've debugged similar ad-serving systems where synchronization issues caused inconsistent delivery and tracking problems. Your core issue is that your site and database aren't fully synchronized, causing ad settings to misfire and creating gaps in your API layer. You have the foundation—short-link creation, tracking, member dashboard—but the backend needs tightening so payments, subscriptions, CRM functions, and ad logic flow reliably through one coherent interface. I've refactored similar projects, taking loosely coupled PHP and Java code and rebuilding the API layer so wallet functions, payment gateways, and ad delivery talk to the database consistently. My approach: 1. Review your codebase and database schema to identify disconnects 2. Trace and fix ad-firing bugs in login and redirect logic 3. Wire up banner, video, and interstitial ad endpoints 4. Complete remaining API endpoints and refactor code to use them consistently 5. Document each endpoint clearly for future maintenance Before starting, I'd clarify: Do you have existing tests for ad delivery logic? How do you currently track impressions and clicks—logged directly or queued? These details shape the refactoring structure. I'll deliver comprehensive API documentation with endpoint definitions, examples, and error handling notes, enabling your team to maintain and extend it independently. I'm ready
$100 USD in 2 days
6.4
6.4

As a full-stack developer and a leader at Fourge, I bring an array of skills and expertise to your table. With an impressive proficiency in Java, PHP and databases like PostgreSQL and MySQL- the same repositories that you use, I'm confident I can effectively debug and restructure the Codebase for earnway.art. In terms of relevant projects, I’ve built numerous APIs from scratch utilizing features like login systems, Ad tracking mechanisms, wallets, AP scripts connections with Database etch. Your requirements resonate perfectly with my experience. To ensure the handover of the finished API docs is streamlined, I suggest clearly highlighting not just how each API endpoint functions but also their specific purpose. At the same time, I will be able to incorporate a good measure of developer friendly documentation for easy understanding and future edits. I understand that boostinating these features is crucial for your business as it would enhance daily site-to-database functionalities. Partnering with me means getting an experienced hand, who workscollaboratively with other developers or teams because I know how crucial team synergy is to project success. Another distinguishing quality I bring is a focus on end-to-end solutions driven by streamlined architecture development as proven in my past works that define my core work principle to solve problems efficiently rather than merely fixing symptoms.
$200 USD in 7 days
6.4
6.4

Hi, You're aiming to tighten the site-to-database integration and stabilize the login-time and redirect-time ad behavior, with a unified backend for the Java and PHP components. I’ve done similar work where ad signals and payment flows depend on precise data contracts across PostgreSQL and MySQL, while keeping dashboards and exports intact. Execution approach: I’d start by validating the current login/ad flow in the live code path, isolate flaky parts, then implement the remaining API surfaces against real usage patterns and surface clear, developer-friendly docs. One technical risk / key challenge: Keeping data consistency across two databases while refactoring backend calls can introduce subtle drift. Two clarification questions: What edge cases should we cover for ad state reconciliation if records mismatch during a deployment? Who owns the API docs handover and how should versioning be handled for ongoing changes? If we're aligned, I can outline the implementation phases before kickoff. Best regards, Brandon
$100 USD in 1 day
6.0
6.0

Drawing on my extensive experience in full-stack development, software architecture, and proficient skills in PostgreSQL, MySQL, Java, and PHP, I can offer you a comprehensive solution to debug the ad settings, wire up ads for accurate tracking, complete API endpoints, and solidify the backend functionality. Having worked on a variety of projects including inventory management systems, financial platforms, and even gaming apps with databases like PostgreSQL, I am adept at understanding and streamlining complex data operations. Choosing me means not only getting a high-skilled professional but also an intelligent thinker who can anticipate potential issues and provide appropriate solutions. My deep knowledge of front-end languages such as HTML/CSS, Bootstrap alongside JavaScript libraries like AngularJS and React JS can also be leveraged if required. Let's take your website from its current status to an elevated platform that's capable of seamless operations every single day.
$140 USD in 4 days
6.1
6.1

Ad misfires at login and redirect usually trace back to session state being read before the ad config resolves, not the ad SDK itself. I'll audit the Java and PHP handlers, finish the missing endpoints against your Postgres/MySQL schema, and ship OpenAPI docs with request/response samples for wallet, recharge and short-link controls. Past work covers Laravel systems, Java backends and PostgreSQL API jobs. You can see my past work and reviews here: https://www.freelancer.com/u/shayankhan333 1) Which gateway powers recharge, and is it live or sandbox? 2) Are Java and PHP sharing one auth layer, or separate sessions? Cheers Shayan
$55 USD in 3 days
5.7
5.7

hello, on a platform that pays people for ad views, every incentive in your user base points at the wallet, so that is where i would look first. the specific thing that ends these projects is a balance stored as a number and incremented. two withdrawal requests arriving at the same moment both read the old balance, both pass the check, and the money leaves twice. it is not exotic, it is the first thing anyone probing a payout system tries. the fix is a wallet that is an append only ledger with the balance derived from it, withdrawals locked to a single terminal state, and gateway callbacks made idempotent so a retry never pays again. the ad tracking has the same shape. impressions counted in the browser are self reported by the party being paid, so those counts need server side verification and per session deduplication or your costs and your payouts drift apart. honest note on scope. ads, the remaining endpoints, wallet, payments, subscriptions, CRM and a Java and PHP refactor are four or five projects, well beyond this budget. i would start with the money path. is the wallet crediting real balances today, and where are payouts triggered from? why both Java and PHP? is one of them being retired? have a nice day.
$450 USD in 12 days
5.6
5.6

I've built and maintained multi-tier ad systems with PHP/Java backends connected to PostgreSQL databases—handling login flows, ad delivery pipelines, and payment gateway integrations across several production platforms. This is right in my wheelhouse. I'll start by auditing the current API endpoints and database schema to identify the ad mis-fire root cause (likely session state or redirect timing), then wire the banner/video/interstitial ad stack with proper event tracking and state validation. Next I'll complete the remaining endpoints for wallet, recharge, subscription, and CRM member tools, refactoring the Java and PHP layers so they share a single coherent interface instead of duplicated logic. Once the API is solid and tested end-to-end, I'll document each endpoint with curl examples and architecture notes so your team can extend it without friction. I can start immediately and will flag any schema or architectural questions as I move through the codebase. Thanks, Andrii.
$175 USD in 3 days
5.3
5.3

I have complete command over PostgreSQL and MySQL and fluency in Java and PHP – skills that the task at hand specifically calls for. With your prior setup of short-link creation, access tracking, data export and a basic member dashboard in place, what you need now is someone who can elevate these features while making daily operations run smoothly. My expertise doesn't end at just fixing things; I dive deep to understand precisely what's breaking or missing before architecting a system that can work without manual intervention. Clients choose to work with me because of my clear communication style; I lay down explanations that are easy to understand without undermining their depth. Taking into account the finicky nature of integrations, my clients appreciate my reliability and ap
$200 USD in 5 days
5.4
5.4

Hello, The line that jumps out is "run smoothly from the same backend interface," because right now you have Java and PHP, plus PostgreSQL and MySQL. That split is almost certainly the root of the problems, so I'd start there. The part that worries me most is the wallet and payments. If the balance, recharges and subscriptions are touched by both the Java and PHP sides, or live across two databases, the balance can drift, and with money that's the one thing you can't afford. So before refactoring, I'd map which language and database owns each piece, then give the wallet and payments a single source of truth, one database, with real transactions, so a recharge and a balance change can't half-apply. The other backend calls it via API, but only one place changes the money. Tied to that: a recharge is confirmed by the gateway's webhook, never the browser returning, and keyed so a retry can't credit twice. That alone fixes a class of wallet bugs. On the ads mis-firing at login and redirect, that's usually timing: the ad decision runs before the session or redirect is ready, or it's decided in cached output. I'd run the ad logic after the page settles and tie each view to the creator ID for correct tracking. For the API docs, I'd write them as OpenAPI/Swagger, testable, not just a text file. One question: which side owns the wallet and payment data today, Java or PHP, and is it in PostgreSQL or MySQL? That's the first thing to pin down, since it decides the whole refactor.
$100 USD in 3 days
5.4
5.4

As an experienced API developer and engineer, I feel like I'd be the perfect match for your project. I've tackled similar problems involving connection between websites and databases in the past. My proficiency in MySQL and PostgreSQL combined with my fluency in Java and PHP will not only help me debug the existing ad settings but also enable me to create new API endpoints seamlessly syncing your website with the central database. Beyond just addressing your immediate needs, I aim to provide you with a refined backend interface that encompasses all core functionalities like the API calls, wallet functions, subscription package management, CRM member tools and more – all working cohesively and smoothly. Having a dashboard already in place is an asset, which will enable me to leverage those current features and build upon them for maximum effectiveness. Having worked across multiple industries with clients worldwide, including CMS, eCommerce & CRM solution projects, I bring a wealth of knowledge that can truly elevate the architecture of Earnway.art. I'm particularly focused on delivering quality results that stand up to long-term business growth. We can commence a smooth hand-over process after project completion through detailed documentation that's clear, developer-friendly and tailored to your specific needs. Let’s team up towards making your platform even more efficient.
$50 USD in 4 days
5.4
5.4

Hi, I can jump into the existing codebase and help stabilize the connection between the website and your central database. I have experience with PHP, Java, PostgreSQL, MySQL, API integrations and backend systems, including payment, wallet and member management flows. I can troubleshoot the ad and redirect issues, complete the remaining API endpoints and refactor the existing code without disrupting what is already working. I’ll also keep the API documentation clear and practical for future developers. Thanks
$140 USD in 7 days
5.2
5.2

Hi, I can debug the ad firing logic and complete your API layer so the site, database, and payment flows actually talk to each other without friction. I've worked through similar database sync issues on a SaaS platform—the ads weren't firing because the redirect middleware wasn't waiting for the database query to finish, which we fixed by restructuring the request pipeline. My approach would be to map out the exact data flow between your Java backend and PHP frontend first, then tighten the PostgreSQL queries and add proper transaction handling so ad settings and wallet updates stay consistent. The real win comes from centralizing your API endpoints so login redirects, ad tracking, and payment processing all read from the same source of truth instead of fighting each other. This means fewer support tickets when ads don't display, faster payment processing, and your team can actually maintain the codebase after I'm done. I'll provide two weeks of bug fixes and refinements after delivery, so if edge cases pop up once you're running live, we catch them early. Happy to review your current architecture and flag any questions before we lock in the approach. Thanks, Lazar.
$30 USD in 1 day
5.0
5.0

The ad mis-fires at login and redirect usually mean race conditions between session writes and your ad-impression tracking, especially if you're mixing Java session state with PHP cookie reads or hitting the database before the user record is fully committed. I'd add a lightweight Redis layer between the two so ad calls wait on a confirmed session token instead of polling half-written rows, then refactor the existing endpoints to use prepared statements and a single connection pool so wallet, recharge, and CRM queries don't spawn competing transactions. I built an 81-table PostgreSQL invoicing platform with Supabase RLS and 17 edge functions, plus a VPS stack with MariaDB and licensing-server integration under 24 hours, both at ffulb.com. If you can share SSH, database credentials, and repo access I can assess the current session flow and ad-tracking logic, then map out which endpoints need finishing and how to structure the handover docs.
$150 USD in 3 days
5.0
5.0

Bangkok, Thailand
Payment method verified
Member since Feb 12, 2023
$10-30 USD
$10-30 USD
$30-250 USD
$30-250 USD
$30-250 USD
£20-250 GBP
$250-750 USD
$30-250 USD
$8-15 USD / hour
₹37500-75000 INR
₹12500-37500 INR
₹12500-37500 INR
₹1500-12500 INR
$250-750 USD
$30-250 USD
₹12500-37500 INR
$8-15 AUD / hour
₹1500-12500 INR
₹600-1500 INR
₹12500-37500 INR
$750-1500 AUD
₹1500-12500 INR
$30-250 USD
₹600-1500 INR
₹12500-37500 INR