Esempio n. 1
0
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;
}
Esempio n. 2
0
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;
}