2 /************************************************************************
3 * MXChange v0.2.1 Start: 08/27/2008 *
4 * ================ Last change: 08/27/2008 *
6 * -------------------------------------------------------------------- *
7 * File : ext-yoomedia.php *
8 * -------------------------------------------------------------------- *
9 * Short description : Extension for contacting the API of Yoo!Media *
10 * -------------------------------------------------------------------- *
11 * Kurzbeschreibung : Erweitertung zur Anbindung an die API von *
13 * -------------------------------------------------------------------- *
15 * -------------------------------------------------------------------- *
16 * Copyright (c) 2003 - 2008 by Roland Haeder *
17 * For more information visit: http://www.mxchange.org *
19 * This program is free software; you can redistribute it and/or modify *
20 * it under the terms of the GNU General Public License as published by *
21 * the Free Software Foundation; either version 2 of the License, or *
22 * (at your option) any later version. *
24 * This program is distributed in the hope that it will be useful, *
25 * but WITHOUT ANY WARRANTY; without even the implied warranty of *
26 * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
27 * GNU General Public License for more details. *
29 * You should have received a copy of the GNU General Public License *
30 * along with this program; if not, write to the Free Software *
31 * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, *
33 ************************************************************************/
35 // Some security stuff...
36 if (!defined('__SECURITY')) {
37 $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
42 EXT_SET_VERSION("0.0");
44 // Version history array (add more with , "0.1" and so on)
45 EXT_SET_VER_HISTORY(array("0.0"));
47 // This extension is deprecated!
48 // Only since 'network' is ready! EXT_SET_DEPRECATED("Y");
50 switch ($EXT_LOAD_MODE)
52 case "register": // Do stuff when installation is running (modules.php?module=admin&action=login is called)
53 // SQL commands to run
54 ADD_SQL("ALTER TABLE `{!_MYSQL_PREFIX!}_config` ADD `yoomedia_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0");
55 ADD_SQL("ALTER TABLE `{!_MYSQL_PREFIX!}_config` ADD `yoomedia_sid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0");
56 ADD_SQL("ALTER TABLE `{!_MYSQL_PREFIX!}_config` ADD `yoomedia_passwd` VARCHAR(255) NOT NULL DEFAULT ''");
57 ADD_SQL("ALTER TABLE `{!_MYSQL_PREFIX!}_config` ADD `yoomedia_erotic_allowed` TINYINT(2) UNSIGNED NOT NULL DEFAULT 0");
58 ADD_SQL("ALTER TABLE `{!_MYSQL_PREFIX!}_config` ADD `yoomedia_tm_max_reload` SMALLINT(6) UNSIGNED NOT NULL DEFAULT ".(24 * 8)."");
59 ADD_SQL("ALTER TABLE `{!_MYSQL_PREFIX!}_config` ADD `yoomedia_tm_min_wait` SMALLINT(6) UNSIGNED NOT NULL DEFAULT 60");
60 ADD_SQL("ALTER TABLE `{!_MYSQL_PREFIX!}_config` ADD `yoomedia_tm_clicks_remain` INT(7) UNSIGNED NOT NULL DEFAULT 1000");
61 ADD_SQL("ALTER TABLE `{!_MYSQL_PREFIX!}_config` ADD `yoomedia_tm_min_pay` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000");
62 ADD_SQL("ALTER TABLE `{!_MYSQL_PREFIX!}_config` ADD `yoomedia_requests_total` SMALLINT(6) UNSIGNED NOT NULL DEFAULT 200");
63 ADD_SQL("ALTER TABLE `{!_MYSQL_PREFIX!}_config` ADD `yoomedia_requests_remain` SMALLINT(6) UNSIGNED NOT NULL DEFAULT 200");
66 ADD_SQL("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)");
67 ADD_SQL("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)");
70 ADD_SQL("DROP TABLE IF EXISTS `{!_MYSQL_PREFIX!}_yoomedia_reload`");
71 ADD_SQL("CREATE TABLE `{!_MYSQL_PREFIX!}_yoomedia_reload` (
72 `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
73 `type` VARCHAR(255) NOT NULL DEFAULT 'general',
74 `y_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
75 `y_reload` SMALLINT(6) UNSIGNED NOT NULL DEFAULT 0,
76 `inserted` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
78 UNIQUE `y_type` (`type`,`y_id`)
79 ) TYPE={!_TABLE_TYPE!} COMMENT='Reload lock reminder for Yoo!Media campaigns'");
82 case "remove": // Do stuff when removing extension
83 // SQL commands to run
84 ADD_SQL("DELETE LOW_PRIORITY FROM `{!_MYSQL_PREFIX!}_admin_menu` WHERE `what` IN('config_yoomedia','list_yoomedia_tm') LIMIT 2");
85 ADD_SQL("DROP TABLE IF EXISTS `{!_MYSQL_PREFIX!}_yoomedia_reload`");
88 case "activate": // Do stuff when admin activates this extension
89 // SQL commands to run
92 case "deactivate": // Do stuff when admin deactivates this extension
93 // SQL commands to run
96 case "update": // Update an extension
99 case "0.0.1": // SQL queries for v0.0.1
102 // Update notes (these will be set as task text!)
103 EXT_SET_UPDATE_NOTES("");
108 case "modify": // When the extension got modified
111 case "test": // For testing purposes. For details see file inc/modules/admin/what-extensions.php, arround line 305.
114 default: // Do stuff when extension is loaded
115 // The translation table
116 $yoomediaTranslationTable = array(
118 'error_codes' => array(
121 3 => 'website_locked',
122 4 => 'api_data_error',
123 5 => 'requests_depleted',
125 10 => 'incomplete_request'
141 // Keep this extension always active!
142 EXT_SET_ALWAYS_ACTIVE("Y");