<?php
/*
Used in PLAY, EDIT, DISPLAY and CREATE
Needed to
A Scene has
*/
class sql_scene {
/*
returns an assoc arry of SCENE
*/
public get($sceneid) {
$sql = "SELECT * from `originator`.`orig_scene` WHERE `sceneid` = ". $sceneid;
$dbh = db::query($sql);
if (0==$dbh->rowcount()){
$scene["error"] = true;
$scene["errorMsg"] = "Originator Error - Scene ID: ". $sceneid ." not found.";
} else {
$dbh->setFetchMode(PDO::FETCH_ASSOC);
$scene = $dbh->fetchAll();
}
return $scene;
}
/*
getAll - gets the entire scene and any conversations related to the scene, used mostly for play.
*/
public getAll($sceneid){
$sql
}
/*
Pass a
*/
public set($sceneArr){
}
public toXML(){
}
}
?>