SQL command for member registration moved to proper extension

[mailer.git] / install / menu-de.sql

diff --git a/install/menu-de.sql b/install/menu-de.sql
index cf41b23256722f1cfcaeb6b3fc2722911454590c..2e322e57942df96b1cd57b846516647c215d371e 100644 (file)
--- a/install/menu-de.sql
+++ b/install/menu-de.sql
@@ -13,33 +13,32 @@ INSERT INTO `{?_MYSQL_PREFIX?}_admin_menu` (`action`,`what`,`title`,`descr`,`sor
 INSERT INTO `{?_MYSQL_PREFIX?}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('setup','refbanner','Referal-Banner','Fügen Sie neue Banner hinzu, die dann die Mitglieder verlinken können, um neue Mitglieder zu werben. Oder editieren / löschen Sie bestehende. Hier sehen Sie auch die Anzahl der Klicks auf den jeweiligen Banner!',12);
 INSERT INTO `{?_MYSQL_PREFIX?}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('setup','payments','{OPEN_CONFIG}POINTS{CLOSE_CONFIG}-Vergütungen','Fügen Sie neue {OPEN_CONFIG}POINTS{CLOSE_CONFIG}-Vergütungen hinzu oder ändern / löschen Sie bestende.',11);
 
-INSERT INTO `{?_MYSQL_PREFIX?}_cats` VALUES (1,'Mix / Alles Senden --> keine Erotik!','Y',0);
-INSERT INTO `{?_MYSQL_PREFIX?}_cats` VALUES (2,'Mix / Alles Senden --> ohne PopUps, keine Erotik','Y',1);
-INSERT INTO `{?_MYSQL_PREFIX?}_cats` VALUES (3,'Traffic, Reflinks, Kostenloses, KEIN MLM!','Y',2);
-INSERT INTO `{?_MYSQL_PREFIX?}_cats` VALUES (4,'Geldverdienen, Beruf, Arbeit, KEIN MLM!','Y',3);
-INSERT INTO `{?_MYSQL_PREFIX?}_cats` VALUES (5,'Download, PC- Software, HP-Design','Y',4);
-INSERT INTO `{?_MYSQL_PREFIX?}_cats` VALUES (6,'Investment, Banken, Börse, Versicherungen, KEIN MLM','Y',5);
-INSERT INTO `{?_MYSQL_PREFIX?}_cats` VALUES (7,'Politik, Wissenschaft','Y',6);
-INSERT INTO `{?_MYSQL_PREFIX?}_cats` VALUES (8,'Handy, SMS, ISDN, DSL,','Y',7);
-INSERT INTO `{?_MYSQL_PREFIX?}_cats` VALUES (9,'Elektronik, Technik, Server, PC-Hardware, Hosting','Y',8);
-INSERT INTO `{?_MYSQL_PREFIX?}_cats` VALUES (10,'Auto, Motorrad','Y',9);
-INSERT INTO `{?_MYSQL_PREFIX?}_cats` VALUES (11,'Reise,Touristik','Y',10);
-INSERT INTO `{?_MYSQL_PREFIX?}_cats` VALUES (12,'Kunst, Kultur, Bildung','Y',11);
-INSERT INTO `{?_MYSQL_PREFIX?}_cats` VALUES (13,'Gesundheit, Fitness, Sport, KEIN MLM!','Y',12);
-INSERT INTO `{?_MYSQL_PREFIX?}_cats` VALUES (14,'Lifestyle, Mode, Kosmetik, KEIN MLM!','Y',13);
-INSERT INTO `{?_MYSQL_PREFIX?}_cats` VALUES (15,'Auktionen, Shopping, Verkauf, KEIN MLM!','Y',14);
-INSERT INTO `{?_MYSQL_PREFIX?}_cats` VALUES (16,'Medien, Musik, Film, TV, Video & DVD','Y',15);
-INSERT INTO `{?_MYSQL_PREFIX?}_cats` VALUES (17,'Singles, Flirten, Partnerschaft','Y',16);
-INSERT INTO `{?_MYSQL_PREFIX?}_cats` VALUES (18,'Gewinnspiele, Wetten, Lotto, KEIN MLM!','Y',17);
-INSERT INTO `{?_MYSQL_PREFIX?}_cats` VALUES (19,'Haus, Garten, Freizeit, Hobbys','Y',18);
-INSERT INTO `{?_MYSQL_PREFIX?}_cats` VALUES (20,'Erotik --> Keine Hardcore !','Y',19);
-INSERT INTO `{?_MYSQL_PREFIX?}_cats` VALUES (21,'Multi Level Marketing (alle Arten)','Y',20);
-INSERT INTO `{?_MYSQL_PREFIX?}_cats` VALUES (22,'Wernis-Seiten','Y',21);
-INSERT INTO `{?_MYSQL_PREFIX?}_cats` VALUES (23,'Primera-Seiten','Y',22);
+INSERT INTO `{?_MYSQL_PREFIX?}_cats` (`cat`,`visible`,`sort`) VALUES ('Mix / Alles Senden --> keine Erotik!','Y',0);
+INSERT INTO `{?_MYSQL_PREFIX?}_cats` (`cat`,`visible`,`sort`) VALUES ('Mix / Alles Senden --> ohne PopUps, keine Erotik','Y',1);
+INSERT INTO `{?_MYSQL_PREFIX?}_cats` (`cat`,`visible`,`sort`) VALUES ('Traffic, Reflinks, Kostenloses, KEIN MLM!','Y',2);
+INSERT INTO `{?_MYSQL_PREFIX?}_cats` (`cat`,`visible`,`sort`) VALUES ('Geldverdienen, Beruf, Arbeit, KEIN MLM!','Y',3);
+INSERT INTO `{?_MYSQL_PREFIX?}_cats` (`cat`,`visible`,`sort`) VALUES ('Download, PC- Software, HP-Design','Y',4);
+INSERT INTO `{?_MYSQL_PREFIX?}_cats` (`cat`,`visible`,`sort`) VALUES ('Investment, Banken, Börse, Versicherungen, KEIN MLM','Y',5);
+INSERT INTO `{?_MYSQL_PREFIX?}_cats` (`cat`,`visible`,`sort`) VALUES ('Politik, Wissenschaft','Y',6);
+INSERT INTO `{?_MYSQL_PREFIX?}_cats` (`cat`,`visible`,`sort`) VALUES ('Handy, SMS, ISDN, DSL,','Y',7);
+INSERT INTO `{?_MYSQL_PREFIX?}_cats` (`cat`,`visible`,`sort`) VALUES ('Elektronik, Technik, Server, PC-Hardware, Hosting','Y',8);
+INSERT INTO `{?_MYSQL_PREFIX?}_cats` (`cat`,`visible`,`sort`) VALUES ('Auto, Motorrad','Y',9);
+INSERT INTO `{?_MYSQL_PREFIX?}_cats` (`cat`,`visible`,`sort`) VALUES ('Reise,Touristik','Y',10);
+INSERT INTO `{?_MYSQL_PREFIX?}_cats` (`cat`,`visible`,`sort`) VALUES ('Kunst, Kultur, Bildung','Y',11);
+INSERT INTO `{?_MYSQL_PREFIX?}_cats` (`cat`,`visible`,`sort`) VALUES ('Gesundheit, Fitness, Sport, KEIN MLM!','Y',12);
+INSERT INTO `{?_MYSQL_PREFIX?}_cats` (`cat`,`visible`,`sort`) VALUES ('Lifestyle, Mode, Kosmetik, KEIN MLM!','Y',13);
+INSERT INTO `{?_MYSQL_PREFIX?}_cats` (`cat`,`visible`,`sort`) VALUES ('Auktionen, Shopping, Verkauf, KEIN MLM!','Y',14);
+INSERT INTO `{?_MYSQL_PREFIX?}_cats` (`cat`,`visible`,`sort`) VALUES ('Medien, Musik, Film, TV, Video & DVD','Y',15);
+INSERT INTO `{?_MYSQL_PREFIX?}_cats` (`cat`,`visible`,`sort`) VALUES ('Singles, Flirten, Partnerschaft','Y',16);
+INSERT INTO `{?_MYSQL_PREFIX?}_cats` (`cat`,`visible`,`sort`) VALUES ('Gewinnspiele, Wetten, Lotto, KEIN MLM!','Y',17);
+INSERT INTO `{?_MYSQL_PREFIX?}_cats` (`cat`,`visible`,`sort`) VALUES ('Haus, Garten, Freizeit, Hobbys','Y',18);
+INSERT INTO `{?_MYSQL_PREFIX?}_cats` (`cat`,`visible`,`sort`) VALUES ('Erotik --> Keine Hardcore !','Y',19);
+INSERT INTO `{?_MYSQL_PREFIX?}_cats` (`cat`,`visible`,`sort`) VALUES ('Multi Level Marketing (alle Arten)','Y',20);
+INSERT INTO `{?_MYSQL_PREFIX?}_cats` (`cat`,`visible`,`sort`) VALUES ('Wernis-Seiten','Y',21);
+INSERT INTO `{?_MYSQL_PREFIX?}_cats` (`cat`,`visible`,`sort`) VALUES ('Primera-Seiten','Y',22);
 
 INSERT INTO `{?_MYSQL_PREFIX?}_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','welcome','Willkommen',1,'Y','N');
 INSERT INTO `{?_MYSQL_PREFIX?}_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main',NULL,'Hauptmenü',0,'Y','N');
-INSERT INTO `{?_MYSQL_PREFIX?}_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('members','register','Anmeldung',2,'Y','N');
 INSERT INTO `{?_MYSQL_PREFIX?}_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('members','confirm','Bestätigungslink',3,'Y','N');
 INSERT INTO `{?_MYSQL_PREFIX?}_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('members',NULL,'Mitglieder',1,'Y','N');
 INSERT INTO `{?_MYSQL_PREFIX?}_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('members','login','Einloggen',3,'Y','N');
@@ -47,40 +46,37 @@ INSERT INTO `{?_MYSQL_PREFIX?}_guest_menu` (`action`,`what`,`title`,`sort`,`visi
 INSERT INTO `{?_MYSQL_PREFIX?}_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','agb','AGBs',4,'Y','N');
 INSERT INTO `{?_MYSQL_PREFIX?}_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','infos','Infos',2,'Y','N');
 
-INSERT INTO `{?_MYSQL_PREFIX?}_max_receive` VALUES (1,0,'Urlaub');
-INSERT INTO `{?_MYSQL_PREFIX?}_max_receive` VALUES (2,50,'Bonus möglich!');
-INSERT INTO `{?_MYSQL_PREFIX?}_max_receive` VALUES (3,90,'Bonus möglich!');
-INSERT INTO `{?_MYSQL_PREFIX?}_max_receive` VALUES (4,5,'');
-INSERT INTO `{?_MYSQL_PREFIX?}_max_receive` VALUES (5,10,'');
-INSERT INTO `{?_MYSQL_PREFIX?}_max_receive` VALUES (6,15,'');
-INSERT INTO `{?_MYSQL_PREFIX?}_max_receive` VALUES (7,20,'');
-INSERT INTO `{?_MYSQL_PREFIX?}_max_receive` VALUES (8,25,'');
-INSERT INTO `{?_MYSQL_PREFIX?}_max_receive` VALUES (9,30,'');
-INSERT INTO `{?_MYSQL_PREFIX?}_max_receive` VALUES (10,35,'');
-INSERT INTO `{?_MYSQL_PREFIX?}_max_receive` VALUES (11,40,'');
-INSERT INTO `{?_MYSQL_PREFIX?}_max_receive` VALUES (12,45,'');
+INSERT INTO `{?_MYSQL_PREFIX?}_max_receive` (`value`,`comment`) VALUES (0,'Urlaub');
+INSERT INTO `{?_MYSQL_PREFIX?}_max_receive` (`value`,`comment`) VALUES (50,'Bonus möglich!');
+INSERT INTO `{?_MYSQL_PREFIX?}_max_receive` (`value`,`comment`) VALUES (90,'Bonus möglich!');
+INSERT INTO `{?_MYSQL_PREFIX?}_max_receive` (`value`,`comment`) VALUES (5,'');
+INSERT INTO `{?_MYSQL_PREFIX?}_max_receive` (`value`,`comment`) VALUES (10,'');
+INSERT INTO `{?_MYSQL_PREFIX?}_max_receive` (`value`,`comment`) VALUES (15,'');
+INSERT INTO `{?_MYSQL_PREFIX?}_max_receive` (`value`,`comment`) VALUES (20,'');
+INSERT INTO `{?_MYSQL_PREFIX?}_max_receive` (`value`,`comment`) VALUES (25,'');
+INSERT INTO `{?_MYSQL_PREFIX?}_max_receive` (`value`,`comment`) VALUES (30,'');
+INSERT INTO `{?_MYSQL_PREFIX?}_max_receive` (`value`,`comment`) VALUES (35,'');
+INSERT INTO `{?_MYSQL_PREFIX?}_max_receive` (`value`,`comment`) VALUES (40,'');
+INSERT INTO `{?_MYSQL_PREFIX?}_max_receive` (`value`,`comment`) VALUES (45,'');
 
 INSERT INTO `{?_MYSQL_PREFIX?}_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main',NULL,'Mitgliedsmenü',0,'Y','N');
 INSERT INTO `{?_MYSQL_PREFIX?}_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','welcome','Willkommen!',1,'Y','N');
 INSERT INTO `{?_MYSQL_PREFIX?}_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('logout','logout','Ausloggen',999,'Y','N');
-INSERT INTO `{?_MYSQL_PREFIX?}_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','mydata','Profildaten ändern',2,'Y','N');
 INSERT INTO `{?_MYSQL_PREFIX?}_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('logout',NULL,'Ausloggen',1,'Y','N');
 INSERT INTO `{?_MYSQL_PREFIX?}_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','points','{OPEN_CONFIG}POINTS{CLOSE_CONFIG}-Guthaben',4,'Y','N');
 INSERT INTO `{?_MYSQL_PREFIX?}_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','categories','Kategorien auswählen',3,'Y','N');
 INSERT INTO `{?_MYSQL_PREFIX?}_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','reflinks','Referal-Links',6,'Y','N');
-INSERT INTO `{?_MYSQL_PREFIX?}_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','order','Mailbuchung',8,'Y','N');
 INSERT INTO `{?_MYSQL_PREFIX?}_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','unconfirmed','Unbestätigte Emails',5,'Y','N');
-INSERT INTO `{?_MYSQL_PREFIX?}_member_menu` (`action`,`what`,`title`,`visible`,`locked`,`sort`) VALUES ('main','stats','Statistiken', 'Y','N',9);
-INSERT INTO `{?_MYSQL_PREFIX?}_member_menu` (`action`,`what`,`title`,`visible`,`locked`,`sort`) VALUES ('main','support','Support ','Y','N',10);
-INSERT INTO `{?_MYSQL_PREFIX?}_member_menu` (`action`,`what`,`title`,`visible`,`locked`,`sort`) VALUES ('logout','guest','Zum Gastmenü','Y','N',1000);
+INSERT INTO `{?_MYSQL_PREFIX?}_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','stats','Statistiken',9, 'Y','N');
+INSERT INTO `{?_MYSQL_PREFIX?}_member_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('logout','guest','Zum Gastmenü',1000,'Y','N');
 
-INSERT INTO `{?_MYSQL_PREFIX?}_payments` VALUES (1,10,2.000,'Klick-Mail 10 Sek.',1.000);
-INSERT INTO `{?_MYSQL_PREFIX?}_payments` VALUES (2,20,10.000,'Klick-Mail 20 Sek.',9.000);
-INSERT INTO `{?_MYSQL_PREFIX?}_payments` VALUES (3,30,30.000,'Klick-Mail 30 Sek.',29.000);
-INSERT INTO `{?_MYSQL_PREFIX?}_payments` VALUES (4,40,40.000,'Klick-Mail 40 Sek.',39.000);
-INSERT INTO `{?_MYSQL_PREFIX?}_payments` VALUES (5,50,50.000,'Klick-Mail 50 Sek.',49.000);
+INSERT INTO `{?_MYSQL_PREFIX?}_payments` (`time`,`payment`,`mail_title`,`price`) VALUES (10,1.000,'Klick-Mail 10 Sek.',2.000);
+INSERT INTO `{?_MYSQL_PREFIX?}_payments` (`time`,`payment`,`mail_title`,`price`) VALUES (20,5.000,'Klick-Mail 20 Sek.',10.000);
+INSERT INTO `{?_MYSQL_PREFIX?}_payments` (`time`,`payment`,`mail_title`,`price`) VALUES (30,25.000,'Klick-Mail 30 Sek.',30.000);
+INSERT INTO `{?_MYSQL_PREFIX?}_payments` (`time`,`payment`,`mail_title`,`price`) VALUES (40,35.000,'Klick-Mail 40 Sek.',40.000);
+INSERT INTO `{?_MYSQL_PREFIX?}_payments` (`time`,`payment`,`mail_title`,`price`) VALUES (50,45.000,'Klick-Mail 50 Sek.',50.000);
 
-INSERT INTO `{?_MYSQL_PREFIX?}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('email','del_email','E-Mail l&ouml;schen','L&ouml;schen Sie hierr&uuml;ber E-Mails (sowohl Bonus- als auch Normal-Mails) aus Ihrem Mailtausch-System. <strong>Nur bei Normal-Mails:</strong> {OPEN_CONFIG}POINTS{CLOSE_CONFIG} aus den unbest&auml;tigten Mails werden dem Werber wieder verg&uuml;tet.','7');
+INSERT INTO `{?_MYSQL_PREFIX?}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('email','del_email','E-Mail l&ouml;schen','L&ouml;schen Sie hierr&uuml;ber E-Mails (sowohl Bonus- als auch Normal-Mails) aus Ihrem {?mt_word?}-System. <strong>Nur bei Normal-Mails:</strong> {OPEN_CONFIG}POINTS{CLOSE_CONFIG} aus den unbest&auml;tigten Mails werden dem Werber wieder verg&uuml;tet.','7');
 INSERT INTO `{?_MYSQL_PREFIX?}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('misc','extensions','Erweiterungen','Erweiterungen installieren, updaten, sperren, l&ouml;schen usw.','8');
 
 INSERT INTO `{?_MYSQL_PREFIX?}_guest_menu` (`action`,`what`,`title`,`sort`,`visible`,`locked`) VALUES ('main','stats','Statistiken','7','Y','N');