Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- function vehicleorders()
- {
- DB.Handle.query("SELECT * FROM vehicleorders", function(e, result) {
- if (!e) {
- if (result.length) {
- for (var i = 0; i < result.length; i++) {
- var lid = result[i].lid;
- var vehname = result[i].vehname;
- var vehshop = result[i].vehshop;
- if(result[i].delivertime > 1) {
- var oldtime = result[i].delivertime;
- var newtime = parseInt(oldtime) - 1;
- DB.Handle.query("UPDATE vehicleorders SET delivertime = ? WHERE lid = ?", [newtime, lid], function(e,result) {
- if(!e) {
- }
- });
- } else {
- var shopName;
- if(vehshop == 3) {
- shopName = "PDM";
- }
- var vehHash;
- DB.Handle.query("SELECT * FROM vehicles_all_new WHERE type = ?", [vehname], function(e, result) {
- vehHash = result[0]["hash"];
- return vehHash;
- });
- var plateNum = Math.floor((Math.random() * 99999) + 10000);
- var plateText = "LS " + plateNum.toString();
- console.log(shopName + " " + vehHash + " " + plateText);
- setTimeout(() => {
- DB.Handle.query("INSERT INTO `vehicles` (owner, model, numberplate, colorP, colorS, alive, garID, fraktion) VALUES (?,?,?,0,0,0,0,3)", [shopName, parseInt(vehHash), plateText], function(e,result) {
- if(!e) {
- }
- });
- DB.Handle.query("SELECT id FROM vehicles WHERE numberplate = ?", [plateText], function(e, result) {
- if (!e) {
- if (result.length) {
- DB.Handle.query("INSERT INTO tuning (id) VALUES (?)", [result[0]["id"]], function(e,result) {
- if(!e) {
- }
- });
- };
- } else console.log(e);
- });
- DB.Handle.query("DELETE FROM vehicleorders WHERE lid = ?", [lid], function(e,result) {
- if(!e) {
- }
- });
- }, 100);
- }
- }
- };
- } else console.log (e);
- });
- }
- setInterval(vehicleorders, 60000);
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement