SproutCMS

/modules/Demo/Controllers/Admin/DemoItemAdminController.php   Highlighted file source

Line 23: use Sprout\Helpers\Pdb;
Line 149: $res = Pdb::q($q, [$_GET['id']], 'arr');
Line 156: $res = Pdb::q($q, [Pdb::likeEscape($_GET['term'])], 'arr');
Line 171: $res = Pdb::q($q, [Pdb::likeEscape($_GET['term'])], 'arr');

/modules/HomePage/Controllers/Admin/HomePageAdminController.php   Highlighted file source

Line 18: use Sprout\Helpers\Pdb;
Line 46: return Pdb::q("SELECT name FROM ~subsites WHERE id = ?", [$row['subsite_id']], 'val');

/modules/HomePage/Helpers/SitemapGenHome.php   Highlighted file source

Line 16: use Sprout\Helpers\Pdb;
Line 33: $row = Pdb::q($q, [SubsiteSelector::$subsite_id], 'row');

/modules/Welcome/Controllers/WelcomeController.php   Highlighted file source

Line 22: use karmabunny\pdb\Exceptions\QueryException;
Line 33: use Sprout\Helpers\Pdb;
Line 142: Pdb::getConnection();
Line 182: Pdb::query($q, [], 'null');
Line 203: $num_pages = Pdb::query($q, [], 'val');
Line 631: $num_pages = Pdb::query("SELECT COUNT(*) FROM ~pages LIMIT 1", [], 'val');
Line 632: $num_files = Pdb::query("SELECT COUNT(*) FROM ~files LIMIT 1", [], 'val');
Line 658: Pdb::query("DELETE FROM ~page_widgets", [], 'null');
Line 659: Pdb::query("DELETE FROM ~page_revisions", [], 'null');
Line 660: Pdb::query("DELETE FROM ~pages", [], 'null');
Line 661: Pdb::query("DELETE FROM ~homepage_banners", [], 'null');
Line 662: Pdb::query("DELETE FROM ~homepage_promos", [], 'null');
Line 663: Pdb::query("DELETE FROM ~files", [], 'null');
Line 664: Pdb::query("DELETE FROM ~files_cat_join", [], 'null');
Line 665: Pdb::query("DELETE FROM ~files_cat_list", [], 'null');
Line 679: $data['date_added'] = Pdb::now();
Line 680: $data['date_modified'] = Pdb::now();
Line 681: $cat_id = Pdb::insert('files_cat_list', $data);
Line 696: $data['date_added'] = Pdb::now();
Line 697: $data['date_modified'] = Pdb::now();
Line 698: $data['date_file_modified'] = Pdb::now();
Line 700: Pdb::insert('files', $data);
Line 705: Pdb::insert('files_cat_join', $data);
Line 745: $data['date_added'] = Pdb::now();
Line 746: $data['date_modified'] = Pdb::now();
Line 747: Pdb::insert('pages', $data);
Line 756: $data['date_added'] = Pdb::now();
Line 757: $data['date_modified'] = Pdb::now();
Line 758: $revision_id = Pdb::insert('page_revisions', $data);
Line 767: Pdb::insert('page_widgets', $data);
Line 780: Pdb::update('homepages', $data, ['id' => 1]);
Line 790: Pdb::insert('homepage_banners', $data);
Line 800: Pdb::insert('homepage_promos', $data);
Line 811: Pdb::insert('homepage_promos', $data);
Line 821: Pdb::insert('homepage_promos', $data);

/sprout/Controllers/Admin/ActionLogAdminController.php   Highlighted file source

Line 19: use karmabunny\pdb\Exceptions\RowMissingException;
Line 28: use Sprout\Helpers\Pdb;
Line 66: $types = Pdb::extractEnumArr($this->table_name, 'type');
Line 120: $row = Pdb::q($q, [$view->data['record_table'], $item_id], 'row');
Line 133: $row = Pdb::q($q, [$view->data['record_table'], $item_id], 'row');
Line 155: $res = Pdb::q($q, [], 'pdo');
Line 177: $res = Pdb::query($q, [], 'arr');
Line 206: $affected = Pdb::q($q, [$date], 'count');
Line 210: $del_st = Pdb::q($q, [], 'prep');
Line 216: $res = Pdb::q($q, [$date], 'pdo');
Line 224: Pdb::execute($del_st, [$row['id']], 'null');

/sprout/Controllers/Admin/DocumentTypeAdminController.php   Highlighted file source

Line 18: use Sprout\Helpers\Pdb;
Line 87: Pdb::transact();
Line 91: Pdb::commit();

/sprout/Controllers/Admin/ExtraPageAdminController.php   Highlighted file source

Line 18: use Sprout\Helpers\Pdb;
Line 78: $res = Pdb::query($q, [$_SESSION['admin']['active_subsite']], 'pdo');
Line 140: $extant_types = Pdb::q($q, [$_SESSION['admin']['active_subsite']], 'col');
Line 173: Pdb::transact();
Line 180: $update_fields['date_added'] = Pdb::now();
Line 181: $update_fields['date_modified'] = Pdb::now();
Line 183: $item_id = Pdb::insert('extra_pages', $update_fields);
Line 189: Pdb::commit();
Line 235: Pdb::transact();
Line 241: $update_fields['date_modified'] = Pdb::now();
Line 245: Pdb::update('extra_pages', $update_fields, ['id' => $item_id]);
Line 251: Pdb::commit();

/sprout/Controllers/Admin/HasCategoriesAdminController.php   Highlighted file source

Line 19: use karmabunny\pdb\Exceptions\RowMissingException;
Line 31: use Sprout\Helpers\Pdb;
Line 79: $records = Pdb::lookup("{$this->table_name}_cat_list");
Line 168: $res = Pdb::q($q, [], 'arr');
Line 178: $uncat = (int) Pdb::q($q, [], 'val');
Line 282: $category = Pdb::q($q, [$_GET['_category_id']], 'row');
Line 295: Pdb::validateIdentifier($_GET['order']);
Line 325: $items = Pdb::q($q, $params, 'arr');
Line 328: $total_row_count = Pdb::q("SELECT FOUND_ROWS()", [], 'val');
Line 465: $view->cats = Pdb::q($q, [], 'map');
Line 526: $cats = Pdb::q($q, [], 'map');
Line 575: $item = Pdb::q($q, [$id], 'row');
Line 590: $cats = Pdb::q($q, [], 'map');
Line 597: $data['categories'] = Pdb::q($q, [$id], 'col');
Line 656: $data = $item = Pdb::q($q, [$id], 'row');
Line 666: $cats = Pdb::q($q, [], 'map');
Line 693: $data['categories'] = Pdb::q($q, [$id], 'col');
Line 744: $extant_transaction = Pdb::inTransaction();
Line 745: if (!$extant_transaction) Pdb::transact();
Line 754: Pdb::delete($cat_table, [$record_col => $item_id]);
Line 757: if (!$extant_transaction) Pdb::commit();
Line 784: $res = Pdb::q($q, [$item_id], 'arr');
Line 806: Pdb::insert($table_name, $update_fields);
Line 816: Pdb::q($q, [$item_id, $cat_id], 'count');
Line 853: $view->cats = Pdb::q($q, [], 'map');
Line 857: $where = Pdb::buildClause([['item.id', 'IN', $_GET['ids']]], $params);
Line 859: $items = Pdb::q($q, $params, 'arr');
Line 893: Pdb::transact();
Line 915: Pdb::commit();

/sprout/Controllers/Admin/ManagedAdminController.php   Highlighted file source

Line 20: use karmabunny\pdb\Exceptions\ConstraintQueryException;
Line 22: use karmabunny\pdb\Exceptions\RowMissingException;
Line 35: use Sprout\Helpers\Pdb;
Line 330: * [1] (array) Params to use in a Pdb::q call which uses the generated WHERE clauses
Line 365: $where[] = Pdb::buildClause($conditions, $params);
Line 395: $items = Pdb::q($q, $params, 'arr');
Line 462: $res = Pdb::query($q, $params, 'pdo');
Line 508: $res = Pdb::q($q, [], 'arr-num');
Line 628: Pdb::transact();
Line 648: Pdb::validateIdentifier($match_db);
Line 653: $existing_record = Pdb::q($q, [$line[$match_csv]], 'row');
Line 690: $field_values['date_added'] = Pdb::now();
Line 691: $field_values['date_modified'] = Pdb::now();
Line 692: $record_id = Pdb::insert($this->table_name, $field_values);
Line 706: $field_values['date_modified'] = Pdb::now();
Line 707: Pdb::update($this->table_name, $field_values, ['id' => $existing_record['id']]);
Line 719: $field_values['date_added'] = Pdb::now();
Line 720: $field_values['date_modified'] = Pdb::now();
Line 721: $record_id = Pdb::insert($this->table_name, $field_values);
Line 733: Pdb::commit();
Line 964: Pdb::validateIdentifier($_GET['order']);
Line 983: $items = Pdb::q($q, $params, 'arr');
Line 987: $total_row_count = Pdb::q($q, [], 'val');
Line 1326: $data['date_added'] = Pdb::now();
Line 1328: $data['date_modified'] = Pdb::now();
Line 1355: return Pdb::get($this->table_name, $id);
Line 1834: if (Pdb::inTransaction()) {
Line 1835: Pdb::rollback();
Line 1901: $records = Pdb::query($q, [$_GET['id']], 'arr');
Line 1906: $records = Pdb::query($q, [Pdb::likeEscape($_GET['term'])], 'arr');
Line 1931: $where = Pdb::buildClause($conditions, $params);
Line 1934: $records = Pdb::query($q, $params, 'arr');
Line 1939: $records = Pdb::query($q, [Pdb::likeEscape($_GET['term'])], 'arr');

/sprout/Controllers/Admin/OperatorAdminController.php   Highlighted file source

Line 24: use Sprout\Helpers\Pdb;
Line 232: Pdb::transact();
Line 240: $update_fields['date_added'] = Pdb::now();
Line 241: $update_fields['date_modified'] = Pdb::now();
Line 243: $item_id = Pdb::insert('operators', $update_fields);
Line 253: Pdb::commit();
Line 361: Pdb::transact();
Line 368: $update_fields['date_modified'] = Pdb::now();
Line 372: Pdb::update('operators', $update_fields, ['id' => $item_id]);
Line 385: Pdb::commit();

/sprout/Controllers/Admin/PageAdminController.php   Highlighted file source

Line 22: use karmabunny\pdb\Exceptions\QueryException;
Line 23: use karmabunny\pdb\Exceptions\RowMissingException;
Line 53: use Sprout\Helpers\Pdb;
Line 123: $query_params[] = Pdb::likeEscape($val);
Line 129: $query_params[] = Pdb::likeEscape($val);
Line 164: $view->home_page_id = Pdb::q($q, [$_SESSION['admin']['active_subsite']], 'val');
Line 336: if (!in_array($_POST['type'], Pdb::extractEnumArr('page_revisions', 'type'))) {
Line 344: Pdb::transact();
Line 358: $update_fields['date_added'] = Pdb::now();
Line 359: $update_fields['date_modified'] = Pdb::now();
Line 375: $page_id = Pdb::insert('pages', $update_fields);
Line 401: $update_fields['date_added'] = Pdb::now();
Line 402: $update_fields['date_modified'] = Pdb::now();
Line 403: Pdb::insert('page_revisions', $update_fields);
Line 416: Pdb::insert('page_admin_permissions', $update_fields);
Line 432: Pdb::insert('page_user_permissions', $update_fields);
Line 438: Pdb::commit();
Line 688: Pdb::transact();
Line 694: $update_fields['date_added'] = Pdb::now();
Line 695: $update_fields['date_modified'] = Pdb::now();
Line 696: $update_fields['date_file_modified'] = Pdb::now();
Line 699: $file_id = Pdb::insert('files', $update_fields);
Line 705: Pdb::update('files', $update_fields, ['id' => $file_id]);
Line 715: Pdb::commit();
Line 768: Pdb::transact();
Line 774: Pdb::commit();
Line 799: $update_fields['date_added'] = Pdb::now();
Line 800: $update_fields['date_modified'] = Pdb::now();
Line 801: $page_id = Pdb::insert('pages', $update_fields);
Line 812: $update_fields['date_added'] = Pdb::now();
Line 813: $update_fields['date_modified'] = Pdb::now();
Line 814: $rev_id = Pdb::insert('page_revisions', $update_fields);
Line 827: Pdb::insert('page_widgets', $update_fields);
Line 859: $approval_admins = Pdb::q($q, [$user_id], 'map');
Line 899: $subsite = Pdb::q($q, [$_SESSION['admin']['active_subsite']], 'row');
Line 907: $page = Pdb::q($q, [$id], 'row');
Line 926: $revs = Pdb::q($q, [$id], 'arr');
Line 978: if (in_array(@$_GET['type'], Pdb::extractEnumArr('page_revisions', 'type'))) {
Line 1005: $wids = Pdb::q($q, [$sel_rev['id']], 'arr');
Line 1070: $history = Pdb::q($q, [$id], 'arr');
Line 1187: $rev = Pdb::get('page_revisions', $id);
Line 1284: $orig_page = Pdb::q($q, [$rev_id, $page_id], 'row');
Line 1288: if (!in_array($page_type, Pdb::extractEnumArr('page_revisions', 'type'))) {
Line 1354: $old_widgets = Pdb::query($q, [$rev_id], 'arr');
Line 1372: $orig_rev = Pdb::q($q, [$rev_id], 'row');
Line 1465: $approval_operator = Pdb::query($q, [(int) $_POST['approval_operator_id']], 'row');
Line 1520: Pdb::transact();
Line 1524: $update_fields['date_modified'] = Pdb::now();
Line 1580: Pdb::update('pages', $update_fields, ['id' => $page_id]);
Line 1593: $update_fields['date_modified'] = Pdb::now();
Line 1605: Pdb::update('page_revisions', $update_fields, ['page_id' => $page_id, 'id' => $rev_id]);
Line 1614: $update_fields['date_added'] = Pdb::now();
Line 1616: $rev_id = Pdb::insert('page_revisions', $update_fields);
Line 1628: Pdb::delete('page_widgets', ['page_revision_id' => $rev_id]);
Line 1633: Pdb::insert('page_widgets', $update_fields);
Line 1642: Pdb::update('page_revisions', $update_fields, ['page_id' => $page_id, 'id' => $rev_id]);
Line 1668: Pdb::delete('page_admin_permissions', ['item_id' => $page_id]);
Line 1680: Pdb::insert('page_admin_permissions', $update_fields);
Line 1687: Pdb::delete('page_user_permissions', ['item_id' => $page_id]);
Line 1699: Pdb::insert('page_user_permissions', $update_fields);
Line 1706: Pdb::delete('page_attributes', ['page_id' => $page_id]);
Line 1717: Pdb::insert('page_attributes', $update_fields);
Line 1753: $res = Pdb::q($q, [$email_sql], 'pdo');
Line 1776: Pdb::commit();
Line 1848: $update_data['date_modified'] = Pdb::now();
Line 1855: Pdb::update('menu_groups', $update_data, $conditions);
Line 1874: Pdb::insert('menu_extras', $update_data);
Line 1878: Pdb::update('menu_extras', $update_data, array('page_id' => $page_id));
Line 1904: $update_fields['date_added'] = Pdb::now();
Line 1906: $res = Pdb::insert('page_history_items', $update_fields);
Line 1927: $view->page = Pdb::q($q, [$id], 'row');
Line 1999: $view->page = Pdb::q($q, ['live', $id], 'row');
Line 2012: $res = Pdb::q($q, ['live', Pdb::likeEscape($url)], 'pdo');
Line 2081: $res = Pdb::q($q, [$_SESSION['admin']['active_subsite']], 'arr');
Line 2102: $res = Pdb::q($q, ['need_approval', $_SESSION['admin']['active_subsite']], 'arr');
Line 2151: Pdb::transact();
Line 2160: $res = Pdb::q($q, ['live'], 'pdo');
Line 2179: Pdb::rollback();
Line 2187: Pdb::commit();
Line 2324: $children = Pdb::q($q, [$_SESSION['admin']['active_subsite']], 'arr');
Line 2353: $item = Pdb::q($q, [$item_id], 'row');
Line 2362: $max = Pdb::q($q, [$item['subsite_id'], $item['parent_id']], 'val');
Line 2368: Pdb::q($q, [$max + 1, $item_id], 'count');
Line 2380: Pdb::transact();
Line 2386: $res = Pdb::q($q, ['auto_launch'], 'arr');
Line 2392: Pdb::update('page_revisions', ['status' => 'live'], ['id' => $row['id']]);
Line 2401: Pdb::update('page_revisions', ['status' => 'old'], $where);
Line 2404: Pdb::commit();
Line 2423: Pdb::transact();
Line 2432: $res = Pdb::q($q, [], 'arr');
Line 2438: Pdb::update('pages', ['active' => 0], ['id' => $row['id']]);
Line 2443: Pdb::commit();
Line 2589: $res = Pdb::query($q, [$_SESSION['admin']['active_subsite']], 'arr');
Line 2645: $res = Pdb::q($q, [$resend_interval, $default_max_age, $default_max_age], 'map-arr');
Line 2720: $where = Pdb::buildClause($conds, $params);
Line 2722: $count = Pdb::q("UPDATE ~pages SET stale_reminder_sent = ? WHERE {$where}", $params, 'count');

/sprout/Controllers/Admin/SubsiteAdminController.php   Highlighted file source

Line 19: use Sprout\Helpers\Pdb;
Line 80: $view->subsites = Pdb::lookup('subsites', ['content_id' => 0]);
Line 107: Pdb::transact();
Line 120: $update_fields['date_added'] = Pdb::now();
Line 121: $update_fields['date_modified'] = Pdb::now();
Line 122: $item_id = Pdb::insert('subsites', $update_fields);
Line 129: $update_fields['date_added'] = Pdb::now();
Line 130: $update_fields['date_modified'] = Pdb::now();
Line 131: Pdb::insert('homepages', $update_fields);
Line 133: Pdb::commit();
Line 144: $view->subsites = Pdb::lookup('subsites', ['content_id' => 0, ['id', '!=', $item_id]]);
Line 174: $res = Pdb::transact();
Line 187: $update_fields['date_modified'] = Pdb::now();
Line 191: Pdb::update('subsites', $update_fields, ['id' => $item_id]);
Line 196: Pdb::commit();
Line 211: $count = Pdb::q($q, [], 'val');
Line 230: $count = Pdb::q($q, [], 'val');

/sprout/Controllers/Admin/WorkerJobAdminController.php   Highlighted file source

Line 23: use Sprout\Helpers\Pdb;
Line 174: $row = Pdb::q($q, [$job_id], 'row');

/sprout/Controllers/AdminController.php   Highlighted file source

Line 27: use karmabunny\pdb\Exceptions\ConstraintQueryException;
Line 28: use karmabunny\pdb\Exceptions\QueryException;
Line 29: use karmabunny\pdb\Exceptions\RowMissingException;
Line 46: use Sprout\Helpers\Pdb;
Line 240: $tfa_method = Pdb::query($q, [$_SESSION['admin']['tfa_id']], 'val');
Line 279: $operator = Pdb::query($q, [$_SESSION['admin']['tfa_id']], 'row');
Line 426: Pdb::update(
Line 885: $res = Pdb::q($q, $params, 'col');
Line 981: $access = Pdb::q($q, [$ctlr->getControllerName(), $item_id], 'arr');
Line 1004: $where = Pdb::buildClause($conds, $params);
Line 1010: $cat_list = Pdb::q($q, $params, 'map');
Line 1136: $subsites = Pdb::lookup('subsites');
Line 1315: $subsites = Pdb::lookup('subsites');
Line 1678: Pdb::transact();
Line 1683: Pdb::q('SET foreign_key_checks = 0', [], 'count');
Line 1684: $id = Pdb::insert($ctlr->getTableName(), array('date_added' => Pdb::now()));
Line 1700: Pdb::q('SET foreign_key_checks = 1', [], 'count');
Line 1717: Pdb::commit();
Line 1825: Pdb::transact();
Line 1849: Pdb::commit();
Line 2141: $records = Pdb::q($q, [$log_id], 'map-arr');
Line 2151: $q .= Pdb::buildClause([['parent_id', 'IN', array_keys($new)]], $params);
Line 2152: $new = Pdb::q($q, $params, 'map-arr');
Line 2159: Pdb::transact();
Line 2161: Pdb::validateIdentifier($row['record_table']);
Line 2165: Pdb::validateIdentifier($field);
Line 2175: Pdb::q($q, $data, 'null');
Line 2177: Pdb::rollback();
Line 2183: $data = ['restored_date' => Pdb::now(), 'restored_operator' => @$op['name']];
Line 2184: Pdb::update('history_items', $data, ['id' => $log_id]);
Line 2185: Pdb::commit();
Line 2234: $tbl_prefix = Pdb::prefix();
Line 2238: $db_tables = Pdb::query($q, [], 'pdo');
Line 2251: $db_cols = Pdb::query($q, [], 'pdo');
Line 2261: Pdb::transact();
Line 2283: $res = Pdb::q($q, [], 'arr');
Line 2287: Pdb::update($tbl_no_prefix, ['active' => 1], ['id' => $row['id']]);
Line 2298: $res = Pdb::q($q, [], 'arr');
Line 2302: Pdb::update($tbl_no_prefix, ['active' => 0], ['id' => $row['id']]);
Line 2309: Pdb::commit();

/sprout/Controllers/ContentSubscribeController.php   Highlighted file source

Line 19: use karmabunny\pdb\Exceptions\RowMissingException;
Line 25: use Sprout\Helpers\Pdb;
Line 61: $email = Pdb::q($q, [$id, $code], 'val');
Line 73: $res = Pdb::q($q, [$code, $email], 'arr');
Line 118: $email = Pdb::q($q, [$id, $code], 'row');
Line 135: $ids = Pdb::q($q, [$code, $email], 'col');
Line 141: Pdb::delete('content_subscriptions', ['id' => $id]);
Line 159: $subsites = Pdb::query($q, [], 'arr');
Line 177: $res = Pdb::q($q, [$subsite['id']], 'pdo');
Line 323: $res = Pdb::q($q, [], 'arr');
Line 344: Pdb::delete('content_subscriptions', ['handler_class' => $row['handler_class']]);

/sprout/Controllers/DbToolsController.php   Highlighted file source

Line 28: use karmabunny\pdb\Exceptions\QueryException;
Line 29: use karmabunny\pdb\Exceptions\RowMissingException;
Line 56: use Sprout\Helpers\Pdb;
Line 250: $row = Pdb::q("SELECT NOW() AS now, @@session.time_zone AS tz", [], 'row');
Line 262: $subsites = Pdb::query($q, [], 'arr');
Line 344: $num += (int) Pdb::query("SELECT COUNT(*) FROM ~operators", [], 'val');
Line 345: $num += (int) Pdb::query("SELECT COUNT(*) FROM ~pages", [], 'val');
Line 346: $num += (int) Pdb::query("SELECT COUNT(*) FROM ~subsites", [], 'val');
Line 434: $res = Pdb::query($q, [], 'pdo');
Line 440: $res = Pdb::query($q, [], 'pdo');
Line 454: $res = Pdb::query($q, $params, 'pdo');
Line 597: Pdb::query("SET profiling=1", [], 'count');
Line 600: $bind_subset = Pdb::getBindSubset($q, $binds);
Line 602: $res = Pdb::query($q, $bind_subset, 'pdo');
Line 614: $deps = Pdb::getDependentKeys($matches[1]);
Line 631: Pdb::query("SET profiling=0", [], 'count');
Line 646: $res = Pdb::query($q, [], 'pdo');
Line 669: $res = Pdb::query($q, [], 'arr');
Line 673: $res2 = Pdb::query($q, [], 'pdo');
Line 689: $res = Pdb::query('SHOW TABLES', [], 'col');
Line 692: $tables[] = preg_replace('/^' . preg_quote(Pdb::prefix()) . '/', '~', $row);
Line 714: $rows = Pdb::q($_POST['sql'], [], 'pdo');
Line 733: Pdb::validateIdentifier($table);
Line 740: $fk_defs = Pdb::getForeignKeys($table);
Line 746: $raw_res = Pdb::q("SHOW FULL COLUMNS FROM ~{$table}", [], 'pdo');
Line 910: Pdb::q("SET FOREIGN_KEY_CHECKS=0", [], 'null');
Line 918: Pdb::q($q, [], 'count');
Line 935: Pdb::q("SET FOREIGN_KEY_CHECKS=1", [], 'null');
Line 1049: $db_tables = Pdb::q($q, [], 'arr');
Line 1082: $prefix = Pdb::prefix();
Line 2069: $items = '{"func": "Pdb::extractEnumArr", "args": ["' . Enc::js($t) . '", "' . Enc::js($f) . '"]}';
Line 2072: $items = '{"func": "Pdb::extractEnumArr", "args": ["' . Enc::js($t) . '", "' . Enc::js($f) . '"]}';
Line 2078: $items = '{"func": "Pdb::lookup", "args": ["' . Enc::js($target_table) . '"]}';
Line 2267: $conditions[] = ['class_name', '!=', 'karmabunny\pdb\Exceptions\RowMissingException'];
Line 2279: $where = Pdb::buildClause($conditions, $binds);
Line 2285: $res = Pdb::query($q, $binds, 'pdo');
Line 2322: $log = Pdb::get('exception_log', $_GET['id']);
Line 2450: $subsite_id = Pdb::query($q, [$skin], 'val');
Line 2871: $view->subsites = Pdb::lookup('subsites');

/sprout/Controllers/MultiStepFormController.php   Highlighted file source

Line 20: use karmabunny\pdb\Exceptions\QueryException;
Line 22: use Sprout\Helpers\Pdb;
Line 286: * e.g. ['members' => ['date_added' => Pdb::now(), ...]]
Line 324: $insert_data['date_added'] = Pdb::now();
Line 325: $insert_data['date_modified'] = Pdb::now();
Line 327: Pdb::transact();
Line 328: $id = Pdb::insert($table, $insert_data);
Line 344: Pdb::insert($sub_name, $insert_data);
Line 347: Pdb::commit();

/sprout/Controllers/Tinymce4Controller.php   Highlighted file source

Line 26: use Sprout\Helpers\Pdb;
Line 104: $res = Pdb::q($q, [FileConstants::TYPE_IMAGE], 'pdo');
Line 140: $res = Pdb::q($q, [$category_id, FileConstants::TYPE_IMAGE], 'pdo');
Line 166: $safe_key = Pdb::likeEscape($key);
Line 174: $res = Pdb::q($q, [FileConstants::TYPE_IMAGE, $safe_key, $safe_key], 'pdo');
Line 205: $row = Pdb::q($q, [$file_id], 'row');
Line 394: $res = Pdb::q($q, [FileConstants::TYPE_VIDEO], 'pdo');
Line 431: $res = Pdb::q($q, [FileConstants::TYPE_VIDEO, $category_id], 'pdo');
Line 457: $safe_key = Pdb::likeEscape($key);
Line 465: $res = Pdb::q($q, [FileConstants::TYPE_VIDEO, $safe_key, $safe_key], 'pdo');
Line 513: $view->cats = Pdb::lookup($cat_table);
Line 548: $categories = Pdb::q($q, [FileConstants::TYPE_IMAGE], 'arr');

/sprout/core/Kohana.php   Highlighted file source

Line 14: use karmabunny\pdb\Exceptions\QueryException;
Line 15: use karmabunny\pdb\Exceptions\RowMissingException;
Line 19: use Sprout\Helpers\Pdb;
Line 680: $conn = Pdb::getConnection();
Line 684: $table = Pdb::prefix() . 'exception_log';
Line 710: 'date' => Pdb::now(),
Line 722: $delete->execute([Pdb::now()]);

/sprout/Helpers/AdminAuth.php   Highlighted file source

Line 20: use karmabunny\pdb\Exceptions\QueryException;
Line 85: $admin = Pdb::q($q, [Pdb::likeEscape($username)], 'row');
Line 95: $ip_lists = Pdb::q($q, [$admin['id']], 'col');
Line 155: $op = Pdb::q($q, [$operator_id], 'row');
Line 239: $max_op_id = (int) Pdb::q($q, [], 'val');
Line 306: Pdb::update('operators', $data, ['id' => $operator_id]);
Line 350: $data['date_added'] = Pdb::now();
Line 351: $data['date_modified'] = Pdb::now();
Line 354: Pdb::insert('login_attempts', $data);
Line 406: return Pdb::q($q, [$_SESSION[self::KEY]['login_id']], 'row');
Line 446: $hascat = Pdb::q($q, [$_SESSION[self::KEY]['login_id'], $category_id], 'arr');
Line 471: return Pdb::q($q, [$_SESSION[self::KEY]['login_id']], 'col');
Line 481: return Pdb::q($q, [], 'map');
Line 522: $q = Pdb::prepare("SELECT id FROM ~operators_cat_list WHERE access_operators = 1 ORDER BY id LIMIT 1");
Line 524: return Pdb::execute($q, [], 'val');

/sprout/Helpers/AdminPerms.php   Highlighted file source

Line 18: use karmabunny\pdb\Exceptions\QueryException;
Line 19: use karmabunny\pdb\Exceptions\RowMissingException;
Line 58: WHERE " . Pdb::buildClause($conditions, $params);
Line 60: Pdb::query($q, $params, 'row');
Line 94: $res = Pdb::q($q, [$id], 'arr');
Line 157: $res = Pdb::q($q, [$_SESSION['admin']['login_id']], 'pdo');
Line 192: $subsites = Pdb::lookup('subsites');
Line 220: $where = Pdb::buildClause([['id', 'IN', $cats]], $params);
Line 225: $res = Pdb::q($q, $params, 'col');
Line 238: $where = Pdb::buildClause([['operatorcategory_id', 'IN', $cats]], $params);
Line 242: $subs_ops = Pdb::q($q, $params, 'col');
Line 271: Pdb::validateIdentifier($access_flag);
Line 280: return Pdb::q($q, [], 'arr');
Line 319: $res = Pdb::q($q, [AdminAuth::getId()], 'arr');
Line 341: $where = Pdb::buildClause($conditions, $params);
Line 347: $flag = Pdb::q($q, $params, 'val');
Line 374: $res = Pdb::q($q, [AdminAuth::getId()], 'arr');
Line 392: $where = Pdb::buildClause($conditions, $params);
Line 397: $res = Pdb::q($q, $params, 'arr');
Line 478: return Pdb::lookup($cats_table);
Line 494: return Pdb::q($q, [AdminAuth::getId()], 'map');

/sprout/Helpers/ColModifierActionLogData.php   Highlighted file source

Line 34: $row = Pdb::q($q, [$val], 'row');

/sprout/Helpers/ColModifierLookupTable.php   Highlighted file source

Line 19: * This is basically than ColModifierLookupArray(Pdb::lookup),
Line 20: * but it doesn't call the Pdb::lookup until right before it's needed,
Line 46: $this->data = Pdb::lookup($this->table);

/sprout/Helpers/ContentReplace.php   Highlighted file source

Line 18: use karmabunny\pdb\Exceptions\RowMissingException;
Line 128: Pdb::validateIdentifier($widget_table);
Line 186: Pdb::validateIdentifier($widget_table);
Line 193: $where = Pdb::buildClause($conditions, $params);
Line 198: $res = Pdb::q($q, $params, 'arr');
Line 252: Pdb::validateIdentifier($widget_table);
Line 270: $widget = Pdb::query($q, [$widget_record, $matches[1]], 'row');
Line 422: $where = Pdb::buildClause([['id', 'IN', $ids]], $params);
Line 424: $filenames = Pdb::q($q, $params, 'map');

/sprout/Helpers/Cron.php   Highlighted file source

Line 62: $update_fields['date_added'] = Pdb::now();
Line 63: $update_fields['date_modified'] = Pdb::now();
Line 65: self::$job_id = Pdb::insert('cron_jobs', $update_fields);
Line 67: self::$pdo = Pdb::connect('default');
Line 68: $pf = Pdb::prefix();
Line 128: $pf = Pdb::prefix();
Line 149: $pf = Pdb::prefix();

/sprout/Helpers/Drivers/Session/Database.php   Highlighted file source

Line 20: use karmabunny\pdb\Exceptions\RowMissingException;
Line 23: use Sprout\Helpers\Pdb;
Line 55: Pdb::validateIdentifier($config['storage']['table']);
Line 78: $data = Pdb::q($q, [$id], 'val');
Line 104: $count = Pdb::insert($this->table, $data);
Line 112: $count = Pdb::update($this->table, $data, array('session_id' => $id));
Line 117: $count = Pdb::update($this->table, $data, array('session_id' => $this->session_id));
Line 129: Pdb::delete($this->table, array('session_id' => $id));
Line 149: Pdb::delete($this->table, [['last_activity', '<', time() - $maxlifetime]]);

/sprout/Helpers/Export.php   Highlighted file source

Line 105: $res = Pdb::query($q, [], 'pdo');
Line 117: $res = Pdb::query($q, [], 'pdo');
Line 177: $res = Pdb::query($q, [], 'pdo');

/sprout/Helpers/ExportDBMS_SQLite.php   Highlighted file source

Line 44: $res = Pdb::query($q, [], 'arr-num');
Line 89: $res = Pdb::query($q, [], 'arr-num');

/sprout/Helpers/File.php   Highlighted file source

Line 21: use karmabunny\pdb\Exceptions\RowMissingException;
Line 45: $prepared_q = Pdb::prepare($q);
Line 49: return Pdb::execute($prepared_q, [$id], 'row');
Line 292: $filename = Pdb::q('SELECT filename FROM ~files WHERE id = ?', [$id], 'val');
Line 522: $pf = Pdb::prefix();
Line 526: 'like_filename' => Pdb::likeEscape($filename),
Line 532: Pdb::validateIdentifier($size_name);
Line 534: $all_params["resize_{$size_name}"] = Pdb::likeEscape(File::getResizeFilename($filename, $size_name));
Line 551: $db_tables = Pdb::q($q, [], 'arr');
Line 560: $db_cols = Pdb::q($q, [], 'arr');
Line 639: $res = Pdb::q($q, $params, 'pdo');
Line 973: $row = Pdb::q($q, [$filename], 'row');
Line 1042: Pdb::update('files', $update_data, ['id' => $file_id]);
Line 1050: Pdb::update('files', $update_data, ['id' => $file_id]);
Line 1107: $dest_spec_json = Pdb::q($q, ['files/' . $filename], 'val');

/sprout/Helpers/ImportCMS.php   Highlighted file source

Line 10: use Sprout\Helpers\Pdb;
Line 34: Pdb::transact();
Line 50: $record_order = Pdb::query($q, [$_POST['page_id']], 'val');
Line 60: Pdb::commit();
Line 97: $fields['date_added'] = Pdb::now();
Line 98: $fields['date_modified'] = Pdb::now();
Line 106: $page_id = Pdb::insert('pages', $fields);
Line 118: $fields['date_added'] = Pdb::now();
Line 119: $fields['date_modified'] = Pdb::now();
Line 121: $revision_id = Pdb::insert('page_revisions', $fields);
Line 141: Pdb::insert('page_widgets', $fields);
Line 163: $where = Pdb::buildClause($conditions, $params);
Line 174: $widgets = Pdb::query($q, $params, 'arr');
Line 184: Pdb::update('page_widgets', ['settings' => json_encode(['text' => $settings->text])], [['id', '=', $widget['id']]]);

/sprout/Helpers/LaunchChecks.php   Highlighted file source

Line 33: $codes = Pdb::query($q, [], 'col');

/sprout/Helpers/MultiEdit.php   Highlighted file source

Line 37: * @param array $where Conditions for WHERE clause, as per {@see Pdb::buildClause}
Line 43: Pdb::validateIdentifier($table);
Line 48: Pdb::validateIdentifier($col);
Line 54: $where = Pdb::buildClause($where, $vals);
Line 58: return Pdb::q($q, $vals, 'arr');

/sprout/Helpers/NavigationGroups.php   Highlighted file source

Line 38: $res = Pdb::q($q, [$subsite_id], 'pdo');
Line 52: $res = Pdb::q($q, [$subsite_id], 'pdo');
Line 96: $update_data['date_added'] = Pdb::now();
Line 97: $update_data['date_modified'] = Pdb::now();
Line 100: $menu_group_id = Pdb::insert('menu_groups', $update_data);

/sprout/Helpers/PageRouting.php   Highlighted file source

Line 16: use karmabunny\pdb\Exceptions\QueryException;
Line 38: 'url_like' => Pdb::likeEscape($url_std),
Line 57: $row = Pdb::q($q, $params, 'row');

/sprout/Helpers/PerRecordPerms.php   Highlighted file source

Line 17: use karmabunny\pdb\Exceptions\RowMissingException;
Line 36: return (bool) Pdb::query($q, [$controller_name], 'count');
Line 51: return (bool) Pdb::query($q, [$controller_name], 'count');
Line 90: $row = Pdb::q($q, [$ctlr->getControllerName(), $item_id], 'row');
Line 148: $where = Pdb::buildClause($conds, $params);
Line 151: $perm_id = Pdb::q($q, $params, 'val');
Line 152: Pdb::update('per_record_permissions', $perms, ['id' => $perm_id]);
Line 154: Pdb::insert('per_record_permissions', $perms);

/sprout/Helpers/RateLimit.php   Highlighted file source

Line 57: $data['date_added'] = Pdb::now();
Line 62: Pdb::insert('rate_limit_hits', $data);
Line 78: $where = Pdb::buildClause($conditions, $params);
Line 84: return Pdb::q($q, $params, 'val');

/sprout/Helpers/RteLibraryDocuments.php   Highlighted file source

Line 49: $res = Pdb::query($q, [FileConstants::TYPE_DOCUMENT], 'pdo');
Line 68: $res = Pdb::query($q, [$cat_id, FileConstants::TYPE_DOCUMENT], 'pdo');
Line 105: $where = Pdb::buildClause($conditions, $params, 'OR');
Line 113: $res = Pdb::query($q, $params, 'pdo');

/sprout/Helpers/RteLibraryImages.php   Highlighted file source

Line 52: $res = Pdb::query($q, [FileConstants::TYPE_IMAGE], 'pdo');
Line 71: $res = Pdb::query($q, [$cat_id, FileConstants::TYPE_IMAGE], 'pdo');
Line 111: $where = Pdb::buildClause($conditions, $params, 'OR');
Line 119: $res = Pdb::query($q, $params, 'pdo');

/sprout/Helpers/RteLibrarySounds.php   Highlighted file source

Line 49: $res = Pdb::query($q, [FileConstants::TYPE_SOUND], 'pdo');
Line 68: $res = Pdb::query($q, [$cat_id, FileConstants::TYPE_SOUND], 'pdo');
Line 105: $where = Pdb::buildClause($conditions, $params, 'OR');
Line 113: $res = Pdb::query($q, $params, 'pdo');

/sprout/Helpers/Slug.php   Highlighted file source

Line 16: use karmabunny\pdb\Exceptions\RowMissingException;
Line 54: * Return all columns for a single row of a table (similar to {@see Pdb::get})
Line 59: * @param string $conditions Extra WHERE clause if required, in the format prescribed by {@see Pdb::buildClause}
Line 66: Pdb::validateIdentifier($table);
Line 71: $q .= " AND " . Pdb::buildClause($conditions, $params);
Line 73: return Pdb::q($q, $params, 'row');
Line 102: * @param array $conditions Extra conditions to check, in the format prescribed by {@see Pdb::buildClause}
Line 109: Pdb::validateIdentifier($table);
Line 114: $where = Pdb::buildClause($conditions, $params);
Line 117: $row = Pdb::q($q, $params, 'row');

/sprout/Helpers/Subsites.php   Highlighted file source

Line 21: use karmabunny\pdb\Exceptions\QueryException;
Line 44: $result = Pdb::query($q, [], 'pdo');

/sprout/Helpers/Tags.php   Highlighted file source

Line 16: use karmabunny\pdb\Exceptions\QueryException;
Line 40: return Pdb::q($q, [$table, $record_id], 'col');
Line 57: return Pdb::q($q, [$table], 'col');
Line 75: return Pdb::query($q, [$table, $tag], 'col');
Line 94: Pdb::validateIdentifier($table);
Line 103: return Pdb::query($q, [$table], 'map');
Line 124: Pdb::validateIdentifier($table);
Line 138: return Pdb::query($q, [$table, $subsite_id], 'map');
Line 155: return Pdb::query($q, [Pdb::likeEscape($prefix)], 'col');
Line 177: $values['prefix'] = Pdb::likeEscape($prefix);
Line 190: $tags = Pdb::q($q, $values, 'col');
Line 203: $tags = array_merge($tags, Pdb::q($q, $values, 'col'));
Line 228: Pdb::transact();
Line 238: Pdb::insert('tags', ['record_table' => $table, 'record_id' => $record_id, 'name' => $tag]);
Line 243: Pdb::delete('tags', ['record_table' => $table, 'record_id' => $record_id, ['name', 'IN', $del_tags]]);
Line 246: Pdb::commit();
Line 250: Pdb::rollback();

/sprout/Helpers/TreenodeHasWidgetMatcher.php   Highlighted file source

Line 42: $this->ids = Pdb::query($q, [$type], 'col');

/sprout/Helpers/Worker.php   Highlighted file source

Line 49: $update_fields['date_started'] = Pdb::now();
Line 50: $update_fields['date_modified'] = Pdb::now();
Line 56: Pdb::update('worker_jobs', $update_fields, array('id' => $job_id));
Line 58: self::$pdo = Pdb::connect('default');
Line 59: $pf = Pdb::prefix();
Line 151: $pf = Pdb::prefix();
Line 182: $pf = Pdb::prefix();

/sprout/Helpers/WorkerLinkChecker.php   Highlighted file source

Line 45: $res = Pdb::query($q, [], 'map-arr');
Line 63: $widgets = Pdb::q($q, [], 'pdo');

/sprout/Models/CategoryModel.php   Highlighted file source

Line 7: use karmabunny\pdb\Pdb;
Line 8: use karmabunny\pdb\PdbQuery;
Line 27: public static function getConnection(): Pdb
Line 29: return \Sprout\Helpers\Pdb::getInstance();
Line 58: * @return PdbQuery
Line 60: public static function find(string $main_table, array $conditions = []): PdbQuery
Line 62: $pdb = static::getConnection();
Line 65: return (new PdbQuery($pdb))
Line 113: $pdb = static::getConnection();
Line 116: $now = Pdb::now();
Line 124: $pdb->update($cat_table, $data, $conditions);
Line 132: if (!$pdb->inTransaction()) {
Line 134: $pdb->transact();
Line 137: $this->id = $pdb->insert($cat_table, $data);
Line 140: $pdb->commit();
Line 162: $pdb = static::getConnection();
Line 164: return (bool) $pdb->delete($cat_table, ['id' => $this->id]);

/sprout/module_template/tree/Controllers/Admin/CNAMEAdminController.php   Highlighted file source

Line 20: use Sprout\Helpers\Pdb;
Line 81: Pdb::transact();
Line 85: Pdb::commit();
Line 123: $parent_id = Pdb::query($q, [$item_id], 'val');
Line 125: Pdb::transact();
Line 130: Pdb::commit();

/sprout/sprout_load.php   Highlighted file source

Line 14: use Sprout\Helpers\Pdb;
Line 171: Pdb::setFormatter('DateTime', function($dt) {
Line 175: Pdb::setFormatter('DateInterval', function($interval) {

/sprout/tests/navigationTest.php   Highlighted file source

Line 15: use Sprout\Helpers\Pdb;
Line 37: Pdb::q($q, [], 'null');
Line 40: Pdb::q($q, [], 'null');
Line 48: Pdb::q($q, $pg, 'null');
Line 52: Pdb::q($q, [$pg[0], $type, $status], 'null');
Line 56: Pdb::setTablePrefixOverride('pages', "unit_test_{$rand}_");
Line 57: Pdb::setTablePrefixOverride('page_revisions', "unit_test_{$rand}_");
Line 66: $top_pages = Pdb::query($q, [], 'arr');
Line 79: Pdb::setTablePrefixOverride('pages', Pdb::prefix());
Line 80: Pdb::setTablePrefixOverride('page_revisions', Pdb::prefix());

/sprout/tests/sproutTest.php   Highlighted file source

Line 227: $this->assertInstanceOf('Sprout\Helpers\Pdb', Sprout::instance('Sprout\Helpers\Pdb'));

/sprout/views/admin/operator_category_edit.php   Highlighted file source

Line 19: use Sprout\Helpers\Pdb;
Line 119: <?= Form::checkboxSet('manage_categories', [], Pdb::lookup('operators_cat_list')); ?>

/sprout/Widgets/ChildrenGalleryWidget.php   Highlighted file source

Line 18: use Sprout\Helpers\Pdb;
Line 114: $res = Pdb::query($q, [], 'arr');

/sprout/Widgets/ImageGalleryWidget.php   Highlighted file source

Line 19: use Sprout\Helpers\Pdb;
Line 140: $res = Pdb::query($q, [$this->settings['category']], 'arr');
Line 217: $cats = Pdb::query($q, [FileConstants::TYPE_IMAGE], 'map');
Line 283: $cats = Pdb::lookup('files_cat_list');
Line 298: $cats = Pdb::lookup('files_cat_list');