Problem with query ?

[botshara]

 [20:15:13] Starting items [ [20:15:13] SCRIPT ERROR: items/items_functions.lua:6: ')' expected (to close '(' [20;2Hat line 1) near '}'  
[ [20:15:13] ERROR: Loading script failed: items/items_functions.lua:6: ')' expect [ Hed (to close '(' at line 1) near '}'  

addEventHandler("onPlayerLogin", root, 
function() 
local getfightstyle = exports.sql:query_fetch_assoc("SELECT characterID, fightstyle FROM characters WHERE characterID = " .. exports.players:getCharacterID( source )) 
setPedFightingStyle(source, tonumber(getfightstyle["fightstyle"])) 
end 
} 

[Tete omar]

addEventHandler("onPlayerLogin", root, 
    function() 
        local getfightstyle = exports.sql:query_fetch_assoc("SELECT characterID, fightstyle FROM characters WHERE characterID = '" .. exports.players:getCharacterID( source )) .. "'") 
        setPedFightingStyle(source, tonumber(getfightstyle["fightstyle"])) 
    end 
) 

[botshara]

No errors but doesnt get fightstyle from database or event doesnt start ?

addEventHandler("onPlayerLogin", root,  
function()  
if exports.players:isLoggedIn( source ) then 
 local characterID = exports.players:getCharacterID( source )  
 local getfightstyle = exports.sql:query_fetch_assoc("SELECT fightstyle FROM characters WHERE characterID = " .. characterID )  
        setPedFightingStyle(source, tonumber(getfightstyle["fightstyle"]))  
end  
end 
 ) 

[botshara]

up

[Spajk]

Add

outputChatBox(characterID) 

Then tell me what it writes in the chat.

[Renkon]

setPedFightingStyle(source, tonumber(getfightstyle["fightstyle"])) 

should eb

setPedFightingStyle(source, tonumber(getfightstyle[1]["fightstyle"]))