$xoopsDB->queryF($sql) or web_error($sql); //取得最後新增資料的流水編號 $sn = $xoopsDB->getInsertId(); //重複事件 rrule($sn, $recurrence, $allday); } // $pageToken = $events->getNextPageToken(); // if ($pageToken) { // $optParams = array('pageToken' => $pageToken); // $events = $cal->events->listEvents($calendarId, $optParams); // } else { // break; // } } $now = date("Y-m-d H:i:s"); $sql = "delete from " . $xoopsDB->prefix("tad_cal_event") . " where cate_sn='{$cate_sn}' and `last_update` < '{$now}'"; $xoopsDB->queryF($sql) or web_error($sql); if (isset($_SESSION['import_google'])) { unset($_SESSION['import_google']); } } else { $authUrl = $client->createAuthUrl(); header("Location: " . $authUrl); exit; } } /*-----------執行動作判斷區----------*/ include_once $GLOBALS['xoops']->path('/modules/system/include/functions.php'); $cate_sn = system_CleanVars($_REQUEST, 'cate_sn', 0, 'int'); import_google($cate_sn);
function tad_cal_all_sync() { global $xoopsDB, $xoopsModule; $sql = "select cate_sn from " . $xoopsDB->prefix("tad_cal_cate") . " where `cate_handle`!=''"; $result = $xoopsDB->query($sql) or web_error($sql); while (list($cate_sn) = $xoopsDB->fetchRow($result)) { import_google($cate_sn); } }