Small fixes

3 files changed, 5 insertions, 2 deletions

diff --git a/admin.php b/admin.php
index a5012b8..24bd448 100644
--- a/admin.php
+++ b/admin.php
@@ -63,7 +63,7 @@ $services = $result->fetch_all(MYSQLI_ASSOC);
                                 <tr><th>name</th><th>type</th><th>billing</th></tr>
                                 <?php
                                 foreach ($services as $service) {
-                                    echo "<tr><td>".$service['name']."</td><td>".$service['type']."</td><td>".$service['billing']."€/mo</tr>\n";
+                                    echo "<tr><td>".$service['name']."</td><td>".$service['type']."</td><td>".$service['billing']."</tr>\n";
                                 }
                                 ?>
                             </table>
diff --git a/config.php.example b/config.php.example
index 6520aaa..7069536 100644
--- a/config.php.example
+++ b/config.php.example
@@ -21,6 +21,9 @@ if($link === false){
     die("ERROR: Could not connect. " . mysqli_connect_error());
 }
 
+require("/usr/share/php/libphp-phpmailer/autoload.php");
+use PHPMailer\PHPMailer\PHPMailer;
+use PHPMailer\PHPMailer\SMTP;
 $mailer = new PHPMailer();
 $mailer->isSMTP();
 $mailer->SMTPDebug = SMTP::DEBUG_SERVER;
diff --git a/dbinit.sql b/dbinit.sql
index bbff3c7..7fdc06e 100644
--- a/dbinit.sql
+++ b/dbinit.sql
@@ -16,7 +16,7 @@ CREATE TABLE `arfnet2`.`services` (
     `id` INT NOT NULL AUTO_INCREMENT ,
     `name` VARCHAR(255) NOT NULL ,
     `type` ENUM('free','standard','premium') NOT NULL ,
-    `billing` TEXT NOT NULL ,
+    `billing` VARCHAR(255) NOT NULL ,
     `description` TEXT NOT NULL ,
     PRIMARY KEY (`id`)
 );