Dismal Posted April 21, 2014 Report Share Posted April 21, 2014 Hey guys, i have had pretty good luck getting help on here so i will try again. I am horribad at SQL and i am trying to get the recommended sql stuff to work. I have created the functions for FindVehicleKeysCount and DeleteNonKeyVehicles just fine. The issue i am having is im not sure how to use them... what exactly they do... and what if any the benifit of them are in my server. Can anyone noob these up a little so i can understand them? Link to comment Share on other sites More sharing options...
0 Guest Posted April 23, 2014 Report Share Posted April 23, 2014 well if you have the function findvehiclekeyscount and the event deletenonkeyvehicles it should work like this: It checks for locked vehicles and looks for all available carkeys in all inventorys. So if there is no key for this locked vehicle anymore the vehicle gets deleted and is gone after next restart.... why is this good? well what do you think? no locked vehicles standing around which nobody uses .... Link to comment Share on other sites More sharing options...
0 Dismal Posted April 24, 2014 Author Report Share Posted April 24, 2014 thank you sir, i appreciate it =) i have very little experience using the database and reading forums is how I've been learning. Link to comment Share on other sites More sharing options...
0 cen Posted April 24, 2014 Report Share Posted April 24, 2014 If you have both functions then all you need to do is run this query: SELECT DeleteNonKeyVehicles(); Dismal 1 Link to comment Share on other sites More sharing options...
Question
Dismal
Hey guys, i have had pretty good luck getting help on here so i will try again.
I am horribad at SQL and i am trying to get the recommended sql stuff to work.
I have created the functions for FindVehicleKeysCount and DeleteNonKeyVehicles just fine.
The issue i am having is im not sure how to use them... what exactly they do... and what if any the benifit of them are in my server.
Can anyone noob these up a little so i can understand them?
Link to comment
Share on other sites
3 answers to this question
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