JHH5XNrT

1event onLoad(){
2    database.execute(
3        "CREATE TABLE IF NOT EXISTS `vehiclelicenceplate` (
4		`licence` INT(11) NOT NULL,);"
5    );
6}
7
8    licencePlateFormat = "INSERT INTO vehiclelicenceplate (licence) VALUE ('{0}')";
9
10    command registerlicence(licence){;
11        permission = "lregister";
12        execute (){
13            database.execute(str.format(licencePlateFormat, licence ,dt.now.string));
14            player.message("You just registered a vehicle with the license plate" + argLicence);
15    }
16}
17
18	licenceSelectFormat = "SELECT FROM vehiclelicenceplate (licence) VALUE ('{0}')";	
19	
20	command checkv(licence){;
21		permission = "checkv";
22		execute(){
23			vehicle = player.look.getVehicle();
24       		if(vehicle != null){
25			database.execute(str.format("SELECT FROM licenceSelectFormat,  licence, dt.now.string"));
26			player.message("The license plate of the selected vehicle is " + argLicence);
27			}
28		}
29	}