public function showDBValue(&$data, $keylink) { $result = ""; if (IsDateFieldType($this->fieldType)) { $result = str_format_time(db2time($data[$this->field])); } else { $numbers = parsenumbers($data[$this->field]); if (!count($numbers)) { return ""; } while (count($numbers) < 3) { $numbers[] = 0; } $result = str_format_time(array(0, 0, 0, $numbers[0], $numbers[1], $numbers[2])); } return $this->checkForEncoding($result, $keylink); }
/** * @param &Array data * @return String */ public function getTextValue(&$data) { $result = ""; if (IsDateFieldType($this->fieldType)) { return str_format_time(db2time($data[$this->field])); } $numbers = parsenumbers($data[$this->field]); if (!count($numbers)) { return ""; } while (count($numbers) < 3) { $numbers[] = 0; } if (count($numbers) == 6) { return str_format_time(array(0, 0, 0, $numbers[3], $numbers[4], $numbers[5])); } // sometimes data is datetime return str_format_time(array(0, 0, 0, $numbers[0], $numbers[1], $numbers[2])); }
function format_time($time) { return str_format_time($time); }
$DMC->query($sql); settings_recount("logs"); //更新Cache hottags_recache(); categories_recache(); settings_recache(); recentLogs_recache(); archives_recache(); calendar_recache(); logsTitle_recache(); logs_sidebar_recache($arrSideModule); } //edit date if ($_POST['operation'] == "editdate" and $stritem != "") { if ($_POST['pubTime'] != "") { $pubtime = str_format_time($_POST['pubTime']); $sql = "update " . $DBPrefix . "logs set postTime='{$pubtime}' where {$stritem}"; $DMC->query($sql); } } //置顶展開 if ($_POST['operation'] == "topopen" and $stritem != "") { $sql = "update " . $DBPrefix . "logs set isTop='1' where {$stritem}"; $DMC->query($sql); } //置顶隱藏 if ($_POST['operation'] == "topclose" and $stritem != "") { $sql = "update " . $DBPrefix . "logs set isTop='2' where {$stritem}"; $DMC->query($sql); } //取消置顶
$tags = trim($_POST['tags']); $edittype = $_REQUEST['edittype']; if ($_POST['addpassword'] != "" && strlen($_POST['addpassword']) < 15) { $addpassword = md5($_POST['addpassword']); } else { $addpassword = $_POST['addpassword']; } //检测输入内容为空 if ($logTitle == "" or $logContent == "" or $cateId == "") { $ActionMessage = $strErrNull; $check_info = 0; } if ($check_info == 1) { //$logContent=encode($logContent); $logTitle = encode($logTitle); $postTime = $pubTimeType == "now" ? time() : str_format_time($pubTime); $author = $_SESSION['username']; //如果是ubb编辑器 if ($logsediter == "ubb") { if (empty($_POST['allowhtml'])) { $logContent = ubblogencode($logContent); } else { $logContent = str_replace("\r", "", $logContent); $logContent = str_replace("\n", "", $logContent); //$logContent=mysql_escape_string($logContent); $logContent = str_replace("'", "'", $logContent); } } else { //$logContent=mysql_escape_string($logContent); $logContent = str_replace("'", "'", $logContent); }
function searchSQL($job, $seekname) { global $DMC, $DBPrefix, $settingInfo; $searchSql = ""; if ($seekname == "") { $job = ""; } else { $seekname = str_replace("&", "&", @urldecode($seekname)); } switch ($job) { case "category": $searchSql = ""; $sql = "select id from " . $DBPrefix . "categories where parent='{$seekname}' or id='{$seekname}'"; if ($result = $DMC->fetchQueryAll($DMC->query($sql))) { $cateSql = ""; foreach ($result as $key => $value) { if (empty($cateSql)) { $cateSql = "cateId='{$value['id']}'"; } else { $cateSql .= " or cateId='{$value['id']}'"; } } $searchSql = $key > 0 ? " and ({$cateSql})" : " and {$cateSql}"; } break; case "private": $searchSql = " and saveType=3"; break; case "tags": $searchSql = " and concat(';',a.tags,';') like '%;{$seekname};%'"; break; case "calendar": //与archives查找代一样。 //与archives查找代一样。 case "archives": $curYear = substr($seekname, 0, 4); $curMonth = substr($seekname, 4, 2); $curDay = substr($seekname, 6, 2); if ($curDay > 0) { $start = str_format_time($curYear . '-' . $curMonth . '-' . $curDay . " 00:00"); $end = str_format_time($curYear . '-' . $curMonth . '-' . $curDay . " 23:59"); } elseif ($curMonth > 0) { $start = str_format_time($curYear . '-' . $curMonth . '-01 00:00'); $maxDay = gmdate("t", $start + $settingInfo['timezone'] * 3600); $end = str_format_time($curYear . '-' . $curMonth . '-' . $maxDay . " 23:59"); } else { $start = str_format_time($curYear . '-01-01 00:00'); $end = str_format_time($curYear . '-12-31 23:59'); } $searchSql = " and a.postTime>='{$start}' and a.postTime<='{$end}'"; break; case "searchTitle": $searchSql = " and (a.logTitle like '%{$seekname}%')"; break; case "searchContent": $searchSql = " and (a.logContent like '%{$seekname}%')"; break; case "searchAll": $searchSql = " and (a.logTitle like '%{$seekname}%' or a.logContent like '%{$seekname}%')"; break; default: $searchSql = ""; break; } //echo $searchSql; return $searchSql; }
function getFormattedValue($pageObject, $value, $fieldName, $strViewFormat, $strEditFormat = '', $mode = MODE_LIST) { if ($strViewFormat == FORMAT_TIME && is_numeric($value)) { $val = ''; $d = intval($value / 86400); $h = intval($value % 86400 / 3600); $m = intval($value % 86400 % 3600 / 60); $s = $value % 86400 % 3600 % 60; $val .= $d > 0 ? $d . 'd ' : ''; $val .= str_format_time(array(0, 0, 0, $h, $m, $s)); } else { $arrValue = array($fieldName => $value); $val = $pageObject->getViewControl($fieldName, $strViewFormat)->showDBValue($arrValue, ""); } return $val; }
function get_other_test() { global $_G; pload('F:spider'); $url = format_url($_GET['url']); $args['from_get_type'] = format_url($_GET['from_get_type']); $args['author_get_type'] = format_url($_GET['author_get_type']); $args['dateline_get_type'] = format_url($_GET['dateline_get_type']); $args['from_get_rules'] = format_url($_GET['from_get_rules']); $args['author_get_rules'] = format_url($_GET['author_get_rules']); $args['dateline_get_rules'] = format_url($_GET['dateline_get_rules']); $login_cookie = format_cookie($_GET['login_cookie']); $contents = get_contents($url, array('cookie' => $login_cookie)); $data = get_other_info($contents, $args); $show_time = str_format_time($data['article_dateline']); $show_time = $show_time ? dgmdate($show_time) : ''; if (!$data) { $output = milu_lang('no_get_info'); } else { $output = '<table class="tb tb2 "><tbody><tr class="header"><th width="51">' . milu_lang('field_name') . '</th><th width="220">' . milu_lang('the_get_info') . '</th><th width="80">' . milu_lang('trun_info') . '</th></tr> <tr class="td24"><td class="td25">' . milu_lang('article_from') . '</td><td class="td24">' . $data['from'] . '</td><td>' . milu_lang('no_turn') . '</td></tr> <tr class="td24"><td class="td25">' . milu_lang('old_author') . '</td><td class="td24">' . $data['author'] . '</td><td>' . milu_lang('no_turn') . '</td></tr> <tr class="td24"><td class="td25">' . milu_lang('public_time') . '</td><td class="td24">' . $data['article_dateline'] . '</td><td>' . $show_time . '</td></tr> </tr></tbody></table>'; if ($args['dateline_get_rules']) { $output .= milu_lang('get_other_notice'); } } show_pick_window(milu_lang('get_other_show'), $output, array('w' => 645, 'h' => '460', 'f' => 1)); }
$cateId = $arr_result['id']; } else { $sql = "INSERT INTO " . $DBPrefix . "categories(parent,name,orderNo,cateTitle,outLinkUrl,cateCount,isHidden) VALUES ('0','BlogBus','1','BlogBus','','" . count($logTitle) . "','0')"; $DMC->query($sql); $cateId = $DMC->insertId(); } $error = 0; $success = 0; $i = 0; foreach ($logTitle as $key => $value) { $i = $key + 1; echo "正在汇入第{$i} 条日志 ... "; $sql = "INSERT INTO " . $DBPrefix . "logs(cateId,logTitle,logContent,author,quoteUrl,postTime,isComment,isTrackback,isTop,weather,saveType,tags,password,logsediter) VALUES ('{$cateId}','{$logTitle[$key]}','{$logContent[$key]}','{$author[$key]}','{$quoteUrl[$key]}','{$postTime[$key]}','{$isComment[$key]}','{$isTrackback[$key]}','0','sunny','{$saveType[$key]}','{$tags[$key]}','','tiny')"; $DMC->query($sql); if ($DMC->error()) { $error++; echo $DMC->error() . "<br>"; } else { $logsId = $DMC->insertId(); //增加评论 foreach ($arr_comments[$key] as $subkey => $subvalue) { $subvalue['CommentText'] = encode(strip_tags($subvalue['CommentText']), "<br>"); $comm_sql = "insert into " . $DBPrefix . "comments(author,password,logId,ip,content,postTime,isSecret,parent) values('" . $subvalue['NiceName'] . "','','" . $logsId . "','" . $subvalue['PostIP'] . "','" . $subvalue['CommentText'] . "','" . str_format_time($subvalue['CreateTime']) . "','0','0')"; $DMC->query($comm_sql); } $success++; echo "<font color=red>OK</font><br>"; } } echo "<br>共有{$i} 条日志,成功汇入{$success} 条,失败{$error} 条"; }
function GetDataInt($value, $data, $field, $format) { global $strTableName; if ($format == FORMAT_CUSTOM && $data) { return CustomExpression($value, $data, $field, ""); } $ret = ""; // long binary data? if (IsBinaryType(GetFieldType($field))) { $ret = mlang_message("LONG_BINARY"); } else { $ret = $value; } if ($ret === false) { $ret = ""; } if ($format == FORMAT_DATE_SHORT) { $ret = format_shortdate(db2time($value)); } else { if ($format == FORMAT_DATE_LONG) { $ret = format_longdate(db2time($value)); } else { if ($format == FORMAT_DATE_TIME) { $ret = str_format_datetime(db2time($value)); } else { if ($format == FORMAT_TIME) { if (IsDateFieldType(GetFieldType($field))) { $ret = str_format_time(db2time($value)); } else { $numbers = parsenumbers($value); if (!count($numbers)) { return ""; } while (count($numbers) < 3) { $numbers[] = 0; } $ret = str_format_time(array(0, 0, 0, $numbers[0], $numbers[1], $numbers[2])); } } else { if ($format == FORMAT_NUMBER) { $ret = str_format_number($value, GetFieldData($strTableName, $field, "DecimalDigits", false)); } else { if ($format == FORMAT_CURRENCY) { $ret = str_format_currency($value); } else { if ($format == FORMAT_CHECKBOX) { $ret = "<img src=\"images/check_"; if ($value && $value != 0) { $ret .= "yes"; } else { $ret .= "no"; } $ret .= ".gif\" border=0"; if (isEnableSection508()) { $ret .= " alt=\" \""; } $ret .= ">"; } else { if ($format == FORMAT_PERCENT) { if ($value != "") { $ret = $value * 100 . "%"; } } else { if ($format == FORMAT_PHONE_NUMBER) { if (strlen($ret) == 7) { $ret = substr($ret, 0, 3) . "-" . substr($ret, 3); } else { if (strlen($ret) == 10) { $ret = "(" . substr($ret, 0, 3) . ") " . substr($ret, 3, 3) . "-" . substr($ret, 6); } } } else { if ($format == FORMAT_FILE_IMAGE) { if (!CheckImageExtension($ret)) { return ""; } $thumbnailed = false; $thumbprefix = ""; if ($thumbnailed) { // show thumbnail $thumbname = $thumbprefix . $ret; if (substr(GetLinkPrefix($field), 0, 7) != "http://" && !myfile_exists(getabspath(GetLinkPrefix($field) . $thumbname))) { $thumbname = $ret; } $ret = "<a target=_blank href=\"" . htmlspecialchars(AddLinkPrefix($field, $ret)) . "\">"; $ret .= "<img"; if (isEnableSection508()) { $ret .= " alt=\"" . htmlspecialchars($data[$field]) . "\""; } $ret .= " border=0"; $ret .= " src=\"" . htmlspecialchars(AddLinkPrefix($field, $thumbname)) . "\"></a>"; } else { if (isEnableSection508()) { $ret = '<img alt=\\"".htmlspecialchars($data[$field])."\\" src="' . AddLinkPrefix($field, $ret) . '" border=0>'; } else { $ret = '<img src="' . htmlspecialchars(AddLinkPrefix($field, $ret)) . '" border=0>'; } } } else { if ($format == FORMAT_HYPERLINK) { if ($data) { $ret = GetHyperlink($ret, $field, $data); } } else { if ($format == FORMAT_EMAILHYPERLINK) { $link = $ret; $title = $ret; if (substr($ret, 0, 7) == "mailto:") { $title = substr($ret, 8); } else { $link = "mailto:" . $link; } $ret = '<a href="' . $link . '">' . $title . '</a>'; } else { if ($format == FORMAT_FILE) { $iquery = "table=" . GetTableURL($strTableName) . "&field=" . rawurlencode($field); $arrKeys = GetTableKeys($strTableName); $keylink = ""; for ($j = 0; $j < count($arrKeys); $j++) { $keylink .= "&key" . ($j + 1) . "=" . rawurlencode($data[$arrKeys[$j]]); } $iquery .= $keylink; return '<a href="download.php?' . $iquery . '">' . htmlspecialchars($ret) . '</a>'; } else { if (GetEditFormat($field) == EDIT_FORMAT_CHECKBOX && $format == FORMAT_NONE) { if ($ret && $ret != 0) { $ret = mlang_message("YES"); } else { $ret = mlang_message("NO"); } } } } } } } } } } } } } } } return $ret; }
function pjtime_convert($time) { if (strpos($time, "下午")) { $time = str_replace("下午 ", "", $time); $mktime = strtotime($time) + 12 * 3600; } elseif (strpos($time, "上午")) { $time = str_replace("上午 ", "", $time); $mktime = strtotime($time); } elseif (preg_match("/AM/is", $time)) { $time = preg_replace("/AM /is", "", $time); $mktime = strtotime($time); } elseif (preg_match("/PM/is", $time)) { $time = preg_replace("/PM /is", "", $time); $mktime = strtotime($time) + 12 * 3600; } else { $mktime = strtotime($time); } $pjtime = gmdate("Y-m-d H:i:s", $mktime); return str_format_time($pjtime); }
/** * Get the full caption value for the slider with the 'seconds' step type * @param Array dateArray * @return String */ protected function getSecondsCaption($dateArray) { return str_format_time($dateArray); }
function getFormattedValue($value, $fieldName, $strViewFormat, $strEditFormat = '', $mode = MODE_LIST) { if ($strViewFormat == FORMAT_TIME && is_numeric($value)) { $val = ''; $d = intval($value / 86400); $h = intval($value % 86400 / 3600); $m = intval($value % 86400 % 3600 / 60); $s = $value % 86400 % 3600 % 60; $val .= $d > 0 ? $d . 'd ' : ''; $val .= str_format_time(array(0, 0, 0, $h, $m, $s)); } else { if ($strEditFormat == EDIT_FORMAT_LOOKUP_WIZARD || $strEditFormat == EDIT_FORMAT_RADIO) { $val = DisplayLookupWizard($fieldName, $value, null, '', $mode); } else { $val = GetDataInt($value, array($fieldName => $value), $fieldName, $strViewFormat); } } return $val; }
function get_article_other($contents) { if ($this->p_arr['is_get_other'] != 1) { return array(); } $data = (array) get_other_info($contents, $this->p_arr); $data['article_dateline'] = str_format_time($data['article_dateline']); return $data; }