Focker Posted July 12, 2015 Share Posted July 12, 2015 Hello help me? I made a log for punishment to jail, mutes, ban, etc ... The problem is that if an admin returns evil punishment can not be erased and want to make a button with the function of selecting the wrong log given by the administrator and to delete local sql = { Query = executeSQLQuery }; addEventHandler( 'onResourceStart', resourceRoot, function() sql.Query( "CREATE TABLE IF NOT EXISTS LogPunishment (\ Date STRING, Elemento STRING, STAFF STRING,\ Time STRING, Reazon STRING )" ) end ) function LogAdmin (source) local logPunish = executeSQLQuery("SELECT * FROM LogPunishment") triggerClientEvent (source,"Punishlog",source,logPunish) end addCommandHandler ("punishlog", LogAdmin) Link to comment
xXMADEXx Posted July 12, 2015 Share Posted July 12, 2015 If you're looking to delete a log, you'll just need to use the SQL DELETE and WHERE statements. http://www.w3schools.com/sql/sql_delete.asp 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