local rootElement= getRootElement()
addEvent("onMapStarting")
addEvent("onPlayerPickupRacePickup")
addEvent("onPlayerReachCheckpoint")
addEvent("onPlayerRaceWasted")
addEvent("onPlayerFinish")
addEvent("onRaceStateChanging")

function ResourceStart()
executeSQLCreateTable("MoneyB", "serial STRING,B INT")
end
addEventHandler("onResourceStart", getResourceRootElement(getThisResource()), ResourceStart)

function ClientReady(g_player)
local serial = getPlayerSerial(g_player)
local playername = getPlayerName(g_player)
CheckPlayer4 = executeSQLSelect ( "MoneyB", "serial", "serial = '" .. serial .. "'" )
if ( type( CheckPlayer4 ) == "table" and #CheckPlayer4 == 0 ) or not CheckPlayer4 then
executeSQLInsert ( "MoneyB", "'"..serial.."','0','0'" )
end
end
addEvent("onClientReady",true)
addEventHandler("onClientReady",getRootElement(),ClientReady)

function DestructionMoney2(mapInfo,mapOptions,gameOptions)
local alivePlayers = getAlivePlayers()
if info == "Destruction derby" then
   if #alivePlayers == 1 then
   local playername = getPlayerName(alivePlayers[1])
   local serial = getPlayerSerial(alivePlayers[1])
   local Money = executeSQLSelect ( "MoneyB", "B","serial = '" .. serial .. "'")

   outputChatBox("*Wins: "..playername.." took 20 B Points for surviving!",getRootElement(),255,255,0)

   Money  = tonumber(Money[1]["B"]) + 20

   setElementData(alivePlayers[1] ,"B Points", Money)

   executeSQLUpdate ( "MoneyB", "B = '"..Money.."'","serial = '" .. serial .. "'")
   end
end
end

 function hunterBonus(pickupID, pickupType, vehicleModel)
if info == "Destruction derby" then
if pickupType == "vehiclechange" then
if vehicleModel == 425 then

local serial = getPlayerSerial(source)
local Money = executeSQLSelect ( "MoneyB", "B","serial = '" .. serial .. "'")

Money  = tonumber(Money[1]["B"]) + 5

outputChatBox("*"..getPlayerName(source).." gets the hunter!",25,125,225)
outputChatBox("*You reicive 5 B Points!",25,125,225)


setElementData(source ,"B Points", Money)

executeSQLUpdate ( "MoneyB", "B = '"..Money.."'","serial = '" .. serial .. "'")
end
end
end
end
addEventHandler("onPlayerPickUpRacePickup",getRootElement(),hunterBonus)

function RespawnTime(mapInfo,mapOptions)
mapinfo = mapInfo.modename
respawntime = mapOptions.respawntime
setTime (12, 0)
setWeather (0)
end
addEventHandler("onMapStarting",getRootElement(),RespawnTime)

function checkMoney (player,cmd)
		local serial = getPlayerSerial(player)
		local Money = executeSQLSelect ( "MoneyB", "B","serial = '" .. serial .. "'")
        outputChatBox("You Have "..tonumber(Money[1]["B"]).." B Points!" , player,255,255,0)
end

function AchExplode()
		 local driver = getVehicleOccupant(source)
		 AchExplodeAlternative(driver)
end
addEventHandler("onVehicleExplode", rootElement, AchExplode)

--Scoreboard 'B' Column & Refreshing
addEventHandler("onResourceStart",
	getResourceRootElement(getThisResource()),
	function()
		exports.scoreboard:addScoreboardColumn( "B Points")
	end)

addEventHandler ("onPlayerJoin",getRootElement(), function()
local serial = getPlayerSerial(source)
local AchB = executeSQLSelect ( "MoneyB", "B","serial = '" .. serial .. "'")
setElementData(source, "B Points", tonumber(AchB[1]["B"])) end)

 --- Cash !Command
 function PubMoney(message,messageType)
 if message == "!points" or message =="!Points" then
 local serial = getPlayerSerial(source)
 local Money = executeSQLSelect ( "MoneyB", "B","serial = '" .. serial .. "'")
 local name = getPlayerName(source)
 outputChatBox(name.." has $"..tonumber(Money[1]["B"]),getRootElement(),255,255,0,true)
 end
 end
 addEventHandler("onPlayerChat",getRootElement(),PubMoney)

addCommandHandler( "Points",  checkMoney )
addCommandHandler( "points",  checkMoney )
addEventHandler("onPlayerFinish", rootElement, raceWin )
addEventHandler("onMapStarting", rootElement , DestructionMoney)
addEventHandler("onPlayerWasted", rootElement  , DestructionMoney2)