skript-db dosent work and write. | skUnity | Page 1

fervent wyvern Jul 2, 2024, 4:46 PM

#

i use mc 1.20.4

quaint mortar Jul 2, 2024, 6:06 PM

#

you should remove your username/password from the url when sending it online for your privacy
do not update the database every tick! because it’s checking the player count, only update it during a player join/leave event
make sure to verify that the details of the database connection are good

#

and because you’re using an sql database, consider switching to skript’s built in database available in the skript config

ebon spoke Jul 2, 2024, 7:05 PM

#

If you're running 2.8.0+ you gotta use execute unsafe "..." in ...

sonic basin Jul 3, 2024, 6:22 AM

#

Hide your password

ebon spoke Jul 3, 2024, 6:41 AM

#

That's also probably a good idea

fervent wyvern Jul 3, 2024, 9:13 AM

#

ebon spoke If you're running 2.8.0+ you gotta use ``execute unsafe "..." in ...``

ok

fervent wyvern Jul 3, 2024, 9:13 AM

#

sonic basin Hide your password

FUCK

fervent wyvern Jul 3, 2024, 9:13 AM

#

ebon spoke That's also probably a good idea

FR

ebon spoke Jul 3, 2024, 9:13 AM

#

yeah, duh

fervent wyvern Jul 3, 2024, 9:13 AM

#

i am so fucking stupid

#

i switched password

#

to other one

ebon spoke Jul 3, 2024, 9:13 AM

#

you should probably rotate your password

#

or change it

fervent wyvern Jul 3, 2024, 9:14 AM

#

ye i change it to something else rn

fervent wyvern Jul 3, 2024, 9:14 AM

#

ebon spoke you should probably rotate your password

wdym reroll

ebon spoke Jul 3, 2024, 9:14 AM

#

like change it*

fervent wyvern Jul 3, 2024, 9:14 AM

#

i changed it to random stuff

fervent wyvern Jul 3, 2024, 9:15 AM

#

quaint mortar you should remove your username/password from the url when sending it online for...

i dont have ram problom btw

fervent wyvern Jul 3, 2024, 9:15 AM

#

quaint mortar and because you’re using an sql database, consider switching to skript’s built i...

i need to send data from 2 servers

#

from the main to the que

ebon spoke Jul 3, 2024, 9:15 AM

#

that's fine just use the on join and on leave event to update it

fervent wyvern Jul 3, 2024, 9:15 AM

#

ebon spoke If you're running 2.8.0+ you gotta use ``execute unsafe "..." in ...``

i am using the newst

ebon spoke Jul 3, 2024, 9:15 AM

#

ebon spoke If you're running 2.8.0+ you gotta use ``execute unsafe "..." in ...``

also this

#

ah okay, then you gotta use execute unsafe

fervent wyvern Jul 3, 2024, 9:16 AM

#

ok

#

ty

#

utleast i didnt type my ip LOL

#

cus i cant change my ip

ebon spoke Jul 3, 2024, 9:16 AM

#

it's just localhost..

fervent wyvern Jul 3, 2024, 9:18 AM

#

ye

#

but not the numbers

#

lol

#

on script load:
    set {-sql} to the database "mysql://localhost:3306/mydatabase?user=Fornite&password=NotThePassword&useSSL=false"

on join:
    execute unsafe "INSERT INTO table (playerOnlineRP) VALUES (%number of all players%) ON DUPLICATE KEY UPDATE playerOnlineRP=VALUES(playerOnlineRP)" in {-sql}

on leave:
    execute unsafe "INSERT INTO table (playerOnlineRP) VALUES (%number of all players%) ON DUPLICATE KEY UPDATE playerOnlineRP=VALUES(playerOnlineRP)" in {-sql}``` like that?

#

i will use every 1 tick

#

cus if 0 players it will not know

ebon spoke Jul 3, 2024, 9:19 AM

#

you shouldnt use every 1 tick for that

fervent wyvern Jul 3, 2024, 9:20 AM

#

i dont have a problom with ever y1 tick cus it isnt loop all players or loop

#

i used a lot of every 1 tick

ebon spoke Jul 3, 2024, 9:20 AM

#

well then just continue using it

fervent wyvern Jul 3, 2024, 9:21 AM

#

its not like i will have 400 every 1 tick

ebon spoke Jul 3, 2024, 9:21 AM

#

facepalm

fervent wyvern Jul 3, 2024, 9:21 AM

#

i will use on join too

#

what did you send

#

if its in white i cant see it

#

so i will delete this from now

#

bye

ebon spoke Jul 3, 2024, 9:22 AM

#

I sent a face palm emoji.

fervent wyvern Jul 3, 2024, 9:22 AM

#

if it will not work i will open a new one

fervent wyvern Jul 3, 2024, 9:23 AM

#

ebon spoke I sent a face palm emoji.

(my discord in white mode)

#

bye

ebon spoke Jul 3, 2024, 9:23 AM

#

Lord have mercy on your eyes 😬

fervent wyvern Jul 3, 2024, 9:39 AM

#

@ebon spoke

#

it dosent work

ebon spoke Jul 3, 2024, 9:39 AM

#

did you remember to change the password in your code too?

fervent wyvern Jul 3, 2024, 9:39 AM

#

ye

ebon spoke Jul 3, 2024, 9:39 AM

#

hmn... that's weird

#

well it's saying it can't find it

fervent wyvern Jul 3, 2024, 9:40 AM

#

on script load:
set {-sql} to the database "mysql://localhost:3306/mydatabase?user=-----&password=-----&useSSL=false"

every 1 tick:
execute unsafe "INSERT INTO table (playerOnlineRP) VALUES (%number of all players%) ON DUPLICATE KEY UPDATE playerOnlineRP=VALUES(playerOnlineRP)" in {-sql}

on join:
execute unsafe "INSERT INTO table (playerOnlineRP) VALUES (%number of all players%) ON DUPLICATE KEY UPDATE playerOnlineRP=VALUES(playerOnlineRP)" in {-sql}

on leave:
execute unsafe "INSERT INTO table (playerOnlineRP) VALUES (%number of all players%) ON DUPLICATE KEY UPDATE playerOnlineRP=VALUES(playerOnlineRP)" in {-sql}

#

do i need to add 3306 to the lan settings?

ebon spoke Jul 3, 2024, 9:40 AM

#

why do you still have the every 1 tick event

fervent wyvern Jul 3, 2024, 9:40 AM

#

it saying it cant find mydatabase

ebon spoke Jul 3, 2024, 9:40 AM

#

yes, I know

fervent wyvern Jul 3, 2024, 9:40 AM

#

do i need to change it or something

ebon spoke Jul 3, 2024, 9:40 AM

#

yes

fervent wyvern Jul 3, 2024, 9:40 AM

#

wait let me try something

#

i am in heer

#

do i need to do something in heer

#

wait wut

ebon spoke Jul 3, 2024, 9:45 AM

#

fervent wyvern on script load: set {-sql} to the database "mysql://localhost:3306/mydatabas...

you still shouldnt use the every tick event

fervent wyvern Jul 3, 2024, 9:46 AM

#

bro

#

dont look at the every 1 tick

#

do i need to change the mydatabase

ebon spoke Jul 3, 2024, 9:46 AM

#

well then, don't take my help

fervent wyvern Jul 3, 2024, 9:47 AM

#

BRO

#

so who dod i detect when 0 players online

#

@ebon spoke

#

@ebon spoke

#

@ebon spoke

ebon spoke Jul 3, 2024, 9:48 AM

#

Yeah mate you're blocked

fervent wyvern Jul 3, 2024, 9:48 AM

#

why

#

i will not use every 1 tick

#skript-db dosent work and write.