iFoReX Posted June 8, 2012 Posted June 8, 2012 que esta mal en esta function exportada ? sv-side addEventHandler("onResourceStart", resourceRoot, function() exports.sql:create_table('doingJob', { { name = 'Player', type = 'TEXT' }, { name = 'State', type = 'TEXT', default = 'false' }, } ) end ) addEvent("ChangeStateMYSQL",true) addEventHandler("ChangeStateMYSQL", getRootElement(), function() local theName = getPlayerName(source) local state = 'true' exports.sql:query_insertid( "INSERT INTO doingJob (Player, State,) VALUES (" .. table.concat( { theName, state } ) .. ")" ) end ) cl-side MedicB = {} MedicB[1] = guiCreateButton(551,189,199,42,"Si deseo hacerlo",false) guiSetVisible(MedicB[1],false) guiSetAlpha(MedicB[1],0) MedicB[2] = guiCreateButton(551,242,199,42,"No gracias",false) guiSetVisible(MedicB[2],false) guiSetAlpha(MedicB[2],0) function ambulanceDX() dxDrawText("No , Gracias !",558.0,250.0,743.0,277.0,tocolor(255,255,255,255),0.5,"bankgothic","left","top",false,false,true) dxDrawRectangle(552.0,244.0,196.0,40.0,tocolor(0,0,0,200),false) dxDrawText("Si, deseo hacerlo !",558.0,194.0,742.0,226.0,tocolor(255,255,255,255),0.5,"bankgothic","left","top",false,false,true) dxDrawRectangle(551.0,189.0,199.0,43.0,tocolor(0,0,0,220),false) dxDrawText("ambulancia ?",438.0,109.0,598.0,139.0,tocolor(255,255,255,255),0.5,"bankgothic","left","top",false,false,true) dxDrawText("Hola amigo, quieres trabajar conduciendo la",437.0,91.0,816.0,108.0,tocolor(255,255,255,255),0.5,"bankgothic","left","top",false,false,true) dxDrawRectangle(429.0,86.0,419.0,329.0,tocolor(0,0,0,200),false) end medicPed = createPed( 70, -2655.1479492188, 640.16479492188, 14.454549789429) setElementRotation(medicPed, 0, 0, 180) medicMarker = createMarker( -2655.0856933594, 639.46484375, 13.5, "cylinder", 1, 255,255,255, 100 ) function markerHit (hitPlayer) if ( hitPlayer == localPlayer ) then addEventHandler("onClientRender",root, ambulanceDX) guiSetVisible(MedicB[1],true) guiSetVisible(MedicB[2],true) showCursor (true) end end addEventHandler ("onClientMarkerHit", medicMarker, markerHit) addEventHandler("onClientResourceStart", getResourceRootElement(), function() exports.sql:create_table('doingJob', { { name = 'Player', type = 'TEXT' }, { name = 'State', type = 'TEXT', default = 'false' }, } ) end ) addEventHandler("onClientGUIClick", root, function() if source == MedicB[2] then removeEventHandler("onClientRender",root, ambulanceDX) guiSetVisible(MedicB[1],false) guiSetVisible(MedicB[2],false) showCursor(false) elseif source == MedicB[1] then triggerServerEvent("ChangeStateMYSQL", getLocalPlayer()) end end ) elMota/elFoReX De Vuelta En MTA *---------* Cuenta De Youtube En La Que Subo Tutoriales Acerca De MTA :3 https://www.youtube.com/user/KillersGPs
Castillo Posted June 8, 2012 Posted June 8, 2012 addEventHandler("onClientResourceStart", getResourceRootElement(), function() exports.sql:create_table('doingJob', { { name = 'Player', type = 'TEXT' }, { name = 'State', type = 'TEXT', default = 'false' }, } ) end ) Borra eso. San Andreas Utopia RPG (SAUR) Owner & Developer. Education is the most powerful weapon which you can use to change the world.
iFoReX Posted June 8, 2012 Author Posted June 8, 2012 pero sin eso se creara la tabla igual o no ? elMota/elFoReX De Vuelta En MTA *---------* Cuenta De Youtube En La Que Subo Tutoriales Acerca De MTA :3 https://www.youtube.com/user/KillersGPs
Castillo Posted June 8, 2012 Posted June 8, 2012 Pues claro, porque las funciones de MySQL son server side, y eso que tenes que borrar es client side. San Andreas Utopia RPG (SAUR) Owner & Developer. Education is the most powerful weapon which you can use to change the world.
iFoReX Posted June 8, 2012 Author Posted June 8, 2012 lol verdad se me habia olvidado borrar eso en el debugscript 3 unable to create table doingJob aqui los codigos cl-side MedicB = {} MedicB[1] = guiCreateButton(551,189,199,42,"Si deseo hacerlo",false) guiSetVisible(MedicB[1],false) guiSetAlpha(MedicB[1],0) MedicB[2] = guiCreateButton(551,242,199,42,"No gracias",false) guiSetVisible(MedicB[2],false) guiSetAlpha(MedicB[2],0) CancelB = {} CancelB[1] = guiCreateButton(0.4375,0.3967,0.1047,0.0383,"Cancelar Job",true) guiSetVisible(CancelB[1],false) guiSetAlpha(CancelB[1],0) CancelB[2] = guiCreateButton(0.4359,0.48,0.0672,0.04,"Cerrar",true) guiSetVisible(CancelB[2],false) guiSetAlpha(CancelB[2],0) function cancelDX() dxDrawText("Cerrar !",568.0,292.0,692.0,310.0,tocolor(255,255,255,255),0.5,"bankgothic","left","top",false,false,true) dxDrawText("Cancelar job !",568.0,243.0,692.0,261.0,tocolor(255,255,255,255),0.5,"bankgothic","left","top",false,false,true) dxDrawText("Cancelar Job",408.0,170.0,631.0,200.0,tocolor(255,255,255,255),1.0,"bankgothic","left","top",false,false,true) dxDrawRectangle(428.0,185.0,461.0,211.0,tocolor(0,0,0,200),false) end function ambulanceDX() dxDrawText("No , Gracias !",558.0,250.0,743.0,277.0,tocolor(255,255,255,255),0.5,"bankgothic","left","top",false,false,true) dxDrawRectangle(552.0,244.0,196.0,40.0,tocolor(0,0,0,200),false) dxDrawText("Si, deseo hacerlo !",558.0,194.0,742.0,226.0,tocolor(255,255,255,255),0.5,"bankgothic","left","top",false,false,true) dxDrawRectangle(551.0,189.0,199.0,43.0,tocolor(0,0,0,220),false) dxDrawText("ambulancia ?",438.0,109.0,598.0,139.0,tocolor(255,255,255,255),0.5,"bankgothic","left","top",false,false,true) dxDrawText("Hola amigo, quieres trabajar conduciendo la",437.0,91.0,816.0,108.0,tocolor(255,255,255,255),0.5,"bankgothic","left","top",false,false,true) dxDrawRectangle(429.0,86.0,419.0,329.0,tocolor(0,0,0,200),false) end medicPed = createPed( 70, -2655.1479492188, 640.16479492188, 14.454549789429) setElementRotation(medicPed, 0, 0, 180) medicMarker = createMarker( -2655.0856933594, 639.46484375, 13.5, "cylinder", 1, 255,255,255, 100 ) function markerHit (hitPlayer) if ( hitPlayer == localPlayer ) then addEventHandler("onClientRender",root, ambulanceDX) guiSetVisible(MedicB[1],true) guiSetVisible(MedicB[2],true) showCursor (true) end end addEventHandler ("onClientMarkerHit", medicMarker, markerHit) function markerHit2 (hitPlayer) if ( hitPlayer == localPlayer ) then addEventHandler("onClientRender",root, cancelDX) guiSetVisible(CancelB[1],true) guiSetVisible(CancelB[2],true) showCursor (true) end end addEventHandler("onClientGUIClick", root, function() if source == MedicB[2] then removeEventHandler("onClientRender",root, ambulanceDX) guiSetVisible(MedicB[1],false) guiSetVisible(MedicB[2],false) showCursor(false) elseif source == MedicB[1] then triggerServerEvent("ChangeStateMYSQL", getLocalPlayer()) end end ) sv-side addEventHandler("onResourceStart", resourceRoot, function() exports.sql:create_table('doingJob', { { name = 'Player', type = 'TEXT' }, { name = 'State', type = 'TEXT', default = 'false' }, } ) end ) addEvent("ChangeStateMYSQL",true) addEventHandler("ChangeStateMYSQL", getRootElement(), function() local theName = getPlayerName(source) local state = 'true' exports.sql:query_insertid( "INSERT INTO doingJob (Player, State,) VALUES (" .. table.concat( { theName, state } ) .. ")" ) end ) elMota/elFoReX De Vuelta En MTA *---------* Cuenta De Youtube En La Que Subo Tutoriales Acerca De MTA :3 https://www.youtube.com/user/KillersGPs
Recommended Posts