[Release] Supertable [1.3] - A Lightweight MySQL database manager for FX-Server [ST]

FiveM Releases
43

The .lua file already has create table so just rip that part and voilla. But it doesn’t work with other payments which is a shame but…

function Super_First_Run()
local sql = “CREATE TABLE IF NOT EXISTS supertable (id int NOT NULL AUTO_INCREMENT, steamid varchar(255), steamname varchar(255), money int, bank int, banned TINYINT(1), PRIMARY KEY (id))”
local param = {}

print ("SUPERTABLE EXISTS")
    
MySQL.Async.execute(sql, param)
Wait(3000)
Wait(1000)
print ("Ignore these 'errors'. They are expected and SuperTable is functioning properly!")

end

That is the part that adds into the supertable IF it doesn’t exist, maybe handy for you to know.

44

I was asking the same question. I know how to write SQL and php and lua but no matter what i try, it doesn’t change my ‘users’ in the database and it seems that the creator don’t respond as well.
Even the creator needs help as i can see or it is not his script: https://pastebin.com/tTja2uCy

45

I have not been participating in the community for a long time. Sorry and best of luck if you’re still interested in this project use it as a reference point to start your own server management database =)

46

Did this ever get fixed i’m having this issue and nothing i seem to do will correct it.

47

Whenever I try to connect to my server the console spits out the following error message:

grafik
grafik1920×561 37.1 KB

and client side I get the Steam authentication error. It says that “supertable” in my database doesn’t exist. How do I create that table?

48

when i connect to my server.The console print : [MariaDB:10.9.1-MariaDB] [ERROR] [supertable] An error happens for query “SELECT money FROM supertable WHERE steamid LIKE ? LIMIT 1 : [“E:4C63C3B71E7CF37005D999D644FB2B8F85581D9F”]”: ER_NO_SUCH_TABLE: Table ‘server.supertable’ doesn’t exist
please help me