SQL

function sql_update(name:text, uuid:text, rank: text) :: text:
	set {_results::*} to objects in column "name" from result of query "SELECT * FROM {@table} WHERE name = '%{_name}%'" and close
	set {_result} to false
	loop {_results::*}:
		If loop-value is {_name}:
			set {_result} to true
	If {_result} is false:
		update "INSERT INTO `{@table}` (`name`,`uuid`,`rank`,`online`) VALUES ('%{_name}%', '%{_uuid}%', '%{_rank}%', 'OFFLINE')"
		return "{@prefix} &7Staff: &9%{_name}% &7Rang: &b%{_rank}% &7Update."
	else:
		update "UPDATE `{@table}` SET `rank` = '%{_rank}%' WHERE `{@table}`.`name` ='%{_name}%'"
		return "{@ban} &7Staff: &9%{_name}% &7Rang: &9%{_rank}% &7Update."