<?php
$prefix = "";
$suffix = "行事曆";
$c1     = mt_rand(200, 255);
$c2     = mt_rand(200, 255);
$c3     = mt_rand(200, 255);
$b1     = mt_rand(50, 255);
$b2     = mt_rand(50, 255);
$b3     = mt_rand(50, 255);

$sql            = "select max(cate_sort) from `" . $xoopsDB->prefix("tad_cal_cate") . "`";
$result         = $xoopsDB->query($sql);
list($max_sort) = $xoopsDB->fetchRow($result);

$read_perm_name = '';
$post_perm_name = '';

foreach ($create_cate as $groupid => $cate_name) {

    $max_sort++;

    $sql = "INSERT INTO `" . $xoopsDB->prefix("tad_cal_cate") . "`
  (`cate_title`, `cate_sort`, `cate_enable`, `cate_handle`, `enable_group`, `enable_upload_group`, `google_id`, `google_pass`, `cate_bgcolor`, `cate_color`)
  VALUES
  ('{$prefix}{$cate_name}{$suffix}',  '$max_sort',  '1',  '', '',  '1,{$groupid}',  '', '', 'rgb($b1, $b2, $b3)', 'rgb($c1, $c2, $c3)');
  ";
    $xoopsDB->queryF($sql) or die($sql);
    $insert_id = $xoopsDB->getInsertId();

    if (!empty($read_perm_name)) {
        add_perm(1, $insert_id, $mid, $read_perm_name);
        add_perm(2, $insert_id, $mid, $read_perm_name);
        add_perm(3, $insert_id, $mid, $read_perm_name);
        add_perm($groupid, $insert_id, $mid, $read_perm_name);
    }

    if (!empty($post_perm_name)) {
        add_perm(1, $insert_id, $mid, $post_perm_name);
        add_perm($groupid, $insert_id, $mid, $post_perm_name);
    }
}
