Project: Modify SocialAds by Techjoomla to allow individual ad orders to select and be displayed in more than one "zone"
We are replacing our current banner ad system with SocialAds by Techjoomla. We need the ability to choose more than one display zone for each ad, since ads may need to be used in multiple locations (and/or multiple websites via the affiliate ad script). By default the SocialAds system requires a new ad order entry for each display zone, which is very inefficient for our ad production team.
[url removed, login to view]
Adding the select multiple option:
I haven't looked at the MySQL table yet to see if the selection can be handled by SocialAds as an array, but that would be my guess.
I've added a couple of screenshots to better show the project.
1. Is a shot of the SocialAds Administrator page. I have already modified the dropdown by adding multiple="multiple" and size="auto" so multiple value can be selected by the User.
2. Is a screenshot of the MySQL database table. As you can see each ad has a row in the table, but the "ad zone" column will only hold the first value selected. ***THIS is the main part of the project. To figure out the best way to handle multiple values selected.
3. Is a screenshot of our test ad display page.
After looking, the data will need to be normalized, since using multiple "zone" values creates and "many to many" relationship and I don't think we want to use "FIND_IN_SET".
***More information about this process: (link) http://stackoverflow.com/questions/10628186/mysql-store-multiple-references-for-another-table-inside-one-cell-and-select-it
7 freelancer đang chào giá trung bình $232 cho công việc này
Hello There I can help you out to achieve this task. However it would be better if you could just show me on the website on what changes are required in the component. Thanks and Regards