executeSQL problem

[seal]

I'll like to save players' characters name into an sql table, but i got this debug message:

attemp to call global: executesqlquery(a nil value)

pls help me what do i wrong

function createLoginWindow(thePlayer) 
  showCursor(true, true) 
  wdwLogin = guiCreateWindow(0.425, 0.425,0.15, 0.15, "Type your character's name", true) 
  cname = guiCreateEdit(0.25, 0.2, 0.5, 0.15, "", true, wdwLogin) 
  guiEditSetMaxLength(cname, 15) 
  btnLogin = guiCreateButton(0.375, 0.7, 0.25, 0.2, "Save", true, wdwLogin) 
  addEventHandler ( "onClientGUIClick", btnLogin, saveNick, false ) 
  outputDebugString( "leves" ) 
end 
  
addCommandHandler("leves", createLoginWindow) 
  
function saveNick(button) 
  if button == "left" then 
    local nickname = guiGetText ( cname ) 
    executeSQLQuery("INSERT INTO accounts(character) VALUES(?)", cname ) 
    guiSetVisible(wdwLogin, false) 
    destroyElement ( wdwLogin ) 
    showCursor (  false ) 
  end 
end 

[iPrestege]

Because the sql function undefined in the client side .

[Baseplate]

executeSQLQuery is server sided only, and I'm even questioning if you really can script.

Client

function createLoginWindow(thePlayer) 
  showCursor(true, true) 
  wdwLogin = guiCreateWindow(0.425, 0.425,0.15, 0.15, "Type your character's name", true) 
  cname = guiCreateEdit(0.25, 0.2, 0.5, 0.15, "", true, wdwLogin) 
  guiEditSetMaxLength(cname, 15) 
  btnLogin = guiCreateButton(0.375, 0.7, 0.25, 0.2, "Save", true, wdwLogin) 
  addEventHandler ( "onClientGUIClick", btnLogin, saveNick, false ) 
  outputDebugString( "leves" ) 
end 
  
addCommandHandler("leves", createLoginWindow) 
  
function saveNick(button) 
  if button == "left" then 
    local nickname = guiGetText ( cname ) 
    triggerServerEvent("saveCharacter", nickname) 
    guiSetVisible(wdwLogin, false) 
    destroyElement ( wdwLogin ) 
    showCursor (  false ) 
  end 
end 

Server

addEvent("saveCharacter", true) 
addEventHandler("saveCharacter", root, 
function(nickname) 
executeSQLQuery("INSERT INTO accounts(character) VALUES(?)", nickname) 
end 
) 

[TAPL]

triggerServerEvent("saveCharacter", nickname) 

^^

triggerServerEvent("saveCharacter", localPlayer, nickname) 

[Baseplate]

OOPS! Sorry lol, my mind isn't working correctly these days.

[seal]

thanks, i forgot it and now it is corrected thanks