uPurchase - Experience

event onLoad(){
	database.execute("CREATE TABLE IF NOT EXISTS doorbuyprices(
    doorid INT PRIMARY KEY,
    price INT NOT NULL DEFAULT 0
    );");
	database.execute("CREATE TABLE IF NOT EXISTS carbuyprices(
    carid INT PRIMARY KEY,
    price INT NOT NULL DEFAULT 0
    );");
}

command uPurchase(){
	permission = "upurchase";
	execute(){
		object = player.look.getBarricade();
		vehicle = player.look.getVehicle();
		if (isSet(object)){
			if(object.hasDoor()){
				if(object.owner == "0"){
					doorID = toNumber(object.group);
					doorID = doorID / 100000000;
					DBcheck = database.execute("SELECT * FROM doorbuyprices WHERE doorid = '" + doorID + "';");
					DBcheck = DBcheck[0];
					if (DBcheck.count != 0){
						doorCost = toNumber(DBcheck[1]);
						if(player.experience >= doorCost){
							player.experience = player.experience - toNumber(doorCost);
							player.message("Door Bought For " + doorCost + " Experience!");
							player.message("Salvage And Replace The Door To Allow Your Group To Open It!");
							database.execute("DELETE FROM doorbuyprices WHERE doorid = '" + doorID + "';");
							object.owner = player.id;
							object.group = player.steamGroup;
						}
						else{
							player.message("You Don't Have Enough Experience!");
						}
					}
					else{
						player.message("This door is not for sale");
					}
				}
				else{
					player.message("This door is not for sale");
				}
			}
			else{
				player.message("Use This Command Whilst Looking At  A Door/Vehicle");
			}
		}
		else if (isSet(vehicle)){
			if(vehicle.owner == null){
				vehicleID = toNumber(vehicle.group);
				vehicleID=vehicleID / 100000000;
				DBcheck = database.execute("SELECT * FROM carbuyprices WHERE carid = '" + vehicleID + "';");
				DBcheck = DBcheck[0];
				if (DBcheck.count != 0){
					vehicleCost = toNumber(DBcheck[1]);
					if(player.experience >= vehicleCost){
						player.experience = player.experience - toNumber(vehicleCost);
						player.message("Vehicle Bought For " + vehicleCost + " Experience!");
						player.message("Leave and Rejoin the server to be able to enter the car!");
						database.execute("DELETE FROM carbuyprices WHERE carid = '" + vehicleID + "';");
						vehicle.owner = player.id;
						vehicle.group = player.steamGroup;
					}
					else{
						player.message("You Don't Have Enough Experience!");
					}
				}
				else{
					player.message("This vehicle is not for sale!");
				}
			}
			else{
				player.message("This vehicle is not for sale");
			}
		}
		else if (isSet(vehicle) == false and isSet(object) == false){
			player.message("Use This Command Whilst Looking At  A Door/Vehicle");
		}
	}
}

command uPrice(){
	permission = "upurchase";
	execute(){
		object = player.look.getBarricade();
		vehicle = player.look.getVehicle();
		if (isSet(object)){
			if(object.hasDoor()){
				if(object.owner == "0"){
					doorID = toNumber(object.group);
					doorID = doorID / 100000000;
					DBcheck = database.execute("SELECT * FROM doorbuyprices WHERE doorid = '" + doorID + "';");
					DBcheck = DBcheck[0];
					if (DBcheck.count != 0){
						player.message("This Door Costs: " + DBcheck[1] + " Experience.");
					}
					else{
						player.message("This door is not for sale!");
					}
				}
				else{
					player.message("This door is not for sale!");
				}
			}
			else{
				player.message("Use this command whilst looking at a door!");
			}
		}
		else if (isSet(vehicle)){
			if(vehicle.owner == null){
				vehicleID = toNumber(vehicle.group);
				vehicleID = vehicleID / 100000000;
				DBcheck = database.execute("SELECT * FROM carbuyprices WHERE carid = '" + vehicleID + "';");
				DBcheck = DBcheck[0];
				if (DBcheck.count != 0){
					player.message("This Vehicle Costs: " + DBcheck[1] + " Experience.");
				}
				else{
					player.message("This vehicle is not for sale!");
				}
			}
			else{
				player.message("This vehicle is not for sale!");
			}
		}
		else if (isSet(vehicle) == false and isSet(object) == false){
			player.message("Use This Command Whilst Looking At  A Door/Vehicle");
		}
	}
}

command uSell(amount){
	permission = "upurchaseadmin";
	execute(){
		object = player.look.getBarricade();
		vehicle = player.look.getVehicle();
		if (isSet(object)){
			if(object.hasDoor()){
				randomID = random.int(111111111,1000000000);
				database.execute("INSERT INTO doorbuyprices (doorid, price) VALUES ('" + randomID + "', '" + amount + "');");
				object.owner = "00000000000000000";
				object.group = randomID+"00000000";
				player.message("Door Set To Purchasable! Cost: " + amount);
			}
			else{
				player.message("Use This Command Whilst Looking At  A Door/Vehicle");
			}
		}
		else if (isSet(vehicle)){
			randomID = random.int(111111111,1000000000);
			database.execute("INSERT INTO carbuyprices (carid, price) VALUES ('" + randomID + "', '" + amount + "');");
			vehicle.owner = "00000000000000000";
			vehicle.group = randomID+"00000000";
			player.message("Vehicle Set To Purchasable! Cost: " + amount);
		}
		else{
			player.message("Use This Command Whilst Looking At  A Door/Vehicle");
		}
	}
}

event onPlayerGestured(player, gesture){
	if(gesture == "PunchLeft" or gesture == "PunchRight"){
		object=player.look.getBarricade();
		vehicle=player.look.getVehicle();
		if(isSet(object)){
			if(object.hasDoor()){
				doorID = toNumber(object.group);
				doorID = doorID/100000000;
				DBcheck = database.execute("SELECT * FROM doorbuyprices WHERE doorid = '" + doorID + "';");
				DBcheck = DBcheck[0];
				if(DBcheck.count != 0){
					effectManager.sendUI(7802, 7802, player.id, "Door", "Price: "+ DBcheck[1] + " Experience","Use /Purchase To Buy");
				}
			}
		}
		else if(isSet(vehicle)){
			vehicleID = toNumber(vehicle.group);
			vehicleID = vehicleID/100000000;
			DBcheck = database.execute("SELECT * FROM carbuyprices WHERE carid = '" + vehicleID + "';");
			DBcheck = DBcheck[0];
			if(DBcheck.count != 0){
				effectManager.sendUI(7802, 7802, player.id, vehicle.name, "Price: "+ DBcheck[1] + " Experience","Use /Purchase To Buy");
			}
		}
		else if (isSet(vehicle) == false and isSet(object) == false){
			effectManager.clearUIbyID(7802,player.id);
		}
	}
}