Fala galera. Estou iniciando a fazer mods no MTA e estou com um problema que pra vocês pede ser facíl de mais, mas para mim está terrivél ! Estou tentando converter um script dp MySQL para sqlite. Já até consegui ele fazer a conexão com a db, mas quando eu tento acrescentar alguma coisa pelo mod dentro do jogo, ele não acrescentar. Alguém pode me ajudar ?
local connection = dbConnect("sqlite", "database.db")
function mdcLoginServer(username, password)
local source = client
dbQuery(
function (queryHandler)
local result, numAffectedRows, errorMsg = dbPoll(queryHandler, 0)
if numAffectedRows > 0 then
for _, row in ipairs(result) do
faction = row["faction"]
end
triggerClientEvent(source, "loginMdcClient", source, faction)
else
exports.ng_info:showBoxS(source, "Hibás felhasználónév vagy jelszó.", "error")
end
end,
connection,
"SELECT * FROM mdcaccounts WHERE username = ? AND password = ?", username, password
)
end
addEvent("mdcLoginServer", true)
addEventHandler("mdcLoginServer", getRootElement(), mdcLoginServer)
addEvent("acceptPlayerLogin", true)
addEventHandler("acceptPlayerLogin", getRootElement(), function(player)
triggerClientEvent(player, "loginMdcClient", player)
end)
function createMdcAccount(thePlayer, command, username, password)
local faction = getElementData(thePlayer, "char.factionID")
if faction == 190 then
if not (username) or not (password) then
outputChatBox("#4169E1[Use]:#ffffff /" .. command .. " [nome de usuário] [senha]", thePlayer, 208, 101, 29, true)
else
local query = dbExec(connection, "INSERT INTO mdcaccounts SET username = ?, password = ?, faction = ?",username,password,faction)
if query then
outputChatBox("#4169E1[Brasil PH]:#ffffff Usuário adicionado com sucesso", thePlayer, 208, 101, 29, true)
else
outputChatBox("#FF0000[Error]:#ffffff Erro no MySQL", thePlayer, 124, 9, 9, true)
end
end
end
end
addCommandHandler("addmdconta", createMdcAccount)
function deleteMdcAccount(thePlayer, command, username)
if getElementData(thePlayer, "char.factionID") == 1 then
if not (username) then
outputChatBox("[Használat]:#ffffff /" .. command .. " [Felhasználónév]", thePlayer, 208, 101, 29, true)
else
local query = dbExec(connection, "DELETE FROM mdcaccounts WHERE username=?",username)
if query then
outputChatBox("[Információ]:#ffffff Felhasználó törölve!", thePlayer, 208, 101, 29, true)
else
outputChatBox("[Hiba]:#ffffff MySQL Hiba!", thePlayer, 124, 9, 9, true)
end
end
end
end
addCommandHandler("removemdconta", deleteMdcAccount)
--================================================--
local positions = {
-- x, y, z, tamanho, nome
{1020.9491577148, -957.35943603516, 41.883373260498, 20, "Posto de gasolina do sul"},
{1528.837890625, -1674.6318359375, 13.3828125, 50, "polícia"},
{1304.6455078125, -1700.59375, 13.546875, 50, "filme"},
{1548.044921875, -1789.8291015625, 13.546875, 50, "Prefeitura próxima a ela"},
{1477.966796875, -1759.06640625, 13.58437538147, 50, "Prefeitura"},
{2102.0439453125, -1782.5283203125, 13.392087936401, 50, "Pizzaria bem empilhada"},
{1909.9931640625, -1421.6787109375, 11.533273696899, 100, "Skate Park"},
{1012.896484375, -931.2958984375, 42.1796875, 50, "Posto de gasolina do norte"},
{1582.197265625, -2165.1767578125, 13.60000038147, 50, "oficina de montagem"},
{2227.388671875, -1722.4697265625, 13.555265426636, 20, "ginásio"},
{2860.5537109375, -2048.947265625, 10.9375, 30, "Pista de entrada"},
{2058.3115234375, -1912.3310546875, 13.546875, 50, "Táxis Bateria"},
{1821.87109375, -1684.2158203125, 13.3828125, 50, "Alhambra Club"},
{1192.4443359375, -1322.03125, 13.3984375, 50, "hospital"}
}
for k,v in ipairs(positions) do
local x,y,z = v[1], v[2], v[3]
local marker = createMarker(x,y,z-1, "cylinder", v[4], 255,255,255,0)
setElementData(marker, "marker.ZoneName", v[5])
setElementData(marker, "marker.isZoneCamera", true)
end
--================================================--
function sendMessageToPoliceG(text, number)
for k, v in ipairs(getElementsByType("player")) do
if getElementData(v, "char.factionID") == 190 then
outputChatBox("[PMESP]:#ffffff "..text, v, 208, 101, 29, true)
end
end
end
addEvent("sendMessageToPoliceG", true)
addEventHandler("sendMessageToPoliceG", getRootElement(), sendMessageToPoliceG)
function createBackupBlipServer(vehicle)
for k, v in ipairs(getElementsByType("player")) do
local count = getElementData(v, "groupCount")
if count then
for i=0, count-1 do
local group = getElementData(v, "group_" .. i .. "")
if group == 1 or group == 2 or group == 3 or group == 14 or group == 8 or group == 15 then
triggerClientEvent(root, "createBackupBlipClient", root, vehicle)
end
end
end
end
end
addEvent("createBackupBlipServer", true)
addEventHandler("createBackupBlipServer", getRootElement(), createBackupBlipServer)
function destroyBlipServer(vehicle)
for k, v in ipairs(getElementsByType("player")) do
local count = getElementData(v, "groupCount")
if count then
for i=0, count-1 do
local group = getElementData(v, "group_" .. i .. "")
if group == 1 or group == 2 or group == 3 then
triggerClientEvent(root, "destroyBlipClient", root, vehicle)
end
end
end
end
end
addEvent("destroyBlipServer", true)
addEventHandler("destroyBlipServer", getRootElement(), destroyBlipServer)
function createDutyBlipServer(vehicle)
for k, v in ipairs(getElementsByType("player")) do
local count = getElementData(v, "groupCount")
if count then
for i=0, count-1 do
local group = getElementData(v, "group_" .. i .. "")
if group == 1 or group == 2 or group == 3 then
triggerClientEvent(root, "createDutyBlipClient", root, vehicle)
end
end
end
end
end
addEvent("createDutyBlipServer", true)
addEventHandler("createDutyBlipServer", getRootElement(), createDutyBlipServer)
function addTicket(charactername, price, jail, reason)
local insertSQL = dbExec(connection, "INSERT INTO mdctickets SET targetname = ?, price = ?, jailtime =?, reason =?",charactername, price, jail, reason)
end
addEvent("addTicket", true)
addEventHandler("addTicket", getRootElement(), addTicket)
function deleteFromTickets(id)
local insertSQL = dbExec(connection, "DELETE FROM mdctickets WHERE id=?",id)
end
addEvent("deleteFromTickets", true)
addEventHandler("deleteFromTickets", getRootElement(), deleteFromTickets)
function addWantedPerson(charactername, reason, description)
local insertSQL = dbExec(connection, "INSERT INTO mdcwantedpersons SET charactername = ?, reason = ?, description = ?",charactername, reason, description)
end
addEvent("addWantedPerson", true)
addEventHandler("addWantedPerson", getRootElement(), addWantedPerson)
function deleteFromWantedPersons(id)
local insertSQL = dbExec(connection, "DELETE FROM mdcwantedpersons WHERE id=?",id)
end
addEvent("deleteFromWantedPersons", true)
addEventHandler("deleteFromWantedPersons", getRootElement(), deleteFromWantedPersons)
function addWantedCar(modelname,numberplate,reason)
local insertSQL = dbExec(connection, "INSERT INTO mdcwantedcars SET modelname = ?, numberplate = ?, reason = ?",modelname,numberplate,reason)
triggerEvent("getKorozottKocsik", root)
end
addEvent("addWantedCar", true)
addEventHandler("addWantedCar", getRootElement(), addWantedCar)
function deleteFromWantedCars(id)
local insertSQL = dbExec(connection, "DELETE FROM mdcwantedcars WHERE id=?",id)
triggerEvent("getKorozottKocsik", root)
end
addEvent("deleteFromWantedCars", true)
addEventHandler("deleteFromWantedCars", getRootElement(), deleteFromWantedCars)
function getTicketsServer(playerSource)
local tickets = {}
tickets = {}
local QueryEredmeny = dbPoll ( dbQuery( connection, "SELECT * FROM mdctickets"), -1 )
if (QueryEredmeny) then
for k, v in ipairs(QueryEredmeny) do
tickets[#tickets + 1] = {v["targetname"], v["price"], v["jailtime"], v["reason"], v["id"]}
end
triggerClientEvent(root, "getTicketsClient", root, tickets)
end
end
addEvent("getTicketsServer", true)
addEventHandler("getTicketsServer", getRootElement(), getTicketsServer)
function getWantedCarsServer(playerSource)
local wantedcars = {}
wantedcars = {}
local QueryEredmeny = dbPoll ( dbQuery( connection, "SELECT * FROM mdcwantedcars"), -1 )
if (QueryEredmeny) then
for k, v in ipairs(QueryEredmeny) do
wantedcars[#wantedcars + 1] = {v["modelname"], v["numberplate"], v["reason"], v["id"]}
end
triggerClientEvent(root, "getWantedCarsClient", root, wantedcars)
end
end
addEvent("getWantedCarsServer", true)
addEventHandler("getWantedCarsServer", getRootElement(), getWantedCarsServer)
function getWantedPersonsServer(playerSource)
local wantedpersons = {}
wantedpersons = {}
local QueryEredmeny = dbPoll ( dbQuery( connection, "SELECT * FROM mdcwantedpersons"), -1 )
if (QueryEredmeny) then
for k, v in ipairs(QueryEredmeny) do
wantedpersons[#wantedpersons + 1] = {v["charactername"], v["reason"], v["id"], v["description"]}
end
triggerClientEvent(root, "getWantedPersonsClient", root, wantedpersons)
end
end
addEvent("getWantedPersonsServer", true)
addEventHandler("getWantedPersonsServer", getRootElement(), getWantedPersonsServer)
--[[CCTV]]--
--[[local pdcamera = createObject ( 2606, 253.8818359375, 114.7880859375, 1009.3209228516, 0, 0, 90)
setElementData(pdcamera,"cctv:allowed",true)
setElementInterior(pdcamera,10)
setElementDimension(pdcamera,2)
local pdmarker = createMarker(255.431640625, 114.466796875, 1007.813659668, "cylinder", 1, 202, 84, 84, 170)
setElementInterior(pdmarker,10)
setElementDimension(pdmarker,2)
setElementData(pdmarker,"visibleName","\nJobb klikk a kamerákra.",true)
setElementData(pdmarker,"marker:name","#ca5454[CCTV]\n#ffffffHasználata:\n#acd373[BAL KLIKK] #ffffff- Kamera panel megnyitása\n#acd373[BACKSPACE] #ffffff- Kilépés a panelből",true)
setElementData(pdmarker,"visiblePedName","Használat:")
setElementData(pdmarker,"nameEnabled",true)]]--
