Rewrote 2 str_replace() calls to one with array()

[mailer.git] / inc / extensions / wernis / mode-update.php

diff --git a/inc/extensions/wernis/mode-update.php b/inc/extensions/wernis/mode-update.php
index 6be7b14ec70973be32f5ea7cd94941048c943fea..4f431d409d3ad0176d73fb643b119e694906d3e4 100644 (file)
--- a/inc/extensions/wernis/mode-update.php
+++ b/inc/extensions/wernis/mode-update.php
@@ -113,6 +113,27 @@ switch (getCurrentExtensionVersion()) {
                // Update notes
                setExtensionUpdateNotes("Anmeldung ürber WDS66 API angefangen: Filter registriert.");
                break;
+
+       case '0.0.8': // SQL queries for v0.0.8
+               addConfigAddSql('wernis_base_url', "VARCHAR(255) NOT NULL DEFAULT 'http://www.wds66.com'");
+
+               // SQL commands to run
+               addDropTableSql('wernis_regs');
+               addCreateTableSql('wernis_regs', "
+`id` BIGINT(20) UNSIGNED NOT NULL AUTO_INCREMENT,
+`local_userid` BIGINT(20) UNSIGNED NULL DEFAULT NULL,
+`wernis_userid` BIGINT(20) UNSIGNED NOT NULL DEFAULT 0,
+`api_auth_status` VARCHAR(255) NOT NULL DEFAULT 'UNKNOWN',
+`api_auth_key` VARCHAR(255) NOT NULL DEFAULT 'INVALID',
+`api_redirect_challenge` VARCHAR(255) NOT NULL DEFAULT 'INVALID',
+`record_inserted` TIMESTAMP NOT NULL DEFAULT CURRENT_TIMESTAMP,
+PRIMARY KEY (`id`),
+INDEX (`wernis_userid`)",
+                       'Registrations (also pending) over WDS66 API');
+
+               // Update notes (these will be set as task text!)
+               setExtensionUpdateNotes("Basis-URL für alle Scripte (Referral-Link, auth.php-Umleitung usw. nicht aber API) und Tabelle für API-Aufrufe von auth.php hinzugefügt.");
+               break;
 } // END - switch
 
 // [EOF]