PHP regReplace Examples

Programming Language: PHP

Method/Function: regReplace

Examples at hotexamples.com: 9

PHP regReplace - 9 examples found. These are the top rated real world PHP examples of regReplace extracted from open source projects. You can rate examples to help us improve the quality of examples.

Example #1

Show file

File: template.php Project: klarclm/sgv

 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 .= '&nbsp;';
                                 }
                                 $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 .= '&nbsp;';
                                 }
                                 $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 .= '&nbsp;';
                                 }
                                 $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 .= '&nbsp;';
                                 }
                                 $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;
 }

Example #2

Show file

File: admin_config.php Project: andyongithub/joyplus-cms

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 "配置修改成功";
}

Example #3

Show file

File: extend.php Project: klarclm/sgv

     $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 {

Example #4

Show file

File: admin_gbook.php Project: andyongithub/joyplus-cms

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">
		 	&nbsp;昵称:<strong><?php 
            echo $row["g_name"];
            ?>
</strong>
		 	&nbsp;&nbsp;IP:<?php 
            echo $row["g_ip"];
            ?>
		 	&nbsp;&nbsp;<?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;">
	 	&nbsp;&nbsp;[<a style="cursor:pointer" onclick="reply(<?php 
            echo $g_id;
            ?>
)">
	 	回复</a>]&nbsp;&nbsp;[<a href="admin_ajax.php?action=del&tab={pre}gbook&g_id=<?php 
            echo $g_id;
            ?>
" onClick="return confirm('确定要删除吗?');">删除</a>]&nbsp;&nbsp;
	 </div>
 </div>
	<?php 
        }
    }
    ?>
<table>
<tr><td>
全选<input name="chkall" type="checkbox" id="chkall" value="1" onClick="checkAll(this.checked,'g_id[]');"/>&nbsp;
<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);
}

Example #5

Show file

File: system.php Project: klarclm/sgv

    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+?)\\;");

Example #6

Show file

File: collect_fun.php Project: andyongithub/joyplus-cms

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;
}

Example #7

Show file

File: admin_comment.php Project: andyongithub/joyplus-cms

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%">&nbsp;</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[]')" />
	&nbsp;<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);
}

Example #8

Show file

File: index.php Project: andyongithub/joyplus-cms

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">&nbsp;</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);
}

Example #9

Show file

File: string.php Project: tarsana/functional

/**
 * 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());
}