function create_cate($title = '', $sort = '', $handle = '', $enable_group = '', $enable_upload_group = '1', $google_id = '', $google_pass = '') { global $xoopsDB; $myts =& MyTextSanitizer::getInstance(); $title = $myts->addSlashes($title); if (empty($sort)) { $sort = tad_cal_cate_max_sort(); } $sql = "insert into " . $xoopsDB->prefix("tad_cal_cate") . "\n (`cate_title` , `cate_sort` , `cate_enable` , `cate_handle` , `enable_group` , `enable_upload_group` , `google_id` , `google_pass`, `cate_color`)\n values('{$title}' , '{$sort}' , '1' , '{$handle}' , '{$enable_group}' , '{$enable_upload_group}' , '{$google_id}' , '{$google_pass}','rgb(0,0,0)')"; $xoopsDB->queryF($sql) or web_error($sql); //取得最後新增資料的流水編號 $cate_sn = $xoopsDB->getInsertId(); //自動給顏色碼 $color = num2color($cate_sn); $sql = "update " . $xoopsDB->prefix("tad_cal_cate") . " set `cate_bgcolor`='{$color}' where `cate_sn`='{$cate_sn}'"; $xoopsDB->queryF($sql) or web_error($sql); return $cate_sn; }
function save_google() { global $xoopsDB, $xoopsUser; //抓出現有google行事曆 $sql = "select `cate_sn`,`cate_handle` from " . $xoopsDB->prefix("tad_cal_cate") . " where `cate_handle`!=''"; $result = $xoopsDB->query($sql) or web_error($sql); while (list($cate_sn, $cate_handle) = $xoopsDB->fetchRow($result)) { $all_handle[] = $cate_handle; $cate_sn_arr[$cate_handle] = $cate_sn; } $myts =& MyTextSanitizer::getInstance(); $_POST['google_id'] = $myts->addSlashes($_POST['google_id']); $_POST['google_pass'] = $myts->addSlashes($_POST['google_pass']); foreach ($_POST['handle'] as $i => $handle) { $title = $myts->addSlashes($_POST['title'][$i]); $enable_group = ""; $enable_upload_group = "1"; $sort = tad_cal_cate_max_sort(); if (!in_array($handle, $all_handle)) { $cate_sn = create_cate($title, $sort, $handle, $enable_group, $enable_upload_group, $_POST['google_id'], $_POST['google_pass']); } else { $sql = "update " . $xoopsDB->prefix("tad_cal_cate") . " set `cate_title`='{$title}' , `google_id`='{$_POST['google_id']}' , `google_pass`='{$_POST['google_pass']}' where `cate_handle`='{$handle}'"; $xoopsDB->queryF($sql) or web_error($sql); $cate_sn = $cate_sn_arr[$handle]; } import_google($cate_sn); } return; }