PHP arr_from_query Examples

Example #1

File: 01CGMInformatics.php Project: Nazg-Gul/e-marsa

 function UpdateTasksCache($contest_id, $problem_id)
 {
     if ($contest_id < 0) {
         $contest_id = $_SESSION['WT_contest_id'];
     }
     if (isset($this->cache['tasks'][$contest_id])) {
         return;
     }
     $t = arr_from_query("SELECT * FROM `tester_tasks` " . "WHERE `contest_id`={$contest_id}");
     $this->cache['tasks'][$contest_id] = $t;
 }

Example #2

File: 00CGMVirtual.php Project: Nazg-Gul/e-marsa

 function GetProblemsAtContest($contest_id = -1)
 {
     if ($contest_id < 0) {
         $contest_id = $_SESSION['WT_contest_id'];
     }
     return arr_from_query('SELECT * FROM `tester_tasks` ' . 'WHERE `contest_id`=' . $contest_id . ' ORDER BY `letter`');
 }

Example #3

File: 02CGMTesting.php Project: Nazg-Gul/e-marsa

 function Categories_Get($contest_id = -1)
 {
     if ($contest_id < 0) {
         $contest_id = $_SESSION['WT_contest_id'];
     }
     return arr_from_query('SELECT * FROM `tester_categories` ' . 'WHERE `contest_id`=' . $contest_id . ' ORDER BY `order`');
 }

Example #4

File: user.php Project: Nazg-Gul/gate

 function user_get_groups($id)
 {
     return arr_from_query('SELECT `group_id` FROM `usergroup` ' . 'WHERE `user_id`=' . $id . '  GROUP BY `group_id`', 'group_id');
 }

Example #5

File: dataset.php Project: Nazg-Gul/gate

 function manage_dataset_get_fields($id)
 {
     return arr_from_query('SELECT * FROM `dataset_assoc` WHERE `dataset`=' . $id . ' ORDER BY `order`');
 }

Example #6

File: group.php Project: Nazg-Gul/gate

 function group_default_list()
 {
     return arr_from_query('SELECT * FROM `group` ' . 'WHERE `default`=1 ORDER BY `name`');
 }

Example #7

File: service.php Project: Nazg-Gul/gate

 function manage_service_get_list()
 {
     return arr_from_query('SELECT * FROM `service` ORDER BY `name`');
 }

Example #8

File: 01CCList.php Project: Nazg-Gul/gate

 function Editor_GetHistory()
 {
     $arr = array();
     if ($this->settings['content'] != '') {
         $arr = arr_from_query('SELECT `id`, `timestamp`, `user_id`, ' . '`ip` FROM ' . $this->settings['content'] . ' ORDER BY `id`');
     }
     return $arr;
 }

Example #9

File: settings.php Project: Nazg-Gul/gate

 function manage_settings_get_section_elements($section)
 {
     return arr_from_query('SELECT * FROM `settings` WHERE `section`="' . $section . '" ORDER BY `name`');
 }