Well, you can do that programmatically. That's what the interface does — it's just code, not magic :)
You need to modify the #__update_sites table and set the extra_query column to dlid=YOUR_DOWNLOAD_ID for the records that have to do with our software that has Professional editions (Admin Tools, Akeeba Backup or Akeeba Ticket System).
You can use the SQL query below, as long as you replace two things:
- CHANGEME_ is the table name prefix of your site. Look in configuration.php, it's state in the $prefix line. Do not forget the trailing underscore.
- YOUR_DOWNLOAD_ID is your Download ID. If you are using an Add-on Download ID replace : with %3A. For example, the add-on download ID 123:abcdef01234567890abcdef01234567890 becomes 123%3Aabcdef01234567890abcdef01234567890
UPDATE `CHANGEME_update_sites`
SET `extra_query` = "dlid=YOUR_DOWNLOAD_ID"
WHERE `update_site_id` IN (
SELECT `update_site_id`
FROM `CHANGEME_update_sites_extensions`
WHERE `extension_id` IN (
SELECT `extension_id` FROM `CHANGEME_extensions`
WHERE `type` = 'package' AND `element` IN (
'pkg_akeeba', 'pkg_admintools', 'pkg_ats'
)
)
)
I am not convinced that for real world use this is any faster than going through the interface.
Nicholas K. Dionysopoulos
Lead Developer and Director
🇬🇷Greek: native 🇬🇧English: excellent 🇫🇷French: basic • 🕐 My time zone is Europe / Athens
Please keep in mind my timezone and cultural differences when reading my replies. Thank you!