From 6bf04fb78dddeef3d95a4dfd7de75546055e04b0 Mon Sep 17 00:00:00 2001
From: arf20 <aruizfernandez05@gmail.com>
Date: Mon, 18 Mar 2024 16:02:34 +0100
Subject: Small fixes

---
 admin.php          | 2 +-
 config.php.example | 3 +++
 dbinit.sql         | 2 +-
 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`)
 );
-- 
cgit v1.2.3