aboutsummaryrefslogtreecommitdiff
path: root/src/main/resources
diff options
context:
space:
mode:
Diffstat (limited to 'src/main/resources')
-rw-r--r--src/main/resources/db/migration/V1.46__premium_users.sql1
-rw-r--r--src/main/resources/schema-h2.sql1
-rw-r--r--src/main/resources/schema-mysql.sql1
-rw-r--r--src/main/resources/schema-sqlite.sql1
-rw-r--r--src/main/resources/schema-sqlserver.sql1
-rw-r--r--src/main/resources/templates/views/partial/message.html2
-rw-r--r--src/main/resources/templates/views/partial/navigation.html3
-rw-r--r--src/main/resources/templates/views/thread.html4
8 files changed, 11 insertions, 3 deletions
diff --git a/src/main/resources/db/migration/V1.46__premium_users.sql b/src/main/resources/db/migration/V1.46__premium_users.sql
new file mode 100644
index 00000000..11edb121
--- /dev/null
+++ b/src/main/resources/db/migration/V1.46__premium_users.sql
@@ -0,0 +1 @@
+alter table users add column premium smallint not null default (0)::smallint;
diff --git a/src/main/resources/schema-h2.sql b/src/main/resources/schema-h2.sql
index ea979df1..8b786382 100644
--- a/src/main/resources/schema-h2.sql
+++ b/src/main/resources/schema-h2.sql
@@ -66,6 +66,7 @@ CREATE MEMORY TABLE "PUBLIC"."USERS"(
"LASTPM" INTEGER DEFAULT '0' NOT NULL,
"LASTPHOTO" INTEGER DEFAULT '0' NOT NULL,
"KARMA" SMALLINT DEFAULT '0' NOT NULL,
+ "PREMIUM" SMALLINT DEFAULT '0' NOT NULL,
"LAST_SEEN" TIMESTAMP(6)
);
ALTER TABLE "PUBLIC"."USERS" ADD CONSTRAINT "PUBLIC"."CONSTRAINT_4" PRIMARY KEY("ID");
diff --git a/src/main/resources/schema-mysql.sql b/src/main/resources/schema-mysql.sql
index e458203f..d0943254 100644
--- a/src/main/resources/schema-mysql.sql
+++ b/src/main/resources/schema-mysql.sql
@@ -558,6 +558,7 @@ CREATE TABLE `users` (
`lastpm` int(11) NOT NULL DEFAULT 0,
`lastphoto` int(11) NOT NULL DEFAULT 0,
`karma` smallint(6) NOT NULL DEFAULT 0,
+ `premium` smallint default '0' not null,
`last_seen` timestamp(6) NULL DEFAULT NULL,
PRIMARY KEY (`id`),
UNIQUE KEY `nick` (`nick`)
diff --git a/src/main/resources/schema-sqlite.sql b/src/main/resources/schema-sqlite.sql
index 84ad015c..ae1f4317 100644
--- a/src/main/resources/schema-sqlite.sql
+++ b/src/main/resources/schema-sqlite.sql
@@ -227,6 +227,7 @@ CREATE TABLE users (
lastpm bigint DEFAULT (0) NOT NULL,
lastphoto bigint DEFAULT (0) NOT NULL,
karma smallint DEFAULT (0) NOT NULL,
+ premium smallint DEFAULT (0) NOT NULL,
last_seen timestamp with time zone,
UNIQUE(nick)
);
diff --git a/src/main/resources/schema-sqlserver.sql b/src/main/resources/schema-sqlserver.sql
index 4a683189..34032b67 100644
--- a/src/main/resources/schema-sqlserver.sql
+++ b/src/main/resources/schema-sqlserver.sql
@@ -8,6 +8,7 @@ CREATE TABLE users (
lastpm bigint DEFAULT (0) NOT NULL,
lastphoto bigint DEFAULT (0) NOT NULL,
karma smallint DEFAULT (0) NOT NULL,
+ premium smallint DEFAULT (0) NOT NULL,
last_seen datetimeoffset,
UNIQUE(nick),
PRIMARY KEY (id)
diff --git a/src/main/resources/templates/views/partial/message.html b/src/main/resources/templates/views/partial/message.html
index 9d54d614..e9ddd3db 100644
--- a/src/main/resources/templates/views/partial/message.html
+++ b/src/main/resources/templates/views/partial/message.html
@@ -1,7 +1,7 @@
<article class="msg-cont" data-mid="{{ msg.mid }}">
<header class="h">
<span>
- <a href="/{{ msg.user.name }}/"><span>{{ msg.user.name }}</span></a>
+ <a href="/{{ msg.user.name }}/"><span>{{ msg.user.name }}</span>{% if msg.user.premium %}<span style="color: green;"><i data-icon="ei-star" data-size="s"></i></span>{% endif %}</a>
</span>
<div class="msg-avatar"><a href="/{{ msg.user.name }}/">
<img src="{{ msg.user.avatar }}" alt="{{ msg.user.name }}"/></a>
diff --git a/src/main/resources/templates/views/partial/navigation.html b/src/main/resources/templates/views/partial/navigation.html
index 159c3d21..105cc568 100644
--- a/src/main/resources/templates/views/partial/navigation.html
+++ b/src/main/resources/templates/views/partial/navigation.html
@@ -4,6 +4,9 @@
<div id="ctitle">
<a href="/{{ visitor.name }}/">
<img src="{{ visitor.avatar }}" alt=""/>{{ visitor.name }}
+ {% if visitor.premium %}
+ <span style="color: green;"><i data-icon="ei-star" data-size="s"></i></span>
+ {% endif %}
{% if not visitor.verified %}
<span style="color: red;"><i data-icon="ei-exclamation" data-size="s"></i></span>
{% endif %}
diff --git a/src/main/resources/templates/views/thread.html b/src/main/resources/templates/views/thread.html
index ca74a2ff..84c52282 100644
--- a/src/main/resources/templates/views/thread.html
+++ b/src/main/resources/templates/views/thread.html
@@ -9,7 +9,7 @@
<a href="/{{ msg.user.name }}/"><img src="{{ msg.user.avatar }}" alt="{{ msg.user.name }}"/></a>
</div>
<span>
- <a href="/{{ msg.user.name }}/"><span>{{ msg.user.name }}</span></a>
+ <a href="/{{ msg.user.name }}/"><span>{{ msg.user.name }}</span>{% if msg.user.premium %}<span style="color: green;"><i data-icon="ei-star" data-size="s"></i></span>{% endif %}</a>
</span>
<div class="msg-ts">
{% if msg.FriendsOnly %}
@@ -129,7 +129,7 @@
<div class="msg-cont">
<div class="msg-header" data-uri="{{ msg.user.uri }}">
{% if not msg.user.banned %}
- <a class="a-username" href="/{{ msg.user.name }}/">{{ msg.user.name }}</a>
+ <a class="a-username" href="/{{ msg.user.name }}/">{{ msg.user.name }}{% if msg.user.premium %}<span style="color: green;"><i data-icon="ei-star" data-size="s"></i></span>{% endif %}</a>
<div class="msg-avatar">
<a class="a-username" href="/{{ msg.user.name }}/">
<img src="{{ msg.user.avatar }}" alt="{{ msg.user.name }}"/>