public static function getLastID($tabelID, $whereArr = NULL, $obj = NULL)
{
if (is_null($obj)) {
$obj = array();
}
$obj['addToEnd'] = 'ORDER BY id DESC LIMIT 1';
$api = new GetTable($tabelID, $whereArr, $obj);
$chk = $api->getResult();
$chk['result'] = $chk['result'][0]['id'];
return $chk;
}
public static function getNextInsertID($table, $hash = true, $append = "")
{
//----------------------------------------------------------
//init var
//----------------------------------------------------------
$chk = array("bool" => true, 'result' => array(), "func" => "getHash");
//----------------------------------------------------------
$date = date("Y-m-d H:i:s");
//----------------------------------------------------------
$chk = GetTable::getLastID($table);
//----------------------------------------------------------
if (!$chk['bool']) {
$chk['bool'] = false;
$chk['message'] = "getHash() returned NULL";
return $chk;
}
//----------------------------------------------------------
if ($chk['bool']) {
$total = $chk['result'];
}
//----------------------------------------------------------
$insert_id = $total + 1;
//----------------------------------------------------------
return $hash ? alphaID($insert_id . $date . $append) : alphaID($insert_id);
}
public function getFiles($getHtml = true)
{
//----------------------------------------------------------
//init var
//----------------------------------------------------------
$html;
$chk = array("bool" => true, 'result' => array(), "func" => "getFiles");
//----------------------------------------------------------
$chk = GetTable::go("files", NULL, array("addToEnd" => " ORDER BY id DESC ", "limitFrom" => 0, "limitTo" => 60));
if (sizeof($chk['result']) > 0) {
foreach ($chk['result'] as $index) {
$html .= "<a href = '" . $this->getDownloadUrl() . "?hash=" . $index['hash'] . "'>" . $index['name'] . "</a><br>";
}
} else {
$html = "<p>No files have been uploaded.</p>";
}
//----------------------------------------------------------
if ($chk['bool']) {
$chk['html'] = $html;
}
//----------------------------------------------------------
return !$chk['bool'] || !$getHtml ? $chk : $html;
}
public function update()
{
//----------------------------------------------------------
//init var
//----------------------------------------------------------
$chk = array("bool" => true, 'function' => "update");
//----------------------------------------------------------
$this->tableID = GlobalMas::$mysqli->real_escape_string($this->tableID);
//----------------------------------------------------------
$this->queryString = "UPDATE " . $this->tableID . " ";
//----------------------------------------------------------
$this->queryString = MySQL::condition($this->tableID, $this->setArr, "set", $this->queryString);
$this->queryString = MySQL::condition($this->tableID, $this->whereArr, "where", $this->queryString);
//----------------------------------------------------------
$chk = $this->getResult();
//----------------------------------------------------------
if ($this->returnTable) {
$chk = GetTable::go($this->tableID, $this->whereArr);
}
//----------------------------------------------------------
return $chk;
//----------------------------------------------------------
}
public function forgotPassword($email)
{
Trace::output($this->traceID, "forgotPassword");
//----------------------------------------------------------
$this->email = $email;
$this->addRowFunction = "addForgotRow";
$this->tblName = ForgotPwRequest_const::TBL;
//----------------------------------------------------------
//init var
//----------------------------------------------------------
$chk = array("bool" => true, 'traceID' => "forgotPassword");
//----------------------------------------------------------
$chk = GenFun::error_CHK(array($email, $this->tblName));
//----------------------------------------------------------
if (!$chk["bool"]) {
return $chk;
}
//----------------------------------------------------------
if (!$this->character_CHK($email)) {
$chk['bool'] = false;
$chk['message'] = "email must only contain numbers, upper, and lowercase characters!!!";
}
//----------------------------------------------------------
if ($chk['bool']) {
$chk = GetTable::go(Accounts_const::TBL, array("email" => $email));
}
//----------------------------------------------------------
if ($chk['bool']) {
$this->emailRow = $chk['result'][0];
}
//----------------------------------------------------------
if (sizeof($chk['result']) != 0) {
if ($chk['result']['0']['email'] != $email) {
$chk['bool'] = false;
$chk['message'] = "Email does not match email!!!";
} else {
if ($chk['bool']) {
$chk = GetTable::go(ForgotPwRequest_const::TBL, array("accounts_id" => $this->emailRow['id'], "disabled" => '0', "confirmed" => '0'));
}
}
} else {
$chk['bool'] = false;
$chk['message'] = "No Account exist with that email!!!";
}
//----------------------------------------------------------
if ($chk['bool']) {
$chk = $this->start($chk['result'][0], 1, "emailForgotLink");
}
//----------------------------------------------------------
return $chk;
}
public function getStates()
{
//----------------------------------------------------------
//init var
//----------------------------------------------------------
$chk = array("bool" => true, 'traceID' => "initLoad");
//----------------------------------------------------------
$chk = GetTable::go("states");
//----------------------------------------------------------
return $chk;
}
public function deleteFile($id, $hardDelete = false)
{
Trace::output(self::$traceID, "insertFile", func_get_args());
//----------------------------------------------------------
//init var
//----------------------------------------------------------
$chk = array("bool" => true, 'result' => array(), "func" => "deleteFile");
$date = date("Y-m-d H:i:s");
//----------------------------------------------------------
if ($hardDelete) {
$file = GetTable::go("files", array("id" => $id));
$path = $file['result'][0]['hash'];
$path = GlobalMas::$filesPath_absolute . $path;
if (!FileFolder::delete($path)) {
$chk['bool'] = false;
$chk['message'] = "file was not deleted";
}
}
if (!$chk['bool']) {
return $chk;
} else {
$chk = Update::go("files", array("deleted" => $date), array('id' => $id));
}
//----------------------------------------------------------
return $chk;
}
public function insertINTO()
{
//----------------------------------------------------------
//init var
//----------------------------------------------------------
$chk = array("bool" => true, 'function' => "insertINTO");
$this->updateArr = array();
//----------------------------------------------------------
$chk = GenFun::errorKey_chk($this->setArr, NULL, true);
//----------------------------------------------------------
$this->setArr = $chk['valueArr'];
//----------------------------------------------------------
if (!$chk['bool']) {
return $chk;
}
//----------------------------------------------------------
$this->tableID = Constants::$mysqli->real_escape_string($this->tableID);
//----------------------------------------------------------
$this->queryString = $this->insertType . " " . $this->tableID . " (";
foreach ($this->setArr as $i => $value) {
if (strrpos($value, "{hash}") === 0) {
$this->updateArr[$i] = $value;
} else {
$this->queryString .= $i . ",";
}
}
//----------------------------------------------------------
foreach ($this->updateArr as $i => $value) {
unset($this->setArr[$i]);
}
//----------------------------------------------------------
$this->queryString = substr($this->queryString, 0, -1);
$this->queryString .= ") ";
//----------------------------------------------------------
$keys = array_keys($this->setArr);
$this->queryString .= "VALUES ";
//----------------------------------------------------------
$high = sizeof($this->setArr[$keys[0]]);
for ($i = 1; $i < sizeof($this->setArr); $i++) {
if (is_array($this->setArr[$keys[$i]])) {
$cur = sizeof($this->setArr[$keys[$i]]);
if ($high < $cur) {
$high = $cur;
}
}
}
//----------------------------------------------------------
for ($i = 0; $i < 1; $i++) {
$value = $this->setArr[$keys[$i]];
$num = is_array($value) ? sizeof($value) : 1;
for ($j = 0; $j < $high; $j++) {
if (is_array($this->setArr[$keys[$i]])) {
$value = $this->setArr[$keys[$i]][$j];
}
if ($i == 0) {
$this->queryString .= "(";
}
if (strrpos($value, "(") !== false && strrpos($value, "(") == 0 && !$this->ignore) {
$this->queryString .= $value;
//$this->queryString .= ",";
} else {
if ($value == "DEFAULT") {
$this->queryString .= $value;
} else {
$this->queryString .= "'" . Constants::$mysqli->escape_string($value) . "'";
}
}
//-------------------------------------------------
for ($k = 0; $k < sizeof($this->setArr); $k++) {
if ($keys[$k] != $keys[$i]) {
$this->queryString .= ",";
if (is_array($this->setArr[$keys[$k]])) {
$v = $this->setArr[$keys[$k]][$j];
$this->queryString .= "'" . Constants::$mysqli->escape_string($v) . "'";
} else {
$v = $this->setArr[$keys[$k]];
$this->queryString .= "'" . Constants::$mysqli->escape_string($v) . "'";
}
}
}
//-------------------------------------------------
//if ($i == sizeof($this->setArr)-1) {
//$this->queryString = substr($this->queryString, 0, -1);
$this->queryString .= ")";
//}
//-------------------------------------------------
if ($j < $high - 1) {
$this->queryString .= ",";
}
}
}
//----------------------------------------------------------
if (!is_null($this->onDuplicate)) {
$this->queryString .= " ON DUPLICATE KEY UPDATE ";
$this->queryString = MySQL::condition($this->tableID, $this->onDuplicate, NULL, $this->queryString);
}
//----------------------------------------------------------
if (!$this->returnQuery) {
$chk = $this->getResult();
$insert_id = $chk['insert_id'];
if ($chk['duplicate']) {
$chk['duplicate'] = GetTable::go($this->tableID, $this->setArr);
} else {
if (sizeof($this->updateArr) > 0) {
foreach ($this->updateArr as $i => $value) {
if (strrpos($value, "{hash}") === 0) {
$value = strtr($value, array('{hash}' => ""));
/*if (!is_numeric($value)) {
$chk['bool'] = false;
$chk['messgae'] = "In order to use the alphaID() utility ".$value.' must be numeric!!!';
return $chk;
}*/
$this->updateArr[$i] = alphaID($insert_id . $value);
}
}
$this->setArr['id'] = $insert_id;
$chk = Update::go($this->tableID, $this->updateArr, $this->setArr);
}
}
if (!$chk['bool']) {
return $chk;
}
if ($this->returnRow) {
$chk['row'] = GetTable::go($this->tableID, array("id" => $insert_id));
if ($chk['row']['bool']) {
$chk['row'] = $chk['row']['result'][0];
}
}
$chk['insert_id'] = $insert_id;
return $chk;
} else {
return $this->queryString;
}
}
public function _getProjects($limit = null)
{
//----------------------------------------------------------
//init var
//----------------------------------------------------------
$chk = array("bool" => true, 'result' => array(), "func" => "getProjects");
//----------------------------------------------------------
$chk = GetTable::go("projects", NULL, array("addToEnd" => " Order By id DESC" . (is_null($limit) ? "" : " LIMIT " . $limit)));
//---------------------------------------------------------
return $chk;
}
public function session_CHK($email = NULL, $accounts_id = NULL)
{
Trace::output($this->traceID, "session_CHK", func_get_args());
//----------------------------------------------------------
//init var
//----------------------------------------------------------
$chk = array("bool" => true, 'traceID' => "session_CFG");
$userKey;
$last_userKey;
//----------------------------------------------------------
if (is_null($email) && !isset($_COOKIE[$this->cookiePrefix . "user"])) {
$chk['bool'] = false;
}
//----------------------------------------------------------
if (!$chk['bool']) {
$chk['message'] = "No session or email exist!!!";
return $chk;
}
//----------------------------------------------------------
if (session_id() == '') {
session_start();
}
//----------------------------------------------------------
if ($chk['bool'] && isset($_COOKIE[$this->cookiePrefix . "user"]) && is_null($email)) {
$chk = $this->getSession($_COOKIE[$this->cookiePrefix . 'user']);
if ($chk['bool']) {
//Constants::$loggedIN = $chk['result'][0];
$email = $chk['result'][0]['email'];
$accounts_id = $chk['result'][0]['id'];
}
} else {
$chk['bool'] = false;
}
//----------------------------------------------------------
if (!$chk['bool'] && is_null($email)) {
$chk['bool'] = false;
$chk['message'] = "No session or email exist!!!";
return $chk;
}
//----------------------------------------------------------
$session_id = GenFun::encrypt(session_id() . $this->salt . $email);
//----------------------------------------------------------
$last_userKey = $_COOKIE[$this->cookiePrefix . "user"];
//----------------------------------------------------------
$userKey = $email . "-" . alphaID(time() . rand(0, 13000000));
//----------------------------------------------------------
setcookie($this->cookiePrefix . "user", $userKey, GenFun::getCookieTime());
//----------------------------------------------------------
$this->setAndChk($email);
//----------------------------------------------------------
if (!$chk['bool']) {
$chk = GetTable::go(Accounts_const::TBL, array("email" => $email));
//------------------------------------------------------
if ($chk['bool'] && sizeof($chk['result']) > 0) {
Update::go(SessionLog_const::TBL, array("disabled" => "{function}NOW()"), array("accounts_id" => $chk['result'][0]['id']));
}
//------------------------------------------------------
session_regenerate_id();
$session_id = GenFun::encrypt(session_id() . $this->salt . $email);
if ($chk['bool']) {
$chk = InsertINTO::go(SessionLog_const::TBL, array("userKey" => $userKey, "accounts_id" => $chk['result'][0]['id'], "session_id" => $session_id));
}
//------------------------------------------------------
$session = $this->getSession($userKey);
//------------------------------------------------------
if ($session['bool']) {
Constants::$loggedIN = $session['result'][0];
}
} else {
setcookie("shit", $userKey, GenFun::getCookieTime());
$chk = Update::go(SessionLog_const::TBL, array("userKey" => $userKey), array("userKey" => $last_userKey));
Constants::$loggedIN['userKey'] = $userKey;
if ($chk['bool']) {
$chk['message'] = "session for this user has already been established!!!";
}
}
//----------------------------------------------------------
return $chk;
}
<?php
require_once "Import.php";
require_once Import::$uber_src_path . "server/werm/utils/GenFun.php";
if (file_exists("ProjectGlobal.php")) {
Import::current("ProjectGlobal.php");
}
Import::sUtils("GetTable.php");
$hash = $_GET['hash'];
$chk = GetTable::go("files", array("hash" => $hash));
$_GET['url'] = ProjectGlobal::$filesPath . "/{$hash}/" . $chk['result'][0]['name'];
include Import::services("Download.php");
public function confirm($linkHash = NULL, $confirmTbl = NULL)
{
Trace::output($this->traceID, "confirm");
//----------------------------------------------------------
//init var
//----------------------------------------------------------
$row = NULL;
$confirmLink;
$tbl = NULL;
$this->confirmTbl = $confirmTbl;
//----------------------------------------------------------
if ($linkHash == NULL && isset($_GET['hash'])) {
$linkHash = $_GET['hash'];
}
//----------------------------------------------------------
$chk = array("bool" => true, "traceID" => "confirm");
//----------------------------------------------------------
if ($chk['bool']) {
$chk = GenFun::error_CHK(array($linkHash, $this->confirmTbl));
} else {
return $chk;
}
//----------------------------------------------------------
if ($chk['bool']) {
$chk = $this->getConfirmLink(NULL, $linkHash);
} else {
return $chk;
}
//----------------------------------------------------------
$confirmLink = $chk['result'][0];
//----------------------------------------------------------
if ($chk['bool']) {
$chk = $this->exp_CHK($confirmLink);
} else {
return $chk;
}
//----------------------------------------------------------
if ($confirmLink['type'] == 1) {
if (!$chk['bool']) {
$chk = GetTable::go($this->confirmTbl, array("id" => $confirmLink['confirming_id']));
} else {
return $chk;
}
//------------------------------------------------------
$tbl = $chk['result'][0];
//------------------------------------------------------
if ($chk['bool']) {
$chk = $this->tblConfirm_CHK($tbl);
} else {
return $chk;
}
//------------------------------------------------------
if (!$chk['bool']) {
$chk = $this->confirmSubscription($tbl['id'], $confirmLink['type']);
} else {
return $chk;
}
//------------------------------------------------------
} else {
if ($confirmLink['type'] == 0) {
if (!$chk['bool']) {
$chk = $this->disableSubscription($confirmLink['confirming_id']);
} else {
return $chk;
}
}
}
//----------------------------------------------------------
if ($chk['bool']) {
$chk = $this->disableConfirmLink($linkHash);
} else {
return $chk;
}
//----------------------------------------------------------
if ($chk['bool'] && $confirmLink['type'] == 0) {
$chk['message'] = $email . " has successfully unsubscried to " . $tbl['categories_id'];
}
//----------------------------------------------------------
if ($chk['bool'] && $confirmLink['type'] == 1) {
$chk['message'] = $email . " has successfully subscried to " . $tbl['categories_id'];
$chk['type'] = 0;
}
//----------------------------------------------------------
$chk['confirmLink'] = $confirmLink;
//----------------------------------------------------------
return $chk;
}
public function email_CHK($email)
{
//----------------------------------------------------------
//init var
//----------------------------------------------------------
$chk = array("bool" => true, "traceID" => "email_CHK");
//----------------------------------------------------------
$email_result = GetTable::go("accounts", array('email' => $email));
//----------------------------------------------------------
if (!$email_result['bool']) {
return $email_result;
}
//----------------------------------------------------------
if (sizeof($email_result['result']) == 0) {
$chk['bool'] = true;
} else {
$chk['bool'] = false;
$chk['message'] = "'" . $email . "' ALREADY BELONGS TO A PMBL MEMBER";
}
//----------------------------------------------------------
$chk['email'] = $email;
//----------------------------------------------------------
return $chk;
}
public function _getPlaylist($hash = NULL, $lookThroughAll = false, $excludeVideo_id = NULL, $exclude_id = NULL, $limitFrom = NULL, $limitTo = NULL, $getTotal = false, $returnQuery = false)
{
Trace::output($this->traceID, "getPlaylist: " . print_r(func_get_args(), true));
//----------------------------------------------------------
//init var
//----------------------------------------------------------
$excludeVideo_id = GenFun::varChk($excludeVideo_id);
//----------------------------------------------------------
$whereArr = array();
//----------------------------------------------------------
if (!$lookThroughAll) {
$whereArr["title"] = "{ignore} IS NOT NULL";
$whereArr["disabled"] = "{ignore} IS NULL";
}
//----------------------------------------------------------
if (!is_null($hash)) {
$whereArr["hash"] = $hash;
}
//----------------------------------------------------------
if (!is_null($exclude_id)) {
$whereArr["id"] = "{isnot}{$exclude_id}";
}
//----------------------------------------------------------
if (!is_null($excludeVideo_id)) {
$whereArr['id'] = "{notin}" . $this->getPlaylistWithVideo($excludeVideo_id, false, true);
}
//----------------------------------------------------------
$chk = GetTable::go("playlist", $whereArr, array('getTotalRows' => $getTotal, "chkForQuery" => true, "returnQuery" => $returnQuery ? true : false));
//----------------------------------------------------------
if (!is_null($hash)) {
$chk['result'] = $chk['result'][0];
}
//----------------------------------------------------------
return $chk;
}
