Results and jackpots refreshed on their own, where the pages had static images before.
Lottery review site · — · 2022–2023
A WordPress plugin that keeps lottery results up to date by itself
I replaced static result images with live draws, results and jackpots from two data sources, updated on their own.
A lottery API and an operator's feed, with different fields, merged into one set of tables.
The site reviews online lotteries, and its pages showed results as static images, so every new draw left old data on it. The owner wanted real results, the next draw and the biggest jackpots, updated with no one touching them. The data existed in separate sources with different fields, and none of it was on the site.
I started with the data. I studied and documented the main lottery API and compared it with a lottery operator’s feed, and only then planned the widgets. I built it as a separate plugin, so a new theme does not break it. Both sources write into the plugin’s own tables, and a currency API converts the jackpots. Lottery data refreshes every 8 hours, currency rates once a day.
Three widgets go in by shortcode: results with history, the next draw and the top jackpots. The table adapts to the width of its column, since it sits in columns of different sizes. The owner’s SEO check found that the history table was really two tables, one of them hidden, so I rebuilt it as one real table with a header row.
On the owner’s host the scheduled jobs and outgoing requests failed, while locally they worked. I diagnosed it and made the case for a plugin that works out of the box on any hosting. I assessed a third data source by the number of requests it would need, and the owner parked it.
I showed the plugin to the owner on calls and handed it over on staging with a how-to guide. After handover I traced a draw-date bug to the query, and showed that many «missing» widgets were gaps in the source data itself.
I delivered the plugin in December 2022, and the owner installed it on his site. His pages got fresh results, the next draw and the top jackpots from live data, with no one updating them by hand.
I’ve had the pleasure of working with Serhii for the past eight years, primarily on long-term client projects where he has served as a lead full-stack developer. Over the years, we’ve worked together on complex web applications, integrations, mobile apps, and interactive 3D projects. Serhii consistently stands out for his ability to solve complex technical problems, maintain a high standard of code quality, improve performance, and quickly adapt to unfamiliar technologies when a project requires it. One of his strongest qualities is that he doesn’t just implement requirements. He looks at the bigger picture, identifies potential issues early, and often finds opportunities to improve the product before they become problems. On one of our virtual museum projects, for example, he identified and optimized several processes that significantly reduced loading times and made the overall experience feel seamless. Serhii is also someone I can trust to take a project from requirements through implementation and delivery with a high degree of independence. That gives me a great deal of peace of mind when managing complex client projects. He takes ownership, is highly reliable, and communicates well with clients. Beyond his own development work, Serhii has mentored several developers who joined our team and has become the person we naturally turn to when discussing technical architecture, implementation approaches, or choosing the best solution for a difficult problem. After working together for so many years, I can confidently recommend Serhii for senior full-stack, lead developer, technical lead, and solution architecture roles. He combines strong technical ability with sound judgment, ownership, and the ability to deliver.
ExpertSure & Ecopreneurist: WordPress sites, plugins and a store
Since 2023 I've been the developer of a UK publisher's comparison sites: merged installs, custom plugins, fixes and a domain store.
Making an e-book sales page readable on phones
On a one-page e-book sales page the text was tiny on phones and the page scrolled sideways. I fixed both on top of another freelancer's half-done responsive attempt.
Tim Plunkett: a print company's website and a Coming Soon page
Two jobs I did in 2019 for a client in Sydney: a print company's five-page site from PSD mockups and a Coming Soon page for a new shop.