Citizenship System

event onLoad(){
	datebase.execute(
		"CREATE TABLE IF NOT EXIST `playerinfo` (
		`steamId` VARCHAR(17) NOT NULL,
		`name` VARCHAR(255) NOT NULL,
		`description` VARCHAR(255) NOT NULL,
		`age` INT(11) NOT NULL,
		PRIMARY KEY (`steamId`));"
);

playerInfoFormat = "INSERT INTO playerinfo (PlayerName, Description, Age, SteamId) VALUES ('{0}', '{1}', '{2}', '{3}');";
command createinfo(arg, description, age){
	permission = "adminci";
	execute() {
		if(argument.count !=3){
			player.message("Badly placed command: /createinfo <player> <description> <age>", "red");
			return;
		}
		argPlayer = ToPlayer(arg);
		if(isPlayer(argPlayer) == false){
			player.message("Player not found", "red");
			return;
		}
		datebase.execute(str.format(playerInfoFormat, argPlayer.name, description, age, dt.now.string));
		player.message("You have registered " + argPlayer.name + " whit this data " + argDescription + " , " + argAge + "green");

		argPlayer.message("You are now a citizen thanks to " + player.name + " whit this data " + argDescription + " , " + argAge + "green");

	}
}

playerInfoF = "SELECT FROM playerinfo (PlayerName, Description, Age, SteamId) VALUES ('{0}', '{1}', '{2}', '{3}');";
command info(startPlayer){
	permission = "infocity";
	execute(){
		argPlayer = ToPlayer(startPlayer)
		if(isPlayer(argPlayer) == false){
			player.message("Player not found", "red");
			return;
		}
		argPlayer = toPlayer(startPlayer);
		datebase.execute(str.format("SELECT playerInfoF, startPlayer, description, age, dt.now.string));

		player.message("The citizen has been registered with this data " + argPlayer + ", " + argDescription + ", " + argAge + "green");
	}

}

}