aboutsummaryrefslogtreecommitdiff
diff options
context:
space:
mode:
-rw-r--r--admin.php2
-rw-r--r--config.php.example3
-rw-r--r--dbinit.sql2
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`)
);