/**
* Given the hash of a some data, check to see whether it exists in
* `tbl_cache`. If no cached object is found, this function will return
* false, otherwise the cached object will be returned as an array.
*
* @param string $hash
* The hash of the Cached object, as defined by the user
* @return array|boolean
* An associative array of the cached object including the creation time,
* expiry time, the hash and the data. If the object is not found, false will
* be returned.
*/
public function read($hash)
{
if ($c = $this->Database->fetchRow(0, "SELECT SQL_NO_CACHE * FROM `tbl_cache` WHERE `hash` = '{$hash}' AND (`expiry` IS NULL OR UNIX_TIMESTAMP() <= `expiry`) LIMIT 1")) {
if (!($c['data'] = Cacheable::decompressData($c['data']))) {
$this->delete($hash);
return false;
}
return $c;
}
$this->delete();
return false;
}
/**
* Given the hash of a some data, check to see whether it exists in
* `tbl_cache`. If no cached object is found, this function will return
* false, otherwise the cached object will be returned as an array.
*
* @param string $hash
* The hash of the Cached object, as defined by the user
* @param string $namespace
* The namespace allows a group of data to be retrieved at once
* @return array|boolean
* An associative array of the cached object including the creation time,
* expiry time, the hash and the data. If the object is not found, false will
* be returned.
*/
public function read($hash, $namespace = null)
{
$data = false;
// Check namespace first
if (!is_null($namespace)) {
$data = $this->Database->fetch("\n SELECT SQL_NO_CACHE *\n FROM `tbl_cache`\n WHERE `namespace` = '{$namepspace}'\n AND (`expiry` IS NULL OR UNIX_TIMESTAMP() <= `expiry`)\n ");
}
// Then check hash
if (!is_null($hash)) {
$data = $this->Database->fetchRow(0, "\n SELECT SQL_NO_CACHE *\n FROM `tbl_cache`\n WHERE `hash` = '{$hash}'\n AND (`expiry` IS NULL OR UNIX_TIMESTAMP() <= `expiry`)\n LIMIT 1\n ");
}
// If the data exists, see if it's still valid
if ($data) {
if (!($data['data'] = Cacheable::decompressData($data['data']))) {
$this->delete($hash, $namespace);
return false;
}
return $data;
}
$this->delete(null, $namespace);
return false;
}
/**
* Given the `$page_id` and a `$column`
*
* @param mixed $page_id
* The ID of the Page that currently being viewed, or the handle of the
* current Page
* @return array
* An array of the current Page, containing the `$column`
* requested. The current page will be the last item the array, as all
* parent pages are prepended to the start of the array
*/
public function resolvePage($page_id, $column)
{
$path = array();
$page = self::$Database->fetchRow(0, "\n\t\t\t\tSELECT\n\t\t\t\t\tp.{$column},\n\t\t\t\t\tp.parent\n\t\t\t\tFROM\n\t\t\t\t\t`tbl_pages` AS p\n\t\t\t\tWHERE\n\t\t\t\t\tp.id = '{$page_id}'\n\t\t\t\t\tOR p.handle = '{$page_id}'\n\t\t\t\tLIMIT 1\n\t\t\t");
$path = array($page[$column]);
if (!is_null($page['parent'])) {
$next_parent = $page['parent'];
while ($parent = self::$Database->fetchRow(0, "\n\t\t\t\t\t\tSELECT\n\t\t\t\t\t\t\tp.{$column},\n\t\t\t\t\t\t\tp.parent\n\t\t\t\t\t\tFROM\n\t\t\t\t\t\t\t`tbl_pages` AS p\n\t\t\t\t\t\tWHERE\n\t\t\t\t\t\t\tp.id = '{$next_parent}'\n\t\t\t\t\t")) {
array_unshift($path, $parent[$column]);
$next_parent = $parent['parent'];
}
}
return $path;
}
if (!$newresults) {
die('Error building database!' . $sql);
}
}
//get supplier from categories
// print"<br>";
for ($i = 1; $i < $num_rec; $i++) {
$sql = "SELECT supplier FROM hkmatrix WHERE uid = " . $i;
$results = $db->QuerySingleRowArray($sql);
$suppcode = $results[0];
if ($suppcode) {
$sql2 = "SELECT hksupplier, wwwsupplier FROM categories WHERE code = '" . $suppcode . "'";
//print $sql2."<br>";
$subresults = $db->Query($sql2);
if (!empty($subresults)) {
$ns = $db->fetchRow($subresults);
//print_r($ns);
if ($ns[1]) {
$newsupp = $db->clean($ns[1]);
} else {
$newsupp = $db->clean($ns[0]);
}
$sql3 = "UPDATE hkmatrix SET supplier ='" . $newsupp . "' WHERE uid = " . $i;
//print "<br> $sql3";
$results = $db->Query($sql3);
}
}
//finish suppcode check
$sql = "SELECT prodgroup FROM hkmatrix WHERE uid = " . $i;
$results = $db->QuerySingleRowArray($sql);
$pgcode = $results[0];
$db_insertid = $db->insertID();
$urlex = '/\\b(([^:\\/?#]+):)(\\/\\/([^\\/?#]*))([^?#]*)(\\?([^#]*))?(#(.*))?/i';
$contentArray = explode(" ", $status);
$linkArray = array();
foreach ($contentArray as $content) {
if (preg_match($urlex, $content, $matches)) {
array_push($linkArray, $matches);
}
}
foreach ($linkArray as $link) {
if ($link[4] != "" && strlen($link[4]) > 3) {
$db->query('SELECT * FROM stream WHERE type = 4 AND data = "' . mysql_real_escape_string($link[0]) . '"');
if ($db->numRows() == 0) {
$db->insert('stream', array('timestamp' => time(), 'type' => 4, 'data' => $link[0], 'likes' => 1));
} else {
$oid = $db->fetchRow();
$db->query('UPDATE stream SET likes = likes+1 WHERE sid = ' . $oid);
}
}
}
$final = array("data" => array("insertid" => $db_insertid, "status" => addslashes($status)), "error" => false);
print_r(json_encode($final));
} else {
die('0');
}
} catch (Exception $e) {
echo $e->getMessage();
exit;
}
} elseif ($_POST['p'] == 'updatestatus') {
try {
<?php /* Logged In Get Request */
if (isset($_GET['p'])) {
if ($_GET['p'] == 'userdata') {
try {
$db = new MySQL();
if (!isset($_GET['uid'])) $uid = $_SESSION['user_id'];
else $uid = $_GET['uid'];
$db->query();
if ($db->numRows() == 1) {
header('Content-Type: text/javascript; charset=utf8');
print_r(json_encode($db->fetchRow()));
} else die('0');
} catch(Exception $e) {
echo $e->getMessage();
exit();
}
}
}
?>