GTAONLINE.PL :: Baza MySQL

A wiec w tym pliku wpisywalem haslo itp. kod:

Kod:

MYSQL_SERVER="localhost"

MYSQL_USERNAME="ironmine"

MYSQL_PASSWORD=""

MYSQL_DB="ironmine"

MYSQL_PORT="3306"

I pewnie chodzi ci o ten plik (jak nie to napisz

) kod:

Kod:

MYSQL_SERVER,MYSQL_USERNAME,MYSQL_PASSWORD,MYSQL_DB)

	if not handle then

		return

	end

	setTimer(restartDataBase,600000,1)

end

-------------------------------------------------------------------

-- save/loadStats

-------------------------------------------------------------------

function saveStats(thePlayer,debuger)

	local postacID = getPlayerID(thePlayer)

	if thePlayer then

		if isPlayerLoged(thePlayer) then

			setElementData(thePlayer,"ostatnio",getRealTime().timestamp)

			local String = ""

			for j=2,#DanePostacie do

				local data = getElementData(thePlayer,DanePostacie[j])

				if not data or data == false then data = 0 end

				if DanePostacie[j] == "czas" then 

					data = data+(getElementData(thePlayer,"czasToday") and getElementData(thePlayer,"czasToday") or 0)

				elseif DanePostacie[j] == "frakcja" then

					if getPlayerTeam ( thePlayer ) == KierowcyTeam then data = 0 end

					if getPlayerTeam ( thePlayer ) == PolicjaTeam then data = 1 end

					if getPlayerTeam ( thePlayer ) == PogotowieTeam then data = 2 end

					if getPlayerTeam ( thePlayer ) == PDTeam then data = 3 end

					if getPlayerTeam ( thePlayer ) == TaxiTeam then data = 4 end

					if getPlayerTeam ( thePlayer ) == PetrolTeam then data = 5 end

					if getPlayerTeam ( thePlayer ) == FreshLogisticTeam then data = 6 end

					if getPlayerTeam ( thePlayer ) == TarTexTeam then data = 7 end

					if getPlayerTeam ( thePlayer ) == SlCompanyTeam then data = 8 end

				end

				if j == #DanePostacie then 

					String = String..""..DanePostacie[j].."='"..data.."'"

				else 

					String = String..""..DanePostacie[j].."='"..data.."', "

				end

			end

			mysql_query(handle,	"UPDATE MTATS_postacie SET "..String.." WHERE id = "..postacID.."")

			mysql_query(handle,	"UPDATE MTATS_postacie SET loged=0 WHERE id = "..postacID.."")	

			local String = nil

		end

	end

end

function loadStats(thePlayer)

	local postacID = getPlayerID(thePlayer)

	local result = mysql_query(handle,"SELECT * FROM MTATS_postacie WHERE id = "..postacID.."")

	if result then

		setElementData(thePlayer,"loged",1)

		for i,v in mysql_rows(result) do

			for j=2,#DanePostacie do

				setElementData(thePlayer,DanePostacie[j],v[j],true)

				if DanePostacie[j] == "frakcja" then

					if tonumber(v[j]) == 0 then setPlayerTeam ( thePlayer, KierowcyTeam ) end

					if tonumber(v[j]) == 1 then setPlayerTeam ( thePlayer, PolicjaTeam ) end

					if tonumber(v[j]) == 2 then setPlayerTeam ( thePlayer, PogotowieTeam ) end

					if tonumber(v[j]) == 3 then setPlayerTeam ( thePlayer, PDTeam ) end

					if tonumber(v[j]) == 4 then setPlayerTeam ( thePlayer, TaxiTeam ) end

					if tonumber(v[j]) == 5 then setPlayerTeam ( thePlayer, PetrolTeam ) end

					if tonumber(v[j]) == 6 then setPlayerTeam ( thePlayer, FreshLogisticTeam ) end

					if tonumber(v[j]) == 7 then setPlayerTeam ( thePlayer, TarTexTeam ) end

					if tonumber(v[j]) == 8 then setPlayerTeam ( thePlayer, SlCompanyTeam ) end

					local r,g,b = getTeamColor(getPlayerTeam(thePlayer))

					if tonumber(v[j]) ~= 1 then

						createBlipAttachedTo(thePlayer, 0, 2, r, g, b, 255, 1,9999)

					end

				end

			end

		end

		mysql_free_result(result)

		setElementData(thePlayer,"czasToday",0)

		mysql_query(handle,	"UPDATE MTATS_postacie SET loged=1 WHERE id = "..postacID.."")	

	end

	return true

end

function addHistory(thePlayer,co,gdzie,ile,wartosc,szczegoly)

	if isElement(thePlayer) then

		local frakcja = tonumber(getElementData(thePlayer,"frakcja"))

		local ID = getPlayerID(thePlayer)

		if ID and frakcja then

			if frakcja >= 1 then

				local tablename = nil

				if frakcja == 1 then tablename = "policja"

				elseif frakcja == 2 then tablename = "pogotowie"

				elseif frakcja == 3 then tablename = "pd"

				elseif frakcja == 4 then tablename = "taxi"

				elseif frakcja == 5 then tablename = "petrol"

				elseif frakcja == 6 then tablename = "freshlogistic"

				elseif frakcja == 7 then tablename = "tartex"

				elseif frakcja == 8 then tablename = "slcompany"

				end

				if tablename then

					local szczegoly = string.gsub(szczegoly,"?","e")

					local szczegoly = string.gsub(szczegoly,"?","o")

					local szczegoly = string.gsub(szczegoly,"?","a")

					local szczegoly = string.gsub(szczegoly,"?","s")

					local szczegoly = string.gsub(szczegoly,"?","l")

					local szczegoly = string.gsub(szczegoly,"?","z")

					local szczegoly = string.gsub(szczegoly,"?","z")

					local szczegoly = string.gsub(szczegoly,"?","c")

					local szczegoly = string.gsub(szczegoly,"?","n")

					mysql_query(handle, "INSERT INTO MTATS_firmy_"..tablename.." (kiedy,kto,co,gdzie,ile,wartosc,szczegoly) VALUES ("..getRealTime().timestamp..","..ID..","..co..","..gdzie..","..ile..","..wartosc..",'"..szczegoly.."')")

				end

			end			

		end

	end

end

function onPlayerExit()

	saveStats(source)

	for _, blip in ipairs(getElementsByType("blip")) do

		if getElementAttachedTo(blip) == source then

			destroyElement(blip)

		end

	end

end

addEventHandler("onPlayerQuit",gRoot,onPlayerExit)

function updatePlayerTime()

	local players = getElementsByType("player")

	for i,v in ipairs(players) do

		local rtime = getElementData(v,"czasToday")

		if rtime then

			setElementData(v,"czasToday",tonumber(rtime)+1,true)

			setElementData(v,"czasConverted",convertTime(tonumber(rtime)+1),true)

		end

		local tired = getElementData(v,"zmeczenie")

		if tired then

			if isPedInVehicle(v) then

				setElementData(v,"zmeczenie",tonumber(tired)+0.02,true)

			else

				setElementData(v,"zmeczenie",math.max(0,tonumber(tired)-0.005),true)

			end

		end

	end

	for i,vehicle in ipairs(getElementsByType("vehicle")) do

		local naczepa = getElementData(vehicle,"trailer")

		if naczepa and isElement(naczepa) then

			attachTrailerToVehicle(vehicle,naczepa)

		end

	end

end

setTimer(updatePlayerTime,1000,0)

function onKasaChange(dataName,oldValue)

	if getElementType(source) == "player" then

		if dataName == "kasa" then

			setPlayerMoney(source,getElementData(source,"kasa"))

		end

	end

end

addEventHandler("onElementDataChange",gRoot,onKasaChange)