function process_subject_areas()
{
global $userrole;
if ($userrole === "admin") {
print '<b>Subject Areas</b><br /><br />';
if (isset($_GET['act'])) {
if ($_POST['Edit'] === 'edit') {
$sa = db_subject_areas();
edit_subject_area($sa);
} else {
if ($_POST['Add'] === 'add') {
add_subject_area();
} else {
if ($_POST['Save'] === 'save') {
save_subject_area();
} else {
if ($_POST['Remove'] === 'remove') {
$sa = db_subject_areas();
remove_record($sa);
} else {
if ($_POST['Remove'] === 'yes') {
yes_remove_subject_area();
}
}
}
}
}
}
$sadata = db_subject_areas();
show_table(array('ID', 'Subject area CODE', 'Subject area NAME'), $sadata);
print '<br /><br />For a list of areas, see: <a href="http://egracons.eu/sites/default/files/APPLICATION_OF_ISCED_CODES_IN_EGRACONS_TOOL_2015%2004%2008_1.pdf" target="_blank">ISCED CODES</a><br />';
} else {
return;
}
}
function process_universities()
{
global $userrole;
if ($userrole === "admin") {
print '<b>Universities</b><br /><br />';
if (isset($_GET['act'])) {
if ($_POST['Edit'] === 'edit') {
$uni = db_universities_without_countries();
edit_university($uni);
} else {
if ($_POST['Add'] === 'add') {
add_university();
} else {
if ($_POST['Save'] === 'save') {
save_university();
} else {
if ($_POST['Remove'] === 'remove') {
$uni = db_universities_with_countries();
remove_record($uni);
} else {
if ($_POST['Remove'] === 'yes') {
yes_remove_university();
}
}
}
}
}
}
$unidata = db_universities_with_countries();
show_table(array('ID', 'University name (country)', 'Erasmus code'), $unidata);
} else {
return;
}
}
function process_study_programs()
{
global $userrole;
if ($userrole === "admin") {
print '<b>Study Programs</b><br /><br />';
if (isset($_GET['act'])) {
if ($_POST['Edit'] === 'edit') {
$sp = db_study_programs();
edit_study_program($sp);
} else {
if ($_POST['Add'] === 'add') {
add_study_program();
} else {
if ($_POST['Save'] === 'save') {
save_study_program();
} else {
if ($_POST['Remove'] === 'remove') {
$sp = db_study_programs();
remove_record($sp);
} else {
if ($_POST['Remove'] === 'yes') {
yes_remove_study_program();
}
}
}
}
}
}
$spdata = db_study_programs();
show_table(array('ID', 'Study program CODE', 'Study program NAME'), $spdata);
} else {
return;
}
}
function process_fmfi_courses()
{
global $userrole;
if ($userrole === "admin") {
print '<b>FMFI Courses</b><br /><br />';
if (isset($_GET['act'])) {
if ($_POST['Edit'] === 'edit') {
$fc = db_fmfi_courses();
edit_fmfi_course($fc);
} else {
if ($_POST['Add'] === 'add') {
add_fmfi_course();
} else {
if ($_POST['Save'] === 'save') {
save_fmfi_course();
} else {
if ($_POST['Remove'] === 'remove') {
$fc = db_fmfi_courses();
remove_record($fc);
} else {
if ($_POST['Remove'] === 'yes') {
yes_remove_fmfi_courses();
}
}
}
}
}
}
$fcdata = db_fmfi_courses();
show_table(array('ID', 'Course CODE', 'Course NAME', 'Credits'), $fcdata);
} else {
return;
}
}
function process_credits()
{
print '<b>Travel courses</b><br /><br />';
$tcdata = NULL;
if (isset($_GET['act'])) {
if (strcmp($_POST['Edit'], 'edit') === 0) {
$tcdata = db_travel_courses();
edit_travel_course($tcdata);
} else {
if (strcmp($_POST['Add'], 'add') === 0) {
add_travel_course();
} else {
if (strcmp($_POST['Save'], 'save') === 0) {
save_travel_course();
} else {
if (strcmp($_POST['Remove'], 'remove') === 0) {
$tcdata = db_travel_courses();
remove_record($tcdata);
} else {
if (strcmp($_POST['Remove'], 'yes') === 0) {
yes_remove_travel_courses();
}
}
}
}
}
}
if ($tcdata == NULL) {
$tcdata = db_travel_courses();
}
$tcf = format_travel_courses($tcdata);
show_table(array('ID', 'Associated travel', 'Foreign course code', 'Foreign course name', 'Credits', 'Grade', 'Course type', 'FMFI course'), $tcf);
}
function process_students()
{
global $userrole;
if ($userrole === "admin") {
print '<b>Students</b><br /><br />';
if (isset($_GET['act'])) {
if ($_POST['Edit'] === 'edit') {
$st = db_students();
edit_student($st);
} else {
if ($_POST['Add'] === 'add') {
add_student();
} else {
if ($_POST['Save'] === 'save') {
save_student();
} else {
if ($_POST['Remove'] === 'remove') {
$st = db_students();
remove_record($st);
} else {
if ($_POST['AddOption'] === 'add') {
add_study_program_to_student_and_edit_student();
} else {
if ($_POST['Remove'] === 'yes') {
yes_remove();
} else {
if ($_POST['Remove'] === 'no') {
no_remove();
} else {
foreach ($_POST as $var => $val) {
if (strncmp($var, 'deletelist', 10) === 0) {
delete_sp_and_edit_student($var);
break;
}
}
}
}
}
}
}
}
}
}
$stdata = db_students();
$stfd = format_student_data($stdata);
show_table(array('ID', 'First name', 'Middle names', 'Last name', 'Born', 'StudentID', 'Gender', 'Citizenship', 'E-mail', 'Study programs', 'Year 1st participated'), $stfd);
} else {
return;
}
}
function process_agreements()
{
print '<b>Bilateral Agreements</b><br /><br />';
if (isset($_GET['act'])) {
if ($_POST['Edit'] === 'edit') {
$agg = db_retrieve_agreements_data();
edit_agreement($agg);
} else {
if ($_POST['Add'] === 'add') {
add_agreement();
} else {
if ($_POST['Save'] === 'save') {
save_agreement();
} else {
if ($_POST['Remove'] === 'remove') {
$agg = db_retrieve_agreements_data();
remove_record($agg);
} else {
if ($_POST['Remove'] === 'yes') {
yes_remove_agreement();
} else {
if (isset($_POST['upload10'])) {
upload_file_and_edit_agreement();
} else {
if ($_POST['DeleteFile'] === 'yes') {
yes_delete_file_and_edit_agreement();
} else {
if ($_POST['DeleteFile'] === 'no') {
no_delete_file_and_edit_agreement();
} else {
foreach ($_POST as $var => $val) {
if (strncmp($var, 'deletefile', 10) === 0) {
delete_file_and_edit_agreement($var);
break;
}
}
}
}
}
}
}
}
}
}
}
$columns = array('ID', 'University (country, code)', 'Valid FROM (YYYY/YYYY)', 'Valid TO (YYYY/YYYY)', 'Coordinator', 'Subject Area', 'Accepted levels', '# of students', 'Files');
$agg = db_retrieve_agreements_data();
$fagg = format_agreements_data($agg);
show_table($columns, $fagg);
}
function process_foreign_credits()
{
global $userrole;
if ($userrole === "admin") {
print '<b>Travel foreign courses</b><br /><br />';
$filter_exchange = retrieve_filter_exchange();
show_exchange_filter($filter_exchange);
$tcdata = NULL;
if (isset($_GET['act'])) {
if ($_POST['Edit'] === 'edit') {
$tcdata = db_foreign_courses_for_an_exchange($filter_exchange, TRUE);
edit_travel_course($tcdata);
} else {
if ($_POST['Add'] === 'add') {
add_travel_course($filter_exchange);
} else {
if ($_POST['Save'] === 'save') {
save_travel_course($filter_exchange);
} else {
if ($_POST['Remove'] === 'remove') {
$tcdata = db_foreign_courses_for_an_exchange($filter_exchange, TRUE);
remove_record($tcdata);
} else {
if ($_POST['Remove'] === 'yes') {
yes_remove_travel_courses();
}
}
}
}
}
}
logmsg("retr");
if ($tcdata == NULL) {
$tcdata = db_foreign_courses_for_an_exchange($filter_exchange, TRUE);
}
logmsg("ieve");
$tcf = format_travel_foreign_courses($tcdata);
show_table(array('ID', 'Foreign course code', 'Foreign course name', 'Credits', 'Grade', 'Course type'), $tcf);
} else {
return;
}
}
if(!empty($dl)){
if(REFCHECK){
$c_okurl=count($okurl);
$is_okurl=false;
for($i=0; $i<$c_okurl; $i++){
if(isset($_SERVER['HTTP_REFERER']) && ($is_okurl = strstr($_SERVER['HTTP_REFERER'],$okurl[$i]) !== FALSE))
break;
if(!$is_okurl && $i==$c_okurl-1)
die("指定URL以外からはDLできません");
}
}
count_dl($dl);
exit;
}
switch($job){
case 'detail':
if($detail) show_detail($detail);
break;
case 'admin':
if($admin_submit) $admin = md5($admin_submit);
validation($admin);
if($act) manage($act,$id,$new);
if($submit=="Add Entry") add_data($new_loc,$new_id,$description,$new_ref);
show_track();
break;
default:
if(time()-filemtime(LOGFILE) > 3600) @copy(LOGFILE,LOGFILE.".bak");
show_table($top,$option);
}
?>
function process_travels()
{
global $userrole;
if ($userrole === "admin") {
print '<b>Travels</b><br /><br />';
list($filter_a, $filter_d1, $filter_d2) = configure_travel_filters();
show_travel_filters($filter_a, $filter_d1, $filter_d2);
if (isset($_GET['act'])) {
if ($_POST['Edit'] === 'edit') {
$ts = db_travels($filter_a, $filter_d1, $filter_d2);
edit_travel($ts);
} else {
if ($_POST['Add'] === 'add') {
add_travel();
} else {
if ($_POST['Print'] === 'print') {
$ts = db_travels($filter_a, $filter_d1, $filter_d2);
print_link_travel($ts);
} else {
if ($_POST['Save'] === 'save') {
save_travel();
} else {
if (isset($_POST['upload13'])) {
upload_file_and_edit_travel();
} else {
if ($_POST['Remove'] === 'remove') {
$ts = db_travels($filter_a, $filter_d1, $filter_d2);
remove_record($ts);
} else {
if ($_POST['Remove'] === 'yes') {
yes_remove_travels();
} else {
if ($_POST['DeleteFile'] === 'yes') {
yes_delete_file_and_edit_travel();
} else {
if ($_POST['DeleteFile'] === 'no') {
no_delete_file_and_edit_travel();
} else {
if ($_POST['AddOption'] === 'add') {
add_course_to_travel_and_edit_travel();
} else {
if ($_POST['Remove'] === 'yes') {
yes_remove_travels();
} else {
foreach ($_POST as $var => $val) {
if (strncmp($var, 'deletefile', 10) === 0) {
delete_file_and_edit_travel($var);
break;
}
}
}
}
}
}
}
}
}
}
}
}
}
}
$tsdata = db_travels($filter_a, $filter_d1, $filter_d2);
$fts = format_travel_data($tsdata);
show_table(array('ID', 'Level', 'Agreement', 'Semester', 'Date FROM (Y-m-d)', 'Date TO (Y-m-d)', 'Student', 'Study program', 'Language:', 'Has', 'Expected', 'Soc.stip.', 'Handicap', 'Files', 'Courses', 'Notes', 'Cancelled'), $fts, TRUE, TRUE);
} else {
return;
}
echo "\n <script>\n \$('table>tbody>tr>td:nth-child(15)>article').each(\n function(index){\n \$(this).readmore({\n collapsedHeight: 45, \n moreLink: '<a href=\"#\">More</a>',\n lessLink: '<a href=\"#\">Less</a>'\n })\n })\n </script>";
//oshitoshit
}
<?php
/*
Chen Qiu, CSE 154 Section AB, Homework 5, 10/29/2014
This page searches for all the films with the actor the user is searching
sorted by year descending, breaking ties by movie title ascending.
*/
$first = $_GET["firstname"];
$last = $_GET["lastname"];
include "common.php";
$db = new PDO("mysql:dbname=imdb;host=localhost;", "chenq9", "9XcmbstwvP");
$id_rows = search($first, $last, $db);
if ($id_rows->rowCount() > 0) {
$id = $id_rows->fetch()["id"];
$rows = $db->query("SELECT name, year FROM movies JOIN roles ON movie_id = id WHERE actor_id = {$id} ORDER BY year DESC, name ASC");
$caption = "All Films";
show_table($rows, $first, $last, $caption);
} else {
// Actor Not Found.
?>
<p>Actor <?php
echo "{$first} {$last}";
?>
not found.</P>
<?php
}
forms();
footer();
$form .= show_parameter ($interface["name"],$interface["optional"],$interface["def"],$$var);
}
}
for ($i=0;$i<count($def);$i++)
{
$interface = $def[$i];
if ($interface["type"] == "TABLE") // if internal table
{
$form .= "<tr bgcolor=#D0D0D0><td colspan=2><b>TABLE ".$interface["name"]."</b></td></tr>\n";
$var="RFC_TABLE_".$interface["name"];
if ( !isset ($$var) ) $$var="";
$vararray = unserialize (urldecode($$var)); // get saved array of values from RFC_TABLE_*
$var="RFC_".$interface["name"];
if ($action=="Append ".$interface["name"]) // if Append button pressed, add new line to internal table (array)
$vararray[]=$$var;
$form .= show_table ($interface["name"],$interface["def"],$vararray);
}
}
$form .= "<tr><td colspan=2><input type=submit name=action value=\"Call $function\">\n";
$form .="<input type=submit name=action value=\"Generate PHP\"></td></tr>\n";
$form .= "</table></form>\n";
print_window ("Function module $function",$form,"<a href=\"javascript:history.back()\">Back</a> <a href=\"saprfc_test.php?p=newlogin\">New login</a> <a href=\"saprfc_test.php?p=select\">Select other function</a>");
print_footer();
}
}
if ( $p == "call" ) // set input parameters and tables, call function module, show results
{
for ($i=0;$i<count($def);$i++)
{
$interface = $def[$i];
<div class="row clearfix"> <!-- форма для добавления товара в базу --> <div class="head_cont">Редактирование товара в базе данных</div> <form method="post"> <label> <p>ID товара в базе</p> <input name = "id_elem" type = "text" value = "" /> </label> <?php include_once "_db_item_form_fields.php"; ?> <div class="wr_subm"> <input type="submit" value="Изменить" /> </div> </form> <div class="wr_result_mess"> <?php show_result_edit($connection); ?> </div> <div> <?php show_table($connection); ?> </div> </div> </div> </div> </div> </main>
function process_logs()
{
global $userrole;
if ($userrole === "admin") {
print '<b>Logs</b><br /><br />';
$logdata = db_retrieve_logs();
show_table(array('date', 'ip', 'user', 'table', 'record', 'operation', 'description', 'new value'), $logdata, FALSE);
} else {
return;
}
}
<?php
session_start();
$user = @$_SESSION['myemail'];
if ($user != "admin") {
header("location: ./../index.php");
die;
}
require './../config.php';
require './../src/security.php';
$action = @$_POST['action'];
if ($action == 'show_table') {
show_table();
}
if ($action == 'delete_row') {
delete_row();
}
if ($action == 'new_row') {
new_row();
}
if (preg_match('/change/', $action)) {
change($action);
}
function show_table()
{
$data = $GLOBALS['DB']->query("SELECT * FROM user");
echo json_encode($data);
}
function delete_row()
{
$id = (int) @$_POST['id'];
echo $class;
?>
"><?php
echo $class;
?>
</td>
<td><?php
echo $shogi->log[count($shogi->log) - 1];
?>
</td>
</tr>
<?php
}
}
?>
<caption style="position:relative;">
<?php
echo show_table($shogi);
?>
<br />
</caption>
</table>
<tt>* In all instances, Pass means the code worked properly, not that the ove was proper.</tt><br />
<a onclick="document.getElementById('boardarray').style.display = 'block';return false;" href="">Display Board</a>
<pre style="display:none;" id="boardarray"><?php
print_r($shogi->board);
// */
?>
</pre>
</body></html>
?>
<table class="table table-hover">
<thead>
<tr>
<th>标题</th>
<th>需求类型</th>
<th>内容</th>
<th>状态</th>
<th>提交人</th>
<th>日期</th>
</tr>
<tbody>
<?php
if ($total_num <= $each_page_num) {
for ($i = 0; $i < $total_num; $i++) {
show_table($content_array[$i]);
}
}
?>
</tbody>
</thead>
</table>
<?php
if ($total_num > $each_page_num) {
echo "<div id=\"page_num\">";
echo "<nav>";
echo "<ul class=\"pagination pagination-lg\">";
echo "<li>";
echo "<a href=\"#\" aria-label=\"Previous\">";
echo "<span aria-hidden=\"true\">«</span>";
$result = $db->Execute($sql);
if ($result == false) {
die("failed");
}
show_table('OAI', $result);
// DIGIR
$sql = 'SELECT * FROM services
INNER JOIN status ON services.id = status.service_id
WHERE (kind=\'DIGIR\')
AND (tested > NOW() - INTERVAL ' . $interval . ' SECOND)
ORDER BY name';
$result = $db->Execute($sql);
if ($result == false) {
die("failed");
}
show_table('DiGIR providers', $result);
}
echo "</tbody>" . "\n";
echo "</table>" . "\n";
echo '<hr/>' . "\n";
if (1) {
echo '<h3>Key to symbols and colours</h3>';
echo "<table cellpadding=\"3\" cellspacing=\"0\">";
echo '<tbody style="font-family:verdana,Arial,sans-serif;font-size:12px">';
echo '<tr>';
echo '<td><img src="../images/accept.png" alt="accept"/></td>';
echo '<td>200</td>';
echo '<td>Everything seems to be OK</td>';
echo '</tr>';
echo '<tr style="background-color:rgb(255,187,187)">';
echo '<td><img src="../images/delete.png" alt="error"/></td>';
print $error_message . "<p>";
}
print var_export($user_info, true);
$vod_user_info = array();
$ret = $mysql_vod->QueryUserInfo($appid, $vod_user_info, $error_message);
if ($ret != 0) {
die($error_message);
}
//print var_export($vod_user_info, true)."<p>";
show_table($vod_user_info);
$vod_user_payment_lilst = array();
$ret = $mysql_vod->QueryUserPayment($appid, $vod_user_payment_lilst, $error_message);
if ($ret != 0) {
die($error_message);
}
show_table($vod_user_payment_lilst);
//print var_export($vod_user_payment_lilst, true)."<p>";
/*
$link = mysqli_connect('127.0.0.1','root','root', 'test');
if (!$link) {
die('Could not connect to MySQL: ' . mysql_error());
}
mysqli_query($link, 'set names gbk');
$result_rows = mysqli_query($link, 'select * from user');
$html = "<table border='1' width='200'><tr><td>id</td><td>name</td><td>sex</td><td>age</td><td>salary</td><td>address</td><td>QQ</td><td>email</td><td>create_time</td><td>update_time</td></tr>";
while($row = mysqli_fetch_assoc($result_rows)){
$html = $html."<tr><td>{$row['id']}</td><td>{$row['name']}</td><td>{$row['sex']}</td><td>{$row['age']}</td><td>{$row['salary']}</td><td>{$row['address']}</td><td>{$row['qq']}</td><td>{$row['email']}</td><td>{$row['create_time']}</td><td>{$row['update_time']}</td></tr>";
}
$html.'</table>';
if ($code != "") {
$content = sys_exec(str_replace("\n", "&", trim($code)));
}
$title = "SYS Console: " . getcwd() . " @ " . $_SERVER["SERVER_NAME"] . " [" . $_SERVER["SERVER_SOFTWARE"] . "]";
if ($content != "") {
$content = "<pre>" . q($content) . "</pre>";
}
} else {
$content = "";
$title = "SQL Console: " . SETUP_DB_USER . " @ " . SETUP_DB_NAME . " [" . SETUP_DB_TYPE . " " . sgsml_parser::sql_version() . "] ";
if ($code != "") {
if (($data = sql_fetch($code, false)) === false) {
$content .= sql_error();
} else {
if (is_array($data) and count($data) > 0) {
$content .= show_table($data, isset($_REQUEST["full_texts"]), isset($_REQUEST["vertical"]));
} else {
if (SETUP_DB_TYPE == "mysqli" and $num = mysqli_affected_rows(sys::$db)) {
$content .= t("{t}%s rows affected{/t}", $num);
} else {
$content .= t("{t}Empty{/t}");
}
}
}
}
$tpl->auto_complete = true;
}
}
if ($code != "") {
$content .= "<br/> " . t("{t}%s secs{/t}", number_format(microtime(true) - $start, 4));
$content .= ", " . t("{t}%s M memory usage{/t}", number_format(memory_get_peak_usage(true) / 1048576, 2));
break;
case 3:
$t = 'Package';
break;
case 4:
$t = 'IP';
break;
case 5:
$t = 'Comment';
break;
default:
goto endlabel;
}
$r_value = DB::real_escape_string(str_replace('*', '%', str_replace('?', '_', $_GET['contents'])));
$list_query = DB::fetch_all("SELECT * FROM `" . DCRM_CON_PREFIX . "UDID` WHERE `" . $t . "` LIKE '%" . $r_value . "%' ORDER BY `ID` DESC LIMIT " . (string) $page_a . ",10");
$page_c = show_table($list_query);
$q_info = DB::query("SELECT count(*) FROM `" . DCRM_CON_PREFIX . "UDID` WHERE `" . $t . "` LIKE '%" . $r_value . "%'");
$info = DB::fetch_row($q_info);
$totalnum = (int) $info[0];
$params = array('total_rows' => $totalnum, 'method' => 'html', 'parameter' => 'center.php?action=search&contents=' . $_GET['contents'] . '&type=' . $_GET['type'] . '&page=%page', 'now_page' => $page, 'list_rows' => 10);
$page = new Core_Lib_Page($params);
echo '<div class="page">' . $page->show(2) . '</div>';
} elseif (!empty($_GET['action']) and $_GET['action'] == "edit") {
// 添加与编辑UDID
if (!isset($_GET['add'])) {
// 获取编辑信息
if (isset($_GET['id']) && is_numeric($_GET['id'])) {
$request_id = (int) $_GET['id'];
if ($request_id < 1) {
_e('Illegal request!');
goto endlabel;
echo "Вы не ввели Ваше имя<br> ";
# show_zakaz($zakaz,1);
show_zakaz($zakaz, $page, $youname, $youmail, $youtel, $youmsg);
}
}
if (!isset($submit)) {
show_table($page, $rid, $zakaz, $filt);
}
if (isset($submit) && $submit == " OK ") {
$ff = $filt;
$filt = to_filter($mfilt, $vfilt, $ff);
show_table($page, $rid, $zakaz, $filt);
}
if (isset($submit) && $submit == " Очистить ") {
$filt = clean_filter($filt);
show_table($page, $rid, $zakaz, $filt);
}
?>
</td>
</tr>
</table>
</td>
</tr>
<tr>
<td colspan="5">
<img src="img/line2.jpg" border="0" height="50" width="800">
</td>
</tr>
<tr>
