drk

You'll need use account data / SQL / MySQL to store free / occupied slots and get data when player press the button before doing something. We can't help in this, or we will need to create the full script for you, sorry. Try by yourself and we'll help you with problems.

You mean you can only buy a determinated amount of vehicles and when you press "Comprar vehiculo" appears a window with your free / occupied slots where you can select one and add a vehicle in the slot?

But what is 'slot' ???

Put vehicle price in item data and get the item data when click on a item. For slots, I don't understand you.

My bad ElMota, copy my code again.

Obviously. GUIEditor_Window = {} GUIEditor_Button = {} GUIEditor_Label = {} GUIEditor_Edit = {} GUIEditor_Grid = {} GUIEditor_Window[1] = guiCreateWindow(11,92,229,464,"Mi panel de Spawn",false) GUIEditor_Button[1] = guiCreateButton(9,29,209,43,"Spawnear Vehiculo",false,GUIEditor_Window[1]) GUIEditor_Button[2] = guiCreateButton(9,75,208,41,"Spawnear Vehiculo",false,GUIEditor_Window[1]) GUIEditor_Button[3] = guiCreateButton(9,118,208,41,"Spawnear Vehiculo",false,GUIEditor_Window[1]) GUIEditor_Button[4] = guiCreateButton(9,162,208,41,"Spawnear Vehiculo",false,GUIEditor_Window[1]) GUIEditor_Button[5] = guiCreateButton(9,251,208,41,"Spawnear Vehiculo",false,GUIEditor_Window[1]) GUIEditor_Button[6] = guiCreateButton(9,206,208,41,"Spawnear Vehiculo",false,GUIEditor_Window[1]) GUIEditor_Button[7] = guiCreateButton(10,296,206,41,"Spawnear Vehiculo",false,GUIEditor_Window[1]) GUIEditor_Button[8] = guiCreateButton(10,340,206,41,"Spawnear Vehiculo",false,GUIEditor_Window[1]) GUIEditor_Label[1] = guiCreateLabel(12,396,205,56,"GUI Creada por ElMota",false,GUIEditor_Window[1]) guiLabelSetColor(GUIEditor_Label[1],255,255,0) guiSetFont(GUIEditor_Label[1],"default-bold-small") GUIEditor_Window[2] = guiCreateWindow(11,340,219,216,"GUI Shop Panel",false) GUIEditor_Button[9] = guiCreateButton(18,70,168,32,"Comprar Vehiculo",false,GUIEditor_Window[2]) GUIEditor_Button[10] = guiCreateButton(18,109,168,32,"Vender Vehiculo",false,GUIEditor_Window[2]) GUIEditor_Button[11] = guiCreateButton(21,148,109,30,"Elejir un Color",false,GUIEditor_Window[2]) GUIEditor_Button[12] = guiCreateButton(22,26,75,39,"Cancelar",false,GUIEditor_Window[2]) GUIEditor_Window[3] = guiCreateWindow(544,249,240,326,"Vehiculos",false) GUIEditor_Grid[1] = guiCreateGridList(9,24,222,293,false,GUIEditor_Window[3]) guiGridListSetSelectionMode(GUIEditor_Grid[1],2) guiGridListAddColumn(GUIEditor_Grid[1],"Autos",0.5) guiGridListAddColumn(GUIEditor_Grid[1],"Precio $",0.3) local cars = {{493,699999},{484,300000},{446,1599999},{469,2999999},{563,5999999},{488,6999999},{487,6999999},{417,3999999},{548,4999999},{497,7999999},{579,60000},{400,60000},{404,28000},{489,65000},{505,65000},{479,45000},{442,45000},{458,45000},{602,50000},{496,42500},{401,41000},{518,60000},{527,75000},{589,75000},{419,45000},{533,75000},{526,50000},{474,55000},{545,50000},{517,45000},{410,41000},{600,50000},{436,41000},{580,50000},{439,75000},{549,75000},{491,45000},{445,45000},{507,45000},{585,45000},{587,75000},{466,55000},{492,50000},{546,45000},{551,45000},{516,45000},{467,45000},{426,47500},{547,45000},{405,55000},{409,75000},{550,45000},{566,45000},{540,45000},{421,50000},{529,45000},{402,12000},{542,65000},{603,12000},{475,75000},{562,120000},{565,95000},{559,120000},{561,50000},{560,120000},{558,100000},{429,120000},{541,120000},{415,120000},{480,95000},{434,100000},{494,120000},{502,120000},{503,120000},{411,120000},{506,120000},{451,120000},{555,95000},{477,95000},{499,25000},{498,25000},{578,50000},{486,70000},{455,75000},{588,50000},{403,75000},{414,50000},{443,75000},{515,75000},{514,75000},{531,12000},{456,45000},{422,45000},{482,95000},{530,12000},{418,45000},{572,12000},{582,50000},{413,5000},{440,50000},{543,65000},{583,12000},{478,35000},{554,50000},{536,75000},{575,75000},{534,75000},{567,75000},{535,75000},{576,75000},{412,75000},{568,75000},{457,12000},{483,45000},{508,40000},{571,10000},{500,55000},{444,120000},{556,120000},{557,120000},{471,20000},{495,100000},{539,75000},{481,25050},{509,2500},{581,45000},{462,12000},{521,60000},{463,50000},{522,75000},{448,12000},{468,45000},{586,45000},{485,12000},{431,60000},{438,45000},{437,60000},{574,12000},{420,45000},{525,75000},{408,50000},{428,65000}} for i,v in ipairs (cars) do local carName = getVehicleNameFromModel (v[1]) local row = guiGridListAddRow (GUIEditor_Grid[1]) guiGridListSetItemText (GUIEditor_Grid[1], row, 1, carName, false, true) guiGridListSetItemText (GUIEditor_Grid[1], row, 2, tostring(v[2]), false, true) end GUIEditor_Window[4] = guiCreateWindow(252,171,410,105,"Verificacion",false) GUIEditor_Label[2] = guiCreateLabel(10,29,391,25,"Porfavor elije aqui un slot para tu vehiculo",false,GUIEditor_Window[4]) guiLabelSetColor(GUIEditor_Label[2],255,255,0) guiSetFont(GUIEditor_Label[2],"default-bold-small") GUIEditor_Edit[1] = guiCreateEdit(242,57,43,25,"",false,GUIEditor_Window[4]) guiEditSetMaxLength(GUIEditor_Edit[1],1) GUIEditor_Button[13] = guiCreateButton(10,59,100,37,"Acepto",false,GUIEditor_Window[4]) GUIEditor_Button[14] = guiCreateButton(112,65,100,31,"Cancelar",false,GUIEditor_Window[4]) guiSetVisible(GUIEditor_Window[1], false) guiSetVisible(GUIEditor_Window[2], false) guiSetVisible(GUIEditor_Window[3], false) guiSetVisible(GUIEditor_Window[4], false) showCursor(false) function VerLaGUI() guiSetVisible( "GUIEditor_Window[1]", true ) showCursor(true) end bindKey("F2", "down", VerLaGUI) ----------------------------------------------------- --Los Markers y Blips---- local marker = createMarker(2131.91846, -1149.65430, 23.4, "cylinder", 1.5, 255, 0, 0 ) createBlipAttachedTo(marker,55,2,0,255,0,0,0,200) ----------------------------------------------------- ----------------------------------------------------- --LasFunciones---- function VerLaGUI() guiSetVisible(GUIEditor_Window[1], not guiGetVisible(GUIEditor_Window[1])) showCursor(guiGetVisible(GUIEditor_Window[1])) end bindKey("F2", "down", VerLaGUI) addEventHandler("onClientGUIClick", root, function() if ( source == GUIEditor_Button[12] ) then guiSetVisible(GUIEditor_Window[2], false) guiSetVisible(GUIEditor_Window[3], false) showCursor(false) setCameraTarget(localPlayer,localPlayer) end end ) function markerHit (hitPlayer) if ( hitPlayer == localPlayer ) then guiSetVisible (GUIEditor_Window[2], true) guiSetVisible (GUIEditor_Window[3], true) showCursor (true) triggerServerEvent("lacamara", localPlayer, hitPlayer) end end addEventHandler ("onClientMarkerHit", marker, markerHit) -----ElAuto---- local tCars = { } Prototype = function ( ) local uRow, uCol = guiGridListGetSelectedItem ( source ); if ( uRow and uCol and uRow ~= -1 and uCol ~= -1 ) then local id = 0 if ( #tCars >= 1 ) then destroyElement ( tCars [ #tCars ] ) end local sName = guiGridListGetItemText ( GUIEditor_Grid[1], uRow, uCol ); tCars [ id + 1 ] = createVehicle ( getVehicleModelFromName ( sName ), -1655.20386, 1209.95129, 21.15625 ); end end addEventHandler ( 'onClientGUIClick', GUIEditor_Grid[1],Prototype ) Try.

GUIEditor_Window = {} GUIEditor_Button = {} GUIEditor_Label = {} GUIEditor_Edit = {} GUIEditor_Grid = {} GUIEditor_Window[1] = guiCreateWindow(11,92,229,464,"Mi panel de Spawn",false) GUIEditor_Button[1] = guiCreateButton(9,29,209,43,"Spawnear Vehiculo",false,GUIEditor_Window[1]) GUIEditor_Button[2] = guiCreateButton(9,75,208,41,"Spawnear Vehiculo",false,GUIEditor_Window[1]) GUIEditor_Button[3] = guiCreateButton(9,118,208,41,"Spawnear Vehiculo",false,GUIEditor_Window[1]) GUIEditor_Button[4] = guiCreateButton(9,162,208,41,"Spawnear Vehiculo",false,GUIEditor_Window[1]) GUIEditor_Button[5] = guiCreateButton(9,251,208,41,"Spawnear Vehiculo",false,GUIEditor_Window[1]) GUIEditor_Button[6] = guiCreateButton(9,206,208,41,"Spawnear Vehiculo",false,GUIEditor_Window[1]) GUIEditor_Button[7] = guiCreateButton(10,296,206,41,"Spawnear Vehiculo",false,GUIEditor_Window[1]) GUIEditor_Button[8] = guiCreateButton(10,340,206,41,"Spawnear Vehiculo",false,GUIEditor_Window[1]) GUIEditor_Label[1] = guiCreateLabel(12,396,205,56,"GUI Creada por ElMota",false,GUIEditor_Window[1]) guiLabelSetColor(GUIEditor_Label[1],255,255,0) guiSetFont(GUIEditor_Label[1],"default-bold-small") GUIEditor_Window[2] = guiCreateWindow(11,340,219,216,"GUI Shop Panel",false) GUIEditor_Button[9] = guiCreateButton(18,70,168,32,"Comprar Vehiculo",false,GUIEditor_Window[2]) GUIEditor_Button[10] = guiCreateButton(18,109,168,32,"Vender Vehiculo",false,GUIEditor_Window[2]) GUIEditor_Button[11] = guiCreateButton(21,148,109,30,"Elejir un Color",false,GUIEditor_Window[2]) GUIEditor_Button[12] = guiCreateButton(22,26,75,39,"Cancelar",false,GUIEditor_Window[2]) GUIEditor_Window[3] = guiCreateWindow(544,249,240,326,"Vehiculos",false) GUIEditor_Grid[1] = guiCreateGridList(9,24,222,293,false,GUIEditor_Window[3]) guiGridListSetSelectionMode(GUIEditor_Grid[1],2) guiGridListAddColumn(GUIEditor_Grid[1],"Autos",0.5) guiGridListAddColumn(GUIEditor_Grid[1],"Precio $",0.3) local cars = {{493,699999},{484,300000},{446,1599999},{469,2999999},{563,5999999},{488,6999999},{487,6999999},{417,3999999},{548,4999999},{497,7999999},{579,60000},{400,60000},{404,28000},{489,65000},{505,65000},{479,45000},{442,45000},{458,45000},{602,50000},{496,42500},{401,41000},{518,60000},{527,75000},{589,75000},{419,45000},{533,75000},{526,50000},{474,55000},{545,50000},{517,45000},{410,41000},{600,50000},{436,41000},{580,50000},{439,75000},{549,75000},{491,45000},{445,45000},{507,45000},{585,45000},{587,75000},{466,55000},{492,50000},{546,45000},{551,45000},{516,45000},{467,45000},{426,47500},{547,45000},{405,55000},{409,75000},{550,45000},{566,45000},{540,45000},{421,50000},{529,45000},{402,12000},{542,65000},{603,12000},{475,75000},{562,120000},{565,95000},{559,120000},{561,50000},{560,120000},{558,100000},{429,120000},{541,120000},{415,120000},{480,95000},{434,100000},{494,120000},{502,120000},{503,120000},{411,120000},{506,120000},{451,120000},{555,95000},{477,95000},{499,25000},{498,25000},{578,50000},{486,70000},{455,75000},{588,50000},{403,75000},{414,50000},{443,75000},{515,75000},{514,75000},{531,12000},{456,45000},{422,45000},{482,95000},{530,12000},{418,45000},{572,12000},{582,50000},{413,5000},{440,50000},{543,65000},{583,12000},{478,35000},{554,50000},{536,75000},{575,75000},{534,75000},{567,75000},{535,75000},{576,75000},{412,75000},{568,75000},{457,12000},{483,45000},{508,40000},{571,10000},{500,55000},{444,120000},{556,120000},{557,120000},{471,20000},{495,100000},{539,75000},{481,25050},{509,2500},{581,45000},{462,12000},{521,60000},{463,50000},{522,75000},{448,12000},{468,45000},{586,45000},{485,12000},{431,60000},{438,45000},{437,60000},{574,12000},{420,45000},{525,75000},{408,50000},{428,65000}} for i,v in ipairs (cars) do local carName = getVehicleNameFromModel (v[1]) local row = guiGridListAddRow (GUIEditor_Grid[1]) guiGridListSetItemText (GUIEditor_Grid[1], row, 1, carName, false, true) guiGridListSetItemText (GUIEditor_Grid[1], row, 2, tostring(v[2]), false, true) end GUIEditor_Window[4] = guiCreateWindow(252,171,410,105,"Verificacion",false) GUIEditor_Label[2] = guiCreateLabel(10,29,391,25,"Porfavor elije aqui un slot para tu vehiculo",false,GUIEditor_Window[4]) guiLabelSetColor(GUIEditor_Label[2],255,255,0) guiSetFont(GUIEditor_Label[2],"default-bold-small") GUIEditor_Edit[1] = guiCreateEdit(242,57,43,25,"",false,GUIEditor_Window[4]) guiEditSetMaxLength(GUIEditor_Edit[1],1) GUIEditor_Button[13] = guiCreateButton(10,59,100,37,"Acepto",false,GUIEditor_Window[4]) GUIEditor_Button[14] = guiCreateButton(112,65,100,31,"Cancelar",false,GUIEditor_Window[4]) guiSetVisible(GUIEditor_Window[1], false) guiSetVisible(GUIEditor_Window[2], false) guiSetVisible(GUIEditor_Window[3], false) guiSetVisible(GUIEditor_Window[4], false) showCursor(false) function VerLaGUI() guiSetVisible( "GUIEditor_Window[1]", true ) showCursor(true) end bindKey("F2", "down", VerLaGUI) ----------------------------------------------------- --Los Markers y Blips---- local marker = createMarker(2131.91846, -1149.65430, 23.4, "cylinder", 1.5, 255, 0, 0 ) createBlipAttachedTo(marker,55,2,0,255,0,0,0,200) ----------------------------------------------------- ----------------------------------------------------- --LasFunciones---- function VerLaGUI() guiSetVisible(GUIEditor_Window[1], not guiGetVisible(GUIEditor_Window[1])) showCursor(guiGetVisible(GUIEditor_Window[1])) end bindKey("F2", "down", VerLaGUI) addEventHandler("onClientGUIClick", root, function() if ( source == GUIEditor_Button[12] ) then guiSetVisible(GUIEditor_Window[2], false) guiSetVisible(GUIEditor_Window[3], false) showCursor(false) setCameraTarget(localPlayer,localPlayer) end end ) function markerHit (hitPlayer) if ( hitPlayer == localPlayer ) then guiSetVisible (GUIEditor_Window[2], true) guiSetVisible (GUIEditor_Window[3], true) showCursor (true) triggerServerEvent("lacamara", localPlayer, hitPlayer) end end addEventHandler ("onClientMarkerHit", marker, markerHit) -----ElAuto---- local tCars = { } Prototype = function ( ) local uRow, uCol = guiGridListGetSelectedItem ( source ); if ( uRow and uCol and uRow ~= -1 and uCol ~= -1 ) then local id = 0 local sName = guiGridListGetItemText ( GUIEditor_Grid[1], uRow, uCol ); tCars [ id + 1 ] = createVehicle ( getVehicleModelFromName ( sName ), -1655.20386, 1209.95129, 21.15625 ); end end addEventHandler ( 'onClientGUIClick', GUIEditor_Grid[1],Prototype ) local lastCarID = #tCars destroyElement ( tCars [ lastCarID ] )

Show line 116.

viewtopic.php?f=91&t=42070&p=425473#p425473

Copy my code again.

Ah, I thought marker is about other thing, because markers don't have nothing related to this.

Is the positions right? I can't find any error in the code.

local tCars = { } Prototype = function ( ) local uRow, uCol = guiGridListGetSelectedItem ( source ); if ( uRow and uCol and uRow ~= -1 and uCol ~= -1 ) then local id = 0 local sName = guiGridListGetItemText ( GUIEditor_Grid[1], uRow, uCol ); tCars = [ id + 1 ] = createVehicle ( getVehicleModelFromName ( sName ), -1655.20386, 1209.95129, 21.15625 ); end end addEventHandler ( 'onClientGUIClick', GUIEditor_Grid[1],Prototype ) To delete the last car: local lastCarID = #tCars destroyElement ( tCars [ lastCarID ] ) Idk if it's right.. Test

guiGridListGetSelectedItem guiGridListGetItemText

What's your machine system and version?

Can you explain me what is "My Sequel"? As far as I know, MySQL is MySQL and SQL is "Structured Query Language".

Do you have 2 or more MySQL servers with same database running on the same machine?

I had this error too sometimes in MySQL console. I reinstalled MySQL and now is working perfectly.

X-SHADOW, we are not talking about 'shutdown' command -.- We are talking about MySQL connection, the problem is: the script can't connect to the mysql database.

X-SHADOW it have nothing about admin rights.

local tDrugTimer = { } function timerAnzeigen ( ) guiSetVisible ( Drugs_Window, false ) guiSetVisible ( Create_Window, true ) time = 20 guiSetText ( Create_LBL_Timer, tonumber ( time ) .. ' Minuten' ) tDrugTimer [ localPlayer ] = setTimer ( updateTimerZeit, 1000, 0, localPlayer ) end function updateTimerZeit ( player ) time = time - 1 if ( time <= 0 ) then killTimer ( tDrugTimer [ player ] ) guiSetVisible ( Create_Window, false ) else guiSetText ( Create_LBL_Timer, tonumber ( time ) .. ' Minuten' ) end end addEventHandler ( 'onClientPlayerQuit', root, function ( ) if ( isTimer ( tDrugTimer [ source ] ) ) then tDrugTimer [ source ] = nil end end )

Just load modified files, don't need to change my code. As I said: This not affect modified files.

This is only a table with the objects and a for-loop to set all elements collision. This not affect modified files.

Copy my code again, I solved an issue.

No. If work, you need only to add more createObject