Branch: patch-2.0.3
Cellxpert API initial testings
Cellxpert API initial testings
Branch: patch-2.0.2
Maintenance on general features in the system and API
Fixes to the general reports and minor expansions to API
New scripts
- Bitsler Partners
- 7K Partners
- Esportiva Bet Affiliates
- One Affiliate Club
- Traffikongs.com
- Bet and you partners
- Alanbase
- Mostbet
Fixes to existing scripts
20+ fixes to scripts across Voonix
Branch: patch-2.0.1
Data validation
Extend Data validation to include more data and optionally show it on accounts in earnings on Advertiser Login breakdown
ALTER TABLE `tracker_logins_columns` ADD `tlco_campaign_key` VARCHAR(255) NOT NULL AFTER `tlco_fk_login`, ADD `tlco_campaign_name` VARCHAR(255) NOT NULL AFTER `tlco_campaign_key`, ADD `tlco_brand` VARCHAR(255) NOT NULL AFTER `tlco_campaign_name`, ADD `tlco_product` VARCHAR(255) NOT NULL AFTER `tlco_brand`, ADD `tlco_date` VARCHAR(255) NOT NULL AFTER `tlco_product`;
New error code for identical login issues
New error code for identical login issues
INSERT INTO `error_codes` (`erro_key`, `erro_text`) VALUES ('invalid_credentials_identicals', 'Invalid credentials on an identical login');
20+ minor import script updates
We have made minor changes to 20+ import scripts to help get better data.
New affiliate systems supported
New affiliate systems now supported in Voonix:
Branch: patch-2.0.0
Large rework to imports
Important This update includes major updates to imports, we therefor encourage extra care when downloading this. Please make sure to check thoroughly after download to ensure it works. This includes automatic as well as manual imports. This is primarily technical in the background, for more information please have a look at our blog post here.
Handle larger API keys
Change API keys to handle 800 characters for Cloudbet
ALTER TABLE `tracker_logins` CHANGE `tlog_remote_key1` `tlog_remote_key1` VARCHAR(800) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL, CHANGE `tlog_remote_key2` `tlog_remote_key2` VARCHAR(800) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL;
Import queue & status improvements
Overhaul of the import queue with several new features. queueingmultiple imports and months.
ALTER TABLE `import_queue` ADD `impo_month` DATE NOT NULL AFTER `impo_instance`, ADD `impo_manual` INT NOT NULL AFTER `impo_month`, ADD `impo_fk_tlog` INT NULL AFTER `impo_fk_advertiser`, ADD `impo_data` INT NOT NULL AFTER `impo_manual`,ADD `impo_nodata` INT NOT NULL AFTER `impo_data`, ADD `impo_errors` INT NOT NULL AFTER `impo_nodata`, ADD `impo_paused` INT NOT NULL AFTER `impo_errors`, ADD `impo_fk_admin` INT NULL AFTER `impo_id`, ADD `impo_fk_status` INT NULL AFTER `impo_paused`, ADD `impo_success` INT NOT NULL AFTER `impo_paused`; ALTER TABLE `tracker_logins` ADD `tlog_rows_imported` INT NOT NULL AFTER `tlog_optional_id`; TRUNCATE TABLE import_queue;
Performance improvement
Summary stats to increase performance. New crontab required to "scripts/getUnlinkedCampaignsCount.php?run_script&folder=
CREATE TABLE summary_stats (`sust_id` INT NOT NULL AUTO_INCREMENT , `sust_unlinked_campaigns` INT NOT NULL , PRIMARY KEY (`sust_id`)) ENGINE = InnoDB;
Affiliate Markets functionality
We are slowly beginning to add functionality to the affiliate markets for advertisers. "iGaming" has been discarded, in favor of "All" and a few new markets are added and changed.
UPDATE `advertisers` SET `adve_affiliate_market` = 'All' WHERE `adve_affiliate_market` LIKE 'iGaming'
New currency TRY
We have added the currency TRY.
40+ minor import script updates
We have made minor changes to 40+ import scripts to help get better data.
Branch: patch-1.7.1
MyAffiliates revshare improvements
Improvements to MyAffiliates to get better revshare income for hybrid accounts. This includes languages and additional methods if original ones fail.
GVC Netrevenue improvements
Added GVC Netrevenue options to further improve stats.
New currency added (KES)
Added a new currency to Voonix, KES
1xPartners update
Due to changes in 1xPartners (and their similar whitelabels/brands) we have updated our script to try and better match the accurate data.
Minor updates to 25+ scripts
Minor updates to 25+ scripts
Branch: patch-1.7.0
Import Schedule range increase
The range for import schedule has been increased to stretch even further.
NEW SCRIPT: Bettilt partners
We have created a script for Bettilt Partners to be imported automatically.
MyAffiliates Hybrid change
We have updated MyAffiliates to hopefully work better with hybrid accounts that consists of CPA and REV only tables. If the table in MyAffiliates does not contain a percentage in the billing title/description the script will not assume that it's purely revshare, but rather expect it to be CPA directly. In this case you may see zero earnings in revshare compared to before. This is to avoid CPA income accidentally ending in revshare.
Quints multiple brand IDs (IF!)
If you are using lettered brand IDs you are now able to add multiple to brand ID. You can do so by comma separation like so "NG,BR,JBCL". Note: This does not apply to the numerical IDs in which case it wont work.
Additional note field
We have added an additional note field called extra note to logins. You can use this for anything you might need, if your existing note field is already occupied.
ALTER TABLE `tracker_logins` ADD `tlog_extra_note` TEXT NULL DEFAULT NULL AFTER `tlog_note`;
For any previous patches please visit the link below
We moved parts of the old patches in order to optimize this structure internally. They can all still be found below.
Patches 1 through 1.6 can be found here.