[Yii] CDbCritria::compare()でのフィールド指定

サンプル

$criteria->compare('column_a', 'A', false);
$criteria->compare('column_b', 'B', false);
$criteria->compare('column_c', 'C', false, 'OR');
$criteria->compare('column_d', 'D', false);

上記ソースは以下のようになる。

WHERE column_a = 'A'
WHERE (column_a = 'A') AND column_b = 'B'
WHERE ((column_a = 'A') AND column_b = 'B') OR column_c = 'C'
WHERE (((column_a = 'A') AND column_b = 'B') OR column_c = 'C') AND column_d = 'D'

Read More

[Unity][C#]GameObjectにアタッチされたコンポーネントを参照する方法

Scoreオブジェクトにアタッチされたスクリプトを取得して、変数を処理

using UnityEngine;
using System.Collections;

public class Score : MonoBehaviour {
 public int score;
 // Use this for initialization
 void Start () {
  score = 30; 
 }
 
 // Update is called once per frame
 void Update () {
  guiText.text = score.ToString ();
 }
}

using UnityEngine;
using System.Collections;

public class Spawner : MonoBehaviour {
 public Transform prefab;
 // Use this for initialization
 void Start () {
 }
 
 // Update is called once per frame
 void Update () {
  GameObject score = GameObject.Find("Score");
  Score scoreScript = score.GetComponent();
  scoreScript.score -= 1;
 }
}

Read More