We need to add some functionality to our existing script which is used to display promotional items on front page. The original free script stores the information in MySQL database, each new item is identified by unique ID.
We can have 3, 6, 9 items displayed on front page (3 items per row, 3 colons, look at screenshot #1). The problem is that we can't have, say, 20 items listed in admin panel and choose which one we want displayed on front page - we must delete all the items not in use and keep only the items displayed currently on front page (screenshot #2), so in admin control panel we have only the set which is also published on front page. I'm not sure actually is the item deleted from database or we just can't see it in the list.
So basically we need modification to existing script that will allow us to have, say, 30 products stored in database which we can browse from admin control panel and choose which 3, 6 or 9 items from those 30 items will be displayed on front page - so 3,6 or 9 products will be active (published) and the rest - currently inactive but we can trigger the status back and forth choosing which item will be displayed.
When you choose which item to publish the script should report if you try to add more than 9 items and decline do so.
Of course, at one point of time we will delete some of these 30 items and replace them with new ones which should not change the way how they are currently displayed on front page.
I think in admin control panel (screenshot #2)in "Actions" column along with "Edit" and "Delete" should be one check box "Publish" or "Active" - that will be the easiest way to choose which product will be displayed, or it could be one button "Publish" or "Active" and status indicator (green/red icon or table cell background color) which will tell us that this particular product is published on front page.
So, let me repeat briefly what we need. Existing script should be modified to allow us to have up to 30 items in database stored at the same time and we should be able to choose which 3, 6 or 9 items will be displayed on front page the same way they are displayed right now. Those 30 items in database are not permanent so sometimes we will replace them with new items - the same way how it is performed by existing script.