Revert "Fix CraftbukkitWrapper20"

This reverts commit db3f98209e.

CommonCore/SQL/src/de/steamwar/sql/EventFight.kt

@@ -151,9 +151,9 @@ class EventFight(id: EntityID<Int>) : IntEntity(id), Comparable<EventFight> {
     val dependents by lazy { useDb { EventRelation.getFightRelations(this@EventFight).toList() } }
 
     val winner: Team?
-        get() = useDb { if (ergebnis == 1) Team[teamBlue] else if (ergebnis == 2) Team[teamRed] else null }
+        get() = if (ergebnis == 1) Team[teamBlue] else if (ergebnis == 2) Team[teamRed] else null
     val losser: Team?
-        get() = useDb { if (ergebnis == 1) Team[teamRed] else if (ergebnis == 2) Team[teamBlue] else null }
+        get() = if (ergebnis == 1) Team[teamRed] else if (ergebnis == 2) Team[teamBlue] else null
 
     fun setGroup(group: Int?) = useDb { groupId = group?.let { EntityID(it, EventGroupTable) } }
     fun hasFinished() = fight != null || ergebnis != 0

CommonCore/SQL/src/de/steamwar/sql/EventGroup.kt

@@ -90,7 +90,7 @@ class EventGroup(id: EntityID<Int>) : IntEntity(id) {
         set(value) {
             groupPointsPerDraw = value
         }
-    val dependents by lazy { EventRelation.getGroupRelations(this).toList() }
+    val dependents by lazy { EventRelation.getGroupRelations(this) }
     val lastFight by lazy { Optional.ofNullable(fights.maxByOrNull { it.startTime }) }
 
     fun getId() = id.value

CommonCore/SQL/src/de/steamwar/sql/EventRelation.kt

@@ -117,10 +117,10 @@ class EventRelation(id: EntityID<Int>) : IntEntity(id) {
         fromPlace = place
     }
 
-    fun getAdvancingTeam(): Team? = useDb { when(fromType) {
+    fun getAdvancingTeam(): Team? = when(fromType) {
         FromType.FIGHT -> if (fromPlace == 0) fromFight?.winner else fromFight?.losser
         FromType.GROUP -> fromGroup?.calculatePoints()?.toList()?.sortedBy { (_, v) -> v }?.reversed()?.elementAt(fromPlace)?.first
-    } }
+    }
 
     fun apply(): Boolean {
         val team = getAdvancingTeam() ?: return false

CommonCore/SQL/src/de/steamwar/sql/Leaderboard.kt

@@ -1,90 +0,0 @@
-/*
- *   This file is a part of the SteamWar software.
- *
- *   Copyright (C) 2025 SteamWar.de-Serverteam
- *
- *   This program is free software: you can redistribute it and/or modify
- *   it under the terms of the GNU Affero General Public License as published by
- *   the Free Software Foundation, either version 3 of the License, or
- *   (at your option) any later version.
- *
- *   This program is distributed in the hope that it will be useful,
- *   but WITHOUT ANY WARRANTY; without even the implied warranty of
- *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
- *   GNU Affero General Public License for more details.
- *
- *   You should have received a copy of the GNU Affero General Public License
- *   along with this program.  If not, see <https://www.gnu.org/licenses/>.
- */
-
-package de.steamwar.sql
-
-import de.steamwar.sql.internal.useDb
-import org.jetbrains.exposed.v1.core.SortOrder
-import org.jetbrains.exposed.v1.core.and
-import org.jetbrains.exposed.v1.core.count
-import org.jetbrains.exposed.v1.core.dao.id.CompositeID
-import org.jetbrains.exposed.v1.core.dao.id.CompositeIdTable
-import org.jetbrains.exposed.v1.core.dao.id.EntityID
-import org.jetbrains.exposed.v1.core.eq
-import org.jetbrains.exposed.v1.core.lessSubQuery
-import org.jetbrains.exposed.v1.dao.CompositeEntity
-import org.jetbrains.exposed.v1.dao.CompositeEntityClass
-import org.jetbrains.exposed.v1.dao.flushCache
-import org.jetbrains.exposed.v1.javatime.CurrentTimestamp
-import org.jetbrains.exposed.v1.javatime.timestamp
-import org.jetbrains.exposed.v1.jdbc.select
-import org.jetbrains.exposed.v1.jdbc.upsert
-
-object LeaderboardTable : CompositeIdTable("Leaderboard") {
-    val userId = reference("UserId", SteamwarUserTable)
-    val name = varchar("LeaderboardName", 64).entityId()
-    val time = long("Time")
-    val updatedAt = timestamp("UpdatedAt").defaultExpression(CurrentTimestamp)
-    val bestTime = bool("BestTime")
-
-    override val primaryKey = PrimaryKey(userId, name)
-}
-
-class Leaderboard(id: EntityID<CompositeID>) : CompositeEntity(id) {
-    companion object : CompositeEntityClass<Leaderboard>(LeaderboardTable) {
-        @JvmStatic
-        fun getLeaderboard(name: String) = useDb {
-            find { LeaderboardTable.name eq name }.orderBy(LeaderboardTable.time to SortOrder.ASC).limit(5).toList()
-        }
-
-        @JvmStatic
-        fun getPlayerTime(user: SteamwarUser, name: String) = useDb {
-            find { (LeaderboardTable.userId eq user.id.value) and (LeaderboardTable.name eq name) }.firstOrNull()
-        }
-
-        @JvmStatic
-        fun getPlayerPlacement(user: SteamwarUser, name: String) = useDb {
-            LeaderboardTable.select(LeaderboardTable.time.count())
-                .where {
-                    (LeaderboardTable.name eq name) and (LeaderboardTable.time lessSubQuery LeaderboardTable.select(
-                        LeaderboardTable.time
-                    ).where { (LeaderboardTable.userId eq user.id.value) and (LeaderboardTable.name eq name) })
-                }
-                .firstOrNull()?.get(LeaderboardTable.time.count())?.toInt() ?: Int.MAX_VALUE
-        }
-
-        @JvmStatic
-        fun upsert(userId: Int, name: String, time: Long, bestTime: Boolean) = useDb {
-            LeaderboardTable.upsert(
-                onUpdateExclude = listOf(LeaderboardTable.updatedAt, LeaderboardTable.userId, LeaderboardTable.name)
-            ) {
-                it[LeaderboardTable.userId] = userId
-                it[LeaderboardTable.name] = name
-                it[LeaderboardTable.time] = time
-                it[LeaderboardTable.bestTime] = bestTime
-            }
-        }
-    }
-
-    val user by LeaderboardTable.userId.transform({ EntityID(it, SteamwarUserTable) }, { it.value })
-    val name by LeaderboardTable.name
-    var time by LeaderboardTable.time
-    var updatedAt by LeaderboardTable.updatedAt
-    var bestTime by LeaderboardTable.bestTime
-}

CommonCore/SQL/src/de/steamwar/sql/NodeMember.kt

@@ -55,17 +55,6 @@ class NodeMember(id: EntityID<CompositeID>) : CompositeEntity(id) {
             getNodeMember(node, member) ?: throw IllegalStateException("NodeMember not created")
         }
 
-        @JvmStatic
-        fun createNodeMember(node: Int, member: Int, parent: SchematicNode): NodeMember = useDb {
-            if (!parent.isDir()) throw IllegalStateException("Parent must be a directory")
-            NodeMemberTable.insertIgnore {
-                it[this.node] = EntityID(node, SchematicNodeTable)
-                it[this.userId] = EntityID(member, SteamwarUserTable)
-                it[NodeMemberTable.parentNode] = parent.getId()
-            }
-            getNodeMember(node, member) ?: throw IllegalStateException("NodeMember not created")
-        }
-
         @JvmStatic
         fun createNodeMember(node: Int, member: SteamwarUser) = createNodeMember(node, member.id.value)
 
@@ -92,7 +81,6 @@ class NodeMember(id: EntityID<CompositeID>) : CompositeEntity(id) {
     var parent by NodeMemberTable.parentNode.transform(
         { it.map { EntityID(it, SchematicNodeTable) }.getOrNull() },
         { Optional.ofNullable(it?.value) })
-        private set
 
     fun setParentId(id: Int?) {
         parent = Optional.ofNullable(id)

CommonCore/SQL/src/de/steamwar/sql/SchematicNode.kt

@@ -314,7 +314,7 @@ class SchematicNode(id: EntityID<Int>) : IntEntity(id) {
             parentNodeId = value?.let { EntityID(it, SchematicNodeTable) }
         }
     val parentNode: SchematicNode?
-        get() = useDb { parent?.let { findById(it) } }
+        get() = parent?.let { findById(it) }
 
     val optionalParent: Optional<Int> get() = Optional.ofNullable(parent)
     var lastUpdate by SchematicNodeTable.lastUpdate.transform({ it.toInstant() }, { Timestamp.from(it) })

LobbySystem/src/de/steamwar/lobby/boatrace/BoatRace.java

@@ -22,9 +22,8 @@ package de.steamwar.lobby.boatrace;
 import de.steamwar.entity.REntity;
 import de.steamwar.entity.REntityServer;
 import de.steamwar.lobby.LobbySystem;
-import de.steamwar.lobby.util.LeaderboardManager;
-import de.steamwar.sql.Leaderboard;
-import de.steamwar.sql.SteamwarUser;
+import de.steamwar.lobby.util.Leaderboard;
+import de.steamwar.sql.UserConfig;
 import org.bukkit.Bukkit;
 import org.bukkit.Location;
 import org.bukkit.Sound;
@@ -44,18 +43,16 @@ import org.bukkit.scheduler.BukkitTask;
 
 import java.util.EventListener;
 
-import static de.steamwar.lobby.util.LeaderboardManager.renderTime;
+import static de.steamwar.lobby.util.Leaderboard.renderTime;
 
 public class BoatRace implements EventListener, Listener {
 
-    private static final String CONFIG_KEY = "lobby@boatrace";
-
     private static final double MIN_HEIGHT = 4.3;
 
     public static final REntityServer boatNpcServer;
 
     private static boolean oneNotStarted = false;
-    private static final LeaderboardManager leaderboard;
+    private static final Leaderboard leaderboard;
 
     static {
         boatNpcServer = new REntityServer();
@@ -68,7 +65,7 @@ public class BoatRace implements EventListener, Listener {
                 new BoatRace(player);
             }
         });
-        leaderboard = new LeaderboardManager(boatNpcServer, CONFIG_KEY, BoatRacePositions.LEADERBOARD);
+        leaderboard = new Leaderboard(boatNpcServer, "lobby@boatrace", BoatRacePositions.LEADERBOARD, 5);
     }
 
     private final Player player;
@@ -126,11 +123,12 @@ public class BoatRace implements EventListener, Listener {
                 HandlerList.unregisterAll(this);
                 task.cancel();
                 LobbySystem.getMessage().send("BOAT_RACE_TIME", player, renderTime(time));
-                SteamwarUser user = SteamwarUser.get(player.getUniqueId());
-                long best = leaderboard.getPlayerTime(user);
+                String conf = UserConfig.getConfig(player.getUniqueId(), "lobby@boatrace");
+                long best = Long.parseLong(conf == null ? String.valueOf(Long.MAX_VALUE) : conf);
                 if (time < best) {
                     LobbySystem.getMessage().send("BOAT_RACE_NEW_BEST", player);
-                    leaderboard.updateBestTime(user, time);
+                    UserConfig.updatePlayerConfig(player.getUniqueId(), "lobby@boatrace", String.valueOf(time));
+                    leaderboard.update();
                 }
             } else {
                 player.playSound(player.getLocation(), Sound.ENTITY_PLAYER_LEVELUP, 1, 1);

LobbySystem/src/de/steamwar/lobby/jumpandrun/JumpAndRun.java

@@ -22,8 +22,8 @@ package de.steamwar.lobby.jumpandrun;
 import de.steamwar.linkage.Linked;
 import de.steamwar.lobby.LobbySystem;
 import de.steamwar.lobby.listener.PlayerSpawn;
-import de.steamwar.lobby.util.LeaderboardManager;
-import de.steamwar.sql.SteamwarUser;
+import de.steamwar.lobby.util.Leaderboard;
+import de.steamwar.sql.UserConfig;
 import net.md_5.bungee.api.ChatMessageType;
 import org.bukkit.Bukkit;
 import org.bukkit.Location;
@@ -45,7 +45,7 @@ import java.util.*;
 @Linked
 public class JumpAndRun implements Listener {
 
-    public static final String JUMP_AND_RUN_CONFIG = "jump_and_run@winter25";
+    public static final String JUMP_AND_RUN_CONFIG = "jump_and_run";
 
     private static final String BAR_EMPTY = "||||||||||||||||||||||||||||||";
 
@@ -58,7 +58,7 @@ public class JumpAndRun implements Listener {
     private static final Map<Player, Long> CLICKED = new HashMap<>();
     private static final Map<Player, Integer> CLICKED_COUNT = new HashMap<>();
 
-    private static final LeaderboardManager LEADERBOARD = new LeaderboardManager(LobbySystem.getEntityServer(false), JUMP_AND_RUN_CONFIG, new Location(Bukkit.getWorlds().get(0), 2338.5, 42.5, 1231.5));
+    private static final Leaderboard LEADERBOARD = new Leaderboard(LobbySystem.getEntityServer(false), JUMP_AND_RUN_CONFIG, new Location(Bukkit.getWorlds().get(0), 2338.5, 42.5, 1231.5), 5);
 
     {
         Bukkit.getScheduler().runTaskTimer(LobbySystem.getInstance(), () -> {
@@ -161,14 +161,18 @@ public class JumpAndRun implements Listener {
     }
 
     private void updateJumpAndRunTime(Player player, long time) {
-        long best = LEADERBOARD.getPlayerTime(SteamwarUser.get(player.getUniqueId()));
-        if (time < best) {
-            if (best != Long.MAX_VALUE) {
+        String jumpAndRunTimeConfig = UserConfig.getConfig(player.getUniqueId(), JUMP_AND_RUN_CONFIG);
+        if (jumpAndRunTimeConfig == null) {
+            UserConfig.updatePlayerConfig(player.getUniqueId(), JUMP_AND_RUN_CONFIG, time + "");
+        } else {
+            long jumpAndRunTime = Long.parseLong(jumpAndRunTimeConfig);
+            if (time < jumpAndRunTime) {
                 SimpleDateFormat format = new SimpleDateFormat(LobbySystem.getMessage().parse("JUMP_AND_RUN_TIME", player), Locale.ROOT);
-                String parsed = format.format(new Date(best - time));
+                String parsed = format.format(new Date(jumpAndRunTime - time));
                 LobbySystem.getMessage().sendPrefixless("JUMP_AND_RUN_PERSONAL_BEST", player, parsed);
+                UserConfig.updatePlayerConfig(player.getUniqueId(), JUMP_AND_RUN_CONFIG, time + "");
+                LEADERBOARD.update();
             }
-            LEADERBOARD.updateBestTime(SteamwarUser.get(player.getUniqueId()), time);
         }
     }
 

LobbySystem/src/de/steamwar/lobby/special/advent/Present.java

@@ -97,10 +97,9 @@ public class Present {
                 folder = null;
             }
         }
+        NodeMember nodeMember = NodeMember.createNodeMember(schematicId, user.getId());
         if (folder != null) {
-            NodeMember.createNodeMember(schematicId, user.getId(), folder);
-        } else {
-            NodeMember.createNodeMember(schematicId, user.getId());
+            nodeMember.setParent(Optional.of(folder.getId()));
         }
         LobbySystem.getMessage().send("ADVENT_CALENDAR_OPEN", player, node.getName());
         player.playSound(location, Sound.ENTITY_EXPERIENCE_ORB_PICKUP, 1, 1);

LobbySystem/src/de/steamwar/lobby/util/Leaderboard.java

@@ -23,8 +23,9 @@ import de.steamwar.entity.RArmorStand;
 import de.steamwar.entity.REntity;
 import de.steamwar.entity.REntityServer;
 import de.steamwar.lobby.LobbySystem;
-import de.steamwar.sql.Leaderboard;
 import de.steamwar.sql.SteamwarUser;
+import de.steamwar.sql.internal.Statement;
+import lombok.AllArgsConstructor;
 import org.bukkit.Bukkit;
 import org.bukkit.Location;
 import org.bukkit.entity.Player;
@@ -38,18 +39,25 @@ import java.util.HashMap;
 import java.util.List;
 import java.util.Map;
 
-public class LeaderboardManager implements Listener {
+public class Leaderboard implements Listener {
+
+    private static final Statement LEADERBOARD = new Statement("SELECT User, CAST(Value as integer) AS Time from UserConfig WHERE Config = ? ORDER BY CAST(Value as integer) ASC LIMIT ?");
+    private static final Statement PLAYER_TIME = new Statement("SELECT CAST(Value as integer) AS Time FROM UserConfig WHERE Config = ? AND User = ?");
+    private static final Statement PLAYER_PLACEMENT = new Statement("SELECT COUNT(*) AS Placement FROM UserConfig WHERE Config = ? AND CAST(Value as integer) < (SELECT CAST(Value as integer) AS Time FROM UserConfig WHERE Config = ? AND User = ?)");
+
     private final REntityServer server;
     private final String configKey;
     private final Location location;
+    private final int best;
     private long bestTime;
     private final List<REntity> entities = new ArrayList<>();
     private final Map<Integer, REntityServer> playerPlacements = new HashMap<>();
 
-    public LeaderboardManager(REntityServer server, String configKey, Location location) {
+    public Leaderboard(REntityServer server, String configKey, Location location, int best) {
         this.server = server;
         this.configKey = configKey;
         this.location = location;
+        this.best = best;
         Bukkit.getPluginManager().registerEvents(this, LobbySystem.getInstance());
         update();
     }
@@ -57,23 +65,20 @@ public class LeaderboardManager implements Listener {
     public void update() {
         entities.forEach(REntity::die);
         entities.clear();
-        List<Leaderboard> leaderboard = getLeaderboard();
-        if (leaderboard.isEmpty()) {
-            bestTime = Long.MAX_VALUE;
-            return;
-        }
-        bestTime = leaderboard.get(0).getTime();
+        List<LeaderboardEntry> leaderboard = getLeaderboard();
+        if (leaderboard.isEmpty()) return;
+        bestTime = leaderboard.get(0).time;
         for (int i = 0; i < leaderboard.size(); i++) {
-            Leaderboard entry = leaderboard.get(i);
+            LeaderboardEntry entry = leaderboard.get(i);
             RArmorStand entity = new RArmorStand(server, location.clone().add(0, (leaderboard.size() - i - 1) * 0.32, 0), RArmorStand.Size.MARKER);
-            SteamwarUser user = SteamwarUser.byId(entry.getUser());
+            SteamwarUser user = SteamwarUser.byId(entry.user);
             String color = "§7";
             if (i == 0) {
                 color = "§6§l";
             } else if (i < 3) {
                 color = "§e";
             }
-            entity.setDisplayName(calcName(user, color, i + 1, entry.getTime()));
+            entity.setDisplayName(calcName(user, color, i + 1, entry.time));
             entity.setInvisible(true);
             entities.add(entity);
         }
@@ -130,27 +135,32 @@ public class LeaderboardManager implements Listener {
         return st.toString();
     }
 
-    private boolean isNewBestTime(long time) {
-        return time < bestTime;
+    private List<LeaderboardEntry> getLeaderboard() {
+        return LEADERBOARD.select(resultSet -> {
+            List<LeaderboardEntry> leaderboard = new ArrayList<>();
+            while (resultSet.next()) {
+                leaderboard.add(new LeaderboardEntry(resultSet.getInt("User"), resultSet.getLong("Time")));
+            }
+            return leaderboard;
+        }, configKey, best);
     }
 
-    public void updateBestTime(SteamwarUser user, long time) {
-        Leaderboard.upsert(user.getId(), configKey, time, isNewBestTime(time));
-        update();
-    }
-
-    private List<Leaderboard> getLeaderboard() {
-        return Leaderboard.getLeaderboard(configKey);
-    }
-
-    public long getPlayerTime(SteamwarUser user) {
-        Leaderboard lb = Leaderboard.getPlayerTime(user, configKey);
-        if(lb != null) return lb.getTime();
+    private long getPlayerTime(SteamwarUser user) {
+        return PLAYER_TIME.select(resultSet -> {
+            if (!resultSet.next()) {
                 return Long.MAX_VALUE;
             }
+            return resultSet.getLong("Time");
+        }, configKey, user.getId());
+    }
 
     private int getPlayerPlacement(SteamwarUser user) {
-        return Leaderboard.getPlayerPlacement(user, configKey);
+        return PLAYER_PLACEMENT.select(resultSet -> {
+            if (!resultSet.next()) {
+                return Integer.MAX_VALUE;
+            }
+            return resultSet.getInt("Placement");
+        }, configKey, configKey, user.getId());
     }
 
     public static String renderTime(long time) {
@@ -168,6 +178,13 @@ public class LeaderboardManager implements Listener {
                 time % 1000);
     }
 
+    @AllArgsConstructor
+    private class LeaderboardEntry {
+
+        private final int user;
+        private final long time;
+    }
+
     @EventHandler
     public void onPlayerJoin(PlayerJoinEvent event) {
         SteamwarUser steamwarUser = SteamwarUser.get(event.getPlayer().getUniqueId());

SpigotCore/CompileDummy/src/jdk/internal/misc/Unsafe.java

@@ -0,0 +1,30 @@
+/*
+ *   This file is a part of the SteamWar software.
+ *
+ *   Copyright (C) 2025 SteamWar.de-Serverteam
+ *
+ *   This program is free software: you can redistribute it and/or modify
+ *   it under the terms of the GNU Affero General Public License as published by
+ *   the Free Software Foundation, either version 3 of the License, or
+ *   (at your option) any later version.
+ *
+ *   This program is distributed in the hope that it will be useful,
+ *   but WITHOUT ANY WARRANTY; without even the implied warranty of
+ *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
+ *   GNU Affero General Public License for more details.
+ *
+ *   You should have received a copy of the GNU Affero General Public License
+ *   along with this program.  If not, see <https://www.gnu.org/licenses/>.
+ */
+
+package jdk.internal.misc;
+
+public class Unsafe {
+
+    public static Unsafe getUnsafe() {
+        throw new UnsupportedOperationException();
+    }
+
+    public native Object allocateInstance(Class<?> cls)
+            throws InstantiationException;
+}

SpigotCore/SpigotCore_Main/build.gradle.kts

@@ -30,7 +30,7 @@ dependencies {
     annotationProcessor(libs.classindex)
     compileOnly(project(":CommonCore", "default"))
     compileOnly(project(":CommandFramework", "default"))
-    compileOnly(project(":SpigotCore:CRIUDummy", "default"))
+    compileOnly(project(":SpigotCore:CompileDummy", "default"))
 
     compileOnly(libs.worldedit12)
 

SpigotCore/SpigotCore_Main/src/de/steamwar/sql/SQLWrapperImpl.java

@@ -30,7 +30,6 @@ import java.io.File;
 import java.util.Arrays;
 import java.util.List;
 import java.util.stream.Collectors;
-import java.util.stream.Stream;
 
 public class SQLWrapperImpl implements SQLWrapper<Material> {
 
@@ -46,11 +45,9 @@ public class SQLWrapperImpl implements SQLWrapper<Material> {
 
     @Override
     public List<Material> getMaterialWithGreaterBlastResistance(double maxBlastResistance) {
-        Stream<Material> stream = Arrays.stream(Material.values());
-        if (Core.getVersion() > 12) {
-            stream = stream.filter(material -> !material.isLegacy());
-        }
-        return stream.filter(Material::isBlock)
+        return Arrays.stream(Material.values())
+                .filter(material -> !material.isLegacy())
+                .filter(Material::isBlock)
                 .filter(material -> material.getBlastResistance() > maxBlastResistance)
                 .collect(Collectors.toList());
     }

WebsiteBackend/src/de/steamwar/Application.kt

@@ -20,9 +20,12 @@
 package de.steamwar
 
 import de.steamwar.plugins.configurePlugins
+import de.steamwar.routes.ResponseUser
+import de.steamwar.routes.SchematicCode
 import io.ktor.server.application.*
 import io.ktor.server.engine.*
 import de.steamwar.routes.configureRoutes
+import de.steamwar.sql.SchematicType
 import de.steamwar.sql.SteamwarUser
 import io.ktor.server.netty.*
 import kotlinx.serialization.ExperimentalSerializationApi
@@ -44,6 +47,7 @@ fun main() {
     Thread {
         while (true) {
             Thread.sleep(1000 * 10)
+            ResponseUser.clearCache()
             SteamwarUser.clear()
         }
     }.start()

WebsiteBackend/src/de/steamwar/routes/AuditLog.kt

@@ -1,215 +0,0 @@
-/*
- *   This file is a part of the SteamWar software.
- *
- *   Copyright (C) 2025 SteamWar.de-Serverteam
- *
- *   This program is free software: you can redistribute it and/or modify
- *   it under the terms of the GNU Affero General Public License as published by
- *   the Free Software Foundation, either version 3 of the License, or
- *   (at your option) any later version.
- *
- *   This program is distributed in the hope that it will be useful,
- *   but WITHOUT ANY WARRANTY; without even the implied warranty of
- *   MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE. See the
- *   GNU Affero General Public License for more details.
- *
- *   You should have received a copy of the GNU Affero General Public License
- *   along with this program.  If not, see <https://www.gnu.org/licenses/>.
- */
-
-package de.steamwar.routes
-
-import de.steamwar.plugins.SWPermissionCheck
-import de.steamwar.sql.AuditLog
-import de.steamwar.sql.AuditLogTable
-import de.steamwar.sql.SteamwarUserTable
-import de.steamwar.sql.UserPerm
-import de.steamwar.sql.internal.useDb
-import io.ktor.server.application.call
-import io.ktor.server.application.install
-import io.ktor.server.response.respond
-import io.ktor.server.routing.Route
-import io.ktor.server.routing.get
-import io.ktor.server.routing.route
-import kotlinx.serialization.Serializable
-import org.jetbrains.exposed.v1.core.Alias
-import org.jetbrains.exposed.v1.core.JoinType
-import org.jetbrains.exposed.v1.core.SortOrder
-import org.jetbrains.exposed.v1.core.alias
-import org.jetbrains.exposed.v1.core.greater
-import org.jetbrains.exposed.v1.core.inList
-import org.jetbrains.exposed.v1.core.isNull
-import org.jetbrains.exposed.v1.core.less
-import org.jetbrains.exposed.v1.core.like
-import org.jetbrains.exposed.v1.core.or
-import org.jetbrains.exposed.v1.jdbc.Query
-import org.jetbrains.exposed.v1.jdbc.andWhere
-import org.jetbrains.exposed.v1.jdbc.select
-import org.jetbrains.exposed.v1.jdbc.selectAll
-import java.time.Instant
-
-fun Route.configureAuditLog() {
-    route("/auditlog") {
-        install(SWPermissionCheck) {
-            mustAuth = true
-            permission = UserPerm.MODERATION
-        }
-
-        get {
-            val text = call.request.queryParameters["fullText"]
-            val actionText = call.request.queryParameters["actionText"]
-            val serverText = call.request.queryParameters["server"]
-            val actor = call.request.queryParameters.getAll("actor")?.map { it.toInt() }?.toSet()
-            val actionType =
-                call.request.queryParameters.getAll("actionType")?.map { AuditLog.Type.valueOf(it) }?.toSet()
-            val timeGreater = call.request.queryParameters["timeGreater"]?.let { Instant.ofEpochMilli(it.toLong()) }
-            val timeLess = call.request.queryParameters["timeLess"]?.let { Instant.ofEpochMilli(it.toLong()) }
-
-            val serverOwner = call.request.queryParameters.getAll("serverOwner")?.map { it.toInt() }?.toSet()
-            val velocity = call.request.queryParameters["velocity"]?.toBoolean()
-
-            val page = call.request.queryParameters["page"]?.toIntOrNull() ?: 0
-            val limit = call.request.queryParameters["limit"]?.toIntOrNull() ?: 100
-            val sorting = call.request.queryParameters["sorting"] ?: "DESC"
-
-            call.respond(
-                PagedAuditLog.filter(
-                    actionText,
-                    serverText,
-                    text,
-                    actor,
-                    actionType,
-                    timeGreater,
-                    timeLess,
-                    serverOwner,
-                    velocity,
-                    page,
-                    limit,
-                    sorting
-                )
-            )
-        }
-    }
-}
-
-@Serializable
-data class PagedAuditLog(val rows: Long, val entries: List<AuditLogEntry>) {
-
-    companion object {
-        fun filter(
-            actionText: String? = null,
-            serverText: String? = null,
-            fullText: String? = null,
-            actor: Set<Int>? = null,
-            actionType: Set<AuditLog.Type>? = null,
-            timeGreater: Instant? = null,
-            timeLess: Instant? = null,
-            serverOwner: Set<Int>? = null,
-            velocity: Boolean? = null,
-            page: Int = 0,
-            limit: Int = 100,
-            sorting: String = "DESC"
-        ) = useDb {
-            val actorTable = SteamwarUserTable.alias("actor")
-            val serverOwnerTable = SteamwarUserTable.alias("serverOwner")
-
-            val query = AuditLogTable.join(
-                actorTable,
-                JoinType.INNER,
-                onColumn = actorTable[SteamwarUserTable.id],
-                otherColumn = AuditLogTable.actor
-            )
-                .join(
-                    serverOwnerTable,
-                    JoinType.LEFT,
-                    onColumn = serverOwnerTable[SteamwarUserTable.id],
-                    otherColumn = AuditLogTable.serverOwner
-                )
-                .select(
-                    actorTable[SteamwarUserTable.username], serverOwnerTable[SteamwarUserTable.username],
-                    *AuditLogTable.columns.toTypedArray()
-                )
-
-            PagedAuditLog(
-                AuditLogTable.selectAll().addAuditLogFilters(
-                    actionText,
-                    serverText,
-                    fullText,
-                    actor,
-                    actionType,
-                    timeGreater,
-                    timeLess,
-                    serverOwner,
-                    velocity
-                ).count(),
-                query
-                    .addAuditLogFilters(
-                        actionText,
-                        serverText,
-                        fullText,
-                        actor,
-                        actionType,
-                        timeGreater,
-                        timeLess,
-                        serverOwner,
-                        velocity
-                    )
-                    .limit(limit)
-                    .offset((page * limit).toLong())
-                    .orderBy(AuditLogTable.time, SortOrder.valueOf(sorting.uppercase()))
-                    .map {
-                        AuditLogEntry(
-                            it[AuditLogTable.id].value,
-                            it[AuditLogTable.time].toEpochMilli(),
-                            it[AuditLogTable.server],
-                            it[serverOwnerTable[SteamwarUserTable.username]],
-                            it[actorTable[SteamwarUserTable.username]],
-                            it[AuditLogTable.action],
-                            it[AuditLogTable.actionText]
-                        )
-                    },
-            )
-        }
-
-        private fun Query.addAuditLogFilters(
-            actionText: String? = null,
-            serverText: String? = null,
-            fullText: String? = null,
-            actor: Set<Int>? = null,
-            actionType: Set<AuditLog.Type>? = null,
-            timeGreater: Instant? = null,
-            timeLess: Instant? = null,
-            serverOwner: Set<Int>? = null,
-            velocity: Boolean? = null,
-        ): Query {
-            actionText?.let {
-                andWhere { (AuditLogTable.actionText like "%$it%") }
-            }
-            serverText?.let {
-                andWhere { (AuditLogTable.server like "%$it%") }
-            }
-            fullText?.let {
-                andWhere { (AuditLogTable.actionText like "%$it%") or (AuditLogTable.server like "%$it%") }
-            }
-            actor?.let { andWhere { AuditLogTable.actor inList actor } }
-            actionType?.let { andWhere { AuditLogTable.action inList actionType } }
-            timeGreater?.let { andWhere { AuditLogTable.time greater timeGreater } }
-            timeLess?.let { andWhere { AuditLogTable.time less timeLess } }
-            serverOwner?.let { andWhere { AuditLogTable.serverOwner inList serverOwner } }
-            if (velocity == true) andWhere { AuditLogTable.serverOwner.isNull() }
-
-            return this
-        }
-    }
-}
-
-@Serializable
-data class AuditLogEntry(
-    val id: Int,
-    val time: Long,
-    val server: String,
-    val serverOwner: String?,
-    val actor: String,
-    val actionType: AuditLog.Type,
-    val actionText: String
-)

WebsiteBackend/src/de/steamwar/routes/Auth.kt

@@ -66,7 +66,7 @@ fun Route.configureAuth() {
             }
 
             call.sessions.set(SWUserSession(user.getId()))
-            call.respond(ResponseUser(user))
+            call.respond(ResponseUser.get(user))
         }
 
         delete {
@@ -100,7 +100,7 @@ fun Route.configureAuth() {
                 }
 
                 call.sessions.set(SWUserSession(user.getId()))
-                call.respond(ResponseUser(user))
+                call.respond(ResponseUser.get(user))
             }
         }
     }

WebsiteBackend/src/de/steamwar/routes/Data.kt

@@ -25,7 +25,6 @@ import de.steamwar.plugins.SWAuthPrincipal
 import de.steamwar.plugins.SWPermissionCheck
 import de.steamwar.sql.SchematicType
 import de.steamwar.sql.SteamwarUser
-import de.steamwar.sql.SteamwarUserTable
 import de.steamwar.sql.Team
 import de.steamwar.sql.UserPerm
 import de.steamwar.sql.internal.useDb
@@ -37,13 +36,6 @@ import io.ktor.server.response.*
 import io.ktor.server.routing.*
 import kotlinx.serialization.Serializable
 import org.bspfsystems.yamlconfiguration.file.YamlConfiguration
-import org.jetbrains.exposed.v1.core.ResultRow
-import org.jetbrains.exposed.v1.core.eq
-import org.jetbrains.exposed.v1.core.inList
-import org.jetbrains.exposed.v1.core.like
-import org.jetbrains.exposed.v1.jdbc.Query
-import org.jetbrains.exposed.v1.jdbc.andWhere
-import org.jetbrains.exposed.v1.jdbc.selectAll
 import java.io.File
 import java.net.InetSocketAddress
 import java.util.*
@@ -52,39 +44,28 @@ import java.util.*
 data class ResponseSchematicType(val name: String, val db: String)
 
 @Serializable
-data class ResponseUser(
-    val name: String, val uuid: String, val id: Int?, val perms: List<String>?, val prefix: String?
-) {
-    constructor(user: SteamwarUser, includeId: Boolean = false, includePerms: Boolean = false) : this(
-        user.userName,
-        user.uuid.toString(),
-        if (includeId) user.getId() else null,
-        if (includePerms) user.perms().map { it.name } else null,
-        if (includePerms) user.prefix().chatPrefix else null,
-    )
+data class ResponseUser(val name: String, val uuid: String, val prefix: String, val perms: List<String>) {
+    private constructor(user: SteamwarUser) : this(user.userName, user.uuid.toString(), user.prefix().chatPrefix, user.perms().filter { !it.name.startsWith("PREFIX_") }.map { it.name })
 
-    constructor(row: ResultRow, includeId: Boolean = false, includePerms: Boolean = false, prefixes: MutableSet<UserPerm> = mutableSetOf()) : this(
-        row[SteamwarUserTable.username],
-        row[SteamwarUserTable.uuid],
-        if (includeId) row[SteamwarUserTable.id].value else null,
-        if (includePerms) UserPerm.getPerms(row[SteamwarUserTable.id].value).also { prefixes.addAll(it) }.map { it.name } else null,
-        if (includePerms) prefixes.firstOrNull { UserPerm.prefixes.containsKey(it) }?.let { UserPerm.prefixes[it]!!.chatPrefix } else null
-    )
-}
+    companion object {
+        private val cache = mutableMapOf<Int, ResponseUser>()
 
-@Serializable
-data class ResponseUserList(val entries: List<ResponseUser>, val rows: Long)
+        fun get(id: Int): ResponseUser {
+            synchronized(cache) {
+                return cache[id] ?: ResponseUser(SteamwarUser.byId(id)!!).also { cache[id] = it }
+            }
+        }
 
-private fun Query.addUserFilter(
-    name: String? = null,
-    uuid: UUID? = null,
-    team: Set<Int>? = null,
-): Query {
-    name?.let { andWhere { (SteamwarUserTable.username like "%$it%") } }
-    uuid?.let { andWhere { (SteamwarUserTable.uuid eq it.toString()) } }
-    team?.let { andWhere { (SteamwarUserTable.team inList team) } }
+        fun get(user: SteamwarUser): ResponseUser = synchronized(cache) {
+            return cache[user.getId()] ?: ResponseUser(user).also { cache[user.getId()] = it }
+        }
 
-    return this
+        fun clearCache() {
+            synchronized(cache) {
+                cache.clear()
+            }
+        }
+    }
 }
 
 fun Route.configureDataRoutes() {
@@ -95,33 +76,13 @@ fun Route.configureDataRoutes() {
                 permission = UserPerm.MODERATION
             }
             get("/users") {
-                val name = call.request.queryParameters["name"]
-                val uuid = call.request.queryParameters["uuid"]?.let { catchException { UUID.fromString(it) } }
-                val team = call.request.queryParameters.getAll("team")?.map { it.toInt() }?.toSet()
-
-                val limit = call.request.queryParameters["limit"]?.toIntOrNull() ?: 100
-                val page = call.request.queryParameters["page"]?.toIntOrNull() ?: 0
-
-                val includePerms = call.request.queryParameters["includePerms"]?.toBoolean() ?: false
-                val includeId = call.request.queryParameters["includeId"]?.toBoolean() ?: false
-
-                call.respond(
-                    useDb {
-                        ResponseUserList(
-                            SteamwarUserTable.selectAll().addUserFilter(name, uuid, team).limit(limit)
-                                .offset((page * limit).toLong())
-                                .map { ResponseUser(it, includeId, includePerms) },
-                            SteamwarUserTable.selectAll().addUserFilter(name, uuid, team).count()
-                        )
-                    }
-                )
+                call.respond(useDb { SteamwarUser.all().map { ResponseUser.get(it) } })
             }
             get("/teams") {
                 call.respond(Team.getAll().map { ResponseTeam(it) })
             }
             get("/schematicTypes") {
-                call.respond(SchematicType.values().filter { !it.check() }
-                    .map { ResponseSchematicType(it.name(), it.toDB()) })
+                call.respond(SchematicType.values().filter { !it.check() }.map { ResponseSchematicType(it.name(), it.toDB()) })
             }
             get("/gamemodes") {
                 call.respond(
@@ -155,14 +116,11 @@ fun Route.configureDataRoutes() {
         }
         get("/team") {
             call.respond(
-                listOf(
-                    UserPerm.PREFIX_ADMIN,
-                    UserPerm.PREFIX_DEVELOPER,
-                    UserPerm.PREFIX_MODERATOR,
-                    UserPerm.PREFIX_SUPPORTER,
-                    UserPerm.PREFIX_BUILDER
-                ).associateWith { SteamwarUser.getUsersWithPerm(it) }.mapKeys { UserPerm.prefixes[it.key]!!.chatPrefix }
-                    .mapValues { it.value.map { ResponseUser(it) } })
+                listOf(UserPerm.PREFIX_ADMIN, UserPerm.PREFIX_DEVELOPER, UserPerm.PREFIX_MODERATOR, UserPerm.PREFIX_SUPPORTER, UserPerm.PREFIX_BUILDER)
+                    .associateWith { SteamwarUser.getUsersWithPerm(it) }
+                    .mapKeys { UserPerm.prefixes[it.key]!!.chatPrefix }
+                    .mapValues { it.value.map { ResponseUser.get(it) } }
+            )
         }
         get("/skin/{uuid}") {
             val uuid = call.parameters["uuid"]
@@ -180,7 +138,7 @@ fun Route.configureDataRoutes() {
         route("/me") {
             install(SWPermissionCheck)
             get {
-                call.respond(ResponseUser(call.principal<SWAuthPrincipal>()!!.user, includePerms = true))
+                call.respond(ResponseUser.get(call.principal<SWAuthPrincipal>()!!.user))
             }
         }
     }

WebsiteBackend/src/de/steamwar/routes/EventReferees.kt

@@ -31,7 +31,7 @@ fun Route.configureEventRefereesRouting() {
     route("/referees") {
         get {
             val event = call.receiveEvent() ?: return@get
-            call.respond(Referee.get(event.eventID).map { ResponseUser(SteamwarUser.byId(it)!!) })
+            call.respond(Referee.get(event.eventID).map { ResponseUser.get(SteamwarUser.byId(it)!!) })
         }
         put {
             val event = call.receiveEvent() ?: return@put
@@ -39,7 +39,7 @@ fun Route.configureEventRefereesRouting() {
             referees.forEach {
                 Referee.add(event.eventID, SteamwarUser.get(UUID.fromString(it))!!.getId())
             }
-            call.respond(Referee.get(event.eventID).map { ResponseUser(SteamwarUser.byId(it)!!) })
+            call.respond(Referee.get(event.eventID).map { ResponseUser.get(SteamwarUser.byId(it)!!) })
         }
         delete {
             val event = call.receiveEvent() ?: return@delete
@@ -47,7 +47,7 @@ fun Route.configureEventRefereesRouting() {
             referees.forEach {
                 Referee.remove(event.eventID, SteamwarUser.get(UUID.fromString(it))!!.getId())
             }
-            call.respond(Referee.get(event.eventID).map { ResponseUser(SteamwarUser.byId(it)!!) })
+            call.respond(Referee.get(event.eventID).map { ResponseUser.get(SteamwarUser.byId(it)!!) })
         }
     }
 }

WebsiteBackend/src/de/steamwar/routes/Events.kt

@@ -118,7 +118,7 @@ data class ExtendedResponseEvent(
         TeamTeilnahme.getTeams(event.eventID).map { ResponseTeam(it) },
         EventGroup.get(event).map { ResponseGroups(it) },
         EventFight.getEvent(event.eventID).map { ResponseEventFight(it) },
-        Referee.get(event.eventID).map { ResponseUser(SteamwarUser.byId(it)!!) },
+        Referee.get(event.eventID).map { ResponseUser.get(SteamwarUser.byId(it)!!) },
         EventRelation.get(event).map { ResponseRelation(it) }
     )
 }

WebsiteBackend/src/de/steamwar/routes/Routes.kt

@@ -33,7 +33,6 @@ fun Application.configureRoutes() {
             configurePage()
             configureSchematic()
             configureAuth()
-            configureAuditLog()
         }
     }
 }

WebsiteBackend/src/de/steamwar/routes/Schematic.kt

@@ -34,7 +34,9 @@ import io.ktor.server.response.*
 import io.ktor.server.routing.*
 import kotlinx.serialization.Serializable
 import java.io.BufferedInputStream
+import java.io.ByteArrayInputStream
 import java.io.DataInputStream
+import java.io.InputStream
 import java.security.MessageDigest
 import java.time.Duration
 import java.time.Instant
@@ -47,6 +49,16 @@ data class ResponseSchematic(val name: String, val id: Int, val type: String?, v
     constructor(node: SchematicNode) : this(node.name, node.getId(), node.schemtype?.name(), node.owner, node.item, node.lastUpdate.time, node.rank, node.replaceColor(), node.allowReplay())
 }
 
+@Serializable
+data class ResponseSchematicLong(val members: List<ResponseUser>, val path: String, val schem: ResponseSchematic) {
+    constructor(node: SchematicNode, path: String): this(NodeMember.getNodeMembers(node.getId()).map { ResponseUser.get(it.member) }, path, ResponseSchematic(node))
+}
+
+@Serializable
+data class ResponseSchematicList(val breadcrumbs: List<ResponseBreadcrumb>, val schematics: List<ResponseSchematic>, val players: Map<String, ResponseUser>) {
+    constructor(schematics: List<ResponseSchematic>, breadcrumbs: List<ResponseBreadcrumb>) : this(breadcrumbs, schematics, schematics.map { it.owner }.distinct().map { ResponseUser.get(it) }.associateBy { it.uuid })
+}
+
 @Serializable
 data class ResponseBreadcrumb(val name: String, val id: Int)
 

WebsiteBackend/src/de/steamwar/routes/UserPerms.kt

@@ -23,17 +23,11 @@ import de.steamwar.plugins.SWPermissionCheck
 import de.steamwar.plugins.getUser
 import de.steamwar.sql.SteamwarUser
 import de.steamwar.sql.UserPerm
-import io.ktor.http.HttpStatusCode
-import io.ktor.server.application.ApplicationCall
-import io.ktor.server.application.call
-import io.ktor.server.application.install
-import io.ktor.server.response.respond
-import io.ktor.server.routing.Route
-import io.ktor.server.routing.delete
-import io.ktor.server.routing.get
-import io.ktor.server.routing.put
-import io.ktor.server.routing.route
-import kotlinx.serialization.Serializable;
+import io.ktor.http.*
+import io.ktor.server.application.*
+import io.ktor.server.response.*
+import io.ktor.server.routing.*
+import kotlinx.serialization.Serializable
 
 @Serializable
 data class RespondPrefix(val name: String, val colorCode: String, val chatPrefix: String)
@@ -82,12 +76,7 @@ fun Route.configureUserPerms() {
 
                 val prefixs = UserPerm.prefixes[prefix]!!
 
-                call.respond(
-                    RespondUserPermsPrefix(
-                        RespondPrefix(prefix.name, prefixs.colorCode, prefixs.chatPrefix),
-                        perms
-                    )
-                )
+                call.respond(RespondUserPermsPrefix(RespondPrefix(prefix.name, prefixs.colorCode, prefixs.chatPrefix), perms))
             }
             put("/prefix/{prefix}") {
                 val (user, prefix) = call.receivePermission("prefix", isPrefix = true) ?: return@put
@@ -123,10 +112,7 @@ fun Route.configureUserPerms() {
     }
 }
 
-suspend fun ApplicationCall.receivePermission(
-    fieldName: String = "perm",
-    isPrefix: Boolean = false
-): Pair<SteamwarUser, UserPerm>? {
+suspend fun ApplicationCall.receivePermission(fieldName: String = "perm", isPrefix: Boolean = false): Pair<SteamwarUser, UserPerm>? {
     val user = request.getUser()
     if (user == null) {
         respond(HttpStatusCode.BadRequest)

build.gradle.kts

@@ -25,39 +25,3 @@ allprojects {
     group = "de.steamwar"
     version = ""
 }
-
-tasks.register("0_ClearAllGradle") {
-    group = "run"
-    description = "Clears the gradle build caches"
-
-    doLast {
-        File("~/.gradle/").deleteRecursively()
-    }
-}
-
-tasks.register("1_ClearGradleBuilds") {
-    group = "run"
-    description = "Clears the gradle build caches"
-
-    doLast {
-        File("~/.gradle/build-cache-1/").deleteRecursively()
-    }
-}
-
-tasks.register("2_ClearAllGradleDependencies") {
-    group = "run"
-    description = "Clears the dependencies in the .gradle folder"
-
-    doLast {
-        File("~/.gradle/modules-2/files-2.1/").deleteRecursively()
-    }
-}
-
-tasks.register("2_ClearSWGradleDependencies") {
-    group = "run"
-    description = "Clears the dependencies in the .gradle folder"
-
-    doLast {
-        File("~/.gradle/modules-2/files-2.1/de.steamwar/").deleteRecursively()
-    }
-}

settings.gradle.kts

@@ -234,7 +234,7 @@ include(
 
 include(
     "SpigotCore",
-    "SpigotCore:CRIUDummy",
+    "SpigotCore:CompileDummy",
     "SpigotCore:SpigotCore_8",
     "SpigotCore:SpigotCore_9",
     "SpigotCore:SpigotCore_10",