I am looking to import API data for each Item, Monster and NPC located in an existing online game API into a table in a Joomla article.
For each item, monster or NPC that exists in the API, a Joomla article must be created in the correct Joomla category.
- The Joomla article table should contain the following details from the item API: Item name, item icon, Release date, Members?, Quest item, Properties, Tradeable?, Equipable?, Stackable?, Noteable?, Destroy method?, Examine, current grand exchange price, change in price over the last 24 hours, 30 days, 90 days and 180 days (and a chart to show the 24 hour, 30/90/180 day price changes) High Alch value, Low alch value, Weight, Buy limit, Daily volume.
- The Joomla article table should contain the attached API details of a Monster. See the attached brown image.
- The Joomla article table should contain the attached API details of a Non-Player-Character (NPC): Name, Release date, combat level, member?, Race, Location, Sells, Quest NPC?, Examine.
I work with Joomla 3.9.20. I will give you access to the Joomla administration articles and categories interface.
Ideally you should provide instructions on how I can insert the above API data into the Joomla mySQL database using Phpmyadmin import function so that each item and weapon can be auto-inserted and represented in a neat and legible table in each of their own Joomla articles. I can provide a screenshot of the current CSS table style that I would like to use.
Summary: As the API data exists the bulk of the work is 'done'. This task merely involves importing and presenting such items listed in the API data into a table within each of their own Joomla articles automatically via Phpmyadmin.
Notes: 1. The above work must not cause disruption to the functioning of Joomla.