prezenty = {};
prezenty.marker = Marker(252.33,-157.90,1.57-1, "cylinder", 3.5, 255,255,255,70);
prezenty.text = createElement("text");
prezenty.blip = Blip(252.33,-157.90,1.57, 19, nil, nil, nil, nil, nil, nil, 275);
setElementData(prezenty.text, "name", "Prezenty\nOd Mikołaja!");
setElementPosition(prezenty.text, 252.33,-157.90,1.57+1);

setPremiumDay = function(plr,days)
	if getPremiumDate(plr) then
	local queryA=exports['ogrpg-db']:dbSet(string.format("UPDATE ogrpg_users SET premiumdate = DATE(premiumdate) + INTERVAL %d DAY WHERE id=%d",days,getElementData(plr,"player:uid")))
	return end;
	local queryA=exports['ogrpg-db']:dbSet(string.format("UPDATE ogrpg_users SET premiumdate = DATE(curdate()) + INTERVAL %d DAY WHERE id=%d",days,getElementData(plr,"player:uid")))
end;

getPremiumDate = function(plr)
	local queryA=exports['ogrpg-db']:dbGet("SELECT * FROM ogrpg_users WHERE id=? AND premiumdate>NOW() LIMIT 1", getElementData(plr,"player:uid"))
	if (queryA and #queryA > 0) then
		return queryA[1].premiumdate
	end;
	return false
end;

losuj = function(plr)
    if(plr:isWithinMarker(prezenty.marker) and not plr:getData("prezenty"))then
        kasa = math.random(350, 3500);
        dni = math.random(1,3);
        uid = getElementData(plr,"player:uid")
		exports["ogrpg-db"]:dbSet("UPDATE ogrpg_users SET prezent=1 where id=?", uid)
        premium = setPremiumDay(plr, dni);
        plr:giveMoney(kasa);
        plr:setData("prezenty", true);
        plr:outputChat("#00FF00* #FFFFFFWylosowałeś(/aś) "..kasa.." EUR + Premium na: "..dni.." dni/dzień", 255,255,255,true);
    end
end;
addCommandHandler("losuj", losuj);

addEventHandler("onMarkerHit", prezenty.marker, function(plr)
    if(plr:getData("prezenty"))then
        plr:outputChat("Posiadasz, już odebrany prezent!");
    else
        plr:outputChat("Aby, odebrać prezent wpisz /losuj.");
    end;
end);