Changelog & updates

2023-12-11 Patch 1.6.8

Branch: patch-1.6.8

Improvements and fixes to scripts

Improvements and fixes to scripts

2023-12-04 Patch 1.6.7

Branch: patch-1.6.7

Improvements and fixes to scripts

Improvements and fixes to scripts

2023-11-28 Patch 1.6.6

Branch: patch-1.6.6

Improvements and fixes to scripts

Improvements and fixes to scripts

2023-11-21 Patch 1.6.5

Branch: patch-1.6.5

Improvements and fixes to scripts

Improvements and fixes to scripts

2023-11-14 Patch 1.6.4

Branch: patch-1.6.4

Various updates and fixes to scripts

Various updates and fixes to scripts

Minor improvements to reports

Minor improvements to reports

2023-11-03 Patch 1.6.3

Branch: patch-1.6.3

New report: Earnings

We have created a new report with new data available in Voonix. It's called "Earnings" and can be located under special reports.

The intention is to get your actual earnings as shown in the affiliate system for those that have it available. Not all is included, for a detailed list see your report in Voonix.

This report can be used as a great helpful tool when doing finances and invoicing the various operators.

Report optimization

Reports have received a long awaited optimization in the form of data being correctly presented according to an account logic basis.

This means that all reports will consider if the account is overall positive before using the revenue based metrics in any totals. The idea behind this is to present more accurate data everywhere and not only in advertiser earnings.

For a detailed explanation feel free to reach out to Voonix directly.

Cellxpert multiple brand IDs

Updated Cellxpert to work with multiple brand IDs

Fixed Wynta

More Generation Web integration

Integrated different Generation Web versions

Overall improvements to 10+ scripts

Minor improvements and fixes to 10+ scripts.

SQL: Basic event logging

CREATE TABLE event_log (evlo_id int(11) NOT NULL, evlo_ip varchar(62) NOT NULL, evlo_time timestamp NOT NULL DEFAULT current_timestamp(), evlo_fk_admin int(11) NOT NULL, evlo_comment text NOT NULL, evlo_fk_type int(11) NOT NULL, evlo_before text DEFAULT NULL, evlo_after text DEFAULT NULL, evlo_changes text DEFAULT NULL) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

ALTER TABLE event_log ADD PRIMARY KEY (evlo_id);

ALTER TABLE event_log MODIFY evlo_id int(11) NOT NULL AUTO_INCREMENT;

2023-10-25 Patch 1.6.2

Branch: patch-1.6.2

Added a new currency ARS

Overall improvements to 20+ scripts

Minor improvements and fixes to 20+ scripts.

2023-09-27 Patch 1.6.1

Branch: patch-1.6.1

Enable baseline posibility for Sarah Enterprises v2

Baseline warning

Since baseline has now been enabled for Sarah Enterprises v2, keep in mind that NOT enabling baseline will allow Voonix to use FTDs as CPAs. Find the query below if you wish to update all of them to have baseline enabled, disabling the chance of FTDs as CPA.

UPDATE tracker_logins SET tlog_baseline = 1 WHERE tlog_fk_advertiser IN (SELECT adve_id FROM advertisers WHERE adve_affiliate_system = 'Sarah Enterprises v2');

2023-09-18 Patch 1.6

Branch: patch-1.6

Overall improvements to 20+ scripts

Minor improvements and fixes to 20+ scripts.

New import scripts

  • Gambling Affiliation
  • GrandX Affiliates
  • Bona Fides Affiliates

Changes for earnings updates in the future

Changes for earnings updates in the future

SQL: Earnings additions

ALTER TABLE `earnings_data` CHANGE `edat_net_revenue` `edat_net_revenue` DOUBLE NULL DEFAULT '0', CHANGE `edat_gross_revenue` `edat_gross_revenue` DOUBLE NULL DEFAULT '0', CHANGE `edat_revshare` `edat_revshare` DOUBLE NULL DEFAULT '0', CHANGE `edat_cpa_commission` `edat_cpa_commission` DOUBLE NULL DEFAULT '0', CHANGE `edat_bonus` `edat_bonus` DOUBLE NULL DEFAULT '0', CHANGE `edat_extra_fee` `edat_extra_fee` DOUBLE NULL DEFAULT '0', CHANGE `edat_deposit_value` `edat_deposit_value` DOUBLE NULL DEFAULT '0', CHANGE `edat_deduction` `edat_deduction` DOUBLE NULL DEFAULT '0', CHANGE `edat_total` `edat_total` DOUBLE NULL DEFAULT '0';

New error code

New error code to give more precise instructions when certain group by options are missing from an affiliate system.

SQL: New error code

INSERT INTO `error_codes` (`erro_key`, `erro_text`) VALUES ('missing_group_by', 'Account is missing one or more required group by options in statistic report or API');

2023-06-19 Patch 1.5.9

Branch: patch-1.5.9

Improvements to performance for 20+ scripts

Improvements to performance for 20+ scripts

Changes for earnings updates in the future

Changes for earnings updates in the future

SQL: Earnings additions

ALTER TABLE `earnings_data` ADD `edat_gross_revenue` FLOAT NULL DEFAULT '0' AFTER `edat_net_revenue`;

CREATE TABLE `earnings_settings` (`eset_id` INT(11) NOT NULL AUTO_INCREMENT , `eset_login_url` VARCHAR(200) NOT NULL , `eset_username` VARCHAR(400) NOT NULL , `eset_carryover` INT(1) NULL , `eset_created` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP , `eset_created_by` INT(11) NOT NULL , `eset_updated` DATETIME NULL , `eset_updated_by` INT(11) NULL , `eset_history` TEXT NULL , PRIMARY KEY (`eset_id`)) ENGINE = InnoDB;

ALTER TABLE `earnings_data` ADD `edat_product` VARCHAR(50) NULL DEFAULT NULL AFTER `edat_brand`, ADD `edat_reward_plan` VARCHAR(150) NULL DEFAULT NULL AFTER `edat_product`;

ALTER TABLE `earnings_data` ADD `edat_total_manipulated` BOOLEAN NOT NULL DEFAULT FALSE AFTER `edat_currency`;

2023-04-26 Patch 1.5.8

Branch: patch-1.5.8

Major improvements to performance for 20+ scripts

Major improvements to performance for 20+ scripts

5+ new import scripts

5+ new import scripts

API: Siteearnings

Added site group name to siteearnings API

Changes for payout/earnings updates in the future

Changes for payout/earnings updates in the future

SQL: Earnings preparations (Old: Payout)

CREATE TABLE `earnings_data` (`edat_id` INT(11) NOT NULL AUTO_INCREMENT , `edat_fk_tracker_login` INT(11) NOT NULL , `edat_username` VARCHAR(400) NULL DEFAULT NULL , `edat_brand` VARCHAR(100) NULL DEFAULT NULL , `edat_login_url` VARCHAR(200) NOT NULL , `edat_campaign_key` VARCHAR(45) NOT NULL , `edat_date` DATE NOT NULL , `edat_currency` VARCHAR(10) NULL DEFAULT NULL , `edat_net_revenue` FLOAT NULL DEFAULT '0' , `edat_revshare` FLOAT NULL DEFAULT '0' , `edat_cpa_commission` FLOAT NULL DEFAULT '0' , `edat_bonus` FLOAT NULL DEFAULT '0' , `edat_extra_fee` FLOAT NULL DEFAULT '0' , `edat_deposit_value` FLOAT NULL DEFAULT '0' , `edat_deduction` FLOAT NULL DEFAULT '0' , `edat_total` FLOAT NULL DEFAULT '0' , PRIMARY KEY (`edat_id`)) ENGINE = InnoDB;

ALTER TABLE `earnings_data` ADD INDEX(`edat_fk_tracker_login`, `edat_username`, `edat_brand`, `edat_login_url`, `edat_campaign_key`, `edat_date`);

2023-04-14 Patch 1.5.7

Branch: patch-1.5.7

Overall improvements to 10+ scripts

Minor improvements and fixes to 10+ scripts.

New error code

New error code

SQL: New error code

INSERT INTO `error_codes` (`erro_key`, `erro_text`) VALUES ('invalid_credentials_or_missing_whitelist', 'Invalid credentials or missing whitelisting');

2023-03-03 Patch 1.5.6

Branch: patch-1.5.6

Overall improvements to 10+ scripts

Minor improvements and fixes to 10+ scripts.

Preparations for Microsoft SSO

Preparations for Microsoft SSO

SQL: Microsoft SSO

CREATE TABLE `single_signon_microsoft_settings` ( `ssms_id` int(11) NOT NULL, `ssms_client_id` varchar(256) NOT NULL, `ssms_tenant_id` varchar(256) NOT NULL, `ssms_client_secret` varchar(256) NOT NULL, `ssms_admin_level` int(11) NOT NULL DEFAULT 3, `ssms_approval_required` int(11) NOT NULL DEFAULT 1, `ssms_created` timestamp NOT NULL DEFAULT current_timestamp(), `ssms_created_by` int(11) NOT NULL ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

ALTER TABLE `single_signon_microsoft_settings` ADD PRIMARY KEY (`ssms_id`), ADD KEY `ssms_client_id` (`ssms_client_id`), ADD KEY `ssms_tenant_id` (`ssms_tenant_id`), ADD KEY `ssms_client_secret` (`ssms_client_secret`);

ALTER TABLE `single_signon_microsoft_settings` MODIFY `ssms_id` int(11) NOT NULL AUTO_INCREMENT;

Payout status changes

Payout status changes

SQL: Payout statuses

ALTER TABLE `payout_data` ADD `pdat_completed` INT NOT NULL DEFAULT '1' AFTER `pdat_period`, ADD `pdat_status` VARCHAR(15) NOT NULL AFTER `pdat_completed`

2023-02-02 Patch 1.5.5

Branch: patch-1.5.5

Overall improvements to 10+ scripts

Minor improvements and fixes to 10+ scripts.

2023-01-23 - Patch 1.5.4

Branch: patch-1.5.4

Fix for dashboard graphs

Updates to fix the dashboard graphs on some external servers

2FA (Functionality affect internal only)

New 2FA security for internal clients. Externals wont have the functionality as they have the flexibility of setting up other login setups

SQL: Create 2FA

CREATE TABLE `admin_2fa_auth` ( `a2fa_id` int(11) NOT NULL, `a2fa_fk_admin` int(11) NOT NULL, `a2fa_otp` varchar(100) NOT NULL, `a2fa_ip` varchar(256) NOT NULL, `a2fa_user_agent` varchar(256) NOT NULL, `a2fa_device_hash` varchar(256) NOT NULL, `a2fa_expiration_date` date NOT NULL, `a2fa_valid` int(11) NOT NULL, `created` timestamp NOT NULL DEFAULT current_timestamp() ) ENGINE=InnoDB DEFAULT CHARSET=latin1 COLLATE=latin1_swedish_ci;

ALTER TABLE `admin_2fa_auth` ADD PRIMARY KEY (`a2fa_id`), ADD UNIQUE KEY `a2fa_fk_admin` (`a2fa_fk_admin`,`a2fa_device_hash`), ADD KEY `a2fa_fk_admin_2` (`a2fa_fk_admin`), ADD KEY `a2fa_device_hash` (`a2fa_device_hash`);

ALTER TABLE `admin_2fa_auth` MODIFY `a2fa_id` int(11) NOT NULL AUTO_INCREMENT;

Overall changes and fixes to many different import scripts

2022-12-19 - Patch 1.5.3

Branch: patch-1.5.3

New error codes

New error codes to give better information

SQL: Error codes

INSERT INTO `error_codes` (`erro_key`, `erro_text`) VALUES ('missing_brand_id_extra', 'Missing brand ID Extra.');

INSERT INTO `error_codes` (`erro_key`, `erro_text`) VALUES ('invalid_brand_id_extra', 'Invalid brand ID Extra.');

Changes to baseline/CPA

MyAffiliates

SoftSwiss

Overall changes to many different import scripts

2022-11-08 - Patch 1.5.2

Branch: patch-1.5.2

Product toggles/switches to enable products

It is now possible to toggle product import on overall in settings, and for each login for affiliate systems where applicable.

SQL: Login toggle/switch for product import

ALTER TABLE `tracker_logins` ADD `tlog_product` INT NOT NULL DEFAULT '0' AFTER `tlog_baseline`;

Product changes to import scripts

GVCAffiliates (Also known as Entain)

Income Access

Overall improvements to 10+ scripts

Minor improvements and fixes to 10+ scripts. This includes some further preparations for payout data.

2022-10-13 - Patch 1.5.1

Branch: patch-1.5.1

Optional ID (Campaign)

Login Optional ID available in Campaigns module to view and search for across campaigns.

API Optional ID

Login and Advertiser Optional ID available in APIs for viewing, editing and when inserting rows.

Payout BETA

Payout BETA release. Imports will now fetch payout data at the 11pm(23:00) server time import

Report and API endpoint available for testing. Module is partly limited until future updates.

Overall improvements to 10+ scripts

Minor improvements and fixes to 10+ scripts. This includes some further preparations for payout data.

2022-08-08 - Patch 1.5

Branch: patch-1.5

Preparations for new Optional IDs

Created a new list that will display all logins and work with login Optional ID, also in searches.

Database table for Optional IDs

SQL: New Optional IDs (Note: multiple queries)

ALTER TABLE `advertisers` ADD `adve_optional_id` VARCHAR(255) NULL DEFAULT NULL;
ALTER TABLE `advertisers` ADD INDEX( `adve_optional_id`);
ALTER TABLE `tracker_logins` ADD `tlog_optional_id` VARCHAR(255) NULL DEFAULT NULL;
ALTER TABLE `tracker_logins` ADD INDEX( `tlog_optional_id`);

Further updates to Payout data

Preparations for Payout data to launch in BETA soon.

Database table for payout data in it's later stages

SQL: Payout dates

ALTER TABLE `payout_data` ADD `pdat_period` DATE NULL AFTER `pdat_date`;

Currency error code

Error code for issues with currencies

Note: Some servers might already have this

SQL: Allow error codes

INSERT INTO `error_codes` (`erro_key`, `erro_text`) VALUES ('missing_currency', 'Currency missing in affiliate system');

Country Report Nullables

Allow country data to be nullable

SQL: Allow nullable country data

ALTER TABLE `stats_data_country` CHANGE `sdac_signups` `sdac_signups` INT (11) NULL DEFAULT '0', CHANGE `sdac_deposits` `sdac_deposits` INT (11) NULL DEFAULT '0', CHANGE `sdac_active_players` `sdac_active_players` INT (11) NULL DEFAULT '0', CHANGE `sdac_new_active_players` `sdac_new_active_players` INT (11) NULL DEFAULT '0', CHANGE `sdac_new_deposits` `sdac_new_deposits` INT (11) NULL DEFAULT '0', CHANGE `sdac_deposit_value` `sdac_deposit_value` FLOAT NULL DEFAULT '0', CHANGE `sdac_gross_revenue` `sdac_gross_revenue` FLOAT NULL DEFAULT '0', CHANGE `sdac_ndc` `sdac_ndc` INT (11) NULL DEFAULT '0', CHANGE `sdac_qndc` `sdac_qndc` INT (11) NULL DEFAULT '0', CHANGE `sdac_total` `sdac_total` FLOAT NULL DEFAULT '0';

GVC Affiliates (States ready)

Updated GVC Affiliates to work with states

Overall improvements to 25+ scripts

Minor improvements and fixes to 25+ scripts. This includes some preparations for payout data.

2022-08-08 - Patch 1.4.5

Branch: patch-1.4.5

Import script update

Updated many affiliate systems to have more metrics and use file system more widely to limit outgoing import requests.

Preparation for more data which might affect import executor (general imports).

2022-07-14 - Patch 1.4.4

Branch: patch-1.4.4

MyAffiliates language barrier fix

Updated MyAffiliates to work with more languages.

2022-06-20 - Patch 1.4.3

Branch: patch-1.4.3

MyAffiliates updates

Updates to try and provide more accurate income for MyAffiliate Hybrids

Added the initial support for Payout/Earnings data (Early stages)

Database table for payout data in it's early stage

SQL: New payout table

CREATE TABLE IF NOT EXISTS `payout_data` ( `pdat_id` int(11) NOT NULL AUTO_INCREMENT, `pdat_fk_tracker_login` int(11) NOT NULL, `pdat_username` varchar(400) DEFAULT NULL, `pdat_brand` varchar(100) DEFAULT NULL, `pdat_login_url` varchar(200) NOT NULL, `pdat_campaign_key` varchar(45) NOT NULL, `pdat_date` date NOT NULL, `pdat_currency` varchar(10) DEFAULT NULL, `pdat_net_revenue` float DEFAULT 0, `pdat_revshare` float DEFAULT 0, `pdat_cpa_commission` float DEFAULT 0, `pdat_bonus` float DEFAULT 0, `pdat_extra_fee` float DEFAULT 0, `pdat_deposit_value` float DEFAULT 0, `pdat_deduction` float DEFAULT 0, `pdat_total` float DEFAULT 0, PRIMARY KEY (`pdat_id`), UNIQUE KEY `pdat_brand` (`pdat_brand`,`pdat_login_url`,`pdat_campaign_key`,`pdat_date`), KEY `pdat_fk_tracker_login` (`pdat_fk_tracker_login`,`pdat_campaign_key`,`pdat_date`) )

Minor bugfixes
  • Sites - Campaigns linked did not account for deleted accounts/advertisers
  • StarVegas - Script fix to match platform data
  • MrBet - Script fix for login issues
  • API - Fixes and corrections to setup
  • Quints - Fix for API v2 (their end) to work also

2022-06-20 - Patch 1.4.2

Branch: patch-1.4.2

888 Update for brand IDs and Brand ID extras

Option available to add brand groups or brand IDs into Voonix.

2022-06-15 - Patch 1.4.1

Branch: patch-1.4.1

API 2.0 issue fix

Further corrected an issue in API 2.0 with incorrect data and negative CPAs for chargebacks.

2022-06-13 - Patch 1.4

Branch: patch-1.4

API 2.0 issue fix

Corrected an issue in API 2.0 with incorrect data.

2022-06-08 - Patch 1.3

Branch: patch-1.3

API input issue fix

Fixed an issue where input from API was altered to remove special characters, this is no longer the case.

Optimized currency symbol for RAW Values

Optimized currency symbols for raw values displayed in reports.

Updated SGI script to SoftGamings

Updated the naming for SGI to SoftGamings as more platforms use this and we believe this to be the overall name.

Karamba bug fix

Bugfix to solve import from breaking when stats are empty for one account.

Minor bug fixes

Fixed a bug where CPA commission in negative (caused by chargebacks) were not shown.

Expand currency length to support mBTC

Added mBTC and support for this.

SQL: New metrics to data validation

ALTER TABLE `advertisers` CHANGE `adve_affiliate_system_currency` `adve_affiliate_system_currency` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NOT NULL;

ALTER TABLE `tracker_logins` CHANGE `tlog_currency` `tlog_currency` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL, CHANGE `tlog_currency_CPA` `tlog_currency_CPA` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL, CHANGE `tlog_currency_CPL` `tlog_currency_CPL` VARCHAR(10) CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL;

2022-05-25 - Patch 1.2

Branch: patch-1.2

Data validation metrics expanded

New metrics to data validation.

SQL: New metrics to data validation

ALTER TABLE `tracker_logins_columns` ADD `tlco_ndcs` VARCHAR(255) NOT NULL DEFAULT 'unavailable' AFTER `tlco_net_revenue`, ADD `tlco_qndcs` VARCHAR(255) NOT NULL DEFAULT 'unavailable' AFTER `tlco_ndcs`, ADD `tlco_gross_revenue` VARCHAR(255) NOT NULL DEFAULT 'unavailable' AFTER `tlco_qndcs`;

Metrics expanded

New metrics are added to several import scripts, mainly the large ones such as NetRefer, Income Access, MyAffiliates, Bet365 and so forth.

Metrics available in reports

NDCs, QNDCs, Gross Revenue and RAW Currency Values now availabe in reports throughout Voonix

MyAffiliates Unspecified Solution Attempt

Attempt to solve Unspecified issue with MyAffiliates and brands

New scripts

  • SGI
  • FinanceAds
  • GamblingCraft
  • Karamba Partners

Improvements to API

API will return values even if they are not set such as deals.

API endpoints

Two new static endpoints for affiliate systems and brand database.

CPA/CPL Specific currency

Adds the option to set currencies for specific parts of the deal like CPA income.

SQL: Adds currencies for deal specific currencies

ALTER TABLE `tracker_logins` ADD `tlog_currency_CPA` VARCHAR(3) NULL DEFAULT NULL AFTER `tlog_currency`, ADD `tlog_currency_CPL` VARCHAR(3) NULL DEFAULT NULL AFTER `tlog_currency_CPA`;

2022-04-09 - Patch 1.1

Branch: patch-1.1

Major changes

Pause login imports

Ability to pause certain logins from importing in case of them being inactive or similar.

SQL: Pause logins

ALTER TABLE `tracker_logins` ADD `tlog_paused` INT NULL DEFAULT '0' AFTER `tlog_history`;

Payers expanded

Updated payers table to include more advertisers in case of larger operators.

SQL: More advertisers pr. payer

ALTER TABLE `advertiser_payers` CHANGE `payr_advertisers_array` `payr_advertisers_array` TEXT CHARACTER SET latin1 COLLATE latin1_swedish_ci NULL DEFAULT NULL;

Statistic metrics

More metrics for statistical data tables (NDC, QNC, Gross Revenue)

  • Integer NDCs (ndc) the NDCs for the affiliate systems
  • Integer QNDCs (qndc) the Qualified NDCs for the affiliate systems
  • Float Gross revenue (gross_revenue) the gross revenue income for the affiliate systems
  • Float Raw CPA Income (raw_cpa_income) the raw value (Non-converted) of CPA Income
  • Float Raw CPL Income (raw_cpl_income) the raw value (Non-converted) of CPL Income
  • Float Raw Extra fee (raw_Extra_fee) the raw value (Non-converted) of Extra fees (Manual input)
  • Float Raw Revshare (raw_REV_income) the raw value (Non-converted) of Revshare income
  • Float Raw Bonus (raw_bonus) the raw value (Non-converted) of Bonus
  • Float Raw Deposit Value (raw_deposit_value) the raw value (Non-converted) of Deposit value/amount
  • Float Raw Gross Revenue (raw_gross_revenue) the raw value (Non-converted) of Gross Revenue
  • Float Raw Net Revenue (raw_netrevenue) the raw value (Non-converted) of Net Revenue
  • Float Raw Turnover (raw_turnover) the raw value (Non-converted) of Turnover

SQL: Metrics for statistics

ALTER TABLE `stats_data` ADD `sdat_qndc` INT(11) NULL DEFAULT '0' AFTER `sdat_cpa`, ADD `sdat_ndc` INT(11) NULL DEFAULT '0' AFTER `sdat_depositors`, ADD `sdat_gross_revenue` FLOAT NULL DEFAULT '0' AFTER `sdat_net_revenue`;

ALTER TABLE `stats_data_backup` ADD `sdat_qndc` INT(11) NULL DEFAULT '0' AFTER `sdat_cpa`, ADD `sdat_ndc` INT(11) NULL DEFAULT '0' AFTER `sdat_depositors`, ADD `sdat_gross_revenue` FLOAT NULL DEFAULT '0' AFTER `sdat_net_revenue`;

ALTER TABLE `stats_data_country` ADD `sdac_gross_revenue` FLOAT NULL DEFAULT '0' AFTER `sdac_deposit_value`, ADD `sdac_ndc` INT NULL DEFAULT '0' AFTER `sdac_gross_revenue`, ADD `sdac_qndc` INT NULL DEFAULT '0' AFTER `sdac_ndc`;

Raw currency values

Show values in raw currencies available (NOTE: Only availabe in the API currently)

API 3.0

New API containing a lot of endpoints and features

  • Key in header
  • HTTP Codes
  • New documentation
  • Campaign and campaign deal endpoints
  • JSON Post

Minor changes

Import scripts

  • BetWay Partners Africa
  • 500Affiliates
  • V&J Japan
  • Awin

Patch 1.0 (Original deploy)

Branch: patch-1.0

The original deploy of Voonix