SQL

[Wei]

executeSQLInsert ( "group", "'"..groupName.."', '"..groupTag.."', '" .. groupType .. "', '"..groupColorR.."', '"..groupColorG.."', '"..groupColorB.."', '"..getAccountName(getPlayerAccount(source)).."'" ) 
     

I can't f****** find whats wrong....

ERROR:Database query failed: near "group": syntax error

[Castillo]

Rename your table to something else.

[Wei]

Thanks it works !

[Castillo]

You're welcome.

[Wei]

I have 2 questions more.

addEvent("groupSystem:isCreator", true ) 
addEventHandler("groupSystem:isCreator", getRootElement(), 
function( ) 
local isCreator = executeSQLSelect("group_", "groupCreator", "groupCreator = '"..getAccountName(getPlayerAccount(source)).."'") 
    if isCreator then 
    triggerClientEvent(source, "groupSystem:showRemoveGroup", source, true ) 
    end 
end 
) 

why this allways returns true ?

addEvent("groupSystem:removeGroup", true ) 
addEventHandler("groupSystem:removeGroup", getRootElement(), 
function() 
    executeSQLDelete("group_", "groupName = '"..getElementData(source, "Group").."'") 
end 
) 
  

How can I make this that it will remove the whole line ?

[Wei]

any1 ?

[Castillo]

addEvent ( "groupSystem:isCreator", true ) 
addEventHandler ( "groupSystem:isCreator", getRootElement(), 
    function ( ) 
        local isCreator = executeSQLSelect ( "group_", "groupCreator", "groupCreator = '".. getAccountName ( getPlayerAccount ( source ) ) .."'" ) 
        if ( isCreator and type ( isCreator ) == "table" and #isCreator == 1 ) then 
            triggerClientEvent ( source, "groupSystem:showRemoveGroup", source, true ) 
        end 
    end 
) 

[Wei]

Thanks