#What's the best database addon for Skript (MySQL / multi-server / Velocity)

1 messages · Page 1 of 1 (latest)

supple jacinth
#

I'm running a Velocity network with multiple Paper 1.21.1 servers.
I use Skript and I want to store a global currency (gems) shared across all servers.

Each server must read/write the same data (MySQL or similar), so if a player has
70 gemmes on Survival, they also have 70 on PvP.

I already have the database set up, but I'm not sure which Skript addon is the
best and most reliable for database usage:

  • skript-db
  • Skellett

What would you recommend ?

Thanks!

dapper quartzBOT
coral ledge
#

I would recommend skript-db but iirc it's not maintained anymore so you have to watch about the versions

spiral heart
#

Skellet is heavily outdated

gray escarp
#

I use MongoSK for this purpose, works great for me

#

Also Redis with SkRedis

supple jacinth
#

Hello,

thanks for the answers so I decided to use skript-db, but I’m facing an issue I don’t understand.

The condition if {_uuid} is not in {_r::uuid::*} is always true, even though the UUID is correctly inserted into the database.

Here is my script:

on join:
wait 1 tick
set {_uuid} to uuid of player

execute "SELECT uuid FROM gemmes" in {db} and store result in {_r::*}

wait 30 ticks

broadcast "%{_r::uuid::*}%"
broadcast "%{_uuid}%"

if {_uuid} is not in {_r::uuid::*}:
    execute unsafe "INSERT INTO gemmes (uuid, amount) VALUES ('%{_uuid}%', 0)" in {db}
    broadcast "&aUUID added to db"

The UUID is added to the database correctly, but the condition still returns true every time.
Am I missing something with skript-db ? and i put the broadcast in screenshot too

Thanks in advance.

image.png image.png
dapper quartzBOT