assign_block_vars( 'update_result', array( 'UPD_ELEMENT'=> $lang['ws_adding_legend'].$lang['ws_success_upd'], ) ); } // Next, Update selected access if (isset($_POST['wsu_submit'])) { $upd_end = ( is_numeric($_POST['upd_end']) ) ? $_POST['upd_end']:0; $settxt = ' end = ADDDATE(NOW(), INTERVAL '. $upd_end .' DAY)'; if ((isset($_POST['selection'])) and (trim($settxt) != '')) { $uid = (int) $_POST['selection']; $query = ' UPDATE '.WEB_SERVICES_ACCESS_TABLE.' SET '.$settxt.' WHERE id = '.$uid.'; '; pwg_query($query); $template->assign_block_vars( 'update_result', array( 'UPD_ELEMENT'=> $lang['ws_update_legend'].$lang['ws_success_upd'], ) ); } else { $template->assign_block_vars( 'update_result', array( 'UPD_ELEMENT'=> $lang['ws_update_legend'].$lang['ws_failed_upd'], ) ); } } // Next, Delete selected access if (isset($_POST['wsX_submit'])) { if ((isset($_POST['delete_confirmation'])) and (isset($_POST['selection']))) { $uid = (int) $_POST['selection']; $query = 'DELETE FROM '.WEB_SERVICES_ACCESS_TABLE.' WHERE id = '.$uid.'; '; pwg_query($query); $template->assign_block_vars( 'update_result', array( 'UPD_ELEMENT'=> $lang['ws_delete_legend'].$lang['ws_success_upd'], ) ); } else { $template->assign_block_vars( 'update_result', array( 'UPD_ELEMENT'=> $lang['Not selected / Not confirmed'] .$lang['ws_failed_upd'], ) ); } } $template->assign_vars( array( 'DEFLT_HIGH_YES' => '', 'DEFLT_HIGH_NO' => 'checked', 'DEFLT_NORMAL_YES' => '', 'DEFLT_NORMAL_NO' => 'checked', 'U_HELP' => PHPWG_ROOT_PATH.'popuphelp.php?page=web_service', ) ); // Build where $where = ''; $order = ' ORDER BY `id` DESC' ; $query = ' SELECT * FROM '.WEB_SERVICES_ACCESS_TABLE.' WHERE 1=1 ' .$where. ' ' .$order. ';'; $result = pwg_query($query); $acc_list = mysql_num_rows($result); $result = pwg_query($query); // +-----------------------------------------------------------------------+ // | template init | // +-----------------------------------------------------------------------+ $template->set_filenames( array( 'ws_checker' => 'admin/ws_checker.tpl' ) ); $selected = 'selected="selected"'; $num=0; if ( $acc_list > 0 ) { $template->assign_block_vars( 'acc_list', array() ); } // Access List while ($row = mysql_fetch_array($result)) { $num++; $template->assign_block_vars( 'acc_list.access', array( 'CLASS' => ($num % 2 == 1) ? 'row1' : 'row2', 'ID' => $row['id'], 'NAME' => (is_adviser()) ? '*********' : $row['name'], 'TARGET' => $row['access'], 'END' => $row['end'], 'REQUEST' => $row['request'], 'LIMIT' => $row['limit'], 'COMMENT' => $row['comment'], 'SELECTED' => '', ) ); } $template->assign_block_vars( 'add_request', array( 'VALUE'=> '', 'CONTENT' => '', 'SELECTED' => $selected, ) ); foreach ($req_type_list as $value) { $template->assign_block_vars( 'add_request', array( 'VALUE'=> $value, 'CONTENT' => $value, 'SELECTED' => '', ) ); } foreach ($conf['ws_allowed_limit'] as $value) { $template->assign_block_vars( 'add_limit', array( 'VALUE'=> $value, 'CONTENT' => $value, 'SELECTED' => ($conf['ws_allowed_limit'][0] == $value) ? $selected:'', ) ); } // Postponed Start Date // By default 0, 1, 2, 3, 5, 7, 14 or 30 days foreach ($conf['ws_postponed_start'] as $value) { $template->assign_block_vars( 'add_start', array( 'VALUE'=> $value, 'CONTENT' => $value, 'SELECTED' => ($conf['ws_postponed_start'][0] == $value) ? $selected:'', ) ); } // Durations (Allowed Web Services Period) // By default 10, 5, 2, 1 year(s) or 6, 3, 1 month(s) or 15, 10, 7, 5, 1, 0 day(s) foreach ($conf['ws_durations'] as $value) { $template->assign_block_vars( 'add_end', array( 'VALUE'=> $value, 'CONTENT' => $value, 'SELECTED' => ($conf['ws_durations'][3] == $value) ? $selected:'', ) ); if ( $acc_list > 0 ) { $template->assign_block_vars( 'acc_list.upd_end', array( 'VALUE'=> $value, 'CONTENT' => $value, 'SELECTED' => ($conf['ws_durations'][3] == $value) ? $selected:'', ) ); } } //----------------------------------------------------------- sending html code $template->assign_var_from_handle('ADMIN_CONTENT', 'ws_checker'); ?>