Function GetValue(uuid:text, n:text, sql:text) :: text:
	set {_result} to mysql result of query "SELECT * FROM %{_sql}% WHERE `uuid` = '%{_uuid}%'"
	set {_result::*} to mysql string "%{_n}%" in {_result}
	return "%{_result::*}%"
Function UpdateValue(uuid:text, n1:text, n2:text, sql:text) :: text:
	mysql update "UPDATE %{_sql}% SET %{_n1}% = '%{_n2}%' WHERE `uuid` = '%{_uuid}%'"
Function text2Loc(location: text, world: world) :: location:
	set {_loc::*} to {_location} parsed as "x: %num%, y: %num%, z: %num%"
	return location({_loc::1}, {_loc::2}, {_loc::3}, {_world})


on load:
	loop 30 times:
		set {Room::%loop-number%} to false
	set {Room_Loc::1} to "x: -16, y: 29, z: -21"
	set {Room_Loc::2} to "x: -67, y: 29, z: -21"
	set {Room_Loc::3} to "x: -118, y: 29, z: -21"
	set {Room_Loc::4} to "x: -169, y: 29, z: -21"
	set {Room_Loc::5} to "x: -220, y: 29, z: -21"
	set {Room_Loc::6} to "x: -271, y: 29, z: -21"
	set {Room_Loc::7} to "x: -322, y: 29, z: -21"
	set {Room_Loc::8} to "x: -373, y: 29, z: -21"
	set {Room_Loc::9} to "x: -424, y: 29, z: -21"
	set {Room_Loc::10} to "x: -475, y: 29, z: -21"


	set {Room_Loc::11} to "x: -16, y: 29, z: -76"
	set {Room_Loc::12} to "x: -67, y: 29, z: -76"
	set {Room_Loc::13} to "x: -118, y: 29, z: -76"
	set {Room_Loc::14} to "x: -169, y: 29, z: -76"
	set {Room_Loc::15} to "x: -220, y: 29, z: -76"
	set {Room_Loc::16} to "x: -271, y: 29, z: -76"
	set {Room_Loc::17} to "x: -322, y: 29, z: -76"
	set {Room_Loc::18} to "x: -373, y: 29, z: -76"
	set {Room_Loc::19} to "x: -424, y: 29, z: -76"
	set {Room_Loc::21} to "x: -475, y: 29, z: -76"


	set {Room_Loc::21} to "x: -16, y: 29, z: -131"
	set {Room_Loc::22} to "x: -67, y: 29, z: -131"
	set {Room_Loc::23} to "x: -118, y: 29, z: -131"
	set {Room_Loc::24} to "x: -169, y: 29, z: -131"
	set {Room_Loc::25} to "x: -220, y: 29, z: -131"
	set {Room_Loc::26} to "x: -271, y: 29, z: -131"
	set {Room_Loc::27} to "x: -322, y: 29, z: -131"
	set {Room_Loc::28} to "x: -373, y: 29, z: -131"
	set {Room_Loc::29} to "x: -424, y: 29, z: -131"
	set {Room_Loc::30} to "x: -475, y: 29, z: -131"
on stop:
	delete {Room::*}
	delete {Room_Loc::*}




on join:
	set {_uuid} to uuid of player
	if GetValue({_uuid},"uuid","chnumber") is "<none>":
		set {_ch} to convert text "未創建" to unicode
		replace all "\" with "_" in {_ch}
		mysql update "INSERT INTO chnumber (`uuid`,`ch1ID`,`ch2ID`,`ch3ID`,`ch4ID`) VALUES ('%{_uuid}%','%{_ch}%','%{_ch}%','%{_ch}%','%{_ch}%')"
	set {_sp} to location at -2, 26, 9 of the world "chroom"
	teleport player to {_sp}
	add player to {排隊::*}
every 1 second:
	loop {Room::*}:
		if {Room::%loop-index-1%} is false:
			loop {排隊::*}:
				remove loop-value-2 from {排隊::*}
				set {Room::%loop-index-1%} to loop-value-2
				set {_loc} to text2Loc("%{Room_Loc::%loop-index-1%}%",chroom)
				teleport loop-value-2 to {_loc}