function __construct($cmid = 0) { global $db; $this->_cmid = $cmid; if ($this->_cmid != 0) { $this->_dbo = DB_DataObject::Factory("phph_comments"); if (PEAR::isError($this->_dbo)) { throw new Exception2("Bd wewn�rzny", $this->_dbo->getMessage()); } $r = $this->_dbo->get($cmid); if (PEAR::isError($r)) { throw new Exception2("Bd wewn�rzny", $r->getMessage()); } if ($r == 0) { throw new Exception2("Bd", "Komentarz nie istnieje", COMMENT_NOT_FOUND); } $this->_user = DB_DataObject::Factory("phph_users"); if (PEAR::isError($this->_user)) { throw new Exception2("Bd wewn�rzny", $this->_user->getMessage()); } $r = $this->_user->get($this->_dbo->user_id); if (PEAR::isError($r)) { throw new Exception2("Bd wewn�rzny", $r->getMessage()); } if ($r == 0) { throw new Exception2("Bd sp�noci danych", "Uytkownik do kt�ego nalezy komentarz nie istnieje.<br />Skontakuj si�z administratorem, podajc numer komentarza ({$cmid}).", COMMENT_USER_NOT_FOUND); } } }
public function lunchReport($idBrand, $idSocialNetwork, $idInteraction) { $report = DB_DataObject::Factory('MpBrandXSocialNetwork'); // DB_DataObject::debugLevel(1); $report->idBrand = $idBrand; $report->idInteraction = $idInteraction; $report->idSocialNetwork = $idSocialNetwork; $find = $report->find(); if ($find > 0) { while ($report->fetch()) { if ($report->status == 'L') { $report->status = 'E'; $report->update(); } } } else { $report->snID = "Aqui va algo"; $report->ownedBrand = 'N'; $report->status = 'E'; $report->date = date('Y-m-d h:i:s'); $l = $report->insert(); // printVar($l); } $report->free(); return 'ok'; }
function get($table) { $d = DB_DAtaObject::Factory($table); if (method_exists($d, 'availableColumns')) { $cols = $d->availableColumns(); } else { $re = $d->autoJoin(); //echo '<PRE>';print_r($re); $cols = $re['cols']; $types = array(); $tables = array(); $schemas = array($table => $d->table()); foreach ($cols as $name => $table_col) { list($tbl, $col) = explode('.', $table_col); if (!isset($schemas[$tbl])) { $schemas[$tbl] = DB_DataObject::Factory($tbl)->table(); } $types[$name] = $schemas[$tbl][$col]; $tables[$name] = $tbl; } foreach ($re['join_names'] as $c => $f) { $cols[$c] = $f; } } foreach ($cols as $c => $f) { $ret[] = array('name' => $c, 'val' => $f, 'type' => isset($types[$c]) ? $this->typeToName($types[$c]) : -1, 'table' => isset($tables[$c]) ? $tables[$c] : ""); } $this->jdata($ret); }
function launchFacebook($terminoBuscar) { $app_access_token = genToken(); $resultFacebook = app_request("https://graph.facebook.com/v2.5/search?q=" . $terminoBuscar . "&type=page&limit=10&fields=id,name,picture.type(normal),likes&" . $app_access_token); //printVar($resultFacebook,$_SERVER['SERVER_NAME'].'/publication/search/results/resultFacebook.json'); //printVar($_SERVER["DOCUMENT_ROOT"]); $fp = fopen($_SERVER["DOCUMENT_ROOT"] . '/publication/search/results/resultFacebook.json', 'w'); $qpaso = fwrite($fp, json_encode($resultFacebook)); fclose($fp); //printVar($qpaso,'que paso'); $obj = DB_DataObject::Factory('MpBrand'); $obj->name = $terminoBuscar; $find = $obj->find(); if ($find > 0) { // echo 'entra al if'; while ($obj->fetch()) { //DB_DataObject::debugLevel(1); $obj->picture = $resultFacebook['data'][0]['picture']['data']['url']; $obj->update(); } } else { } $obj->free(); //echo json_encode(''); }
function get() { $this->transObj = DB_DataObject::Factory('core_enum'); $this->transObj->query('BEGIN'); PEAR::setErrorHandling(PEAR_ERROR_CALLBACK, array($this, 'onPearError')); $this->modules = $this->modulesList(); $this->etype(); $this->defaults(); foreach ($this->defaults as $k => $v) { $enum = DB_DataObject::factory('core_enum'); $enum->setFrom(array('etype' => $this->etype->name, 'name' => $k, 'active' => 1)); if ($enum->find(true)) { continue; } $enum->display_name = $v; $enum->insert(); } $notify = DB_DataObject::factory('core_notify'); $notify->selectAdd(); $notify->selectAdd("\n DISTINCT(evtype) AS evtype\n "); $types = $notify->fetchAll(); foreach ($types as $t) { $enum = DB_DataObject::factory('core_enum'); $enum->setFrom(array('etype' => $this->etype->name, 'name' => $t->evtype, 'active' => 1)); if ($enum->find(true)) { continue; } $enum->display_name = $t->evtype; $enum->insert(); } $this->jok('DONE'); }
static function getUserLevel($uid) { global $db; $gl = 0; $q = $db->prepare("SELECT IFNULL(MAX(group_level), 0) AS gl FROM phph_groups WHERE group_id IN (SELECT group_id FROM phph_group_users WHERE user_id = ?)"); if (PEAR::isError($q)) { die($q->getMessage()); } $r = $db->execute($q, $uid); if (PEAR::isError($r)) { die($r->getMessage()); } $row = $r->fetchRow(); $gl = $row['gl']; $user = DB_DataObject::Factory("phph_users"); if (PEAR::isError($user)) { die($user->getMessage()); } $r = $user->get($uid); if (PEAR::isError($r)) { die($r->getMessage()); } if ($r == 0) { return 0; } return max($gl, $user->user_level); }
function get($id) { $ev = DB_DataObject::Factory('Events'); if (!$ev->get((int) $id)) { $this->jerr("invalid id"); } // verify if not admin, then they should $g = DB_DataObject::Factory('core_group_member'); if (is_a($g, 'DB_DataObject')) { $grps = $g->listGroupMembership($this->authUser); //var_dump($grps); $isAdmin = $g->inAdmin; if (!$isAdmin && $ev->person_id != $this->authUser->id) { $this->jerrAuth(); } } echo '<PRE>' . htmlspecialchars(print_r($ev->toArray(), true)) . "</PRE>"; // we have 2 bits of data available at present: // core_event_audit // the event file.. $d = DB_DataObject::factory('core_event_audit'); if (is_a($d, 'DB_DataObject')) { echo "<H2>Changed Data:</H2>"; $d->event_id = $ev->id; foreach ($d->fetchAll() as $d) { echo "{$d->name} SET TO: " . htmlspecialchars($d->newvalue) . "<br/>\n"; } } echo "<HR><H2>Posted Data:</H2>"; $logdir = DB_DAtaObject::Factory('Events')->logDir(); if (!$logdir) { echo "not available (Pman[storedir] not configured)"; exit; } $file = $logdir . date('/Y/m/d/', strtotime($ev->event_when)) . $ev->id . ".php"; if (file_exists($file)) { echo '<PRE>' . htmlspecialchars(file_get_contents($file)) . '</PRE>'; } $file = $logdir . date('/Y/m/d/', strtotime($ev->event_when)) . $ev->id . ".json"; if (!file_exists($file)) { echo "not available (missing file) {$file}"; exit; } echo '<PRE>' . htmlspecialchars(print_r(json_decode(file_get_contents($file)), true)) . '</PRE>'; echo '<BR/><PRE>' . htmlspecialchars($ev->remarks) . '</PRE>'; $json = json_decode($ev->remarks, JSON_PRETTY_PRINT); if (json_last_error() == JSON_ERROR_NONE) { echo "<HR><H2>JSON DECODE Data:</H2>"; echo '<PRE>' . print_r($json, true) . '</PRE>'; } $filesJ = json_decode(file_get_contents($file)); echo '<br /><PRE>Download files</PRE>'; foreach ($filesJ->FILES as $k => $f) { $ip = $ff->baseURL . "/Images/events/" . $ev->id . '/' . $f->tmp_name; echo '<a href="' . $ip . '/download">' . htmlspecialchars($k . ' - ' . $f->name) . '</a><br/>'; } exit; }
function get($args, $opts) { //DB_DataObject::DebugLevel(1); $d = DB_DataObject::Factory('core_curr_rate'); $d->loadRates(); $hkd = $d->convert(1, 'USD', 'HKD'); echo "1 USD is ~ {$hkd} HKD (should be about 7.75)\n "; die("done"); }
function post() { PEAR::setErrorHandling(PEAR_ERROR_CALLBACK, array($this, 'onPearError')); $this->sessionState(0); // turn off the session.. $img = DB_DataObject::Factory('images'); $img->setFrom(array('onid' => 0, 'ontable' => 'ipshead')); $img->onUpload(false); require_once 'File/Convert.php'; $fc = new File_Convert($img->getStoreName(), $img->mimetype); $csv = $fc->convert('text/csv'); $this->importCsv($csv); }
function post() { $this->transObj = DB_DataObject::Factory('invhist_transfer'); $this->transObj->query('BEGIN'); PEAR::setErrorHandling(PEAR_ERROR_CALLBACK, array($this, 'onPearError')); $img = DB_DataObject::Factory('images'); $img->setFrom(array('onid' => 0, 'ontable' => 'ipshead')); $img->onUpload(false); require_once 'File/Convert.php'; $fc = new File_Convert($img->getStoreName(), $img->mimetype); $csv = $fc->convert('text/csv'); $ret = $this->importCsv($csv); $this->jdata($ret['data'], false, isset($ret['extra']) ? $ret['extra'] : array()); }
function get($app) { die("DISABLED"); $b = DB_DataObject::Factory('Builder'); $b->find(); echo '<PRE>'; $dir = "/home/gitlive/"; $map = array('Clipping' => 'web.MediaOutreach/Pman/Clipping', 'PressRelease' => 'web.MediaOutreach/Pman/PressRelease', 'Ris' => 'web.Ris/Pman/Ris', 'TestApp' => false, 'Hex' => false, 'Example' => false, 'ExampleOld' => false, 'Deleted' => false, 'DealFlow' => 'web.Dealflow/Pman/DealFlow', 'Aviation' => 'web.Aviation/Pman/Aviation'); $dirs = array(); while ($b->fetch()) { // print_r($b); $data = json_decode($b->json); $data->title = $data->name; $data->name = $data->{'|module'}; if (empty($data->name)) { continue; } // {"id":"roo-file-1","name":"layout test.bjs","parent":"","title":false,"path":"/h //ome/alan/buildertest/layout test.bjs" $fn = $dir . "Pman." . trim($data->app) . '/' . $data->name . '.bjs'; if (isset($map[trim($data->app)])) { if ($map[trim($data->app)] === false) { continue; } $fn = $dir . $map[$data->app] . '/' . $data->name . '.bjs'; } if (!file_exists(dirname($fn))) { print "<B>SKIP " . $fn . "</B>\n"; continue; } $dirs[dirname($fn)] = true; echo "WRITE : " . $fn . "\n"; //echo " " .htmlspecialchars(json_encode($data)) . "\n"; file_put_contents($fn, json_encode($data)); } print_r($dirs); foreach ($dirs as $d => $n) { chdir($d); $cmd = 'git pull 2>&1'; echo $cmd . "\n" . `{$cmd}`; $cmd = 'git add --all 2>&1'; echo $cmd . "\n" . `{$cmd}`; $cmd = "git commit -m 'add bjs' -a --author='Alan Knowles <*****@*****.**>' 2>&1"; echo $cmd . "\n" . `{$cmd}`; $cmd = "git push 2>&1"; echo $cmd . "\n" . `{$cmd}`; } exit; }
public function getall() { global $g; $data_obj = \DB_DataObject::Factory('mycms\\' . $this->m_type); if ($data_obj instanceof \DB_DataObject_Error) { $g['error']->push($data_obj->message); return; } $count = $data_obj->find(); $rows = array(); while ($data_obj->fetch()) { $rows[] = clone $data_obj; } return array('rows' => $rows, 'count' => $count); }
function makeCopy($roo) { $c = DB_DataObject::Factory($this->tableName()); $c->setFrom($this); $c->name = "COPY of " . $this->name; $c->updated_dt = $this->sqlValue('NOW()'); $id = $c->insert(); $c = DB_DataObject::Factory($this->tableName()); $c->get($id); // copy images. $i = DB_DataObject::factory('Images'); $i->onid = $this->id; $i->ontable = $this->tableName(); $i->find(); while ($i->fetch()) { $new_image = DB_DataObject::factory('Images'); $new_image->onid = $c->id; $new_image->ontable = $this->tableName(); $new_image->createFrom($i->getStoreName(), $i->filename); $map[$i->id] = $new_image->id; } libxml_use_internal_errors(true); $doc = new DOMDocument('1.0', 'UTF-8'); $doc->loadHTML('<?xml encoding="UTF-8"><HTML><BODY>' . $this->bodytext . '</BODY></HTML>'); $doc->formatOutput = true; //echo '<PRE>'; print_R($doc); $xpath = new DOMXpath($doc); foreach ($xpath->query('//img[@src]') as $img) { $href = $img->getAttribute('src'); //var_dump($href); $matches = array(); if (preg_match("/Images\\/([0-9]+)\\/([^#]+)\\#image\\-([0-9]+)\$/", $href, $matches)) { $oid = $matches[1]; if (!isset($map[$oid])) { //echo "skip no new id for $oid"; continue; } $nid = $map[$oid]; $nstr = "/Images/{$nid}/{$matches[2]}/#image-{$nid}"; $img->setAttribute('src', str_replace($matches[0], $nstr, $href)); } } $cc = clone $c; $c->bodytext = $doc->saveHTML(); $c->update($cc); libxml_use_internal_errors(false); $roo->jok("duplicated"); }
public function insertAnalytics($pagina, $usuario, $pass, $idBrand) { $web = DB_DataObject::Factory('MpWeb'); // DB_DataObject::debugLevel(1); $web->url = $pagina; $web->idBrand = $idBrand; $find = $web->find(); if ($find > 0) { while ($web->fetch()) { $web->analyticsUser = $usuario; $web->analyticsPass = $pass; $web->update(); } } $web->free(); }
function get() { // must recieve a group.. if (!isset($_GET['group_id']) || (int) $_GET['group_id'] < 0) { $this->jerr("NO GROUP"); } if (!$this->hasPerm('Core.Groups', 'S')) { // listing groups.. $this->jerr("PERMISSION DENIED"); } $g = DB_DataObject::Factory('core_group'); if (!$g->get($_GET['group_id'])) { $this->jerr("group is invalid"); } //print_r($g); // DB_DataObject::debugLevel(1); $p = DB_DataObject::factory('core_group_right'); $p->group_id = (int) $_GET['group_id']; $p->find(); $cur = array(); while ($p->fetch()) { $cur[$p->rightname] = clone $p; } $e = -1; $ar = array(); // echo "<PRE>"; print_r($p->defaultPermData() ); foreach ($p->defaultPermData() as $k => $defdata) { if (empty($defdata[0])) { // no admin data available.. continue; } if (!isset($cur[$k])) { // then there is no current access right for it.. //DB_DataObject::debugLevel(1); $gr = DB_DataObject::factory('core_group_right'); $gr->group_id = (int) $_GET['group_id']; $gr->rightname = $k; $gr->accessmask = $g->type == 2 ? '' : $defdata[1]; // set to defaults.. unless it's a contact group. $gr->insert(); $cur[$k] = clone $gr; } $ar[] = array('id' => $cur[$k]->id * 1, 'rightname' => $k, 'descript' => isset($defdata[2]) ? $defdata[2] : '', 'accessmask' => $cur[$k]->accessmask, 'FullMask' => $defdata[0], 'group_id' => (int) $_GET['group_id']); } $this->jdata($ar); }
static function set($name, $val) { $config = DB_DataObject::Factory('phph_config'); if (PEAR::isError($config)) { return $config; } $r = $config->get($name); if (PEAR::isError($r)) { return $config; } $config->config_value = $val; if ($r == 0) { return $config->insert(); } else { return $config->update(); } }
public function traeHastag() { //DB_DataObject::debugLevel(5); //Crea una nueva instancia de $tabla a partir de DataObject $objDBO = DB_DataObject::Factory('DpHashtag'); $objDBO->selectadd(); $objDBO->selectadd('id,hashtag'); //$objDBO -> orderBy("idTweet DESC"); //$objDBO -> limit('1'); $objDBO->find(); $count = 0; while ($objDBO->fetch()) { $ret[$count]->id = $objDBO->id; $ret[$count]->hashtag = $objDBO->hashtag; $count++; } //$ret = $ret + 1; //Libera el objeto DBO $objDBO->free(); return $ret; }
/** * initalizie the cfg aray * */ function cfg() { static $loaded = false; if ($loaded) { return self::$cfg; } $loaded = true; $ff = HTML_FlexyFramework::get(); // BC compatible.. if any of these are set, then we use them as the settings.. $opts = array(); foreach (array('Pman_Core_I18n', 'Pman_Core_I18N', 'Pman_I18N', 'Pman_I18n') as $pk) { if (isset($ff->{$pk})) { //var_dump($pk); $opts = $ff->{$pk}; break; } } //echo '<PRE>';print_R($opts);//exit; // var_dump($opts);exit; $i = DB_DataObject::Factory('I18n'); // load the cofiguration foreach ($opts as $k => $v) { if ($v == '*') { // everything.. // self::$cfg[$k] = $i->availableCodes($k, false); continue; } self::$cfg[$k] = is_array($v) ? $v : explode(',', $v); } // available codes recursively calls this... -- so the above has to be set first.. foreach ($opts as $k => $v) { if ($v == '*') { // everything.. self::$cfg[$k] = '*'; //$i->availableCodes($k, false); continue; } } return self::$cfg; }
private function getSubTreeR($cid) { global $db; $dbo = DB_DataObject::Factory("phph_categories"); if (PEAR::isError($dbo)) { throw new Exception2("B³±d wewnêtrzny", $dbo->getMessage()); } $r = $dbo->get($cid); if (PEAR::isError($r)) { throw new Exception2("B³±d wewnêtrzny", $r->getMessage()); } if ($r == 0) { throw new Exception2("B³±d", "Kategoria nie istnieje", CATEGORY_NOT_FOUND); } $sub = array(); $q = $db->prepare("SELECT category_id FROM phph_categories WHERE category_parent = ? ORDER BY category_order ASC"); $res = $db->execute($q, array($cid)); while ($row = $res->fetchRow()) { $sub[] = $this->getSubTreeR($row['category_id']); } return array('id' => $cid, 'name' => $dbo->category_name, 'sub' => $sub); }
function addComment($title, $text) { $session = Session::singletone(); $dbo = DB_DataObject::Factory("phph_comments"); if (PEAR::isError($dbo)) { throw new Exception2(_INTERNAL_ERROR, $dbo->getMessage()); } $dbo->comment_title = $title; $dbo->comment_text = $text; $dbo->photo_id = $this->_pid; $dbo->comment_date = time(); $dbo->user_id = $session->_uid; $dbo->insert(); if ($this->_dbo->user_id != $session->_uid) { $user = new User($session->_uid); $to_name = $this->_user->user_login; $photo_title = $this->_dbo->photo_title; $author = $user->_dbo->user_login; $body = <<<EOT Witaj {$to_name}, U¿ytkownik {$author} doda³ do Twojego zdjêcia "{$photo_title}" komentarz. Poni¿ej znajduje siê tre¶æ komentarza: {$title} {$text} -- Ten email zosta³ wys³any automatycznie. Prosimy nie odpowiadaæ. EOT; Utils::mail("Nowy komentarz do Twojego zdjêcia \"{$photo_title}\".", $body, $this->_user->user_email, $this->_user->user_name); } }
function logDeleteEvent($object) { DB_DataObject::Factory('Events')->logDeletedRecord($object); $this->addEvent("DELETE", $object); }
} if ($user_pass1 == "") { $err_pass1 = true; $err_pass2 = true; throw new Exception2(_ADMIN_CANT_CREATE_ACCOUNT, _ADMIN_ERROR_EMPTY_PASSWORD); } if ($user_email == "") { $err_email = true; throw new Exception2(_ADMIN_CANT_CREATE_ACCOUNT, _ADMIN_ERROR_EMPTY_EMAIL); } if ($user_pass1 != $user_pass2) { $err_pass1 = true; $err_pass2 = true; throw new Exception2(_ADMIN_CANT_CREATE_ACCOUNT, _ADMIN_ERROR_PASSWORDS_DO_NOT_MATCH); } $user = DB_DataObject::Factory('phph_users'); if (PEAR::isError($user)) { throw new Exception2(_INTERNAL_ERROR, $user->getMessage()); } $r = $user->get('user_login', $_POST['user_login']); if (PEAR::isError($r)) { throw new Exception2(_INTERNAL_ERROR, $r->getMessage()); } if ($r != 0) { throw new Exception2(_ADMIN_CANT_CREATE_ACCOUNT, _ADMIN_LOGIN_EXISTS); } $user->user_login = $user_login; $user->user_pass = md5($user_pass1); $user->user_email = $user_email; $user->user_registered = time(); $user->user_activated = time();
function post() { //DB_DataObject::debugLevel(1); if (!empty($_REQUEST['getAuthUser'])) { $this->sendAuthUserDetails(); exit; } if (!empty($_REQUEST['logout'])) { return $this->logout(); } if (!empty($_REQUEST['passwordRequest'])) { //|| (strpos($_REQUEST['username'], '@') < 1)) { return $this->passwordRequest($_REQUEST['passwordRequest']); } if (!empty($_REQUEST['changePassword'])) { return $this->changePassword($_REQUEST); } // login attempt.. $ff = HTML_FlexyFramework::get(); $tbl = empty($ff->Pman['authTable']) ? 'core_person' : $ff->Pman['authTable']; $u = DB_DataObject::factory($tbl); // ratelimit if (!empty($_SERVER['REMOTE_ADDR'])) { //DB_DataObject::DebugLevel(1); $e = DB_DataObject::Factory('Events'); $e->action = 'LOGIN-BAD'; $e->ipaddr = $_SERVER['REMOTE_ADDR']; $e->whereAdd('event_when > NOW() - INTERVAL 10 MINUTE'); if ($e->count() > 5) { $this->jerror('LOGIN-RATE', "Login failures are rate limited - please try later"); } } //$u->active = 1; // empty username = not really a hacking attempt. if (empty($_REQUEST['username'])) { //|| (strpos($_REQUEST['username'], '@') < 1)) { $this->jerror('LOGIN-EMPTY', 'You typed the wrong Username or Password (0)'); exit; } $u->authUserName($_REQUEST['username']); if ($u->count() > 1 || !$u->find(true)) { $this->jerror('LOGIN-BAD', 'You typed the wrong Username or Password (1)'); exit; } if (!$u->active()) { $this->jerror('LOGIN-BAD', 'Account disabled'); } // check if config allows non-owner passwords. // auth_company = "OWNER" // auth_company = "CLIENT" or blank for all? // perhaps it should support arrays.. $ff = HTML_FlexyFramework::get(); if (!empty($ff->Pman['auth_comptype']) && $ff->Pman['auth_comptype'] != $u->company()->comptype) { //print_r($u->company()); $this->jerror('LOGIN-BADUSER', "Login not permited to outside companies"); // serious failure } // note we trim \x10 -- line break - as it was injected the front end // may have an old bug on safari/chrome that added that character in certian wierd scenarios.. if ($u->checkPassword(trim($_REQUEST['password'], ""))) { $u->login(); // we might need this later.. $this->addEvent("LOGIN", false, session_id()); if (!empty($_REQUEST['lang'])) { $u->lang($_REQUEST['lang']); } // log it.. $this->sendAuthUserDetails(); exit; //exit; } $this->jerror('LOGIN-BAD', 'You typed the wrong Username or Password (2)'); // - " . htmlspecialchars(print_r($_POST,true))."'"); exit; }
$category->category_name = $category_name; if ($category_parent > 0) { $category->category_parent = $category_parent; } else { $category->category_parent = DB_DataObject_Cast::sql("NULL"); } $r = $category->find(); if (PEAR::isError($r)) { throw new Exception2(_INTERNAL_ERROR, $r->getMessage()); } $category->fetch(); if ($r != 0 && ($action == "add" || $action == "edit" && $category->category_id != $cid)) { throw new Exception2($err, _ADMIN_CATEGORY_EXISTS); } if ($action == "edit") { $category = DB_DataObject::Factory('phph_categories'); if (PEAR::isError($category)) { throw new Exception2(_INTERNAL_ERROR, $category->getMessage()); } $r = $category->get($cid); if (PEAR::isError($r)) { throw new Exception2(_INTERNAL_ERROR, $r->getMessage()); } if ($r == 0) { throw new Exception2($err, _ADMIN_ERROR_CATEGORY_DOESNT_EXISTS); } } else { $category->category_created = time(); $category->category_creator = $session->_uid; } $category->category_name = $category_name;
/** * translate (used by database building); * usage : * require_once 'Pman/Core/I18n.php'; * $x = new Pman_Core_I18N(); * $x->translate($this->authuser, 'c', 'US'); * @param au - auth User * @param type = 'c' or 'l' * @param k - key to translate * */ function translate($au, $type, $k) { static $cache; if (empty($k)) { return '??'; } $lang = !$au || empty($au->lang) ? 'en' : is_string($au) ? $au : $au->lang; // does it need caching? $i = DB_DataObject::Factory('I18n'); return $i->translate($lang, $type, $k); }
function syncTemplate() { // possibly needs to be cleverer = if template is a dialog etc.? $m = $this->module(); $t = DB_DataObject::Factory('cms_template'); $t->view_name = $m->name; $t->template = $this->name . '.html'; $t->lang = 'en'; if (!$t->find(true)) { $t->updated = $t->sqlValue('NOW()'); $t->insert(); return; } $t->updated = $t->sqlValue('NOW()'); $t->update(); }
} $r = $user->get($uid); if (PEAR::isError($r)) { die($r->getMessage()); } if ($r == 0) { header("Location: " . $session->addSID(Config::get("site_url") . "/admin/users.php")); } $name = $user->user_login; $field = "user_id"; $id = $uid; } else { if (!Permissions::checkPerm('change_groups_permissions')) { die("Permission denied."); } $group = DB_DataObject::Factory('phph_groups'); if (PEAR::isError($group)) { die($group->getMessage()); } $r = $group->get($gid); if (PEAR::isError($r)) { die($r->getMessage()); } if ($r == 0) { header("Location: " . $session->addSID(Config::get("site_url") . "/admin/groups.php")); } $name = $group->group_name; $field = "group_id"; $id = $gid; } $q = $db->prepare("SELECT permission FROM phph_permissions WHERE {$field} = ?");
function actualizaRanking() { //DB_DataObject::debugLevel(1); $tableDB = DB_DataObject::Factory("VistaNestumRanking"); $tableDB->query("insert into nestum_rankingcron (idUsuario,idFacebook,nombreCompleto,nombres,apellidos,total) select idUsuario,idFacebook,concat(nombres,' ',apellidos),nombres,apellidos,total from vista_nestum_ranking ORDER BY total DESC"); return $tableDB; }
function lastId($field) { //Crea una nueva instancia de $tabla a partir de DataObject $objDBO = DB_DataObject::Factory($this->__tempName); $objDBO->selectadd(); $objDBO->selectadd($field); $objDBO->orderBy("{$field} DESC"); $objDBO->find(); $objDBO->fetch(); $ret = $objDBO->{$field}; $objDBO->free(); return $ret; }
function applyDefs($g, $usecol) { $defs = $this->defaultPermData(); //echo '<PRE>';print_r($defs); //$usecol = 1; foreach ($defs as $rightname => $defdata) { $gr = DB_DataObject::Factory('core_group_right'); $gr->rightname = $rightname; $gr->group_id = $g->id; if (!$gr->find(true)) { $gr->accessmask = $defdata[$usecol]; $gr->insert(); continue; } $oldgr = clone $gr; $gr->accessmask = $gr->mergeMask($gr->accessmask, $defdata[$usecol]); if ($gr->accessmask == $oldgr->accessmask) { continue; } $gr->update($oldgr); } }