Web of mmorpg
The website administrator creates a variation of the premium account (type, number of days, price), then in the user account panel of the site, the proposed variations of the premium appear.The user chooses the premium, chooses which of the game accounts he wants to buy, points are recorded, in the game bd table, the data of his accounts are filled membership - 1(Type of premium), expire - End of the premium.But in my version of the game, the premium accounts are implemented differently, you need to change the issue of the premium account.In the old version, the columns of the premium account were directly in the table with the game accounts, and now here is how:
What to do:
There is a separate table with columns:
id, accound_id, day_duration, status, start_date, end_date
When a user purchases a premium and then chooses which game account he wants it, the data must be kept as follows:
ID: Ordinary Number
account_id - here must be preserved the ID of the game account that the user has chosen
day_duration - The number of days of the premium - the data must be taken from the link database where the proposed premium is saved
Status - 1 (Premium active)
Start_date - Date of purchase of the premium
end_date - The date when the premium ends.In fact, the membership columns in the old version, this status in the new, you just need to keep 1.(Premium is active) and expire in the old version is end_date in the new.Similarly, you need to transfer the data that is stored in the membership game account table, expire to new status, end_date and keep it in a separate table.
Current freelance projects in the category Databases & SQL
Need a Power BI specialist to build management reporting based on BAS Accounting CORP
About the CompanyWe are a distributor of international sports brands in Ukraine. Accounting is maintained in BAS Accounting CORP.We are looking for a specialist who can help build a management reporting system for the company's management based on Power BI.Important: we are… Databases & SQL, Accounting Services ∙ 2 days 3 hours back ∙ 4 proposals |
Technical task: Integration of Telegram chatbot with BAS1. General Description It is necessary to implement the integration of the chatbot with the BAS system for the transfer and recording of data about products (orders). 2. Input Data (sent by the chatbot): Group ID Product name (with product code) Product price 3. Logic of… Enterprise Resource Planning (ERP), Databases & SQL ∙ 2 days 6 hours back ∙ 18 proposals |
1C data integration
Organize quality preparation and data transfer from 1C to BigQuery for further use in Looker:Organize the data according to the required fields.Prepare a clear structure of tables and intermediate datasets on which dashboards will be built.Set up data loading, gather key… Databases & SQL, Data Processing ∙ 3 days 21 hours back ∙ 9 proposals |
Development of a simple controlling and management record system in Google Sheets "turnkey"
Task name: Development of a simple controlling and management record system in Google Sheets "turnkey" for a construction company in Poland (+ online training and implementation assistance) About the company, context, and my main problem Hello, I am looking for an experienced… Databases & SQL, Accounting Services ∙ 5 days 2 hours back ∙ 36 proposals |
Development of an analytical Power BI dashboard
45 USD
This is our request, we need a person who understands Power BI: Screen 1: Strategic Cockpit (Financial Health of the Plant) Goal: To understand in 5 seconds, "where are we losing money and how much?". KPI Tiles (Top Bar): Overall margin (Actual vs Plan) in %. Amount of "lost… Databases & SQL ∙ 5 days 6 hours back ∙ 13 proposals |
Krivoi Rog