[HELP] Storing advice

[..:D&G:..]

So I want to do quest thing where the players have to look and hit 150 pickups in order to use the command /getgift to get a gift... The problem is, I don't know the best way of storing each pickup to each player so that a player cannot use the same pickup twice.

So yeah... I need a reliable and easy way to store all this in a MySQL database

[WhoAmI]

I don't think that MySQL database is necessary there. I think normal table will do the work.

Something like

local playerPickups = {} 
  
addEventHandler("onPickupHit", root, function(player) 
    if isElement(player) and getElementType(player) == "player" then 
        if not playerPickups[player] then 
            playerPickups[player] = 1; 
        else 
            return; 
        end 
    else 
        return; 
    end 
end) 

[..:D&G:..]

Yeah but the thing is that there are 150 pickups, and if the player relogs or if the resource gets stoped, I want everything to be saved so that the player doesn't have to find all the pickups again

[WhoAmI]

So you can use databse there. I'll do the project for you.

https://scr.hu/d3DoOe

In 'pickup' you store all players, in 'player' you store all players which picked atleast one pickup and in 'player_pickup' you store id_player and what pickup he picked id_pickup.

[..:D&G:..]

So you can use databse there. I'll do the project for you.

https://scr.hu/d3DoOe

In 'pickup' you store all players, in 'player' you store all players which picked atleast one pickup and in 'player_pickup' you store id_player and what pickup he picked id_pickup.

So there is no efficient way of saving everything in only 1 table?

[WhoAmI]

Well, some way you will do that, but databse has to be optimalised and easy to read and get data.

[Axel]

Use pickup id's and save them in a table, and then use toJSON(table) to save them to a string, then in the database.

[WhoAmI]

That's the worst idea I've ever heard. That's not the way how we use database, c'mon.

[..:D&G:..]

I've took your advice and made 2 separate tables for the pickups and for the pickups found by the player, thanks

[WhoAmI]

No problem. I've learned a lot about databases.