Creando mi Primer SQL

iFoReX · May 5, 2012

que esta mal ? me sale error cerca del INTO expected near ')' linea 146

aqui los codes

-------------Server--------- 
function cb1 ( ) 
    local money = getPlayerMoney ( source ) 
    local name = getPlayerName ( source ) 
    if name == "~ElMota~" then 
    destroyElement(blip2) 
    destroyElement(blip3) 
    destroyElement(blip4) 
    destroyElement(blip5) 
    blip1 = createBlipAttachedTo( source, 58 ) 
    else 
        if ( money >= 6000 ) then 
            takePlayerMoney ( source, 6000 ) 
            destroyElement(blip2) 
            destroyElement(blip3) 
            destroyElement(blip4) 
            destroyElement(blip5) 
            blip1 = createBlipAttachedTo( source, 58 ) 
        else 
            outputChatBox ( "No Tienes Suficiente Dinero", source ) 
        end 
    end 
end 
addEvent( "comprarBlip1", true ) 
addEventHandler( "comprarBlip1", getRootElement(), cb1 ) 
  
function cb2() 
    local money = getPlayerMoney ( source ) 
    local name = getPlayerName ( source ) 
    if name == "~ElMota~" then 
destroyElement("blip1") 
destroyElement("blip3") 
destroyElement("blip4") 
destroyElement("blip5") 
blip2 = createBlipAttachedTo( source, 59 ) 
    else 
        if ( money >= 6000 ) then 
            takePlayerMoney ( source, 6000 ) 
destroyElement("blip1") 
destroyElement("blip3") 
destroyElement("blip4") 
destroyElement("blip5") 
blip2 = createBlipAttachedTo( source, 59 ) 
        else 
            outputChatBox ( "No Tienes Suficiente Dinero", source ) 
        end 
    end 
end 
addEvent( "comprarBlip2", true ) 
addEventHandler( "comprarBlip2", getRootElement(), cb2 ) 
  
function cb3() 
    local money = getPlayerMoney ( source ) 
    local name = getPlayerName ( source ) 
    if name == "~ElMota~" then 
destroyElement(blip1) 
destroyElement(blip2) 
destroyElement(blip4) 
destroyElement(blip5) 
blip3 = createBlipAttachedTo( source, 60 ) 
    else 
        if ( money >= 6000 ) then 
            takePlayerMoney ( source, 6000 ) 
destroyElement(blip1) 
destroyElement(blip2) 
destroyElement(blip4) 
destroyElement(blip5) 
blip3 = createBlipAttachedTo( source, 60 ) 
        else 
            outputChatBox ( "No Tienes Suficiente Dinero", source ) 
        end 
    end 
end 
addEvent( "comprarBlip3", true ) 
addEventHandler( "comprarBlip3", getRootElement(), cb3 ) 
  
function cb4() 
    local money = getPlayerMoney ( source ) 
    local name = getPlayerName ( source ) 
    if name == "~ElMota~" then 
destroyElement(blip1) 
destroyElement(blip2) 
destroyElement(blip3) 
destroyElement(blip5) 
blip4 = createBlipAttachedTo( source, 61 ) 
    else 
        if ( money >= 6000 ) then 
            takePlayerMoney ( source, 6000 ) 
destroyElement(blip1) 
destroyElement(blip2) 
destroyElement(blip3) 
destroyElement(blip5) 
blip4 = createBlipAttachedTo( source, 61 ) 
        else 
            outputChatBox ( "No Tienes Suficiente Dinero", source ) 
        end 
    end 
end 
addEvent( "comprarBlip4", true ) 
addEventHandler( "comprarBlip4", getRootElement(), cb4 ) 
  
function cb5() 
    local money = getPlayerMoney ( source ) 
    local name = getPlayerName ( source ) 
    if name == "~ElMota~" then 
destroyElement(blip1) 
destroyElement(blip2) 
destroyElement(blip3) 
destroyElement(blip4) 
blip5 = createBlipAttachedTo( source, 62 ) 
    else 
        if ( money >= 6000 ) then 
            takePlayerMoney ( source, 6000 ) 
destroyElement(blip1) 
destroyElement(blip2) 
destroyElement(blip3) 
destroyElement(blip4) 
blip5 = createBlipAttachedTo( source, 62 ) 
        else 
            outputChatBox ( "No Tienes Suficiente Dinero", source ) 
        end 
    end 
end 
addEvent( "comprarBlip5", true ) 
addEventHandler( "comprarBlip5", getRootElement(), cb5 ) 
  
function cb6() 
destroyElement(blip1) 
destroyElement(blip2) 
destroyElement(blip3) 
destroyElement(blip4) 
destroyElement(blip5) 
end 
addEvent( "comprarBlip6", true ) 
addEventHandler( "comprarBlip6", getRootElement(), cb6 ) 
  
addEventHandler("onResourceStart", getResourceRootElement(getThisResource()),  
function() 
executeSQLQuery("CREATE TABLE IF NOT EXISTS blips (Cuenta STRING,blipN NUMBER)") 
end 
) 
  
addEventHandler("onPlayerQuit", getRootElement(),  
function() 
obtenerB = getBlipIcon( source ) 
executeSQLInsert(INSERT INTO 'blips' ('Cuenta', 'blipN') VALUES ('..getAccountName( source )..', '..obtenerB..')) 
end 
) 
  
addEventHandler("onPlayerLogin" getRootElement(),  
function() 
  
local consulta = executeSQLQuery("SELECT * FROM blips WHERE Cuenta = '"..getPlayerName(source).."'") 
local consulta2 = executeSQLQuery("SELECT * FROM blips WHERE blipN = '"..attachElements( source, obtenerB ).."'") 
end 
)

GUIEditor_Window = {} 
GUIEditor_Button = {} 
GUIEditor_Label = {} 
GUIEditor_Image = {} 
  
GUIEditor_Window[1] = guiCreateWindow(0.36,0.225,0.2412,0.6017,"GUI Blips",true) 
guiWindowSetMovable(GUIEditor_Window[1],false) 
guiWindowSetSizable(GUIEditor_Window[1],false) 
GUIEditor_Image[1] = guiCreateStaticImage(34,63,31,26,"images/Blip58.png",false,GUIEditor_Window[1]) 
GUIEditor_Button[1] = guiCreateButton(69,63,105,28,"Buy Blip58",false,GUIEditor_Window[1]) 
GUIEditor_Image[2] = guiCreateStaticImage(33,106,32,30,"images/Blip59.png",false,GUIEditor_Window[1]) 
GUIEditor_Button[2] = guiCreateButton(69,108,105,28,"Buy Blip59",false,GUIEditor_Window[1]) 
GUIEditor_Image[3] = guiCreateStaticImage(33,151,32,32,"images/Blip60.png",false,GUIEditor_Window[1]) 
GUIEditor_Button[3] = guiCreateButton(69,157,105,28,"Buy Blip60",false,GUIEditor_Window[1]) 
GUIEditor_Image[4] = guiCreateStaticImage(33,204,32,31,"images/Blip61.png",false,GUIEditor_Window[1]) 
GUIEditor_Button[4] = guiCreateButton(69,208,105,28,"Buy Blip61",false,GUIEditor_Window[1]) 
GUIEditor_Image[5] = guiCreateStaticImage(33,253,32,27,"images/Blip62.png",false,GUIEditor_Window[1]) 
GUIEditor_Button[5] = guiCreateButton(69,255,105,28,"Buy Blip62",false,GUIEditor_Window[1]) 
GUIEditor_Label[1] = guiCreateLabel(31,292,149,18,"GUI Blips by ElMota",false,GUIEditor_Window[1]) 
guiLabelSetColor(GUIEditor_Label[1],255,255,0) 
GUIEditor_Button[6] = guiCreateButton(68,322,108,28,"Usar el de defecto",false,GUIEditor_Window[1]) 
  
guiSetVisible(GUIEditor_Window[1],false) 
showCursor(false) 
  
bindKey("F7","down",  
function() 
guiSetVisible(GUIEditor_Window[1], not guiGetVisible(GUIEditor_Window[1])) 
showCursor(guiGetVisible(GUIEditor_Window[1])) 
end 
) 
  
addEventHandler("onClientMouseEnter", root,  
function() 
if source == GUIEditor_Button[1] then 
guiSetText(GUIEditor_Label[1], "Price : 6000") 
guiLabelSetColor(GUIEditor_Label[1], 0, 0, 255) 
elseif source == GUIEditor_Button[2] then 
guiLabelSetColor(GUIEditor_Label[1], 0, 0, 255) 
guiSetText(GUIEditor_Label[1], "Price : 6000") 
elseif source == GUIEditor_Button[3] then 
guiLabelSetColor(GUIEditor_Label[1], 0, 0, 255) 
guiSetText(GUIEditor_Label[1], "Price : 6000") 
elseif source == GUIEditor_Button[4] then 
guiLabelSetColor(GUIEditor_Label[1], 0, 0, 255) 
guiSetText(GUIEditor_Label[1], "Price : 6000") 
elseif source == GUIEditor_Button[5] then 
guiLabelSetColor(GUIEditor_Label[1], 0, 0, 255) 
guiSetText(GUIEditor_Label[1], "Price : 6000") 
end 
end 
) 
  
addEventHandler("onClientMouseLeave", root,  
function() 
if source == GUIEditor_Button[1] then 
guiLabelSetColor(GUIEditor_Label[1], 255, 255, 0) 
guiSetText(GUIEditor_Label[1], "GUI Blips by ElMota") 
elseif source == GUIEditor_Button[2] then 
guiLabelSetColor(GUIEditor_Label[1], 255, 255, 0) 
guiSetText(GUIEditor_Label[1], "GUI Blips by ElMota") 
elseif source == GUIEditor_Button[3] then 
guiLabelSetColor(GUIEditor_Label[1], 255, 255, 0) 
guiSetText(GUIEditor_Label[1], "GUI Blips by ElMota") 
elseif source == GUIEditor_Button[4] then 
guiLabelSetColor(GUIEditor_Label[1], 255, 255, 0) 
guiSetText(GUIEditor_Label[1], "GUI Blips by ElMota") 
elseif source == GUIEditor_Button[5] then 
guiLabelSetColor(GUIEditor_Label[1], 255, 255, 0) 
guiSetText(GUIEditor_Label[1], "GUI Blips by ElMota") 
end 
end 
) 
  
addEventHandler("onClientGUIClick", root,  
function() 
if source == GUIEditor_Button[1] then 
triggerServerEvent("comprarBlip1", getLocalPlayer()) 
elseif source == GUIEditor_Button[2] then 
triggerServerEvent("comprarBlip2", getLocalPlayer()) 
elseif source == GUIEditor_Button[3] then 
triggerServerEvent("comprarBlip3", getLocalPlayer()) 
elseif source == GUIEditor_Button[4] then 
triggerServerEvent("comprarBlip4", getLocalPlayer()) 
elseif source == GUIEditor_Button[5] then 
triggerServerEvent("comprarBlip5", getLocalPlayer()) 
elseif source == GUIEditor_Button[6] then 
triggerServerEvent("comprarBlip6", getLocalPlayer()) 
end 
end 
)

gracias de antemano

Edikosh998 · May 5, 2012

Te falto las comillas del principio, y de los dos valores.

  
  
local account = getPlayerAccount(source) 
executeSQLQuery("INSERT INTO blips (Cuenta, blipN) VALUES ('"..getAccountName( account).."', '"..obtenerB.."')")

Y pone query, no pongas insert porque es diferente.

Otra aclaracion, yo puse los ' ' como aclaracion, no se si lo toma como valido (creo que no hay problema en ponerlo, pero como nunca lo use, ni idea).

EDIT : otro super detalle , no pongas ...getAccountName(source) , porque necesitas el account no el player

iFoReX · May 5, 2012

Edikosh entonces que coloco ? getPlayerName( source ) ?

Alexs · May 5, 2012

local account = getPlayerAccount(thePlayer)

iFoReX · May 5, 2012

ahh Ok pero mi codigo estaba bueno verdad ?

Alexs · May 5, 2012

Creo..

iFoReX · May 5, 2012

Ook lo voy a probar y digo que tal, es que es mi primera vez creando codigos con SQL D:

iFoReX · May 5, 2012

no funciono D: me compre un blip reconecte y ya no tenia el blip D:

-------------Server--------- 
function cb1 ( ) 
    local money = getPlayerMoney ( source ) 
    local name = getPlayerName ( source ) 
    if name == "~ElMota~" then 
    destroyElement(blip2) 
    destroyElement(blip3) 
    destroyElement(blip4) 
    destroyElement(blip5) 
    blip1 = createBlipAttachedTo( source, 58 ) 
    else 
        if ( money >= 6000 ) then 
            takePlayerMoney ( source, 6000 ) 
            destroyElement(blip2) 
            destroyElement(blip3) 
            destroyElement(blip4) 
            destroyElement(blip5) 
            blip1 = createBlipAttachedTo( source, 58 ) 
        else 
            outputChatBox ( "No Tienes Suficiente Dinero", source ) 
        end 
    end 
end 
addEvent( "comprarBlip1", true ) 
addEventHandler( "comprarBlip1", getRootElement(), cb1 ) 
  
function cb2() 
    local money = getPlayerMoney ( source ) 
    local name = getPlayerName ( source ) 
    if name == "~ElMota~" then 
destroyElement("blip1") 
destroyElement("blip3") 
destroyElement("blip4") 
destroyElement("blip5") 
blip2 = createBlipAttachedTo( source, 59 ) 
    else 
        if ( money >= 6000 ) then 
            takePlayerMoney ( source, 6000 ) 
destroyElement("blip1") 
destroyElement("blip3") 
destroyElement("blip4") 
destroyElement("blip5") 
blip2 = createBlipAttachedTo( source, 59 ) 
        else 
            outputChatBox ( "No Tienes Suficiente Dinero", source ) 
        end 
    end 
end 
addEvent( "comprarBlip2", true ) 
addEventHandler( "comprarBlip2", getRootElement(), cb2 ) 
  
function cb3() 
    local money = getPlayerMoney ( source ) 
    local name = getPlayerName ( source ) 
    if name == "~ElMota~" then 
destroyElement(blip1) 
destroyElement(blip2) 
destroyElement(blip4) 
destroyElement(blip5) 
blip3 = createBlipAttachedTo( source, 60 ) 
    else 
        if ( money >= 6000 ) then 
            takePlayerMoney ( source, 6000 ) 
destroyElement(blip1) 
destroyElement(blip2) 
destroyElement(blip4) 
destroyElement(blip5) 
blip3 = createBlipAttachedTo( source, 60 ) 
        else 
            outputChatBox ( "No Tienes Suficiente Dinero", source ) 
        end 
    end 
end 
addEvent( "comprarBlip3", true ) 
addEventHandler( "comprarBlip3", getRootElement(), cb3 ) 
  
function cb4() 
    local money = getPlayerMoney ( source ) 
    local name = getPlayerName ( source ) 
    if name == "~ElMota~" then 
destroyElement(blip1) 
destroyElement(blip2) 
destroyElement(blip3) 
destroyElement(blip5) 
blip4 = createBlipAttachedTo( source, 61 ) 
    else 
        if ( money >= 6000 ) then 
            takePlayerMoney ( source, 6000 ) 
destroyElement(blip1) 
destroyElement(blip2) 
destroyElement(blip3) 
destroyElement(blip5) 
blip4 = createBlipAttachedTo( source, 61 ) 
        else 
            outputChatBox ( "No Tienes Suficiente Dinero", source ) 
        end 
    end 
end 
addEvent( "comprarBlip4", true ) 
addEventHandler( "comprarBlip4", getRootElement(), cb4 ) 
  
function cb5() 
    local money = getPlayerMoney ( source ) 
    local name = getPlayerName ( source ) 
    if name == "~ElMota~" then 
destroyElement(blip1) 
destroyElement(blip2) 
destroyElement(blip3) 
destroyElement(blip4) 
blip5 = createBlipAttachedTo( source, 62 ) 
    else 
        if ( money >= 6000 ) then 
            takePlayerMoney ( source, 6000 ) 
destroyElement(blip1) 
destroyElement(blip2) 
destroyElement(blip3) 
destroyElement(blip4) 
blip5 = createBlipAttachedTo( source, 62 ) 
        else 
            outputChatBox ( "No Tienes Suficiente Dinero", source ) 
        end 
    end 
end 
addEvent( "comprarBlip5", true ) 
addEventHandler( "comprarBlip5", getRootElement(), cb5 ) 
  
function cb6() 
destroyElement(blip1) 
destroyElement(blip2) 
destroyElement(blip3) 
destroyElement(blip4) 
destroyElement(blip5) 
end 
addEvent( "comprarBlip6", true ) 
addEventHandler( "comprarBlip6", getRootElement(), cb6 ) 
  
addEventHandler("onResourceStart", getResourceRootElement(getThisResource()),  
function() 
executeSQLQuery("CREATE TABLE IF NOT EXISTS blips (Cuenta STRING,blipN NUMBER)") 
end 
) 
  
addEventHandler("onPlayerQuit", getRootElement(),  
function() 
obtenerB = getBlipIcon( source ) 
local account = getPlayerAccount(thePlayer) 
executeSQLQuery("INSERT INTO blips (Cuenta, blipN) VALUES ('"..getAccountName( account).."', '"..obtenerB.."')") 
end 
) 
  
addEventHandler("onPlayerLogin", getRootElement(),  
function() 
local consulta = executeSQLQuery("SELECT * FROM blips WHERE Cuenta = '"..getPlayerName(source).."'") 
local consulta2 = executeSQLQuery("SELECT * FROM blips WHERE blipN = '"..attachElements( source, obtenerB ).."'") 
end 
)

Alexs · May 5, 2012

Si solo son Blips mejor usas los AccounData que son mas simples

Edikosh998 · May 6, 2012

Alex podes usar SQL para TODO. El tema es que lo uso mal...

  
  
function(_,account) 
local query = executeSQLQuery("SELECT * FROM blips WHERE Cuenta = '"..getAccountName(account).."'") 
if #query == 1 then 
createBlipAttachedTo(source,query[1]["blipN"]) 
  
end 
end

Si entendi bien, eso es lo que queres, que se atachee el blip al jugador, por lo tanto si guardas el numero de blip

iFoReX · May 6, 2012

eso es cuando el player se logge verdad ?

Edikosh998 · May 6, 2012

Exactamente, si vos guardaste una fila con el nombre del account y el ID del blip, despues cuando loguea, si el tipo tiene un blip...Se lo ataccheas ni bien loguea

iFoReX · May 6, 2012

no funciono cuando reconecto el blip se queda ahy y no se atachea asia mi D:

Edikosh998 · May 6, 2012

Sino hacelo onPlayerSpawn

Sign In

Creando mi Primer SQL

Recommended Posts

iFoReX

Edikosh998

iFoReX

Alexs

iFoReX

Alexs

iFoReX

iFoReX

Alexs

Edikosh998

iFoReX

Edikosh998

iFoReX

Edikosh998

Recently Browsing 0 members

Browse

Activity

MTA Network

Social Media