inc/modules/member/action-order.php -text
inc/modules/member/action-rals.php -text
inc/modules/member/action-stats.php -text
+inc/modules/member/action-surfbar.php -text
inc/modules/member/action-themes.php -text
inc/modules/member/what- -text
inc/modules/member/what-bank_create.php -text
inc/modules/member/what-sponsor.php -text
inc/modules/member/what-stats.php -text
inc/modules/member/what-support.php -text
+inc/modules/member/what-surfbar_start.php -text
inc/modules/member/what-themes.php -text
inc/modules/member/what-transfer.php -text
inc/modules/member/what-unconfirmed.php -text
break;
case "0.0.5": // SQL queries for v0.0.5
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD active_limit bigint(20) not null default '10'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD active_limit BIGINT(20) NOT NULL DEFAULT '10'";
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES('setup', 'config_active', 'Aktiv-Liste', 'Einstellungen an der Aktiv-Liste (<STRONG>Heute Online</STRONG> im Gastbereich) vornehmen.', 8)";
// Update notes (these will be set as task text!)
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES ('admins', 'config_admins', 'ACL einstellen', 'Richten Sie Zugriffskontrollzeilen für jeden Admin individuell ein, um ihm nur bestimmte Bereiche des Admin-Bereiches zugänglich zu machen oder zu sperren.', '4')";
// Which is the default setting when you create a new admin login?
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD admins_default_acl enum('deny', 'allow') not null default 'deny'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD admins_default_acl ENUM('deny', 'allow') NOT NULL DEFAULT 'deny'";
// Default is deny everything
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_admins ADD default_acl enum('deny', 'allow') not null default 'deny'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_admins ADD default_acl ENUM('deny', 'allow') NOT NULL DEFAULT 'deny'";
// But allow current admin everything (THIS SHALL BE YOU!)
$SQLs[] = "UPDATE "._MYSQL_PREFIX."_admins SET default_acl='allow' WHERE login='".get_session('admin_login')."' LIMIT 1";
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_admins_acls";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_admins_acls (
-id bigint(20) not null auto_increment,
-admin_id bigint(20) not null default '0',
-action_menu varchar(255) not null default '',
-what_menu varchar(255) not null default '',
-access_mode enum('deny', 'allow') not null default 'deny',
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+admin_id BIGINT(20) NOT NULL DEFAULT '0',
+action_menu VARCHAR(255) NOT NULL DEFAULT '',
+what_menu VARCHAR(255) NOT NULL DEFAULT '',
+access_mode ENUM('deny', 'allow') NOT NULL DEFAULT 'deny',
KEY (admin_id),
PRIMARY KEY (id)
) TYPE=MyISAM";
break;
case "0.3.1": // SQL queries for v0.3.1
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_admins_acls MODIFY id bigint(20) not null auto_increment";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_admins_acls MODIFY id BIGINT(20) NOT NULL AUTO_INCREMENT";
break;
case "0.4.0": // SQL queries for v0.4.0
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_admins_mails";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_admins_mails (
-id bigint(20) not null auto_increment,
-admin_id bigint(20) not null default '0',
-mail_template varchar(255) not null,
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+admin_id BIGINT(20) NOT NULL DEFAULT '0',
+mail_template VARCHAR(255) NOT NULL,
KEY (admin_id),
PRIMARY KEY (id)
) TYPE=MyISAM";
break;
case "0.6.7": // SQL queries for v0.6.7
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_admins ADD la_mode enum('global', 'OLD', 'NEW') not null default 'global'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_admins ADD la_mode ENUM('global', 'OLD', 'NEW') NOT NULL DEFAULT 'global'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Namenskonflikt zwischen den Erweiterungen <STRONG>admins</STRONG> und (kommender) <STRONG>contact</STRONG>. Beseitigung eines Fehlers <STRONG>HTTP_POSR_VARS</STRONG> beim Ändern von Administratoren.";
{
case "register": // Do stuff when installtion is running (modules.php?module=admin&action=login is called)
// SQL commands to run
- $SQLs[] = "alter table "._MYSQL_PREFIX."_pool modify data_type enum('TEMP','SEND','NEW','ADMIN','ACTIVE','DELETED') not null default 'TEMP'";
+ $SQLs[] = "alter table "._MYSQL_PREFIX."_pool modify data_type ENUM('TEMP','SEND','NEW','ADMIN','ACTIVE','DELETED') NOT NULL DEFAULT 'TEMP'";
if (EXT_IS_ACTIVE("bonus"))
{
- $SQLs[] = "alter table "._MYSQL_PREFIX."_bonus modify data_type enum('NEW','QUEUE','SEND','DELETED') not null default 'NEW'";
+ $SQLs[] = "alter table "._MYSQL_PREFIX."_bonus modify data_type ENUM('NEW','QUEUE','SEND','DELETED') NOT NULL DEFAULT 'NEW'";
}
break;
case "remove": // Do stuff when removing extension
// SQL commands to run
- $SQLs[] = "alter table "._MYSQL_PREFIX."_pool modify data_type enum('TEMP','SEND','NEW','ADMIN','ACTIVE') not null default 'TEMP'";
+ $SQLs[] = "alter table "._MYSQL_PREFIX."_pool modify data_type ENUM('TEMP','SEND','NEW','ADMIN','ACTIVE') NOT NULL DEFAULT 'TEMP'";
if (EXT_IS_ACTIVE("bonus"))
{
- $SQLs[] = "alter table "._MYSQL_PREFIX."_bonus modify data_type enum('NEW','QUEUE','SEND') not null default 'NEW'";
+ $SQLs[] = "alter table "._MYSQL_PREFIX."_bonus modify data_type ENUM('NEW','QUEUE','SEND') NOT NULL DEFAULT 'NEW'";
}
$SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config DROP autopurge_inactive";
$SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config DROP autopurge_unconfirmed";
switch ($EXT_VER)
{
case "0.1": // SQL queries for v0.1
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD autopurge_inactive enum('Y', 'N') not null default 'Y'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD autopurge_unconfirmed enum('Y', 'N') not null default 'Y'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD ap_inactive_since bigint(20) not null default '2592000'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD ap_inactive_time bigint(20) not null default '25200'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD ap_unconfirmed_time bigint(20) not null default '432000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD autopurge_inactive ENUM('Y', 'N') NOT NULL DEFAULT 'Y'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD autopurge_unconfirmed ENUM('Y', 'N') NOT NULL DEFAULT 'Y'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD ap_inactive_since BIGINT(20) NOT NULL DEFAULT '2592000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD ap_inactive_time BIGINT(20) NOT NULL DEFAULT '25200'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD ap_unconfirmed_time BIGINT(20) NOT NULL DEFAULT '432000'";
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES ('setup', 'config_autopurge', 'Auto-Löschung', 'Automatisch inaktive oder nicht bestätigte Accounts löschen.', '12')";
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES ('user', 'list_autopurge', 'Inaktive finden', 'Lassen Sie sich vor dem täglichen Reset anzeigen, welche Mitglieder als inaktiv erkannt werden und welche gelöscht werden.', '10')";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD ap_notified bigint(20) not null default '0'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD ap_notified BIGINT(20) NOT NULL DEFAULT '0'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Automatisches Lö:schen von inaktiven bzw. nicht bestätigten Accounts hinzugefügt.";
break;
case "0.1.9": // SQL queries for v0.1.9
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD autopurge_tasks enum('Y', 'N') not null default 'Y'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD ap_tasks_time bigint(20) not null default '".(60*60*24*7)."'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD autopurge_tasks ENUM('Y', 'N') NOT NULL DEFAULT 'Y'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD ap_tasks_time BIGINT(20) NOT NULL DEFAULT '".(60*60*24*7)."'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Bereinigung von zu löschenden Aufgaben klappt wieder. Zeitlimit für genanntes kann eingestellt werden (Default = 7 Tage).<br /><br /><U>Bitte aktualisieren Sie auch die Admin-Templates!</U>";
break;
case "0.2.0": // SQL queries for v0.2.0
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD ap_in_notify enum('Y', 'N') not null default 'Y'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD ap_un_notify enum('Y', 'N') not null default 'Y'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD ap_tasks_notify enum('Y', 'N') not null default 'Y'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD ap_in_notify ENUM('Y', 'N') NOT NULL DEFAULT 'Y'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD ap_un_notify ENUM('Y', 'N') NOT NULL DEFAULT 'Y'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD ap_tasks_notify ENUM('Y', 'N') NOT NULL DEFAULT 'Y'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Mail wird bei Löschung von Aufgaben ausgesendet.<br /><br /><U>Bitte aktualisieren Sie auch die Admin-Templates!</U>";
break;
case "0.3.3": // SQL queries for v0.3.3
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD ap_del_mails enum('Y', 'N') not null default 'Y'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD ap_dm_notify enum('Y', 'N') not null default 'Y'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD ap_dm_timeout bigint(20) not null default '86400'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD ap_del_mails ENUM('Y', 'N') NOT NULL DEFAULT 'Y'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD ap_dm_notify ENUM('Y', 'N') NOT NULL DEFAULT 'Y'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD ap_dm_timeout BIGINT(20) NOT NULL DEFAULT '86400'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Von bereits gelöschten Mitgliedern die Mails löschen integriert.";
// SQL commands to run
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_bank_accounts";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_bank_accounts (
-id BIGINT(20) NOT NULL AUTO_INCREMENT,
-uid BIGINT(20) NOT NULL DEFAULT '0',
-account_created BIGINT(20) NOT NULL DEFAULT '0',
-account_locked BIGINT(20) NOT NULL DEFAULT '0',
+id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+uid BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
+account_created BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
+account_locked BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
locked_reason TINYTEXT,
status ENUM('NEW', 'ACTIVE', 'LOCKED') NOT NULL DEFAULT 'NEW',
-account_balance DOUBLE(20,5) NOT NULL DEFAULT '0.00000',
+account_balance DOUBLE(20,5) UNSIGNED NOT NULL DEFAULT '0.00000',
output_mode ENUM('LOGIN', 'EMAIL', 'DISABLED'),
pin VARCHAR(50) NOT NULL DEFAULT '',
tan_mode ENUM('NORMAL', 'INDEXED'),
tan_list_status ENUM('PENDING', 'ACTIVE', 'INVALID', 'LOCKED') NOT NULL DEFAULT 'PENDING',
tan_key VARCHAR(50) NOT NULL DEFAULT '',
-month_transfered BIGINT(20) NOT NULL DEFAULT '0',
+month_transfered BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
last_tan VARCHAR(5) NOT NULL DEFAULT '00000',
-last_tan_stamp BIGINT(20) NOT NULL DEFAULT '0',
+last_tan_stamp BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
last_tan_purpose TINYTEXT,
account_type ENUM('CHECK', 'SAVING') NOT NULL DEFAULT 'CHECK',
-overdraft_credit DOUBLE(20,5) NOT NULL DEFAULT '0.00000',
+overdraft_credit DOUBLE(20,5) UNSIGNED NOT NULL DEFAULT '0.00000',
PRIMARY KEY (id),
UNIQUE KEY (pin),
INDEX `uid_type` (uid, account_type),
) TYPE=MyISAM";
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_bank_transfers";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_bank_transfers (
-id BIGINT(20) NOT NULL AUTO_INCREMENT,
-to_account_id BIGINT(20) NOT NULL DEFAULT '0',
-from_account_id BIGINT(20) NOT NULL DEFAULT '0',
-points_amount DOUBLE(20,5) NOT NULL DEFAULT '0.00000',
-day_bookkeeping char(4) NOT NULL DEFAULT '0000',
-day_available char(4) NOT NULL DEFAULT '0000',
+id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+to_account_id BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
+from_account_id BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
+points_amount DOUBLE(20,5) UNSIGNED NOT NULL DEFAULT '0.00000',
+day_bookkeeping CHAR(4) NOT NULL DEFAULT '0000',
+day_available CHAR(4) NOT NULL DEFAULT '0000',
transfer_purpose TINYTEXT,
PRIMARY KEY (id),
INDEX (to_account_id, from_account_id),
) TYPE=MyISAM";
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_bank_packages";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_bank_packages (
-id BIGINT(20) NOT NULL AUTO_INCREMENT,
+id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
title VARCHAR(255) NOT NULL DEFAULT '',
description TINYTEXT,
-account_fee DOUBLE(20,5) NOT NULL DEFAULT '0.00000',
-free_transfers int(7) NOT NULL DEFAULT '0',
-transfer_fee DOUBLE(20,5) NOT NULL DEFAULT '0.00000',
+account_fee DOUBLE(20,5) UNSIGNED NOT NULL DEFAULT '0.00000',
+free_transfers INT(7) UNSIGNED NOT NULL DEFAULT '0',
+transfer_fee DOUBLE(20,5) UNSIGNED NOT NULL DEFAULT '0.00000',
available TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
output_system_mode ENUM('LOGIN', 'EMAIL', 'DISABLED'),
package_active ENUM('Y', 'N') NOT NULL DEFAULT 'N',
-free_months_no_fee TINYINT(3) NOT NULL DEFAULT '0',
-interest_plus float(7,5) NOT NULL DEFAULT '0.00000',
-interest_minus float(7,5) NOT NULL DEFAULT '0.00000',
-first_payment DOUBLE(20,5) NOT NULL DEFAULT '0.00000',
-free_account_income DOUBLE(20,5) NOT NULL DEFAULT '0.00000',
+free_months_no_fee TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
+interest_plus FLOAT(7,5) UNSIGNED NOT NULL DEFAULT '0.00000',
+interest_minus FLOAT(7,5) UNSIGNED NOT NULL DEFAULT '0.00000',
+first_payment DOUBLE(20,5) UNSIGNED NOT NULL DEFAULT '0.00000',
+free_account_income DOUBLE(20,5) UNSIGNED NOT NULL DEFAULT '0.00000',
free_account_stuff TINYTEXT null,
-tan_lock TINYINT(3) NOT NULL DEFAULT '0',
+tan_lock TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY (id)
) TYPE=MyISAM";
// free_account_stuff will be a list of columns of the table _bank_packages
// should be fine. More than one entry and not DISABLED ;) are not supported.
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_bank_tanlist";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_bank_tanlist (
-id BIGINT(20) NOT NULL AUTO_INCREMENT,
-idx TINYINT(3) NOT NULL DEFAULT '0',
-account_id BIGINT(20) NOT NULL DEFAULT '0',
+id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+idx TINYINT(3) UNSIGNED NOT NULL DEFAULT '0',
+account_id BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
tan VARCHAR(50) NOT NULL DEFAULT '',
used ENUM('Y', 'N') NOT NULL DEFAULT 'N',
PRIMARY KEY (id),
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES('setup', 'config_beg', 'Bettel-Link', 'IP-Sperre, {!POINTS!}-Vergütung usw. können Sie hier einstellen.', 10)";
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_guest_menu (action, what, title, sort, visible, locked) VALUES ('main', 'beg', '{!POINTS!} erbetteln!', 4, 'Y', 'Y')";
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_member_menu (action, what, title, sort, visible, locked) VALUES ('main', 'beg', 'Ihr Bettel-Link', 6, 'Y', 'Y')";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD beg_timeout bigint(20) not null default '600'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD beg_uid_timeout bigint(20) not null default '1800'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD beg_points double(20,5) not null default '0.00100'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD beg_clicks bigint(20) not null default '0'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD beg_timeout BIGINT(20) NOT NULL DEFAULT '600'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD beg_uid_timeout BIGINT(20) NOT NULL DEFAULT '1800'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD beg_points DOUBLE(20,5) NOT NULL DEFAULT '0.00100'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD beg_clicks BIGINT(20) NOT NULL DEFAULT '0'";
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_beg_ips";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_beg_ips (
-id bigint(20) not null auto_increment,
-userid bigint(20) not null default '0',
-remote_ip varchar(15) not null default '0.0.0.0',
-timeout varchar(10) not null default '',
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+userid BIGINT(20) NOT NULL DEFAULT '0',
+remote_ip VARCHAR(15) NOT NULL DEFAULT '0.0.0.0',
+timeout VARCHAR(10) NOT NULL DEFAULT '',
KEY (userid),
PRIMARY KEY(id)
) TYPE=MyISAM";
break;
case "0.0.3": // SQL queries for v0.0.3
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD beg_points_max double(20,5) not null default '0.10000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD beg_points_max DOUBLE(20,5) NOT NULL DEFAULT '0.10000'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Maximale Obergrenze an {!POINTS!} einstellbar (Standart: 0,1 {!POINTS!})";
break;
case "0.0.6": // SQL queries for v0.0.6
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD beg_uid bigint(20) not null default '0'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD beg_uid BIGINT(20) NOT NULL DEFAULT '0'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Ein Mitgliedsaccount (empfehlenswert ist Ihr eigenes!) kann zum Abbuchen der {!POINTS!} verwendet werden. Template <U>admin_config_beg.tpl</U> (und pro!) nicht vergessen, zu aktualisieren.";
break;
case "0.0.8": // SQL queries for v0.0.8
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD beg_ip_timeout bigint(20) not null default '1800'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD beg_ip_timeout BIGINT(20) NOT NULL DEFAULT '1800'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Zeitsperre gegen die selbe IP-Nummer hinzugefügt.";
if ($curr == "00") $curr = "12";
// SQL queries for v0.1.2
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD beg_mode enum('DIRECT', 'REF') not null default 'REF'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD beg_month char(2) not null default '".$curr."'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD beg_ranks tinyint(4) not null default '10'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD beg_active enum('Y', 'N') not null default 'N'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD beg_rallye enum('Y', 'N') not null default 'N'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD beg_points double(21,5) not null default '0.00000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD beg_mode ENUM('DIRECT', 'REF') NOT NULL DEFAULT 'REF'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD beg_month CHAR(2) NOT NULL DEFAULT '".$curr."'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD beg_ranks TINYINT(3) NOT NULL DEFAULT '10'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD beg_active ENUM('Y', 'N') NOT NULL DEFAULT 'N'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD beg_rallye ENUM('Y', 'N') NOT NULL DEFAULT 'N'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD beg_points DOUBLE(21,5) NOT NULL DEFAULT '0.00000'";
$VIS = "N"; $LOCKED = "Y";
if (EXT_IS_ACTIVE("beg")) { $VIS = "Y"; $LOCKED = "N"; }
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_member_menu (action, what, title, visible, locked, sort) VALUES ('main', 'beg2', 'Bettel-Rallye', '".$VIS."', '".$LOCKED."', '7')";
break;
case "0.1.7": // SQL queries for v0.1.7
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD beg_ral_en_notify enum('Y', 'N') not null default 'N'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD beg_ral_di_notify enum('Y', 'N') not null default 'N'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD beg_new_mem_notify enum('Y', 'N') not null default 'N'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD beg_notify_bonus double(20,5) not null default '0.00000'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD beg_notify_wait bigint(20) not null default '30'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD beg_ral_notify bigint(20) not null default '0'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD beg_ral_en_notify bigint(20) not null default '0'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD beg_ral_di_notify bigint(20) not null default '0'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD beg_ral_en_notify ENUM('Y', 'N') NOT NULL DEFAULT 'N'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD beg_ral_di_notify ENUM('Y', 'N') NOT NULL DEFAULT 'N'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD beg_new_mem_notify ENUM('Y', 'N') NOT NULL DEFAULT 'N'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD beg_notify_bonus DOUBLE(20,5) NOT NULL DEFAULT '0.00000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD beg_notify_wait BIGINT(20) NOT NULL DEFAULT '30'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD beg_ral_notify BIGINT(20) NOT NULL DEFAULT '0'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD beg_ral_en_notify BIGINT(20) NOT NULL DEFAULT '0'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD beg_ral_di_notify BIGINT(20) NOT NULL DEFAULT '0'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Die Mitglieder können nun optional automatisch über eine aktivierte und/oder deaktivierte Bettel-Rallye informiert werden. Beide Benachrichtigungen können Sie unter <STRONG>Einstellungen --> Bettel-Link/-rallye</STRONG> seperat ein- und ausschalten! Zudem ist eine Sperre gegen eingeloggte Mitglieder eingebaut, die das Klicken auf den eigenen Bettel-Link etwas erschweren soll.";
break;
case "0.2.2": // SQL queries for v0.2.2
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD beg_include_own enum('Y', 'N') not null default 'N'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD beg_include_own ENUM('Y', 'N') NOT NULL DEFAULT 'N'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Eigene User-ID von Bettel-Rallye ausschliessbar.";
{
case "register": // Do stuff when installtion is running (modules.php?module=admin&action=login is called)
// SQL commands to run
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD birthday_sent varchar(10) NOT NULL default '0'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD birthday_sent VARCHAR(10) NOT NULL DEFAULT '0'";
break;
case "remove": // Do stuff when removing extension
break;
case "0.2": // SQL queries for v0.2
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD birthday_points bigint(20) not null default '0'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD birthday_points BIGINT(20) NOT NULL DEFAULT '0'";
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_user_birthday";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_user_birthday (
-id bigint(20) not null auto_increment,
-userid bigint(20) not null default '0',
-points bigint(20) not null default '0',
-chk_value varchar(255) not null default '',
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+userid BIGINT(20) NOT NULL DEFAULT '0',
+points BIGINT(20) NOT NULL DEFAULT '0',
+chk_value VARCHAR(255) NOT NULL DEFAULT '',
KEY(userid),
PRIMARY KEY(id)
) Type=MyISAM";
break;
case "0.3.6": // SQL queries for v0.3.6
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD birthday_mode enum('DIRECT', 'REF') not null default 'DIRECT'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD birthday_active enum('Y', 'N') not null default 'N'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD birthday_mode ENUM('DIRECT', 'REF') NOT NULL DEFAULT 'DIRECT'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD birthday_active ENUM('Y', 'N') NOT NULL DEFAULT 'N'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Vergütungsmodus des Geburtstagsbonus einstellbar.";
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_member_menu VALUES (NULL,'main','bonus','Bonuspunkte',7,'Y','Y', '', 0)";
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_bonus";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_bonus (
-id bigint(20) NOT NULL auto_increment,
-cat_id bigint(20) NOT NULL default '0',
-subject varchar(255) NOT NULL default '',
-text longblob NOT NULL,
-receivers longblob NOT NULL,
-points bigint(20) NOT NULL default '0',
-time tinyint(4) NOT NULL default '0',
-data_type enum('NEW','QUEUE','SEND') NOT NULL default 'NEW',
-timestamp varchar(10) NOT NULL default '0',
-url varchar(255) NOT NULL default '',
-target_send bigint(20) NOT NULL default '0',
-clicks bigint(20) not null default '0',
-mails_sent bigint(20) not null default '0',
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+cat_id BIGINT(20) NOT NULL DEFAULT '0',
+subject VARCHAR(255) NOT NULL DEFAULT '',
+text LONGBLOB NOT NULL,
+receivers LONGBLOB NOT NULL,
+points BIGINT(20) NOT NULL DEFAULT '0',
+time TINYINT(3) NOT NULL DEFAULT '0',
+data_type ENUM('NEW','QUEUE','SEND') NOT NULL DEFAULT 'NEW',
+timestamp VARCHAR(10) NOT NULL DEFAULT '0',
+url VARCHAR(255) NOT NULL DEFAULT '',
+target_send BIGINT(20) NOT NULL DEFAULT '0',
+clicks BIGINT(20) NOT NULL DEFAULT '0',
+mails_sent BIGINT(20) NOT NULL DEFAULT '0',
KEY(cat_id),
PRIMARY KEY (id)
)TYPE=MyISAM";
- $SQLs[] = "alter table "._MYSQL_PREFIX."_user_links modify link_type enum('NORMAL','BONUS') not null default 'NORMAL'";
- $SQLs[] = "alter table "._MYSQL_PREFIX."_user_links add bonus_id bigint not null default '0'";
+ $SQLs[] = "alter table "._MYSQL_PREFIX."_user_links modify link_type ENUM('NORMAL','BONUS') NOT NULL DEFAULT 'NORMAL'";
+ $SQLs[] = "alter table "._MYSQL_PREFIX."_user_links ADD bonus_id BIGINT(20) NOT NULL DEFAULT '0'";
$SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_links ADD INDEX (bonus_id)";
// Run this SQL when html or html_mail extension is installed
- if (EXT_IS_ACTIVE("html_mail")) $SQLs[] = "alter table "._MYSQL_PREFIX."_bonus add html_msg enum('Y','N') not null default 'N'";
+ if (EXT_IS_ACTIVE("html_mail")) $SQLs[] = "alter table "._MYSQL_PREFIX."_bonus add html_msg ENUM('Y','N') NOT NULL DEFAULT 'N'";
break;
case "remove": // Do stuff when removing extension
$SQLs[] = "DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_admin_menu WHERE what='bonus' OR what='config_bonus' OR what='send_bonus' OR what='list_bonus' LIMIT 4";
$SQLs[] = "DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_member_menu WHERE what='bonus' LIMIT 1";
$SQLs[] = "DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_guest_menu WHERE action='bonus' LIMIT 1";
- $SQLs[] = "alter table "._MYSQL_PREFIX."_user_links modify link_type enum('NORMAL') not null default 'NORMAL'";
+ $SQLs[] = "alter table "._MYSQL_PREFIX."_user_links modify link_type ENUM('NORMAL') NOT NULL DEFAULT 'NORMAL'";
$SQLs[] = "alter table "._MYSQL_PREFIX."_user_links drop bonus_id";
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_bonus";
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_bonus_urls";
case "0.2.1": // SQL queries for v0.2.1
$SQLs[] = "DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_admin_menu WHERE what='config_bonus' LIMIT 1";
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu VALUES (NULL,'setup','config_bonus','Bonus-{!POINTS!}',8,'Richten Sie Bonus-{!POINTS!} ein, die beim x'ten Klick auf die Mail verbucht werden sollen. Beispiele: Der 1. Klick sollte mehr {!POINTS!} zusätzlich bekommen, als der 10. Klick.')";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD login_bonus double(20,3) not null default '10.000'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD turbo_bonus double(20,3) not null default '100.000'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD login_timeout bigint(20) not null default '86400'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD turbo_rates varchar(255) not null default '50;20;10'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_ranks tinyint(4) not null default '10'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD login_bonus DOUBLE(20,3) NOT NULL DEFAULT '10.000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD turbo_bonus DOUBLE(20,3) NOT NULL DEFAULT '100.000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD login_timeout BIGINT(20) NOT NULL DEFAULT '86400'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD turbo_rates VARCHAR(255) NOT NULL DEFAULT '50;20;10'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_ranks TINYINT(3) NOT NULL DEFAULT '10'";
// Use actual month for this update
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD last_bonus_month char(2) not null default '".date("m", time())."'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD login_bonus double(20,3) not null default '0.000'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD turbo_bonus double(20,3) not null default '0.000'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_stats ADD bonus_stats enum('Y', 'N') not null default 'N'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD last_bonus_month CHAR(2) NOT NULL DEFAULT '".date("m", time())."'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD login_bonus DOUBLE(20,3) NOT NULL DEFAULT '0.000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD turbo_bonus DOUBLE(20,3) NOT NULL DEFAULT '0.000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_stats ADD bonus_stats ENUM('Y', 'N') NOT NULL DEFAULT 'N'";
$SQLs[] = "UPDATE "._MYSQL_PREFIX."_extensions SET ext_has_css='Y' WHERE ext_name='bonus' AND ext_has_css='N' LIMIT 1";
// Update notes (these will be set as task text!)
case "0.2.2": // SQL queries for v0.2.2
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_bonus_turbo";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_bonus_turbo (
-id bigint(20) NOT NULL auto_increment,
-userid bigint(20) NOT NULL default '0',
-mail_id bigint(20) NOT NULL default '0',
-bonus_id bigint(20) NOT NULL default '0',
-level bigint(20) NOT NULL default '0',
-points double(20,3) NOT NULL default '0.000',
-timemark varchar(32) NOT NULL default '0',
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+userid BIGINT(20) NOT NULL DEFAULT '0',
+mail_id BIGINT(20) NOT NULL DEFAULT '0',
+bonus_id BIGINT(20) NOT NULL DEFAULT '0',
+level BIGINT(20) NOT NULL DEFAULT '0',
+points DOUBLE(20,3) NOT NULL DEFAULT '0.000',
+timemark VARCHAR(32) NOT NULL DEFAULT '0',
PRIMARY KEY(id),
KEY mail_id (mail_id),
KEY bonus_id (bonus_id),
case "0.2.8": // SQL queries for v0.2.8
$SQLs[] = "UPDATE "._MYSQL_PREFIX."_bonus SET timestamp='0' WHERE timestamp='0000000000'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_bonus_turbo CHANGE points points double(22,5) not null default '0.00000'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config CHANGE turbo_bonus turbo_bonus double(22,5) not null default '0.00000'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config CHANGE login_bonus login_bonus double(22,5) not null default '0.00000'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data CHANGE turbo_bonus turbo_bonus double(22,5) not null default '0.00000'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data CHANGE login_bonus login_bonus double(22,5) not null default '0.00000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_bonus_turbo CHANGE points points DOUBLE(22,5) NOT NULL DEFAULT '0.00000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config CHANGE turbo_bonus turbo_bonus DOUBLE(22,5) NOT NULL DEFAULT '0.00000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config CHANGE login_bonus login_bonus DOUBLE(22,5) NOT NULL DEFAULT '0.00000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data CHANGE turbo_bonus turbo_bonus DOUBLE(22,5) NOT NULL DEFAULT '0.00000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data CHANGE login_bonus login_bonus DOUBLE(22,5) NOT NULL DEFAULT '0.00000'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "5 Nachkommastellen implementiert";
break;
case "0.3.5": // SQL queries for v0.3.5
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_mode enum('UID', 'JACKPOT', 'ADD') not null default 'ADD'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_uid bigint(20) not null default '0'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_mode ENUM('UID', 'JACKPOT', 'ADD') NOT NULL DEFAULT 'ADD'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_uid BIGINT(20) NOT NULL DEFAULT '0'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Der Login-Bonus Aktiv-Bonus (= Klick-Bonus) können nun zuerst von einem Mitgliederaccount (das sollte Ihres sein!), vom Jackpot abgezogen oder einfach dazuadiert werden.";
break;
case "0.4.0": // SQL queries for v0.4.0
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_timeout bigint(20) not null default '".(ONE_DAY * 7)."'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_lines bigint(20) not null default '10'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_timeout BIGINT(20) NOT NULL DEFAULT '".(ONE_DAY * 7)."'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_lines BIGINT(20) NOT NULL DEFAULT '10'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Automatisches Löschen von Turbo-Bonus-Zeilen ("._MYSQL_PREFIX."_bonus_turbo) und begrenzte Anzahl von Einträgen hinzugefügt.";
break;
case "0.4.4": // SQL queries for v0.4.4
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_order double(20,5) not null default '15.00000'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_ref double(20,5) not null default '100.00000'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_stats double(20,5) not null default '5.00000'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_active enum('Y', 'N') not null default 'Y'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD bonus_order double(20,5) not null default '0.00000'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD bonus_ref double(20,5) not null default '0.00000'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD bonus_stats double(20,5) not null default '0.00000'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_stats ADD is_stats enum('Y', 'N') not null default 'N'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_order DOUBLE(20,5) NOT NULL DEFAULT '15.00000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_ref DOUBLE(20,5) NOT NULL DEFAULT '100.00000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_stats DOUBLE(20,5) NOT NULL DEFAULT '5.00000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_active ENUM('Y', 'N') NOT NULL DEFAULT 'Y'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD bonus_order DOUBLE(20,5) NOT NULL DEFAULT '0.00000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD bonus_ref DOUBLE(20,5) NOT NULL DEFAULT '0.00000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD bonus_stats DOUBLE(20,5) NOT NULL DEFAULT '0.00000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_stats ADD is_stats ENUM('Y', 'N') NOT NULL DEFAULT 'N'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Bonus-{!POINTS!} für: Mailbestellung, Referral-Werbung (bei Best. der EMail-Adresse) und wenn 100% Klickrate jeder Mailbuchung erreicht wurde.<br>Template <u>admin_config_bonus_pro.tpl</u> ist überflüssig geworden. Bitte löschen Sie dies!<br>Eingestellte Bonus-{!POINTS!} für Rank 2 war um eins verschoben.";
break;
case "0.6.5": // SQL queries for v0.6.5
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_stats ADD bonus_stats enum('Y', 'N') not null default 'N'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_stats ADD bonus_stats ENUM('Y', 'N') NOT NULL DEFAULT 'N'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Fehler mit bonus_stats beseitigt.";
break;
case "0.6.9": // SQL queries for v0.6.9
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_order_yn enum('Y', 'N') not null default 'N'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_ref_yn enum('Y', 'N') not null default 'N'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_stats_yn enum('Y', 'N') not null default 'N'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_login_yn enum('Y', 'N') not null default 'N'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_click_yn enum('Y', 'N') not null default 'Y'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_order_yn ENUM('Y', 'N') NOT NULL DEFAULT 'N'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_ref_yn ENUM('Y', 'N') NOT NULL DEFAULT 'N'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_stats_yn ENUM('Y', 'N') NOT NULL DEFAULT 'N'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_login_yn ENUM('Y', 'N') NOT NULL DEFAULT 'N'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_click_yn ENUM('Y', 'N') NOT NULL DEFAULT 'Y'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Es können nun auch die folgenden Vergütungen bei der Auswertung der monatlichen Aktiv-Rallye mit berücksichtigt werden: Mailbestätigung (war vorher schon), Login-, Mailbuchung, Referral und Statistik-Bonus (100% Klickrate erreicht).";
break;
case "0.7.7": // SQL queries for v0.7.7
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_en_notify enum('Y', 'N') not null default 'N'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_di_notify enum('Y', 'N') not null default 'N'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_new_mem_notify enum('Y', 'N') not null default 'N'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_notify_points double(20,5) not null default '0.00000'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_notify_wait bigint(20) not null default '30'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD bonus_ral_notify bigint(20) not null default '0'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD bonus_ral_en_notify bigint(20) not null default '0'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD bonus_ral_di_notify bigint(20) not null default '0'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_en_notify ENUM('Y', 'N') NOT NULL DEFAULT 'N'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_di_notify ENUM('Y', 'N') NOT NULL DEFAULT 'N'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_new_mem_notify ENUM('Y', 'N') NOT NULL DEFAULT 'N'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_notify_points DOUBLE(20,5) NOT NULL DEFAULT '0.00000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_notify_wait BIGINT(20) NOT NULL DEFAULT '30'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD bonus_ral_notify BIGINT(20) NOT NULL DEFAULT '0'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD bonus_ral_en_notify BIGINT(20) NOT NULL DEFAULT '0'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD bonus_ral_di_notify BIGINT(20) NOT NULL DEFAULT '0'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Optionale automatische Benachrichtigung über aktivierte und/oder deaktivierte Aktiv-Rallye einstellbar.";
break;
case "0.8.2": // SQL queries for v0.8.2
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_include_own enum('Y', 'N') not null default 'N'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_bonus ADD is_notify enum('Y', 'N') not null default 'N'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD bonus_include_own ENUM('Y', 'N') NOT NULL DEFAULT 'N'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_bonus ADD is_notify ENUM('Y', 'N') NOT NULL DEFAULT 'N'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Eigene User-ID von Aktiv-Rallye ausschliessbar. Benachrichtigungsmails sind von Aktiv-Rallye ausgeschlossen.";
{
case "register": // Do stuff when installtion is running (modules.php?module=admin&action=login is called)
// SQL commands to run
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD cache_update bigint(20) not null default '3600'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD cache_path varchar(255) not null default 'cache/'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD cache_tested tinyint(1) not null default '0'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD cache_update BIGINT(20) NOT NULL DEFAULT '3600'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD cache_path VARCHAR(255) NOT NULL DEFAULT 'cache/'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD cache_tested tinyint(1) NOT NULL DEFAULT '0'";
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES ('setup', 'config_cache', 'Cache-Einstellungen', 'Update-Interval des Caches usw. können Sie hier ändern.', 9)";
break;
break;
case "0.0.7": // SQL queries for v0.0.7
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD db_hits bigint(20) not null default '0'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD cache_hits bigint(20) not null default '0'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD db_hits BIGINT(20) NOT NULL DEFAULT '0'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD cache_hits BIGINT(20) NOT NULL DEFAULT '0'";
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES ('stats', 'cache_stats', 'DB-Cache', 'Auf Cache und gesamte Datenbank registrierte Anfragen anzeigen.', 4)";
// Update notes (these will be set as task text!)
break;
case "0.1.3": // SQL queries for v0.1.3
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD cache_admins enum('Y', 'N') not null default 'Y'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD cache_acls enum('Y', 'N') not null default 'Y'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD cache_exts enum('Y', 'N') not null default 'Y'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD cache_config enum('Y', 'N') not null default 'Y'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD cache_modreg enum('Y', 'N') not null default 'Y'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD cache_refdepth enum('Y', 'N') not null default 'Y'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD cache_refsys enum('Y', 'N') not null default 'Y'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD cache_admins ENUM('Y', 'N') NOT NULL DEFAULT 'Y'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD cache_acls ENUM('Y', 'N') NOT NULL DEFAULT 'Y'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD cache_exts ENUM('Y', 'N') NOT NULL DEFAULT 'Y'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD cache_config ENUM('Y', 'N') NOT NULL DEFAULT 'Y'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD cache_modreg ENUM('Y', 'N') NOT NULL DEFAULT 'Y'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD cache_refdepth ENUM('Y', 'N') NOT NULL DEFAULT 'Y'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD cache_refsys ENUM('Y', 'N') NOT NULL DEFAULT 'Y'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Alle cache-baren Tabellen sind nun einzelnt ein- bzw. ausschaltbar. Falls die eine oder andere ausgelagerte Tabelle also Fehler verursachen sollte, so können Sie diese hier abschalten. Beachten Sie aber bitte, dass dann mehr Abfragen an die Datenbank gestellt wird und dies bedeutend mehr Zeit braucht, als nur die Daten aus einem Datenfeld zu laden, das sich im Speicher aufhält.";
// SQL commands to run
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_countries";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_countries (
-id bigint(20) not null auto_increment,
-code char(2) not null default 'DE',
-descr varchar(255) not null default 'Deutschland',
-is_active enum('Y', 'N') not null default 'N',
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+code CHAR(2) NOT NULL DEFAULT 'DE',
+descr VARCHAR(255) NOT NULL DEFAULT 'Deutschland',
+is_active ENUM('Y', 'N') NOT NULL DEFAULT 'N',
KEY(code),
PRIMARY KEY(id)
) TYPE=MyISAM";
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES('country', 'list_country', 'Verwalten', 'Hinzufügen, Ändern und Löschen von Ländercodes.', 1)";
// Add entry to user table
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD country_code bigint(20) not null default '1'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD country_code BIGINT(20) NOT NULL DEFAULT '1'";
break;
case "remove": // Do stuff when removing extension
// Doubler table
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_doubler";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_doubler (
-id bigint(20) not null auto_increment,
-userid bigint(20) not null default '0',
-refid bigint(20) not null default '0',
-points double(20,5) not null default '0.00000',
-remote_ip varchar(15) not null default '0.0.0.0',
-timemark varchar(10) not null default '',
-completed enum('Y', 'N') not null default 'N',
-is_ref enum('Y', 'N') not null default 'N',
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+userid BIGINT(20) NOT NULL DEFAULT '0',
+refid BIGINT(20) NOT NULL DEFAULT '0',
+points DOUBLE(20,5) NOT NULL DEFAULT '0.00000',
+remote_ip VARCHAR(15) NOT NULL DEFAULT '0.0.0.0',
+timemark VARCHAR(10) NOT NULL DEFAULT '',
+completed ENUM('Y', 'N') NOT NULL DEFAULT 'N',
+is_ref ENUM('Y', 'N') NOT NULL DEFAULT 'N',
KEY(refid),
KEY(userid),
PRIMARY KEY(id)
// --- SETTINGS ---
//
// Minimum points to double
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_min double(20,5) not null default '100.00000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_min DOUBLE(20,5) NOT NULL DEFAULT '100.00000'";
// Maximum points to double
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_max double(20,5) not null default '10000.00000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_max DOUBLE(20,5) NOT NULL DEFAULT '10000.00000'";
// Points left on users account after doubling
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_left bigint(20) not null default '1000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_left BIGINT(20) NOT NULL DEFAULT '1000'";
// Charge for doubling points which goes to the webmaster (shreddered in fact!)
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_charge float(7,3) not null default '0.030'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_charge FLOAT(7,3) NOT NULL DEFAULT '0.030'";
// Referral percents
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_ref float(7,3) not null default '0.020'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_ref FLOAT(7,3) NOT NULL DEFAULT '0.020'";
// Shall I use the jackpot to take points from? (Y/N, default=Y)
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_jackpot enum('Y', 'N') not null default 'Y'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_jackpot ENUM('Y', 'N') NOT NULL DEFAULT 'Y'";
// A user account to take points from (default: 0->none)
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_uid bigint(20) not null default '0'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_uid BIGINT(20) NOT NULL DEFAULT '0'";
// Total payed out points from your doublers
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_points double(20,5) not null default '0.00000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_points DOUBLE(20,5) NOT NULL DEFAULT '0.00000'";
// Sending mode of mails (immediately/daily reset)
// --> This also means who fast the doubled points will be payed out!
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_send_mode enum('DIRECT', 'RESET') not null default 'DIRECT'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_send_mode ENUM('DIRECT', 'RESET') NOT NULL DEFAULT 'DIRECT'";
// Timeout for entries to be purged (default: one week)
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_timeout bigint(20) not null default '".(60*60*24*7)."'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_timeout BIGINT(20) NOT NULL DEFAULT '".(60*60*24*7)."'";
// Number of newest entries to display
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_display_new tinyint(3) not null default '10'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_display_new TINYINT(3) NOT NULL DEFAULT '10'";
// Number of entries which will be payed out soon
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_display_pay tinyint(3) not null default '10'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_display_pay TINYINT(3) NOT NULL DEFAULT '10'";
// Number of entries which are already payed out
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_display_old tinyint(3) not null default '10'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_display_old TINYINT(3) NOT NULL DEFAULT '10'";
// Points used by every member
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD doubler_points double(20,5) not null default '0.00000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD doubler_points DOUBLE(20,5) NOT NULL DEFAULT '0.00000'";
// Counter for usage of the doubler
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_counter bigint(20) not null default '0'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_counter BIGINT(20) NOT NULL DEFAULT '0'";
//
// --- MENU SYSTEMS ---
case "0.0.2": // SQL queries for v0.0.2
// Total used points
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_used double(20,5) not null default '0.00000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_used DOUBLE(20,5) NOT NULL DEFAULT '0.00000'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Gebühr wird vom Verdoppler-Pott abgezogen.";
case "0.0.4": // SQL queries for v0.0.4
// Shall I use the doubler's account to take points from? (Y/N, default=Y)
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_own enum('Y', 'N') not null default 'Y'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_own ENUM('Y', 'N') NOT NULL DEFAULT 'Y'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = POINTS."-Guthaben des Verdopplers kann optional nicht mit einbezogen werden.";
break;
case "0.0.6": // SQL queries for v0.0.6
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_max_sent tinyint(4) not null default '1'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_group_sent tinyint(4) not null default '1'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_sent_all enum('Y', 'N') not null default 'Y'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_max_sent TINYINT(3) NOT NULL DEFAULT '1'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_group_sent TINYINT(3) NOT NULL DEFAULT '1'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD doubler_sent_all ENUM('Y', 'N') NOT NULL DEFAULT 'Y'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Gebührenabzug wird beim Einzahlen abgezogen (wurde von Auszahlung abgezogen) und maximal bei Auszahlung zu kontrollierende Accounts einstellbar.<br>Template <u>admin_config_doubler_pro.tpl</u> ist überflüssig geworden. Bitte löschen Sie dies!";
// Create database
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_user_holidays";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_user_holidays (
-id bigint(20) not null auto_increment,
-userid bigint(20) not null default '0',
-holiday_start varchar(10) not null default '0',
-holiday_end varchar(10) not null default '0',
-comments longblob not null,
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+userid BIGINT(20) NOT NULL DEFAULT '0',
+holiday_start VARCHAR(10) NOT NULL DEFAULT '0',
+holiday_end VARCHAR(10) NOT NULL DEFAULT '0',
+comments LONGBLOB NOT NULL,
KEY (userid),
PRIMARY KEY(id)
) TYPE=MyISAM";
// Add default values to config
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD holiday_max bigint(20) not null default '30'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD holiday_max BIGINT(20) NOT NULL DEFAULT '30'";
// Add member menu
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_member_menu (action, what, title, sort, visible, locked) VALUES ('main', 'holiday', 'Urlaubsschaltung', '4', 'Y', 'Y')";
break;
case "0.1.3": // SQL queries for v0.1.3
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD holiday_active enum('Y', 'N') not null default 'N'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD holiday_active ENUM('Y', 'N') NOT NULL DEFAULT 'N'";
$SQLs[] = "DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_max_receive WHERE value='0' LIMIT 1";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD holiday_lock bigint(20) not null default '".(60*60*24*2)."'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD holiday_lock BIGINT(20) NOT NULL DEFAULT '".(60*60*24*2)."'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Die Mitglieder-Accounts werden nicht mehr gesperrt, sondern nur auf <STRONG>Urlaub</STRONG> geschaltet. Lassen Sie sich nicht davon verwirren, dass sie "freigegeben" sind!";
break;
case "0.1.4": // SQL queries for v0.1.4
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD holiday_mode enum('DIRECT', 'RESET') not null default 'RESET'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD holiday_mode ENUM('DIRECT', 'RESET') NOT NULL DEFAULT 'RESET'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Urlaubsschaltung wird erst Abends um 00:00 Uhr aktiv und nicht durch die Beantragung. Dies kann nun auch auf direkte Umstellung eingestellt werden.";
break;
case "0.1.5": // SQL queries for v0.1.5
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD holiday_mode enum('DIRECT', 'RESET') not null default 'RESET'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD holiday_mode ENUM('DIRECT', 'RESET') NOT NULL DEFAULT 'RESET'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Sicherheitsupdate für die Include-Befehle.";
break;
case "0.1.6": // SQL queries for v0.1.6
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD holiday_activated bigint(20) not null default '0'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD holiday_activated BIGINT(20) NOT NULL DEFAULT '0'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Fehlende Tabellenspalte hinzugefügt.";
{
case "register": // Do stuff when installtion is running (modules.php?module=admin&action=login is called)
// SQL commands to run
- $SQLs[] = "alter table "._MYSQL_PREFIX."_user_data add html enum('Y','N') not null default 'Y'";
- $SQLs[] = "alter table "._MYSQL_PREFIX."_bonus add html_msg enum('Y','N') not null default 'N'";
- $SQLs[] = "alter table "._MYSQL_PREFIX."_pool add html_msg enum('Y','N') not null default 'N'";
+ $SQLs[] = "alter table "._MYSQL_PREFIX."_user_data add html ENUM('Y','N') NOT NULL DEFAULT 'Y'";
+ $SQLs[] = "alter table "._MYSQL_PREFIX."_bonus add html_msg ENUM('Y','N') NOT NULL DEFAULT 'N'";
+ $SQLs[] = "alter table "._MYSQL_PREFIX."_pool add html_msg ENUM('Y','N') NOT NULL DEFAULT 'N'";
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_member_menu (action, what, title, sort, visible, locked) VALUES ('main', 'html_mail', 'HTML-Empfang', '3', 'Y', 'Y')";
break;
{
case "register": // Do stuff when installtion is running (modules.php?module=admin&action=login is called)
// SQL commands to run
- $SQLs[] = "alter table "._MYSQL_PREFIX."_config add maintenance enum('Y', 'N') not null default 'N';";
+ $SQLs[] = "alter table "._MYSQL_PREFIX."_config add maintenance ENUM('Y', 'N') NOT NULL DEFAULT 'N';";
if (SQL_NUMROWS(SQL_QUERY("SELECT id FROM "._MYSQL_PREFIX."_admin_menu WHERE what='maintenance' LIMIT 1", __FILE__, __LINE__)) == 0)
{
// Insert menu only when not exists
// SQL commands to run
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_mediadata";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_mediadata (
-media_key varchar(255) not null default '',
-media_value varchar(255) not null default '',
+media_key VARCHAR(255) NOT NULL DEFAULT '',
+media_value VARCHAR(255) NOT NULL DEFAULT '',
PRIMARY KEY(media_key)
) TYPE=MyISAM";
break;
case "0.0.7": // SQL queries for v0.0.7
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD mt_start bigint(20) not null default '0'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD mt_stage bigint(20) not null default '500'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD mt_start BIGINT(20) NOT NULL DEFAULT '0'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD mt_stage BIGINT(20) NOT NULL DEFAULT '500'";
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES('setup', 'config_mediadata', 'Mediendaten', 'Stellen Sie allgemeine Einstellungen zu den Mediendaten ein.', 10)";
// Update notes (these will be set as task text!)
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES ('newsletter', 'config_newsletter', 'Einstellungen', 'Gebühr zum Abbestellen des Newsletters usw. sind hier einstellbar.', 3)";
$SQLs[] = "UPDATE "._MYSQL_PREFIX."_admin_menu SET action='newsletter', what='send_newsletter', title='Versenden', sort='1' WHERE what='newsletter' LIMIT 1";
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_member_menu (action, what, title, visible, locked, sort) VALUES ('main', 'newsletter', 'Newsletter-Empfang', 'N', 'Y', 10)";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD nl_charge float(10,2) not null default '5.00'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD nl_receive enum('Y', 'N') not null default 'Y'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD nl_until varchar(10) not null default '0'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD nl_timespan varchar(10) not null default '0'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD nl_charge FLOAT(10,2) NOT NULL DEFAULT '5.00'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD nl_receive ENUM('Y', 'N') NOT NULL DEFAULT 'Y'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD nl_until VARCHAR(10) NOT NULL DEFAULT '0'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD nl_timespan VARCHAR(10) NOT NULL DEFAULT '0'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Vor der eigentlichen Freigabe dieser Erweiterungen habe ich sie versehendlich im Archiv mit auf den Server hochgeladen. Diese Version fügt die bereits angekündigte Funktionalitäten, wie zum Beispiel das Einstellen der Abschaltgebühr.";
break;
case "0.1.0": // SQL queries for v0.2.1
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD nl_month char(2) not null default '".date("m", time())."'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD nl_month CHAR(2) NOT NULL DEFAULT '".date("m", time())."'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Nur bei installierter Erweiterung <STRONG>html_mail</STRONG> können Sie auch HTML-Mails versenden.";
{
case "register": // Do stuff when installtion is running (modules.php?module=admin&action=login is called)
// SQL commands to run
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD nickname varchar(255) NOT NULL default ''";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD nick_uid enum('nick', 'uid') NOT NULL default 'uid'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD nickname VARCHAR(255) NOT NULL DEFAULT ''";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD nick_uid ENUM ('nick','uid') NOT NULL DEFAULT 'uid'";
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_member_menu (action, what, title, sort, visible, locked) VALUES ('main', 'nickname', 'Nicknamen', '5', 'Y', 'Y')";
// Load CSS file?
break;
case "0.0.6": // SQL queries for v0.0.6
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD nickname_len tinyint(4) not null default '5'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD nickname_pattern varchar(255) not null default 'a-zA-Z0-9_'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD nickname_chars varchar(255) not null default 'a-z, A-Z, 0-9, _'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD nickname_len TINYINT(3) NOT NULL DEFAULT '5'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD nickname_pattern VARCHAR(255) NOT NULL DEFAULT 'a-zA-Z0-9_'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD nickname_chars VARCHAR(255) NOT NULL DEFAULT 'a-z, A-Z, 0-9, _'";
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES('setup', 'config_nickname', 'Nicknamen', 'Stellen Sie minimale Nicknamenlänge, sowie erlaubte Zeichen hier ein.', 12)";
// Update notes (these will be set as task text!)
// SQL commands to run
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_online";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_online (
-id bigint(20) NOT NULL auto_increment,
-sid varchar(32) NOT NULL default '',
-ip varchar(15) NOT NULL default '',
-userid bigint(20) NOT NULL default '0',
-refid bigint(20) NOT NULL default '0',
-module varchar(255) NOT NULL default '',
-action varchar(255) NOT NULL default '',
-what varchar(255) NOT NULL default '',
-is_admin enum('Y','N') NOT NULL default 'N',
-is_member enum('Y','N') NOT NULL default 'N',
-timestamp varchar(10) not null default '0',
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+sid VARCHAR(32) NOT NULL DEFAULT '',
+ip VARCHAR(15) NOT NULL DEFAULT '',
+userid BIGINT(20) NOT NULL DEFAULT '0',
+refid BIGINT(20) NOT NULL DEFAULT '0',
+module VARCHAR(255) NOT NULL DEFAULT '',
+action VARCHAR(255) NOT NULL DEFAULT '',
+what VARCHAR(255) NOT NULL DEFAULT '',
+is_admin ENUM('Y','N') NOT NULL DEFAULT 'N',
+is_member ENUM('Y','N') NOT NULL DEFAULT 'N',
+timestamp VARCHAR(10) NOT NULL DEFAULT '0',
PRIMARY KEY(id),
KEY(userid),
KEY(refid)
case "register": // Do stuff when installtion is running (modules.php?module=admin&action=login is called)
// SQL commands to run
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_optimize_gain(
- id bigint(20) not null auto_increment,
- gain decimal(10,3) not null default '0.000',
+ id BIGINT(20) NOT NULL AUTO_INCREMENT,
+ gain decimal(10,3) NOT NULL DEFAULT '0.000',
PRIMARY KEY(id)
) TYPE=MyISAM";
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES ('misc', 'optimize', 'DB optimieren', 'Führen Sie dies ab und an aus, damit überflüssige Daten aus der Datenbank entfernt werden.', '5')";
switch ($EXT_VER)
{
case "0.1": // SQL queries for v0.1
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD order_max_full enum('ORDER', 'MAX') not null default 'MAX'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD order_max_full ENUM('ORDER', 'MAX') NOT NULL DEFAULT 'MAX'";
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, sort, descr) VALUES ('setup', 'config_order', 'Mailbuchungsseite', '7', 'Einstellungen am Mailbuchungsformular.')";
// Update notes (these will be set as task text!)
case "0.1.1": // SQL queries for v0.1.1
$SQLs[] = "DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_admin_menu WHERE what='config_order' LIMIT 1";
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, sort, descr) VALUES ('setup', 'config_order', 'Mailbuchungsseite', '7', 'Einstellungen am Mailbuchungsformular.')";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD mail_orders bigint(20) not null default '0'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD mail_orders BIGINT(20) NOT NULL DEFAULT '0'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Maximale Mailbuchung vervollständigt (Admin-Bereich und im Buchungsformular selber).";
break;
case "0.2.3": // SQL queries for v0.2.3
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD order_min bigint(20) not null default '10'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD order_min BIGINT(20) NOT NULL DEFAULT '10'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Minimum an Empfänger pro Mailbuchung einstellbar. Standart: 10 Empfänger";
break;
case "0.3.1": // SQL queries for v0.3.1
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD order_select varchar(255) not null default 'userid'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD order_mode enum('ASC', 'DESC') not null default 'DESC'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD order_select VARCHAR(255) NOT NULL DEFAULT 'userid'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD order_mode ENUM('ASC', 'DESC') NOT NULL DEFAULT 'DESC'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Beworbene URL wird nun getestet.";
break;
case "0.4.9": // SQL queries for v0.4.9
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD repay_deleted_mails ENUM('REPAY', 'JACKPOT', 'SHRED') not null default 'REPAY'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD repay_deleted_mails ENUM('REPAY', 'JACKPOT', 'SHRED') NOT NULL DEFAULT 'REPAY'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Bei Löschung von Mailbuchungen kann nun global entschieden werden (Einstellungen also), ob die verbliebenen ".POINTS." wieder gutgeschrieben werden sollen oder in den Jackpot landen.";
break;
case "0.0.4": // SQL queries for v0.0.4
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD max_comma tinyint(4) not null default '3'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD max_comma TINYINT(3) NOT NULL DEFAULT '3'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Angezeigte Kommastellen können zwischen 0 und 5 eingestellt werden.";
break;
case "0.1.6": // SQL queries for v0.1.6
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD reject_url varchar(255) not null default '".URL."'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD reject_url VARCHAR(255) NOT NULL DEFAULT '".URL."'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Bei Ablehnung der URL wird jetzt endlich eine Standart-URL eingesetzt, die konfigurierbar ist. Fehler beim Laden der Konfiguration gefunden.";
break;
case "0.1.7": // SQL queries for v0.1.7
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD currency varchar(255) not null default '€'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD currency VARCHAR(255) NOT NULL DEFAULT '€'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Standart-Währung der Gebühren für alle Erweiterungen geltend hinzugefügt.";
break;
case "0.1.9": // SQL queries for v0.1.9
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD mailid_error_redirect ENUM('index', 'reject') NOT NULL DEFAULT 'index'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD mailid_error_redirect ENUM('index','reject') NOT NULL DEFAULT 'index'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Bei fehlerhafter Mail während der Bestätigung kann wahlweise zur Hauptseite weitergeleitet oder auf die eingestellte Ablehnungsseite umgeleitet werden.";
break;
case "0.2.0": // SQL queries for v0.2.0
- $SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_config` CHANGE `mailid_error_redirect` `mailid_error_redirect` ENUM( 'INDEX', 'REJECT' ) NOT NULL DEFAULT 'INDEX'";
+ $SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_config` CHANGE `mailid_error_redirect` `mailid_error_redirect` ENUM('INDEX','REJECT') NOT NULL DEFAULT 'INDEX'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Bei fehlerhafter Mail während der Bestätigung kann wahlweise zur Hauptseite weitergeleitet oder auf die eingestellte Ablehnungsseite umgeleitet werden.";
// SQL commands to run
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_user_payouts";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_user_payouts (
-id bigint(20) NOT NULL auto_increment,
-userid bigint(20) NOT NULL default '0',
-payout_total double(22,3) NOT NULL default '0.000',
-target_account varchar(255) NOT NULL default '',
-target_bank varchar(255) NOT NULL default '',
-payout_id bigint(20) NOT NULL default '0',
-payout_timestamp varchar(10) NOT NULL default '0',
-status enum('NEW', 'ACCEPTED', 'REJECTED') NOT NULL default 'NEW',
+id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+userid BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
+payout_total DOUBLE(22,3) UNSIGNED NOT NULL DEFAULT '0.000',
+target_account VARCHAR(255) NOT NULL DEFAULT '',
+target_bank VARCHAR(255) NOT NULL DEFAULT '',
+payout_id BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
+payout_timestamp VARCHAR(10) NOT NULL DEFAULT '0',
+status ENUM('NEW', 'ACCEPTED', 'REJECTED') NOT NULL DEFAULT 'NEW',
KEY(userid),
KEY(payout_id),
PRIMARY KEY(id)
) TYPE=MyISAM";
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_payout_types";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_payout_types (
-id bigint(20) NOT NULL auto_increment,
-type varchar(255) NOT NULL default '',
-rate double(22,3) NOT NULL default '0.000',
-min_points bigint(20) NOT NULL default '0',
+id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+type VARCHAR(255) NOT NULL DEFAULT '',
+rate DOUBLE(22,3) UNSIGNED NOT NULL DEFAULT '0.000',
+min_points BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
PRIMARY KEY(id)
) TYPE=MyISAM";
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES('setup', 'config_payouts', 'Auszahlungen', 'Auszahlungsarten einstellen, neu anlegen oder löschen.', '15')";
break;
case "0.1.3": // SQL queries for v0.1.3
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_payout_types ADD from_account varchar(255) NOT NULL default ''";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_payout_types ADD from_pass varchar(255) NOT NULL default ''";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_payout_types ADD engine_url varchar(255) NOT NULL default ''";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_payout_types ADD engine_ret_ok varchar(255) NOT NULL default ''";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_payout_types ADD engine_ret_failed varchar(255) NOT NULL default ''";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_payout_types ADD pass_enc enum('md5', 'base64', 'none') NOT NULL default 'md5'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_payout_types ADD from_account VARCHAR(255) NOT NULL DEFAULT ''";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_payout_types ADD from_pass VARCHAR(255) NOT NULL DEFAULT ''";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_payout_types ADD engine_url VARCHAR(255) NOT NULL DEFAULT ''";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_payout_types ADD engine_ret_ok VARCHAR(255) NOT NULL DEFAULT ''";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_payout_types ADD engine_ret_failed VARCHAR(255) NOT NULL DEFAULT ''";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_payout_types ADD pass_enc ENUM('md5', 'base64', 'none') NOT NULL DEFAULT 'md5'";
break;
case "0.1.4": // SQL queries for v0.1.4
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_payouts ADD password varchar(255) NOT NULL default ''";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_payouts ADD password VARCHAR(255) NOT NULL DEFAULT ''";
break;
case "0.1.5": // SQL queries for v0.1.5
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_payouts ADD target_url longblob NOT NULL";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_payouts ADD banner_url longblob NOT NULL";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_payouts ADD link_text varchar(30) NOT NULL default ''";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_payout_types ADD allow_url enum('Y', 'N') NOT NULL default 'N'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_payouts ADD target_url LONGBLOB NOT NULL";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_payouts ADD banner_url LONGBLOB NOT NULL";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_payouts ADD link_text VARCHAR(30) NOT NULL DEFAULT ''";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_payout_types ADD allow_url ENUM('Y', 'N') NOT NULL DEFAULT 'N'";
break;
case "0.1.6": // SQL queries for v0.1.6
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_payout_types CHANGE pass_enc pass_enc enum('md5', 'base64', 'xxx') NOT NULL default 'xxx'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_payout_types CHANGE pass_enc pass_enc ENUM('md5', 'base64', 'xxx') NOT NULL DEFAULT 'xxx'";
break;
case "0.1.8": // SQL queries for v0.1.8
break;
case "0.2.1": // SQL queries for v0.2.1
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_payouts CHANGE payout_total payout_total double(22,5) not null default '0.00000'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_payout_types CHANGE rate rate double(22,5) not null default '0.00000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_payouts CHANGE payout_total payout_total DOUBLE(22,5) NOT NULL DEFAULT '0.00000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_payout_types CHANGE rate rate DOUBLE(22,5) NOT NULL DEFAULT '0.00000'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Problem mit Speicherung der Einstellungen beseitigt.";
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_rallye_prices";
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_rallye_users";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_rallye_data (
-id bigint(20) not null auto_increment,
-admin_id bigint(20) not null default '0',
-title varchar(255) not null default '',
-descr longblob not null,
-template varchar(255) not null default '',
-start_time varchar(10) not null default '0',
-end_time varchar(10) not null default '0',
-auto_add_new_user enum('Y', 'N') not null default 'Y',
-is_active enum('Y', 'N') not null default 'N',
-send_notify enum('Y', 'N') not null default 'Y',
-notified enum('Y', 'N') not null default 'N',
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+admin_id BIGINT(20) NOT NULL DEFAULT '0',
+title VARCHAR(255) NOT NULL DEFAULT '',
+descr LONGBLOB NOT NULL,
+template VARCHAR(255) NOT NULL DEFAULT '',
+start_time VARCHAR(10) NOT NULL DEFAULT '0',
+end_time VARCHAR(10) NOT NULL DEFAULT '0',
+auto_add_new_user ENUM('Y', 'N') NOT NULL DEFAULT 'Y',
+is_active ENUM('Y', 'N') NOT NULL DEFAULT 'N',
+send_notify ENUM('Y', 'N') NOT NULL DEFAULT 'Y',
+notified ENUM('Y', 'N') NOT NULL DEFAULT 'N',
KEY (admin_id),
PRIMARY KEY (id)
) TYPE=MyISAM";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_rallye_prices (
-id bigint(20) not null auto_increment,
-rallye_id bigint(20) not null default '0',
-price_level bigint(20) not null default '0',
-points bigint(20) not null default '0',
-info longblob not null,
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+rallye_id BIGINT(20) NOT NULL DEFAULT '0',
+price_level BIGINT(20) NOT NULL DEFAULT '0',
+points BIGINT(20) NOT NULL DEFAULT '0',
+info LONGBLOB NOT NULL,
KEY (rallye_id),
PRIMARY KEY(id)
) TYPE=MyISAM";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_rallye_users (
-id bigint(20) not null auto_increment,
-rallye_id bigint(20) not null default '0',
-userid bigint(20) not null default '0',
-refs bigint(20) not null default '0',
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+rallye_id BIGINT(20) NOT NULL DEFAULT '0',
+userid BIGINT(20) NOT NULL DEFAULT '0',
+refs BIGINT(20) NOT NULL DEFAULT '0',
KEY (rallye_id),
KEY (userid),
PRIMARY KEY(id)
switch ($EXT_VER)
{
case "0.0.1": // SQL queries for v0.0.1
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_rallye_data ADD expired enum('Y', 'N') not null default 'N'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_rallye_data ADD expired ENUM('Y', 'N') NOT NULL DEFAULT 'N'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Ablaufen der Rallyes intergriert.";
break;
case "0.0.2": // SQL queries for v0.0.2
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_rallye_users ADD curr_points double(23,3) not null default '0.000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_rallye_users ADD curr_points DOUBLE(23,3) NOT NULL DEFAULT '0.000'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Aktueller {!POINTS!}-Stand wird beachtet.";
break;
case "0.1.0": // SQL queries for v0.2.1
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_rallye_users CHANGE curr_points curr_points double(23,5) not null default '0.00000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_rallye_users CHANGE curr_points curr_points DOUBLE(23,5) NOT NULL DEFAULT '0.00000'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "5 Nachkommastellen implementiert.";
break;
case "0.2.0": // SQL queries for v0.2.0
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_rallye_data ADD min_users bigint(20) not null default '0'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_rallye_data ADD min_prices bigint(20) not null default '3'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_rallye_data ADD min_users BIGINT(20) NOT NULL DEFAULT '0'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_rallye_data ADD min_prices BIGINT(20) NOT NULL DEFAULT '3'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Ablaufen der Rallyes intergriert. Bauen Sie in Ihr Template <STRONG>templates/de/emails/member/member_rallye_notifty.tpl</STRONG> folgende zwei Zeilen ein:<br />
case "0.1": // SQL queries for v0.1
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_must_register";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_must_register (
-id bigint(20) NOT NULL auto_increment,
-field_name varchar(255) not null default '',
-field_required enum('Y', 'N') not null default 'Y',
+id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+field_name VARCHAR(255) NOT NULL DEFAULT '',
+field_required ENUM('Y', 'N') NOT NULL DEFAULT 'Y',
PRIMARY KEY(id)
) TYPE=MyISAM";
break;
case "0.4.2": // SQL queries for v0.4.2
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD register_default ENUM('Y', 'N') NOT NULL DEFAULT 'N'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD register_default ENUM('Y','N') NOT NULL DEFAULT 'N'";
$SQLs[] = "UPDATE "._MYSQL_PREFIX."_admin_menu SET what='config_register2' WHERE what='config_reg' LIMIT 1";
// Update notes (these will be set as task text!)
break;
case "0.0.9": // SQL queries for v0.0.9
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD rewrite_skip varchar(255) not null default 'login:admin:frametester:mailid'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD rewrite_skip VARCHAR(255) NOT NULL DEFAULT 'login:admin:frametester:mailid'";
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES ('setup', 'config_rewrite', 'Rewrite-Engine', 'Stellen Sie hier ein, welche Module übersprungen werden sollen, in denen also kein Umschreiben des HTML-Codes stattfinden soll.', 8)";
// Update notes (these will be set as task text!)
//
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_data";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_data (
-id bigint(20) not null auto_increment,
-company varchar(255) not null default '',
-position varchar(255) not null default '',
-tax_ident varchar(255) not null default '',
-salut enum('M', 'F', 'C') not null default 'M',
-surname varchar(255) not null default '',
-family varchar(255) not null default '',
-street_nr1 varchar(255) not null default '',
-street_nr2 varchar(255) not null default '',
-zip varchar(6) not null default '',
-city varchar(255) not null default '',
-country char(2) not null default 'DE',
-phone varchar(255) not null default '',
-fax varchar(255) not null default '',
-cell varchar(255) not null default '',
-email varchar(255) not null default '',
-url varchar(255) not null default '',
-password varchar(255) not null default '',
-remote_addr varchar(15) not null default '0.0.0.0',
-sponsor_created varchar(10) not null default '0',
-last_online varchar(10) not null default '0',
-last_change varchar(10) not null default '0',
-status enum('UNCONFIRMED', 'PENDING', 'CONFIRMED', 'LOCKED') not null default 'UNCONFIRMED',
-receive_warnings enum('Y', 'N') not null default 'Y',
-warning_interval bigint(20) not null default '".(ONE_DAY*7)."',
-points_amount double(20,5) not null default '0.00000',
-points_used double(20,5) not null default '0.00000',
-refid bigint(20) not null default '0',
-ref_count bigint(20) not null default '0',
-hash varchar(32) not null default '',
-last_pay float(7,2) not null default '0.00',
-last_curr varchar(255) not null default '€',
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+company VARCHAR(255) NOT NULL DEFAULT '',
+position VARCHAR(255) NOT NULL DEFAULT '',
+tax_ident VARCHAR(255) NOT NULL DEFAULT '',
+salut ENUM('M', 'F', 'C') NOT NULL DEFAULT 'M',
+surname VARCHAR(255) NOT NULL DEFAULT '',
+family VARCHAR(255) NOT NULL DEFAULT '',
+street_nr1 VARCHAR(255) NOT NULL DEFAULT '',
+street_nr2 VARCHAR(255) NOT NULL DEFAULT '',
+zip VARCHAR(6) NOT NULL DEFAULT '',
+city VARCHAR(255) NOT NULL DEFAULT '',
+country CHAR(2) NOT NULL DEFAULT 'DE',
+phone VARCHAR(255) NOT NULL DEFAULT '',
+fax VARCHAR(255) NOT NULL DEFAULT '',
+cell VARCHAR(255) NOT NULL DEFAULT '',
+email VARCHAR(255) NOT NULL DEFAULT '',
+url VARCHAR(255) NOT NULL DEFAULT '',
+password VARCHAR(255) NOT NULL DEFAULT '',
+remote_addr VARCHAR(15) NOT NULL DEFAULT '0.0.0.0',
+sponsor_created VARCHAR(10) NOT NULL DEFAULT '0',
+last_online VARCHAR(10) NOT NULL DEFAULT '0',
+last_change VARCHAR(10) NOT NULL DEFAULT '0',
+status ENUM('UNCONFIRMED', 'PENDING', 'CONFIRMED', 'LOCKED') NOT NULL DEFAULT 'UNCONFIRMED',
+receive_warnings ENUM('Y', 'N') NOT NULL DEFAULT 'Y',
+warning_interval BIGINT(20) NOT NULL DEFAULT '".(ONE_DAY*7)."',
+points_amount DOUBLE(20,5) NOT NULL DEFAULT '0.00000',
+points_used DOUBLE(20,5) NOT NULL DEFAULT '0.00000',
+refid BIGINT(20) NOT NULL DEFAULT '0',
+ref_count BIGINT(20) NOT NULL DEFAULT '0',
+hash VARCHAR(32) NOT NULL DEFAULT '',
+last_pay FLOAT(7,2) NOT NULL DEFAULT '0.00',
+last_curr VARCHAR(255) NOT NULL DEFAULT '€',
KEY(refid),
KEY(email),
PRIMARY KEY(id)
//
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_orders";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_orders (
-id bigint(20) not null auto_increment,
-sponsorid bigint(20) not null default '0',
-aid bigint(20) not null default '0',
-regid bigint(20) not null default '0',
-payid bigint(20) not null default '0',
-pay_count bigint(20) not null default '0',
-pay_status enum('PENDING', 'PAYED', 'UNPAYED', 'DELETED') not null default 'PENDING',
-pay_ordered varchar(10) not null default '0',
-pay_done varchar(10) not null default '0',
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+sponsorid BIGINT(20) NOT NULL DEFAULT '0',
+aid BIGINT(20) NOT NULL DEFAULT '0',
+regid BIGINT(20) NOT NULL DEFAULT '0',
+payid BIGINT(20) NOT NULL DEFAULT '0',
+pay_count BIGINT(20) NOT NULL DEFAULT '0',
+pay_status ENUM('PENDING', 'PAYED', 'UNPAYED', 'DELETED') NOT NULL DEFAULT 'PENDING',
+pay_ordered VARCHAR(10) NOT NULL DEFAULT '0',
+pay_done VARCHAR(10) NOT NULL DEFAULT '0',
KEY (payid),
KEY (regid),
KEY (aid),
//
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_paytypes";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_paytypes (
-id bigint(20) not null auto_increment,
-pay_name varchar(255) not null default '',
-pay_rate double(20,5) not null default '0.00000',
-pay_min_count bigint(20) not null default '1',
-pay_currency varchar(255) not null default '€',
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+pay_name VARCHAR(255) NOT NULL DEFAULT '',
+pay_rate DOUBLE(20,5) NOT NULL DEFAULT '0.00000',
+pay_min_count BIGINT(20) NOT NULL DEFAULT '1',
+pay_currency VARCHAR(255) NOT NULL DEFAULT '€',
PRIMARY KEY(id)
)TYPE=MyISAM";
//
//
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_action_convert";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_action_convert (
-id bigint(20) not null auto_increment,
-ext_name varchar(255) not null default 'sponsor',
-conv_rate bigint(20) not null default '0',
-conv_name varchar(255) not null default 'Mails',
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+ext_name VARCHAR(255) NOT NULL DEFAULT 'sponsor',
+conv_rate BIGINT(20) NOT NULL DEFAULT '0',
+conv_name VARCHAR(255) NOT NULL DEFAULT 'Mails',
KEY (ext_name),
PRIMARY KEY(id)
)TYPE=MyISAM";
//
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_menu";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_menu (
-id bigint(20) not null auto_increment,
-action varchar(255) not null default '',
-what varchar(255) not null default '',
-title varchar(255) not null default '',
-active enum('Y', 'N') not null default 'N',
-sort bigint(20) not null default '0',
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+action VARCHAR(255) NOT NULL DEFAULT '',
+what VARCHAR(255) NOT NULL DEFAULT '',
+title VARCHAR(255) NOT NULL DEFAULT '',
+active ENUM('Y', 'N') NOT NULL DEFAULT 'N',
+sort BIGINT(20) NOT NULL DEFAULT '0',
KEY(what),
KEY(action),
PRIMARY KEY(id)
//
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_registry";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_registry (
-id bigint(20) not null auto_increment,
-aid bigint(20) not null default '0',
-ext_name varchar(255) not null default 'sponsor',
-is_active enum('Y', 'N') not null default 'N',
-stamp_added varchar(10) not null default '0',
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+aid BIGINT(20) NOT NULL DEFAULT '0',
+ext_name VARCHAR(255) NOT NULL DEFAULT 'sponsor',
+is_active ENUM('Y', 'N') NOT NULL DEFAULT 'N',
+stamp_added VARCHAR(10) NOT NULL DEFAULT '0',
KEY(ext_name),
KEY(aid),
PRIMARY KEY(id)
//
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_urls";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_urls (
-id bigint(20) not null auto_increment,
-sponsorid bigint(20) not null default '0',
-url varchar(255) not null default 'http://',
-title varchar(255) not null default '',
-clicks bigint(20) not null default '0',
-status enum('PENDING', 'ACTIVE', 'LOCKED') not null default 'PENDING',
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+sponsorid BIGINT(20) NOT NULL DEFAULT '0',
+url VARCHAR(255) NOT NULL DEFAULT 'http://',
+title VARCHAR(255) NOT NULL DEFAULT '',
+clicks BIGINT(20) NOT NULL DEFAULT '0',
+status ENUM('PENDING', 'ACTIVE', 'LOCKED') NOT NULL DEFAULT 'PENDING',
KEY(sponsorid),
PRIMARY KEY(id)
)TYPE=MyISAM";
//
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_banner";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_banner (
-id bigint(20) not null auto_increment,
-sponsorid bigint(20) not null default '0',
-url varchar(255) not null default 'http://',
-alternate varchar(255) not null default '',
-width int(7) not null default '468',
-height int(7) not null default '60',
-views bigint(20) not null default '0',
-status enum('PENDING', 'ACTIVE', 'LOCKED') not null default 'PENDING',
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+sponsorid BIGINT(20) NOT NULL DEFAULT '0',
+url VARCHAR(255) NOT NULL DEFAULT 'http://',
+alternate VARCHAR(255) NOT NULL DEFAULT '',
+width INT(7) NOT NULL DEFAULT '468',
+height INT(7) NOT NULL DEFAULT '60',
+views BIGINT(20) NOT NULL DEFAULT '0',
+status ENUM('PENDING', 'ACTIVE', 'LOCKED') NOT NULL DEFAULT 'PENDING',
KEY(sponsorid),
PRIMARY KEY(id)
)TYPE=MyISAM";
//
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_campaigns";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_campaigns (
-id bigint(20) not null auto_increment,
-sponsorid bigint(20) not null default '0',
-aid bigint(20) not null default '0',
-campaign_name varchar(255) not null default '',
-campaign_start varchar(10) not null default '0',
-campaign_end varchar(10) not null default '0',
-campaign_amount double(20,5) not null default '0.00000',
-campaign_expired enum('Y', 'N') not null default 'N',
-campaign_locked enum('Y', 'N') not null default 'Y',
-campaign_ended varchar(10) not null default '0',
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+sponsorid BIGINT(20) NOT NULL DEFAULT '0',
+aid BIGINT(20) NOT NULL DEFAULT '0',
+campaign_name VARCHAR(255) NOT NULL DEFAULT '',
+campaign_start VARCHAR(10) NOT NULL DEFAULT '0',
+campaign_end VARCHAR(10) NOT NULL DEFAULT '0',
+campaign_amount DOUBLE(20,5) NOT NULL DEFAULT '0.00000',
+campaign_expired ENUM('Y', 'N') NOT NULL DEFAULT 'N',
+campaign_locked ENUM('Y', 'N') NOT NULL DEFAULT 'Y',
+campaign_ended VARCHAR(10) NOT NULL DEFAULT '0',
locked_reason tinyblob,
-locked_timestamp varchar(10) not null default '0',
-status enum('PENDING', 'ACTIVE', 'LOCKED') not null default 'PENDING',
+locked_timestamp VARCHAR(10) NOT NULL DEFAULT '0',
+status ENUM('PENDING', 'ACTIVE', 'LOCKED') NOT NULL DEFAULT 'PENDING',
KEY(aid),
KEY(sponsorid),
PRIMARY KEY(id)
//
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_campaign_assigns";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_campaign_assigns (
-id bigint(20) not null auto_increment,
-campaignid bigint(20) not null default '0',
-urlid bigint(20) not null default '0',
-bannerid bigint(20) not null default '0',
-clicks bigint(20) not null default '0',
-views bigint(20) not null default '0',
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+campaignid BIGINT(20) NOT NULL DEFAULT '0',
+urlid BIGINT(20) NOT NULL DEFAULT '0',
+bannerid BIGINT(20) NOT NULL DEFAULT '0',
+clicks BIGINT(20) NOT NULL DEFAULT '0',
+views BIGINT(20) NOT NULL DEFAULT '0',
KEY(bannerid),
KEY(urlid),
KEY(campaignid),
//
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_admin_data";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_admin_data (
-id bigint(20) not null auto_increment,
-data_row varchar(255) not null default '',
-display enum('Y', 'N') not null default 'N',
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+data_row VARCHAR(255) NOT NULL DEFAULT '',
+display ENUM('Y', 'N') NOT NULL DEFAULT 'N',
PRIMARY KEY(id)
)TYPE=MyISAM";
//
//
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_display_data";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_display_data (
-id bigint(20) not null auto_increment,
-sponsorid bigint(20) not null default '0',
-data_row varchar(255) not null default '',
-display enum('Y', 'N') not null default 'N',
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+sponsorid BIGINT(20) NOT NULL DEFAULT '0',
+data_row VARCHAR(255) NOT NULL DEFAULT '',
+display ENUM('Y', 'N') NOT NULL DEFAULT 'N',
KEY(sponsorid),
PRIMARY KEY(id)
)TYPE=MyISAM";
//
// General configuration stuff
//
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD sponsor_ref_points double(20,5) not null default '100.00000'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD sponsor_min_points double(20,5) not null default '1000.00000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD sponsor_ref_points DOUBLE(20,5) NOT NULL DEFAULT '100.00000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD sponsor_min_points DOUBLE(20,5) NOT NULL DEFAULT '1000.00000'";
// Load CSS file
$EXT_CSS = "Y";
switch ($EXT_VER)
{
case "0.0.1": // SQL queries for v0.0.1
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD ext_autopurge enum('Y', 'N') not null default 'Y'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD ext_autopurge ENUM('Y', 'N') NOT NULL DEFAULT 'Y'";
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES ('setup', 'config_extensions', 'Erweitungsmanagement', 'Alle Einstellungen am Erweiterungsmanagement.', 10)";
// Update notes (these will be set as task text!)
break;
case "0.0.2": // SQL queries for v0.0.2
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config CHANGE auto_purge auto_purge bigint(20) not null default '1209600'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config CHANGE auto_purge auto_purge BIGINT(20) NOT NULL DEFAULT '1209600'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "In der Tabelle <STRONG>mxchange_config</STRONG> musste die Spalte <STRONG>auto_purge</STRONG> (autom. Löschen von Bestätigungsmails angepasst werden (war auf dem Testsystem auf tiny(4) gesetzt.)";
break;
case "0.0.3": // SQL queries for v0.0.3
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD points_word varchar(255) not null default 'Punkte'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD points_word VARCHAR(255) NOT NULL DEFAULT 'Punkte'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Das Wort "Punkte" kann nun per Datenbank geändert werden. Damit können Sie anstelle des Wortes Punkte auch Klammlose oder € schreiben.";
break;
case "0.0.4": // SQL queries for v0.0.4
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD mails_page bigint(20) not null default '10'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD mails_page BIGINT(20) NOT NULL DEFAULT '10'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Anzahl Mails pro Seite in <STRONG>EMail-Details ansehen</STRONG> und <STRONG>EMail-Archiv</STRONG> hinzugefügt.";
break;
case "0.0.5": // SQL queries for v0.0.5
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD index_home varchar(255) not null default 'welcome'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD index_home VARCHAR(255) NOT NULL DEFAULT 'welcome'";
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES ('setup', 'config_home', 'Home-Seite festlegen', 'Stellen Sie hier ein, welcher Menüpunkt (what-welcome ist Standart) als Einstiegspunkt in das Menüsystem genutzt werden soll.', 5)";
// Update notes (these will be set as task text!)
break;
case "0.0.6": // SQL queries for v0.0.6
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_extensions ADD ext_has_css enum('Y', 'N') not null default 'N'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_extensions ADD ext_has_css ENUM('Y', 'N') NOT NULL DEFAULT 'N'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Es können nun SQL-Updates von einander abhängig gemacht werden und die CSS-Datei kann per Admin-Bereich (wegen Debuggings) ein- bzw. ausgeschaltet werden.";
break;
case "0.0.7": // SQL queries for v0.0.7
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD verbose_sql enum('Y', 'N') not null default 'Y'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD verbose_sql ENUM('Y', 'N') NOT NULL DEFAULT 'Y'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Die SQL-Anweisungen werden bei eingeschalteter Verbose-Funktion detailiert angezeigt.";
break;
case "0.0.8": // SQL queries for v0.0.8
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD menu_blur_spacer varchar(255) not null default ' <STRONG><BIG>·</BIG></STRONG> '";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD menu_blur_spacer VARCHAR(255) NOT NULL DEFAULT ' <STRONG><BIG>·</BIG></STRONG> '";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Nette Mouse-Hover-Effekte eingebaut (Anleitung <STRONG>MENUE_HOVER.txt</STRONG> zum Patchen der general.css bitte lesen!)";
break;
case "0.1.0": // SQL queries for v0.2.1
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD reg_points_mode enum('ref', 'direct') not null default 'ref'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD reg_points_mode ENUM('ref', 'direct') NOT NULL DEFAULT 'ref'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Soll der einmalige Ref-Bonus über das Referral-System (also alle oberen Refs bekommen auch etwas davon ab) oder direkt dem Werber aufgebucht werden?";
case "0.1.1": // SQL queries for v0.1.1
$SQLs[] = "UPDATE "._MYSQL_PREFIX."_admin_menu SET title='Home-/Eingangsseite', descr='Stellen Sie hier ein, welcher Menüpunkt (what-welcome ist Standart) als Einstiegspunkt in das Menüsystem genutzt werden soll und wie die automatische Weiterleitung in der Eingangsseite funktionieren soll.' WHERE what='config_home' LIMIT 1";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD index_delay tinyint(4) not null default '-1'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD index_cookie bigint(20) not null default '31536000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD index_delay TINYINT(3) NOT NULL DEFAULT '-1'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD index_cookie BIGINT(20) NOT NULL DEFAULT '31536000'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Sie können nun <A href=\"".URL."/modules.php?module=admin&what=config_home\">hier</A> die Verzögerungszeit in der <A href=\"".URL."/index.php\">Eingangsseite</A> einstellen.";
case "0.1.2": // SQL queries for v0.1.2
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES ('setup', 'config_refid', 'Standart-Ref-ID', 'Stellen Sie hier die User-ID ein, die genommen werden soll, wenn der Gast n icht per Referral-Link Ihren Mailtausch aufgerufen hat.', 7)";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD def_refid bigint(20) not null default '0'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD def_refid BIGINT(20) NOT NULL DEFAULT '0'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Standart Referral-ID kann per Admin-Bereich eingestellt werden (war vorher nur in modules.php und index.php direkt eingebbar.)";
break;
case "0.1.3": // SQL queries for v0.1.3
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD refid_target enum('register', 'index') not null default 'register'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD refid_target ENUM('register', 'index') NOT NULL DEFAULT 'register'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Auf welche Seite soll der Ref-Link zeigen? Eingangsseite oder Anmeldeformular?";
break;
case "0.1.4": // SQL queries for v0.1.4
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD default_theme varchar(255) not null default '".GET_CURR_THEME()."'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD default_theme VARCHAR(255) NOT NULL DEFAULT '".GET_CURR_THEME()."'";
$SQLs[] = "DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_admin_menu WHERE action='theme' LIMIT 3";
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES ('theme', NULL, 'Themes', 'Verwalten Sie hier alle Designs (Themes) Ihres Mailtausch-Scriptes.', 8)";
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES ('theme', 'theme_import', 'Importieren', 'Es wird das Verzeichnis "theme" nach neuen Ordnern durchsucht und anschliessend in die Datenbank gesperrt aufgenommen.', 1)";
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_member_menu (action, what, title, sort, visible, locked) VALUES ('themes', NULL, 'Design-Auswahl', 3, 'Y', 'N')";
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_themes";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_themes (
-id bigint(20) not null auto_increment,
-theme_path varchar(255) not null default '',
-theme_active enum('Y', 'N') not null default 'N',
-theme_ver varchar(255) not null default '0.0',
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+theme_path VARCHAR(255) NOT NULL DEFAULT '',
+theme_active ENUM('Y', 'N') NOT NULL DEFAULT 'N',
+theme_ver VARCHAR(255) NOT NULL DEFAULT '0.0',
PRIMARY KEY(id)
) TYPE=MyISAM";
break;
case "0.1.6": // SQL queries for v0.1.6
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD enable_title_deco enum('Y', 'N') not null default 'Y'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD title_left varchar(10) not null default '[--'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD title_middle varchar(10) not null default '-'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD title_right varchar(10) not null default '--]'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD enable_mod_title enum('Y', 'N') not null default 'Y'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD enable_what_title enum('Y', 'N') not null default 'Y'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD enable_title_deco ENUM('Y', 'N') NOT NULL DEFAULT 'Y'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD title_left VARCHAR(10) NOT NULL DEFAULT '[--'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD title_middle VARCHAR(10) NOT NULL DEFAULT '-'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD title_right VARCHAR(10) NOT NULL DEFAULT '--]'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD enable_mod_title ENUM('Y', 'N') NOT NULL DEFAULT 'Y'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD enable_what_title ENUM('Y', 'N') NOT NULL DEFAULT 'Y'";
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES ('setup', 'config_title', 'Seitentitel ändern', 'De-/aktivieren Sie hier die Dekorationen, sowie Modul-Titel und what-Titel im Seitentitel.', 8)";
// Update notes (these will be set as task text!)
break;
case "0.2.0": // SQL queries for v0.2.0
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_jackpot CHANGE points points double(22,5) not null default '0.00000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_jackpot CHANGE points points DOUBLE(22,5) NOT NULL DEFAULT '0.00000'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_payments CHANGE payment payment double(22,5) not null default '0.00000'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_payments CHANGE price price double(22,5) not null default '0.00000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_payments CHANGE payment payment DOUBLE(22,5) NOT NULL DEFAULT '0.00000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_payments CHANGE price price DOUBLE(22,5) NOT NULL DEFAULT '0.00000'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data CHANGE used_points used_points double(22,5) not null default '0.00000'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_points CHANGE points points double(22,5) not null default '0.00000'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_points CHANGE locked_points locked_points double(22,5) not null default '0.00000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data CHANGE used_points used_points DOUBLE(22,5) NOT NULL DEFAULT '0.00000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_points CHANGE points points DOUBLE(22,5) NOT NULL DEFAULT '0.00000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_points CHANGE locked_points locked_points DOUBLE(22,5) NOT NULL DEFAULT '0.00000'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "5 Nachkommastellen implementiert";
break;
case "0.2.1": // SQL queries for v0.2.1
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD css_php enum('DIRECT', 'FILE') not null default 'FILE'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD css_php ENUM('DIRECT', 'FILE') NOT NULL DEFAULT 'FILE'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Ausgabe der CSS-Dateien entweder per css.php oder sie sind direkt eingebunden.";
break;
case "0.2.3": // SQL queries for v0.2.3
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD guest_menu enum('Y', 'N') not null default 'Y'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD member_menu enum('Y', 'N') not null default 'Y'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD youre_here enum('Y', 'N') not null default 'Y'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD guest_menu ENUM('Y', 'N') NOT NULL DEFAULT 'Y'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD member_menu ENUM('Y', 'N') NOT NULL DEFAULT 'Y'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD youre_here ENUM('Y', 'N') NOT NULL DEFAULT 'Y'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Gast- und Mitgliedsmenüs lassen sich getrennt voneinander abschalten.";
// Switch to JPEG format
$auto_type = "jpg";
}
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD img_type enum('jpg', 'png') not null default '".$auto_type."'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD img_type ENUM('jpg', 'png') NOT NULL DEFAULT '".$auto_type."'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Generierung des Mailbestätigungscodes hängt davon ab, ob die PHP-Funktion <U>imagecreatefromjpeg()</U> und das JPEG-Bild vorhanden sind oder nicht.";
break;
case "0.2.5": // SQL queries for v0.2.5
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data CHANGE receive_mails receive_mails bigint(20) not null default '0'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data CHANGE max_mails max_mails bigint(20) not null default '0'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data CHANGE receive_mails receive_mails BIGINT(20) NOT NULL DEFAULT '0'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data CHANGE max_mails max_mails BIGINT(20) NOT NULL DEFAULT '0'";
// Update notes (these will be set as task text!)
- $UPDATE_NOTES = "Spalten <U>max_mails</U> und <U>receive_mails</U> auf bigint(20) gesetzt.";
+ $UPDATE_NOTES = "Spalten <U>max_mails</U> und <U>receive_mails</U> auf BIGINT(20) gesetzt.";
break;
case "0.2.6": // SQL queries for v0.2.6
case "0.2.7": // SQL queries for v0.2.7
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_member_menu (action, what, title, sort) VALUES ('main', 'themes', 'Designs', 6)";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD curr_theme varchar(255) not null default 'default'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD stats_limit bigint(20) not null default '10'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD curr_theme VARCHAR(255) NOT NULL DEFAULT 'default'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD stats_limit BIGINT(20) NOT NULL DEFAULT '10'";
$SQLs[] = "UPDATE "._MYSQL_PREFIX."_admin_menu SET what='config_stats' WHERE what='stats' LIMIT 1";
// Update notes (these will be set as task text!)
break;
case "0.2.8": // SQL queries for v0.2.8
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD last_login varchar(10) not null default '0'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD last_login VARCHAR(10) NOT NULL DEFAULT '0'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Letzter Login wird gespeichert, Cache wird bei installierter Cache-Erweiterung bei Sprachenänderung aufgefrischt.";
break;
case "0.2.9": // SQL queries for v0.2.9
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD mt_word varchar(255) not null default 'Mailtausch'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD mt_word2 varchar(255) not null default 'Mailtausches'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD mt_word3 varchar(255) not null default 'Mailtauscher'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD mt_word VARCHAR(255) NOT NULL DEFAULT 'Mailtausch'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD mt_word2 VARCHAR(255) NOT NULL DEFAULT 'Mailtausches'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD mt_word3 VARCHAR(255) NOT NULL DEFAULT 'Mailtauscher'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Wörter <STRONG>Mailtausch</STRONG>, <STRONG>Mailtausches</STRONG> und <STRONG>Mailtauscher</STRONG> sind austauschbar.";
// Connection table between the menu system and the "logical area" system
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_admin_menu_las";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_admin_menu_las (
-id bigint(20) not null auto_increment,
-la_id varchar(255) not null default '',
-la_action varchar(255) not null default '',
-la_what varchar(255) not null default '',
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+la_id VARCHAR(255) NOT NULL DEFAULT '',
+la_action VARCHAR(255) NOT NULL DEFAULT '',
+la_what VARCHAR(255) NOT NULL DEFAULT '',
INDEX (la_id),
INDEX (la_action),
INDEX (la_what),
// All "logical areas" together
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_admin_menu_las_data";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_admin_menu_las_data (
-id bigint(20) not null auto_increment,
-la_id varchar(255) not null default '',
-la_title varchar(255) not null default '',
-la_posx bigint(20) not null default '0',
-la_posy bigint(20) not null default '0',
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+la_id VARCHAR(255) NOT NULL DEFAULT '',
+la_title VARCHAR(255) NOT NULL DEFAULT '',
+la_posx BIGINT(20) NOT NULL DEFAULT '0',
+la_posy BIGINT(20) NOT NULL DEFAULT '0',
UNIQUE KEY (la_id),
INDEX (la_posx),
INDEX (la_posy),
PRIMARY KEY(id)
) TYPE=MyISAM";
// Which menu do you like?
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD admin_menu enum('NEW', 'OLD') not null default 'OLD'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD admin_menu ENUM('NEW', 'OLD') NOT NULL DEFAULT 'OLD'";
// Insert menus
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES ('setup', 'config_admin', 'Adminmenü', 'Diverse Einstellungen am Adminmenü vornehmen.', 9)";
case "0.3.3": // SQL queries for v0.3.3
// Switch of the "intelligent menu sorter" when you want to have a fixed menu structure...
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD admin_menu_sorter enum('Y', 'N') not null default 'Y'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD admin_menu_sorter ENUM('Y', 'N') NOT NULL DEFAULT 'Y'";
// The statistics table
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_admin_menu_stats";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_admin_menu_stats (
-id bigint(20) not null auto_increment,
-aid bigint(20) not null default '0',
-type enum('la', 'action', 'what') not null default 'what',
-clicks bigint(20) not null default '0',
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+aid BIGINT(20) NOT NULL DEFAULT '0',
+type ENUM('la', 'action', 'what') NOT NULL DEFAULT 'what',
+clicks BIGINT(20) NOT NULL DEFAULT '0',
INDEX (aid),
PRIMARY KEY (id)
) TYPE=MyISAM";
break;
case "0.3.6": // SQL queries for v0.3.6
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD salt_length tinyint(4) not null default '9'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD pass_scramble varchar(255) not null default ''";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data MODIFY password varchar(255) not null default ''";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data MODIFY user_hash varchar(255) not null default ''";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_admins MODIFY password varchar(255) not null default ''";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD rand_no bigint(20) not null default '0'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD file_hash varchar(255) not null default ''";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD master_salt varchar(255) not null default ''";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD salt_length TINYINT(3) NOT NULL DEFAULT '9'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD pass_scramble VARCHAR(255) NOT NULL DEFAULT ''";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data MODIFY password VARCHAR(255) NOT NULL DEFAULT ''";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data MODIFY user_hash VARCHAR(255) NOT NULL DEFAULT ''";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_admins MODIFY password VARCHAR(255) NOT NULL DEFAULT ''";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD rand_no BIGINT(20) NOT NULL DEFAULT '0'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD file_hash VARCHAR(255) NOT NULL DEFAULT ''";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD master_salt VARCHAR(255) NOT NULL DEFAULT ''";
$SQLs[] = "UPDATE "._MYSQL_PREFIX."_config SET rand_no=(ROUND(RAND() * 99999) + 100000) WHERE config=0 LIMIT 1";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_mod_reg ADD has_menu enum('Y', 'N') NOT NULL default 'N'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_mod_reg ADD has_menu ENUM('Y', 'N') NOT NULL DEFAULT 'N'";
$SQLs[] = "UPDATE "._MYSQL_PREFIX."_mod_reg SET has_menu='Y' WHERE module='admin' OR module='index' OR module='login' LIMIT 3";
// Update notes (these will be set as task text!)
case "0.4.3": // SQL queries for v0.4.3
$SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_config` ADD `proxy_host` VARCHAR(255) NOT NULL DEFAULT ''";
- $SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_config` ADD `proxy_port` INT(5) NOT NULL DEFAULT '0'";
+ $SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_config` ADD `proxy_port` INT(5) UNSIGNED NOT NULL DEFAULT '0'";
$SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_config` ADD `proxy_username` VARCHAR(255) NOT NULL DEFAULT ''";
$SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_config` ADD `proxy_password` VARCHAR(255) NOT NULL DEFAULT ''";
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES ('setup', 'config_proxy', 'Proxy-Einstellungen', 'Sollte Ihr Webserver sich hinter einem Proxy befinden, so können Sie hier MXChange so konfigurieren, dass es Updates durch diesen hindurch sucht!', 15)";
// SQL commands to run (surfbar URLs)
$SQLs[] = "DROP TABLE IF EXISTS `"._MYSQL_PREFIX."_surfbar_urls`";
$SQLs[] = "CREATE TABLE `"._MYSQL_PREFIX."_surfbar_urls` (
-`id` BIGINT(20) NOT NULL AUTO_INCREMENT,
-`userid` BIGINT(20) NOT NULL DEFAULT '0',
+`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+`userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
`url` VARCHAR(255) NOT NULL DEFAULT '',
-`reward` double(20,5) NOT NULL DEFAULT '0.00000',
-`views_total` BIGINT(20) NOT NULL DEFAULT '0',
+`reward` DOUBLE(20,5) UNSIGNED NOT NULL DEFAULT '0.00000',
+`views_total` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
`status` ENUM('PENDING','CONFIRMED', 'LOCKED') NOT NULL DEFAULT 'CONFIRMED',
`registered` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
`last_locked` TIMESTAMP NOT NULL DEFAULT '0000-00-00 00:00:00',
$SQLs[] = "DROP TABLE IF EXISTS `"._MYSQL_PREFIX."_surfbar_locks`";
$SQLs[] = "CREATE TABLE `"._MYSQL_PREFIX."_surfbar_locks` (
`id` BIGINT(20) NOT NULL AUTO_INCREMENT,
-`userid` BIGINT(20) NOT NULL DEFAULT '0',
-`url_id` BIGINT(20) NOT NULL DEFAULT '0',
+`userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
+`url_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
`last_surfed` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
PRIMARY KEY(`id`),
INDEX(`userid`),
$SQLs[] = "DROP TABLE IF EXISTS `"._MYSQL_PREFIX."_surfbar_reflevels`";
$SQLs[] = "CREATE TABLE `"._MYSQL_PREFIX."_surfbar_reflevels` (
`id` BIGINT(20) NOT NULL AUTO_INCREMENT,
-`level` SMALLINT(6) NOT NULL DEFAULT '0',
-`percent` FLOAT(10,5) NOT NULL DEFAULT '0.00000',
+`level` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '0',
+`percent` FLOAT(10,5) UNSIGNED NOT NULL DEFAULT '0.00000',
PRIMARY KEY(`id`)
) TYPE=MyISAM COMMENT='Surfbar referal levels'";
// Config entries
$SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_config` ADD `surfbar_pay_model` ENUM('STATIC','DYNAMIC') NOT NULL DEFAULT 'STATIC'";
- $SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_config` ADD `surfbar_static_reward` FLOAT(20,5) NOT NULL DEFAULT '0.25000'";
- $SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_config` ADD `surfbar_static_time` SMALLINT(6) NOT NULL DEFAULT '60'";
- $SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_config` ADD `surfbar_static_lock` SMALLINT(6) NOT NULL DEFAULT '".(60*60)."'";
- $SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_config` ADD `surfbar_notify_admin_unlock` ENUM('N', 'Y') NOT NULL DEFAULT 'N'";
+ $SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_config` ADD `surfbar_static_reward` FLOAT(20,5) UNSIGNED NOT NULL DEFAULT '0.25000'";
+ $SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_config` ADD `surfbar_static_time` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '60'";
+ $SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_config` ADD `surfbar_static_lock` SMALLINT(6) UNSIGNED NOT NULL DEFAULT '".(60*60)."'";
+ $SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_config` ADD `surfbar_notify_admin_unlock` ENUM('N','Y') NOT NULL DEFAULT 'N'";
+ $SQLs[] = "ALTER TABLE `"._MYSQL_PREFIX."_config` ADD `surfbar_dynamic_percent` FLOAT(10,5) UNSIGNED NOT NULL DEFAULT '10.00000'";
// Member menus
$SQLs[] = "INSERT INTO `"._MYSQL_PREFIX."_member_menu` (`action`,`what`,`title`,`visible`,`locked`,`sort`) VALUES ('surfbar',NULL,'Surfbar','Y','Y',5)";
// SQL commands to run
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_guest_menu (action, what, title, visible, locked, sort) VALUES ('main', 'top10', 'TOP-10', 'Y', 'Y', 7)";
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES ('setup', 'config_top10', 'TOP-10 Listen', 'Stellen Sie hier ein, wie lang die TOP-Listen sein sollen, also wie viele Plätze angezeigt werden sollen.', 8)";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD top10_max tinyint(4) not null default '10'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD top10_max TINYINT(3) NOT NULL DEFAULT '10'";
// Load CSS file?
$EXT_CSS = "Y";
// Transfer from a member
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_user_transfers_in (
-id bigint(20) not null auto_increment,
-userid bigint(20) not null default '0',
-from_uid bigint(20) not null default '0',
-points bigint(20) not null default '0',
-reason varchar(255) not null default '',
-time_trans varchar(14) not null default '0',
-trans_id varchar(12) not null default '',
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+userid BIGINT(20) NOT NULL DEFAULT '0',
+from_uid BIGINT(20) NOT NULL DEFAULT '0',
+points BIGINT(20) NOT NULL DEFAULT '0',
+reason VARCHAR(255) NOT NULL DEFAULT '',
+time_trans VARCHAR(14) NOT NULL DEFAULT '0',
+trans_id VARCHAR(12) NOT NULL DEFAULT '',
KEY (userid),
KEY (from_uid),
PRIMARY KEY(id)
// Transfers to a member
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_user_transfers_out (
-id bigint(20) not null auto_increment,
-userid bigint(20) not null default '0',
-to_uid bigint(20) not null default '0',
-points bigint(20) not null default '0',
-reason varchar(255) not null default '',
-time_trans varchar(14) not null default '0',
-trans_id varchar(12) not null default '',
+id BIGINT(20) NOT NULL AUTO_INCREMENT,
+userid BIGINT(20) NOT NULL DEFAULT '0',
+to_uid BIGINT(20) NOT NULL DEFAULT '0',
+points BIGINT(20) NOT NULL DEFAULT '0',
+reason VARCHAR(255) NOT NULL DEFAULT '',
+time_trans VARCHAR(14) NOT NULL DEFAULT '0',
+trans_id VARCHAR(12) NOT NULL DEFAULT '',
KEY (userid),
KEY (to_uid),
PRIMARY KEY(id)
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_member_menu (action, what, title, visible, locked, sort) VALUES ('main', 'transfer', '{!POINTS!}-Transfer', 'Y', 'Y', 5)";
// Add config values
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD transfer_max bigint(20) not null default '50'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD transfer_age bigint(20) not null default '".(ONE_DAY*28)."'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD transfer_timeout bigint(20) not null default '".ONE_DAY."'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD transfer_balance bigint(20) not null default '100'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD transfer_code bigint(20) not null default '5'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD transfer_max BIGINT(20) NOT NULL DEFAULT '50'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD transfer_age BIGINT(20) NOT NULL DEFAULT '".(ONE_DAY*28)."'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD transfer_timeout BIGINT(20) NOT NULL DEFAULT '".ONE_DAY."'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD transfer_balance BIGINT(20) NOT NULL DEFAULT '100'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD transfer_code BIGINT(20) NOT NULL DEFAULT '5'";
// Add row(s) to user's data
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD opt_in enum('Y', 'N') not null default 'N'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD opt_in ENUM('Y', 'N') NOT NULL DEFAULT 'N'";
break;
case "remove": // Do stuff when removing extension
break;
case "0.0.5": // SQL queries for v0.0.5
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD ap_transfer enum('Y', 'N') not null default 'Y'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD ap_transfer ENUM('Y', 'N') NOT NULL DEFAULT 'Y'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Link <I>Auflisten</LI> im Admin-Bereich hatte das eingeloggte Mitglied und nicht den eingeloggten Admin abgefragt. Automatisches Löschen von veraltete Einträgen kann unabhängig von der autopurge-Erweiterung de-/aktiviert werden. Bitte aktualisieren Sie auch die beiden Admin-Templates!";
switch ($EXT_VER)
{
case "0.1": // SQL queries for v0.1
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD user_limit int(7) not null default '20'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD user_limit INT(7) NOT NULL DEFAULT '20'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Seitenweises Anzeigen der User-Liste ist nun möglich.";
$UPDATE_NOTES = "CSS-Datei kann per Admin-Bereich ein- und ausgeschaltet werden.";
case "0.1.2": // SQL queries for v0.1.2
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD mails_confirmed bigint(20) not null default '0'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD mails_confirmed BIGINT(20) NOT NULL DEFAULT '0'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Dem Mitglied wird nun angezeigt, wie viele Mails er bestätigt hat. Alle vor dieser Version best. Mails werden leider nicht mehr berücksichtigt! Bitte teilen Sie dies Ihren Mitgliedern mit.";
break;
case "0.1.4": // SQL queries for v0.1.4
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD emails_received bigint(20) not null default '0'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD emails_received BIGINT(20) NOT NULL DEFAULT '0'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Anzahl empfangener Mails wird angezeigt. <BIG>Diese Anzeige kann fehlerhaft sein, wenn Sie bereits Mitglieder in Ihrem {!MT_WORD!} haben sollen!</BIG>";
break;
case "0.2.1": // SQL queries for v0.2.1
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD user_alpha tinyint(4) not null default '10'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD user_alpha TINYINT(3) NOT NULL DEFAULT '10'";
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES('setup', 'config_user', 'Mitgliederliste', 'Anzahl Mitglieder pro Seite, Anzahl Buchstaben pro Zeile usw.', 8)";
// Update notes (these will be set as task text!)
break;
case "0.2.2": // SQL queries for v0.2.2
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data CHANGE sex sex enum('M', 'F', 'C') not null default 'M'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data CHANGE sex sex ENUM('M', 'F', 'C') NOT NULL DEFAULT 'M'";
// Update notes (these will be set as task text!)
$UPDATE_NOTES = "Anrede "Firma" hinzugefügt.";
// SQL commands to run
$SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_user_wernis";
$SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_user_wernis (
-id bigint(20) NOT NULL auto_increment,
-userid bigint(20) NOT NULL default '0',
-wernis_account varchar(255) NOT NULL default '',
-wernis_amount double(22,5) NOT NULL default '0.00000',
-wernis_timestamp varchar(10) NOT NULL default '0',
-wernis_type ENUM('IN','OUT', 'FAILED') NOT NULL default 'FAILED',
+id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+userid BIGINT(20) UNSIGNED NOT NULL DEFAULT '0',
+wernis_account VARCHAR(255) NOT NULL DEFAULT '',
+wernis_amount DOUBLE(22,5) UNSIGNED NOT NULL DEFAULT '0.00000',
+wernis_timestamp VARCHAR(10) NOT NULL DEFAULT '0',
+wernis_type ENUM('IN','OUT', 'FAILED') NOT NULL DEFAULT 'FAILED',
wernis_api_message TINYTEXT,
-wernis_api_status varchar(255) NULL default NULL,
+wernis_api_status VARCHAR(255) NULL DEFAULT NULL,
KEY(userid),
PRIMARY KEY(id)
) TYPE=MyISAM";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD wernis_min_payout bigint(20) not null default '40000'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD wernis_min_withdraw bigint(20) not null default '5000'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD wernis_api_id bigint(20) not null default '0'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD wernis_api_md5 varchar(32) not null default ''";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD wernis_api_url varchar(255) not null default 'http://www.wds66.com/api/'";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD wernis_refid varchar(6) not null default ''";
- $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD wernis_userid varchar(6) not null default ''";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD wernis_min_payout BIGINT(20) NOT NULL DEFAULT '40000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD wernis_min_withdraw BIGINT(20) NOT NULL DEFAULT '5000'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD wernis_api_id BIGINT(20) NOT NULL DEFAULT '0'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD wernis_api_md5 VARCHAR(32) NOT NULL DEFAULT ''";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD wernis_api_url VARCHAR(255) NOT NULL DEFAULT 'http://www.wds66.com/api/'";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD wernis_refid VARCHAR(6) NOT NULL DEFAULT ''";
+ $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_user_data ADD wernis_userid VARCHAR(6) NOT NULL DEFAULT ''";
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES('wernis', NULL, '{!POINTS!}-Management', 'Konfiguration zur WDS66-API einstellen, Auszahlungen auflisten usw..', 15)";
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES('wernis', 'config_wernis', 'WDS66-API-Einstellungen', 'Konfiguration zur WDS66-API einstellen.', 1)";
$SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (action, what, title, descr, sort) VALUES('wernis', 'list_wernis', '{!POINTS!}-Anfragen auflisten', 'Listet alle {!POINTS!}-Auszahlungsanfragen Ihrer Mitglieder auf.', 2)";
define('ADMIN_CONFIG_SURFBAR_PAYMENT_MODEL_STATIC', "Statische Werte verwenden.");
define('ADMIN_CONFIG_SURFBAR_PAYMENT_MODEL_DYNAMIC', "Dynamische Werte errechnen.");
define('ADMIN_CONFIG_SURFBAR_NOTIFY_ADMIN_UNLOCK', "Admin bei Freigabe von Mailbuchungen informieren, dass die URL in die Surfbar aufgenommen wurde?");
+define('ADMIN_CONFIG_SURFBAR_DYNAMIC_PERCENT', "Prozent auf dynamische Vergütung:");
define('ADMIN_SURFBAR_NOTIFY_UNLOCK_YES', "Ja, Admin(s) informieren.");
define('ADMIN_SURFBAR_NOTIFY_UNLOCK_NO', "Nein, nicht informieren.");
define('ADMIN_SURFBAR_NO_REF_LEVELS_FOUND', "Zur Zeit sind keine Referal-Ebenen für die Surfbar eingestellt.<br />\nBitte installieren Sie die Erweiterung <strong>surfbar</strong> neu.");
// Was the form submitted?
if (isset($_POST['ok'])) {
// Replace german decimal comma with computer decimal dot
- if (isset($_POST['surfbar_static_reward'])) $_POST['surfbar_static_reward'] = str_replace(",", ".", $_POST['surfbar_static_reward']);
+ if (isset($_POST['surfbar_static_reward'])) $_POST['surfbar_static_reward'] = str_replace(",", ".", $_POST['surfbar_static_reward']);
+ if (isset($_POST['surfbar_dynamic_percent'])) $_POST['surfbar_dynamic_percent'] = str_replace(",", ".", $_POST['surfbar_dynamic_percent']);
// Save settings
ADMIN_SAVE_SETTINGS($_POST);
} else {
// Prepare content
$content = array(
- 'surfbar_static_reward' => TRANSLATE_COMMA($_CONFIG['surfbar_static_reward']),
- 'surfbar_static_time' => $_CONFIG['surfbar_static_time'],
- 'surfbar_static_lock' => $_CONFIG['surfbar_static_lock']
+ 'surfbar_static_reward' => TRANSLATE_COMMA($_CONFIG['surfbar_static_reward']),
+ 'surfbar_static_time' => $_CONFIG['surfbar_static_time'],
+ 'surfbar_static_lock' => $_CONFIG['surfbar_static_lock'],
+ 'surfbar_dynamic_percent' => TRANSLATE_COMMA($_CONFIG['surfbar_dynamic_percent'])
);
// Prepare payment model for template
<TD class=\"member_menu\">");
// Adding the main content module here
-if (empty($GLOBALS['action']))
-{
+if (empty($GLOBALS['action'])) {
if (empty($GLOBALS['what'])) $GLOBALS['what'] = "welcome";
-}
- else
-{
+} else {
$act = SQL_ESCAPE($GLOBALS['action']);
}
// Add the member's menu here...
-if (($_CONFIG['member_menu'] == "Y") || (!EXT_IS_ACTIVE("sql_patches", true)))
-{
+if (($_CONFIG['member_menu'] == "Y") || (!EXT_IS_ACTIVE("sql_patches", true))) {
ADD_MENU("member", GET_ACTION("member", $GLOBALS['what']), $GLOBALS['what']);
}
<TD valign=\"top\" align=\"center\" rowspan=\"3\" class=\"member_content\">");
$INC_ACTION = sprintf("%sinc/modules/member/action-%s.php", PATH, $act);
-if ((file_exists($INC_ACTION)) && (is_readable($INC_ACTION)) && (VALIDATE_MENU_ACTION("member", GET_ACTION("member", $GLOBALS['what']), $GLOBALS['what'])))
-{
+if ((file_exists($INC_ACTION)) && (is_readable($INC_ACTION)) && (VALIDATE_MENU_ACTION("member", GET_ACTION("member", $GLOBALS['what']), $GLOBALS['what']))) {
// Requested module is available so we load it
include ($INC_ACTION);
-}
- else
-{
+} else {
// Invalid module specified or not found...
LOAD_URL("modules.php?module=login");
}
************************************************************************/
// Some security stuff...
-if (ereg(basename(__FILE__), $_SERVER['PHP_SELF']))
-{
+if (ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) {
$INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
require($INC);
-}
- elseif (!IS_LOGGED_IN())
-{
+} elseif (!IS_LOGGED_IN()) {
LOAD_URL(URL."/modules.php?module=index");
-}
- elseif ($BLOCK_MODE)
-{
+} elseif ($BLOCK_MODE) {
// Block mode detected
return;
}
ADD_DESCR("member", basename(__FILE__));
// Load the include file
-$INC_WHAT = sprintf(PATH."inc/modules/member/what-%s.php", $GLOBALS['what']);
-if (file_exists($INC_WHAT))
-{
+$INC_WHAT = sprintf("%sinc/modules/member/what-%s.php", PATH, $GLOBALS['what']);
+if (file_exists($INC_WHAT)) {
// Ok, we finally load the member action module
include_once($INC_WHAT);
-}
- else
-{
+} else {
ADD_FATAL(MEMBER_404_ACTION_1.$GLOBALS['what'].MEMBER_404_ACTION_2);
}
+
//
?>
--- /dev/null
+<?php
+/************************************************************************
+ * MXChange v0.2.1 Start: 09/05/2008 *
+ * ================ Last change: 09/05/2008 *
+ * *
+ * -------------------------------------------------------------------- *
+ * File : action-surfbar.php *
+ * -------------------------------------------------------------------- *
+ * Short description : Surfbar main menu *
+ * -------------------------------------------------------------------- *
+ * Kurzbeschreibung : Surfbar-Hauptmenue *
+ * -------------------------------------------------------------------- *
+ * *
+ * -------------------------------------------------------------------- *
+ * Copyright (c) 2003, 2004, 2005, 2006, 2007 by Roland Haeder *
+ * For more information visit: http://www.mxchange.org *
+ * *
+ * This program is free software; you can redistribute it and/or modify *
+ * it under the terms of the GNU General Public License as published by *
+ * the Free Software Foundation; either version 2 of the License, or *
+ * (at your option) any later version. *
+ * *
+ * This program is distributed in the hope that it will be useful, *
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of *
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
+ * GNU General Public License for more details. *
+ * *
+ * You should have received a copy of the GNU General Public License *
+ * along with this program; if not, write to the Free Software *
+ * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, *
+ * MA 02110-1301 USA *
+ ************************************************************************/
+
+// Some security stuff...
+if (ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) {
+ $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
+ require($INC);
+} elseif (!IS_LOGGED_IN()) {
+ LOAD_URL(URL."/modules.php?module=index");
+} elseif ($BLOCK_MODE) {
+ // Block mode detected
+ return;
+}
+
+// Add description as navigation point
+ADD_DESCR("member", basename(__FILE__));
+
+// Load the include file
+$INC_WHAT = sprintf("%sinc/modules/member/what-%s.php", PATH, $GLOBALS['what']);
+if (file_exists($INC_WHAT)) {
+ // Ok, we finally load the member action module
+ include_once($INC_WHAT);
+} else {
+ ADD_FATAL(MEMBER_404_ACTION_1.$GLOBALS['what'].MEMBER_404_ACTION_2);
+}
+
+//
+?>
************************************************************************/
// Some security stuff...
-if (ereg(basename(__FILE__), $_SERVER['PHP_SELF']))
-{
+if (ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) {
$INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
require($INC);
-}
- elseif (!IS_LOGGED_IN())
-{
+} elseif (!IS_LOGGED_IN()) {
LOAD_URL(URL."/modules.php?module=index");
}
--- /dev/null
+<?php
+/************************************************************************
+ * MXChange v0.2.1 Start: 09/05/2008 *
+ * ================ Last change: 09/05/2008 *
+ * *
+ * -------------------------------------------------------------------- *
+ * File : what-surfbar_start.php *
+ * -------------------------------------------------------------------- *
+ * Short description : Gives some infos to the surfbar and launch link *
+ * -------------------------------------------------------------------- *
+ * Kurzbeschreibung : Gibt ein paar Infos zur Surfbar und Startlink *
+ * -------------------------------------------------------------------- *
+ * *
+ * -------------------------------------------------------------------- *
+ * Copyright (c) 2003, 2004, 2005, 2006, 2007 by Roland Haeder *
+ * For more information visit: http://www.mxchange.org *
+ * *
+ * This program is free software; you can redistribute it and/or modify *
+ * it under the terms of the GNU General Public License as published by *
+ * the Free Software Foundation; either version 2 of the License, or *
+ * (at your option) any later version. *
+ * *
+ * This program is distributed in the hope that it will be useful, *
+ * but WITHOUT ANY WARRANTY; without even the implied warranty of *
+ * MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the *
+ * GNU General Public License for more details. *
+ * *
+ * You should have received a copy of the GNU General Public License *
+ * along with this program; if not, write to the Free Software *
+ * Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, *
+ * MA 02110-1301 USA *
+ ************************************************************************/
+
+// Some security stuff...
+if (ereg(basename(__FILE__), $_SERVER['PHP_SELF'])) {
+ $INC = substr(dirname(__FILE__), 0, strpos(dirname(__FILE__), "/inc") + 4) . "/security.php";
+ require($INC);
+} elseif (!IS_LOGGED_IN()) {
+ LOAD_URL(URL."/modules.php?module=index");
+}
+
+// Add description as navigation point
+ADD_DESCR("member", basename(__FILE__));
+
+// Prepare content for output
+$content = array(
+ 'surfbar_static_reward' => TRANSLATE_COMMA($_CONFIG['surfbar_static_reward']),
+ 'surfbar_static_time' => CREATE_FANCY_TIME($_CONFIG['surfbar_static_time']),
+ 'surfbar_static_lock' => CREATE_FANCY_TIME($_CONFIG['surfbar_static_lock']),
+ 'surfbar_dynamic_percent' => TRANSLATE_COMMA($_CONFIG['surfbar_dynamic_percent'])
+);
+
+// Construct template name
+$templateName = substr(basename(__FILE__), 5, -4)."_".strtolower($_CONFIG['surfbar_pay_model']);
+
+// Load the template
+LOAD_TEMPLATE($templateName, false, $content);
+
+//
+?>
//
// First of all create the temporary table
$result = SQL_QUERY("CREATE TEMPORARY TABLE "._MYSQL_PREFIX."_transfers_tmp (
-trans_id varchar(12) not null default '',
-party_uid bigint(20) not null default '0',
-points bigint(20) not null default '0',
-reason varchar(255) not null default '',
-time_trans varchar(10) not null default '0',
-trans_type enum('IN', 'OUT') not null default 'IN',
+trans_id VARCHAR(12) NOT NULL DEFAULT '',
+party_uid BIGINT(20) NOT NULL DEFAULT '0',
+points BIGINT(20) NOT NULL DEFAULT '0',
+reason VARCHAR(255) NOT NULL DEFAULT '',
+time_trans VARCHAR(10) NOT NULL DEFAULT '0',
+trans_type ENUM('IN', 'OUT') NOT NULL DEFAULT 'IN',
KEY(party_uid)
) TYPE=HEAP", __FILE__, __LINE__);
DROP TABLE IF EXISTS `mxchange_admin_menu`;\r
CREATE TABLE `mxchange_admin_menu` (\r
- `id` bigint(22) NOT NULL auto_increment,\r
- `action` varchar(255) NOT NULL default '',\r
- `what` varchar(255) NOT NULL default '',\r
- `title` varchar(50) NOT NULL default '',\r
- `sort` bigint(20) NOT NULL default '0',\r
+ `id` BIGINT(22) NOT NULL AUTO_INCREMENT,\r
+ `action` VARCHAR(255) NOT NULL DEFAULT '',\r
+ `what` VARCHAR(255) NOT NULL DEFAULT '',\r
+ `title` VARCHAR(50) NOT NULL DEFAULT '',\r
+ `sort` BIGINT(20) NOT NULL DEFAULT '0',\r
`descr` blob NOT NULL,\r
PRIMARY KEY (`id`)\r
) TYPE=MyISAM;\r
\r
DROP TABLE IF EXISTS `mxchange_admins`;\r
CREATE TABLE `mxchange_admins` (\r
- `id` bigint(20) NOT NULL auto_increment,\r
- `login` varchar(100) NOT NULL default '',\r
- `password` varchar(40) NOT NULL default '',\r
+ `id` BIGINT(20) NOT NULL AUTO_INCREMENT,\r
+ `login` VARCHAR(100) NOT NULL DEFAULT '',\r
+ `password` VARCHAR(40) NOT NULL DEFAULT '',\r
PRIMARY KEY (`id`)\r
) TYPE=MyISAM;\r
\r
DROP TABLE IF EXISTS `mxchange_cats`;\r
CREATE TABLE `mxchange_cats` (\r
- `id` bigint(22) NOT NULL auto_increment,\r
- `cat` varchar(255) NOT NULL default '',\r
- `visible` enum('Y','N') NOT NULL default 'Y',\r
- `sort` bigint(20) NOT NULL default '0',\r
+ `id` BIGINT(22) NOT NULL AUTO_INCREMENT,\r
+ `cat` VARCHAR(255) NOT NULL DEFAULT '',\r
+ `visible` ENUM('Y','N') NOT NULL DEFAULT 'Y',\r
+ `sort` BIGINT(20) NOT NULL DEFAULT '0',\r
PRIMARY KEY (`id`)\r
) TYPE=MyISAM;\r
\r
DROP TABLE IF EXISTS `mxchange_config`;\r
CREATE TABLE `mxchange_config` (\r
- `config` tinyint(1) NOT NULL default '0',\r
- `pass_len` tinyint(4) NOT NULL default '5',\r
- `points_register` bigint(20) NOT NULL default '0',\r
- `points_ref` bigint(20) NOT NULL default '0',\r
- `least_cats` tinyint(4) NOT NULL default '5',\r
- `check_double_email` enum('Y','N') NOT NULL default 'Y',\r
- `check_double_pass` enum('Y','N') NOT NULL default 'N',\r
- `admin_notify` enum('Y','N') NOT NULL default 'Y',\r
- `url_tlock` bigint(20) NOT NULL default '86400',\r
- `test_text` enum('Y','N') NOT NULL default 'Y',\r
- `max_tlength` bigint(20) NOT NULL default '1000',\r
- `test_subj` enum('Y','N') NOT NULL default 'Y',\r
- `autosend_active` enum('Y','N') NOT NULL default 'N',\r
+ `config` tinyint(1) NOT NULL DEFAULT '0',\r
+ `pass_len` TINYINT(3) NOT NULL DEFAULT '5',\r
+ `points_register` BIGINT(20) NOT NULL DEFAULT '0',\r
+ `points_ref` BIGINT(20) NOT NULL DEFAULT '0',\r
+ `least_cats` TINYINT(3) NOT NULL DEFAULT '5',\r
+ `check_double_email` ENUM('Y','N') NOT NULL DEFAULT 'Y',\r
+ `check_double_pass` ENUM('Y','N') NOT NULL DEFAULT 'N',\r
+ `admin_notify` ENUM('Y','N') NOT NULL DEFAULT 'Y',\r
+ `url_tlock` BIGINT(20) NOT NULL DEFAULT '86400',\r
+ `test_text` ENUM('Y','N') NOT NULL DEFAULT 'Y',\r
+ `max_tlength` BIGINT(20) NOT NULL DEFAULT '1000',\r
+ `test_subj` ENUM('Y','N') NOT NULL DEFAULT 'Y',\r
+ `autosend_active` ENUM('Y','N') NOT NULL DEFAULT 'N',\r
PRIMARY KEY (`config`)\r
) TYPE=MyISAM;\r
\r
\r
DROP TABLE IF EXISTS `mxchange_guest_menu`;\r
CREATE TABLE `mxchange_guest_menu` (\r
- `id` bigint(22) NOT NULL auto_increment,\r
- `action` varchar(20) NOT NULL default '',\r
- `what` varchar(20) NOT NULL default '',\r
- `title` varchar(50) NOT NULL default '',\r
- `sort` bigint(20) NOT NULL default '0',\r
- `visible` enum('Y','N') NOT NULL default 'Y',\r
- `locked` enum('Y','N') NOT NULL default 'Y',\r
- `counter` bigint(20) NOT NULL default '0',\r
+ `id` BIGINT(22) NOT NULL AUTO_INCREMENT,\r
+ `action` VARCHAR(20) NOT NULL DEFAULT '',\r
+ `what` VARCHAR(20) NOT NULL DEFAULT '',\r
+ `title` VARCHAR(50) NOT NULL DEFAULT '',\r
+ `sort` BIGINT(20) NOT NULL DEFAULT '0',\r
+ `visible` ENUM('Y','N') NOT NULL DEFAULT 'Y',\r
+ `locked` ENUM('Y','N') NOT NULL DEFAULT 'Y',\r
+ `counter` BIGINT(20) NOT NULL DEFAULT '0',\r
PRIMARY KEY (`id`)\r
) TYPE=MyISAM;\r
\r
DROP TABLE IF EXISTS `mxchange_max_receive`;\r
CREATE TABLE `mxchange_max_receive` (\r
- `id` bigint(22) NOT NULL auto_increment,\r
- `value` mediumint(9) NOT NULL default '0',\r
- `comment` varchar(255) NOT NULL default '',\r
+ `id` BIGINT(22) NOT NULL AUTO_INCREMENT,\r
+ `value` MEDIUMINT(9) NOT NULL DEFAULT '0',\r
+ `comment` VARCHAR(255) NOT NULL DEFAULT '',\r
PRIMARY KEY (`id`)\r
) TYPE=MyISAM;\r
\r
DROP TABLE IF EXISTS `mxchange_member_menu`;\r
CREATE TABLE `mxchange_member_menu` (\r
- `id` bigint(22) NOT NULL auto_increment,\r
- `action` varchar(20) NOT NULL default '',\r
- `what` varchar(20) NOT NULL default '',\r
- `title` varchar(50) NOT NULL default '',\r
- `sort` bigint(20) NOT NULL default '0',\r
- `visible` enum('Y','N') NOT NULL default 'Y',\r
- `locked` enum('Y','N') NOT NULL default 'Y',\r
+ `id` BIGINT(22) NOT NULL AUTO_INCREMENT,\r
+ `action` VARCHAR(20) NOT NULL DEFAULT '',\r
+ `what` VARCHAR(20) NOT NULL DEFAULT '',\r
+ `title` VARCHAR(50) NOT NULL DEFAULT '',\r
+ `sort` BIGINT(20) NOT NULL DEFAULT '0',\r
+ `visible` ENUM('Y','N') NOT NULL DEFAULT 'Y',\r
+ `locked` ENUM('Y','N') NOT NULL DEFAULT 'Y',\r
`descr` blob NOT NULL,\r
- `counter` bigint(20) NOT NULL default '0',\r
+ `counter` BIGINT(20) NOT NULL DEFAULT '0',\r
PRIMARY KEY (`id`)\r
) TYPE=MyISAM;\r
\r
DROP TABLE IF EXISTS `mxchange_mod_reg`;\r
CREATE TABLE `mxchange_mod_reg` (\r
- `id` bigint(20) NOT NULL auto_increment,\r
- `module` varchar(50) NOT NULL default '',\r
- `locked` enum('Y','N') NOT NULL default 'Y',\r
- `hidden` enum('Y','N') NOT NULL default 'N',\r
- `admin_only` enum('Y','N') NOT NULL default 'N',\r
- `title` varchar(200) NOT NULL default '',\r
- `mem_only` enum('Y','N') NOT NULL default 'N',\r
- `clicks` bigint(20) NOT NULL default '0',\r
+ `id` BIGINT(20) NOT NULL AUTO_INCREMENT,\r
+ `module` VARCHAR(50) NOT NULL DEFAULT '',\r
+ `locked` ENUM('Y','N') NOT NULL DEFAULT 'Y',\r
+ `hidden` ENUM('Y','N') NOT NULL DEFAULT 'N',\r
+ `admin_only` ENUM('Y','N') NOT NULL DEFAULT 'N',\r
+ `title` VARCHAR(200) NOT NULL DEFAULT '',\r
+ `mem_only` ENUM('Y','N') NOT NULL DEFAULT 'N',\r
+ `clicks` BIGINT(20) NOT NULL DEFAULT '0',\r
PRIMARY KEY (`id`)\r
) TYPE=MyISAM;\r
\r
\r
DROP TABLE IF EXISTS `mxchange_payments`;\r
CREATE TABLE `mxchange_payments` (\r
- `id` bigint(20) NOT NULL auto_increment,\r
- `time` int(11) NOT NULL default '0',\r
- `payment` float(5,3) NOT NULL default '0.000',\r
- `mail_title` varchar(255) NOT NULL default '',\r
- `price` float(5,3) NOT NULL default '0.000',\r
+ `id` BIGINT(20) NOT NULL AUTO_INCREMENT,\r
+ `time` INT(7) NOT NULL DEFAULT '0',\r
+ `payment` FLOAT(5,3) NOT NULL DEFAULT '0.000',\r
+ `mail_title` VARCHAR(255) NOT NULL DEFAULT '',\r
+ `price` FLOAT(5,3) NOT NULL DEFAULT '0.000',\r
PRIMARY KEY (`id`)\r
) TYPE=MyISAM;\r
\r
DROP TABLE IF EXISTS `mxchange_pool`;\r
CREATE TABLE `mxchange_pool` (\r
- `id` bigint(20) NOT NULL auto_increment,\r
- `sender` bigint(20) NOT NULL default '0',\r
- `subject` varchar(200) NOT NULL default '',\r
- `text` longblob NOT NULL,\r
- `receivers` longblob NOT NULL,\r
- `payment_id` tinyint(4) NOT NULL default '0',\r
- `data_type` enum('TEMP','SEND','NEW','ADMIN') NOT NULL default 'TEMP',\r
- `timestamp` varchar(10) NOT NULL default '0',\r
+ `id` BIGINT(20) NOT NULL AUTO_INCREMENT,\r
+ `sender` BIGINT(20) NOT NULL DEFAULT '0',\r
+ `subject` VARCHAR(200) NOT NULL DEFAULT '',\r
+ `text` LONGBLOB NOT NULL,\r
+ `receivers` LONGBLOB NOT NULL,\r
+ `payment_id` TINYINT(3) NOT NULL DEFAULT '0',\r
+ `data_type` ENUM('TEMP','SEND','NEW','ADMIN') NOT NULL DEFAULT 'TEMP',\r
+ `timestamp` VARCHAR(10) NOT NULL DEFAULT '0',\r
`url` tinytext NOT NULL,\r
- `target_send` bigint(20) NOT NULL default '0',\r
- `cat_id` bigint(20) NOT NULL default '0',\r
+ `target_send` BIGINT(20) NOT NULL DEFAULT '0',\r
+ `cat_id` BIGINT(20) NOT NULL DEFAULT '0',\r
PRIMARY KEY (`id`)\r
) TYPE=MyISAM;\r
\r
DROP TABLE IF EXISTS `mxchange_refbanner`;\r
CREATE TABLE `mxchange_refbanner` (\r
- `id` bigint(22) NOT NULL auto_increment,\r
- `url` text NOT NULL,\r
- `alternate` text NOT NULL,\r
- `visible` enum('Y','N') NOT NULL default 'Y',\r
- `counter` bigint(22) NOT NULL default '0',\r
+ `id` BIGINT(22) NOT NULL AUTO_INCREMENT,\r
+ `url` TEXT NOT NULL,\r
+ `alternate` TEXT NOT NULL,\r
+ `visible` ENUM('Y','N') NOT NULL DEFAULT 'Y',\r
+ `counter` BIGINT(22) NOT NULL DEFAULT '0',\r
PRIMARY KEY (`id`)\r
) TYPE=MyISAM;\r
\r
DROP TABLE IF EXISTS `mxchange_refdepths`;\r
CREATE TABLE `mxchange_refdepths` (\r
- `id` tinyint(4) NOT NULL auto_increment,\r
- `level` tinyint(4) NOT NULL default '0',\r
- `percents` tinyint(4) NOT NULL default '0',\r
+ `id` TINYINT(3) NOT NULL AUTO_INCREMENT,\r
+ `level` TINYINT(3) NOT NULL DEFAULT '0',\r
+ `percents` TINYINT(3) NOT NULL DEFAULT '0',\r
PRIMARY KEY (`id`)\r
) TYPE=MyISAM;\r
\r
\r
DROP TABLE IF EXISTS `mxchange_refsystem`;\r
CREATE TABLE `mxchange_refsystem` (\r
- `id` bigint(22) NOT NULL auto_increment,\r
- `userid` bigint(20) NOT NULL default '0',\r
- `level` tinyint(4) NOT NULL default '0',\r
- `counter` bigint(20) NOT NULL default '0',\r
+ `id` BIGINT(22) NOT NULL AUTO_INCREMENT,\r
+ `userid` BIGINT(20) NOT NULL DEFAULT '0',\r
+ `level` TINYINT(3) NOT NULL DEFAULT '0',\r
+ `counter` BIGINT(20) NOT NULL DEFAULT '0',\r
PRIMARY KEY (`id`)\r
) TYPE=MyISAM;\r
\r
DROP TABLE IF EXISTS `mxchange_user_cats`;\r
CREATE TABLE `mxchange_user_cats` (\r
- `id` bigint(22) NOT NULL auto_increment,\r
- `userid` bigint(20) NOT NULL default '0',\r
- `cat_id` tinyint(4) NOT NULL default '0',\r
+ `id` BIGINT(22) NOT NULL AUTO_INCREMENT,\r
+ `userid` BIGINT(20) NOT NULL DEFAULT '0',\r
+ `cat_id` TINYINT(3) NOT NULL DEFAULT '0',\r
PRIMARY KEY (`id`)\r
) TYPE=MyISAM;\r
\r
DROP TABLE IF EXISTS `mxchange_user_data`;\r
CREATE TABLE `mxchange_user_data` (\r
- `userid` bigint(22) NOT NULL auto_increment,\r
- `surname` varchar(255) NOT NULL default '',\r
- `family` varchar(255) NOT NULL default '',\r
- `street_nr` varchar(255) NOT NULL default '',\r
- `country` varchar(4) NOT NULL default '',\r
- `zip` varchar(6) NOT NULL default '',\r
- `city` varchar(255) NOT NULL default '',\r
- `email` varchar(255) NOT NULL default '',\r
- `birth_day` char(2) NOT NULL default '01',\r
- `birth_month` char(2) NOT NULL default '01',\r
- `birth_year` varchar(4) NOT NULL default '1970',\r
- `password` varchar(32) NOT NULL default '',\r
- `max_mails` int(11) NOT NULL default '0',\r
- `receive_mails` int(11) NOT NULL default '0',\r
- `refid` bigint(22) NOT NULL default '0',\r
- `status` enum('UNCONFIRMED','CONFIRMED','LOCKED') NOT NULL default 'UNCONFIRMED',\r
- `user_hash` varchar(32) NOT NULL default '',\r
- `REMOTE_ADDR` varchar(15) NOT NULL default '0.0.0.0',\r
- `last_online` varchar(10) NOT NULL default '0',\r
- `last_module` varchar(20) NOT NULL default '',\r
- `ref_clicks` bigint(20) NOT NULL default '0',\r
- `total_logins` bigint(20) NOT NULL default '0',\r
- `sex` enum('M','F') NOT NULL default 'M',\r
- `used_points` double(22,3) NOT NULL default '0.000',\r
- `emails_sent` bigint(20) NOT NULL default '0',\r
+ `userid` BIGINT(22) NOT NULL AUTO_INCREMENT,\r
+ `surname` VARCHAR(255) NOT NULL DEFAULT '',\r
+ `family` VARCHAR(255) NOT NULL DEFAULT '',\r
+ `street_nr` VARCHAR(255) NOT NULL DEFAULT '',\r
+ `country` VARCHAR(4) NOT NULL DEFAULT '',\r
+ `zip` VARCHAR(6) NOT NULL DEFAULT '',\r
+ `city` VARCHAR(255) NOT NULL DEFAULT '',\r
+ `email` VARCHAR(255) NOT NULL DEFAULT '',\r
+ `birth_day` CHAR(2) NOT NULL DEFAULT '01',\r
+ `birth_month` CHAR(2) NOT NULL DEFAULT '01',\r
+ `birth_year` VARCHAR(4) NOT NULL DEFAULT '1970',\r
+ `password` VARCHAR(32) NOT NULL DEFAULT '',\r
+ `max_mails` INT(7) NOT NULL DEFAULT '0',\r
+ `receive_mails` INT(7) NOT NULL DEFAULT '0',\r
+ `refid` BIGINT(22) NOT NULL DEFAULT '0',\r
+ `status` ENUM('UNCONFIRMED','CONFIRMED','LOCKED') NOT NULL DEFAULT 'UNCONFIRMED',\r
+ `user_hash` VARCHAR(32) NOT NULL DEFAULT '',\r
+ `REMOTE_ADDR` VARCHAR(15) NOT NULL DEFAULT '0.0.0.0',\r
+ `last_online` VARCHAR(10) NOT NULL DEFAULT '0',\r
+ `last_module` VARCHAR(20) NOT NULL DEFAULT '',\r
+ `ref_clicks` BIGINT(20) NOT NULL DEFAULT '0',\r
+ `total_logins` BIGINT(20) NOT NULL DEFAULT '0',\r
+ `sex` ENUM('M','F') NOT NULL DEFAULT 'M',\r
+ `used_points` DOUBLE(22,3) NOT NULL DEFAULT '0.000',\r
+ `emails_sent` BIGINT(20) NOT NULL DEFAULT '0',\r
PRIMARY KEY (`userid`)\r
) TYPE=MyISAM;\r
\r
DROP TABLE IF EXISTS `mxchange_user_points`;\r
CREATE TABLE `mxchange_user_points` (\r
- `id` bigint(22) NOT NULL auto_increment,\r
- `userid` bigint(22) NOT NULL default '0',\r
- `ref_depth` tinyint(4) NOT NULL default '0',\r
- `points` double(22,3) NOT NULL default '0.000',\r
+ `id` BIGINT(22) NOT NULL AUTO_INCREMENT,\r
+ `userid` BIGINT(22) NOT NULL DEFAULT '0',\r
+ `ref_depth` TINYINT(3) NOT NULL DEFAULT '0',\r
+ `points` DOUBLE(22,3) NOT NULL DEFAULT '0.000',\r
PRIMARY KEY (`id`)\r
) TYPE=MyISAM;\r
\r
-alter table `mxchange_config` add `max_send` tinyint not null default '100';\r
-alter table `mxchange_config` add `url_blacklist` enum('Y','N') not null default 'Y';\r
-alter table `mxchange_config` add `auto_purge` tinyint not null default '14';\r
-alter table `mxchange_config` add `auto_purge_active` enum('Y','N') not null default 'Y';\r
+alter table `mxchange_config` add `max_send` TINYINT(3) NOT NULL DEFAULT '100';\r
+alter table `mxchange_config` add `url_blacklist` ENUM('Y','N') NOT NULL DEFAULT 'Y';\r
+alter table `mxchange_config` add `auto_purge` TINYINT(3) NOT NULL DEFAULT '14';\r
+alter table `mxchange_config` add `auto_purge_active` ENUM('Y','N') NOT NULL DEFAULT 'Y';\r
\r
-alter table `mxchange_pool` modify `url` tinytext not null;\r
-alter table `mxchange_pool` change `url` `url` tinyblob not null;\r
-alter table `mxchange_pool` modify `data_type` enum('TEMP','SEND','NEW','ADMIN','ACTIVE') not null default 'TEMP';\r
+alter table `mxchange_pool` modify `url` tinytext NOT NULL;\r
+alter table `mxchange_pool` change `url` `url` tinyblob NOT NULL;\r
+alter table `mxchange_pool` modify `data_type` ENUM('TEMP','SEND','NEW','ADMIN','ACTIVE') NOT NULL DEFAULT 'TEMP';\r
\r
DROP TABLE IF EXISTS `mxchange_user_links`;\r
CREATE TABLE `mxchange_user_links` (\r
- `id` bigint(20) NOT NULL auto_increment,\r
- `stats_id` bigint(20) NOT NULL default '0',\r
- `userid` bigint(20) NOT NULL default '0',\r
- `link_type` enum('NORMAL') NOT NULL default 'NORMAL',\r
+ `id` BIGINT(20) NOT NULL AUTO_INCREMENT,\r
+ `stats_id` BIGINT(20) NOT NULL DEFAULT '0',\r
+ `userid` BIGINT(20) NOT NULL DEFAULT '0',\r
+ `link_type` ENUM('NORMAL') NOT NULL DEFAULT 'NORMAL',\r
PRIMARY KEY (`id`)\r
) TYPE=MyISAM;\r
\r
DROP TABLE IF EXISTS `mxchange_user_stats`;\r
CREATE TABLE `mxchange_user_stats` (\r
- `id` bigint(20) NOT NULL auto_increment,\r
- `userid` bigint(20) NOT NULL default '0',\r
- `cat_id` bigint(20) NOT NULL default '0',\r
- `payment_id` bigint(20) NOT NULL default '0',\r
- `subject` varchar(200) NOT NULL default '',\r
+ `id` BIGINT(20) NOT NULL AUTO_INCREMENT,\r
+ `userid` BIGINT(20) NOT NULL DEFAULT '0',\r
+ `cat_id` BIGINT(20) NOT NULL DEFAULT '0',\r
+ `payment_id` BIGINT(20) NOT NULL DEFAULT '0',\r
+ `subject` VARCHAR(200) NOT NULL DEFAULT '',\r
`url` tinyblob NOT NULL,\r
- `max_rec` bigint(20) NOT NULL default '0',\r
- `timestamp_ordered` varchar(10) NOT NULL default '',\r
- `pool_id` bigint(20) NOT NULL default '0',\r
- `timestamp_sstart` varchar(10) NOT NULL default '',\r
- `timestamp_send` varchar(10) NOT NULL default '',\r
+ `max_rec` BIGINT(20) NOT NULL DEFAULT '0',\r
+ `timestamp_ordered` VARCHAR(10) NOT NULL DEFAULT '',\r
+ `pool_id` BIGINT(20) NOT NULL DEFAULT '0',\r
+ `timestamp_sstart` VARCHAR(10) NOT NULL DEFAULT '',\r
+ `timestamp_send` VARCHAR(10) NOT NULL DEFAULT '',\r
PRIMARY KEY (`id`)\r
) TYPE=MyISAM;\r
\r
-alter table `mxchange_user_data` add `joined` varchar(10) not null default '0';\r
-alter table `mxchange_config` add `last_update` varchar(10) not null default '0';\r
+alter table `mxchange_user_data` add `joined` VARCHAR(10) NOT NULL DEFAULT '0';\r
+alter table `mxchange_config` add `last_update` VARCHAR(10) NOT NULL DEFAULT '0';\r
\r
UPDATE `mxchange_member_menu` SET `locked` = 'N' WHERE 'id'='12' OR 'id'='11' LIMIT 1;\r
\r
UPDATE `mxchange_member_menu` SET `counter`=0;\r
\r
INSERT INTO `mxchange_mod_reg` VALUES (NULL,'chk_login','N','N','N','','N',0);\r
-alter table `mxchange_pool` modify `data_type` enum('TEMP','SEND','NEW','ADMIN','ACTIVE') not null default 'TEMP';\r
-alter table `mxchange_config` add `unconfirmed` bigint not null default '100';\r
-alter table `mxchange_config` add `profile_lock` bigint not null default '86400';\r
-alter table `mxchange_user_data` add `last_update` varchar(10) not null default '0';\r
-alter table `mxchange_refbanner` add `clicks` bigint not null default '0';\r
-alter table `mxchange_config` add `online_timeout` bigint not null default '1800';\r
+alter table `mxchange_pool` modify `data_type` ENUM('TEMP','SEND','NEW','ADMIN','ACTIVE') NOT NULL DEFAULT 'TEMP';\r
+alter table `mxchange_config` add `unconfirmed` BIGINT(20) NOT NULL DEFAULT '100';\r
+alter table `mxchange_config` add `profile_lock` BIGINT(20) NOT NULL DEFAULT '86400';\r
+alter table `mxchange_user_data` add `last_update` VARCHAR(10) NOT NULL DEFAULT '0';\r
+alter table `mxchange_refbanner` add `clicks` BIGINT(20) NOT NULL DEFAULT '0';\r
+alter table `mxchange_config` add `online_timeout` BIGINT(20) NOT NULL DEFAULT '1800';\r
\r
-alter table `mxchange_config` add `mad_timestamp` varchar(10) not null default '0';\r
-alter table `mxchange_config` add `mad_count` bigint not null;\r
-alter table `mxchange_config` add `profile_update` bigint not null default '15768000';\r
-alter table `mxchange_config` add `send_prof_update` enum('Y','N') not null default 'Y';\r
-alter table `mxchange_config` add `resend_profile_update` bigint not null default '172800';\r
+alter table `mxchange_config` add `mad_timestamp` VARCHAR(10) NOT NULL DEFAULT '0';\r
+alter table `mxchange_config` add `mad_count` BIGINT(20) NOT NULL;\r
+alter table `mxchange_config` add `profile_update` BIGINT(20) NOT NULL DEFAULT '15768000';\r
+alter table `mxchange_config` add `send_prof_update` ENUM('Y','N') NOT NULL DEFAULT 'Y';\r
+alter table `mxchange_config` add `resend_profile_update` BIGINT(20) NOT NULL DEFAULT '172800';\r
\r
-alter table `mxchange_user_data` add `last_profile_sent` varchar(10) not null default '0';\r
-alter table `mxchange_user_data` add `notified` enum('Y','N') not null default 'N';\r
+alter table `mxchange_user_data` add `last_profile_sent` VARCHAR(10) NOT NULL DEFAULT '0';\r
+alter table `mxchange_user_data` add `notified` ENUM('Y','N') NOT NULL DEFAULT 'N';\r
\r
-alter table `mxchange_config` add `patch_level` varchar(100) not null default '78';\r
-alter table `mxchange_config` add `patch_ctime` varchar(10) not null default '0';\r
+alter table `mxchange_config` add `patch_level` VARCHAR(100) NOT NULL DEFAULT '78';\r
+alter table `mxchange_config` add `patch_ctime` VARCHAR(10) NOT NULL DEFAULT '0';\r
\r
-alter table `mxchange_admins` add `email` varchar(255) not null;\r
+alter table `mxchange_admins` add `email` VARCHAR(255) NOT NULL;\r
\r
DROP TABLE IF EXISTS `mxchange_task_system`;\r
CREATE TABLE `mxchange_task_system` (\r
- `id` bigint(20) NOT NULL auto_increment,\r
- `assigned_admin` bigint(20) NOT NULL default '0',\r
- `userid` bigint(20) NOT NULL default '0',\r
- `status` enum('NEW','OPEN','SOLVED','CLOSED','DELETED') NOT NULL default 'NEW',\r
- `task_type` enum('FIRST_USER','SUPPORT_MEMBER','SUPPORT_ADMIN','OTHERS', 'EXTENSION', 'EXTENSION_UPDATE') NOT NULL default 'FIRST_USER',\r
- `subject` varchar(255) NOT NULL default '',\r
- `text` longblob NOT NULL,\r
- `task_created` varchar(10) NOT NULL default '0',\r
+ `id` BIGINT(20) NOT NULL AUTO_INCREMENT,\r
+ `assigned_admin` BIGINT(20) NOT NULL DEFAULT '0',\r
+ `userid` BIGINT(20) NOT NULL DEFAULT '0',\r
+ `status` ENUM('NEW','OPEN','SOLVED','CLOSED','DELETED') NOT NULL DEFAULT 'NEW',\r
+ `task_type` ENUM('FIRST_USER','SUPPORT_MEMBER','SUPPORT_ADMIN','OTHERS', 'EXTENSION', 'EXTENSION_UPDATE') NOT NULL DEFAULT 'FIRST_USER',\r
+ `subject` VARCHAR(255) NOT NULL DEFAULT '',\r
+ `text` LONGBLOB NOT NULL,\r
+ `task_created` VARCHAR(10) NOT NULL DEFAULT '0',\r
KEY (`assigned_admin`),\r
PRIMARY KEY (`id`)\r
) TYPE=MyISAM;\r
ALTER TABLE `mxchange_user_stats` ADD INDEX (`payment_id`);\r
ALTER TABLE `mxchange_user_stats` ADD INDEX (`pool_id`);\r
\r
-alter table `mxchange_user_stats` add `clicks` bigint not null;\r
-alter table `mxchange_config` add `code_length` tinyint not null default '5';\r
-alter table `mxchange_config` add `guest_stats` enum('MEMBERS','MODULES','INACTIVE') not null default 'MEMBERS';\r
-alter table `mxchange_config` add `ref_payout` tinyint not null default '5';\r
-alter table `mxchange_user_data` add `ref_payout` tinyint not null default '0';\r
-alter table `mxchange_user_points` add `locked_points` bigint not null default '0';\r
+alter table `mxchange_user_stats` add `clicks` BIGINT(20) NOT NULL;\r
+alter table `mxchange_config` add `code_length` TINYINT(3) NOT NULL DEFAULT '5';\r
+alter table `mxchange_config` add `guest_stats` ENUM('MEMBERS','MODULES','INACTIVE') NOT NULL DEFAULT 'MEMBERS';\r
+alter table `mxchange_config` add `ref_payout` TINYINT(3) NOT NULL DEFAULT '5';\r
+alter table `mxchange_user_data` add `ref_payout` TINYINT(3) NOT NULL DEFAULT '0';\r
+alter table `mxchange_user_points` add `locked_points` BIGINT(20) NOT NULL DEFAULT '0';\r
\r
DROP TABLE IF EXISTS `mxchange_extensions`;\r
CREATE TABLE `mxchange_extensions` (\r
- `id` bigint(20) NOT NULL auto_increment,\r
- `ext_name` varchar(255) NOT NULL default '',\r
- `ext_lang_file` varchar(255) NOT NULL default '',\r
- `ext_active` enum('Y','N') NOT NULL default 'N',\r
- `ext_version` varchar(255) NOT NULL default '0.',\r
+ `id` BIGINT(20) NOT NULL AUTO_INCREMENT,\r
+ `ext_name` VARCHAR(255) NOT NULL DEFAULT '',\r
+ `ext_lang_file` VARCHAR(255) NOT NULL DEFAULT '',\r
+ `ext_active` ENUM('Y','N') NOT NULL DEFAULT 'N',\r
+ `ext_version` VARCHAR(255) NOT NULL DEFAULT '0.',\r
PRIMARY KEY (`id`)\r
) TYPE=MyISAM;\r
\r
DROP TABLE IF EXISTS `mxchange_jackpot`;\r
CREATE TABLE `mxchange_jackpot` (\r
- `ok` char(2) NOT NULL default 'ok',\r
- `points` double(23,3) NOT NULL default '0.000',\r
+ `ok` CHAR(2) NOT NULL DEFAULT 'ok',\r
+ `points` DOUBLE(23,3) NOT NULL DEFAULT '0.000',\r
PRIMARY KEY (`ok`)\r
) TYPE=MyISAM;\r
\r
-alter table `mxchange_config` add `activate_xchange` bigint(20) not null default '100';\r
-alter table `mxchange_config` add `order_multi_page` enum('Y','N') not null default 'Y';\r
-alter table `mxchange_config` add `display_refid` enum('Y','N') not null default 'Y';\r
-alter table `mxchange_config` add `ip_timeout` bigint(20) not null default '86400';\r
-alter table `mxchange_pool` add `zip` varchar(6) not null default '';\r
-\r
-alter table `mxchange_task_system` change `task_type` `task_type` varchar(255) not null default 'FIRST_USER';\r
-alter table `mxchange_user_data` modify `zip` varchar(6) not null default '';\r
-alter table `mxchange_admin_menu` modify `action` varchar(255) not null default '';\r
-alter table `mxchange_admin_menu` modify `what` varchar(255) not null default '';\r
-alter table `mxchange_user_data` modify `last_module` varchar(255) not null default '';\r
-alter table `mxchange_config` add `allow_direct_pay` enum('N', 'Y') not null default 'N';\r
-alter table `mxchange_user_data` modify `last_profile_sent` varchar(10) not null default '0';\r
-alter table `mxchange_user_data` modify `last_update` varchar(10) not null default '0';\r
-alter table `mxchange_user_data` modify `joined` varchar(10) not null default '0';\r
-alter table `mxchange_user_data` modify `last_online` varchar(10) not null default '0';\r
+alter table `mxchange_config` add `activate_xchange` BIGINT(20) NOT NULL DEFAULT '100';\r
+alter table `mxchange_config` add `order_multi_page` ENUM('Y','N') NOT NULL DEFAULT 'Y';\r
+alter table `mxchange_config` add `display_refid` ENUM('Y','N') NOT NULL DEFAULT 'Y';\r
+alter table `mxchange_config` add `ip_timeout` BIGINT(20) NOT NULL DEFAULT '86400';\r
+alter table `mxchange_pool` add `zip` VARCHAR(6) NOT NULL DEFAULT '';\r
+\r
+alter table `mxchange_task_system` change `task_type` `task_type` VARCHAR(255) NOT NULL DEFAULT 'FIRST_USER';\r
+alter table `mxchange_user_data` modify `zip` VARCHAR(6) NOT NULL DEFAULT '';\r
+alter table `mxchange_admin_menu` modify `action` VARCHAR(255) NOT NULL DEFAULT '';\r
+alter table `mxchange_admin_menu` modify `what` VARCHAR(255) NOT NULL DEFAULT '';\r
+alter table `mxchange_user_data` modify `last_module` VARCHAR(255) NOT NULL DEFAULT '';\r
+alter table `mxchange_config` add `allow_direct_pay` ENUM('N', 'Y') NOT NULL DEFAULT 'N';\r
+alter table `mxchange_user_data` modify `last_profile_sent` VARCHAR(10) NOT NULL DEFAULT '0';\r
+alter table `mxchange_user_data` modify `last_update` VARCHAR(10) NOT NULL DEFAULT '0';\r
+alter table `mxchange_user_data` modify `joined` VARCHAR(10) NOT NULL DEFAULT '0';\r
+alter table `mxchange_user_data` modify `last_online` VARCHAR(10) NOT NULL DEFAULT '0';\r
<INPUT type="text" name="surfbar_static_lock" size="10" maxlength="20" value="$content[surfbar_static_lock]" />
</TD>
</TR>
+ <TR><TD height="3" colspan="2" class="seperator"> </TD></TR>
+ <TR>
+ <TD height="30" align="right" style="padding-right:5px">
+ {--ADMIN_CONFIG_SURFBAR_DYNAMIC_PERCENT--}
+ </TD>
+ <TD>
+ <INPUT type="text" name="surfbar_dynamic_percent" size="10" maxlength="20" value="$content[surfbar_dynamic_percent]" />%
+ </TD>
+ </TR>
<TR><TD height="8" colspan="2" class="seperator bottom2"> </TD></TR>
<TR>
<TD align="center" colspan="2" class="admin_footer bottom2">
<br />
Die Fix-Vergütung in {!POINTS!} stellen Sie im Adminbereich ein. Soll
die Vergütung dynamisch erfolgen, stellen Sie dies einfach um. Sind mehr
-Mitglieder Online erhält das surbarnutzende Mitglied für jeden
+Mitglieder Online, erhält das surbarnutzende Mitglied für jeden
Seitenbesuch mehr {!POINTS!} gutgeschrieben. Hat das Mitglied selbst mehr URLs
gebucht, erhält es für den Besuch anderer gebuchter Webseiten
ebenfalls mehr {!POINTS!} gutgeschrieben. Dabei richtig sich der Basispreis
projects / mailer.git / commitdiff