X-Git-Url: https://git.mxchange.org/?p=mailer.git;a=blobdiff_plain;f=inc%2Fextensions%2Fext-bonus.php;h=7e6d7d444c042edf1515f3ca27d4b7f78334f945;hp=b57f4fced32058f8501dd69183f1939b9826502f;hb=be39a7fb887473487fd2c5f8d550aa03b720cb73;hpb=6f8a68c6c5ed9eeae1bf790f5d758c800b5d5d5d diff --git a/inc/extensions/ext-bonus.php b/inc/extensions/ext-bonus.php index b57f4fced3..7e6d7d444c 100644 --- a/inc/extensions/ext-bonus.php +++ b/inc/extensions/ext-bonus.php @@ -55,7 +55,7 @@ switch (getExtensionMode()) { addAdminMenuSql('email','send_bonus','Bonusmail senden','Versenden Sie hier Bonus-Mails an alle Mitglieder oder nur an alle aus einer Kategorie. Es spielt keine Rolle, wie viele Mails bereits versendet worden, Sie können hier immer senden.', 5); addMemberMenuSql('main','bonus','Bonuspunkte','N','Y',7); addDropTableSql('bonus'); - addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_bonus` ( + addCreateTableSql('bonus', "( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `cat_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, `subject` VARCHAR(255) NOT NULL DEFAULT '', @@ -144,7 +144,7 @@ PRIMARY KEY (`id`) case '0.2.2': // SQL queries for v0.2.2 addDropTableSql('bonus_turbo'); - addExtensionSql("CREATE TABLE `{?_MYSQL_PREFIX?}_bonus_turbo` ( + addCreateTableSql('bonus_turbo', "( `id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT, `userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0, `mail_id` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,