PauloCascus Posted October 29, 2014 Share Posted October 29, 2014 i have a problem with sqlite database just i want to create special database for ACL groups and i saw function like this ( but my shit isn't work ) executeSQLQuery do not created table into the db and i think this table has been created in internal.db becouze i saw some the same tables there sorry for bad english function groupdb() groupdb = dbConnect("sqlite", "group.db") if (groupdb) then executeSQLQuery("CREATE TABLE IF NOT EXIST group ( name TEXT, permission TEXT, accounts TEXT )") outputDebugString("You have seccessfully connected to the group.db") else outputDebugString("You have not connected to the group.db") end end addEventHandler("onResourceStart", getRootElement(), groupdb) Link to comment
WASSIm. Posted October 29, 2014 Share Posted October 29, 2014 lol if you want learn database functions look at this Database function groupdb() groupdb = dbConnect("sqlite", "group.db") if (groupdb) then dbExec(groupdb , "CREATE TABLE IF NOT EXIST group ( name TEXT, permission TEXT, accounts TEXT )") outputDebugString("You have seccessfully connected to the group.db") else outputDebugString("You have not connected to the group.db") end end addEventHandler("onResourceStart", getRootElement(), groupdb) Link to comment
PauloCascus Posted October 29, 2014 Author Share Posted October 29, 2014 lol i have learning functions but easy to forget it without practic Link to comment
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