Missing changed files added

diff --git a/inc/databases.php b/inc/databases.php
index 72828697bd4f97b683a38698ddadf43bb423dbee..4d6b7fc4e86b9792117ff4b408dc567ad3bb0cf3 100644 (file)
--- a/inc/databases.php
+++ b/inc/databases.php
@@ -114,7 +114,7 @@ define('USAGE_BASE', "usage");
 define('SERVER_URL', "http://www.mxchange.org");
 
 // Current SVN revision
 define('SERVER_URL', "http://www.mxchange.org");
 
 // Current SVN revision

-define('CURR_SVN_REVISION', "630");
+define('CURR_SVN_REVISION', "631");

 
 // Take a prime number which is long (if you know a longer one please try it out!)
 define('_PRIME', 591623);
 
 // Take a prime number which is long (if you know a longer one please try it out!)
 define('_PRIME', 591623);

diff --git a/inc/extensions/ext-sponsor.php b/inc/extensions/ext-sponsor.php
index 9342c009b645e4c8362d12f638e1b988f6cc62a4..4bcff990a9c7ea494b99fa976ff61346cc04ca2f 100644 (file)
--- a/inc/extensions/ext-sponsor.php
+++ b/inc/extensions/ext-sponsor.php
@@ -51,16 +51,14 @@ case "register": // Do stuff when installation is running (modules.php?module=ad
        //
        // SQL commands to run
        //
        //
        // SQL commands to run
        //

-       //if (EXT_IS_ACTIVE("repair"))
-       //{
-               // Try to make it depend on repair
-               $EXT_UPDATE_DEPENDS = "repair";
+       // Try to make it depend on repair
+       $EXT_UPDATE_DEPENDS = "repair";

 
 

-               //
-               // Sponsor data
-               //
-               $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_data";
-               $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_data (
+       //
+       // Sponsor data
+       //
+       $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_data";
+       $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_data (

 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 company VARCHAR(255) NOT NULL DEFAULT '',
 position VARCHAR(255) NOT NULL DEFAULT '',
 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 company VARCHAR(255) NOT NULL DEFAULT '',
 position VARCHAR(255) NOT NULL DEFAULT '',


@@ -97,11 +95,11 @@ KEY(refid),
 KEY(email),
 PRIMARY KEY(id)
 )TYPE=MyISAM";
 KEY(email),
 PRIMARY KEY(id)
 )TYPE=MyISAM";

-               //
-               // Sponsor orders
-               //
-               $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_orders";
-               $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_orders (
+       //
+       // Sponsor orders
+       //
+       $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_orders";
+       $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_orders (

 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 sponsorid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 aid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 sponsorid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 aid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,


@@ -117,11 +115,11 @@ KEY (aid),
 KEY (sponsorid),
 PRIMARY KEY(id)
 )TYPE=MyISAM";
 KEY (sponsorid),
 PRIMARY KEY(id)
 )TYPE=MyISAM";

-               //
-               // Pay-types
-               //
-               $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_paytypes";
-               $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_paytypes (
+       //
+       // Pay-types
+       //
+       $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_paytypes";
+       $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_paytypes (

 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 pay_name VARCHAR(255) NOT NULL DEFAULT '',
 pay_rate FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000,
 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 pay_name VARCHAR(255) NOT NULL DEFAULT '',
 pay_rate FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 0.00000,


@@ -129,11 +127,11 @@ pay_min_count BIGINT(20) UNSIGNED NOT NULL DEFAULT 1,
 pay_currency VARCHAR(255) NOT NULL DEFAULT '€',
 PRIMARY KEY(id)
 )TYPE=MyISAM";
 pay_currency VARCHAR(255) NOT NULL DEFAULT '€',
 PRIMARY KEY(id)
 )TYPE=MyISAM";

-               //
-               // Points-to-action converting
-               //
-               $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_action_convert";
-               $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_action_convert (
+       //
+       // Points-to-action converting
+       //
+       $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_action_convert";
+       $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_action_convert (

 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 ext_name VARCHAR(255) NOT NULL DEFAULT 'sponsor',
 conv_rate BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 ext_name VARCHAR(255) NOT NULL DEFAULT 'sponsor',
 conv_rate BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,


@@ -141,26 +139,26 @@ conv_name VARCHAR(255) NOT NULL DEFAULT 'Mails',
 KEY (ext_name),
 PRIMARY KEY(id)
 )TYPE=MyISAM";
 KEY (ext_name),
 PRIMARY KEY(id)
 )TYPE=MyISAM";

-               //
-               // Sponsor menu system (default)
-               //
-               $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_menu";
-               $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_menu (
+       //
+       // Sponsor menu system (default)
+       //
+       $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_menu";
+       $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_menu (

 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 action VARCHAR(255) NOT NULL DEFAULT '',
 what  VARCHAR(255) NULL DEFAULT NULL,
 title VARCHAR(255) NOT NULL DEFAULT '',
 active ENUM('Y','N') NOT NULL DEFAULT 'N',
 sort BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 action VARCHAR(255) NOT NULL DEFAULT '',
 what  VARCHAR(255) NULL DEFAULT NULL,
 title VARCHAR(255) NOT NULL DEFAULT '',
 active ENUM('Y','N') NOT NULL DEFAULT 'N',
 sort BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,

-KEY(what),
-KEY(action),
+KEY (action),
+UNIQUE KEY (what),

 PRIMARY KEY(id)
 )TYPE=MyISAM";
 PRIMARY KEY(id)
 )TYPE=MyISAM";

-               //
-               // Registry for performable actions by your sponsors
-               //
-               $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_registry";
-               $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_registry (
+       //
+       // Registry for performable actions by your sponsors
+       //
+       $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_registry";
+       $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_registry (

 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 aid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 ext_name VARCHAR(255) NOT NULL DEFAULT 'sponsor',
 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 aid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 ext_name VARCHAR(255) NOT NULL DEFAULT 'sponsor',


@@ -170,11 +168,11 @@ KEY(ext_name),
 KEY(aid),
 PRIMARY KEY(id)
 )TYPE=MyISAM";
 KEY(aid),
 PRIMARY KEY(id)
 )TYPE=MyISAM";

-               //
-               // URLs from the sponsors
-               //
-               $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_urls";
-               $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_urls (
+       //
+       // URLs from the sponsors
+       //
+       $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_urls";
+       $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_urls (

 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 sponsorid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 url VARCHAR(255) NOT NULL DEFAULT 'http://',
 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 sponsorid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 url VARCHAR(255) NOT NULL DEFAULT 'http://',


@@ -184,11 +182,11 @@ status ENUM('PENDING','ACTIVE','LOCKED') NOT NULL DEFAULT 'PENDING',
 KEY(sponsorid),
 PRIMARY KEY(id)
 )TYPE=MyISAM";
 KEY(sponsorid),
 PRIMARY KEY(id)
 )TYPE=MyISAM";

-               //
-               // Banners of any size from the sponsors
-               //
-               $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_banner";
-               $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_banner (
+       //
+       // Banners of any size from the sponsors
+       //
+       $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_banner";
+       $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_banner (

 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 sponsorid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 url VARCHAR(255) NOT NULL DEFAULT 'http://',
 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 sponsorid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 url VARCHAR(255) NOT NULL DEFAULT 'http://',


@@ -200,11 +198,11 @@ status ENUM('PENDING','ACTIVE','LOCKED') NOT NULL DEFAULT 'PENDING',
 KEY(sponsorid),
 PRIMARY KEY(id)
 )TYPE=MyISAM";
 KEY(sponsorid),
 PRIMARY KEY(id)
 )TYPE=MyISAM";

-               //
-               // Campaigns
-               //
-               $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_campaigns";
-               $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_campaigns (
+       //
+       // Campaigns
+       //
+       $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_campaigns";
+       $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_campaigns (

 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 sponsorid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 aid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 sponsorid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 aid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,


@@ -222,11 +220,11 @@ KEY(aid),
 KEY(sponsorid),
 PRIMARY KEY(id)
 )TYPE=MyISAM";
 KEY(sponsorid),
 PRIMARY KEY(id)
 )TYPE=MyISAM";

-               //
-               // Campaigns + URLs + Banner
-               //
-               $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_campaign_assigns";
-               $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_campaign_assigns (
+       //
+       // Campaigns + URLs + Banner
+       //
+       $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_campaign_assigns";
+       $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_campaign_assigns (

 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 campaignid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 urlid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 campaignid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 urlid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,


@@ -238,21 +236,21 @@ KEY(urlid),
 KEY(campaignid),
 PRIMARY KEY(id)
 )TYPE=MyISAM";
 KEY(campaignid),
 PRIMARY KEY(id)
 )TYPE=MyISAM";

-               //
-               // Allowed data to display (administrative)
-               //
-               $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_admin_data";
-               $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_admin_data (
+       //
+       // Allowed data to display (administrative)
+       //
+       $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_admin_data";
+       $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_admin_data (

 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 data_row VARCHAR(255) NOT NULL DEFAULT '',
 display ENUM('Y','N') NOT NULL DEFAULT 'N',
 PRIMARY KEY(id)
 )TYPE=MyISAM";
 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 data_row VARCHAR(255) NOT NULL DEFAULT '',
 display ENUM('Y','N') NOT NULL DEFAULT 'N',
 PRIMARY KEY(id)
 )TYPE=MyISAM";

-               //
-               // Allowed data to display (sponsor-side)
-               //
-               $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_display_data";
-               $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_display_data (
+       //
+       // Allowed data to display (sponsor-side)
+       //
+       $SQLs[] = "DROP TABLE IF EXISTS "._MYSQL_PREFIX."_sponsor_display_data";
+       $SQLs[] = "CREATE TABLE "._MYSQL_PREFIX."_sponsor_display_data (

 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 sponsorid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 data_row VARCHAR(255) NOT NULL DEFAULT '',
 id BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
 sponsorid BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
 data_row VARCHAR(255) NOT NULL DEFAULT '',


@@ -260,122 +258,116 @@ display ENUM('Y','N') NOT NULL DEFAULT 'N',
 KEY(sponsorid),
 PRIMARY KEY(id)
 )TYPE=MyISAM";
 KEY(sponsorid),
 PRIMARY KEY(id)
 )TYPE=MyISAM";

-               //
-               // Default allowed data to display
-               //
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('id','N')";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('company','Y')";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('position','N')";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('tax_ident','N')";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('gender','N')";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('surname','N')";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('family','N')";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('street_nr1','Y')";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('street_nr2','Y')";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('zip','Y')";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('city','Y')";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('country','Y')";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('phone','Y')";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('fax','Y')";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('email','Y')";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('url','N')";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('password','N')";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('remote_addr','N')";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('sponsor_created','N')";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('last_online','N')";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('last_change','N')";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('status','N')";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('receive_warnings','N')";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('warning_interval','N')";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('points_amount','N')";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('points_used','N')";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('refid','N')";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('ref_count','N')";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('hash','N')";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('last_pay','N')";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('last_curr','N')";
-               //
-               // Add default entries
-               //
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_registry (ext_name, is_active, aid, stamp_added) VALUES ('sponsor','N','".GET_ADMIN_ID(get_session('admin_login'))."','UNIX_TIMESTAMP()')";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_action_convert (ext_name, conv_rate, conv_name) VALUES ('sponsor','10','Mails')";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_paytypes (pay_name, pay_min_count, pay_rate, pay_currency) VALUES ('Standart-Paket', 5, 1000.00000, '€')";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_paytypes (pay_name, pay_min_count, pay_rate, pay_currency) VALUES ('Spar-Paket', 1, 200.00000, '€')";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_paytypes (pay_name, pay_min_count, pay_rate, pay_currency) VALUES ('Power-Paket', 10, 2000.00000, '€')";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_paytypes (pay_name, pay_min_count, pay_rate, pay_currency) VALUES ('Sponsor-Paket', 20, 4000.00000, '€')";
-               //
-               // Admin menu
-               //
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('sponsor', NULL, 'Sponsorenbereich','Den Sponsorenbereich verwalten. Hier können Sie auch Sonderaktionen seperat deakvieren oder wieder aktivieren, Sponsorenaccounts verwalten usw.', 7)";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('sponsor','add_sponsor','Neuer Sponsor','Neues Sponsorenaccount hinzufügen.', 1)";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('sponsor','unlock_sponsor','Sponsor freischalten','Sponsorenaccounts freigeben / sperren.', 2)";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('sponsor','list_sponsor','Sponsoren auflisten','Listet alle verfügbaren Sponsorenaccounts auf.', 3)";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('sponsor','edit_sponsor','Sponsor ändern','Sponsorenaccount ändern (Grundaten, nicht Freigabe!).', 4)";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('sponsor','lock_sponsor','Sponsor ent-/sperren','Sponsorenaccount sperren und entsperren.', 5)";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('sponsor','del_sponsor','Sponsor löschen','Sponsorenaccount löschen.', 6)";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('sponsor','allow_sponsor_data','Datenverwaltung','Stellen Sie hier ein, welche Daten der Sponsor im Mitgliedsbereich über sicht anzeigen darf und welche nicht.', 7)";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('sponsor','list_sponsor_pays','Bestellungen...','Bestellungen der Sponsoren auflisten / bearbeiten.', 8)";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('sponsor','list_sponsor_menu','Sponsorenmenü','Das Sponsorenmenü kann hier geändert werden.', 9)";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('sponsor','list_sponsor_campaigns','Kampagnen...','Verwaltung aller von Ihren Sponsoren eingerichteten Kampagnen.', 10)";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('sponsor','list_sponsor_urls','URL-Verwaltung','Verwaltung (freischalten, sperren, löschen, testen, bearbeiten usw.) von gebuchten URLs.', 11)";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('sponsor','list_sponsor_banner','Banner-Verwaltung','Verwaltung (freischalten, sperren, löschen, testen, bearbeiten usw.) von gebuchten Bannern.', 12)";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('sponsor','list_sponsor_reg','Sponsor-Aktionen','Alle Sponsor-Aktionen auflisten und verwalten.', 13)";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('sponsor','list_sponsor_pay','Buchungspakete','Die Sponsoren können sich {!POINTS!}-Pakete kaufen. Hier können Sie diese verwalten.', 14)";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('sponsor','list_sponsor_conv','{!POINTS!} umwandeln...','Mit den vom Sponsor gekauften {!POINTS!} kann er Aktionen buchen. Hier stellen Sie die Umrechnungsrate von {!POINTS!} nach Sponsoraktionen um. Beispiel: 1 {!POINTS!} = 10 Mails.', 15)";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('sponsor','config_sponsor','Einstellungen','Allgemeine Einstellungen am Sponsoring-System.', 16)";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('repair','repr_sponsor','Sponsormenü','Gewichtung des Sponsormenüs reparieren.', 5)";
-               //
-               // Menu system (still admin menu)
-               //
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('menu','sponsor_medit','Sponsor-Menü editieren','Hier können Sie das Sponsorenmenü verändern: Positionen verändern, Menütitel ändern usw.', 7)";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('menu','sponsor_madd','Sponsor-Menü hinzufügen','Hier können Sie einen neuen Menüpunkt hinzufügen (falls Sie z.B. eigene Sponsoraktionen entwickelt haben oder welche versehendlich gelöscht haben.', 8)";
-               //
-               // Guest menu
-               //
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_guest_menu (action, what, title, sort) VALUES ('sponsor', NULL, 'Sponsoren', 2)";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_guest_menu (action, what, title, sort) VALUES ('sponsor','sponsor_reg','Anmeldung', 1)";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_guest_menu (action, what, title, sort) VALUES ('sponsor','sponsor_login','Einloggen', 2)";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_guest_menu (action, what, title, sort) VALUES ('sponsor','sponsor_infos','Infos/Preise', 3)";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_guest_menu (action, what, title, sort) VALUES ('sponsor','sponsor_agb','AGBs', 4)";
-               //
-               // Member menu
-               //
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_member_menu (action, what, title, sort) VALUES ('main','sponsor','Unsere Sponsoren', 8)";
-               //
-               // Add default menus to sponsor menu
-               //
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('main', NULL, 'Hauptauswahl','N', 1)";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('main','welcome','Willkommen','N', 1)";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('main','account','Ihr Account','N', 2)";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('main','campaigns','Kampagnen','N', 3)";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('main','urls','URL-Verwaltung','N', 4)";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('main','banner','Banner-Verwaltung','N', 5)";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('main','settings','Einstellungen','N', 6)";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('main','fillup','Konto auffüllen','N', 7)";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('main','stats','Statistiken','N', 8)";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('main','inquiry','Kontaktanfrage','N', 9)";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('main','refid','Referal-Link','N', 10)";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('actions', NULL, 'Sponsorenaktionen','N', 2)";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('actions','mail','Sponsor-Mail','N', 1)";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('actions','banner','Banner buchen','N', 2)";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('actions','text','Textlink buchen','N', 3)";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('logout', NULL, 'Ausloggen','N', 3)";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('logout','logout','Ausloggen','N', 1)";
-               $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('logout','guest','Zum Gastbereich','N', 2)";
-               //
-               // General configuration stuff
-               //
-               $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD sponsor_ref_points FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 100.00000";
-               $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD sponsor_min_points FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 1000.00000";
+       //
+       // Default allowed data to display
+       //
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('id','N')";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('company','Y')";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('position','N')";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('tax_ident','N')";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('gender','N')";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('surname','N')";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('family','N')";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('street_nr1','Y')";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('street_nr2','Y')";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('zip','Y')";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('city','Y')";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('country','Y')";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('phone','Y')";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('fax','Y')";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('email','Y')";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('url','N')";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('password','N')";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('remote_addr','N')";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('sponsor_created','N')";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('last_online','N')";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('last_change','N')";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('status','N')";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('receive_warnings','N')";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('warning_interval','N')";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('points_amount','N')";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('points_used','N')";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('refid','N')";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('ref_count','N')";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('hash','N')";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('last_pay','N')";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_admin_data (data_row, display) VALUES ('last_curr','N')";
+       //
+       // Add default entries
+       //
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_registry (ext_name, is_active, aid, stamp_added) VALUES ('sponsor','N','".GET_ADMIN_ID(get_session('admin_login'))."','UNIX_TIMESTAMP()')";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_action_convert (ext_name, conv_rate, conv_name) VALUES ('sponsor','10','Mails')";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_paytypes (pay_name, pay_min_count, pay_rate, pay_currency) VALUES ('Standart-Paket', 5, 1000.00000, '€')";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_paytypes (pay_name, pay_min_count, pay_rate, pay_currency) VALUES ('Spar-Paket', 1, 200.00000, '€')";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_paytypes (pay_name, pay_min_count, pay_rate, pay_currency) VALUES ('Power-Paket', 10, 2000.00000, '€')";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_paytypes (pay_name, pay_min_count, pay_rate, pay_currency) VALUES ('Sponsor-Paket', 20, 4000.00000, '€')";
+       //
+       // Admin menu
+       //
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('sponsor', NULL, 'Sponsorenbereich','Den Sponsorenbereich verwalten. Hier können Sie auch Sonderaktionen seperat deakvieren oder wieder aktivieren, Sponsorenaccounts verwalten usw.', 7)";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('sponsor','add_sponsor','Neuer Sponsor','Neues Sponsorenaccount hinzufügen.', 1)";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('sponsor','unlock_sponsor','Sponsor freischalten','Sponsorenaccounts freigeben / sperren.', 2)";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('sponsor','list_sponsor','Sponsoren auflisten','Listet alle verfügbaren Sponsorenaccounts auf.', 3)";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('sponsor','edit_sponsor','Sponsor ändern','Sponsorenaccount ändern (Grundaten, nicht Freigabe!).', 4)";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('sponsor','lock_sponsor','Sponsor ent-/sperren','Sponsorenaccount sperren und entsperren.', 5)";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('sponsor','del_sponsor','Sponsor löschen','Sponsorenaccount löschen.', 6)";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('sponsor','allow_sponsor_data','Datenverwaltung','Stellen Sie hier ein, welche Daten der Sponsor im Mitgliedsbereich über sicht anzeigen darf und welche nicht.', 7)";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('sponsor','list_sponsor_pays','Bestellungen...','Bestellungen der Sponsoren auflisten / bearbeiten.', 8)";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('sponsor','list_sponsor_menu','Sponsorenmenü','Das Sponsorenmenü kann hier geändert werden.', 9)";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('sponsor','list_sponsor_campaigns','Kampagnen...','Verwaltung aller von Ihren Sponsoren eingerichteten Kampagnen.', 10)";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('sponsor','list_sponsor_urls','URL-Verwaltung','Verwaltung (freischalten, sperren, löschen, testen, bearbeiten usw.) von gebuchten URLs.', 11)";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('sponsor','list_sponsor_banner','Banner-Verwaltung','Verwaltung (freischalten, sperren, löschen, testen, bearbeiten usw.) von gebuchten Bannern.', 12)";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('sponsor','list_sponsor_reg','Sponsor-Aktionen','Alle Sponsor-Aktionen auflisten und verwalten.', 13)";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('sponsor','list_sponsor_pay','Buchungspakete','Die Sponsoren können sich {!POINTS!}-Pakete kaufen. Hier können Sie diese verwalten.', 14)";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('sponsor','list_sponsor_conv','{!POINTS!} umwandeln...','Mit den vom Sponsor gekauften {!POINTS!} kann er Aktionen buchen. Hier stellen Sie die Umrechnungsrate von {!POINTS!} nach Sponsoraktionen um. Beispiel: 1 {!POINTS!} = 10 Mails.', 15)";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('sponsor','config_sponsor','Einstellungen','Allgemeine Einstellungen am Sponsoring-System.', 16)";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('repair','repr_sponsor','Sponsormenü','Gewichtung des Sponsormenüs reparieren.', 5)";
+       //
+       // Menu system (still admin menu)
+       //
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('menu','sponsor_medit','Sponsor-Menü editieren','Hier können Sie das Sponsorenmenü verändern: Positionen verändern, Menütitel ändern usw.', 7)";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_admin_menu (`action`,`what`,`title`,`descr`,`sort`) VALUES ('menu','sponsor_madd','Sponsor-Menü hinzufügen','Hier können Sie einen neuen Menüpunkt hinzufügen (falls Sie z.B. eigene Sponsoraktionen entwickelt haben oder welche versehendlich gelöscht haben.', 8)";
+       //
+       // Guest menu
+       //
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_guest_menu (action, what, title, sort) VALUES ('sponsor', NULL, 'Sponsoren', 2)";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_guest_menu (action, what, title, sort) VALUES ('sponsor','sponsor_reg','Anmeldung', 1)";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_guest_menu (action, what, title, sort) VALUES ('sponsor','sponsor_login','Einloggen', 2)";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_guest_menu (action, what, title, sort) VALUES ('sponsor','sponsor_infos','Infos/Preise', 3)";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_guest_menu (action, what, title, sort) VALUES ('sponsor','sponsor_agb','AGBs', 4)";
+       //
+       // Member menu
+       //
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_member_menu (action, what, title, sort) VALUES ('main','sponsor','Unsere Sponsoren', 8)";
+       //
+       // Add default menus to sponsor menu
+       //
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('main', NULL, 'Hauptauswahl','N', 1)";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('main','welcome','Willkommen','N', 1)";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('main','account','Ihr Account','N', 2)";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('main','campaigns','Kampagnen','N', 3)";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('main','urls','URL-Verwaltung','N', 4)";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('main','banner','Banner-Verwaltung','N', 5)";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('main','settings','Einstellungen','N', 6)";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('main','fillup','Konto auffüllen','N', 7)";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('main','stats','Statistiken','N', 8)";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('main','inquiry','Kontaktanfrage','N', 9)";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('main','refid','Referal-Link','N', 10)";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('actions', NULL, 'Sponsorenaktionen','N', 2)";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('actions','mail','Sponsor-Mail','N', 1)";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('actions','banner','Banner buchen','N', 2)";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('actions','text','Textlink buchen','N', 3)";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('logout', NULL, 'Ausloggen','N', 3)";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('logout','logout','Ausloggen','N', 1)";
+       $SQLs[] = "INSERT INTO "._MYSQL_PREFIX."_sponsor_menu (action, what, title, active, sort) VALUES ('logout','guest','Zum Gastbereich','N', 2)";
+       //
+       // General configuration stuff
+       //
+       $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD sponsor_ref_points FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 100.00000";
+       $SQLs[] = "ALTER TABLE "._MYSQL_PREFIX."_config ADD sponsor_min_points FLOAT(20,5) UNSIGNED NOT NULL DEFAULT 1000.00000";

 
 

-               // Load CSS file
-               $EXT_CSS = "Y";
-       //}
-       // else
-       //{
-       //      // Sponsor extension depends now on repair extension!
-       //      $SQLs[] = "DELETE LOW_PRIORITY FROM "._MYSQL_PREFIX."_extensions WHERE ext_name='sponsor' LIMIT 1";
-       //}
+       // Load CSS file
+       $EXT_CSS = "Y";

        break;
 
 case "remove": // Do stuff when removing extension
        break;
 
 case "remove": // Do stuff when removing extension

diff --git a/inc/modules/admin/what-config_surfbar.php b/inc/modules/admin/what-config_surfbar.php
index d481f6a761f0885fa835f17cd57fbbcddd8ebbc6..2d0d6d38ca26fe028fe87391753d2fad3dab3d0d 100644 (file)
--- a/inc/modules/admin/what-config_surfbar.php
+++ b/inc/modules/admin/what-config_surfbar.php
@@ -54,17 +54,17 @@ if (isset($_POST['ok'])) {
        $content = array(
                'surfbar_static_reward'   => TRANSLATE_COMMA($_CONFIG['surfbar_static_reward']),
                'surfbar_static_costs'    => TRANSLATE_COMMA($_CONFIG['surfbar_static_costs']),
        $content = array(
                'surfbar_static_reward'   => TRANSLATE_COMMA($_CONFIG['surfbar_static_reward']),
                'surfbar_static_costs'    => TRANSLATE_COMMA($_CONFIG['surfbar_static_costs']),

-               'surfbar_static_time'     => CREATE_TIME_SELECTIONS($_CONFIG['surfbar_static_time']   , "surfbar_static_time"   , "ms"),
-               'surfbar_static_lock'     => CREATE_TIME_SELECTIONS($_CONFIG['surfbar_static_lock']   , "surfbar_static_lock"   , "hm"),
-               'surfbar_restart_time'    => CREATE_TIME_SELECTIONS($_CONFIG['surfbar_restart_time']  , "surfbar_restart_time"  , "ms"),
+               'surfbar_static_time'     => CREATE_TIME_SELECTIONS($_CONFIG['surfbar_static_time']   , "surfbar_static_time"   , "ms" , "left"),
+               'surfbar_static_lock'     => CREATE_TIME_SELECTIONS($_CONFIG['surfbar_static_lock']   , "surfbar_static_lock"   , "hm" , "left"),
+               'surfbar_restart_time'    => CREATE_TIME_SELECTIONS($_CONFIG['surfbar_restart_time']  , "surfbar_restart_time"  , "ms" , "left"),

                'surfbar_dynamic_percent' => TRANSLATE_COMMA($_CONFIG['surfbar_dynamic_percent']),
                'surfbar_max_order'       => $_CONFIG['surfbar_max_order'],
                'surfbar_dynamic_percent' => TRANSLATE_COMMA($_CONFIG['surfbar_dynamic_percent']),
                'surfbar_max_order'       => $_CONFIG['surfbar_max_order'],

-               'surfbar_stats_reload'    => CREATE_TIME_SELECTIONS($_CONFIG['surfbar_stats_reload']  , "surfbar_stats_reload"  , "ms"),
-               'surfbar_purge_deleted'   => CREATE_TIME_SELECTIONS($_CONFIG['surfbar_purge_deleted'] , "surfbar_purge_deleted" , "WDh"),
-               'surfbar_purge_migrated'  => CREATE_TIME_SELECTIONS($_CONFIG['surfbar_purge_migrated'], "surfbar_purge_migrated", "WDh"),
+               'surfbar_stats_reload'    => CREATE_TIME_SELECTIONS($_CONFIG['surfbar_stats_reload']  , "surfbar_stats_reload"  , "ms" , "left"),
+               'surfbar_purge_deleted'   => CREATE_TIME_SELECTIONS($_CONFIG['surfbar_purge_deleted'] , "surfbar_purge_deleted" , "WDh", "left"),
+               'surfbar_purge_migrated'  => CREATE_TIME_SELECTIONS($_CONFIG['surfbar_purge_migrated'], "surfbar_purge_migrated", "WDh", "left"),

                'surfbar_pause_url'       => $_CONFIG['surfbar_pause_url'],
                'surfbar_warn_low_points' => $_CONFIG['surfbar_warn_low_points'],
                'surfbar_pause_url'       => $_CONFIG['surfbar_pause_url'],
                'surfbar_warn_low_points' => $_CONFIG['surfbar_warn_low_points'],

-               'surfbar_low_interval'    => CREATE_TIME_SELECTIONS($_CONFIG['surfbar_low_interval']  , "surfbar_low_interval"  , "WDh"),
+               'surfbar_low_interval'    => CREATE_TIME_SELECTIONS($_CONFIG['surfbar_low_interval']  , "surfbar_low_interval"  , "WDh", "left"),

        );
 
        // Prepare payment model for template
        );
 
        // Prepare payment model for template

diff --git a/templates/de/html/admin/admin_config_surfbar.tpl b/templates/de/html/admin/admin_config_surfbar.tpl
index 7a6622c653082723d42f539f0d63059d4a37ed3d..a193384adbc88929b5c65e6d76b30ed9aa7495dd 100644 (file)
--- a/templates/de/html/admin/admin_config_surfbar.tpl
+++ b/templates/de/html/admin/admin_config_surfbar.tpl
@@ -1,5 +1,5 @@
 <form action="{!URL!}/modules.php?module=admin&amp;what=config_surfbar" method="POST">
 <form action="{!URL!}/modules.php?module=admin&amp;what=config_surfbar" method="POST">

-<table border="0" cellspacing="0" cellpadding="0" width="500" class="admin_table dashed" align="center">
+<table border="0" cellspacing="0" cellpadding="0" width="550" class="admin_table dashed" align="center">

        <tr>
                <td colspan="2" align="center" class="admin_title bottom2" height="30">
                        <STRONG>{--ADMIN_CONFIG_SURFBAR_TITLE--}</STRONG>
        <tr>
                <td colspan="2" align="center" class="admin_title bottom2" height="30">
                        <STRONG>{--ADMIN_CONFIG_SURFBAR_TITLE--}</STRONG>


@@ -7,10 +7,10 @@
        </tr>
        <tr><td height="3" colspan="2" class="seperator">&nbsp;</td></tr>
        <tr>
        </tr>
        <tr><td height="3" colspan="2" class="seperator">&nbsp;</td></tr>
        <tr>

-               <td width="70%" height="30" align="right" style="padding-right:5px">
+               <td width="65%" height="30" align="right" style="padding-right:5px">

                        {--ADMIN_CONFIG_SURFBAR_STATIC_REWARD--}
                </td>
                        {--ADMIN_CONFIG_SURFBAR_STATIC_REWARD--}
                </td>

-               <td width="30%">
+               <td width="35%">

                        <input type="text" name="surfbar_static_reward" size="6" maxlength="20" value="$content[surfbar_static_reward]" /> {!POINTS!}
                </td>
        </tr>
                        <input type="text" name="surfbar_static_reward" size="6" maxlength="20" value="$content[surfbar_static_reward]" /> {!POINTS!}
                </td>
        </tr>


@@ -151,41 +151,34 @@
                </td>
        </tr>
        <tr><td height="3" colspan="2" class="seperator bottom2">&nbsp;</td></tr>
                </td>
        </tr>
        <tr><td height="3" colspan="2" class="seperator bottom2">&nbsp;</td></tr>

+       <tr><td height="3" colspan="2" class="seperator">&nbsp;</td></tr>

        <tr>
        <tr>

-               <td height="30" align="center" colspan="2" class="admin_footer bottom2">
+               <td height="30" align="right" style="padding-right:5px">

                        {--ADMIN_CONFIG_SURFBAR_AUTOSTART--}
                </td>
                        {--ADMIN_CONFIG_SURFBAR_AUTOSTART--}
                </td>

-       </tr>
-       <tr><td height="3" colspan="2" class="seperator">&nbsp;</td></tr>
-       <tr>
-               <td align="center" colspan="2">
+               <td align="center">

                        <input type="radio" name="surfbar_autostart" value="Y"{!__CONFIG_SURFBAR_AUTOSTART_Y!} />&nbsp;{--YES--}
                        <input type="radio" name="surfbar_autostart" value="N"{!__CONFIG_SURFBAR_AUTOSTART_N!} />&nbsp;{--NO--}
                </td>
        </tr>
                        <input type="radio" name="surfbar_autostart" value="Y"{!__CONFIG_SURFBAR_AUTOSTART_Y!} />&nbsp;{--YES--}
                        <input type="radio" name="surfbar_autostart" value="N"{!__CONFIG_SURFBAR_AUTOSTART_N!} />&nbsp;{--NO--}
                </td>
        </tr>

-       <tr><td height="3" colspan="2" class="seperator">&nbsp;</td></tr>

        <tr><td height="3" colspan="2" class="seperator bottom2">&nbsp;</td></tr>
        <tr><td height="3" colspan="2" class="seperator bottom2">&nbsp;</td></tr>

+       <tr><td height="3" colspan="2" class="seperator">&nbsp;</td></tr>

        <tr>
        <tr>

-               <td height="30" align="center" colspan="2" class="admin_footer bottom2">
+               <td height="30" align="right" style="padding-right:5px">

                        {--ADMIN_CONFIG_SURFBAR_NOTIFY_LIMITS--}
                </td>
                        {--ADMIN_CONFIG_SURFBAR_NOTIFY_LIMITS--}
                </td>

-       </tr>
-       <tr><td height="3" colspan="2" class="seperator">&nbsp;</td></tr>
-       <tr>
-               <td align="center" colspan="2">
+               <td align="center">

                        <input type="radio" name="surfbar_notify_limits" value="Y"{!__CONFIG_SURFBAR_NOTIFY_LIMITS_Y!} />&nbsp;{--YES--}
                        <input type="radio" name="surfbar_notify_limits" value="N"{!__CONFIG_SURFBAR_NOTIFY_LIMITS_N!} />&nbsp;{--NO--}
                </td>
        </tr>
        <tr><td height="3" colspan="2" class="seperator bottom2">&nbsp;</td></tr>
                        <input type="radio" name="surfbar_notify_limits" value="Y"{!__CONFIG_SURFBAR_NOTIFY_LIMITS_Y!} />&nbsp;{--YES--}
                        <input type="radio" name="surfbar_notify_limits" value="N"{!__CONFIG_SURFBAR_NOTIFY_LIMITS_N!} />&nbsp;{--NO--}
                </td>
        </tr>
        <tr><td height="3" colspan="2" class="seperator bottom2">&nbsp;</td></tr>

-       <tr>
-               <td align="center" colspan="2" class="admin_footer bottom2">
-                       {--ADMIN_CONFIG_SURFBAR_NOTIFICATION_MODE--}
-               </td>
-       </tr>

        <tr><td height="3" colspan="2" class="seperator">&nbsp;</td></tr>
        <tr>
                <td height="30" align="right" style="padding-right:5px">
        <tr><td height="3" colspan="2" class="seperator">&nbsp;</td></tr>
        <tr>
                <td height="30" align="right" style="padding-right:5px">

+                       {--ADMIN_CONFIG_SURFBAR_NOTIFICATION_MODE--}
+               </td>
+               <td align="center">

                        <select name="surfbar_notification_mode" class="admin_select" size="1">
                                <option value="INSTANT"{!__CONFIG_SURFBAR_NOTIFICATION_MODE_INSTANT!}>{--ADMIN_CONFIG_SURFBAR_NOTIFICATION_MODE_INSTANT--}</option>
                                <option value="RESET"{!__CONFIG_SURFBAR_NOTIFICATION_MODE_RESET!}>{--ADMIN_CONFIG_SURFBAR_NOTIFICATION_MODE_RESET--}</option>
                        <select name="surfbar_notification_mode" class="admin_select" size="1">
                                <option value="INSTANT"{!__CONFIG_SURFBAR_NOTIFICATION_MODE_INSTANT!}>{--ADMIN_CONFIG_SURFBAR_NOTIFICATION_MODE_INSTANT--}</option>
                                <option value="RESET"{!__CONFIG_SURFBAR_NOTIFICATION_MODE_RESET!}>{--ADMIN_CONFIG_SURFBAR_NOTIFICATION_MODE_RESET--}</option>


@@ -212,14 +205,12 @@
                </td>
        </tr>
        <tr><td height="3" colspan="2" class="seperator bottom2">&nbsp;</td></tr>
                </td>
        </tr>
        <tr><td height="3" colspan="2" class="seperator bottom2">&nbsp;</td></tr>

+       <tr><td height="3" colspan="2" class="seperator">&nbsp;</td></tr>

        <tr>
        <tr>

-               <td height="30" align="center" colspan="2" class="admin_footer bottom2">
+               <td height="30" align="center">

                        {--ADMIN_CONFIG_SURFBAR_MIGRATE_ORDER--}
                </td>
                        {--ADMIN_CONFIG_SURFBAR_MIGRATE_ORDER--}
                </td>

-       </tr>
-       <tr><td height="3" colspan="2" class="seperator">&nbsp;</td></tr>
-       <tr>
-               <td align="center" colspan="2">
+               <td align="center">

                        <input type="radio" name="surfbar_migrate_order" value="Y"{!__CONFIG_SURFBAR_MIGRATE_ORDER_Y!} />&nbsp;{--YES--}
                        <input type="radio" name="surfbar_migrate_order" value="N"{!__CONFIG_SURFBAR_MIGRATE_ORDER_N!} />&nbsp;{--NO--}
                </td>
                        <input type="radio" name="surfbar_migrate_order" value="Y"{!__CONFIG_SURFBAR_MIGRATE_ORDER_Y!} />&nbsp;{--YES--}
                        <input type="radio" name="surfbar_migrate_order" value="N"{!__CONFIG_SURFBAR_MIGRATE_ORDER_N!} />&nbsp;{--NO--}
                </td>