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 )
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.
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.
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 )
Recommended Posts