E
A [..] "musical dice game" was a system for using dice to randomly 'generate' music from precomposed options. These 'games' were quite popular throughout Western Europe in the 18th century. Several different games were devised, some that did not require dice, but merely 'choosing a random number.'
using System.Collections;
using System.Collections.Generic;
using UnityEngine;
using Photon.Pun;
using Photon.Realtime;
public class NetworkManager : MonoBehaviourPunCallbacks
{
void Start()
{
ConnectToServer();
}
void ConnectToServer()
{
PhotonNetwork.ConnectUsingSettings();
Debug.Log("Connecting to server...");
}
public override void OnConnectedToMaster()
{
Debug.Log("Connected to server.");
base.OnConnectedToMaster();
RoomOptions roomOptions = new RoomOptions();
roomOptions.MaxPlayers = 4;
roomOptions.IsVisible = true;
roomOptions.IsOpen = true;
PhotonNetwork.JoinOrCreateRoom("Room 1", roomOptions, TypedLobby.Default);
}
public override void OnJoinedRoom()
{
Debug.Log("Joined room.");
base.OnJoinedRoom();
}
public override void OnPlayerEnteredRoom(Player newPlayer)
{
Debug.Log("New player joined.");
base.OnPlayerEnteredRoom(newPlayer);
}
}
using System.Collections;
using System.Collections.Generic;
using UnityEngine;
using Photon.Pun;
public class NetworkPlayerSpawner : MonoBehaviourPunCallbacks
{
public GameObject spawnedPlayerPrefab;
public override void OnJoinedRoom()
{
base.OnJoinedRoom();
spawnedPlayerPrefab = PhotonNetwork.Instantiate("Network Player", transform.position, transform.rotation);
}
public override void OnLeftRoom()
{
base.OnLeftRoom();
PhotonNetwork.Destroy(spawnedPlayerPrefab);
}
}
using UnityEngine;
using Photon.Pun;
public class NetworkPlayer : MonoBehaviour
{
public Transform head;
public Transform leftHand;
public Transform rightHand;
private PhotonView photonView;
public Animator leftHandAnimator;
public Animator rightHandAnimator;
private Transform headRig;
private Transform leftHandRig;
private Transform rightHandRig;
void Start()
{
photonView = GetComponent<PhotonView>();
OVRCameraRig rig = FindObjectOfType<OVRCameraRig>();
headRig = rig.centerEyeAnchor;
leftHandRig = rig.leftHandAnchor;
rightHandRig = rig.rightHandAnchor;
if (photonView.IsMine)
{
foreach (var item in GetComponentsInChildren<Renderer>())
{
item.enabled = false;
}
}
}
void Update()
{
if (photonView.IsMine)
{
MapPosition(head, headRig);
MapPosition(leftHand, leftHandRig);
MapPosition(rightHand, rightHandRig);
UpdateHandAnimation(OVRInput.Controller.LTouch, leftHandAnimator);
UpdateHandAnimation(OVRInput.Controller.RTouch, rightHandAnimator);
}
}
void UpdateHandAnimation(OVRInput.Controller controller, Animator handAnimator)
{
float triggerValue = OVRInput.Get(OVRInput.Axis1D.PrimaryIndexTrigger, controller);
handAnimator.SetFloat("Trigger", triggerValue);
float gripValue = OVRInput.Get(OVRInput.Axis1D.PrimaryHandTrigger, controller);
handAnimator.SetFloat("Grip", gripValue);
}
void MapPosition(Transform target, Transform rigTransform)
{
target.position = rigTransform.position;
target.rotation = rigTransform.rotation;
}
}
array = {'string1':12.3, 'string2':0.4,......}
sorted_array = sorted(array.items(), key = lambda x:float(x[1]))
TypeError: float() argument must be a string or a real number, not 'NoneType'
is
type kol_dep is record (sum_sal number,
min_sal number,
max_sal number,
names varchar2(1000),
dep_id number);
type kol_dep_tb is table of kol_dep;
v_kol_dep_tb kol_dep_tb;
function get_zp (proc_tbl kol_dep_tb) return kol_dep_tb pipelined;
end pkg_agg_employees;
---------TELO PAKETA-------
create or replace package body pkg_agg_employees
is
function get_zp (proc_tbl kol_dep_tb) return kol_dep_tb pipelined
is
v_report_row kol_dep;
cursor c_dep
is
select e.department_id as dep,
sum(e.salary)sum_sal,
min(e.salary)min_sal,
max(e.salary)max_sal,
listagg(e.first_name||' '||e.last_name|| ', '||chr(10))within group (order by e.last_name) as names
from employees e
inner join departments dep
on e.department_id=dep.department_id
inner join jobs j
on e.job_id=j.job_id
group by e.department_id
order by e.department_id;
begin
for r in c_dep loop
v_report_row:=null;
v_report_row.dep_id:=r.dep;
v_report_row.sum_sal:=r.sum_sal;
v_report_row.min_sal:=r.min_sal;
v_report_row.max_sal:=r.max_sal;
v_report_row.names:=r.names;
pipe row (v_report_row);
end loop;
return;
close c_dep;
end get_zp;
end pkg_agg_employees;```
не понимаю куда вставить
```DECLARE
v_table pkg_agg_employees.kol_dep_tb;
BEGIN
v_table := pkg_agg_employees.kol_dep_tb();
SELECT *
FROM TABLE(pkg_agg_employees.get_zp(v_table));
END; ```
или как по-другому исправить эту ошибку?
[1]][1]
[1]: [URL]https://i.sstatic.net/82Xar8QT.jpg[/URL] помогите сделать такую таблицу html
A polymorphic Virus can continue to alter the signature and attack undetected even after a fresh signature is found and added to the antivirus solution's signature database.