Full insert SQLs may prevent problems in the future...

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

diff --git a/install/menu-en.sql b/install/menu-en.sql
index 4efe69ab55e2e995f97c9e644b6b9f53f0952302..6257f10a2d534e9a138f4403dfca57b8b8a8b01a 100644 (file)
--- a/install/menu-en.sql
+++ b/install/menu-en.sql
@@ -13,29 +13,29 @@ 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');
@@ -47,18 +47,18 @@ 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');
@@ -68,20 +68,17 @@ INSERT INTO `{?_MYSQL_PREFIX?}_member_menu` (`action`,`what`,`title`,`sort`,`vis
 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?}_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,2.000,'Klick-Mail 10 Sek.',1.000);
+INSERT INTO `{?_MYSQL_PREFIX?}_payments` (`time`,`payment`,`mail_title`,`price`) VALUES (20,10.000,'Klick-Mail 20 Sek.',9.000);
+INSERT INTO `{?_MYSQL_PREFIX?}_payments` (`time`,`payment`,`mail_title`,`price`) VALUES (30,30.000,'Klick-Mail 30 Sek.',29.000);
+INSERT INTO `{?_MYSQL_PREFIX?}_payments` (`time`,`payment`,`mail_title`,`price`) VALUES (40,40.000,'Klick-Mail 40 Sek.',39.000);
+INSERT INTO `{?_MYSQL_PREFIX?}_payments` (`time`,`payment`,`mail_title`,`price`) VALUES (50,50.000,'Klick-Mail 50 Sek.',49.000);
 
-INSERT INTO `{?_MYSQL_PREFIX?}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('email','email_archiv','E-Mail Archiv','Sehen Sie sich hier bereits gesendete Mails an.','6');
-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');