switch ($EXT_LOAD_MODE)
{
-case "register": // Do stuff when installtion is running (modules.php?module=admin&action=login is called)
+case "register": // Do stuff when installation is running (modules.php?module=admin&action=login is called)
// SQL commands to run
- $SQLs[] = "";
+ $SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_config` ADD `yoomedia_id` BIGINT(20) NOT NULL DEFAULT 0";
+ $SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_config` ADD `yoomedia_sid` BIGINT(20) NOT NULL DEFAULT 0";
+ $SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_config` ADD `yoomedia_passwd` VARCHAR(255) NOT NULL DEFAULT ''";
+ $SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_config` ADD `yoomedia_erotic_allowed` TINYINT(2) NOT NULL DEFAULT 0";
+ $SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_config` ADD `yoomedia_tm_max_reload` SMALLINT(6) NOT NULL DEFAULT ".(24 * 8)."";
+ $SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_config` ADD `yoomedia_tm_min_wait` SMALLINT(6) NOT NULL DEFAULT 60";
+ $SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_config` ADD `yoomedia_tm_clicks_remain` INT(7) NOT NULL DEFAULT 1000";
+ $SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_config` ADD `yoomedia_tm_min_pay` FLOAT(20,5) NOT NULL DEFAULT 0.00000";
+ $SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_config` ADD `yoomedia_requests_total` SMALLINT(6) NOT NULL DEFAULT 200";
+ $SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_config` ADD `yoomedia_requests_remain` SMALLINT(6) NOT NULL DEFAULT 200";
+
+ // Admin menu
+ $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('setup','config_yoomedia','Yoo!Media Interface 2.0','Einstellungen zum Yoo!Media Interface 2.0, wie User-ID, Interface-Passwort und vieles mehr.',17)";
+ $SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('email','list_yoomedia_tm','Yoo!Media Textmails','Listet Textmail-Buchungen über das Interface 2.0 von Yoo!Media nach Ihren eingestellten Kriterien auf. <strong>Vorsicht:</strong> Jede Aktualisierung dieser Liste kostet Ihnen eine Abfrage!',10)";
+
+ // Reload lock table
+ $SQLs[] = "DROP TABLE IF EXISTS `"._MYSQL_PREFIX."_yoomedia_reload`";
+ $SQLs[] = "CREATE TABLE `"._MYSQL_PREFIX."_yoomedia_reload` (
+`id` BIGINT(20) NOT NULL AUTO_INCREMENT,
+`type` VARCHAR(255) NOT NULL DEFAULT 'general',
+`y_id` BIGINT(20) NOT NULL DEFAULT 0,
+`y_reload` SMALLINT(6) NOT NULL DEFAULT 0,
+`inserted` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
+PRIMARY KEY (`id`),
+UNIQUE `y_type` (`type`,`y_id`)
+) TYPE=MyISAM COMMENT='Reload lock reminder for Yoo!Media campaigns'";
break;
case "remove": // Do stuff when removing extension
// SQL commands to run
+ $SQLs[] = "DELETE LOW_PRIORITY FROM `"._MYSQL_PREFIX."_admin_menu` WHERE `what` IN('config_yoomedia','list_yoomedia_tm') LIMIT 2";
+ $SQLs[] = "DROP TABLE IF EXISTS `"._MYSQL_PREFIX."_yoomedia_reload`";
break;
case "activate": // Do stuff when admin activates this extension
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;
}
// Language file prefix
$EXT_LANG_PREFIX = "yoomedia";
+// Keep this extension always active!
+$EXT_ALWAYS_ACTIVE = "Y";
+
//
?>