Jump to content

what is the problem


Best-Killer

Recommended Posts

addEvent( 'CreateMarker', true )
addEventHandler( 'CreateMarker', root, 
function( role, name, X, Y, Z, r, g, b, v, rot)
local AllMarker = exports.NGSQL:db_query( "SELECT * FROM vehicle_marker" )
id = #AllMarker + 1
exports.NGSQL:db_exec( "INSERT INTO vehicle_marker ( Role, Name, posX, posY, posZ, r, g, b, Vehicles, Rotation, ID ) VALUES ( "..role..", "..name..", "..X..", "..Y..", "..Z..", "..r..", "..g..", "..b..", '..v..', '..rot..', "..id..")" )
local marker = createMarker( X, Y, Z, 'cylinder', 1.25, r, g, b, 255 )
setElementData( marker, 'giveCarSystem', true )
setElementData( marker, 'id', id )
outputChatBox( "Marker Was Created", source, 255, 255, 0 )
end
)
addEventHandler("onClientGUIClick",root,
function ()
local name = guiGetText(GUIEditor.edit[7])
local role = guiGetText(GUIEditor.edit[1])
local x,y,z = getElementPosition (getLocalPlayer())
local r, g, b = getColorFromString ( guiGetText (GUIEditor.edit[6] ))
local coloredit = guiGetText (GUIEditor.edit[6])
local rot = getPlayerRotation (getLocalPlayer())
local v = guiGridListGetItemText ( GUIEditor.gridlist[2], 1, 1)
if ( source == GUIEditor.button[6] ) then
    guiSetVisible(GUIEditor.window[1],false)         
    showCursor(false) 
elseif ( source == GUIEditor.button[5] ) then
guiSetText (GUIEditor.edit[2], x )
guiSetText (GUIEditor.edit[3], y )
guiSetText (GUIEditor.edit[4], z )
guiSetText (GUIEditor.edit[5], rot )
guiGetText (GUIEditor.edit[6],{r,g,b})
elseif ( source == GUIEditor.button[2] ) then
currentPosition = {role,name,x,y,z,r,g,b,v,rot}
if #currentPosition == 0 then return end
	local send = {
		[1] = currentPosition[1], [2] = currentPosition[2], 
		[3] = currentPosition[3], [4] = currentPosition[4],
		[5] = currentPosition[5], [6] = currentPosition[6], 
		[7] = currentPosition[7], [8] = currentPosition[8],
		[9] = currentPosition[9], [10] = currentPosition[10]
	}
	newPos = {}
	triggerServerEvent("CreateMarker", localPlayer, unpack(send))
elseif ( source == GUIEditor.button[1] ) then
-----Create Marker---
elseif ( source == GUIEditor.button [3] ) then 
-----Remove Vehicle-----
guiGridListRemoveRow(GUIEditor.gridlist[2], guiGridListGetSelectedItem(GUIEditor.gridlist[2])) 

elseif ( source == GUIEditor.button [4] ) then 
-----Add vehicle -------
local vehicletext = guiComboBoxGetSelected(GUIEditor.combobox[1])
local vehicle = guiComboBoxGetItemText(GUIEditor.combobox[1], vehicletext)
local vehicleid = getVehicleModelFromName(vehicle)
local row = guiGridListAddRow(GUIEditor.gridlist[2])
guiGridListSetItemText(GUIEditor.gridlist[2],row, model,vehicleid,false,false)
end
end)

dbExec failed; (1054) unknown column 'Job' in 'field list'

Link to comment

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
  • Recently Browsing   0 members

    • No registered users viewing this page.
×
×
  • Create New...