Wei Posted July 20, 2012 Posted July 20, 2012 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 Diet with russian vodka, lose 3 days in one week !
Castillo Posted July 20, 2012 Posted July 20, 2012 Rename your table to something else. San Andreas Utopia RPG (SAUR) Owner & Developer. Education is the most powerful weapon which you can use to change the world.
Wei Posted July 20, 2012 Author Posted July 20, 2012 Thanks it works ! Diet with russian vodka, lose 3 days in one week !
Castillo Posted July 20, 2012 Posted July 20, 2012 You're welcome. San Andreas Utopia RPG (SAUR) Owner & Developer. Education is the most powerful weapon which you can use to change the world.
Wei Posted July 21, 2012 Author Posted July 21, 2012 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 ? Diet with russian vodka, lose 3 days in one week !
Wei Posted July 21, 2012 Author Posted July 21, 2012 any1 ? Diet with russian vodka, lose 3 days in one week !
Castillo Posted July 21, 2012 Posted July 21, 2012 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 ) San Andreas Utopia RPG (SAUR) Owner & Developer. Education is the most powerful weapon which you can use to change the world.
Wei Posted July 21, 2012 Author Posted July 21, 2012 Thanks Diet with russian vodka, lose 3 days in one week !
Recommended Posts
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now