quest paczki_vip begin
	state start begin
		function data()
			return {
				[30181] = {
					{bonus="pd", minute=1440},
					{bonus="safebox", minute=1440},
					{bonus="dodatkoweeq", minute=1440},
				},
			}
		end

		function GetVipTypeFromString(vipString)
			if vipString == "pd" then
				return "silver_expire"
			elseif vipString == "safebox" then
				return "safebox_expire"
			elseif vipString == "dodatkoweeq" then
				return "dodatkowe_eq_aut"
			end
			return "NONE_EXPIRE"
		end

		function add_vip(vipTime, vipString, account_id)
			local vipType = paczki_vip.GetVipTypeFromString(vipString)
			local qr = "UPDATE account.account SET "..
			vipType.."=IF(UNIX_TIMESTAMP("..vipType..") >= UNIX_TIMESTAMP(NOW()), "..vipType.." + INTERVAL "..vipTime.." MINUTE, NOW() + INTERVAL "..vipTime.." MINUTE) "..
			"where id="..account_id..";"
			debug(qr)
			query(qr)
		end

		when 30181.use begin
			local vnum = item.get_vnum()
			local vipData = paczki_vip.data()[vnum]
			if not pc.can_warp() then
				syschat("Odczekaj 10 sekund po zakoñczonym handlu.")
				return
			end
			if vipData == nil then
				return
			end

			local account_id = pc.get_account_id()
			debug(account_id)

			for i,v in pairs(vipData) do
				paczki_vip.add_vip(v.minute, v.bonus, account_id)
			end
			say_title("Informacja:")
			say("Przeloguj siê, aby zatwierdziĉ zmiany!")
			pc.remove_item(vnum, 1)
		end
	end
end