db = $db;
$this->tabledefid = $tabledefid;
$this->tabledefuuid = getUuid($this->db, "tbld:5c9d645f-26ab-5003-b98e-89e9049f8ac3", ((int) $tabledefid));
$querystatement = "
SELECT
`prefix`
FROM
`tabledefs`
WHERE
`uuid` = '".$this->tabledefuuid."'
";
$queryresult = $this->db->query($querystatement);
$therecord = $this->db->fetchArray($queryresult);
$this->prefix = $therecord["prefix"];
}//end function init
function load($id){
$querystatement = "
SELECT
sqlclause
FROM
usersearches
WHERE
id = ".((int) $id);
$queryresult = $this->db->query($querystatement);
$therecord = $this->db->fetchArray($queryresult);
echo $therecord["sqlclause"];
}//end function load
function delete($id){
$deletestatement = "
DELETE FROM
usersearches
WERE
id = ".((int) $id);
$this->db->query($deletestatement);
echo "success";
}//end function delete
function showList($queryresult){
$numrows = $this->db->numRows($queryresult);
?>
tabledefuuid."'
AND type = 'SRT'
AND (userid = '' OR userid IS NULL OR userid = '".$userid."')
ORDER BY
userid,
name";
$queryresult = $this->db->query($querystatement);
?>
showList($queryresult)?>
tabledefuuid)."',
'".mysql_real_escape_string($name)."',
'SRT',
'".mysql_real_escape_string($sqlclause)."',
'".uuid($this->prefix.":")."'
)";
$this->db->query($insertstatement);
echo "success";
}//end function save
function showUI(){
//First, grab table name from id
$querystatement = "
SELECT
querytable
FROM
tabledefs
WHERE
uuid = '".$this->tabledefuuid."'";
$queryresult = $this->db->query($querystatement);
if(!$queryresult)
$error = new appError(500,"Cannot retrieve Table Information");
$thetabledef = $this->db->fetchArray($queryresult);
//Grab query for all columns
$querystatement = "
SELECT
*
FROM
".$thetabledef["querytable"]."
LIMIT 1";
$queryresult = $this->db->query($querystatement);
if(!$queryresult)
$error = new appError(500,"Cannot retrieve Table Information");
$numfields = $this->db->numFields($queryresult);
for ($i=0;$i<$numfields;$i++)
$fieldlist[] = $this->db->fieldTable($queryresult,$i).".".$this->db->fieldName($queryresult,$i);
?>
sql order by clause
showUI();
break;
case "save":
$sorts->save($_GET["name"], $_GET["clause"], $_SESSION["userinfo"]["uuid"]);
break;
case "showSaved":
$sorts->showSaved($_SESSION["userinfo"]["uuid"]);
break;
case "deleteSaved":
$sorts->delete($_GET["id"]);
break;
case "loadSaved":
$sorts->load($_GET["id"]);
break;
}//end switch
}//endif
?>