X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fextensions%2Fext-yoomedia.php;h=9d5fd0d52caf3e72fb0a3e1e612e5fd2eb72409d;hp=d9720a0bad9db93d13b0884fd088d9ef8783b916;hb=0dd76819236495cb7cfe97d8152700b895261eea;hpb=ee71bda9cc7d75f090ae2e1a2d05d4903523e112 diff --git a/inc/extensions/ext-yoomedia.php b/inc/extensions/ext-yoomedia.php index d9720a0bad..9d5fd0d52c 100644 --- a/inc/extensions/ext-yoomedia.php +++ b/inc/extensions/ext-yoomedia.php @@ -1,7 +1,7 @@ Vorsicht: Jede Aktualisierung dieser Liste kostet Ihnen eine Abfrage!',10)"); - - // Reload lock table - ADD_SQL("DROP TABLE IF EXISTS `{!_MYSQL_PREFIX!}_yoomedia_reload`"); - ADD_SQL("CREATE TABLE `{!_MYSQL_PREFIX!}_yoomedia_reload` ( +setThisExtensionVersion('0.0.0'); + +// Version history array (add more with , '0.0.1' and so on) +setExtensionVersionHistory(array('0.0.0')); + +// Keep this extension always active! +setExtensionAlwaysActive('Y'); + +// This extension is deprecated +// @TODO Only deprecated when 'ext-network' is ready: setExtensionDeprecated('Y'); + +switch (getExtensionMode()) { + case 'setup': // Do stuff when installation is running + // SQL commands to run + addConfigAddSql('yoomedia_id', 'BIGINT(20) UNSIGNED NOT NULL DEFAULT 0'); + addConfigAddSql('yoomedia_sid', 'BIGINT(20) UNSIGNED NOT NULL DEFAULT 0'); + addConfigAddSql('yoomedia_passwd', "VARCHAR(255) NOT NULL DEFAULT ''"); + addConfigAddSql('yoomedia_erotic_allowed', 'TINYINT(2) UNSIGNED NOT NULL DEFAULT 0' ) ; + addConfigAddSql('yoomedia_tm_max_reload', 'SMALLINT(6) UNSIGNED NOT NULL DEFAULT ' . (24 * 8)); + addConfigAddSql('yoomedia_tm_min_wait', 'SMALLINT(6) UNSIGNED NOT NULL DEFAULT 60'); + addConfigAddSql('yoomedia_tm_clicks_remain', 'INT(7) UNSIGNED NOT NULL DEFAULT 1000'); + addConfigAddSql('yoomedia_tm_min_pay', 'FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000'); + addConfigAddSql('yoomedia_requests_total', 'SMALLINT(6) UNSIGNED NOT NULL DEFAULT 200'); + addConfigAddSql('yoomedia_requests_remain', 'SMALLINT(6) UNSIGNED NOT NULL DEFAULT 200'); + + // Admin menu + addAdminMenuSql('setup', 'config_yoomedia', 'Yoo!Media Interface 2.0','Einstellungen zum Yoo!Media Interface 2.0, wie Affiliate-Id, Interface-Passwort und vieles mehr.',17); + addAdminMenuSql('email', 'list_yoomedia_tm', 'Yoo!Media Textmails','Listet Textmail-Buchungen über das Interface 2.0 von Yoo!Media nach Ihren eingestellten Kriterien auf. Vorsicht: Jede Aktualisierung dieser Liste kostet Ihnen eine Abfrage!',10); + + // Reload lock table + addDropTableSql('yoomedia_reload'); + addCreateTableSql('yoomedia_reload', " `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `type` VARCHAR(255) NOT NULL DEFAULT 'general', `y_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, `y_reload` SMALLINT(6) UNSIGNED NOT NULL DEFAULT 0, `inserted` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP, PRIMARY KEY (`id`), -UNIQUE `y_type` (`type`,`y_id`) -) TYPE={!_TABLE_TYPE!} COMMENT='Reload lock reminder for Yoo!Media campaigns'"); - break; - -case "remove": // Do stuff when removing extension - // SQL commands to run - ADD_SQL("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_admin_menu` WHERE `what` IN('config_yoomedia','list_yoomedia_tm') LIMIT 2"); - ADD_SQL("DROP TABLE IF EXISTS `{!_MYSQL_PREFIX!}_yoomedia_reload`"); - break; - -case "activate": // Do stuff when admin activates this extension - // SQL commands to run - break; - -case "deactivate": // Do stuff when admin deactivates this extension - // SQL commands to run - break; - -case "update": // Update an extension - switch ($EXT_VER) - { - case "0.0.1": // SQL queries for v0.0.1 - ADD_SQL(""); - - // Update notes (these will be set as task text!) - EXT_SET_UPDATE_NOTES(""); +UNIQUE INDEX `y_type` (`type`, `y_id`)", + 'Reload lock reminder for Yoo!Media campaigns'); break; - } - break; - -case "test": // For testing purposes. For details see file inc/modules/admin/what-extensions.php, arround line 305. - break; - -default: // Do stuff when extension is loaded - // The translation table - $yoomediaTranslationTable = array( - // Error messages - 'error_codes' => array( - 1 => 'wrong_pass', - 2 => 'wrong_sid', - 3 => 'website_locked', - 4 => 'api_data_error', - 5 => 'requests_depleted', - 6 => 'zero_result', - 10 => 'incomplete_request' - ), - // For text mails - 'textmail' => array( - 0 => 'id', - 1 => 'name', - 2 => 'reload', - 3 => 'wait', - 4 => 'remain', - 5 => 'pay', - 6 => 'text' - ) - ); - break; -} -// Keep this extension always active! -EXT_SET_ALWAYS_ACTIVE("Y"); + case 'remove': // Do stuff when removing extension + // SQL commands to run + addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_admin_menu` WHERE `what` IN('config_yoomedia','list_yoomedia_tm')"); + addDropTableSql('yoomedia_reload'); + break; + + case 'activate': // Do stuff when admin activates this extension + // SQL commands to run + break; + + case 'deactivate': // Do stuff when admin deactivates this extension + // SQL commands to run + break; + + case 'update': // Update an extension + switch (getCurrentExtensionVersion()) { + case '0.0.1': // SQL queries for v0.0.1 + addExtensionSql(''); + + // Update notes (these will be set as task text!) + setExtensionUpdateNotes(''); + break; + } // END - switch + break; + + case 'modify': // When the extension got modified + break; + + case 'test': // For testing purposes + break; + + case 'init': // Do stuff when extension is initialized + // The translation table + // @TODO Can this be moved into a database table? + $GLOBALS['translation_tables']['yoomedia'] = array( + // Error messages + 'error_codes' => array( + -999 => 'unknown_error', + 1 => 'wrong_pass', + 2 => 'wrong_sid', + 3 => 'website_locked', + 4 => 'api_data_error', + 5 => 'requests_depleted', + 6 => 'zero_result', + 7 => 'no_campaigns_with_interface', + 10 => 'incomplete_request' + ), + // For text mails + 'textmail' => array( + 0 => 'id', + 1 => 'name', + 2 => 'reload', + 3 => 'wait', + 4 => 'remain', + 5 => 'pay', + 6 => 'text' + ) + ); + break; + + default: // Unknown extension mode + reportBug(__FILE__, __LINE__, sprintf('Unknown extension mode %s in extension %s detected.', getExtensionMode(), getCurrentExtensionName())); + break; +} // END - switch -// +// [EOF] ?>