function parse($f, $mdes, $m1, $m2, $m3, $mrs, $mnum) { if ($mnum < 10) { $numfill = "0" . $mnum; } else { $numfill = $mnum; } $val = $m1; switch ($f) { case "menu": switch ($m2) { case "num": $val = $mnum; break; case "numfill": $val = $numfill; break; case "id": $val = $mrs["t_id"]; break; case "name": $val = getTextt($m3, $mrs["t_name"]); break; case "enname": $val = getTextt($m3, $mrs["t_enname"]); break; case "pid": $val = $mrs["t_pid"]; break; case "title": $val = $mrs["t_title"]; break; case "key": $val = $mrs["t_key"]; break; case "des": $val = $mrs["t_des"]; break; case "link": if ($this->L['type'] == 'auto') { $an = $this->P['vodtypeid'] > 0 ? 'list' : 'search'; $col = $this->P['vodtypeid'] > 0 ? 'id' : 'typeid'; $val = $this->getLink($this->L['table'], $an, $this->T, array($col => $mrs['t_id'])); } else { $val = $this->getLink($this->L['table'], 'type', $mrs, $row); } break; case "count": if ($this->L['table'] == "art") { $typearr = $GLOBALS['MAC_CACHE']['arttype'][$mrs["t_id"]]; $val = $this->getDataCount('art', " and a_type in (" . $typearr["childids"] . ")"); } else { $typearr = $GLOBALS['MAC_CACHE']['vodtype'][$mrs["t_id"]]; $val = $this->getDataCount('vod', " and d_type in (" . $typearr["childids"] . ")"); } break; } break; case "class": switch ($m2) { case "num": $val = $mnum; break; case "numfill": $val = $numfill; break; case "id": $val = $mrs["c_id"]; break; case "name": $val = getTextt($m3, $mrs["c_name"]); break; case "enname": $val = getTextt($m3, $mrs["c_enname"]); break; case "pid": $val = $mrs["c_pid"]; break; case "link": if ($this->L['type'] == 'auto') { $an = $this->P['vodtypeid'] > 0 ? 'list' : 'search'; $col = $this->P['vodtypeid'] > 0 ? 'class' : 'classid'; $val = $this->getLink('vod', $an, $this->T, array($col => $mrs['c_id'])); } else { $val = $this->getLink('vod', 'search', $mrs, array('classid' => $mrs['c_id'])); } break; } break; case "topic": switch ($m2) { case "num": $val = $mnum; break; case "numfill": $val = $numfill; break; case "id": $val = $mrs["t_id"]; break; case "name": $val = getTextt($m3, $mrs["t_name"]); break; case "enname": $val = getTextt($m3, $mrs["t_enname"]); break; case "sort": $val = $mrs["t_sort"]; break; case "title": $val = $mrs["t_title"]; break; case "key": $val = $mrs["t_key"]; break; case "des": $val = $mrs["t_des"]; break; case "addtime": $val = getDatet($m3, $mrs["t_addtime"]); break; case "time": $val = getDatet($m3, $mrs["t_time"]); break; case "level": $val = $mrs["t_level"]; break; case "hits": $val = $mrs["t_hits"]; break; case "dayhits": $val = $mrs["t_dayhits"]; break; case "weekhits": $val = $mrs["t_weekhits"]; break; case "monthhits": $val = $mrs["t_monthhits"]; break; case "content": $val = getTextt($m3, $mrs["t_content"]); break; case "contenttext": $val = getTextt($m3, strip_tags($mrs["t_content"])); break; case "remarks": $val = getTextt($m3, $mrs["t_remarks"]); break; case "pic": $val = $mrs["t_pic"]; if (strpos("," . $val, "http://") <= 0) { if ($GLOBALS['MAC']['upload']['remote'] == 1) { $val = $GLOBALS['MAC']['upload']['remoteurl'] . $val; } else { $val = MAC_PATH . $val; } } break; case "count": $val = $this->getDataCount($this->L['table'] . '_relation', " and r_type=2 and r_a=" . $mrs["t_id"]); break; case "link": $val = $this->getLink($this->L['table'], 'topic', $mrs, $row); break; } break; case "link": switch ($m2) { case "num": $val = $mnum; break; case "numfill": $val = $numfill; break; case "id": $val = $mrs["l_id"]; break; case "name": $val = getTextt($m3, $mrs["l_name"]); break; case "type": $val = $mrs["l_type"] == 1 ? "图片" : "文字"; break; case "link": $val = $mrs["l_url"]; break; case "pic": $val = $mrs["l_logo"]; break; } break; case "gbook": $bgcolorArr = array("D66203", "513DBD", "784E1A", "C55200", "DA6912", "537752", "C58200", "519DBD", "D60103", "531752"); $reg2 = '~(\\d+)\\.(\\d+)\\.(\\d+)\\.(\\d+)~'; switch ($m2) { case "num": $val = $mnum; break; case "numfill": $val = $numfill; break; case "id": $val = $mrs["g_id"]; break; case "name": $val = getTextt($m3, $mrs["g_name"]); break; case "content": $val = regReplace(getTextt($m3, $mrs["g_content"]), "\\[em:(\\d{1,})?\\]", "<img src=\"" . MAC_PATH . "images/face/\$1.gif\" border=0/>"); break; case "reply": $val = getTextt($m3, $mrs["g_reply"]); break; case "ip": $val = preg_replace($reg2, "\$1.\$2.*.*", long2ip($mrs["g_ip"])); break; case "time": $val = getDatet($m3, $mrs["g_time"]); break; case "replytime": $val = getDatet($m3, $mrs["g_replytime"]); break; case "color": $val = '#' . $bgcolorArr[rand(1, 9)]; break; } break; case "comment": $bgcolorArr = array("D66203", "513DBD", "784E1A", "C55200", "DA6912", "537752", "C58200", "519DBD", "D60103", "531752"); $reg2 = '~(\\d+)\\.(\\d+)\\.(\\d+)\\.(\\d+)~'; switch ($m2) { case "num": $val = $mnum; break; case "numfill": $val = $numfill; break; case "id": $val = $mrs["c_id"]; break; case "name": $val = getTextt($m3, $mrs["c_name"]); break; case "content": $val = regReplace(getTextt($m3, $mrs["c_content"]), "\\[em:(\\d{1,})?\\]", "<img src=\"" . MAC_PATH . "images/face/\$1.gif\" border=0/>"); break; case "ip": $val = preg_replace($reg2, "\$1.\$2.*.*", long2ip($mrs["c_ip"])); break; case "time": $val = getDatet($m3, $mrs["c_time"]); break; case "color": $val = '#' . $bgcolorArr[rand(1, 9)]; break; } break; case "vod": $typearr = $GLOBALS['MAC_CACHE']['vodtype'][$mrs["d_type"]]; if (!is_array($typearr)) { return; } $tp = $GLOBALS['MAC_CACHE']['vodtype'][$typearr["t_pid"]]; switch ($m2) { case "num": $val = $mnum; break; case "numfill": $val = $numfill; break; case "numjoin": $val = $this->L['start'] + $mnum; if ($val < 10) { $val = "0" . $val; } break; case "id": $val = $mrs["d_id"]; break; case "name": $val = getTextt($m3, $mrs["d_name"]); break; case "encodename": $val = urlencode($mrs["d_name"]); break; case "colorname": $val = getTextt($m3, $mrs["d_name"]); if (!empty($mrs["d_color"])) { $val = "<font color=" . $mrs["d_color"] . ">" . $val . "</font>"; } break; case "subname": $val = getTextt($m3, $mrs["d_subname"]); break; case "enname": $val = getTextt($m3, $mrs["d_enname"]); break; case "ennamelink": $val = getKeysLink($mrs["d_enname"], "pinyin"); break; case "state": $val = $mrs["d_state"]; break; case "color": $val = $mrs["d_color"]; break; case "pic": $val = $mrs["d_pic"]; if (strpos("," . $val, "http://") <= 0) { if ($GLOBALS['MAC']['upload']['remote'] == 1) { $val = $GLOBALS['MAC']['upload']['remoteurl'] . $val; } else { $val = MAC_PATH . $val; } } break; case "picthumb": $val = $mrs["d_picthumb"]; if (strpos("," . $val, "http://") <= 0) { if ($GLOBALS['MAC']['upload']['remote'] == 1) { $val = $GLOBALS['MAC']['upload']['remoteurl'] . $val; } else { $val = MAC_PATH . $val; } } break; case "picslide": $val = $mrs["d_picslide"]; if (strpos("," . $val, "http://") <= 0) { if ($GLOBALS['MAC']['upload']['remote'] == 1) { $val = $GLOBALS['MAC']['upload']['remoteurl'] . $val; } else { $val = MAC_PATH . $val; } } break; case "letter": $val = getTextt($m3, $mrs["d_letter"]); break; case "letterlink": $val = getKeysLink($mrs["d_letter"], "letter"); break; case "tag": $val = getTextt($m3, $mrs["d_tag"]); break; case "taglink": $val = getKeysLink($mrs["d_tag"], "tag"); break; case "starring": $val = getTextt($m3, $mrs["d_starring"]); break; case "starringlink": $val = getKeysLink($mrs["d_starring"], "starring"); break; case "directed": $val = getTextt($m3, $mrs["d_directed"]); break; case "directedlink": $val = getKeysLink($mrs["d_directed"], "directed"); break; case "area": $val = $mrs["d_area"]; break; case "arealink": $val = getKeysLink($mrs["d_area"], "area"); break; case "year": $val = $mrs["d_year"] == 0 ? '未知' : $mrs["d_year"]; break; case "yearlink": $val = getKeysLink($mrs["d_year"] == 0 ? '未知' : $mrs["d_year"], "year"); break; case "lang": $val = $mrs["d_lang"]; break; case "langlink": $val = getKeysLink($mrs["d_lang"], "lang"); break; case "level": $val = $mrs["d_level"]; break; case "stint": $val = $mrs["d_stint"]; break; case "stintdown": $val = $mrs["d_stintdown"]; break; case "hits": $val = $mrs["d_hits"]; break; case "dayhits": $val = $mrs["d_dayhits"]; break; case "weekhits": $val = $mrs["d_weekhits"]; break; case "monthhits": $val = $mrs["d_monthhits"]; break; case "content": $val = getTextt($m3, $mrs["d_content"]); break; case "contenttext": $val = getTextt($m3, strip_tags($mrs["d_content"])); break; case "remarks": $val = getTextt($m3, $mrs["d_remarks"]); break; case "up": $val = $mrs["d_up"]; break; case "down": $val = $mrs["d_down"]; break; case "score": $val = $mrs["d_score"]; break; case "scoreall": $val = $mrs["d_scoreall"]; break; case "scorenum": $val = $mrs["d_scorenum"]; break; case "duration": $val = $mrs["d_duration"]; break; case "addtime": $val = getDatet($m3, $mrs["d_addtime"]); break; case "time": $val = getDatet($m3, $mrs["d_time"]); break; case "from": $val = getVodXmlText("vodplay", "play", $mrs["d_playfrom"]); break; case "fromdown": $val = getVodXmlText("voddown", "down", $mrs["d_downfrom"]); break; case "link": $val = $this->getLink('vod', 'detail', $typearr, $mrs); break; case "playlink": $val = str_replace(array('{src}', '{num}'), array('1', '1'), $this->getLink('vod', 'play', $typearr, $mrs)); break; case "playlinks": $val = ''; $arr = explode('$$$', $mrs['d_playfrom']); $cc = count($arr); if (empty($mrs['d_playfrom']) || $cc == 0) { break; } $xmlarr = $GLOBALS['MAC_CACHE']['vodplay']; $url = $this->getLink('vod', 'play', $typearr, $mrs); for ($i = 0; $i < $cc; $i++) { $show = $xmlarr[$arr[$i]]['show']; $lnk = str_replace(array('{src}', '{num}'), array($i + 1, '1'), $url); $val .= '<a href="' . $lnk . '" target="_blank" class="playlink_' . $arr[$i] . '">' . $show . '</a> '; } unset($arr, $xmlarr); break; case "downlink": $val = str_replace(array('{src}', '{num}'), array('1', '1'), $this->getLink('vod', 'down', $typearr, $mrs)); break; case "downlinks": $val = ''; $arr = explode('$$$', $mrs['d_downfrom']); $cc = count($arr); if (empty($mrs['d_downfrom']) || $cc == 0) { break; } $xmlarr = $GLOBALS['MAC_CACHE']['voddown']; $url = $this->getLink('vod', 'down', $typearr, $mrs); for ($i = 0; $i < $cc; $i++) { $show = $xmlarr[$arr[$i]]['show']; $lnk = str_replace(array('{src}', '{num}'), array($i + 1, '1'), $url); $val .= '<a href="' . $lnk . '" target="_blank" class="downlink_' . $arr[$i] . '">' . $show . '</a> '; } unset($arr, $xmlarr); break; case "type": $val = $mrs["d_type"]; break; case "typepid": $val = $typearr["t_pid"]; break; case "typeplink": $val = $this->getLink('vod', 'type', $tp, $mrs); break; case "typepname": $val = $tp["t_name"]; break; case "typepenname": $val = $tp["t_enname"]; break; case "typepkey": $val = $tp["t_key"]; break; case "typepdes": $val = $tp["t_des"]; break; case "typelink": $val = $this->getLink('vod', 'type', $typearr, $mrs); break; case "typename": $val = $typearr["t_name"]; break; case "typeenname": $val = $typearr["t_enname"]; break; case "typekey": $val = $typearr["t_key"]; break; case "typedes": $val = $typearr["t_des"]; break; case "typetitle": $val = $typearr["t_title"]; break; case "typeexpandlink": $val = ''; break; case "classname": $val = ''; if (!empty($mrs['d_class'])) { $rc = false; $ids = explode(',', $mrs['d_class']); foreach ($ids as $a) { if (!empty($a)) { $arr = $GLOBALS['MAC_CACHE']['vodclass'][$a]; if ($rc) { $val .= ' '; } $val .= $arr['c_name']; $rc = true; } } unset($ids); } break; case "classlink": $val = ''; if (!empty($mrs['d_class'])) { $rc = false; $ids = explode(',', $mrs['d_class']); foreach ($ids as $a) { if (!empty($a)) { $arr = $GLOBALS['MAC_CACHE']['vodclass'][$a]; $mrs['id'] = $typearr['t_id']; $mrs['class'] = $arr['c_id']; $lnk = $this->getLink('vod', 'list', $typearr, $mrs); if ($rc) { $val .= ' '; } $val .= "<a target='_blank' href='" . $lnk . "' />" . $arr['c_name'] . "</a>"; $rc = true; } } unset($ids); } break; case "topiclink": $val = ''; if (!empty($mrs['d_topic'])) { $rc = false; $ids = explode(',', $mrs['d_topic']); foreach ($ids as $a) { if (!empty($a)) { $arr = $GLOBALS['MAC_CACHE']['vodtopic'][$a]; $lnk = $this->getLink('vod', 'topic', $arr, $mrs); if ($rc) { $val .= ' '; } $val .= "<a target='_blank' href='" . $lnk . "' />" . $arr['t_name'] . "</a>"; $rc = true; } } unset($ids); } break; case "userfav": $val = "<a href=\"javascript:void(0)\" onclick=\"MAC.UserFav('" . $mrs["d_id"] . "');return false;\"/>会员收藏</a>"; break; default: $val = $m1; break; } break; case "art": $typearr = $GLOBALS['MAC_CACHE']['arttype'][$mrs["a_type"]]; if (!is_array($typearr)) { return; } $tp = $GLOBALS['MAC_CACHE']['arttype'][$typearr["t_pid"]]; switch ($m2) { case "num": $val = $mnum; break; case "numfill": $val = $numfill; break; case "numjoin": $val = $this->P['start'] + $mnum; break; case "id": $val = $mrs["a_id"]; break; case "name": $val = getTextt($m3, $mrs["a_name"]); break; case "encodename": $val = urlencode($mrs["a_name"]); break; case "colorname": $val = getTextt($m3, $mrs["a_name"]); if (!empty($mrs["a_color"])) { $val = "<font color=" . $mrs["a_color"] . ">" . $val . "</font>"; } break; case "letter": $val = getTextt($m3, $mrs["a_letter"]); break; case "letterlink": $val = getKeysLink($mrs["a_letter"], "letter", 'art'); break; case "subname": $val = getTextt($m3, $mrs["a_subname"]); break; case "enname": $val = getTextt($m3, $mrs["a_enname"]); break; case "from": $val = getTextt($m3, $mrs["a_from"]); break; case "remarks": $val = getTextt($m3, $mrs["a_remarks"]); break; case "tag": $val = getTextt($m3, $mrs["a_tag"], 'art'); break; case "taglink": $val = getKeysLink($mrs["a_tag"], "tag", 'art'); break; case "content": $val = $mrs["a_content"]; if ($this->P['pagetype'] == "detail") { $val = $this->P['content']; } $val = getTextt($m3, $val); break; case "contenttext": $val = $mrs["a_content"]; if ($this->P['pagetype'] == "detail") { $val = $this->P['content']; } $val = strip_tags($val); $val = getTextt($m3, strip_tags($val)); break; case "author": $val = getTextt($m3, $mrs["a_author"]); break; case "color": $val = $mrs["a_color"]; break; case "up": $val = $mrs["a_up"]; break; case "down": $val = $mrs["a_down"]; break; case "hits": $val = $mrs["a_hits"]; break; case "dayhits": $val = $mrs["a_dayhits"]; break; case "weekhits": $val = $mrs["a_weekhits"]; break; case "monthhits": $val = $mrs["a_monthhits"]; break; case "addtime": $val = getDatet($m3, $mrs["a_addtime"]); break; case "time": $val = getDatet($m3, $mrs["a_time"]); break; case "pic": $val = $mrs["a_pic"]; if (strpos("," . $val, "http://") <= 0) { if ($GLOBALS['MAC']['upload']['remote'] == 1) { $val = $GLOBALS['MAC']['upload']['remoteurl'] . $val; } else { $val = MAC_PATH . $val; } } break; case "link": $val = $this->getLink('art', 'detail', $typearr, $mrs); break; case "level": $val = $mrs["a_level"]; break; case "type": $val = $mrs["a_type"]; break; case "typepid": $val = $typearr["t_pid"]; break; case "typeplink": $val = $this->getLink('art', 'type', $tp, $mrs); break; case "typepname": $val = $tp["t_name"]; break; case "typepenname": $val = $tp["t_enname"]; break; case "typepkey": $val = $tp["t_key"]; break; case "typepdes": $val = $tp["t_des"]; break; case "typeptitle": $val = $tp["t_title"]; break; case "typelink": $val = $this->getLink('art', 'type', $typearr, $mrs); break; case "typename": $val = $typearr["t_name"]; break; case "typeenname": $val = $typearr["t_enname"]; break; case "typekey": $val = $typearr["t_key"]; break; case "typedes": $val = $typearr["t_des"]; break; case "typetitle": $val = $typearr["t_title"]; break; case "topiclink": $val = ''; if (!empty($mrs['a_topic'])) { $rc = false; $ids = explode(',', $mrs['a_topic']); foreach ($ids as $a) { if (!empty($a)) { $arr = $GLOBALS['MAC_CACHE']['arttopic'][$a]; $lnk = $this->getLink('art', 'topic', $arr, $mrs); if ($rc) { $val .= ' '; } $val .= "<a target='_blank' href='" . $lnk . "' />" . $arr['t_name'] . "</a>"; $rc = true; } } unset($ids); } break; default: $val = $m1; break; } break; default: break; } unset($typearr, $tp); $markstr = str_replace($m1, $val, $mdes); return $markstr; }
function configconnectsave() { $QQ_OAUTH_CONSUMER_KEY = be("post", "QQ_OAUTH_CONSUMER_KEY"); $QQ_OAUTH_CONSUMER_SECRET = be("post", "QQ_OAUTH_CONSUMER_SECRET"); $fc = file_get_contents("../user/qqconfig.php"); $fc = regReplace($fc, "QQ_OAUTH_CONSUMER_KEY\",\"(\\S+?)\"", "QQ_OAUTH_CONSUMER_KEY\",\"" . $QQ_OAUTH_CONSUMER_KEY . "\""); $fc = regReplace($fc, "QQ_OAUTH_CONSUMER_SECRET\",\"(\\S+?)\"", "QQ_OAUTH_CONSUMER_SECRET\",\"" . $QQ_OAUTH_CONSUMER_SECRET . "\""); fwrite(fopen("../user/qqconfig.php", "wb"), $fc); echo "配置修改成功"; }
$plt->set_if('main', 'isnull', true); return; } $plt->set_if('main', 'isnull', false); $colarr = $col_comment; $rn = 'comment'; $plt->set_block('main', 'list_' . $rn, 'rows_' . $rn); while ($row = $db->fetch_array($rs)) { $valarr = array(); for ($i = 0; $i < count($colarr); $i++) { $n = $colarr[$i]; $valarr[$n] = $row[$n]; } //$valarr['c_type']= $row['c_type'] == 26 ? '文章':'视频'; $valarr['c_ip'] = long2ip($row['c_ip']); $valarr['c_content'] = regReplace($row['c_content'], "\\[em:(\\d{1,})?\\]", "<img src=\"../images/face/\$1.gif\" border=0/>"); $valarr['c_time'] = getColorDay($row['c_time']); for ($i = 0; $i < count($colarr); $i++) { $n = $colarr[$i]; $v = $valarr[$n]; $plt->set_var($n, $v); } $plt->parse('rows_' . $rn, 'list_' . $rn, true); if ($row['c_type'] == 16) { $plt->set_if('rows_' . $rn, 'isvod', true); } else { $plt->set_if('rows_' . $rn, 'isvod', false); } if ($row['c_hide'] == 1) { $plt->set_if('rows_' . $rn, 'ishide', true); } else {
function main() { global $db; $pagenum = be("all", "page"); if (!isNum($pagenum)) { $pagenum = 1; } else { $pagenum = intval($pagenum); } if ($pagenum < 1) { $pagenum = 1; } $sql = "SELECT count(*) FROM {pre}gbook"; $nums = $db->getOne($sql); $pagecount = ceil($nums / app_pagenum); $sql = "SELECT g_id,g_vid,g_audit,g_name,g_content,g_ip,g_reply,g_time,g_replytime FROM {pre}gbook ORDER BY g_id DESC limit " . app_pagenum * ($pagenum - 1) . "," . app_pagenum; $rs = $db->query($sql); ?> <script language="javascript"> $(document).ready(function(){ $('#form1').form({ onSubmit:function(){ if(!$("#form1").valid()) {return false;} }, success:function(data){ $.messager.alert('系统提示', data, 'info',function(){ location.href=location.href; }); } }); $('#form2').form({ onSubmit:function(){ if(!$("#form2").valid()) {return false;} }, success:function(data){ $.messager.alert('系统提示', data, 'info'); } }); $("#btnCancel").click(function(){ location.href= location.href; }); $("#btnDel").click(function(){ if(confirm('确定要删除吗')){ $("#form1").attr("action","admin_ajax.php?action=del&flag=batch&tab={pre}gbook"); $("#form1").submit(); } else{return false} }); $("#btnAudit").click(function(){ $("#form1").attr("action","admin_gbook.php?action=audit"); $("#form1").submit(); }); }); function reply(id) { $('#form2').form('clear'); $("#flag").val("edit"); $('#win1').window('open'); $('#form2').form('load','admin_ajax.php?action=getinfo&tab={pre}gbook&col=g_id&val='+id); } </script> <?php if ($nums == 0) { ?> <div align="center">没有任何记录!</div> <?php } else { while ($row = $db->fetch_array($rs)) { $g_id = $row["g_id"]; $g_content = $row["g_content"]; $g_content = regReplace($g_content, "\\[em:(\\d{1,})?\\]", "<img src=\"../images/face/\$1.gif\" border=0/>"); ?> <form id="form1" name="form1" method="post"> <div style="width:100%; border:1px solid #B5D6E6; margin-top:10px;"> <div style="width:100%; height:30px; line-height:30px; font-size:12px; background:#EEF7FE"> <span style="float:left;color:#185691;"> <input type="checkbox" name="g_id[]" value="<?php echo $g_id; ?> " class="checkbox"> 昵称:<strong><?php echo $row["g_name"]; ?> </strong> IP:<?php echo $row["g_ip"]; ?> <?php if ($row["g_audit"] == 1) { ?> <font color=green>已审核</font><?php } else { ?> <font color=red>未审核</font><?php } ?> </span> <span style="float:right;text-align:right; font-size:12px;"> 发表于:<font color="red"><?php echo $row["g_time"]; ?> </font> </span> </div> <div style="width:95%; margin:0 auto; height:60px; font-size:12px; line-height:20px; border-bottom:1px solid #CCC"> 留言内容:<?php echo $g_content; ?> <br> <font color="red">回复内容:</font><?php echo $row["g_reply"]; ?> </div> <div style="width:100%; height:20px; text-align:right;font-size:12px; line-height:20px;"> [<a style="cursor:pointer" onclick="reply(<?php echo $g_id; ?> )"> 回复</a>] [<a href="admin_ajax.php?action=del&tab={pre}gbook&g_id=<?php echo $g_id; ?> " onClick="return confirm('确定要删除吗?');">删除</a>] </div> </div> <?php } } ?> <table> <tr><td> 全选<input name="chkall" type="checkbox" id="chkall" value="1" onClick="checkAll(this.checked,'g_id[]');"/> <input type="button" id="btnDel" value="批量删除" class="input"> <input type="button" id="btnAudit" value="批量审核" class="input"> </td></tr> </table> <div align="center"> <?php echo pagelist_manage($pagecount, $pagenum, $nums, app_pagenum, "admin_gbook.php?page={p}"); ?> </div> <br><br> </form> <div id="win1" class="easyui-window" title="窗口" style="padding:5px;width:400px;" closed="true" minimizable="false" maximizable="false"> <form action="admin_ajax.php?action=save&tab={pre}gbook" method="post" name="form2" id="form2"> <table class="tb"> <input id="g_id" name="g_id" type="hidden" value=""> <input id="flag" name="flag" type="hidden" value=""> <tr> <td width="20%" >回复内容:</td> <td><textarea id="g_reply" rows="8" style="width:200px;" value="" name="g_reply"></textarea> </td> </tr> <tr align="center"> <td colspan="2"><input class="input" type="submit" value="保存" id="btnSave"> <input class="input" type="button" value="返回" id="btnCancel"> </td> </tr> </table> </form> </div> </body> </html> <?php unset($rs); }
if (!file_exists($fp)) { $fp .= '.bak'; } $fc = file_get_contents($fp); $fc = regReplace($fc, "var\\smac_flag\\=(\\d+?)\\;", "var mac_flag=" . $mac_flag . ";"); $fc = regReplace($fc, "var\\smac_second\\=(\\d+?)\\;", "var mac_second=" . $mac_second . ";"); $fc = regReplace($fc, "var\\smac_width\\=(\\d+?)\\;", "var mac_width=" . $mac_width . ";"); $fc = regReplace($fc, "var\\smac_height\\=(\\d+?)\\;", "var mac_height=" . $mac_height . ";"); $fc = regReplace($fc, "var\\smac_widthpop\\=(\\d+?)\\;", "var mac_widthpop=" . $mac_widthpop . ";"); $fc = regReplace($fc, "var\\smac_heightpop\\=(\\d+?)\\;", "var mac_heightpop=" . $mac_heightpop . ";"); $fc = regReplace($fc, "var\\smac_showtop\\=(\\d+?)\\;", "var mac_showtop=" . $mac_showtop . ";"); $fc = regReplace($fc, "var\\smac_showlist\\=(\\d+?)\\;", "var mac_showlist=" . $mac_showlist . ";"); $fc = regReplace($fc, "var\\smac_autofull\\=(\\d+?)\\;", "var mac_autofull=" . $mac_autofull . ";"); $fc = regReplace($fc, "var\\smac_buffer\\=*\"*(\\S+?)'*\"*\\;", "var mac_buffer=\"" . $mac_buffer . "\";"); $fc = regReplace($fc, "var\\smac_prestrain\\=*\"*(\\S+?)'*\"*\\;", "var mac_prestrain=\"" . $mac_prestrain . "\";"); $fc = regReplace($fc, "var\\smac_colors\\=*\"*(\\S+?)'*\"*\\;", "var mac_colors=\"" . $mac_colors . "\";"); fwrite(fopen('../js/playerconfig.js', 'wb'), $fc); redirect('?m=system-configplay'); } elseif ($method == 'configplay') { $plt->set_file('main', $ac . '_' . $method . '.html'); $fp = '../js/playerconfig.js'; if (!file_exists($fp)) { $fp .= '.bak'; } $fc = file_get_contents($fp); $mac_flag = regMatch($fc, "var\\smac_flag\\=(\\d+?)\\;"); $mac_second = regMatch($fc, "var\\smac_second\\=(\\d+?)\\;"); $mac_width = regMatch($fc, "var\\smac_width\\=(\\d+?)\\;"); $mac_height = regMatch($fc, "var\\smac_height\\=(\\d+?)\\;"); $mac_widthpop = regMatch($fc, "var\\smac_widthpop\\=(\\d+?)\\;"); $mac_heightpop = regMatch($fc, "var\\smac_heightpop\\=(\\d+?)\\;");
function scriptHtml($ConStr, $TagName, $FType) { switch ($FType) { case 1: $rule = "<" . $TagName . "([^>])*>"; $ConStr = regReplace($ConStr, $rule, ""); break; case 2: $rule = "<" . $TagName . "([^>])*>.*?</" . $TagName . "([^>])*>"; $ConStr = regReplace($ConStr, $rule, ""); break; case 3: $rule = "<" . $TagName . "([^>])*>"; $ConStr = regReplace($ConStr, $rule, ""); $rule = "</" . $TagName . "([^>])*>"; $ConStr = regReplace($ConStr, $rule, ""); break; case 4: $rule = "<" . $TagName . "([^>])*>"; $ConStr = regReplace($ConStr, $rule, ""); $rule = "</" . $TagName . "([^>])*>"; $ConStr = regReplace($ConStr, $rule, ","); break; } $ConStr = str_replace(chr(9), "", $ConStr); $ConStr = str_replace(chr(10), "", $ConStr); return $ConStr; }
function main() { global $db; $pagenum = be("all", "page"); if (!isNum($pagenum)) { $pagenum = 1; } else { $pagenum = intval($pagenum); } if ($pagenum < 1) { $pagenum = 1; } $sql = "SELECT count(*) FROM {pre}comment"; $nums = $db->getOne($sql); $pagecount = ceil($nums / app_pagenum); $sql = "select c_id,c_type,c_vid,c_rid,c_audit,c_name,c_ip,c_content,c_time from {pre}comment order by c_id desc "; $sql .= " limit " . app_pagenum * ($pagenum - 1) . "," . app_pagenum; $rs = $db->query($sql); ?> <script language="javascript"> $(document).ready(function(){ $('#form1').form({ onSubmit:function(){ if(!$("#form1").valid()) {return false;} }, success:function(data){ $.messager.alert('系统提示', data, 'info',function(){ location.href=location.href; }); } }); $('#form2').form({ onSubmit:function(){ if(!$("#form2").valid()) {return false;} }, success:function(data){ $.messager.alert('系统提示', data, 'info'); } }); $("#btnCancel").click(function(){ location.href= location.href; }); $("#btnDel").click(function(){ if(confirm('确定要删除吗')){ $("#form1").attr("action","admin_ajax.php?action=del&flag=batch&tab={pre}comment"); $("#form1").submit(); } else{return false} }); $("#btnAudit").click(function(){ $("#form1").attr("action","admin_comment.php?action=audit"); $("#form1").submit(); }); }); </script> <form action="" method="post" name="form1" id="form1"> <table class="tb"> <tr> <td width="5%"> </td> <td width="15%">用户</td> <td >内容</td> <td width="20%">来源</td> <td width="15%">时间</td> <td width="10%">IP地址</td> </tr> <?php if ($nums == 0) { ?> <tr><td align="center" colspan="7">没有任何记录!</td></tr> <?php } else { while ($row = $db->fetch_array($rs)) { $c_id = $row["c_id"]; $c_content = $row["c_content"]; $c_content = regReplace($c_content, "\\[em:(\\d{1,})?\\]", "<img src=\"../images/face/\$1.gif\" border=0/>"); ?> <tr> <td><input name="c_id[]" type="checkbox" id="c_id" value="<?php echo $c_id; ?> " /></td> <td><?php echo $row["c_name"]; ?> </td> <td><?php echo $c_content; ?> </td> <td> <?php $vid = $row["c_vid"]; if ($row["c_type"] == 2) { $rowinfo = $db->getRow("select a_id,a_title,a_type from {pre}art where a_id=" . $vid); if (!$rowinfo) { echo "该数据已经被删除"; } else { echo "(" . $vid . ")" . $rowinfo["a_title"]; } unset($rowinfo); } else { $rowinfo = $db->getRow("select d_id,d_name,d_type from {pre}vod where d_id=" . $vid); if (!$rowinfo) { echo "该数据已经被删除"; } else { echo "(" . $vid . ")" . $rowinfo["d_name"]; } unset($rowinfo); } ?> </td> <td><?php echo $row["c_time"]; ?> </td> <td><?php echo $row["c_ip"]; ?> </td> </tr> <?php } } ?> <tr> <td colspan="7">全选<input type="checkbox" name="chkall" id="chkall" class="checkbox" onClick="checkAll(this.checked,'c_id[]')" /> <input type="button" id="btnDel" value="批量删除" class="input" /> </td></tr> <tr align="center"> <td colspan="7"> <?php echo pagelist_manage($pagecount, $pagenum, $nums, app_pagenum, "admin_comment.php?page={p}"); ?> </td> </tr> </table> </form> </body> </html> <?php unset($rs); }
function stepC() { global $db; $app_siteurl = be("post", "app_siteurl"); $app_sitename = be("post", "app_sitename"); $app_installdir = be("post", "app_installdir"); $app_keywords = be("post", "app_keywords"); $app_description = be("post", "app_description"); $app_dbtype = be("post", "app_dbtype"); $app_dbpath = "inc/" & be("post", "app_dbpath"); $app_dbserver = be("post", "app_dbserver"); $app_dbname = be("post", "app_dbname"); $app_dbuser = be("post", "app_dbuser"); $app_dbpass = be("post", "app_dbpass"); $app_tablepre = be("post", "app_tablepre"); $m_name = be("post", "m_name"); $m_password1 = be("post", "m_password1"); $m_password2 = be("post", "m_password2"); $app_safecode = be("post", "app_safecode"); show_step(3, "安装数据库", "正在执行数据库安装写入配置文件"); echo <<<EOT \t<div class="main"> \t<div class="btnbox"><div id="notice"></div></div> \t<div class="btnbox margintop marginbot"><form method="get" autocomplete="off" action="index.php"> \t<table class="tb2 btn2" style="margin-top:10px; width:100%;"><tr><th class="tbopt" align="left"> </th><td> <input type="hidden" name="action" value="d" /><div class="btnbox marginbot"><input class="left btnpre" type="button" onclick="history.back();" value="上一步"><input class="right btnnext" type="submit" value="下一步"></td><td></td></tr></table></form></div> EOT; $configstr = file_get_contents("../inc/config.php"); $configstr = regReplace($configstr, "\"app_siteurl\",\"(\\S*?)\"", "\"app_siteurl\",\"" . $app_siteurl . "\""); $configstr = regReplace($configstr, "\"app_installdir\",\"(\\S*?)\"", "\"app_installdir\",\"" . $app_installdir . "\""); $configstr = regReplace($configstr, "\"app_keywords\",\"(\\S*?)\"", "\"app_keywords\",\"" . $app_keywords . "\""); $configstr = regReplace($configstr, "\"app_description\",\"(\\S*?)\"", "\"app_description\",\"" . $app_description . "\""); $configstr = regReplace($configstr, "\"app_dbtype\",\"(\\S*?)\"", "\"app_dbtype\",\"" . $app_dbtype . "\""); $configstr = regReplace($configstr, "\"app_dbpath\",\"(\\S*?)\"", "\"app_dbpath\",\"" . $app_dbpath . "\""); $configstr = regReplace($configstr, "\"app_dbserver\",\"(\\S*?)\"", "\"app_dbserver\",\"" . $app_dbserver . "\""); $configstr = regReplace($configstr, "\"app_dbname\",\"(\\S*?)\"", "\"app_dbname\",\"" . $app_dbname . "\""); $configstr = regReplace($configstr, "\"app_dbuser\",\"(\\S*?)\"", "\"app_dbuser\",\"" . $app_dbuser . "\""); $configstr = regReplace($configstr, "\"app_dbpass\",\"(\\S*?)\"", "\"app_dbpass\",\"" . $app_dbpass . "\""); $configstr = regReplace($configstr, "\"app_safecode\",\"(\\S*?)\"", "\"app_safecode\",\"" . $app_safecode . "\""); $configstr = regReplace($configstr, "\"app_tablepre\",\"(\\S*?)\"", "\"app_tablepre\",\"" . $app_tablepre . "\""); $configstr = regReplace($configstr, "\"app_install\",(\\S*?)\\)\\;", "\"app_install\",1);"); fwrite(fopen("../inc/config.php", "wb"), $configstr); echo '<script type="text/javascript">showmessage(\'写入网站配置文件... 成功 \');</script>'; error_reporting(E_NOTICE); $dbck = false; $lnk = @mysql_connect($app_dbserver, $app_dbuser, $app_dbpass); if (!$lnk) { echo '<script type="text/javascript">showmessage(\'数据库设置出错:mysql请检查数据库连接信息... \');</script>'; } else { if (!@mysql_select_db($app_dbname, $lnk)) { echo '<script type="text/javascript">showmessage(\'数据库服务器连接成功,没有找到【 ' . $app_dbname . ' 】数据... \');</script>'; } else { $dbck = true; } } error_reporting(7); if ($dbck) { $db = new AppDataBase($app_dbserver, $app_dbuser, $app_dbpass, $app_dbname); $app_tablepre = ''; echo '<script type="text/javascript">showmessage(\'开始创建数据库结构... \');</script>'; if (!isExistTable("" . $app_tablepre . "apk_category", $app_dbname)) { $db->query("CREATE TABLE `" . $app_tablepre . "apk_category` (`id` int(11) NOT NULL AUTO_INCREMENT,\r\n `parent_id` int(11) DEFAULT NULL,\r\n `name` varchar(250) DEFAULT NULL,\r\n \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`status` int(11) NOT NULL DEFAULT '1',\r\n \t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t`disp_order` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `type_desc` text NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `type_key` varchar(100) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `t_hide` int(11) NOT NULL DEFAULT '1',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`id`))ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=9 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $app_tablepre . 'apk_category... \');</script>'; } if (!isExistTable("" . $app_tablepre . "apk_company", $app_dbname)) { $db->query("CREATE TABLE `" . $app_tablepre . "apk_company` ( `id` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `name` varchar(250) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `email` varchar(60) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `contact` varchar(50) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `zipcode` varchar(10) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `adress` varchar(450) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `description` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `status` int(11) NOT NULL DEFAULT '1',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=5 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $app_tablepre . 'apk_company... \');</script>'; } if (!isExistTable("" . $app_tablepre . "apk_device", $app_dbname)) { $db->query("CREATE TABLE `" . $app_tablepre . "apk_device` (`id` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `device_name` varchar(250) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `device_mac_address` varchar(50) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `pin_code` varchar(50) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `channel_name` varchar(200) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`id`)) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=82 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $app_tablepre . 'apk_device... \');</script>'; } if (!isExistTable("" . $app_tablepre . "apk_master_base", $app_dbname)) { $db->query("CREATE TABLE `" . $app_tablepre . "apk_master_base` (`id` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `company_id` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `company_name` varchar(250) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `package_name` varchar(250) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `category_id` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `category_name` varchar(250) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `create_date` datetime DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `status` int(11) NOT NULL DEFAULT '1',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `download_count` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `upload_count` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `disp_order` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `apk_tag` varchar(1150) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `app_name` varchar(100) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `description` text NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `latest_item_id` int(11) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `apk_icon` varchar(300) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`id`)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=30 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $app_tablepre . 'apk_master_base... \');</script>'; } if (!isExistTable("" . $app_tablepre . "apk_master_info", $app_dbname)) { $db->query("CREATE TABLE `" . $app_tablepre . "apk_master_info` (`id` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `app_id` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `language_id` varchar(10) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `display_name` varchar(350) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `description` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`id`)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=30 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $app_tablepre . 'apk_master_info... \');</script>'; } if (!isExistTable("" . $app_tablepre . "apk_master_items", $app_dbname)) { $db->query("CREATE TABLE `" . $app_tablepre . "apk_master_items` (`id` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `apk_id` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `file_url` varchar(350) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `file_type` varchar(20) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `qiniu_file_key` varchar(150) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `file_size` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `status` int(11) NOT NULL DEFAULT '1',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `md5` varchar(50) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `version_code` varchar(10) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `version_name` varchar(20) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `min_sdk_version` varchar(10) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `target_sdk_version` varchar(10) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `file_name` varchar(50) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `package_name` varchar(250) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `create_date` datetime DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `disp_order` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `upload_count` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `download_count` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `description` varchar(50) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `apk_icon` varchar(300) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`id`)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=58 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $app_tablepre . 'apk_master_items... \');</script>'; } if (!isExistTable("" . $app_tablepre . "apk_master_temp", $app_dbname)) { $db->query("CREATE TABLE `" . $app_tablepre . "apk_master_temp` ( `id` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `apk_id` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `package_name` varchar(250) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `upload_count` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `file_url` varchar(350) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `file_type` varchar(20) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `qiniu_file_key` varchar(150) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `file_size` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `status` int(11) NOT NULL DEFAULT '1',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `md5` varchar(50) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `version_code` varchar(10) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `version_name` varchar(20) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `min_sdk_version` varchar(10) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `target_sdk_version` varchar(10) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `file_name` varchar(50) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `create_date` datetime DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `app_name` varchar(100) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `state` int(11) NOT NULL DEFAULT '1',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `description` text NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `author_id` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `apk_icon` varchar(300) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`id`)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=32 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $app_tablepre . 'apk_master_temp... \');</script>'; } if (!isExistTable("" . $app_tablepre . "apk_meta_lang", $app_dbname)) { $db->query("CREATE TABLE `" . $app_tablepre . "apk_meta_lang` (`id` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `meta_key` varchar(100) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `language_id` varchar(10) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `meta_des` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`id`)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $app_tablepre . 'apk_meta_lang... \');</script>'; } if (!isExistTable("" . $app_tablepre . "apk_push_msg_history", $app_dbname)) { $db->query("CREATE TABLE `" . $app_tablepre . "apk_push_msg_history` (`id` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `package_name` varchar(250) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `file_url` varchar(350) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `qiniu_file_key` varchar(150) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `status` int(11) NOT NULL DEFAULT '1',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `file_name` varchar(50) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `version_code` varchar(10) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `version_name` varchar(20) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `md5` varchar(50) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `create_date` datetime DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `app_name` varchar(100) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `mac_address` varchar(300) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`id`)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=8 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $app_tablepre . 'apk_push_msg_history... \');</script>'; } if (!isExistTable("" . $app_tablepre . "mac_cj_change", $app_dbname)) { $db->query("CREATE TABLE `" . $app_tablepre . "mac_cj_change` (`c_id` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `c_name` varchar(64) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `c_toid` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `c_pid` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `c_type` int(4) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `c_sys` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`c_id`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `i_c_projectid` (`c_pid`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `i_c_type` (`c_type`)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $app_tablepre . 'mac_cj_change... \');</script>'; } if (!isExistTable("" . $app_tablepre . "mac_cj_filters", $app_dbname)) { $db->query("CREATE TABLE `" . $app_tablepre . "mac_cj_filters` ( `f_id` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `f_name` varchar(64) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `f_object` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `f_type` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `f_content` varchar(64) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `f_strstart` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `f_strend` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `f_rep` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `f_flag` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `f_pid` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `f_sys` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`f_id`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `i_f_type` (`f_type`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `i_f_object` (`f_object`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `i_f_projectid` (`f_pid`)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $app_tablepre . 'mac_cj_filters... \');</script>'; } if (!isExistTable("" . $app_tablepre . "mac_cj_vod", $app_dbname)) { $db->query("CREATE TABLE `" . $app_tablepre . "mac_cj_vod` (`m_id` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `m_pid` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `m_name` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `m_type` varchar(64) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `m_typeid` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `m_area` varchar(64) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `m_playfrom` varchar(64) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `m_starring` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `m_directed` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `m_pic` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `m_content` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `m_year` varchar(64) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `m_addtime` varchar(64) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `m_urltest` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `m_zt` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `m_playserver` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `m_hits` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `m_state` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `m_language` varchar(64) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `m_remarks` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `duraning` varchar(10) NOT NULL DEFAULT '',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `can_search_device` varchar(300) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `m_pic_ipad` varchar(500) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`m_id`)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=54350 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $app_tablepre . 'mac_cj_vod... \');</script>'; } if (!isExistTable("" . $app_tablepre . "mac_cj_vod_projects", $app_dbname)) { $db->query("CREATE TABLE `" . $app_tablepre . "mac_cj_vod_projects` (`p_id` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_name` varchar(128) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_coding` varchar(64) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_playtype` varchar(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_pagetype` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_url` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_pagebatchurl` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_manualurl` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_pagebatchid1` varchar(128) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_pagebatchid2` varchar(128) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_script` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_showtype` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_collecorder` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_savefiles` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_intolib` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_ontime` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_listcodestart` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_listcodeend` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_classtype` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_collect_type` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_time` datetime DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_listlinkstart` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_listlinkend` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_starringtype` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_starringstart` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_starringend` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_titletype` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_titlestart` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_titleend` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_pictype` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_picstart` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_picend` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_timestart` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_timeend` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_areastart` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_areaend` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_typestart` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_typeend` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_contentstart` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_contentend` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_playcodetype` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_playcodestart` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_playcodeend` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_playurlstart` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_playurlend` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_playlinktype` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_playlinkstart` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_playlinkend` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_playspecialtype` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_playspecialrrul` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_playspecialrerul` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_server` varchar(128) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_hitsstart` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_hitsend` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_lzstart` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_lzend` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_colleclinkorder` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_lzcodetype` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_lzcodestart` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_lzcodeend` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_languagestart` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_languageend` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_remarksstart` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_remarksend` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_directedstart` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_directedend` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_setnametype` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_setnamestart` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_setnameend` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_playcodeApiUrl` varchar(300) NOT NULL DEFAULT '',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_playcodeApiUrltype` int(1) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_playcodeApiUrlParamstart` varchar(300) NOT NULL DEFAULT '',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_playcodeApiUrlParamend` varchar(300) NOT NULL DEFAULT '',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_videocodeApiUrl` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_videocodeApiUrlParamstart` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_videocodeApiUrlParamend` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_videourlstart` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_videourlend` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `p_videocodeType` int(1) DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`p_id`)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=186 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $app_tablepre . 'mac_cj_vod_projects... \');</script>'; } if (!isExistTable("" . $app_tablepre . "mac_cj_vod_url", $app_dbname)) { $db->query("CREATE TABLE `" . $app_tablepre . "mac_cj_vod_url` (`u_id` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `u_url` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `u_weburl` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `u_movieid` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `iso_video_url` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `android_vedio_url` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `name` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `pic` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `time` varchar(10) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `u_desc` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`u_id`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `i_u_movieid` (`u_movieid`)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=649433 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $app_tablepre . 'mac_cj_vod_url... \');</script>'; } if (!isExistTable("" . $app_tablepre . "mac_cj_zhuiju", $app_dbname)) { $db->query("CREATE TABLE `" . $app_tablepre . "mac_cj_zhuiju` (`m_id` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `m_pid` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `m_name` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `m_typeid` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `m_playfrom` varchar(64) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `m_urltest` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `crontab_desc` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `status` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`m_id`)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=54350 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $app_tablepre . 'mac_cj_zhuiju... \');</script>'; } if (!isExistTable("" . $app_tablepre . "mac_comment", $app_dbname)) { $db->query("CREATE TABLE `" . $app_tablepre . "mac_comment` (`c_id` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `c_type` int(11) DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `c_vid` int(11) DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `c_rid` int(11) DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `c_audit` int(11) DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `c_name` varchar(64) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `c_ip` varchar(32) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `c_content` varchar(128) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `c_time` datetime DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`c_id`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `c_vid` (`c_vid`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `c_type` (`c_type`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `c_rid` (`c_rid`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `c_time` (`c_time`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `c_audit` (`c_audit`)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16249 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $app_tablepre . 'mac_comment... \');</script>'; } if (!isExistTable("" . $app_tablepre . "mac_manager", $app_dbname)) { $db->query("CREATE TABLE `" . $app_tablepre . "mac_manager` (`m_id` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `m_name` varchar(32) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `m_password` varchar(32) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `m_levels` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `m_status` int(11) DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `m_logintime` datetime DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `m_loginip` varchar(32) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `m_random` varchar(64) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`m_id`)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=22 ;\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $app_tablepre . 'mac_manager... \');</script>'; } if (!isExistTable("" . $app_tablepre . "mac_thirdpart_config", $app_dbname)) { $db->query("CREATE TABLE `" . $app_tablepre . "mac_thirdpart_config` (`id` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `device_name` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `company_name` varchar(250) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `api_url` varchar(250) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `logo_url` varchar(250) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `app_key` varchar(250) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `create_date` datetime DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `status` int(11) NOT NULL DEFAULT '1',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `user_id` int(11) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`id`)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=16 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $app_tablepre . 'mac_thirdpart_config... \');</script>'; } if (!isExistTable("" . $app_tablepre . "mac_vod", $app_dbname)) { $db->query("CREATE TABLE `" . $app_tablepre . "mac_vod` (`d_id` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_name` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_subname` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_enname` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_type` int(11) DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_letter` char(1) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_state` int(11) DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_color` varchar(8) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_pic` varchar(800) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_starring` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_directed` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_area` varchar(32) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_year` varchar(32) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_language` varchar(32) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_level` int(11) DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_stint` int(11) DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_hits` int(11) DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_dayhits` int(11) DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_weekhits` int(11) DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_monthhits` int(11) DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_topic` int(11) DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_content` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_remarks` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_hide` int(11) DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_good` int(11) DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_bad` int(11) DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_usergroup` int(11) DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_score` float DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_scorecount` int(11) DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_addtime` datetime DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_time` datetime DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_hitstime` datetime DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_playfrom` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_playserver` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_playurl` longtext,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_downurl` longtext,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `webUrls` longtext NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `publish_owner_id` int(11) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `love_user_count` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `watch_user_count` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `favority_user_count` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_type_name` varchar(100) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_pic_ipad` varchar(1600) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `share_number` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `good_number` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `total_comment_number` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_pic_ipad_tmp` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_play_check` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_play_num` bigint(20) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_video_desc_url` varchar(255) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_douban_id` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `can_play_device` int(2) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_day_play_num` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_status` int(3) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `can_search_device` varchar(300) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `duraning` varchar(10) NOT NULL DEFAULT '',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_capital_name` varchar(20) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`d_id`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `d_type` (`d_type`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `d_state` (`d_state`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `d_level` (`d_level`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `d_hits` (`d_hits`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `d_dayhits` (`d_dayhits`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `d_weekhits` (`d_weekhits`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `d_monthhits` (`d_monthhits`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `d_stint` (`d_stint`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `d_hide` (`d_hide`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `d_score` (`d_score`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `d_topic` (`d_topic`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `d_letter` (`d_letter`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `d_name` (`d_name`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `d_starring` (`d_starring`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `d_directed` (`d_directed`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `d_type_name_index` (`d_type_name`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `d_id_index` (`d_id`)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=984429 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $app_tablepre . 'mac_vod... \');</script>'; } if (!isExistTable("" . $app_tablepre . "mac_vod_pasre_item", $app_dbname)) { $db->query("CREATE TABLE `" . $app_tablepre . "mac_vod_pasre_item` (`id` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `prod_id` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `prod_name` varchar(300) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `create_date` datetime DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `d_status` int(2) DEFAULT '1',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `channels` text NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`id`)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=50 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $app_tablepre . 'mac_vod_pasre_item... \');</script>'; } if (!isExistTable("" . $app_tablepre . "mac_vod_popular", $app_dbname)) { $db->query("CREATE TABLE `" . $app_tablepre . "mac_vod_popular` (`id` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `iphone_pic_url` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `vod_id` int(11) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `ipad_pic_url` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `disp_order` int(11) NOT NULL DEFAULT '1',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `status` int(11) NOT NULL DEFAULT '1',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `info_desc` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `type` int(11) DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`id`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t UNIQUE KEY `vod_id_unique` (`vod_id`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `vod_id_index` (`vod_id`)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=42 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $app_tablepre . 'mac_vod_popular... \');</script>'; } if (!isExistTable("" . $app_tablepre . "mac_vod_subscribe", $app_dbname)) { $db->query("CREATE TABLE `" . $app_tablepre . "mac_vod_subscribe` (`id` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `prod_id` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `create_date` datetime DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `subscriber_num` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `prod_name` varchar(300) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `author_id` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`id`)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=3 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $app_tablepre . 'mac_vod_subscribe... \');</script>'; } if (!isExistTable("" . $app_tablepre . "mac_vod_topic", $app_dbname)) { $db->query("CREATE TABLE `" . $app_tablepre . "mac_vod_topic` (`t_id` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `t_name` varchar(64) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `t_enname` varchar(128) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `t_sort` int(11) DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `t_template` varchar(128) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `t_pic` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `t_des` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `t_type` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `t_flag` int(1) DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `t_userid` int(11) DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `create_date` datetime DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `t_bdtype` int(1) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `t_toptype` int(11) DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `t_tag_name` varchar(1000) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `can_search_device` varchar(300) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`t_id`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `t_sort` (`t_sort`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `t_userid` (`t_userid`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `t_id` (`t_id`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `t_bdtype` (`t_bdtype`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `t_flag` (`t_flag`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `t_type` (`t_type`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `t_name_index` (`t_name`)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=7285 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $app_tablepre . 'mac_vod_topic... \');</script>'; } if (!isExistTable("" . $app_tablepre . "mac_vod_topic_items", $app_dbname)) { $db->query("CREATE TABLE `" . $app_tablepre . "mac_vod_topic_items` (`id` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `topic_id` int(11) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `author_id` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `vod_id` int(11) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `vod_name` varchar(150) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `vod_pic` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `vod_pic_ipad` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `flag` int(1) DEFAULT '1',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `disp_order` int(5) DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `create_date` datetime DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`id`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t UNIQUE KEY `unique_key` (`topic_id`,`vod_id`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `author_id` (`author_id`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `vod_id` (`vod_id`)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=latin1 AUTO_INCREMENT=7244 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $app_tablepre . 'mac_vod_topic_items... \');</script>'; } if (!isExistTable("" . $app_tablepre . "mac_vod_type", $app_dbname)) { $db->query("CREATE TABLE `" . $app_tablepre . "mac_vod_type` (`t_id` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `t_name` varchar(64) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `t_enname` varchar(128) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `t_sort` int(11) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `t_pid` int(11) DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `t_key` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `t_des` varchar(255) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `t_template` varchar(64) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `t_vodtemplate` varchar(64) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `t_playtemplate` varchar(64) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `t_hide` int(11) DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `t_union` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`t_id`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `t_sort` (`t_sort`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `t_pid` (`t_pid`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `t_hide` (`t_hide`)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=174 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $app_tablepre . 'mac_vod_type... \');</script>'; } if (!isExistTable("" . $app_tablepre . "tbl_comments", $app_dbname)) { $db->query("CREATE TABLE `" . $app_tablepre . "tbl_comments` (`id` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `author_id` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `content_type` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `content_name` varchar(50) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `content_id` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `create_date` datetime DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `status` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `like_number` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `content_pic_url` varchar(300) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `comments` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `thread_id` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `thread_author_id` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `author_photo_url` varchar(300) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `author_username` varchar(50) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `comments_leaf` tinyint(4) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `comment_type` int(2) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `douban_comment_id` int(11) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `comment_title` varchar(300) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`id`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `FK_Reference_5` (`content_id`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `FK_Reference_7` (`author_id`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `FK_Reference_8` (`thread_id`)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=38745 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $app_tablepre . 'tbl_comments... \');</script>'; } if (!isExistTable("" . $app_tablepre . "tbl_feedback", $app_dbname)) { $db->query("CREATE TABLE `" . $app_tablepre . "tbl_feedback` (`id` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `author_id` int(11) DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `author_name` varchar(255) DEFAULT '',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `email` varchar(255) DEFAULT '',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `content` text NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `ip` varchar(255) DEFAULT '',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `user_agent` varchar(455) DEFAULT '',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `create_time` datetime NOT NULL DEFAULT '0000-00-00 00:00:00',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`id`)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) ENGINE=InnoDB DEFAULT CHARSET=utf8 AUTO_INCREMENT=14 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $app_tablepre . 'tbl_feedback... \');</script>'; } if (!isExistTable("" . $app_tablepre . "tbl_lookup", $app_dbname)) { $db->query("CREATE TABLE `" . $app_tablepre . "tbl_lookup` (`id` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `content` varchar(50) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `search_count` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `last_search_date` datetime DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `keyword_order` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`id`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `i_content` (`content`)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1883 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $app_tablepre . 'tbl_lookup... \');</script>'; } if (!isExistTable("" . $app_tablepre . "tbl_my_dynamic", $app_dbname)) { $db->query("CREATE TABLE `" . $app_tablepre . "tbl_my_dynamic` (`id` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `author_id` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `content_type` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `content_name` varchar(50) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `content_id` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `create_date` datetime DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `status` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `order_position` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `dynamic_type` tinyint(4) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `content_pic_url` varchar(300) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `content_desc` varchar(300) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`id`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `i_author_id` (`author_id`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `i_dynamic_type` (`dynamic_type`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `content_id` (`content_id`)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2353 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $app_tablepre . 'tbl_my_dynamic... \');</script>'; } if (!isExistTable("" . $app_tablepre . "tbl_my_friend", $app_dbname)) { $db->query("CREATE TABLE `" . $app_tablepre . "tbl_my_friend` ( `id` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `author_id` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `friend_id` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `create_date` datetime DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `status` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `friend_photo_url` varchar(300) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `friend_username` varchar(50) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`id`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `FK_Reference_2` (`friend_id`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `i_author_id` (`author_id`)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1450 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $app_tablepre . 'tbl_my_friend... \');</script>'; } if (!isExistTable("" . $app_tablepre . "tbl_notfiy_msg", $app_dbname)) { $db->query("CREATE TABLE `" . $app_tablepre . "tbl_notfiy_msg` ( `id` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `author_id` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `notify_type` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `nofity_user_id` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `notify_user_name` varchar(80) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `content_id` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `content_info` varchar(300) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `status` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `created_date` datetime DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `notify_user_pic_url` varchar(300) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `content_type` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `content_desc` varchar(300) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`id`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `i_author_id` (`author_id`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `i_notify_type` (`notify_type`)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=440 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $app_tablepre . 'tbl_notfiy_msg... \');</script>'; } if (!isExistTable("" . $app_tablepre . "tbl_play_history", $app_dbname)) { $db->query("CREATE TABLE `" . $app_tablepre . "tbl_play_history` (`id` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `author_id` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `prod_type` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `prod_name` varchar(100) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `prod_subname` varchar(200) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `prod_id` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `create_date` datetime DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `status` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `play_type` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `playback_time` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `video_url` varchar(500) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `duration` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`id`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `i_author_id` (`author_id`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `i_prod_type` (`prod_type`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `i_prod_id` (`prod_id`)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=1537 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $app_tablepre . 'tbl_play_history... \');</script>'; } if (!isExistTable("" . $app_tablepre . "tbl_play_records", $app_dbname)) { $db->query("CREATE TABLE `" . $app_tablepre . "tbl_play_records` (`id` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `author_id` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `prod_type` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `prod_name` varchar(100) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `prod_subname` varchar(200) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `client` varchar(100) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `prod_id` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `create_date` datetime DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`id`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `i_author_id` (`author_id`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `i_prod_type` (`prod_type`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `i_prod_id` (`prod_id`)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $app_tablepre . 'tbl_play_records... \');</script>'; } if (!isExistTable("" . $app_tablepre . "tbl_system_config", $app_dbname)) { $db->query("CREATE TABLE `" . $app_tablepre . "tbl_system_config` (`id` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `sys_value` text,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `sys_key` varchar(100) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `create_date` datetime DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `sys_desc` varchar(500) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `status` int(11) DEFAULT '1',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`id`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t UNIQUE KEY `sys_key_unique` (`sys_key`)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=4 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $app_tablepre . 'tbl_system_config... \');</script>'; } if (!isExistTable("" . $app_tablepre . "tbl_user", $app_dbname)) { $db->query("CREATE TABLE `" . $app_tablepre . "tbl_user` (`id` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `username` varchar(100) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `password` varchar(50) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `email` varchar(50) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `phone` varchar(20) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `sina_wb_user_id` varchar(50) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `qq_wb_user_id` varchar(50) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `ren_user_id` varchar(50) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `douban_user_id` varchar(50) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `create_date` datetime DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `last_modify_date` datetime DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `last_login_date` datetime DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `user_photo_url` varchar(200) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `user_bg_photo_url` varchar(200) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `status` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `signature` varchar(300) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `other_part_one_user_id` varchar(50) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `other_part_two_user_id` varchar(50) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `other_part_three_user_id` varchar(50) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `other_part_four_user_id` varchar(50) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `like_number` int(11) DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `watch_number` int(11) DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `fan_number` int(11) DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `category` varbinary(20) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `grade` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `prestige` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `nickname` varchar(80) NOT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `good_number` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `top_number` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `favority_number` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `share_number` int(11) NOT NULL DEFAULT '0',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `device_number` varchar(300) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `device_type` varchar(200) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`id`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `i_username` (`username`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `i_phone` (`phone`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `i_sina_wb_user_id` (`sina_wb_user_id`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `i_douban_user_id` (`douban_user_id`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `i_ren_user_id` (`ren_user_id`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `i_qq_wb_user_id` (`qq_wb_user_id`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `i_prestige` (`prestige`)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2869 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $app_tablepre . 'tbl_user... \');</script>'; } if (!isExistTable("" . $app_tablepre . "tbl_video_feedback", $app_dbname)) { $db->query("CREATE TABLE `" . $app_tablepre . "tbl_video_feedback` (`id` int(11) NOT NULL AUTO_INCREMENT,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `author_id` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `prod_type` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `prod_name` varchar(100) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `client` varchar(100) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `prod_id` int(11) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `create_date` datetime DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `feedback_memo` varchar(1000) DEFAULT NULL,\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `feedback_type` varchar(50) NOT NULL DEFAULT '8',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t `status` int(11) NOT NULL DEFAULT '1',\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t PRIMARY KEY (`id`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `i_author_id` (`author_id`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `i_prod_type` (`prod_type`),\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t KEY `i_prod_id` (`prod_id`)\r\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t) ENGINE=MyISAM DEFAULT CHARSET=utf8 AUTO_INCREMENT=2970 ;"); echo '<script type="text/javascript">showmessage(\'创建数据表 ' . $app_tablepre . 'tbl_video_feedback... \');</script>'; } echo '<script type="text/javascript">showmessage(\'数据库结构创建完成... \');</script>'; $db->query("insert into " . $app_tablepre . "mac_manager(m_id,m_name,m_password,m_status,m_levels) values('1','" . $m_name . "','" . md5($m_password1) . "',1,'2, 4, 6, 7, 8 ,9, 10')"); echo '<script type="text/javascript">showmessage(\'管理员帐号' . $m_name . '初始化成功... \');</script>'; $db->query("\r\n\t\t\t\t\tINSERT INTO `mac_vod_type` (`t_id`, `t_name`, `t_enname`, `t_sort`, `t_pid`, `t_key`, `t_des`, `t_template`, `t_vodtemplate`, `t_playtemplate`, `t_hide`, `t_union`) VALUES\r\n\t\t\t\t\t(1, '电影', 'dianying', 1, 0, '', '', 'vodlist.html', 'vod.html', 'vodplay.html', 0, ''),\r\n\t\t\t\t\t(2, '连续剧', 'lianxuju', 2, 0, '', '', 'vodlist.html', 'vod.html', 'vodplay.html', 0, ',114_7,'),\r\n\t\t\t\t\t(3, '综艺', 'zongyi', 3, 0, '', '', 'vodlist.html', 'vod.html', 'vodplay.html', 0, ',114_16,'),\r\n\t\t\t\t\t(4, '视频', 'shiping', 4, 0, '', '', 'vodlist.html', 'vod.html', 'vodplay.html', 1, ''),\r\n\t\t\t\t\t\r\n\t\t\t\t\t(131, '动漫', '动漫', 83, 0, '动漫', '动漫', 'vodlist.html', 'vod.html', 'vodplay.html', 0, NULL),\r\n\t\t\t\t\t(132, '记录片', '记录片', 84, 0, '记录片', '记录片', 'vodlist.html', 'vod.html', 'vodplay.html', 1, NULL),\r\n\t\t\t\t\t(133, '教育', '教育', 85, 0, '教育', '教育', 'vodlist.html', 'vod.html', 'vodplay.html', 0, NULL),\r\n\t\t\t\t\t(173, '混合类', 'hunhelei', 125, 0, 'hunhelei', 'hunhelei', 'vodlist.html', 'vod.html', 'vodplay.html', 0, NULL);"); $file = "joyplus.sql"; if (file_exists($file)) { global $db; $buffer = ''; // Defaults for parser $sql = ''; $start_pos = 0; $i = 0; $len = 0; $big_value = 2147483647; $delimiter_keyword = 'DELIMITER '; // include the space because it's mandatory $length_of_delimiter_keyword = strlen($delimiter_keyword); $buffer = iconv("UTF-8", "UTF-8", file_get_contents($file)); $len = strlen($buffer); $GLOBALS['finished'] = true; $sql_delimiter = ';'; while ($i < $len) { $found_delimiter = false; // Find first interesting character $old_i = $i; // this is about 7 times faster that looking for each sequence i // one by one with strpos() if (preg_match('/(\'|"|#|-- |\\/\\*|`|(?i)(?<![A-Z0-9_])' . $delimiter_keyword . ')/', $buffer, $matches, PREG_OFFSET_CAPTURE, $i)) { // in $matches, index 0 contains the match for the complete // expression but we don't use it $first_position = $matches[1][1]; } else { $first_position = $big_value; } /** * @todo we should not look for a delimiter that might be * inside quotes (or even double-quotes) */ // the cost of doing this one with preg_match() would be too high $first_sql_delimiter = strpos($buffer, $sql_delimiter, $i); if ($first_sql_delimiter === false) { $first_sql_delimiter = $big_value; } else { $found_delimiter = true; } // set $i to the position of the first quote, comment.start or delimiter found $i = min($first_position, $first_sql_delimiter); if ($i == $big_value) { // none of the above was found in the string $i = $old_i; if (!$GLOBALS['finished']) { break; } // at the end there might be some whitespace... if (trim($buffer) == '') { $buffer = ''; $len = 0; break; } // We hit end of query, go there! $i = strlen($buffer) - 1; } // Grab current character $ch = $buffer[$i]; // Quotes if (strpos('\'"`', $ch) !== false) { $quote = $ch; $endq = false; while (!$endq) { // Find next quote $pos = strpos($buffer, $quote, $i + 1); /* * Behave same as MySQL and accept end of query as end of backtick. * I know this is sick, but MySQL behaves like this: * * SELECT * FROM `table * * is treated like * * SELECT * FROM `table` */ if ($pos === false && $quote == '`' && $found_delimiter) { $pos = $first_sql_delimiter - 1; // No quote? Too short string } elseif ($pos === false) { // We hit end of string => unclosed quote, but we handle it as end of query if ($GLOBALS['finished']) { $endq = true; $i = $len - 1; } $found_delimiter = false; break; } // Was not the quote escaped? $j = $pos - 1; while ($buffer[$j] == '\\') { $j--; } // Even count means it was not escaped $endq = ($pos - 1 - $j) % 2 == 0; // Skip the string $i = $pos; if ($first_sql_delimiter < $pos) { $found_delimiter = false; } } if (!$endq) { break; } $i++; // Aren't we at the end? if ($GLOBALS['finished'] && $i == $len) { $i--; } else { continue; } } // Not enough data to decide if (($i == $len - 1 && ($ch == '-' || $ch == '/') || $i == $len - 2 && ($ch == '-' && $buffer[$i + 1] == '-' || $ch == '/' && $buffer[$i + 1] == '*')) && !$GLOBALS['finished']) { break; } // Comments if ($ch == '#' || $i < $len - 1 && $ch == '-' && $buffer[$i + 1] == '-' && ($i < $len - 2 && $buffer[$i + 2] <= ' ' || $i == $len - 1 && $GLOBALS['finished']) || $i < $len - 1 && $ch == '/' && $buffer[$i + 1] == '*') { // Copy current string to SQL if ($start_pos != $i) { $sql .= substr($buffer, $start_pos, $i - $start_pos); } // Skip the rest $start_of_comment = $i; // do not use PHP_EOL here instead of "\n", because the export // file might have been produced on a different system $i = strpos($buffer, $ch == '/' ? '*/' : "\n", $i); // didn't we hit end of string? if ($i === false) { if ($GLOBALS['finished']) { $i = $len - 1; } else { break; } } // Skip * if ($ch == '/') { $i++; } // Skip last char $i++; // We need to send the comment part in case we are defining // a procedure or function and comments in it are valuable $sql .= substr($buffer, $start_of_comment, $i - $start_of_comment); // Next query part will start here $start_pos = $i; // Aren't we at the end? if ($i == $len) { $i--; } else { continue; } } // Change delimiter, if redefined, and skip it (don't send to server!) if (strtoupper(substr($buffer, $i, $length_of_delimiter_keyword)) == $delimiter_keyword && $i + $length_of_delimiter_keyword < $len) { // look for EOL on the character immediately after 'DELIMITER ' // (see previous comment about PHP_EOL) $new_line_pos = strpos($buffer, "\n", $i + $length_of_delimiter_keyword); // it might happen that there is no EOL if (false === $new_line_pos) { $new_line_pos = $len; } $sql_delimiter = substr($buffer, $i + $length_of_delimiter_keyword, $new_line_pos - $i - $length_of_delimiter_keyword); $i = $new_line_pos + 1; // Next query part will start here $start_pos = $i; continue; } // End of SQL if ($found_delimiter || $GLOBALS['finished'] && $i == $len - 1) { $tmp_sql = $sql; if ($start_pos < $len) { $length_to_grab = $i - $start_pos; if (!$found_delimiter) { $length_to_grab++; } $tmp_sql .= substr($buffer, $start_pos, $length_to_grab); unset($length_to_grab); } // Do not try to execute empty SQL if (!preg_match('/^([\\s]*;)*$/', trim($tmp_sql))) { $sql = $tmp_sql; $sql = preg_replace("/--.*\n/iU", "", $sql); //去掉注释 $sql = trim($sql); if (stripos($sql, "CREATE") !== false && stripos($sql, "CREATE") == 0 || stripos($sql, "INSERT") !== false && strpos($sql, "INSERT") == 0 || stripos($sql, "UPDATE") !== false && strpos($sql, "UPDATE") == 0 || stripos($sql, "DELETE") !== false && strpos($sql, "DELETE") == 0) { $rs2 = $db->query($sql); } else { $sql = str_replace("/*!40101", "", $sql); $sql = str_replace("*/", "", $sql); $rs2 = $db->query($sql); } $buffer = substr($buffer, $i + strlen($sql_delimiter)); $len = strlen($buffer); $sql = ''; $i = 0; $start_pos = 0; // Any chance we will get a complete query? //if ((strpos($buffer, ';') === false) && !$GLOBALS['finished']) { if (strpos($buffer, $sql_delimiter) === false && !$GLOBALS['finished']) { break; } } else { $i++; $start_pos = $i; } } } } echo '<script type="text/javascript">showmessage(\'数据分类初始化成功... \');</script>'; updateCacheFile(); echo '<script type="text/javascript">showmessage(\'数据缓存初始化成功... \');</script>'; } unset($db); }
/** * Gets the snake-case of the string using `$delimiter` as separator. * ``` * $underscoreCase = snakeCase('_'); * $underscoreCase('IAm-Happy'); // i_am_happy * ``` * * @signature String -> String -> String * @param string $delimiter * @param string $string * @return string */ function snakeCase() { $snackCase = function ($delimiter, $string) { return apply(pipe(regReplace('/([A-Z])/', ' \\1'), regReplace('/([0-9]+)/', ' \\1'), regReplace('/[^a-z0-9]+/i', ' '), 'trim', 'strtolower', replace(' ', $delimiter)), [$string]); }; return apply(curry($snackCase), func_get_args()); }