aboutsummaryrefslogtreecommitdiffstats
path: root/toj
diff options
context:
space:
mode:
Diffstat (limited to 'toj')
-rwxr-xr-xtoj/index.html85
-rwxr-xr-xtoj/jcs/common.js183
-rwxr-xr-xtoj/jcs/index.js4
-rwxr-xr-xtoj/jcs/pro.js2
-rwxr-xr-xtoj/jcs/stat.css2
-rwxr-xr-xtoj/jcs/stat.js68
-rwxr-xr-xtoj/jcs/user.css57
-rwxr-xr-xtoj/jcs/user.js191
-rwxr-xr-xtoj/php/common.inc.php3
-rwxr-xr-xtoj/php/sqlib_scoreboard.inc.php6
-rwxr-xr-xtoj/php/square.inc.php14
-rwxr-xr-xtoj/php/square.php24
-rwxr-xr-xtoj/php/status.inc.php10
-rwxr-xr-xtoj/php/user.inc.php51
-rwxr-xr-xtoj/php/user.php7
-rwxr-xr-xtoj/sqmod/sqmod_contest/sqmod_contest.css116
-rwxr-xr-xtoj/sqmod/sqmod_contest/sqmod_contest.html39
-rwxr-xr-xtoj/sqmod/sqmod_contest/sqmod_contest.inc.php289
-rwxr-xr-xtoj/sqmod/sqmod_contest/sqmod_contest.js425
-rwxr-xr-xtoj/sqmod/sqmod_contest/sqmod_contest.php123
-rwxr-xr-xtoj/sqmod/sqmod_contest/team.inc.php37
-rwxr-xr-x[-rw-r--r--]toj/sqmod/sqmod_test/sqmod_test.inc.php104
-rwxr-xr-xtoj/sqmod/sqmod_test/sqmod_test.js8
-rwxr-xr-xtoj/sqmod/sqmod_test/sqmod_test.php6
-rwxr-xr-xtoj/sqmod/sqmod_test/sqmod_test_man.php174
-rwxr-xr-x[-rw-r--r--]toj/sqmod/sqmod_test/team.inc.php0
26 files changed, 1685 insertions, 343 deletions
diff --git a/toj/index.html b/toj/index.html
index 11a7a97..8f68a8b 100755
--- a/toj/index.html
+++ b/toj/index.html
@@ -6,8 +6,8 @@
<link href='http://fonts.googleapis.com/css?family=Droid+Sans' rel='stylesheet' type='text/css'>
-<link rel="stylesheet" href="/codemirror.css">
-<link rel="stylesheet" href="/lesser-dark.css">
+<link rel="stylesheet" type="text/css" href="/codemirror.css">
+<link rel="stylesheet" type="text/css" href="/lesser-dark.css">
<link rel="stylesheet" type="text/css" href="/toj/jcs/common.css">
<link rel="stylesheet" type="text/css" href="/toj/jcs/index.css">
@@ -18,8 +18,9 @@
<link rel="stylesheet" type="text/css" href="/toj/jcs/sq.css">
<link rel="stylesheet" type="text/css" href="/toj/jcs/pro.css">
-<script src="/jquery-1.9.1.min.js"></script>
-<script src="/jquery.easing.1.3.js"></script>
+<script type="text/javascript" src="/jquery-1.9.1.min.js"></script>
+<script type="text/javascript" src="/jquery.easing.1.3.js"></script>
+<script type="text/javascript" src="https://www.google.com/jsapi"></script>
<script type="text/javascript" src="/codemirror.js"></script>
<script type="text/javascript" src="/clike.js"></script>
<script type="text/javascript" src="http://cdn.mathjax.org/mathjax/latest/MathJax.js?config=TeX-AMS-MML_HTMLorMML"></script>
@@ -87,13 +88,25 @@ a:hover{
color:#E9E9E9;
text-decoration:underline;
}
-input,select{
+input{
+ height:32px;
font-size:16px;
font-family:'Roboto','LiHei Pro','微軟正黑體';
+ padding:0px 6px 0px 6px;
+ border-width:0px;
+ display:block;
+}
+select{
+ height:32px;
+ font-size:16px;
+ font-family:'Roboto','LiHei Pro','微軟正黑體';
+ border-width:0px;
+ display:block;
}
</style>
<script type="text/javascript">
+ google.load("visualization","1",{packages:["corechart"]});
$(document).ready(function(){
com.init();
user.init();
@@ -157,7 +170,7 @@ input,select{
<div class="com_pbox none_pbox">
<div style="margin:192px 0px 0px 246px;">
- <h1>Oops! 此頁不存在</h1>
+ <h1>Oops! 此頁不存在或權限不足</h1>
<a href="/toj/home/" style="margin-left:6px; color:#E9E9E9;">回首頁</a>
</div>
</div>
@@ -167,13 +180,17 @@ input,select{
<div class="subset">
<table class="filter">
<tr class="head">
- <th class="key"><h3>過濾器</h3></th>
+ <th class="key"><strong>過濾器</strong></th>
<th class="value"><button class="clear">清除</button></th>
</tr>
<tr class="item uid">
<td class="key">UID</td>
<td class="value">None</td>
</tr>
+ <tr class="item proid">
+ <td class="key">ProID</td>
+ <td class="value"><input type="textbox" value="None"></td>
+ </tr>
<tr class="item result">
<td class="key">Result</td>
<td class="value">
@@ -216,11 +233,29 @@ input,select{
</div>
<div class="data_box">
<button class="looksub">查看動態</button>
+ <h2>統計</h2>
+ <div class="statis">
+ <div class="subpie chart_box">
+ <div class="title">上傳次數</div>
+ <div class="chart"></div>
+ </div>
+ <div class="trypie chart_box">
+ <div class="title">嘗試題目</div>
+ <div class="chart"></div>
+ </div>
+ <div class="timecombo chart_box">
+ <div class="title">時間</div>
+ <div class="chart"></div>
+ </div>
+ <div style="clear:both"></div>
+ </div>
+ <h2>已嘗試題目</h2>
+ <div class="trylist"></div>
</div>
</div>
<div class="com_pbox edit_pbox">
<div class="edit_box">
- <h1>個人資料</h1>
+ <h2>個人資料</h2>
<label>暱稱</label>
<input name="nickname" type="textbox">
<label>照片</label>
@@ -231,7 +266,7 @@ input,select{
<label>電子郵件</label>
<input name="email" type="textbox"><br>
- <h1>重設密碼</h1>
+ <h2>重設密碼</h2>
<label>舊使用者密碼</label>
<input name="password_old" type="password">
<label>新使用者密碼</label>
@@ -246,29 +281,29 @@ input,select{
</div>
<div class="com_pbox mgsq_pbox">
<div class="in_box">
- <h1>已加入方塊</h1>
- <h2>等待中</h2>
+ <h2>已加入方塊</h2>
+ <h3>等待中</h3>
<div class="wait"></div><br>
- <h2>進行中</h2>
+ <h3>進行中</h3>
<div class="run"></div><br>
- <h2>已結束</h2>
+ <h3>已結束</h3>
<div class="past"></div>
</div>
<div class="out_box">
- <h1>未加入方塊</h1>
- <h2>等待中</h2>
+ <h2>未加入方塊</h2>
+ <h3>等待中</h3>
<div class="wait"></div><br>
- <h2>進行中</h2>
+ <h3>進行中</h3>
<div class="run"></div><br>
- <h2>已結束</h2>
+ <h3>已結束</h3>
<div class="past"></div>
</div>
</div>
<div class="com_pbox mg_pbox">
<div class="left_box">
- <h1>方塊</h1>
+ <h2>方塊</h2>
<button class="newsq">建立方塊</button>
- <h1>題目</h1>
+ <h2>題目</h2>
<button class="newpro">建立題目</button>
<table class="prolist">
<tr class="head">
@@ -325,7 +360,7 @@ input,select{
<div class="user_mask">
<div class="com_mbox editsq_mbox">
<div class="edit_box">
- <h1>基本資料</h1>
+ <h2>基本資料</h2>
<label>方塊名稱</label>
<input name="sqname" type="textbox" size="16" placeholder="foo">
<label>模組名稱</label>
@@ -362,11 +397,11 @@ input,select{
<button class="delete" style="display:none;">刪除</button>
</div>
<div class="pro_box">
- <h1>已加入題目</h1>
+ <h2>已加入題目</h2>
<div class="prolist_box">
<table class="prolist prolist_in"></table>
</div>
- <h1>未加入題目</h1>
+ <h2>未加入題目</h2>
<div class="prolist_box">
<table class="prolist prolist_out"></table>
</div>
@@ -375,7 +410,7 @@ input,select{
</div>
<div class="com_mbox editpro_mbox">
<div class="edit_box">
- <h1>基本資料</h1>
+ <h2>基本資料</h2>
<label>題目名稱</label>
<input name="name" type="textbox" size="16" placeholder="foo">
<label>模組ID</label>
@@ -386,7 +421,7 @@ input,select{
<option value=2>隱藏</option>
</select>
<div class="update" style="display:none;">
- <h1>更新題目</h1>
+ <h2>更新題目</h2>
<span class="cacheid"></span><br><br>
<button class="update">更新</button>
<button class="rejudge">重測</button>
@@ -405,7 +440,7 @@ input,select{
<div class="title"></div>
<div class="error"></div>
<div class="oper">
- <select name="lang">
+ <select name="lang" style="display:inline-block;">
<option value="1">C++</option>
</select>
<button class="submit">確定</button>
diff --git a/toj/jcs/common.js b/toj/jcs/common.js
index de5a707..6d4f0d3 100755
--- a/toj/jcs/common.js
+++ b/toj/jcs/common.js
@@ -1,4 +1,5 @@
var RESULTMAP = {0:'AC',1:'WA',2:'TLE',3:'MLE',4:'RF',5:'RE',6:'CE',7:'ERR',100:'WAIT'};
+var RESULTCOLOR = {0:'#00FF00',1:'#FF0000',2:'#FFFFFF',3:'#FFFFFF',4:'#FFFFFF',5:'#FFFFFF',6:'#FFFFFF',7:'#FFFFFF',100:'#FFFFFF'};
var USER_PER_USER = 0x00000001;
var USER_PER_PROCREATOR = 0x00000002;
@@ -90,7 +91,7 @@ var com = new function(){
that.url_curr = null;
that.url_prev = null;
that.url_back = null;
- that.pbox_exist = false;
+ that.url_pbox = null;
that.init = function(){
var i;
@@ -155,23 +156,21 @@ var com = new function(){
window.history.replaceState(null,document.title,url);
that.url_chg();
};
- that.url_pull = function(){
- that.url_update(that.url_back);
+ that.url_pull_pbox = function(){
+ that.url_update(that.url_pbox);
//window.history.back();
};
that.url_chg = function(){
var i;
- var j;
var ret;
- var len;
var stop_flag;
var url_old;
var url_new;
var url_cpart;
var url_ppart;
- var is_mbox_prev;
- var is_mbox_curr;
+ var is_mbox_old;
+ var is_mbox_new;
var url_upart;
var url_dpart;
@@ -179,7 +178,50 @@ var com = new function(){
var node_parent;
var node_bottom;
+ var _chg_out = function(url_ppart,url_cpart){
+ var i;
+ var len;
+
+ var url_upart;
+ var url_dpart;
+ var node_curr;
+ var node_parent;
+ var node_bottom;
+
+ len = Math.min(url_ppart.length,url_cpart.length);
+ node_bottom = that.vus_root;
+ node_curr = node_bottom;
+ for(i = 0;i < len;i++){
+ if(url_ppart[i] != url_cpart[i]){
+ break;
+ }
+ if((node_curr = node_curr.child[url_ppart[i]]) == undefined){
+ break;
+ }
+ node_bottom = node_curr;
+ }
+ if(node_curr != undefined){
+ for(;i < url_ppart.length;i++){
+ if(node_curr.child[url_ppart[i]] == undefined){
+ break;
+ }
+ node_curr = node_curr.child[url_ppart[i]];
+ }
+
+ url_upart = url_ppart.slice(0);
+ url_dpart = new Array;
+ while(node_curr != node_bottom){
+ node_parent = node_curr.parent;
+ node_curr.url_chg('out',url_upart,url_dpart);
+ url_dpart = url_dpart.splice(0,0,url_upart.pop());
+ node_curr = node_parent;
+ }
+ }
+
+ return node_bottom;
+ };
var _chg_in = function(url_cpart,idx,node_curr,url_upart,url_dpart){
+ var node_parent;
var delay_obj;
for(;idx < url_cpart.length;idx++){
@@ -188,9 +230,9 @@ var com = new function(){
if((delay_obj = node_parent.delay_child[url_cpart[idx]]) == undefined){
that.url_update('/toj/none/');
}else{
- delay_obj.url_curr = that.url_curr;
+ delay_obj.url_curr = url_new;
delay_obj.defer.done(function(){
- if(that.url_curr == delay_obj.url_curr){
+ if(url_new == delay_obj.url_curr){
_chg_in(url_cpart,idx,node_parent,url_upart,url_dpart);
}
});
@@ -221,66 +263,44 @@ var com = new function(){
arguments.callee.hasnext = false;
url_old = that.url_prev;
- url_new = that.url_new;
+ url_new = that.url_curr;
- url_cpart = that.url_curr.match(/toj\/(.*)/)[1].split('/');
+ url_cpart = url_new.match(/toj\/(.*)/)[1].split('/');
url_cpart.pop();
if(url_cpart.length == 0){
that.url_update('/toj/home/');
continue;
}
- if(that.url_prev == null){
- is_mbox_prev = false;
+ if(url_old == null){
+ is_mbox_old = false;
}else{
- is_mbox_prev = check_mbox_url(that.url_prev);
+ is_mbox_old = check_mbox_url(url_old);
}
- is_mbox_curr = check_mbox_url(that.url_curr);
+ is_mbox_new = check_mbox_url(url_new);
- stop_flag = false;
- if(that.url_prev == null || (is_mbox_prev == false && is_mbox_curr == true)){
- i = 0;
- node_curr = that.vus_root;
- url_upart = new Array;
- url_dpart = url_cpart.slice(0);
+ if(url_old == null || (is_mbox_old == false && is_mbox_new == true)){
+ node_bottom = that.vus_root;
+ }else if(that.url_pbox != null && is_mbox_old == true && is_mbox_new == false){
+ url_ppart = that.url_pbox.match(/toj\/(.*)/)[1].split('/');
+ url_ppart.pop();
+ node_bottom = _chg_out(url_ppart,url_cpart);
}else{
- url_ppart = that.url_prev.match(/toj\/(.*)/)[1].split('/');
+ url_ppart = url_old.match(/toj\/(.*)/)[1].split('/');
url_ppart.pop();
-
- len = Math.min(url_ppart.length,url_cpart.length);
- node_bottom = that.vus_root;
- node_curr = node_bottom;
- for(i = 0;i < len;i++){
- if(url_ppart[i] != url_cpart[i]){
- break;
- }
- if((node_curr = node_curr.child[url_ppart[i]]) == undefined){
- break;
- }
- node_bottom = node_curr;
- }
- if(node_curr != undefined){
- for(;i < url_ppart.length;i++){
- if(node_curr.child[url_ppart[i]] == undefined){
- break;
- }
- node_curr = node_curr.child[url_ppart[i]];
- }
+ node_bottom = _chg_out(url_ppart,url_cpart);
+ }
- url_upart = url_ppart.slice(0);
- url_dpart = new Array;
- while(node_curr != node_bottom){
- node_parent = node_curr.parent;
- node_curr.url_chg('out',url_upart,url_dpart);
- url_dpart = url_dpart.splice(0,0,url_upart.pop());
- node_curr = node_parent;
- }
- }
+ if(url_old != null && is_mbox_old == false && is_mbox_new == false){
+ index.page_scroll_reset();
+ }
+ if(url_new != that.url_pbox){
i = 0;
node_curr = that.vus_root;
url_upart = new Array;
url_dpart = url_cpart.slice(0);
+ stop_flag = false;
while(node_curr != node_bottom){
if((node_curr = node_curr.child[url_cpart[i]]) == undefined){
break;
@@ -293,19 +313,23 @@ var com = new function(){
}
i++;
}
+ if(stop_flag == false){
+ _chg_in(url_cpart,i,node_curr,url_upart,url_dpart);
+ }
}
- if(that.url_prev != null && is_mbox_prev == false && is_mbox_curr == false){
- index.page_scroll_reset();
- }
- if(stop_flag == false && (that.url_prev == null || that.pbox_exist == false || !(is_mbox_prev == true && is_mbox_curr == false))){
- _chg_in(url_cpart,i,node_curr,url_upart,url_dpart);
+ if(that.url_pbox != null && is_mbox_old == true && is_mbox_new == false){
+ url_ppart = url_old.match(/toj\/(.*)/)[1].split('/');
+ url_ppart.pop();
+ _chg_out(url_ppart,url_cpart);
}
- if(that.pbox_exist == false && is_mbox_curr == false){
- that.pbox_exist = true;
- $('#index_mask').removeClass('index_mask_nopbox');
- $('#index_mask').addClass('index_mask');
+ if(is_mbox_new == false){
+ if(that.url_pbox == null){
+ $('#index_mask').removeClass('index_mask_nopbox');
+ $('#index_mask').addClass('index_mask');
+ }
+ that.url_pbox = url_new;
}
}
@@ -393,6 +417,45 @@ var com = new function(){
return date.getFullYear() + '-' + month + '-' + day + ' ' + hr + ':' + min;
}
};
+ that.get_durstring = function(duration,secflag){
+ var sec;
+ var min;
+ var hr;
+ var day;
+
+ duration = Math.floor(duration / 1000);
+
+ sec = duration % 60;
+ duration = Math.floor(duration / 60);
+ if(sec < 10){
+ sec = '0' + sec;
+ }
+
+ min = duration % 60;
+ duration = Math.floor(duration / 60);
+ if(min < 10){
+ min = '0' + min;
+ }
+
+ hr = duration % 24;
+ duration = Math.floor(duration / 24);
+ if(hr < 10){
+ hr = '0' + hr;
+ }
+
+ day = duration;
+ if(day == 0){
+ day = '';
+ }else{
+ day = day + ':';
+ }
+
+ if(secflag == true){
+ return day + hr + ':' + min + ':' + sec;
+ }else{
+ return day + hr + ':' + min;
+ }
+ };
that.get_lang = function(value){
var i;
var ret;
diff --git a/toj/jcs/index.js b/toj/jcs/index.js
index 102d067..1d90756 100755
--- a/toj/jcs/index.js
+++ b/toj/jcs/index.js
@@ -62,11 +62,11 @@ var index = new function(){
$('#index_mask').on('click',function(e){
if((e.target == this || e.target.parentNode == this) && $(this).hasClass('index_mask')){
- com.url_pull();
+ com.url_pull_pbox();
}
});
$('#index_mask > button.close').on('click',function(e){
- com.url_pull();
+ com.url_pull_pbox();
});
};
diff --git a/toj/jcs/pro.js b/toj/jcs/pro.js
index ee28217..b2ea9ba 100755
--- a/toj/jcs/pro.js
+++ b/toj/jcs/pro.js
@@ -151,7 +151,7 @@ var class_pro_sub_mbox = function(){
j_error.text('其他錯誤');
}
}else{
- com.url_pull();
+ com.url_pull_pbox();
}
});
});
diff --git a/toj/jcs/stat.css b/toj/jcs/stat.css
index 3293a98..88a465c 100755
--- a/toj/jcs/stat.css
+++ b/toj/jcs/stat.css
@@ -12,7 +12,7 @@ div.stat_page > div.sub_pbox > div.subset > table.filter tr.head{
height:64px;
}
div.stat_page > div.sub_pbox > div.subset > table.filter tr.item{
- height:32px;
+ height:38px;
}
div.stat_page > div.sub_pbox > div.subset > table.filter th.key,div.stat_page > div.sub_pbox > div.subset > table.filter td.key{
width:76px;
diff --git a/toj/jcs/stat.js b/toj/jcs/stat.js
index 046c27f..95ec06a 100755
--- a/toj/jcs/stat.js
+++ b/toj/jcs/stat.js
@@ -110,13 +110,14 @@ var stat = new function(){
$.post('/toj/php/status.php',{'action':'get_by_subid','data':JSON.stringify({'subid':that.sub_subid})},function(res){
var reto;
- if(res[0] != 'E'){
+ if(res[0] == 'E'){
+ com.url_update('/toj/none/');
+ }else{
reto = JSON.parse(res);
subid_node.smodname = reto.smodname;
reto.submit_time = com.get_date(reto.submit_time);
delete reto.smodname;
-
css = $('<link rel="stylesheet" type="text/css" href="/toj/smod/' + subid_node.smodname + '/' + subid_node.smodname + '.css">');
$('head').append(css);
css.ready(function(){
@@ -143,7 +144,7 @@ var stat = new function(){
j_button = $('<button style="margin:6px 0px 0px 6px; float:right;">重測</button>');
j_button.on('click',function(e){
$.post('/toj/php/status.php',{'action':'rejudge_submit','data':JSON.stringify({'subid':that.sub_subid})});
- com.url_pull();
+ com.url_pull_pbox();
});
j_subres_mbox.prepend(j_button);
}
@@ -155,8 +156,6 @@ var stat = new function(){
});
});
});
- }else{
- com.url_update('/toj/none/');
}
});
}
@@ -233,7 +232,7 @@ var class_stat_sub_pbox = function(pbox_name){
}
j_ajax = $.post('/toj/php/status.php',{'action':'get_submit',
'data':JSON.stringify({
- 'filter':{'uid':filter.uid,'result':filter.result,'proid':null,'lang':null},
+ 'filter':{'uid':filter.uid,'result':filter.result,'proid':filter.proid,'lang':null},
'sort':{'score':null,'runtime':null,'memory':null,'subid':[1,0]},
'wait':10,
'count':100,
@@ -292,7 +291,7 @@ var class_stat_sub_pbox = function(pbox_name){
down_block = true;
$.post('/toj/php/status.php',{'action':'get_submit',
'data':JSON.stringify({
- 'filter':{'uid':filter.uid,'result':filter.result,'proid':null,'lang':null},
+ 'filter':{'uid':filter.uid,'result':filter.result,'proid':filter.proid,'lang':null},
'sort':{'score':null,'runtime':null,'memory':null,'subid':[0,esubid]},
'wait':0,
'count':50,
@@ -363,11 +362,15 @@ var class_stat_sub_pbox = function(pbox_name){
ret = '';
if(filter.uid != null){
- ret += 'uid:' + filter.uid;
+ ret += 'uid:' + filter.uid + ':';
+ }
+ if(filter.proid != null){
+ ret += 'proid:' + filter.proid + ':';
}
if(filter.result != null){
- ret += 'result:' + filter.result;
+ ret += 'result:' + filter.result + ':';
}
+ ret = ret.slice(0,-1);
return ret;
};
@@ -379,11 +382,14 @@ var class_stat_sub_pbox = function(pbox_name){
that.node.url_chg = function(direct,url_upart,url_dpart){
var i;
var filter_part;
+ var key;
+ var value;
var _clear = function(){
$(window).off('scorll');
j_filter.find('tr.uid > td.value').text('None');
- j_filter.find('tr.result select').val(null);
+ j_filter.find('tr.proid input').val('None');
+ j_filter.find('tr.result select').val('null');
j_table.find('tr.item').remove();
if(j_ajax != null){
@@ -413,14 +419,20 @@ var class_stat_sub_pbox = function(pbox_name){
refresh_flag = true;
filter.uid = null;
+ filter.proid = null;
filter.result = null;
if(url_dpart[0] != undefined){
filter_part = url_dpart[0].split(':');
for(i = 0;i < filter_part.length;i += 2){
- if(filter_part[i] == 'uid'){
- filter.uid = parseInt(filter_part[i + 1]);
- }else if(filter_part[i] == 'result'){
- filter.result = parseInt(filter_part[i + 1]);
+ key = filter_part[i];
+ value = filter_part[i + 1];
+
+ if(key == 'uid'){
+ filter.uid = parseInt(value);
+ }else if(key == 'proid'){
+ filter.proid = parseInt(value);
+ }else if(key == 'result'){
+ filter.result = parseInt(value);
}
}
}
@@ -428,6 +440,9 @@ var class_stat_sub_pbox = function(pbox_name){
if(filter.uid != null){
j_filter.find('tr.uid > td.value').text(filter.uid);
}
+ if(filter.proid != null){
+ j_filter.find('tr.proid input').val(filter.proid);
+ }
if(filter.result != null){
j_filter.find('tr.result select').val(filter.result);
}
@@ -442,6 +457,31 @@ var class_stat_sub_pbox = function(pbox_name){
return 'stop';
};
+ j_pbox.find('div.subset > table.filter tr.proid input').on('focusin',function(e){
+ if($(this).val() == 'None'){
+ $(this).val('');
+ }
+ }).on('focusout',function(e){
+ if($(this).val() == ''){
+ $(this).val('None');
+ }
+ }).on('keypress',function(e){
+ var param;
+
+ if(e.which != 13){
+ return;
+ }
+
+ if((filter.proid = $(this).val()) == 'None'){
+ filter.proid = null;
+ }
+ console.log(filter.proid);
+ if((param = filter_getparam()) != ''){
+ com.url_push('/toj/stat/sub/' + param + '/');
+ }else{
+ com.url_push('/toj/stat/sub/');
+ }
+ });
j_pbox.find('div.subset > table.filter tr.result select').on('change',function(e){
var param;
diff --git a/toj/jcs/user.css b/toj/jcs/user.css
index 37dd3f7..a99f8c9 100755
--- a/toj/jcs/user.css
+++ b/toj/jcs/user.css
@@ -26,6 +26,44 @@ div.user_page > div.main_pbox > div.data_box{
padding:32px 0px 32px 0px;
float:left;
}
+div.user_page > div.main_pbox > div.data_box > div.statis > div.chart_box{
+ width:322px;
+ height:240px;
+ margin:0px 6px 6px 0px;
+ background-color:#1C1C1C;
+ float:left;
+ position:relative;
+}
+div.user_page > div.main_pbox > div.data_box > div.statis > div.chart_box > div.title{
+ position:absolute;
+ top:6px;
+ left:6px;
+ z-index:1
+}
+div.user_page > div.main_pbox > div.data_box > div.statis > div.chart_box > div.chart{
+ width:100%;
+ height:100%;
+ position:absolute;
+ top:0px;
+ left:0px;
+ z-index:0
+}
+div.user_page > div.main_pbox > div.data_box > div.statis > div.timecombo{
+ width:978px;
+ height:240px;
+}
+div.user_page > div.main_pbox > div.data_box > div.trylist > span.item{
+ width:35px;
+ height:24px;
+ margin:0px 6px 6px 0px;
+ line-height:24px;
+ background-color:#1C1C1C;
+ display:inline-block;
+}
+div.user_page > div.main_pbox > div.data_box > div.trylist > span.item > a{
+ padding:0px 0px 0px 3px;
+ font-size:12px;
+}
div.user_page > div.edit_pbox > div.edit_box{
width:240px;
margin:0px 0px 0px 246px;
@@ -42,11 +80,7 @@ div.user_page > div.edit_pbox > div.edit_box > div.error{
}
div.user_page > div.edit_pbox > div.edit_box input{
width:228px;
- height:32px;
margin:0px 0px 16px 0px;
- padding:0px 6px 0px 6px;
- border-width:0px;
- display:block;
}
div.user_page > div.mgsq_pbox > div.in_box{
width:486px;
@@ -130,11 +164,7 @@ div.user_mask > div.editsq_mbox > div.edit_box > div.error{
}
div.user_mask > div.editsq_mbox > div.edit_box input{
width:146px;
- height:32px;
margin:0px 0px 16px 0px;
- padding:0px 6px 0px 6px;
- border-width:0px;
- display:block;
}
div.user_mask > div.editsq_mbox > div.edit_box > div.time > input{
width:35px;
@@ -143,8 +173,6 @@ div.user_mask > div.editsq_mbox > div.edit_box select{
width:76px;
height:32px;
margin:0px 0px 16px 0px;
- border-width:0px;
- display:block;
}
div.user_mask > div.editsq_mbox > div.pro_box{
width:404px;
@@ -188,9 +216,6 @@ div.user_mask > div.editpro_mbox > div.edit_box input{
width:146px;
height:32px;
margin:0px 0px 16px 0px;
- padding:0px 6px 0px 6px;
- border-width:0px;
- display:block;
}
div.user_mask > div.editpro_mbox > div.edit_box select{
width:76px;
@@ -219,9 +244,6 @@ div.login_pbox > div.login_box > input{
width:228px;
height:32px;
margin:0px 0px 16px 0px;
- padding:0px 6px 0px 6px;
- border-width:0px;
- display:block;
}
div.register_pbox > div.info_box{
@@ -243,7 +265,4 @@ div.register_pbox > div.register_box > input{
width:228px;
height:32px;
margin:0px 0px 16px 0px;
- padding:0px 6px 0px 6px;
- border-width:0px;
- display:block;
}
diff --git a/toj/jcs/user.js b/toj/jcs/user.js
index 1a45a32..4aa7252 100755
--- a/toj/jcs/user.js
+++ b/toj/jcs/user.js
@@ -181,7 +181,7 @@ var user = new function(){
'data':{'action':'view','data':JSON.stringify({'uid':null})},
'async':!sync,
'success':function(res){
- var reto;
+ var usero;
var old_uid;
old_uid = that.uid;
@@ -197,14 +197,14 @@ var user = new function(){
that.login_chg.fire(false);
}else{
- reto = JSON.parse(res);
- that.uid = reto.uid;
- that.level = reto.level;
- that.username = reto.username;
- that.nickname = reto.nickname;
- that.avatar = reto.avatar;
- that.aboutme = reto.aboutme;
- that.email = reto.email;
+ usero = JSON.parse(res).user;
+ that.uid = usero.uid;
+ that.level = usero.level;
+ that.username = usero.username;
+ that.nickname = usero.nickname;
+ that.avatar = usero.avatar;
+ that.aboutme = usero.aboutme;
+ that.email = usero.email;
if(old_uid != that.uid){
that.login_chg.fire(true);
@@ -264,20 +264,158 @@ var class_user_main_pbox = function(){
that.fadein(j_pbox);
$.post('/toj/php/user.php',{'action':'view','data':JSON.stringify({'uid':user.view_uid})},function(res){
+ var i;
+
var reto;
+ var usero;
+ var statiso;
+ var trylist;
+ var substatis;
+ var actry;
+ var series;
+ var total;
+
+ var j_div;
+ var j_span;
+ var j_a;
+
+ var pie_add = function(j_div,series){
+ var draw = function(){
+ var data = google.visualization.arrayToDataTable(series);
+ var chart = new google.visualization.PieChart(j_div[0]);
+
+ chart.draw(data,{
+ 'chartArea':{'width':'90%','height':'85%','top':'15%','left':'10%'},
+ 'backgroundColor':'#1C1C1C',
+ 'legend':{
+ 'textStyle':{'color':'#E9E9E9'}
+ },
+ 'pieSliceBorderColor':'#E9E9E9',
+ 'pieSliceText':'value',
+ 'titleTextStyle':{'color':'#E9E9E9','fontSize':'16'}
+ });
+ }
+ if(typeof google === 'object'){
+ draw();
+ }else{
+ google.setOnLoadCallback(draw);
+ }
+ };
+ var combo_add = function(j_div,series){
+ var draw = function(){
+ var data = google.visualization.arrayToDataTable(series);
+ var chart = new google.visualization.ComboChart(j_div[0]);
+
+ chart.draw(data,{
+ 'backgroundColor':'#1C1C1C',
+ 'legend':{
+ 'textStyle':{'color':'#E9E9E9'}
+ },
+ 'titleTextStyle':{'color':'#E9E9E9','fontSize':'16'},
+ 'hAxis':{'textStyle':{'color':'#E9E9E9'},'slantedText':false},
+ 'vAxis':{'textStyle':{'color':'#E9E9E9'}},
+ 'series':{'0':{'type':'bars','targetAxisIndex':0}}
+ });
+ }
+ if(typeof google === 'object'){
+ draw();
+ }else{
+ google.setOnLoadCallback(draw);
+ }
+ };
+ var draw_timeline = function(timesub){
+ var i;
+ var j;
+ var series;
+ var part;
+ var last_time;
+ var curr_time;
+
+ if(timesub.length == 0){
+ return;
+ }
+ series = new Array();
+ series.push(['Time','上傳次數']);
+
+ part = timesub[0].time.split('-');
+ last_time = parseInt(part[0]) * 12 + parseInt(part[1]) + 1;
+
+ series.push([timesub[0].time,timesub[0].count]);
+
+ for(i = 1;i < timesub.length;i++){
+ part = timesub[i].time.split('-');
+ curr_time = parseInt(part[0]) * 12 + parseInt(part[1]);
+
+ for(;last_time < curr_time;last_time++){
+ if((last_time % 6) == 1){
+ series.push([Math.floor(last_time / 12) + '-' + last_time % 12,0]);
+ }else{
+ series.push(['',0]);
+ }
+ }
+
+ if((last_time % 6) == 1){
+ series.push([Math.floor(last_time / 12) + '-' + last_time % 12,timesub[i].count]);
+ }else{
+ series.push(['',timesub[i].count]);
+ }
+
+ last_time = curr_time + 1;
+ }
+
+ combo_add(j_pbox.find('div.data_box > div.statis > div.timecombo > div.chart'),series);
+ };
if(res[0] == 'E'){
com.url_update('/toj/none/');
}else{
reto = JSON.parse(res);
- j_pbox.find('div.info_box > div.name').text(reto.nickname + ' (' + reto.username + ')');
- if(reto.avatar == ''){
+ usero = reto.user;
+ statiso = reto.statis;
+
+ j_pbox.find('div.info_box > div.name').text(usero.nickname + ' (' + usero.username + ')');
+ if(usero.avatar == ''){
j_pbox.find('div.info_box > img.avatar').attr('src','http://i.imgur.com/ykkQD.png');
}else{
- j_pbox.find('div.info_box > img.avatar').attr('src',reto.avatar);
+ j_pbox.find('div.info_box > img.avatar').attr('src',usero.avatar);
+ }
+ j_pbox.find('div.info_box > div.aboutme').text(usero.aboutme);
+
+ j_div = j_pbox.find('div.data_box > div.trylist');
+ trylist = statiso.trylist;
+ actry = 0;
+ for(i = 0;i < trylist.length;i++){
+ j_span = $('<span class="item"><a></a></span>');
+
+ j_a = j_span.find('a');
+ j_a.css('color',RESULTCOLOR[trylist[i].result]);
+ j_a.text(trylist[i].proid);
+ j_a.attr('href','/toj/pro/' + trylist[i].proid + '/');
+
+ j_div.append(j_span);
+
+ if(trylist[i].result == 0){
+ actry++;
+ }
}
- j_pbox.find('div.info_box > div.aboutme').text(reto.aboutme);
+ substatis = statiso.substatis;
+ series = new Array();
+ series[0] = ['Result','Count'];
+ total = 0;
+ for(i = 0;i < substatis.length;i++){
+ series[i + 1] = [RESULTMAP[substatis[i].result],substatis[i].count];
+ }
+
+ pie_add(j_pbox.find('div.data_box > div.statis > div.subpie > div.chart'),series);
+
+ pie_add(j_pbox.find('div.data_box > div.statis > div.trypie > div.chart'),
+ [['Result','Count'],
+ ['AC',actry],
+ ['Failed',statiso.trylist.length - actry]
+ ]);
+
+ draw_timeline(statiso.timesub);
}
});
}else if(direct == 'out'){
@@ -286,6 +424,7 @@ var class_user_main_pbox = function(){
j_pbox.find('div.info_box > div.name').text('');
j_pbox.find('div.info_box > img.avatar').attr('src','');
+ j_pbox.find('div.data_box > div.trylist').empty();
}
};
@@ -849,18 +988,19 @@ var class_user_editsq_mbox = function(){
j++;
pro_listset(j_item,proo,type);
- j_last = j_item;
}else{
j_item = pro_listnew(proo,type);
j_item.hide();
if(j_last == null){
- j_table.append(j_item);
+ j_table.prepend(j_item);
}else{
j_item.insertAfter(j_last);
}
j_item.css('opacity',0).slideDown('fast').fadeTo(100,1);
}
+
+ j_last = j_item;
}
for(;j < trs.length;j++){
j_item = $(trs[j]);
@@ -930,6 +1070,8 @@ var class_user_editsq_mbox = function(){
j_mbox.find('[name="e_min"]').val(sqo.end_time.getMinutes());
}
j_mbox.find('button.delete').show();
+
+ pro_update();
}
com.vus_mbox.child_set(that.node);
@@ -940,7 +1082,6 @@ var class_user_editsq_mbox = function(){
that.node.url_chg = function(direct,url_upart,url_dpart){
if(direct == 'in'){
that.fadein(j_mbox);
- pro_update();
}else if(direct == 'out'){
that.fadeout(j_mbox);
@@ -992,7 +1133,7 @@ var class_user_editsq_mbox = function(){
}
}else{
defer.resolve();
- com.url_pull();
+ com.url_pull_pbox();
}
});
}
@@ -1049,7 +1190,7 @@ var class_user_editsq_mbox = function(){
}
}else{
defer.resolve();
- com.url_pull();
+ com.url_pull_pbox();
}
});
}else if(action == 'edit'){
@@ -1074,13 +1215,13 @@ var class_user_editsq_mbox = function(){
}else{
user.update(false);
defer.resolve();
- com.url_pull();
+ com.url_pull_pbox();
}
});
}
});
j_mbox.find('button.cancel').on('click',function(e){
- com.url_pull();
+ com.url_pull_pbox();
});
}; __extend(class_user_editsq_mbox,class_com_mbox);
var class_user_editpro_mbox = function(){
@@ -1140,13 +1281,13 @@ var class_user_editpro_mbox = function(){
j_mbox.find('button.update').on('click',function(e){
$.post('/toj/php/problem.php',{'action':'update_pro_cache','data':JSON.stringify({'proid':proid})},function(res){
defer.resolve();
- com.url_pull();
+ com.url_pull_pbox();
});
});
j_mbox.find('button.rejudge').on('click',function(e){
$.post('/toj/php/problem.php',{'action':'rejudge_pro','data':JSON.stringify({'proid':proid})},function(res){
defer.resolve();
- com.url_pull();
+ com.url_pull_pbox();
});
});
j_mbox.find('button.submit').on('click',function(e){
@@ -1188,7 +1329,7 @@ var class_user_editpro_mbox = function(){
}
}else{
defer.resolve();
- com.url_pull();
+ com.url_pull_pbox();
}
});
}else if(action == 'edit'){
@@ -1215,13 +1356,13 @@ var class_user_editpro_mbox = function(){
}
}else{
defer.resolve();
- com.url_pull();
+ com.url_pull_pbox();
}
});
}
});
j_mbox.find('button.cancel').on('click',function(e){
- com.url_pull();
+ com.url_pull_pbox();
});
}; __extend(class_user_editpro_mbox,class_com_mbox);
diff --git a/toj/php/common.inc.php b/toj/php/common.inc.php
index 0922c91..18786e9 100755
--- a/toj/php/common.inc.php
+++ b/toj/php/common.inc.php
@@ -2,7 +2,10 @@
date_default_timezone_set('Asia/Taipei');
//error_reporting(E_ALL ^ E_NOTICE);
+//ini_set("display_errors", "On");
+
//error_reporting(0);
+//
require('connect.inc.php');
diff --git a/toj/php/sqlib_scoreboard.inc.php b/toj/php/sqlib_scoreboard.inc.php
index e5e7d66..32bec44 100755
--- a/toj/php/sqlib_scoreboard.inc.php
+++ b/toj/php/sqlib_scoreboard.inc.php
@@ -71,14 +71,14 @@
sqlib_scoreboard::update($sqlc, $msqlc, $sqid, $sboard_id, $score_func, $start_time, $end_time);
//display
- $sqlstr = 'SELECT "a1"."uid", "a1"."rank_score", COUNT(*) AS "rank" FROM "sqlib_scoreboard_main" "a1", "sqlib_scoreboard_main" "a2" WHERE "a1"."sqid"=$1 AND "a1"."sboard_id"=$2 AND "a2"."sqid"=$1 AND "a2"."sboard_id"=$2 AND ("a2"."rank_score">"a1"."rank_score" OR "a2"."uid"="a1"."uid") GROUP BY "a1"."uid", "a1"."rank_score" ORDER BY "a1"."rank_score" DESC, "a1"."uid" LIMIT $4 OFFSET $3;';
- $sqlarr = array($sqid, $sboard_id, $start_offset-1, $number);
+ $sqlstr = 'SELECT "a1"."uid", "a1"."rank_score", COUNT(*) AS "rank" FROM "sqlib_scoreboard_main" "a1", "sqlib_scoreboard_main" "a2" WHERE "a1"."sqid"=$1 AND "a1"."sboard_id"=$2 AND "a2"."sqid"=$1 AND "a2"."sboard_id"=$2 AND ("a2"."rank_score">"a1"."rank_score" OR "a2"."uid"="a1"."uid") GROUP BY "a1"."uid", "a1"."rank_score" ORDER BY "a1"."rank_score" DESC, "a1"."uid" LIMIT $4 OFFSET $3;';
+ $sqlarr = array($sqid, $sboard_id, $start_offset, $number);
if($uid)
{
$sqlstr = 'SELECT "a1"."uid", "a1"."rank_score", COUNT(*) AS "rank" FROM "sqlib_scoreboard_main" "a1", "sqlib_scoreboard_main" "a2" WHERE "a1"."sqid"=$1 AND "a1"."sboard_id"=$2 AND "a1"."uid"=$3 AND "a2"."sqid"=$1 AND "a2"."sboard_id"=$2 AND ("a2"."rank_score">"a1"."rank_score" OR "a2"."uid"="a1"."uid") GROUP BY "a1"."uid", "a1"."rank_score";';
$sqlarr = array($sqid, $sboard_id, $uid);
}
-
+
$res = pg_query_params($msqlc, $sqlstr, $sqlarr);
$arr = pg_fetch_all($res);
diff --git a/toj/php/square.inc.php b/toj/php/square.inc.php
index 4a4b52f..99f0d2e 100755
--- a/toj/php/square.inc.php
+++ b/toj/php/square.inc.php
@@ -226,6 +226,20 @@ class square
}
return $ret;
}
+ public static function get_user_list($sqlc, $sqid)
+ {
+ //get problem list of square $sqid.
+ $sqlstr = 'SELECT "user"."uid", "user"."nickname" FROM "user" INNER JOIN "us_sq" ON "user"."uid"="us_sq"."uid" WHERE "us_sq"."sqid"=$1 ORDER BY "user"."uid";';
+ $sqlarr = array($sqid);
+ $sqlr = pg_query_params($sqlc, $sqlstr, $sqlarr);
+ $ret = array();
+ while($obj = pg_fetch_object($sqlr))
+ {
+ $obj->uid = intval($obj->uid);
+ array_push($ret, $obj);
+ }
+ return $ret;
+ }
}
?>
diff --git a/toj/php/square.php b/toj/php/square.php
index c95c584..fb87741 100755
--- a/toj/php/square.php
+++ b/toj/php/square.php
@@ -2,6 +2,7 @@
//ini_set("display_errors", "On");
require_once('square.inc.php');
+require_once('event.inc.php');
$sqlc = db_connect();
@@ -44,6 +45,9 @@ if($action == 'add_sq')
if(!$res2)
die('Eadd_admin_failed');
+ if(event::exec_func('../sqmod/'.$sq->sqmodname.'/'.$sq->sqmodname.'.inc.php','event_create',[$res->sqid]) === false)
+ die('Eevent_error');
+
echo('S');
}
if($action == 'delete_sq')
@@ -59,13 +63,17 @@ if($action == 'delete_sq')
die('Epermission_denied');
$sqid = intval($sq->sqid);
- if(!square::get($sqlc, $sqid))
- die('Eno_such_sq');
+ $sq = square::get($sqlc, $sqid);
+ if(!$sq)
+ die('Ewrong_sqid');
$res = square::del($sqlc, $sqid);
if(!$res)
die('Edelete_failed');
+ if(event::exec_func('../sqmod/'.$sq->sqmodname.'/'.$sq->sqmodname.'.inc.php','event_destroy',[$sq->sqid]) === false)
+ die('Eevent_error');
+
echo('S');
}
if($action == 'edit_sq')
@@ -313,7 +321,8 @@ if($action == 'add_pro_into_sq')
if(!problem::is_available($sqlc, $dt->proid))
die('Ewrong_proid');
- if(!square::get($sqlc, $dt->sqid))
+ $sq = square::get($sqlc, $dt->sqid);
+ if(!$sq)
die('Ewrong_sqid');
$adm = sec_check_level($sqlc, USER_LEVEL_SUPERADMIN) || square::get_user_relationship($sqlc, $uid, $dt->sqid) >= SQUARE_USER_ADMIN;
@@ -328,6 +337,9 @@ if($action == 'add_pro_into_sq')
if(!$ret)
die('Eadd_problem_into_square_failed');
+ if(event::exec_func('../sqmod/'.$sq->sqmodname.'/'.$sq->sqmodname.'.inc.php','event_add_pro',[$sq->sqid, $dt->proid]) === false)
+ die('Eevent_error');
+
echo('S');
}
if($action == 'delete_pro_from_sq')
@@ -343,7 +355,8 @@ if($action == 'delete_pro_from_sq')
$dt = json_decode($data);
- if(!square::get($sqlc, $dt->sqid))
+ $sq = square::get($sqlc, $dt->sqid);
+ if(!$sq)
die('Ewrong_sqid');
$adm = sec_check_level($sqlc, USER_LEVEL_SUPERADMIN) || square::get_user_relationship($sqlc, $uid, $dt->sqid) >= SQUARE_USER_ADMIN;
@@ -358,6 +371,9 @@ if($action == 'delete_pro_from_sq')
if(!$ret)
die('Edelete_problem_from_square_failed');
+ if(event::exec_func('../sqmod/'.$sq->sqmodname.'/'.$sq->sqmodname.'.inc.php','event_del_pro',[$sq->sqid, $dt->proid]) === false)
+ die('Eevent_error');
+
echo('S');
}
diff --git a/toj/php/status.inc.php b/toj/php/status.inc.php
index adc749f..f0ad3da 100755
--- a/toj/php/status.inc.php
+++ b/toj/php/status.inc.php
@@ -33,31 +33,31 @@ class status
{
$condstr = $condstr.'"submit"."uid"='.pg_escape_string($filter->uid).' AND ';
}
- if($filter->result != null)
+ if($filter->result !== null)
{
$condstr = $condstr.'"result"='.pg_escape_string($filter->result).' AND ';
}
if($filter->proid != null)
{
- $condstr = $condstr.'"proid"='.pg_escape_string($filter->proid).' AND ';
+ $condstr = $condstr.'"submit"."proid"='.pg_escape_string($filter->proid).' AND ';
}
if($filter->lang != null)
{
$condstr = $condstr.'"lang"='.pg_escape_string($filter->lang).' AND ';
}
- if($sort->score != null)
+ if($sort->score !== null)
{
$relstr = $sort->score[0]==0 ? '<=' : '>=';
$condstr = $condstr.'"score"'.$relstr.pg_escape_string($sort->score[1]).' AND ';
$ordstr = $ordstr.'"score" '.($sort->score[0]==0 ? 'DESC' : 'ASC').' ,';
}
- if($sort->runtime != null)
+ if($sort->runtime !== null)
{
$relstr = $sort->runtime[0]==0 ? '<=' : '>=';
$condstr = $condstr.'"runtime"'.$relstr.pg_escape_string($sort->runtime[1]).' AND ';
$ordstr = $ordstr.'"runtime" '.($sort->runtime[0]==0 ? 'DESC' : 'ASC').' ,';
}
- if($sort->maxmem != null)
+ if($sort->maxmem !== null)
{
$relstr = $sort->maxmem[0]==0 ? '<=' : '>=';
$condstr = $condstr.'"memory"'.$relstr.pg_escape_string($sort->maxmem[1]).' AND ';
diff --git a/toj/php/user.inc.php b/toj/php/user.inc.php
index 8b3bb61..46205d7 100755
--- a/toj/php/user.inc.php
+++ b/toj/php/user.inc.php
@@ -192,6 +192,57 @@ class user
return true;
}
+
+ public static function statistic($sqlc, $uid){
+ $sqlstr = 'SELECT "proid",MIN("result") AS "result" FROM "submit" WHERE "uid"=$1 GROUP BY "proid" ORDER BY "proid" ASC;';
+ $sqlarr = array(intval($uid));
+ $sqlr = pg_query_params($sqlc, $sqlstr, $sqlarr);
+ $trylist = array();
+ while($obj = pg_fetch_object($sqlr)){
+ $obj->proid = intval($obj->proid);
+ $obj->result = intval($obj->result);
+ array_push($trylist, $obj);
+ }
+ pg_free_result($sqlr);
+
+ $sqlstr = 'SELECT "result",COUNT("result") AS "count" FROM "submit" WHERE "uid"=$1 GROUP BY "result" ORDER BY "result";';
+ $sqlarr = array(intval($uid));
+ $sqlr = pg_query_params($sqlc, $sqlstr, $sqlarr);
+ $substatis = array();
+ while($obj = pg_fetch_object($sqlr)){
+ $obj->result = intval($obj->result);
+ $obj->count = intval($obj->count);
+ array_push($substatis, $obj);
+ }
+ pg_free_result($sqlr);
+
+ $sqlstr = 'SELECT "result",COUNT("result") AS "count" FROM "submit" WHERE "uid"=$1 GROUP BY "result" ORDER BY "result";';
+ $sqlarr = array(intval($uid));
+ $sqlr = pg_query_params($sqlc, $sqlstr, $sqlarr);
+ $substatis = array();
+ while($obj = pg_fetch_object($sqlr)){
+ $obj->result = intval($obj->result);
+ $obj->count = intval($obj->count);
+ array_push($substatis, $obj);
+ }
+ pg_free_result($sqlr);
+
+ $sqlstr = 'SELECT TO_CHAR("submit_time",\'YYYY-MM\') AS "time",COUNT("submit_time") AS "count" FROM "submit" WHERE uid=$1 GROUP BY TO_CHAR("submit_time",\'YYYY-MM\');';
+ $sqlarr = array(intval($uid));
+ $sqlr = pg_query_params($sqlc, $sqlstr, $sqlarr);
+ $timesub = array();
+ while($obj = pg_fetch_object($sqlr)){
+ $obj->count = intval($obj->count);
+ array_push($timesub, $obj);
+ }
+ pg_free_result($sqlr);
+
+ return array(
+ 'trylist' => $trylist,
+ 'substatis' => $substatis,
+ 'timesub' => $timesub
+ );
+ }
}
function sec_check_level($sqlc, $lv, $uid = null)
diff --git a/toj/php/user.php b/toj/php/user.php
index 4570700..23a15e6 100755
--- a/toj/php/user.php
+++ b/toj/php/user.php
@@ -125,7 +125,12 @@ if($action == 'view')
if(intval($_COOKIE['uid']) != $user->uid)
unset($user->email);
- echo(json_encode($user));
+ $statis = user::statistic($sqlc, $user->uid);
+
+ echo(json_encode(array(
+ 'user' => $user,
+ 'statis' => $statis
+ )));
}
if($action == 'login')
{
diff --git a/toj/sqmod/sqmod_contest/sqmod_contest.css b/toj/sqmod/sqmod_contest/sqmod_contest.css
new file mode 100755
index 0000000..4932aae
--- /dev/null
+++ b/toj/sqmod/sqmod_contest/sqmod_contest.css
@@ -0,0 +1,116 @@
+div.sqmod_contest > div.sboard_pbox > table.sboardlist{
+ margin:32px 0px 6px 0px;
+ border-collapse:collapse;
+ text-align:left;
+}
+div.sqmod_contest > div.sboard_pbox > table.sboardlist tr.head{
+ height:32px;
+}
+div.sqmod_contest > div.sboard_pbox > table.sboardlist tr.item{
+ height:32px;
+ border-top:#BDC0BA 1px solid;
+}
+div.sqmod_contest > div.sboard_pbox > table.sboardlist th,div.sqmod_contest > div.sboard_pbox > table.sboardlist td{
+ width:76px;
+ padding:0px 0px 0px 6px;
+ border-left:#BDC0BA 1px solid;
+}
+div.sqmod_contest > div.sboard_pbox > table.sboardlist th.rank,div.sqmod_contest > div.sboard_pbox > table.sboardlist td.rank{
+ border-width:0px;
+}
+div.sqmod_contest > div.sboard_pbox > table.sboardlist th.nickname,div.sqmod_contest > div.sboard_pbox > table.sboardlist td.nickname{
+ width:240px;
+}
+div.sqmod_contest > div.sboard_pbox > table.sboardlist th.pro,div.sqmod_contest > div.sboard_pbox > table.sboardlist td.pro{
+ width:117px;
+ position:relative;
+}
+div.sqmod_contest > div.sboard_pbox > table.sboardlist td.pro > sup.try{
+ color:#BDC0BA;
+}
+div.sqmod_contest > div.sboard_pbox > table.sboardlist td.pro > sub.time{
+ color:#BDC0BA;
+}
+
+div.sqmod_contest > div.pro_pbox > table.prolist{
+ width:1060px;
+ margin:0px 0px 6px 164px;
+ border-collapse:collapse;
+ text-align:left;
+}
+div.sqmod_contest > div.pro_pbox > table.prolist tr.head{
+ height:64px;
+}
+div.sqmod_contest > div.pro_pbox > table.prolist tr.item{
+ height:32px;
+ border-left:2px solid;
+ border-color:#1C1C1C;
+}
+div.sqmod_contest > div.pro_pbox > table.prolist tr:hover.item{
+ background-color:rgba(255,255,255,0.2);
+}
+div.sqmod_contest > div.pro_pbox > table.prolist th,div.sqmod_contest > div.pro_pbox > table.prolist td{
+ width:76px;
+ padding:0px 0px 0px 6px;
+}
+div.sqmod_contest > div.pro_pbox > table.prolist th.name,div.sqmod_contest > div.pro_pbox > table.prolist td.name{
+ width:auto;
+ padding:0px 0px 0px 0px;
+}
+
+div.sqmod_contest > div.pro_pbox > table.stat{
+ margin:32px 0px 6px 164px;
+ border-collapse:collapse;
+ text-align:left;
+}
+div.sqmod_contest > div.pro_pbox > table.stat tr{
+ height:32px;
+}
+div.sqmod_contest > div.pro_pbox div.prog_box{
+ width:486px;
+ height:16px;
+ background-color:rgba(255,255,255,0.2);
+ color:#1C1C1C;
+ font-size:12px;
+ font-family:monospace;
+ line-height:16px;
+ text-align:right;
+ position:relative;
+}
+div.sqmod_contest > div.pro_pbox div.prog_box > div.pass{
+ width:0%;
+ height:16px;
+ border-right:rgba(0,255,0,0.8) 2px solid;
+ position:absolute;
+ top:0px;
+ left:0%;
+ overflow:hidden;
+}
+div.sqmod_contest > div.pro_pbox div.prog_box > div.good{
+ width:0%;
+ height:16px;
+ border-right:rgba(255,255,0,0.8) 2px solid;
+ position:absolute;
+ top:0px;
+ left:0%;
+ overflow:hidden;
+}
+div.sqmod_contest > div.pro_pbox div.prog_box > div.total{
+ width:0%;
+ height:16px;
+ border-right:rgba(255,255,255,0.8) 2px solid;
+ position:absolute;
+ top:0px;
+ left:0%;
+ overflow:hidden;
+}
+div.sqmod_contest > div.pro_pbox div.prog_box > div.prog{
+ width:0%;
+ height:16px;
+ background-color:rgba(0,0,0,0);
+ font-weight:bold;
+ position:absolute;
+ top:0px;
+ left:0px;
+ overflow:hidden;
+}
diff --git a/toj/sqmod/sqmod_contest/sqmod_contest.html b/toj/sqmod/sqmod_contest/sqmod_contest.html
new file mode 100755
index 0000000..3f7c759
--- /dev/null
+++ b/toj/sqmod/sqmod_contest/sqmod_contest.html
@@ -0,0 +1,39 @@
+<div class="com_pbox sboard_pbox">
+ <table class="sboardlist">
+ <tr class="head">
+ <th class="rank">名次</th>
+ <th class="nickname">昵稱</th>
+ <th class="ac">AC數</th>
+ <th class="score">總分</th>
+ </tr>
+ </table>
+</div>
+<div tab="pro" class="com_pbox pro_pbox">
+ <table class="prolist">
+ <tr class="head">
+ <th class="no">#</th>
+ <th class="name">題目名稱</th>
+ <th class="bscore">最佳分數</th>
+ </tr>
+ </table>
+ <table class="stat">
+ <tr class="user_prog">
+ <td style="width:76px;">個人進度</td>
+ <td style="padding:0px 0px 0px 6px;"><div class="prog_box user_prog">
+ <div class="pass"></div>
+ <div class="good"></div>
+ <div class="total"></div>
+ <div class="prog"></div>
+ </div></td>
+ </tr>
+ <tr class="team_prog" style="display:none;">
+ <td style="width:76px;">小組進度</td>
+ <td style="padding:0px 0px 0px 6px;"><div class="prog_box team_prog">
+ <div class="pass"></div>
+ <div class="good"></div>
+ <div class="total"></div>
+ <div class="prog"></div>
+ </div></td>
+ </tr>
+ </table>
+</div>
diff --git a/toj/sqmod/sqmod_contest/sqmod_contest.inc.php b/toj/sqmod/sqmod_contest/sqmod_contest.inc.php
new file mode 100755
index 0000000..b045dae
--- /dev/null
+++ b/toj/sqmod/sqmod_contest/sqmod_contest.inc.php
@@ -0,0 +1,289 @@
+<?php
+
+require_once('common.inc.php');
+require_once('square.inc.php');
+require_once('sqlib_scoreboard.inc.php');
+
+const SQMODNAME = 'sqmod_contest';
+
+const SCOREBOARD_ID_PROBSTAT = 1;
+const SCOREBOARD_ID_SCOREBOARD = 2;
+
+function score_func($sqid, $proid, $best_score, $best_time, $is_ac, $ac_time, $tries_before_ac, $last_score, $last_status, $tries)
+{
+ $data = get_setting($sqid);
+ $fscore = 0;
+
+ foreach($data->pro as $pro)
+ {
+ if($pro->proid == $proid && $pro->method == 'normal')
+ {
+ $fscore = $pro->score;
+ break;
+ }
+ if($pro->method == 'max')
+ {
+ foreach($pro->config as $cf)
+ {
+ foreach($cf as $sp)
+ {
+ if($sp[0] == $proid)
+ {
+ $fscore = $sp[1];
+ break;
+ }
+ }
+ }
+ }
+ }
+
+ $rscore = $best_score * $fscore / 100;
+ return $rscore;
+}
+
+function get_pro_stat_uid($sqlc, $msqlc, $sqid, $sboard_id, $uid)
+{
+ //get user $uid solving status of square $sqid. $sboard_id can be set as a fixed value.
+ $sq = square::get($sqlc, $sqid);
+ if(!$sq)die('Eno_such_sq');
+
+ $data = sqlib_scoreboard::get_scoreboard_uid($sqlc, $msqlc, $sqid, $sboard_id, 'score_func', $sq->start_time, $sq->end_time, $uid);
+
+ return $data[0];
+}
+
+function process_pro_stat($obj)
+{
+ $ret = array();
+ foreach($obj->problem as $pro)
+ {
+ $ps = new stdClass();
+ $ps->proid = $pro->proid;
+ $ps->is_ac = $pro->is_ac;
+ $ps->best_score = $pro->best_score;
+ //$ps->rank_score = $pro->rank_score;
+ $ps->tried = ($pro->tries > 0);
+ //array_push($ret, $ps);
+ $ret[$pro->proid] = $ps;
+ }
+ return $ret;
+}
+
+function add_setting($sqid)
+{
+ mkdir('/srv/http/toj/center/sq/'.$sqid);
+}
+function del_setting($sqid)
+{
+ $sqdir = '/srv/http/toj/center/sq/'.$sqid.'/';
+ unlink($sqdir.'setting');
+ rmdir($sqdir);
+}
+function get_setting($sqid)
+{
+ $sqdir = '/srv/http/toj/center/sq/'.$sqid.'/';
+ $cont = file_get_contents($sqdir.'setting');
+ $data = json_decode($cont);
+ return $data;
+}
+function put_setting($sqid, $data)
+{
+ $sqdir = '/srv/http/toj/center/sq/'.$sqid.'/';
+ file_put_contents($sqdir.'setting', json_encode($data));
+}
+
+function get_term($data, $sqid)
+{
+ return $data->term;
+}
+
+function calc_score($stat, $data, $sqid)
+{
+ $prolist = $data->pro;
+ $ret = array();
+ foreach($prolist as $pro)
+ {
+ $proid = $pro->proid;
+ $np = new stdClass();
+ if($stat)$np = clone $stat[$proid];
+ //else continue;
+ if(!$stat)
+ {
+ $np->proid = $proid;
+ $np->best_score = 0;
+ $np->tried = false;
+ $np->is_ac = false;
+ array_push($ret, $np);
+ continue;
+ }
+ $method = $pro->method;
+ //$np->full_score = $pro->score;
+ if($method == 'normal')
+ {
+ $np->best_score = $stat[$proid]->best_score / 100 * $pro->score;
+ }
+ if($method == 'max')
+ {
+ $score = 0;
+ $tis_ac = false;
+ foreach($pro->config as $conf)
+ {
+ //$np->best_score = json_encode($conf);
+ $nowscore = 0;
+ $is_ac = true;
+ foreach($conf as $unit)
+ {
+ $nowscore += $stat[$unit[0]]->best_score / 100 * $unit[1];
+ $np->tried = $np->tried || $stat[$unit[0]]->tried;
+ if(!$stat[$unit[0]]->is_ac)$is_ac = false;
+ }
+ $score = max($score, $nowscore);
+ if($is_ac)$tis_ac = true;
+ }
+ $np->is_ac = $tis_ac;
+ $np->best_score = $score;// / 100 * $pro->score;
+ }
+ //$np->best_score = json_encode($np);
+ array_push($ret, $np);
+ }
+ //$stat[0]->best_score = json_encode($ret[0]);
+ return $ret;
+}
+
+function process_pro_list($list, $data, $sqid)
+{
+ $prol = $data->pro;
+ $ret = array();
+ foreach($prol as $pro)
+ {
+ $proid = $pro->proid;
+ $np = null;
+ foreach($list as $op)
+ {
+ if($op->proid == $proid)
+ {
+ $np = clone $op;
+ break;
+ }
+ }
+ $np->prono = $pro->prono;
+ $np->full_score = $pro->score;
+ if($pro->proname)$np->proname = $pro->proname;
+ array_push($ret, $np);
+ }
+ return $ret;
+}
+
+function get_base_line($data, $sqid, $isteam)
+{
+ $ret = new stdClass();
+ if($isteam)
+ {
+ $ret->total_score = $data->total_score;
+ $ret->pass_score = $data->pass_score_team;
+ $ret->good_score = $data->good_score_team;
+ }
+ else
+ {
+ $ret->total_score = $data->total_score;
+ $ret->pass_score = $data->pass_score;
+ $ret->good_score = $data->good_score;
+ }
+
+ return $ret;
+}
+
+function get_scoreboard($sqlc, $msqlc, $sqid, $sboard_id){
+ $sq = square::get($sqlc, $sqid);
+ if(!$sq)
+ die('Eno_such_sq');
+
+ $data = sqlib_scoreboard::get_scoreboard($sqlc, $msqlc, $sqid, $sboard_id, 'score_func', $sq->start_time, $sq->end_time, 0, 65536);
+
+ return $data;
+}
+
+function calc_default_baseline($total_score)
+{
+ $ret = new stdClass();
+
+ $ret->pass_score = round($total_score * 0.6);
+ $ret->good_score = round($total_score * 0.8);
+ $ret->pass_score_team = round($total_score * 0.8);
+ $ret->good_score_team = round($total_score * 1);
+
+ return $ret;
+}
+
+function event_create($sqid)
+{
+ $set = array(
+ 'term' => 1,
+ 'pro' => [],
+ 'total_score' => 0,
+ 'pass_score' => 0,
+ 'good_score' => 0,
+ 'pass_score_team' => 0,
+ 'good_score_team' => 0
+ );
+
+ add_setting($sqid);
+ put_setting($sqid, $set);
+}
+function event_destroy($sqid)
+{
+ del_setting($sqid);
+}
+function event_add_pro($sqid, $proid)
+{
+ $set = get_setting($sqid);
+
+ $list = $set->pro;
+ for($idx = 0;$idx < count($list);$idx++){
+ if($list[$idx]->proid == $proid)
+ return;
+ }
+ $list[$idx] = array(
+ "prono" => $idx + 1,
+ "proid" => $proid,
+ "score" => 100,
+ "method" => 'normal'
+ );
+ $set->pro = $list;
+ $set->total_score += 100;
+
+ $baseline = calc_default_baseline($set->total_score);
+ $set->pass_score = $baseline->pass_score;
+ $set->good_score = $baseline->good_score;
+ $set->pass_score_team = $baseline->pass_score_team;
+ $set->good_score_team = $baseline->good_score_team;
+
+ put_setting($sqid, $set);
+}
+function event_del_pro($sqid, $proid)
+{
+ $set = get_setting($sqid);
+
+ $list = $set->pro;
+ $idx = 0;
+ while($idx < count($list)){
+ if($list[$idx]->proid == $proid){
+ array_splice($list,$idx,1);
+ $set->total_score -= 100;
+ }else{
+ $list[$idx]->prono = $idx + 1;
+ $idx++;
+ }
+ }
+ $set->pro = $list;
+
+ $baseline = calc_default_baseline($set->total_score);
+ $set->pass_score = $baseline->pass_score;
+ $set->good_score = $baseline->good_score;
+ $set->pass_score_team = $baseline->pass_score_team;
+ $set->good_score_team = $baseline->good_score_team;
+
+ put_setting($sqid, $set);
+}
+
+?>
diff --git a/toj/sqmod/sqmod_contest/sqmod_contest.js b/toj/sqmod/sqmod_contest/sqmod_contest.js
new file mode 100755
index 0000000..bb8d9b8
--- /dev/null
+++ b/toj/sqmod/sqmod_contest/sqmod_contest.js
@@ -0,0 +1,425 @@
+var sqmod_contest = function(that,j_page){
+ var sboard_pbox = new class_sqmod_contest_sboard_pbox(that.sqid,j_page);
+ var pro_pbox = new class_sqmod_contest_pro_pbox(that.sqid,j_page);
+
+ that.node.url_chg = function(direct,url_upart,url_dpart){
+ if(direct == 'in'){
+ index.title_set('TOJ-' + that.sqname);
+
+ index.tab_add('sboard','/toj/sq/' + that.sqid + '/sboard/','記分板');
+ index.tab_add('pro','/toj/sq/' + that.sqid + '/pro/','題目');
+
+ if(url_dpart.length == 0){
+ com.url_update('/toj/sq/' + that.sqid + '/pro/');
+ return 'stop';
+ }
+ }else if(direct == 'out'){
+ index.tab_empty();
+ }
+
+ return 'cont';
+ };
+
+ that.node.child_set(sboard_pbox.node);
+ that.node.child_set(pro_pbox.node);
+};
+
+var class_sqmod_contest_sboard_pbox = function(sqid,j_page){
+ var that = this;
+ var j_pbox = j_page.find('div.sboard_pbox');
+ var j_table = j_pbox.find('table.sboardlist');
+ var refresh_flag = false;
+
+ var sboard_refresh = function(){
+ if(refresh_flag == false){
+ return;
+ }
+
+ $.post('/toj/sqmod/sqmod_contest/sqmod_contest.php',{'action':'get_prolist','data':JSON.stringify({'sqid':sqid})},function(res){
+ var i;
+ var prolist;
+ var proo;
+
+ var tds;
+ var j_head;
+ var j_td;
+ var j_a;
+
+ if(res[0] != 'E'){
+ prolist = JSON.parse(res);
+
+ j_table.css('width',(486 + prolist.length * 123) + 'px');
+
+ j_head = j_table.find('tr.head');
+ tds = j_head.find('td.pro');
+ for(i = 0;i < prolist.length;i++){
+ proo = prolist[i];
+ if(i < tds.length){
+ j_td = $(tds[i]);
+ }else{
+ j_td = $('<td class="pro"><a></a></td>');
+ j_head.append(j_td);
+ }
+
+ j_a = j_td.find('a');
+ j_a.text(proo.proid);
+ j_a.attr('href','/toj/pro/' + proo.proid + '/');
+ }
+ for(;i < tds.length;i++){
+ $(tds[i]).remove();
+ }
+
+ $.post('/toj/sqmod/sqmod_contest/sqmod_contest.php',{'action':'get_scoreboard','data':JSON.stringify({'sqid':sqid})},function(res){
+ var i;
+ var j;
+ var reto;
+ var start_time
+ var sboard_list;
+ var sboardo;
+ var proo;
+ var total_ac;
+ var total_score;
+ var duration;
+ var use_time;
+
+ var trs;
+ var tds;
+ var j_item;
+ var j_a;
+ var j_score;
+
+ if(res[0] != 'E'){
+ reto = JSON.parse(res);
+ start_time = reto.start_time;
+ sboard_list = reto.list;
+
+ trs = j_table.find('tr.item');
+ for(i = 0;i < sboard_list.length;i++){
+ sboardo = sboard_list[i];
+
+ if(i < trs.length){
+ j_item = $(trs[i]);
+ }else{
+ j_item = $('<tr class="item"><td class="rank"></td><td class="nickname"><a></a></td><td class="ac"></td><td class="score"></td></tr>');
+ j_table.append(j_item);
+ }
+
+ j_a = j_item.find('td.nickname > a');
+ j_a.text(sboardo.nickname);
+ j_a.attr('href','/toj/user/' + sboardo.uid + '/');
+
+ if(sboardo.rank == -1){
+ j_item.find('td.rank').text('-');
+ }else{
+ j_item.find('td.rank').text(sboardo.rank);
+ }
+
+ tds = j_item.find('td.pro');
+ for(j = tds.length;j < prolist.length;j++){
+ j_item.append($('<td class="pro"><span class="score"></span><sup class="try"></sup><sub class="time"></sub></td>'));
+ }
+ for(;j < tds.length;j++){
+ $(tds[j]).remove();
+ }
+
+ total_ac = 0;
+ total_score = 0;
+ tds = j_item.find('td.pro');
+ for(j = 0;j < prolist.length;j++){
+ j_td = $(tds[j]);
+ if(!(prolist[j].proid in sboardo.problem) || sboardo.problem[prolist[j].proid].tries == 0){
+ j_td.find('span.score').text('')
+ j_td.find('sup.try').text('');
+ j_td.find('sub.time').text('');
+ }else{
+ proo = sboardo.problem[prolist[j].proid];
+
+ j_score = j_td.find('span.score');
+ if(proo.is_ac == true){
+ j_score.css('color',RESULTCOLOR[0]);
+ total_ac++;
+
+ if(start_time != null){
+ duration = new Date(com.get_date(proo.ac_time) - com.get_date(start_time)).getTime();
+ j_td.find('sub.time').text(com.get_durstring(duration,true));
+ }
+ }else{
+ j_score.css('color',null);
+ }
+ total_score += proo.best_score;
+
+ j_score.text(proo.best_score)
+ j_td.find('sup.try').text(proo.tries_before_ac);
+ }
+ }
+ j_item.find('td.ac').text(total_ac);
+ j_item.find('td.score').text(total_score);
+ }
+ for(;i < trs.length;i++){
+ trs[i].remove();
+ }
+ }
+
+ setTimeout(sboard_refresh,5000);
+ });
+ }
+ });
+ };
+
+ that.node = new vus.node('sboard');
+
+ that.__super();
+
+ that.node.url_chg = function(direct,url_upart,url_dpart){
+ var reto;
+
+ if(direct == 'in'){
+ index.tab_hl('sboard');
+
+ refresh_flag = true;
+ sboard_refresh();
+
+ that.fadein(j_pbox);
+ }else if(direct == 'out'){
+ index.tab_ll('sboard');
+ that.fadeout(j_pbox);
+
+ refresh_flag = false;
+
+ j_table.find('tr.item').remove();
+ j_table.find('tr.head > td.pro').remove();
+ }
+ };
+}; __extend(class_sqmod_contest_sboard_pbox,class_com_pbox);
+
+var class_sqmod_contest_pro_pbox = function(sqid,j_page){
+ var that = this;
+ var j_pbox = j_page.find('div.pro_pbox');
+ var promap = null;
+
+ var pro_listset = function(j_item,proo){
+ var i;
+
+ var bscore;
+ var fscore;
+ var ratio;
+ var j_a;
+ var j_team;
+
+ if(proo != null){
+ j_item.attr('proid',proo.proid);
+
+ j_item.find('td.no').text(proo.prono);
+ j_a = j_item.find('td.name > a');
+ j_a.attr('href','/toj/pro/' + proo.proid + '/');
+ j_a.text(proo.proname);
+
+ bscore = proo.bscore;
+ fscore = proo.full_score;
+ j_item.find('td.bscore').text(Math.floor(bscore) + ' / ' + Math.floor(fscore));
+
+ if(proo.tried == false){
+ j_item.css('border-color','#1C1C1C');
+ }else{
+ ratio = bscore / fscore;
+
+ if(ratio < 0.6){
+ j_item.css('border-color','#FF0000');
+ }else if(ratio < 0.8){
+ j_item.css('border-color','#00FF00');
+ }else if(ratio < 1){
+ j_item.css('border-color','#FFFF00');
+ }else{
+ j_item.css('border-color','#FFFFFF');
+ }
+ }
+
+ j_item.find('td.team').remove();
+ for(i = 0;i < proo.tscore.length;i++){
+ j_team = $('<td class="team"></td>');
+ j_team.text(Math.floor(proo.tscore[i]));
+ j_item.append(j_team);
+ }
+ }
+ };
+ var pro_listnew = function(proo){
+ var j_item;
+
+ j_item = $('<tr class="item"><td class="no"></td><td class="name"><a></a></td><td class="bscore"></td></tr>');
+ pro_listset(j_item,proo);
+
+ return j_item;
+ };
+ var prog_set = function(j_progbox,baseline,totalscore){
+ var off;
+ var ratio;
+ var j_prog;
+
+ off = 0;
+ ratio = baseline.pass_score * 100 / baseline.total_score;
+ j_prog = j_progbox.find('div.pass');
+ j_prog.css('width',ratio + '%');
+ j_prog.html(Math.floor(baseline.pass_score) + '&nbsp');
+ off += ratio;
+ ratio = (baseline.good_score - baseline.pass_score) * 100 / baseline.total_score;
+ j_prog = j_progbox.find('div.good');
+ j_prog.css('left',off + '%');
+ j_prog.css('width',ratio + '%');
+ j_prog.html(Math.floor(baseline.good_score) + '&nbsp');
+ off += ratio;
+ ratio = 100 - off;
+ j_prog = j_progbox.find('div.total');
+ j_prog.css('left',off + '%');
+ j_prog.css('width',ratio + '%');
+ j_prog.html(Math.floor(baseline.total_score) + '&nbsp');
+
+ ratio = totalscore * 100 / baseline.total_score;
+ j_prog = j_progbox.find('div.prog');
+ j_prog.css('width',ratio + '%');
+ j_prog.html(Math.floor(totalscore) + '&nbsp');
+ if(totalscore < baseline.pass_score){
+ ratio = totalscore / baseline.pass_score;
+ j_prog.css('background-color','rgba(255,' + Math.round(64 * ratio) + ',0,0.8)');
+ }else if(totalscore < baseline.good_score){
+ ratio = (totalscore - baseline.pass_score) / (baseline.good_score - baseline.pass_score);
+ j_prog.css('background-color','rgba(' + Math.round(128 * ratio) + ',255,0,0.8)');
+ }else if(totalscore < baseline.total_score){
+ ratio = (totalscore - baseline.good_score) / (baseline.total_score - baseline.good_score);
+ j_prog.css('background-color','rgba(255,255,' + Math.round(128 * ratio) + ',0.8)');
+ }else{
+ j_prog.css('background-color','rgba(255,255,255,0.8)');
+ }
+ }
+ var prostat_refresh = function(){
+ if(refresh_flag == false){
+ return;
+ }
+
+ $.post('/toj/sqmod/sqmod_contest/sqmod_contest.php',{'action':'get_user_stat','data':JSON.stringify({'sqid':sqid,'display_team':true})},function(res){
+ var i;
+ var j;
+
+ var reto;
+ var team;
+ var teamo;
+ var prostat;
+ var prostato;
+ var proo;
+ var user_total;
+ var team_total;
+ var maxscore;
+ var j_list;
+ var j_head;
+ var j_team;
+ var j_a;
+ var j_item;
+
+ if(res[0] != 'E'){
+ reto = JSON.parse(res);
+ team = reto.team;
+ prostat = reto.prostat;
+
+ j_list = j_pbox.find('table.prolist');
+ if(team != undefined){
+ j_head = j_list.find('tr.head');
+ j_head.find('th.team').remove();
+ for(i = 0;i < team.length;i++){
+ teamo = team[i];
+
+ j_team = $('<th class="team"><a></a></th>');
+ j_a = j_team.find('a');
+ j_a.attr('href','/toj/user/' + teamo.uid + '/')
+ j_a.text(teamo.name);
+
+ for(j = 0;j < teamo.prostat.length;j++){
+ if(teamo.prostat[j].tried == true){
+ promap[teamo.prostat[j].proid].tscore[i] = teamo.prostat[j].best_score;
+ }else{
+ promap[teamo.prostat[j].proid].tscore[i] = 0;
+ }
+ }
+
+ j_head.append(j_team);
+ }
+
+ j_pbox.find('table.stat tr.team_prog').show();
+ }
+
+ user_total = 0;
+ team_total = 0;
+ for(i = 0;i < prostat.length;i++){
+ prostato = prostat[i];
+ proo = promap[prostato.proid];
+ proo.bscore = prostato.best_score;
+ proo.tried = prostato.tried;
+ user_total += prostato.best_score;
+ j_item = j_list.find('[proid = "' + prostato.proid + '"]');
+ if(j_item.length > 0){
+ pro_listset(j_item,proo);
+ }
+
+ maxscore = proo.bscore;
+ for(j = 0;j < proo.tscore.length;j++){
+ maxscore = Math.max(maxscore,proo.tscore[j]);
+ }
+ team_total += maxscore;
+ }
+
+ prog_set(j_pbox.find('table.stat div.user_prog'),reto.base_line,user_total);
+ if(team != undefined){
+ prog_set(j_pbox.find('table.stat div.team_prog'),reto.team_base_line,team_total);
+ }
+
+ setTimeout(prostat_refresh,2000);
+ }
+ });
+ };
+
+ that.node = new vus.node('pro');
+
+ that.__super();
+
+ that.node.url_chg = function(direct,url_upart,url_dpart){
+ if(direct == 'in'){
+ index.tab_hl('pro');
+ that.fadein(j_pbox);
+ refresh_flag = true;
+
+ $.post('/toj/sqmod/sqmod_contest/sqmod_contest.php',{'action':'get_prolist','data':JSON.stringify({'sqid':sqid})},function(res){
+ var i;
+ var reto;
+ var proo;
+ var j_list;
+ var j_item;
+
+ if(res[0] != 'E'){
+ reto = JSON.parse(res);
+
+ promap = new Array;
+ j_list = j_pbox.find('table.prolist');
+ for(i = 0;i < reto.length;i++){
+ proo = reto[i];
+ proo.bscore = 0;
+ proo.tscore = new Array;
+ proo.tried = false;
+ if(proo.hidden == false || user.level == -1){
+ promap[proo.proid] = proo;
+ j_item = pro_listnew(proo);
+ j_list.append(j_item);
+ }
+ }
+
+ prostat_refresh();
+ }
+ });
+ }else if(direct == 'out'){
+ index.tab_ll('pro');
+ that.fadeout(j_pbox);
+ refresh_flag = false;
+
+ j_pbox.find('table.prolist tr.item').remove();
+ }
+
+ return 'cont';
+ };
+}; __extend(class_sqmod_contest_pro_pbox,class_com_pbox);
diff --git a/toj/sqmod/sqmod_contest/sqmod_contest.php b/toj/sqmod/sqmod_contest/sqmod_contest.php
new file mode 100755
index 0000000..f999cfa
--- /dev/null
+++ b/toj/sqmod/sqmod_contest/sqmod_contest.php
@@ -0,0 +1,123 @@
+<?php
+//ini_set("display_errors", "On");
+
+require_once('common.inc.php');
+require_once('user.inc.php');
+require_once('square.inc.php');
+require_once('sqmod_contest.inc.php');
+require_once('team.inc.php');
+require_once('sqlib_scoreboard.inc.php');
+
+$sqlc = db_connect();
+$msqlc = db_connect('toj_mod');
+
+$action = $_POST['action'];
+$data = $_POST['data'];
+
+if(strlen($action)==0)
+ die('Eno_action');
+if($action == 'get_prolist')
+{
+ $dt = json_decode($data);
+ $sqid = intval($dt->sqid);
+ if(square::get_sqmod($sqlc, $sqid) != SQMODNAME)
+ die('Eerror_sqid_this_mod');
+ if(!sec_is_login())
+ die('Enot_login');
+ $uid = intval($_COOKIE['uid']);
+ if(square::get_user_relationship($sqlc, $uid, $sqid) < SQUARE_USER_ACTIVE)
+ die('Ecannot_view_sq');
+
+ $list = square::get_pro_list($sqlc, $sqid);
+ if(!$list)
+ die('Eno_problem');
+ $data = get_setting($sqid);
+ $nlist = process_pro_list($list, $data, $sqid);
+ echo(json_encode($nlist));
+}
+if($action == 'get_user_stat')
+{
+ $dt = json_decode($data);
+ $sqid = intval($dt->sqid);
+ $display_team = $dt->display_team;
+ if(square::get_sqmod($sqlc, $sqid) != SQMODNAME)
+ die('Eerror_sqid_this_mod');
+ if(!sec_is_login())
+ die('Enot_login');
+ $uid = intval($_COOKIE['uid']);
+ if(square::get_user_relationship($sqlc, $uid, $sqid) < SQUARE_USER_ACTIVE)
+ die('Ecannot_view_sq');
+
+ $data = get_setting($sqid);
+
+ $ret = new stdClass();
+ $prostat = get_pro_stat_uid($sqlc, $msqlc, $sqid, SCOREBOARD_ID_PROBSTAT, $uid);
+ $tmpstat = process_pro_stat($prostat);
+ $ret->prostat = calc_score($tmpstat, $data, $sqid);
+ $ret->base_line = get_base_line($data, $sqid, false);
+
+ if($display_team)
+ {
+ $term = get_term($data, $sqid);
+ $teamid = intval(get_teamid($msqlc, $term, $uid));
+ if($teamid)
+ {
+ $ret->team_base_line = get_base_line($data, $sqid, true);
+ $members = get_team_member($msqlc, $term, $teamid);
+ $arr = array();
+ foreach($members as $mem)
+ {
+ if($mem->uid == $uid)continue;
+ $tmpstat = process_pro_stat(get_pro_stat_uid($sqlc, $msqlc, $sqid, SCOREBOARD_ID_PROBSTAT, $mem->uid));
+ $mem->prostat = calc_score($tmpstat, $data, $sqid);
+ array_push($arr, $mem);
+ }
+ $ret->team = $arr;
+ $ret->teamid = $teamid;
+ }
+ }
+ echo(json_encode($ret));
+}
+if($action == 'get_scoreboard'){
+ $dt = json_decode($data);
+ $sqid = intval($dt->sqid);
+
+ $sqo = square::get($sqlc, $sqid);
+ if($sqo == NULL || $sqo->sqmodname != SQMODNAME)
+ die('Eerror_sq_error');
+ if(!sec_is_login())
+ die('Enot_login');
+ $uid = intval($_COOKIE['uid']);
+ if(square::get_user_relationship($sqlc, $uid, $sqid) < SQUARE_USER_ACTIVE)
+ die('Ecannot_view_sq');
+
+ $list = get_scoreboard($sqlc, $msqlc, $sqid, SCOREBOARD_ID_SCOREBOARD);
+ $user_map = array();
+ for($idx = 0;$idx < count($list);$idx++){
+ $list[$idx]->nickname = user::get_nickname($sqlc, $list[$idx]->uid);
+ $user_map[$list[$idx]->uid] = true;
+ }
+
+ $user_list = square::get_user_list($sqlc, $sqid);
+ for($idx = 0;$idx < count($user_list);$idx++){
+ if(!array_key_exists($user_list[$idx]->uid,$user_map)){
+ array_push($list,array(
+ 'uid' => $user_list[$idx]->uid,
+ 'nickname' => $user_list[$idx]->nickname,
+ 'rank' => -1,
+ 'rank_score' => 0,
+ 'problem' => []
+ ));
+ }
+ }
+
+ echo(json_encode(array(
+ 'start_time' => $sqo->start_time,
+ 'list' => $list
+ )));
+}
+
+db_close($sqlc);
+db_close($msqlc);
+
+?>
diff --git a/toj/sqmod/sqmod_contest/team.inc.php b/toj/sqmod/sqmod_contest/team.inc.php
new file mode 100755
index 0000000..3effc0e
--- /dev/null
+++ b/toj/sqmod/sqmod_contest/team.inc.php
@@ -0,0 +1,37 @@
+<?php
+
+require_once('../../php/common.inc.php');
+
+const TEAM_TYPE_BOY = 1;
+const TEAM_TYPE_GIRL = 2;
+const TEAM_TYPE_COL = 3;
+const TEAM_TYPE_TEA = 4;
+
+function get_teamid($msqlc, $term, $uid)
+{
+ //Return the teamid of $uid. False if not exists.
+ $sqlstr = 'SELECT "teamid" FROM "sqmod_sprout_team" WHERE "term"=$1 AND "uid"=$2;';
+ $sqlarr = array($term, $uid);
+ $res = pg_query_params($msqlc, $sqlstr, $sqlarr);
+ $teamid = pg_fetch_result($res, 0);
+ return $teamid;
+}
+
+function get_team_member($msqlc, $term, $teamid)
+{
+ //Return all team member uid, level of team $teamid. False if not exists.
+ $sqlstr = 'SELECT "sqmod_sprout_team"."uid", "sqmod_sprout_team"."level", "sqmod_sprout_student"."name" FROM "sqmod_sprout_team" INNER JOIN "sqmod_sprout_student" ON "sqmod_sprout_team"."uid"="sqmod_sprout_student"."uid" WHERE "sqmod_sprout_team"."term"=$1 AND "sqmod_sprout_team"."teamid"=$2 ORDER BY "sqmod_sprout_team"."level" DESC, "sqmod_sprout_team"."uid";';
+ $sqlarr = array($term, $teamid);
+ $res = pg_query_params($msqlc, $sqlstr, $sqlarr);
+ $ret = array();
+ while($obj = pg_fetch_object($res))
+ {
+ $obj->uid = intval($obj->uid);
+ $obj->level = intval($obj->level);
+ array_push($ret, $obj);
+ }
+ return $ret;
+}
+
+
+?>
diff --git a/toj/sqmod/sqmod_test/sqmod_test.inc.php b/toj/sqmod/sqmod_test/sqmod_test.inc.php
index f7e5dca..c331a3f 100644..100755
--- a/toj/sqmod/sqmod_test/sqmod_test.inc.php
+++ b/toj/sqmod/sqmod_test/sqmod_test.inc.php
@@ -1,8 +1,8 @@
<?php
-require_once('../../php/common.inc.php');
-require_once('../../php/square.inc.php');
-require_once('../../php/sqlib_scoreboard.inc.php');
+require_once('common.inc.php');
+require_once('square.inc.php');
+require_once('sqlib_scoreboard.inc.php');
const SQMODNAME = 'sqmod_test';
@@ -68,6 +68,16 @@ function process_pro_stat($obj)
return $ret;
}
+function add_setting($sqid)
+{
+ mkdir('/srv/http/toj/center/sq/'.$sqid);
+}
+function del_setting($sqid)
+{
+ $sqdir = '/srv/http/toj/center/sq/'.$sqid.'/';
+ unlink($sqdir.'setting');
+ rmdir($sqdir);
+}
function get_setting($sqid)
{
$sqdir = '/srv/http/toj/center/sq/'.$sqid.'/';
@@ -75,6 +85,11 @@ function get_setting($sqid)
$data = json_decode($cont);
return $data;
}
+function put_setting($sqid, $data)
+{
+ $sqdir = '/srv/http/toj/center/sq/'.$sqid.'/';
+ file_put_contents($sqdir.'setting', json_encode($data));
+}
function get_term($data, $sqid)
{
@@ -177,4 +192,87 @@ function get_base_line($data, $sqid, $isteam)
return $ret;
}
+function calc_default_baseline($total_score)
+{
+ $ret = new stdClass();
+
+ $ret->pass_score = round($total_score * 0.6);
+ $ret->good_score = round($total_score * 0.8);
+ $ret->pass_score_team = round($total_score * 0.8);
+ $ret->good_score_team = round($total_score * 1);
+
+ return $ret;
+}
+
+function event_create($sqid)
+{
+ $set = array(
+ 'term' => 1,
+ 'pro' => [],
+ 'total_score' => 0,
+ 'pass_score' => 0,
+ 'good_score' => 0,
+ 'pass_score_team' => 0,
+ 'good_score_team' => 0
+ );
+
+ add_setting($sqid);
+ put_setting($sqid, $set);
+}
+function event_destroy($sqid)
+{
+ del_setting($sqid);
+}
+function event_add_pro($sqid, $proid)
+{
+ $set = get_setting($sqid);
+
+ $list = $set->pro;
+ for($idx = 0;$idx < count($list);$idx++){
+ if($list[$idx]->proid == $proid)
+ return;
+ }
+ $list[$idx] = array(
+ "prono" => $idx + 1,
+ "proid" => $proid,
+ "score" => 100,
+ "method" => 'normal'
+ );
+ $set->pro = $list;
+ $set->total_score += 100;
+
+ $baseline = calc_default_baseline($set->total_score);
+ $set->pass_score = $baseline->pass_score;
+ $set->good_score = $baseline->good_score;
+ $set->pass_score_team = $baseline->pass_score_team;
+ $set->good_score_team = $baseline->good_score_team;
+
+ put_setting($sqid, $set);
+}
+function event_del_pro($sqid, $proid)
+{
+ $set = get_setting($sqid);
+
+ $list = $set->pro;
+ $idx = 0;
+ while($idx < count($list)){
+ if($list[$idx]->proid == $proid){
+ array_splice($list,$idx,1);
+ $set->total_score -= 100;
+ }else{
+ $list[$idx]->prono = $idx + 1;
+ $idx++;
+ }
+ }
+ $set->pro = $list;
+
+ $baseline = calc_default_baseline($set->total_score);
+ $set->pass_score = $baseline->pass_score;
+ $set->good_score = $baseline->good_score;
+ $set->pass_score_team = $baseline->pass_score_team;
+ $set->good_score_team = $baseline->good_score_team;
+
+ put_setting($sqid, $set);
+}
+
?>
diff --git a/toj/sqmod/sqmod_test/sqmod_test.js b/toj/sqmod/sqmod_test/sqmod_test.js
index 1792b77..4923ed0 100755
--- a/toj/sqmod/sqmod_test/sqmod_test.js
+++ b/toj/sqmod/sqmod_test/sqmod_test.js
@@ -5,9 +5,9 @@ var sqmod_test = function(that,j_page){
if(direct == 'in'){
index.title_set('TOJ-' + that.sqname);
- index.tab_add('pro','/toj/sq/' + that.sqid + '/','題目');
+ index.tab_add('pro','/toj/sq/' + that.sqid + '/pro/','題目');
- if(url_dpart[0] == ''){
+ if(url_dpart.length == 0){
com.url_update('/toj/sq/' + that.sqid + '/pro/');
return 'stop';
}
@@ -194,7 +194,9 @@ var class_sqmod_test_pro_pbox = function(sqid,j_page){
}
prog_set(j_pbox.find('table.stat div.user_prog'),reto.base_line,user_total);
- prog_set(j_pbox.find('table.stat div.team_prog'),reto.team_base_line,team_total);
+ if(team != undefined){
+ prog_set(j_pbox.find('table.stat div.team_prog'),reto.team_base_line,team_total);
+ }
setTimeout(prostat_refresh,2000);
}
diff --git a/toj/sqmod/sqmod_test/sqmod_test.php b/toj/sqmod/sqmod_test/sqmod_test.php
index 3665dbd..341daae 100755
--- a/toj/sqmod/sqmod_test/sqmod_test.php
+++ b/toj/sqmod/sqmod_test/sqmod_test.php
@@ -1,11 +1,11 @@
<?php
//ini_set("display_errors", "On");
-require_once('../../php/common.inc.php');
-require_once('../../php/user.inc.php');
+require_once('common.inc.php');
+require_once('php/user.inc.php');
require_once('sqmod_test.inc.php');
require_once('team.inc.php');
-require_once('../../php/sqlib_scoreboard.inc.php');
+require_once('php/sqlib_scoreboard.inc.php');
$sqlc = db_connect();
$msqlc = db_connect('toj_mod');
diff --git a/toj/sqmod/sqmod_test/sqmod_test_man.php b/toj/sqmod/sqmod_test/sqmod_test_man.php
deleted file mode 100755
index b65804c..0000000
--- a/toj/sqmod/sqmod_test/sqmod_test_man.php
+++ /dev/null
@@ -1,174 +0,0 @@
-<?php
-
-require_once('../../php/common.inc.php');
-require_once('../../php/square.inc.php');
-require_once('../../php/user.inc.php');
-require_once('../../php/sqlib_scoreboard.inc.php');
-require_once('sqmod_test.inc.php');
-
-function get_sprout_data($msqlc, $uid, $term)
-{
- $sqlstr = 'SELECT * FROM "sqmod_sprout_student" INNER JOIN "sqmod_sprout_team" ON "sqmod_sprout_student"."uid"="sqmod_sprout_team"."uid" WHERE "sqmod_sprout_student"."uid"=$1 AND "sqmod_sprout_team"."term"=$2;';
- $sqlarr = array($uid, $term);
- $res = pg_query_params($sqlstr, $sqlarr);
- $ret = pg_fetch_object($res);
- return $ret;
-}
-
-function trans_type($type)
-{
- if($type==1)return '高中男';
- if($type==2)return '高中女';
- if($type==3)return '大學生';
- if($type==4)return '小老師';
- if($type==5)return '內測員';
- if($type==6)return '管理員';
-}
-
-function team_cmp($a, $b)
-{
- if($a->sspd->teamid == $b->sspd->teamid)return ($a->sspd->type < $b->sspd->type);
- //var_dump($a);
- //echo($a->sspd->teamid.','.$b->sspd->teamid.'<br>');
- return $a->sspd->teamid > $b->sspd->teamid;
-}
-
-function get_user_spent_time($sqlc, $sqid, $uid, $start_time = null, $end_time = null)
-{
- if(!$start_time)$start_time = '1990-01-01 01:01:01';
- if(!$end_time)$end_time = '2222-02-02 02:02:02';
- $sqlstr = 'SELECT "submit_time" FROM "submit" WHERE "uid"=$1 AND "submit_time">=$2 AND "submit_time"<$3 AND "proid" IN (SELECT "proid" FROM "pro_sq" WHERE "sqid"=$4) ORDER BY "submit_time";';
- $sqlarr = array($uid, $start_time, $end_time, $sqid);
- $res = pg_query_params($sqlc, $sqlstr, $sqlarr);
- $arr = pg_fetch_all_columns($res, 0);
- $last_time = 0;
- $tot_time = 0;
- $cnt = 0;
- //return 3;
- foreach($arr as $str)
- {
- $cnt += 1;
- $time = strtotime($str);
- //return $time/60;
- $mid = 10 * 60;
- $lng = 90 * 60;
-
- $nl_time = $time + $mid;
- if($nl_time <= $last_time + $lng)
- {
- $tot_time += $nl_time - $last_time;
- }
- else
- {
- $tot_time += 2 * $mid;
- }
-
- $last_time = $nl_time;
- }
- return array($tot_time, $cnt);
-}
-
-$sqlc = db_connect();
-$msqlc = db_connect('toj_mod');
-
-$sqid = intval($_GET['sqid']);
-if(!$sqid)
- die('Eno_sqid');
-
-$sboard_id = 1;
-$sq = square::get($sqlc, $sqid);
-if(!$sq)
- die('Eerror_sqid');
-
-$stime = $sq->start_time;
-$etime = $sq->end_time;
-
-$sbdata = sqlib_scoreboard::get_scoreboard($sqlc, $msqlc, $sqid, $sboard_id, 'score_func', $sq->start_time, $sq->end_time, 1, null);
-
-//var_dump($sbdata);
-
-$prol = '';
-foreach($sbdata[0]->problem as $pro)
-{
- $prol = $prol.'<td align=center width=50>'.$pro->proid.'</td>';
-}
-
-$dt = get_setting($sqid);
-$base = get_base_line($dt, $sqid, false);
-$term = get_term($dt, $sqid);
-
-echo('<meta http-equiv="Content-Type" content="text/html; charset=utf8">');
-echo('<table border = 1>');
-echo('<h align=center><td>rank</td><td>uid</td><td>Nickname</td><td>Name</td><td>StuNo.</td><td>Team</td><td>Type</td><td>Total</td>'.$prol.'<td>Sub.</td><td>Est. Time</td></h>');
-
-$teamsc = array();
-
-foreach($sbdata as $usr)
-{
- $usr->sspd = get_sprout_data($msqlc, $usr->uid, $term);
-}
-
-if($_GET['sort']=='team')usort($sbdata, 'team_cmp');
-
-foreach($sbdata as $usr)
-{
- $spd = $usr->sspd;
- if($_GET['stu_only'] && !($spd->type>=1 && $spd->type<=4))
- continue;
- echo('<tr align="center">');
- echo('<td>'.$usr->rank.'</td>');
- echo('<td>'.$usr->uid.'</td>');
- $user = user::get_from_uid($sqlc, $usr->uid);
- $original_nickname=$user->nickname;
- if(mb_strlen($user->nickname,'UTF-8')>7){
- $user->nickname=mb_substr($user->nickname,0,6,'UTF-8').'...';
- echo('<td title="'.str_replace("!","!",htmlspecialchars($original_nickname)).'">'.$user->nickname.'</td>');
- } else {
- echo('<td>'.$user->nickname.'</td>');
- }
- echo('<td>'.$spd->name.'</td>');
- echo('<td>'.$spd->stuno.'</td>');
- echo('<td>'.$spd->teamid.'</td>');
- echo('<td>'.trans_type($spd->type).'</td>');
-
- $color = 'black';
- if($usr->rank_score >= $base->total_score)$color = 'gray';
- else if($usr->rank_score >= $base->good_score)$color = 'goldenrod';
- else if($usr->rank_score >= $base->pass_score)$color = 'limegreen';
- echo('<td><b><font color="'.$color.'">'.intval($usr->rank_score).'</font></b></td>');
-
-
- foreach($usr->problem as $pro)
- {
- if(!$pro->tries){echo('<td></td>');continue;}
-
- $clr = 'red';
- $b = false;
- if($pro->is_ac){$clr = 'green';$b = true;}
- else if($pro->best_score>=50)$clr = 'orange';
- echo('<td><font color="'.$clr.'">'.(b?'<b>':'').intval($pro->rank_score).(b?'</b>':'').'</font></td>');
- }
-
- $usr_time = get_user_spent_time($sqlc, $sqid, $usr->uid, $stime, $etime);
- $uttmin = floor($usr_time[0] / 60);
- $uttcnt = $usr_time[1];
- $tm_clr = 'black';
- $utmin = $uttmin % 60;
- if($utmin<10)$utmin = '0'.$utmin;
- $uthr = floor($uttmin/60);
- if($uthr >= 2)$tm_clr = 'lime';
- if($uthr >= 6)$tm_clr = 'orange';
- if($uthr >= 10)$tm_clr = 'red';
- echo('<td>'.$uttcnt.'</td><td><font color="'.$tm_clr.'">'.$uthr.':'.$utmin.'</font></td>');
-
-
- echo('</tr>');
-}
-
-echo('</table>');
-
-
-db_close($sqlc);
-db_close($msqlc);
-
-?>
diff --git a/toj/sqmod/sqmod_test/team.inc.php b/toj/sqmod/sqmod_test/team.inc.php
index 3effc0e..3effc0e 100644..100755
--- a/toj/sqmod/sqmod_test/team.inc.php
+++ b/toj/sqmod/sqmod_test/team.inc.php