user_login){
die('Please login this website first.');
}
/*
# get_all_google_spreadsheet_for_courses.php
$a = [];
foreach(get_posts('category='.CALENDAR_CAT_ID.'&posts_per_page=-1')as$v){
$s = $v->post_content;
preg_match_all('/\[week_course .*]/', $s, $m);
if(!isset($m[0]) or !$m[0]){continue;}
foreach($m[0] as$_){
preg_match_all('/ d=.*?[ \]]/', $_, $x);
preg_match_all('/ gid=.*?[ \]]/', $_, $y);
if(!isset($x[0][0]) or !$x[0][0] or !isset($y[0][0]) or !$y[0][0]){continue;}
$doc = trim($x[0][0]); $doc = substr($doc,2);
$gid = trim($y[0][0]); $gid = substr($gid,4);
$doc = str_replace(['"', "'", ']'], '', $doc);
$gid = str_replace(['"', "'", ']'], '', $gid);
$a[] = $doc.'```'.$gid;
}
}
$a = array_unique($a);
print_r($a);
echo'';
*/
?>
更新課程表表格內容 Update calendar table
Please input d and gid!';
}else{
#echo $doc; echo $gid;
$ary_gid = explode(',', $gid);
foreach($ary_gid as $gid){
if(0===preg_match('/^[0-9]+$/',$gid)){continue;}
$url = 'https://docs.google.com/spreadsheets/d/'.$doc.'/export?format=csv&gid='.$gid;
$fn = __DIR__ . '/cache4calendar/'.$doc.'```'.$gid.'.cache';
$s = file_get_contents($url);
file_put_contents($fn, $s);
echo'Updated for gid='.$gid.'
';
}
echo'Updated! Please review and re-check the '.$_SERVER['SERVER_NAME'].'/calendar-XXXXX/ webpage. If still fail, please contact Web Developer.
';
}
}else{
$doc = isset($_GET['d']) ? $_GET['d'] : '';
$gid = isset($_GET['gid']) ? $_GET['gid'] : '';
}
?>
[您現正在 站 ]
更新 站 之課程表表格內容 Update calendar table:
請輸入 d 與 gid。 Please input the d and gid.
For example, if the one sheet you edited just now is https://docs.google.com/spreadsheets/d/vD2XA8j14FNfWvD4wvNgs7X-uXdICpEuo/edit#gid=689479925,
then the blue text is for "d" and the green text is for "gid"
-------------------------------
created at 2021.1.30