From 3df6733da9e2c5262c6a264dcf04211fb8b0b55b Mon Sep 17 00:00:00 2001 From: =?utf8?q?Roland=20H=C3=A4der?= Date: Mon, 9 Aug 2010 19:37:31 +0000 Subject: [PATCH] Full insert SQLs may prevent problems in the future... --- install/menu-de.sql | 80 ++++++++++++++++++++++----------------------- install/menu-en.sql | 80 ++++++++++++++++++++++----------------------- 2 files changed, 80 insertions(+), 80 deletions(-) diff --git a/install/menu-de.sql b/install/menu-de.sql index b81286150d..6257f10a2d 100644 --- a/install/menu-de.sql +++ b/install/menu-de.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'); @@ -72,11 +72,11 @@ INSERT INTO `{?_MYSQL_PREFIX?}_member_menu` (`action`,`what`,`title`,`sort`,`vis 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 ('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','del_email','E-Mail löschen','Löschen Sie hierrüber E-Mails (sowohl Bonus- als auch Normal-Mails) aus Ihrem {?mt_word?}-System. Nur bei Normal-Mails: {OPEN_CONFIG}POINTS{CLOSE_CONFIG} aus den unbestätigten Mails werden dem Werber wieder vergütet.','7'); INSERT INTO `{?_MYSQL_PREFIX?}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('misc','extensions','Erweiterungen','Erweiterungen installieren, updaten, sperren, löschen usw.','8'); diff --git a/install/menu-en.sql b/install/menu-en.sql index b81286150d..6257f10a2d 100644 --- 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'); @@ -72,11 +72,11 @@ INSERT INTO `{?_MYSQL_PREFIX?}_member_menu` (`action`,`what`,`title`,`sort`,`vis 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 ('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','del_email','E-Mail löschen','Löschen Sie hierrüber E-Mails (sowohl Bonus- als auch Normal-Mails) aus Ihrem {?mt_word?}-System. Nur bei Normal-Mails: {OPEN_CONFIG}POINTS{CLOSE_CONFIG} aus den unbestätigten Mails werden dem Werber wieder vergütet.','7'); INSERT INTO `{?_MYSQL_PREFIX?}_admin_menu` (`action`,`what`,`title`,`descr`,`sort`) VALUES ('misc','extensions','Erweiterungen','Erweiterungen installieren, updaten, sperren, löschen usw.','8'); -- 2.39.5