/home/joonbug3/codebases/skyphp/lib/Sky/functions.inc.php line 469
- 1 /home/joonbug3/codebases/skyphp/lib/Sky/functions.inc.php line 469PDO->query(0, 1)
462 // default to the global read db
463 if (!$dbx) {
464 global $db;
465 $dbx = $db;
466 }
467 // execute the query
468 elapsed('begin SQL: ' . $sql);
469 $rows = $dbx->query($sql, PDO::FETCH_OBJ);
470 elapsed('end SQL');
471 return $rows->fetchAll();
472 }
473
474 function sql_array($SQL, $dbx=NULL){
475 $rows = sql($SQL,$dbx);
476 $rs = array();
- 0 string (273) "SELECT id, id AS blog_article_tag_id FROM ( SELECT DISTINCT "
SELECT id, id AS blog_article_tag_idFROM (SELECT DISTINCT ON (q.id) id, rowFROM (SELECTblog_article_tag.id,row_number() OVER() as rowFROM blog_article_tagWHERE blog_article_tag.active = 1AND blog_article_tag.blog_article_id = ) as q) as finORDER BY row
- 1 integer 5
- 2 /home/joonbug3/codebases/skyphp/lib/class/class.getList.php line 280sql(sql)
- 3 /home/joonbug3/codebases/skyphp/lib/class/class.getList.php line 646getList->select(arr)
639 * @return callable
640 */
641 public static function getFn($aql, $search_operators = false)
642 {
643 $list = static::autoGenerate($aql, $search_operators);
644
645 return function($clause = array(), $count = false) use($list) {
646 return $count ? $list->getCount($clause) : $list->select($clause);
647 };
648 }
649
650 }
- arr array (1)
- 'where' => string (35) "blog_article_tag.blog_article_id = "
- 4 /home/joonbug3/codebases/skyphp/lib/Sky/Model/AQLModel.php line 988getList::{closure}(0, 1)
981 * - offset
982 * @param bool $do_count if true, returns count instead of ids
983 * @return array list of IDs
984 */
985 public static function getList($criteria = [], $do_count = false)
986 {
987 $fn = \getList::getFn(static::getAQL());
988 $ids = $fn($criteria, $do_count);
989 return $ids;
990 }
991
992
993 /**
994 * Gets the quantity of objects with the given criteria
995 * @param array $criteria
- 0 array (1)
- 'where' => string (35) "blog_article_tag.blog_article_id = "
- 1 bool FALSE
- 5 /home/joonbug3/codebases/skyphp/lib/Sky/Model/PHPModel.php line 178Sky\Model\AQLModel::getList(criteria)
171 * - order by
172 * - limit
173 * - offset
174 * @return array
175 */
176 public static function getMany(array $criteria = array())
177 {
178 $rs = static::getList($criteria);
179 foreach ($rs as $i => $id) {
180 $rs[$i] = static::get($id);
181 }
182 return ($criteria['limit'] === 1) ? $rs[0] : $rs;
183 }
184
185
- criteria array (1)
- 'where' => string (35) "blog_article_tag.blog_article_id = "
- 6 /home/joonbug3/codebases/joonbug/pages/_market.slug_/_blog.slug_/_blog.slug_.php line 22Sky\Model\PHPModel::getMany(criteria)
15 $blog = new \Crave\Model\blog($this->vars['blog_id']);
16 if (IDE) {
17 $article = new \Crave\Model\blog_article(IDE);
18 $articles = [$article];
19
20 $profile_page = true;
21
22 $tags_rs = \Crave\Model\blog_article_tag::getMany(['where'=>"blog_article_tag.blog_article_id = {$article->id}"]);
23
24 $tags = implode(', ', array_map(function($item){ return $item->name ; }, $tags_rs));
25
26 } else {
27 $query = ['where' => "blog_article.blog_id = {$blog->id} AND blog_article.market_id = {$market_id} AND status = 'A' ", 'order_by' => 'blog_article.id desc'];
28 $page = $_GET['page'] ?: 1;
29
- criteria array (1)
- 'where' => string (35) "blog_article_tag.blog_article_id = "
- 7 /home/joonbug3/codebases/skyphp/lib/Sky/Page.php line 326include(0)
319
320 // push data array into the file's scope
321 foreach ($__d as $__k => $__v) $$__k = $__v;
322 unset($__d, $__k, $__v);
323
324 // for backwards compatibility
325 $p = $this;
326 include $__p;
327
328 // removing $__p, otherwise it will be in defined_vars()
329 unset($__p);
330 return get_defined_vars();
331 }
332
333 /**
- 0 string (80) "/home/joonbug3/codebases/joonbug/pages/_market.slug_/_blog.s "
/home/joonbug3/codebases/joonbug/pages/_market.slug_/_blog.slug_/_blog.slug_.php
- 8 /home/joonbug3/codebases/skyphp/lib/Sky/Page.php line 239Sky\Page->includePath(__p, __d)
232 $get_contents = (bool) ($_POST['_json'] || $_GET['_script']);
233 if ($get_contents) {
234 if ($_GET['_script']) $this->no_template = true;
235 ob_start();
236 }
237
238 // run-first / settings / script files need to be executed in the same scope
239 $vars = $this->includePath($this->page_path, $vars);
240
241 if ($get_contents) {
242 // refreshing a secondary div after an ajax state change
243 if (is_array($this->div)) {
244 $this->div['page'] = ob_get_contents();
245 } else {
246 if (!$this->div) {
- __p string (47) "pages/_market.slug_/_blog.slug_/_blog.slug_.php"
- __d array (13)
- 'this' => object Sky\Page (30)
- public uri -> string (27) "/newyork/glamdamnit/rss.xml"
- public urlpath -> string (19) "/newyork/glamdamnit"
- public incpath -> string (24) "pages/newyork/glamdamnit"
- public page_path -> string (47) "pages/_market.slug_/_blog.slug_/_blog.slug_.php"
- public queryfolders -> array (1)
- string (7) "rss.xml"
- public ide -> string (7) "rss.xml"
- public slug -> string (0) ""
- public title -> string (0) ""
- public favicon -> string (12) "/favicon.ico"
- public apple_touch_icon -> string (21) "/apple-touch-icon.png"
- public seo -> object Crave\Model\website_page (1)
- object (1)
- Static class properties (9)
- protected _data -> object stdClass (13)
- public end_mmdd -> NULL
- public nickname -> string (4) "old "
- public page_path -> string (47) "pages/_market.slug_/_blog.slug_/_blog.slug_.php"
- public start_mmdd -> string (4) "0627"
- public url -> NULL
- public website_id -> integer 1
- public website_page_id -> integer 163
- public id -> integer 163
- public domain -> string (11) "joonbug.com"
- public website_ide -> string (11) "FTf5apggq3J"
- public website_page_ide -> string (11) "uoUyVkBPQdC"
- public ide -> string (11) "uoUyVkBPQdC"
- public fields -> array (8)
- object Crave\Model\website_page_data (2)
*DEPTH TOO GREAT*
- object Crave\Model\website_page_data (2)
*DEPTH TOO GREAT*
- object Crave\Model\website_page_data (2)
*DEPTH TOO GREAT*
- object Crave\Model\website_page_data (2)
*DEPTH TOO GREAT*
- object Crave\Model\website_page_data (2)
*DEPTH TOO GREAT*
- object Crave\Model\website_page_data (2)
*DEPTH TOO GREAT*
- object Crave\Model\website_page_data (2)
*DEPTH TOO GREAT*
- object Crave\Model\website_page_data (2)
*DEPTH TOO GREAT*
- public $_meta :: array (9)
- 'requiredFields' => array (0)
- 'cachedLists' => array (0)
- 'readOnlyProperties' => array (0)
- 'readOnlyTables' => array (0)
- 'possibleErrors' => array (1)
- 'my_error_code' => array (2)
*DEPTH TOO GREAT*
- 'aql' => object Sky\AQL (6)
- object (6)
- Static class properties (4)
- public statement -> string (308) " website_page { end_mmdd, nickname, page_path, start_mmdd, u "
website_page { end_mmdd, nickname, page_path, start_mmdd, url, website_id, [website_page_data]s as fields } website { domain name as website_name, }
- public primaryTable -> string (12) "website_page"
- public blocks -> array (2)
*DEPTH TOO GREAT*
- public distinct -> bool FALSE
- public distinctOn -> string (0) ""
- public sql -> object stdClass (3)
*DEPTH TOO GREAT*
- private $transactionCounter :: integer 0
- public $activeWhere :: string (10) "active = 1"
- public $errors :: array (0)
- public $reserved :: array (35)
*DEPTH TOO GREAT*
- 'primary_table' => string (12) "website_page"
- 'class' => string (24) "Crave\Model\website_page"
- 'lazyObjects' => array (1)
- 'fields' => array (4)
*DEPTH TOO GREAT*
- protected $_internalErrors :: array (4)
- 'read_only' => array (1)
- 'message' => string (47) "Currently in "read only" mode. Try again later."
- 'required' => array (0)
- 'not_found' => array (0)
- 'database_error' => array (0)
- constant AQL :: string (308) " website_page { end_mmdd, nickname, page_path, start_mmdd, u "
website_page { end_mmdd, nickname, page_path, start_mmdd, url, website_id, [website_page_data]s as fields } website { domain name as website_name, }
- constant FIELD_IS_REQUIRED :: string (15) "%s is required."
- constant LAZY_OBJECTS_MESSAGE :: string (48) "[This array of objects will be loaded on demand]"
- constant LAZY_OBJECT_MESSAGE :: string (38) "[This object will be loaded on demand]"
- constant VALIDATION_METHOD_PREFIX :: string (9) "validate_"
- constant ID_FIELD :: string (2) "id"
- constant FOREIGN_KEY_VALUE_TBD :: string (39) "[This value will be determined on save]"
- public breadcrumb -> array (0)
- public vars -> array (7)
- 'market_id' => integer 1
- 'market_slug' => string (7) "newyork"
- 'blog_id' => integer 4
- 'blog_slug' => string (10) "glamdamnit"
- 'primary_table' => NULL
- 'model' => NULL
- 'database_folder' => NULL
- public css -> array (0)
- public js -> array (0)
- public script -> array (0)
- public script_files -> array (0)
- public template_css -> array (0)
- public template_js -> array (0)
- public html_attrs -> array (0)
- public head -> array (0)
- public templates -> array (0)
- public is_ajax_request -> bool FALSE
- protected cache_is_buffering -> array (0)
- protected css_added -> array (0)
- public querystring -> string (0) ""
- public sky_start_time -> float 1434895604.68
- public protocol -> string (4) "http"
- public website -> object stdClass (8)
- public website_id -> integer 1
- public ct_promoter_website_id -> integer 2333
- public ct_promoter_id -> integer 1
- public ct_promoter_website_ide -> string (11) "GR7zqahrsoz"
- public ct_promoter_ide -> string (11) "rquNesCME11"
- public website_name -> string (7) "Joonbug"
- public phone -> string (12) "800-111-1234"
- public site_criteria -> array (3)
- 'status' => string (1) "A"
- 'seller__ct_promoter_id' => integer 1
- 'ct_promoter_website_id' => integer 2333
- public market -> object Crave\Model\market (1)
- object (1)
- Static class properties (10)
- protected _data -> object stdClass (30)
- public city -> string (8) "New York"
- public code -> string (3) "NYC"
- public country_code -> string (2) "US"
- public latitude -> string (9) "40.735747"
- public longitude -> string (9) "-73.99056"
- public name -> string (8) "New York"
- public on_website -> integer 1
- public slug -> string (7) "newyork"
- public venue_search_nickname -> string (3) "NYC"
- public state -> string (2) "NY"
- public state_full -> string (8) "New York"
- public market1 -> string (8) "New York"
- public market2 -> string (3) "NYC"
- public market3 -> string (13) "New York City"
- public market4 -> string (2) "NY"
- public name_alt1 -> string (3) "NYC"
- public name_alt2 -> string (13) "New York City"
- public name_alt3 -> string (9) "Big Apple"
- public county -> string (9) "Manhattan"
- public target -> integer 1
- public skybox -> integer 1
- public market_id -> integer 1
- public id -> integer 1
- public country_name -> string (13) "United States"
- public country_slug -> string (2) "us"
- public country_id -> integer 213
- public market_ide -> string (11) "ra4eW4jJfYw"
- public ide -> string (11) "ra4eW4jJfYw"
- public country_ide -> string (11) "EfzEx1yFX5m"
- public neighborhoods -> string (48) "[This array of objects will be loaded on demand]"
- public $_meta :: array (5)
- 'requiredFields' => array (3)
- 'name' => string (4) "Name"
- 'latitude' => string (8) "Latitude"
- 'longitude' => string (9) "Longitude"
- 'aql' => object Sky\AQL (6)
- object (6)
- Static class properties (4)
- public statement -> string (671) " market { [market_nbhd]s as neighborhoods, city, code, count "
market { [market_nbhd]s as neighborhoods, city, code, country_code, latitude, longitude, name, on_website, slug, venue_search_nickname, state, state_full, market1, market2, market3, market4, name_alt1, name_alt2, name_alt3, county, target, skybox } country on market.country_code ilike country.code { name as country_name, slug as country_slug }
- public primaryTable -> string (6) "market"
- public blocks -> array (2)
*DEPTH TOO GREAT*
- public distinct -> bool FALSE
- public distinctOn -> string (0) ""
- public sql -> object stdClass (3)
*DEPTH TOO GREAT*
- private $transactionCounter :: integer 0
- public $activeWhere :: string (10) "active = 1"
- public $errors :: array (0)
- public $reserved :: array (35)
*DEPTH TOO GREAT*
- 'primary_table' => string (6) "market"
- 'class' => string (18) "Crave\Model\market"
- 'lazyObjects' => array (1)
- 'neighborhoods' => array (4)
*DEPTH TOO GREAT*
- public $primary_markets :: array (17)
- integer 1
- integer 7
- integer 9
- integer 6
- integer 2
- integer 10
- integer 11
- integer 16
- integer 49
- integer 17
- integer 13
- integer 14
- integer 64
- integer 12
- integer 50
- integer 8
- integer 21
- protected $_internalErrors :: array (4)
- 'read_only' => array (1)
- 'message' => string (47) "Currently in "read only" mode. Try again later."
- 'required' => array (0)
- 'not_found' => array (0)
- 'database_error' => array (0)
- constant AQL :: string (671) " market { [market_nbhd]s as neighborhoods, city, code, count "
market { [market_nbhd]s as neighborhoods, city, code, country_code, latitude, longitude, name, on_website, slug, venue_search_nickname, state, state_full, market1, market2, market3, market4, name_alt1, name_alt2, name_alt3, county, target, skybox } country on market.country_code ilike country.code { name as country_name, slug as country_slug }
- constant FIELD_IS_REQUIRED :: string (15) "%s is required."
- constant LAZY_OBJECTS_MESSAGE :: string (48) "[This array of objects will be loaded on demand]"
- constant LAZY_OBJECT_MESSAGE :: string (38) "[This object will be loaded on demand]"
- constant VALIDATION_METHOD_PREFIX :: string (9) "validate_"
- constant ID_FIELD :: string (2) "id"
- constant FOREIGN_KEY_VALUE_TBD :: string (39) "[This value will be determined on save]"
- 'market_id' => integer 1
- 'market_slug' => string (7) "newyork"
- 'blog_id' => integer 4
- 'blog_slug' => string (10) "glamdamnit"
- 'primary_table' => NULL
- 'model' => NULL
- 'database_folder' => NULL
- 'p' => object Sky\Page (30)
- public uri -> string (27) "/newyork/glamdamnit/rss.xml"
- public urlpath -> string (19) "/newyork/glamdamnit"
- public incpath -> string (24) "pages/newyork/glamdamnit"
- public page_path -> string (47) "pages/_market.slug_/_blog.slug_/_blog.slug_.php"
- public queryfolders -> array (1)
- string (7) "rss.xml"
- public ide -> string (7) "rss.xml"
- public slug -> string (0) ""
- public title -> string (0) ""
- public favicon -> string (12) "/favicon.ico"
- public apple_touch_icon -> string (21) "/apple-touch-icon.png"
- public seo -> object Crave\Model\website_page (1)
- object (1)
- Static class properties (9)
- protected _data -> object stdClass (13)
- public end_mmdd -> NULL
- public nickname -> string (4) "old "
- public page_path -> string (47) "pages/_market.slug_/_blog.slug_/_blog.slug_.php"
- public start_mmdd -> string (4) "0627"
- public url -> NULL
- public website_id -> integer 1
- public website_page_id -> integer 163
- public id -> integer 163
- public domain -> string (11) "joonbug.com"
- public website_ide -> string (11) "FTf5apggq3J"
- public website_page_ide -> string (11) "uoUyVkBPQdC"
- public ide -> string (11) "uoUyVkBPQdC"
- public fields -> array (8)
- object Crave\Model\website_page_data (2)
*DEPTH TOO GREAT*
- object Crave\Model\website_page_data (2)
*DEPTH TOO GREAT*
- object Crave\Model\website_page_data (2)
*DEPTH TOO GREAT*
- object Crave\Model\website_page_data (2)
*DEPTH TOO GREAT*
- object Crave\Model\website_page_data (2)
*DEPTH TOO GREAT*
- object Crave\Model\website_page_data (2)
*DEPTH TOO GREAT*
- object Crave\Model\website_page_data (2)
*DEPTH TOO GREAT*
- object Crave\Model\website_page_data (2)
*DEPTH TOO GREAT*
- public $_meta :: array (9)
- 'requiredFields' => array (0)
- 'cachedLists' => array (0)
- 'readOnlyProperties' => array (0)
- 'readOnlyTables' => array (0)
- 'possibleErrors' => array (1)
- 'my_error_code' => array (2)
*DEPTH TOO GREAT*
- 'aql' => object Sky\AQL (6)
- object (6)
- Static class properties (4)
- public statement -> string (308) " website_page { end_mmdd, nickname, page_path, start_mmdd, u "
website_page { end_mmdd, nickname, page_path, start_mmdd, url, website_id, [website_page_data]s as fields } website { domain name as website_name, }
- public primaryTable -> string (12) "website_page"
- public blocks -> array (2)
*DEPTH TOO GREAT*
- public distinct -> bool FALSE
- public distinctOn -> string (0) ""
- public sql -> object stdClass (3)
*DEPTH TOO GREAT*
- private $transactionCounter :: integer 0
- public $activeWhere :: string (10) "active = 1"
- public $errors :: array (0)
- public $reserved :: array (35)
*DEPTH TOO GREAT*
- 'primary_table' => string (12) "website_page"
- 'class' => string (24) "Crave\Model\website_page"
- 'lazyObjects' => array (1)
- 'fields' => array (4)
*DEPTH TOO GREAT*
- protected $_internalErrors :: array (4)
- 'read_only' => array (1)
- 'message' => string (47) "Currently in "read only" mode. Try again later."
- 'required' => array (0)
- 'not_found' => array (0)
- 'database_error' => array (0)
- constant AQL :: string (308) " website_page { end_mmdd, nickname, page_path, start_mmdd, u "
website_page { end_mmdd, nickname, page_path, start_mmdd, url, website_id, [website_page_data]s as fields } website { domain name as website_name, }
- constant FIELD_IS_REQUIRED :: string (15) "%s is required."
- constant LAZY_OBJECTS_MESSAGE :: string (48) "[This array of objects will be loaded on demand]"
- constant LAZY_OBJECT_MESSAGE :: string (38) "[This object will be loaded on demand]"
- constant VALIDATION_METHOD_PREFIX :: string (9) "validate_"
- constant ID_FIELD :: string (2) "id"
- constant FOREIGN_KEY_VALUE_TBD :: string (39) "[This value will be determined on save]"
- public breadcrumb -> array (0)
- public vars -> array (7)
- 'market_id' => integer 1
- 'market_slug' => string (7) "newyork"
- 'blog_id' => integer 4
- 'blog_slug' => string (10) "glamdamnit"
- 'primary_table' => NULL
- 'model' => NULL
- 'database_folder' => NULL
- public css -> array (0)
- public js -> array (0)
- public script -> array (0)
- public script_files -> array (0)
- public template_css -> array (0)
- public template_js -> array (0)
- public html_attrs -> array (0)
- public head -> array (0)
- public templates -> array (0)
- public is_ajax_request -> bool FALSE
- protected cache_is_buffering -> array (0)
- protected css_added -> array (0)
- public querystring -> string (0) ""
- public sky_start_time -> float 1434895604.68
- public protocol -> string (4) "http"
- public website -> object stdClass (8)
- public website_id -> integer 1
- public ct_promoter_website_id -> integer 2333
- public ct_promoter_id -> integer 1
- public ct_promoter_website_ide -> string (11) "GR7zqahrsoz"
- public ct_promoter_ide -> string (11) "rquNesCME11"
- public website_name -> string (7) "Joonbug"
- public phone -> string (12) "800-111-1234"
- public site_criteria -> array (3)
- 'status' => string (1) "A"
- 'seller__ct_promoter_id' => integer 1
- 'ct_promoter_website_id' => integer 2333
- public market -> object Crave\Model\market (1)
- object (1)
- Static class properties (10)
- protected _data -> object stdClass (30)
- public city -> string (8) "New York"
- public code -> string (3) "NYC"
- public country_code -> string (2) "US"
- public latitude -> string (9) "40.735747"
- public longitude -> string (9) "-73.99056"
- public name -> string (8) "New York"
- public on_website -> integer 1
- public slug -> string (7) "newyork"
- public venue_search_nickname -> string (3) "NYC"
- public state -> string (2) "NY"
- public state_full -> string (8) "New York"
- public market1 -> string (8) "New York"
- public market2 -> string (3) "NYC"
- public market3 -> string (13) "New York City"
- public market4 -> string (2) "NY"
- public name_alt1 -> string (3) "NYC"
- public name_alt2 -> string (13) "New York City"
- public name_alt3 -> string (9) "Big Apple"
- public county -> string (9) "Manhattan"
- public target -> integer 1
- public skybox -> integer 1
- public market_id -> integer 1
- public id -> integer 1
- public country_name -> string (13) "United States"
- public country_slug -> string (2) "us"
- public country_id -> integer 213
- public market_ide -> string (11) "ra4eW4jJfYw"
- public ide -> string (11) "ra4eW4jJfYw"
- public country_ide -> string (11) "EfzEx1yFX5m"
- public neighborhoods -> string (48) "[This array of objects will be loaded on demand]"
- public $_meta :: array (5)
- 'requiredFields' => array (3)
- 'name' => string (4) "Name"
- 'latitude' => string (8) "Latitude"
- 'longitude' => string (9) "Longitude"
- 'aql' => object Sky\AQL (6)
- object (6)
- Static class properties (4)
- public statement -> string (671) " market { [market_nbhd]s as neighborhoods, city, code, count "
market { [market_nbhd]s as neighborhoods, city, code, country_code, latitude, longitude, name, on_website, slug, venue_search_nickname, state, state_full, market1, market2, market3, market4, name_alt1, name_alt2, name_alt3, county, target, skybox } country on market.country_code ilike country.code { name as country_name, slug as country_slug }
- public primaryTable -> string (6) "market"
- public blocks -> array (2)
*DEPTH TOO GREAT*
- public distinct -> bool FALSE
- public distinctOn -> string (0) ""
- public sql -> object stdClass (3)
*DEPTH TOO GREAT*
- private $transactionCounter :: integer 0
- public $activeWhere :: string (10) "active = 1"
- public $errors :: array (0)
- public $reserved :: array (35)
*DEPTH TOO GREAT*
- 'primary_table' => string (6) "market"
- 'class' => string (18) "Crave\Model\market"
- 'lazyObjects' => array (1)
- 'neighborhoods' => array (4)
*DEPTH TOO GREAT*
- public $primary_markets :: array (17)
- integer 1
- integer 7
- integer 9
- integer 6
- integer 2
- integer 10
- integer 11
- integer 16
- integer 49
- integer 17
- integer 13
- integer 14
- integer 64
- integer 12
- integer 50
- integer 8
- integer 21
- protected $_internalErrors :: array (4)
- 'read_only' => array (1)
- 'message' => string (47) "Currently in "read only" mode. Try again later."
- 'required' => array (0)
- 'not_found' => array (0)
- 'database_error' => array (0)
- constant AQL :: string (671) " market { [market_nbhd]s as neighborhoods, city, code, count "
market { [market_nbhd]s as neighborhoods, city, code, country_code, latitude, longitude, name, on_website, slug, venue_search_nickname, state, state_full, market1, market2, market3, market4, name_alt1, name_alt2, name_alt3, county, target, skybox } country on market.country_code ilike country.code { name as country_name, slug as country_slug }
- constant FIELD_IS_REQUIRED :: string (15) "%s is required."
- constant LAZY_OBJECTS_MESSAGE :: string (48) "[This array of objects will be loaded on demand]"
- constant LAZY_OBJECT_MESSAGE :: string (38) "[This object will be loaded on demand]"
- constant VALIDATION_METHOD_PREFIX :: string (9) "validate_"
- constant ID_FIELD :: string (2) "id"
- constant FOREIGN_KEY_VALUE_TBD :: string (39) "[This value will be determined on save]"
- 'website' => object stdClass (8)
- public website_id -> integer 1
- public ct_promoter_website_id -> integer 2333
- public ct_promoter_id -> integer 1
- public ct_promoter_website_ide -> string (11) "GR7zqahrsoz"
- public ct_promoter_ide -> string (11) "rquNesCME11"
- public website_name -> string (7) "Joonbug"
- public phone -> string (12) "800-111-1234"
- public site_criteria -> array (3)
- 'status' => string (1) "A"
- 'seller__ct_promoter_id' => integer 1
- 'ct_promoter_website_id' => integer 2333
- 'seo_cache_key' => string (88) "jb:seo_layer:/newyork/glamdamnit/rss.xml:pages/_market.slug_ "
jb:seo_layer:/newyork/glamdamnit/rss.xml:pages/_market.slug_/_blog.slug_/_blog.slug_.php
- 'seo' => object Crave\Model\website_page (1)
- object (1)
- Static class properties (9)
- protected _data -> object stdClass (13)
- public end_mmdd -> NULL
- public nickname -> string (4) "old "
- public page_path -> string (47) "pages/_market.slug_/_blog.slug_/_blog.slug_.php"
- public start_mmdd -> string (4) "0627"
- public url -> NULL
- public website_id -> integer 1
- public website_page_id -> integer 163
- public id -> integer 163
- public domain -> string (11) "joonbug.com"
- public website_ide -> string (11) "FTf5apggq3J"
- public website_page_ide -> string (11) "uoUyVkBPQdC"
- public ide -> string (11) "uoUyVkBPQdC"
- public fields -> array (8)
- object Crave\Model\website_page_data (2)
- object (2)
- Static class properties (9)
- public _parent -> object Crave\Model\website_page (1) *RECURSION*
- protected _data -> object stdClass (9)
*DEPTH TOO GREAT*
- public $_meta :: array (8)
*DEPTH TOO GREAT*
- protected $_internalErrors :: array (4)
*DEPTH TOO GREAT*
- constant AQL :: string (95) " website_page_data { website_page_id, draft, field, value } "
website_page_data { website_page_id,draft,field,value }
- constant FIELD_IS_REQUIRED :: string (15) "%s is required."
- constant LAZY_OBJECTS_MESSAGE :: string (48) "[This array of objects will be loaded on demand]"
- constant LAZY_OBJECT_MESSAGE :: string (38) "[This object will be loaded on demand]"
- constant VALIDATION_METHOD_PREFIX :: string (9) "validate_"
- constant ID_FIELD :: string (2) "id"
- constant FOREIGN_KEY_VALUE_TBD :: string (39) "[This value will be determined on save]"
- object Crave\Model\website_page_data (2)
- object (2)
- Static class properties (9)
- public _parent -> object Crave\Model\website_page (1) *RECURSION*
- protected _data -> object stdClass (9)
*DEPTH TOO GREAT*
- public $_meta :: array (8)
*DEPTH TOO GREAT*
- protected $_internalErrors :: array (4)
*DEPTH TOO GREAT*
- constant AQL :: string (95) " website_page_data { website_page_id, draft, field, value } "
website_page_data { website_page_id,draft,field,value }
- constant FIELD_IS_REQUIRED :: string (15) "%s is required."
- constant LAZY_OBJECTS_MESSAGE :: string (48) "[This array of objects will be loaded on demand]"
- constant LAZY_OBJECT_MESSAGE :: string (38) "[This object will be loaded on demand]"
- constant VALIDATION_METHOD_PREFIX :: string (9) "validate_"
- constant ID_FIELD :: string (2) "id"
- constant FOREIGN_KEY_VALUE_TBD :: string (39) "[This value will be determined on save]"
- object Crave\Model\website_page_data (2)
- object (2)
- Static class properties (9)
- public _parent -> object Crave\Model\website_page (1) *RECURSION*
- protected _data -> object stdClass (9)
*DEPTH TOO GREAT*
- public $_meta :: array (8)
*DEPTH TOO GREAT*
- protected $_internalErrors :: array (4)
*DEPTH TOO GREAT*
- constant AQL :: string (95) " website_page_data { website_page_id, draft, field, value } "
website_page_data { website_page_id,draft,field,value }
- constant FIELD_IS_REQUIRED :: string (15) "%s is required."
- constant LAZY_OBJECTS_MESSAGE :: string (48) "[This array of objects will be loaded on demand]"
- constant LAZY_OBJECT_MESSAGE :: string (38) "[This object will be loaded on demand]"
- constant VALIDATION_METHOD_PREFIX :: string (9) "validate_"
- constant ID_FIELD :: string (2) "id"
- constant FOREIGN_KEY_VALUE_TBD :: string (39) "[This value will be determined on save]"
- object Crave\Model\website_page_data (2)
- object (2)
- Static class properties (9)
- public _parent -> object Crave\Model\website_page (1) *RECURSION*
- protected _data -> object stdClass (9)
*DEPTH TOO GREAT*
- public $_meta :: array (8)
*DEPTH TOO GREAT*
- protected $_internalErrors :: array (4)
*DEPTH TOO GREAT*
- constant AQL :: string (95) " website_page_data { website_page_id, draft, field, value } "
website_page_data { website_page_id,draft,field,value }
- constant FIELD_IS_REQUIRED :: string (15) "%s is required."
- constant LAZY_OBJECTS_MESSAGE :: string (48) "[This array of objects will be loaded on demand]"
- constant LAZY_OBJECT_MESSAGE :: string (38) "[This object will be loaded on demand]"
- constant VALIDATION_METHOD_PREFIX :: string (9) "validate_"
- constant ID_FIELD :: string (2) "id"
- constant FOREIGN_KEY_VALUE_TBD :: string (39) "[This value will be determined on save]"
- object Crave\Model\website_page_data (2)
- object (2)
- Static class properties (9)
- public _parent -> object Crave\Model\website_page (1) *RECURSION*
- protected _data -> object stdClass (9)
*DEPTH TOO GREAT*
- public $_meta :: array (8)
*DEPTH TOO GREAT*
- protected $_internalErrors :: array (4)
*DEPTH TOO GREAT*
- constant AQL :: string (95) " website_page_data { website_page_id, draft, field, value } "
website_page_data { website_page_id,draft,field,value }
- constant FIELD_IS_REQUIRED :: string (15) "%s is required."
- constant LAZY_OBJECTS_MESSAGE :: string (48) "[This array of objects will be loaded on demand]"
- constant LAZY_OBJECT_MESSAGE :: string (38) "[This object will be loaded on demand]"
- constant VALIDATION_METHOD_PREFIX :: string (9) "validate_"
- constant ID_FIELD :: string (2) "id"
- constant FOREIGN_KEY_VALUE_TBD :: string (39) "[This value will be determined on save]"
- object Crave\Model\website_page_data (2)
- object (2)
- Static class properties (9)
- public _parent -> object Crave\Model\website_page (1) *RECURSION*
- protected _data -> object stdClass (9)
*DEPTH TOO GREAT*
- public $_meta :: array (8)
*DEPTH TOO GREAT*
- protected $_internalErrors :: array (4)
*DEPTH TOO GREAT*
- constant AQL :: string (95) " website_page_data { website_page_id, draft, field, value } "
website_page_data { website_page_id,draft,field,value }
- constant FIELD_IS_REQUIRED :: string (15) "%s is required."
- constant LAZY_OBJECTS_MESSAGE :: string (48) "[This array of objects will be loaded on demand]"
- constant LAZY_OBJECT_MESSAGE :: string (38) "[This object will be loaded on demand]"
- constant VALIDATION_METHOD_PREFIX :: string (9) "validate_"
- constant ID_FIELD :: string (2) "id"
- constant FOREIGN_KEY_VALUE_TBD :: string (39) "[This value will be determined on save]"
- object Crave\Model\website_page_data (2)
- object (2)
- Static class properties (9)
- public _parent -> object Crave\Model\website_page (1) *RECURSION*
- protected _data -> object stdClass (9)
*DEPTH TOO GREAT*
- public $_meta :: array (8)
*DEPTH TOO GREAT*
- protected $_internalErrors :: array (4)
*DEPTH TOO GREAT*
- constant AQL :: string (95) " website_page_data { website_page_id, draft, field, value } "
website_page_data { website_page_id,draft,field,value }
- constant FIELD_IS_REQUIRED :: string (15) "%s is required."
- constant LAZY_OBJECTS_MESSAGE :: string (48) "[This array of objects will be loaded on demand]"
- constant LAZY_OBJECT_MESSAGE :: string (38) "[This object will be loaded on demand]"
- constant VALIDATION_METHOD_PREFIX :: string (9) "validate_"
- constant ID_FIELD :: string (2) "id"
- constant FOREIGN_KEY_VALUE_TBD :: string (39) "[This value will be determined on save]"
- object Crave\Model\website_page_data (2)
- object (2)
- Static class properties (9)
- public _parent -> object Crave\Model\website_page (1) *RECURSION*
- protected _data -> object stdClass (9)
*DEPTH TOO GREAT*
- public $_meta :: array (8)
*DEPTH TOO GREAT*
- protected $_internalErrors :: array (4)
*DEPTH TOO GREAT*
- constant AQL :: string (95) " website_page_data { website_page_id, draft, field, value } "
website_page_data { website_page_id,draft,field,value }
- constant FIELD_IS_REQUIRED :: string (15) "%s is required."
- constant LAZY_OBJECTS_MESSAGE :: string (48) "[This array of objects will be loaded on demand]"
- constant LAZY_OBJECT_MESSAGE :: string (38) "[This object will be loaded on demand]"
- constant VALIDATION_METHOD_PREFIX :: string (9) "validate_"
- constant ID_FIELD :: string (2) "id"
- constant FOREIGN_KEY_VALUE_TBD :: string (39) "[This value will be determined on save]"
- public $_meta :: array (9)
- 'requiredFields' => array (0)
- 'cachedLists' => array (0)
- 'readOnlyProperties' => array (0)
- 'readOnlyTables' => array (0)
- 'possibleErrors' => array (1)
- 'my_error_code' => array (2)
- 'message' => string (16) "My Error Message"
- 'fields' => array (1)
*DEPTH TOO GREAT*
- 'aql' => object Sky\AQL (6)
- object (6)
- Static class properties (4)
- public statement -> string (308) " website_page { end_mmdd, nickname, page_path, start_mmdd, u "
website_page { end_mmdd, nickname, page_path, start_mmdd, url, website_id, [website_page_data]s as fields } website { domain name as website_name, }
- public primaryTable -> string (12) "website_page"
- public blocks -> array (2)
- object Sky\AQL\Block (14)
*DEPTH TOO GREAT*
- object Sky\AQL\Block (13)
*DEPTH TOO GREAT*
- public distinct -> bool FALSE
- public distinctOn -> string (0) ""
- public sql -> object stdClass (3)
- public query -> string (381) "SELECT website_page.end_mmdd, website_page.nickname, website "
SELECT website_page.end_mmdd,website_page.nickname,website_page.page_path,website_page.start_mmdd,website_page.url,website_page.website_id,website_page.id AS website_page_id,website_page.id,website.domainFROM website_pageLEFT JOIN website ON website_page.website_id = website.id AND website.active = 1WHERE website_page.active = 1AND website_page.id = 163
- public count -> string (183) "SELECT count(*) as count FROM website_page LEFT JOIN website "
SELECT count(*) as countFROM website_pageLEFT JOIN website ON website_page.website_id = website.id AND website.active = 1WHERE website_page.active = 1AND website_page.id = 163
- public list -> string (324) "SELECT id, id AS website_page_id FROM ( SELECT DISTINCT ON ( "
SELECT id, id AS website_page_idFROM (SELECT DISTINCT ON (q.id) id, rowFROM (SELECTwebsite_page.id,row_number() OVER() as rowFROM website_pageLEFT JOIN website ON website_page.website_id = website.id AND website.active = 1WHERE website_page.active = 1AND website_page.id = 163) as q) as finORDER BY row
- private $transactionCounter :: integer 0
- public $activeWhere :: string (10) "active = 1"
- public $errors :: array (0)
- public $reserved :: array (35)
- string (4) "date"
- string (4) "case"
- string (4) "when"
- string (3) "end"
- string (6) "length"
- string (5) "ilike"
- string (4) "like"
- string (8) "distinct"
- string (6) "select"
- string (5) "where"
- string (4) "from"
- string (4) "then"
- string (4) "else"
- string (5) "upper"
- string (5) "lower"
- string (3) "and"
- string (2) "or"
- string (2) "is"
- string (4) "null"
- string (2) "in"
- string (3) "not"
- string (4) "true"
- string (5) "false"
- string (5) "now()"
- string (7) "to_date"
- string (3) "asc"
- string (4) "desc"
- string (8) "interval"
- string (4) "trim"
- string (7) "to_char"
- string (11) "date_format"
- string (8) "random()"
- string (7) "between"
- string (7) "extract"
- string (3) "dow"
- 'primary_table' => string (12) "website_page"
- 'class' => string (24) "Crave\Model\website_page"
- 'lazyObjects' => array (1)
- 'fields' => array (4)
- 'model' => string (17) "website_page_data"
- 'fk' => NULL
- 'type' => string (4) "many"
- 'alias' => string (6) "fields"
- protected $_internalErrors :: array (4)
- 'read_only' => array (1)
- 'message' => string (47) "Currently in "read only" mode. Try again later."
- 'required' => array (0)
- 'not_found' => array (0)
- 'database_error' => array (0)
- constant AQL :: string (308) " website_page { end_mmdd, nickname, page_path, start_mmdd, u "
website_page { end_mmdd, nickname, page_path, start_mmdd, url, website_id, [website_page_data]s as fields } website { domain name as website_name, }
- constant FIELD_IS_REQUIRED :: string (15) "%s is required."
- constant LAZY_OBJECTS_MESSAGE :: string (48) "[This array of objects will be loaded on demand]"
- constant LAZY_OBJECT_MESSAGE :: string (38) "[This object will be loaded on demand]"
- constant VALIDATION_METHOD_PREFIX :: string (9) "validate_"
- constant ID_FIELD :: string (2) "id"
- constant FOREIGN_KEY_VALUE_TBD :: string (39) "[This value will be determined on save]"
- 'r' => integer 84
- 9 /home/joonbug3/codebases/skyphp/sky.php line 135Sky\Page->run()
128
129 # $access_groups to global (for authenticate hook)
130 # authentication hook
131 $access_groups = $router->settings['access_groups'];
132 include 'includes/hooks/login-authenticate.php';
133
134 # run the page
135 $p->run();
136
137 # output the error if the master is down
138 if ($db_host && !$dbw && !$p->is_ajax_request) {
139 echo $master_db_connect_error;
140 } else {
141 // no problems with the master db
142 // make sure our php-cron-daemon is running only on one host
- 10 <ROOT>/index.php line 18include(0)
No comments:
Post a Comment