X-Git-Url: https://git.mxchange.org/?a=blobdiff_plain;f=inc%2Fextensions%2Fext-primera.php;h=6b0f8b1aa24f925a489b7005b06d3d62c8791425;hb=7d61cd8a78e4f9afc42888759523e8069e75102a;hp=286c3cde293d4ebb94bc102fb723dcd9e9c7f72e;hpb=c8d76610eb94093d4eed4fcd8a6cb72e74c8f6d8;p=mailer.git diff --git a/inc/extensions/ext-primera.php b/inc/extensions/ext-primera.php index 286c3cde29..6b0f8b1aa2 100644 --- a/inc/extensions/ext-primera.php +++ b/inc/extensions/ext-primera.php @@ -18,7 +18,7 @@ * $Author:: $ * * -------------------------------------------------------------------- * * Copyright (c) 2003 - 2009 by Roland Haeder * - * Copyright (c) 2009, 2010 by Mailer Developer Team * + * Copyright (c) 2009 - 2011 by Mailer Developer Team * * For more information visit: http://www.mxchange.org * * * * This program is free software; you can redistribute it and/or modify * @@ -43,53 +43,53 @@ if (!defined('__SECURITY')) { } // END - if // Version of this extension -setThisExtensionVersion('0.0'); +setThisExtensionVersion('0.0.0'); -// Version history array (add more with , '0.1.0' and so on) -setExtensionVersionHistory(array('0.0')); +// Version history array (add more with , '0.0.1' and so on) +setExtensionVersionHistory(array('0.0.0')); // This extension is in development (non-productive) enableExtensionProductive(false); switch (getExtensionMode()) { - case 'register': // Do stuff when installation is running (modules.php?module=admin is called) + case 'register': // Do stuff when installation is running // SQL commands to run - addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_user_primera`'); - addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_user_primera` ( + addDropTableSql('user_primera'); + addCreateTableSql('user_primera', " `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, `primera_account` VARCHAR(255) NOT NULL DEFAULT '', `primera_amount` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000, `primera_timestamp` VARCHAR(10) NOT NULL DEFAULT 0, -`primera_type` ENUM('IN','OUT','FAILED') NOT NULL DEFAULT 'FAILED', +`primera_type` ENUM('WITHDRAW','PAYOUT','FAILED') NOT NULL DEFAULT 'FAILED', `primera_api_message` TINYTEXT, `primera_api_status` VARCHAR(255) NULL DEFAULT NULL, -KEY (`userid`), -PRIMARY KEY (`id`) -) TYPE={?_TABLE_TYPE?} COMMENT='Transfers in Primera'"); +PRIMARY KEY (`id`), +INDEX (`userid`)", + 'Transfers in Primera'); - // Confiuration - addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `primera_min_payout` BIGINT(20) UNSIGNED NOT NULL DEFAULT 40000"); - addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `primera_min_withdraw` BIGINT(20) UNSIGNED NOT NULL DEFAULT 5000"); - addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `primera_api_name` VARCHAR(255) NOT NULL DEFAULT ''"); - addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `primera_api_md5` VARCHAR(32) NOT NULL DEFAULT ''"); - addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_config` ADD `primera_refid` VARCHAR(255) NOT NULL DEFAULT ''"); + // Configuration + addConfigAddSql('primera_min_payout', 'BIGINT(20) UNSIGNED NOT NULL DEFAULT 40000'); + addConfigAddSql('primera_min_withdraw', 'BIGINT(20) UNSIGNED NOT NULL DEFAULT 5000'); + addConfigAddSql('primera_api_name', "VARCHAR(255) NOT NULL DEFAULT ''"); + addConfigAddSql('primera_api_md5', "VARCHAR(32) NOT NULL DEFAULT ''"); + addConfigAddSql('primera_refid', "VARCHAR(255) NOT NULL DEFAULT ''"); // User data addExtensionSql("ALTER TABLE `{?_MYSQL_PREFIX?}_user_data` ADD `primera_nickname` VARCHAR(255) NOT NULL DEFAULT ''"); // Admin menu - addAdminMenuSql('primera', NULL, 'Primera-Management','Konfiguration zur Primera-API einstellen, Auszahlungen auflisten usw..', 15); - addAdminMenuSql('primera','config_primera','Primera-API-Einstellungen','Konfiguration zur Primera-API einstellen.', 1); - addAdminMenuSql('primera','list_primera','Primera-Anfragen auflisten','Listet alle Primera-Auszahlungsanfragen Ihrer Mitglieder auf.', 2); + addAdminMenuSql('primera', NULL, 'Primera-Management', 'Konfiguration zur Primera-API einstellen, Auszahlungen auflisten usw..', 15); + addAdminMenuSql('primera', 'config_primera', 'Primera-API-Einstellungen', 'Konfiguration zur Primera-API einstellen.', 1); + addAdminMenuSql('primera', 'list_primera', 'Primera-Anfragen auflisten', 'Listet alle Primera-Auszahlungsanfragen Ihrer Mitglieder auf.', 2); // Member menu - addMemberMenuSql('main','primera','Primera-Ein-/Auszahlungen','N','Y',11); + addMemberMenuSql('main', 'primera', 'Primera-Ein-/Auszahlungen', 11); break; case 'remove': // Do stuff when removing extension // SQL commands to run - addExtensionSql('DROP TABLE IF EXISTS `{?_MYSQL_PREFIX?}_user_primera`'); + addDropTableSql('user_primera'); addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_admin_menu` WHERE `action`='primera'"); addExtensionSql("DELETE LOW_PRIORITY FROM `{?_MYSQL_PREFIX?}_member_menu` WHERE `what`='primera'"); break; @@ -110,13 +110,13 @@ PRIMARY KEY (`id`) // Update notes (these will be set as task text!) setExtensionUpdateNotes(''); break; - } + } // END - if break; case 'modify': // When the extension got modified break; - case 'test': // For testing purposes. For details see file inc/modules/admin/what-extensions.php, arround line 305. + case 'test': // For testing purposes break; case 'init': // Do stuff when extension is initialized @@ -125,7 +125,7 @@ PRIMARY KEY (`id`) default: // Unknown extension mode logDebugMessage(__FILE__, __LINE__, sprintf("Unknown extension mode %s in extension %s detected.", getExtensionMode(), getCurrentExtensionName())); break; -} +} // END - if -// +// [EOF] ?>