I'm trying to get this code to add an item to a character on their first log in. It works, however I want to only have it work on one character. So I added a new column in the accounts table called "booster" when set to 0 it means you can have the item, and 1 means you cannot have it.
Now I'm stuck on the last part. Where it should send a query to set the column to 1, though I don't know how I would select the correct id.
function First_Login(event, player)
local query = AuthDBQuery("SELECT id,booster FROM account;")
local id = query:GetUint32(0);
local booster = query:GetUint32(1);
if booster = 0 then
local query2 = AuthDBQuery("UPDATE `account` SET `booster`=1;")